20131210
16004400
1.0
FALSE
CalculateField Join_Output SEGID [SEGID_1] VB #
CalculateField Join_Output ADDRESS_ID "900000 + ( [FID] + 1)" VB #
CalculateField Join_Output CITY "GLENDALE" VB #
CalculateField Join_Output CITY "PHOENIX" VB #
CalculateField Join_Output CITY "MARICOPA COUNTY" VB #
CalculateField GISADMIN.ADDRESS_100BLOCK CITY "MC" VB #
CalculateField GISADMIN.ADDRESS_100BLOCK STATE "AZ" VB #
CalculateField GISADMIN.ADDRESS_100BLOCK CITY "MARICOPA COUNTY" VB #
CalculateField GISADMIN.ADDRESS_100BLOCK STREET_NAM Mid( [STREET_NAM], 3 ) VB #
CalculateField GISADMIN.ADDRESS_100BLOCK STREET_NAM Right( [STREET_NAM], 3 ) VB #
CalculateField GISADMIN.ADDRESS_100BLOCK STREET_NAM "PARADISE" VB #
CalculateField GISADMIN.ADDRESS_100BLOCK STREET_NAM "COTTON" VB #
CalculateField GISADMIN.ADDRESS_100BLOCK UNIT_NUM "100BLK" VB #
CalculateField GISADMIN.ADDRESS_100BLOCK UNIT_NUM "100BK" VB #
CalculateField GISADMIN.ADDRESS_100BLOCK UNIT_NUM "100BK" VB #
CalculateField GISADMIN.ADDRESS_100BLOCK UNIT_NUM "100BK" VB #
CalculateField GISADMIN.ADDRESS_100BLOCK CITY "GLENDALE" VB #
CalculateField GISADMIN.ADDRESS_100BLOCK CITY "MARICOPA COUNTY" VB #
CalculateField GISADMIN.ADDRESS_100BLOCK CITY "GLENDALE" VB #
CalculateField GISADMIN.ADDRESS_100BLOCK SEGID 12673 VB #
CalculateField "SDE\100 Blk Address" SEGID 885 VB #
CalculateField "SDE\100 Blk Address" SEGID 27006 VB #
CalculateField "SDE\100 Blk Address" SEGID 18740 VB #
CalculateField "SDE\100 Blk Address" SEGID 13087 VB #
CalculateField "SDE ADDRESS_100 BLOCK" SEGID 18993 VB #
CalculateField "SDE ADDRESS_100 BLOCK" SEGID 19479 VB #
CalculateField "SDE ADDRESS_100 BLOCK" SEGID 21577 VB #
AddField C:\batch\database_connections\gisadmin@AGSQL607GIS_Land.sde\GISADMIN.ADDRESS_100BLOCK GlobalID "GUID (globally unique identifier)" # # # # NULLABLE NON_REQUIRED #
DeleteField C:\batch\database_connections\gisadmin@AGSQL607GIS_Land.sde\GISADMIN.ADDRESS_100BLOCK GlobalID "Delete Fields"
AddGlobalIDs C:\batch\database_connections\gisadmin@AGSQL607GIS_Land.sde\GISADMIN.ADDRESS_100BLOCK
AddGlobalIDs C:\batch\database_connections\gisadmin@AGSQL607GIS_Land.sde\GISADMIN.ADDRESS_100BLOCK
AddGlobalIDs C:\batch\database_connections\gisadmin@AGSQL607GIS_Land.sde\GISADMIN.ADDRESS_100BLOCK
AddGlobalIDs C:\batch\database_connections\gisadmin@AGSQL607GIS_Land.sde\GISADMIN.ADDRESS_100BLOCK
AddGlobalIDs C:\batch\database_connections\gisadmin@AGSQL607GIS_Land.sde\GISADMIN.ADDRESS_100BLOCK
AddGlobalIDs C:\batch\database_connections\gisadmin@AGSQL607GIS_Land.sde\GISADMIN.ADDRESS_100BLOCK
EnableEditorTracking C:\batch\database_connections\gisadmin@AGSQL607GIS_Land.sde\GISADMIN.ADDRESS_100BLOCK created_user created_date last_edited_user last_edited_date ADD_FIELDS "UTC (Coordinated Universal Time)"
GISADMIN.ADDRESS_100BLOCK
002
Server=GISDB03; Service=sde:sqlserver:GISDB03,18181; Database=GIS_Land; User=gisadmin; Version=sde.DEFAULT
ArcSDE Connection
534640.100722
632380.199147
907863.782152
981150.722113
1
Projected
GCS_North_American_1983
Linear Unit: Foot (0.304800)
NAD_1983_StatePlane_Arizona_Central_FIPS_0202_Feet_Intl
<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.5'><WKT>PROJCS["NAD_1983_StatePlane_Arizona_Central_FIPS_0202_Feet_Intl",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",700000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-111.9166666666667],PARAMETER["Scale_Factor",0.9999],PARAMETER["Latitude_Of_Origin",31.0],UNIT["Foot",0.3048],AUTHORITY["EPSG",2223]]</WKT><XOrigin>-17746700</XOrigin><YOrigin>-44067300</YOrigin><XYScale>3048</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808398950131233</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2223</WKID><LatestWKID>2223</LatestWKID></ProjectedCoordinateSystem>
20170109
16051200
20170109
16051200
Microsoft Windows 7 Version 6.1 (Build 7601) Service Pack 1; Esri ArcGIS 10.5.0.6491
ADDRESS_100BLOCK
1
-112.460351
-112.138480
33.696856
33.494452
SDE Feature Class
dataset
EPSG
5.3(9.0.0)
2703
Simple
FALSE
2703
TRUE
FALSE
GISADMIN.ADDRESS_100BLOCK
Feature Class
2703
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
ADDRESS
ADDRESS
String
50
0
0
SEGID
SEGID
Integer
4
10
0
HOUSE_NUM
HOUSE_NUM
Integer
4
10
0
STREET_PRE
STREET_PRE
String
50
0
0
STREET_NAM
STREET_NAM
String
50
0
0
STREET_TYP
STREET_TYP
String
50
0
0
CITY
CITY
String
50
0
0
ADDRESS_ID
ADDRESS_ID
Double
8
38
8
Shape
Shape
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
STATE
STATE
String
10
0
0
UNIT_NUM
UNIT_NUM
String
20
0
0
20170109
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD02iii
vXOAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii
igAooooAKKKKACiiigAooooAr2EEttYQwzyeZKgIZs5zySBz6DA/CrFFFJKysNu7uFFFFMQUUUUA
FFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAU
UUUAFFFFAEFndx3tss8YZVJZSGHIKkg9PcVPTY40ijCRqFUdABTqSvbUb30CiiimIKKKKACiiigA
ooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACi
iigBkM0dxEssLh0boR+Rp9Q2ttHZ26wxZ2gk/Mckkkkn8yampK9tRu19AooopiCiiigAooooAKKK
KACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoooo
ARWDKGUhlIyCDkGlqtY2gsrRYA5fDMxYjHLMWPH41ZpK9tRvfQKKKKYgooooAKKKKACiiigAoooo
AKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACisrSo
dStXn+2yPOHfKEybscnnnoOnHtUUmmamdPiiju0WdLh5PMMzn5CWwp4BPUd+1ZOo7X5S+RX3Nqiu
Rfw94gNoIl1gCUIyrKJHJTIx6c8/T8639PiubO1MUymQmWR12vkIjOSqgnB4BAohUlJ2cbBKCS0Z
forJa31M214iyyLK975kDGX7kWF+Xg9OG4IPXpVK7sNfkUtbXskcjzSPgzkrGDtEY5PzABWJHq54
pOq/5WPkXc6OisjTodUg024hupJJLlixicyByvygDk/7QY+2ahvIvEBtrU2jBJxbFZ97IQZPl5HO
M/e9OT17U3VaV7MOTXc3aK5iaHxRJOjhkjjLJ5kcUoxsDR7guSSGwJOc9+vStOE6mq6WsrOWEbLe
bVQ5baMEZHXdnpxSVa/Rg6fmalFc/cHxItmz28iyTkTKsbRxgAZPlvnHXGBjHuaS0m1sarGtzIPs
m5+GVQSm59u7A+9t8vp7+9CrXdrMPZ+Z0NFUbhrsagoj837MbZySiA4k3DbyVPbPGDWTPJ4qAtyi
whDbDzfLVWkEmVycEYzgtgDjj8A5VUnazEqd+p0lFYmlSa81/jUlCw+W24BFCg4j24IGSSTLkZwM
DpU1xPqqx6h5VsxkjnUWo8o4kTauc9c8lueOnUUe2Vr2D2bva5q0VgX93r0WoSpZ2jPbh/3bNH9/
lPlPTC8vz7Dmrmjz6lMk51GHyyH+T5dv1A9QPWiNVSdrA6bSuadFULnVobWLUJJIZiLFBJJtC/Mp
BORk+1Vr3xHZ2LzLJDcMYgCxQKRjaW659BnB55FN1YLdgqcmbFFZ+laxbauZPs6SqE5y6gbhuZQR
gnuh4PPSnJqts9tZ3A8zyrtisZKdxngj8DT9pC17i5JbF6isabxRpkCRO7ShZY0kB2dA+/aD7ny2
/Kr8OoQT6eb1N/lBWJBX5htzkY/ChVIvRMHCS3RaorNudcs7VLdpC+LiISRYX7wJVQPrl1qsPFWm
M6IjSM0hCRgJ95iVG365YUvaw7j5JdjboqGC5iubOK7iJaKSMSqcclSMjj6VUk1zT4ba2uJJisNz
GJYWKH5gcY/HkcVTnFbslRbNGisgeJtIOzF0W3hSuI2OSeg6dfar639q9pb3QmXybjYImPG7d938
6SqRezG4yXQsUVSl1fT4WKy3caMJPLIY4IbaGx+RB/GmRa3ps0qRR3SF3baF75yoH0zuXH1FHtId
w5JdjQoqu19aIJS9xGoifZISfutjOD6cGmS6pp8M7QyXkKyqwRlLcgnHB/MfnT549xcr7Fuiobe7
t7sObeZJQh2ttOcGnG4hAz5qY3+X97+L0+vIp8y3uFmSUVCbu2BQGeMGQkJlvvY64p8E0d1H5kEi
ypnG5DkZoUk+oWY+iqOkXz6jp63EkaoxYr8udrAdxntV6iLUldA1Z2CiiimIKKKKACiiigAooooA
KQqGGCAfrS0UAReQo+4zJ/unj8qMzJ1CyD/Z+U/l/wDXqWiiwXIvPToQwb+6V5NHnEfeikH4Z/lU
tFAEX2hf7kv/AH7NH2hf7kv/AH7NS0UagVWW2cyF7ckyY3kxH5sdM+tNaKyffutlO9t7Zi6n16Vc
oqeVdh8zK0RtoC5ih2bzubbGRuPvx71GkFhGkSJZxqkWTGoh4XOc449zV2qlxqdlaSvFcXAidAGI
cEcEkAjjkcHp6GlJRW9hpyexC1jpTBAbCHEabEAh+6vPHT/ab8zU6C1jtvs6whYNpXy/LwMH2qE6
5pYDH7dEdpAOMnru6eo+RuRx8p9K0AQQCDkHoaUVB/DYb5upQe20yRESS1gKomxN0Y+VeOB6dB+Q
phsNHPP2W16AD5Bxggj9QPyrSop+zj2Qud9yBZbVIViRkSNV2Kq8BRjAAx0qtHZaZEIfLQAQw+RH
+8b5U9Ov+cVoUmB6Cm4J7oFJrYzG0fRmKn7LCNiqq7SV246EYPB9+tWHtbF7SC12qIYGRo0VyNuz
7vQ1b2L/AHR+VJ5af3F/Kl7OK6BzvuZcuhaROpE0PmZlaYlpmJLNgEk554AH4U2Hw/o9vOk8cQEi
EEEysc4KkZ55AKLj6Vq+VH/zzT8qPKj/AOeaflS9lHsPnl3Kc2lW1154aSUrPMs0ihhhioAAIxyv
A4PpUdzoNhduzypIWZ2dzv5fcVJB9vkX8qvmCI/wD8KT7PGPu5X/AHSRR7KPYOd9yCw0y20xZFtg
4DnJ3NnGOgHsKibRLV1Kme62Nd/a2TcmGYYwD8n3QQD68daueSR92WQfU5/nRsmHSYH/AHl/wxQ6
cWrWFzO97mHF4M0yGOOMTXjRxqECNIMFQAAPu/7IORyT1Na+lWEWkW7wwvJJvYOzSkEkhVQdAB0U
VLi4HeJvbBH+NG64/wCeUX/fw/8AxNCpwTukNzk+pKSSck5oqpp2owana+fAHVc4IcAEcAjoT2Iq
3Vppq6JaadmFFFFMQUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABVKbSLG4W6E0Jf7Uy
tKSxz8owAD2GOw9T61dopOKluNNrYx/+EX0n5sQOM9MSEbR8/A9B+8f8611UKoVRgAYApaKUYRjs
gcm9woooqhBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAEVvbQ2kQit4ljjHO1RgVLUUFzBdIXgmSRQ
cEqc4NS0la2g3e+oUUUUxBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFY2pWWrXD3b2
V0sG5USFfMOD3ZjxwegGPQ+tbNFTOCmrMqMuU5f+zfE2Hzfqc4ziUjd8zEY4+XAKj3xXSxB1hjEr
BpAoDMO5xyafRUwpqGwSm5BRRRWhIUUUUAFFFFABRRRQAUUUUAFFFFABRRRQBS03S7fSoXit2kYO
QSZCCeBgDgDoBV2mpJHJny3V9pwdpzg06lFJKyG229QooopiCiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKzb671CK4nW1t0eKK3DAtGxLyk4VQQwyOCT6ZFaVFTKLktHYcXY5q61fXre5e
JdPicIcM6xOQvEeG+98wJZ+B02810UDO9vE8qbJGQFl/unHIp+T60VMIOL1dxyknsgooorQkKKKK
ACiiigAooooAKKKKACiiigAooooAz9L0mLSxMI5HfzWz82OAOg/+vWhVOw1S11NZGtmZghwSy4yO
xHtxVyphy8vu7FSvfUKKKKokKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigArK1WfVIZs
6fbtIiQ7nDjKsxbAC4GcgZJ69uOa1aKmceZWvYcXZnMXGpeIjKDDp0kcZxuVkDlF2x/MDgbmy0gx
j+EcDv0No8z2cL3KBJ2QGRR2bHNTUVMIOLu3cqUk+gUUUVoQFFFFABRRRQAUUUUAFFFFABRRRQAU
UUUAVLeyjsN/2WFArncwHBJ+tWUcOOMgjqD1FOpjxhznJB9QcGklbYbd9x9FReQO8khHoWpqZ8zE
TsyA/NnkfQGi4ieiiimAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFUbrUJYbxLS3sTdStC0
xAnEeAOBnIxyTgc+vpV6kKg5yAcjByOoqZJtaOw4tJ6nOP4wh3Hy7GRl+6D5mPm2q3OV+782N3qO
lbljdC+sobkRmPzFztJzj8al8qMkkxpkrtPyj7vp9PangAAAAADoBUwjNP3ncqTi1ogooorQgKKK
KACiiigAooooAKKKKACiiigAooooAydJbWTczf2nGipsXbtKkbsnO3BzjGOta1FFRTVolTd2FRW3
Fug9Bj8uKKKrqSS0UUUwCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigD//2Q==