20250908
12485600
1.0
TRUE
CreateFeatureclass "\\ccgisags01m\ServerMxds\Addresser\ArcPro\AddresserData\server=ccentgis db=prdgis user=gismo.sde" addressorData Point # No Yes "PROJCS["NAD_1983_StatePlane_Nevada_East_FIPS_2701_Feet",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",656166.6666666665],PARAMETER["False_Northing",26246666.66666666],PARAMETER["Central_Meridian",-115.5833333333333],PARAMETER["Scale_Factor",0.9999],PARAMETER["Latitude_Of_Origin",34.75],UNIT["Foot_US",0.3048006096012192]];-17790500 -19184900 3048.00609601219;-100000 10000;-100000 10000;3.28083333333333E-03;0.001;0.001;IsHighPrecision" # # # # addressorData
UpdateSchema "\\ccgisags01m\ServerMxds\Addresser\ArcPro\AddresserData\server=ccentgis db=prdgis user=gismo.sde\addressorData" <operationSequence><workflow><AddField><field_name>StreetNumber</field_name><field_type>Short</field_type><field_alias>StreetNumber</field_alias><field_is_nullable>FALSE</field_is_nullable><field_length>2</field_length></AddField></workflow><workflow><AddField><field_name>Direction</field_name><field_type>TEXT</field_type><field_alias>Direction</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>10</field_length></AddField></workflow><workflow><AddField><field_name>StreetName</field_name><field_type>TEXT</field_type><field_alias>StreetName</field_alias><field_is_nullable>FALSE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>StreetType</field_name><field_type>TEXT</field_type><field_alias>StreetType</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>50</field_length></AddField></workflow><workflow><AddField><field_name>AddressType</field_name><field_type>TEXT</field_type><field_alias>AddressType</field_alias><field_is_nullable>FALSE</field_is_nullable><field_length>20</field_length></AddField></workflow><workflow><AddField><field_name>Notes</field_name><field_type>TEXT</field_type><field_alias>Notes</field_alias><field_is_nullable>FALSE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>Parcel</field_name><field_type>TEXT</field_type><field_alias>Parcel</field_alias><field_is_nullable>FALSE</field_is_nullable><field_length>15</field_length></AddField></workflow><workflow><AddField><field_name>XCoordinate</field_name><field_type>DOUBLE</field_type><field_alias>XCoordinate</field_alias><field_is_nullable>FALSE</field_is_nullable><field_length>8</field_length></AddField></workflow><workflow><AddField><field_name>YCoordinate</field_name><field_type>DOUBLE</field_type><field_alias>YCoordinate</field_alias><field_is_nullable>FALSE</field_is_nullable><field_length>8</field_length></AddField></workflow><workflow><AddField><field_name>Username</field_name><field_type>TEXT</field_type><field_alias>Username</field_alias><field_is_nullable>FALSE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>CreatedBy</field_name><field_type>TEXT</field_type><field_alias>CreatedBy</field_alias><field_is_nullable>FALSE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>DateCreated</field_name><field_type>DATE</field_type><field_alias>DateCreated</field_alias><field_is_nullable>FALSE</field_is_nullable><field_length>8</field_length></AddField></workflow><workflow><AddField><field_name>ModifiedBy</field_name><field_type>TEXT</field_type><field_alias>ModifiedBy</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>DateModified</field_name><field_type>TEXT</field_type><field_alias>DateModified</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>Lat</field_name><field_type>DOUBLE</field_type><field_alias>Lat</field_alias><field_is_nullable>FALSE</field_is_nullable><field_length>8</field_length></AddField></workflow><workflow><AddField><field_name>Long</field_name><field_type>DOUBLE</field_type><field_alias>Long</field_alias><field_is_nullable>FALSE</field_is_nullable><field_length>8</field_length></AddField></workflow><workflow><AddField><field_name>AccelaID</field_name><field_type>Long</field_type><field_alias>AccelaID</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>4</field_length></AddField></workflow><workflow><AddField><field_name>HasPushedToAccela</field_name><field_type>TEXT</field_type><field_alias>HasPushedToAccela</field_alias><field_is_nullable>FALSE</field_is_nullable><field_default_value>N</field_default_value><field_length>5</field_length></AddField></workflow></operationSequence>
AssignDefaultToField "\\ccgisags01m\ServerMxds\Addresser\ArcPro\AddresserData\server=ccentgis db=prdgis user=gismo.sde\addressorData" HasPushedToAccela N # DO_NOT_CLEAR
UpdateSchema "\\ccgisags01m\ServerMxds\Addresser\ArcPro\AddresserData\server=ccentgis db=prdgis user=gismo.sde\addressorData" <operationSequence><workflow><AlterField><field_name>OBJECTID</field_name><field_alias>OBJECTID</field_alias></AlterField></workflow><workflow><AlterField><field_name>SHAPE</field_name><field_alias>SHAPE</field_alias></AlterField></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6832345a4f6d7467745547553031486857432b6533716154517677583668766a73632f48323378643365594d3d2a00;ENCRYPTED_PASSWORD=00022e68316d6462345a52654e562f787a542f327a70364733442b304a4b302f2b6c4f3745366931337347796a73633d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addressorData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>Direction</field_name><domain_name>GI_StrDir</domain_name></AssignDomainToField></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6832345a4f6d7467745547553031486857432b6533716154517677583668766a73632f48323378643365594d3d2a00;ENCRYPTED_PASSWORD=00022e68316d6462345a52654e562f787a542f327a70364733442b304a4b302f2b6c4f3745366931337347796a73633d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addressorData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>StreetType</field_name><domain_name>ST_Suffix</domain_name></AssignDomainToField></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6832345a4f6d7467745547553031486857432b6533716154517677583668766a73632f48323378643365594d3d2a00;ENCRYPTED_PASSWORD=00022e68316d6462345a52654e562f787a542f327a70364733442b304a4b302f2b6c4f3745366931337347796a73633d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addressorData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>AddressType</field_name><domain_name>AddressType2</domain_name></AssignDomainToField><AssignDefaultToField><field_name>AddressType</field_name><default_value>Pri</default_value></AssignDefaultToField></workflow></operationSequence>
CalculateField addressorData DateCreated Today() Arcade # Text NO_ENFORCE_DOMAINS
CalculateField addressorData DateCreated Date() Arcade # Text NO_ENFORCE_DOMAINS
CalculateField addressorData DateCreated time.strftime('%d/%m/%Y') "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField addressorData DateCreated time.strftime('%m/%d/%Y') "Python 3" # Text NO_ENFORCE_DOMAINS
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6832345a4f6d7467745547553031486857432b6533716154517677583668766a73632f48323378643365594d3d2a00;ENCRYPTED_PASSWORD=00022e68316d6462345a52654e562f787a542f327a70364733442b304a4b302f2b6c4f3745366931337347796a73633d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addressorData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>DateCreated</field_name><clear_value>True</clear_value></AssignDefaultToField></workflow></operationSequence>
CalculateGeometryAttributes addressorData "XCoordinate POINT_X;YCoordinate POINT_Y" # # PROJCS["NAD_1983_StatePlane_Nevada_East_FIPS_2701_Feet",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",656166.6666666665],PARAMETER["False_Northing",26246666.66666666],PARAMETER["Central_Meridian",-115.5833333333333],PARAMETER["Scale_Factor",0.9999],PARAMETER["Latitude_Of_Origin",34.75],UNIT["Foot_US",0.3048006096012192]] "Same as input"
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6832345a4f6d7467745547553031486857432b6533716154517677583668766a73632f48323378643365594d3d2a00;ENCRYPTED_PASSWORD=00022e68316d6462345a52654e562f787a542f327a70364733442b304a4b302f2b6c4f3745366931337347796a73633d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addressorData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>DateModified</field_name></DeleteField></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6832345a4f6d7467745547553031486857432b6533716154517677583668766a73632f48323378643365594d3d2a00;ENCRYPTED_PASSWORD=00022e68316d6462345a52654e562f787a542f327a70364733442b304a4b302f2b6c4f3745366931337347796a73633d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addressorData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>DateModified</field_name></DeleteField></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6832345a4f6d7467745547553031486857432b6533716154517677583668766a73632f48323378643365594d3d2a00;ENCRYPTED_PASSWORD=00022e68316d6462345a52654e562f787a542f327a70364733442b304a4b302f2b6c4f3745366931337347796a73633d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addressorData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>DateModified</field_name></DeleteField></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6832345a4f6d7467745547553031486857432b6533716154517677583668766a73632f48323378643365594d3d2a00;ENCRYPTED_PASSWORD=00022e68316d6462345a52654e562f787a542f327a70364733442b304a4b302f2b6c4f3745366931337347796a73633d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addressorData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>DateModified</field_name></DeleteField></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6832345a4f6d7467745547553031486857432b6533716154517677583668766a73632f48323378643365594d3d2a00;ENCRYPTED_PASSWORD=00022e68316d6462345a52654e562f787a542f327a70364733442b304a4b302f2b6c4f3745366931337347796a73633d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addressorData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>DateModified</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
Rename "\\ccgisags01m\ServerMxds\Addresser\ArcPro\AddresserData\server=ccentgis db=prdgis user=gismo.sde\prdgis.GISMO.addressorData" "\\ccgisags01m\ServerMxds\Addresser\ArcPro\AddresserData\server=ccentgis db=prdgis user=gismo.sde\prdgis.GISMO.addresserData" FeatureClass
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686a75413373523631564b702b734a556533334e774f78357455647050365262674f6c4755476b776c644c673d2a00;ENCRYPTED_PASSWORD=00022e686d4159627967546a477773476e6150374342495153794e4a4e3054762b544a6e397a784e7a4664694471553d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><EnableEditorTracking><creator_field>CreatedBy</creator_field><creation_date_field>DateCreated</creation_date_field><last_editor_field>ModifiedBy</last_editor_field><last_edit_date_field>DateModified</last_edit_date_field><add_fields>TRUE</add_fields><record_dates_in>UTC</record_dates_in></EnableEditorTracking></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686a75413373523631564b702b734a556533334e774f78357455647050365262674f6c4755476b776c644c673d2a00;ENCRYPTED_PASSWORD=00022e6845747758455664796c3779736d37674241753779624d72483541564834682f683852416750355267646d733d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddGlobalIDs /></workflow></operationSequence>"
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686a75413373523631564b702b734a556533334e774f78357455647050365262674f6c4755476b776c644c673d2a00;ENCRYPTED_PASSWORD=00022e685862724c74764872344177696b784753457045693442563362467541426734757a703850435635674c70553d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddGlobalIDs /></workflow></operationSequence>"
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686a75413373523631564b702b734a556533334e774f78357455647050365262674f6c4755476b776c644c673d2a00;ENCRYPTED_PASSWORD=00022e6875346a717a2f4c6e31646557422f5a4d4c4e48454b445437784f6d4d39684b78703270335455616c3577343d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Populate X</rule_name><rule_type>CALCULATION</rule_type><expression>var xcord = Geometry($feature).x
return xcord</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>Populate X Coordinate</rule_description><field_name>XCoordinate</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><tags>xcoordinate</tags><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Populate X</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Populate Y</rule_name><rule_type>CALCULATION</rule_type><expression>var ycord = Geometry($feature).y
return ycord</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>Populate Y Coordinate</rule_description><field_name>YCoordinate</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><tags>ycoordiante</tags><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Populate Y</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
CalculateGeometryAttributes addresserData "XCoordinate POINT_X" # # PROJCS["NAD_1983_StatePlane_Nevada_East_FIPS_2701_Feet",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",656166.6666666665],PARAMETER["False_Northing",26246666.66666666],PARAMETER["Central_Meridian",-115.5833333333333],PARAMETER["Scale_Factor",0.9999],PARAMETER["Latitude_Of_Origin",34.75],UNIT["Foot_US",0.3048006096012192]] "Same as input"
CalculateGeometryAttributes addresserData "YCoordinate POINT_Y" # # PROJCS["NAD_1983_StatePlane_Nevada_East_FIPS_2701_Feet",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",656166.6666666665],PARAMETER["False_Northing",26246666.66666666],PARAMETER["Central_Meridian",-115.5833333333333],PARAMETER["Scale_Factor",0.9999],PARAMETER["Latitude_Of_Origin",34.75],UNIT["Foot_US",0.3048006096012192]] "Same as input"
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686a75413373523631564b702b734a556533334e774f78357455647050365262674f6c4755476b776c644c673d2a00;ENCRYPTED_PASSWORD=00022e6875346a717a2f4c6e31646557422f5a4d4c4e48454b445437784f6d4d39684b78703270335455616c3577343d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Update Accela Flag</rule_name><rule_type>CALCULATION</rule_type><expression>return 'N'</expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Updates Accela Flag to 'N' when feature is modified.</rule_description><field_name>HasPushedToAccela</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><tags>Clark County</tags><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Update Accela Flag</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686a75413373523631564b702b734a556533334e774f78357455647050365262674f6c4755476b776c644c673d2a00;ENCRYPTED_PASSWORD=00022e6875346a717a2f4c6e31646557422f5a4d4c4e48454b445437784f6d4d39684b78703270335455616c3577343d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>Parcel</field_name><field_type>TEXT</field_type><field_is_nullable>False</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField><AssignDefaultToField><field_name>Parcel</field_name><default_value>0</default_value></AssignDefaultToField></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686a75413373523631564b702b734a556533334e774f78357455647050365262674f6c4755476b776c644c673d2a00;ENCRYPTED_PASSWORD=00022e6875346a717a2f4c6e31646557422f5a4d4c4e48454b445437784f6d4d39684b78703270335455616c3577343d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>StreetType</field_name><domain_name>ST_Suffix_New</domain_name></AssignDomainToField></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686a75413373523631564b702b734a556533334e774f78357455647050365262674f6c4755476b776c644c673d2a00;ENCRYPTED_PASSWORD=00022e6875346a717a2f4c6e31646557422f5a4d4c4e48454b445437784f6d4d39684b78703270335455616c3577343d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Street Name Validation</rule_name><rule_type>VALIDATION</rule_type><expression>// --- Configuration ---
var INPUT_DIRECTION = $feature.Direction; // Replace with actual field name if needed
var INPUT_STREETNAME = $feature.StreetName;
var INPUT_SUFFIX = $feature.StreetType;
var MASTER_TABLE = 'prdgis.dbo.vwAddressorData';
var MASTER_DIRECTION = 'Direction';
var MASTER_STREETNAME = 'StreetName';
var MASTER_SUFFIX = 'StreetSuffix';
// Allowed directionals (adjust if needed)
var allowedDirs = ['N', 'S', 'E', 'W'];
// Allowed street suffix codes
var allowedTypes = ['ALY', 'ANX', 'AVE', 'BND', 'BLF', 'BLVD', 'BRK', 'BYP', 'CYN', 'CIR', 'CT', 'CV', 'CRK', 'CRES', 'CRST', 'XING', 'DR', 'EXPY', 'FRK', 'FWY', 'HTS', 'HWY', 'HL', 'JCT', 'LN', 'LOOP', 'MTN', 'PARK', 'PKWY', 'PASS', 'PATH', 'PL', 'PLZ', 'PT', 'RNCH', 'RDG', 'RD', 'RTE', 'RUN', 'SPG', 'SPUR', 'SQ', 'STRA', 'ST', 'SMT', 'TER', 'TRAK', 'TRL', 'VLY', 'VW', 'VIS', 'WALK', 'WAY'];
// --- Input Processing ---
//var dir = ($feature[INPUT_DIRECTION]);
//var name = Text($feature[INPUT_STREETNAME]);
// suffix = Text($feature[INPUT_SUFFIX]);
// 1) Presence checks
if (IsEmpty(INPUT_STREETNAME)) { return false; } // StreetName required
// 2) Whitelist checks
function inListOrEmpty(v, lst){
if (IsEmpty(v) || v == '') return true;
return IndexOf(lst, Upper(Trim(v))) > -1;
}
if (!inListOrEmpty(INPUT_DIRECTION, allowedDirs)) { return false; }
if (!inListOrEmpty(INPUT_SUFFIX, allowedTypes)) { return false; }
// 3) Master lookup: compare in Arcade (case-insensitive)
var masterFS = FeatureSetByName($datastore, MASTER_TABLE, [MASTER_DIRECTION, MASTER_STREETNAME, MASTER_SUFFIX], false);
if (IsEmpty(masterFS) || Count(masterFS) == 0) { return false; }
var tName = Upper(Trim(INPUT_STREETNAME));
var tDir = Upper(Trim(INPUT_DIRECTION));
var tSuffix = Upper(Trim(INPUT_SUFFIX));
for (var m in masterFS) {
var mName = Upper(Trim(Text(m[MASTER_STREETNAME])));
var mDir = Upper(Trim(DefaultValue(m[MASTER_DIRECTION], '')));
var mSuffix = Upper(Trim(DefaultValue(m[MASTER_SUFFIX], '')));
// Logic: Name must match; Dir/Suffix optional but must match if present
var nameOK = mName == tName;
var dirOK = IsEmpty(tDir) || tDir == mDir;
var suffixOK = IsEmpty(tSuffix) || tSuffix == mSuffix;
if (nameOK && dirOK && suffixOK) {
return true;
}
}
// No valid match found
return false;</expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>10010</error_number><error_message>Street Validation Error. Invalid street components. Street Name must exist in Addresser View Data (data is from Accela, SCL Street Centerline and recently added Streets temp table). Direction must use approved abbreviations and match the master. Street Suffix must use approved abbreviations and match the master.</error_message><rule_description>Validate Addresser Pin Drop Street Name user entry before committing </rule_description><exclude_from_client_eval>False</exclude_from_client_eval><batch>True</batch><severity>1</severity><tags>Pin Drop;Addresser;Clark County</tags><category>-1</category></AddAttributeRule></workflow></operationSequence>"
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/3.5.0'><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>StreetNameValidation_PinDrop</rule_name><rule_type>VALIDATION</rule_type><expression>// --- Configuration ---
var INPUT_DIRECTION = 'Direction'; // Replace with actual field name if needed
var INPUT_STREETNAME = 'StreetName';
var INPUT_SUFFIX = 'StreetType';
var MASTER_TABLE = 'prdgis.dbo.vwAddressorData';
var MASTER_DIRECTION = 'Direction';
var MASTER_STREETNAME = 'StreetName';
var MASTER_SUFFIX = 'StreetSuffix';
// Allowed directionals (adjust if needed)
var allowedDirs = ['N', 'S', 'E', 'W'];
// Allowed street suffix codes
var allowedTypes = ['ALY', 'ANX', 'AVE', 'BND', 'BLF', 'BLVD', 'BRK', 'BYP', 'CYN', 'CIR', 'CT', 'CV', 'CRK', 'CRES', 'CRST', 'XING', 'DR', 'EXPY', 'FRK', 'FWY', 'HTS', 'HWY', 'HL', 'JCT', 'LN', 'LOOP', 'MTN', 'PARK', 'PKWY', 'PASS', 'PATH', 'PL', 'PLZ', 'PT', 'RNCH', 'RDG', 'RD', 'RTE', 'RUN', 'SPG', 'SPUR', 'SQ', 'STRA', 'ST', 'SMT', 'TER', 'TRAK', 'TRL', 'VLY', 'VW', 'VIS', 'WALK', 'WAY'];
// --- Input Processing ---
//var dir = Text($feature[INPUT_DIRECTION]);
//var name = Text($feature[INPUT_STREETNAME]);
//var suffix = Text($feature[INPUT_SUFFIX]);
// 1) Presence checks
if (IsEmpty(INPUT_STREETNAME)) { return false; } // StreetName required
// 2) Whitelist checks
function inListOrEmpty(v, lst){
if (IsEmpty(v) || v == '') return true;
return IndexOf(lst, Upper(Trim(v))) > -1;
}
if (!inListOrEmpty(INPUT_DIRECTION, allowedDirs)) { return false; }
if (!inListOrEmpty(INPUT_SUFFIX, allowedTypes)) { return false; }
// 3) Master lookup: compare in Arcade (case-insensitive)
var masterFS = FeatureSetByName($datastore, MASTER_TABLE, [MASTER_DIRECTION, MASTER_STREETNAME, MASTER_SUFFIX], false);
if (IsEmpty(masterFS) || Count(masterFS) == 0) { return false; }
var tName = Upper(Trim(INPUT_STREETNAME));
var tDir = Upper(Trim(INPUT_DIRECTION));
var tSuffix = Upper(Trim(INPUT_SUFFIX));
for (var m in masterFS) {
var mName = Upper(Trim(Text(m[MASTER_STREETNAME])));
var mDir = Upper(Trim(DefaultValue(m[MASTER_DIRECTION], '')));
var mSuffix = Upper(Trim(DefaultValue(m[MASTER_SUFFIX], '')));
// Logic: Name must match; Dir/Suffix optional but must match if present
var nameOK = mName == tName;
var dirOK = IsEmpty(tDir) || tDir == mDir;
var suffixOK = IsEmpty(tSuffix) || tSuffix == mSuffix;
if (nameOK && dirOK && suffixOK) {
return true;
}
}
// No valid match found
return false;</expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>10010</error_number><error_message>Street Validation Error. Invalid street components. Street Name must exist in Addresser View Data (data is from Accela, SCL Street Centerline and recently added Streets temp table). Direction must use approved abbreviations and match the master. Street Suffix must use approved abbreviations and match the master.</error_message><rule_description>Street Name Validation Pin Drop data</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><batch>True</batch><severity>5</severity><tags>PinDrop</tags><category>-1</category></AddAttributeRule></workflow></operationSequence>"
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/3.5.0'><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>StreetNameValidation_PinDrop</rule_name><rule_type>VALIDATION</rule_type><expression>// --- Configuration ---
var INPUT_DIRECTION = 'Direction'; // Replace with actual field name if needed
var INPUT_STREETNAME = 'StreetName';
var INPUT_SUFFIX = 'StreetType';
var MASTER_TABLE = 'prdgis.dbo.vwAddressorData';
var MASTER_DIRECTION = 'Direction';
var MASTER_STREETNAME = 'StreetName';
var MASTER_SUFFIX = 'StreetSuffix';
// Allowed directionals (adjust if needed)
var allowedDirs = ['N', 'S', 'E', 'W'];
// Allowed street suffix codes
var allowedTypes = ['ALY', 'ANX', 'AVE', 'BND', 'BLF', 'BLVD', 'BRK', 'BYP', 'CYN', 'CIR', 'CT', 'CV', 'CRK', 'CRES', 'CRST', 'XING', 'DR', 'EXPY', 'FRK', 'FWY', 'HTS', 'HWY', 'HL', 'JCT', 'LN', 'LOOP', 'MTN', 'PARK', 'PKWY', 'PASS', 'PATH', 'PL', 'PLZ', 'PT', 'RNCH', 'RDG', 'RD', 'RTE', 'RUN', 'SPG', 'SPUR', 'SQ', 'STRA', 'ST', 'SMT', 'TER', 'TRAK', 'TRL', 'VLY', 'VW', 'VIS', 'WALK', 'WAY'];
// --- Input Processing ---
//var dir = Text($feature[INPUT_DIRECTION]);
//var name = Text($feature[INPUT_STREETNAME]);
//var suffix = Text($feature[INPUT_SUFFIX]);
// 1) Presence checks
if (IsEmpty(INPUT_STREETNAME)) { return false; } // StreetName required
// 2) Whitelist checks
function inListOrEmpty(v, lst){
if (IsEmpty(v) || v == '') return true;
return IndexOf(lst, Upper(Trim(v))) > -1;
}
if (!inListOrEmpty(INPUT_DIRECTION, allowedDirs)) { return false; }
if (!inListOrEmpty(INPUT_SUFFIX, allowedTypes)) { return false; }
// 3) Master lookup: compare in Arcade (case-insensitive)
var masterFS = FeatureSetByName($datastore, MASTER_TABLE, [MASTER_DIRECTION, MASTER_STREETNAME, MASTER_SUFFIX], false);
if (IsEmpty(masterFS) || Count(masterFS) == 0) { return false; }
var tName = Upper(Trim(INPUT_STREETNAME));
var tDir = Upper(Trim(INPUT_DIRECTION));
var tSuffix = Upper(Trim(INPUT_SUFFIX));
for (var m in masterFS) {
var mName = Upper(Trim(Text(m[MASTER_STREETNAME])));
var mDir = Upper(Trim(DefaultValue(m[MASTER_DIRECTION], '')));
var mSuffix = Upper(Trim(DefaultValue(m[MASTER_SUFFIX], '')));
// Logic: Name must match; Dir/Suffix optional but must match if present
var nameOK = mName == tName;
var dirOK = IsEmpty(tDir) || tDir == mDir;
var suffixOK = IsEmpty(tSuffix) || tSuffix == mSuffix;
if (nameOK && dirOK && suffixOK) {
return true;
}
}
// No valid match found
return false;</expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>10010</error_number><error_message>Street Validation Error. Invalid street components. Street Name must exist in Addresser View Data (data is from Accela, SCL Street Centerline and recently added Streets temp table). Direction must use approved abbreviations and match the master. Street Suffix must use approved abbreviations and match the master.</error_message><rule_description>Street Name Validation Pin Drop data</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><batch>True</batch><severity>5</severity><tags>PinDrop</tags><category>-1</category></AddAttributeRule><DisableAttributeRules><rule_name>StreetNameValidation_PinDrop</rule_name><rule_type>VALIDATION</rule_type></DisableAttributeRules></workflow></operationSequence>"
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686a75413373523631564b702b734a556533334e774f78357455647050365262674f6c4755476b776c644c673d2a00;ENCRYPTED_PASSWORD=00022e6875346a717a2f4c6e31646557422f5a4d4c4e48454b445437784f6d4d39684b78703270335455616c3577343d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Invalid Street Name</rule_name><rule_type>CONSTRAINT</rule_type><expression>if (IsEmpty($feature.FullStreetName)) {
return true; }
var addresserStreetName = Upper($feature.FullStreetName);
var masterStreetName = FeatureSetByName($datastore, 'gismo.vwAddressorData_v2', ["FULLADDRESS"], false);
var matches = Filter(masterStreetName, "UPPER(FULLADDRESS) = @addresserStreetName");
if (Count(matches) > 0) {
return true;
} return {"errorMessage": "The address " + addresserStreetName + " does not exist in the master Street table."};</expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><error_number>1001</error_number><error_message>Street Name is not in the master Street Name table.</error_message><rule_description>Street name is not defined in the Master Road Name table</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><tags>Pin Drop</tags><category>-1</category></AddAttributeRule></workflow></operationSequence>"
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686a75413373523631564b702b734a556533334e774f78357455647050365262674f6c4755476b776c644c673d2a00;ENCRYPTED_PASSWORD=00022e6875346a717a2f4c6e31646557422f5a4d4c4e48454b445437784f6d4d39684b78703270335455616c3577343d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>FullStreetName</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>300</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686a75413373523631564b702b734a556533334e774f78357455647050365262674f6c4755476b776c644c673d2a00;ENCRYPTED_PASSWORD=00022e6875346a717a2f4c6e31646557422f5a4d4c4e48454b445437784f6d4d39684b78703270335455616c3577343d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Invalid Street Name</rule_name><rule_type>CONSTRAINT</rule_type><expression>if (IsEmpty($feature.FullStreetName)) {
return true; }
var addresserStreetName = Upper($feature.FullStreetName);
var masterStreetName = FeatureSetByName($datastore, 'gismo.vwAddressorData_v2', ["FULLADDRESS"], false);
var matches = Filter(masterStreetName, "UPPER(FULLADDRESS) = @addresserStreetName");
if (Count(matches) > 0) {
return true;
} return {"errorMessage": "The address " + addresserStreetName + " does not exist in the master Street table."};</expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><error_number>1001</error_number><error_message>Street Name is not in the master Street Name table.</error_message><rule_description>Street name is not defined in the Master Road Name table</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><tags>Pin Drop</tags><category>-1</category></AddAttributeRule></workflow></operationSequence>"
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686a75413373523631564b702b734a556533334e774f78357455647050365262674f6c4755476b776c644c673d2a00;ENCRYPTED_PASSWORD=00022e6875346a717a2f4c6e31646557422f5a4d4c4e48454b445437784f6d4d39684b78703270335455616c3577343d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Invalid Street Name</rule_name><rule_type>CONSTRAINT</rule_type><expression>if (IsEmpty($feature.FullStreetName)) {
return true; }
var addresserStreetName = Upper($feature.FullStreetName);
var masterStreetName = FeatureSetByName($datastore, 'gismo.vwAddressorData_v2', ["FULLADDRESS"], false);
var matches = Filter(masterStreetName, "UPPER(FULLADDRESS) = @addresserStreetName");
if (Count(matches) > 0) {
return true;
} return {"errorMessage": "The address " + addresserStreetName + " does not exist in the master Street table."};</expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><error_number>1001</error_number><error_message>Street Name is not in the master Street Name table.</error_message><rule_description>Street name is not defined in the Master Road Name table</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><tags>Pin Drop</tags><category>-1</category></AddAttributeRule></workflow></operationSequence>"
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686a75413373523631564b702b734a556533334e774f78357455647050365262674f6c4755476b776c644c673d2a00;ENCRYPTED_PASSWORD=00022e6875346a717a2f4c6e31646557422f5a4d4c4e48454b445437784f6d4d39684b78703270335455616c3577343d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate Full Street Name (edit)</rule_name><rule_type>CALCULATION</rule_type><expression>// This rule will calculate the full road name for the master road table by concatenating several other field values // Define the full name field
var fullname_field = "FullStreetName";
// Specify the fields to concatenate
var values = [$feature.Direction, $feature.StreetName, $feature.StreetType];
if (!HasKey($feature, fullname_field)) return;
var combined_value = [];
// Loop through the field values and test if they are null or empty strings
// If they are not null or empty add them to an array
for (var i in values) {
var value = values[i];
if (IsEmpty(value)) continue;
combined_value[Count(combined_value)] = value
}
// Return the field values concatenated with a space between
return {
"result": {
"attributes": Dictionary(fullname_field, Concatenate(combined_value, " ")) }
}</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 the full road name for the master road table by concatenating several other field values</rule_description><field_name>FullStreetName</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><tags>Pin Drop</tags><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate Full Street Name (edit)</rule_name><evaluation_order>4</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686a75413373523631564b702b734a556533334e774f78357455647050365262674f6c4755476b776c644c673d2a00;ENCRYPTED_PASSWORD=00022e6875346a717a2f4c6e31646557422f5a4d4c4e48454b445437784f6d4d39684b78703270335455616c3577343d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Calculate Full Street Name (edit)</rule_name><rule_description>Calculates the full road name for the master road table by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><tags>Pin Drop</tags><severity>-1</severity><expression>// This rule will calculate the full road name for the master road table by concatenating several other field values // Define the full name field
var fullname_field = "FullStreetName";
// Specify the fields to concatenate
var values = [$feature.Direction, $feature.StreetName, $feature.StreetType];
if (!HasKey($feature, fullname_field)) return;
var combined_value = [];
// Loop through the field values and test if they are null or empty strings
// If they are not null or empty add them to an array
for (var i in values) {
var value = values[i];
if (IsEmpty(value)) continue;
combined_value[Count(combined_value)] = value
}
// Return the field values concatenated with a space between
return {
"result": {
"attributes": Dictionary(fullname_field, Concatenate(combined_value, " ")) }
}</expression><category>-1</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>"
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686a75413373523631564b702b734a556533334e774f78357455647050365262674f6c4755476b776c644c673d2a00;ENCRYPTED_PASSWORD=00022e6875346a717a2f4c6e31646557422f5a4d4c4e48454b445437784f6d4d39684b78703270335455616c3577343d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Calculate Full Street Name (edit)</rule_name><rule_description>Calculates the full road name for the master road table by concatenating several other field values</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><tags>Pin Drop</tags><severity>-1</severity><expression>// This rule will calculate the full road name for the master road table by concatenating several other field values // Define the full name field
var fullname_field = "FullStreetName";
// Specify the fields to concatenate
var values = [$feature.Direction, $feature.StreetName, $feature.StreetType];
if (!HasKey($feature, fullname_field)) return;
var combined_value = [];
// Loop through the field values and test if they are null or empty strings
// If they are not null or empty add them to an array
for (var i in values) {
var value = values[i];
if (IsEmpty(value)) continue;
combined_value[Count(combined_value)] = value
}
// Return the field values concatenated with a space between
return {
"result": {
"attributes": Dictionary(fullname_field, Concatenate(combined_value, " ")) }
}</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>"
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686a75413373523631564b702b734a556533334e774f78357455647050365262674f6c4755476b776c644c673d2a00;ENCRYPTED_PASSWORD=00022e6875346a717a2f4c6e31646557422f5a4d4c4e48454b445437784f6d4d39684b78703270335455616c3577343d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Invalid Street Name</rule_name><rule_description>Street name is not defined in the Master Road Name table</rule_description><error_number>1001</error_number><error_message>Street Name is not in the master Street Name table.</error_message><exclude_from_client_eval>True</exclude_from_client_eval><tags>Pin Drop</tags><severity>-1</severity><expression>if (IsEmpty($feature.FullStreetName)) {
return true; }
var addresserStreetName = Upper($feature.FullStreetName);
var masterStreetName = FeatureSetByName($datastore, 'prdgis.gismo.vwAddressorData_v2', ["FULLADDRESS"], false);
var matches = Filter(masterStreetName, "UPPER(FULLADDRESS) = @addresserStreetName");
if (Count(matches) > 0) {
return true;
} return {"errorMessage": "The address " + addresserStreetName + " does not exist in the master Street table."};</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>"
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686a75413373523631564b702b734a556533334e774f78357455647050365262674f6c4755476b776c644c673d2a00;ENCRYPTED_PASSWORD=00022e6875346a717a2f4c6e31646557422f5a4d4c4e48454b445437784f6d4d39684b78703270335455616c3577343d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Invalid Street Name</rule_name><rule_description>Street name is not defined in the Master Road Name table</rule_description><error_number>1001</error_number><error_message>Street Name is not in the master Street Name table.</error_message><exclude_from_client_eval>True</exclude_from_client_eval><tags>Pin Drop</tags><severity>-1</severity><expression>if (IsEmpty($feature.FullStreetName)) {
return true; }
var addresserStreetName = Upper($feature.FullStreetName);
var masterStreetName = FeatureSetByName($datastore, 'prdgis.gismo.vwAddressorData_v2', ["FULLADDRESS"], false);
var matches = Filter(masterStreetName, "UPPER(FULLADDRESS) = @addresserStreetName");
if (Count(matches) > 0) {
return true;
} return {"errorMessage": "The address " + addresserStreetName + " does not exist in the master Street table."};</expression><category>4294967295</category><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>"
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686a75413373523631564b702b734a556533334e774f78357455647050365262674f6c4755476b776c644c673d2a00;ENCRYPTED_PASSWORD=00022e6875346a717a2f4c6e31646557422f5a4d4c4e48454b445437784f6d4d39684b78703270335455616c3577343d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.addresserData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>Direction</field_name><domain_name>ST_Direction</domain_name></AssignDomainToField></workflow></operationSequence>
Clark County
Addresser 'Pin Drop' data
addresserData
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACikqrazvcB3KMiZw
odSre+QaV0tALdFFFMAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKK
ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA
KKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAo
oooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii
igAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKK
ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA
KKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAo
oooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii
igAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKK
ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA
KKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAo
oooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii
igAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAP/Z