20180419
08072700
1.0
FGDC CSDGM Metadata
FALSE
CalculateField Centerlines_E_STD ADDR_HN Null VB #
CalculateField Centerlines_E_STD MTFCC_CODE "S1400" VB #
CalculateField Centerlines_E_STD MTFCC_CODE "S1400" VB #
CalculateField Centerlines_E_STD MTFCC_CODE "S1100" VB #
CalculateField Centerlines_E_STD MTFCC_CODE "S1100" VB #
CalculateField Centerlines_E_STD MTFCC_CODE "S1100" VB #
CalculateField Centerlines_E_STD MTFCC_CODE "S1100" VB #
CalculateField Centerlines_E_STD MTFCC_CODE "S1200" VB #
CalculateField Centerlines_E_STD MTFCC_CODE "S1100" VB #
CalculateField Centerlines_E_STD ADDR_PT "Interstate" VB #
CalculateField Centerlines_E_STD ADDR_SN Replace( [ADDR_SN],"I","" ) VB #
CalculateField Centerlines_E_STD MTFCC_CODE "S1630" VB #
CalculateField Centerlines_E_STD MTFCC_CODE "S1200" VB #
CalculateField Centerlines_E_STD MTFCC_CODE "S1200" VB #
CalculateField Centerlines_E_STD MTFCC_CODE "S1200" VB #
CalculateField Centerlines_E_STD MTFCC_CODE "S1200" VB #
CalculateField Centerlines_E_STD MTFCC_CODE "S1400" VB #
CalculateField Centerlines_E_STD MTFCC_CODE "S1400" VB #
CalculateField IDSI201803\Centerlines_E_STD ADDR_HN null VB #
CalculateField IDSI201803\Centerlines_E_STD CENTERLINEID [ObjectID] VB #
DeleteField C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment ADDR_HN;FULL_STREET_NAME
AlterField C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment GEO_FULL_STREET_NAME FULL_STREET_NAME FULL_STREET_NAME TEXT 100 NULLABLE false
FeatureClassToFeatureClass C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment "Database Connections\GIO_Library2_EDITS.sde" COUNTY_Trans_RoadSegment # "ADDR_PD "PreDir" true true false 12 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,ADDR_PD,-1,-1;ADDR_PT "PreType" true true false 40 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,ADDR_PT,-1,-1;ADDR_SN "StreetName" true true false 60 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,ADDR_SN,-1,-1;ADDR_ST "SufType" true true false 40 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,ADDR_ST,-1,-1;ADDR_SD "SufDir" true true false 12 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,ADDR_SD,-1,-1;CURRENT_STATUS "CURRENT_STATUS" true true false 2 Short 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,CURRENT_STATUS,-1,-1;HIGH_ADDRESS_LEFT "HIGH_ADDRESS_LEFT" true true false 12 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,HIGH_ADDRESS_LEFT,-1,-1;HIGH_ADDRESS_RIGHT "HIGH_ADDRESS_RIGHT" true true false 12 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,HIGH_ADDRESS_RIGHT,-1,-1;LOADDATE "LOADDATE" true true false 8 Date 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,LOADDATE,-1,-1;LOW_ADDRESS_LEFT "LOW_ADDRESS_LEFT" true true false 12 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,LOW_ADDRESS_LEFT,-1,-1;LOW_ADDRESS_RIGHT "LOW_ADDRESS_RIGHT" true true false 12 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,LOW_ADDRESS_RIGHT,-1,-1;PERMANENT_IDENTIFIER "PERMANENT_IDENTIFIER" true true false 40 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,PERMANENT_IDENTIFIER,-1,-1;SOURCE_DATADESC "SOURCE_DATADESC" true true false 100 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,SOURCE_DATADESC,-1,-1;SOURCE_DATASETID "SOURCE_DATASETID" true true false 40 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,SOURCE_DATASETID,-1,-1;SOURCE_FEATUREID "SOURCE_FEATUREID" true true false 40 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,SOURCE_FEATUREID,-1,-1;SOURCE_ORIGINATOR "SOURCE_ORIGINATOR" true true false 130 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,SOURCE_ORIGINATOR,-1,-1;ZIP_LEFT "ZIP_LEFT" true true false 10 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,ZIP_LEFT,-1,-1;ZIP_RIGHT "ZIP_RIGHT" true true false 10 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,ZIP_RIGHT,-1,-1;MUNIRIGHT "MUNIRIGHT" true true false 100 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,MUNIRIGHT,-1,-1;STATELEFT "STATELEFT" true true false 2 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,STATELEFT,-1,-1;MUNILEFT "MUNILEFT" true true false 100 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,MUNILEFT,-1,-1;STATERIGHT "STATERIGHT" true true false 2 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,STATERIGHT,-1,-1;COUNTY_ID "COUNTY_ID" true true false 2 Short 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,COUNTY_ID,-1,-1;MTFCC_CODE "MTFCC_CODE" true true false 5 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,MTFCC_CODE,-1,-1;CENTERLINEID "CENTERLINEID" true true false 4 Long 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,CENTERLINEID,-1,-1;FULL_STREET_NAME "FULL_STREET_NAME" true true false 100 Text 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,FULL_STREET_NAME,-1,-1;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0 ,First,#,C:\GIS\DataUpdates\CountyDataSharingUpdates_20180301\For_GIO.gdb\COUNTY_Trans_RoadSegment,SHAPE_Length,-1,-1" IDNR
AssignDomainToField "Database Connections\GIO_LibraryGIO_do_not_use.sde\GIO.COUNTY_Trans_RoadSegment" ONE_WAY OneWay #
AssignDomainToField "Database Connections\GIO_LibraryGIO_do_not_use.sde\GIO.COUNTY_Trans_RoadSegment" ADDR_ST StreetType #
AssignDomainToField "Database Connections\GIO_LibraryGIO_do_not_use.sde\GIO.COUNTY_Trans_RoadSegment" ADDR_PD Direction #
AssignDomainToField "Database Connections\GIO_LibraryGIO_do_not_use.sde\GIO.COUNTY_Trans_RoadSegment" ADDR_SD Direction #
AssignDomainToField "Database Connections\GIO_LibraryGIO_do_not_use.sde\GIO.COUNTY_Trans_RoadSegment" ADDR_PT StreetTypes #
AssignDomainToField "Database Connections\GIO_LibraryGIO_do_not_use.sde\GIO.COUNTY_Trans_RoadSegment" ADDR_PT StreetType #
TruncateTable C:\Users\jmotz\AppData\Roaming\Esri\ArcGISPro\Favorites\GIO_LibraryGIO_EDITS.sde\GIO.COUNTY_Trans_RoadSegment
Append C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment C:\Users\jmotz\AppData\Roaming\Esri\ArcGISPro\Favorites\GIO_LibraryGIO_EDITS.sde\GIO.COUNTY_Trans_RoadSegment "Use the Field Map to reconcile schema differences" "ADDR_PD "PreDir" true true false 12 Text 0 0,First,#,StreetCenterlines-HARVEST,ADDRESS_PREFIX,0,9;ADDR_SN "StreetName" true true false 60 Text 0 0,First,#,StreetCenterlines-HARVEST,ADDRESS_NAME,0,60;ADDR_ST "SufType" true true false 40 Text 0 0,First,#,StreetCenterlines-HARVEST,ADDRESS_TYPE,0,50;ADDR_SD "SufDir" true true false 12 Text 0 0,First,#,StreetCenterlines-HARVEST,ADDRESS_SUFFIX,0,9;CURRENT_STATUS "CURRENT_STATUS" true true false 2 Short 0 0,First,#,StreetCenterlines-HARVEST,CURRENT_STATUS,-1,-1;HIGH_ADDRESS_LEFT "HIGH_ADDRESS_LEFT" true true false 12 Text 0 0,First,#,StreetCenterlines-HARVEST,HIGH_ADDRESS_LEFT,-1,-1;HIGH_ADDRESS_RIGHT "HIGH_ADDRESS_RIGHT" true true false 12 Text 0 0,First,#,StreetCenterlines-HARVEST,HIGH_ADDRESS_RIGHT,-1,-1;LOADDATE "LOADDATE" true true false 8 Date 0 0,First,#,StreetCenterlines-HARVEST,LOADDATE,-1,-1;LOW_ADDRESS_LEFT "LOW_ADDRESS_LEFT" true true false 12 Text 0 0,First,#,StreetCenterlines-HARVEST,LOW_ADDRESS_LEFT,-1,-1;LOW_ADDRESS_RIGHT "LOW_ADDRESS_RIGHT" true true false 12 Text 0 0,First,#,StreetCenterlines-HARVEST,LOW_ADDRESS_RIGHT,-1,-1;PERMANENT_IDENTIFIER "PERMANENT_IDENTIFIER" true true false 40 Text 0 0,First,#,StreetCenterlines-HARVEST,PERMANENT_IDENTIFIER,0,40;SOURCE_DATADESC "SOURCE_DATADESC" true true false 100 Text 0 0,First,#,StreetCenterlines-HARVEST,SOURCE_DATADESC,0,100;SOURCE_DATASETID "SOURCE_DATASETID" true true false 40 Text 0 0,First,#,StreetCenterlines-HARVEST,SOURCE_DATASETID,0,40;SOURCE_FEATUREID "SOURCE_FEATUREID" true true false 40 Text 0 0,First,#,StreetCenterlines-HARVEST,SOURCE_FEATUREID,0,40;SOURCE_ORIGINATOR "SOURCE_ORIGINATOR" true true false 130 Text 0 0,First,#,StreetCenterlines-HARVEST,SOURCE_ORIGINATOR,0,130;ZIP_LEFT "ZIP_LEFT" true true false 10 Text 0 0,First,#,StreetCenterlines-HARVEST,ZIP_LEFT,0,10;ZIP_RIGHT "ZIP_RIGHT" true true false 10 Text 0 0,First,#,StreetCenterlines-HARVEST,ZIP_RIGHT,0,10;MUNIRIGHT "MUNIRIGHT" true true false 100 Text 0 0,First,#,StreetCenterlines-HARVEST,MUNIRIGHT,0,100;STATELEFT "STATELEFT" true true false 2 Text 0 0,First,#,StreetCenterlines-HARVEST,STATELEFT,0,2;MUNILEFT "MUNILEFT" true true false 100 Text 0 0,First,#,StreetCenterlines-HARVEST,MUNILEFT,0,100;STATERIGHT "STATERIGHT" true true false 2 Text 0 0,First,#,StreetCenterlines-HARVEST,STATERIGHT,0,2;COUNTY_ID "COUNTY_ID" true true false 2 Short 0 0,First,#,StreetCenterlines-HARVEST,COUNTY_ID,-1,-1;MTFCC_CODE "MTFCC_CODE" true true false 5 Text 0 0,First,#,StreetCenterlines-HARVEST,MTFCC_CODE,0,5;CENTERLINEID "CENTERLINEID" true true false 4 Long 0 0,First,#,StreetCenterlines-HARVEST,OBJECTID,-1,-1;FULL_STREET_NAME "FULL_STREET_NAME" true true false 100 Text 0 0,First,#,StreetCenterlines-HARVEST,FULL_STREET_NAME,0,100;COUNTY_L "COUNTY_L" true true false 40 Text 0 0,First,#,StreetCenterlines-HARVEST,COUNTY_L,0,40;COUNTY_R "COUNTY_R" true true false 40 Text 0 0,First,#,StreetCenterlines-HARVEST,COUNTY_R,0,40;ONE_WAY "ONE_WAY" true true false 2 Text 0 0,First,#,StreetCenterlines-HARVEST,ONE_WAY,0,2;SPEED_LIMIT "SPEED_LIMIT" true true false 2 Short 0 0,First,#,StreetCenterlines-HARVEST,SPEED_LIMIT,-1,-1;COUNTY_FIPS "COUNTY_FIPS" true true false 5 Text 0 0,First,#,StreetCenterlines-HARVEST,COUNTY_FIPS,0,5;TIGER_TLID "TIGER_TLID" true true false 4 Long 0 0,First,#,StreetCenterlines-HARVEST,TIGER_TLID,-1,-1;TIGER_LINEARID "TIGER_LINEARID" true true false 22 Text 0 0,First,#,StreetCenterlines-HARVEST,TIGER_LINEARID,0,22;TIGER_FULLNAME "TIGER_FULLNAME" true true false 100 Text 0 0,First,#,StreetCenterlines-HARVEST,TIGER_FULLNAME,0,100;TIGER_LFROMHN "TIGER_LFROMHN" true true false 4 Long 0 0,First,#,StreetCenterlines-HARVEST,TIGER_LFROMHN,-1,-1;TIGER_LTOHN "TIGER_LTOHN" true true false 4 Long 0 0,First,#,StreetCenterlines-HARVEST,TIGER_LTOHN,-1,-1;TIGER_RFROMHN "TIGER_RFROMHN" true true false 4 Long 0 0,First,#,StreetCenterlines-HARVEST,TIGER_RFROMHN,-1,-1;TIGER_RTOHN "TIGER_RTOHN" true true false 4 Long 0 0,First,#,StreetCenterlines-HARVEST,TIGER_RTOHN,-1,-1;TIGER_ROAD_MTFCC "TIGER_ROAD_MTFCC" true true false 5 Text 0 0,First,#,StreetCenterlines-HARVEST,TIGER_ROAD_MTFCC,0,5;TIGER_ZIPL "TIGER_ZIPL" true true false 5 Text 0 0,First,#,StreetCenterlines-HARVEST,TIGER_ZIPL,0,5;TIGER_ZIPR "TIGER_ZIPR" true true false 5 Text 0 0,First,#,StreetCenterlines-HARVEST,TIGER_ZIPR,0,5;ESRI_PONAMEL "ESRI_PONAMEL" true true false 100 Text 0 0,First,#,StreetCenterlines-HARVEST,ESRI_PONAMEL,0,100;ESRI_PONAMER "ESRI_PONAMER" true true false 100 Text 0 0,First,#,StreetCenterlines-HARVEST,ESRI_PONAMER,0,100;GEOFULLADDRESS "GEOFULLADDRESS" true true false 100 Text 0 0,First,#,StreetCenterlines-HARVEST,GEOFULLADDRESS,0,100" # #
CalculateField C:\Users\jmotz\AppData\Roaming\Esri\ArcGISPro\Favorites\GIO_LibraryGIO_EDITS.sde\GIO.COUNTY_Trans_RoadSegment LOADDATE time.strftime('%d/%m/%Y') "Python 3" Text
TruncateTable C:\Users\jmotz\AppData\Roaming\Esri\ArcGISPro\Favorites\GIO_LibraryGIO_EDITS.sde\GIO.COUNTY_Trans_RoadSegment
Append C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment C:\Users\jmotz\AppData\Roaming\Esri\ArcGISPro\Favorites\GIO_LibraryGIO_EDITS.sde\GIO.COUNTY_Trans_RoadSegment "Use the Field Map to reconcile schema differences" "ADDR_PD "PreDir" true true false 12 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,ADDR_PD,0,12;ADDR_PT "PreType" true true false 40 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,ADDR_PT,0,40;ADDR_SN "StreetName" true true false 60 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,ADDR_SN,0,60;ADDR_ST "SufType" true true false 40 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,ADDR_ST,0,40;ADDR_SD "SufDir" true true false 12 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,ADDR_SD,0,12;CURRENT_STATUS "CURRENT_STATUS" true true false 2 Short 0 5,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,CURRENT_STATUS,-1,-1;HIGH_ADDRESS_LEFT "HIGH_ADDRESS_LEFT" true true false 12 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,HIGH_ADDRESS_LEFT,0,12;HIGH_ADDRESS_RIGHT "HIGH_ADDRESS_RIGHT" true true false 12 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,HIGH_ADDRESS_RIGHT,0,12;LOADDATE "LOADDATE" true true false 8 Date 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,LOADDATE,-1,-1;LOW_ADDRESS_LEFT "LOW_ADDRESS_LEFT" true true false 12 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,LOW_ADDRESS_LEFT,0,12;LOW_ADDRESS_RIGHT "LOW_ADDRESS_RIGHT" true true false 12 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,LOW_ADDRESS_RIGHT,0,12;PERMANENT_IDENTIFIER "PERMANENT_IDENTIFIER" true true false 40 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,PERMANENT_IDENTIFIER,0,40;SOURCE_DATADESC "SOURCE_DATADESC" true true false 100 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,SOURCE_DATADESC,0,100;SOURCE_DATASETID "SOURCE_DATASETID" true true false 40 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,SOURCE_DATASETID,0,40;SOURCE_FEATUREID "SOURCE_FEATUREID" true true false 40 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,SOURCE_FEATUREID,0,40;SOURCE_ORIGINATOR "SOURCE_ORIGINATOR" true true false 130 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,SOURCE_ORIGINATOR,0,130;ZIP_LEFT "ZIP_LEFT" true true false 10 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,ZIP_LEFT,0,10;ZIP_RIGHT "ZIP_RIGHT" true true false 10 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,ZIP_RIGHT,0,10;MUNIRIGHT "MUNIRIGHT" true true false 100 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,MUNIRIGHT,0,100;STATELEFT "STATELEFT" true true false 2 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,STATELEFT,0,2;MUNILEFT "MUNILEFT" true true false 100 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,MUNILEFT,0,100;STATERIGHT "STATERIGHT" true true false 2 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,STATERIGHT,0,2;COUNTY_ID "COUNTY_ID" true true false 2 Short 0 5,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,COUNTY_ID,-1,-1;MTFCC_CODE "MTFCC_CODE" true true false 5 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,MTFCC_CODE,0,5;CENTERLINEID "CENTERLINEID" true true false 4 Long 0 10,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,CENTERLINEID,-1,-1;FULL_STREET_NAME "FULL_STREET_NAME" true true false 100 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,FULL_STREET_NAME,0,100;COUNTY_L "COUNTY_L" true true false 40 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,COUNTY_L,0,40;COUNTY_R "COUNTY_R" true true false 40 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,COUNTY_R,0,40;ONE_WAY "ONE_WAY" true true false 2 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,ONE_WAY,0,2;SPEED_LIMIT "SPEED_LIMIT" true true false 2 Short 0 5,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,SPEED_LIMIT,-1,-1;COUNTY_FIPS "COUNTY_FIPS" true true false 5 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,COUNTY_FIPS,0,5;TIGER_TLID "TIGER_TLID" true true false 4 Long 0 10,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,TIGER_TLID,-1,-1;TIGER_LINEARID "TIGER_LINEARID" true true false 22 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,TIGER_LINEARID,0,22;TIGER_FULLNAME "TIGER_FULLNAME" true true false 100 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,TIGER_FULLNAME,0,100;TIGER_LFROMHN "TIGER_LFROMHN" true true false 4 Long 0 10,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,TIGER_LFROMHN,-1,-1;TIGER_LTOHN "TIGER_LTOHN" true true false 4 Long 0 10,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,TIGER_LTOHN,-1,-1;TIGER_RFROMHN "TIGER_RFROMHN" true true false 4 Long 0 10,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,TIGER_RFROMHN,-1,-1;TIGER_RTOHN "TIGER_RTOHN" true true false 4 Long 0 10,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,TIGER_RTOHN,-1,-1;TIGER_ROAD_MTFCC "TIGER_ROAD_MTFCC" true true false 5 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,TIGER_ROAD_MTFCC,0,5;TIGER_ZIPL "TIGER_ZIPL" true true false 5 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,TIGER_ZIPL,0,5;TIGER_ZIPR "TIGER_ZIPR" true true false 5 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,TIGER_ZIPR,0,5;ESRI_PONAMEL "ESRI_PONAMEL" true true false 100 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,ESRI_PONAMEL,0,100;ESRI_PONAMER "ESRI_PONAMER" true true false 100 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,ESRI_PONAMER,0,100;GEOFULLADDRESS "GEOFULLADDRESS" true true false 100 Text 0 0,First,#,C:\GIS\DataUpdates\GIO_DummySchema.gdb\DummyCOUNTY_Trans_RoadSegment,GEOFULLADDRESS,0,100" # #
CalculateField C:\Users\jmotz\AppData\Roaming\Esri\ArcGISPro\Favorites\GIO_LibraryGIO_EDITS.sde\GIO.COUNTY_Trans_RoadSegment LOADDATE time.strftime('%d/%m/%Y') "Python 3" Text
CalculateField "Database Connections\GIO_Library2_EDITS.sde\GIO.COUNTY_Trans_RoadSegment" GEOFULLADDRESS getaddress(!ADDR_PD!,!ADDR_SN!,!ADDR_ST!,!ADDR_SD!) PYTHON "def getaddress(pre, name, typ, suf):
address = ''
if pre is not None:
address = address + ' ' + pre
if name is not None:
address = address + ' ' + name
if typ is not None:
address = address + ' ' + typ
if suf is not None:
address = address + ' ' + suf
if address == '':
return None
address = address.replace(' ',' ').replace(' ',' ').replace(' ',' ')
return address"
CalculateField "Database Connections\GIO_Library2_EDITS.sde\GIO.COUNTY_Trans_RoadSegment" GEOFULLADDRESS getaddress(!ADDR_PD!,!ADDR_SN!,!ADDR_ST!,!ADDR_SD!) PYTHON "def getaddress(pre, name, typ, suf):
address = ''
if pre is not None:
address = address + ' ' + pre
if name is not None:
address = address + ' ' + name
if typ is not None:
address = address + ' ' + typ
if suf is not None:
address = address + ' ' + suf
if address == '':
return None
address = address.replace(' ',' ').replace(' ',' ').replace(' ',' ')
return address"
FeatureClassToFeatureClass "Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment" C:\GIS\DataUpdates\COUNTY_Trans_RoadSegment.gdb COUNTY_Trans_RoadSegment # "ADDR_PD "PreDir" true true false 12 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,ADDR_PD,-1,-1;ADDR_PT "PreType" true true false 40 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,ADDR_PT,-1,-1;ADDR_SN "StreetName" true true false 60 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,ADDR_SN,-1,-1;ADDR_ST "SufType" true true false 40 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,ADDR_ST,-1,-1;ADDR_SD "SufDir" true true false 12 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,ADDR_SD,-1,-1;CURRENT_STATUS "CURRENT_STATUS" true true false 2 Short 0 5 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,CURRENT_STATUS,-1,-1;HIGH_ADDRESS_LEFT "HIGH_ADDRESS_LEFT" true true false 12 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,HIGH_ADDRESS_LEFT,-1,-1;HIGH_ADDRESS_RIGHT "HIGH_ADDRESS_RIGHT" true true false 12 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,HIGH_ADDRESS_RIGHT,-1,-1;LOADDATE "LOADDATE" true true false 8 Date 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,LOADDATE,-1,-1;LOW_ADDRESS_LEFT "LOW_ADDRESS_LEFT" true true false 12 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,LOW_ADDRESS_LEFT,-1,-1;LOW_ADDRESS_RIGHT "LOW_ADDRESS_RIGHT" true true false 12 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,LOW_ADDRESS_RIGHT,-1,-1;PERMANENT_IDENTIFIER "PERMANENT_IDENTIFIER" true true false 40 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,PERMANENT_IDENTIFIER,-1,-1;SOURCE_DATADESC "SOURCE_DATADESC" true true false 100 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,SOURCE_DATADESC,-1,-1;SOURCE_DATASETID "SOURCE_DATASETID" true true false 40 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,SOURCE_DATASETID,-1,-1;SOURCE_FEATUREID "SOURCE_FEATUREID" true true false 40 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,SOURCE_FEATUREID,-1,-1;SOURCE_ORIGINATOR "SOURCE_ORIGINATOR" true true false 130 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,SOURCE_ORIGINATOR,-1,-1;ZIP_LEFT "ZIP_LEFT" true true false 10 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,ZIP_LEFT,-1,-1;ZIP_RIGHT "ZIP_RIGHT" true true false 10 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,ZIP_RIGHT,-1,-1;MUNIRIGHT "MUNIRIGHT" true true false 100 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,MUNIRIGHT,-1,-1;STATELEFT "STATELEFT" true true false 2 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,STATELEFT,-1,-1;MUNILEFT "MUNILEFT" true true false 100 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,MUNILEFT,-1,-1;STATERIGHT "STATERIGHT" true true false 2 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,STATERIGHT,-1,-1;COUNTY_ID "COUNTY_ID" true true false 2 Short 0 5 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,COUNTY_ID,-1,-1;MTFCC_CODE "MTFCC_CODE" true true false 5 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,MTFCC_CODE,-1,-1;CENTERLINEID "CENTERLINEID" true true false 4 Long 0 10 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,CENTERLINEID,-1,-1;FULL_STREET_NAME "FULL_STREET_NAME" true true false 100 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,FULL_STREET_NAME,-1,-1;COUNTY_L "COUNTY_L" true true false 40 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,COUNTY_L,-1,-1;COUNTY_R "COUNTY_R" true true false 40 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,COUNTY_R,-1,-1;ONE_WAY "ONE_WAY" true true false 2 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,ONE_WAY,-1,-1;SPEED_LIMIT "SPEED_LIMIT" true true false 2 Short 0 5 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,SPEED_LIMIT,-1,-1;COUNTY_FIPS "COUNTY_FIPS" true true false 5 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,COUNTY_FIPS,-1,-1;TIGER_TLID "TIGER_TLID" true true false 4 Long 0 10 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,TIGER_TLID,-1,-1;TIGER_LINEARID "TIGER_LINEARID" true true false 22 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,TIGER_LINEARID,-1,-1;TIGER_FULLNAME "TIGER_FULLNAME" true true false 100 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,TIGER_FULLNAME,-1,-1;TIGER_LFROMHN "TIGER_LFROMHN" true true false 4 Long 0 10 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,TIGER_LFROMHN,-1,-1;TIGER_LTOHN "TIGER_LTOHN" true true false 4 Long 0 10 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,TIGER_LTOHN,-1,-1;TIGER_RFROMHN "TIGER_RFROMHN" true true false 4 Long 0 10 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,TIGER_RFROMHN,-1,-1;TIGER_RTOHN "TIGER_RTOHN" true true false 4 Long 0 10 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,TIGER_RTOHN,-1,-1;TIGER_ROAD_MTFCC "TIGER_ROAD_MTFCC" true true false 5 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,TIGER_ROAD_MTFCC,-1,-1;TIGER_ZIPL "TIGER_ZIPL" true true false 5 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,TIGER_ZIPL,-1,-1;TIGER_ZIPR "TIGER_ZIPR" true true false 5 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,TIGER_ZIPR,-1,-1;ESRI_PONAMEL "ESRI_PONAMEL" true true false 100 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,ESRI_PONAMEL,-1,-1;ESRI_PONAMER "ESRI_PONAMER" true true false 100 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,ESRI_PONAMER,-1,-1;GEOFULLADDRESS "GEOFULLADDRESS" true true false 100 Text 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,GEOFULLADDRESS,-1,-1;SHAPE_LEN "SHAPE_LEN" false false true 0 Double 0 0 ,First,#,Database Connections\GIO_LibraryREAD.sde\GIO.COUNTY_Trans_RoadSegment,SHAPE.LEN,-1,-1" #
file://\\MXL9194L83\C$\GIS\DataUpdates\COUNTY_Trans_RoadSegment.gdb
Local Area Network
COUNTY_Trans_RoadSegment
002
405637.383700
691585.086500
4181486.414500
4626032.214200
1
Projected
GCS_North_American_1983
Linear Unit: Meter (1.000000)
NAD_1983_UTM_Zone_16N
<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.8'><WKT>PROJCS["NAD_1983_UTM_Zone_16N",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",500000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-87.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",26916]]</WKT><XOrigin>-5120900</XOrigin><YOrigin>1900</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>26916</WKID><LatestWKID>26916</LatestWKID></ProjectedCoordinateSystem>
20210303
15361800
20210303
15361800
150000000
5000
FGDC
Version 6.2 (Build 9200) ; Esri ArcGIS 10.8.1.14362
Road Centerlines of Indiana 2020
2018-04-02T00:00:00
1
-88.135501
-84.695266
41.786142
37.760649
This data set was developed to provide accurate framework data (including address points, street centerlines, land parcels, and governmental boundaries) for Indiana, as part of the Indiana Data Sharing Initiative (IDSI) of the Indiana Geographic Information Office (IGIO).
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>COUNTY_Trans_RoadSegmentis a polyline feature class that contains street centerlines maintained by county agencies in Indiana, provided by personnel of Indiana Geographic Information Office (IGIO) on April 12, 2018. These data were compiled by IGIO as part of the Indiana Data Sharing Initiative (IDSI) between Indiana Geographic Information Council (IGIC), Indiana Geographic Information Office (IGIO), Indiana Geological and Water Survey (IGWS) and participating Indiana counties to provide the most accurate framework data (including address points, street centerlines, land parcels, and governmental boundaries) for the citizens of Indiana. The attributes have been expanded to now include improved street address information better suited for geocoding, property classification codes, and tax district numbers.</SPAN></P></DIV></DIV></DIV>
It is requested, but not required, that the Indiana Data Sharing Initiative (IDSI) between IGIC, Indiana Geographic Information Office (IGIO), Indiana Geological and Water Survey (IGWS) and participating Indiana counties be cited in any products generated from this data set. If citing, the following source citation language should be included: [COUNTY_STREET_CENTERLINES_IGIO_IN: Street Centerlines Maintained by County Agencies in Indiana, (Indiana Geographic Information Office, Line Feature Class), 20180412].
Indiana
Counties
Data Sharing Initiative
Road
Street Centerline
streets, roads, centerlines, addresses, Indiana Data Sharing Initiative
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>This product is provided "AS IS", without any other warranties or conditions, expressed or implied, including, but not limited to, warranties for product quality, or suitability to a particular purpose or use. The risk or liability resulting from the use of this product is assumed by the user. Indiana Geographic Information Council (IGIC), Indiana Geographic Information Office (IGIO), Indiana University, Indiana Geological and Water Survey, and the Indiana counties participaing in this program share no liability with product users indirect, incidental, special, or consequential damages whatsoever including, but not limited to, loss of revenue or profit, lost or damaged data or other commercial or economic loss, including any claims by a third party. The maximum aggregate liability to the original purchaser shall not exceed the amount paid by you for the product.</SPAN></P></DIV></DIV></DIV>
File Geodatabase Feature Class
dataset
EPSG
6.13(3.0.1)
0
Simple
FALSE
0
TRUE
FALSE
COUNTY_Trans_RoadSegment
Feature Class
0
ObjectID
OBJECTID
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
ADDR_PD
PreDir
String
12
0
0
ADDR_PT
PreType
String
40
0
0
ADDR_SN
StreetName
String
60
0
0
ADDR_ST
SufType
String
40
0
0
ADDR_SD
SufDir
String
12
0
0
SHAPE
Shape
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
CURRENT_STATUS
CURRENT_STATUS
SmallInteger
2
0
0
FULL_STREET_NAME
FULL_STREET_NAME
String
100
0
0
HIGH_ADDRESS_LEFT
HIGH_ADDRESS_LEFT
String
12
0
0
HIGH_ADDRESS_RIGHT
HIGH_ADDRESS_RIGHT
String
12
0
0
LOADDATE
LOADDATE
Date
8
0
0
LOW_ADDRESS_LEFT
LOW_ADDRESS_LEFT
String
12
0
0
LOW_ADDRESS_RIGHT
LOW_ADDRESS_RIGHT
String
12
0
0
PERMANENT_IDENTIFIER
PERMANENT_IDENTIFIER
String
40
0
0
SOURCE_DATADESC
SOURCE_DATADESC
String
100
0
0
SOURCE_DATASETID
SOURCE_DATASETID
String
40
0
0
SOURCE_FEATUREID
SOURCE_FEATUREID
String
40
0
0
SOURCE_ORIGINATOR
SOURCE_ORIGINATOR
String
130
0
0
ZIP_LEFT
ZIP_LEFT
String
10
0
0
ZIP_RIGHT
ZIP_RIGHT
String
10
0
0
MUNIRIGHT
MUNIRIGHT
String
100
0
0
STATELEFT
STATELEFT
String
2
0
0
MUNILEFT
MUNILEFT
String
100
0
0
STATERIGHT
STATERIGHT
String
2
0
0
COUNTY_ID
COUNTY_ID
SmallInteger
2
0
0
MTFCC_CODE
MTFCC_CODE
String
5
0
0
CENTERLINEID
CENTERLINEID
Integer
4
0
0
COUNTY_L
COUNTY_L
String
40
0
0
COUNTY_R
COUNTY_R
String
40
0
0
ONE_WAY
ONE_WAY
String
2
0
0
SPEED_LIMIT
SPEED_LIMIT
SmallInteger
2
0
0
COUNTY_FIPS
COUNTY_FIPS
String
5
0
0
TIGER_TLID
TIGER_TLID
Integer
4
0
0
TIGER_LINEARID
TIGER_LINEARID
String
22
0
0
TIGER_FULLNAME
TIGER_FULLNAME
String
100
0
0
TIGER_LFROMHN
TIGER_LFROMHN
Integer
4
0
0
TIGER_LTOHN
TIGER_LTOHN
Integer
4
0
0
TIGER_RFROMHN
TIGER_RFROMHN
Integer
4
0
0
TIGER_RTOHN
TIGER_RTOHN
Integer
4
0
0
TIGER_ROAD_MTFCC
TIGER_ROAD_MTFCC
String
5
0
0
TIGER_ZIPL
TIGER_ZIPL
String
5
0
0
TIGER_ZIPR
TIGER_ZIPR
String
5
0
0
ESRI_PONAMEL
ESRI_PONAMEL
String
100
0
0
ESRI_PONAMER
ESRI_PONAMER
String
100
0
0
GEOFULLADDRESS
GEOFULLADDRESS
String
100
0
0
Shape_Length
Shape_Length
Double
8
0
0
Length of feature in internal units.
Esri
Positive real numbers that are automatically generated.
20210303
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAR13Iy
5xkYrOt7xbWJraVWWSBQCT0bPCkfXH860qwMQJql2sjyeW8iZLZK8AkjP1PTp096AJXtZWt4VRyE
zz8udxPJI7461dVJVi85rkOFXIJT/wCvUcl7bySrulxDgjpjJ/nUbNavFdQecvlFRgA4oAhu5pM3
DrIpmSEGPGQD37HmqkOgz3U6XN7JFJB94QxjarccE4/PFLrEVnFoaxQOhmBHlngkknvW7FcxCBN8
ihtoyM9DigCIt5k8Qt2VG8tiQV91oEM7S7ZpFJ6j5eMfTNRLdRterKrA7o2UA8d161YGSVc3C7gT
7jBoAjtY2MCOksYIXBITke3WsXV9evLC9EMToU2ggtH15Pv7VqRtb/ZI4wd0mwc7sDPqe1YXiQxy
6mpGGAiAGPqaAOxooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii
igAooooAKKKpaiXeJLZG2/aCYyw6qCDkigAm1W0iVsSeYw42oM5PpWHZT3EjRxPG3lbg7YHOSe/t
n+VbN1FC0ciZMSRqFCx8E+n9Kgh08WySTRkjcRgNnIGf60AapRCMFV/KsqNIZL+WEbVyowIxxwTy
atTzTeXIAsbqBhuSPwz61VWYrMhXymXASXaOWHr+HNADL77PbajaCaNVt2JYvjgv2B/OtWdo44WL
MicHBbiszXY4joUghbHl4aMq33TnrmnT6Ut5p8YaZ9/ljkuWGcc0AX4RE9sm0KVKjHftUFuyR6ex
KAmPORj8R+hFQWmnRpboRMCWwxYgFh9DVqxKi3KEj5T1z1yAf60AQ6d5cdrGG6BFAYjg4HWsHxKc
aoMDI8odPqa24NiwKow3zZ2k5B61heIwg1NQoXAiAGPxoA7GiiigAooooAKKKKACiiigAooooAKK
KKACiiigAooooAKKKKACiiigAooooAKKKKACiiigArL2S3uqCaKbZDbNt+6DvP8AEP5VoXDRrbyG
V9ibTubPQVn6ddEWZVYkKRNs3owAfpyPrmgCdEMkz3EcSMTjYz5HGPpSyN+7eKdwQf41P3fr+NUr
nUJLCwjf7wHyZwMAgEn+RqG8v1js7b7KIZ7hiCxPO0E4LHHv70AaSyfaYE8kL8oDED19B+tTeREy
Bo1Ctj5WHBrFFlqKGdnuzGvlsQsQAzgcdc981Ysvt8Vr9okLM38cUnGRjqvp/I0AGrWmdIuGnEKh
Uydidfx61ft4IHtYmCbQyAhd5OOKrPO2pxm3ijdEbAmL/KQOpAH0pp0uKN3Aml3LF+7dm5jx0xj0
oAsSwwxXCEQphYX42+60rW8C2ibYk6pztHPIqko1S9kQsscARSC5GdxzngenA/M0/wDtaKWJopFe
O4jZd8W0k9c5GO2BmgCxJDCBI3kpw6gAJ1IxXO+I0RNTAVQo8scAY9a2zqFq8wUyBFL7ld8rxjtn
r/8AXrC8RzRPqnyyKcIAcHvzQB2VFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAF
FFFABRRRQAUUUUAFVr6WWG0Z4VZnyB8q7iATycDrirNU9TnEVk6A/vZQUjA6kn+goAjSCKe3We5u
WngA3AOAqj3I/wAar22raR8zrtgZem9NpI55Hr0p6QedAIri7TyVG3ZCpQH68mrAWwgjC7Y8IgHI
ycCgDMTTYDa4dCrNmcxmQgEk5AxnFWpbWOUSCCFUmMS7iRt3cjGT+Bp8N3DLZ7kg2Fzt4XIz9ajm
kLu0kGWVAseCh5/H8aAHm7E0RmYbA0LAKWzk88D1q3PcwmBwJFyVNUore3gvLPyRhsNu5Pp/jV29
mCW7opBkYYAzQA23sY4nExLPJ13NjI4xSvIhuXQq5ym0hVP86aFmklaJpQqqoIwOTn8aUxtCxdJF
3EqpG31I9/egCaJnDbJByclfcf5NZ4ZhfXhjRi/noCVHbYuRmrcizm4QJKu4KckpkAZHv7fpVWzQ
LfXySkuTMoDdOfLWgCwYRGi+aAUIKsCc7c0kFhafZ0Bt43wCAXUMevqaZdhFkSJQS7K2FBJzxxmo
pEFowQJuBAPzP04xj9KANWiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAo
oooAKKCQASTgCshtWl85gqIVdCYgM7ic4X8+fyoAv3lwbaDcq7pGO1F9TTba3YMLieUyTFcDgAKP
QCs+GWS4eKOSQSTRSybhjlVGRz9e31rXiOYkP+yKAKH3HYtFJtLlmXHB96nUKsJlt137j3HQc9BV
ouqkBmAJOBk9az5XFrdI1um8SFgyK3f1oASCSaW4CFWZDnejrtCemKnZl86RGkCKG3N07BaYL18k
Ouwg4I25x+NMS4IlkYgsHYfLs4PAH9aAJLq2t9QMIfLJ8x+Viv8AKqN9ZaaIp0SECaNC+4Mcjp3z
7irqzJ9qURo/lxqQQBwDmo7qeGXTp5IYz8yH5tmM0AT29xahflaJGAwRkUydrQKzCVAXdNxEn+0P
eppYVwsgwpQZJPTAqqYzdSOFZB8uBheO1AE9tLDsEjTqWYdWft2qmksTahdgSqpMqneGHA8tQa0S
ZIQCfnXuAORWdZXqm6vXMbsTIp+Vf9haAIXeFrgQSOP3WSkgf24/WpY7i4O4G6gXBxh8H9asXcsU
qQTOGFv1L9NpPA9+tSWs8zQ42Btp27i2CR2NAFyiiigAooooAKKKKACiiigAooooAKKKKACiiigA
ooooAKKKKACiiigAooooAxtYnvY7uGOzVpFdGEqBcgA8A1PA9vAsWLa4LRrtV2iy2Ks3MMnmpcQY
MqDaVboy+n1qmdRS7n+zQ70l6SZz8uCMjjvyKAIpb6ITTeWkyu7AMREc9AKuWd7G1soZ+RwMjkiq
jJMGWOJTIhywYcHcOcnse1RrH5jtbQz3SGPJKHbgHqADj196ANAv5lwrNGm4YKbuCuc/4CktFBle
UlMh2HBrKd3jvI2u52eNG2lXAySVJ7D2qys+nSFjLcLGm4kR52j8e9AGjAXEsvmbME/KQRyKSd4G
xHld24e1UoJdIgZj9rt2LHjewOKbeXNi6JFaT2wuGdQpTaSOaALEpHmPHa7AWTLMTwOefxxUc4eP
Sp4wFAEWQB2P1p1tYyPAkgvZQZEBICpgcduKrnT7y4eWNr2QIvysCFG4YHoKAJpr+U2yb4ZUYH96
FQkYHvilW9BvElEEyqY/nPlnr6VJLuS1lje6XcFb5e/PbmljklYyJIbjKtxhV6du1AC/2rB2jm+v
ln/PcVVsQZXvmjjBJugcOCMAotSiPy7iMK0w+U5DgcjKj0qc6eBNLJFcTQ+YQzKm3GcAdx6AUAQr
bRrI0SSSCMscru4/zmqckkytlZpBu5Pzfh/SpLHT5bm3M815Nuk9Nv09KjvNMuVlURT3DqF67V9T
7UAb1FFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRUc88VvHvmkVF6ZJo
Aq3GoLuWO2kiaQ53FjkKAO+PwFUtOs5XFxLc29v50rbm7Hp+lRm2t5YorS0mkmYbQrE/LGoI54wC
cVo+Szyuk0+W/hOwAkf5NAFTCQT7I4ok+6QfMJ6HnnFTzXjB1ljg3bcg4bjt3pLa1jaZmlIOxBjt
gZbr+VOjVy3nFjJBGMjfjLH+9xQBVeaaW8t0htx9oV3kZmIwABtPv/EKsX73C2ksjEx5XbjIx0OT
TDeJNq8Xkyou2B8lxxyy+49KbdMl1a3Ymk5CEJgFV6H3oAS4aJ7+R+rAbR6fdP8A9al1K4jMdpti
BZ5FPToO/wDWqdrd/v5EkMAVVI34Izg5x171JHGJp4mMqEPKAQh5XAb+eaANVLZo3VohCgAxwhGf
1qJ5bi3umBUSeaMgIp4xwT/L86nliiijz8+chQA5HJOBVa3dxM8hLyBMqSGBwPTmgCZpALd0EczM
QeTGeSaU3A3NIm4ADDbo27Un2+KWcW8LHzGGc4+7SxRlYpoedwYsCe4JyKAGefHNNE5VynlsG/dt
wSV46exoi1GBV8smUvHhXAiY4OM+npTIL1GgLRSoTFuaVT1xzUGm3KLCZtzyGf53IUnc2Oo9gMD8
KACy1FINOTcpyFOOG5PoeKmfUpkbAspn46opx+uKqQgGGNWDHcQ2PLPA3DOD9K0DPaR4VnYHHfPN
AF2iiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAqlqsatYSSkNuhUupU4wc
VdqpfXQhi2qiSMzBCrNgDPr1oArx2UiWaoVYyqhG8EDJp3k+WFVopGL/ACndtbtU1sTbWdvB80zJ
GoLLjnAxnk1VvdSEMkYdVj+fgu3TjuB9aAGz2iqpZbZ0jAG5VIBOO+c+/wClS7fJQo1oX3EhWO0n
p/8AWp7zPPasySxPHkAlVPr9aluZ4/JLJIBImWX64NAGFdtbiSIJAw/dctx1LLk5qW6uv9EuAxcb
xhTwRxxyB9D0prRPdX0jLIWLw5O1DgfNwOPpVW6sMXiW6iQNI6jORxk89PbmgCG1niadTI+0hgyt
jOzjqRUkQJ3Sxzspt8thcZLHPI9R0qld2slldSxDJjV9oLj73H/16sRvcLbyzW8eMRkOVXjBFAGn
dzTT20PlvOrnaxyDyccY9Oak0+ztvKZjkMpJ7ZYYrIknLLbrjLcKTswP/r1rqzXASJYF85wHY44U
fXJoAsNpq+ckxkdS75AVuQSMZz16AVJeSHTYWuA7yg4QRt8zEk9jSy3brDHJIkYCnJAfJJ9AMU60
gN1Gl1dqfNYZVDwIwfb1xQBR0yxt3RY7xIpLhexXnnnnP+eK0fs9vbyqYdkB24wq8YqsyPG7SRoS
ySEIcg+2BmrUXnKG32+WYkk7wcigCC3WeSFDHKMoBjK+vWnyWElwQ8s2GxjAUVYtOLOLPHyintcQ
qcNKgPoWFAElFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAEVzJJFbSPEm9
1XIX1rBuYFuUe7RbiOVxvyih0JxgH17Cuid1RC7kBQMkntWXBeJbkiJ0lt3k+UBsOhY9Np9z+VAF
mCYCBZGt5FkZAX+XnOKpwWEWqM15dwABx8iAn/vo+9bFU7fNtdG0JzGUMkR7gA8j8Mj86AIo5Wjj
NpL/AKyN12sf403DB+vrVmW8ijk8sBpJAMlUXJH1p89rb3IAnhjkx03qDilhght02QxJGvXCjFAG
N+/hupLhY5fswT5yQFYDJJA/Srs0Qt7iK8SLeioQ2OWAOOR69Kk1Ij7Moc4iaRRIfRc/ypJ76IJ5
dq8cs7cIinOD6nHQCgBJrOG9CXMLhXK5VwNwYe470Q2TsVNz5e1Puxp93PqfU/yqxa262trFApyI
1C5PepqAGtGjrtZFK+hFZ8djLYSs9kEaFuWhbgj/AHT/AENaVFAGU9zBJfwZQq0aszIV5U8AH9a0
jMg/iz345qG6s1udr5KSp91x/I+oqNZriBdslmWx/FCRg/gSKAHwJ5jmTcCqyMQMf1p11deRsRF3
TSHCKeB+NFpKs0TSKCAXPBGCPrUV2iyX1muPmVmfPoAP/r0ANi0xfLUXUjTkDoThR9B/jUo02yH/
AC6xfioq1RQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUANdFkRkcZVhg
iqP9mfMHFy4deEbaMqPfjn8a0KKAKRuJ7NsXOJIT0mUYIPow/rS2sUkrpdzk+ZtIVMYCAkH8+BVy
igAooooACMjBpqoifdVV+gxTqKACiiigAooooAKKKKAKJY2d5K3lSNFKAw8tc4fkH8xj9afbRyvc
PdTLsLKEjTOSq9efc/0FW6KACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigD//2Q==