{ "layers": [ { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 3, "name": "IowaCity.SDE.wHydrantR", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102676, "latestWkid": 3418, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 0.003280833333333333, "zTolerance": 0.003280833333333333, "mTolerance": 0.001, "falseX": -119240500, "falseY": -96507600, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD_1988_Foot_US", "heightUnit": "us-foot" }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 50000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 85, 255, 0, 255 ], "size": 12, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 85, 255, 0, 255 ], "width": 0 } } }, "scaleSymbols": false, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2151996.9765985236, "ymin": 591935.928136677, "xmax": 2197106.087535587, "ymax": 623631.1866296022, "spatialReference": { "wkid": 102676, "latestWkid": 3418, "xyTolerance": 0.003280833333333333, "zTolerance": 0.003280833333333333, "mTolerance": 0.001, "falseX": -119240500, "falseY": -96507600, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 3048.006096012192, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "HYD_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "HYD_ID", "type": "esriFieldTypeString", "alias": "HYD_ID", "length": 50, "domain": null }, { "name": "OWNERSHIP", "type": "esriFieldTypeString", "alias": "OWNERSHIP", "length": 20, "domain": { "type": "codedValue", "name": "wOwnership", "description": "Ownership of water assests", "codedValues": [ { "name": "City", "code": "City" }, { "name": "Other", "code": "Other" }, { "name": "Private", "code": "Private" }, { "name": "Raw", "code": "Raw" }, { "name": "Killed-City", "code": "Killed-City" }, { "name": "Killed-Private", "code": "Killed-Private" }, { "name": "Killed-Raw", "code": "Killed-Raw" }, { "name": "Proposed-City", "code": "Proposed-City" }, { "name": "Proposed-Private", "code": "Proposed-Private" }, { "name": "U of Iowa", "code": "U of Iowa" }, { "name": "Coralville", "code": "Coralville" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAP_NUM", "type": "esriFieldTypeString", "alias": "MAP_NUM", "length": 20, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 256, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 50, "domain": { "type": "codedValue", "name": "wHydrantManufacturer", "description": "The name of the hydrant manufacturer", "codedValues": [ { "name": "AMERICAN DARLING", "code": "AMERICAN DARLING" }, { "name": "CLOW", "code": "CLOW" }, { "name": "EDDY", "code": "EDDY" }, { "name": "IOWA", "code": "IOWA" }, { "name": "KENNEDY", "code": "KENNEDY" }, { "name": "LUDLOW", "code": "LUDLOW" }, { "name": "M&H", "code": "M&H" }, { "name": "MUELLER", "code": "MUELLER" }, { "name": "TRAVERSE CITY", "code": "TRAVERSE CITY" }, { "name": "WATEROUS", "code": "WATEROUS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "HYD_MODEL", "type": "esriFieldTypeString", "alias": "HYD_MODEL", "length": 50, "domain": { "type": "codedValue", "name": "wHydrantModel", "description": "Model of fire hydrant", "codedValues": [ { "name": "F-2545", "code": "F-2545" }, { "name": "F-2500", "code": "F-2500" }, { "name": "MK-73", "code": "MK-73" }, { "name": "B-84-B-5", "code": "B-84-B-5" }, { "name": "Improved", "code": "Improved" }, { "name": "K-81-A", "code": "K-81-A" }, { "name": "Super Centurion", "code": "Super Centurion" }, { "name": "Centurion", "code": "Centurion" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "YEAR_MAN", "type": "esriFieldTypeSmallInteger", "alias": "YEAR_MAN", "domain": null }, { "name": "HYD_SIZE", "type": "esriFieldTypeDouble", "alias": "HYD_SIZE", "domain": null }, { "name": "NOZZLE_NUM", "type": "esriFieldTypeSmallInteger", "alias": "NOZZLE_NUM", "domain": null }, { "name": "BURY_DEPTH", "type": "esriFieldTypeDouble", "alias": "BURY_DEPTH", "domain": null }, { "name": "HYD_EXTEN", "type": "esriFieldTypeSingle", "alias": "HYD_EXTEN", "domain": null }, { "name": "YEAR_INST", "type": "esriFieldTypeSmallInteger", "alias": "YEAR_INST", "domain": null }, { "name": "AUX_VAL", "type": "esriFieldTypeString", "alias": "AUX_VAL", "length": 5, "domain": { "type": "codedValue", "name": "wYesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "UNKNOWN", "code": "UNK" }, { "name": "NOT APPLICABLE", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "VALVE_DIAM", "type": "esriFieldTypeSingle", "alias": "VALVE_DIAM", "domain": null }, { "name": "ROUTE_NUM", "type": "esriFieldTypeString", "alias": "ROUTE_NUM", "length": 20, "domain": null }, { "name": "ROUTE_ORDER", "type": "esriFieldTypeDouble", "alias": "ROUTE_ORDER", "domain": null }, { "name": "DEAD_END", "type": "esriFieldTypeString", "alias": "DEAD_END", "length": 10, "domain": { "type": "codedValue", "name": "wYesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "UNKNOWN", "code": "UNK" }, { "name": "NOT APPLICABLE", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DE_NUM", "type": "esriFieldTypeString", "alias": "DE_NUM", "length": 10, "domain": null }, { "name": "DE_ORDER", "type": "esriFieldTypeDouble", "alias": "DE_ORDER", "domain": null }, { "name": "STATIC_PRES", "type": "esriFieldTypeSmallInteger", "alias": "STATIC_PRES", "domain": null }, { "name": "DATE_REC", "type": "esriFieldTypeDate", "alias": "DATE_REC", "length": 8, "domain": null }, { "name": "MAIN_DIAM", "type": "esriFieldTypeSmallInteger", "alias": "MAIN_DIAM", "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "NOTES", "length": 500, "domain": null }, { "name": "BILLING", "type": "esriFieldTypeString", "alias": "BILLING", "length": 50, "domain": { "type": "codedValue", "name": "wHydrantBilling", "description": "Entity billed for private hydrant maintenance program", "codedValues": [ { "name": "U OF I", "code": "U OF I" }, { "name": "UI-DUAL", "code": "UI-DUAL" }, { "name": "UNIVERSITY HEIGHTS", "code": "UNIVERSITY HEIGHTS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "EASTING", "type": "esriFieldTypeDouble", "alias": "EASTING", "domain": null }, { "name": "NORTHING", "type": "esriFieldTypeDouble", "alias": "NORTHING", "domain": null }, { "name": "GPS_ACCURACY", "type": "esriFieldTypeString", "alias": "GPS_ACCURACY", "length": 50, "domain": { "type": "codedValue", "name": "wGPSAccuracy", "description": "Accuracy category for GPS point", "codedValues": [ { "name": "CAD 3FT TO 300FT", "code": "CAD" }, { "name": "GPS RECREATIONAL GRADE 10M TO 30FT", "code": "REC" }, { "name": "GPS MAPPING GRADE 4IN TO 1M", "code": "MAP" }, { "name": "GPS RTK SURVEY GRADE 2CM", "code": "SVY" }, { "name": "UNKNOWN", "code": "UNK" }, { "name": "CANNOT RECORD GPS", "code": "NON" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "LAT_DIAM", "type": "esriFieldTypeSingle", "alias": "LAT_DIAM", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "GPM", "type": "esriFieldTypeDouble", "alias": "Gallons per Minute", "domain": null }, { "name": "Storz_Conn", "type": "esriFieldTypeString", "alias": "Storz_Connection", "length": 10, "domain": { "type": "codedValue", "name": "wYesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "UNKNOWN", "code": "UNK" }, { "name": "NOT APPLICABLE", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ANN_BAC_SAM_HYD", "type": "esriFieldTypeString", "alias": "Annual Bacterial Sample Hydrant", "length": 10, "domain": { "type": "codedValue", "name": "wYesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "UNKNOWN", "code": "UNK" }, { "name": "NOT APPLICABLE", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R498_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_498", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_498", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_957_HYD_ID", "fields": "HYD_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S456_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "SDE.HydrantMaintenanceInspection", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "HYD_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{61A71E8C-D5EE-45D0-B22D-FD14F4430349}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "maxSelectionCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "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": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1694167777000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "7bc86292d3a540db8598ac1a5de732f5" } ], "tables": [ { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 2, "name": "HydrantMaintenanceInspection", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "OBJECTID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PRESSURE", "type": "esriFieldTypeDouble", "alias": "Pressure (PSI)", "domain": null }, { "name": "FACILITYKEY", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 50, "domain": null }, { "name": "INSPECTOR", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": { "type": "codedValue", "name": "wDist_Inspector", "description": "List of Water Distribution Staff", "codedValues": [ { "name": "Alex Lorack", "code": "AL" }, { "name": "Brian Bailey", "code": "BB" }, { "name": "Dave Exline", "code": "DE" }, { "name": "Dave Worby", "code": "DW" }, { "name": "Eric Gringer", "code": "EG" }, { "name": "Michael Willis", "code": "MW" }, { "name": "Nate Swartzentruber", "code": "NS" }, { "name": "Tony Stipes", "code": "TS" }, { "name": "Justin Sellers", "code": "JS" }, { "name": "David Bontrager", "code": "DB" }, { "name": "Shawn Ostrander", "code": "SO" }, { "name": "Kyle Westfall", "code": "KW" }, { "name": "Bill Donahue", "code": "BD" }, { "name": "Mathew Solinger", "code": "MS" }, { "name": "Garrit Thomann", "code": "GT" }, { "name": "Michael Frieden", "code": "MF" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "NOTES", "length": 1000, "domain": null }, { "name": "DateInspected", "type": "esriFieldTypeDate", "alias": "Date Inspected", "length": 8, "domain": null }, { "name": "HydAccessible", "type": "esriFieldTypeString", "alias": "Hydrant Accessible?", "length": 10, "domain": { "type": "codedValue", "name": "wYesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "UNKNOWN", "code": "UNK" }, { "name": "NOT APPLICABLE", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "HydDrains", "type": "esriFieldTypeString", "alias": "Hydrant Drains?", "length": 10, "domain": { "type": "codedValue", "name": "wYesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "UNKNOWN", "code": "UNK" }, { "name": "NOT APPLICABLE", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "HydFlushed", "type": "esriFieldTypeString", "alias": "Hyd Flushed?", "length": 10, "domain": { "type": "codedValue", "name": "wYesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "UNKNOWN", "code": "UNK" }, { "name": "NOT APPLICABLE", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "HydPaint", "type": "esriFieldTypeString", "alias": "Paint Req'd?", "length": 10, "domain": { "type": "codedValue", "name": "wYesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "UNKNOWN", "code": "UNK" }, { "name": "NOT APPLICABLE", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LocatorBox", "type": "esriFieldTypeString", "alias": "Locator Box?", "length": 10, "domain": { "type": "codedValue", "name": "wYesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "UNKNOWN", "code": "UNK" }, { "name": "NOT APPLICABLE", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "RepairsNeeded", "type": "esriFieldTypeString", "alias": "Repairs Needed", "length": 10, "domain": { "type": "codedValue", "name": "wYesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "UNKNOWN", "code": "UNK" }, { "name": "NOT APPLICABLE", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "RepairNotes", "type": "esriFieldTypeString", "alias": "Repair Notes", "length": 200, "domain": null }, { "name": "FlushTime", "type": "esriFieldTypeDouble", "alias": "Flush Time in Minutes", "domain": null }, { "name": "WaterLoss", "type": "esriFieldTypeDouble", "alias": "Water Loss in Gallons", "domain": null }, { "name": "TotalChlorine", "type": "esriFieldTypeDouble", "alias": "Total Chlorine", "domain": null }, { "name": "InspectionStatus", "type": "esriFieldTypeString", "alias": "InspectionStatus", "length": 25, "domain": { "type": "codedValue", "name": "wHydrantInspectStatus", "description": "Hydrant Inspection Status", "codedValues": [ { "name": "Complete", "code": "Complete" }, { "name": "Complete Needs Work Order", "code": "Needs Work Order" }, { "name": "In Progress", "code": "In Progress" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HydOperational", "type": "esriFieldTypeString", "alias": "Hyd Operational?", "length": 10, "domain": { "type": "codedValue", "name": "wYesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "UNKNOWN", "code": "UNK" }, { "name": "NOT APPLICABLE", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Repairs_1", "type": "esriFieldTypeString", "alias": "Repairs 1", "length": 100, "domain": { "type": "codedValue", "name": "wHydRepairs", "description": "Hydrant Repairs", "codedValues": [ { "name": "Bolt", "code": "Bolt" }, { "name": "Broken Flange", "code": "Broken Flange" }, { "name": "Coupler", "code": "Coupler" }, { "name": "Crooked", "code": "Crooked" }, { "name": "Does Not Drain", "code": "Does Not Drain" }, { "name": "Does Not Shut Off", "code": "Does Not Shut Off" }, { "name": "Drains Slow", "code": "Drains Slow" }, { "name": "Hydrant High", "code": "Hydrant High" }, { "name": "Hydrant Hit", "code": "Hydrant Hit" }, { "name": "Hydrant Low", "code": "Hydrant Low" }, { "name": "Leaks", "code": "Leaks" }, { "name": "Locator Box Issue", "code": "Locator Box Issue" }, { "name": "Nozzle Threads Damaged", "code": "Nozzle Threads Damaged" }, { "name": "Oil/Grease", "code": "Oil/Grease" }, { "name": "Operator", "code": "Operator" }, { "name": "Other", "code": "Other" }, { "name": "Shaft Dropped", "code": "Shaft Dropped" }, { "name": "Stem", "code": "Stem" }, { "name": "Turns Hard", "code": "Turns Hard" }, { "name": "Wiring", "code": "Wiring" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Repairs_2", "type": "esriFieldTypeString", "alias": "Repairs 2", "length": 100, "domain": { "type": "codedValue", "name": "wHydRepairs", "description": "Hydrant Repairs", "codedValues": [ { "name": "Bolt", "code": "Bolt" }, { "name": "Broken Flange", "code": "Broken Flange" }, { "name": "Coupler", "code": "Coupler" }, { "name": "Crooked", "code": "Crooked" }, { "name": "Does Not Drain", "code": "Does Not Drain" }, { "name": "Does Not Shut Off", "code": "Does Not Shut Off" }, { "name": "Drains Slow", "code": "Drains Slow" }, { "name": "Hydrant High", "code": "Hydrant High" }, { "name": "Hydrant Hit", "code": "Hydrant Hit" }, { "name": "Hydrant Low", "code": "Hydrant Low" }, { "name": "Leaks", "code": "Leaks" }, { "name": "Locator Box Issue", "code": "Locator Box Issue" }, { "name": "Nozzle Threads Damaged", "code": "Nozzle Threads Damaged" }, { "name": "Oil/Grease", "code": "Oil/Grease" }, { "name": "Operator", "code": "Operator" }, { "name": "Other", "code": "Other" }, { "name": "Shaft Dropped", "code": "Shaft Dropped" }, { "name": "Stem", "code": "Stem" }, { "name": "Turns Hard", "code": "Turns Hard" }, { "name": "Wiring", "code": "Wiring" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R3014_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_19186_FACILI", "fields": "FACILITYKEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_3014", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_3014", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "SDE.wHydrantR", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "FACILITYKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{61A71E8C-D5EE-45D0-B22D-FD14F4430349}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1694167777000 }, "serviceItemId": "7bc86292d3a540db8598ac1a5de732f5" } ] }