Name: coa_wHydrantMeter

Display Field: H_StreetName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

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: 4867318.79290375
YMin: 2903236.11119415
XMax: 40360864.3670186
YMax: 8671917.84474292
Spatial Reference: 102675 (3417)

Drawing Info:

{"renderer":{"type":"simple","label":"","description":"","symbol":{"color":[0,168,73,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,0,0,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"}}},"transparency":0}

HasZ: false

HasM: false

Has Attachments: true

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)
• HYD_FUID (type: esriFieldTypeString, alias: Hydrant FUID N/A, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• OLD_HydMeterAddress (type: esriFieldTypeString, alias: OLD Hydrant Meter Address - N/A, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• HydMeterLocationDescription (type: esriFieldTypeString, alias: Hydrant Meter Location Description, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Contractor (type: esriFieldTypeString, alias: Contractor, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ContactPerson (type: esriFieldTypeString, alias: Contact Person, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ContactBusinessPhone (type: esriFieldTypeString, alias: Contact Business Phone, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• ContactCellPhone (type: esriFieldTypeString, alias: Contact Cell Phone, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• DateSet (type: esriFieldTypeDate, alias: Date Set - N/A, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AnticipatedDateRemoved (type: esriFieldTypeDate, alias: Anticipated Date Removed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DateRemoved (type: esriFieldTypeDate, alias: Date Removed - N/A, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Action (type: esriFieldTypeString, alias: Meter Action Needed - N/A, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Install: Hydrant Meter Install], [Remove: Hydrant Meter Remove], [Complete: Complete])
• VolUsed_Jun30_CF (type: esriFieldTypeInteger, alias: Vol Used Jun 30 (CF) - N/A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalVolUsed_CF (type: esriFieldTypeInteger, alias: Total Vol Used (CF) - N/A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PostDate (type: esriFieldTypeDate, alias: Posting Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• A_Date (type: esriFieldTypeDate, alias: Application Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• A_BillingStreet (type: esriFieldTypeString, alias: Billing Street, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• A_BillingCity (type: esriFieldTypeString, alias: Billing City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• A_BillingState (type: esriFieldTypeString, alias: Billing State, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• A_BillingZip (type: esriFieldTypeString, alias: Billing Zip, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• A_Comments (type: esriFieldTypeString, alias: Application Comments, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• A_ReqInstallDate (type: esriFieldTypeDate, alias: Date Requested to Install meter, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• A_ReqRemoveDate (type: esriFieldTypeDate, alias: Date Requested to Remove Meter, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• A_ReqMeterSize (type: esriFieldTypeInteger, alias: Requested Meter Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1"], [2: 2"])
• A_BFDeviceSerNo (type: esriFieldTypeString, alias: Back Flow Device Serial Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• A_HydMtrNo (type: esriFieldTypeString, alias: Hydrant Mtr Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• A_InstalledBy (type: esriFieldTypeString, alias: Installed By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [John Sanderson: John Sanderson], [Josh DeVos: Josh DeVos], [Other: Other], ... 1 more ...)
• A_RemBy (type: esriFieldTypeString, alias: Removed By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [John Sanderson: John Sanderson], [Josh DeVos: Josh DeVos], [Other: Other], ... 1 more ...)
• A_InstallRemovalFee (type: esriFieldTypeInteger, alias: Install/Removal Fee, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_CapacityChg (type: esriFieldTypeInteger, alias: Service Charge - N/A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_RepOthChg (type: esriFieldTypeInteger, alias: Rep/Oth Charge, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_WaterChg (type: esriFieldTypeInteger, alias: Water Charge - N/A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_SentToFinance_Text (type: esriFieldTypeString, alias: Sent To Finance, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• MeterSize (type: esriFieldTypeInteger, alias: Meter Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2])
• InRead_PreJul1_ (type: esriFieldTypeInteger, alias: In Read Pre Jul 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Read_June30_ (type: esriFieldTypeInteger, alias: Read June 30, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InRead_PostJul1_ (type: esriFieldTypeInteger, alias: In Read Post Jul 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OutRead_ (type: esriFieldTypeInteger, alias: Out Read, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalBilled_ (type: esriFieldTypeDouble, alias: Total Billed - N/A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• 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)
• H_HouseNum (type: esriFieldTypeInteger, alias: Hydrant Location House Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• H_StreetName (type: esriFieldTypeString, alias: Hydrant Location Street Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true, Coded Values: [10TH ST: 10TH ST], [11TH ST: 11TH ST], [12TH ST: 12TH ST], ... 738 more ...)
• DB_WaChg100CF (type: esriFieldTypeInteger, alias: Water Chg 100 CF - N/A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DB_BillDate (type: esriFieldTypeDate, alias: Bill Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• A_InstallHrs (type: esriFieldTypeDouble, alias: Install Hrs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_RemHrs (type: esriFieldTypeDouble, alias: Rem Hrs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Project (type: esriFieldTypeString, alias: Water Use & Purpose, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DB_MeterNoOut (type: esriFieldTypeString, alias: Meter Num Out, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DB_LID (type: esriFieldTypeString, alias: DB_LID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• DB_SODescription (type: esriFieldTypeString, alias: Svc Order Description, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true, Coded Values: [Set 1 Hydrant Meter: Set 1" Hydrant Meter], [Set 2 Hydrant Meter: Set 2" Hydrant Meter], [Remove 1 Hydrant Meter: Remove 1" Hydrant Meter], ... 7 more ...)
• Comments (type: esriFieldTypeString, alias: Meter Dept Comments, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• A_IAgree (type: esriFieldTypeString, alias: I hereby agree and understand that I am responsible for payment for all charges and any damages caused to the water meter, the backflow prevention assembly, the fire hydrant or any other City of Ames property or facilities., SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [I Agree and Understand: I Agree and Understand], [I Disagree: I Disagree])
• A_IHaveRead (type: esriFieldTypeString, alias: I have read and understand the City of Ames Hydrant Meter Policy., SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [I Agree and Understand: I Agree and Understand], [I Disagree: I Disagree])
• A_IAgreePresence (type: esriFieldTypeString, alias: *A REPRESENTATIVE OF YOUR COMPANY MUST BE PRESENT AT TIME OF INSTALLATION*, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [I Agree and Understand: I Agree and Understand], [I Disagree: I Disagree])
• AppInf (type: esriFieldTypeString, alias: Applicant Information, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SOInf (type: esriFieldTypeString, alias: Service Order Information, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BillingInf (type: esriFieldTypeString, alias: Billing Information, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AuthorizedBy (type: esriFieldTypeString, alias: Authorized By, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• Nov1_read (type: esriFieldTypeInteger, alias: Nov 1 Read, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_InstalledBy_2 (type: esriFieldTypeString, alias: Installed By 2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [John Sanderson: John Sanderson], [Josh DeVos: Josh DeVos], [Other: Other], ... 1 more ...)
• A_RemBy2 (type: esriFieldTypeString, alias: Removed By 2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [John Sanderson: John Sanderson], [Josh DeVos: Josh DeVos], [Other: Other], ... 1 more ...)
• DateTime_Removed (type: esriFieldTypeDate, alias: Date and Time Removed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DateTime_Installed (type: esriFieldTypeDate, alias: Date and Time Installed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Meter Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [In Field: In Field], [In Shop: In Shop])
• DB_MeterFees (type: esriFieldTypeString, alias: Meter Move Fees - N/A, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• A_MovedBy_1 (type: esriFieldTypeString, alias: Moved By 1, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [John Sanderson: John Sanderson], [Josh DeVos: Josh DeVos], [Other: Other], ... 1 more ...)
• A_MoveHrs (type: esriFieldTypeDouble, alias: Move Hrs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DateTime_Moved (type: esriFieldTypeDate, alias: Date and Time Moved, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Move_Read (type: esriFieldTypeInteger, alias: Move Read, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Move_OriginalLocation (type: esriFieldTypeString, alias: Move Original Location, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• A_Movedby_2 (type: esriFieldTypeString, alias: Moved By 2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [John Sanderson: John Sanderson], [Josh Devoss: Josh DeVoss], [Other: Other], ... 1 more ...)
• ContactEmail (type: esriFieldTypeString, alias: ContactEmail, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)

Templates:

Name: coa_wHydrantMeter
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• A_InstallRemovalFee: 260

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/14/2026 3:42:59 PM

Schema Last Edit Date: 9/14/2026 3:42:59 PM

Data Last Edit Date: 9/14/2026 3:42:59 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat