20221122 16184700 1.0 FALSE CreateFeatureclass N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde CodePropertyViolationSurvey2022_pt Point C:\Users\cssims\Downloads\Address_Points_Example\Address_Points_Example.gdb\Address_Points_Example No No "PROJCS["NAD_1983_StatePlane_Kansas_North_FIPS_1501_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["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1312333.333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-98.0],PARAMETER["Standard_Parallel_1",38.71666666666667],PARAMETER["Standard_Parallel_2",39.78333333333333],PARAMETER["Latitude_Of_Origin",38.33333333333334],UNIT["Foot_US",0.3048006096012192]];-120389200 -95723100 3048.00609601219;-100000 10000;-100000 10000;3.28083333333333E-03;0.001;0.001;IsHighPrecision" # 0 0 0 # Append 'gisJOCO.DL.Address_joco_pt selection' gispub.DL.CodePropertyViolationSurvey2022_pt "Use the field map to reconcile field differences" "siteaddress "Site Address" true true false 256 Text 0 0,First,#,gisJOCO.DL.Address_joco_pt selection,MailAddLine,0,100;taxpropid "TaxPropID" true true false 16 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gisJOCO_dl.sde\gisJOCO.DL.Address_joco_pt,TaxPropID,0,16" # # UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e685a6f4f51744c3770307567377a315045466670586337496e4f6a6b346d2f33697844304d4b346d485975773d2a00;SERVER=gisdbprod;INSTANCE=sde:sqlserver:gisdbprod;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdbprod;DATABASE=gispub;USER=dl;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gispub.DL.CodePropertyViolationSurvey2022_pt</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>violationfound</field_name><domain_name>CodePropertyViolations</domain_name></AssignDomainToField><AssignDefaultToField><field_name>violationfound</field_name><default_value>0</default_value></AssignDefaultToField></workflow><workflow><AssignDomainToField><field_name>inspectionstatus</field_name><domain_name>CodePropertyViolations</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>v_premid</field_name><domain_name>CodePropertyViolations</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>v_wall_and_trim</field_name><domain_name>CodePropertyViolations</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>v_exterior_openings</field_name><domain_name>CodePropertyViolations</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>v_roof_gutter</field_name><domain_name>CodePropertyViolations</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>v_stair_deck_porch_balcony</field_name><domain_name>CodePropertyViolations</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>v_accessory_structures</field_name><domain_name>CodePropertyViolations</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>v_exterior_storage</field_name><domain_name>CodePropertyViolations</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>v_pavements</field_name><domain_name>CodePropertyViolations</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>v_vehicles</field_name><domain_name>CodePropertyViolations</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>v_trash_placement</field_name><domain_name>CodePropertyViolations</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>v_trees_shrubs</field_name><domain_name>CodePropertyViolations</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>v_grass_weeds</field_name><domain_name>CodePropertyViolations</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>v_nuisance</field_name><domain_name>CodePropertyViolations</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>v_other</field_name><domain_name>CodePropertyViolations</domain_name></AssignDomainToField><AssignDefaultToField><field_name>v_other</field_name><clear_value>True</clear_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/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686463754e424f55433859667231516d54676f2f694a4e4e52797863493148504c524b54346d3170483874773d2a00;SERVER=gisdbprod;INSTANCE=sde:sqlserver:gisdbprod;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdbprod;DATABASE=gispub;USER=dl;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gispub.DL.CodePropertyViolationSurvey2022_pt</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Ward</field_name><field_type>SHORT</field_type><field_precision>5</field_precision><field_alias>Ward</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> TruncateTable gispub.DL.CodePropertyViolationSurvey2022_pt Append residential_LU_pts gispub.DL.CodePropertyViolationSurvey2022_pt "Use the field map to reconcile field differences" "globalid "globalid" false false true 38 GlobalID 0 0,First,#;created_date "created_date" true true false 8 Date 0 0,First,#;created_user "created_user" true true false 255 Text 0 0,First,#;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#;siteaddress "Site Address" true true false 256 Text 0 0,First,#,residential_LU_pts,MailAddLine,0,100;taxpropid "TaxPropID" true true false 16 Text 0 0,First,#,N:\projects\neighborhood_conservation\2022\CodeViolationsApplication\ViolationsDataset.gdb\residential_LU_pts,TaxPropID,0,16;lbcsfunction "LBCS Function" true true false 20 Text 0 0,First,#;lbcsfundsc "LBCS Function Description" true true false 60 Text 0 0,First,#;dwellingunits "# of Dwelling Units" true true false 4 Long 0 10,First,#;yearbuilt "Year Built" true true false 4 Long 0 10,First,#;propidurl "JOCO Mapping Link" true true false 256 Text 0 0,First,#;violationfound "Violation Found" true true false 4 Long 0 10,First,#;inspectionstatus "Inspection Status" true true false 4 Long 0 10,First,#;v_premid "Premise Identification Violation" true true false 4 Long 0 10,First,#;v_wall_and_trim "Exterior Wall & Trim Violation" true true false 4 Long 0 10,First,#;v_exterior_openings "Exterior Openings Violations" true true false 4 Long 0 10,First,#;v_roof_gutter "Roofing & Gutter Violations" true true false 4 Long 0 10,First,#;v_stair_deck_porch_balcony "Stairway, Deck, Porch. Balcony Violation" true true false 4 Long 0 10,First,#;v_accessory_structures "Accessory Structures Violation" true true false 4 Long 0 10,First,#;v_exterior_storage "Exterior Item Storage Violation" true true false 4 Long 0 10,First,#;v_pavements "Hard Surface, Walks, and Drives Violation" true true false 4 Long 0 10,First,#;v_vehicles "Vehicle Violation" true true false 4 Long 0 10,First,#;v_trash_placement "Trash Can Placement/Storage Violation" true true false 4 Long 0 10,First,#;v_trees_shrubs "Tree and Shrub Violation" true true false 4 Long 0 10,First,#;v_grass_weeds "Tall Grass and Weeds Violation" true true false 4 Long 0 10,First,#;v_nuisance "Nuisance Violation" true true false 4 Long 0 10,First,#;v_other "Other Violation" true true false 4 Long 0 10,First,#;notes "Notes" true true false 256 Text 0 0,First,#;code_compliance_district "Code Compliance District" true true false 4 Long 0 10,First,#;neightborhood "Neighborhood" true true false 36 Text 0 0,First,#;energov_violations "EnerGov Violations" true true false 8 Double 8 38,First,#;v_total "Total Violations" true true false 4 Long 0 10,First,#;Ward "Ward" true true false 0 Short 0 5,First,#" # # UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686463754e424f55433859667231516d54676f2f694a4e4e52797863493148504c524b54346d3170483874773d2a00;SERVER=gisdbprod;INSTANCE=sde:sqlserver:gisdbprod;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdbprod;DATABASE=gispub;USER=dl;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gispub.DL.CodePropertyViolationSurvey2022_pt</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><EnableAttachments /></workflow><workflow><EnableEditorTracking><creator_field>created_user</creator_field><creation_date_field>created_date</creation_date_field><last_editor_field>last_edited_user</last_editor_field><last_edit_date_field>last_edited_date</last_edit_date_field><add_fields>TRUE</add_fields><record_dates_in>DATABASE_TIME</record_dates_in></EnableEditorTracking></workflow></operationSequence>" CalculateField "Code Property Violation Survey" inspectionstatus 0 "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/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6858436a6b5a4b6b41716a7a453977756e674b2b4c5441366f625549304a7866667533664f586f61797230593d2a00;SERVER=gisdbprod;INSTANCE=sde:sqlserver:gisdbprod;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdbprod;DATABASE=gispub;USER=dl;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gispub.DL.CodePropertyViolationSurvey2022_pt</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>n_premid</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_wall_and_trim</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_exterior_openings</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_roof_gutter</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_stair_deck_porch_balcony</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_accessory_structures</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_exterior_storage</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_pavements</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_vehicles</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_trash_placement</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_trees_shrubs</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_grass_weeds</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_nuisance</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_other</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><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/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6858436a6b5a4b6b41716a7a453977756e674b2b4c5441366f625549304a7866667533664f586f61797230593d2a00;SERVER=gisdbprod;INSTANCE=sde:sqlserver:gisdbprod;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdbprod;DATABASE=gispub;USER=dl;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gispub.DL.CodePropertyViolationSurvey2022_pt</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>n_premid</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_wall_and_trim</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_exterior_openings</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_roof_gutter</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_stair_deck_porch_balcony</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_accessory_structures</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_exterior_storage</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_pavements</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_vehicles</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_trash_placement</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_trees_shrubs</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_grass_weeds</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_nuisance</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_other</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Violation Notes</field_alias><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/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686463754e424f55433859667231516d54676f2f694a4e4e52797863493148504c524b54346d3170483874773d2a00;SERVER=gisdbprod;INSTANCE=sde:sqlserver:gisdbprod;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdbprod;DATABASE=gispub;USER=dl;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gispub.DL.CodePropertyViolationSurvey2022_pt</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>n_premid</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Premise Identification Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_wall_and_trim</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Exterior Wall &amp; Trim Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_exterior_openings</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Exterior Openings Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_roof_gutter</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Roofing &amp; Gutter Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_stair_deck_porch_balcony</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Stairway, Deck, Porch. Balcony Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_accessory_structures</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Accessory Structures Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_exterior_storage</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Exterior Item Storage Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_pavements</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Hard Surface, Walks, and Drives Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_vehicles</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Vehicle Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_trash_placement</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Trash Can Placement/Storage Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_trees_shrubs</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Tree and Shrub Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_grass_weeds</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Tall Grass and Weeds Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_nuisance</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Nuisance Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_other</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Other Notes</field_alias><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/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686463754e424f55433859667231516d54676f2f694a4e4e52797863493148504c524b54346d3170483874773d2a00;SERVER=gisdbprod;INSTANCE=sde:sqlserver:gisdbprod;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdbprod;DATABASE=gispub;USER=dl;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gispub.DL.CodePropertyViolationSurvey2022_pt</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>n_premid</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Premise Identification Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_wall_and_trim</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Exterior Wall &amp; Trim Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_exterior_openings</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Exterior Openings Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_roof_gutter</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Roofing &amp; Gutter Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_stair_deck_porch_balcony</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Stairway, Deck, Porch. Balcony Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_accessory_structures</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Accessory Structures Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_exterior_storage</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Exterior Item Storage Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_pavements</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Hard Surface, Walks, and Drives Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_vehicles</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Vehicle Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_trash_placement</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Trash Can Placement/Storage Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_trees_shrubs</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Tree and Shrub Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_grass_weeds</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Tall Grass and Weeds Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_nuisance</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Nuisance Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_other</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Other Notes</field_alias><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/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686463754e424f55433859667231516d54676f2f694a4e4e52797863493148504c524b54346d3170483874773d2a00;SERVER=gisdbprod;INSTANCE=sde:sqlserver:gisdbprod;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdbprod;DATABASE=gispub;USER=dl;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gispub.DL.CodePropertyViolationSurvey2022_pt</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>v_other</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/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686463754e424f55433859667231516d54676f2f694a4e4e52797863493148504c524b54346d3170483874773d2a00;SERVER=gisdbprod;INSTANCE=sde:sqlserver:gisdbprod;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdbprod;DATABASE=gispub;USER=dl;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gispub.DL.CodePropertyViolationSurvey2022_pt</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>v_RV_boat_trailer</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>RV, Boat, and Trailer Violation</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>v_commercial_vehicle</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Commercial Vehicle Violation</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>n_RV_boat_trailer</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>RV, Boat, and Trailer Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_commercial_vehicle</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Commercial Vehicle Notes</field_alias><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/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686463754e424f55433859667231516d54676f2f694a4e4e52797863493148504c524b54346d3170483874773d2a00;SERVER=gisdbprod;INSTANCE=sde:sqlserver:gisdbprod;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdbprod;DATABASE=gispub;USER=dl;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gispub.DL.CodePropertyViolationSurvey2022_pt</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>v_RV_boat_trailer</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>RV, Boat, and Trailer Violation</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>v_commercial_vehicle</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Commercial Vehicle Violation</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>n_RV_boat_trailer</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>RV, Boat, and Trailer Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>n_commercial_vehicle</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>256</field_length><field_alias>Commercial Vehicle Notes</field_alias><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/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686463754e424f55433859667231516d54676f2f694a4e4e52797863493148504c524b54346d3170483874773d2a00;SERVER=gisdbprod;INSTANCE=sde:sqlserver:gisdbprod;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdbprod;DATABASE=gispub;USER=dl;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gispub.DL.CodePropertyViolationSurvey2022_pt</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>v_other</field_name><default_value>1</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/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686463754e424f55433859667231516d54676f2f694a4e4e52797863493148504c524b54346d3170483874773d2a00;SERVER=gisdbprod;INSTANCE=sde:sqlserver:gisdbprod;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdbprod;DATABASE=gispub;USER=dl;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gispub.DL.CodePropertyViolationSurvey2022_pt</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>v_other</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/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686463754e424f55433859667231516d54676f2f694a4e4e52797863493148504c524b54346d3170483874773d2a00;SERVER=gisdbprod;INSTANCE=sde:sqlserver:gisdbprod;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdbprod;DATABASE=gispub;USER=dl;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gispub.DL.CodePropertyViolationSurvey2022_pt</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>m_premid</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_wall_and_trim</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_exterior_openings</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_roof_gutter</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_stair_deck_porch_balcony</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_accessory_stuctures</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_exterior_storage</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_pavements</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_vehicles</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_trash_placement</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_trees_shrubs</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_grass_weeds</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_nuisance</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_other</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_RV_boat_trailer</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_commercial_vehicle</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_total</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Total Minor</field_alias><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/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686463754e424f55433859667231516d54676f2f694a4e4e52797863493148504c524b54346d3170483874773d2a00;SERVER=gisdbprod;INSTANCE=sde:sqlserver:gisdbprod;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdbprod;DATABASE=gispub;USER=dl;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gispub.DL.CodePropertyViolationSurvey2022_pt</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>m_premid</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_wall_and_trim</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_exterior_openings</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_roof_gutter</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_stair_deck_porch_balcony</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_accessory_stuctures</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_exterior_storage</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_pavements</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_vehicles</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_trash_placement</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_trees_shrubs</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_grass_weeds</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_nuisance</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_other</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_RV_boat_trailer</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_commercial_vehicle</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_total</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Total Minor</field_alias><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/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686463754e424f55433859667231516d54676f2f694a4e4e52797863493148504c524b54346d3170483874773d2a00;SERVER=gisdbprod;INSTANCE=sde:sqlserver:gisdbprod;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdbprod;DATABASE=gispub;USER=dl;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gispub.DL.CodePropertyViolationSurvey2022_pt</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>m_premid</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_wall_and_trim</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_exterior_openings</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_roof_gutter</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_stair_deck_porch_balcony</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_accessory_stuctures</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_exterior_storage</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_pavements</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_vehicles</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_trash_placement</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_trees_shrubs</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_grass_weeds</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_nuisance</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_other</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_RV_boat_trailer</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_commercial_vehicle</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CodePropertyViolations</field_domain><field_default_value>0</field_default_value></AddField></workflow><workflow><AddField><field_name>m_total</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Total Minor</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>" CalculateFields gispub.DL.CodePropertyViolationSurvey2022_pt "Python 3" "m_premid 0;m_wall_and_trim 0;m_exterior_openings 0;m_roof_gutter 0;m_stair_deck_porch_balcony 0;m_accessory_stuctures 0;m_exterior_storage 0;m_pavements 0;m_vehicles 0;m_trash_placement 0;m_trees_shrubs 0;m_grass_weeds 0;m_nuisance 0;m_other 0;m_RV_boat_trailer 0;m_commercial_vehicle 0" # 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/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686463754e424f55433859667231516d54676f2f694a4e4e52797863493148504c524b54346d3170483874773d2a00;SERVER=gisdbprod;INSTANCE=sde:sqlserver:gisdbprod;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdbprod;DATABASE=gispub;USER=dl;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gispub.DL.CodePropertyViolationSurvey2022_pt</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>Code_Officer_Name</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>75</field_length><field_alias>Code Officer Name</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>" FeatureClassToFeatureClass N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde CodePropertyViolationSurvey2023_pt # "globalid "globalid" false false true 38 GlobalID 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,globalid,-1,-1;created_date "created_date" false true false 8 Date 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,created_date,-1,-1;created_user "created_user" false true false 255 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,created_user,0,255;last_edited_date "last_edited_date" false true false 8 Date 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,last_edited_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,last_edited_user,0,255;siteaddress "Site Address" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,siteaddress,0,256;taxpropid "TaxPropID" true true false 16 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,taxpropid,0,16;lbcsfunction "LBCS Function" true true false 20 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,lbcsfunction,0,20;lbcsfundsc "LBCS Function Description" true true false 60 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,lbcsfundsc,0,60;dwellingunits "# of Dwelling Units" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,dwellingunits,-1,-1;yearbuilt "Year Built" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,yearbuilt,-1,-1;propidurl "JOCO Mapping Link" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,propidurl,0,256;violationfound "Violation Found" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,violationfound,-1,-1;inspectionstatus "Inspection Status" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,inspectionstatus,-1,-1;v_premid "Premise Identification Violation" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,v_premid,-1,-1;v_wall_and_trim "Exterior Wall & Trim Violation" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,v_wall_and_trim,-1,-1;v_exterior_openings "Exterior Openings Violations" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,v_exterior_openings,-1,-1;v_roof_gutter "Roofing & Gutter Violations" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,v_roof_gutter,-1,-1;v_stair_deck_porch_balcony "Stairway, Deck, Porch. Balcony Violation" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,v_stair_deck_porch_balcony,-1,-1;v_accessory_structures "Accessory Structures Violation" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,v_accessory_structures,-1,-1;v_exterior_storage "Exterior Item Storage Violation" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,v_exterior_storage,-1,-1;v_pavements "Hard Surface, Walks, and Drives Violation" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,v_pavements,-1,-1;v_vehicles "Vehicle Violation" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,v_vehicles,-1,-1;v_trash_placement "Trash Can Placement/Storage Violation" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,v_trash_placement,-1,-1;v_trees_shrubs "Tree and Shrub Violation" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,v_trees_shrubs,-1,-1;v_grass_weeds "Tall Grass and Weeds Violation" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,v_grass_weeds,-1,-1;v_nuisance "Nuisance Violation" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,v_nuisance,-1,-1;v_other "Other Violation" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,v_other,-1,-1;notes "Notes" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,notes,0,256;code_compliance_district "Code Compliance District" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,code_compliance_district,-1,-1;neightborhood "Neighborhood" true true false 36 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,neightborhood,0,36;energov_violations "EnerGov Violations" true true false 8 Double 8 38,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,energov_violations,-1,-1;v_total "Total Violations" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,v_total,-1,-1;Ward "Ward" true true false 2 Short 0 5,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,Ward,-1,-1;n_premid "Premise Identification Notes" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,n_premid,0,256;n_wall_and_trim "Exterior Wall & Trim Notes" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,n_wall_and_trim,0,256;n_exterior_openings "Exterior Openings Notes" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,n_exterior_openings,0,256;n_roof_gutter "Roofing & Gutter Notes" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,n_roof_gutter,0,256;n_stair_deck_porch_balcony "Stairway, Deck, Porch. Balcony Notes" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,n_stair_deck_porch_balcony,0,256;n_accessory_structures "Accessory Structures Notes" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,n_accessory_structures,0,256;n_exterior_storage "Exterior Item Storage Notes" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,n_exterior_storage,0,256;n_pavements "Hard Surface, Walks, and Drives Notes" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,n_pavements,0,256;n_vehicles "Vehicle Notes" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,n_vehicles,0,256;n_trash_placement "Trash Can Placement/Storage Notes" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,n_trash_placement,0,256;n_trees_shrubs "Tree and Shrub Notes" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,n_trees_shrubs,0,256;n_grass_weeds "Tall Grass and Weeds Notes" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,n_grass_weeds,0,256;n_nuisance "Nuisance Notes" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,n_nuisance,0,256;n_other "Other Notes" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,n_other,0,256;v_RV_boat_trailer "RV, Boat, and Trailer Violation" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,v_RV_boat_trailer,-1,-1;v_commercial_vehicle "Commercial Vehicle Violation" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,v_commercial_vehicle,-1,-1;n_RV_boat_trailer "RV, Boat, and Trailer Notes" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,n_RV_boat_trailer,0,256;n_commercial_vehicle "Commercial Vehicle Notes" true true false 256 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,n_commercial_vehicle,0,256;m_premid "Minor" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,m_premid,-1,-1;m_wall_and_trim "Minor" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,m_wall_and_trim,-1,-1;m_exterior_openings "Minor" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,m_exterior_openings,-1,-1;m_roof_gutter "Minor" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,m_roof_gutter,-1,-1;m_stair_deck_porch_balcony "Minor" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,m_stair_deck_porch_balcony,-1,-1;m_accessory_stuctures "Minor" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,m_accessory_stuctures,-1,-1;m_exterior_storage "Minor" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,m_exterior_storage,-1,-1;m_pavements "Minor" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,m_pavements,-1,-1;m_vehicles "Minor" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,m_vehicles,-1,-1;m_trash_placement "Minor" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,m_trash_placement,-1,-1;m_trees_shrubs "Minor" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,m_trees_shrubs,-1,-1;m_grass_weeds "Minor" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,m_grass_weeds,-1,-1;m_nuisance "Minor" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,m_nuisance,-1,-1;m_other "Minor" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,m_other,-1,-1;m_RV_boat_trailer "Minor" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,m_RV_boat_trailer,-1,-1;m_commercial_vehicle "Minor" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,m_commercial_vehicle,-1,-1;m_total "Total Minor" true true false 4 Long 0 10,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,m_total,-1,-1;Code_Officer_Name "Code Officer Name" true true false 75 Text 0 0,First,#,N:\DatabaseConnections\GISStaff\gisdbprod\gisdbprod_gispub_dl.sde\gispub.DL.CodePropertyViolationSurvey2022_pt,Code_Officer_Name,0,75" # CalculateField gispub.DL.CodePropertyViolationSurvey2023_pt violationfound 0 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField gispub.DL.CodePropertyViolationSurvey2023_pt inspectionstatus 0 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField gispub.DL.CodePropertyViolationSurvey2023_pt v_premid 0 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField gispub.DL.CodePropertyViolationSurvey2023_pt v_wall_and_trim 0 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateFields gispub.DL.CodePropertyViolationSurvey2023_pt "Python 3" "v_exterior_openings 0;v_roof_gutter 0;v_stair_deck_porch_balcony 0;v_accessory_structures 0;v_exterior_storage 0;v_pavements 0;v_vehicles 0;v_trash_placement 0;v_trees_shrubs 0;v_grass_weeds 0;v_nuisance 0;v_other 0;v_total 0;v_RV_boat_trailer 0;v_commercial_vehicle 0;m_premid 0;m_wall_and_trim 0;m_exterior_openings 0;m_roof_gutter 0;m_stair_deck_porch_balcony 0;m_accessory_stuctures 0;m_exterior_storage 0;m_pavements 0;m_vehicles 0;m_trash_placement 0;m_trees_shrubs 0;m_grass_weeds 0;m_nuisance 0;m_other 0;m_RV_boat_trailer 0;m_commercial_vehicle 0;m_total 0" # NO_ENFORCE_DOMAINS CalculateFields gispub.DL.CodePropertyViolationSurvey2023_pt "Python 3" "n_premid None;n_wall_and_trim None;n_exterior_openings None;n_roof_gutter None;n_stair_deck_porch_balcony None;v_accessory_structures None;n_exterior_storage None;n_pavements None;n_vehicles None;n_trash_placement None;n_trees_shrubs None;n_grass_weeds None;n_nuisance None;n_other None;n_RV_boat_trailer None;n_commercial_vehicle None" # NO_ENFORCE_DOMAINS CalculateField gispub.DL.CodePropertyViolationSurvey2023_pt Code_Officer_Name None "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/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686463754e424f55433859667231516d54676f2f694a4e4e52797863493148504c524b54346d3170483874773d2a00;SERVER=gisdbprod;INSTANCE=sde:sqlserver:gisdbprod;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdbprod;DATABASE=gispub;USER=dl;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gispub.DL.CodePropertyViolationSurvey2023_pt</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><EnableEditorTracking><creator_field>created_user</creator_field><creation_date_field>created_date</creation_date_field><last_editor_field>last_edited_user</last_editor_field><last_edit_date_field>last_edited_date</last_edit_date_field><add_fields>TRUE</add_fields><record_dates_in>DATABASE_TIME</record_dates_in></EnableEditorTracking></workflow></operationSequence> gispub.DL.CodePropertyViolationSurvey2023_pt 002 Server=gisdbprod; Service=sde:sqlserver:gisdbprod; Database=gispub; User=dl; Version=sde.DEFAULT ArcSDE Connection Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_StatePlane_Kansas_North_FIPS_1501_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/2.9.0'><WKT>PROJCS[&quot;NAD_1983_StatePlane_Kansas_North_FIPS_1501_Feet&quot;,GEOGCS[&quot;GCS_North_American_1983&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Lambert_Conformal_Conic&quot;],PARAMETER[&quot;False_Easting&quot;,1312333.333333333],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-98.0],PARAMETER[&quot;Standard_Parallel_1&quot;,38.71666666666667],PARAMETER[&quot;Standard_Parallel_2&quot;,39.78333333333333],PARAMETER[&quot;Latitude_Of_Origin&quot;,38.33333333333334],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,3419]]</WKT><XOrigin>-120389200</XOrigin><YOrigin>-95723100</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>102677</WKID><LatestWKID>3419</LatestWKID></ProjectedCoordinateSystem> 20230130 16005700 20230130 16005700 Microsoft Windows 10 Version 10.0 (Build 19044) ; Esri ArcGIS 12.9.4.32739 Code Property Violation Survey OP Codes Community Services Survey Field Maps Code Property Violation Survey Enterprise Geodatabase Feature Class dataset EPSG 8.2.10(9.3.0.0) 0 Simple FALSE 0 TRUE FALSE gispub.DL.CodePropertyViolationSurvey2023_pt Feature Class 0 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. globalid globalid GlobalID 38 0 0 created_date created_date Date 8 0 0 created_user created_user String 255 0 0 last_edited_date last_edited_date Date 8 0 0 last_edited_user last_edited_user String 255 0 0 siteaddress Site Address String 256 0 0 taxpropid TaxPropID String 16 0 0 lbcsfunction LBCS Function String 20 0 0 lbcsfundsc LBCS Function Description String 60 0 0 dwellingunits # of Dwelling Units Integer 4 10 0 yearbuilt Year Built Integer 4 10 0 propidurl JOCO Mapping Link String 256 0 0 violationfound Violation Found Integer 4 10 0 inspectionstatus Inspection Status Integer 4 10 0 v_premid Premise Identification Violation Integer 4 10 0 v_wall_and_trim Exterior Wall & Trim Violation Integer 4 10 0 v_exterior_openings Exterior Openings Violations Integer 4 10 0 v_roof_gutter Roofing & Gutter Violations Integer 4 10 0 v_stair_deck_porch_balcony Stairway, Deck, Porch. Balcony Violation Integer 4 10 0 v_accessory_structures Accessory Structures Violation Integer 4 10 0 v_exterior_storage Exterior Item Storage Violation Integer 4 10 0 v_pavements Hard Surface, Walks, and Drives Violation Integer 4 10 0 v_vehicles Vehicle Violation Integer 4 10 0 v_trash_placement Trash Can Placement/Storage Violation Integer 4 10 0 v_trees_shrubs Tree and Shrub Violation Integer 4 10 0 v_grass_weeds Tall Grass and Weeds Violation Integer 4 10 0 v_nuisance Nuisance Violation Integer 4 10 0 v_other Other Violation Integer 4 10 0 notes Notes String 256 0 0 code_compliance_district Code Compliance District Integer 4 10 0 neightborhood Neighborhood String 36 0 0 energov_violations EnerGov Violations Double 8 38 8 v_total Total Violations Integer 4 10 0 Ward Ward SmallInteger 2 5 0 n_premid Premise Identification Notes String 256 0 0 n_wall_and_trim Exterior Wall & Trim Notes String 256 0 0 n_exterior_openings Exterior Openings Notes String 256 0 0 n_roof_gutter Roofing & Gutter Notes String 256 0 0 n_stair_deck_porch_balcony Stairway, Deck, Porch. Balcony Notes String 256 0 0 n_accessory_structures Accessory Structures Notes String 256 0 0 n_exterior_storage Exterior Item Storage Notes String 256 0 0 n_pavements Hard Surface, Walks, and Drives Notes String 256 0 0 n_vehicles Vehicle Notes String 256 0 0 n_trash_placement Trash Can Placement/Storage Notes String 256 0 0 n_trees_shrubs Tree and Shrub Notes String 256 0 0 n_grass_weeds Tall Grass and Weeds Notes String 256 0 0 n_nuisance Nuisance Notes String 256 0 0 n_other Other Notes String 256 0 0 v_RV_boat_trailer RV, Boat, and Trailer Violation Integer 4 10 0 v_commercial_vehicle Commercial Vehicle Violation Integer 4 10 0 n_RV_boat_trailer RV, Boat, and Trailer Notes String 256 0 0 n_commercial_vehicle Commercial Vehicle Notes String 256 0 0 m_premid Minor Integer 4 10 0 m_wall_and_trim Minor Integer 4 10 0 m_exterior_openings Minor Integer 4 10 0 m_roof_gutter Minor Integer 4 10 0 m_stair_deck_porch_balcony Minor Integer 4 10 0 m_accessory_stuctures Minor Integer 4 10 0 m_exterior_storage Minor Integer 4 10 0 m_pavements Minor Integer 4 10 0 m_vehicles Minor Integer 4 10 0 m_trash_placement Minor Integer 4 10 0 m_trees_shrubs Minor Integer 4 10 0 m_grass_weeds Minor Integer 4 10 0 m_nuisance Minor Integer 4 10 0 m_other Minor Integer 4 10 0 m_RV_boat_trailer Minor Integer 4 10 0 m_commercial_vehicle Minor Integer 4 10 0 m_total Total Minor Integer 4 10 0 Code_Officer_Name Code Officer Name String 75 0 0 Shape Shape Geometry 8 0 0 Feature geometry. Esri Coordinates defining the features. 20230130 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2bPzL g96k5yOKjIAKngc1NXPDqKImT6frSDd7U6itCxOfak5AA49KdSN0/GgA+b2qOGaKeWSKOeNpI/vq rAlfrUo3HopP0rH0zw3p+j61f6pbpKLm9OZdz5H4CgatZ3Nu3/4+F5zwajndY/MkdwiLklm4AFS2 /wAqvKewwKoajY2+q6bcWF0rmG4Qo+04OPY0+glvqTxyJPEskUqujDIZSCDS855PFU9J0u10PS4d Ps1cQQrtXecn8TVySSK3t3muJUiiQZZ3OAB7mkDtfQcEyeM0Ou3IJP51Tvo31DRp4LO7ERuYj5Vx Gc7c9CKg0HTrnS9It7O8vWvZ4x80zdTQOyte5pBTt6nP1oAB9c1i6T4gn1PW9R0+XS7i1S0ICTSD 5ZfpW3/F+FANNOzJrXiUj2qVubb8aitv9d+FP/5YOP8AaqkSVQox0pcD0oXpS5ApDMvVtf0zQ5bS K/n8t7p9kQxnJrXg4uF+hqpd2dlfPE93bQzNC26IuoOw+oq1Cw89ORR1B2toNYfvH+tQWl/Y33nr a3UUzwNtkCNnafQ1PIQJnBI61l6VoOmaLLdy2ECxPdPvlOc5NHUatY1KQ9RRuHqKQkEikID1P0pw 6U09fwpQwwOv5UALWT4i8TWXhq1t5ryKWQTyiJfLTOD6mtXd7H8qZKiTIElhWRQcgOoOD680DVr6 j1O7btGS3SnNE8QG4ceopI5CkqsVOBwasXTKqBB/Ec807EnN65F4jkv9OOiSQJbrLm6EoGSvtW6w wxFNEmOh/Kjd9fypFN3sgbpS00tweD+VA3YHAoESIQDzXm7/AApjEsjf8JPqI3uWxkdzXovzegow 3tRoVGUo/CyI9B9RU1Qt0/EUtxOtvFvYEj2qKacnZGKaSbZLRWUdXbPEQx7mk/td/wDnkv512fVa nYj6xDua1IRkEVmDVz3i/I1KmqxH7yMv61LwtVdBqvTfU0EYAZJxxWB4f0fUNIkvnvtZn1EXExeM SA/uh6DJP6YFbkW1wGHIPOaxdE1DXLu81CPVdNS0t4ZNtu6n/WL61ibq9nY6E/LaoP7xzXPan/wk f/CS6b9ga2Gj7D9qDj593P8A9bGPeugfm2irCtPEmn33iK80SEzfa7RQ0hKkLzjofxFDCF9Wlc1z ycVU1fSrfWdLm06+Rnt5lwwViD9auLwT9ayfFXiOHw1ZQXU1tPcCSQRhYRkjPel0CKk5JR3L2kad aaXZW2n2qbbaBQiKTk4HrmtK6RBGGAAbPFVY2DqjgEZwRnrUty374AnoOKa2E9XdkOfmxlc+nejn cM46ViL4atk8WN4gF1cGZovLMJPyfWtvILCkN26E9v8A66pB/q5P96ooP9cKmH3Zf96qRJTUDHQd aXA9KBgA896Nw9akZiaxr8+lazpthHpVzdJeNtaeP7sX14/qK2mzjjrginBwPQ/Wk3DI55zTG2rb DIiSgJJJIHWpFaMuU81C6jJQHkD6UroY3wzZOOtYdt4bs7XxPca8ssxuJ49hQv8AIPfFHUStbU26 Q9vrRuHrSEjjnvSAU/e/Chfuj6UhODn2oBwAMGgB1UNa13TfD+nrealK0cRcICq5JJq9k+lQXdnb 38HkXdvHNFkHbIMjIoGrX12JI5UngSWI7o5AGU+oPSrNz/rEHotQLtj2DbhFxwPSpJpA0xOeMU+h Jg+IddvNGksVtdHn1AXEwjcxkjyx6ng1uHgkUeZx96k3D1pFN6bAehpRwBTSwwaATjp+tAh4JLAk 96pXunzXNy0qarPApA/doRgcfSrYLZ44oO8nORTTEQsOOp696fPEJoWQ9xTW5HSpqzptp3RCV7pn MspRip6g4pKu6lAYrjePuvz+NUq+gpzU4qSPNnHlk0FFOjCmRQxwpPNXdQtYoUR4hgHjrnNEqijJ RfUag3FyXQvaed9rHzjjH61naT4m0/WtV1DT7VJxNYttkaRcA9uK0rJfKtYuM/LmpgACzKiKWOWK ryT7141X43buenTtyK/YsP8A8esf1qqsESzNMsMSyvwzhQGbHTJ6mrP3rMeqms7UdV0/SUibULyO 385/LjDfxN6VDKSb0RbGRnI/KhwJFCugZQc4Io6rlTwefWgkKpZnwoGST2pALlsjgVLcf6xW9VrO 07VNP1i2Nzpt4tzCGKF07MO3StGX5oYm/Cn0Bqz1Ofnl8Rr4rgjitrc6GYiZZiw3hvTr9O1bZ6is ebxLpsPiSHQXeX7dKnmKNp24+v4Vr4wR1/OkVK+l1Ymg/wBcKm7TD3qCH/XLVlhgy/TNUiCkAMn6 0tNyAT9aUPg//WqRmNrniI6LqOmWg025uheybDJEOI/rWy3T8ad5zHsPypjEkHg0x3Vtia4GXQ+q 1z114ha28V2eiDTrh1uELfaVX5F+tdDMf3cTe2KYJNvRhih7iTS3QlIehoLAknIoLDBpANbp+FPp h6D6U7J9P1oAcOozWJbeKbS78UXnh+O2uFuLZN7SsvyH6Vs5b0H50HJbcQN3rQNW6jJCcgAlckDI GetMu7uGytZ7u4bbFEpdzjOAKnWJXRpXz8hyAD3phCPGUdQysMMrLkEe9PoJFTR9c0/xBpaX+nOz wuSAWUqQR14NXqhggtrSIQ2tvHBEvSOJAqj8BUufY0hu19APQ0o6Ckz7GkUttHA/OgQ6kkgR3Lec 6+ykYo+b2o+b2pp2EZc9y63wjVspwCK1B0FU5baN5PNK/MB69auD7opOUXbl7GVJSTdyK5gFxAyd +x96x3sbiPrGSPUVvUVvRxEqastgqUYz1ZzLKynDAg+9SJcSxjCuceh6Vd1Zfmjb2xWbXp05KrBS aOGcXTk0mdBbN5kEbHklRWULvXx4te1a1h/sXyciYH5t9XtN5tBnoCRVfxBrln4a0ptRvI5XiDhM RDJya8mquWbR6dFtxVlds24PmEkfqM1lano9hrKwLf2qT+RJ5ke4fdarlhcx3EVvdRBhHKoYbhg4 IqaaMbpIySoYEZHUZqBptPQjX7oC4CjjikIDIUYbgeCPUVjeGtA/4R2zmt/t9xeeZKZN0xyVz2HJ raH3jxSG0k9ClpWj2OiWZttOtFt4GcuVUYyx71pnm0/3WrnrS38QJ4rvZrm7hfRXjAghA+ZW4/8A r/mK3DMFTZwQx9aaCW927kZtomnFyYEMqjaJMDcB6Zp/ORmsXXn8Ri704aItubYy/wClmUjOz25r bPUfWkDVlcki/wBctWn+9J/u1Uj/ANatXGB3P/u1S2JKH8TfWlppYB2HvRvFSMflApZieBmsbw/4 ksfE1tPPYCUJDKYm8xNpyK1vMA7n8qjijt7cMIYkjDHcQiBcn14oGrWLT82sZ96gmmht4WmnlSKN erOcAVO3/Hmn1rL1rRrPX9Ll06+V2gkxu2Ng8HPWmxK19S+pR0V0ZWVhkFTkEUHoahsrSGwsoLO3 UrDBGI0BOTgDAqc9KQDD90U+mH7op2eKAIb29t9NsJ727cpBAm92AzgVFpeqWms6dFf2Mhe3lGVY jBqxKkc8LwyoJI3GGQjIIpttbRWlusFtAI4kGFRFwBQPS3mWj8tkP9o1n6qb9dKuW0xUa9CHyVk6 FvetKSN/s0Y2nI6iq7Ns+8MfU02JMpaK2pvo9q2sJGl+U/eiPpmr9M81TjnrwOal8uT/AJ5tSBu7 uNpF+6Kf5Uv9w0xw0KguMCiwD0+8K881vxJ4+tdau4bDwzHcWaSEQzZ++vY9a7zzht3dvoasCCUj O0fnTsyoSUd0n6lZvun6VIGG0denpUbfdP0qVfuj6VlDcyjuG4e/5Ubh7/lS0VoWQzwpcptdWwPS q4023HVXP1NXqjeeKNtrSKD6ZrSFSolyxbIlCD1khY40jTYi7VHahkEiFHRXX0bnNOU5yR0oVgpN Rdt6legPuxkqB6YqWYrJscc8YP1rntD8PHRr/UbttRnuftkm8JIeI/pWuRslDAEg8H+lCHJJPQyR J4iHi2RHW0GheUNpH399bXP3scUq4LfMeBWNpt3rs3iXUIb+1hj0pFH2WVT8zHj/AOvQV8WvYu6p qdpo+my6hqE3l20WNzYJ6nA4FPt7m31Oxiu7OXfDKoeNwMZFST29ve2klrdwRzwOPmjkXIP4VLa2 iRQpFEixQoMKFGAB6ChC0t5ixK7gDHPf2qytuijMjAn64qJpFQkQjGeretUxchrxoGU5xkMT1qlG 97EN23NSNVD8eX+HWpqzk4kUir2Tl/pQmMhm3HPl+SDnq1QFJ8HdNb/gvSo2AZ2zRsHvU3An82GN QCA7dyBim/aI/wDnjWNr/iDT/DNlFd6gziOWQRrsTccmtRWEqIy9HwR+NFx8rtcuyyRiJd68N0FV /wDRj/fWnXB/eKv90Vz8Oq6m/i6TTH0pl04RbxeZ4z6UN6go3N7Zb/8APQ/nRsg/56mmcUUrgP22 w/iY/SgNbjpEzfWox3+tLRcCTzyPuRKPrSGeb+8B+FIu3uOawfD+sanqs1+uo6WbFYJdkJJ/1i+t O41G6udI8z/ZlcYDE4JrOvtRtbPyjfXUEXmNsTzSBuPoM1d62X+61ZOr6BpmvfZhqVv5ot5PMj+Y jDf5FDuKNr6mjjGMYHcYUU7zJP8Ano350hxnjoBgUUmAvmSZx5j/AJ0hLHq7Un8X4UtAB8399qcI 3IzuP502pBKAMYpoRWPSnp9wUynx/wCrX6VjDcmO46iiitSyC7Ept28o4asAkkndnPvXTVg36BLx wBgHmu/BT1cTjxUdFI1bBt1oh9qsL1IPrVXTuLNPx/nVrHOQSK5Kv8SXqdNP4EYl5qWrQ+K7TT4d JMmmSRlpbzPCHnj/AD61uxx75AB9c03B9ackrIjAYy3Gaz6mjd+hIRbKSmCAP4hVYs2TtBIHepAM CkwD1Ap3JFiZQzGQZx90DvSyzZUliEQdqSormEzwNGDgmnGzaT2B3S0G/bLfGfNXj3rOS583VFkH 3Sdo+lA0mbu6VPbaaYZhI7g46AV2pUqak1K+hyt1JtXVjSX76/Wro++/0FUl+8PrVwH96R6rXEjq KP8AG1OAzTWAMjfQUbR6VIxtxDb3cQjuLeKZAchZFDAH15qSMDzYx71heI/EUfh1bMtYXN19plEQ 8lc7fc1uJgSI2Mc07jcWlcdMw898mkEgCkZzmlkZWmYqQQe4rB1PUNct/EGm2thpaXNhM2LmdmwY x7c/0NHUErm3kUbvY/lTiMMQaSkIaMnOPWl59aF7/WloAQBj0P6UxJUd3RJUZk4YA5I+tSqQrZNY uleF9N0TVb/ULMzma+bdKJHyB9OP55oGrdTdTmzlHoao3t/Z6bb/AGi+uo7eHIXfK4UZPQZNXo/+ PeYVl6vomna/Yiz1O2Fxb7g+wsV5HuDmhhG19di8pV0DK25WGQQeCKXaKSOOOGNIok2RooVVHYCn UCG4+YdRS49zQfvCloATHuaY0sKHDzRq3oxGakqrc6bptzMZZ7GKSQ9WbqaaES06P/Vrznim06P/ AFa85rGG5Edx9V9XuJbDSbi7t4GuJYkLLEOrH0qyGxngGgsSAMAAVtoadTL0DUbnVdGgvLuza0mk GWhbqKsz2MdxL5jls4xgVaoohOUHeLFNRlutCNEWFQij5QMCnb/ajGW/Cl20m76sNhN9NycfjT9o pD938aBhk/5FGW9P0p1FADcn0/Sj5qdRQA35vej5qdRQAi7tw+tXf+W6/wC7VPuKt/8ALdP92mhM qH/Wt9BSgZpHAMppNo9KQxScgA4IHTikJ461h3PiS3tfFdtoBtLhpZ4zIJgvyCtsgY6UXG4tbiLG 0e4443Z/A0/e2MDpVjMOWl3DlcFaqqcimyRcnnj9aMn0/WsfQvDb6LqWq3zalPdC+fesMn3YuvA5 9/0rZpFOyeg0ZJPOKXHuaB1NLQIr3t3badYzXl5OIoIV3O57Cm2F7banZRXlnN5sEoyjg9RU1zbW 95aSWt1Cs0Mo2ujdCKba2ttY2sdtaQrDBGMIi9AKB6W8y1D/AKmYVnanqNrpGmTX94xW3hXc5Aya 1baPMTk8b+BVOaCKeJ7e4iSSM/KyOMg03sJWvqQadfWuq6bb39o2+3nXchIwcVa2j0pI44oIEhhi WONBhVUYAHtTsikw9BpA3DHFLj3NGRuFLQALGW6E/nTDjJGTxx1qQHgjJAI6ivPIvhzPApX/AISr VOWLdfU/WgqKT3Z3tOj+5TAfXrT4/un61lHcxjuPooorU0CiiigBP4vwo5JwKP4vwpM4b8KAK8d/ Yz3k1nFexSXUIBkhVxuQH1FXQB9lY45DdayLXQdOstYutVt7UJe3S7ZZMnkfT8BWwP8Aj0kz600D t0Kk13aWrxJc3kMLynbGsrhS59BnrU3IbGQazNU8PaVrlxZz6hAZJLR98RDEYPvjrWnkF+OlIbt0 FopACe/eoYrq2uGlSC6jleI7ZFRgSp9DRYRPRQORRQAVb/5bRfSqlSSyst3aqAcNnPFNCI3/ANc1 FLJ/r2pOlJjHb9q9s9vamdeTR1OTS0XAjncQW8s2wv5altqjJOOwrJ8N68viTTWvBZXFptkMeyYY PHetsEjpTQAOgA+goHdWFU7W+bp6ijIJODmikx6UCExljS7R7/nSAncc06gBNoqKWe2huI7eSeFJ pPuRs4DN9B1NTg4OayNS8Oadqmt2Wrzxubq0/wBWQ5A/Ed6Bq19TajnEaBWTdg/Kao6neixsLm+e B5jEhfy4xlm9hVl8ZXH40u7HcUNiRm6Dqia5okGoi0ltvN/5ZSryK0do9BS7xtxkAdMCk3L/AHh+ dF0DavoB4IpaYzqMfMODRvU9WHHaldCuh3LfT+dLTfMQZ+Ycc0nmJ/epcy7hdDDwc06L7p6dTTdo 9BSBVOeB1rNO2pmnYmyPWkLqP4hUe1f7o/KjA9KrnZXMyTzE/vD86A6nowplLF/F9aFJt2BS1HZB YY9KUffpaEUO5z0FaFmJq+i3t94i0zUbfVHgtrYky26jiX/PSt48Wij+81QpJBNuaCWORQdpKPnB 7g4qaclYIhgkgZwO9MG27IwpX8RDxZCsMdudD8rMrkjeG/nWwPvGsTw1rV7rdvdSXmkXGmmGYxqs pJ3j1GQK3F70uhUrp2fQFYD65rK0vw5puj315dWMTpLePvlLNkZ9qm1ibU4NFuZdHgjn1BV/cxSH Csc/UdvepNIfUJdKtW1SFIb5kBmjjOVVvQdf50Bqo3uaklsiQkqSCBnNVx0qa5dmYRg8Ac+9QEMv XH5U2QLS3GftdkQcc9M9aTPFLco7TWTIOA/Jx2oQMjldzOSAvfv70zLkjJFSSj963Tqen1NMrC7M 7sNz/wB4flRl/wC8OvpRSkEYzRdhcbl/736UfPz89LRSAQ7sH5jRhv77UHoaWgBMHOdzUbf9o/nS 0UANKgY5P50u0cdePeg9qdjC5osAzYvHHT3o2r6U6igBu0bulLtX0H5UfxfhS0AJtX0FGB6ClooA ao+Xp3p34Ui9KXHt+lACE54H50KMZpelIOpoAWiiigApY+rUlLH95vwpx3GtxwGSeT+dK0TGNl52 sCD9DSAgMc+tYmo2+uzeJ7K5tNQji0mNCLi3I5c1sapXJPD/AIdsfDkFxDZeZieQyN5jZ59q3bg7 ZEHotPhtg6q7njqAKLtcMr9ulO1kJycndkBZiuMHHvSL0rF0XRL3StR1K5udUku47t90UTdIhWyO 5pDaSegqKTjBOadGMSrznmq9zD9osprbe0ZljZN69VyMZFUfC+hnQNNisWvJrwhy3my9eTTCytc1 5WAnfNc94d8ODw++oOL25uftk5mxMc7M9h+dbt2Zttwbfb520+Xv6bscZrJ8NPrr6Op8QpCl9vbI hxjb26UmNX5Xqa4+6Ktfwwn3qqPu1Z/5ZRf71NEFWXiV+g5PT60ypJxiduMc9qjrnZmiG7tvtlpN bb2j81Cm5DgrnuKpeHdAXw7ocen/AGuW52MzeZKeeT0+ladLuO3FNWHzO1uglFFFIQh6GlHSkPQ0 o6CgAooooAQ9KWkb7tLQAUUUUAJ/F+FLSfx0tABRRRQAg7/Wl4pB3+tNZXY5ErqPRcYoAfSDqaWk 7mgBaKKKAClj+83TtSUsf326dqcd0Nbjx1P1rC0HxDcaze6hbzaTc2S2smxZJeko9RwP6/Wt0juO tJnGeMGtTVNWehLHcSKm1cEDoTTlmLZSY5U9/SoHaVIHEO3zdp27ume1Y/hg68dI3eI2ha+MjY8k ADZ26d+tVcVtLm3JG0fB5U9CKaMMcDoKRl3phskfXpTAhUnDE8dD/jQIyLbxDNc+LL3RG0i5jht4 w63p/wBXITjgcY7+p6GtkPtkwr4Yc4qQxOse/APHOOtQooVmJ6k5NA209jO1jxFpWhSWy6ncNE11 JsjwpbJ98dBWoQBxz6dahuLO2u2jNxaxTGJt6eYoO1vUe9TDO7mkN2toLjAxVn/ljH/vVXqyozbK fQ00SVbgETNjA5+tRc+o/Kp7gfvm4xz/AEFQ1g9zMTn1H5UYPr+lLRjNIBMH1NGPc04gjrSUAJj3 NA+6KWkX7ooAWiiigBG6UtIelLQAUUm5PNMe9fMA3FcjIHriloAT+IUvWkPUUoODmgCnY6tYalPc w2d3FPJbNsmVDyhq5VCw0XTtMuLmeztY4Zbl98rKMbjV+gcrX90QdT9aXn3/ACFIOp+tHH+RQIN3 saB1NLSfxfhQAtFFFABSp98/SkpU/wBZ07daa3GtySggHrSZ5wBSEnHT9a2NBdo+lG33NU9U1Sw0 Wwe+1G4EFsmAznJ6nA4HNT208F3axXNvIJIZUDo4JwykZBoHZ2uTVi+JH16PSg/h6GGa88xdyykY 29+tbI5XmjLJ0NAJ2dwgaaOOMyYEu0b1U5Gcc1LKoKiVOh+8KpXV9a2PlfbLuC3859kfmuF3t6DP U1dgwwZM5DCmI55dJ1NfFr6o2qs1g0WwWeOAfWtvOW49KUAY6c0tIbbe4VZj/wCPU/Wq1WYubVqa JZXuf9c3H+cCoamuB+/PB7fyqGsHuQOVtqnpntWH4iuNfgFidCt4JS04FyZSPlj9v1raoouEXZ3t cQZIBPXvS0UUhBSDoKWkXpQAtYniZtfFlb/8I8kDXHnr5vnYx5ffGfwrbooHF2dxo3eWN2N2OcU4 cc96Q9DSjpQIxYvDVtF4qm8QCec3EsXlGMt8g6dvwFbVJkeooznoCfpQNyb3A9RS04RSNg7cD3pd saffk3H+6tOwiPqcDk+gqQQnGXYIKPNIGI1CD9aZ1OSST70APzAvQM59aPOH/PFfzqMfeNLz/nFF wCk/i/CiikAtFFFACZ9BSpnzOfSiimtxrcpa5rll4e02TUdQZ1t0IB2LuOT7VcguYry0iuoCTFKg dCRjINFFbI25VZerKHiU2a+Hb2S/0/7fbxxl2ttu4vjkACpPD19DqXh2wu4LJrKN4wFt2GDGBwB9 OOKKKFuP7PzNBfuilIyKKKCDM1bQNL14Wv8AaVt5xtpPNi+Yrhvw69Ola9vGyuuFIUfyoopoJN2H vbneSGUAnPNQyKUYBQZM/wB0iiiqsICHCArbOxz03gVejGIh8m3jkZoooQivPErscg9uc1EYEH/L XH1IoorB7kEZiUf8thR5af8APcflRRUgGyP/AJ7fpSbYv+ejflRRQIMQ/wB9/wAqhdfm/dyEL7ii igYqgBgWkJGOQB1qXMP91z+NFFAhcwf882pN8PaE0UUxi+aB92FfxoM0nYgfQUUUARsWYjcxNLgC iipAKKKKAEH3j9KX/PSiigD/2Q==