20231122
15214700
1.0
FALSE
CalculateField "Addresses - Site Address Points" temp [SITEADDID]+"B" VB #
CalculateField "Addresses - Site Address Points" temp2 [ADDPTKEY]+"B" VB #
CalculateField "Addresses - Site Address Points" temp [OBJECTID]-12217 VB #
CalculateField "Addresses - Site Address Points" SITEADDID [temp] VB #
CalculateField "Addresses - Site Address Points" temp ""SID-"+ [SITEADDID]" VB #
CalculateField "Addresses - Site Address Points" temp ""SID"+ [SITEADDID]" VB #
CalculateField "Addresses - Site Address Points" temp2 "SID" VB #
CalculateField "Addresses - Site Address Points" temp2 "SID-" VB #
CalculateField "Addresses - Site Address Points" temp3 [temp2] VB #
RepairGeometry "Addresses - Site Address Points" DELETE_NULL
CalculateField "Addresses - Site Address Points" Comment [SITEADDID] VB #
CalculateField "Addresses - Site Address Points" SITEADDID "SID-"+[SITEADDID] VB #
CalculateField "Addresses - Site Address Points" AddNum_Parcel [ADDRNUM] VB #
CalculateField "Addresses - Site Address Points" ADDNUMSUFF_Parcel [ADDRNUMSUF] VB #
CalculateField "Addresses - Site Address Points" PREFIX_Parcel [PREADDRNUM] VB #
CalculateField "Addresses - Site Address Points" STREETNAME_Parcel [FULLNAME] VB #
CalculateField "Addresses - Site Address Points" AddNum_Parcel NULL VB #
CalculateField "Addresses - Site Address Points" STREETNAME_Parcel NULL VB #
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.2.0'><FeatureDataset>Address</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Dropbox\Projects\Grant County WI\working\Grant_County_LGIM_new.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>CALCED_ADDNUM</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Calculated Address Number</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
CalculateField "Addresses - Site Address Points" CALCED_ADDNUM !ADDRNUM! "Python 3" #
CalculateField "Addresses - Site Address Points" ADDRNUM !AddNum_Parcel! "Python 3" #
CalculateField "Addresses - Site Address Points" FULLADDR !ADDRNUM!+" "+!FULLNAME! "Python 3" #
CalculateField "Addresses - Site Address Points" ADDRNUM [HouseNumber] VB #
CalculateField "Addresses - Site Address Points" FULLADDR Trim([HouseNumber]) VB #
CalculateField "Addresses - Site Address Points" ADDRNUM Trim([HouseNumber]) VB #
CalculateField "Addresses - Site Address Points" ADDRNUM [HouseNumber] VB #
Merge 'Addresses - Site Address Points';'Site Address Points' "C:\Dropbox\Grant County WI\working\New File Geodatabase.gdb\Address\SiteAddressPoint_merged" "SITEADDID "Site Address ID" true true false 20 Text 0 0 ,First,#,Addresses - Site Address Points,SITEADDID,-1,-1,Site Address Points,SITEADDID,-1,-1;ADDPTKEY "Address Point ID" true true false 20 Text 0 0 ,First,#,Addresses - Site Address Points,ADDPTKEY,-1,-1,Site Address Points,ADDPTKEY,-1,-1;PREADDRNUM "Address Number Prefix" true true false 5 Text 0 0 ,First,#,Addresses - Site Address Points,PREADDRNUM,-1,-1,Site Address Points,PREADDRNUM,-1,-1;ADDRNUMSUF "Address Number Suffix" true true false 5 Text 0 0 ,First,#,Addresses - Site Address Points,ADDRNUMSUF,-1,-1,Site Address Points,ADDRNUMSUF,-1,-1;ADDRNUM "Full Address Number" true true false 20 Text 0 0 ,First,#,Addresses - Site Address Points,ADDRNUM,-1,-1,Site Address Points,ADDRNUM,-1,-1;ADDRRANGE "Address Range" true true false 50 Text 0 0 ,First,#,Addresses - Site Address Points,ADDRRANGE,-1,-1,Site Address Points,ADDRRANGE,-1,-1;UNITTYPE "Address Unit Type" true true false 10 Text 0 0 ,First,#,Addresses - Site Address Points,UNITTYPE,-1,-1,Site Address Points,UNITTYPE,-1,-1;UNITID "Address Unit Number" true true false 10 Text 0 0 ,First,#,Addresses - Site Address Points,UNITID,-1,-1,Site Address Points,UNITID,-1,-1;ALTUNITTYPE "Alternate Address Unit Type" true true false 10 Text 0 0 ,First,#,Addresses - Site Address Points,ALTUNITTYPE,-1,-1,Site Address Points,ALTUNITTYPE,-1,-1;ALTUNITID "Alternate Address Unit Number" true true false 10 Text 0 0 ,First,#,Addresses - Site Address Points,ALTUNITID,-1,-1,Site Address Points,ALTUNITID,-1,-1;FULLNAME "Full Road Name" true true false 125 Text 0 0 ,First,#,Addresses - Site Address Points,FULLNAME,-1,-1,Site Address Points,FULLNAME,-1,-1;FULLADDR "Full Address" true true false 250 Text 0 0 ,First,#,Addresses - Site Address Points,FULLADDR,-1,-1,Site Address Points,FULLADDR,-1,-1;PLACENAME "Place Name" true true false 250 Text 0 0 ,First,#,Addresses - Site Address Points,PLACENAME,-1,-1,Site Address Points,PLACENAME,-1,-1;MUNICIPALITY "Municipality Name" true true false 100 Text 0 0 ,First,#,Addresses - Site Address Points,MUNICIPALITY,-1,-1,Site Address Points,MUNICIPALITY,-1,-1;ESN "Emergency Service Number" true true false 5 Text 0 0 ,First,#,Addresses - Site Address Points,ESN,-1,-1,Site Address Points,ESN,-1,-1;PSAP "Public Safety Answering Point" true true false 4 Text 0 0 ,First,#,Addresses - Site Address Points,PSAP,-1,-1,Site Address Points,PSAP,-1,-1;MSAG "MSAG Community" true true false 35 Text 0 0 ,First,#,Addresses - Site Address Points,MSAG,-1,-1,Site Address Points,MSAG,-1,-1;USNGCOORD "USNG Coordinate" true true false 50 Text 0 0 ,First,#,Addresses - Site Address Points,USNGCOORD,-1,-1,Site Address Points,USNGCOORD,-1,-1;ADDRCLASS "Description" true true false 4 Long 0 0 ,First,#,Addresses - Site Address Points,ADDRCLASS,-1,-1,Site Address Points,ADDRCLASS,-1,-1;POINTTYPE "Location" true true false 30 Text 0 0 ,First,#,Addresses - Site Address Points,POINTTYPE,-1,-1,Site Address Points,POINTTYPE,-1,-1;CAPTUREMETH "Capture Method" true true false 30 Text 0 0 ,First,#,Addresses - Site Address Points,CAPTUREMETH,-1,-1,Site Address Points,CAPTUREMETH,-1,-1;STATUS "Status" true true false 30 Text 0 0 ,First,#,Addresses - Site Address Points,STATUS,-1,-1,Site Address Points,STATUS,-1,-1;LASTUPDATE "Last Update Date" true true false 8 Date 0 0 ,First,#,Addresses - Site Address Points,LASTUPDATE,-1,-1,Site Address Points,LASTUPDATE,-1,-1;LASTEDITOR "Last Editor" true true false 50 Text 0 0 ,First,#,Addresses - Site Address Points,LASTEDITOR,-1,-1,Site Address Points,LASTEDITOR,-1,-1;Comment "Comment" true true false 255 Text 0 0 ,First,#,Addresses - Site Address Points,Comment,-1,-1,Site Address Points,Comment,-1,-1;created_user "created_user" true true false 255 Text 0 0 ,First,#,Addresses - Site Address Points,created_user,-1,-1;created_date "created_date" true true false 8 Date 0 0 ,First,#,Addresses - Site Address Points,created_date,-1,-1;AddNum_Parcel "AddNum_Parcel" true true false 50 Text 0 0 ,First,#,Addresses - Site Address Points,AddNum_Parcel,-1,-1;ADDNUMSUFF_Parcel "ADDNUMSUFF_Parcel" true true false 50 Text 0 0 ,First,#,Addresses - Site Address Points,ADDNUMSUFF_Parcel,-1,-1;PREFIX_Parcel "PREFIX_Parcel" true true false 50 Text 0 0 ,First,#,Addresses - Site Address Points,PREFIX_Parcel,-1,-1;STREETNAME_Parcel "STREETNAME_Parcel" true true false 100 Text 0 0 ,First,#,Addresses - Site Address Points,STREETNAME_Parcel,-1,-1;STREETTYPE_Parcel "STREETTYPE_Parcel" true true false 50 Text 0 0 ,First,#,Addresses - Site Address Points,STREETTYPE_Parcel,-1,-1;Parcel_SiteAddr "Parcel_SiteAddr" true true false 200 Text 0 0 ,First,#,Addresses - Site Address Points,Parcel_SiteAddr,-1,-1;CALCED_ADDNUM "Calculated Address Number" true true false 255 Text 0 0 ,First,#,Addresses - Site Address Points,CALCED_ADDNUM,-1,-1;HouseNumber "HouseNumber" true true false 50 Text 0 0 ,First,#,Addresses - Site Address Points,HouseNumber,-1,-1"
EnableEditorTracking "C:\Dropbox\Grant County WI\working\Grant_County_LGIM_final.gdb\Address\SiteAddressPoint" created_user created_date LASTEDITOR LASTUPDATE # UTC
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.2.0'><FeatureDataset>Address</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Dropbox\Projects\Grant County WI\working\Grant_County_LGIM_final.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>ADDPTKEY2</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Corrected Add Pt ID</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
CalculateField CCOLNEY.SiteAddressPoint FULLNAME "NORTH DUTCH HOLLOW RD" VB #
CalculateField CCOLNEY.SiteAddressPoint FULLADDR "[ADDRNUM] & [FULLNAME]" VB #
CalculateField CCOLNEY.SiteAddressPoint FULLADDR "[ADDRNUM] &" " & [FULLNAME]" VB #
CalculateField "Grant County\Addressing\Site Address Points" FULLNAME "EASTSIDE RD" VB #
CalculateField "Grant County\Addressing\Site Address Points" STREETNAME_Parcel "EASTSIDE" VB #
CalculateField "Grant County\Addressing\Site Address Points" STREETTYPE_Parcel "ROAD" VB #
CalculateField "Grant County\Addressing\Site Address Points" FULLNAME "EASTSIDE RD" VB #
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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'><FeatureDataset>CCOLNEY.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e685938323750496143644a3371637949515530713051583842493674756c5546306162334550544858737a773d2a00;SERVER=ADII;INSTANCE=sde:sqlserver:ADII;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ADII;DATABASE=Land_Information;USER=ccolney;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>CCOLNEY.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Generate Unique ID for Site Address Point</rule_name><rule_type>CALCULATION</rule_type><expression>return 'SITEADD_'+NextSequenceValue('site_add_seq')</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Generates a Unique ID for Site Address Point</rule_description><field_name>SITEADDID</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Generate Unique ID for Site Address Point</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Retrieve Entrance ID</rule_name><rule_type>CALCULATION</rule_type><expression>var driveway = featuresetbyname($datastore, 'Driveway')
var site = $feature
for(var d in driveway){
if (intersects(d, site)==True){
return d.ENTID
}
}</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Retrieves Entrance ID</rule_description><field_name>ENTID</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Retrieve Entrance ID</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Retrieve Address Point ID</rule_name><rule_type>CALCULATION</rule_type><expression>var entry_id = $feature.ENTID
var driveway = featuresetbyname($datastore, 'Driveway')
var sql = 'ENTID = @entry_id'
var driveway =first(filter(driveway, sql))
var address_pts = featuresetbyname($datastore, 'Address_Point')
for(var pt in address_pts){
if(intersects(driveway, pt)==True){
return pt.ADDPTKEY
}
}</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Retrieves Address Point ID</rule_description><field_name>ADDPTKEY</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Retrieve Address Point ID</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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'><FeatureDataset>CCOLNEY.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e685938323750496143644a3371637949515530713051583842493674756c5546306162334550544858737a773d2a00;SERVER=ADII;INSTANCE=sde:sqlserver:ADII;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ADII;DATABASE=Land_Information;USER=ccolney;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>CCOLNEY.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Unique ID</rule_name><rule_type>CALCULATION</rule_type><expression>return 'ADD-' + NextSeqValue('site_add_seq)</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Generate Unique ID for Site Address Point</rule_description><field_name>SITEADDID</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Unique ID</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
TruncateTable "NEW LAYERS\DBO Site Address Points"
Append 'OLD LAYERS\ADII Site Address Points' "C:\DATADRIVE\GIS_PRO\2. ProProjects\AddressDataManagement\GCSQL.sde\DBO.Addressing\DBO.SiteAddressPoint" "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AlterField><field_name>ENTID</field_name><new_field_name>DRWID</new_field_name><field_type>TEXT</field_type><field_length>50</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>
CalculateField "Address Management Features\Site Addresses\Site Addresses" DRWID !DRWID!.replace('ENT','DRW') "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Address Management Features\Site Addresses\Site Addresses" SITEADDID !SITEADDID! "Python 3" "rec=0
def autoIncrement():
global rec
pStart = 23062
pInterval = 1
if (rec == 0):
rec = pStart
else:
rec += pInterval
return 'SID-' + rec" Text NO_ENFORCE_DOMAINS
CalculateField "Address Management Features\Site Addresses\Site Addresses" SITEADDID autoIncrement() "Python 3" "rec=0
def autoIncrement():
global rec
pStart = 23062
pInterval = 1
if (rec == 0):
rec = pStart
else:
rec += pInterval
return rec" Text NO_ENFORCE_DOMAINS
CalculateField "Address Management Features\Site Addresses\Site Addresses" SITEADDID "'SID-' + !SITEADDID!" "Python 3" # Text NO_ENFORCE_DOMAINS
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>SiteAddressID</rule_name><rule_type>CALCULATION</rule_type><expression>var id = NextSequenceValue("SiteAddressIDSequence");
return `SID-${id}`;</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>0</error_number><rule_description>Calculates a new SiteAddress ID (SID-#) using the SiteAddressID database sequence.</rule_description><field_name>SITEADDID</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>SiteAddressID</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>SiteAddressID</rule_name><rule_type>CALCULATION</rule_type><expression>var id = NextSequenceValue("SiteAddressPointIDSequence");
return `SID-${id}`;</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>0</error_number><rule_description>Calculates a new SiteAddress ID (SID-#) using the SiteAddressID database sequence.</rule_description><field_name>SITEADDID</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>SiteAddressID</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteDomain><domain_name>PointCollectionMethod</domain_name></DeleteDomain></workflow><workflow><AssignDomainToField><field_name>CAPTUREMETH</field_name><domain_name>PointCollectionMethod.</domain_name></AssignDomainToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>ALTUNITTYPE</field_name></RemoveDomainFromField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>MUNICIPALITY</field_name><domain_name>Full_Name</domain_name></AssignDomainToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteDomain><domain_name>SiteAddressClass</domain_name></DeleteDomain></workflow><workflow><RemoveDomainFromField><field_name>ADDRCLASS</field_name></RemoveDomainFromField></workflow></operationSequence>
CalculateField "Address Management Features\Site Addresses\Site Addresses" ADDRNUMSUF $feature.ADDNUMSUFF_Parcel Arcade # Text NO_ENFORCE_DOMAINS
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteDomain><domain_name>SiteAddressClass</domain_name></DeleteDomain></workflow><workflow><DeleteField><field_name>AddNum_Parcel</field_name><field_name>ADDNUMSUFF_Parcel</field_name></DeleteField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>ADDRCLASS</field_name></DeleteField></workflow><workflow><AddField><field_name>Field</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>Field</field_name></DeleteField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><CreateFieldGroup><name>MunicipalityRoadName</name><fields>FULLNAME</fields><fields>MUNICIPALITY</fields><is_restrictive>TRUE</is_restrictive></CreateFieldGroup></workflow><workflow><AddContingentValue><field_group_name>MunicipalityRoadName</field_group_name><values><contingent_field_value><name>fullname</name><type>ANY</type><value>#</value></contingent_field_value><contingent_field_value><name>municipality</name><type>ANY</type><value>#</value></contingent_field_value></values><retire_value>FALSE</retire_value></AddContingentValue></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AlterContingentValue><id>1</id><field_group_name>MunicipalityRoadName</field_group_name><values><contingent_field_value><name>fullname</name><type>NULL</type><value>#</value></contingent_field_value><contingent_field_value><name>municipality</name><type>ANY</type><value>#</value></contingent_field_value></values><retire_value>TRUE</retire_value></AlterContingentValue></workflow><workflow><AddContingentValue><field_group_name>MunicipalityRoadName</field_group_name><values><contingent_field_value><name>fullname</name><type>ANY</type><value>#</value></contingent_field_value><contingent_field_value><name>municipality</name><type>ANY</type><value>#</value></contingent_field_value></values><retire_value>TRUE</retire_value></AddContingentValue></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><RemoveContingentValue><id>1</id></RemoveContingentValue></workflow><workflow><RemoveContingentValue><id>2</id></RemoveContingentValue></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AlterField><field_name>MUNICIPALITY</field_name><new_field_name>COMMUNITY</new_field_name><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField><AssignDomainToField><field_name>COMMUNITY</field_name><domain_name>Community</domain_name></AssignDomainToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>ZIPCODE</field_name><field_type>SHORT</field_type><field_precision>5</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>ZIPCODE</field_name></DeleteField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>ZIPCODE</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Zipcode</field_domain></AddField></workflow></operationSequence>
UpdateSchema "Address Management Features\Site Addresses\Site Addresses" <operationSequence><workflow><AssignDefaultToField><field_name>ZIPCODE</field_name><default_value>53801</default_value></AssignDefaultToField></workflow><workflow><SetSubtypeField><clear_value>True</clear_value></SetSubtypeField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteFieldGroup><name>MunicipalityRoadName</name></DeleteFieldGroup></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>ZIPCODE</field_name></DeleteField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>FULLNAME</field_name><domain_name>Full_Road_Name</domain_name></AssignDomainToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>USNGCOORD</field_name><field_name>PREFIX_Parcel</field_name><field_name>STREETNAME_Parcel</field_name><field_name>STREETTYPE_Parcel</field_name><field_name>Parcel_SiteAddr</field_name></DeleteField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>USNGCOORD</field_name><field_name>CALCED_ADDNUM</field_name><field_name>PREFIX_Parcel</field_name><field_name>STREETNAME_Parcel</field_name><field_name>STREETTYPE_Parcel</field_name><field_name>Parcel_SiteAddr</field_name></DeleteField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>USNGCOORD</field_name></DeleteField></workflow></operationSequence>
CalculateField "Address Management Features\Site Addresses\Site Addresses" FULLADDR "!ADDRNUM! + ' ' + !FULLNAME!" "Python 3" # Text NO_ENFORCE_DOMAINS
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>FullAddress</rule_name><rule_type>CALCULATION</rule_type><expression>$feature.ADDRNUM + ' ' + $feature.FULLNAME</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Calculate FullAddress</rule_description><field_name>FULLADDR</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>FullAddress</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>FullAddress</rule_name><rule_type>CALCULATION</rule_type><expression>$feature.ADDRNUM + ' ' + $feature.FULLNAME</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Calculate FullAddress</rule_description><field_name>FULLADDR</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>FullAddress</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>CalcFullAddress</rule_name><rule_type>CALCULATION</rule_type><expression>$feature.ADDRNUM + ' ' + $feature.FULLNAME</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Calculates Full Address Fields</rule_description><field_name>FULLADDR</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>CalcFullAddress</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>CalcFullAddress</rule_name><rule_type>CALCULATION</rule_type><expression>$feature.ADDRNUM + ' ' + $feature.FULLNAME</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Calculates Full Address Fields</rule_description><field_name>FULLADDR</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>CalcFullAddress</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>CalcFullAddress</rule_name><rule_type>CALCULATION</rule_type><expression>$feature.ADDRNUM + ' ' + $feature.FULLNAME</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Calculates Full Address Fields</rule_description><field_name>FULLADDR</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>CalcFullAddress</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b313432475643592f552b747966753472537a6b2b70644a70484570594b7a5a54666249763676586359453d2a00;ENCRYPTED_PASSWORD=00022e68497361466e546643324333634e4d67586974316d6a3353462b4674614f6e664a4866622b5354665669706b3d2a00;SERVER=GCSQL;INSTANCE=sde:sqlserver:GCSQL\GCSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GCSQL\GCSQL;DATABASE=Land_Information;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>CalcFullAddress</rule_name><rule_type>CALCULATION</rule_type><expression>$feature.ADDRNUM + ' ' + $feature.FULLNAME</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Calculates Full Address Fields</rule_description><field_name>FULLADDR</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>CalcFullAddress</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
CCOLNEY.SiteAddressPoint
002
Server=GCSQL; Service=sde:sqlserver:GCSQL\GCSQL; Database=Land_Information; User=sa; Version=dbo.DEFAULT
ArcSDE Connection
703573.874930
895807.159098
399708.497996
653778.960655
1
-
Projected
GCS_NAD_1983_2011
Linear Unit: Foot_US (0.304801)
NAD_1983_2011_WISCRS_Grant_Feet
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.7'><WKT>PROJCS["NAD_1983_2011_WISCRS_Grant_Feet",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",794999.998],PARAMETER["False_Northing",0.033],PARAMETER["Central_Meridian",-90.8],PARAMETER["Scale_Factor",1.0000349452],PARAMETER["Latitude_Of_Origin",41.41111111111111],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",7607]]</WKT><XOrigin>-17654200</XOrigin><YOrigin>-47863500</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>7607</WKID><LatestWKID>7607</LatestWKID></ProjectedCoordinateSystem>
20210521
08463900
20210521
08463900
Version 6.2 (Build 9200) ; Esri ArcGIS 10.7.0.10450
Address Numbers
1
-91.142879
-90.421940
43.205012
42.507327
Address Number
Site Address Point
Site Address Points assigned in Grant County
SDE Feature Class
dataset
EPSG
8.8(10.4.0)
24021
Simple
FALSE
24021
TRUE
FALSE
CCOLNEY.SiteAddressPoint
Feature Class
24021
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
SHAPE
Shape
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
SITEADDID
Site Address ID
String
20
0
0
ADDPTKEY
Address Point ID
String
20
0
0
PREADDRNUM
Address Number Prefix
String
5
0
0
ADDRNUMSUF
Address Number Suffix
String
5
0
0
ADDRNUM
Full Address Number
String
20
0
0
ADDRRANGE
Address Range
String
50
0
0
UNITTYPE
Address Unit Type
String
10
0
0
UNITID
Address Unit Number
String
10
0
0
ALTUNITTYPE
Alternate Address Unit Type
String
10
0
0
ALTUNITID
Alternate Address Unit Number
String
10
0
0
FULLNAME
Full Road Name
String
125
0
0
FULLADDR
Full Address
String
250
0
0
PLACENAME
Place Name
String
250
0
0
MUNICIPALITY
Municipality Name
String
100
0
0
ESN
Emergency Service Number
String
5
0
0
PSAP
Public Safety Answering Point
String
4
0
0
MSAG
MSAG Community
String
35
0
0
USNGCOORD
USNG Coordinate
String
50
0
0
ADDRCLASS
Description
Integer
4
10
0
POINTTYPE
Location
String
30
0
0
CAPTUREMETH
Capture Method
String
30
0
0
STATUS
Status
String
30
0
0
LASTUPDATE
Last Update Date
Date
8
0
0
LASTEDITOR
Last Editor
String
50
0
0
Comment
Comment
String
255
0
0
created_user
created_user
String
255
0
0
created_date
created_date
Date
8
0
0
AddNum_Parcel
AddNum_Parcel
String
50
0
0
ADDNUMSUFF_Parcel
ADDNUMSUFF_Parcel
String
50
0
0
PREFIX_Parcel
PREFIX_Parcel
String
50
0
0
STREETNAME_Parcel
STREETNAME_Parcel
String
100
0
0
STREETTYPE_Parcel
STREETTYPE_Parcel
String
50
0
0
Parcel_SiteAddr
Parcel_SiteAddr
String
200
0
0
CALCED_ADDNUM
Calculated Address Number
String
255
0
0
Enabled
Enabled
SmallInteger
2
5
0
HouseNumber
HouseNumber
String
50
0
0
ENTID
Entrance Connection ID
String
20
0
0
NOTES
Notes
String
250
0
0
20210521
/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
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooATtWfqct7CLX7HHG++
4RJfMB4jP3iMd/rxWjSUIE7O4VXS7t5LuS1SVGuIlDSRg/MoPQke+KsVVjsoYr+e8UHzZkRH9MLu
x/6Ef0pgra3LdFFFIAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooASk60vtWba27xaxfzNdNIsqxbYDJkRYBBIXtn9cUwSvc06Sqdx
fw2tzawS799y5jj2oWGQCeSOnAPWrlIGmhaKKKAK0d5by3MttHPG08IUyRqwLKD0yO2as1Wjs4Yr
ua6RAJZlVXYAc7c4/nVmhjdugUUUUCCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKK
KACiiigAooooAKKKKACiiigBMUtV0uYJLiS3SaNpogC8YYFlB6ZHbNWKAtYb6VRh06CHVbnUEAEt
xHHG/H9wtg/+PY/AVfoouCur2I3iSRo2ZQTG25T6HBGfyJ/OpaKKAM9rSf8AthLsXUogEDRtb5Gw
tuBDYx1xkdfStCkpaLjeolLWf9ucayLD7M3lm3Mwn3DGQwG3HXvnNaFFhNNCE4FNR1kUMjAqehBy
KcRkVS0vTodK0+KytwBFHnGBjqST/OgNLF6iiigAooooAKKKKACiiigAooooAKKKKACiiigAoooo
AKKKKACiiigAooooAKKKKAEqrd39tYLG1zMsSySLEhY/edugq0TxWbDc2urieMJIRbXIRt6lfnQh
gR6jOOaaQ4q+r2J47GCK+mvEVRNMiI5AHO3OOf8AgX6Cn3l5DZWktzcPshiQu7YJwB16VYqC5to7
u1lt5hujlQo4z1BGDR11BO71HwypPDHNG25JFDKfUHkVLTVUKoUdAMCnUhGfYSXjyXa3ixAJcFYP
LBGY8AgnPU8nOOKv0tFDBu7uFFFFACYGc459aWiigAooooAoatHey6dImnT+RdErskKB8fMM8Hjp
mrwpaKLhfQKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAEpaoG5uRq6Wv2
ZTatA0nn7+Q4YDbtx6HOc1fosNqxn3N81vf2NqLd5Bcs4MgIAj2rnn1z7Vbjiji37FC72LNjuT3p
5UEgkDI6H0pe1MG9BaKKKQgpKKzpb24TWra0W3DQSwySPNu5UqVAGMd93+cUJXBJscLqc601p9m/
0cW4l+0b+rFsbdv0Gc1oUUUA3cKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKK
KKACiiigAooooAQ8c1n6Vezahp8dzPbG2kfOYmcNjBIHI9cZpdK1D+0rRpzA8JWWSIo5BOUcqTx7
g1f7U9tBtWumtSG5m8i2ll2M/loW2L1bAzge9R2N0L7T7e6CNGJ41kCP1UEZwatYz1qNI1ijVEAV
VACqowAB2FLoK6tYlooooAKKKKAKEdzcvq1xbGBVt44kdJt+SzMWBGMdtvrV+iigG7iUGiqV/Auo
6Zd2kcoHnRPDvU/dJBHb0oQJF6ioYIRb28UKklY0Cgsck4GOTU1ABRTWYKpZiAAMknoKbHJHNEsk
Tq8bDKspyCPUGgB9FUJ1vjqloYZY1swshnUpkseNuDnjqT+FX6AasLRRRQAUUUUAFFFFABRRRQAU
UUUAFFFFABRRRQAUUUUAJS1Q0mW8m0+N9Qjjjuju3rECFGGIGM89MVeoeg2rOxm6et8L7UTdybrc
zL9lXaBhNi56f7RYc+laVA+tZ7RXp1pZRORYiAqYtowZN33s9en4U9w31LyKqcKoHJOB6nk0+iik
IKzryS9XULFLdYzbOzi4LAlgNpK47Dkd60aSgE7C0UUUAZ2mw3cMc/2udpWa4kaPKgbI9x2rx14/
HmtCoZLiGKSKKSVEeUkRqzAFyBkgDvxU9Njd27sKKKKQjMmubsa5b2qQobWSCSSSU5yrKVAHpzu/
Q+lSadpsGmRzJAoUTTvO2Bj5mOTV6g079Btu1kLRRRSERTRLNE0bgMjqVYHuDUGn2UenadbWUWfL
gjWNSepAGM1boov0Hd2sLRRRQIKKKKACiiigAooooAKKKKAKct/DDqNvZMspluFdkKoSoC4zk9B1
FXKiMS+YshUb1BUH0Bxn+Q/KpaAdugUUUUAFFFFABRRRQAlJnmlrPt7AW+p3l750rC4WMeWzkqhU
EfKOgzkdKYK3U0aKKKQFZ7mCO4jt2mjWaUEohYBmA64HfGasVUlsIJtQt711Bmt1dUOOgbGf5Vbp
g7aWGsu5SMkZGMjtVLSrSez02G3ubiS4mRcPLIcsx69cCnX+owabbrNcsVRpEjBClvmYgDp7mrua
NbD1S8mLRRRSEUbnT4Lu7s7mRcyWjs8ZwOpUqf5/pVwcCqmpX6aZYy3ckcsix4ysa7mOSBwPxq2C
DT1sN3sm9h1FFFIRS/tG2/tX+zvN/wBK8nz/AC9p+5nbnPTrV2ohEizGbHzlQpPsMn+pqWgH5BRR
RQBRsdQjvjc7I5U8iZoW3rtyRjkeo561PcwC4tpIGztkQqcEg4Ix1FOSGOIsUQDc25sDqfWpafoN
tXuinp1mLDTra0DFvIiWPcSTnAxnmrdFFJ6ibbd2LRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRR
QAUUUUAJS1n6hHeSPaGzuDEqTq042g748HK89O3Tmr46Uwa0FooopAFFJVDVLa4u9NmgtbqS2mdf
kljI3Kc57g/ShAld2LF1aw3kYjnTeokSQDP8SMGU/gQDU4oHCjnNGaAv0FooooAZJGkqFJEVlPUM
Min0UUARSSpBE0kjqsagszMcAAdSTTQ0dzb5R8xyL8rxt1BHUEfzongjubeSGVQ0UilGVhkEEYIx
RbW6WttDbxACOJAigDGABgUBpbzINLtHstNtraSV5XijVWkdixY45OT1q7RS0N3Btt3YUUUUAFFF
FABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRVTUIZbnT7iGCVopZImVJEOCrEcEGnWkckNnDHLI0
kiRqruxyWIHJNAW0uWaKaSFUsxAA5JPakVldQykFSMgg8EUAPooooASqE9lJJq1rdLcSrHEjq0St
hXJxgkd8c1oUlCdhptbBS1n299JNqd3aPbPGsCxssxYESbs9B1GCCOavHJBwcH1oasDTW4tB4FUN
IivItMgXUJ/PuwmZXChcn0wOOOn4U681COxltY3jmc3EwhQxoWCnBOW9BgHmnbWyC2tkM0u7uL2y
Wa6tRbSlnUxh9+MMQDnA64zWhQKKTE2m7pWFpKWqMOpQz6jc2KLIJbYIzlkIUhgSMHv0osCTexdq
h/Z//E6/tDzX/wCPfydm44+9nOOma0KShOw02haKKKBBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAB
RRRQAUUUUAFFFFABRRRQBBc28d3bS28qho5UKMD3BGDTbK2Wzs4LVPuQxrGvGOAMf0qxRRfoO7tY
WiiigQUUUUANwM5xye9OoooAKjaNXZGZQSh3KT2OCM/kT+dSUUAFFFFABUQiRZmkCgM4AZu5x0/m
alooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAp3t/b6f
HG9zJsWSRYkOCcsxwBxVsHIqC5tormNUlXKq6yAdPmVgwP5gVOBgUaBpbzFooooAKKKKACiiigAo
oooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii
igAooooAKKKKAP/Z