Name: Houston Fire Hydrant

Display Field: FACILITYNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: 32000

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 8000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 50000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.0654305909552528E7
YMin: 3442822.8330964833
XMax: -1.0585255874902958E7
YMax: 3517307.8045730353
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SubtypeCD

Fields:

• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• ANCILLARYROLE ( nullable: true, alias: Ancillary Role, type: esriFieldTypeSmallInteger , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• ENABLED ( nullable: true, alias: Enabled, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• CONDITION ( nullable: true, length: 20, alias: Condition, type: esriFieldTypeString )
• CONDITIONDATE ( nullable: true, length: 8, alias: Condition Date, type: esriFieldTypeDate )
• UFID ( nullable: true, alias: UFID, type: esriFieldTypeInteger )
• NOTES ( nullable: true, length: 255, alias: Notes, type: esriFieldTypeString )
• QCVERIFIED ( nullable: true, length: 20, alias: QC Verified, type: esriFieldTypeString , Coded Values: [N: No] , [Y: Yes] )
• PLANDATE ( nullable: true, length: 8, alias: Plan Date, type: esriFieldTypeDate )
• DATASOURCEREFNUM ( nullable: true, alias: Field Verified Number, type: esriFieldTypeInteger )
• INSERVICEDATE ( nullable: true, length: 8, alias: In Service Date, type: esriFieldTypeDate )
• CREATIONSOURCE ( nullable: true, length: 20, alias: Financial Assets, type: esriFieldTypeString , Coded Values: [CIP: CAPITAL IMPROVEMENT PROJECT] , [COMMERCIAL: COMMERCIAL] , [DPC: DEVELOPER PARTICIPATION CONTRACTOR] , ...2 more... )
• SOURCEOFFUND ( nullable: true, length: 20, alias: Funding Source, type: esriFieldTypeString )
• FACILITYNAME ( nullable: true, length: 20, alias: Facility Name, type: esriFieldTypeString )
• FACILITYADDRESS ( nullable: true, length: 30, alias: Facility Address, type: esriFieldTypeString )
• LIFECYCLESTATUS ( nullable: true, length: 10, alias: Lifecycle Status, type: esriFieldTypeString , Coded Values: [E: Features Being Used and Maintained] , [P: Proposed] , [A: Abandoned] , ...2 more... )
• SYMBOLROTATION ( nullable: true, alias: Symbol Rotation, type: esriFieldTypeDouble )
• WATERTRACEWEIGHT ( nullable: true, alias: Water Trace Weight, type: esriFieldTypeInteger )
• BARRELDIAMETER ( nullable: true, alias: Barrel Diameter, type: esriFieldTypeDouble , Coded Values: [4: 4"] )
• NOZZLEDIAMETER1 ( nullable: true, alias: Nozzle Diameter 1, type: esriFieldTypeDouble , Coded Values: [2.5: 2.5"] , [4: 4"] )
• NOZZLEDIAMETER2 ( nullable: true, alias: Nozzle DIameter 2, type: esriFieldTypeDouble , Coded Values: [2.5: 2.5"] , [4: 4"] )
• NOZZLEDIAMETER3 ( nullable: true, alias: Nozzle Diameter 3, type: esriFieldTypeDouble , Coded Values: [2.5: 2.5"] , [4: 4"] )
• MANUFACTURER ( nullable: true, length: 20, alias: Manufacturer, type: esriFieldTypeString , Coded Values: [AUK: AUK] , [AVK: AVK] , [AVR: AVR] , ...8 more... )
• SUBTYPECD ( nullable: true, alias: Subtype, type: esriFieldTypeInteger )
• HFD_DELIVERY ( nullable: true, length: 8, alias: HFD Delivery, type: esriFieldTypeDate )
• HYDRANT_INSPECTED_DATE ( nullable: true, length: 8, alias: Inspected Date, type: esriFieldTypeDate )
• SUBDIVISION_NAME ( nullable: true, length: 50, alias: Subdivision Name, type: esriFieldTypeString )
• LAND_BASE_REVIEWED ( nullable: true, length: 25, alias: Land Base Reviewed, type: esriFieldTypeString , Coded Values: [N: No] , [Y: Yes] )
• NORTHING ( nullable: true, alias: Northing, type: esriFieldTypeDouble )
• PERMITDATE ( nullable: true, length: 8, alias: Permit Date, type: esriFieldTypeDate )
• MOTIONDATE ( nullable: true, length: 8, alias: Motion Date, type: esriFieldTypeDate )
• PRIVATEFUND ( nullable: true, length: 50, alias: Private Fund, type: esriFieldTypeString )
• ILMSNUMBER ( nullable: true, length: 30, alias: ILMS Number, type: esriFieldTypeString )
• FISCAL_YEAR ( nullable: true, length: 10, alias: Fiscal Year, type: esriFieldTypeString , Coded Values: [FY10: FY10] , [FY11: FY11] , [FY12: FY12] , ...5 more... )
• IMSNO ( nullable: true, alias: IMS Number, type: esriFieldTypeInteger )
• COMPKEY ( nullable: true, alias: COMPKEY, type: esriFieldTypeInteger )
• NOZZLECOLOR ( nullable: true, length: 5, alias: Nozzle Color, type: esriFieldTypeString , Coded Values: [302: 302] )
• BONNETCOLOR ( nullable: true, length: 5, alias: Bonnet Color, type: esriFieldTypeString , Coded Values: [303: 303] , [304: 304] , [306: 306] , ...1 more... )
• INSPECTIONDATE ( nullable: true, length: 8, alias: Inspection Date, type: esriFieldTypeDate )
• LINESIZE ( nullable: true, alias: Line Size, type: esriFieldTypeDouble , Coded Values: [0.75: 0.75"] , [1: 1"] , [1.5: 1.5"] , ...17 more... )
• CASTYEAR ( nullable: true, length: 5, alias: Cast Year, type: esriFieldTypeString )
• KEYMAP ( nullable: true, length: 14, alias: Key Map, type: esriFieldTypeString )
• COUNCILDISTRICT ( nullable: true, length: 10, alias: Council District, type: esriFieldTypeString , Coded Values: [A: A] , [B: B] , [C: C] , ...7 more... )
• PLANNUMBER ( nullable: true, length: 10, alias: Plan Number, type: esriFieldTypeString )
• PROJECTNUMBER ( nullable: true, length: 24, alias: Project Number, type: esriFieldTypeString )
• OWNER ( nullable: true, length: 10, alias: Owner, type: esriFieldTypeString , Coded Values: [C: No - City Owned/Maintained] , [P: Yes - Privately Owned & Maintained] )
• HYDRANTLEADDIAMETER ( nullable: true, alias: Hydrant Lead Size, type: esriFieldTypeDouble , Coded Values: [-1: Unknown] , [0: Other] , [0.5: 0.5"] , ...40 more... )
• IPSSUBTYPE ( nullable: true, length: 10, alias: IPS Subtype Code, type: esriFieldTypeString )
• ZONE ( nullable: true, length: 10, alias: Zone, type: esriFieldTypeString , Coded Values: [GNEHSA: GNEHSA] , [IAH: IAH] , [NE: NE] , ...3 more... )
• ADDRESS ( nullable: true, length: 100, alias: ADDRESS, type: esriFieldTypeString )
• MAINDIAMETER ( nullable: true, length: 10, alias: Main Size, type: esriFieldTypeString , Coded Values: [1: 1"] , [1.5: 1.5"] , [2: 2"] , ...20 more... )
• FACILITYID ( nullable: true, length: 11, alias: Facility ID, type: esriFieldTypeString )
• MOTIONNUMBER ( nullable: true, length: 20, alias: Motion Number, type: esriFieldTypeString )
• PCSNUMBER ( nullable: true, length: 20, alias: PCS Number, type: esriFieldTypeString )
• PERMITNUMBER ( nullable: true, length: 20, alias: Permit Number, type: esriFieldTypeString )
• WCRNUMBER ( nullable: true, length: 20, alias: WCR Number, type: esriFieldTypeString )
• HYDRANTNUMBER ( nullable: true, length: 25, alias: Hydrant Number, type: esriFieldTypeString )
• COSTPERACRE ( nullable: true, length: 30, alias: Cost Per Acre, type: esriFieldTypeString )
• DATASOURCETYPE ( nullable: true, length: 30, alias: Data Source Type, type: esriFieldTypeString , Coded Values: [BM: Block Map] , [P: Plan and Profile] , [AB: As Built] , ...8 more... )
• PLANTYPE ( nullable: true, length: 30, alias: Plan Type, type: esriFieldTypeString , Coded Values: [P: Plan and Profile] , [THD: Texas Highway Department] , [WD: Water Drawing] , ...3 more... )
• PROJECTTYPE ( nullable: true, length: 30, alias: Project Type, type: esriFieldTypeString , Coded Values: [BG: Budgeted Job] , [C: Private Construction] , [JOB: City Job] , ...6 more... )
• ADDRESS_ID ( nullable: true, alias: ADDRESS_ID, type: esriFieldTypeDouble )
• GFSORWBS ( nullable: true, length: 5, alias: GFS or WBS, type: esriFieldTypeString , Coded Values: [GFS: Government Financial System] , [WBS: Work Business Structure] )
• GFSWBSNUMBER ( nullable: true, length: 24, alias: GFS-WBS Number, type: esriFieldTypeString )
• UNITID ( nullable: true, length: 20, alias: UNITID, type: esriFieldTypeString )
• COMPTYPE ( nullable: true, alias: COMPTYPE, type: esriFieldTypeSmallInteger )
• SPATIALADJUSTNOTE ( nullable: true, length: 255, alias: Sptatial Adjustment Notes, type: esriFieldTypeString )
• SERVICEADDRESS ( nullable: true, length: 100, alias: Service Address, type: esriFieldTypeString )
• SHAPE ( nullable: true, alias: Shape, type: esriFieldTypeGeometry )

Types:

ID: 8
Name: Fire Hydrant
Domains:
• ANCILLARYROLE:
  Inherited
• CREATIONSOURCE:
  Inherited
• BARRELDIAMETER:
  Inherited
• ZONE:
  Inherited
• HYDRANTLEADDIAMETER:
  Inherited
• BONNETCOLOR:
  Inherited
• MANUFACTURER:
  Inherited
• MAINDIAMETER:
  Inherited
• PROJECTTYPE:
  Inherited
• QCVERIFIED:
  Inherited
• OWNER:
  Inherited
• LAND_BASE_REVIEWED:
  Inherited
• COUNCILDISTRICT:
  Inherited
• PLANTYPE:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• NOZZLECOLOR:
  Inherited
• LINESIZE:
  Inherited
• GFSORWBS:
  Inherited
• ENABLED:
  Inherited
• NOZZLEDIAMETER2:
  Inherited
• NOZZLEDIAMETER1:
  Inherited
• FISCAL_YEAR:
  Inherited
• DATASOURCETYPE:
  Inherited
• NOZZLEDIAMETER3:
  Inherited

---

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata