{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "wHydrant", "type" : "Feature Layer", "serviceItemId" : "110748ef134e444a8f2bf0acee581a95", "cacheMaxAge" : 30, "displayField" : "FACILITYNAME", "description" : "\u003cDIV STYLE=\"text-align:Left;\"\u003e\u003cDIV\u003e\u003cDIV\u003e\u003cP\u003e\u003cSPAN\u003e\u003cSPAN\u003eThis point feature class contains information about the geographic location and related attributes of the City of Houston’s owned and maintained hydrants. \u003c/span\u003e\u003c/span\u003e\u003c/p\u003e\u003cP\u003e\u003cP\u003e\u003cSPAN\u003e\u003cSPAN\u003eThe information in this layer is derived from the Plan and Profile Engineering Drawings that come from the following sources: Block Map, As-Built, Field Verified with Control Number, Taps and Meters, Metro, Field Verified Fire Department, Field Verified Fire Line, Construction Drawing (Layer), Fire Department, and Capital Improvement Project. \u003c/span\u003e\u003c/span\u003e\u003c/p\u003e\u003cP\u003e\u003cP\u003e\u003cSPAN\u003e\u003cSPAN\u003eThe GIS Services Group of Houston Water, Houston Public Works currently stores and maintains the dataset in a Relational Database Management System. \u003c/span\u003e\u003c/span\u003e\u003c/p\u003e\u003cP\u003e\u003cSPAN STYLE=\"font-style:italic;\"\u003eGeospatial or map data maintained by the Houston Public Works for informational purposes and may not have been prepared for or be suitable for legal, engineering, or surveying purposes. It does not represent an on-the-ground survey and only represents the approximate location of these assets.\u003c/span\u003e\u003c/p\u003e\u003cP\u003e\u003cSPAN\u003e\u003cSPAN /\u003e\u003c/span\u003e\u003c/p\u003e\u003c/div\u003e\u003c/div\u003e\u003c/div\u003e\u003c/p\u003e\u003c/p\u003e", "copyrightText" : "Originator: City of Houston, Houston Public Works, Houston Water, GIS Services \nPublication Date: 06/10/2021 \nEditors: Albert Lent / Myriam Wright\nContact Person: Kirt Arthur / kirt.arthur@houstontx.gov", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1738880913756, "schemaLastEditDate" : 1738880913756, "dataLastEditDate" : 1738880913756 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "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, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "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" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -10654305.909552528, "ymin" : 3442822.8330964833, "xmax" : -10585246.798168592, "ymax" : 3517580.5760013605, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"SUBTYPECD","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,130,130,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[215,252,246,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"8","label":"Fire Hydrant"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[197,252,206,255],"toColor":[197,252,206,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,241,255],"toColor":[252,179,241,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,218,252,255],"toColor":[182,218,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,214,194,255],"toColor":[252,214,194,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[246,252,179,255],"toColor":[246,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[202,252,252,255],"toColor":[202,252,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[200,189,252,255],"toColor":[200,189,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,241,255],"toColor":[252,212,241,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,189,255],"toColor":[252,179,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,249,212,255],"toColor":[252,249,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[214,252,184,255],"toColor":[214,252,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[219,212,252,255],"toColor":[219,212,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[223,179,252,255],"toColor":[223,179,252,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "SUBTYPECD", "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" : "ANCILLARYROLE", "type" : "esriFieldTypeSmallInteger", "alias" : "Ancillary Role", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AncillaryRoleDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "None", "code" : 0 }, { "name" : "Source", "code" : 1 }, { "name" : "Sink", "code" : 2 } ] }, "defaultValue" : 0 }, { "name" : "ENABLED", "type" : "esriFieldTypeSmallInteger", "alias" : "Enabled", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "EnabledDomain_8", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : 1 }, { "name" : "CREATIONUSER", "type" : "esriFieldTypeString", "alias" : "Employee Number", "sqlType" : "sqlTypeOther", "length" : 30, "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" : 30, "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" : "UFID", "type" : "esriFieldTypeInteger", "alias" : "UFID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NOTES", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "QCVERIFIED", "type" : "esriFieldTypeString", "alias" : "QC Verified", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wYes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "PLANDATE", "type" : "esriFieldTypeDate", "alias" : "Plan Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "DATASOURCEREFNUM", "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" : "CREATIONSOURCE", "type" : "esriFieldTypeString", "alias" : "Financial Assets", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wCreation 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 WATER", "code" : "FVW" } ] }, "defaultValue" : null }, { "name" : "SOURCEOFFUND", "type" : "esriFieldTypeString", "alias" : "Funding Source", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FACILITYNAME", "type" : "esriFieldTypeString", "alias" : "Facility Name", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FACILITYADDRESS", "type" : "esriFieldTypeString", "alias" : "Facility Address", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LIFECYCLESTATUS", "type" : "esriFieldTypeString", "alias" : "Lifecycle Status", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wLifecycle Status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Features Being Used and Maintained", "code" : "E" }, { "name" : "Proposed", "code" : "P" }, { "name" : "Abandoned", "code" : "A" }, { "name" : "Rehabilitation", "code" : "R" }, { "name" : "Unknown", "code" : "U" } ] }, "defaultValue" : "E" }, { "name" : "SYMBOLROTATION", "type" : "esriFieldTypeDouble", "alias" : "Symbol Rotation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 0 }, { "name" : "WATERTRACEWEIGHT", "type" : "esriFieldTypeInteger", "alias" : "Water Trace Weight", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BARRELDIAMETER", "type" : "esriFieldTypeDouble", "alias" : "Barrel Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wHydrantBarrelDiam", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Barrel Diameter for Fire Hydrants", "codedValues" : [ { "name" : "4\"", "code" : 4 } ] }, "defaultValue" : 4 }, { "name" : "NOZZLEDIAMETER1", "type" : "esriFieldTypeDouble", "alias" : "Nozzle Diameter 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wHydrantNozDiam", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Nozzle Diameters for Fire Hydrants", "codedValues" : [ { "name" : "2.5\"", "code" : 2.5 }, { "name" : "4\"", "code" : 4 } ] }, "defaultValue" : 4 }, { "name" : "NOZZLEDIAMETER2", "type" : "esriFieldTypeDouble", "alias" : "Nozzle DIameter 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wHydrantNozDiam", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Nozzle Diameters for Fire Hydrants", "codedValues" : [ { "name" : "2.5\"", "code" : 2.5 }, { "name" : "4\"", "code" : 4 } ] }, "defaultValue" : 2.5 }, { "name" : "NOZZLEDIAMETER3", "type" : "esriFieldTypeDouble", "alias" : "Nozzle Diameter 3", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wHydrantNozDiam", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Nozzle Diameters for Fire Hydrants", "codedValues" : [ { "name" : "2.5\"", "code" : 2.5 }, { "name" : "4\"", "code" : 4 } ] }, "defaultValue" : 2.5 }, { "name" : "MANUFACTURER", "type" : "esriFieldTypeString", "alias" : "Manufacturer", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wHydrantManufac_4", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "List of Fire Hydrant Manufacturers", "codedValues" : [ { "name" : "AVK", "code" : "AVK" }, { "name" : "Clow", "code" : "CLO" }, { "name" : "Darling", "code" : "DAR" }, { "name" : "EJIW", "code" : "EJI" }, { "name" : "Kennedy K-10", "code" : "KEN" }, { "name" : "MH", "code" : "MH" }, { "name" : "Mueller", "code" : "MUE" }, { "name" : "USP", "code" : "USP" }, { "name" : "Water Master", "code" : "WAM" }, { "name" : "American Flow Control", "code" : "AFC" } ] }, "defaultValue" : null }, { "name" : "SUBTYPECD", "type" : "esriFieldTypeInteger", "alias" : "Subtype", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 8 }, { "name" : "HFD_DELIVERY", "type" : "esriFieldTypeDate", "alias" : "HFD Delivery", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "HYDRANT_INSPECTED_DATE", "type" : "esriFieldTypeDate", "alias" : "Inspected Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "SUBDIVISION_NAME", "type" : "esriFieldTypeString", "alias" : "Subdivision Name", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LAND_BASE_REVIEWED", "type" : "esriFieldTypeString", "alias" : "Land Base Reviewed", "sqlType" : "sqlTypeOther", "length" : 25, "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" : "NORTHING", "type" : "esriFieldTypeDouble", "alias" : "Northing", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PERMITDATE", "type" : "esriFieldTypeDate", "alias" : "Permit 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" : "PRIVATEFUND", "type" : "esriFieldTypeString", "alias" : "Private Fund", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ILMSNUMBER", "type" : "esriFieldTypeString", "alias" : "ILMS Number", "sqlType" : "sqlTypeOther", "length" : 30, "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" : "wFiscalYear", "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" : "IMSNO", "type" : "esriFieldTypeInteger", "alias" : "IMS Number", "sqlType" : "sqlTypeOther", "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" : "NOZZLECOLOR", "type" : "esriFieldTypeString", "alias" : "Nozzle Color", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wHydrantNozColor", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Fire Hydrant Nozzle Color", "codedValues" : [ { "name" : "302", "code" : "302" } ] }, "defaultValue" : null }, { "name" : "BONNETCOLOR", "type" : "esriFieldTypeString", "alias" : "Bonnet Color", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wHydrantBonColor_2", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Fire Hydrant Bonnet Color", "codedValues" : [ { "name" : "303", "code" : "303" }, { "name" : "304", "code" : "304" }, { "name" : "306", "code" : "306" }, { "name" : "307", "code" : "307" }, { "name" : "305", "code" : "305" } ] }, "defaultValue" : null }, { "name" : "INSPECTIONDATE", "type" : "esriFieldTypeDate", "alias" : "Inspection Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LINESIZE", "type" : "esriFieldTypeDouble", "alias" : "Line Size", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDistribution Main Diameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "0.75\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1.5\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2.5\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "5\"", "code" : 5 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "Unknown", "code" : -1 }, { "name" : "Other", "code" : 0 }, { "name" : "30\"", "code" : 30 }, { "name" : "32\"", "code" : 32 }, { "name" : "36\"", "code" : 36 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "84\"", "code" : 84 }, { "name" : "90\"", "code" : 90 }, { "name" : "96\"", "code" : 96 }, { "name" : "142\"", "code" : 142 }, { "name" : "0.5\"", "code" : 0.5 }, { "name" : "1.25\"", "code" : 1.25 }, { "name" : "21\"", "code" : 21 }, { "name" : "34\"", "code" : 34 }, { "name" : "46\"", "code" : 46 }, { "name" : "102\"", "code" : 102 }, { "name" : "108\"", "code" : 108 }, { "name" : "120\"", "code" : 120 }, { "name" : "64\"", "code" : 64 } ] }, "defaultValue" : null }, { "name" : "CASTYEAR", "type" : "esriFieldTypeString", "alias" : "Cast Year", "sqlType" : "sqlTypeOther", "length" : 5, "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", "description" : "City Council Districts", "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" : "PLANNUMBER", "type" : "esriFieldTypeString", "alias" : "Plan Number", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PROJECTNUMBER", "type" : "esriFieldTypeString", "alias" : "Project Number", "sqlType" : "sqlTypeOther", "length" : 24, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OWNER", "type" : "esriFieldTypeString", "alias" : "Owner", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wOwner", "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" : "C" }, { "name" : "HYDRANTLEADDIAMETER", "type" : "esriFieldTypeDouble", "alias" : "Hydrant Lead Size", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wMainDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Diameter Selection for all water main related objects", "codedValues" : [ { "name" : "Unknown", "code" : -1 }, { "name" : "Other", "code" : 0 }, { "name" : "0.5\"", "code" : 0.5 }, { "name" : "0.75\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1.25\"", "code" : 1.25 }, { "name" : "1.5\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2.5\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "5\"", "code" : 5 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "17\"", "code" : 17 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "21\"", "code" : 21 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "32\"", "code" : 32 }, { "name" : "34\"", "code" : 34 }, { "name" : "36\"", "code" : 36 }, { "name" : "38\"", "code" : 38 }, { "name" : "42\"", "code" : 42 }, { "name" : "46\"", "code" : 46 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "64\"", "code" : 64 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "84\"", "code" : 84 }, { "name" : "90\"", "code" : 90 }, { "name" : "96\"", "code" : 96 }, { "name" : "102\"", "code" : 102 }, { "name" : "108\"", "code" : 108 }, { "name" : "120\"", "code" : 120 }, { "name" : "142\"", "code" : 142 } ] }, "defaultValue" : 6 }, { "name" : "IPSSUBTYPE", "type" : "esriFieldTypeString", "alias" : "IPS Subtype Code", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "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", "description" : "Utility Maintenance 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" } ] }, "defaultValue" : null }, { "name" : "ADDRESS", "type" : "esriFieldTypeString", "alias" : "ADDRESS", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MAINDIAMETER", "type" : "esriFieldTypeString", "alias" : "Main Size", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Water Main Diameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "1\"", "code" : "1" }, { "name" : "1.5\"", "code" : "1.5" }, { "name" : "2\"", "code" : "2" }, { "name" : "2.5\"", "code" : "2.5" }, { "name" : "3\"", "code" : "3" }, { "name" : "4\"", "code" : "4" }, { "name" : "5\"", "code" : "5" }, { "name" : "6\"", "code" : "6" }, { "name" : "8\"", "code" : "8" }, { "name" : "10\"", "code" : "10" }, { "name" : "12\"", "code" : "12" }, { "name" : "14\"", "code" : "14" }, { "name" : "16\"", "code" : "16" }, { "name" : "18\"", "code" : "18" }, { "name" : "20\"", "code" : "20" }, { "name" : "24\"", "code" : "24" }, { "name" : "30\"", "code" : "30" }, { "name" : "36\"", "code" : "36" }, { "name" : "38\"", "code" : "38" }, { "name" : "0.75\"", "code" : ".75" }, { "name" : "0.50\"", "code" : ".5" }, { "name" : "NULL", "code" : "NULL" }, { "name" : "1.25\"", "code" : "1.25" }, { "name" : "21\"", "code" : "21" }, { "name" : "32\"", "code" : "32" }, { "name" : "34\"", "code" : "34" }, { "name" : "42\"", "code" : "42" }, { "name" : "46\"", "code" : "46" }, { "name" : "54\"", "code" : "54" }, { "name" : "60\"", "code" : "60" }, { "name" : "66\"", "code" : "66" }, { "name" : "72\"", "code" : "72" }, { "name" : "84\"", "code" : "84" }, { "name" : "90\"", "code" : "90" }, { "name" : "96\"", "code" : "96" }, { "name" : "102\"", "code" : "102" }, { "name" : "108\"", "code" : "108" }, { "name" : "120\"", "code" : "120" }, { "name" : "142\"", "code" : "142" }, { "name" : "Other", "code" : "0" }, { "name" : "UNKNOWN", "code" : "-1" }, { "name" : "48\"", "code" : "48" }, { "name" : "17\"", "code" : "17" } ] }, "defaultValue" : null }, { "name" : "FACILITYID", "type" : "esriFieldTypeString", "alias" : "Facility ID", "sqlType" : "sqlTypeOther", "length" : 11, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MOTIONNUMBER", "type" : "esriFieldTypeString", "alias" : "Motion 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" : "WCRNUMBER", "type" : "esriFieldTypeString", "alias" : "WCR Number", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HYDRANTNUMBER", "type" : "esriFieldTypeString", "alias" : "Hydrant Number", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COSTPERACRE", "type" : "esriFieldTypeString", "alias" : "Cost Per Acre", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DATASOURCETYPE", "type" : "esriFieldTypeString", "alias" : "Data Source Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wData Source Type", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Block Map", "code" : "BM" }, { "name" : "Plan and Profile", "code" : "P" }, { "name" : "As Built", "code" : "AB" }, { "name" : "Other source", "code" : "O" }, { "name" : "Unknown", "code" : "U" }, { "name" : "Field Verified with Control Number", "code" : "FV" }, { "name" : "Taps and Meters", "code" : "TM" }, { "name" : "Metro", "code" : "MT" }, { "name" : "Field Verify Fire Department", "code" : "FVFD" }, { "name" : "Field Verify Fire Line", "code" : "FVFL" }, { "name" : "Construction Layer", "code" : "CL" }, { "name" : "Fire Department", "code" : "FD" }, { "name" : "Capital Improvement Project", "code" : "CIP" } ] }, "defaultValue" : null }, { "name" : "PLANTYPE", "type" : "esriFieldTypeString", "alias" : "Plan Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wPlan Type", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Plan and Profile", "code" : "P" }, { "name" : "Texas Highway Department", "code" : "THD" }, { "name" : "Water Drawing", "code" : "WD" }, { "name" : "Well Collection Drawing", "code" : "WCL" }, { "name" : "Water Production Drawing", "code" : "WP" }, { "name" : "Rehabilitation", "code" : "R" }, { "name" : "Unknown", "code" : "UN" }, { "name" : "Control Section Job", "code" : "CSJ" } ] }, "defaultValue" : null }, { "name" : "PROJECTTYPE", "type" : "esriFieldTypeString", "alias" : "Project Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wProject Type", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Budgeted Job", "code" : "BG" }, { "name" : "Private Construction", "code" : "C" }, { "name" : "City Job", "code" : "JOB" }, { "name" : "Water Project", "code" : "PJ" }, { "name" : "Government Financial System", "code" : "GFS" }, { "name" : "Street and Bridge", "code" : "SB" }, { "name" : "Water", "code" : "WA" }, { "name" : "Permit Number", "code" : "PN" }, { "name" : "Work Business Structure", "code" : "WBS" }, { "name" : "Unknown", "code" : "UNKNOWN" }, { "name" : "Storm", "code" : "SM" }, { "name" : "Wastewater", "code" : "WW" }, { "name" : "Control Section Job", "code" : "CSJ" } ] }, "defaultValue" : null }, { "name" : "ADDRESS_ID", "type" : "esriFieldTypeDouble", "alias" : "ADDRESS_ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GFSORWBS", "type" : "esriFieldTypeString", "alias" : "GFS or WBS", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wProject 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" : "GFS-WBS Number", "sqlType" : "sqlTypeOther", "length" : 24, "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" : "COMPTYPE", "type" : "esriFieldTypeSmallInteger", "alias" : "COMPTYPE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 12 }, { "name" : "SPATIALADJUSTNOTE", "type" : "esriFieldTypeString", "alias" : "Sptatial Adjustment Notes", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SERVICEADDRESS", "type" : "esriFieldTypeString", "alias" : "Service Address", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LONGITUDE", "type" : "esriFieldTypeDouble", "alias" : "Longitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LATITUDE", "type" : "esriFieldTypeDouble", "alias" : "Latitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "REPLACEMENTPROJTYPE", "type" : "esriFieldTypeString", "alias" : "Replacement Project Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wProject Type", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Budgeted Job", "code" : "BG" }, { "name" : "Private Construction", "code" : "C" }, { "name" : "City Job", "code" : "JOB" }, { "name" : "Water Project", "code" : "PJ" }, { "name" : "Government Financial System", "code" : "GFS" }, { "name" : "Street and Bridge", "code" : "SB" }, { "name" : "Water", "code" : "WA" }, { "name" : "Permit Number", "code" : "PN" }, { "name" : "Work Business Structure", "code" : "WBS" }, { "name" : "Unknown", "code" : "UNKNOWN" }, { "name" : "Storm", "code" : "SM" }, { "name" : "Wastewater", "code" : "WW" }, { "name" : "Control Section Job", "code" : "CSJ" } ] }, "defaultValue" : null }, { "name" : "WORKORDERNUMBER", "type" : "esriFieldTypeString", "alias" : "Work Order Number", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "REPLACEMENTPROJNUM", "type" : "esriFieldTypeString", "alias" : "Replacement Project Number", "sqlType" : "sqlTypeOther", "length" : 24, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "REPLACEMENTDATE", "type" : "esriFieldTypeDate", "alias" : "Replacement Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "QCDATE", "type" : "esriFieldTypeDate", "alias" : "QC Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "PSCNUMBER", "type" : "esriFieldTypeString", "alias" : "PSC Number", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEMELEV2008", "type" : "esriFieldTypeDouble", "alias" : "DEM Elevation 2008", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEMELEV2018", "type" : "esriFieldTypeDouble", "alias" : "DEM Elevation 2018", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "IPSEXPIREDATE", "type" : "esriFieldTypeDate", "alias" : "IPS Expire Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "IPSEXPIREDBY", "type" : "esriFieldTypeString", "alias" : "IPS Expired By", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ADDRKEY", "type" : "esriFieldTypeInteger", "alias" : "ADDRKEY", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__WHYDRANT__F4B70D85EC07C090", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_279.WHYDRANT_WHYDRANT_Shape_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : 8, "name" : "Fire Hydrant", "domains" : { "ANCILLARYROLE" : {"type" : "inherited"}, "ENABLED" : {"type" : "inherited"}, "QCVERIFIED" : {"type" : "inherited"}, "CREATIONSOURCE" : {"type" : "inherited"}, "LIFECYCLESTATUS" : {"type" : "inherited"}, "BARRELDIAMETER" : {"type" : "inherited"}, "NOZZLEDIAMETER1" : {"type" : "inherited"}, "NOZZLEDIAMETER2" : {"type" : "inherited"}, "NOZZLEDIAMETER3" : {"type" : "inherited"}, "MANUFACTURER" : {"type" : "inherited"}, "LAND_BASE_REVIEWED" : {"type" : "inherited"}, "FISCAL_YEAR" : {"type" : "inherited"}, "NOZZLECOLOR" : {"type" : "inherited"}, "BONNETCOLOR" : {"type" : "inherited"}, "LINESIZE" : {"type" : "inherited"}, "COUNCILDISTRICT" : {"type" : "inherited"}, "OWNER" : {"type" : "inherited"}, "HYDRANTLEADDIAMETER" : {"type" : "inherited"}, "ZONE" : {"type" : "inherited"}, "MAINDIAMETER" : {"type" : "inherited"}, "DATASOURCETYPE" : {"type" : "inherited"}, "PLANTYPE" : {"type" : "inherited"}, "PROJECTTYPE" : {"type" : "inherited"}, "GFSORWBS" : {"type" : "inherited"}, "REPLACEMENTPROJTYPE" : {"type" : "inherited"} }, "templates" : [ { "name" : "Fire Hydrant", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "IPSEXPIREDBY" : null, "ADDRKEY" : null, "ANCILLARYROLE" : 0, "ENABLED" : 1, "CREATIONUSER" : null, "DATECREATED" : null, "DATEMODIFIED" : null, "LASTUSER" : null, "CONDITION" : null, "CONDITIONDATE" : null, "UFID" : null, "NOTES" : null, "QCVERIFIED" : null, "PLANDATE" : null, "DATASOURCEREFNUM" : null, "INSERVICEDATE" : null, "CREATIONSOURCE" : null, "SOURCEOFFUND" : null, "FACILITYNAME" : null, "FACILITYADDRESS" : null, "LIFECYCLESTATUS" : "E", "SYMBOLROTATION" : 0, "WATERTRACEWEIGHT" : null, "BARRELDIAMETER" : 4, "NOZZLEDIAMETER1" : 4, "NOZZLEDIAMETER2" : 2.5, "NOZZLEDIAMETER3" : 2.5, "MANUFACTURER" : null, "SUBTYPECD" : 8, "HFD_DELIVERY" : null, "HYDRANT_INSPECTED_DATE" : null, "SUBDIVISION_NAME" : null, "LAND_BASE_REVIEWED" : null, "NORTHING" : null, "PERMITDATE" : null, "MOTIONDATE" : null, "PRIVATEFUND" : null, "ILMSNUMBER" : null, "FISCAL_YEAR" : null, "IMSNO" : null, "COMPKEY" : null, "NOZZLECOLOR" : null, "BONNETCOLOR" : null, "INSPECTIONDATE" : null, "LINESIZE" : null, "CASTYEAR" : null, "KEYMAP" : null, "COUNCILDISTRICT" : null, "PLANNUMBER" : null, "PROJECTNUMBER" : null, "OWNER" : "C", "HYDRANTLEADDIAMETER" : 6, "IPSSUBTYPE" : null, "ZONE" : null, "ADDRESS" : null, "MAINDIAMETER" : null, "FACILITYID" : null, "MOTIONNUMBER" : null, "PERMITNUMBER" : null, "WCRNUMBER" : null, "HYDRANTNUMBER" : "HFD??", "COSTPERACRE" : null, "DATASOURCETYPE" : null, "PLANTYPE" : null, "PROJECTTYPE" : null, "ADDRESS_ID" : null, "GFSORWBS" : null, "GFSWBSNUMBER" : null, "UNITID" : null, "COMPTYPE" : 12, "SPATIALADJUSTNOTE" : null, "SERVICEADDRESS" : null, "LONGITUDE" : null, "LATITUDE" : null, "REPLACEMENTPROJTYPE" : null, "WORKORDERNUMBER" : null, "REPLACEMENTPROJNUM" : null, "REPLACEMENTDATE" : null, "QCDATE" : null, "PSCNUMBER" : null, "DEMELEV2008" : null, "DEMELEV2018" : null, "IPSEXPIREDATE" : null } } } ] } ], "templates" : [], "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" : 2000, "standardMaxRecordCount" : 16000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query", "subtypeField" : "SubtypeCD", "defaultSubtypeCode" : 8, "subtypes" : [ { "code" : 8, "name" : "Fire Hydrant", "defaultValues" : { "ANCILLARYROLE" : 0, "ENABLED" : 1, "CREATIONUSER" : null, "DATECREATED" : null, "DATEMODIFIED" : null, "LASTUSER" : null, "CONDITION" : null, "CONDITIONDATE" : null, "UFID" : null, "NOTES" : null, "QCVERIFIED" : null, "PLANDATE" : null, "DATASOURCEREFNUM" : null, "INSERVICEDATE" : null, "CREATIONSOURCE" : null, "SOURCEOFFUND" : null, "FACILITYNAME" : null, "FACILITYADDRESS" : null, "LIFECYCLESTATUS" : "E", "SYMBOLROTATION" : 0, "WATERTRACEWEIGHT" : null, "BARRELDIAMETER" : 4, "NOZZLEDIAMETER1" : 4, "NOZZLEDIAMETER2" : 2.5, "NOZZLEDIAMETER3" : 2.5, "MANUFACTURER" : null, "SUBTYPECD" : 8, "HFD_DELIVERY" : null, "HYDRANT_INSPECTED_DATE" : null, "SUBDIVISION_NAME" : null, "LAND_BASE_REVIEWED" : null, "NORTHING" : null, "PERMITDATE" : null, "MOTIONDATE" : null, "PRIVATEFUND" : null, "ILMSNUMBER" : null, "FISCAL_YEAR" : null, "IMSNO" : null, "COMPKEY" : null, "NOZZLECOLOR" : null, "BONNETCOLOR" : null, "INSPECTIONDATE" : null, "LINESIZE" : null, "CASTYEAR" : null, "KEYMAP" : null, "COUNCILDISTRICT" : null, "PLANNUMBER" : null, "PROJECTNUMBER" : null, "OWNER" : "C", "HYDRANTLEADDIAMETER" : 6, "IPSSUBTYPE" : null, "ZONE" : null, "ADDRESS" : null, "MAINDIAMETER" : null, "FACILITYID" : null, "MOTIONNUMBER" : null, "PERMITNUMBER" : null, "WCRNUMBER" : null, "HYDRANTNUMBER" : "HFD??", "COSTPERACRE" : null, "DATASOURCETYPE" : null, "PLANTYPE" : null, "PROJECTTYPE" : null, "ADDRESS_ID" : null, "GFSORWBS" : null, "GFSWBSNUMBER" : null, "UNITID" : null, "COMPTYPE" : 12, "SPATIALADJUSTNOTE" : null, "SERVICEADDRESS" : null, "LONGITUDE" : null, "LATITUDE" : null, "REPLACEMENTPROJTYPE" : null, "WORKORDERNUMBER" : null, "REPLACEMENTPROJNUM" : null, "REPLACEMENTDATE" : null, "QCDATE" : null, "PSCNUMBER" : null, "DEMELEV2008" : null, "DEMELEV2018" : null, "IPSEXPIREDATE" : null, "IPSEXPIREDBY" : null, "ADDRKEY" : null }, "domains" : { "ANCILLARYROLE" : { "type" : "codedValue", "name" : "AncillaryRoleDomain", "codedValues" : [ { "name" : "None", "code" : 0 }, { "name" : "Source", "code" : 1 }, { "name" : "Sink", "code" : 2 } ] }, "ENABLED" : { "type" : "codedValue", "name" : "EnabledDomain_8", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "QCVERIFIED" : { "type" : "codedValue", "name" : "wYes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CREATIONSOURCE" : { "type" : "codedValue", "name" : "wCreation 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 WATER", "code" : "FVW" } ] }, "LIFECYCLESTATUS" : { "type" : "codedValue", "name" : "wLifecycle Status", "codedValues" : [ { "name" : "Features Being Used and Maintained", "code" : "E" }, { "name" : "Proposed", "code" : "P" }, { "name" : "Abandoned", "code" : "A" }, { "name" : "Rehabilitation", "code" : "R" }, { "name" : "Unknown", "code" : "U" } ] }, "BARRELDIAMETER" : { "type" : "codedValue", "name" : "wHydrantBarrelDiam", "description" : "Barrel Diameter for Fire Hydrants", "codedValues" : [ { "name" : "4\"", "code" : 4 } ] }, "NOZZLEDIAMETER1" : { "type" : "codedValue", "name" : "wHydrantNozDiam", "description" : "Nozzle Diameters for Fire Hydrants", "codedValues" : [ { "name" : "2.5\"", "code" : 2.5 }, { "name" : "4\"", "code" : 4 } ] }, "NOZZLEDIAMETER2" : { "type" : "codedValue", "name" : "wHydrantNozDiam", "description" : "Nozzle Diameters for Fire Hydrants", "codedValues" : [ { "name" : "2.5\"", "code" : 2.5 }, { "name" : "4\"", "code" : 4 } ] }, "NOZZLEDIAMETER3" : { "type" : "codedValue", "name" : "wHydrantNozDiam", "description" : "Nozzle Diameters for Fire Hydrants", "codedValues" : [ { "name" : "2.5\"", "code" : 2.5 }, { "name" : "4\"", "code" : 4 } ] }, "MANUFACTURER" : { "type" : "codedValue", "name" : "wHydrantManufac_4", "description" : "List of Fire Hydrant Manufacturers", "codedValues" : [ { "name" : "AVK", "code" : "AVK" }, { "name" : "Clow", "code" : "CLO" }, { "name" : "Darling", "code" : "DAR" }, { "name" : "EJIW", "code" : "EJI" }, { "name" : "Kennedy K-10", "code" : "KEN" }, { "name" : "MH", "code" : "MH" }, { "name" : "Mueller", "code" : "MUE" }, { "name" : "USP", "code" : "USP" }, { "name" : "Water Master", "code" : "WAM" }, { "name" : "American Flow Control", "code" : "AFC" } ] }, "LAND_BASE_REVIEWED" : { "type" : "codedValue", "name" : "Yes No Reviewed", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "FISCAL_YEAR" : { "type" : "codedValue", "name" : "wFiscalYear", "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" } ] }, "NOZZLECOLOR" : { "type" : "codedValue", "name" : "wHydrantNozColor", "description" : "Fire Hydrant Nozzle Color", "codedValues" : [ { "name" : "302", "code" : "302" } ] }, "BONNETCOLOR" : { "type" : "codedValue", "name" : "wHydrantBonColor_2", "description" : "Fire Hydrant Bonnet Color", "codedValues" : [ { "name" : "303", "code" : "303" }, { "name" : "304", "code" : "304" }, { "name" : "306", "code" : "306" }, { "name" : "307", "code" : "307" }, { "name" : "305", "code" : "305" } ] }, "LINESIZE" : { "type" : "codedValue", "name" : "wDistribution Main Diameter", "codedValues" : [ { "name" : "0.75\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1.5\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2.5\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "5\"", "code" : 5 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "Unknown", "code" : -1 }, { "name" : "Other", "code" : 0 }, { "name" : "30\"", "code" : 30 }, { "name" : "32\"", "code" : 32 }, { "name" : "36\"", "code" : 36 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "84\"", "code" : 84 }, { "name" : "90\"", "code" : 90 }, { "name" : "96\"", "code" : 96 }, { "name" : "142\"", "code" : 142 }, { "name" : "0.5\"", "code" : 0.5 }, { "name" : "1.25\"", "code" : 1.25 }, { "name" : "21\"", "code" : 21 }, { "name" : "34\"", "code" : 34 }, { "name" : "46\"", "code" : 46 }, { "name" : "102\"", "code" : 102 }, { "name" : "108\"", "code" : 108 }, { "name" : "120\"", "code" : 120 }, { "name" : "64\"", "code" : 64 } ] }, "COUNCILDISTRICT" : { "type" : "codedValue", "name" : "COH Council District", "description" : "City Council Districts", "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" } ] }, "OWNER" : { "type" : "codedValue", "name" : "wOwner", "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" } ] }, "HYDRANTLEADDIAMETER" : { "type" : "codedValue", "name" : "wMainDiameter", "description" : "Diameter Selection for all water main related objects", "codedValues" : [ { "name" : "Unknown", "code" : -1 }, { "name" : "Other", "code" : 0 }, { "name" : "0.5\"", "code" : 0.5 }, { "name" : "0.75\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1.25\"", "code" : 1.25 }, { "name" : "1.5\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2.5\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "5\"", "code" : 5 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "17\"", "code" : 17 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "21\"", "code" : 21 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "32\"", "code" : 32 }, { "name" : "34\"", "code" : 34 }, { "name" : "36\"", "code" : 36 }, { "name" : "38\"", "code" : 38 }, { "name" : "42\"", "code" : 42 }, { "name" : "46\"", "code" : 46 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "64\"", "code" : 64 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "84\"", "code" : 84 }, { "name" : "90\"", "code" : 90 }, { "name" : "96\"", "code" : 96 }, { "name" : "102\"", "code" : 102 }, { "name" : "108\"", "code" : 108 }, { "name" : "120\"", "code" : 120 }, { "name" : "142\"", "code" : 142 } ] }, "ZONE" : { "type" : "codedValue", "name" : "UM Zones", "description" : "Utility Maintenance 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" } ] }, "MAINDIAMETER" : { "type" : "codedValue", "name" : "Water Main Diameter", "codedValues" : [ { "name" : "1\"", "code" : "1" }, { "name" : "1.5\"", "code" : "1.5" }, { "name" : "2\"", "code" : "2" }, { "name" : "2.5\"", "code" : "2.5" }, { "name" : "3\"", "code" : "3" }, { "name" : "4\"", "code" : "4" }, { "name" : "5\"", "code" : "5" }, { "name" : "6\"", "code" : "6" }, { "name" : "8\"", "code" : "8" }, { "name" : "10\"", "code" : "10" }, { "name" : "12\"", "code" : "12" }, { "name" : "14\"", "code" : "14" }, { "name" : "16\"", "code" : "16" }, { "name" : "18\"", "code" : "18" }, { "name" : "20\"", "code" : "20" }, { "name" : "24\"", "code" : "24" }, { "name" : "30\"", "code" : "30" }, { "name" : "36\"", "code" : "36" }, { "name" : "38\"", "code" : "38" }, { "name" : "0.75\"", "code" : ".75" }, { "name" : "0.50\"", "code" : ".5" }, { "name" : "NULL", "code" : "NULL" }, { "name" : "1.25\"", "code" : "1.25" }, { "name" : "21\"", "code" : "21" }, { "name" : "32\"", "code" : "32" }, { "name" : "34\"", "code" : "34" }, { "name" : "42\"", "code" : "42" }, { "name" : "46\"", "code" : "46" }, { "name" : "54\"", "code" : "54" }, { "name" : "60\"", "code" : "60" }, { "name" : "66\"", "code" : "66" }, { "name" : "72\"", "code" : "72" }, { "name" : "84\"", "code" : "84" }, { "name" : "90\"", "code" : "90" }, { "name" : "96\"", "code" : "96" }, { "name" : "102\"", "code" : "102" }, { "name" : "108\"", "code" : "108" }, { "name" : "120\"", "code" : "120" }, { "name" : "142\"", "code" : "142" }, { "name" : "Other", "code" : "0" }, { "name" : "UNKNOWN", "code" : "-1" }, { "name" : "48\"", "code" : "48" }, { "name" : "17\"", "code" : "17" } ] }, "DATASOURCETYPE" : { "type" : "codedValue", "name" : "wData Source Type", "codedValues" : [ { "name" : "Block Map", "code" : "BM" }, { "name" : "Plan and Profile", "code" : "P" }, { "name" : "As Built", "code" : "AB" }, { "name" : "Other source", "code" : "O" }, { "name" : "Unknown", "code" : "U" }, { "name" : "Field Verified with Control Number", "code" : "FV" }, { "name" : "Taps and Meters", "code" : "TM" }, { "name" : "Metro", "code" : "MT" }, { "name" : "Field Verify Fire Department", "code" : "FVFD" }, { "name" : "Field Verify Fire Line", "code" : "FVFL" }, { "name" : "Construction Layer", "code" : "CL" }, { "name" : "Fire Department", "code" : "FD" }, { "name" : "Capital Improvement Project", "code" : "CIP" } ] }, "PLANTYPE" : { "type" : "codedValue", "name" : "wPlan Type", "codedValues" : [ { "name" : "Plan and Profile", "code" : "P" }, { "name" : "Texas Highway Department", "code" : "THD" }, { "name" : "Water Drawing", "code" : "WD" }, { "name" : "Well Collection Drawing", "code" : "WCL" }, { "name" : "Water Production Drawing", "code" : "WP" }, { "name" : "Rehabilitation", "code" : "R" }, { "name" : "Unknown", "code" : "UN" }, { "name" : "Control Section Job", "code" : "CSJ" } ] }, "PROJECTTYPE" : { "type" : "codedValue", "name" : "wProject Type", "codedValues" : [ { "name" : "Budgeted Job", "code" : "BG" }, { "name" : "Private Construction", "code" : "C" }, { "name" : "City Job", "code" : "JOB" }, { "name" : "Water Project", "code" : "PJ" }, { "name" : "Government Financial System", "code" : "GFS" }, { "name" : "Street and Bridge", "code" : "SB" }, { "name" : "Water", "code" : "WA" }, { "name" : "Permit Number", "code" : "PN" }, { "name" : "Work Business Structure", "code" : "WBS" }, { "name" : "Unknown", "code" : "UNKNOWN" }, { "name" : "Storm", "code" : "SM" }, { "name" : "Wastewater", "code" : "WW" }, { "name" : "Control Section Job", "code" : "CSJ" } ] }, "GFSORWBS" : { "type" : "codedValue", "name" : "wProject Type2", "codedValues" : [ { "name" : "Government Financial System", "code" : "GFS" }, { "name" : "Work Business Structure", "code" : "WBS" } ] }, "REPLACEMENTPROJTYPE" : { "type" : "codedValue", "name" : "wProject Type", "codedValues" : [ { "name" : "Budgeted Job", "code" : "BG" }, { "name" : "Private Construction", "code" : "C" }, { "name" : "City Job", "code" : "JOB" }, { "name" : "Water Project", "code" : "PJ" }, { "name" : "Government Financial System", "code" : "GFS" }, { "name" : "Street and Bridge", "code" : "SB" }, { "name" : "Water", "code" : "WA" }, { "name" : "Permit Number", "code" : "PN" }, { "name" : "Work Business Structure", "code" : "WBS" }, { "name" : "Unknown", "code" : "UNKNOWN" }, { "name" : "Storm", "code" : "SM" }, { "name" : "Wastewater", "code" : "WW" }, { "name" : "Control Section Job", "code" : "CSJ" } ] } } } ] } ], "tables" : [] }