20170405
14311000
1.0
FGDC CSDGM Metadata
FALSE
AddField T:\GIS\911_SAM\Documents\Templates\SAM_DeliverySchema_v2.gdb\SAM_DeliverySchema PrimaryPoint TEXT # # 3 # NULLABLE REQUIRED #
Sort AddressPoints T:\GIS\911_SAM\Deliveries\Oneida\Final\SAM_DeliverySchema_v5.gdb\AddressPoints_Sort "SHAPE ASCENDING;ZipCode ASCENDING" PEANO
CalculateField Contractor_Delivered_Data\FullDelivery FullAddr "[PrefixAddressNumber] & " " & [AddressNumber] & " " & [SuffixAddressNumber] & " " & [CompleteStreetName] & " " & [SubAddress] & " " & [ZipCode]" VB #
CalculateField AddressPoints FullAddr Trim( [FullAddr]) VB #
CalculateField AddressPoints ZipCode 13489 VB #
CalculateField AddressPoints ZipName "West Leyden" VB #
CalculateField AddressPoints DateUpdate "7/19/2017" VB #
CalculateField AddressPoints AddressSou "911AA" VB #
CalculateField AddressPoints ATT_EDIT "JQ" VB #
CalculateField AddressPoints COMMENT "zip change" VB #
CalculateField AddressPoints StreetName "Old State Route 12" VB #
CalculateField AddressPoints CompleteSt "Old State Route 12" VB #
CalculateField AddressPoints AddressSou "911AA" VB #
CalculateField AddressPoints DateUpdate "7/25/17" VB #
CalculateField AddressPoints NYSStreetI 0 VB #
CalculateField AddressPoints StreetName Sheehan VB #
CalculateField AddressPoints StreetName "Sheehan" VB #
CalculateField AddressPoints AddressSou "E911" VB #
CalculateField AddressPoints DateUpdate "9/11/2018" VB #
CalculateField AddressPoints CompleteSt "Sheehan Rd" VB #
CalculateField AddressPoints ATT_EDIT "JDQ" VB #
CalculateField AddressPoints COMMENT "Yorkland to Sheehan" VB #
CalculateField ocdata.GISADMIN.OC_SAM_911 StreetName "Gracies" VB #
CalculateField ocdata.GISADMIN.OC_SAM_911 CompleteSt "Gracies Pl" VB #
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipName "Boonville" VB #
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipCode "13309" VB #
CalculateField ocdata.GISADMIN.OC_SAM_911 AddressSou "911AA" VB #
CalculateField ocdata.GISADMIN.OC_SAM_911 SP_EDIT " " VB #
CalculateField ocdata.GISADMIN.OC_SAM_911 ATT_EDIT "JMW" VB #
CalculateField ocdata.GISADMIN.OC_SAM_911 COMMENT " " VB #
CalculateField ocdata.GISADMIN.OC_SAM_911 DateUpdate "Date ( )" VB #
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipCode "13321" VB #
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipName "Clark Mills" VB #
CalculateField ocdata.GISADMIN.OC_SAM_911 DateUpdate time.strftime('%m/%d/%Y') "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 ATT_EDIT "JMW" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 SP_EDIT " " "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 CompleteSt "Angelia Dr" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 StreetName "Alder Creek" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 CompleteSt "Alder Creek Rd" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 AddressSou "911AA" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 ATT_EDIT "JMW" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 DateUpdate "9/16/2020" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipName "Alder Creek" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipCode "13301" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 ATT_EDIT "JMW" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 DateUpdate "12/4/2020" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 AddressSou "911AA" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipCode "13502" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipCode "Utica" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipCode "13502" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipName "Utica" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipName "Utica" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipCode "13502" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipName "Chadwicks" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipCode "13319" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipName "Utica" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipCode "13502" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipCode '13502' "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipName 'Utica' "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 PostType "St" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 AddressSou "911AA" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 DateUpdate "3/12/2021" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 CompleteSt "Dexter St" "Python 3" # Text
CalculateField ocdata.GISADMIN.OC_SAM_911 ATT_EDIT "JMW" "Python 3" # Text
FeatureClassToFeatureClass ocdata.GISADMIN.OC_SAM_911 C:\ARCGIS_PRO\DATA\SAM OC_SAM_911.shp # "NYSAddress "NYSAddress" true true false 10 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,NYSAddress,0,10;CountyID "CountyID" true true false 40 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,CountyID,0,40;NYSStreetI "NYSStreetI" true true false 4 Long 0 10,First,#,ocdata.GISADMIN.OC_SAM_911,NYSStreetI,-1,-1;PrefixAddr "PrefixAddr" true true false 10 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PrefixAddr,0,10;AddressNum "AddressNum" true true false 4 Long 0 10,First,#,ocdata.GISADMIN.OC_SAM_911,AddressNum,-1,-1;SuffixAddr "SuffixAddr" true true false 10 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,SuffixAddr,0,10;PreModifie "PreModifie" true true false 25 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PreModifie,0,25;PreDirecti "PreDirecti" true true false 10 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PreDirecti,0,10;PreType "PreType" true true false 20 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PreType,0,20;SeparatorE "SeparatorE" true true false 10 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,SeparatorE,0,10;StreetName "StreetName" true true false 40 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,StreetName,0,40;PostType "PostType" true true false 20 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PostType,0,20;PostDirect "PostDirect" true true false 10 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PostDirect,0,10;PostModifi "PostModifi" true true false 25 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PostModifi,0,25;SubAddress "SubAddress" true true false 200 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,SubAddress,0,200;LandmarkNa "LandmarkNa" true true false 60 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,LandmarkNa,0,60;Building "Building" true true false 40 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,Building,0,40;Floor "Floor" true true false 40 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,Floor,0,40;Unit "Unit" true true false 40 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,Unit,0,40;Room "Room" true true false 40 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,Room,0,40;Seat "Seat" true true false 40 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,Seat,0,40;Location "Location" true true false 40 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,Location,0,40;ZipName "ZipName" true true false 30 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,ZipName,0,30;State "State" true true false 2 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,State,0,2;ZipCode "ZipCode" true true false 5 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,ZipCode,0,5;PointType "PointType" true true false 3 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PointType,0,3;AddressSou "AddressSou" true true false 30 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,AddressSou,0,30;SourceOfDa "SourceOfDa" true true false 30 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,SourceOfDa,0,30;DateUpdate "DateUpdate" true true false 8 Date 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,DateUpdate,-1,-1;PrimaryPoi "PrimaryPoi" true true false 3 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PrimaryPoi,0,3;CityTownNa "CityTownNa" true true false 30 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,CityTownNa,0,30;PlaceName "PlaceName" true true false 30 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PlaceName,0,30;PlaceType "PlaceType" true true false 75 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PlaceType,0,75;CompleteSt "CompleteSt" true true false 68 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,CompleteSt,0,68;AP_Flag "AP_Flag" true true false 20 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,AP_Flag,0,20;SP_EDIT "SP_EDIT" true true false 10 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,SP_EDIT,0,10;ATT_EDIT "ATT_EDIT" true true false 10 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,ATT_EDIT,0,10;COMMENT "COMMENT" true true false 50 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,COMMENT,0,50" #
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.8.0'><WorkspaceConnectionString>DATABASE=C:\ARCGIS_PRO\DATA\SAM</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>OC_SAM_911</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>GLOBAL_ID</field_name><field_type>LONG</field_type><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>ASSETNME</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField OC_SAM_911 GLOBAL_ID !FID! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField OC_SAM_911 ASSETNME "$feature.NYSAddress+ " "+$feature.CompleteSt+"-"+$feature.GLOBAL_ID" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField OC_SAM_911 ASSETNME "$feature.AddressNum +" "+$feature.CompleteSt+"-"+$feature.GLOBAL_ID" Arcade # Text NO_ENFORCE_DOMAINS
FeatureClassToFeatureClass C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp "Database Connections\GISADMIN2.sde\ocdata.GISADMIN.E911" OC_SAM_911 # "NYSAddress "NYSAddress" true true false 10 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,NYSAddress,-1,-1;CountyID "CountyID" true true false 40 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,CountyID,-1,-1;NYSStreetI "NYSStreetI" true true false 10 Long 0 10 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,NYSStreetI,-1,-1;PrefixAddr "PrefixAddr" true true false 10 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,PrefixAddr,-1,-1;AddressNum "AddressNum" true true false 10 Long 0 10 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,AddressNum,-1,-1;SuffixAddr "SuffixAddr" true true false 10 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,SuffixAddr,-1,-1;PreModifie "PreModifie" true true false 25 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,PreModifie,-1,-1;PreDirecti "PreDirecti" true true false 10 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,PreDirecti,-1,-1;PreType "PreType" true true false 20 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,PreType,-1,-1;SeparatorE "SeparatorE" true true false 10 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,SeparatorE,-1,-1;StreetName "StreetName" true true false 40 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,StreetName,-1,-1;PostType "PostType" true true false 20 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,PostType,-1,-1;PostDirect "PostDirect" true true false 10 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,PostDirect,-1,-1;PostModifi "PostModifi" true true false 25 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,PostModifi,-1,-1;SubAddress "SubAddress" true true false 200 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,SubAddress,-1,-1;LandmarkNa "LandmarkNa" true true false 60 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,LandmarkNa,-1,-1;Building "Building" true true false 40 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,Building,-1,-1;Floor "Floor" true true false 40 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,Floor,-1,-1;Unit "Unit" true true false 40 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,Unit,-1,-1;Room "Room" true true false 40 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,Room,-1,-1;Seat "Seat" true true false 40 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,Seat,-1,-1;Location "Location" true true false 40 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,Location,-1,-1;ZipName "ZipName" true true false 30 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,ZipName,-1,-1;State "State" true true false 2 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,State,-1,-1;ZipCode "ZipCode" true true false 5 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,ZipCode,-1,-1;PointType "PointType" true true false 3 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,PointType,-1,-1;AddressSou "AddressSou" true true false 30 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,AddressSou,-1,-1;SourceOfDa "SourceOfDa" true true false 30 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,SourceOfDa,-1,-1;DateUpdate "DateUpdate" true true false 8 Date 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,DateUpdate,-1,-1;PrimaryPoi "PrimaryPoi" true true false 3 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,PrimaryPoi,-1,-1;CityTownNa "CityTownNa" true true false 30 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,CityTownNa,-1,-1;PlaceName "PlaceName" true true false 30 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,PlaceName,-1,-1;PlaceType "PlaceType" true true false 75 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,PlaceType,-1,-1;CompleteSt "CompleteSt" true true false 68 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,CompleteSt,-1,-1;AP_Flag "AP_Flag" true true false 20 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,AP_Flag,-1,-1;SP_EDIT "SP_EDIT" true true false 10 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,SP_EDIT,-1,-1;ATT_EDIT "ATT_EDIT" true true false 10 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,ATT_EDIT,-1,-1;COMMENT "COMMENT" true true false 50 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,COMMENT,-1,-1;GLOBAL_ID "GLOBAL_ID" true true false 10 Long 0 10 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,GLOBAL_ID,-1,-1;ASSETNME "ASSETNME" true true false 254 Text 0 0 ,First,#,C:\ARCGIS_PRO\DATA\SAM\OC_SAM_911.shp,ASSETNME,-1,-1" #
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipName "Barneveld" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipCode "13304" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911 ATT_EDIT "JMW" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911 DateUpdate "9/9/2021" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911 AddressSou "911AA" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911 AddressNum "1000" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911 DateUpdate "10/27/2021" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911 ATT_EDIT "JMW" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911 SP_EDIT " " "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipName "Sylvan Beach" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911 ZipCode "13157" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911 AddressSou "911AA" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911 DateUpdate "10/29/2021" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911 ATT_EDIT "JMW" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911 AddressNum "750" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911 GLOBAL_ID " " "Python 3" # Text NO_ENFORCE_DOMAINS
FeatureClassToFeatureClass ocdata.GISADMIN.OC_SAM_911 C:\ArcGIS_PRO\PROJECTS\ADDRESSING\E911_Addressing_Pro\E911_Addressing_Pro.gdb SAM_911_2022 # "NYSAddress "NYSAddress" true true false 10 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,NYSAddress,0,10;CountyID "CountyID" true true false 40 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,CountyID,0,40;NYSStreetI "NYSStreetI" true true false 4 Long 0 10,First,#,ocdata.GISADMIN.OC_SAM_911,NYSStreetI,-1,-1;PrefixAddr "PrefixAddr" true true false 10 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PrefixAddr,0,10;AddressNum "AddressNum" true true false 4 Long 0 10,First,#,ocdata.GISADMIN.OC_SAM_911,AddressNum,-1,-1;SuffixAddr "SuffixAddr" true true false 10 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,SuffixAddr,0,10;PreModifie "PreModifie" true true false 25 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PreModifie,0,25;PreDirecti "PreDirecti" true true false 10 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PreDirecti,0,10;PreType "PreType" true true false 20 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PreType,0,20;SeparatorE "SeparatorE" true true false 10 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,SeparatorE,0,10;StreetName "StreetName" true true false 40 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,StreetName,0,40;PostType "PostType" true true false 20 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PostType,0,20;PostDirect "PostDirect" true true false 10 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PostDirect,0,10;PostModifi "PostModifi" true true false 25 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PostModifi,0,25;SubAddress "SubAddress" true true false 200 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,SubAddress,0,200;LandmarkNa "LandmarkNa" true true false 60 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,LandmarkNa,0,60;Building "Building" true true false 40 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,Building,0,40;Floor "Floor" true true false 40 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,Floor,0,40;Unit "Unit" true true false 40 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,Unit,0,40;Room "Room" true true false 40 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,Room,0,40;Seat "Seat" true true false 40 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,Seat,0,40;Location "Location" true true false 40 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,Location,0,40;ZipName "ZipName" true true false 30 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,ZipName,0,30;State "State" true true false 2 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,State,0,2;ZipCode "ZipCode" true true false 5 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,ZipCode,0,5;PointType "PointType" true true false 3 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PointType,0,3;AddressSou "AddressSou" true true false 30 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,AddressSou,0,30;SourceOfDa "SourceOfDa" true true false 30 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,SourceOfDa,0,30;DateUpdate "DateUpdate" true true false 8 Date 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,DateUpdate,-1,-1;PrimaryPoi "PrimaryPoi" true true false 3 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PrimaryPoi,0,3;CityTownNa "CityTownNa" true true false 30 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,CityTownNa,0,30;PlaceName "PlaceName" true true false 30 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PlaceName,0,30;PlaceType "PlaceType" true true false 75 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,PlaceType,0,75;CompleteSt "CompleteSt" true true false 68 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,CompleteSt,0,68;AP_Flag "AP_Flag" true true false 20 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,AP_Flag,0,20;SP_EDIT "SP_EDIT" true true false 10 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,SP_EDIT,0,10;ATT_EDIT "ATT_EDIT" true true false 10 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,ATT_EDIT,0,10;COMMENT "COMMENT" true true false 50 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,COMMENT,0,50;GLOBAL_ID "GLOBAL_ID" true true false 4 Long 0 10,First,#,ocdata.GISADMIN.OC_SAM_911,GLOBAL_ID,-1,-1;ASSETNME "ASSETNME" true true false 254 Text 0 0,First,#,ocdata.GISADMIN.OC_SAM_911,ASSETNME,0,254" #
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:\ArcGIS_PRO\PROJECTS\ADDRESSING\E911_Addressing_Pro\E911_Addressing_Pro.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SAM_911_2022</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>SITE</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>SITE</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>STRUCTURE</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>STRUCTURE</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>SUBSITE</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>SUBSITE</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>BUSINESSNAME</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>BUSINESSNAME</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField SAM_911_2022 SITE !LandmarkNa! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField SAM_911_2022 STRUCTURE !Building! "Python 3" # Text NO_ENFORCE_DOMAINS
DeleteField SAM_911_2022 LandmarkNa "Delete Fields"
DeleteField SAM_911_2022 Building "Delete Fields"
FeatureClassToFeatureClass SAM_911_2022 C:\Users\jwebb\AppData\Roaming\Esri\ArcGISPro\Favorites\ocwpc02.sde\ocdata.GISADMIN.E911 ocdata_GISADMIN_OC_SAM_911_2022 # "NYSAddress "NYSAddress" true true false 10 Text 0 0,First,#,SAM_911_2022,NYSAddress,0,10;CountyID "CountyID" true true false 40 Text 0 0,First,#,SAM_911_2022,CountyID,0,40;NYSStreetI "NYSStreetI" true true false 4 Long 0 0,First,#,SAM_911_2022,NYSStreetI,-1,-1;PrefixAddr "PrefixAddr" true true false 10 Text 0 0,First,#,SAM_911_2022,PrefixAddr,0,10;AddressNum "AddressNum" true true false 4 Long 0 0,First,#,SAM_911_2022,AddressNum,-1,-1;SuffixAddr "SuffixAddr" true true false 10 Text 0 0,First,#,SAM_911_2022,SuffixAddr,0,10;PreModifie "PreModifie" true true false 25 Text 0 0,First,#,SAM_911_2022,PreModifie,0,25;PreDirecti "PreDirecti" true true false 10 Text 0 0,First,#,SAM_911_2022,PreDirecti,0,10;PreType "PreType" true true false 20 Text 0 0,First,#,SAM_911_2022,PreType,0,20;SeparatorE "SeparatorE" true true false 10 Text 0 0,First,#,SAM_911_2022,SeparatorE,0,10;StreetName "StreetName" true true false 40 Text 0 0,First,#,SAM_911_2022,StreetName,0,40;PostType "PostType" true true false 20 Text 0 0,First,#,SAM_911_2022,PostType,0,20;PostDirect "PostDirect" true true false 10 Text 0 0,First,#,SAM_911_2022,PostDirect,0,10;PostModifi "PostModifi" true true false 25 Text 0 0,First,#,SAM_911_2022,PostModifi,0,25;SubAddress "SubAddress" true true false 200 Text 0 0,First,#,SAM_911_2022,SubAddress,0,200;Floor "Floor" true true false 40 Text 0 0,First,#,SAM_911_2022,Floor,0,40;Unit "Unit" true true false 40 Text 0 0,First,#,SAM_911_2022,Unit,0,40;Room "Room" true true false 40 Text 0 0,First,#,SAM_911_2022,Room,0,40;Seat "Seat" true true false 40 Text 0 0,First,#,SAM_911_2022,Seat,0,40;Location "Location" true true false 40 Text 0 0,First,#,SAM_911_2022,Location,0,40;ZipName "ZipName" true true false 30 Text 0 0,First,#,SAM_911_2022,ZipName,0,30;State "State" true true false 2 Text 0 0,First,#,SAM_911_2022,State,0,2;ZipCode "ZipCode" true true false 5 Text 0 0,First,#,SAM_911_2022,ZipCode,0,5;PointType "PointType" true true false 3 Text 0 0,First,#,SAM_911_2022,PointType,0,3;AddressSou "AddressSou" true true false 30 Text 0 0,First,#,SAM_911_2022,AddressSou,0,30;SourceOfDa "SourceOfDa" true true false 30 Text 0 0,First,#,SAM_911_2022,SourceOfDa,0,30;DateUpdate "DateUpdate" true true false 8 Date 0 0,First,#,SAM_911_2022,DateUpdate,-1,-1;PrimaryPoi "PrimaryPoi" true true false 3 Text 0 0,First,#,SAM_911_2022,PrimaryPoi,0,3;CityTownNa "CityTownNa" true true false 30 Text 0 0,First,#,SAM_911_2022,CityTownNa,0,30;PlaceName "PlaceName" true true false 30 Text 0 0,First,#,SAM_911_2022,PlaceName,0,30;PlaceType "PlaceType" true true false 75 Text 0 0,First,#,SAM_911_2022,PlaceType,0,75;CompleteSt "CompleteSt" true true false 68 Text 0 0,First,#,SAM_911_2022,CompleteSt,0,68;AP_Flag "AP_Flag" true true false 20 Text 0 0,First,#,SAM_911_2022,AP_Flag,0,20;SP_EDIT "SP_EDIT" true true false 10 Text 0 0,First,#,SAM_911_2022,SP_EDIT,0,10;ATT_EDIT "ATT_EDIT" true true false 10 Text 0 0,First,#,SAM_911_2022,ATT_EDIT,0,10;COMMENT "COMMENT" true true false 50 Text 0 0,First,#,SAM_911_2022,COMMENT,0,50;GLOBAL_ID "GLOBAL_ID" true true false 4 Long 0 0,First,#,SAM_911_2022,GLOBAL_ID,-1,-1;ASSETNME "ASSETNME" true true false 254 Text 0 0,First,#,SAM_911_2022,ASSETNME,0,254;SITE "SITE" true true false 255 Text 0 0,First,#,SAM_911_2022,SITE,0,255;STRUCTURE "STRUCTURE" true true false 255 Text 0 0,First,#,SAM_911_2022,STRUCTURE,0,255;SUBSITE "SUBSITE" true true false 255 Text 0 0,First,#,SAM_911_2022,SUBSITE,0,255;BUSINESSNAME "BUSINESSNAME" true true false 255 Text 0 0,First,#,SAM_911_2022,BUSINESSNAME,0,255" #
Rename C:\Users\jwebb\AppData\Roaming\Esri\ArcGISPro\Favorites\ocwpc02.sde\ocdata.GISADMIN.E911\ocdata.GISADMIN.ocdata_GISADMIN_OC_SAM_911_2022 C:\Users\jwebb\AppData\Roaming\Esri\ArcGISPro\Favorites\ocwpc02.sde\ocdata.GISADMIN.E911\ocdata.GISADMIN.OC_SAM_911_2022 FeatureClass
CalculateField ocdata.GISADMIN.OC_SAM_911 DateUpdate '8/25/2022' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" AddressSou "911AA" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" DateUpdate "4/12/2023" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" CompleteSt "Boon St" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" ATT_EDIT "JMW" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" DateUpdate "11/28/2023" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" AddressSou "911AA" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" ATT_EDIT "JMW" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" StreetName "Many" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" PostType "Dr" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" CompleteSt "Many Dr" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" DateUpdate "6/20/2024" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" SP_EDIT "JMW" Python # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911_2022 ZipName 'Verona' Python # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911_2022 State 'NY' Python # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911_2022 ZipCode 13478 Python # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911_2022 ATT_EDIT 'RAR' Python # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911_2022 ZipName 'Vernon' Python # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911_2022 State 'NY' Python # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911_2022 ZipCode 13476 Python # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911_2022 AddressSou '911AA' Python # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911_2022 DateUpdate '6/24/2024' Python # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911_2022 ATT_EDIT 'RAR' Python # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911_2022 ZipName 'Rome' Python # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911_2022 State 'NY' Python # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911_2022 ZipCode 13440 Python # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911_2022 DateUpdate '6/24/2024' Python # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911_2022 AddressSou '911AA' Python # Text NO_ENFORCE_DOMAINS
CalculateField ocdata.GISADMIN.OC_SAM_911_2022 ATT_EDIT 'RAR' Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" DateUpdate "5/1/2024" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" ATT_EDIT "JMW" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" DateUpdate "8/5/2024" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" NYSStreetI " " Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" NYSStreetI " " VBScript # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" NYSStreetI " " VBScript # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" NYSStreetI "" VBScript # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" NYSStreetI " " VBScript # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" NYSStreetI "1" VBScript # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" NYSStreetI " " VBScript # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" NYSStreetI ' ' Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" ZipName "UTICA" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" AddressSou "911AA" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" DateUpdate "10/2/2024" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" CityTownNa "UTICA" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" PlaceName " " Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" CompleteSt "CENTENNIAL CIR" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" AP_Flag " " Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" SP_EDIT " " Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" ATT_EDIT "JMW" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" StreetName "CENTENNIAL" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" PostType "CIR" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" BUSINESSNAME "SCHUYLER COMMONS" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" COMMENT "FLOOR 1" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" Floor " " Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" Floor " " Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" COMMENT "FLOOR 2" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" COMMENT "FLOOR 3" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" Floor " " Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" StreetName "CENTENNIAL" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" PostType "CIR" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" ZipName "UTICA" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" AddressSou "911AA" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" DateUpdate "10/2/2024" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" CityTownNa "UTICA" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" PlaceName " " Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" CompleteSt "CENTENNIAL CIR" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" AP_Flag " " Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" SP_EDIT " " Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" StreetName "KENNEDY" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" PostType "PLZ" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" ZipName "UTICA" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" DateUpdate "10/3/2024" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" CityTownNa "UTICA" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" PlaceName " " Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" AP_Flag " " Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" CompleteSt "KENNEDY PLZ" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" ATT_EDIT "JMW" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" BUSINESSNAME "SCHUYLER COMMONS" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" Floor " " Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" COMMENT "FLOOR 1" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" COMMENT "FLOOR 2" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" COMMENT "FLOOR 3" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" COMMENT "FLOOR 3" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" COMMENT "FLOOR 2" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" COMMENT "FLOOR 1" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" ZipName "UTICA" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" AddressSou "911AA" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" StreetName "MEMORIAL" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" PostType "PKWY" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" PostType "PKWY" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" DateUpdate "11/1/2024" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" CityTownNa "UTICA" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" CompleteSt "MEMORIAL PKWY" Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" AP_Flag " " Python # Text NO_ENFORCE_DOMAINS
CalculateField "Address Points" ATT_EDIT "JMW" Python # Text NO_ENFORCE_DOMAINS
CopyFeatures C:\Users\jwebb\AppData\Roaming\Esri\ArcGISPro\Favorites\Windows_Authentication_ocsql16.sde\ocdata.GISADMIN.E911\ocdata.GISADMIN.OC_SAM_911_2022 C:\ArcGIS_PRO\PROJECTS\ADDRESSING\E911_Addressing_Pro\E911_ADDRESSING_2025.gdb\OC_SAM_911_2022 # # # #
Rename C:\ArcGIS_PRO\PROJECTS\ADDRESSING\E911_Addressing_Pro\E911_ADDRESSING_2025.gdb\OC_SAM_911_2022 C:\ArcGIS_PRO\PROJECTS\ADDRESSING\E911_Addressing_Pro\E911_ADDRESSING_2025.gdb\OC_SAM_TEST FeatureClass
CopyFeatures OC_SAM_TEST C:\Users\jwebb\AppData\Roaming\Esri\ArcGISPro\Favorites\GISADMIN_Authentication_ocsql16.sde\ocdata.GISADMIN.E911\ocdata.GISADMIN.OC_SAM_TEST # # # #
Rename C:\ARCGIS_PRO\PROJECTS\ADDRESSING\GISADMIN.sde\ocdata.GISADMIN.E911\ocdata.GISADMIN.OC_SAM_TEST C:\ARCGIS_PRO\PROJECTS\ADDRESSING\GISADMIN.sde\ocdata.GISADMIN.E911\ocdata.GISADMIN.OC_SAM_MASTER_2025 FeatureClass
Server=ocsql16; Service=sde:sqlserver:ocsql16\lucity_gis; Database=ocdata; User=GISADMIN; Version=sde.DEFAULT
ArcSDE Connection
ocdata.GISADMIN.OC_SAM_TEST
002
0.000
428433.469000
513477.698100
4745895.988600
4828750.121000
1
Projected
GCS_North_American_1983
Linear Unit: Meter (1.000000)
NAD_1983_UTM_Zone_18N
<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/3.4.0'><WKT>PROJCS["NAD_1983_UTM_Zone_18N",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",-75.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",26918]]</WKT><XOrigin>-5120900</XOrigin><YOrigin>-9998100</YOrigin><XYScale>10000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>26918</WKID><LatestWKID>26918</LatestWKID></ProjectedCoordinateSystem>
20250314
12121000
20250314
12121000
Microsoft Windows 10 Version 10.0 (Build 19045) ; Esri ArcGIS 13.4.0.55405
OC_SAM_MASTER_2025
1
-75.886824
-74.832980
43.611731
42.862301
NEW SAM POINTS EFFECTIVE 3/14/2025
Enterprise Geodatabase Feature Class
0.000
dataset
EPSG
6.11(3.0.1)
0
Simple
FALSE
0
TRUE
FALSE
ocdata.GISADMIN.OC_SAM_TEST
Feature Class
0
OBJECTID
OBJECTID
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.
NYSAddress
NYSAddress
String
10
0
0
CountyID
CountyID
String
40
0
0
NYSStreetI
NYSStreetI
Integer
4
10
0
PrefixAddr
PrefixAddr
String
10
0
0
AddressNum
AddressNum
Integer
4
10
0
SuffixAddr
SuffixAddr
String
10
0
0
PreModifie
PreModifie
String
25
0
0
PreDirecti
PreDirecti
String
10
0
0
PreType
PreType
String
20
0
0
SeparatorE
SeparatorE
String
10
0
0
StreetName
StreetName
String
40
0
0
PostType
PostType
String
20
0
0
PostDirect
PostDirect
String
10
0
0
PostModifi
PostModifi
String
25
0
0
SubAddress
SubAddress
String
200
0
0
Floor
Floor
String
40
0
0
Unit
Unit
String
40
0
0
Room
Room
String
40
0
0
Seat
Seat
String
40
0
0
Location
Location
String
40
0
0
ZipName
ZipName
String
30
0
0
State
State
String
2
0
0
ZipCode
ZipCode
String
5
0
0
PointType
PointType
String
3
0
0
AddressSou
AddressSou
String
30
0
0
SourceOfDa
SourceOfDa
String
30
0
0
DateUpdate
DateUpdate
Date
8
0
0
PrimaryPoi
PrimaryPoi
String
3
0
0
CityTownNa
CityTownNa
String
30
0
0
PlaceName
PlaceName
String
30
0
0
PlaceType
PlaceType
String
75
0
0
CompleteSt
CompleteSt
String
68
0
0
SP_EDIT
SP_EDIT
String
10
0
0
ATT_EDIT
ATT_EDIT
String
10
0
0
COMMENT
COMMENT
String
50
0
0
GLOBAL_ID
GLOBAL_ID
Integer
4
10
0
ASSETNME
ASSETNME
String
254
0
0
SITE
SITE
String
255
0
0
STRUCTURE
STRUCTURE
String
255
0
0
SUBSITE
SUBSITE
String
255
0
0
BUSINESSNAME
BUSINESSNAME
String
255
0
0
AP_Flag
AP_Flag
String
20
0
0
created_user
created_user
String
255
0
0
created_date
created_date
Date
8
0
0
last_edited_user
last_edited_user
String
255
0
0
last_edited_date
last_edited_date
Date
8
0
0
20250314
iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO
xAAADsQBlSsOGwAAAqpJREFUeJzt1DENADAMwLAd5U+5o7BvimQjyJXZ3T0AAfM7AOCVYQEZhgVk
GBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFY
QIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZ
hgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgW
kGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECG
YQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYF
ZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBh
WECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEB
GYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQY
FpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhA
hmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmG
BWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQ
YVhAhmEBGYYFnIoLreIHHblfYqUAAAAASUVORK5CYII=