{ "layers": [ { "currentVersion": 10.5, "id": 0, "name": "Wastewater Casing", "type": "Feature Layer", "description": "This geospatial layer is a polyline feature class that contains information about the location and attributes of casings of the City of Houston\u2019s wastewater collection system. The force main feature class includes Sludge and Force.The GIS Services Group of Houston Water, Houston Public Works currently stores and maintains the dataset within a Relational Database Management System (RDBMS). The data are derived from Plan and Profile Engineering drawings obtained from Block Map, As Built, Field Book, Taps and Meters, Metro, Autocad Data from GHW Project, Wastewater Reconciliation Project, Other Source (Operator Input), FVFL, FVFD, Field Verified with Control Number, and Construction Layer.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102740, "latestWkid": 2278 }, "copyrightText": "City of Houston, Houston Public Works, Houston Water, GIS Services", "parentLayer": null, "subLayers": [], "minScale": 10000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "SUBTYPECD", "field2": null, "field3": null, "defaultSymbol": null, "defaultLabel": null, "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 0, 0, 255 ], "width": 1 }, "value": "1", "label": "", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3032472.4444834143, "ymin": 1.3757400915141344E7, "xmax": 3205865.886436969, "ymax": 1.3965067913026437E7, "spatialReference": { "wkid": 102740, "latestWkid": 2278 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "SUBDIVISION_NAME", "typeIdField": "SUBTYPECD", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CREATIONUSER", "type": "esriFieldTypeString", "alias": "Employee Number", "length": 20, "domain": null }, { "name": "DATECREATED", "type": "esriFieldTypeDate", "alias": "Date Created", "length": 8, "domain": null }, { "name": "DATEMODIFIED", "type": "esriFieldTypeDate", "alias": "Date Modified", "length": 8, "domain": null }, { "name": "LASTUSER", "type": "esriFieldTypeString", "alias": "Last User", "length": 20, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 50, "domain": null }, { "name": "UFID", "type": "esriFieldTypeInteger", "alias": "UFID", "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "QCVERIFIED", "type": "esriFieldTypeInteger", "alias": "QC Verified", "domain": { "type": "codedValue", "name": "sYes/No Indicator - Integer", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FIELDVERIFYNUM", "type": "esriFieldTypeInteger", "alias": "Field Verified Number", "domain": null }, { "name": "INSERVICEDATE", "type": "esriFieldTypeDate", "alias": "In Service Date", "length": 8, "domain": null }, { "name": "PLANDATE", "type": "esriFieldTypeDate", "alias": "Plan Date", "length": 8, "domain": null }, { "name": "REHABCOMPLETIONDATE", "type": "esriFieldTypeDate", "alias": "Rehab Completion Date", "length": 8, "domain": null }, { "name": "MOTIONDATE", "type": "esriFieldTypeDate", "alias": "Motion Date", "length": 8, "domain": null }, { "name": "PERMITDATE", "type": "esriFieldTypeDate", "alias": "Permit Date", "length": 8, "domain": null }, { "name": "SUBTYPECD", "type": "esriFieldTypeInteger", "alias": "Subtype", "domain": null }, { "name": "LIFECYCLESTATUS", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 5, "domain": { "type": "codedValue", "name": "sLifecycle Status", "codedValues": [ { "name": "Features Being Used and Maintained", "code": "E" }, { "name": "Proposed", "code": "P" }, { "name": "Abandoned", "code": "A" }, { "name": "Rehabilitated", "code": "R" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "Size", "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 5, "domain": { "type": "codedValue", "name": "sWater Line Material", "codedValues": [ { "name": "Clay or Concrete Brick", "code": "BRK" }, { "name": "Corrugated Metal Pipe", "code": "CGMP" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Cast Iron Soil Pipe", "code": "CISO" }, { "name": "Vitrified Clay Pipe and Fittings", "code": "CLAY" }, { "name": "Concrete", "code": "CONC" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Extra Strength Clay Pipe", "code": "ESC" }, { "name": "Extra Strength Concrete Pipe", "code": "ESP" }, { "name": "Monolithic Reinforced Concrete", "code": "MRC" }, { "name": "Polyethylene Pipe", "code": "PEP" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Conc Pipe", "code": "RCP" }, { "name": "Reinforced Conc Pipe w/Sliplining", "code": "RCSL" }, { "name": "Steel Cylinder Reinforced Conc Pipe", "code": "SRC" }, { "name": "Steel", "code": "STL" }, { "name": "Wrought Iron", "code": "WI" }, { "name": "Unknown", "code": "UNK" }, { "name": "Other", "code": "OTH" }, { "name": "Cured in Place Pipe", "code": "CIPP" }, { "name": "Reinforced Plastic Mortar Pipe", "code": "RPM" }, { "name": "Asbestos Concrete", "code": "AC" }, { "name": "Plastic", "code": "PL" }, { "name": "Non-Plastic", "code": "NPL" }, { "name": "Plastic Lined Concrete Pipe", "code": "PLP" }, { "name": "Unreinforced Concrete Pipe", "code": "URC" }, { "name": "Acrylonitrile Butadiene Styrene", "code": "ABS" }, { "name": "Reinforced Conc Pipe Asphalt", "code": "RCPA" }, { "name": "Fiberglass Reinforced Pipe", "code": "FRP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MEASUREDLENGTH", "type": "esriFieldTypeDouble", "alias": "Measured Length", "domain": null }, { "name": "UPSTREAMINVERT", "type": "esriFieldTypeDouble", "alias": "Upstream Elevation", "domain": null }, { "name": "DOWNSTREAMINVERT", "type": "esriFieldTypeDouble", "alias": "Downstream Elevation", "domain": null }, { "name": "PERCENTSLOPE", "type": "esriFieldTypeDouble", "alias": "Percent Slope", "domain": null }, { "name": "SIZE2", "type": "esriFieldTypeDouble", "alias": "Size 2", "domain": null }, { "name": "STUBLENGTH", "type": "esriFieldTypeString", "alias": "Stub Length", "length": 255, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SUBDIVISION_NAME", "type": "esriFieldTypeString", "alias": "Subdivision Name", "length": 50, "domain": null }, { "name": "LENGTHSOURCE", "type": "esriFieldTypeString", "alias": "Length Source", "length": 5, "domain": { "type": "codedValue", "name": "sLength Source", "codedValues": [ { "name": "Field Measurement", "code": "FM" }, { "name": "Mapping System", "code": "MS" }, { "name": "User-Derived", "code": "USER" }, { "name": "Engineering Drawing", "code": "EGDOC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FISCAL_YEAR", "type": "esriFieldTypeString", "alias": "Fiscal Year", "length": 10, "domain": { "type": "codedValue", "name": "sFiscalYear", "codedValues": [ { "name": "FY10", "code": "FY10" }, { "name": "FY11", "code": "FY11" }, { "name": "FY12", "code": "FY12" }, { "name": "FY13", "code": "FY13" }, { "name": "FY14", "code": "FY14" }, { "name": "FY15", "code": "FY15" }, { "name": "FY16", "code": "FY16" }, { "name": "FY17", "code": "FY17" }, { "name": "FY18", "code": "FY18" }, { "name": "FY19", "code": "FY19" }, { "name": "FY20", "code": "FY20" }, { "name": "FY21", "code": "FY21" }, { "name": "FY22", "code": "FY22" }, { "name": "FY23", "code": "FY23" }, { "name": "FY24", "code": "FY24" }, { "name": "FY25", "code": "FY25" }, { "name": "FY26", "code": "FY26" }, { "name": "FY27", "code": "FY27" }, { "name": "FY28", "code": "FY28" }, { "name": "FY29", "code": "FY29" }, { "name": "FY30", "code": "FY30" }, { "name": "FY31", "code": "FY31" }, { "name": "FY32", "code": "FY32" }, { "name": "FY33", "code": "FY33" }, { "name": "FY34", "code": "FY34" }, { "name": "FY35", "code": "FY35" }, { "name": "FY36", "code": "FY36" }, { "name": "FY37", "code": "FY37" }, { "name": "FY38", "code": "FY38" }, { "name": "FY39", "code": "FY39" }, { "name": "FY40", "code": "FY40" }, { "name": "FY41", "code": "FY41" }, { "name": "FY42", "code": "FY42" }, { "name": "FY43", "code": "FY43" }, { "name": "FY44", "code": "FY44" }, { "name": "FY45", "code": "FY45" }, { "name": "FY46", "code": "FY46" }, { "name": "FY47", "code": "FY47" }, { "name": "FY48", "code": "FY48" }, { "name": "FY49", "code": "FY49" }, { "name": "FY50", "code": "FY50" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "COMPKEY", "type": "esriFieldTypeInteger", "alias": "COMPKEY", "domain": null }, { "name": "KEYMAP", "type": "esriFieldTypeString", "alias": "Key Map", "length": 14, "domain": null }, { "name": "COUNCILDISTRICT", "type": "esriFieldTypeString", "alias": "Council District", "length": 10, "domain": { "type": "codedValue", "name": "COH Council District", "codedValues": [ { "name": "A", "code": "A" }, { "name": "B", "code": "B" }, { "name": "C", "code": "C" }, { "name": "D", "code": "D" }, { "name": "E", "code": "E" }, { "name": "F", "code": "F" }, { "name": "G", "code": "G" }, { "name": "H", "code": "H" }, { "name": "I", "code": "I" }, { "name": "K", "code": "K" }, { "name": "J", "code": "J" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ZONE", "type": "esriFieldTypeString", "alias": "Zone", "length": 10, "domain": { "type": "codedValue", "name": "UM Zones", "codedValues": [ { "name": "GNEHSA", "code": "GNEHSA" }, { "name": "IAH", "code": "IAH" }, { "name": "NE", "code": "NE" }, { "name": "NW", "code": "NW" }, { "name": "SE", "code": "SE" }, { "name": "SW", "code": "SW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IPSSUBTYPE", "type": "esriFieldTypeString", "alias": "IPSSUBTYPE", "length": 10, "domain": null }, { "name": "IPSFACILITYID", "type": "esriFieldTypeString", "alias": "IPSFACILITYID", "length": 11, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "DATUM", "type": "esriFieldTypeString", "alias": "Datum", "length": 10, "domain": { "type": "codedValue", "name": "sDatum", "codedValues": [ { "name": "City of Houston", "code": "COHnnnn" }, { "name": "U.S. Army Corps of Engrs", "code": "CORPnnnn" }, { "name": "Harris County Flood Control", "code": "HCFnnnn" }, { "name": "National Geodetic Survey", "code": "NGSnnnn" }, { "name": "Texas Highway Dept", "code": "THDnnnn" }, { "name": "U.S. Geological Survey", "code": "USGSnnnn" }, { "name": "U.S. Coastal and Geodetic Survey", "code": "UCGSnnnn" }, { "name": "Unknown", "code": "UNKnnnn" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Owner", "length": 10, "domain": { "type": "codedValue", "name": "sOwner", "codedValues": [ { "name": "City Owned/Maintained", "code": "C" }, { "name": "Privately Owned & Maintained", "code": "P" }, { "name": "City Own & Privately Maintained", "code": "CP" }, { "name": "Privately Own & City Maintained", "code": "PC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PIPESHAPE", "type": "esriFieldTypeString", "alias": "Pipe Shape", "length": 10, "domain": { "type": "codedValue", "name": "sPipe Shape", "codedValues": [ { "name": "Round", "code": "RND" }, { "name": "Arch", "code": "ARCH" }, { "name": "Box", "code": "BOX" }, { "name": "Oval", "code": "OVAL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PLANNUMBER", "type": "esriFieldTypeString", "alias": "Plan Number", "length": 10, "domain": null }, { "name": "REHABPLANNUMBER", "type": "esriFieldTypeString", "alias": "Rehab Plan Number", "length": 10, "domain": null }, { "name": "ILMSNUMBER", "type": "esriFieldTypeString", "alias": "ILMS Number", "length": 15, "domain": null }, { "name": "COSTPERACRE", "type": "esriFieldTypeString", "alias": "Cost Per Acre", "length": 20, "domain": null }, { "name": "CREATIONSOURCE", "type": "esriFieldTypeString", "alias": "Financial Assets", "length": 20, "domain": { "type": "codedValue", "name": "sCreation Source", "codedValues": [ { "name": "CAPITAL IMPROVEMENT PROJECT", "code": "CIP" }, { "name": "COMMERCIAL", "code": "COMMERCIAL" }, { "name": "DEVELOPER PARTICIPATION CONTRACTOR", "code": "DPC" }, { "name": "DEVELOPER", "code": "DEVELOPER" }, { "name": "FIELD VERIFICATION WASTEWATER", "code": "FVWW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DATASOURCETYPE", "type": "esriFieldTypeString", "alias": "Data Source Type", "length": 20, "domain": { "type": "codedValue", "name": "sData Source Type LINE", "codedValues": [ { "name": "Block Map", "code": "BM" }, { "name": "Plan and Profile", "code": "P" }, { "name": "As Built", "code": "AB" }, { "name": "Field Book", "code": "FB" }, { "name": "Taps and Meters", "code": "MT" }, { "name": "Metro", "code": "Metro" }, { "name": "Autocad Data from GHW Project", "code": "ACAD" }, { "name": "Wastewater Reconciliation Project", "code": "WWRECON" }, { "name": "Other Source (Operator Input)", "code": "O" }, { "name": "FVFL", "code": "FVFL" }, { "name": "FVFD", "code": "FVFD" }, { "name": "Unknown", "code": "\" \"" }, { "name": "Field Verified with Control Number", "code": "FV" }, { "name": "Construction Layer", "code": "CL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MOTIONNUMBER", "type": "esriFieldTypeString", "alias": "Motion Number", "length": 20, "domain": null }, { "name": "PERMITNUMBER", "type": "esriFieldTypeString", "alias": "Permit Number", "length": 20, "domain": null }, { "name": "PLANTYPE", "type": "esriFieldTypeString", "alias": "Plan Type", "length": 20, "domain": { "type": "codedValue", "name": "sPlan Type", "codedValues": [ { "name": "Plan and Profile", "code": "P" }, { "name": "Rehabilitation Drawing", "code": "R" }, { "name": "Proposed Rehabilitation Drawing", "code": "RP" }, { "name": "Texas Highway Department", "code": "THD" }, { "name": "Water Drawing", "code": "WD" }, { "name": "Unknown", "code": "UN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "REHABMATERIAL", "type": "esriFieldTypeString", "alias": "Rehab Material", "length": 20, "domain": { "type": "codedValue", "name": "sRehabilitation Material NODE", "codedValues": [ { "name": "Concrete", "code": "CONC" }, { "name": "Fiberglass", "code": "FBGL" }, { "name": "Reinforced Fiberglass", "code": "RFBG" }, { "name": "Epoxy", "code": "EPXY" }, { "name": "Fosrock", "code": "FSRK" }, { "name": "Thanecoat (wastewater facility)", "code": "THCT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SOURCEOFFUND", "type": "esriFieldTypeString", "alias": "Funding Source", "length": 20, "domain": null }, { "name": "WCRNUMBER", "type": "esriFieldTypeString", "alias": "WCR Number", "length": 20, "domain": null }, { "name": "PROJECTNUMBER", "type": "esriFieldTypeString", "alias": "File Number", "length": 24, "domain": null }, { "name": "REHABPROJECTNUMBER", "type": "esriFieldTypeString", "alias": "Rehab Project Number", "length": 24, "domain": null }, { "name": "PROJECTTYPE", "type": "esriFieldTypeString", "alias": "Project Type", "length": 30, "domain": { "type": "codedValue", "name": "sProject Type", "codedValues": [ { "name": "City Job", "code": "JOB" }, { "name": "Waste Water", "code": "WW" }, { "name": "Government Financial System", "code": "GFS" }, { "name": "Street and Bridge", "code": "SB" }, { "name": "Work Business Structure", "code": "WBS" }, { "name": "Permit Number", "code": "PN" }, { "name": "Water", "code": "WA" }, { "name": "Unknown", "code": "UNKNOWN" }, { "name": "Storm", "code": "SM" }, { "name": "Control Section Job", "code": "CSJ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "REHABMETHOD", "type": "esriFieldTypeString", "alias": "Rehab Method", "length": 35, "domain": { "type": "codedValue", "name": "sRehabilitation Method NODE", "codedValues": [ { "name": "Adjust Ring/Cover", "code": "ARC" }, { "name": "Abandon MH", "code": "AMH" }, { "name": "Coating", "code": "COAT" }, { "name": "Frame Sealing", "code": "FMHS" }, { "name": "Grout MH Joints", "code": "GMHJ" }, { "name": "Insert", "code": "INS" }, { "name": "Liner", "code": "LINE" }, { "name": "Adjust MH to Grade", "code": "MHA" }, { "name": "Replace Cleanout w/MH", "code": "NMH" }, { "name": "New Ring/Cover", "code": "NRC" }, { "name": "Rehab MH", "code": "RMH" }, { "name": "Remove and Replace", "code": "RR" }, { "name": "Watertight Manhole (wastewater facility)", "code": "WCMH" }, { "name": "Clean & TV", "code": "CCTV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DATUM_YEAR", "type": "esriFieldTypeString", "alias": "Datum Year", "length": 5, "domain": null }, { "name": "LAND_BASE_REVIEWED", "type": "esriFieldTypeString", "alias": "Land Base Reviewed", "length": 5, "domain": { "type": "codedValue", "name": "Yes No Reviewed", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LENGTH", "type": "esriFieldTypeDouble", "alias": "Length", "domain": null }, { "name": "ADDRESS_ID", "type": "esriFieldTypeDouble", "alias": "ADDRESS_ID", "domain": null }, { "name": "GFSORWBS", "type": "esriFieldTypeString", "alias": "GFS or WBS", "length": 5, "domain": { "type": "codedValue", "name": "wProject Type2", "codedValues": [ { "name": "Government Financial System", "code": "GFS" }, { "name": "Work Business Structure", "code": "WBS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "GFSWBSNUMBER", "type": "esriFieldTypeString", "alias": "GFS-WBS Number", "length": 24, "domain": null }, { "name": "UNITID2", "type": "esriFieldTypeString", "alias": "Unit ID 2", "length": 20, "domain": null }, { "name": "MAINCOMP1", "type": "esriFieldTypeSmallInteger", "alias": "Main Comp 1", "domain": null }, { "name": "MAINCOMP2", "type": "esriFieldTypeSmallInteger", "alias": "Main Comp 2", "domain": null }, { "name": "COMPTYPE", "type": "esriFieldTypeSmallInteger", "alias": "COMPTYPE", "domain": null }, { "name": "PARLINENO", "type": "esriFieldTypeString", "alias": "PARLINENO", "length": 2, "domain": null }, { "name": "UNITID", "type": "esriFieldTypeString", "alias": "UNITID", "length": 20, "domain": null }, { "name": "QCDATE", "type": "esriFieldTypeDate", "alias": "QC Date", "length": 8, "domain": null }, { "name": "PSCNUMBER", "type": "esriFieldTypeString", "alias": "PSC Number", "length": 20, "domain": null }, { "name": "IPSExpire", "type": "esriFieldTypeDate", "alias": "IPS Expire Date", "length": 8, "domain": null }, { "name": "IPSExpBy", "type": "esriFieldTypeString", "alias": "IPS Expired By", "length": 10, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "indexes": [ { "name": "R379_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_379", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S189_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "id": 1, "name": "Casing", "domains": { "QCVERIFIED": {"type": "inherited"}, "LIFECYCLESTATUS": {"type": "inherited"}, "MATERIAL": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "FISCAL_YEAR": {"type": "inherited"}, "ZONE": {"type": "inherited"} } } ], "relationships": [], "canModifyLayer": true, "canScaleSymbols": true, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF, geoJSON", "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null }, { "currentVersion": 10.5, "id": 1, "name": "Wastewater Service Line", "type": "Feature Layer", "description": "This geospatial layer is a polyline feature class that contains information about the locations and related attributes of service leads of the City of Houston\u2019s wastewater collection system. According to the City's Infrastructure Design Manual, a service lead is a sewer pipe that connects a building sewer to a sewer line that is wholly located within the public Right-Of-Way or public easement.The GIS Services Group of Houston Water, Houston Public Works currently stores and maintains the dataset within a Relational Database Management System (RDBMS). The data are derived from Plan and Profile Engineering drawings obtained from Block Map, As Built, Field Book, Taps and Meters, Metro, Autocad Data from GHW Project, Wastewater Reconciliation Project, Other Source (Operator Input), FVFL, FVFD, Field Verified with Control Number, and Construction Layer.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102740, "latestWkid": 2278 }, "copyrightText": "City of Houston, Houston Public Works, Houston Water, GIS Services", "parentLayer": null, "subLayers": [], "minScale": 10000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "SUBTYPE", "field2": null, "field3": null, "defaultSymbol": null, "defaultLabel": null, "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 127, 127, 255 ], "width": 1.5 }, "value": "0", "label": "Service Line", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3014610.175636366, "ymin": 1.3762905069049895E7, "xmax": 3211884.97116144, "ymax": 1.3966097273284957E7, "spatialReference": { "wkid": 102740, "latestWkid": 2278 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "SUBDIVISIONNAME", "typeIdField": "SUBTYPE", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "Object ID", "domain": null }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EMPLOYEENUMBER", "type": "esriFieldTypeString", "alias": "Employee Number", "length": 20, "domain": null }, { "name": "DATECREATED", "type": "esriFieldTypeDate", "alias": "Date Created", "length": 8, "domain": null }, { "name": "DATEMODIFIED", "type": "esriFieldTypeDate", "alias": "Date Modified", "length": 8, "domain": null }, { "name": "LASTUSER", "type": "esriFieldTypeString", "alias": "Last User", "length": 20, "domain": null }, { "name": "UFID", "type": "esriFieldTypeInteger", "alias": "UFID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 50, "domain": null }, { "name": "SUBTYPE", "type": "esriFieldTypeInteger", "alias": "Subtype", "domain": null }, { "name": "PLANDATE", "type": "esriFieldTypeDate", "alias": "PlanDate", "length": 8, "domain": null }, { "name": "FILENUMBER", "type": "esriFieldTypeString", "alias": "File Number", "length": 50, "domain": null }, { "name": "SIZECD", "type": "esriFieldTypeInteger", "alias": "Size", "domain": { "type": "codedValue", "name": "sWaste Water Line Diameter", "codedValues": [ { "name": "2\"", "code": 2 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "21\"", "code": 21 }, { "name": "22\"", "code": 22 }, { "name": "24\"", "code": 24 }, { "name": "26\"", "code": 26 }, { "name": "27\"", "code": 27 }, { "name": "30\"", "code": 30 }, { "name": "33\"", "code": 33 }, { "name": "36\"", "code": 36 }, { "name": "42\"", "code": 42 }, { "name": "45\"", "code": 45 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "69\"", "code": 69 }, { "name": "72\"", "code": 72 }, { "name": "78\"", "code": 78 }, { "name": "82\"", "code": 82 }, { "name": "84\"", "code": 84 }, { "name": "90\"", "code": 90 }, { "name": "96\"", "code": 96 }, { "name": "102\"", "code": 102 }, { "name": "108\"", "code": 108 }, { "name": "114\"", "code": 114 }, { "name": "120\"", "code": 120 }, { "name": "132\"", "code": 132 }, { "name": "144\"", "code": 144 }, { "name": "168\"", "code": 168 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 }, { "name": "64\"", "code": 64 }, { "name": "85\"", "code": 85 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": { "type": "codedValue", "name": "sWater Line Material", "codedValues": [ { "name": "Clay or Concrete Brick", "code": "BRK" }, { "name": "Corrugated Metal Pipe", "code": "CGMP" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Cast Iron Soil Pipe", "code": "CISO" }, { "name": "Vitrified Clay Pipe and Fittings", "code": "CLAY" }, { "name": "Concrete", "code": "CONC" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Extra Strength Clay Pipe", "code": "ESC" }, { "name": "Extra Strength Concrete Pipe", "code": "ESP" }, { "name": "Monolithic Reinforced Concrete", "code": "MRC" }, { "name": "Polyethylene Pipe", "code": "PEP" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Conc Pipe", "code": "RCP" }, { "name": "Reinforced Conc Pipe w/Sliplining", "code": "RCSL" }, { "name": "Steel Cylinder Reinforced Conc Pipe", "code": "SRC" }, { "name": "Steel", "code": "STL" }, { "name": "Wrought Iron", "code": "WI" }, { "name": "Unknown", "code": "UNK" }, { "name": "Other", "code": "OTH" }, { "name": "Cured in Place Pipe", "code": "CIPP" }, { "name": "Reinforced Plastic Mortar Pipe", "code": "RPM" }, { "name": "Asbestos Concrete", "code": "AC" }, { "name": "Plastic", "code": "PL" }, { "name": "Non-Plastic", "code": "NPL" }, { "name": "Plastic Lined Concrete Pipe", "code": "PLP" }, { "name": "Unreinforced Concrete Pipe", "code": "URC" }, { "name": "Acrylonitrile Butadiene Styrene", "code": "ABS" }, { "name": "Reinforced Conc Pipe Asphalt", "code": "RCPA" }, { "name": "Fiberglass Reinforced Pipe", "code": "FRP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PERCENTSLOPE", "type": "esriFieldTypeDouble", "alias": "Percent Slope", "domain": null }, { "name": "DISTANCETODOWNSTREAMMANHOLE", "type": "esriFieldTypeString", "alias": "Distance To Downstream Manhole", "length": 20, "domain": null }, { "name": "UPSTREAMINVERT", "type": "esriFieldTypeDouble", "alias": "Upstream Invert", "domain": null }, { "name": "DOWNSTREAMINVERT", "type": "esriFieldTypeDouble", "alias": "Downstream Invert", "domain": null }, { "name": "FIELDVERIFIEDNUMBER", "type": "esriFieldTypeInteger", "alias": "Field Verified Number", "domain": null }, { "name": "LIFECYCLESTATUS", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 25, "domain": { "type": "codedValue", "name": "sLifecycle Status", "codedValues": [ { "name": "Features Being Used and Maintained", "code": "E" }, { "name": "Proposed", "code": "P" }, { "name": "Abandoned", "code": "A" }, { "name": "Rehabilitated", "code": "R" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FINANCIALASSETS", "type": "esriFieldTypeString", "alias": "Financial Assets", "length": 50, "domain": { "type": "codedValue", "name": "sCreation Source", "codedValues": [ { "name": "CAPITAL IMPROVEMENT PROJECT", "code": "CIP" }, { "name": "COMMERCIAL", "code": "COMMERCIAL" }, { "name": "DEVELOPER PARTICIPATION CONTRACTOR", "code": "DPC" }, { "name": "DEVELOPER", "code": "DEVELOPER" }, { "name": "FIELD VERIFICATION WASTEWATER", "code": "FVWW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FISCALYEAR", "type": "esriFieldTypeString", "alias": "Fiscal Year", "length": 25, "domain": { "type": "codedValue", "name": "sFiscalYear", "codedValues": [ { "name": "FY10", "code": "FY10" }, { "name": "FY11", "code": "FY11" }, { "name": "FY12", "code": "FY12" }, { "name": "FY13", "code": "FY13" }, { "name": "FY14", "code": "FY14" }, { "name": "FY15", "code": "FY15" }, { "name": "FY16", "code": "FY16" }, { "name": "FY17", "code": "FY17" }, { "name": "FY18", "code": "FY18" }, { "name": "FY19", "code": "FY19" }, { "name": "FY20", "code": "FY20" }, { "name": "FY21", "code": "FY21" }, { "name": "FY22", "code": "FY22" }, { "name": "FY23", "code": "FY23" }, { "name": "FY24", "code": "FY24" }, { "name": "FY25", "code": "FY25" }, { "name": "FY26", "code": "FY26" }, { "name": "FY27", "code": "FY27" }, { "name": "FY28", "code": "FY28" }, { "name": "FY29", "code": "FY29" }, { "name": "FY30", "code": "FY30" }, { "name": "FY31", "code": "FY31" }, { "name": "FY32", "code": "FY32" }, { "name": "FY33", "code": "FY33" }, { "name": "FY34", "code": "FY34" }, { "name": "FY35", "code": "FY35" }, { "name": "FY36", "code": "FY36" }, { "name": "FY37", "code": "FY37" }, { "name": "FY38", "code": "FY38" }, { "name": "FY39", "code": "FY39" }, { "name": "FY40", "code": "FY40" }, { "name": "FY41", "code": "FY41" }, { "name": "FY42", "code": "FY42" }, { "name": "FY43", "code": "FY43" }, { "name": "FY44", "code": "FY44" }, { "name": "FY45", "code": "FY45" }, { "name": "FY46", "code": "FY46" }, { "name": "FY47", "code": "FY47" }, { "name": "FY48", "code": "FY48" }, { "name": "FY49", "code": "FY49" }, { "name": "FY50", "code": "FY50" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SUBDIVISIONNAME", "type": "esriFieldTypeString", "alias": "Subdivision Name", "length": 75, "domain": null }, { "name": "LANDBASEREVIEWED", "type": "esriFieldTypeString", "alias": "Land Base Reviewed", "length": 25, "domain": { "type": "codedValue", "name": "Yes No Reviewed", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "QCVERIFIED", "type": "esriFieldTypeInteger", "alias": "QC Verified", "domain": { "type": "codedValue", "name": "sYes/No Indicator - Integer", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "COMPKEY", "type": "esriFieldTypeInteger", "alias": "COMPKEY", "domain": null }, { "name": "KEYMAP", "type": "esriFieldTypeString", "alias": "Key Map", "length": 14, "domain": null }, { "name": "COUNCILDISTRICT", "type": "esriFieldTypeString", "alias": "Council District", "length": 10, "domain": { "type": "codedValue", "name": "COH Council District", "codedValues": [ { "name": "A", "code": "A" }, { "name": "B", "code": "B" }, { "name": "C", "code": "C" }, { "name": "D", "code": "D" }, { "name": "E", "code": "E" }, { "name": "F", "code": "F" }, { "name": "G", "code": "G" }, { "name": "H", "code": "H" }, { "name": "I", "code": "I" }, { "name": "K", "code": "K" }, { "name": "J", "code": "J" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ZONE", "type": "esriFieldTypeString", "alias": "Zone", "length": 10, "domain": { "type": "codedValue", "name": "UM Zones", "codedValues": [ { "name": "GNEHSA", "code": "GNEHSA" }, { "name": "IAH", "code": "IAH" }, { "name": "NE", "code": "NE" }, { "name": "NW", "code": "NW" }, { "name": "SE", "code": "SE" }, { "name": "SW", "code": "SW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSERVICEDATE", "type": "esriFieldTypeDate", "alias": "In Service Date", "length": 8, "domain": null }, { "name": "IPSSUBTYPE", "type": "esriFieldTypeString", "alias": "IPSSUBTYPE", "length": 10, "domain": null }, { "name": "IPSFACILITYID", "type": "esriFieldTypeString", "alias": "IPSFACILITYID", "length": 11, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "DATUM", "type": "esriFieldTypeString", "alias": "Datum", "length": 10, "domain": { "type": "codedValue", "name": "sDatum", "codedValues": [ { "name": "City of Houston", "code": "COHnnnn" }, { "name": "U.S. Army Corps of Engrs", "code": "CORPnnnn" }, { "name": "Harris County Flood Control", "code": "HCFnnnn" }, { "name": "National Geodetic Survey", "code": "NGSnnnn" }, { "name": "Texas Highway Dept", "code": "THDnnnn" }, { "name": "U.S. Geological Survey", "code": "USGSnnnn" }, { "name": "U.S. Coastal and Geodetic Survey", "code": "UCGSnnnn" }, { "name": "Unknown", "code": "UNKnnnn" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Owner", "length": 10, "domain": { "type": "codedValue", "name": "sOwner", "codedValues": [ { "name": "City Owned/Maintained", "code": "C" }, { "name": "Privately Owned & Maintained", "code": "P" }, { "name": "City Own & Privately Maintained", "code": "CP" }, { "name": "Privately Own & City Maintained", "code": "PC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PIPESHAPE", "type": "esriFieldTypeString", "alias": "Pipe Shape", "length": 10, "domain": { "type": "codedValue", "name": "sPipe Shape", "codedValues": [ { "name": "Round", "code": "RND" }, { "name": "Arch", "code": "ARCH" }, { "name": "Box", "code": "BOX" }, { "name": "Oval", "code": "OVAL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PLANNUMBER", "type": "esriFieldTypeString", "alias": "Plan Number", "length": 10, "domain": null }, { "name": "ILMSNUMBER", "type": "esriFieldTypeString", "alias": "ILMS Number", "length": 15, "domain": null }, { "name": "DATASOURCETYPE", "type": "esriFieldTypeString", "alias": "Data Source Type", "length": 20, "domain": { "type": "codedValue", "name": "sData Source Type LINE", "codedValues": [ { "name": "Block Map", "code": "BM" }, { "name": "Plan and Profile", "code": "P" }, { "name": "As Built", "code": "AB" }, { "name": "Field Book", "code": "FB" }, { "name": "Taps and Meters", "code": "MT" }, { "name": "Metro", "code": "Metro" }, { "name": "Autocad Data from GHW Project", "code": "ACAD" }, { "name": "Wastewater Reconciliation Project", "code": "WWRECON" }, { "name": "Other Source (Operator Input)", "code": "O" }, { "name": "FVFL", "code": "FVFL" }, { "name": "FVFD", "code": "FVFD" }, { "name": "Unknown", "code": "\" \"" }, { "name": "Field Verified with Control Number", "code": "FV" }, { "name": "Construction Layer", "code": "CL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PLANTYPE", "type": "esriFieldTypeString", "alias": "Plan Type", "length": 20, "domain": { "type": "codedValue", "name": "sPlan Type", "codedValues": [ { "name": "Plan and Profile", "code": "P" }, { "name": "Rehabilitation Drawing", "code": "R" }, { "name": "Proposed Rehabilitation Drawing", "code": "RP" }, { "name": "Texas Highway Department", "code": "THD" }, { "name": "Water Drawing", "code": "WD" }, { "name": "Unknown", "code": "UN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PROJECTTYPE", "type": "esriFieldTypeString", "alias": "ProjectType", "length": 30, "domain": { "type": "codedValue", "name": "sProject Type", "codedValues": [ { "name": "City Job", "code": "JOB" }, { "name": "Waste Water", "code": "WW" }, { "name": "Government Financial System", "code": "GFS" }, { "name": "Street and Bridge", "code": "SB" }, { "name": "Work Business Structure", "code": "WBS" }, { "name": "Permit Number", "code": "PN" }, { "name": "Water", "code": "WA" }, { "name": "Unknown", "code": "UNKNOWN" }, { "name": "Storm", "code": "SM" }, { "name": "Control Section Job", "code": "CSJ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DATUMYEAR", "type": "esriFieldTypeString", "alias": "Datum Year", "length": 4, "domain": null }, { "name": "SERVICELENGTH", "type": "esriFieldTypeDouble", "alias": "Service Length", "domain": null }, { "name": "ADDRESS_ID", "type": "esriFieldTypeDouble", "alias": "ADDRESS_ID", "domain": null }, { "name": "GFSORWBS", "type": "esriFieldTypeString", "alias": "GFS or WBS", "length": 5, "domain": { "type": "codedValue", "name": "wProject Type2", "codedValues": [ { "name": "Government Financial System", "code": "GFS" }, { "name": "Work Business Structure", "code": "WBS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "GFSWBSNUMBER", "type": "esriFieldTypeString", "alias": "GFS-WBS Number", "length": 24, "domain": null }, { "name": "COMPTYPE", "type": "esriFieldTypeSmallInteger", "alias": "COMPTYPE", "domain": null }, { "name": "UNITID", "type": "esriFieldTypeString", "alias": "UNITID", "length": 20, "domain": null }, { "name": "QCDATE", "type": "esriFieldTypeDate", "alias": "QC Date", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "COMMUNITYSEWERINDICATOR", "type": "esriFieldTypeString", "alias": "Community Sewer Indicator", "length": 5, "domain": { "type": "codedValue", "name": "Yes/No Indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unk", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SUBSTITUTESERVICEINDICATOR", "type": "esriFieldTypeString", "alias": "Substitute Service Indicator", "length": 5, "domain": { "type": "codedValue", "name": "Yes/No Indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unk", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMUNITYSEWERINDICATOR", "type": "esriFieldTypeString", "alias": "Community Sewer Indicator", "length": 5, "domain": { "type": "codedValue", "name": "Yes/No Indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unk", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ADDRKEY", "type": "esriFieldTypeInteger", "alias": "ADDRKEY", "domain": null }, { "name": "IPSEXPIREDATE", "type": "esriFieldTypeDate", "alias": "IPS Expire Date", "length": 8, "domain": null }, { "name": "IPSEXPIREDBY", "type": "esriFieldTypeString", "alias": "IPS Expired By", "length": 10, "domain": null } ], "indexes": [ { "name": "R377_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_377", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I655PROJECTTYPE", "fields": "PROJECTTYPE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I655UNITID", "fields": "UNITID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I655UFID", "fields": "UFID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S187_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "id": 0, "name": "Service Lead", "domains": { "ENABLED": {"type": "inherited"}, "SIZECD": {"type": "inherited"}, "MATERIAL": {"type": "inherited"}, "LIFECYCLESTATUS": {"type": "inherited"}, "FINANCIALASSETS": {"type": "inherited"}, "FISCALYEAR": {"type": "inherited"}, "LANDBASEREVIEWED": {"type": "inherited"}, "QCVERIFIED": {"type": "inherited"}, "COUNCILDISTRICT": {"type": "inherited"}, "ZONE": {"type": "inherited"}, "DATUM": {"type": "inherited"}, "OWNER": {"type": "inherited"}, "PIPESHAPE": {"type": "inherited"}, "DATASOURCETYPE": {"type": "inherited"}, "PLANTYPE": {"type": "inherited"}, "PROJECTTYPE": {"type": "inherited"}, "GFSORWBS": {"type": "inherited"} } } ], "relationships": [], "canModifyLayer": true, "canScaleSymbols": true, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF, geoJSON", "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null }, { "currentVersion": 10.5, "id": 2, "name": "Wastewater Force Main", "type": "Feature Layer", "description": "This geospatial layer is a polyline feature class that contains information about the location and attributes of more than 320 miles of force mains of the City of Houston\u2019s wastewater collection system. According to the City's Infrastructure Design Manual, a force main is a pressure-rated conduit which conveys wastewater from one pump station to one discharge point. This feature class includes force and sludge.The GIS Services Group of Houston Water, Houston Public Works currently stores and maintains the dataset within a Relational Database Management System (RDBMS). The data are derived from Plan and Profile Engineering drawings obtained from Block Map, As Built, Field Book, Taps and Meters, Metro, Autocad Data from GHW Project, Wastewater Reconciliation Project, Other Source (Operator Input), FVFL, FVFD, Field Verified with Control Number, and Construction Layer.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102740, "latestWkid": 2278 }, "copyrightText": "City of Houston, Houston Public Works, Houston Water, GIS Services", "parentLayer": null, "subLayers": [], "minScale": 50000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "SUBTYPECD", "field2": "OWNER", "field3": null, "defaultSymbol": null, "defaultLabel": null, "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 76, 0, 255 ], "width": 6.900001525878906 }, "value": "1,C", "label": "Force", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 76, 0, 255 ], "width": 6.900001525878906 }, "value": "1,", "label": "Force", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 168, 56, 0, 255 ], "width": 6.900001525878906 }, "value": "2,C", "label": "Sludge", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 168, 56, 0, 255 ], "width": 6.900001525878906 }, "value": "2,", "label": "Sludge", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 230, 76, 0, 255 ], "width": 2 }, "value": "1,P", "label": "Force, Privately Owned", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 168, 56, 0, 255 ], "width": 1.5 }, "value": "2,P", "label": "Sludge, Privately Owned", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3018756.747063458, "ymin": 1.3757369953280538E7, "xmax": 3211897.449563682, "ymax": 1.3963263333479553E7, "spatialReference": { "wkid": 102740, "latestWkid": 2278 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "SUBDIVISION_NAME", "typeIdField": "SubtypeCD", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CREATIONUSER", "type": "esriFieldTypeString", "alias": "Employee Number", "length": 20, "domain": null }, { "name": "DATECREATED", "type": "esriFieldTypeDate", "alias": "Date Created", "length": 8, "domain": null }, { "name": "DATEMODIFIED", "type": "esriFieldTypeDate", "alias": "Date Modified", "length": 8, "domain": null }, { "name": "LASTUSER", "type": "esriFieldTypeString", "alias": "Last User", "length": 20, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 50, "domain": null }, { "name": "UFID", "type": "esriFieldTypeInteger", "alias": "UFID", "domain": null }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "Condition", "length": 20, "domain": null }, { "name": "CONDITIONDATE", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "QCVERIFIED", "type": "esriFieldTypeInteger", "alias": "QC Verified", "domain": { "type": "codedValue", "name": "sYes/No Indicator - Integer", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FIELDVERIFYNUM", "type": "esriFieldTypeInteger", "alias": "Field Verified Number", "domain": null }, { "name": "INSERVICEDATE", "type": "esriFieldTypeDate", "alias": "In Service Date", "length": 8, "domain": null }, { "name": "PLANDATE", "type": "esriFieldTypeDate", "alias": "Plan Date", "length": 8, "domain": null }, { "name": "REHABCOMPLETIONDATE", "type": "esriFieldTypeDate", "alias": "Rehab Completion Date", "length": 8, "domain": null }, { "name": "MOTIONDATE", "type": "esriFieldTypeDate", "alias": "Motion Date", "length": 8, "domain": null }, { "name": "PERMITDATE", "type": "esriFieldTypeDate", "alias": "Permit Date", "length": 8, "domain": null }, { "name": "SUBTYPECD", "type": "esriFieldTypeInteger", "alias": "Subtype", "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 5, "domain": { "type": "codedValue", "name": "sWater Line Material", "codedValues": [ { "name": "Clay or Concrete Brick", "code": "BRK" }, { "name": "Corrugated Metal Pipe", "code": "CGMP" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Cast Iron Soil Pipe", "code": "CISO" }, { "name": "Vitrified Clay Pipe and Fittings", "code": "CLAY" }, { "name": "Concrete", "code": "CONC" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Extra Strength Clay Pipe", "code": "ESC" }, { "name": "Extra Strength Concrete Pipe", "code": "ESP" }, { "name": "Monolithic Reinforced Concrete", "code": "MRC" }, { "name": "Polyethylene Pipe", "code": "PEP" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Conc Pipe", "code": "RCP" }, { "name": "Reinforced Conc Pipe w/Sliplining", "code": "RCSL" }, { "name": "Steel Cylinder Reinforced Conc Pipe", "code": "SRC" }, { "name": "Steel", "code": "STL" }, { "name": "Wrought Iron", "code": "WI" }, { "name": "Unknown", "code": "UNK" }, { "name": "Other", "code": "OTH" }, { "name": "Cured in Place Pipe", "code": "CIPP" }, { "name": "Reinforced Plastic Mortar Pipe", "code": "RPM" }, { "name": "Asbestos Concrete", "code": "AC" }, { "name": "Plastic", "code": "PL" }, { "name": "Non-Plastic", "code": "NPL" }, { "name": "Plastic Lined Concrete Pipe", "code": "PLP" }, { "name": "Unreinforced Concrete Pipe", "code": "URC" }, { "name": "Acrylonitrile Butadiene Styrene", "code": "ABS" }, { "name": "Reinforced Conc Pipe Asphalt", "code": "RCPA" }, { "name": "Fiberglass Reinforced Pipe", "code": "FRP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LIFECYCLESTATUS", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 5, "domain": { "type": "codedValue", "name": "sLifecycle Status", "codedValues": [ { "name": "Features Being Used and Maintained", "code": "E" }, { "name": "Proposed", "code": "P" }, { "name": "Abandoned", "code": "A" }, { "name": "Rehabilitated", "code": "R" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MEASUREDLENGTH", "type": "esriFieldTypeDouble", "alias": "Measured Length", "domain": null }, { "name": "LENGTHSOURCE", "type": "esriFieldTypeString", "alias": "Length Source", "length": 5, "domain": { "type": "codedValue", "name": "sLength Source", "codedValues": [ { "name": "Field Measurement", "code": "FM" }, { "name": "Mapping System", "code": "MS" }, { "name": "User-Derived", "code": "USER" }, { "name": "Engineering Drawing", "code": "EGDOC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WASTEWATERTRACEWEIGHT", "type": "esriFieldTypeInteger", "alias": "Wastewater Trace Weight", "domain": null }, { "name": "DISTANCETODOWNSTREAMMANHOLE", "type": "esriFieldTypeString", "alias": "Distance To Downstream Manhole", "length": 20, "domain": null }, { "name": "STUBLENGTH", "type": "esriFieldTypeInteger", "alias": "Stub Length", "domain": null }, { "name": "SIZE2", "type": "esriFieldTypeInteger", "alias": "Size 2", "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeInteger", "alias": "Size", "domain": { "type": "codedValue", "name": "sWaste Water Line Diameter", "codedValues": [ { "name": "2\"", "code": 2 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "21\"", "code": 21 }, { "name": "22\"", "code": 22 }, { "name": "24\"", "code": 24 }, { "name": "26\"", "code": 26 }, { "name": "27\"", "code": 27 }, { "name": "30\"", "code": 30 }, { "name": "33\"", "code": 33 }, { "name": "36\"", "code": 36 }, { "name": "42\"", "code": 42 }, { "name": "45\"", "code": 45 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "69\"", "code": 69 }, { "name": "72\"", "code": 72 }, { "name": "78\"", "code": 78 }, { "name": "82\"", "code": 82 }, { "name": "84\"", "code": 84 }, { "name": "90\"", "code": 90 }, { "name": "96\"", "code": 96 }, { "name": "102\"", "code": 102 }, { "name": "108\"", "code": 108 }, { "name": "114\"", "code": 114 }, { "name": "120\"", "code": 120 }, { "name": "132\"", "code": 132 }, { "name": "144\"", "code": 144 }, { "name": "168\"", "code": 168 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 }, { "name": "64\"", "code": 64 }, { "name": "85\"", "code": 85 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "UPSTREAMINVERT", "type": "esriFieldTypeDouble", "alias": "Upstream Invert", "domain": null }, { "name": "DOWNSTREAMINVERT", "type": "esriFieldTypeDouble", "alias": "Downstream Invert", "domain": null }, { "name": "PERCENTSLOPE", "type": "esriFieldTypeDouble", "alias": "Percent Slope", "domain": null }, { "name": "GROUNDCOVER", "type": "esriFieldTypeDouble", "alias": "Ground Cover", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "SUBDIVISION_NAME", "type": "esriFieldTypeString", "alias": "Subdivision Name", "length": 50, "domain": null }, { "name": "FISCAL_YEAR", "type": "esriFieldTypeString", "alias": "Fiscal Year", "length": 10, "domain": { "type": "codedValue", "name": "sFiscalYear", "codedValues": [ { "name": "FY10", "code": "FY10" }, { "name": "FY11", "code": "FY11" }, { "name": "FY12", "code": "FY12" }, { "name": "FY13", "code": "FY13" }, { "name": "FY14", "code": "FY14" }, { "name": "FY15", "code": "FY15" }, { "name": "FY16", "code": "FY16" }, { "name": "FY17", "code": "FY17" }, { "name": "FY18", "code": "FY18" }, { "name": "FY19", "code": "FY19" }, { "name": "FY20", "code": "FY20" }, { "name": "FY21", "code": "FY21" }, { "name": "FY22", "code": "FY22" }, { "name": "FY23", "code": "FY23" }, { "name": "FY24", "code": "FY24" }, { "name": "FY25", "code": "FY25" }, { "name": "FY26", "code": "FY26" }, { "name": "FY27", "code": "FY27" }, { "name": "FY28", "code": "FY28" }, { "name": "FY29", "code": "FY29" }, { "name": "FY30", "code": "FY30" }, { "name": "FY31", "code": "FY31" }, { "name": "FY32", "code": "FY32" }, { "name": "FY33", "code": "FY33" }, { "name": "FY34", "code": "FY34" }, { "name": "FY35", "code": "FY35" }, { "name": "FY36", "code": "FY36" }, { "name": "FY37", "code": "FY37" }, { "name": "FY38", "code": "FY38" }, { "name": "FY39", "code": "FY39" }, { "name": "FY40", "code": "FY40" }, { "name": "FY41", "code": "FY41" }, { "name": "FY42", "code": "FY42" }, { "name": "FY43", "code": "FY43" }, { "name": "FY44", "code": "FY44" }, { "name": "FY45", "code": "FY45" }, { "name": "FY46", "code": "FY46" }, { "name": "FY47", "code": "FY47" }, { "name": "FY48", "code": "FY48" }, { "name": "FY49", "code": "FY49" }, { "name": "FY50", "code": "FY50" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LIFTSTATION_NUM", "type": "esriFieldTypeString", "alias": "Lift Station Number", "length": 10, "domain": null }, { "name": "LS_DIRECTION", "type": "esriFieldTypeString", "alias": "Lift Station Direction", "length": 10, "domain": { "type": "codedValue", "name": "sLSDirection", "codedValues": [ { "name": "North", "code": "N" }, { "name": "South", "code": "S" }, { "name": "East", "code": "E" }, { "name": "West", "code": "W" }, { "name": "Central", "code": "C" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NOTES2", "type": "esriFieldTypeString", "alias": "Notes 2", "length": 255, "domain": null }, { "name": "COMPKEY", "type": "esriFieldTypeInteger", "alias": "COMPKEY", "domain": null }, { "name": "KEYMAP", "type": "esriFieldTypeString", "alias": "Key Map", "length": 14, "domain": null }, { "name": "COUNCILDISTRICT", "type": "esriFieldTypeString", "alias": "Council District", "length": 10, "domain": { "type": "codedValue", "name": "COH Council District", "codedValues": [ { "name": "A", "code": "A" }, { "name": "B", "code": "B" }, { "name": "C", "code": "C" }, { "name": "D", "code": "D" }, { "name": "E", "code": "E" }, { "name": "F", "code": "F" }, { "name": "G", "code": "G" }, { "name": "H", "code": "H" }, { "name": "I", "code": "I" }, { "name": "K", "code": "K" }, { "name": "J", "code": "J" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ZONE", "type": "esriFieldTypeString", "alias": "Zone", "length": 10, "domain": { "type": "codedValue", "name": "UM Zones", "codedValues": [ { "name": "GNEHSA", "code": "GNEHSA" }, { "name": "IAH", "code": "IAH" }, { "name": "NE", "code": "NE" }, { "name": "NW", "code": "NW" }, { "name": "SE", "code": "SE" }, { "name": "SW", "code": "SW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IPSSUBTYPE", "type": "esriFieldTypeString", "alias": "IPSSUBTYPE", "length": 10, "domain": null }, { "name": "IPSFACILITYID", "type": "esriFieldTypeString", "alias": "IPSFACILITYID", "length": 11, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "DATUM", "type": "esriFieldTypeString", "alias": "Datum", "length": 10, "domain": { "type": "codedValue", "name": "sDatum", "codedValues": [ { "name": "City of Houston", "code": "COHnnnn" }, { "name": "U.S. Army Corps of Engrs", "code": "CORPnnnn" }, { "name": "Harris County Flood Control", "code": "HCFnnnn" }, { "name": "National Geodetic Survey", "code": "NGSnnnn" }, { "name": "Texas Highway Dept", "code": "THDnnnn" }, { "name": "U.S. Geological Survey", "code": "USGSnnnn" }, { "name": "U.S. Coastal and Geodetic Survey", "code": "UCGSnnnn" }, { "name": "Unknown", "code": "UNKnnnn" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Owner", "length": 10, "domain": { "type": "codedValue", "name": "sOwner", "codedValues": [ { "name": "City Owned/Maintained", "code": "C" }, { "name": "Privately Owned & Maintained", "code": "P" }, { "name": "City Own & Privately Maintained", "code": "CP" }, { "name": "Privately Own & City Maintained", "code": "PC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PIPESHAPE", "type": "esriFieldTypeString", "alias": "Pipe Shape", "length": 10, "domain": { "type": "codedValue", "name": "sPipe Shape", "codedValues": [ { "name": "Round", "code": "RND" }, { "name": "Arch", "code": "ARCH" }, { "name": "Box", "code": "BOX" }, { "name": "Oval", "code": "OVAL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PLANNUMBER", "type": "esriFieldTypeString", "alias": "Plan Number", "length": 10, "domain": null }, { "name": "REHABPLANNUMBER", "type": "esriFieldTypeString", "alias": "Rehab Plan Number", "length": 10, "domain": null }, { "name": "ILMSNUMBER", "type": "esriFieldTypeString", "alias": "ILMS Number", "length": 15, "domain": null }, { "name": "COSTPERACRE", "type": "esriFieldTypeString", "alias": "Cost Per Acre", "length": 20, "domain": null }, { "name": "CREATIONSOURCE", "type": "esriFieldTypeString", "alias": "Financial Assets", "length": 20, "domain": { "type": "codedValue", "name": "sCreation Source", "codedValues": [ { "name": "CAPITAL IMPROVEMENT PROJECT", "code": "CIP" }, { "name": "COMMERCIAL", "code": "COMMERCIAL" }, { "name": "DEVELOPER PARTICIPATION CONTRACTOR", "code": "DPC" }, { "name": "DEVELOPER", "code": "DEVELOPER" }, { "name": "FIELD VERIFICATION WASTEWATER", "code": "FVWW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DATASOURCETYPE", "type": "esriFieldTypeString", "alias": "Data Source Type", "length": 20, "domain": { "type": "codedValue", "name": "sData Source Type LINE", "codedValues": [ { "name": "Block Map", "code": "BM" }, { "name": "Plan and Profile", "code": "P" }, { "name": "As Built", "code": "AB" }, { "name": "Field Book", "code": "FB" }, { "name": "Taps and Meters", "code": "MT" }, { "name": "Metro", "code": "Metro" }, { "name": "Autocad Data from GHW Project", "code": "ACAD" }, { "name": "Wastewater Reconciliation Project", "code": "WWRECON" }, { "name": "Other Source (Operator Input)", "code": "O" }, { "name": "FVFL", "code": "FVFL" }, { "name": "FVFD", "code": "FVFD" }, { "name": "Unknown", "code": "\" \"" }, { "name": "Field Verified with Control Number", "code": "FV" }, { "name": "Construction Layer", "code": "CL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MOTIONNUMBER", "type": "esriFieldTypeString", "alias": "Motion Number", "length": 20, "domain": null }, { "name": "PERMITNUMBER", "type": "esriFieldTypeString", "alias": "Permit Number", "length": 20, "domain": null }, { "name": "PLANTYPE", "type": "esriFieldTypeString", "alias": "Plan Type", "length": 20, "domain": { "type": "codedValue", "name": "sPlan Type", "codedValues": [ { "name": "Plan and Profile", "code": "P" }, { "name": "Rehabilitation Drawing", "code": "R" }, { "name": "Proposed Rehabilitation Drawing", "code": "RP" }, { "name": "Texas Highway Department", "code": "THD" }, { "name": "Water Drawing", "code": "WD" }, { "name": "Unknown", "code": "UN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "REHABMATERIAL", "type": "esriFieldTypeString", "alias": "Rehab Material", "length": 20, "domain": { "type": "codedValue", "name": "sRehabilitation Material LINE", "codedValues": [ { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Cured in Place Pipe", "code": "CIPP" }, { "name": "Polyethylene Pipe", "code": "PEP" }, { "name": "Fiberglass Reinforced Pipe", "code": "FRP" }, { "name": "Plastic Lined Concrete Pipe", "code": "PLP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SOURCEOFFUND", "type": "esriFieldTypeString", "alias": "Funding Source", "length": 20, "domain": null }, { "name": "WCRNUMBER", "type": "esriFieldTypeString", "alias": "WCR Number", "length": 20, "domain": null }, { "name": "PROJECTNUMBER", "type": "esriFieldTypeString", "alias": "File Number", "length": 24, "domain": null }, { "name": "REHABPROJECTNUMBER", "type": "esriFieldTypeString", "alias": "Rehab Project Number", "length": 24, "domain": null }, { "name": "DOWNSTREAMMANHOLENUMBER", "type": "esriFieldTypeString", "alias": "Downstream Manhole Number", "length": 25, "domain": null }, { "name": "UPSTREAMMANHOLENUMBER", "type": "esriFieldTypeString", "alias": "Upstream Manhole Number", "length": 25, "domain": null }, { "name": "PROJECTTYPE", "type": "esriFieldTypeString", "alias": "Project Type", "length": 30, "domain": { "type": "codedValue", "name": "sProject Type", "codedValues": [ { "name": "City Job", "code": "JOB" }, { "name": "Waste Water", "code": "WW" }, { "name": "Government Financial System", "code": "GFS" }, { "name": "Street and Bridge", "code": "SB" }, { "name": "Work Business Structure", "code": "WBS" }, { "name": "Permit Number", "code": "PN" }, { "name": "Water", "code": "WA" }, { "name": "Unknown", "code": "UNKNOWN" }, { "name": "Storm", "code": "SM" }, { "name": "Control Section Job", "code": "CSJ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "REHABMETHOD", "type": "esriFieldTypeString", "alias": "Rehab Method", "length": 35, "domain": { "type": "codedValue", "name": "sRehabilitation Method LINE", "codedValues": [ { "name": "Cured in Place", "code": "CIPP" }, { "name": "Fold and Form", "code": "FLDF" }, { "name": "Pipe Burst", "code": "BRST" }, { "name": "Remove and Replace", "code": "RR" }, { "name": "Sliplined", "code": "SLIP" }, { "name": "Grout Joint", "code": "GJ" }, { "name": "Eco Cast", "code": "EC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DATUM_YEAR", "type": "esriFieldTypeString", "alias": "Datum Year", "length": 4, "domain": null }, { "name": "LAND_BASE_REVIEWED", "type": "esriFieldTypeString", "alias": "Land Base Reviewed", "length": 5, "domain": { "type": "codedValue", "name": "Yes No Reviewed", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GFSORWBS", "type": "esriFieldTypeString", "alias": "GFS or WBS", "length": 5, "domain": { "type": "codedValue", "name": "sProject Type2", "codedValues": [ { "name": "Government Financial System", "code": "GFS" }, { "name": "Work Business Structure", "code": "WBS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "GFSWBSNUMBER", "type": "esriFieldTypeString", "alias": "GFS-WBS Number", "length": 24, "domain": null }, { "name": "LENGTH", "type": "esriFieldTypeDouble", "alias": "Length", "domain": null }, { "name": "ADDRESS_ID", "type": "esriFieldTypeDouble", "alias": "ADDRESS_ID", "domain": null }, { "name": "MODELINGUSINVERTLEVEL", "type": "esriFieldTypeDouble", "alias": "U/S Pipe Invert Elevation", "domain": null }, { "name": "MODELINGUSINVERTFLAGDESC", "type": "esriFieldTypeString", "alias": "Flag for U/S Pipe Invert Elevation", "length": 50, "domain": null }, { "name": "MODELINGDSINVERTLEVEL", "type": "esriFieldTypeDouble", "alias": "D/S Pipe Invert Elevation", "domain": null }, { "name": "MODELINGDSINVERTFLAGDESC", "type": "esriFieldTypeString", "alias": "Flag for D/S Pipe Invert Elevation", "length": 50, "domain": null }, { "name": "UNITID2", "type": "esriFieldTypeString", "alias": "Unit ID 2", "length": 20, "domain": null }, { "name": "MAINCOMP1", "type": "esriFieldTypeSmallInteger", "alias": "Main Comp 1", "domain": null }, { "name": "MAINCOMP2", "type": "esriFieldTypeSmallInteger", "alias": "Main Comp 2", "domain": null }, { "name": "COMPTYPE", "type": "esriFieldTypeSmallInteger", "alias": "COMPTYPE", "domain": null }, { "name": "PARLINENO", "type": "esriFieldTypeString", "alias": "PARLINENO", "length": 2, "domain": null }, { "name": "UNITID", "type": "esriFieldTypeString", "alias": "UNITID", "length": 20, "domain": null }, { "name": "REPLACEMENTYR", "type": "esriFieldTypeString", "alias": "Replacement Year", "length": 4, "domain": { "type": "codedValue", "name": "ReplacementYear", "codedValues": [ { "name": "2010", "code": "2010" }, { "name": "2011", "code": "2011" }, { "name": "2012", "code": "2012" }, { "name": "2013", "code": "2013" }, { "name": "2014", "code": "2014" }, { "name": "2015", "code": "2015" }, { "name": "2016", "code": "2016" }, { "name": "2017", "code": "2017" }, { "name": "2018", "code": "2018" }, { "name": "2019", "code": "2019" }, { "name": "2020", "code": "2020" }, { "name": "2021", "code": "2021" }, { "name": "2022", "code": "2022" }, { "name": "2023", "code": "2023" }, { "name": "2024", "code": "2024" }, { "name": "2025", "code": "2025" }, { "name": "2026", "code": "2026" }, { "name": "2027", "code": "2027" }, { "name": "2028", "code": "2028" }, { "name": "2029", "code": "2029" }, { "name": "2030", "code": "2030" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "QCDATE", "type": "esriFieldTypeDate", "alias": "QC Date", "length": 8, "domain": null }, { "name": "PSCNUMBER", "type": "esriFieldTypeString", "alias": "PSC Number", "length": 20, "domain": null }, { "name": "MeterBasin", "type": "esriFieldTypeString", "alias": "Meter Basin", "length": 30, "domain": null }, { "name": "ADDRKEY", "type": "esriFieldTypeInteger", "alias": "ADDRKEY", "domain": null }, { "name": "IPSEXPIREDATE", "type": "esriFieldTypeDate", "alias": "IPS Expire Date", "length": 8, "domain": null }, { "name": "IPSEXPIREDBY", "type": "esriFieldTypeString", "alias": "IPS Expired By", "length": 10, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "indexes": [ { "name": "R389_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_389", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S199_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "id": 2, "name": "Sludge", "domains": { "ENABLED": {"type": "inherited"}, "QCVERIFIED": {"type": "inherited"}, "MATERIAL": {"type": "inherited"}, "LIFECYCLESTATUS": {"type": "inherited"}, "LENGTHSOURCE": {"type": "inherited"}, "DIAMETER": {"type": "inherited"}, "LS_DIRECTION": {"type": "inherited"}, "ZONE": {"type": "inherited"}, "REPLACEMENTYR": {"type": "inherited"} } }, { "id": 1, "name": "Force", "domains": { "ENABLED": {"type": "inherited"}, "QCVERIFIED": {"type": "inherited"}, "MATERIAL": {"type": "inherited"}, "LIFECYCLESTATUS": {"type": "inherited"}, "LENGTHSOURCE": {"type": "inherited"}, "DIAMETER": {"type": "inherited"}, "FISCAL_YEAR": {"type": "inherited"}, "LS_DIRECTION": {"type": "inherited"}, "ZONE": {"type": "inherited"}, "REPLACEMENTYR": {"type": "inherited"} } } ], "relationships": [], "canModifyLayer": true, "canScaleSymbols": true, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF, geoJSON", "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null }, { "currentVersion": 10.5, "id": 3, "name": "Wastewater Gravity Main", "type": "Feature Layer", "description": "The gravity main layer is a polyline feature class that contains information about the location and attributes of more than 5860 miles of sewer lines of the City of Houston\u2019s sewer collection system. According to the City's Infrastructure Design Manual, a sewer line is a public sewer located within public Right-Of-Way or Permanent Access (PAE)/Public Utility Easement (PUE) that is maintained and operated by the City. The gravity main feature class includes LS Pump Line, Collector, Siphon, and Trunk. The GIS Services Group of Houston Water, Houston Public Works currently stores and maintains the dataset within a Relational Database Management System (RDBMS). The data are derived from Plan and Profile Engineering drawings obtained from Block Map, As Built, Field Book, Taps and Meters, Metro, Autocad Data from GHW Project, Wastewater Reconciliation Project, Other Source (Operator Input), FVFL, FVFD, Field Verified with Control Number, and Construction Layer.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102740, "latestWkid": 2278 }, "copyrightText": "City of Houston, Houston Public Works, Houston Water, GIS Services", "parentLayer": null, "subLayers": [], "minScale": 50000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "SUBTYPECD", "field2": "OWNER", "field3": "SOURCEOFFUND", "defaultSymbol": null, "defaultLabel": null, "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 168, 0, 0, 255 ], "width": 6.900001525878906 }, "value": "8,C,", "label": "Trunk", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 0, 0, 255 ], "width": 6.900001525878906 }, "value": "3,C,", "label": "Collector", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 0, 0, 255 ], "width": 6.900001525878906 }, "value": "3,,", "label": "Collector", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 168, 0, 0, 255 ], "width": 6.900001525878906 }, "value": "5,C,", "label": "Siphon", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 0, 0, 255 ], "width": 0.5 }, "value": "9,C,", "label": "LS Pump Line", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 0, 0, 255 ], "width": 0.5 }, "value": "9,,", "label": "LS Pump Line", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 168, 0, 0, 255 ], "width": 2 }, "value": "8,P,", "label": "Trunk, Privately Owned", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 230, 0, 0, 255 ], "width": 1.5 }, "value": "3,P,", "label": "Collector, Privately Owned", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 168, 0, 0, 255 ], "width": 1.5 }, "value": "5,P,", "label": "Siphon, Privately Owned", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 230, 0, 0, 255 ], "width": 0.5 }, "value": "9,P,", "label": "LS Pump Line, Privately Owned", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 230, 0, 169, 255 ], "width": 2 }, "value": "9,C,PCS", "label": "Private Service Connection; 9, , DNT", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 230, 0, 169, 255 ], "width": 2 }, "value": "5,P,PCS", "label": "Private Service Connection; 9, , DNT", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 230, 0, 169, 255 ], "width": 2 }, "value": "5,C,PCS", "label": "Private Service Connection; 9, , DNT", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 230, 0, 169, 255 ], "width": 2 }, "value": "9,,PCS", "label": "Private Service Connection; 9, , DNT", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 230, 0, 169, 255 ], "width": 2 }, "value": "8,,PCS", "label": "Private Service Connection; 9, , DNT", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 230, 0, 169, 255 ], "width": 2 }, "value": "5,,PCS", "label": "Private Service Connection; 9, , DNT", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 230, 0, 169, 255 ], "width": 2 }, "value": "3,P,PSC", "label": "Private Service Connection; 9, , DNT", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 230, 0, 169, 255 ], "width": 2 }, "value": "3,,PCS", "label": "Private Service Connection; 9, , DNT", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 230, 0, 169, 255 ], "width": 2 }, "value": "8,P,PCS", "label": "Private Service Connection; 9, , DNT", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 230, 0, 169, 255 ], "width": 2 }, "value": "3,C,PSC", "label": "Private Service Connection; 9, , DNT", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 230, 0, 169, 255 ], "width": 2 }, "value": "9,P,PCS", "label": "Private Service Connection; 9, , DNT", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 230, 0, 169, 255 ], "width": 2 }, "value": "8,C,PCS", "label": "Private Service Connection; 9, , DNT", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 230, 0, 169, 255 ], "width": 2 }, "value": "9,,DNT", "label": "Private Service Connection; 9, , DNT", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 197, 255 ], "width": 2 }, "value": "9,P,DNT", "label": "Do Not Tap", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 197, 255 ], "width": 2 }, "value": "8,C,DNT", "label": "Do Not Tap", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 197, 255 ], "width": 2 }, "value": "3,C,DNT", "label": "Do Not Tap", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 197, 255 ], "width": 2 }, "value": "9,C,DNT", "label": "Do Not Tap", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 197, 255 ], "width": 2 }, "value": "5,P,DNT", "label": "Do Not Tap", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 197, 255 ], "width": 2 }, "value": "5,C,DNT", "label": "Do Not Tap", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 197, 255 ], "width": 2 }, "value": "8,,DNT", "label": "Do Not Tap", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 197, 255 ], "width": 2 }, "value": "5,,DNT", "label": "Do Not Tap", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 197, 255 ], "width": 2 }, "value": "3,,DNT", "label": "Do Not Tap", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 197, 255 ], "width": 2 }, "value": "8,P,DNT", "label": "Do Not Tap", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 197, 255 ], "width": 2 }, "value": "3,P,DNT", "label": "Do Not Tap", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3014649.2037613094, "ymin": 1.3762945270631611E7, "xmax": 3211938.466228783, "ymax": 1.3966090418051481E7, "spatialReference": { "wkid": 102740, "latestWkid": 2278 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "SUBDIVISION_NAME", "typeIdField": "SubtypeCD", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CREATIONUSER", "type": "esriFieldTypeString", "alias": "Employee Number", "length": 20, "domain": null }, { "name": "DATECREATED", "type": "esriFieldTypeDate", "alias": "Date Created", "length": 8, "domain": null }, { "name": "DATEMODIFIED", "type": "esriFieldTypeDate", "alias": "Date Modified", "length": 8, "domain": null }, { "name": "LASTUSER", "type": "esriFieldTypeString", "alias": "Last User", "length": 20, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 50, "domain": null }, { "name": "UFID", "type": "esriFieldTypeInteger", "alias": "UFID", "domain": null }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "Condition", "length": 20, "domain": null }, { "name": "CONDITIONDATE", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "QCVERIFIED", "type": "esriFieldTypeInteger", "alias": "QC Verified", "domain": { "type": "codedValue", "name": "sYes/No Indicator - Integer", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FIELDVERIFYNUM", "type": "esriFieldTypeInteger", "alias": "Field Verified Number", "domain": null }, { "name": "INSERVICEDATE", "type": "esriFieldTypeDate", "alias": "In Service Date", "length": 8, "domain": null }, { "name": "PLANDATE", "type": "esriFieldTypeDate", "alias": "Plan Date", "length": 8, "domain": null }, { "name": "REHABCOMPLETIONDATE", "type": "esriFieldTypeDate", "alias": "Rehab Completion Date", "length": 8, "domain": null }, { "name": "MOTIONDATE", "type": "esriFieldTypeDate", "alias": "Motion Date", "length": 8, "domain": null }, { "name": "PERMITDATE", "type": "esriFieldTypeDate", "alias": "Permit Date", "length": 8, "domain": null }, { "name": "SUBTYPECD", "type": "esriFieldTypeInteger", "alias": "Subtype", "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 5, "domain": { "type": "codedValue", "name": "sWater Line Material", "codedValues": [ { "name": "Clay or Concrete Brick", "code": "BRK" }, { "name": "Corrugated Metal Pipe", "code": "CGMP" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Cast Iron Soil Pipe", "code": "CISO" }, { "name": "Vitrified Clay Pipe and Fittings", "code": "CLAY" }, { "name": "Concrete", "code": "CONC" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Extra Strength Clay Pipe", "code": "ESC" }, { "name": "Extra Strength Concrete Pipe", "code": "ESP" }, { "name": "Monolithic Reinforced Concrete", "code": "MRC" }, { "name": "Polyethylene Pipe", "code": "PEP" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Conc Pipe", "code": "RCP" }, { "name": "Reinforced Conc Pipe w/Sliplining", "code": "RCSL" }, { "name": "Steel Cylinder Reinforced Conc Pipe", "code": "SRC" }, { "name": "Steel", "code": "STL" }, { "name": "Wrought Iron", "code": "WI" }, { "name": "Unknown", "code": "UNK" }, { "name": "Other", "code": "OTH" }, { "name": "Cured in Place Pipe", "code": "CIPP" }, { "name": "Reinforced Plastic Mortar Pipe", "code": "RPM" }, { "name": "Asbestos Concrete", "code": "AC" }, { "name": "Plastic", "code": "PL" }, { "name": "Non-Plastic", "code": "NPL" }, { "name": "Plastic Lined Concrete Pipe", "code": "PLP" }, { "name": "Unreinforced Concrete Pipe", "code": "URC" }, { "name": "Acrylonitrile Butadiene Styrene", "code": "ABS" }, { "name": "Reinforced Conc Pipe Asphalt", "code": "RCPA" }, { "name": "Fiberglass Reinforced Pipe", "code": "FRP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LIFECYCLESTATUS", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 5, "domain": { "type": "codedValue", "name": "sLifecycle Status", "codedValues": [ { "name": "Features Being Used and Maintained", "code": "E" }, { "name": "Proposed", "code": "P" }, { "name": "Abandoned", "code": "A" }, { "name": "Rehabilitated", "code": "R" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MEASUREDLENGTH", "type": "esriFieldTypeDouble", "alias": "Measured Length", "domain": null }, { "name": "LENGTHSOURCE", "type": "esriFieldTypeString", "alias": "Length Source", "length": 5, "domain": { "type": "codedValue", "name": "sLength Source", "codedValues": [ { "name": "Field Measurement", "code": "FM" }, { "name": "Mapping System", "code": "MS" }, { "name": "User-Derived", "code": "USER" }, { "name": "Engineering Drawing", "code": "EGDOC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WASTEWATERTRACEWEIGHT", "type": "esriFieldTypeInteger", "alias": "Wastewater Trace Weight", "domain": null }, { "name": "DISTANCETODOWNSTREAMMANHOLE", "type": "esriFieldTypeString", "alias": "Distance To Downstream Manhole", "length": 20, "domain": null }, { "name": "STUBLENGTH", "type": "esriFieldTypeInteger", "alias": "Stub Length", "domain": null }, { "name": "SIZE2", "type": "esriFieldTypeInteger", "alias": "Size 2", "domain": null }, { "name": "UPSTREAMINVERT", "type": "esriFieldTypeDouble", "alias": "Upstream Invert", "domain": null }, { "name": "DOWNSTREAMINVERT", "type": "esriFieldTypeDouble", "alias": "Downstream Invert", "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeInteger", "alias": "Size", "domain": { "type": "codedValue", "name": "sWaste Water Line Diameter", "codedValues": [ { "name": "2\"", "code": 2 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "21\"", "code": 21 }, { "name": "22\"", "code": 22 }, { "name": "24\"", "code": 24 }, { "name": "26\"", "code": 26 }, { "name": "27\"", "code": 27 }, { "name": "30\"", "code": 30 }, { "name": "33\"", "code": 33 }, { "name": "36\"", "code": 36 }, { "name": "42\"", "code": 42 }, { "name": "45\"", "code": 45 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "69\"", "code": 69 }, { "name": "72\"", "code": 72 }, { "name": "78\"", "code": 78 }, { "name": "82\"", "code": 82 }, { "name": "84\"", "code": 84 }, { "name": "90\"", "code": 90 }, { "name": "96\"", "code": 96 }, { "name": "102\"", "code": 102 }, { "name": "108\"", "code": 108 }, { "name": "114\"", "code": 114 }, { "name": "120\"", "code": 120 }, { "name": "132\"", "code": 132 }, { "name": "144\"", "code": 144 }, { "name": "168\"", "code": 168 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 }, { "name": "64\"", "code": 64 }, { "name": "85\"", "code": 85 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PERCENTSLOPE", "type": "esriFieldTypeDouble", "alias": "Percent Slope", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "SUBDIVISION_NAME", "type": "esriFieldTypeString", "alias": "Subdivision Name", "length": 50, "domain": null }, { "name": "FISCAL_YEAR", "type": "esriFieldTypeString", "alias": "Fiscal Year", "length": 10, "domain": { "type": "codedValue", "name": "sFiscalYear", "codedValues": [ { "name": "FY10", "code": "FY10" }, { "name": "FY11", "code": "FY11" }, { "name": "FY12", "code": "FY12" }, { "name": "FY13", "code": "FY13" }, { "name": "FY14", "code": "FY14" }, { "name": "FY15", "code": "FY15" }, { "name": "FY16", "code": "FY16" }, { "name": "FY17", "code": "FY17" }, { "name": "FY18", "code": "FY18" }, { "name": "FY19", "code": "FY19" }, { "name": "FY20", "code": "FY20" }, { "name": "FY21", "code": "FY21" }, { "name": "FY22", "code": "FY22" }, { "name": "FY23", "code": "FY23" }, { "name": "FY24", "code": "FY24" }, { "name": "FY25", "code": "FY25" }, { "name": "FY26", "code": "FY26" }, { "name": "FY27", "code": "FY27" }, { "name": "FY28", "code": "FY28" }, { "name": "FY29", "code": "FY29" }, { "name": "FY30", "code": "FY30" }, { "name": "FY31", "code": "FY31" }, { "name": "FY32", "code": "FY32" }, { "name": "FY33", "code": "FY33" }, { "name": "FY34", "code": "FY34" }, { "name": "FY35", "code": "FY35" }, { "name": "FY36", "code": "FY36" }, { "name": "FY37", "code": "FY37" }, { "name": "FY38", "code": "FY38" }, { "name": "FY39", "code": "FY39" }, { "name": "FY40", "code": "FY40" }, { "name": "FY41", "code": "FY41" }, { "name": "FY42", "code": "FY42" }, { "name": "FY43", "code": "FY43" }, { "name": "FY44", "code": "FY44" }, { "name": "FY45", "code": "FY45" }, { "name": "FY46", "code": "FY46" }, { "name": "FY47", "code": "FY47" }, { "name": "FY48", "code": "FY48" }, { "name": "FY49", "code": "FY49" }, { "name": "FY50", "code": "FY50" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "RMD_DELIVERY", "type": "esriFieldTypeString", "alias": "RMD Delivery", "length": 15, "domain": null }, { "name": "PUMPLINE_NUMBER", "type": "esriFieldTypeString", "alias": "Pumpline Number", "length": 15, "domain": null }, { "name": "NOTES2", "type": "esriFieldTypeString", "alias": "Notes 2", "length": 255, "domain": null }, { "name": "VIDEOLINK", "type": "esriFieldTypeString", "alias": "Video Link", "length": 255, "domain": null }, { "name": "BASELINESIZE", "type": "esriFieldTypeInteger", "alias": "Baseline Size", "domain": { "type": "codedValue", "name": "sWaste Water Line Diameter", "codedValues": [ { "name": "2\"", "code": 2 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "21\"", "code": 21 }, { "name": "22\"", "code": 22 }, { "name": "24\"", "code": 24 }, { "name": "26\"", "code": 26 }, { "name": "27\"", "code": 27 }, { "name": "30\"", "code": 30 }, { "name": "33\"", "code": 33 }, { "name": "36\"", "code": 36 }, { "name": "42\"", "code": 42 }, { "name": "45\"", "code": 45 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "69\"", "code": 69 }, { "name": "72\"", "code": 72 }, { "name": "78\"", "code": 78 }, { "name": "82\"", "code": 82 }, { "name": "84\"", "code": 84 }, { "name": "90\"", "code": 90 }, { "name": "96\"", "code": 96 }, { "name": "102\"", "code": 102 }, { "name": "108\"", "code": 108 }, { "name": "114\"", "code": 114 }, { "name": "120\"", "code": 120 }, { "name": "132\"", "code": 132 }, { "name": "144\"", "code": 144 }, { "name": "168\"", "code": 168 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 }, { "name": "64\"", "code": 64 }, { "name": "85\"", "code": 85 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "BASELINEMATERIAL", "type": "esriFieldTypeString", "alias": "Baseline Material", "length": 5, "domain": { "type": "codedValue", "name": "sWater Line Material", "codedValues": [ { "name": "Clay or Concrete Brick", "code": "BRK" }, { "name": "Corrugated Metal Pipe", "code": "CGMP" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Cast Iron Soil Pipe", "code": "CISO" }, { "name": "Vitrified Clay Pipe and Fittings", "code": "CLAY" }, { "name": "Concrete", "code": "CONC" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Extra Strength Clay Pipe", "code": "ESC" }, { "name": "Extra Strength Concrete Pipe", "code": "ESP" }, { "name": "Monolithic Reinforced Concrete", "code": "MRC" }, { "name": "Polyethylene Pipe", "code": "PEP" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Conc Pipe", "code": "RCP" }, { "name": "Reinforced Conc Pipe w/Sliplining", "code": "RCSL" }, { "name": "Steel Cylinder Reinforced Conc Pipe", "code": "SRC" }, { "name": "Steel", "code": "STL" }, { "name": "Wrought Iron", "code": "WI" }, { "name": "Unknown", "code": "UNK" }, { "name": "Other", "code": "OTH" }, { "name": "Cured in Place Pipe", "code": "CIPP" }, { "name": "Reinforced Plastic Mortar Pipe", "code": "RPM" }, { "name": "Asbestos Concrete", "code": "AC" }, { "name": "Plastic", "code": "PL" }, { "name": "Non-Plastic", "code": "NPL" }, { "name": "Plastic Lined Concrete Pipe", "code": "PLP" }, { "name": "Unreinforced Concrete Pipe", "code": "URC" }, { "name": "Acrylonitrile Butadiene Styrene", "code": "ABS" }, { "name": "Reinforced Conc Pipe Asphalt", "code": "RCPA" }, { "name": "Fiberglass Reinforced Pipe", "code": "FRP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "BASELINEAGE", "type": "esriFieldTypeDate", "alias": "Baseline Age", "length": 8, "domain": null }, { "name": "BASELINENOTES", "type": "esriFieldTypeString", "alias": "Baseline Notes", "length": 255, "domain": null }, { "name": "COMPKEY", "type": "esriFieldTypeInteger", "alias": "COMPKEY", "domain": null }, { "name": "CLEANTVDATE", "type": "esriFieldTypeDate", "alias": "Clean TV Date", "length": 8, "domain": null }, { "name": "CLEANTVMETHOD", "type": "esriFieldTypeString", "alias": "Clean TV Method", "length": 25, "domain": { "type": "codedValue", "name": "sCleanTVMethod", "codedValues": [ { "name": "Clean & TV", "code": "CCTV" }, { "name": "Sonar TV", "code": "SNRTV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "KEYMAP", "type": "esriFieldTypeString", "alias": "Key Map", "length": 14, "domain": null }, { "name": "COUNCILDISTRICT", "type": "esriFieldTypeString", "alias": "Council District", "length": 10, "domain": { "type": "codedValue", "name": "COH Council District", "codedValues": [ { "name": "A", "code": "A" }, { "name": "B", "code": "B" }, { "name": "C", "code": "C" }, { "name": "D", "code": "D" }, { "name": "E", "code": "E" }, { "name": "F", "code": "F" }, { "name": "G", "code": "G" }, { "name": "H", "code": "H" }, { "name": "I", "code": "I" }, { "name": "K", "code": "K" }, { "name": "J", "code": "J" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ZONE", "type": "esriFieldTypeString", "alias": "Zone", "length": 10, "domain": { "type": "codedValue", "name": "UM Zones", "codedValues": [ { "name": "GNEHSA", "code": "GNEHSA" }, { "name": "IAH", "code": "IAH" }, { "name": "NE", "code": "NE" }, { "name": "NW", "code": "NW" }, { "name": "SE", "code": "SE" }, { "name": "SW", "code": "SW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TVREPORT", "type": "esriFieldTypeString", "alias": "TV Report", "length": 255, "domain": null }, { "name": "MODELINGUSINVERTLEVEL", "type": "esriFieldTypeDouble", "alias": "U/S Pipe Invert Elevation", "domain": null }, { "name": "MODELINGUSINVERTFLAGDESC", "type": "esriFieldTypeString", "alias": "Flag for U/S Pipe Invert Elevation", "length": 50, "domain": null }, { "name": "MODELINGDSINVERTLEVEL", "type": "esriFieldTypeDouble", "alias": "D/S Pipe Invert Elevation", "domain": null }, { "name": "MODELINGDSINVERTFLAGDESC", "type": "esriFieldTypeString", "alias": "Flag for D/S Pipe Invert Elevation", "length": 50, "domain": null }, { "name": "IPSSUBTYPE", "type": "esriFieldTypeString", "alias": "IPSSUBTYPE", "length": 10, "domain": null }, { "name": "IPSFACILITYID", "type": "esriFieldTypeString", "alias": "IPSFACILITYID", "length": 11, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "DATUM", "type": "esriFieldTypeString", "alias": "Datum", "length": 10, "domain": { "type": "codedValue", "name": "sDatum", "codedValues": [ { "name": "City of Houston", "code": "COHnnnn" }, { "name": "U.S. Army Corps of Engrs", "code": "CORPnnnn" }, { "name": "Harris County Flood Control", "code": "HCFnnnn" }, { "name": "National Geodetic Survey", "code": "NGSnnnn" }, { "name": "Texas Highway Dept", "code": "THDnnnn" }, { "name": "U.S. Geological Survey", "code": "USGSnnnn" }, { "name": "U.S. Coastal and Geodetic Survey", "code": "UCGSnnnn" }, { "name": "Unknown", "code": "UNKnnnn" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Owner", "length": 10, "domain": { "type": "codedValue", "name": "sOwner", "codedValues": [ { "name": "City Owned/Maintained", "code": "C" }, { "name": "Privately Owned & Maintained", "code": "P" }, { "name": "City Own & Privately Maintained", "code": "CP" }, { "name": "Privately Own & City Maintained", "code": "PC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PIPESHAPE", "type": "esriFieldTypeString", "alias": "Pipe Shape", "length": 10, "domain": { "type": "codedValue", "name": "sPipe Shape", "codedValues": [ { "name": "Round", "code": "RND" }, { "name": "Arch", "code": "ARCH" }, { "name": "Box", "code": "BOX" }, { "name": "Oval", "code": "OVAL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PLANNUMBER", "type": "esriFieldTypeString", "alias": "Plan Number", "length": 10, "domain": null }, { "name": "REHABPLANNUMBER", "type": "esriFieldTypeString", "alias": "Rehab Plan Number", "length": 10, "domain": null }, { "name": "ILMSNUMBER", "type": "esriFieldTypeString", "alias": "ILMS Number", "length": 15, "domain": null }, { "name": "COSTPERACRE", "type": "esriFieldTypeString", "alias": "Cost Per Acre", "length": 20, "domain": null }, { "name": "CREATIONSOURCE", "type": "esriFieldTypeString", "alias": "Financial Assets", "length": 20, "domain": { "type": "codedValue", "name": "sCreation Source", "codedValues": [ { "name": "CAPITAL IMPROVEMENT PROJECT", "code": "CIP" }, { "name": "COMMERCIAL", "code": "COMMERCIAL" }, { "name": "DEVELOPER PARTICIPATION CONTRACTOR", "code": "DPC" }, { "name": "DEVELOPER", "code": "DEVELOPER" }, { "name": "FIELD VERIFICATION WASTEWATER", "code": "FVWW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DATASOURCETYPE", "type": "esriFieldTypeString", "alias": "Data Source Type", "length": 20, "domain": { "type": "codedValue", "name": "sData Source Type LINE", "codedValues": [ { "name": "Block Map", "code": "BM" }, { "name": "Plan and Profile", "code": "P" }, { "name": "As Built", "code": "AB" }, { "name": "Field Book", "code": "FB" }, { "name": "Taps and Meters", "code": "MT" }, { "name": "Metro", "code": "Metro" }, { "name": "Autocad Data from GHW Project", "code": "ACAD" }, { "name": "Wastewater Reconciliation Project", "code": "WWRECON" }, { "name": "Other Source (Operator Input)", "code": "O" }, { "name": "FVFL", "code": "FVFL" }, { "name": "FVFD", "code": "FVFD" }, { "name": "Unknown", "code": "\" \"" }, { "name": "Field Verified with Control Number", "code": "FV" }, { "name": "Construction Layer", "code": "CL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MOTIONNUMBER", "type": "esriFieldTypeString", "alias": "Motion Number", "length": 20, "domain": null }, { "name": "PERMITNUMBER", "type": "esriFieldTypeString", "alias": "Permit Number", "length": 20, "domain": null }, { "name": "PLANTYPE", "type": "esriFieldTypeString", "alias": "Plan Type", "length": 20, "domain": { "type": "codedValue", "name": "sPlan Type", "codedValues": [ { "name": "Plan and Profile", "code": "P" }, { "name": "Rehabilitation Drawing", "code": "R" }, { "name": "Proposed Rehabilitation Drawing", "code": "RP" }, { "name": "Texas Highway Department", "code": "THD" }, { "name": "Water Drawing", "code": "WD" }, { "name": "Unknown", "code": "UN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "REHABMATERIAL", "type": "esriFieldTypeString", "alias": "Rehab Material", "length": 20, "domain": { "type": "codedValue", "name": "sRehabilitation Material LINE", "codedValues": [ { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Cured in Place Pipe", "code": "CIPP" }, { "name": "Polyethylene Pipe", "code": "PEP" }, { "name": "Fiberglass Reinforced Pipe", "code": "FRP" }, { "name": "Plastic Lined Concrete Pipe", "code": "PLP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SOURCEOFFUND", "type": "esriFieldTypeString", "alias": "Funding Source", "length": 20, "domain": { "type": "codedValue", "name": "sSourceoffund", "codedValues": [ { "name": "Private Service Connection", "code": "PSC" }, { "name": "Do Not Tap", "code": "DNT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WCRNUMBER", "type": "esriFieldTypeString", "alias": "WCR Number", "length": 20, "domain": null }, { "name": "CLEANTVPROJECTNUMBER", "type": "esriFieldTypeString", "alias": "Clean TV Project Number", "length": 24, "domain": null }, { "name": "PROJECTNUMBER", "type": "esriFieldTypeString", "alias": "File Number", "length": 24, "domain": null }, { "name": "REHABPROJECTNUMBER", "type": "esriFieldTypeString", "alias": "Rehab Project Number", "length": 24, "domain": null }, { "name": "DOWNSTREAMMANHOLENUMBER", "type": "esriFieldTypeString", "alias": "Downstream Manhole Number", "length": 25, "domain": null }, { "name": "UPSTREAMMANHOLENUMBER", "type": "esriFieldTypeString", "alias": "Upstream Manhole Number", "length": 25, "domain": null }, { "name": "PROJECTTYPE", "type": "esriFieldTypeString", "alias": "Project Type", "length": 30, "domain": { "type": "codedValue", "name": "sProject Type", "codedValues": [ { "name": "City Job", "code": "JOB" }, { "name": "Waste Water", "code": "WW" }, { "name": "Government Financial System", "code": "GFS" }, { "name": "Street and Bridge", "code": "SB" }, { "name": "Work Business Structure", "code": "WBS" }, { "name": "Permit Number", "code": "PN" }, { "name": "Water", "code": "WA" }, { "name": "Unknown", "code": "UNKNOWN" }, { "name": "Storm", "code": "SM" }, { "name": "Control Section Job", "code": "CSJ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "REHABMETHOD", "type": "esriFieldTypeString", "alias": "Rehab Method", "length": 35, "domain": { "type": "codedValue", "name": "sRehabilitation Method LINE", "codedValues": [ { "name": "Cured in Place", "code": "CIPP" }, { "name": "Fold and Form", "code": "FLDF" }, { "name": "Pipe Burst", "code": "BRST" }, { "name": "Remove and Replace", "code": "RR" }, { "name": "Sliplined", "code": "SLIP" }, { "name": "Grout Joint", "code": "GJ" }, { "name": "Eco Cast", "code": "EC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DATUM_YEAR", "type": "esriFieldTypeString", "alias": "Datum Year", "length": 4, "domain": null }, { "name": "LAND_BASE_REVIEWED", "type": "esriFieldTypeString", "alias": "Land Base Reviewed", "length": 5, "domain": { "type": "codedValue", "name": "Yes No Reviewed", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GFSORWBS", "type": "esriFieldTypeString", "alias": "GFS Or WBS", "length": 5, "domain": { "type": "codedValue", "name": "sProject Type2", "codedValues": [ { "name": "Government Financial System", "code": "GFS" }, { "name": "Work Business Structure", "code": "WBS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "GFSWBSNUMBER", "type": "esriFieldTypeString", "alias": "GFS-WBS Number", "length": 24, "domain": null }, { "name": "ADDRESS_ID", "type": "esriFieldTypeDouble", "alias": "ADDRESS_ID", "domain": null }, { "name": "LENGTH", "type": "esriFieldTypeDouble", "alias": "Length", "domain": null }, { "name": "UNITID2", "type": "esriFieldTypeString", "alias": "Unit ID 2", "length": 20, "domain": null }, { "name": "MAINCOMP1", "type": "esriFieldTypeSmallInteger", "alias": "Main Comp 1", "domain": null }, { "name": "MAINCOMP2", "type": "esriFieldTypeSmallInteger", "alias": "Main Comp 2", "domain": null }, { "name": "COMPTYPE", "type": "esriFieldTypeSmallInteger", "alias": "COMPTYPE", "domain": null }, { "name": "PARLINENO", "type": "esriFieldTypeString", "alias": "PARLINENO", "length": 2, "domain": null }, { "name": "UNITID", "type": "esriFieldTypeString", "alias": "UNITID", "length": 20, "domain": null }, { "name": "IMSWONUM", "type": "esriFieldTypeInteger", "alias": "IMS Work Order Number", "domain": null }, { "name": "REHABWBSNUMBER", "type": "esriFieldTypeString", "alias": "Rehab WBS Number", "length": 16, "domain": null }, { "name": "REHABDIAMETER", "type": "esriFieldTypeDouble", "alias": "Rehab Size", "domain": { "type": "codedValue", "name": "sRehabilitation Diameter", "codedValues": [ { "name": "2\"", "code": 2 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "21\"", "code": 21 }, { "name": "22\"", "code": 22 }, { "name": "24\"", "code": 24 }, { "name": "26\"", "code": 26 }, { "name": "27\"", "code": 27 }, { "name": "30\"", "code": 30 }, { "name": "33\"", "code": 33 }, { "name": "36\"", "code": 36 }, { "name": "42\"", "code": 42 }, { "name": "45\"", "code": 45 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "69\"", "code": 69 }, { "name": "72\"", "code": 72 }, { "name": "78\"", "code": 78 }, { "name": "82\"", "code": 82 }, { "name": "84\"", "code": 84 }, { "name": "90\"", "code": 90 }, { "name": "96\"", "code": 96 }, { "name": "102\"", "code": 102 }, { "name": "108\"", "code": 108 }, { "name": "114\"", "code": 114 }, { "name": "120\"", "code": 120 }, { "name": "132\"", "code": 132 }, { "name": "144\"", "code": 144 }, { "name": "168\"", "code": 168 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 }, { "name": "64\"", "code": 64 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPLACEMENTYR", "type": "esriFieldTypeString", "alias": "Replacement Year", "length": 4, "domain": { "type": "codedValue", "name": "ReplacementYear", "codedValues": [ { "name": "2010", "code": "2010" }, { "name": "2011", "code": "2011" }, { "name": "2012", "code": "2012" }, { "name": "2013", "code": "2013" }, { "name": "2014", "code": "2014" }, { "name": "2015", "code": "2015" }, { "name": "2016", "code": "2016" }, { "name": "2017", "code": "2017" }, { "name": "2018", "code": "2018" }, { "name": "2019", "code": "2019" }, { "name": "2020", "code": "2020" }, { "name": "2021", "code": "2021" }, { "name": "2022", "code": "2022" }, { "name": "2023", "code": "2023" }, { "name": "2024", "code": "2024" }, { "name": "2025", "code": "2025" }, { "name": "2026", "code": "2026" }, { "name": "2027", "code": "2027" }, { "name": "2028", "code": "2028" }, { "name": "2029", "code": "2029" }, { "name": "2030", "code": "2030" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SECONDARYLENGTH", "type": "esriFieldTypeDouble", "alias": "Secondary Length", "domain": null }, { "name": "SECONDARYMATERIAL", "type": "esriFieldTypeString", "alias": "Secondary Material", "length": 5, "domain": { "type": "codedValue", "name": "sWater Line Material", "codedValues": [ { "name": "Clay or Concrete Brick", "code": "BRK" }, { "name": "Corrugated Metal Pipe", "code": "CGMP" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Cast Iron Soil Pipe", "code": "CISO" }, { "name": "Vitrified Clay Pipe and Fittings", "code": "CLAY" }, { "name": "Concrete", "code": "CONC" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Extra Strength Clay Pipe", "code": "ESC" }, { "name": "Extra Strength Concrete Pipe", "code": "ESP" }, { "name": "Monolithic Reinforced Concrete", "code": "MRC" }, { "name": "Polyethylene Pipe", "code": "PEP" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Conc Pipe", "code": "RCP" }, { "name": "Reinforced Conc Pipe w/Sliplining", "code": "RCSL" }, { "name": "Steel Cylinder Reinforced Conc Pipe", "code": "SRC" }, { "name": "Steel", "code": "STL" }, { "name": "Wrought Iron", "code": "WI" }, { "name": "Unknown", "code": "UNK" }, { "name": "Other", "code": "OTH" }, { "name": "Cured in Place Pipe", "code": "CIPP" }, { "name": "Reinforced Plastic Mortar Pipe", "code": "RPM" }, { "name": "Asbestos Concrete", "code": "AC" }, { "name": "Plastic", "code": "PL" }, { "name": "Non-Plastic", "code": "NPL" }, { "name": "Plastic Lined Concrete Pipe", "code": "PLP" }, { "name": "Unreinforced Concrete Pipe", "code": "URC" }, { "name": "Acrylonitrile Butadiene Styrene", "code": "ABS" }, { "name": "Reinforced Conc Pipe Asphalt", "code": "RCPA" }, { "name": "Fiberglass Reinforced Pipe", "code": "FRP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "QCDATE", "type": "esriFieldTypeDate", "alias": "QC Date", "length": 8, "domain": null }, { "name": "PSCNUMBER", "type": "esriFieldTypeString", "alias": "PSC Number", "length": 20, "domain": null }, { "name": "COMMUNITYSEWERINDICATOR", "type": "esriFieldTypeString", "alias": "Community Sewer Indicator", "length": 5, "domain": { "type": "codedValue", "name": "Yes/No Indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unk", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MeterBasin", "type": "esriFieldTypeString", "alias": "Meter Basin", "length": 30, "domain": null }, { "name": "IPSEXPIREDATE", "type": "esriFieldTypeDate", "alias": "IPS Expire Date", "length": 8, "domain": null }, { "name": "IPSEXPIREDBY", "type": "esriFieldTypeString", "alias": "IPS Expired By", "length": 10, "domain": null }, { "name": "ADDRKEY", "type": "esriFieldTypeInteger", "alias": "ADDRKEY", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "indexes": [ { "name": "R380_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_380", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I658PLANNUMBER", "fields": "PLANNUMBER", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I658PROJECTNUMBE", "fields": "PROJECTNUMBER", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I658COMPKEY", "fields": "COMPKEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I658SUBTYPECD9", "fields": "SUBTYPECD,OWNER,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I658FACILITYID8", "fields": "FACILITYID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I658MAINCOMP17", "fields": "MAINCOMP1,OBJECTID,UFID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I658MAINCOMP26", "fields": "MAINCOMP2,OBJECTID,UFID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I658UNITID2", "fields": "UNITID2", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I658UNITID", "fields": "UNITID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I658SUBTYPECD", "fields": "SUBTYPECD", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I658UFID", "fields": "UFID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S190_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "id": 9, "name": "LS Pump Line", "domains": { "ENABLED": {"type": "inherited"}, "QCVERIFIED": {"type": "inherited"}, "MATERIAL": {"type": "inherited"}, "LIFECYCLESTATUS": {"type": "inherited"}, "LENGTHSOURCE": {"type": "inherited"}, "DIAMETER": {"type": "inherited"}, "FISCAL_YEAR": {"type": "inherited"}, "ZONE": {"type": "inherited"}, "REHABMATERIAL": {"type": "inherited"}, "REHABMETHOD": {"type": "inherited"}, "REHABDIAMETER": {"type": "inherited"}, "REPLACEMENTYR": {"type": "inherited"} } }, { "id": 5, "name": "Siphon", "domains": { "ENABLED": {"type": "inherited"}, "QCVERIFIED": {"type": "inherited"}, "MATERIAL": {"type": "inherited"}, "LIFECYCLESTATUS": {"type": "inherited"}, "LENGTHSOURCE": {"type": "inherited"}, "DIAMETER": {"type": "inherited"}, "FISCAL_YEAR": {"type": "inherited"}, "ZONE": {"type": "inherited"}, "REHABMATERIAL": {"type": "inherited"}, "REHABMETHOD": {"type": "inherited"}, "REHABDIAMETER": {"type": "inherited"}, "REPLACEMENTYR": {"type": "inherited"} } }, { "id": 3, "name": "Small Diameter Main", "domains": { "ENABLED": {"type": "inherited"}, "QCVERIFIED": {"type": "inherited"}, "MATERIAL": {"type": "inherited"}, "LIFECYCLESTATUS": {"type": "inherited"}, "LENGTHSOURCE": {"type": "inherited"}, "DIAMETER": {"type": "inherited"}, "FISCAL_YEAR": {"type": "inherited"}, "BASELINESIZE": {"type": "inherited"}, "BASELINEMATERIAL": {"type": "inherited"}, "CLEANTVMETHOD": {"type": "inherited"}, "COUNCILDISTRICT": {"type": "inherited"}, "ZONE": {"type": "inherited"}, "DATUM": {"type": "inherited"}, "OWNER": {"type": "inherited"}, "PIPESHAPE": {"type": "inherited"}, "CREATIONSOURCE": {"type": "inherited"}, "DATASOURCETYPE": {"type": "inherited"}, "PLANTYPE": {"type": "inherited"}, "REHABMATERIAL": {"type": "inherited"}, "SOURCEOFFUND": {"type": "inherited"}, "PROJECTTYPE": {"type": "inherited"}, "REHABMETHOD": {"type": "inherited"}, "LAND_BASE_REVIEWED": {"type": "inherited"}, "GFSORWBS": {"type": "inherited"}, "REHABDIAMETER": {"type": "inherited"}, "REPLACEMENTYR": {"type": "inherited"}, "SECONDARYMATERIAL": {"type": "inherited"} } }, { "id": 8, "name": "Large Diameter Main", "domains": { "ENABLED": {"type": "inherited"}, "QCVERIFIED": {"type": "inherited"}, "MATERIAL": {"type": "inherited"}, "LIFECYCLESTATUS": {"type": "inherited"}, "LENGTHSOURCE": {"type": "inherited"}, "DIAMETER": {"type": "inherited"}, "FISCAL_YEAR": {"type": "inherited"}, "BASELINESIZE": {"type": "inherited"}, "BASELINEMATERIAL": {"type": "inherited"}, "CLEANTVMETHOD": {"type": "inherited"}, "COUNCILDISTRICT": {"type": "inherited"}, "ZONE": {"type": "inherited"}, "DATUM": {"type": "inherited"}, "OWNER": {"type": "inherited"}, "PIPESHAPE": {"type": "inherited"}, "CREATIONSOURCE": {"type": "inherited"}, "DATASOURCETYPE": {"type": "inherited"}, "PLANTYPE": {"type": "inherited"}, "REHABMATERIAL": {"type": "inherited"}, "SOURCEOFFUND": {"type": "inherited"}, "PROJECTTYPE": {"type": "inherited"}, "REHABMETHOD": {"type": "inherited"}, "LAND_BASE_REVIEWED": {"type": "inherited"}, "GFSORWBS": {"type": "inherited"}, "REHABDIAMETER": {"type": "inherited"}, "REPLACEMENTYR": {"type": "inherited"}, "SECONDARYMATERIAL": {"type": "inherited"} } } ], "relationships": [], "canModifyLayer": true, "canScaleSymbols": true, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF, geoJSON", "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null } ], "tables": [] }