{ "currentVersion" : 12, "id" : 0, "name" : "Force_Main", "type" : "Feature Layer", "serviceItemId" : "a62b675a264c4966903eeeee7f6040f2", "cacheMaxAge" : 30, "displayField" : "SUBDIVISION_NAME", "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’s 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.From GIMS Planning Database 09/28/2020", "copyrightText" : "City of Houston, Houston Public Works, Houston Water, GIS Services", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1603294512332, "schemaLastEditDate" : 1603294512332, "dataLastEditDate" : 1603294512332 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : true, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "Shape__Length", "units" : "esriFeet" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 80000, "maxScale" : 0, "extent" : { "xmin" : 3018756.747063458, "ymin" : 13757369.953280538, "xmax" : 3211897.4495636821, "ymax" : 13963263.333479552, "spatialReference" : { "wkid" : 102740, "latestWkid" : 2278 } }, "spatialReference" : { "wkid" : 102740, "latestWkid" : 2278 }, "drawingInfo":{"renderer":{"type":"classBreaks","field":"DIAMETER","classificationMethod":"esriClassifyNaturalBreaks","minValue":0,"classBreakInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,38,0,255],"width":1},"classMaxValue":6,"label":"0 - 6","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,38,0,255],"width":1},"classMaxValue":12,"label":"7 - 12","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,0,0,255],"width":1},"classMaxValue":21,"label":"13 - 21","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,38,0,255],"width":1},"classMaxValue":30,"label":"22 - 30","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,38,0,255],"width":1},"classMaxValue":60,"label":"31 - 60","description":""}]},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GLOBALID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "ENABLED", "type" : "esriFieldTypeSmallInteger", "alias" : "Enabled", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "EnabledDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "CREATIONUSER", "type" : "esriFieldTypeString", "alias" : "Employee Number", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DATECREATED", "type" : "esriFieldTypeDate", "alias" : "Date Created", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "DATEMODIFIED", "type" : "esriFieldTypeDate", "alias" : "Date Modified", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LASTUSER", "type" : "esriFieldTypeString", "alias" : "Last User", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FACILITYID", "type" : "esriFieldTypeString", "alias" : "Facility ID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UFID", "type" : "esriFieldTypeInteger", "alias" : "UFID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONDITION", "type" : "esriFieldTypeString", "alias" : "Condition", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONDITIONDATE", "type" : "esriFieldTypeDate", "alias" : "Condition Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "NOTES", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "QCVERIFIED", "type" : "esriFieldTypeInteger", "alias" : "QC Verified", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "sYes/No Indicator - Integer", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "FIELDVERIFYNUM", "type" : "esriFieldTypeInteger", "alias" : "Field Verified Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INSERVICEDATE", "type" : "esriFieldTypeDate", "alias" : "In Service Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "PLANDATE", "type" : "esriFieldTypeDate", "alias" : "Plan Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "REHABCOMPLETIONDATE", "type" : "esriFieldTypeDate", "alias" : "Rehab Completion Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "MOTIONDATE", "type" : "esriFieldTypeDate", "alias" : "Motion Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "PERMITDATE", "type" : "esriFieldTypeDate", "alias" : "Permit Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "SUBTYPECD", "type" : "esriFieldTypeInteger", "alias" : "Subtype", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MATERIAL", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "sWater Line Material", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "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" } ] }, "defaultValue" : null }, { "name" : "LIFECYCLESTATUS", "type" : "esriFieldTypeString", "alias" : "Lifecycle Status", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "sLifecycle Status_1", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Features Being Used and Maintained", "code" : "E" }, { "name" : "Proposed", "code" : "P" }, { "name" : "Abandoned", "code" : "A" }, { "name" : "Rehabilitated", "code" : "R" } ] }, "defaultValue" : null }, { "name" : "MEASUREDLENGTH", "type" : "esriFieldTypeDouble", "alias" : "Measured Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LENGTHSOURCE", "type" : "esriFieldTypeString", "alias" : "Length Source", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "sLength Source", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Field Measurement", "code" : "FM" }, { "name" : "Mapping System", "code" : "MS" }, { "name" : "User-Derived", "code" : "USER" }, { "name" : "Engineering Drawing", "code" : "EGDOC" } ] }, "defaultValue" : null }, { "name" : "WASTEWATERTRACEWEIGHT", "type" : "esriFieldTypeInteger", "alias" : "Wastewater Trace Weight", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DISTANCETODOWNSTREAMMANHOLE", "type" : "esriFieldTypeString", "alias" : "Distance To Downstream Manhole", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STUBLENGTH", "type" : "esriFieldTypeInteger", "alias" : "Stub Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SIZE2", "type" : "esriFieldTypeInteger", "alias" : "Size 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DIAMETER", "type" : "esriFieldTypeInteger", "alias" : "Size", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "sWaste Water Line Diameter_1", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "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 } ] }, "defaultValue" : null }, { "name" : "UPSTREAMINVERT", "type" : "esriFieldTypeDouble", "alias" : "Upstream Invert", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DOWNSTREAMINVERT", "type" : "esriFieldTypeDouble", "alias" : "Downstream Invert", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PERCENTSLOPE", "type" : "esriFieldTypeDouble", "alias" : "Percent Slope", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GROUNDCOVER", "type" : "esriFieldTypeDouble", "alias" : "Ground Cover", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GLOBALID", "type" : "esriFieldTypeGlobalID", "alias" : "GLOBALID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "SUBDIVISION_NAME", "type" : "esriFieldTypeString", "alias" : "Subdivision Name", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FISCAL_YEAR", "type" : "esriFieldTypeString", "alias" : "Fiscal Year", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "sFiscalYear_1", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "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" } ] }, "defaultValue" : null }, { "name" : "LIFTSTATION_NUM", "type" : "esriFieldTypeString", "alias" : "Lift Station Number", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LS_DIRECTION", "type" : "esriFieldTypeString", "alias" : "Lift Station Direction", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "sLSDirection", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "North", "code" : "N" }, { "name" : "South", "code" : "S" }, { "name" : "East", "code" : "E" }, { "name" : "West", "code" : "W" }, { "name" : "Central", "code" : "C" } ] }, "defaultValue" : null }, { "name" : "NOTES2", "type" : "esriFieldTypeString", "alias" : "Notes 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COMPKEY", "type" : "esriFieldTypeInteger", "alias" : "COMPKEY", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "KEYMAP", "type" : "esriFieldTypeString", "alias" : "Key Map", "sqlType" : "sqlTypeOther", "length" : 14, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COUNCILDISTRICT", "type" : "esriFieldTypeString", "alias" : "Council District", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "COH Council District", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "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" } ] }, "defaultValue" : null }, { "name" : "ZONE", "type" : "esriFieldTypeString", "alias" : "Zone", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "UM Zones", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "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" } ] }, "defaultValue" : null }, { "name" : "IPSSUBTYPE", "type" : "esriFieldTypeString", "alias" : "IPSSUBTYPE", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "IPSFACILITYID", "type" : "esriFieldTypeString", "alias" : "IPSFACILITYID", "sqlType" : "sqlTypeOther", "length" : 11, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ADDRESS", "type" : "esriFieldTypeString", "alias" : "ADDRESS", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DATUM", "type" : "esriFieldTypeString", "alias" : "Datum", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "sDatum", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "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" } ] }, "defaultValue" : null }, { "name" : "OWNER", "type" : "esriFieldTypeString", "alias" : "Owner", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "sOwner", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "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" } ] }, "defaultValue" : null }, { "name" : "PIPESHAPE", "type" : "esriFieldTypeString", "alias" : "Pipe Shape", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "sPipe Shape", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Round", "code" : "RND" }, { "name" : "Arch", "code" : "ARCH" }, { "name" : "Box", "code" : "BOX" }, { "name" : "Oval", "code" : "OVAL" } ] }, "defaultValue" : null }, { "name" : "PLANNUMBER", "type" : "esriFieldTypeString", "alias" : "Plan Number", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "REHABPLANNUMBER", "type" : "esriFieldTypeString", "alias" : "Rehab Plan Number", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ILMSNUMBER", "type" : "esriFieldTypeString", "alias" : "ILMS Number", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COSTPERACRE", "type" : "esriFieldTypeString", "alias" : "Cost Per Acre", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CREATIONSOURCE", "type" : "esriFieldTypeString", "alias" : "Financial Assets", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "sCreation Source", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "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" } ] }, "defaultValue" : null }, { "name" : "DATASOURCETYPE", "type" : "esriFieldTypeString", "alias" : "Data Source Type", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "sData Source Type LINE", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "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" } ] }, "defaultValue" : null }, { "name" : "MOTIONNUMBER", "type" : "esriFieldTypeString", "alias" : "Motion Number", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PCSNUMBER", "type" : "esriFieldTypeString", "alias" : "PCS Number", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PERMITNUMBER", "type" : "esriFieldTypeString", "alias" : "Permit Number", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PLANTYPE", "type" : "esriFieldTypeString", "alias" : "Plan Type", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "sPlan Type", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "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" } ] }, "defaultValue" : null }, { "name" : "REHABMATERIAL", "type" : "esriFieldTypeString", "alias" : "Rehab Material", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "sRehabilitation Material LINE", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "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" } ] }, "defaultValue" : null }, { "name" : "SOURCEOFFUND", "type" : "esriFieldTypeString", "alias" : "Funding Source", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WCRNUMBER", "type" : "esriFieldTypeString", "alias" : "WCR Number", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PROJECTNUMBER", "type" : "esriFieldTypeString", "alias" : "File Number", "sqlType" : "sqlTypeOther", "length" : 24, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "REHABPROJECTNUMBER", "type" : "esriFieldTypeString", "alias" : "Rehab Project Number", "sqlType" : "sqlTypeOther", "length" : 24, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DOWNSTREAMMANHOLENUMBER", "type" : "esriFieldTypeString", "alias" : "Downstream Manhole Number", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UPSTREAMMANHOLENUMBER", "type" : "esriFieldTypeString", "alias" : "Upstream Manhole Number", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PROJECTTYPE", "type" : "esriFieldTypeString", "alias" : "Project Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "sProject Type", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "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" } ] }, "defaultValue" : null }, { "name" : "REHABMETHOD", "type" : "esriFieldTypeString", "alias" : "Rehab Method", "sqlType" : "sqlTypeOther", "length" : 35, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "sRehabilitation Method LINE", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "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" } ] }, "defaultValue" : null }, { "name" : "DATUM_YEAR", "type" : "esriFieldTypeString", "alias" : "Datum Year", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LAND_BASE_REVIEWED", "type" : "esriFieldTypeString", "alias" : "Land Base Reviewed", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes No Reviewed", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "GFSORWBS", "type" : "esriFieldTypeString", "alias" : "GFS-WBS Number", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "sProject Type2", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Government Financial System", "code" : "GFS" }, { "name" : "Work Business Structure", "code" : "WBS" } ] }, "defaultValue" : null }, { "name" : "GFSWBSNUMBER", "type" : "esriFieldTypeString", "alias" : "PROJECTNUMBER2", "sqlType" : "sqlTypeOther", "length" : 24, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LENGTH", "type" : "esriFieldTypeDouble", "alias" : "Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ADDRESS_ID", "type" : "esriFieldTypeDouble", "alias" : "ADDRESS_ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MODELINGUSINVERTLEVEL", "type" : "esriFieldTypeDouble", "alias" : "U/S Pipe Invert Elevation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MODELINGUSINVERTFLAGDESC", "type" : "esriFieldTypeString", "alias" : "Flag for U/S Pipe Invert Elevation", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MODELINGDSINVERTLEVEL", "type" : "esriFieldTypeDouble", "alias" : "D/S Pipe Invert Elevation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MODELINGDSINVERTFLAGDESC", "type" : "esriFieldTypeString", "alias" : "Flag for D/S Pipe Invert Elevation", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UNITID2", "type" : "esriFieldTypeString", "alias" : "Unit ID 2", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MAINCOMP1", "type" : "esriFieldTypeSmallInteger", "alias" : "Main Comp 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MAINCOMP2", "type" : "esriFieldTypeSmallInteger", "alias" : "Main Comp 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COMPTYPE", "type" : "esriFieldTypeSmallInteger", "alias" : "COMPTYPE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PARLINENO", "type" : "esriFieldTypeString", "alias" : "PARLINENO", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UNITID", "type" : "esriFieldTypeString", "alias" : "UNITID", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "REPLACEMENTYR", "type" : "esriFieldTypeString", "alias" : "Replacement Year", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ReplacementYear", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "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" } ] }, "defaultValue" : null }, { "name" : "QCDATE", "type" : "esriFieldTypeDate", "alias" : "QC Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__FORCE_MA__F4B70D8503EDD4DE", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_279.FORCE_MAIN_FORCE_MAIN_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GLOBALID", "fields" : "GLOBALID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Force_Main", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "REPLACEMENTYR" : null, "QCDATE" : null, "ENABLED" : 1, "CREATIONUSER" : null, "DATECREATED" : null, "DATEMODIFIED" : null, "LASTUSER" : null, "FACILITYID" : null, "UFID" : null, "CONDITION" : null, "CONDITIONDATE" : null, "NOTES" : null, "QCVERIFIED" : null, "FIELDVERIFYNUM" : null, "INSERVICEDATE" : null, "PLANDATE" : null, "REHABCOMPLETIONDATE" : null, "MOTIONDATE" : null, "PERMITDATE" : null, "SUBTYPECD" : 1, "MATERIAL" : "PVC", "LIFECYCLESTATUS" : "E", "MEASUREDLENGTH" : 0, "LENGTHSOURCE" : "MS", "WASTEWATERTRACEWEIGHT" : null, "DISTANCETODOWNSTREAMMANHOLE" : null, "STUBLENGTH" : null, "SIZE2" : null, "DIAMETER" : 12, "UPSTREAMINVERT" : null, "DOWNSTREAMINVERT" : null, "PERCENTSLOPE" : null, "GROUNDCOVER" : null, "UNITID" : null, "SUBDIVISION_NAME" : null, "FISCAL_YEAR" : null, "LIFTSTATION_NUM" : null, "LS_DIRECTION" : null, "NOTES2" : null, "COMPKEY" : null, "KEYMAP" : null, "COUNCILDISTRICT" : null, "ZONE" : null, "IPSSUBTYPE" : null, "IPSFACILITYID" : null, "ADDRESS" : null, "DATUM" : null, "OWNER" : null, "PIPESHAPE" : null, "PLANNUMBER" : null, "REHABPLANNUMBER" : null, "ILMSNUMBER" : null, "COSTPERACRE" : null, "CREATIONSOURCE" : null, "DATASOURCETYPE" : null, "MOTIONNUMBER" : null, "PCSNUMBER" : null, "PERMITNUMBER" : null, "PLANTYPE" : null, "REHABMATERIAL" : null, "SOURCEOFFUND" : null, "WCRNUMBER" : null, "PROJECTNUMBER" : null, "REHABPROJECTNUMBER" : null, "DOWNSTREAMMANHOLENUMBER" : null, "UPSTREAMMANHOLENUMBER" : null, "PROJECTTYPE" : null, "REHABMETHOD" : null, "DATUM_YEAR" : null, "LAND_BASE_REVIEWED" : null, "GFSORWBS" : null, "GFSWBSNUMBER" : null, "LENGTH" : null, "ADDRESS_ID" : null, "MODELINGUSINVERTLEVEL" : null, "MODELINGUSINVERTFLAGDESC" : null, "MODELINGDSINVERTLEVEL" : null, "MODELINGDSINVERTFLAGDESC" : null, "UNITID2" : null, "MAINCOMP1" : null, "MAINCOMP2" : null, "COMPTYPE" : null, "PARLINENO" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query", "subtypeField" : "SubtypeCD", "defaultSubtypeCode" : 1, "subtypes" : [ { "code" : 2, "name" : "Sludge", "defaultValues" : { "ENABLED" : 1, "CREATIONUSER" : null, "DATECREATED" : null, "DATEMODIFIED" : null, "LASTUSER" : null, "FACILITYID" : null, "UFID" : null, "CONDITION" : null, "CONDITIONDATE" : null, "NOTES" : null, "QCVERIFIED" : null, "FIELDVERIFYNUM" : null, "INSERVICEDATE" : null, "PLANDATE" : null, "REHABCOMPLETIONDATE" : null, "MOTIONDATE" : null, "PERMITDATE" : null, "SUBTYPECD" : 2, "MATERIAL" : "PVC", "LIFECYCLESTATUS" : "E", "MEASUREDLENGTH" : 0, "LENGTHSOURCE" : "MS", "WASTEWATERTRACEWEIGHT" : null, "DISTANCETODOWNSTREAMMANHOLE" : null, "STUBLENGTH" : null, "SIZE2" : null, "DIAMETER" : 12, "UPSTREAMINVERT" : null, "DOWNSTREAMINVERT" : null, "PERCENTSLOPE" : null, "GROUNDCOVER" : null, "SUBDIVISION_NAME" : null, "FISCAL_YEAR" : null, "LIFTSTATION_NUM" : null, "LS_DIRECTION" : null, "NOTES2" : null, "COMPKEY" : null, "KEYMAP" : null, "COUNCILDISTRICT" : null, "ZONE" : null, "IPSSUBTYPE" : null, "IPSFACILITYID" : null, "ADDRESS" : null, "DATUM" : null, "OWNER" : null, "PIPESHAPE" : null, "PLANNUMBER" : null, "REHABPLANNUMBER" : null, "ILMSNUMBER" : null, "COSTPERACRE" : null, "CREATIONSOURCE" : null, "DATASOURCETYPE" : null, "MOTIONNUMBER" : null, "PCSNUMBER" : null, "PERMITNUMBER" : null, "PLANTYPE" : null, "REHABMATERIAL" : null, "SOURCEOFFUND" : null, "WCRNUMBER" : null, "PROJECTNUMBER" : null, "REHABPROJECTNUMBER" : null, "DOWNSTREAMMANHOLENUMBER" : null, "UPSTREAMMANHOLENUMBER" : null, "PROJECTTYPE" : null, "REHABMETHOD" : null, "DATUM_YEAR" : null, "LAND_BASE_REVIEWED" : null, "GFSORWBS" : null, "GFSWBSNUMBER" : null, "LENGTH" : null, "ADDRESS_ID" : null, "MODELINGUSINVERTLEVEL" : null, "MODELINGUSINVERTFLAGDESC" : null, "MODELINGDSINVERTLEVEL" : null, "MODELINGDSINVERTFLAGDESC" : null, "UNITID2" : null, "MAINCOMP1" : null, "MAINCOMP2" : null, "COMPTYPE" : null, "PARLINENO" : null, "UNITID" : null, "REPLACEMENTYR" : null, "QCDATE" : null }, "domains" : { "ENABLED" : { "type" : "codedValue", "name" : "EnabledDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "QCVERIFIED" : { "type" : "codedValue", "name" : "sYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "MATERIAL" : { "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" } ] }, "LIFECYCLESTATUS" : { "type" : "codedValue", "name" : "sLifecycle Status_1", "codedValues" : [ { "name" : "Features Being Used and Maintained", "code" : "E" }, { "name" : "Proposed", "code" : "P" }, { "name" : "Abandoned", "code" : "A" }, { "name" : "Rehabilitated", "code" : "R" } ] }, "LENGTHSOURCE" : { "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" } ] }, "DIAMETER" : { "type" : "codedValue", "name" : "sWaste Water Line Diameter_1", "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 } ] }, "FISCAL_YEAR" : { "type" : "codedValue", "name" : "sFiscalYear_1", "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" } ] }, "LS_DIRECTION" : { "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" } ] }, "COUNCILDISTRICT" : { "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" } ] }, "ZONE" : { "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" } ] }, "DATUM" : { "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" } ] }, "OWNER" : { "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" } ] }, "PIPESHAPE" : { "type" : "codedValue", "name" : "sPipe Shape", "codedValues" : [ { "name" : "Round", "code" : "RND" }, { "name" : "Arch", "code" : "ARCH" }, { "name" : "Box", "code" : "BOX" }, { "name" : "Oval", "code" : "OVAL" } ] }, "CREATIONSOURCE" : { "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" } ] }, "DATASOURCETYPE" : { "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" } ] }, "PLANTYPE" : { "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" } ] }, "REHABMATERIAL" : { "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" } ] }, "PROJECTTYPE" : { "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" } ] }, "REHABMETHOD" : { "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" } ] }, "LAND_BASE_REVIEWED" : { "type" : "codedValue", "name" : "Yes No Reviewed", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "GFSORWBS" : { "type" : "codedValue", "name" : "sProject Type2", "codedValues" : [ { "name" : "Government Financial System", "code" : "GFS" }, { "name" : "Work Business Structure", "code" : "WBS" } ] }, "REPLACEMENTYR" : { "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" } ] } } }, { "code" : 1, "name" : "Force", "defaultValues" : { "ENABLED" : 1, "CREATIONUSER" : null, "DATECREATED" : null, "DATEMODIFIED" : null, "LASTUSER" : null, "FACILITYID" : null, "UFID" : null, "CONDITION" : null, "CONDITIONDATE" : null, "NOTES" : null, "QCVERIFIED" : null, "FIELDVERIFYNUM" : null, "INSERVICEDATE" : null, "PLANDATE" : null, "REHABCOMPLETIONDATE" : null, "MOTIONDATE" : null, "PERMITDATE" : null, "SUBTYPECD" : 1, "MATERIAL" : "PVC", "LIFECYCLESTATUS" : "E", "MEASUREDLENGTH" : 0, "LENGTHSOURCE" : "MS", "WASTEWATERTRACEWEIGHT" : null, "DISTANCETODOWNSTREAMMANHOLE" : null, "STUBLENGTH" : null, "SIZE2" : null, "DIAMETER" : 12, "UPSTREAMINVERT" : null, "DOWNSTREAMINVERT" : null, "PERCENTSLOPE" : null, "GROUNDCOVER" : null, "SUBDIVISION_NAME" : null, "FISCAL_YEAR" : null, "LIFTSTATION_NUM" : null, "LS_DIRECTION" : null, "NOTES2" : null, "COMPKEY" : null, "KEYMAP" : null, "COUNCILDISTRICT" : null, "ZONE" : null, "IPSSUBTYPE" : null, "IPSFACILITYID" : null, "ADDRESS" : null, "DATUM" : null, "OWNER" : null, "PIPESHAPE" : null, "PLANNUMBER" : null, "REHABPLANNUMBER" : null, "ILMSNUMBER" : null, "COSTPERACRE" : null, "CREATIONSOURCE" : null, "DATASOURCETYPE" : null, "MOTIONNUMBER" : null, "PCSNUMBER" : null, "PERMITNUMBER" : null, "PLANTYPE" : null, "REHABMATERIAL" : null, "SOURCEOFFUND" : null, "WCRNUMBER" : null, "PROJECTNUMBER" : null, "REHABPROJECTNUMBER" : null, "DOWNSTREAMMANHOLENUMBER" : null, "UPSTREAMMANHOLENUMBER" : null, "PROJECTTYPE" : null, "REHABMETHOD" : null, "DATUM_YEAR" : null, "LAND_BASE_REVIEWED" : null, "GFSORWBS" : null, "GFSWBSNUMBER" : null, "LENGTH" : null, "ADDRESS_ID" : null, "MODELINGUSINVERTLEVEL" : null, "MODELINGUSINVERTFLAGDESC" : null, "MODELINGDSINVERTLEVEL" : null, "MODELINGDSINVERTFLAGDESC" : null, "UNITID2" : null, "MAINCOMP1" : null, "MAINCOMP2" : null, "COMPTYPE" : null, "PARLINENO" : null, "UNITID" : null, "REPLACEMENTYR" : null, "QCDATE" : null }, "domains" : { "ENABLED" : { "type" : "codedValue", "name" : "EnabledDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "QCVERIFIED" : { "type" : "codedValue", "name" : "sYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "MATERIAL" : { "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" } ] }, "LIFECYCLESTATUS" : { "type" : "codedValue", "name" : "sLifecycle Status_1", "codedValues" : [ { "name" : "Features Being Used and Maintained", "code" : "E" }, { "name" : "Proposed", "code" : "P" }, { "name" : "Abandoned", "code" : "A" }, { "name" : "Rehabilitated", "code" : "R" } ] }, "LENGTHSOURCE" : { "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" } ] }, "DIAMETER" : { "type" : "codedValue", "name" : "sWaste Water Line Diameter_1", "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 } ] }, "FISCAL_YEAR" : { "type" : "codedValue", "name" : "sFiscalYear_1", "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" } ] }, "LS_DIRECTION" : { "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" } ] }, "COUNCILDISTRICT" : { "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" } ] }, "ZONE" : { "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" } ] }, "DATUM" : { "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" } ] }, "OWNER" : { "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" } ] }, "PIPESHAPE" : { "type" : "codedValue", "name" : "sPipe Shape", "codedValues" : [ { "name" : "Round", "code" : "RND" }, { "name" : "Arch", "code" : "ARCH" }, { "name" : "Box", "code" : "BOX" }, { "name" : "Oval", "code" : "OVAL" } ] }, "CREATIONSOURCE" : { "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" } ] }, "DATASOURCETYPE" : { "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" } ] }, "PLANTYPE" : { "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" } ] }, "REHABMATERIAL" : { "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" } ] }, "PROJECTTYPE" : { "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" } ] }, "REHABMETHOD" : { "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" } ] }, "LAND_BASE_REVIEWED" : { "type" : "codedValue", "name" : "Yes No Reviewed", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "GFSORWBS" : { "type" : "codedValue", "name" : "sProject Type2", "codedValues" : [ { "name" : "Government Financial System", "code" : "GFS" }, { "name" : "Work Business Structure", "code" : "WBS" } ] }, "REPLACEMENTYR" : { "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" } ] } } } ] }