20120608
09430600
FALSE
CreateFeatureclass "Database Connections\davie@davie_vector.sde\davie_vector.DAVIE.E911" address # point_Layer SAME_AS_TEMPLATE SAME_AS_TEMPLATE "PROJCS['NAD_1983_StatePlane_North_Carolina_FIPS_3200_Feet',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['Lambert_Conformal_Conic'],PARAMETER['False_Easting',2000000.002616666],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-79.0],PARAMETER['Standard_Parallel_1',34.33333333333334],PARAMETER['Standard_Parallel_2',36.16666666666666],PARAMETER['Latitude_Of_Origin',33.75],UNIT['Foot_US',0.3048006096012192]];1269322.092928 515368.561678 3906.24999636202;0 100000;0 100000" # 0 0 0 "Database Connections\davie@davie_vector.sde\davie_vector.DAVIE.E911\davie_vector.DAVIE.address"
Append point_Layer "Database Connections\davie@davie_vector.sde\davie_vector.DAVIE.E911\davie_vector.DAVIE.address" TEST "Database Connections\davie@davie_vector.sde\davie_vector.DAVIE.E911\davie_vector.DAVIE.address"
FeatureClassToFeatureClass C:\ArcSDE\Planning\address\point "Database Connections\davie@davie_vector.sde\davie_vector.DAVIE.E911" address # "AREA AREA HIDDEN;PERIMETER PERIMETER HIDDEN;ADDRESS# ADDRESS_ HIDDEN;ADDRESS-ID ADDRESS_ID HIDDEN;ADDR ADDR VISIBLE;HSNM HSNM VISIBLE;PREDIR PREDIR VISIBLE;STREET STREET VISIBLE;TYPE TYPE VISIBLE;POSTDIR POSTDIR VISIBLE;UNIT UNIT VISIBLE;CITY CITY VISIBLE;STATE STATE VISIBLE;ZIPCODE ZIPCODE VISIBLE;SYMBOL SYMBOL VISIBLE;DATE DATE_ VISIBLE;ESNNUM ESNNUM VISIBLE;PSAP PSAP VISIBLE;LAW LAW VISIBLE;FIRE FIRE VISIBLE;MEDICAL MEDICAL VISIBLE;$POLYGONID POLYGONID HIDDEN;$SCALE SCALE HIDDEN;$ANGLE ANGLE HIDDEN" SAME_AS_TEMPLATE SAME_AS_TEMPLATE # 0 "Database Connections\davie@davie_vector.sde\davie_vector.DAVIE.E911\davie_vector.DAVIE.address"
CalculateField address MSAG_COMMUNITY Mocksville VB #
CalculateField address MSAG_COMMUNITY "Mocksville" VB #
CalculateField address MSAG_COMMUNITY "Advance" VB #
CalculateField address MSAG_COMMUNITY "Cooleemee" VB #
CalculateField address MSAG_COMMUNITY "Statesville" VB #
CalculateField address MSAG_COMMUNITY "Harmony" VB #
CalculateField address MSAG_COMMUNITY "Yadkinville" VB #
CalculateField address ESN 1269 VB #
CalculateField address ESN 1272 VB #
CalculateField address ESN 1270 VB #
CalculateField address ESN 1262 VB #
CalculateField address ESN 1267 VB #
CalculateField address ESN 1268 VB #
CalculateField address ESN 1273 VB #
CalculateField address ESN 1270 VB #
CalculateField address ESN 1272 VB #
CalculateField address ESN 0 VB #
CalculateField DAVIE.address_Layer ESN 1254 VB #
CalculateField DAVIE.address_Layer ESN ESN=1255 VB #
CalculateField DAVIE.address_Layer ESN ESN=1257 VB #
CalculateField DAVIE.address_Layer1255 ESN ESN=1255 VB #
CalculateField address ESN 1255 VB #
CalculateField address ESN 1257 VB #
CalculateField address ESN 1258 VB #
CalculateField address ESN 1260 VB #
CalculateField address ESN 1261 VB #
CalculateField address ESN 1262 VB #
CalculateField address ESN 1263 VB #
CalculateField address ESN 1264 VB #
CalculateField address ESN 1265 VB #
CalculateField address ESN 1266 VB #
CalculateField address ESN 1267 VB #
CalculateField address ESN 1269 VB #
CalculateField address ESN 1271 VB #
CalculateField address HSNM "LEFT ( [ADDR],3)" VB #
CalculateField address STREET "I40 EB" VB #
CalculateField address STATUS "Approved" VB #
CalculateField address HSNM "left ( [ADDR],3)" VB #
CalculateField address STREET "I40 WB" VB #
CalculateField address STATUS "Approved" VB #
CalculateField address HSNM NULL VB #
CalculateField address MSAG_COMMUNITY "BERMUDA RUN" VB #
DeleteField "Database Connections\davie@davie_vector.sde\davie_vector.DAVIE.E911\davie_vector.DAVIE.address" NO_MSAG
CalculateField Address DATE_OF_EDIT "Now ( )" VB #
AddField "Database Connections\davie@davie_vector.sde\davie_vector.DAVIE.E911\davie_vector.DAVIE.address" NG911_Except TEXT # # 75 # NULLABLE NON_REQUIRED #
CalculateField address NG911_Except "Feature will be removed when uploaded" VB #
CalculateField address NG911_Except "Feature will be removed when uploaded" VB #
CalculateField Address ADDR "[HSNM] + "MARTIN LUTHER KING JR RD"" VB #
CalculateField Address ADDR "[HSNM] + " " + "MARTIN LUTHER KING JR RD"" VB #
CalculateField Address STREET "MARTIN LUTHER KING JR" VB #
CalculateField Address MSAG_COMMUNITY "MOCKSVILLE" VB #
CalculateField Address MSAG_COMMUNITY "ADVANCE" VB #
CalculateField address MSAG_COMMUNITY "ADVANCE" VB #
CalculateField address MSAG_COMMUNITY "BERMUDA RUN" VB #
CalculateField address MSAG_COMMUNITY "HARMONY" VB #
CalculateField address MSAG_COMMUNITY "MOCKSVILLE" VB #
CalculateField address MSAG_COMMUNITY "YADKINVILLE" VB #
CalculateField address MSAG_COMMUNITY UCase([MSAG_COMMUNITY]) VB #
Server=svr-gisapp.davie.pri; Service=sde:sqlserver:svr-gisapp.davie.pri; Database=davie_vector; User=davie; Version=sde.DEFAULT
ArcSDE Connection
davie_vector.DAVIE.address
1492945.225260
1594247.677083
736946.447917
843595.306641
1
002
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_North_Carolina_FIPS_3200_Feet
<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/2.8.0'><WKT>PROJCS["NAD_1983_StatePlane_North_Carolina_FIPS_3200_Feet",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["Lambert_Conformal_Conic"],PARAMETER["False_Easting",2000000.002616666],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-79.0],PARAMETER["Standard_Parallel_1",34.33333333333334],PARAMETER["Standard_Parallel_2",36.16666666666666],PARAMETER["Latitude_Of_Origin",33.75],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2264]]</WKT><XOrigin>-121841899.99999982</XOrigin><YOrigin>-93658999.999999866</YOrigin><XYScale>1536.0000000000025</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.020833333333333301</XYTolerance><ZTolerance>2.0000000000000002e-05</ZTolerance><MTolerance>2</MTolerance><HighPrecision>true</HighPrecision><WKID>102719</WKID><LatestWKID>2264</LatestWKID></ProjectedCoordinateSystem>
20210820
16064500
20210820
16064500
1.0
ItemDescription
davie_vector.DAVIE.address
Feature Class
20726
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
ESRI
Sequential unique whole numbers that are automatically generated.
ADDR
ADDR
String
50
0
0
HSNM
HSNM
String
5
0
0
PREDIR
PREDIR
String
3
0
0
STREET
STREET
String
28
0
0
TYPE
TYPE
String
5
0
0
POSTDIR
POSTDIR
String
3
0
0
UNIT
UNIT
String
5
0
0
Shape
Shape
Geometry
4
0
0
Feature geometry.
ESRI
Coordinates defining the features.
DATE_OF_EDIT
DATE_OF_EDIT
Date
8
0
0
STATUS
STATUS
String
10
0
0
GlobalID
GlobalID
GlobalID
38
0
0
ESN
ESN
SmallInteger
2
5
0
MSAG_COMMUNITY
MSAG_COMMUNITY
String
50
0
0
ADDRESSID
ADDRESSID
SmallInteger
2
5
0
NG911_Except
NG911_Except
String
75
0
0
dataset
20210820
ArcGIS Metadata
1.0
SDE Feature Class
SDE Feature Class
Addresses
Address metadata test
This layer is intended to provide information on addresses in Davie County, NC.
Address metadata test
MetadataTest
Davie County
GIS
Address
Version 6.2 (Build 9200) ; Esri ArcGIS 10.6.1.9270
true
-80.715456
-80.36781
35.762869
36.060137
1
-80.715456
-80.367810
36.060137
35.762869
20726
EPSG
6.12(9.0.0)
6.12(9.0.0)
Simple
FALSE
20726
TRUE
FALSE
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigD//2Q==