20181022
08444400
1.0
North American Profile of ISO19115 2003
FALSE
Fence
002
4622.773400
9614.819500
5934231.224600
5937058.438600
1
Projected
GCS_North_American_1983
Linear Unit: Meter (1.000000)
NAD_1983_3TM_114
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.6'><WKT>PROJCS["NAD_1983_3TM_114",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-114.0],PARAMETER["Scale_Factor",0.9999],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",3776]]</WKT><XOrigin>-5622600</XOrigin><YOrigin>-10001100</YOrigin><XYScale>10000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102187</WKID><LatestWKID>3776</LatestWKID></ProjectedCoordinateSystem>
20190417
14123900
20190417
14123900
150000000
5000
NAP
Esri ArcGIS 10.6.1.9270
Fence
2016-06-01T00:00:00
external
4e8e7ea0f3dbc2a4cba3a8c01d7bc6a3
Information Systems - GIS
City of Spruce Grove
315 Jespersen Ave
Spruce Grove
Alberta
T7X3E8
gis@sprucegrove.org
CA
True
Information Systems - GIS
1
-113.930263
-113.854868
53.566346
53.540873
Municipally owned fence features
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Line features representing the city owned fence features in Spruce Grove</SPAN></P></DIV></DIV></DIV>
fence
city
municipal
Spruce Grove
Alberta
291
fence, city, municipal, Spruce Grove, Alberta, 291
external
4e8e7ea0f3dbc2a4cba3a8c01d7bc6a3
Information Systems - GIS
City of Spruce Grove
315 Jespersen Ave
Spruce Grove
Alberta
T7X3E8
gis@sprucegrove.org
CA
True
Information Systems - GIS
Feature Class
10.3.1
dataset
EPSG
6.16(10.0.0)
27
Simple
FALSE
27
TRUE
FALSE
Fence
Feature Class
27
Lines representing fences
Spruce Grove
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
TYPE
Type
Integer
4
10
0
Subtype Field indicating the type of fence
Spruce Grove
0
Chain Link
Spruce Grove
1
Decorative Metal
Spruce Grove
2
Post and Rail
Spruce Grove
3
Wood Panel
Spruce Grove
4
Other
Spruce Grove
Subtype attribute
NUMBERPOSTS
Number of Posts
SmallInteger
2
5
0
The total number of posts along the fence feature
Spruce Grove
2
200
positive, numeric value representing the number of posts along the fence.
POSTSIZE
Post Size (inches)
String
20
0
0
The size of the posts along the fence in inches
Spruce Grove
Size of post in inches, usually represented as dimensions (ex: 6x6)
POSTHEIGHT
Post Height (ft)
SmallInteger
2
5
0
Height of posts in feet
Spruce Grove
Positive, numeric value representing the height of the fence posts from the ground, in feet.
NUMBERRAILBOARDS
Number of Rails/Boards
SmallInteger
2
5
0
Number of rails/boards along the fence segment
Spruce Grove
Positive numeric value representing the number of boards or rails along the represented fence segment.
RAILBOARDHEIGHT
Rail/Board Height (ft)
SmallInteger
2
5
0
Height of the rails in feet
Spruce Grove
Positive, numeric value representing the total height of the rails/boards along the fenace segment, in feet.
RAILBOARDSIZE
Rail/Board Size (inches)
String
20
0
0
Size lumber used for the rails in inches
Spruce Grove
Size of rails or boards along the fence segment in inches, usually represented as dimensions (ex: 1x6)
TOTALLENGTH
Total Length
Double
8
38
8
Total length of the fence in feet.
Spruce Grove
Positive, numeric value representing the total length of the fence segment in feet. Can be calculated using the SHAPE_LENGTH field of the feature: (SHAPE_LENGTH*3.28)
CONDITION
Condition Rating
String
50
0
0
Condition rating of the fence segment
Spruce Grove
Excellent
Excellent
Esri
Very Good
Very Good
Esri
Good
Good
Esri
Fair
Fair
Esri
Poor
Poor
Esri
Very Poor
Very Poor
Esri
Unknown
Unknown
Esri
Esri Canada Local Government Solutions
Esri Canada Local Government Solutions
CONDITIONCOMMENTS
Condition Comments
String
100
0
0
Comments regarding the condition of the fence
Spruce Grove
Text field for comments regarding the condition rating
PAINTDESCRIPTION
Paint Description
String
50
0
0
Description of the type of treatment product on the fence
Spruce Grove
Text field representing the treatment product used on the fence (ex: Wood Stain, Pressure Treated, etc)
PAINTTYPE
Paint Type
String
25
0
0
The brand of paint used.
Spruce Grove
The brand of product used to treat the fence.
PAINTMAINCOLOR
Paint Main Color
String
20
0
0
The main colour of the treatement product on the fence
Spruce Grove
Official name of the main colour used to treat the fence
PAINTSECONDARYCOLOR
Paint Secondary Color
String
20
0
0
The secondary colour used to treat the fence
Spruce Grove
Text field representing the official name of the secondary colour used to treat the fence, where applicable.
INSTALLDATE
Install Date
Date
8
0
0
Date of installation of the fence
Spruce Grove
Date that the fence was installed.
LOCATIONDESCRIPTION
Location Description
String
100
0
0
Description of the location of the fence
Spruce Grove
Description of the location of the fence.
FENCE_ID
Fence ID
String
7
0
0
Unique identifier of the fence
Spruce Grove
Paricular facility ID, unique identifier for the fence asset.
Chain Link
0
CONDITION
Condition
The condition of the asset
Coded Value
Default value
Duplicate
SDE
String
Decorative Metal
1
CONDITION
Condition
The condition of the asset
Coded Value
Default value
Duplicate
SDE
String
Wood Panel
3
CONDITION
Condition
The condition of the asset
Coded Value
Default value
Duplicate
SDE
String
Other
4
CONDITION
Condition
The condition of the asset
Coded Value
Default value
Duplicate
SDE
String
created_user
created_user
String
255
0
0
The person who created the feature
Spruce Grove
database managed attribute
created_date
created_date
Date
8
0
0
The date the feature was created
Spruce Grove
database managed attribute
last_edited_user
last_edited_user
String
255
0
0
The name of the person who performed the most recent update to the feature
Spruce Grove
database managed attribute
last_edited_date
last_edited_date
Date
8
0
0
The date of the most recent update to the feature
Spruce Grove
database managed attribute
FACILITYID
Facility ID
String
20
0
0
Post and Rail
2
CONDITION
Condition
The condition of the asset
Coded Value
Default value
Duplicate
SDE
String
Shape.STLength()
Shape.STLength()
Double
0
0
0
20190417
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKR3WNC7sFUckk4ApaY8SSFS4ztOQD0z60ANiuEmJCCTju0bKPwyOa
loooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiimx79g343dyO/vQA6iiigAooooAKKbJJ
HDGZJXVEHVmOAKhS/s5HCJdwMxOAqyAk07MCxRRRSAKKKKACiiigAooooAKKKKACiiigAooooAKK
KKACiiigAooooAKRmVRliAMgZJ7ngUtIQDjIBxyM0ALRRQc4460AFVr/AP490/67Rf8AoxaQNexs
d6RTJjOY8o302kkHtzuH+LJ5TOqRCKVZDIjEMhwAGBPzD5egPeqS1Au0UUVIBRRRQAilstuAAz8u
DnIx39Oc0tIDkngjH60tABRRRQAUUUUAFFMeaKM4eRFPXDMBTZLa3nIaWGKQgYBZQeKE0BLRUcUE
MClYYkjBOSEUDP5VJQAUUUUAFFFFAET3EUc8UDtiSXOwYPOOTzUtNaNGdXZFLpnaxHK564p1ABRR
RQAUUUUAFRzOUQEddyj8yBUlRXH+rH++n/oQpS2AkVFRdqKFGScAYpaKKYBRSEBhg5/A4pQMACgA
ooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKZInmKFzjDA/kQf6U+igAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiig
kAZPAoAKKopqsDRCXawhMgi83cpXJIA5BOeSBx/jV6m01uFwooopAFFFFAEbwRSPudFY4x8wzipO
lFFKyAKKKKYBRRRQAUUUUAFFFIzBVLMQABkk9qAFPTg4NFFFABRRRQAUUUUAFFFFABRRRQBBdWsd
5AYZQCpP/wCv6cZH41Mq7VC5JwMZJyaWigAooooAKKKKACiiigAooooAKKKKACiiigAo60UUAFFF
FABRRRQAUUUUAFFFFABRRRQAUUUUAFMKbpFYs2F6KDgfj60+qzahZKxVry3BBwQZV4/Wi1wLNFV1
v7N2CrdwMzHAAkBJP51YptWAKKKKQBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFF
ABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAH//2Q==
D8F71C0F-CA93-4D96-A3ED-C317420DAC45
external
4e8e7ea0f3dbc2a4cba3a8c01d7bc6a3
Information Systems - GIS
City of Spruce Grove
315 Jespersen Ave
Spruce Grove
Alberta
T7X3E8
gis@sprucegrove.org
CA
True
Information Systems - GIS
external
4e8e7ea0f3dbc2a4cba3a8c01d7bc6a3
Information Systems - GIS
City of Spruce Grove
315 Jespersen Ave
Spruce Grove
Alberta
T7X3E8
gis@sprucegrove.org
CA
True
Information Systems - GIS