{ "tables": [{ "preferredTimeReference": null, "maxRecordCount": 1000, "description": null, "datesInUnknownTimezone": false, "type": "Table", "subtypes": [], "relationships": [{ "keyField": "HYDRANT_ID", "role": "esriRelRoleDestination", "catalogID": "{38A01A21-FDF1-476C-A39D-D782462786B6}", "composite": false, "name": "Related Hydrants", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }], "indexes": [ { "name": "R1034_SDE_ROWID_UK", "isUnique": true, "description": "", "fields": "OBJECTID", "isAscending": true }, { "name": "UUID_1034", "isUnique": true, "description": "", "fields": "GlobalID", "isAscending": true }, { "name": "G1283HYDRANT_ID", "isUnique": false, "description": "", "fields": "HYDRANT_ID", "isAscending": true }, { "name": "UUID_OID_1034", "isUnique": true, "description": "", "fields": "GlobalID,OBJECTID", "isAscending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeNone", "cimVersion": "3.6.0", "isDataArchived": false, "id": 1, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "hasAttachments": false, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsTrueCurve": false, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": true, "useStandardizedQueries": false, "supportsQueryWithDistance": true, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsPagination": true, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "subtypeFieldName": null, "supportsStatistics": true, "serviceItemId": "fd4e6ed2b93e4359be52a7e191307e00", "capabilities": "Map,Query,Data", "supportsExceedsLimitStatistics": true, "isDataVersioned": true, "supportsAdvancedQueries": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": false, "currentVersion": 12, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, PBF", "name": "esri_sde.DBO.Fire_Hydrant_Flushing_Records", "displayField": "HYDRANT_ID", "copyrightText": null, "fields": [ { "nullable": false, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "HYDRANT_ID", "length": 20, "alias": "HYDRANT_ID", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "DATE", "length": 8, "alias": "DATE", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "PRESSURE", "alias": "PRESSURE", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "GPM", "alias": "GPM", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "FLUSH_MINS", "alias": "FLUSH_MINS", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "GALLONS_FLUSHED", "alias": "GALLONS_FLUSHED", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "STAFF_MEMBER", "length": 50, "alias": "STAFF_MEMBER", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "created_date", "length": 8, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "last_edited_date", "length": 8, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": false, "domain": null, "name": "GlobalID", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" } ], "dateFieldsTimeReference": null }], "layers": [{ "extent": { "ymin": 466296.19298776984, "xmin": 1380436.0544322729, "ymax": 29357946.636277363, "xmax": 27099184.254300207, "spatialReference": { "falseM": -100000, "xyTolerance": 0.0032808333333333331, "mUnits": 10000, "zUnits": 1, "latestWkid": 2893, "zTolerance": 2, "wkid": 2893, "xyUnits": 36953082.2945481166, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "falseZ": 0 } }, "maxRecordCount": 1000, "datesInUnknownTimezone": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "type": "Feature Layer", "maxSelectionCount": 2000, "subtypes": [], "relationships": [{ "keyField": "HYDRANT_ID", "role": "esriRelRoleOrigin", "catalogID": "{38A01A21-FDF1-476C-A39D-D782462786B6}", "composite": false, "name": "Related Flushing Records", "relatedTableId": 1, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }], "cimVersion": "3.6.0", "isDataArchived": false, "id": 0, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "spatialReference": { "falseM": -100000, "xyTolerance": 0.0032808333333333331, "mUnits": 10000, "zUnits": 1, "latestWkid": 2893, "zTolerance": 2, "wkid": 2893, "xyUnits": 36953082.2945481166, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "falseZ": 0 }, "subtypeFieldName": null, "supportsStatistics": true, "isDataVersioned": true, "supportsAdvancedQueries": true, "parentLayer": null, "subLayers": [], "currentVersion": 12, "canScaleSymbols": false, "name": "Levitt_Fire_Hydrant", "displayField": "HYDRANT_ID", "fields": [ { "nullable": false, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "HYDRANT_ID", "length": 20, "alias": "HYDRANT_ID", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Fire_Hydrant_Type", "description": "Fire Hydrant Type", "type": "codedValue", "codedValues": [ { "code": "Kennedy", "name": "Kennedy" }, { "code": "Mueller", "name": "Mueller" }, { "code": "Matthews", "name": "Matthews" }, { "code": "American Darling", "name": "American Darling" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "HYDR_TYPE", "length": 20, "alias": "HYDR_TYPE", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "HYDR_ELEV", "alias": "HYDR_ELEV", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "NOTES", "length": 50, "alias": "NOTES", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "HOUSE", "alias": "HOUSE", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "STREET", "length": 25, "alias": "STREET", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ST_TYPE", "length": 10, "alias": "ST_TYPE", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "created_date", "length": 8, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "last_edited_date", "length": 8, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "Shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, { "nullable": false, "domain": null, "name": "GlobalID", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "domain": null, "name": "Flushed_Yet", "length": 10, "alias": "Flushed_Yet", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Fitting", "length": 20, "alias": "Fitting", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Buried_Depth", "length": 20, "alias": "Buried_Depth", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Last_Painted_Date", "length": 8, "alias": "Last_Painted_Date", "type": "esriFieldTypeDate" } ], "dateFieldsTimeReference": null, "preferredTimeReference": null, "sourceSpatialReference": { "falseM": 0, "xyTolerance": 0.0032808333333333335, "mUnits": 1, "zUnits": 1, "latestWkid": 2893, "zTolerance": 0.001, "wkid": 2893, "xyUnits": 3048.00609601219139, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "falseZ": 0 }, "description": "", "canModifyLayer": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "indexes": [ { "name": "R1073_pk", "isUnique": true, "description": "", "fields": "OBJECTID", "isAscending": true }, { "name": "UUID_1073", "isUnique": true, "description": "", "fields": "GlobalID", "isAscending": true }, { "name": "G1326HYDRANT_ID", "isUnique": false, "description": "", "fields": "HYDRANT_ID", "isAscending": true }, { "name": "UUID_OID_1073", "isUnique": true, "description": "", "fields": "GlobalID,OBJECTID", "isAscending": true }, { "name": "S992_idx", "isUnique": true, "description": "", "fields": "Shape", "isAscending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "supportsDatumTransformation": true, "minScale": 0, "supportsDynamicLegends": true, "hasAttachments": false, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsTrueCurve": true, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": true, "useStandardizedQueries": false, "supportsLod": false, "supportsQueryWithDistance": true, "supportsQueryWithDatumTransformation": true, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsQueryWithLodSR": false, "supportsPagination": true, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "serviceItemId": "fd4e6ed2b93e4359be52a7e191307e00", "supportsCoordinatesQuantization": true, "capabilities": "Map,Query,Data", "maxScale": 0, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": false, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, geoJSON, PBF", "hasLabels": false, "drawingInfo": { "renderer": { "uniqueValueGroups": [{ "heading": "Flushed_Yet", "classes": [ { "symbol": { "imageData": "Qk02AwAAAAAAADYAAAAoAAAAEAAAABAAAAABABgAAAAAAAADAAAAAAAAAAAAAAAAAAAAAAAAAIAAAIAAAIAAAIAAAIAAgAAAgAAAgAAAgAAAgAAAgAAAAIAAAIAAAIAAAIAAAIAAAIAAAIAAAIAAAIAAAIAAgAAAgAAAgAAAgAAAgAAAgAAAAIAAAIAAAIAAAIAAAIAAAIAAAIAAAIAAAAD/AAD/AAD/AAD/AAD/AAD/AAD/AAD/AAD/AAD/AIAAAIAAAIAA////////////////////AAD/AACAAAD/AAD/AACAAAD/////////////////////////////////////////AAD/AAD/AAD/AAD/AAD/AAD/////////////////////////////////////////AAD/AACAAAD/AAD/AACAAAD/////////////////////////////////////////AAD/AAD/AAD/AAD/AAD/AAD/////////////////////////////////////////AAD/AACAAAD/AAD/AACAAAD/////////////////////////////////////////AACAAACAAACAAACAAACAAACA////////////////////////////////////AAD/AAD/AAD/AAD/AAD/AAD/AAD/AAD/////////////////////////////////////AAD/AAD/AAD/AAD/AAD/AAD/////////////////////////////////////////////AAD/AAD/AAD/AAD/////////////////////////////////////////////////////AAD/AAD/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////", "yoffset": 0, "width": 18, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "db620a94aca9947eb60320ee024bf8e9", "height": 18 }, "values": [["No"]], "description": "No", "label": "No" }, { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAACgAAAAoCAYAAACM/rhtAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABn0lEQVRYhe2Yv06DUBTGv9NgJ3V0cfQNfAyT1skHaHcHxZ0SVyMmprNxcTaS+BY+hulu2Fo85hCQv0XAXv6UfhNc4PLjO/fchE9Dy6Why4CX73youThQDWGN6LMw4JXNx0QYk4tzrHAEqAfUbXbYhbUc4vXxjL7WAgrcgHELxgUI+6hLDNAAz8MVngBM1wKKcx4caoSLa3Jt88f9iObZgFLWOp3LEH1jBCANKA3hr7lmRTiJnv4C+t2aaog7+R6FurHTY9ILQWd3ex9sgzT0CpAoPGbeyJQ9cZAoe2wDLmpK4JLX/gG6xSUmKndvRRerA/ovNAuAGrsS58gQFyPHgczEeaMOGgXHqmj7SyzalbjN0jpfYjLTGzHPSpaYwjko8ax+yj0sMUVdmCUsyVKRe3rlYKsA9T8WMd6KvKZEPxOcTED5UZaUSYKcRsVYWOMwjos5KBGYpExoTg4zXqIDMUDJ5/wIbFI7GiDVe1juxRdNDNAPD6cSgXkpUyLIUSLywBbinMDlBpiB/HxuHgQ5qhmtyJor3cV5+TFqUOv3wR+64YE4wP8EuAAAAABJRU5ErkJggg==", "yoffset": 0, "width": 30, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "d32e6c89529c868d86a2beaa49cc77bd", "height": 30 }, "values": [["Yes"]], "description": "Yes", "label": "Yes" } ] }], "field1": "Flushed_Yet", "authoringInfo": {"colorRamp": { "colorRamps": [ { "toColor": [ 242, 252, 204, 255 ], "fromColor": [ 242, 252, 204, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 188, 179, 252, 255 ], "fromColor": [ 188, 179, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 182, 188, 255 ], "fromColor": [ 252, 182, 188, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 179, 230, 252, 255 ], "fromColor": [ 179, 230, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 215, 251, 255 ], "fromColor": [ 252, 215, 251, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 179, 252, 224, 255 ], "fromColor": [ 179, 252, 224, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 217, 197, 255 ], "fromColor": [ 252, 217, 197, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 195, 252, 179, 255 ], "fromColor": [ 195, 252, 179, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 242, 182, 252, 255 ], "fromColor": [ 242, 182, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 212, 217, 252, 255 ], "fromColor": [ 212, 217, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 182, 218, 255 ], "fromColor": [ 252, 182, 218, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 212, 252, 250, 255 ], "fromColor": [ 212, 252, 250, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 210, 219, 255 ], "fromColor": [ 252, 210, 219, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" }}, "uniqueValueInfos": [ { "symbol": { "imageData": "Qk02AwAAAAAAADYAAAAoAAAAEAAAABAAAAABABgAAAAAAAADAAAAAAAAAAAAAAAAAAAAAAAAAIAAAIAAAIAAAIAAAIAAgAAAgAAAgAAAgAAAgAAAgAAAAIAAAIAAAIAAAIAAAIAAAIAAAIAAAIAAAIAAAIAAgAAAgAAAgAAAgAAAgAAAgAAAAIAAAIAAAIAAAIAAAIAAAIAAAIAAAIAAAAD/AAD/AAD/AAD/AAD/AAD/AAD/AAD/AAD/AAD/AIAAAIAAAIAA////////////////////AAD/AACAAAD/AAD/AACAAAD/////////////////////////////////////////AAD/AAD/AAD/AAD/AAD/AAD/////////////////////////////////////////AAD/AACAAAD/AAD/AACAAAD/////////////////////////////////////////AAD/AAD/AAD/AAD/AAD/AAD/////////////////////////////////////////AAD/AACAAAD/AAD/AACAAAD/////////////////////////////////////////AACAAACAAACAAACAAACAAACA////////////////////////////////////AAD/AAD/AAD/AAD/AAD/AAD/AAD/AAD/////////////////////////////////////AAD/AAD/AAD/AAD/AAD/AAD/////////////////////////////////////////////AAD/AAD/AAD/AAD/////////////////////////////////////////////////////AAD/AAD/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////", "yoffset": 0, "width": 18, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "db620a94aca9947eb60320ee024bf8e9", "height": 18 }, "label": "No", "value": "No" }, { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAACgAAAAoCAYAAACM/rhtAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABn0lEQVRYhe2Yv06DUBTGv9NgJ3V0cfQNfAyT1skHaHcHxZ0SVyMmprNxcTaS+BY+hulu2Fo85hCQv0XAXv6UfhNc4PLjO/fchE9Dy6Why4CX73youThQDWGN6LMw4JXNx0QYk4tzrHAEqAfUbXbYhbUc4vXxjL7WAgrcgHELxgUI+6hLDNAAz8MVngBM1wKKcx4caoSLa3Jt88f9iObZgFLWOp3LEH1jBCANKA3hr7lmRTiJnv4C+t2aaog7+R6FurHTY9ILQWd3ex9sgzT0CpAoPGbeyJQ9cZAoe2wDLmpK4JLX/gG6xSUmKndvRRerA/ovNAuAGrsS58gQFyPHgczEeaMOGgXHqmj7SyzalbjN0jpfYjLTGzHPSpaYwjko8ax+yj0sMUVdmCUsyVKRe3rlYKsA9T8WMd6KvKZEPxOcTED5UZaUSYKcRsVYWOMwjos5KBGYpExoTg4zXqIDMUDJ5/wIbFI7GiDVe1juxRdNDNAPD6cSgXkpUyLIUSLywBbinMDlBpiB/HxuHgQ5qhmtyJor3cV5+TFqUOv3wR+64YE4wP8EuAAAAABJRU5ErkJggg==", "yoffset": 0, "width": 30, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "d32e6c89529c868d86a2beaa49cc77bd", "height": 30 }, "label": "Yes", "value": "Yes" } ], "type": "uniqueValue", "fieldDelimiter": "," }, "scaleSymbols": false, "transparency": 0, "labelingInfo": null }, "geometryField": { "name": "Shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPoint" }] }