20220318
14171500
1.0
FALSE
coagiswarehouse.coagis.coa_zip_codes
002
Server=gis-warehouse.cvxz56fxyemy.us-east-1.rds.amazonaws.com; Service=sde:postgresql:gis-warehouse.cvxz56fxyemy.us-east-1.rds.amazonaws.com; Database=coagiswarehouse; User=coagis; Version=sde.DEFAULT
ArcSDE Connection
Projected
GCS_North_American_1983
Linear Unit: Meter (1.000000)
NAD_1983_StatePlane_North_Carolina_FIPS_3200
<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.9.0'><WKT>PROJCS["NAD_1983_StatePlane_North_Carolina_FIPS_3200",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",609601.22],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["Meter",1.0],AUTHORITY["EPSG",32119]]</WKT><XOrigin>-37137500</XOrigin><YOrigin>-28547400</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>32119</WKID><LatestWKID>32119</LatestWKID></ProjectedCoordinateSystem>
FeatureClassToFeatureClass ZIP_Code_Tabulation_Areas C:\Users\gisadmin\Desktop\Boundaries\Boundaries.gdb Zip_Code_State # "OBJECTID "OBJECTID" true true false 3 Short 0 3,First,#,ZIP_Code_Tabulation_Areas,OBJECTID,-1,-1;ZCTA5CE10 "ZCTA5CE10" true true false 5 Text 0 0,First,#,ZIP_Code_Tabulation_Areas,ZCTA5CE10,0,5;AFFGEOID10 "AFFGEOID10" true true false 14 Text 0 0,First,#,ZIP_Code_Tabulation_Areas,AFFGEOID10,0,14;GEOID10 "GEOID10" true true false 5 Text 0 0,First,#,ZIP_Code_Tabulation_Areas,GEOID10,0,5;ALAND10 "ALAND10" true true false 9 Long 0 9,First,#,ZIP_Code_Tabulation_Areas,ALAND10,-1,-1;AWATER10 "AWATER10" true true false 9 Long 0 9,First,#,ZIP_Code_Tabulation_Areas,AWATER10,-1,-1;ShapeSTAre "ShapeSTAre" true true false 24 Double 15 23,First,#,ZIP_Code_Tabulation_Areas,ShapeSTAre,-1,-1;ShapeSTLen "ShapeSTLen" true true false 24 Double 15 23,First,#,ZIP_Code_Tabulation_Areas,ShapeSTLen,-1,-1" #
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.9.0'><WorkspaceConnectionString>DATABASE=C:\Users\gisadmin\Desktop\Boundaries\Boundaries.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Zip_Code_State</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>po_name</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>po_name</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>citycode</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>citycode</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>state</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>state</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
FeatureClassToFeatureClass "New Zip Codes" "C:\Users\gisadmin\AppData\Roaming\Esri\ArcGISPro\Favorites\gis-warehouse.cvxz56fxyemy.us-east-1.rds.amazonaws.com (1).sde" coa_zip_codes # "OBJECTID "OBJECTID" true true false 2 Short 0 0,First,#,New Zip Codes,OBJECTID,-1,-1;ZCTA5CE10 "ZCTA5CE10" true true false 5 Text 0 0,First,#,New Zip Codes,ZCTA5CE10,0,5;AFFGEOID10 "AFFGEOID10" true true false 14 Text 0 0,First,#,New Zip Codes,AFFGEOID10,0,14;GEOID10 "GEOID10" true true false 5 Text 0 0,First,#,New Zip Codes,GEOID10,0,5;ALAND10 "ALAND10" true true false 4 Long 0 0,First,#,New Zip Codes,ALAND10,-1,-1;AWATER10 "AWATER10" true true false 4 Long 0 0,First,#,New Zip Codes,AWATER10,-1,-1;ShapeSTAre "ShapeSTAre" true true false 8 Double 0 0,First,#,New Zip Codes,ShapeSTAre,-1,-1;ShapeSTLen "ShapeSTLen" true true false 8 Double 0 0,First,#,New Zip Codes,ShapeSTLen,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,New Zip Codes,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,New Zip Codes,Shape_Area,-1,-1;po_name "po_name" true true false 255 Text 0 0,First,#,New Zip Codes,po_name,0,255;citycode "citycode" true true false 255 Text 0 0,First,#,New Zip Codes,citycode,0,255;state "state" true true false 255 Text 0 0,First,#,New Zip Codes,state,0,255" #
20220318
16214400
20220318
16214400
Microsoft Windows Server 2016 Technical Preview Version 10.0 (Build 17763) ; Esri ArcGIS 12.9.0.32739
ZipCodes
zip codes
Zip Codes
Enterprise Geodatabase Feature Class
dataset
EPSG
4.2(3.0.1)
0
Simple
FALSE
0
TRUE
FALSE
coagiswarehouse.coagis.coa_zip_codes
Feature Class
0
OBJECTID_1
objectid_1
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
OBJECTID
OBJECTID
SmallInteger
2
5
0
ZCTA5CE10
ZCTA5CE10
String
5
0
0
AFFGEOID10
AFFGEOID10
String
14
0
0
GEOID10
GEOID10
String
5
0
0
ALAND10
ALAND10
Integer
4
10
0
AWATER10
AWATER10
Integer
4
10
0
ShapeSTAre
ShapeSTAre
Double
8
38
8
po_name
po_name
String
255
0
0
citycode
citycode
String
255
0
0
state
state
String
255
0
0
ShapeSTLen
ShapeSTLen
Double
8
38
8
st_area(shape)
st_area(shape)
Double
0
0
0
st_perimeter(shape)
st_perimeter(shape)
Double
0
0
0
20220318
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD02iii
tD3gooooAKKge5VX2qrOe+0dKBdxGREBO5ugwf1oFdE9FFFAwooooARmCKWY4A6mqple5jYxKrRn
gEnr71LdHFtJkgcY5GabZKEtEQIUCjGCMUEvV2Jo1KxqCckCnUUUFBRRRQBXuSzMkK4G/qfbvU4G
AAO1QRZkuGlwNmNo9asUCXcKKKKBhRRRQAUUUUAFFFFABRRRQAUUUUAQNao0hfLA9gDwD60CWVPl
aJmI7joanooFbsRxzK5xgq391utSUySISAc4YdGHaomilUbxKzMOg6A0BqixRTEkV1BBH09KfQMK
KKKAIPMmfhI9nqX/AMKPKn/57j/vj/69T0UCsQbpouXAkX1UYI/CnSTJ5RIOcjgDrUtRpBHH91AD
60BZiW6MkKq4G4DtTJwPOg4Gd/8AQ1YqADzLonsgwPqaAa0sT0UhIAyTgUxJ433bXB29aB3HO6xj
LMADxTXnjjxubr0xULuLh41VGwGySy8YqZIUjJKjBNArt7DJJoWjKsdwI6VXsJlEbB22kucKewzV
4Kq52qBnrgUMqsMMAR6EUCs73ImuY1OOSB1I6CpQQQCOhqOULFbvtUKMdAMU6IbYUB6hRQNXuPoo
ooGQD9zOQeEfkfWp6juEMkLADJ6j60sTh4lYdxQJb2H0UUUDCiiigAooooAKKKKACiiigAooooAK
KKKACiiigCCe3V0ZlUCTHB96fHMknAOG7qeoqSo5Ig4yvDjo1ArW1RJRUcUm/KsMOvUVJQMKKKKA
CiiigAquIZQ77ZAqMd3TJqxRQDVyEWyZyxZz/tHNLJbpJ6rxj5TjipaKBWQigKoA6DiloooGFFFF
AEFx87xxf3jk/Qf5FT1XgzI7TPjP3QB2qxQJdwooooGRyyeWAAMs3Ciq6+faoMhWQHJI6/lUs/yy
RSdlJz+Iqfgigm12V2nkcHyYs+7cA0Bp5sfKYl7561YooHYrwu4neJ23YGQcdqsVFJArvv3MrYxk
HtTbYsQ+XLKGwpNALTQnooooGFFFFABRRRQAUUUUAFFFFABRRRQAUUUUARSxI3zk7WA+8KrG8mU4
EaMB3wef0qef5niT1bJHsKnoIau9AooooLCiiigAooooAKKKKACiiigApCQoJPQUtBAIwelAENsD
5Zc9XO6pqrMsluNyNmMHlSOgqyCCAR0NAl2CiikJABJ6CgYMAykHoRzUVqSbZCeuKZiWcZ3hI27Y
5IqwqhVCjoKBLV3FooooGQzyOrIiD7/G70qSNBHGqDoBis95LiS7kVMZjbKBuOMCr0coeMMSucc4
NBKd2SUUwSxno4/On0FBRRRQAUUUUAFFFFABRSZGcZGfSloAKKKrENNPIu9l2AbcUA2TvIkf3mA+
tMlmWOLeCDnheepPSoDCjN5S5bP32PNSx2qoRkllUYUHoKCbtjooVQ7yMuepqWiigpKwUUUUAFFF
FABRRRQAUUUUAFFFFABRRVQL51xIwZht4VhQJuxaIDAg9DVffJbrtKNIo+6RUkDs29XIJU4z60XE
myMAY3Mdoz6mgHtcfG4kjVx0YZpJCm3DsADxyaWNBHEqDooxUDxqboBhuDqevbFAO9hQ0sC4K70A
6jrT4LhJ1JTPBwcimPaKy7VZkU9QDU6qFAAGBQJXFooooKKjkRTS7w3zjgqpP4URWaG3VXXDbcEr
wf0q3RQTykJtYSm3y16YzjmmW7MrtE8mdvC7uDVmo5IY5Rh1BoHbsLJKsS5Y/gOpqM3cIH3iT6Ac
/lTo7dIznlm9WNSbVznAz9KA1IftOPvRSAnoMZzRiWX737tfbqanooCxB5DR8wsfdWOQagnuZjiK
JCsp7kdKvVBAN0ksnYtgUCa6IPsqkZckyHqwODSYNvIuGbyz13HOD2qxTXUOhU9xQO3YjnYkpGpw
XOMjsO9IYlhilZC24qeSc9qYqyO0aspXy/4j3qaf/USf7poFvqECgQJgYyAT9akpkXEKf7op9BS2
CiiigAooooAKKKKACiiigAooooAKKKKAEYZUj1FRWxxH5ZGGTg/41NUE37uRJR6hT9DQJ9weORJG
kjOc9VPeopdty8YVGyp5JGMVcooBogxcY2grgfxHvUbRzRypMz7gvDDHardIw3KR6igLACGAIOQe
hparRM8CpHIoCgBQwNWaATuFFFFAwooooAKKKKACiiigAooooAglLvKsSMV7sR6VJFGIowg5A9ai
LA3SmM5J4f0xVigS7hRRRQMKiuP+Pd/pUtRXIJt3x6UCew+P/Vr9BTqahBjUjpgU6gYUUUUAFFFF
ABRRRQAUUUUAFFFFABRRRQAVHOm+BgOuOPrUlFAEcUivGpyMkVJVK4tYYrZikYDZBBxz1q4owoHt
QJN7MWiiigZDdDNtJ7KT+VSIcxqfaq15MqlYWfaHHOBk06MXJjByo9iKCb6k7yJGMuwH1qIXQPzb
G2f3scUR2/zb5Tvf68D6VMQCMdqB6sUEEZHSiq0EqozQs43I2Bk9R1qwSB1IFAJ3FopMjOMjPpSN
IisFZgCegoGO6VB9rhyRv59PWluSSqoP4mx+FSgAdBQLXoIsiOm5WBFQm7iZWCk5HHSlktg7lg5U
N94DvUoRVOQoBxjNAalbTxKLYCZMMD1x196t0UUAlZWCiiigYVDOS2Il6v19hT5JRGO5Y9AO9JFG
Vy7cu3WgT10HgBVAHQcUtFFAwooooAKKZHKsmcZDDqD1FPoAKKKKACiiigAopryLGuWIFRCJpgGl
LAdlBxigVyeioMvAyhm3Rk4yeoqegaYUUVDPOIQBgszHAUUA3YkkQSRsp70yB9yYP3l4NN8qST/W
SED+6vH61JHEsQIXPPUk5JoFrcfRRRQMrvbl7tZSQVA6Y5qxRRQCVgpGbapY9AM0tBGRg9KAK0Nu
j75XUFpOfoKRLZhO2874sfLk8in25Kl4j/AePpU9BKSK/wBji3Fl3Kx4yDUbxrHcxAglSfvE9+1X
KpXs3kTRSNGzIOpAzt96AkklcmixLM0vYfKv9anqC0H7gNjlzuNT0DWwUUUUDCiiigAoopCcKSKA
KzFoJndsMrEc55UVZBDAEHINVoYI5ot7qC5Jy3cc+tWVUIoVRgDgCgmNxaKKKCgooooAguBtUSr9
5SPy71ODkZHSmSqXidV6kEVHFLjZE6MpxgE9DQLZk9FFQm6jzhMuf9kZoHew6WTywMDLHgD1pnly
ycyPtH91P8aVFZ5BJIu3H3Vz0qagW5ElvEhyF59TUtFFA7DXQSIVboai8mTvO34DFT0UBYgxcrwC
j+54xTPL2XCNIc57+9Wqa6CRCrdDQKw6ioYZPmaJiN6fqKmoGncKKKKACiiigAooooAgk+S4jcdG
+U/0qemSoHjIP50lu5kt43bqVBNAupJUc7bYJGHUKcVJ0FUZbgyvsEcnlddwUndQEnZFuFQkKqPS
n1FHOrtswynGQGGMipaBoKKKKACiiigAoopskixrljj096AIofknkj7feH4//Xqeq0If7Q77CFbu
3WrNAo7BRRRQMKKKKACobkDyw2QGU5GamqCMec5kblQcIP60CfYFDXADOCiH+A9T9amChRgACloo
GkFFFFABRRRQAUUUUAFFFFAEUtukrBjkMO4qO2baJQ7nar4G49BgVZqrdwxlN5XoRuPtQS1bVFqi
jtRQUFFFFABRTJJRGBkEk9AOpqPz3H3oH/DmgV0SyKWjZR1IpluR5QXoVGCPSm+bK33YSPdjioYp
TFdTGd0BIGAOKBN6i3M53eWAdnRm9D2qxG37lGYBeBx6Uy2Rgru2fnbcAaSa2NwcPKwj/uLxmgNd
xtxLGksb7gWBxgHnB/8A1U4yz7d/lgL1xnnFOS0gRgwjG4dzzU1AWZWW7VmbKnYDgMOanSRJB8rA
0woIo3MacnnHrUMMsSKSvzSMeQBzmgLtbluo3njQ4ZsGmbJpPvuEX0Xr+dEqLFbNsTJx9aBtsm3b
kypByODUFuoceY3zP0JPanwNH5SrGwIUY4pqfJcug6MN3496A7E9FFFAwoopCQASTgCgBaKg3yy/
6rCp/eYdaXbc/wB9P++f/r0CuSuodCp6EYqKJijmF+cDKn1FTVBcfJsl/uHn6d6AfcnooooGFFFF
ABRRRQAUUUUAFFFFABUF4cWsnTkY5qekIDDBAI96AeqIYGjSNU84MfduTU9UXtY/7QjdRz1I7Cr1
Ao3CiiigZBL8txG5+7yM+lT0jKGBBGQahybdvmOYj3P8NAtiekKgnJAoVlYZUgiloGFFFFABRRRQ
AU3Yu7dtG71p1FABRRRQBFJF8wkjwHH61C0n71X2lXUEFT3FW6gusGAgjJJwKCWhTcxhQQSxPYDJ
pVuYm/jwfQ8UsMCQIFQfU+tOKI3VQfwoHqNeZE75PoOTUZ33GAUKR5yc9TUqRJH91QKfQFm9wooo
oGFVpG+0/ukBKZ+Zu2KdLukmEIbapUsSOp9qmVQqhQMAUC3FooooGFFFFABRRRQAUUUUAFFFFABR
RRQBnmeSOWRo4mkG77x/UVdjfzIw+CM9iKjtuBKPSQ/zqegmKCiiigoKKKKAIWgAJaL5H9uh+tOi
kL5Vhh16ipKgJ23gJ6MuB9aBbE9FFFAwooooAKKKKACiikJAGScCgBaguSD5cY+8WH4e9Dt5ziNG
+X+IinxwxxfcXB9aBbklFFFAwooooAKKKKAIG+a7QLwVUlj7elT0UUxIKKKKQwooooAKKKKACiii
gAooooAKKKKAIIOXlYfdLcGp6KKBLYKKKKBhRRRQAVBP800Kj7wbP4YoooEyeiiigYUUUUAFFFFA
BUU8Inj2kkc5FFFASI0lMBVJURA3AYcDNWaKKBIKKKKBhRRRQAUUUUAf/9k=