{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 162, "name": "UM Backflow Locations", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2253, "latestWkid": 2253, "xyTolerance": 2.5600000022937597E-4, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -1.0713859999994804E8, "falseY": -9.719379999999212E7, "xyUnits": 31249.999972, "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": "esriPMS", "url": "f109eb7fb609ad0c79fe0d0b8b292f81", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABUklEQVQ4jbXSMW7CMBSA4f8J5qwRKRdgiYSCxAmyZeoYIoWJHgCpMwNTJQ5AJlAjLhC2nKBDhJSFC4SgrFzAHSKXEChL1bfZfu+z/ewuf4zu/wB+6SBqgYgD9IAzSmUoWbCzsufA5JQgeCDN2R4iHoJHUEbE1ttjYHJKEPEATKPCHaSYRkV6dMkLW2fNCEo0cgX80ql3Bruf8/H6jt3PAZi7K6qLSbjZamiGX0bsrOwKiFqAYBrVTbEO06jYTkOGy0M90WENjBqAOADuIL0rbiLBOCb+CkDhtHvQ00nPor3eBM5ALz26zN3VU6SR3wCUyhDx8sKmupgPT5IXNqt0rodJC5CFfoVws2U7DW+QVjGI2t8COysjKCNglhc2w+WBYBz/IDfFEPH50joB1J8jKAFmQN3t+3jyEzXilxEd1vqpqBuWIGqvd/4d0NeB0cO1VnwDW4h7KZVqjI4AAAAASUVORK5CYII=", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpressionInfo": { "expression": "$feature.SITENAME", "title": "Custom" }, "labelPlacement": "esriServerPointLabelPlacementAboveRight", "deconflictionStrategy": "dynamic", "removeDuplicates": "none", "stackLabel": false, "useCodedValues": true, "maxScale": 0, "minScale": 4800, "name": "Class 1", "priority": -1, "symbol": { "type": "esriTS", "color": [ 0, 77, 168, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 255, 255, 255, 255 ], "haloSize": 2, "font": { "family": "Tahoma", "size": 10, "style": "normal", "weight": "normal", "decoration": "none" } } } ] }, "defaultVisibility": true, "extent": { "xmin": -1.0713859999994804E8, "ymin": -9.719379999999212E7, "xmax": 1.3314051011913523E7, "ymax": 300505.52099478245, "spatialReference": { "wkid": 2253, "latestWkid": 2253, "xyTolerance": 2.5600000022937597E-4, "zTolerance": 2, "mTolerance": 0.001, "falseX": -1.1316292613600722E8, "falseY": -1.0207058323649935E8, "xyUnits": 3.653321460026327E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "SITENAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PACKEDPIN", "type": "esriFieldTypeString", "alias": "PACKEDPIN", "length": 50, "domain": null }, { "name": "SITECATEGORY", "type": "esriFieldTypeString", "alias": "SITECATEGORY", "length": 20, "domain": { "type": "codedValue", "name": "wBackflowSiteType", "description": "Category of Site", "codedValues": [ { "name": "AAPS", "code": "AAPS" }, { "name": "UM", "code": "UM" }, { "name": "City", "code": "City" }, { "name": "Residential", "code": "Residential" }, { "name": "Commercial", "code": "Commercial" }, { "name": "Church", "code": "Church" }, { "name": "Hospital", "code": "Hospital" }, { "name": "Dental Office", "code": "Dental Office" }, { "name": "Medical Office", "code": "Medical Office" }, { "name": "Funeral Home", "code": "Funeral Home" }, { "name": "Commercial Car Wash", "code": "Commercial Car Wash" }, { "name": "Laboratory", "code": "Laboratory" }, { "name": "Restaurant/Tavern", "code": "Restaurant/Tavern" }, { "name": "Medical Care Fac", "code": "Medical Care Fac" }, { "name": "Plating/Chem Plant", "code": "Plating/Chem Plant" }, { "name": "Veterinary Office", "code": "Veterinary Office" }, { "name": "Vacant", "code": "Vacant" }, { "name": "City - Parks", "code": "City - Parks" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SITENAME", "type": "esriFieldTypeString", "alias": "SITENAME", "length": 50, "domain": null }, { "name": "SITEADDRESS", "type": "esriFieldTypeString", "alias": "SITEADDRESS", "length": 100, "domain": null }, { "name": "MAILNAME", "type": "esriFieldTypeString", "alias": "MAILNAME", "length": 50, "domain": null }, { "name": "MAILADDRESS", "type": "esriFieldTypeString", "alias": "MAILADDRESS", "length": 50, "domain": null }, { "name": "MAILCITY", "type": "esriFieldTypeString", "alias": "MAILCITY", "length": 50, "domain": null }, { "name": "MAILSTATE", "type": "esriFieldTypeString", "alias": "MAILSTATE", "length": 50, "domain": null }, { "name": "MAILZIP", "type": "esriFieldTypeString", "alias": "MAILZIP", "length": 50, "domain": null }, { "name": "CONTACTNAME", "type": "esriFieldTypeString", "alias": "CONTACTNAME", "length": 50, "domain": null }, { "name": "CONTACTPHONE", "type": "esriFieldTypeString", "alias": "CONTACTPHONE", "length": 50, "domain": null }, { "name": "CONTACTFAX", "type": "esriFieldTypeString", "alias": "CONTACTFAX", "length": 50, "domain": null }, { "name": "CONTACTEMAIL", "type": "esriFieldTypeString", "alias": "CONTACTEMAIL", "length": 50, "domain": null }, { "name": "SITEID", "type": "esriFieldTypeInteger", "alias": "SITEID", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "SITEIDText", "type": "esriFieldTypeString", "alias": "SITEIDText", "length": 20, "domain": null }, { "name": "DATECREATED", "type": "esriFieldTypeDate", "alias": "DATECREATED", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 255, "domain": null }, { "name": "HAZARDLEVEL", "type": "esriFieldTypeString", "alias": "HAZARDLEVEL", "length": 20, "domain": { "type": "codedValue", "name": "wBackflowHazardLevel", "description": "Backflow Location Hazard Level", "codedValues": [ { "name": "High - Account", "code": "High - Account" }, { "name": "High - Device", "code": "High - Device" }, { "name": "Low - Commercial", "code": "Low - Commercial" }, { "name": "Low - Residential", "code": "Low - Residential" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REINSPECTCYCLE", "type": "esriFieldTypeString", "alias": "REINSPECTCYCLE", "length": 50, "domain": { "type": "codedValue", "name": "wDmBackflowInspectionCycle", "description": "Inspection cycle for backflow based on risk", "codedValues": [ { "name": "Annual (High Acct) - Jan 1", "code": "Annual (High Acct) - Jan 1" }, { "name": "Annual (High Acct) - April 1", "code": "Annual (High Acct) - April 1" }, { "name": "Annual (High Acct) - July 1", "code": "Annual (High Acct) - July 1" }, { "name": "Year 1 (High Device) - Feb 1", "code": "Year 1 (High Device) - Feb 1" }, { "name": "Year 1 (High Device) - May 1", "code": "Year 1 (High Device) - May 1" }, { "name": "Year 1 (High Device) - Aug 1", "code": "Year 1 (High Device) - Aug 1" }, { "name": "Year 2 (High Device) - Feb 1", "code": "Year 2 (High Device) - Feb 1" }, { "name": "Year 2 (High Device) - May 1", "code": "Year 2 (High Device) - May 1" }, { "name": "Year 2 (High Device) - Aug 1", "code": "Year 2 (High Device) - Aug 1" }, { "name": "Year 3 (High Device) - Feb 1", "code": "Year 3 (High Device) - Feb 1" }, { "name": "Year 3 (High Device) - May 1", "code": "Year 3 (High Device) - May 1" }, { "name": "Year 3 (High Device) - Aug 1", "code": "Year 3 (High Device) - Aug 1" }, { "name": "Year 1 (Com) - Jan 1", "code": "Year 1 (Com) - Jan 1" }, { "name": "Year 1 (Com) - April 1", "code": "Year 1 (Com) - April 1" }, { "name": "Year 1 (Com) - July 1", "code": "Year 1 (Com) - July 1" }, { "name": "Year 2 (Com) - Jan 1", "code": "Year 2 (Com) - Jan 1" }, { "name": "Year 2 (Com) - April 1", "code": "Year 2 (Com) - April 1" }, { "name": "Year 2 (Com) - July 1", "code": "Year 2 (Com) - July 1" }, { "name": "Year 3 (Com) - Jan 1", "code": "Year 3 (Com) - Jan 1" }, { "name": "Year 3 (Com) - April 1", "code": "Year 3 (Com) - April 1" }, { "name": "Year 3 (Com) - July 1", "code": "Year 3 (Com) - July 1" }, { "name": "Year 1 (Res) - May 1", "code": "Year 1 (Res) - May 1" }, { "name": "Year 2 (Res) - May 1", "code": "Year 2 (Res) - May 1" }, { "name": "Year 3 (Res) - May 1", "code": "Year 3 (Res) - May 1" }, { "name": "Year 4 (Res) - May 1", "code": "Year 4 (Res) - May 1" }, { "name": "Year 5 (Res) - May 1", "code": "Year 5 (Res) - May 1" }, { "name": "U of M - Annual", "code": "U of M - Annual" }, { "name": "U of M - Year 1", "code": "U of M - Year 1" }, { "name": "U of M - Year 2", "code": "U of M - Year 2" }, { "name": "U of M - Year 3", "code": "U of M - Year 3" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TESTCYCLE", "type": "esriFieldTypeString", "alias": "TESTCYCLE", "length": 50, "domain": { "type": "codedValue", "name": "wDmBackflowTestCycle", "description": "Test cycle for backflow based on risk", "codedValues": [ { "name": "Annual (High Acct) - Jan 1", "code": "Annual (High Acct) - Jan 1" }, { "name": "Annual (High Acct) - April 1", "code": "Annual (High Acct) - April 1" }, { "name": "Annual (High Acct) - July 1", "code": "Annual (High Acct) - July 1" }, { "name": "Annual (High Device) - Jan 1", "code": "Annual (High Device) - Jan 1" }, { "name": "Annual (High Device) - April 1", "code": "Annual (High Device) - April 1" }, { "name": "Annual (High Device) - July 1", "code": "Annual (High Device) - July 1" }, { "name": "Year 1 (Com) - Jan 1", "code": "Year 1 (Com) - Jan 1" }, { "name": "Year 1 (Com) - April 1", "code": "Year 1 (Com) - April 1" }, { "name": "Year 1 (Com) - July 1", "code": "Year 1 (Com) - July 1" }, { "name": "Year 2 (Com) - Jan 1", "code": "Year 2 (Com) - Jan 1" }, { "name": "Year 2 (Com) - April 1", "code": "Year 2 (Com) - April 1" }, { "name": "Year 2 (Com) - July 1", "code": "Year 2 (Com) - July 1" }, { "name": "Year 3 (Com) - Jan 1", "code": "Year 3 (Com) - Jan 1" }, { "name": "Year 3 (Com) - April 1", "code": "Year 3 (Com) - April 1" }, { "name": "Year 3 (Com) - July 1", "code": "Year 3 (Com) - July 1" }, { "name": "Year 1 (Res) - May 1", "code": "Year 1 (Res) - May 1" }, { "name": "Year 2 (Res) - May 1", "code": "Year 2 (Res) - May 1" }, { "name": "Year 3 (Res) - May 1", "code": "Year 3 (Res) - May 1" }, { "name": "Year 4 (Res) - May 1", "code": "Year 4 (Res) - May 1" }, { "name": "Year 5 (Res) - May 1", "code": "Year 5 (Res) - May 1" }, { "name": "Non-Testable Devices", "code": "Non-Testable Devices" }, { "name": "U of M - Annual", "code": "U of M - Annual" }, { "name": "U of M - Year 1", "code": "U of M - Year 1" }, { "name": "U of M - Year 2", "code": "U of M - Year 2" }, { "name": "U of M - Year 3", "code": "U of M - Year 3" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CREATEDUSER", "type": "esriFieldTypeString", "alias": "CREATEDUSER", "length": 50, "domain": null }, { "name": "DATEMODIFIED", "type": "esriFieldTypeDate", "alias": "DATEMODIFIED", "length": 8, "domain": null }, { "name": "MODIFIEDUSER", "type": "esriFieldTypeString", "alias": "MODIFIEDUSER", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "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": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "BILLING", "type": "esriFieldTypeString", "alias": "Billing", "length": 50, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": { "type": "codedValue", "name": "wBackflowStatus", "description": "Backflow device status", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Inactive/Closed", "code": "InactiveClosed" }, { "name": "NonTestable", "code": "NonTestable" }, { "name": "Out of Service", "code": "OutofService" }, { "name": "Removed", "code": "Removed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R2358_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17725_SITEID", "fields": "SITEID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_2358", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_2358", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S2048_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "BFPDevices", "relatedTableId": 163, "role": "esriRelRoleOrigin", "keyField": "SITEIDText", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Query,Map,Data", "maxRecordCount": 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, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1581286277000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 163, "name": "BFPDevices", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 50, "domain": { "type": "codedValue", "name": "wBackflowManufacturer", "description": "Backflow device manufacturer", "codedValues": [ { "name": "Ameco", "code": "Ameco" }, { "name": "Ames", "code": "Ames" }, { "name": "Apollo", "code": "Apollo" }, { "name": "Apollo Conbraco", "code": "Apollo Conbraco" }, { "name": "Colt", "code": "Colt" }, { "name": "Conbraco", "code": "Conbraco" }, { "name": "Febco", "code": "Febco" }, { "name": "Hershey", "code": "Hershey" }, { "name": "Hershey Beeco", "code": "Hershey Beeco" }, { "name": "Kennedy", "code": "Kennedy" }, { "name": "Nibco", "code": "Nibco" }, { "name": "Viking", "code": "Viking" }, { "name": "Watts", "code": "Watts" }, { "name": "Wilkins", "code": "Wilkins" }, { "name": "Wilkins Zurn", "code": "Wilkins Zurn" }, { "name": "Zurn", "code": "Zurn" }, { "name": "Flomatic", "code": "Flomatic" }, { "name": "AMRS", "code": "AMRS" }, { "name": "Toro", "code": "Toro" }, { "name": "Derringer", "code": "Derringer" }, { "name": "ARI", "code": "ARI" }, { "name": "Globe", "code": "Globe" }, { "name": "Cash Acme", "code": "Cash Acme" }, { "name": "Other", "code": "Other" }, { "name": "Kennedy Beeco", "code": "Kennedy Beeco" }, { "name": "Liberty Pumps", "code": "Liberty Pumps" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 50, "domain": { "type": "codedValue", "name": "wBackflowType", "description": "Backflow prevention device type", "codedValues": [ { "name": "AVB", "code": "AVB" }, { "name": "CV", "code": "CV" }, { "name": "DBC", "code": "DBC" }, { "name": "DBCV", "code": "DBCV" }, { "name": "DC", "code": "DC" }, { "name": "DCA", "code": "DCA" }, { "name": "DCDA", "code": "DCDA" }, { "name": "DCU", "code": "DCU" }, { "name": "DCV", "code": "DCV" }, { "name": "DCVA", "code": "DCVA" }, { "name": "DDCV", "code": "DDCV" }, { "name": "DetChk", "code": "DetChk" }, { "name": "PVB", "code": "PVB" }, { "name": "RP", "code": "RP" }, { "name": "PR2", "code": "RP2" }, { "name": "RP4A", "code": "RP4A" }, { "name": "RPBA", "code": "RPBA" }, { "name": "RPBP", "code": "RPBP" }, { "name": "RPDA", "code": "RPDA" }, { "name": "RPP", "code": "RPP" }, { "name": "RPZ", "code": "RPZ" }, { "name": "SCV", "code": "SCV" }, { "name": "SVB", "code": "SVB" }, { "name": "VB", "code": "VB" }, { "name": "Double Check", "code": "DbCk" }, { "name": "RPA", "code": "RPA" }, { "name": "DCDV", "code": "DCDV" }, { "name": "SRVB", "code": "SRVB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "SIZE", "type": "esriFieldTypeString", "alias": "SIZE", "length": 50, "domain": { "type": "codedValue", "name": "wBacflowSize", "description": "Backflow device size", "codedValues": [ { "name": "0.5", "code": "0.5" }, { "name": "0.75", "code": "0.75" }, { "name": "1.0", "code": "1.0" }, { "name": "1.25", "code": "1.25" }, { "name": "1.5", "code": "1.5" }, { "name": "1.75", "code": "1.75" }, { "name": "2.0", "code": "2.0" }, { "name": "2.5", "code": "2.5" }, { "name": "3.0", "code": "3.0" }, { "name": "4.0", "code": "4.0" }, { "name": "5.0", "code": "5.0" }, { "name": "6.0", "code": "6.0" }, { "name": "8.0", "code": "8.0" }, { "name": "10.0", "code": "10.0" }, { "name": "7.0", "code": "7.0" }, { "name": "12.0", "code": "12.0" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 250, "domain": null }, { "name": "DEVICERISKLEVEL", "type": "esriFieldTypeString", "alias": "DEVICERISKLEVEL", "length": 50, "domain": { "type": "codedValue", "name": "wBackflowRiskLevel", "description": "Risk Level of backflow device", "codedValues": [ { "name": "Residential", "code": "Res" }, { "name": "Commercial", "code": "Com" }, { "name": "High", "code": "High" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DEVICEFUNCTION", "type": "esriFieldTypeString", "alias": "DEVICEFUNCTION", "length": 100, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 50, "domain": { "type": "codedValue", "name": "wBackflowStatus", "description": "Backflow device status", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Inactive/Closed", "code": "InactiveClosed" }, { "name": "NonTestable", "code": "NonTestable" }, { "name": "Out of Service", "code": "OutofService" }, { "name": "Removed", "code": "Removed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DATECREATED", "type": "esriFieldTypeDate", "alias": "DATECREATED", "length": 8, "domain": null }, { "name": "SITEIDTEXT", "type": "esriFieldTypeString", "alias": "SITEIDTEXT", "length": 20, "domain": null }, { "name": "DateLastInspected", "type": "esriFieldTypeDate", "alias": "DateLastInspected", "length": 8, "domain": null }, { "name": "UMAssetTagNumber", "type": "esriFieldTypeString", "alias": "UMAssetTagNumber", "length": 50, "domain": null }, { "name": "UMMaintenanceRegion", "type": "esriFieldTypeString", "alias": "UMMaintenanceRegion", "length": 50, "domain": null }, { "name": "DateLastTested", "type": "esriFieldTypeDate", "alias": "DateLastTested", "length": 8, "domain": null }, { "name": "CREATEDUSER", "type": "esriFieldTypeString", "alias": "CREATEDUSER", "length": 50, "domain": null }, { "name": "DATEMODIFIED", "type": "esriFieldTypeDate", "alias": "DATEMODIFIED", "length": 8, "domain": null }, { "name": "MODIFIEDUSER", "type": "esriFieldTypeString", "alias": "MODIFIEDUSER", "length": 50, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 500, "domain": null }, { "name": "PROTECTSTREATEDSYSTEM", "type": "esriFieldTypeString", "alias": "PROTECTSTREATEDSYSTEM", "length": 255, "domain": { "type": "codedValue", "name": "Yes_No_Text", "description": "Yes or No question", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R2360_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17726_SITEID_1", "fields": "SITEIDTEXT", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "BFPLocations", "relatedTableId": 162, "role": "esriRelRoleDestination", "keyField": "SITEIDTEXT", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1581322161000 } } ] }