{ "layers": [ { "currentVersion": 10.61, "id": 0, "name": "sde.GIS.Pipes", "parentLayerId": -1, "defaultVisibility": true, "minScale": 2400, "maxScale": 0, "type": "Feature Layer", "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "DrainMainMaintenance", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "PIPEID", "composite": false } ], "isDataVersioned": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "extent": { "xmin": 985412.43359375, "ymin": 238172.31992188096, "xmax": 1038554.2037109435, "ymax": 293379.19472655654, "spatialReference": { "wkid": 102710, "latestWkid": 3437 } }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 197, 0, 255, 255 ], "width": 1.7 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "TYPE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "domain": { "type": "codedValue", "name": "PipeType", "description": "Pipe function type", "codedValues": [ { "name": "DRAIN", "code": "DRAIN" }, { "name": "CBLAT", "code": "CBLAT" }, { "name": "CULVERT", "code": "CULVERT" }, { "name": "ABANDON", "code": "ABANDON" }, { "name": "UNDERDRAIN", "code": "UNDER" }, { "name": "TRENCH DRAIN", "code": "TRENCH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 8 }, { "name": "SLOPE", "type": "esriFieldTypeString", "alias": "SLOPE", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "PLAN_", "type": "esriFieldTypeString", "alias": "PLAN_", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "domain": null, "editable": true, "nullable": true, "length": 75 }, { "name": "DISTANCE", "type": "esriFieldTypeDouble", "alias": "DISTANCE", "domain": null, "editable": true, "nullable": true }, { "name": "PIPESHAPE", "type": "esriFieldTypeString", "alias": "PipeShape", "domain": null, "editable": true, "nullable": true, "length": 20 }, { "name": "PIPEWIDTH", "type": "esriFieldTypeSmallInteger", "alias": "PIPEWIDTH", "domain": null, "editable": true, "nullable": true }, { "name": "PIPEHEIGHT", "type": "esriFieldTypeSmallInteger", "alias": "PIPEHEIGHT", "domain": null, "editable": true, "nullable": true }, { "name": "US_ID", "type": "esriFieldTypeString", "alias": "US_ID", "domain": null, "editable": true, "nullable": true, "length": 16 }, { "name": "DS_ID", "type": "esriFieldTypeString", "alias": "DS_ID", "domain": null, "editable": true, "nullable": true, "length": 16 }, { "name": "CDM_PIPEID", "type": "esriFieldTypeString", "alias": "CDM_PIPEID", "domain": null, "editable": true, "nullable": true, "length": 32 }, { "name": "US_RIMTOFLOW", "type": "esriFieldTypeDouble", "alias": "US_RIMTOFLOW", "domain": null, "editable": true, "nullable": true }, { "name": "DS_RIMTOFLOW", "type": "esriFieldTypeDouble", "alias": "DS_RIMTOFLOW", "domain": null, "editable": true, "nullable": true }, { "name": "ADJUSTED", "type": "esriFieldTypeSmallInteger", "alias": "ADJUSTED", "domain": null, "editable": true, "nullable": true }, { "name": "DIAMETER", "type": "esriFieldTypeSmallInteger", "alias": "DIAMETER", "domain": null, "editable": true, "nullable": true }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "domain": { "type": "codedValue", "name": "PipeMat_Drain", "description": "Pipe Material - Drain", "codedValues": [ { "name": "Brick", "code": "Brick" }, { "name": "Cement", "code": "Cement" }, { "name": "Granite", "code": "Granite" }, { "name": "Other", "code": "Other" }, { "name": "HDPE", "code": "HDPE" }, { "name": "PVC", "code": "PVC" }, { "name": "AC", "code": "AC" }, { "name": "C-HDPE", "code": "C-HDPE" }, { "name": "CI", "code": "CI" }, { "name": "DI", "code": "DI" }, { "name": "RCP", "code": "RCP" }, { "name": "VC Tile", "code": "VC Tile" }, { "name": "VC", "code": "VC" }, { "name": "UNK", "code": "UNK" }, { "name": "CMP", "code": "CMP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15 }, { "name": "INSTALLDATE", "type": "esriFieldTypeString", "alias": "INSTALLDATE", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "UPSTREAMINVERT", "type": "esriFieldTypeDouble", "alias": "UPSTREAMINVERT", "domain": null, "editable": true, "nullable": true }, { "name": "DOWNSTREAMINVERT", "type": "esriFieldTypeDouble", "alias": "DOWNSTREAMINVERT", "domain": null, "editable": true, "nullable": true }, { "name": "PIPELENGTH", "type": "esriFieldTypeSmallInteger", "alias": "PIPELENGTH", "domain": null, "editable": true, "nullable": true }, { "name": "SOURCE", "type": "esriFieldTypeString", "alias": "Source", "domain": { "type": "codedValue", "name": "Source_7", "description": "Pipe Data Source", "codedValues": [ { "name": "Contract 2 Outskirt Seperation", "code": "Cont2" }, { "name": "Contract 3 City Proper", "code": "Cont3" }, { "name": "Old Plan City Proper", "code": "CityProper" }, { "name": "Old Plan Outskirt", "code": "Outskirt" }, { "name": "GPS", "code": "GPS" }, { "name": "Private Plan", "code": "PrivPlan" }, { "name": "Permenant Plan", "code": "PermPlan" }, { "name": "2000 Aerial Photo", "code": "Aerial2000" }, { "name": "2005 Aerial Photo", "code": "Aerial2005" }, { "name": "2010 Aerial Photo", "code": "Aerial2010" }, { "name": "Field Observation", "code": "Field" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50 }, { "name": "QCSTATUS", "type": "esriFieldTypeString", "alias": "QCSTATUS", "domain": null, "editable": true, "nullable": true, "length": 1 }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true }, { "name": "UPSTREAMIMAGE", "type": "esriFieldTypeString", "alias": "UPSTREAMIMAGE", "domain": null, "editable": true, "nullable": true, "length": 20 }, { "name": "DOWNSTREAMIMAGE", "type": "esriFieldTypeString", "alias": "DOWNSTREAMIMAGE", "domain": null, "editable": true, "nullable": true, "length": 20 }, { "name": "PIPEID", "type": "esriFieldTypeSmallInteger", "alias": "PIPEID", "domain": null, "editable": true, "nullable": true }, { "name": "PLAN_QC", "type": "esriFieldTypeString", "alias": "PLAN_QC", "domain": null, "editable": true, "nullable": true, "length": 1 }, { "name": "YEARLINED", "type": "esriFieldTypeSmallInteger", "alias": "Year Lined", "domain": null, "editable": true, "nullable": true }, { "name": "SEASONLINED", "type": "esriFieldTypeString", "alias": "Season Lined", "domain": { "type": "codedValue", "name": "LiningSeason_7", "description": "Lining Season", "codedValues": [ { "name": "Spring", "code": "Spring" }, { "name": "Spring/Summer", "code": "Spring/Summer" }, { "name": "Summer/Fall", "code": "Summer/Fall" }, { "name": "Summer", "code": "Summer" }, { "name": "Fall", "code": "Fall" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 13 }, { "name": "LINERMATERIAL", "type": "esriFieldTypeString", "alias": "Liner Material", "domain": { "type": "codedValue", "name": "LinerMaterial_7", "description": "Liner Material - Sewer and Drain", "codedValues": [ { "name": "Felt/Resin", "code": "Felt/Resin" }, { "name": "PVC", "code": "PVC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15 }, { "name": "LININGTYPE", "type": "esriFieldTypeString", "alias": "Lining Type", "domain": { "type": "codedValue", "name": "LiningType_7", "description": "LiningType", "codedValues": [ { "name": "Cured in Place", "code": "Cured in Place" }, { "name": "Fold & Form", "code": "Fold & Form" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15 }, { "name": "LININGCONTRACTOR", "type": "esriFieldTypeString", "alias": "Lining Contractor", "domain": { "type": "codedValue", "name": "LiningContractor_7", "description": "Lining Contractor - Sewer and Drain", "codedValues": [ { "name": "Insituform of NE", "code": "Insituform of NE" }, { "name": "Eastern Pipe Service", "code": "Eastern Pipe Service" }, { "name": "Azurix North America", "code": "Azurix North America" }, { "name": "Reynolds Inliner", "code": "Reynolds Inliner" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25 }, { "name": "PRIVATE", "type": "esriFieldTypeString", "alias": "PRIVATE", "domain": { "type": "codedValue", "name": "YorN", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1 }, { "name": "PERFORATED", "type": "esriFieldTypeString", "alias": "PERFORATED", "domain": { "type": "codedValue", "name": "YorN", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1 }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38 }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": { "type": "codedValue", "name": "PipeStatus", "description": "Status of Pipe", "codedValues": [ { "name": "Laid", "code": "Laid" }, { "name": "Relaid", "code": "Relaid" }, { "name": "Repaired", "code": "Repaired" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 12 }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255 }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8 }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255 }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8 }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "domain": null, "editable": true, "nullable": true, "length": 50 } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R581_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_581", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S401_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "sde.GIS.Pipes", "description": "", "prototype": { "attributes": { "STATUS": "Laid", "AssetID": null, "TYPE": null, "SLOPE": null, "PLAN_": null, "COMMENTS": null, "DISTANCE": null, "PIPESHAPE": "Circular", "PIPEWIDTH": null, "PIPEHEIGHT": null, "US_ID": null, "DS_ID": null, "CDM_PIPEID": null, "US_RIMTOFLOW": null, "DS_RIMTOFLOW": null, "ADJUSTED": null, "DIAMETER": null, "MATERIAL": null, "INSTALLDATE": null, "UPSTREAMINVERT": null, "DOWNSTREAMINVERT": null, "PIPELENGTH": null, "SOURCE": null, "QCSTATUS": null, "ENABLED": 1, "UPSTREAMIMAGE": null, "DOWNSTREAMIMAGE": null, "PIPEID": null, "PLAN_QC": null, "YEARLINED": null, "SEASONLINED": null, "LINERMATERIAL": null, "LININGTYPE": null, "LININGCONTRACTOR": null, "PRIVATE": "N", "PERFORATED": "N" } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, AMF, geoJSON", "capabilities": "Create,Delete,Query,Update,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 10.61, "id": 1, "name": "sde.GIS.Util_tbl_DrainMainMaintenance", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "Pipes", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PipeID", "composite": false } ], "isDataVersioned": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "WorkType", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false }, { "name": "WorkType", "type": "esriFieldTypeString", "alias": "WorkType", "domain": { "type": "codedValue", "name": "SMainMaintenance", "description": "sewer main maintenance type", "codedValues": [ { "name": "Jet Main", "code": "Jet Main" }, { "name": "ROW Mowing", "code": "ROW Mowing" }, { "name": "ROW Rehab", "code": "ROW Rehab" }, { "name": "ROW Inspection", "code": "ROW Inspection" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20 }, { "name": "WorkDate", "type": "esriFieldTypeDate", "alias": "WorkDate", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "LastUpdateDate", "type": "esriFieldTypeDate", "alias": "LastUpdateDate", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "domain": { "type": "codedValue", "name": "Inspector_Sewer", "description": "", "codedValues": [ { "name": "TJ Talbot", "code": "TJ Talbot" }, { "name": "B. Pushee", "code": "B. Pushee" }, { "name": "J. Ferguson", "code": "J. Ferguson" }, { "name": "K. Dyment", "code": "K. Dyment" }, { "name": "A. Nudd", "code": "A. Nudd" }, { "name": "S. McVey", "code": "S. McVey" }, { "name": "R. Rambeau", "code": "R. Rambeau" }, { "name": "Enginering Tech", "code": "Enginering Tech" }, { "name": "C. Chatfield", "code": "C. Chatfield" }, { "name": "M. Nugent", "code": "M. Nugent" }, { "name": "GIS", "code": "GIS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20 }, { "name": "PipeID", "type": "esriFieldTypeSmallInteger", "alias": "PipeID", "domain": null, "editable": true, "nullable": true }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255 }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8 }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255 }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8 } ], "indexes": [ { "name": "R1993_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_10603_PipeID", "fields": "PipeID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "sde.GIS.Util_tbl_DrainMainMaintenance", "description": "", "prototype": { "attributes": { "PipeID": null, "Inspector": null, "WorkType": null, "WorkDate": null, "LastUpdateDate": null, "Notes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, AMF, geoJSON", "capabilities": "Create,Delete,Query,Update,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 1000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 } ] }