View In:   ArcGIS Online Map Viewer

Name: Water Hydrants

Display Field: PROJECTNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 20000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 575794.3528317623
YMin: 1732484.3455979154
XMax: 636434.2580311336
YMax: 1782580.0086757094
Spatial Reference: PROJCS["NAD_1983_StatePlane_Florida_West_FIPS_0902_Feet",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",656166.6666666665],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-82.0],PARAMETER["Scale_Factor",0.9999411764705882],PARAMETER["Latitude_Of_Origin",24.33333333333333],UNIT["Foot_US",0.3048006096012192]],VERTCS["NAD_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PARAMETER["Vertical_Shift",0.0],PARAMETER["Direction",1.0],UNIT["Foot_US",0.3048006096012192]]

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: OWNEDBY
Field 2: HYDRANTMODELNEW
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label:
UniqueValueInfos:
• Value: -1,FDC
  Label: Private,Fire Department Connection
  Description: N/A
  Symbol:
  
• Value: -1,Hydrant
  Label: Private,Hydrant
  Description: N/A
  Symbol:
  
• Value: 1,FDC
  Label: City of Ocala,Fire Department Connection
  Description: N/A
  Symbol:
  
• Value: 1,Hydrant
  Label: City of Ocala,Hydrant
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: OWNEDBY

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• REFNUM ( type: esriFieldTypeString, alias: Referance Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Referance_Number )
• COUNTYNUM ( type: esriFieldTypeString, alias: County Numbers, editable: true, nullable: true, length: 20, defaultValue: null, modelName: County_Numbers )
• ASSETSTAT ( type: esriFieldTypeString, alias: Asset Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Asset_Status , Coded Values: [Removed: Removed] , [AF: Abandoned Filled] , [ALAI: Abandoned Left as is] , ...5 more... )
• ADDRESS ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ADDRESS )
• BODYPAINTCOLOR ( type: esriFieldTypeString, alias: Body Paint Color, editable: true, nullable: true, length: 25, defaultValue: Red, modelName: Body_Paint_Color , Coded Values: [Aluminum: Aluminum] , [Chrome Yellow: Chrome Yellow] , [Purple: Purple] , ...7 more... )
• CAPPAINTCOLOR ( type: esriFieldTypeString, alias: Cap Paint Color, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Cap_Paint_Color , Coded Values: [Blue(1500GPM+): Blue(1500GPM+)] , [Green(1000-1499GPM): Green(1000-1499GPM)] , [Orange(500-999GPM): Orange(500-999GPM)] , ...3 more... )
• HYDRANTYEAR ( type: esriFieldTypeSmallInteger, alias: Hydrant Year, editable: true, nullable: true, defaultValue: null, modelName: Hydrant_Year )
• HYDRANTMODEL ( type: esriFieldTypeString, alias: Hydrant Model, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Hydrant_Model , Coded Values: [American Darling B-50-B: American Darling B-50-B] , [American Darling B-62-B: American Darling B-62-B] , [American Darling B-62-BHP: American Darling B-62-BHP] , ...30 more... )
• HYDRANTSIZE ( type: esriFieldTypeDouble, alias: Hydrant Size, editable: true, nullable: true, defaultValue: null, modelName: Hydrant_Size , Coded Values: [4.25: 4 1/4"] , [4.5: 4 1/2"] , [4.75: 4 3/4"] , ...4 more... )
• DISTMAINDIA ( type: esriFieldTypeDouble, alias: Disribution Main Diameter, editable: true, nullable: true, defaultValue: null, modelName: Disribution_Main_Diameter , Coded Values: [0.5: 1/2"] , [0.625: 5/8"] , [0.75: 3/4"] , ...32 more... )
• DATASOURCE ( type: esriFieldTypeString, alias: Data Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Data_Source , Coded Values: [As-Built Documents: As-Built Documents] , [As-Built Survey: As-Built Survey] , [Construction Drawings: Construction Drawings] , ...17 more... )
• NORTHING ( type: esriFieldTypeDouble, alias: Northing, editable: true, nullable: true, defaultValue: null, modelName: NORTHING )
• EASTING ( type: esriFieldTypeDouble, alias: Easting, editable: true, nullable: true, defaultValue: null, modelName: EASTING )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: false, nullable: true, length: 40, defaultValue: null, modelName: LASTMODBY )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LASTMODDATE )
• FACILITYIDOLD ( type: esriFieldTypeString, alias: Facility ID Old, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESCOLD ( type: esriFieldTypeString, alias: Location Descriiption Old, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MANUFACTURER , Coded Values: [American Darling: American Darling] , [Clow Corporation: Clow Corporation] , [Corey: Corey] , ...17 more... )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: 1, modelName: OPERABLE , Coded Values: [0: False] , [1: True] )
• LASTSERVICE ( type: esriFieldTypeDate, alias: Last Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTSERVICE )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: City of Ocala] , [2: Windstream Utilities] , [3: Marion Utilities] , ...4 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: City of Ocala] , [2: Windstream Utilities] , [3: Marion Utilities] , ...4 more... )
• FLOW ( type: esriFieldTypeDouble, alias: Flow Rate (GPM), editable: true, nullable: true, defaultValue: null, modelName: FLOW )
• COMMENTS ( type: esriFieldTypeString, alias: Comments/Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FACILITDYIDNEW )
• PROJECTNUM ( type: esriFieldTypeString, alias: Project Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PROJECTNUMNEW )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LOCDESCNEW )
• HYDRANTMODELNEW ( type: esriFieldTypeString, alias: Hydrant Model New, editable: true, nullable: true, length: 25, defaultValue: null, modelName: HYDRANTMODELNEW , Coded Values: [Hydrant: Hydrant] , [FDC: Fire Department Connection] , [Siamese FDC: Siamese Fire Department Connection] )
• LASTSYNCH ( type: esriFieldTypeDate, alias: LASTSYNCH, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTSYNCH )
• FLOW_RATE ( type: esriFieldTypeSmallInteger, alias: Flow Rate, editable: true, nullable: true, defaultValue: null, modelName: FLOW_RATE )
• FLOW_GPM ( type: esriFieldTypeSmallInteger, alias: Flow GPM, editable: true, nullable: true, defaultValue: null, modelName: FLOW_GPM )
• FLOW_PSI ( type: esriFieldTypeSmallInteger, alias: Flow PSI, editable: true, nullable: true, defaultValue: null, modelName: FLOW_PSI )
• STATIC_PSI ( type: esriFieldTypeSmallInteger, alias: Static PSI, editable: true, nullable: true, defaultValue: null, modelName: STATIC_PSI )
• RESIDUAL_PSI ( type: esriFieldTypeSmallInteger, alias: Residual PSI, editable: true, nullable: true, defaultValue: null, modelName: RESIDUAL_PSI )
• FLOW_AT_20PSI ( type: esriFieldTypeSmallInteger, alias: Flow @ 20 PSI, editable: true, nullable: true, defaultValue: null, modelName: FLOW_AT_20PSI )
• YEAR_TESTED ( type: esriFieldTypeSmallInteger, alias: Year Tested, editable: true, nullable: true, defaultValue: null, modelName: YEAR_TESTED )

Types:

ID: -1
Name: Private,Fire Department Connection
Domains:
• ASSETSTAT:
  Inherited
• BODYPAINTCOLOR:
  Inherited
• CAPPAINTCOLOR:
  Inherited
• HYDRANTMODEL:
  Inherited
• HYDRANTSIZE:
  Inherited
• DISTMAINDIA:
  Inherited
• DATASOURCE:
  Inherited
• MANUFACTURER:
  Inherited
• OPERABLE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• HYDRANTMODELNEW:
  Inherited
Templates:
• Name: -1, FDC
  Description:
  Prototype:
  FLOW_AT_20PSI: null
  RESIDUAL_PSI: null
  REFNUM: null
  COUNTYNUM: null
  ASSETSTAT: null
  ADDRESS: null
  BODYPAINTCOLOR: Red
  CAPPAINTCOLOR: null
  HYDRANTYEAR: null
  HYDRANTMODEL: null
  HYDRANTSIZE: null
  DISTMAINDIA: null
  DATASOURCE: null
  NORTHING: null
  EASTING: null
  STATIC_PSI: null
  FLOW_PSI: null
  FACILITYIDOLD: null
  INSTALLDATE: null
  LOCDESCOLD: null
  ROTATION: null
  MANUFACTURER: null
  OPERABLE: 1
  LASTSERVICE: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: -1
  MAINTBY: 1
  FLOW: null
  COMMENTS: null
  YEAR_TESTED: null
  FACILITYID: null
  PROJECTNUM: null
  LOCDESC: null
  HYDRANTMODELNEW: FDC
  LASTSYNCH: null
  FLOW_RATE: null
  FLOW_GPM: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: -1, Hydrant
  Description:
  Prototype:
  FLOW_AT_20PSI: null
  RESIDUAL_PSI: null
  REFNUM: null
  COUNTYNUM: null
  ASSETSTAT: null
  ADDRESS: null
  BODYPAINTCOLOR: Red
  CAPPAINTCOLOR: null
  HYDRANTYEAR: null
  HYDRANTMODEL: null
  HYDRANTSIZE: null
  DISTMAINDIA: null
  DATASOURCE: null
  NORTHING: null
  EASTING: null
  STATIC_PSI: null
  FLOW_PSI: null
  FACILITYIDOLD: null
  INSTALLDATE: null
  LOCDESCOLD: null
  ROTATION: null
  MANUFACTURER: null
  OPERABLE: 1
  LASTSERVICE: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: -1
  MAINTBY: 1
  FLOW: null
  COMMENTS: null
  YEAR_TESTED: null
  FACILITYID: null
  PROJECTNUM: null
  LOCDESC: null
  HYDRANTMODELNEW: Hydrant
  LASTSYNCH: null
  FLOW_RATE: null
  FLOW_GPM: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 1
Name: City of Ocala,Fire Department Connection
Domains:
• ASSETSTAT:
  Inherited
• BODYPAINTCOLOR:
  Inherited
• CAPPAINTCOLOR:
  Inherited
• HYDRANTMODEL:
  Inherited
• HYDRANTSIZE:
  Inherited
• DISTMAINDIA:
  Inherited
• DATASOURCE:
  Inherited
• MANUFACTURER:
  Inherited
• OPERABLE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• HYDRANTMODELNEW:
  Inherited
Templates:
• Name: 1, FDC
  Description:
  Prototype:
  FLOW_AT_20PSI: null
  RESIDUAL_PSI: null
  REFNUM: null
  COUNTYNUM: null
  ASSETSTAT: null
  ADDRESS: null
  BODYPAINTCOLOR: Red
  CAPPAINTCOLOR: null
  HYDRANTYEAR: null
  HYDRANTMODEL: null
  HYDRANTSIZE: null
  DISTMAINDIA: null
  DATASOURCE: null
  NORTHING: null
  EASTING: null
  STATIC_PSI: null
  FLOW_PSI: null
  FACILITYIDOLD: null
  INSTALLDATE: null
  LOCDESCOLD: null
  ROTATION: null
  MANUFACTURER: null
  OPERABLE: 1
  LASTSERVICE: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  FLOW: null
  COMMENTS: null
  YEAR_TESTED: null
  FACILITYID: null
  PROJECTNUM: null
  LOCDESC: null
  HYDRANTMODELNEW: FDC
  LASTSYNCH: null
  FLOW_RATE: null
  FLOW_GPM: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: 1, Hydrant
  Description:
  Prototype:
  FLOW_AT_20PSI: null
  RESIDUAL_PSI: null
  REFNUM: null
  COUNTYNUM: null
  ASSETSTAT: null
  ADDRESS: null
  BODYPAINTCOLOR: Red
  CAPPAINTCOLOR: null
  HYDRANTYEAR: null
  HYDRANTMODEL: null
  HYDRANTSIZE: null
  DISTMAINDIA: null
  DATASOURCE: null
  NORTHING: null
  EASTING: null
  STATIC_PSI: null
  FLOW_PSI: null
  FACILITYIDOLD: null
  INSTALLDATE: null
  LOCDESCOLD: null
  ROTATION: null
  MANUFACTURER: null
  OPERABLE: 1
  LASTSERVICE: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  FLOW: null
  COMMENTS: null
  YEAR_TESTED: null
  FACILITYID: null
  PROJECTNUM: null
  LOCDESC: null
  HYDRANTMODELNEW: Hydrant
  LASTSYNCH: null
  FLOW_RATE: null
  FLOW_GPM: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field:
• Creator Field:
• Edit Date Field: LASTUPDATE
• Editor Field: LASTEDITOR

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata