FALSE
1.0
wMeter
002
Projected
GCS_North_American_1983
Linear Unit: Foot (0.304800)
NAD_1983_StatePlane_Arizona_Central_FIPS_0202_Feet_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/10.7'><WKT>PROJCS["NAD_1983_StatePlane_Arizona_Central_FIPS_0202_Feet_Intl",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",700000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-111.9166666666667],PARAMETER["Scale_Factor",0.9999],PARAMETER["Latitude_Of_Origin",31.0],UNIT["Foot",0.3048],AUTHORITY["EPSG",2223]]</WKT><XOrigin>-17746700</XOrigin><YOrigin>-44067300</YOrigin><XYScale>3048</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808398950131233</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2223</WKID><LatestWKID>2223</LatestWKID></ProjectedCoordinateSystem>
20200618
21320500
20200618
21320500
20220222
20413100
A point of service at the end of a lateral where water service is connected. It may be one meter or multiple meters with the same Location ID (This is the meter service location in Lucity).
wMeter
X-Ray
NaN
NaN
NaN
NaN
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.
ACCOUNT_HN
Hansen Account
String
24
0
0
The Hanson Account number
ACCOUNT_NS
Northstar Account
Integer
4
0
0
The Northstar Account number
ACTIVEFLAG
Active Flag
SmallInteger
2
0
0
Indicates if the feature is in use/active
ADDRESS_HN
Hansen Address
String
50
0
0
The Hanson Address
ADDRESS_NS
Northstar Address
String
50
0
0
The Northstar Address
ADDRESSID
Address ID
Integer
4
0
0
The parcel address identifier
ASSETID
Asset ID
String
7
0
0
The assigned serialzed key
BUILDINGNO
Building Number
Integer
4
0
0
The building number associated to the address
COMMENT
Comment
String
255
0
0
Generic open comments
COMPTYPE
Comp Type
Integer
4
0
0
The assigned value to identify asset type
CRITICAL
Critical Customer
SmallInteger
2
0
0
Flag to indicate if this is a Critical Customer
CYCLE
Cycle
String
50
0
0
The meter reading cycle
CYCLE_HN
Hansen Cycle
String
14
0
0
The Hanson Cycle Route
CYCLE_NS
Northstar Cycle
SmallInteger
2
0
0
The Northstar Meter reading route number
DEVICETYPE
Device Type
String
5
0
0
The type of meter device
DIAMETER
Diameter
Double
8
0
0
Diameter of the pipe the meter is connected to
DISTRICT
District
String
4
0
0
Council District
ENABLED
Enabled
SmallInteger
2
0
0
Enabled
FACILITYID
Facility ID
String
30
0
0
GIS assigned facility identifier
GPSDATE
GPS Date
Date
8
0
0
The date the feature was GPS Located
GPSLOCATED
GPS Located
SmallInteger
2
0
0
Indicates if the feature was GPS located
GPSSOURCE
GPS Source
String
30
0
0
The agency who GPS located the feature
HYDRANT
Hydrant Meter
SmallInteger
2
0
0
Indicates if the meter is associated to a hydrant
INSTALLDATE
Install Date
Date
8
0
0
The date the asset was installed
LASTEDITOR
Last Editor
String
50
0
0
The user who performed the last update
LASTUPDATE
Last Update Date
Date
8
0
0
The date the feature was last updated in the maintenance database
LAT
Latitude
String
18
0
0
The latitude coordinate for the asset
LOCDESC
Location Description
String
200
0
0
Text description of the geographic location
LONG
Longitude
String
18
0
0
The longitude coordinate for the asset
LUCITYAUTOID
Lucity Auto ID
Integer
4
0
0
Lucity Created ID for Indexing
MAINTBY
Managed By
SmallInteger
2
0
0
Indicates which organization maintains the asset
METER_NS
Northstar Meter
Integer
4
0
0
The Northstar Meter identifier
MTRDVNO
Meter Device Number
Integer
4
0
0
The identifier for the meter device
MTRLOCADDRESS
Parcel Address
String
50
0
0
The parcel address for the meter
OWNEDBY
Owned By
SmallInteger
2
0
0
Indicates which organization owns the asset
PLANREF
Plan Reference
String
2
0
0
As-built Reference number
PRESSZONE
Pressure Zone ID
SmallInteger
2
0
0
Indicates the identifier of the Pressure Zone
QS
Quarter Section
String
6
0
0
Quarter Section Identifier
ROTATION
Rotation
Double
8
0
0
Map Symbol Rotation Value
SERVICEADDRESS
Service Address
String
50
0
0
The service address for the meter account
SERVICETYPE
Service Type
String
50
0
0
The type of Service Connection
STATUS
Status
String
20
0
0
The status of the asset
STREETNAME
Street Name
String
81
0
0
The named street address associated to the address
UNITID
Unit ID
String
16
0
0
The Hanson Meter Identifier
UNITTYPE
Unit Type
String
30
0
0
The assigned value to define specific type of assets
X
X Coordinate
Double
8
0
0
X-Coordinate
Y
Y Coordinate
Double
8
0
0
Y-Coordinate
wMeter
Feature Class
0
INLUCITY
In Lucity
SmallInteger
2
0
0
LASTSYNC
Last Sync
Date
8
0
0
COMPKEY
Comp Key
Integer
4
0
0
Version 6.2 (Build 9200) ; Esri ArcGIS 10.7.1.11595
wMeter
File Geodatabase Feature Class
dataset
EPSG
5.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
20200618