{ "currentVersion": 10.61, "id": 5, "name": "DrainPipeJetting", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102710, "latestWkid": 3437 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 4800, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 255, 0, 255 ], "width": 8 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": [ { "labelPlacement": "esriServerLinePlacementAboveAlong", "where": null, "labelExpression": "[sde.GIS.Pipes.DIAMETER] CONCAT \" \" CONCAT [sde.GIS.Pipes.MATERIAL] CONCAT \" ID:\" CONCAT [sde.GIS.Pipes.PIPEID]", "useCodedValues": true, "symbol": { "type": "esriTS", "color": [ 0, 0, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "center", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 232, 190, 255, 255 ], "haloSize": 1.5, "font": { "family": "Arial", "size": 10, "style": "normal", "weight": "bold", "decoration": "none" } }, "minScale": 3600, "maxScale": 0 } ] }, "defaultVisibility": true, "extent": { "xmin": 985412.43359375, "ymin": 238172.31992188096, "xmax": 1038554.2037109435, "ymax": 293379.19472655654, "spatialReference": { "wkid": 102710, "latestWkid": 3437 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "sde.GIS.Pipes.TYPE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "sde.GIS.Pipes.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "sde.GIS.Pipes.TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 8, "domain": { "type": "codedValue", "name": "WS2_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" } }, { "name": "sde.GIS.Pipes.SLOPE", "type": "esriFieldTypeString", "alias": "SLOPE", "length": 8, "domain": null }, { "name": "sde.GIS.Pipes.PLAN_", "type": "esriFieldTypeString", "alias": "PLAN_", "length": 8, "domain": null }, { "name": "sde.GIS.Pipes.COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 75, "domain": null }, { "name": "sde.GIS.Pipes.DISTANCE", "type": "esriFieldTypeDouble", "alias": "DISTANCE", "domain": null }, { "name": "sde.GIS.Pipes.PIPESHAPE", "type": "esriFieldTypeString", "alias": "PipeShape", "length": 20, "domain": null }, { "name": "sde.GIS.Pipes.PIPEWIDTH", "type": "esriFieldTypeSmallInteger", "alias": "PIPEWIDTH", "domain": null }, { "name": "sde.GIS.Pipes.PIPEHEIGHT", "type": "esriFieldTypeSmallInteger", "alias": "PIPEHEIGHT", "domain": null }, { "name": "sde.GIS.Pipes.DIAMETER", "type": "esriFieldTypeSmallInteger", "alias": "DIAMETER", "domain": null }, { "name": "sde.GIS.Pipes.MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 15, "domain": { "type": "codedValue", "name": "WS2_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" } }, { "name": "sde.GIS.Pipes.INSTALLDATE", "type": "esriFieldTypeString", "alias": "INSTALLDATE", "length": 8, "domain": null }, { "name": "sde.GIS.Pipes.UPSTREAMINVERT", "type": "esriFieldTypeDouble", "alias": "UPSTREAMINVERT", "domain": null }, { "name": "sde.GIS.Pipes.DOWNSTREAMINVERT", "type": "esriFieldTypeDouble", "alias": "DOWNSTREAMINVERT", "domain": null }, { "name": "sde.GIS.Pipes.PIPELENGTH", "type": "esriFieldTypeSmallInteger", "alias": "PIPELENGTH", "domain": null }, { "name": "sde.GIS.Pipes.SOURCE", "type": "esriFieldTypeString", "alias": "Source", "length": 50, "domain": { "type": "codedValue", "name": "WS2_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" } }, { "name": "sde.GIS.Pipes.ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sde.GIS.Pipes.PIPEID", "type": "esriFieldTypeSmallInteger", "alias": "PIPEID", "domain": null }, { "name": "sde.GIS.Pipes.PLAN_QC", "type": "esriFieldTypeString", "alias": "PLAN_QC", "length": 1, "domain": null }, { "name": "sde.GIS.Pipes.YEARLINED", "type": "esriFieldTypeSmallInteger", "alias": "Year Lined", "domain": null }, { "name": "sde.GIS.Pipes.SEASONLINED", "type": "esriFieldTypeString", "alias": "Season Lined", "length": 13, "domain": { "type": "codedValue", "name": "WS2_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" } }, { "name": "sde.GIS.Pipes.LINERMATERIAL", "type": "esriFieldTypeString", "alias": "Liner Material", "length": 15, "domain": { "type": "codedValue", "name": "WS2_LinerMaterial_7", "description": "Liner Material - Sewer and Drain", "codedValues": [ { "name": "Felt/Resin", "code": "Felt/Resin" }, { "name": "PVC", "code": "PVC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sde.GIS.Pipes.LININGTYPE", "type": "esriFieldTypeString", "alias": "Lining Type", "length": 15, "domain": { "type": "codedValue", "name": "WS2_LiningType_7", "description": "LiningType", "codedValues": [ { "name": "Cured in Place", "code": "Cured in Place" }, { "name": "Fold & Form", "code": "Fold & Form" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sde.GIS.Pipes.LININGCONTRACTOR", "type": "esriFieldTypeString", "alias": "Lining Contractor", "length": 25, "domain": { "type": "codedValue", "name": "WS2_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" } }, { "name": "sde.GIS.Pipes.PRIVATE", "type": "esriFieldTypeString", "alias": "PRIVATE", "length": 1, "domain": { "type": "codedValue", "name": "WS2_YorN", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sde.GIS.Pipes.PERFORATED", "type": "esriFieldTypeString", "alias": "PERFORATED", "length": 1, "domain": { "type": "codedValue", "name": "WS2_YorN", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sde.GIS.Pipes.GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "sde.GIS.Pipes.STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 12, "domain": { "type": "codedValue", "name": "WS2_PipeStatus", "description": "Status of Pipe", "codedValues": [ { "name": "Laid", "code": "Laid" }, { "name": "Relaid", "code": "Relaid" }, { "name": "Repaired", "code": "Repaired" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sde.GIS.Pipes.SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "sde.GIS.Pipes.created_user", "type": "esriFieldTypeString", "alias": "sde.GIS.Pipes.created_user", "length": 255, "domain": null }, { "name": "sde.GIS.Pipes.created_date", "type": "esriFieldTypeDate", "alias": "sde.GIS.Pipes.created_date", "length": 8, "domain": null }, { "name": "sde.GIS.Pipes.last_edited_user", "type": "esriFieldTypeString", "alias": "sde.GIS.Pipes.last_edited_user", "length": 255, "domain": null }, { "name": "sde.GIS.Pipes.last_edited_date", "type": "esriFieldTypeDate", "alias": "sde.GIS.Pipes.last_edited_date", "length": 8, "domain": null }, { "name": "sde.GIS.Pipes.AssetID", "type": "esriFieldTypeString", "alias": "sde.GIS.Pipes.AssetID", "length": 50, "domain": null }, { "name": "sde.GIS.Util_tbl_DrainMainMaintenance.OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "sde.GIS.Util_tbl_DrainMainMaintenance.WorkType", "type": "esriFieldTypeString", "alias": "WorkType", "length": 20, "domain": { "type": "codedValue", "name": "WS2_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" } }, { "name": "sde.GIS.Util_tbl_DrainMainMaintenance.WorkDate", "type": "esriFieldTypeDate", "alias": "WorkDate", "length": 8, "domain": null }, { "name": "sde.GIS.Util_tbl_DrainMainMaintenance.LastUpdateDate", "type": "esriFieldTypeDate", "alias": "LastUpdateDate", "length": 8, "domain": null }, { "name": "sde.GIS.Util_tbl_DrainMainMaintenance.Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 50, "domain": null }, { "name": "sde.GIS.Util_tbl_DrainMainMaintenance.Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 20, "domain": { "type": "codedValue", "name": "WS2_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" } }, { "name": "sde.GIS.Util_tbl_DrainMainMaintenance.PipeID", "type": "esriFieldTypeSmallInteger", "alias": "PipeID", "domain": null }, { "name": "sde.GIS.Util_tbl_DrainMainMaintenance.created_user", "type": "esriFieldTypeString", "alias": "sde.GIS.Util_tbl_DrainMainMaintenance.created_user", "length": 255, "domain": null }, { "name": "sde.GIS.Util_tbl_DrainMainMaintenance.created_date", "type": "esriFieldTypeDate", "alias": "sde.GIS.Util_tbl_DrainMainMaintenance.created_date", "length": 8, "domain": null }, { "name": "sde.GIS.Util_tbl_DrainMainMaintenance.last_edited_user", "type": "esriFieldTypeString", "alias": "sde.GIS.Util_tbl_DrainMainMaintenance.last_edited_user", "length": 255, "domain": null }, { "name": "sde.GIS.Util_tbl_DrainMainMaintenance.last_edited_date", "type": "esriFieldTypeDate", "alias": "sde.GIS.Util_tbl_DrainMainMaintenance.last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "sde.GIS.Pipes.SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R581_pk", "fields": "sde.GIS.Pipes.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_581", "fields": "sde.GIS.Pipes.GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S401_idx", "fields": "sde.GIS.Pipes.SHAPE", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R1993_SDE_ROWID_UK", "fields": "sde.GIS.Util_tbl_DrainMainMaintenance.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_10603_PipeID", "fields": "sde.GIS.Util_tbl_DrainMainMaintenance.PipeID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "DrainMainMaintenance", "relatedTableId": 19, "role": "esriRelRoleOrigin", "keyField": "PIPEID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF, geoJSON", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }