20180322
16191800
1.0
FALSE
system_consumption
002
file://\\GISPORTAL\gis\Projects\2023\23-002 2023-2024 Winter Averages\23-002 2023-2024 Winter Averages.gdb
Local Area Network
Projected
GCS_NAD_1983_2011
Linear Unit: Foot (0.304800)
NAD_1983_2011_Oregon_Statewide_Lambert_Ft_Intl
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WKT>PROJCS["NAD_1983_2011_Oregon_Statewide_Lambert_Ft_Intl",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1312335.958005249],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-120.5],PARAMETER["Standard_Parallel_1",43.0],PARAMETER["Standard_Parallel_2",45.5],PARAMETER["Latitude_Of_Origin",41.75],UNIT["Foot",0.3048],AUTHORITY["EPSG",6557]],VERTCS["NAVD88_height_(ftUS)",VDATUM["North_American_Vertical_Datum_1988"],PARAMETER["Vertical_Shift",0.0],PARAMETER["Direction",1.0],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",6360]]</WKT><XOrigin>-118489100</XOrigin><YOrigin>-97381100</YOrigin><XYScale>3048</XYScale><ZOrigin>-100000</ZOrigin><ZScale>3048.0060960121918</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808398950131233</XYTolerance><ZTolerance>0.0032808333333333331</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102970</WKID><LatestWKID>6557</LatestWKID><VCSWKID>105703</VCSWKID><LatestVCSWKID>6360</LatestVCSWKID></ProjectedCoordinateSystem>
CalculateField "Water Services" METER_SIZE_T f(!METER_SIZE_D!) PYTHON_9.3 "from fractions import Fraction\ndef f(s):\n frac = str(Fraction(s))\n if frac == '3/2':\n return '1 1/2'\n else:\n return frac\n\n\n\n\n"
CalculateField "Water Services" METER_MFR_YEAR int( !METER_MFR![0:4] ) PYTHON_9.3 #
CalculateField "Water Services" METER_AGE "2017 - [METER_MFR_YEAR]" VB #
CalculateField "Water Services" METER_AGE 40 VB #
CalculateField "Water Services" METER_RADIO 0 VB #
CalculateField "Water Services" RES_UNITS 1 VB #
CalculateField "Water Services" RES_UNITS 0 VB #
CalculateField "Water Services" RES_UNITS 0 VB #
CalculateField "Water Services" METER_MFR_YEAR int( !METER_MFR![0:4] ) PYTHON_9.3 #
CalculateField "Water Services" METER_AGE "2018 - !METER_MFR_YEAR!" PYTHON_9.3 #
CalculateField "Water Services" METER_AGE 40 VB #
Project "Database Servers\PET410_SQLEXPRESS.gds\PublicWorks (VERSION:dbo.DEFAULT)\PublicWorks.DBO.Water\PublicWorks.DBO.WaterServices" "Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services" PROJCS['NAD_1983_2011_Oregon_Statewide_Lambert_Ft_Intl',GEOGCS['GCS_NAD_1983_2011',DATUM['D_NAD_1983_2011',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Lambert_Conformal_Conic'],PARAMETER['False_Easting',1312335.958005249],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-120.5],PARAMETER['Standard_Parallel_1',43.0],PARAMETER['Standard_Parallel_2',45.5],PARAMETER['Latitude_Of_Origin',41.75],UNIT['Foot',0.3048]] NAD_1983_HARN_To_NAD_1983_2011 PROJCS['NAD_1983_HARN_StatePlane_Oregon_North_FIPS_3601_Feet_Intl',GEOGCS['GCS_North_American_1983_HARN',DATUM['D_North_American_1983_HARN',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Lambert_Conformal_Conic'],PARAMETER['False_Easting',8202099.737532808],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-120.5],PARAMETER['Standard_Parallel_1',44.33333333333334],PARAMETER['Standard_Parallel_2',46.0],PARAMETER['Latitude_Of_Origin',43.66666666666666],UNIT['Foot',0.3048]],VERTCS['NAVD_1988_Foot_US',VDATUM['North_American_Vertical_Datum_1988'],PARAMETER['Vertical_Shift',0.0],PARAMETER['Direction',1.0],UNIT['Foot_US',0.3048006096012192]] NO_PRESERVE_SHAPE # NO_VERTICAL
CalculateField VernoniaWaterSystem.DBO.Water_Services METER_AGE "2018- [METER_MFR_YEAR]" VB #
CalculateField VernoniaWaterSystem.DBO.Water_Services METER_AGE 40 VB #
CalculateField VernoniaWaterSystem.DBO.Water_Services METER_AGE "2019 - [METER_MFR_YEAR]" VB #
CalculateField VernoniaWaterSystem.DBO.Water_Services METER_AGE 40 VB #
FeatureClassToFeatureClass "Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services" "Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaUtilities (VERSION:dbo.DEFAULT)\VernoniaUtilities.DBO.Water" WaterMeters # "MB_ID "MB_ID" true true false 4 Long 0 10 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,MB_ID,-1,-1;WSC_ID "WSC_ID" true true false 50 Text 0 0 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,WSC_ID,-1,-1;WSC_TYPE "WSC_TYPE" true true false 50 Text 0 0 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,WSC_TYPE,-1,-1;ACCT_TYPE "ACCT_TYPE" true true false 50 Text 0 0 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,ACCT_TYPE,-1,-1;TAXLOT "TAXLOT" true true false 50 Text 0 0 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,TAXLOT,-1,-1;ADDRESS "ADDRESS" true true false 50 Text 0 0 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,ADDRESS,-1,-1;PLACENAME "PLACENAME" true true false 60 Text 0 0 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,PLACENAME,-1,-1;SEWER "SEWER" true true false 2 Short 0 5 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,SEWER,-1,-1;IN_CITY "IN_CITY" true true false 2 Short 0 5 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,IN_CITY,-1,-1;RES_UNITS "RES_UNITS" true true false 2 Short 0 5 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,RES_UNITS,-1,-1;METER_MB_ID "METER_MB_ID" true true false 4 Long 0 10 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,METER_MB_ID,-1,-1;METER_SIZE_D "METER_SIZE_D" true true false 8 Double 8 38 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,METER_SIZE_D,-1,-1;METER_SIZE_T "METER_SIZE_T" true true false 50 Text 0 0 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,METER_SIZE_T,-1,-1;METER_MFR "METER_MFR" true true false 50 Text 0 0 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,METER_MFR,-1,-1;METER_MFR_YEAR "METER_MFR_YEAR" true true false 4 Long 0 10 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,METER_MFR_YEAR,-1,-1;METER_SN "METER_SN" true true false 50 Text 0 0 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,METER_SN,-1,-1;METER_REG_SN "METER_REG_SN" true true false 50 Text 0 0 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,METER_REG_SN,-1,-1;METER_RADIO "METER_RADIO" true true false 2 Short 0 5 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,METER_RADIO,-1,-1;METER_COMPOUND "METER_COMPOUND" true true false 2 Short 0 5 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,METER_COMPOUND,-1,-1;METER_AGE "METER_AGE" true true false 2 Short 0 5 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,METER_AGE,-1,-1;LATITUDE "LATITUDE" true true false 8 Double 8 38 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 8 38 ,First,#,Database Servers\GISPORTAL_SQLEXPRESS.gds\VernoniaWaterSystem (VERSION:dbo.DEFAULT)\VernoniaWaterSystem.DBO.Water_Services,LONGITUDE,-1,-1" #
CalculateGeometryAttributes "Water Meters" "LATITUDE POINT_Y" # # # "Decimal Degrees"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.5.0'><FeatureDataset>VernoniaUtilities.DBO.Water</FeatureDataset><WorkspaceConnectionString>SERVER=gisportal;INSTANCE=sde:sqlserver:gisportal\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisportal\sqlexpress;DATABASE=VernoniaUtilities;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>VernoniaUtilities.DBO.WaterMeters</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>WSC_TYPE</field_name><default_value>BILLABLE</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>ACCT_TYPE</field_name><default_value>RES</default_value></AssignDefaultToField></workflow><workflow><AlterField><field_name>TAXLOT</field_name><field_type>TEXT</field_type><field_length>13</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField><AssignDefaultToField><field_name>TAXLOT</field_name><default_value>4N4W0000000</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>SEWER</field_name><default_value>1</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>IN_CITY</field_name><default_value>1</default_value></AssignDefaultToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.5.0'><FeatureDataset>VernoniaUtilities.DBO.Water</FeatureDataset><WorkspaceConnectionString>SERVER=gisportal;INSTANCE=sde:sqlserver:gisportal\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisportal\sqlexpress;DATABASE=VernoniaUtilities;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>VernoniaUtilities.DBO.WaterMeters</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AlterField><field_name>TAXLOT</field_name><field_type>TEXT</field_type><field_length>13</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField><AssignDefaultToField><field_name>TAXLOT</field_name><default_value>4N4W0000000</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>METER_MFR</field_name><default_value>9999-99</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>METER_RADIO</field_name><default_value>1</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>METER_COMPOUND</field_name><default_value>0</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>METER_AGE</field_name><default_value>0</default_value></AssignDefaultToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.5.0'><FeatureDataset>VernoniaUtilities.DBO.Water</FeatureDataset><WorkspaceConnectionString>SERVER=gisportal;INSTANCE=sde:sqlserver:gisportal\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisportal\sqlexpress;DATABASE=VernoniaUtilities;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>VernoniaUtilities.DBO.WaterMeters</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>WSC_ID</field_name><default_value>3XXXXX</default_value></AssignDefaultToField></workflow><workflow><AlterField><field_name>TAXLOT</field_name><field_type>TEXT</field_type><field_length>13</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField><AssignDefaultToField><field_name>TAXLOT</field_name><default_value>4N4W0000000</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>METER_MFR_YEAR</field_name><default_value>9999</default_value></AssignDefaultToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.5.0'><FeatureDataset>VernoniaUtilities.DBO.Water</FeatureDataset><WorkspaceConnectionString>SERVER=gisportal;INSTANCE=sde:sqlserver:gisportal\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisportal\sqlexpress;DATABASE=VernoniaUtilities;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>VernoniaUtilities.DBO.WaterMeters</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AlterField><field_name>TAXLOT</field_name><field_type>TEXT</field_type><field_length>13</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField><AssignDefaultToField><field_name>TAXLOT</field_name><default_value>4N4W0000000</default_value></AssignDefaultToField></workflow><workflow><AssignDomainToField><field_name>METER_SIZE_D</field_name><domain_name>METER_SIZE_D</domain_name></AssignDomainToField><AssignDefaultToField><field_name>METER_SIZE_D</field_name><default_value>0.75</default_value></AssignDefaultToField></workflow><workflow><AssignDomainToField><field_name>METER_SIZE_T</field_name><domain_name>METER_SIZE_T</domain_name></AssignDomainToField><AssignDefaultToField><field_name>METER_SIZE_T</field_name><default_value>3/4</default_value></AssignDefaultToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.5.0'><FeatureDataset>VernoniaUtilities.DBO.Water</FeatureDataset><WorkspaceConnectionString>SERVER=gisportal;INSTANCE=sde:sqlserver:gisportal\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisportal\sqlexpress;DATABASE=VernoniaUtilities;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>VernoniaUtilities.DBO.WaterMeters</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>TAXLOT</field_name><default_value>4N4W0000000</default_value></AssignDefaultToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.5.0'><FeatureDataset>VernoniaUtilities.DBO.Water</FeatureDataset><WorkspaceConnectionString>SERVER=gisportal;INSTANCE=sde:sqlserver:gisportal\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisportal\sqlexpress;DATABASE=VernoniaUtilities;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>VernoniaUtilities.DBO.WaterMeters</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>TAXLOT</field_name><default_value>4N4W000000000</default_value></AssignDefaultToField></workflow></operationSequence>
CalculateField "Water Meters" METER_MFR_YEAR int(!METER_MFR![0:4] ) "Python 3" # Text
CalculateField "Water Meters" METER_AGE addZero( !METER_MFR_YEAR! ) "Python 3" "def addZero(w):
if w == 9999:
return 40
else:
return 2020 - w" Text
CalculateGeometryAttributes "Water Meters" "LATITUDE POINT_Y" # # # "Decimal Degrees"
CalculateGeometryAttributes "Water Meters" "LONGITUDE POINT_X" # # # "Decimal Degrees"
CalculateGeometryAttributes 3/4" Billable DB "LATITUDE POINT_Y;LONGITUDE POINT_X" # # # "Decimal Degrees"
CalculateField "Water Meters" METER_MFR_YEAR "2021 - !METER_MFR_YEAR!" "Python 3" # Text
CalculateField "Water Meters" METER_MFR_YEAR int(!METER_MFR![0:3]) PYTHON3 # Text
CalculateField "Water Meters" METER_MFR_YEAR int(!METER_MFR![0:4]) PYTHON3 # Text
CalculateField "Water Meters" METER_AGE "2021 - !METER_MFR_YEAR!" PYTHON3 # Text
CalculateField "Water Meters" METER_RADIO "YES" PYTHON3 # Text
CalculateField "Water Meters" METER_RADIO 1 PYTHON3 # Text
CalculateField "Water Meters" METER_AGE "2022 - !METER_MFR_YEAR!" "Python 3" # Text NO_ENFORCE_DOMAINS
CopyFeatures "\\GISPORTAL\gis\Data\Vernonia Utilities\VernoniaUtilities.sde\VernoniaUtilities.DBO.Water\VernoniaUtilities.DBO.WaterMeters" \\GISPORTAL\gis\Data\Utilities\Water\Water.gdb\WaterMeters # # # #
Rename \\GISPORTAL\gis\Data\Utilities\Water\Water.gdb\WaterMeters \\GISPORTAL\gis\Data\Utilities\Water\Water.gdb\Meters FeatureClass
AddGlobalIDs Hydrants;Meters;Valves;Services;Mains
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>DATABASE=\\GISPORTAL\gis\Data\Utilities\Water\Water.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Meters</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>ACCT_TYPE</field_name><domain_name>ACCT_TYPES</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>METER_SIZE_D</field_name><domain_name>METER_SIZE_D</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>METER_SIZE_T</field_name><domain_name>METER_SIZE_T</domain_name></AssignDomainToField></workflow></operationSequence>
CalculateGeometryAttributes Meters "LATITUDE POINT_Y;LONGITUDE POINT_X" # # GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]] "Decimal Degrees"
CalculateField Meters METER_RADIO 1 "Python 3" # Text NO_ENFORCE_DOMAINS
FeatureClassToFeatureClass "Usage heat map" "\\GISPORTAL\gis\Projects\2023\23-002 2023-2024 Winter Averages\23-002 2023-2024 Winter Averages.gdb" system_consumption # "CONSUMPTION "CONSUMPTION" true true false 8 Double 0 0,First,#,Usage heat map,residential_average_reduced.CONSUMPTION,-1,-1" #
20230126
14375700
20230126
14375700
Microsoft Windows 10 Version 10.0 (Build 19042) ; Esri ArcGIS 12.9.0.32739
2022 System Consumption
consumption
2022 System Consumption
File Geodatabase Feature Class
dataset
EPSG
8.2.10(10.3.1)
0
Simple
FALSE
0
TRUE
FALSE
system_consumption
Feature Class
0
OBJECTID
OBJECTID
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
CONSUMPTION
CONSUMPTION
Double
8
0
0
20230126
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAoopCcAmgBGdUGWOKjFzGTjdWPfXTGQgHiqSzsG4Jq1Ay530OqBBGRS1n6d
cGQbSa0KlqxpF3VwooopDGsM0zbzUtJigVhFFOoxRQMKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACkYZUilooA5y9iKynI61SC4NdDfxo6+9YxQBq1i7
o52+XQ0dLX5s1r1kWTbcAVrKcgVEtzSnsLRRRUmgUUUxjigB2RS1Bv5qVTmgSY6iiigYUUUUAFFF
FABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAUrpSwNZTQturddM
1VkjA7VaZjOFyK0j24zWmOlZRmEZqxBc7j1pNDg0tC9RSA5GaWpNQqOTpUlNcZFAmVCeaniNRMvN
SR0yUT0UUUiwooooAKKKKACikJAoBBoAWiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAqCdMrxU9IRkYoE1cwbhSDUcUxRq1Lu3ypxWQ6FWxitU7nNJNM2rW4DAA1crEtCQRWz
GcoKiSNqcrodQelFRyvsQ1JoyKVlU9aYky561l3VyzOQDUcUzBhzWnKYOep0SsGFOqrauWWrVZs2
TugooooGFNdtq5p1VruQLHQhN2RVmusN1p0FzuPWsqWQs5qS2Y7605dDn53c6FTuXNLUUB+QZqWs
zoQUUUUDCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooJxTdwoAdRSZHrS5oAa6h1xVCW0y3
StGimnYlxTKMNttPSroGBigkAVGZeetG4JJEtVro/KakMnFQSsD1oQSehjTId5ohiZnHFXWMRbki
rEAiHIxV3MFG5PbJsUZqxkVXaQY4pqyHNQbJ20LdFNU5FOpFjGbAzWRe3eSVBq/fSeXCTXMzynca
uPczd5PlRNuDGr1lHubNZETkmt7TmQJljVN3RDhyysaKDAFSZHrVaW6jQfeFUXv/AJuDUWbLc0jY
oqhbXYc9avA5GaTVioyTFopMgd6WkUFFFFABRRRQAUUUUAFFFFABRRRQAhOBVeW6WOn3DbUrBuZS
znniqirmc5W0RoNqAJ60n21cZzWN5nNBk4q+VEe8aj6jg8U6LUzuG6sF5jmljmOaWhp7OaVzsYpl
lUEVJWLp05+6TWwrcVDVhxldDZTgVUL81YnbArLluArU0iJuxfU5qjeyleAaEv1UciqN3ceYxaqS
Jb5tEQvPg9akhuGB4NZ7ElqtW6EkUJ3ZpOmoxNqBzIoNWUQ5pllBhBmrwQCpbJjHQEGBTqKKk1M/
U+Yq5uZCTXSXw3KRWI6jNaJXVjLn5Z3KsSEHNWhKUHBxQsdMkQ1SVkJyU5ajWuCT1oWUk1F5RzU0
cVJX6lyUEi1auRIK3Fm2xVl2lschiKvyIRHSluZwutSvLekNwalt7vccZrMlRg5qa0Rt9FlYlSdz
dByM0tMiGEFPrM6QooooAKKKKACiiigAooooAhuVzGa5+4jIkNdHL9w1iXbLuq4mNTuZxSkKcVMS
KMCtCVNlN4T2oSIg81eCBqUQ5PAqeVF+3drEllkSCt5PuCsy0tiCCRWsq4TFTJhTT3Kd0TtNYUzn
cTW/cj5TXPXI5NOOwmveVyBpTTd5ao+pqeKLNSm2btRiriJFk1tafabsMRVe1tC7DI4rcgjEaAU3
ZKyMbub1JFUIMCnUhYCjcKg1FooooAoX3CmsRutdBdR7kNc9OdrGtImEl7xNARvGauvbxGPcSKxB
Pg1MbpimNxxTunsP2bXQfJtVjg0+B1DjPSsySZi3WpbeQlqLlyoNRudZbqrICKnKAjFU9MYmHmr1
ZvccdUU3swx6U+K1VKs0UXDlQdKKKKRQUUUUAFFFFAAeBVeSXbU7dKy71yi00rkTdkWPtag8kU8X
sZ/iFc5LPjqagN5g9avlQoqctkdNPdKUODWJPJliarfa8jrUMtxkU1psNUpyeo958GkFzWdLcYNR
pOSetLmV7NnfHCe7c24p91aNq25sGsO2JJFbmnxlnzTPPrU1GVkbMKAKKmpqDC1Wu7tYUIzzWe5V
0kQ6hOFUgHmsCeXrUl1dl2JJrLknyetaJdCqVJzfMShvmq5E+BWakmTU6uRStymtWlfQ2oLspgGt
OG7V061zCzc1cgmIIwaLJnI1KBry3OD1psd1lutUXJanwId1Fied3NlGyM1LUEIO0VPWbN0MlGYz
XNXqYkYV0krbVrCvcM+RVwM5uzTMZhg05QWFSOnzVLGgoUdTaVS0SqYGJq1bWxLAY5rRtrHzQDWl
DYpF2p3SM3UnNWH2cXlxAVZpAMDFLWZSVlYKKKKBhRRRQAUUUUAFFFFABWbqUfyZFaVQ3EXmRkU0
7MmSujjrnINZruwaugvLQqxBFZj2pz0rQ6cNWilZlRZGxTJJDirn2YgdKrTQkUO9tGdcKkJSM6Ry
WqSAHOaGhO6rEUWBXNGDctTtnOKjoXreQLitS11DymGDXNyzGIcU1ZLkDeF4rSdaEXaRwTwLq+9c
74amjxehrHu7kuxJNZFpfFhgnmrLuXFWmrXRwTw84ztMq3Ex55rPeYk1cnjLVSeEipqcy2PXw6gk
TwSZNXl5FZ9vGQa0UHFVBvk1McTZPQUdauW7cCqJOKcsxQHmqSe5x1KbmtDTmvVQYFQxantfhqwb
m5eSTYnU1ATLAylmzmsZV4RlynRTy28bt6no9hepcpjo1WLi4S3iMjnpXJ6Rcsrq2aua5eFo8KeA
K0tqcLi1P2fUq3+vtvI3YHoKpR6qsrYJzTNHsUvXaWXnnjNO1qwitVDx4BHpXnvMYqt7NI9JYOjf
ke5OX3cipYiap2hLQgmrKttr0U9Tz6sLXidDp7gIOa0gQe9ctFcMnQ1ehvm6E0nE54y5dGbRcCmi
UVn/AGgtT1ck0rFc5og5oqKI5FS1JaCiiigYUUUUAFFFFABRRRQBBNbJKORWfJpfPFa9FNNolwTM
N9NYLmsi6t9pPFddM6qpzXOX7qzsRVptkx9ySsYbxAGlXAFOlYCoC5q7pHqxvJFa7HzA+hq0l5EL
fBx0qF0L0iWQY9K4K+G9rK52RqQUEpDbUFpiwHBNbkMO5eahtLMLjiugs7MbQWFdUIKEUjycZiPa
TtEx2tc9qrvZn0rr/sUZHK1FJp0Z6Cq5kc8alSJysdqQelTiEKK0byFbc4FZck3OBT0BTnUZFKmO
lVHyM1eX5zih7c46Uk9LHTTqqGkjCcPHLvAzS/vLiQZGAK03tx3FIsYTnFY/VoufMegsWuXTctWQ
ESc067cTIVzVUyEcU0OWNdFmef7FuftGQWl5Np7MoUlc8Yp001xqUo3ghBVtIg55FXIoFQcCuRYO
l7Tntqb1Mco621I4IfLiAoZcGrW3iq0vFdTWh5sZucrglWY+1UlbBqzG1EXdCqxZrQJuAq4kJrOt
JsEA1sxEMuamWhMEmORdop1FFQbBRRRQAUUUUAFFFFABRRRQAhIUZNZ11qHlnC1cuCfKOK525JLt
VxVzObd7IWe/ds5asy4uCc0r5zUDxlhTTTOijTindlN5CzVLFGWpRbnNXraA5HFCTvdnbVrRhHQh
W2PpViODHUVrwaezpnFP/s9hTuup5sq85FKBPmAFbtqMAVVhs9p6VoxR7RUyZlBO92S0UUVBsY2r
xncGA4rnpIzurtZoVnQqwrLk0clvlIxVpkxbg7oxbaElhxzW0NNJiB71ZtdNWFtzcmtChytsJpzd
5HMXFiydVqi9se1di8KuORVV9PjY9KOZAnOOxyJtznpTktjnpXTtpSHpSx6UinJp83maOtUtaxk2
tmzdBxWglkAORWpHAka4Ap2wVPMZcl9WY09phMgVlTIa6ySMFTWLdW3zEiqTvoyWuR3RihDmrEaG
rK25J6VdgsQ3WhJRHKo5aIgtIyXBrchXalRw2qx9qs9KmTuOEbBRRRUmgUUUUAFFFFABRRUbPigC
Sio1fNSUBca67lIrKurAsxKiteimnYmUUzmjp0mfu08aW5H3RXQ4HpS4HpT5hcj7nOHS3B+6KtW2
nFWBYVs4HpRRzByX3Y1ECKAKXaD2paKksTaB2paKKACiiigAooooAKKKKACiiigAooooAKKKKAAj
IqpNBuNW6KEJq5nLbc9KuRxbBUmBS02xKKQUUUUigooooAKKKKACiiigBD0qBxzRRTQmCDmpx0oo
oYkLRRRSKCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii
igAooooAKKKKACiiigD/2Q==