{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "SManhole", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user", "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false } }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "WATER.WR.SewerMHCycle", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "extent": { "xmin": 1474702.1384211779, "ymin": 532995.7491721809, "xmax": 1825874.8180767894, "ymax": 696836.9320599586, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 6.561666666666666E-4, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 5.12000000524288E-4, "zTolerance": 2, "mTolerance": 0.001, "falseX": -1.21841899999759E8, "falseY": -9.36589999998884E7, "xyUnits": 15624.999984000002, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "8c62374b000d47815bead24ea9ff59b3", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABoAAAAaCAYAAACpSkzOAAAACXBIWXMAAA7EAAAOxAGVKw4bAAADYklEQVRIieWWP0h6axjHP29IU1BRgbWkFB4RokFrCVzsj5BFFNFQLRW21FBBEDU4uPWHXERbJKIpgjIXCxtahMiGREMQo4bfDxpqMaSh3jt09HYtb917f1wu3Gc57+F5zvk8z/c97/McDf+Saf6/ICllH1APNKjXGBATQsR+CUhK6QScgLmEH2BaCLH1t0BSSjPgAhxfJQP41YT6hRA/vg1SIUe8ScTj4yMej4dQKMTt7S1CCHQ6Hf39/czOzlJZWQlvFV9IKS2fwUpV5MpDQqEQExMTWK1WpqenCYfDVFVV0dbWxvHxMYqisLu7i81mQ30mCFi+BKkSOAAODg4YGhpiYWGBkZERAM7OzqioqMBisWCxWNjb26Onp4dwOJyHmaWUzuI90xRBGnjbeO7v75mcnMTtduPz+TAajbS2tubjAIjH4+zs7LCyssLo6CipVCovowsoDeJNZzPA+vo6drud7u5uDAYDc3NzKIpCJpPh9fWVRCJBMplkbW0NRVGIx+N4vV6WlpYA6qWU5veffjGoPr8IBoMsLy8DoNPp0Ov1aLVarFYrAOfn55hMJhRFAaCrq4vt7e08KJ90SVBDfnF3d0c0GuXi4gKAh4cHOjs7C4Ht7e0EAgECgQAajYZsNksmkylWp6R0hYqklGSzWTQaTeG+2KSUPD09UVZWRi6X++D/M1Ch1MbGRux2OwaDAYBUKkU6naa5ufktMBajqamJmZkZAC4vL4sr+vktUF9fHycnJxgMBhKJBJlMhvLycqLRKC8vL+h0OtLpdAF+enqKw/GHJnJUEiSEiOUlmp+fp6WlBb1ej8/nY3V1FaPRyObmJjU1NYyPj5NMJllcXGRqaopIJILX6y1UU9xsP+sM04Bfq9Xi9/sZHh7G5XJhNBo/BJpMJsbGxnC5XASDQaqrq/OuDw32A0gIsaV2B/Pg4CD7+/s4nU7S6TQ2m43n52dyuRxXV1dEIhHC4TCHh4f09vbmXxETQri+BKnWD1wA9QMDA3R0dODxeNjY2ODm5gZ4O0cOh4Pr62tqa2sLEFWRD/YpSAjxQ0ppAfyAo66uDrfbjdvtLpHX75BSg7DkPFJbfZ8qo4t3Z6zIfgJbn8n1LdA74Bawpc6oQi9UAUe/bJS/A8Z4d87+qv33/oL+qf0GLyJSZKNFiH8AAAAASUVORK5CYII=", "contentType": "image/png", "width": 19, "height": 19, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "WATER.WR.SManhole.ANCILLARYROLE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ANCILLARYROLE", "type": "esriFieldTypeSmallInteger", "alias": "ANCILLARYROLE", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "ANCILLARYROLE" }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": null, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "Enabled" }, { "name": "ADMINISTRATIVEAREA", "type": "esriFieldTypeString", "alias": "AdministrativeArea", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "AdministrativeArea" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": true, "nullable": false, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "PRIMARYIMAGE", "type": "esriFieldTypeString", "alias": "PRIMARYIMAGE", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "PRIMARYIMAGE" }, { "name": "CJURISDICTI", "type": "esriFieldTypeString", "alias": "CJurisdicti", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "CJurisdicti" }, { "name": "CGPSDATE", "type": "esriFieldTypeString", "alias": "CGPSDATE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CGPSDATE" }, { "name": "ELEVATION", "type": "esriFieldTypeDouble", "alias": "ELEVATION", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ELEVATION" }, { "name": "ACCESSDIAMETER", "type": "esriFieldTypeInteger", "alias": "AccessDiameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AccessDiameter" }, { "name": "DEPTH", "type": "esriFieldTypeDouble", "alias": "DEPTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEPTH" }, { "name": "INTERIORDROP", "type": "esriFieldTypeInteger", "alias": "INTERIORDROP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INTERIORDROP" }, { "name": "BARRELMATERIAL", "type": "esriFieldTypeString", "alias": "BarrelMaterial", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "BarrelMaterial" }, { "name": "RIMELEVATION", "type": "esriFieldTypeDouble", "alias": "RIMELEVATION", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RIMELEVATION" }, { "name": "BARRELDIAMETER", "type": "esriFieldTypeInteger", "alias": "BarrelDiameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BarrelDiameter" }, { "name": "CDEADEND", "type": "esriFieldTypeInteger", "alias": "CDeadEnd", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "CDeadEnd" }, { "name": "CDROP_MH", "type": "esriFieldTypeInteger", "alias": "CDrop_MH", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "CDrop_MH" }, { "name": "MANHOLETYPE", "type": "esriFieldTypeInteger", "alias": "ManholeType", "domain": null, "editable": true, "nullable": true, "defaultValue": 3, "modelName": "ManholeType" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "WSACC_ID", "type": "esriFieldTypeString", "alias": "WSACC ID", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WSACC_ID" }, { "name": "LAST_UPDATED", "type": "esriFieldTypeDate", "alias": "Added to GIS", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ADDED_TO_GIS" }, { "name": "PROJECT_ID", "type": "esriFieldTypeString", "alias": "PROJECT_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROJECT_ID" }, { "name": "REHAB_YEAR", "type": "esriFieldTypeString", "alias": "REHAB YEAR", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "REHAB_YEAR" }, { "name": "YEARINSTALL", "type": "esriFieldTypeString", "alias": "YEARINSTALL", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "YEARINSTALL" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R1102_pk", "fields": "WATER.WR.SManhole.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1102", "fields": "WATER.WR.SManhole.GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_1102", "fields": "WATER.WR.SManhole.GlobalID,WATER.WR.SManhole.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9383_FACILIT", "fields": "WATER.WR.SManhole.FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S864_idx", "fields": "WATER.WR.SManhole.SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SManhole", "description": "", "prototype": { "attributes": { "YEARINSTALL": null, "ANCILLARYROLE": 0, "ENABLED": 1, "ADMINISTRATIVEAREA": null, "FACILITYID": " ", "PRIMARYIMAGE": null, "CJURISDICTI": null, "CGPSDATE": null, "ELEVATION": null, "ACCESSDIAMETER": null, "DEPTH": null, "INTERIORDROP": null, "BARRELMATERIAL": null, "RIMELEVATION": null, "BARRELDIAMETER": null, "CDEADEND": 0, "CDROP_MH": 0, "MANHOLETYPE": 3, "COMMENTS": null, "WSACC_ID": null, "LAST_UPDATED": null, "PROJECT_ID": null, "REHAB_YEAR": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "d7004113e89c49b58c86f03804e88153" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "SGravityMain", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user", "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false } }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "WATER.WR.SewerCycle", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 1474702.1384211779, "ymin": 536746.8458160311, "xmax": 1554314.2962627113, "ymax": 634216.3814038336, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 6.561666666666666E-4, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 5.12000000524288E-4, "zTolerance": 2, "mTolerance": 0.001, "falseX": -1.21841899999759E8, "falseY": -9.36589999998884E7, "xyUnits": 15624.999984000002, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 9 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "WATER.WR.SGravityMain.ENABLED", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": null, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "Enabled" }, { "name": "ADMINISTRATIVEAREA", "type": "esriFieldTypeString", "alias": "AdministrativeArea", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "AdministrativeArea" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "RECORDEDLENGTH", "type": "esriFieldTypeDouble", "alias": "RECORDEDLENGTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RECORDEDLENGTH" }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": "PVC", "modelName": "Material" }, { "name": "CAERIAL", "type": "esriFieldTypeInteger", "alias": "CAerial", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "CAerial" }, { "name": "CINMHID", "type": "esriFieldTypeString", "alias": "CINMHID", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CINMHID" }, { "name": "COUTMHID", "type": "esriFieldTypeString", "alias": "COUTMHID", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "COUTMHID" }, { "name": "UPSTREAMINVERT", "type": "esriFieldTypeDouble", "alias": "UPSTREAMINVERT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UPSTREAMINVERT" }, { "name": "DOWNSTREAMINVERT", "type": "esriFieldTypeDouble", "alias": "DOWNSTREAMINVERT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOWNSTREAMINVERT" }, { "name": "NOMINALSIZE", "type": "esriFieldTypeInteger", "alias": "NominalSize", "domain": null, "editable": true, "nullable": true, "defaultValue": 8, "modelName": "NominalSize" }, { "name": "SLOPE", "type": "esriFieldTypeDouble", "alias": "SLOPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SLOPE" }, { "name": "CDROP_TYPE", "type": "esriFieldTypeInteger", "alias": "CDrop_Type", "domain": null, "editable": true, "nullable": true, "defaultValue": 2, "modelName": "CDrop_Type" }, { "name": "MAINTYPE", "type": "esriFieldTypeInteger", "alias": "MainType", "domain": null, "editable": true, "nullable": true, "defaultValue": 4, "modelName": "MainType" }, { "name": "HIGH_PRIORITY", "type": "esriFieldTypeSmallInteger", "alias": "HIGH_PRIORITY", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "HIGH_PRIORITY" }, { "name": "CALC_LENGTH", "type": "esriFieldTypeDouble", "alias": "CALC_LENGTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CALC_LENGTH" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "PROJECT_ID", "type": "esriFieldTypeString", "alias": "Project ID", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "Project_ID" }, { "name": "LAST_UPDATED", "type": "esriFieldTypeDate", "alias": "Added to GIS", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ADDED_TO_GIS" }, { "name": "CIPP_YEAR", "type": "esriFieldTypeString", "alias": "YEAR cipp", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CIPP_YEAR" }, { "name": "YEARINSTALL", "type": "esriFieldTypeString", "alias": "YEARINSTALL", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "YEARINSTALL" }, { "name": "FLOWDIRECTION", "type": "esriFieldTypeSmallInteger", "alias": "Flow direction", "domain": null, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "FLOWDIRECTION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R1103_pk", "fields": "WATER.WR.SGravityMain.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1103", "fields": "WATER.WR.SGravityMain.GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_1103", "fields": "WATER.WR.SGravityMain.GlobalID,WATER.WR.SGravityMain.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9384_FACILIT", "fields": "WATER.WR.SGravityMain.FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S865_idx", "fields": "WATER.WR.SGravityMain.SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SGravityMain", "description": "", "prototype": { "attributes": { "FLOWDIRECTION": 1, "ENABLED": 1, "ADMINISTRATIVEAREA": null, "FACILITYID": null, "RECORDEDLENGTH": null, "MATERIAL": "PVC", "CAERIAL": 0, "CINMHID": null, "COUTMHID": null, "UPSTREAMINVERT": null, "DOWNSTREAMINVERT": null, "NOMINALSIZE": 8, "SLOPE": null, "CDROP_TYPE": 2, "MAINTYPE": 4, "HIGH_PRIORITY": 0, "CALC_LENGTH": null, "COMMENTS": null, "PROJECT_ID": null, "LAST_UPDATED": null, "CIPP_YEAR": null, "YEARINSTALL": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "d7004113e89c49b58c86f03804e88153" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "SewerCycle", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user", "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false } }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "WATER.WR.SGravityMain", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "FACILITYID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "INSPECTOR", "type": "esriFieldTypeString", "alias": "INSPECTOR", "domain": { "type": "codedValue", "name": "SCInspector", "description": "Sewer Cycles Inspectors", "codedValues": [ { "name": "Austin Painter", "code": "AP" }, { "name": "Brian Harwood", "code": "BH" }, { "name": "Chad Grimm", "code": "CG" }, { "name": "Chris Reid", "code": "CR" }, { "name": "Chris Smith", "code": "CS" }, { "name": "Dallas Long", "code": "DL" }, { "name": "Dustin Evans", "code": "DE" }, { "name": "Eric Miller", "code": "EM" }, { "name": "Ethan Gilmore", "code": "EG" }, { "name": "Herb Taylor", "code": "HT" }, { "name": "Jaime Campbell", "code": "JC" }, { "name": "Jarod Allman", "code": "JA" }, { "name": "Jeff Turner", "code": "JT1" }, { "name": "Jeremiah Wilburn", "code": "JW" }, { "name": "Jeremy James", "code": "JJ" }, { "name": "Jesse Sloop", "code": "JS" }, { "name": "John Hill", "code": "JH" }, { "name": "Johnny Gardner", "code": "JG" }, { "name": "Jonathan Rabon", "code": "JR" }, { "name": "Joseph Burleson", "code": "BJ" }, { "name": "Lane Barnhardts", "code": "LB" }, { "name": "Larry Thomas", "code": "LT" }, { "name": "Mattew Guzman", "code": "MG" }, { "name": "Michael McIntosh", "code": "MM" }, { "name": "Robert Seals", "code": "RS" }, { "name": "Ronnie Allman", "code": "AR" }, { "name": "Steven Bowers", "code": "SB" }, { "name": "Wesley Hammill", "code": "WH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "INSPECTOR" }, { "name": "TRUCKNO", "type": "esriFieldTypeString", "alias": "TRUCKNO", "domain": { "type": "codedValue", "name": "SCTruck", "description": "High Priority Line Truck Number", "codedValues": [ { "name": "S122", "code": "122" }, { "name": "S123", "code": "123" }, { "name": "S628", "code": "628" }, { "name": "S661", "code": "661" }, { "name": "S662", "code": "662" }, { "name": "S667", "code": "667" }, { "name": "S675", "code": "657" }, { "name": "S119", "code": "119" }, { "name": "S680", "code": "680" }, { "name": "S684", "code": "684" }, { "name": "S665", "code": "665" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TRUCKNO" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "domain": { "type": "codedValue", "name": "SCType", "description": "Sewer Cycles", "codedValues": [ { "name": "High Priority", "code": "HP" }, { "name": "Right of Way", "code": "RW" }, { "name": "Spray", "code": "SP" }, { "name": "Heavy Clearing", "code": "HC" }, { "name": "Inspected", "code": "INSP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TYPE" }, { "name": "HPDATE", "type": "esriFieldTypeDate", "alias": "DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "HPDATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R971_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_8477_FACILIT", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_971", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_971", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SewerCycle", "description": "", "prototype": { "attributes": { "HPDATE": null, "TYPE": null, "FACILITYID": null, "INSPECTOR": null, "TRUCKNO": null, "COMMENTS": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "d7004113e89c49b58c86f03804e88153" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "SewerMHCycle", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user", "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false } }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "WATER.WR.SManhole", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "FACILITYID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "INSPECTOR", "type": "esriFieldTypeString", "alias": "INSPECTOR", "domain": { "type": "codedValue", "name": "SCInspector", "description": "Sewer Cycles Inspectors", "codedValues": [ { "name": "Austin Painter", "code": "AP" }, { "name": "Brian Harwood", "code": "BH" }, { "name": "Chad Grimm", "code": "CG" }, { "name": "Chris Reid", "code": "CR" }, { "name": "Chris Smith", "code": "CS" }, { "name": "Dallas Long", "code": "DL" }, { "name": "Dustin Evans", "code": "DE" }, { "name": "Eric Miller", "code": "EM" }, { "name": "Ethan Gilmore", "code": "EG" }, { "name": "Herb Taylor", "code": "HT" }, { "name": "Jaime Campbell", "code": "JC" }, { "name": "Jarod Allman", "code": "JA" }, { "name": "Jeff Turner", "code": "JT1" }, { "name": "Jeremiah Wilburn", "code": "JW" }, { "name": "Jeremy James", "code": "JJ" }, { "name": "Jesse Sloop", "code": "JS" }, { "name": "John Hill", "code": "JH" }, { "name": "Johnny Gardner", "code": "JG" }, { "name": "Jonathan Rabon", "code": "JR" }, { "name": "Joseph Burleson", "code": "BJ" }, { "name": "Lane Barnhardts", "code": "LB" }, { "name": "Larry Thomas", "code": "LT" }, { "name": "Mattew Guzman", "code": "MG" }, { "name": "Michael McIntosh", "code": "MM" }, { "name": "Robert Seals", "code": "RS" }, { "name": "Ronnie Allman", "code": "AR" }, { "name": "Steven Bowers", "code": "SB" }, { "name": "Wesley Hammill", "code": "WH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "INSPECTOR" }, { "name": "TRUCKNO", "type": "esriFieldTypeString", "alias": "TRUCKNO", "domain": { "type": "codedValue", "name": "SCTruck", "description": "High Priority Line Truck Number", "codedValues": [ { "name": "S122", "code": "122" }, { "name": "S123", "code": "123" }, { "name": "S628", "code": "628" }, { "name": "S661", "code": "661" }, { "name": "S662", "code": "662" }, { "name": "S667", "code": "667" }, { "name": "S675", "code": "657" }, { "name": "S119", "code": "119" }, { "name": "S680", "code": "680" }, { "name": "S684", "code": "684" }, { "name": "S665", "code": "665" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TRUCKNO" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "domain": { "type": "codedValue", "name": "SCType", "description": "Sewer Cycles", "codedValues": [ { "name": "High Priority", "code": "HP" }, { "name": "Right of Way", "code": "RW" }, { "name": "Spray", "code": "SP" }, { "name": "Heavy Clearing", "code": "HC" }, { "name": "Inspected", "code": "INSP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TYPE" }, { "name": "HPDATE", "type": "esriFieldTypeDate", "alias": "DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "HPDATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R972_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_8478_FACILIT", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_972", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_972", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SewerMHCycle", "description": "", "prototype": { "attributes": { "HPDATE": null, "FACILITYID": null, "INSPECTOR": null, "TRUCKNO": null, "COMMENTS": null, "TYPE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "d7004113e89c49b58c86f03804e88153" } ] }