{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 378, "name": "GIS.wHydrant", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102671, "latestWkid": 3435, "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 99, 173, 62, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1001912.6059025042, "ymin": 1921356.862038426, "xmax": 1033999.8032109216, "ymax": 1956839.7674504295, "spatialReference": { "wkid": 102671, "latestWkid": 3435, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "ROTATION", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 30, "domain": { "type": "codedValue", "name": "wHydrantManufacturer", "description": "The name of the hydrant manufacturer", "codedValues": [ { "name": "American Darling", "code": "American Darling" }, { "name": "Clow Corporation", "code": "Clow Corporation" }, { "name": "Corey", "code": "Corey" }, { "name": "Dresser", "code": "Dresser" }, { "name": "Kennedy Valve", "code": "Kennedy Valve" }, { "name": "M&H Valve", "code": "M&H Valve" }, { "name": "M&H Valve / Dresser", "code": "M&H Valve / Dresser" }, { "name": "Mueller Company", "code": "Mueller Company" }, { "name": "US Pipe", "code": "US Pipe" }, { "name": "Wood-Matthews", "code": "Wood-Matthews" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Eddy", "code": "Eddy" }, { "name": "Traverse City", "code": "Traverse City" }, { "name": "Waterous", "code": "Waterous" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OPERABLE", "type": "esriFieldTypeSmallInteger", "alias": "Operable", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LASTSERVICE", "type": "esriFieldTypeDate", "alias": "Last Service Date", "length": 8, "domain": null }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "AssetOwner_2", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "MWRD", "code": -3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "AssetManager_2", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "MWRD", "code": -3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "Flow", "type": "esriFieldTypeDouble", "alias": "Flow", "domain": null }, { "name": "Lat", "type": "esriFieldTypeDouble", "alias": "Lat", "domain": null }, { "name": "Long", "type": "esriFieldTypeDouble", "alias": "Long", "domain": null }, { "name": "PaintCycle", "type": "esriFieldTypeString", "alias": "PaintCycle", "length": 255, "domain": null }, { "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": "Zone", "type": "esriFieldTypeString", "alias": "Zone", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R1225_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1225", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S1092_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "BARTLETT_GIS.GIS.Hydrant_Inspect", "relatedTableId": 370, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": 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, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "9002f7043d9147b8bcc2ab5d0d958a4d" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 370, "name": "Hydrant Inspection", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Date", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date of Inspection", "length": 8, "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspected by", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 1073741822, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Make/Model", "length": 255, "domain": { "type": "codedValue", "name": "wHydrantManufacturer", "description": "The name of the hydrant manufacturer", "codedValues": [ { "name": "American Darling", "code": "American Darling" }, { "name": "Clow Corporation", "code": "Clow Corporation" }, { "name": "Corey", "code": "Corey" }, { "name": "Dresser", "code": "Dresser" }, { "name": "Kennedy Valve", "code": "Kennedy Valve" }, { "name": "M&H Valve", "code": "M&H Valve" }, { "name": "M&H Valve / Dresser", "code": "M&H Valve / Dresser" }, { "name": "Mueller Company", "code": "Mueller Company" }, { "name": "US Pipe", "code": "US Pipe" }, { "name": "Wood-Matthews", "code": "Wood-Matthews" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Eddy", "code": "Eddy" }, { "name": "Traverse City", "code": "Traverse City" }, { "name": "Waterous", "code": "Waterous" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Paint", "type": "esriFieldTypeString", "alias": "Paint Condition", "length": 255, "domain": { "type": "codedValue", "name": "Hydrant_Inspect_Conditions", "description": "Conditions for Hydrants Inspections", "codedValues": [ { "name": "Poor", "code": "Poor" }, { "name": "Fair", "code": "Fair" }, { "name": "Good", "code": "Good" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Obstruction", "type": "esriFieldTypeString", "alias": "5' radius obstruction", "length": 1073741822, "domain": null }, { "name": "Height", "type": "esriFieldTypeString", "alias": "Proper Height?", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Auxiliary_valve", "type": "esriFieldTypeString", "alias": "Aux Valve to grade?", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Auxiliary_Condition", "type": "esriFieldTypeString", "alias": "Aux Valve Condition", "length": 255, "domain": { "type": "codedValue", "name": "Hydrant_Inspect_Conditions", "description": "Conditions for Hydrants Inspections", "codedValues": [ { "name": "Poor", "code": "Poor" }, { "name": "Fair", "code": "Fair" }, { "name": "Good", "code": "Good" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Port_Caps", "type": "esriFieldTypeString", "alias": "Port Caps removed?", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Cap_Gaskets", "type": "esriFieldTypeString", "alias": "Check cap gaskets?", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Threads", "type": "esriFieldTypeString", "alias": "Greased threads?", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Chains", "type": "esriFieldTypeString", "alias": "Chains on caps?", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Operational", "type": "esriFieldTypeString", "alias": "Operational", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PSI", "type": "esriFieldTypeInteger", "alias": "PSI", "domain": null }, { "name": "Leaks", "type": "esriFieldTypeString", "alias": "Leaks", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Aux_Valve_working", "type": "esriFieldTypeString", "alias": "Aux Valve working?", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Aux_Valve_turns", "type": "esriFieldTypeInteger", "alias": "# of turns to close Aux Valve", "domain": null }, { "name": "Turns_to_close", "type": "esriFieldTypeInteger", "alias": "# of Turns to Close", "domain": null }, { "name": "Drain", "type": "esriFieldTypeString", "alias": "Drains?", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Operating_nut", "type": "esriFieldTypeString", "alias": "Operating Nut Condition", "length": 255, "domain": { "type": "codedValue", "name": "Hydrant_Inspect_Conditions", "description": "Conditions for Hydrants Inspections", "codedValues": [ { "name": "Poor", "code": "Poor" }, { "name": "Fair", "code": "Fair" }, { "name": "Good", "code": "Good" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "operating_nut_type", "type": "esriFieldTypeString", "alias": "Type of operating nut", "length": 255, "domain": null }, { "name": "operating_nut_lube", "type": "esriFieldTypeString", "alias": "Lubrication of operating nut?", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Repairs needed or performed/Notes", "length": 1073741822, "domain": null }, { "name": "Createdby", "type": "esriFieldTypeString", "alias": "Createdby", "length": 255, "domain": null }, { "name": "DateCreated", "type": "esriFieldTypeDate", "alias": "DateCreated", "length": 8, "domain": null }, { "name": "Editedby", "type": "esriFieldTypeString", "alias": "Editedby", "length": 255, "domain": null }, { "name": "DateEdited", "type": "esriFieldTypeDate", "alias": "DateEdited", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 20, "domain": null }, { "name": "Zone", "type": "esriFieldTypeString", "alias": "Zone Number", "length": 20, "domain": null }, { "name": "GUID", "type": "esriFieldTypeGUID", "alias": "GUID", "length": 38, "domain": null } ], "indexes": [ { "name": "R1712_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5509_GUID", "fields": "GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_1712", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "BARTLETT_GIS.GIS.wHydrant", "relatedTableId": 378, "role": "esriRelRoleDestination", "keyField": "GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "9002f7043d9147b8bcc2ab5d0d958a4d" } ] }