Name: Water Meters

Display Field: MAXIMOID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: OBJECTID: System-generated unique identifier for each record within the feature classShape: System-generated geometry type of the featureMAXIMOID: ID given to all features in order of creation and autopopulated with scripts. MAXIMOPFX: Prefix given to the MaximoID that identifies the feature type.WSVLMAXPFX: Prefix given to the MaximoID that identifies the feature type for the water service line. SOURCE: Means by which the data is provided/created off of. SOURCETYPE: Accuracy context for the recordGPS: Whether the feature has been GPS’d. Whether it be GPS’d in an asbuilt or by city staff. Quick information on the accuracy of the data. LOCATIONDESCRIPTION: Statement illustrating the whereabouts of a feature. This could be an address or general location. LIFECYCLESTATUS: Current state of the real-world feature SUBTYPE: The type of the building that the water meter is measuring water. METERNUMBER: Meter number established to each meter by North Star utility. OWNERSHIP: Organization with jurisdiction over the real-world feature represented in the feature classMAINTAINED: Organization responsible for the care of the real-world feature represented in the feature classWATERSERVICELINEID: The MaximoID of the water service line that the meter is attached to. CYCLE: The cycle by which each meter is read in the city. This is on a schedule. ROUTE: The route by which each meter is read in the city. This is on a schedule within each cycle. DEVICEID: The unique device ID given to each meter. RECORDERID: The macaddress for the node that transmits usage data to the AMI system.REGISTERID: The unique identifier for one of the three components of the water meter (dials). ACCOUNTCLASS: The class in which the meter is associated to the type of building where the water is being read. This could be commercial, governmental, residential or unknown. MASTERMETER: This determines whether the meter is a master meter for many units. UNITS: Number of units that the meter is reading for. INSTALLDATE: Date of installation for the real-world feature represented in the feature class/tableMETERSIZE: Size of the meter that is installed. NSACCT: NorthStar Account number (utility billing reference)DAYSSINCEREAD: The number of days since the meter has been read. NODESTALENESS: This indicates the last time a particular water meter reported to the AMI system.NODETYPE: This indicates the type of node attached to the water meter that transmits usage data to the AMI system.POINT_X: X coordinate. POINT_Y: Y coordinate. ENCLOSURETYPE: The feature in which the meter is enclosed. PRODUCTIONNOTES: Technical notes from GIS personnelDESCRIPTION: Statement illustrating the featureCREATEDBY: Name of the person logged into the system that GIS automatically stamps as the original creator. CREATEDDATE: Date/time stamp from the moment the GIS record was createdMODIFIEDBY: Name of the person logged into the system that GIS automatically stamps as the feature is modified. MODIFIEDDATE: Date/time stamp from the last moment the GIS record was changedGlobalID: System-generated unique identifier for each record that is required in replicated geodatabases

Copyright Text: Data has been created and maintained by Public Services and Engineering GIS staff.

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2287936.13362896
YMin: 13851036.7262459
XMax: 2329218.82140464
YMax: 13892389.4860599
Spatial Reference: 102740 (2278)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,12,173,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• MAXIMOID (type: esriFieldTypeString, alias: MAXIMOID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MAXIMOPFX (type: esriFieldTypeString, alias: MAXIMOPFX, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WSVLMAXPFX (type: esriFieldTypeString, alias: WSVLMAXPFX, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SOURCE (type: esriFieldTypeString, alias: SOURCE, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [ASBUILT: Asbuilt], [CAD: Cad], [ESTIMATED: Estimated], ... 4 more ...)
• SOURCETYPE (type: esriFieldTypeString, alias: SOURCETYPE, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [ASBUILT: Asbuilt], [COLLECTOR: Collector], [CAD: CAD], ... 7 more ...)
• GPS (type: esriFieldTypeString, alias: GPS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• LOCATIONDESCRIPTION (type: esriFieldTypeString, alias: LOCATIONDESCRIPTION, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: LIFECYCLESTATUS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [ABANDONED: Abandoned], [ACTIVE: Active], [PROPOSED: Proposed], ... 3 more ...)
• SUBTYPE (type: esriFieldTypeString, alias: SUBTYPE, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [DOMESTIC: Domestic], [FIREDOMESTIC: Fire Domestic], [FIREHYDRANT: Fire Hydrant], ... 3 more ...)
• OWNERSHIP (type: esriFieldTypeString, alias: OWNERSHIP, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [COSM: CoSM], [CRYSTALCLEAR: Crystal Clear], [ESPEY: Espey], ... 8 more ...)
• MAINTAINED (type: esriFieldTypeString, alias: MAINTAINED, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [COSM: CoSM], [CRYSTALCLEAR: Crystal Clear], [GBRA: Guadalupe-Blanco River Authority], ... 6 more ...)
• WATERSERVICELINEID (type: esriFieldTypeSmallInteger, alias: WATERSERVICELINEID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MASTERMETER (type: esriFieldTypeString, alias: MASTERMETER, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [UNKNOWN: Unknown])
• UNITS (type: esriFieldTypeSmallInteger, alias: UNITS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSTALLDATE (type: esriFieldTypeDate, alias: MTRINSTALLDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NSACCT (type: esriFieldTypeString, alias: NSACCT, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• DAYSSINCEREAD (type: esriFieldTypeInteger, alias: DAYSSINCEREAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NODESTALENESS (type: esriFieldTypeString, alias: NODESTALENESS, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [1: 0 to 3 Days], [2: 4 to 7 Days], [3: 1 to 2 Weeks], ... 5 more ...)
• POINT_X (type: esriFieldTypeDouble, alias: POINT_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POINT_Y (type: esriFieldTypeDouble, alias: POINT_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ENCLOSURETYPE (type: esriFieldTypeString, alias: ENCLOSURETYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [BOX: Box], [VAULT: Vault])
• PRODUCTIONNOTES (type: esriFieldTypeString, alias: PRODUCTIONNOTES, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• DESCRIPTION (type: esriFieldTypeString, alias: DESCRIPTION, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• PFX (type: esriFieldTypeString, alias: PFX, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• NSFullAcct (type: esriFieldTypeString, alias: NSFullAcct, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• SCRIPT_EDIT_DATE (type: esriFieldTypeDate, alias: SCRIPT_EDIT_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CYCLE (type: esriFieldTypeString, alias: CYCLE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ROUTE (type: esriFieldTypeString, alias: ROUTE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• FULLADDRESS (type: esriFieldTypeString, alias: FULLADDRESS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• METERNUMBER (type: esriFieldTypeString, alias: METERNUMBER, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SERIALNUMBER (type: esriFieldTypeString, alias: SERIALNUMBER, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• DEVICEID (type: esriFieldTypeString, alias: DEVICEID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• RECORDERID (type: esriFieldTypeString, alias: RECORDERID, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• METERSIZE (type: esriFieldTypeDouble, alias: METERSIZE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• METERTYPE (type: esriFieldTypeString, alias: METERTYPE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• NODETYPE (type: esriFieldTypeString, alias: NODETYPE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• INSTALLATIONDATE (type: esriFieldTypeDate, alias: NODEINSTALLDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SERVTYPE (type: esriFieldTypeString, alias: SERVTYPE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• ACCTCLASS (type: esriFieldTypeString, alias: ACCTCLASS, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• YUKON (type: esriFieldTypeString, alias: YUKON, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)

Templates:

Name: Water Meters
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Enabled: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/3/2025 9:20:11 PM

Schema Last Edit Date: 1/3/2025 9:20:11 PM

Data Last Edit Date: 1/18/2022 4:30:52 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat