{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "hydrants_flushed", "type": "Feature Layer", "description": "

Originally created by Claunch & Miller, Inc. (part of HDR Engineering as of 2008) in 2002, this file has been maintained in-house since then. Updates are provided through a combination of as-builts, field verifications, and word of mouth from employees who have worked on a particular feature.<\/SPAN><\/P>

Field breakdown: The unique identifier for the fhs, which consists of the fire district number* and a base number, is in the <\/SPAN><\/SPAN>FHNUMBER [FH ID] <\/SPAN>field. The individual components of the identifier are in the <\/SPAN><\/SPAN>FHNOPREFIX [FH Prefix] <\/SPAN><\/SPAN>and <\/SPAN><\/SPAN>FH_NO [FH Number] <\/SPAN><\/SPAN>fields. The fire district to which the fh is associated is listed in the <\/SPAN><\/SPAN>DISTRICT [Fire District] <\/SPAN><\/SPAN>field, and the associated Council District is listed in <\/SPAN><\/SPAN>CouncilDist [Council District]<\/SPAN><\/SPAN>. The <\/SPAN><\/SPAN>MANUFACTUR [Model]<\/SPAN><\/SPAN>field uses the FireManu domain to list the fh<\/SPAN><\/SPAN>\u2019<\/SPAN><\/SPAN>s model, and the <\/SPAN><\/SPAN>MANUFACTU2 [Model Year]<\/SPAN><\/SPAN>field contains the year the fh was made. <\/SPAN><\/SPAN>STATUS [Status] <\/SPAN><\/SPAN>contains the fh<\/SPAN><\/SPAN>\u2019<\/SPAN><\/SPAN>s current repair status via the FHStatus domain (the status updates were provided via a weekly email from a designated Public Works Administrative Assistant but stopped after January 5, 2018, due to the implementation of a new work order system) while the <\/SPAN>DATEINSTAL [Update Date]<\/SPAN><\/SPAN>field contains the date of the status update email. The <\/SPAN><\/SPAN>VALVE_ON_H [Has Valve]<\/SPAN><\/SPAN>field uses the YesNo domain to indicate whether the fh has a water valve. The <\/SPAN><\/SPAN>GPS_DATE [GPS Date] <\/SPAN><\/SPAN>and <\/SPAN><\/SPAN>GPS_TIME [GPS Time]<\/SPAN><\/SPAN>fields contain information about when the feature was originally shot into the system. <\/SPAN>The <\/SPAN><\/SPAN>NORTHING [Northing (Y)]<\/SPAN><\/SPAN>, <\/SPAN><\/SPAN>EASTING [Easting (X)] Z [Elevation (Z)] <\/SPAN><\/SPAN>fields contain coordinate data.<\/SPAN><\/SPAN><\/P>

All Z values are in feet. All Elevation data is Surface Elevation.<\/SPAN><\/SPAN><\/P>

Due to VUEWorks (Public Works<\/SPAN><\/SPAN>\u2019<\/SPAN><\/SPAN>work order system), care must be taken when deleting features. The IDs cannot be reused and must be retired after a deletion. The retired IDs for this feature class are: 239, 1072, and 1703.<\/SPAN><\/P>

* Two of the fire district borders changed sometime before 2013 but <\/SPAN><\/SPAN>after<\/SPAN><\/SPAN>the fh numbering system was implemented, resulting in a situation where some fhs have numbers that do not match their district.<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102740, "latestWkid": 2278, "xyTolerance": 0.00328083333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -126725700, "falseY": -77828800, "xyUnits": 3048.0060960121905, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "Claunch and Miller, Inc.\nCity of Galveston", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "FLUSHEDSTATUS", "defaultSymbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 92, 230, 0 ], "size": 7, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 230, 152, 0, 0 ], "width": 0.7 } }, "defaultLabel": "", "uniqueValueGroups": [ { "heading": "Flushed Status", "classes": [ { "label": "Flushing is complete", "description": "Flushing is complete", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 38, 115, 0, 255 ], "size": 7, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "values": [ [ "Complete" ] ] }, { "label": "Flushing Needed", "description": "Flushing Needed", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 255, 115, 255 ], "size": 7, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "values": [ [ "Flushing Needed" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 38, 115, 0, 255 ], "size": 7, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "value": "Complete", "label": "Flushing is complete" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 255, 115, 255 ], "size": 7, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "value": "Flushing Needed", "label": "Flushing Needed" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 211, 252, 179, 255 ], "toColor": [ 211, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 235, 179, 252, 255 ], "toColor": [ 235, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 203, 189, 255 ], "toColor": [ 252, 203, 189, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 187, 240, 252, 255 ], "toColor": [ 187, 240, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 226, 212, 252, 255 ], "toColor": [ 226, 212, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 238, 187, 255 ], "toColor": [ 252, 238, 187, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 252, 222, 255 ], "toColor": [ 179, 252, 222, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 211, 255 ], "toColor": [ 252, 179, 211, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 185, 182, 252, 255 ], "toColor": [ 185, 182, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 228, 252, 215, 255 ], "toColor": [ 228, 252, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 212, 228, 255 ], "toColor": [ 252, 212, 228, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 214, 252, 255 ], "toColor": [ 182, 214, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 236, 212, 255 ], "toColor": [ 252, 236, 212, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3209905.857271239, "ymin": 1.3602029396505713E7, "xmax": 3327082.911630571, "ymax": 1.369391077639088E7, "spatialReference": { "wkid": 102740, "latestWkid": 2278, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -126725700, "falseY": -77828800, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "VALVE_ON_H", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FLUSHEDSTATUS", "type": "esriFieldTypeString", "alias": "Flushed Status", "length": 255, "domain": { "type": "codedValue", "name": "FlushedStatus", "description": "Status of hydrants flushing", "codedValues": [ { "name": "Flushing Needed", "code": "Flushing Needed" }, { "name": "Flushing is Complete", "code": "Complete" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSPECTOR", "type": "esriFieldTypeString", "alias": "Inspector", "length": 100, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location Description", "length": 255, "domain": null }, { "name": "Z", "type": "esriFieldTypeDouble", "alias": "Z", "domain": null }, { "name": "PHOTO", "type": "esriFieldTypeString", "alias": "Image", "length": 255, "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeSmallInteger", "alias": "Asset ID", "domain": null }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "\nLast Edited Date", "length": 8, "domain": null }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "\nLast Edited By", "length": 255, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "\nCreated Date", "length": 8, "domain": null }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "DATEINSPECTED", "type": "esriFieldTypeDate", "alias": "Date Inspected", "length": 8, "domain": null }, { "name": "STATICPRESSURE", "type": "esriFieldTypeDouble", "alias": "Static Pressure", "domain": null }, { "name": "NUMBER_OF_TURNS", "type": "esriFieldTypeDouble", "alias": "Number of Turns", "domain": null }, { "name": "FHNUMBER", "type": "esriFieldTypeString", "alias": "FH ID", "length": 20, "domain": null }, { "name": "FH_NO", "type": "esriFieldTypeSmallInteger", "alias": "FH Number", "domain": null }, { "name": "RESIDUALPRESSURE", "type": "esriFieldTypeDouble", "alias": "Residual Pressure", "domain": null }, { "name": "YEARINSTAL", "type": "esriFieldTypeDate", "alias": "Installation Year", "length": 8, "domain": null }, { "name": "EASTING", "type": "esriFieldTypeDouble", "alias": "Easting (X)", "domain": null }, { "name": "NORTHING", "type": "esriFieldTypeDouble", "alias": "Northing (Y)", "domain": null }, { "name": "GPS_TIME", "type": "esriFieldTypeString", "alias": "GPS Time", "length": 10, "domain": null }, { "name": "GPS_DATE", "type": "esriFieldTypeDate", "alias": "GPS Date", "length": 8, "domain": null }, { "name": "MANUFACTU2", "type": "esriFieldTypeSmallInteger", "alias": "Model Year", "domain": null }, { "name": "FLOW", "type": "esriFieldTypeString", "alias": "Flow", "length": 25, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "DATEINSTAL", "type": "esriFieldTypeDate", "alias": "Update Date", "length": 8, "domain": null }, { "name": "BONNETCOLOR", "type": "esriFieldTypeString", "alias": "Bonnet Color", "length": 25, "domain": { "type": "codedValue", "name": "BonnetColor", "description": "Bonnet Color", "codedValues": [ { "name": "Red", "code": "Red" }, { "name": "Orange", "code": "Orange" }, { "name": "Green", "code": "Green" }, { "name": "Blue", "code": "Blue" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COUNCILDIST", "type": "esriFieldTypeSmallInteger", "alias": "Council District", "domain": { "type": "codedValue", "name": "CouncilDistricts", "description": "Council Districts", "codedValues": [ { "name": "1", "code": 1 }, { "name": "2", "code": 2 }, { "name": "3", "code": 3 }, { "name": "4", "code": 4 }, { "name": "5", "code": 5 }, { "name": "6", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": { "type": "codedValue", "name": "FHStatus", "description": "Maintenance status of fire hydrants", "codedValues": [ { "name": "Functional", "code": "Functional" }, { "name": "Hydrant Needing Repairs", "code": "Needs Repaired" }, { "name": "Hydrant Needing Replacement", "code": "Needs Replaced" }, { "name": "Hydrant New to DB", "code": "New to DB" }, { "name": "Hydrant Inactive", "code": "Not Active" }, { "name": "Hydrant Repaired", "code": "Repaired" }, { "name": "Hydrant Replaced", "code": "Replaced" }, { "name": "Private Hydrant", "code": "Private" }, { "name": "Duplicate Hydrant", "code": "Duplicate" }, { "name": "Not Ike Related", "code": "Not Ike" }, { "name": "Hydrant Needing Paint", "code": "Needs Paint" }, { "name": "Hydrant Does Not Exist", "code": "Does Not Exist" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DISTRICT", "type": "esriFieldTypeSmallInteger", "alias": "Fire District", "domain": { "type": "codedValue", "name": "FireDistricts", "description": "Fire Districts", "codedValues": [ { "name": "1", "code": 1 }, { "name": "2", "code": 2 }, { "name": "4", "code": 4 }, { "name": "5", "code": 5 }, { "name": "7", "code": 7 }, { "name": "8", "code": 8 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FHNOPREFIX", "type": "esriFieldTypeSmallInteger", "alias": "FH Prefix", "domain": { "type": "codedValue", "name": "FireDistricts", "description": "Fire Districts", "codedValues": [ { "name": "1", "code": 1 }, { "name": "2", "code": 2 }, { "name": "4", "code": 4 }, { "name": "5", "code": 5 }, { "name": "7", "code": 7 }, { "name": "8", "code": 8 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MANUFACTUR", "type": "esriFieldTypeString", "alias": "Model", "length": 20, "domain": { "type": "codedValue", "name": "FireManu", "description": "Fire Hydrant Manufacturer", "codedValues": [ { "name": "Amer Darl B-62B", "code": "Amer Darl B-62B" }, { "name": "Amer Darl B-84B", "code": "Amer Darl B-84B" }, { "name": "Clow Challenger", "code": "Clow Challenger" }, { "name": "Clow Eddy", "code": "Clow Eddy" }, { "name": "Clow Medallion", "code": "Clow Medallion" }, { "name": "Kennedy", "code": "Kennedy" }, { "name": "M & H", "code": "M & H" }, { "name": "Matthews", "code": "Matthews" }, { "name": "Muel Super Cent 200", "code": "Muel Super Cent 200" }, { "name": "Muller Improved", "code": "Mueller Improved" }, { "name": "Mueller Old", "code": "Mueller Old" }, { "name": "Other", "code": "Other" }, { "name": "Waterous", "code": "Waterous" }, { "name": "Woods", "code": "Woods" }, { "name": "Unknown", "code": "UNK" }, { "name": "American Darling", "code": "American Darling" }, { "name": "Mueller Centurion", "code": "Mueller Centurion" }, { "name": "Weller", "code": "Weller" }, { "name": "Anniston", "code": "Anniston" }, { "name": "American Foundary", "code": "American Foundary" }, { "name": "AWWA", "code": "AWWA" }, { "name": "Mueller", "code": "Mueller" }, { "name": "East Jordon", "code": "East Jordon" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VALVE_ON_H", "type": "esriFieldTypeString", "alias": "Has Valve", "length": 20, "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_Shape", "fields": "Shape", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "c5e16246db654c0ea6ffe6f8b0353d40" }