20230124
17360500
1.0
FALSE
Rename "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS" "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_OLD_" FeatureClass
Rename "G:\GIS\Run\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_OLD_" "G:\GIS\Run\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW" FeatureClass
RemoveSpatialIndex "G:\GIS\Run\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW"
TruncateTable "G:\GIS\Run\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW"
Append 'G:\GIS\Run\Database Connections\SDED_GISADM.sde\GISADM.COUNTY_PARCELS' "G:\GIS\Run\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW" TEST # #
AddSpatialIndex "G:\GIS\Run\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW" -2 0 0
Rename "G:\GIS\Run\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW" "G:\GIS\Run\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS" FeatureClass
Rename "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS" "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_OLD_" FeatureClass
Rename "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_OLD_" "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW" FeatureClass
RemoveSpatialIndex "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW"
TruncateTable "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW"
AddSpatialIndex "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW" -2 0 0
Rename "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW" "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS" FeatureClass
Rename "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS" "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_OLD_" FeatureClass
Rename "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_OLD_" "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW" FeatureClass
RemoveSpatialIndex "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW"
TruncateTable "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW"
AddSpatialIndex "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW" -2 0 0
RemoveSpatialIndex "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW"
TruncateTable "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW"
AddSpatialIndex "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW" -2 0 0
RemoveSpatialIndex "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW"
TruncateTable "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW"
AddSpatialIndex "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW" -2 0 0
RemoveSpatialIndex "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW"
TruncateTable "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW"
AddSpatialIndex "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW" -2 0 0
Rename "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW" "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS" FeatureClass
Rename "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS" "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_OLD_" FeatureClass
Rename "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_OLD_" "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW" FeatureClass
RemoveSpatialIndex "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW"
TruncateTable "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW"
AddSpatialIndex "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW" -2 0 0
Rename "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS_NEW" "C:\GIS\Service\Database Connections\SDEP_GISADM.sde\GISADM.COUNTY_PARCELS" FeatureClass
FeatureClassToFeatureClass "County Parcels" "\\one\pdd\Shared\Information Systems\GIS\Logan\Data_Entry\Data_Entry.gdb" County_Parcels_1_24 # "PG_APN "PG_APN" true true false 12 Text 0 0,First,#,County Parcels,PG_APN,0,12;PG_RETIRED "PG_RETIRED" true true false 1 Text 0 0,First,#,County Parcels,PG_RETIRED,0,1;APN "APN" true true false 16 Text 0 0,First,#,County Parcels,APN,0,16;PROP_CODE "PROP_CODE" true true false 6 Text 0 0,First,#,County Parcels,PROP_CODE,0,6;ADDRESS "ADDRESS" true true false 96 Text 0 0,First,#,County Parcels,ADDRESS,0,96;CITY "CITY" true true false 40 Text 0 0,First,#,County Parcels,CITY,0,40;ZIP "ZIP" true true false 24 Text 0 0,First,#,County Parcels,ZIP,0,24;FLOOR "FLOOR" true true false 2 Short 0 5,First,#,County Parcels,FLOOR,-1,-1;OWNER "OWNER" true true false 100 Text 0 0,First,#,County Parcels,OWNER,0,100;OWN_ADDR "OWN_ADDR" true true false 150 Text 0 0,First,#,County Parcels,OWN_ADDR,0,150;OWN_CITY "OWN_CITY" true true false 40 Text 0 0,First,#,County Parcels,OWN_CITY,0,40;OWN_STATE "OWN_STATE" true true false 4 Text 0 0,First,#,County Parcels,OWN_STATE,0,4;OWN_ZIP "OWN_ZIP" true true false 15 Text 0 0,First,#,County Parcels,OWN_ZIP,0,15;GIS_CITY_OWNED "GIS_CITY_OWNED" true true false 2 Text 0 0,First,#,County Parcels,GIS_CITY_OWNED,0,2;GIS_PROPERTY_USE "GIS_PROPERTY_USE" true true false 3 Text 0 0,First,#,County Parcels,GIS_PROPERTY_USE,0,3;ASSESSOR_INFO "ASSESSOR_INFO" true true false 100 Text 0 0,First,#,County Parcels,ASSESSOR_INFO,0,100;ASSESSOR_LOT_AREA "ASSESSOR_LOT_AREA" true true false 8 Double 8 38,First,#,County Parcels,ASSESSOR_LOT_AREA,-1,-1;STREET_NUM "STREET_NUM" true true false 6 Text 0 0,First,#,County Parcels,STREET_NUM,0,6;STREET_DIR "STREET_DIR" true true false 2 Text 0 0,First,#,County Parcels,STREET_DIR,0,2;STREET_NAME "STREET_NAME" true true false 40 Text 0 0,First,#,County Parcels,STREET_NAME,0,40;STREET_TYPE "STREET_TYPE" true true false 12 Text 0 0,First,#,County Parcels,STREET_TYPE,0,12;STREET_SUFFIX "STREET_SUFFIX" true true false 24 Text 0 0,First,#,County Parcels,STREET_SUFFIX,0,24;STREET_POSTDIR "STREET_POSTDIR" true true false 4 Text 0 0,First,#,County Parcels,STREET_POSTDIR,0,4;SUITE "SUITE" true true false 7 Text 0 0,First,#,County Parcels,SUITE,0,7;SE_ANNO_CAD_DATA "SE_ANNO_CAD_DATA" true true false 0 Blob 0 0,First,#,County Parcels,SE_ANNO_CAD_DATA,-1,-1" #
FeatureClassToFeatureClass County_Parcels_1_24 "\\one\pdd\Shared\Information Systems\GIS\Logan\Data_Entry\Data_Entry.gdb" County_Parcels_JOINED # "PG_APN "PG_APN" true true false 12 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.PG_APN,0,12;PG_RETIRED "PG_RETIRED" true true false 1 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.PG_RETIRED,0,1;APN "APN" true true false 16 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.APN,0,16;PROP_CODE "PROP_CODE" true true false 6 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.PROP_CODE,0,6;ADDRESS "ADDRESS" true true false 96 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.ADDRESS,0,96;CITY "CITY" true true false 40 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.CITY,0,40;ZIP "ZIP" true true false 24 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.ZIP,0,24;FLOOR "FLOOR" true true false 2 Short 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.FLOOR,-1,-1;OWNER "OWNER" true true false 100 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.OWNER,0,100;OWN_ADDR "OWN_ADDR" true true false 150 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.OWN_ADDR,0,150;OWN_CITY "OWN_CITY" true true false 40 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.OWN_CITY,0,40;OWN_STATE "OWN_STATE" true true false 4 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.OWN_STATE,0,4;OWN_ZIP "OWN_ZIP" true true false 15 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.OWN_ZIP,0,15;GIS_CITY_OWNED "GIS_CITY_OWNED" true true false 2 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.GIS_CITY_OWNED,0,2;GIS_PROPERTY_USE "GIS_PROPERTY_USE" true true false 3 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.GIS_PROPERTY_USE,0,3;ASSESSOR_INFO "ASSESSOR_INFO" true true false 100 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.ASSESSOR_INFO,0,100;ASSESSOR_LOT_AREA "ASSESSOR_LOT_AREA" true true false 8 Double 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.ASSESSOR_LOT_AREA,-1,-1;STREET_NUM "STREET_NUM" true true false 6 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.STREET_NUM,0,6;STREET_DIR "STREET_DIR" true true false 2 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.STREET_DIR,0,2;STREET_NAME "STREET_NAME" true true false 40 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.STREET_NAME,0,40;STREET_TYPE "STREET_TYPE" true true false 12 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.STREET_TYPE,0,12;STREET_SUFFIX "STREET_SUFFIX" true true false 24 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.STREET_SUFFIX,0,24;STREET_POSTDIR "STREET_POSTDIR" true true false 4 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.STREET_POSTDIR,0,4;SUITE "SUITE" true true false 7 Text 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.SUITE,0,7;SE_ANNO_CAD_DATA "SE_ANNO_CAD_DATA" true true false 0 Blob 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.SE_ANNO_CAD_DATA,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,County_Parcels_1_24,County_Parcels_1_24.Shape_Area,-1,-1;OBJECTID "OBJECTID" false true false 4 Long 0 9,First,#,County_Parcels_1_24,Permit_Report_Export.OBJECTID,-1,-1;NAME "NAME" true true false 255 Text 0 0,First,#,County_Parcels_1_24,Permit_Report_Export.NAME,0,255;PER_NUM "PER_NUM" true true false 255 Text 0 0,First,#,County_Parcels_1_24,Permit_Report_Export.PER_NUM,0,255;ADDRESS "ADDRESS" true true false 255 Text 0 0,First,#,County_Parcels_1_24,Permit_Report_Export.ADDRESS,0,255;APN "APN" true true false 255 Text 0 0,First,#,County_Parcels_1_24,Permit_Report_Export.APN,0,255;VAL_FINAL_VALUE "VAL_FINAL_VALUE" true true false 8 Double 0 0,First,#,County_Parcels_1_24,Permit_Report_Export.VAL_FINAL_VALUE,-1,-1;VAL_UNITS "VAL_UNITS" true true false 4 Long 0 0,First,#,County_Parcels_1_24,Permit_Report_Export.VAL_UNITS,-1,-1;Source "Source" true true false 255 Text 0 0,First,#,County_Parcels_1_24,Permit_Report_Export.Source,0,255" #
FeatureClassToFeatureClass County_Parcels_JOINED "\\one\pdd\Shared\Information Systems\GIS\Logan\Data_Entry\Data_Entry.gdb" COUNTY_PARCEL_PERMIT_JOIN # "PARCEL_APN "PARCEL_APN" true true false 16 Text 0 0,First,#,County_Parcels_JOINED,APN,0,16;OBJECTID "OBJECTID" true true false 4 Long 0 0,First,#,County_Parcels_JOINED,OBJECTID,-1,-1;VILLAGE_NAME "VILLAGE_NAME" true true false 255 Text 0 0,First,#,County_Parcels_JOINED,NAME,0,255;PER_NUM "PER_NUM" true true false 255 Text 0 0,First,#,County_Parcels_JOINED,PER_NUM,0,255;PERMIT_ADDRESS "PERMIT_ADDRESS" true true false 255 Text 0 0,First,#,County_Parcels_JOINED,ADDRESS_1,0,255;PERMIT_APN "PERMIT_APN" true true false 16 Text 0 0,First,#,County_Parcels_JOINED,APN_1,0,255;VAL_FINAL_VALUE "VAL_FINAL_VALUE" true true false 8 Double 0 0,First,#,County_Parcels_JOINED,VAL_FINAL_VALUE,-1,-1;VAL_UNITS "VAL_UNITS" true true false 4 Long 0 0,First,#,County_Parcels_JOINED,VAL_UNITS,-1,-1;Source "Source" true true false 255 Text 0 0,First,#,County_Parcels_JOINED,Source,0,255;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,County_Parcels_JOINED,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,County_Parcels_JOINED,Shape_Area,-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=\\one\pdd\Shared\Information Systems\GIS\Logan\Data_Entry\Data_Entry.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>COUNTY_PARCEL_PERMIT_JOIN</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>Source</field_name><new_field_name>PERMIT_SOURCE</new_field_name><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>
FeatureToPoint COUNTY_PARCEL_PERMIT_JOIN "\\one\pdd\Shared\Information Systems\GIS\Logan\Data_Entry\Data_Entry.gdb\COUNTY_PARCEL_PERMIT_JOIN_FEATURE_TO_POINT" CENTROID
Append FINAL_MISSING_PERMITS "\\one\pdd\Shared\Information Systems\GIS\Logan\Data_Entry\Data_Entry.gdb\COUNTY_PARCEL_PERMIT_JOIN_FEATURE_TO_POINT" "Skip and warn if schema does not match" # # #
Append FINAL_MISSING_PERMITS_Geocoded "\\one\pdd\Shared\Information Systems\GIS\Logan\Data_Entry\Data_Entry.gdb\COUNTY_PARCEL_PERMIT_JOIN_FEATURE_TO_POINT" "Use the field map to reconcile field differences" "PARCEL_APN "PARCEL_APN" true true false 16 Text 0 0,First,#,FINAL_MISSING_PERMITS_Geocoded,USER_PARCEL_APN,0,16;OBJECTID "OBJECTID" true true false 4 Long 0 0,First,#,FINAL_MISSING_PERMITS_Geocoded,ObjectID,-1,-1;VILLAGE_NAME "VILLAGE_NAME" true true false 255 Text 0 0,First,#,FINAL_MISSING_PERMITS_Geocoded,USER_VILLAGE_NAME,0,255;PER_NUM "PER_NUM" true true false 255 Text 0 0,First,#,FINAL_MISSING_PERMITS_Geocoded,USER_PER_NUM,0,255;PERMIT_ADDRESS "PERMIT_ADDRESS" true true false 255 Text 0 0,First,#,FINAL_MISSING_PERMITS_Geocoded,USER_PERMIT_ADDRESS,0,255;PERMIT_APN "PERMIT_APN" true true false 16 Text 0 0,First,#,FINAL_MISSING_PERMITS_Geocoded,USER_PERMIT_APN,0,255;VAL_FINAL_VALUE "VAL_FINAL_VALUE" true true false 8 Double 0 0,First,#,FINAL_MISSING_PERMITS_Geocoded,USER_VAL_FINAL_VALUE,-1,-1;VAL_UNITS "VAL_UNITS" true true false 4 Long 0 0,First,#,FINAL_MISSING_PERMITS_Geocoded,USER_VAL_UNITS,-1,-1;PERMIT_SOURCE "PERMIT_SOURCE" true true false 255 Text 0 0,First,#,FINAL_MISSING_PERMITS_Geocoded,USER_PERMIT_SOURCE,0,255;ORIG_FID "ORIG_FID" true true false 4 Long 0 0,First,#,FINAL_MISSING_PERMITS_Geocoded,User_fld,0,120" # #
CopyMultiple "'\\one\pdd\Shared\Information Systems\GIS\Logan\Data_Entry\Data_Entry.gdb\COUNTY_PARCEL_PERMIT_JOIN_FEATURE_TO_POINT' FeatureClass" "S:\Information Systems\GIS\Projects\Annual_Reports\2022\Data\Data.gdb" COUNTY_PARCEL_PERMIT_JOIN_FEATURE_TO_POINT "COUNTY_PARCEL_PERMIT_JOIN_FEATURE_TO_POINT FeatureClass COUNTY_PARCEL_PERMIT_JOIN_FEATURE_TO_POINT #"
SpatialJoin COUNTY_PARCEL_PERMIT_JOIN_FEATURE_TO_POINT GISADM.VILLAGE "\\one\pdd\Shared\Information Systems\GIS\Logan\Data_Entry\Data_Entry.gdb\COUNTY_PARCEL_PERMIT_JOIN_finalfinal" "Join one to one" KEEP_ALL "PARCEL_APN "PARCEL_APN" true true false 16 Text 0 0,First,#,COUNTY_PARCEL_PERMIT_JOIN_FEATURE_TO_POINT,PARCEL_APN,0,16;OBJECTID "OBJECTID" true true false 4 Long 0 0,First,#,COUNTY_PARCEL_PERMIT_JOIN_FEATURE_TO_POINT,OBJECTID,-1,-1;VILLAGE_NAME "VILLAGE_NAME" true true false 255 Text 0 0,First,#,COUNTY_PARCEL_PERMIT_JOIN_FEATURE_TO_POINT,VILLAGE_NAME,0,255;PER_NUM "PER_NUM" true true false 255 Text 0 0,First,#,COUNTY_PARCEL_PERMIT_JOIN_FEATURE_TO_POINT,PER_NUM,0,255;PERMIT_ADDRESS "PERMIT_ADDRESS" true true false 255 Text 0 0,First,#,COUNTY_PARCEL_PERMIT_JOIN_FEATURE_TO_POINT,PERMIT_ADDRESS,0,255;PERMIT_APN "PERMIT_APN" true true false 16 Text 0 0,First,#,COUNTY_PARCEL_PERMIT_JOIN_FEATURE_TO_POINT,PERMIT_APN,0,16;VAL_FINAL_VALUE "VAL_FINAL_VALUE" true true false 8 Double 0 0,First,#,COUNTY_PARCEL_PERMIT_JOIN_FEATURE_TO_POINT,VAL_FINAL_VALUE,-1,-1;VAL_UNITS "VAL_UNITS" true true false 4 Long 0 0,First,#,COUNTY_PARCEL_PERMIT_JOIN_FEATURE_TO_POINT,VAL_UNITS,-1,-1;PERMIT_SOURCE "PERMIT_SOURCE" true true false 255 Text 0 0,First,#,COUNTY_PARCEL_PERMIT_JOIN_FEATURE_TO_POINT,PERMIT_SOURCE,0,255;ORIG_FID "ORIG_FID" true true false 4 Long 0 0,First,#,COUNTY_PARCEL_PERMIT_JOIN_FEATURE_TO_POINT,ORIG_FID,-1,-1;NAME "NAME" true true false 30 Text 0 0,First,#,GISADM.VILLAGE,NAME,0,30;ACRES "ACRES" true true false 8 Double 8 19,First,#,GISADM.VILLAGE,ACRES,-1,-1;SE_ANNO_CAD_DATA "SE_ANNO_CAD_DATA" true true false 0 Blob 0 0,First,#,GISADM.VILLAGE,SE_ANNO_CAD_DATA,-1,-1;INSERT_DATE "INSERT_DATE" true true false 8 Date 0 0,First,#,GISADM.VILLAGE,INSERT_DATE,-1,-1;UPDATE_DATE "UPDATE_DATE" true true false 8 Date 0 0,First,#,GISADM.VILLAGE,UPDATE_DATE,-1,-1;ANID "ANID" true true false 4 Long 0 10,First,#,GISADM.VILLAGE,ANID,-1,-1;URL "URL" true true false 255 Text 0 0,First,#,GISADM.VILLAGE,URL,0,255" Intersect # #
CalculateField COUNTY_PARCEL_PERMIT_JOIN_finalfinal VILLAGE_NAME !NAME! "Python 3" # Text NO_ENFORCE_DOMAINS
FeatureClassToFeatureClass COUNTY_PARCEL_PERMIT_JOIN_finalfinal "\\one\pdd\Shared\Information Systems\GIS\Logan\Data_Entry\Data_Entry.gdb" ANNUAL_REPORT_PERMITS_2022 # "OBJECTID "OBJECTID" true true false 4 Long 0 0,First,#,COUNTY_PARCEL_PERMIT_JOIN_finalfinal,OBJECTID,-1,-1;VILLAGE_NAME "VILLAGE_NAME" true true false 255 Text 0 0,First,#,COUNTY_PARCEL_PERMIT_JOIN_finalfinal,VILLAGE_NAME,0,255;PER_NUM "PER_NUM" true true false 255 Text 0 0,First,#,COUNTY_PARCEL_PERMIT_JOIN_finalfinal,PER_NUM,0,255;PERMIT_ADDRESS "PERMIT_ADDRESS" true true false 255 Text 0 0,First,#,COUNTY_PARCEL_PERMIT_JOIN_finalfinal,PERMIT_ADDRESS,0,255;PERMIT_APN "PERMIT_APN" true true false 16 Text 0 0,First,#,COUNTY_PARCEL_PERMIT_JOIN_finalfinal,PERMIT_APN,0,16;VAL_FINAL_VALUE "VAL_FINAL_VALUE" true true false 8 Double 0 0,First,#,COUNTY_PARCEL_PERMIT_JOIN_finalfinal,VAL_FINAL_VALUE,-1,-1;VAL_UNITS "VAL_UNITS" true true false 4 Long 0 0,First,#,COUNTY_PARCEL_PERMIT_JOIN_finalfinal,VAL_UNITS,-1,-1;PERMIT_SOURCE "PERMIT_SOURCE" true true false 255 Text 0 0,First,#,COUNTY_PARCEL_PERMIT_JOIN_finalfinal,PERMIT_SOURCE,0,255" #
Append FINAL_MISSING_PERMITS_Geocoded "\\one\pdd\Shared\Information Systems\GIS\Logan\Data_Entry\Data_Entry.gdb\ANNUAL_REPORT_PERMITS_2022" "Use the field map to reconcile field differences" "OBJECTID "OBJECTID" true true false 4 Long 0 0,First,#;VILLAGE_NAME "VILLAGE_NAME" true true false 255 Text 0 0,First,#,FINAL_MISSING_PERMITS_Geocoded,USER_VILLAGE_NAME,0,255;PER_NUM "PER_NUM" true true false 255 Text 0 0,First,#,FINAL_MISSING_PERMITS_Geocoded,USER_PER_NUM,0,255;PERMIT_ADDRESS "PERMIT_ADDRESS" true true false 255 Text 0 0,First,#,FINAL_MISSING_PERMITS_Geocoded,USER_PERMIT_ADDRESS,0,255;PERMIT_APN "PERMIT_APN" true true false 16 Text 0 0,First,#,FINAL_MISSING_PERMITS_Geocoded,USER_PERMIT_APN,0,255;VAL_FINAL_VALUE "VAL_FINAL_VALUE" true true false 8 Double 0 0,First,#,FINAL_MISSING_PERMITS_Geocoded,USER_VAL_FINAL_VALUE,-1,-1;VAL_UNITS "VAL_UNITS" true true false 4 Long 0 0,First,#,FINAL_MISSING_PERMITS_Geocoded,USER_VAL_UNITS,-1,-1;PERMIT_SOURCE "PERMIT_SOURCE" true true false 255 Text 0 0,First,#,FINAL_MISSING_PERMITS_Geocoded,USER_PERMIT_SOURCE,0,255" # #
FeatureClassToFeatureClass ANNUAL_REPORT_PERMITS_2022 "S:\Information Systems\GIS\Projects\Annual_Reports\2022\Data\Data.gdb" Annual_Report_Permits_2022 # "OBJECTID "OBJECTID" true true false 4 Long 0 0,First,#,ANNUAL_REPORT_PERMITS_2022,OBJECTID,-1,-1;VILLAGE_NAME "VILLAGE_NAME" true true false 255 Text 0 0,First,#,ANNUAL_REPORT_PERMITS_2022,VILLAGE_NAME,0,255;PER_NUM "PER_NUM" true true false 255 Text 0 0,First,#,ANNUAL_REPORT_PERMITS_2022,PER_NUM,0,255;PERMIT_ADDRESS "PERMIT_ADDRESS" true true false 255 Text 0 0,First,#,ANNUAL_REPORT_PERMITS_2022,PERMIT_ADDRESS,0,255;PERMIT_APN "PERMIT_APN" true true false 16 Text 0 0,First,#,ANNUAL_REPORT_PERMITS_2022,PERMIT_APN,0,16;VAL_FINAL_VALUE "VAL_FINAL_VALUE" true true false 8 Double 0 0,First,#,ANNUAL_REPORT_PERMITS_2022,VAL_FINAL_VALUE,-1,-1;VAL_UNITS "VAL_UNITS" true true false 4 Long 0 0,First,#,ANNUAL_REPORT_PERMITS_2022,VAL_UNITS,-1,-1;PERMIT_SOURCE "PERMIT_SOURCE" true true false 255 Text 0 0,First,#,ANNUAL_REPORT_PERMITS_2022,PERMIT_SOURCE,0,255" #
FeatureClassToFeatureClass Annual_Report_Permits_2022 C:\Users\072785\AppData\Roaming\Esri\Desktop10.4\ArcCatalog\DGIP_DSDSPA.sde Permits_2022_Annual_Report # "OBJECTID "OBJECTID" true true false 4 Long 0 0,First,#,Annual_Report_Permits_2022,OBJECTID,-1,-1;NAME "NAME" true true false 255 Text 0 0,First,#,Annual_Report_Permits_2022,VILLAGE_NAME,0,255;PER_NUM "PER_NUM" true true false 255 Text 0 0,First,#,Annual_Report_Permits_2022,PER_NUM,0,255;PERMIT_ADDRESS "PERMIT_ADDRESS" true true false 255 Text 0 0,First,#,Annual_Report_Permits_2022,PERMIT_ADDRESS,0,255;APN "APN" true true false 16 Text 0 0,First,#,Annual_Report_Permits_2022,PERMIT_APN,0,16;VALUE "VALUE" true true false 8 Double 0 0,First,#,Annual_Report_Permits_2022,VAL_FINAL_VALUE,-1,-1;VAL_UNITS "VAL_UNITS" true true false 4 Long 0 0,First,#,Annual_Report_Permits_2022,VAL_UNITS,-1,-1;PERMIT_SOURCE "PERMIT_SOURCE" true true false 255 Text 0 0,First,#,Annual_Report_Permits_2022,PERMIT_SOURCE,0,255" #
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>ENCRYPTED_PASSWORD=00022e684c584d58694f697775713568616134614a42454c66513d3d2a00;SERVER=sde;INSTANCE=sde:oracle$sde:oracle11g:DGIP;DBCLIENT=oracle;DB_CONNECTION_PROPERTIES=DGIP;PROJECT_INSTANCE=sde;USER=DSDSPA;VERSION=SDE.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DSDSPA.Permits_2022_Annual_Report</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><RegisterAsVersioned><edit_to_base>TRUE</edit_to_base></RegisterAsVersioned></workflow></operationSequence>
DSDSPA.Permits_2022_Annual_Report
002
Server=sde; Service=sde:oracle$sde:oracle11g:DGIP; User=DSDSPA; Version=SDE.DEFAULT
ArcSDE Connection
Projected
GCS_North_American_1983_HARN
Linear Unit: Foot (0.304800)
NAD_1983_HARN_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/2.9.0'><WKT>PROJCS["NAD_1983_HARN_StatePlane_Arizona_Central_FIPS_0202_Feet_Intl",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",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",2868]]</WKT><XOrigin>-17746700</XOrigin><YOrigin>-44067300</YOrigin><XYScale>3048</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.00065616797900262499</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2868</WKID><LatestWKID>2868</LatestWKID></ProjectedCoordinateSystem>
20230126
10053100
20230126
10053100
Microsoft Windows 10 Version 10.0 (Build 19042) ; Esri ArcGIS 12.9.4.32739
Permits_2022_Annual_Report
PDD
2022 Building Permit Information
Enterprise Geodatabase Feature Class
dataset
EPSG
6.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
DSDSPA.Permits_2022_Annual_Report
Feature Class
0
OBJECTID_1
OBJECTID_1
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
OBJECTID
OBJECTID
Integer
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
NAME
NAME
String
255
0
0
Shape
SHAPE
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
PER_NUM
PER_NUM
String
255
0
0
APN
APN
String
16
0
0
VALUE
VALUE
Double
8
38
8
PERMIT_ADDRESS
PERMIT_ADDRESS
String
255
0
0
VAL_UNITS
VAL_UNITS
Integer
4
10
0
PERMIT_SOURCE
PERMIT_SOURCE
String
255
0
0
20230126
/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
ooAKKKKACiiigAooqhrGs2Og2BvNQm8qHcEGBksx6AAdTTSbdkNJt2RforM0XxBpuvwPLp1x5gjO
11KlWU+4PStOhpp2YNNOzCiiikIKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACsfxNo39uaO1sqoZkdZYi/QMP/1mtiq1/qNnpdq1
zfXMVvAvBeRsCqjJxkpLdFRbTTW5heE/DJ0R7y9nZjd3hBkUsCFA+ldNXmfiXxjqgu3utFvYjp8U
atGY0EgmbOCD6DPFej20jzWsMsi7HdAzLnOCRyKqqpN80uppVjLScupLRVLVtTt9G0ufULnd5UK7
iFGSfYVk+HPF9tr88ts1rNZXcYD+RPjLoejDHWs7dTNRbV+h0dFFFBIUUUUAFFFFABRRRQAUUUUA
FFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQA2SSOGNpJXVI1GWZjg
Ae5rzXxdZ3fiTVoL7Rfs+sWcUWxUiu02wS5++wzg8V0fxFjeTwHqgSQIVjDEk4yAQSPxryfwZZXM
NhrqStPbSXdl5EXykD5gSGJ+g/WtKTkpKUTpoxtF1E9UJf6NLai5063vYbxrpGeZkiZY1kXBKI3Q
16x8OY76LwLpyagsizBWwsnULuO39K8ts4I0eDQykKBR5qzxzbWJBxxnoSa663+Kq6XYyW+u2Lrq
MSDYIhhZu3U9DXoYxT5FDe3X1OjEqTiorWx03j2S7Tw+q2qwv5kyLJHKR8655Az3riPCunm/8bW+
q2xkby2ZZE3DEagEYP4/nWtqeujxt4d1Gztrae11iwCXKQo4cnuCCOvB6VF8KZtTuLrUpr2x8mNl
RfNMRQlh2561yxnCFKUJL3jKnaNGV9z06iiiuU4wooooAKKKKACiiigAooooAKKKKACiiigAoooo
AKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigDO17SIte0S60yZ2jS4TbvXqp6g/nXnP8A
wh9p4QtHa/ub6/knBO23bYNqjOB1OfpivV64jx5LGZ7O23SRSPHIRMnOzoOn49a6cPOV/Z30ZvQn
K/J0ZxtuvnXjXyWy2NoE2RqwDtCgGclj1zk5FY+p6XFf3f8AaN4Z7mNIUZIlxh8noPbA6+9dDPL5
aQqBlHG3fMT8uO57EVXkXy5DcXEEmJz5LFCCsYzgYUfmMc13RitnsdcdCLTdVh8Iz3moW9onmahE
rRRxx7GQDGfl9KyvE2p6uduq2+sao7CQEwrI6rET044+nNa2qWf264t1R4t9riRpCoy3HTAq3Pax
3FsgliPlZL7PMIIIwQW7HntinCMKb9pa7fdFRcIWna7PRfC3iG28QaWHidzcQBUuEkTayvjuPety
vNvhpJMPEHiOKQb1YwyiXGOoYbfwxXpNeXVhyTcTz6sOSbQUUUVmZhRRRQAUUUUAFFFFABRRRQAU
UUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUVzmp+ONE0rUvsM08jyrjzTEhdYc
9N5HSmk3sOMXLZHR157400DUL3Xheskk2mG18p9k5jMPIJJAPIOK9AR1kRXRgysMgjuK5zx5qv8A
ZPhO5lQ5llKxRp/fJPI9uM804O0ky6TakrHBCzxbiKB1jIJx5jecMDPUnB/XrUN5G9zHY2oSeNh+
/nuo3EaZH3eAMg5NT2F008Anurd4ZCm8xeWfkAPvgHirEjyCDdIy8BSwZd2/vjjNeo3Y7HLlZF9q
AgRgyRIxG9ncAg9DkEc0y4nIVzbbTJIhZF3Es2D90ZPHBHFYd/bT3ZuWeZ2hG2SNv4llC52kHqBi
tr4cajpC6nc3WuXuzWGAVY7mJY0QZ/gPcn6CoqSUI3Y3FKHMeg+EdEfS7Oa6uECXt6VkmUdFwOF/
U/nXRUgIZQykEHkEUtebKTk7s8+UnJ3YUUUUhBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAU
UUUAFFFFABRRRQAUUUUAFFFFABRRRQBHPGZreWJXKF0Khh1XI6143qmmrosV9DqduybyITLFDIRM
OcNu6En09a9oryH4j+LrNtft7CA3C3OnyHc6qGVmYD5dpIz9c+tdGGqOMuXudGHcua0UV9I1N7nS
IreG8ukjtSI4zO5VvyHUUviCa7utPs4zM88UV0sjJIxKj6n29B61kaVca7Nfu2oW0iQspeJSofGT
g8Z56fpW46yJtjggJckFgIskD1IzxzgfjXpKKjJNI7Lcsk0AEUjQgsG3IcHBKv6gN646VKwZSIUW
RVHyqzdcjrjGT3pkMnkCFMhdiM5Bb+EZzxjJxx0qZmfCBo2k65IXj6gkc/hWUl0MZX2EeFZJiXUB
8ja2/Jbr83saztUsbWO0ury4ijW6aNlMhG/cAAQfY81ai1CCNZPOuIY/s/EjykAqw7HpjnNZSahZ
XeqWJgvVvJZDtWyMe9ZMkcdflP1qopxZcYyTPWvB8U0Pg/SY5y/mi2Tdv69K26ZEMRINoTCj5R29
qfXkt3dzz27u4UUUUhBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUU
AFFFFABRRRQAV4t4008wazf3OrW9wsct2JIWigzGygAKS45BxnOe4r2mkZQylWAIPBB71pSqOnLm
SNKVR05XR4Dq2uwR2t1HYRSTusRVZkXIRSQSSfxxn3rMsPFUy2Fva28Ul3PkLh8lVfPy89+e3SvY
vGfh43WnQvptkhaMlJUiUAtCeSAOh5wfzryZ5LiDSy9mtrZaed0LymL542UkjKjgHIxx616VKo6s
LX36dTvp1FOL8zQttNuzqsV1I8cV21uwbbFwGzjDDvxnpUqQXNtbNcaldyTNI6ZaEZ8okjAAHrxW
JaeI9PivWvTfTyu20FBFtRBjsOe/55re0fW4L4QJa29zLcM7KESLAlJP0wO30repKUUm+xpU5opS
ZdMEdyQZUWaZvlfcnMfHPy8e/Nafwr0yE6jrN+tnbpFHKtvC6/P8yg7irHnByPzrJnttZFzKZNNh
sJVZSPPnDNJ/uqDye+a6/wAC3hOoX9kqgqIo55HAA/eHIOcDqQAa469qlLmj0Oeq7024ncUUUV5x
wBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUA
FFFFABXKX3w90O/1v+05hcAFxJJapIBDI46My46/jzXV0EZGDVRlKOzGpOOx5ve678O77X3jvbSF
rm2JAlaIhGI7ccN+IrJ1zV9FjuYR4eu305QrtPHAvlMvT7qkcE+3Wty4+EWj3Go3V2Ly7QykvGik
YjcnOenPParOm/C7SLa7jvdQuLjULtGDb3OxTjplR6fWtaMqcW3O/wAv1OyM6Mdbt+R5p4XuGklv
nN5I1q0v7uSWQCUnsTn2zzXbeBLwL4xu7e3KPDPaq0gXkxFScAnvndV6++EHh24gZLR7q0lL7hIr
78D+7g9q1fBngW18HrcNHdSXU8+A0jqFwo7Ac1U60fZ8kRTrRlB9zq6KKK5jjCiiigAooooAKKKK
ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA
KKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAo
oooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii
igAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKK
ACiiigAooooAKKKKACiiigD/2Q==