20180220
14195900
FALSE
DefineProjection ZIPCODES PROJCS['NAD_1983_StatePlane_Florida_North_FIPS_0903_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',1968500.0],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-84.5],PARAMETER['Standard_Parallel_1',29.58333333333333],PARAMETER['Standard_Parallel_2',30.75],PARAMETER['Latitude_Of_Origin',29.0],UNIT['Foot_US',0.3048006096012192]] ZIPCODES
CalculateField Columbia_GIS.DBO.Zip_Codes ZIPCODE [GIS_FIG] VB #
Columbia_GIS.DBO.ZIPCODES
002
Server=gis-server_sqlexpress; Service=sde:sqlserver:gis-server\sqlexpress; Database=Columbia_GIS; Version=dbo.DEFAULT
ArcSDE Connection
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Florida_North_FIPS_0903_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/10.3'><WKT>PROJCS["NAD_1983_StatePlane_Florida_North_FIPS_0903_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",1968500.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-84.5],PARAMETER["Standard_Parallel_1",29.58333333333333],PARAMETER["Standard_Parallel_2",30.75],PARAMETER["Latitude_Of_Origin",29.0],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2238]]</WKT><XOrigin>-125939000</XOrigin><YOrigin>-91453300</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102660</WKID><LatestWKID>2238</LatestWKID></ProjectedCoordinateSystem>
20160330
16181700
20160330
16181700
1.0
Version 6.2 (Build 9200) ; Esri ArcGIS 10.3.1.4959
Zip Codes
Zip Codes
Zip Codes
SDE Feature Class
dataset
EPSG
8.6.2
0
Simple
FALSE
0
TRUE
FALSE
Columbia_GIS.DBO.ZIPCODES
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
GIS_FIG
GIS_FIG
String
20
0
0
GIS_STY
GIS_STY
SmallInteger
2
5
0
GIS_PEN
GIS_PEN
SmallInteger
2
5
0
GIS_LGT
GIS_LGT
Double
8
38
8
GIS_AREA
GIS_AREA
Double
8
38
8
GIS_NAME
GIS_NAME
String
20
0
0
GIS_CASE
GIS_CASE
String
8
0
0
GIS_INAR
GIS_INAR
Double
8
38
8
GIS_PCNT
GIS_PCNT
Double
8
38
8
GIS_TAGX
GIS_TAGX
Double
8
38
8
GIS_TAGY
GIS_TAGY
Double
8
38
8
GIS_TAGF
GIS_TAGF
SmallInteger
2
5
0
GIS_TAGT
GIS_TAGT
String
1
0
0
GIS_TAGH
GIS_TAGH
Double
8
38
8
GIS_TAGC
GIS_TAGC
SmallInteger
2
5
0
GIS_TAGR
GIS_TAGR
Double
8
38
8
GIS_PCOL
GIS_PCOL
SmallInteger
2
5
0
GIS_BMP
GIS_BMP
String
30
0
0
GIS_BMPH
GIS_BMPH
SmallInteger
2
5
0
GIS_NTAR
GIS_NTAR
Double
8
38
8
GIS_ISAR
GIS_ISAR
Double
8
38
8
GIS_LIB
GIS_LIB
String
50
0
0
CITY
CITY
String
20
0
0
STATE
STATE
String
2
0
0
ZIP
ZIP
String
5
0
0
Columbia_GIS.DBO.ZIPCODES.ENTITY
Columbia_GIS.DBO.ZIPCODES.ENTITY
String
10
0
0
LAYER
LAYER
String
20
0
0
ELEVATION
ELEVATION
Double
8
38
8
THICKNESS
THICKNESS
SmallInteger
2
5
0
COLOR
COLOR
SmallInteger
2
5
0
Shape
Shape
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
Shape.STArea()
Shape.STArea()
Double
0
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
0
20160330
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAaDjPXrSg5pAASeO9OxigAooooAKKKKACkPb60
tFACbhRn2P5UtFACbvY/lSZAfvzTqKAAHIopNo9/zoxgjrQAtJk+hpaRegoAOfSjn0FLRQAnzegp
MHIPFOooATn2owfUflS0UAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAg7/AFpaQd/r
S0AFFFFABRRRQAUUUUAFFFFABRRRQAUhANLRQAmB7/nS9KKKACiiigAooooAKKKKACiiigAooooA
KKKKACiiigAooooAKKKKACiiigAooooAQd/rS0g7/WloAKKKKACiiigAooooAKKKKACiiigAoooo
AKKKKACiiigAooJApM98cUALTGcqcBCaduHqKaVLc5IoAfRRRQAUUUUAFFFFABRRRQAUUUUAFFFF
ABRRRQAUUhALcjtRtHoKAAd/rS0YxRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAHSk5PsK
CM0ZI6igAAx9fWloooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigBD1FLSEZoBGO9AC
0UdaKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoPSig9KAEHQUtIOgpaACiiigAooooAKK
KKACiiigAooooAKKKKACiiigAooooAKKKTkk80AA6UtIBgUtABRRRQAUUUUAFFFFABRRRQAUUUUA
FFFFABRRRQAUHoaKKAEHQUtIOlLQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFACHpQB
70HpRk5xigBaKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooARelLSL0paACiiigAo
oooAKKKKACiiigAooooAKKKKACiiigAooooAKQ9RS0YzQAnUnmjHuaXFFACY9zQO/wBaWkHU0ALR
RRQAUUUUAFFFFABRRRQAUUUUAFFFFABRSHtz3ox7mgAXpS0gGBS0AFFFFABRRRQAUUUUAFFFFABR
RRQAUUUUAFFFFABRRRQAUUUUAFFI33TRj3NAC0n8Ro2+5oAxQAtFFFABRRRQAUUUUAFFFFABRRRQ
AUUUUAIe31paQ9vrS0AFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFACHJO
M9qWk/i/CloAKKKKACiiigAooooAKKKKACiiigBOc4z2owfX9KP4vwpaAEwfWjHuaWigBMe5paKK
ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigBP4vwpaT+KloAKKKKACiii
gAooooAKKKKACiiigBP4vwpaQ/eFLQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRR
RQAUUUUAFFFFABRRRQAh6ilpD1FLQAUUUUAFFFFABRRRQAUUUUAFFFFACH7wpaQ9RS0AFFFFABRR
RQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAIeopaKKACiiigAooooAK
KKKACiiigAooooACM0g6miigBaKKKACiiigAooooAKKKKAP/2Q==