{ "currentVersion" : 12, "id" : 2, "name" : "Culvert", "type" : "Feature Layer", "serviceItemId" : "4034c097be8d4e28bee3f1d52c472c89", "cacheMaxAge" : 30, "displayField" : "SYSNO", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1696013038615, "schemaLastEditDate" : 1696012962950, "dataLastEditDate" : 1696013038615 }, "relationships" : [ { "id" : 5, "name" : "View Activities", "relatedTableId" : 9, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "OUTETNO", "composite" : false }, { "id" : 2, "name" : "View Overall Culvert System", "relatedTableId" : 0, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "SYSNO", "composite" : false } ], "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, "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" : 5000, "maxScale" : 0, "extent" : { "xmin" : -13832807.541665802, "ymin" : -111325.49419264506, "xmax" : -111317.2344043652, "ymax" : 5161455.6298551252, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"fa1409d2539af9ef6889547709470334","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAgAAAAICAYAAADED76LAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAATklEQVQYlWPxsJQO/fqTwZcBC/j/9/8sFpDkpDSmWAFuVMmHrxkYapf8Y2ABcUCScqKM6PrBJFgBPkAlBSAHwexEdiRYAcgrINdiAyA5AG+lHagCn+DkAAAAAElFTkSuQmCC","contentType":"image/png","width":6,"height":6,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : true, "enableZDefaults" : true, "zDefault" : 0, "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" : "SYSNO", "type" : "esriFieldTypeString", "alias" : "System Number", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INETNO", "type" : "esriFieldTypeString", "alias" : "Inlet End Treatment Number", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OUTETNO", "type" : "esriFieldTypeString", "alias" : "Outlet End Treatment Number", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "District", "type" : "esriFieldTypeString", "alias" : "District", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "District", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "District 1", "code" : "01" }, { "name" : "District 2", "code" : "02" }, { "name" : "District 3", "code" : "03" }, { "name" : "District 4", "code" : "04" }, { "name" : "District 5", "code" : "05" }, { "name" : "District 6", "code" : "06" }, { "name" : "District 7", "code" : "07" }, { "name" : "District 8", "code" : "08" }, { "name" : "District 9", "code" : "09" }, { "name" : "District 10", "code" : "10" }, { "name" : "District 11", "code" : "11" }, { "name" : "District 12", "code" : "12" }, { "name" : "HQ", "code" : "13" } ] }, "defaultValue" : null }, { "name" : "County", "type" : "esriFieldTypeString", "alias" : "County", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "County", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Del Norte (DN)", "code" : "01" }, { "name" : "Siskiyou (SIS)", "code" : "02" }, { "name" : "Modoc (MOD)", "code" : "03" }, { "name" : "Humboldt (HUM)", "code" : "04" }, { "name" : "Trinity (TRI)", "code" : "05" }, { "name" : "Shasta (SHA)", "code" : "06" }, { "name" : "Lassen (LAS)", "code" : "07" }, { "name" : "Tehama (TEH)", "code" : "08" }, { "name" : "Plumas (PLU)", "code" : "09" }, { "name" : "Mendocino (MEN)", "code" : "10" }, { "name" : "Glenn (GLE)", "code" : "11" }, { "name" : "Butte (BUT)", "code" : "12" }, { "name" : "Sierra (SIE)", "code" : "13" }, { "name" : "Lake (LAK)", "code" : "14" }, { "name" : "Colusa (COL)", "code" : "15" }, { "name" : "Yuba (YUB)", "code" : "16" }, { "name" : "Nevada (NEV)", "code" : "17" }, { "name" : "Sutter (SUT)", "code" : "18" }, { "name" : "Placer (PLA)", "code" : "19" }, { "name" : "Sonoma (SON)", "code" : "20" }, { "name" : "Napa (NAP)", "code" : "21" }, { "name" : "Yolo (YOL)", "code" : "22" }, { "name" : "Solano (SOL)", "code" : "23" }, { "name" : "Sacramento (SAC)", "code" : "24" }, { "name" : "El Dorado (ED)", "code" : "25" }, { "name" : "Amador (AMA)", "code" : "26" }, { "name" : "Marin (MRN)", "code" : "27" }, { "name" : "Contra Costa (CC)", "code" : "28" }, { "name" : "San Joaquin (SJ)", "code" : "29" }, { "name" : "Calaveras (CAL)", "code" : "30" }, { "name" : "Alpine (ALP)", "code" : "31" }, { "name" : "Tuolumne (TUO)", "code" : "32" }, { "name" : "Alameda (ALA)", "code" : "33" }, { "name" : "San Francisco (SF)", "code" : "34" }, { "name" : "San Mateo (SM)", "code" : "35" }, { "name" : "Santa Cruz (SCR)", "code" : "36" }, { "name" : "Santa Clara (SCL)", "code" : "37" }, { "name" : "Stanislaus (STA)", "code" : "38" }, { "name" : "Merced (MER)", "code" : "39" }, { "name" : "Mariposa (MPA)", "code" : "40" }, { "name" : "Madera (MAD)", "code" : "41" }, { "name" : "Fresno (FRE)", "code" : "42" }, { "name" : "San Benito (SBT)", "code" : "43" }, { "name" : "Monterey (MON)", "code" : "44" }, { "name" : "Kings (KIN)", "code" : "45" }, { "name" : "Tulare (TUL)", "code" : "46" }, { "name" : "Mono (MNO)", "code" : "47" }, { "name" : "Inyo (INY)", "code" : "48" }, { "name" : "San Luis Obispo (SLO)", "code" : "49" }, { "name" : "Kern (KER)", "code" : "50" }, { "name" : "Santa Barbara (SB)", "code" : "51" }, { "name" : "Ventura (VEN)", "code" : "52" }, { "name" : "Los Angeles (LA)", "code" : "53" }, { "name" : "San Bernardino (SBD)", "code" : "54" }, { "name" : "Orange (ORA)", "code" : "55" }, { "name" : "Riverside (RIV)", "code" : "56" }, { "name" : "San Diego (SD)", "code" : "57" }, { "name" : "Imperial (IMP)", "code" : "58" } ] }, "defaultValue" : null }, { "name" : "Route", "type" : "esriFieldTypeString", "alias" : "Route", "sqlType" : "sqlTypeOther", "length" : 3, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Route", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "001", "code" : "001" }, { "name" : "002", "code" : "002" }, { "name" : "003", "code" : "003" }, { "name" : "004", "code" : "004" }, { "name" : "005", "code" : "005" }, { "name" : "006", "code" : "006" }, { "name" : "007", "code" : "007" }, { "name" : "008", "code" : "008" }, { "name" : "009", "code" : "009" }, { "name" : "010", "code" : "010" }, { "name" : "011", "code" : "011" }, { "name" : "012", "code" : "012" }, { "name" : "013", "code" : "013" }, { "name" : "014", "code" : "014" }, { "name" : "015", "code" : "015" }, { "name" : "016", "code" : "016" }, { "name" : "017", "code" : "017" }, { "name" : "018", "code" : "018" }, { "name" : "019", "code" : "019" }, { "name" : "020", "code" : "020" }, { "name" : "022", "code" : "022" }, { "name" : "023", "code" : "023" }, { "name" : "024", "code" : "024" }, { "name" : "025", "code" : "025" }, { "name" : "026", "code" : "026" }, { "name" : "027", "code" : "027" }, { "name" : "028", "code" : "028" }, { "name" : "029", "code" : "029" }, { "name" : "030", "code" : "030" }, { "name" : "032", "code" : "032" }, { "name" : "033", "code" : "033" }, { "name" : "034", "code" : "034" }, { "name" : "035", "code" : "035" }, { "name" : "036", "code" : "036" }, { "name" : "037", "code" : "037" }, { "name" : "038", "code" : "038" }, { "name" : "039", "code" : "039" }, { "name" : "040", "code" : "040" }, { "name" : "041", "code" : "041" }, { "name" : "043", "code" : "043" }, { "name" : "044", "code" : "044" }, { "name" : "045", "code" : "045" }, { "name" : "046", "code" : "046" }, { "name" : "047", "code" : "047" }, { "name" : "048", "code" : "048" }, { "name" : "049", "code" : "049" }, { "name" : "050", "code" : "050" }, { "name" : "051", "code" : "051" }, { "name" : "052", "code" : "052" }, { "name" : "053", "code" : "053" }, { "name" : "054", "code" : "054" }, { "name" : "055", "code" : "055" }, { "name" : "056", "code" : "056" }, { "name" : "057", "code" : "057" }, { "name" : "058", "code" : "058" }, { "name" : "059", "code" : "059" }, { "name" : "060", "code" : "060" }, { "name" : "061", "code" : "061" }, { "name" : "062", "code" : "062" }, { "name" : "063", "code" : "063" }, { "name" : "065", "code" : "065" }, { "name" : "066", "code" : "066" }, { "name" : "067", "code" : "067" }, { "name" : "068", "code" : "068" }, { "name" : "070", "code" : "070" }, { "name" : "071", "code" : "071" }, { "name" : "072", "code" : "072" }, { "name" : "073", "code" : "073" }, { "name" : "074", "code" : "074" }, { "name" : "075", "code" : "075" }, { "name" : "076", "code" : "076" }, { "name" : "077", "code" : "077" }, { "name" : "078", "code" : "078" }, { "name" : "079", "code" : "079" }, { "name" : "080", "code" : "080" }, { "name" : "082", "code" : "082" }, { "name" : "083", "code" : "083" }, { "name" : "084", "code" : "084" }, { "name" : "085", "code" : "085" }, { "name" : "086", "code" : "086" }, { "name" : "087", "code" : "087" }, { "name" : "088", "code" : "088" }, { "name" : "089", "code" : "089" }, { "name" : "090", "code" : "090" }, { "name" : "091", "code" : "091" }, { "name" : "092", "code" : "092" }, { "name" : "094", "code" : "094" }, { "name" : "095", "code" : "095" }, { "name" : "096", "code" : "096" }, { "name" : "097", "code" : "097" }, { "name" : "098", "code" : "098" }, { "name" : "099", "code" : "099" }, { "name" : "101", "code" : "101" }, { "name" : "103", "code" : "103" }, { "name" : "104", "code" : "104" }, { "name" : "105", "code" : "105" }, { "name" : "107", "code" : "107" }, { "name" : "108", "code" : "108" }, { "name" : "109", "code" : "109" }, { "name" : "110", "code" : "110" }, { "name" : "111", "code" : "111" }, { "name" : "112", "code" : "112" }, { "name" : "113", "code" : "113" }, { "name" : "114", "code" : "114" }, { "name" : "115", "code" : "115" }, { "name" : "116", "code" : "116" }, { "name" : "118", "code" : "118" }, { "name" : "119", "code" : "119" }, { "name" : "120", "code" : "120" }, { "name" : "121", "code" : "121" }, { "name" : "123", "code" : "123" }, { "name" : "124", "code" : "124" }, { "name" : "125", "code" : "125" }, { "name" : "126", "code" : "126" }, { "name" : "127", "code" : "127" }, { "name" : "128", "code" : "128" }, { "name" : "129", "code" : "129" }, { "name" : "130", "code" : "130" }, { "name" : "131", "code" : "131" }, { "name" : "132", "code" : "132" }, { "name" : "133", "code" : "133" }, { "name" : "134", "code" : "134" }, { "name" : "135", "code" : "135" }, { "name" : "136", "code" : "136" }, { "name" : "137", "code" : "137" }, { "name" : "138", "code" : "138" }, { "name" : "139", "code" : "139" }, { "name" : "140", "code" : "140" }, { "name" : "142", "code" : "142" }, { "name" : "144", "code" : "144" }, { "name" : "145", "code" : "145" }, { "name" : "146", "code" : "146" }, { "name" : "147", "code" : "147" }, { "name" : "149", "code" : "149" }, { "name" : "150", "code" : "150" }, { "name" : "151", "code" : "151" }, { "name" : "152", "code" : "152" }, { "name" : "154", "code" : "154" }, { "name" : "155", "code" : "155" }, { "name" : "156", "code" : "156" }, { "name" : "158", "code" : "158" }, { "name" : "160", "code" : "160" }, { "name" : "161", "code" : "161" }, { "name" : "162", "code" : "162" }, { "name" : "163", "code" : "163" }, { "name" : "164", "code" : "164" }, { "name" : "165", "code" : "165" }, { "name" : "166", "code" : "166" }, { "name" : "167", "code" : "167" }, { "name" : "168", "code" : "168" }, { "name" : "169", "code" : "169" }, { "name" : "170", "code" : "170" }, { "name" : "172", "code" : "172" }, { "name" : "173", "code" : "173" }, { "name" : "174", "code" : "174" }, { "name" : "175", "code" : "175" }, { "name" : "177", "code" : "177" }, { "name" : "178", "code" : "178" }, { "name" : "180", "code" : "180" }, { "name" : "182", "code" : "182" }, { "name" : "183", "code" : "183" }, { "name" : "184", "code" : "184" }, { "name" : "185", "code" : "185" }, { "name" : "186", "code" : "186" }, { "name" : "187", "code" : "187" }, { "name" : "188", "code" : "188" }, { "name" : "189", "code" : "189" }, { "name" : "190", "code" : "190" }, { "name" : "191", "code" : "191" }, { "name" : "192", "code" : "192" }, { "name" : "193", "code" : "193" }, { "name" : "195", "code" : "195" }, { "name" : "197", "code" : "197" }, { "name" : "198", "code" : "198" }, { "name" : "199", "code" : "199" }, { "name" : "200", "code" : "200" }, { "name" : "201", "code" : "201" }, { "name" : "202", "code" : "202" }, { "name" : "203", "code" : "203" }, { "name" : "204", "code" : "204" }, { "name" : "205", "code" : "205" }, { "name" : "207", "code" : "207" }, { "name" : "209", "code" : "209" }, { "name" : "210", "code" : "210" }, { "name" : "211", "code" : "211" }, { "name" : "213", "code" : "213" }, { "name" : "215", "code" : "215" }, { "name" : "216", "code" : "216" }, { "name" : "217", "code" : "217" }, { "name" : "218", "code" : "218" }, { "name" : "219", "code" : "219" }, { "name" : "220", "code" : "220" }, { "name" : "221", "code" : "221" }, { "name" : "222", "code" : "222" }, { "name" : "223", "code" : "223" }, { "name" : "225", "code" : "225" }, { "name" : "227", "code" : "227" }, { "name" : "229", "code" : "229" }, { "name" : "232", "code" : "232" }, { "name" : "233", "code" : "233" }, { "name" : "236", "code" : "236" }, { "name" : "237", "code" : "237" }, { "name" : "238", "code" : "238" }, { "name" : "241", "code" : "241" }, { "name" : "242", "code" : "242" }, { "name" : "243", "code" : "243" }, { "name" : "244", "code" : "244" }, { "name" : "245", "code" : "245" }, { "name" : "246", "code" : "246" }, { "name" : "247", "code" : "247" }, { "name" : "253", "code" : "253" }, { "name" : "254", "code" : "254" }, { "name" : "255", "code" : "255" }, { "name" : "259", "code" : "259" }, { "name" : "260", "code" : "260" }, { "name" : "261", "code" : "261" }, { "name" : "262", "code" : "262" }, { "name" : "263", "code" : "263" }, { "name" : "265", "code" : "265" }, { "name" : "266", "code" : "266" }, { "name" : "267", "code" : "267" }, { "name" : "269", "code" : "269" }, { "name" : "270", "code" : "270" }, { "name" : "271", "code" : "271" }, { "name" : "273", "code" : "273" }, { "name" : "274", "code" : "274" }, { "name" : "275", "code" : "275" }, { "name" : "280", "code" : "280" }, { "name" : "281", "code" : "281" }, { "name" : "282", "code" : "282" }, { "name" : "283", "code" : "283" }, { "name" : "284", "code" : "284" }, { "name" : "299", "code" : "299" }, { "name" : "330", "code" : "330" }, { "name" : "371", "code" : "371" }, { "name" : "380", "code" : "380" }, { "name" : "395", "code" : "395" }, { "name" : "405", "code" : "405" }, { "name" : "505", "code" : "505" }, { "name" : "580", "code" : "580" }, { "name" : "605", "code" : "605" }, { "name" : "680", "code" : "680" }, { "name" : "710", "code" : "710" }, { "name" : "780", "code" : "780" }, { "name" : "805", "code" : "805" }, { "name" : "880", "code" : "880" }, { "name" : "905", "code" : "905" }, { "name" : "980", "code" : "980" } ] }, "defaultValue" : null }, { "name" : "PrefixCode", "type" : "esriFieldTypeString", "alias" : "Prefix Code", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "PrefixCode", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "00 - Left - __ - No Prefix", "code" : "00" }, { "name" : "01 - Left - R - Realignment", "code" : "01" }, { "name" : "02 - Left - * - Signalized Intersection", "code" : "02" }, { "name" : "03 - Left - C - Commercial Lanes Paralleling Main Highway", "code" : "03" }, { "name" : "04 - Left - D - Duplication (Due to meandering County Line)", "code" : "04" }, { "name" : "05 - Left - G - Reposting Duplicate PM and End of Route", "code" : "05" }, { "name" : "06 - Left - H - Realignment of Duplication", "code" : "06" }, { "name" : "07 - Left - L - Overlap due to Correction or Chang", "code" : "07" }, { "name" : "08 - Left - M - Realignment of Prior Realignment", "code" : "08" }, { "name" : "09 - Left - N - Realignment of M Mileage", "code" : "09" }, { "name" : "10 - Left - S - Spur", "code" : "10" }, { "name" : "11 - Left - T - Temporary Connection", "code" : "11" }, { "name" : "12 - Left - __ - Final outlet two outlet close proximity", "code" : "12" }, { "name" : "13 - Left - __ - Final outlet three outlet close proximity", "code" : "13" }, { "name" : "14 - Left - __ - Final outlet four outlet close proximity", "code" : "14" }, { "name" : "19 - Left - __ - Use to archive a system Admin Only", "code" : "19" }, { "name" : "20 - Center/Median - __ - No Prefix", "code" : "20" }, { "name" : "21 - Center/Median - R - Realignment", "code" : "21" }, { "name" : "22 - Center/Median - * - Signalized Intersection", "code" : "22" }, { "name" : "23 - Center/Median - C - Commercial Lanes Paralleling Main Highway", "code" : "23" }, { "name" : "24 - Center/Median - D - Duplication (Due to meandering County Line)", "code" : "24" }, { "name" : "25 - Center/Median - G - Reposting Duplicate PM and End of Route", "code" : "25" }, { "name" : "26 - Center/Median - H - Realignment of Duplication", "code" : "26" }, { "name" : "27 - Center/Median - L - Overlap due to Correction or Change", "code" : "27" }, { "name" : "28 - Center/Median - M - Realignment of Prior Realignment", "code" : "28" }, { "name" : "29 - Center/Median - N - Realignment of M Mileage", "code" : "29" }, { "name" : "30 - Center/Median - S - Spur", "code" : "30" }, { "name" : "31 - Center/Median - T - Temporary Connection", "code" : "31" }, { "name" : "32 - Center/Median - __ - Final outlet two outlet close proximity", "code" : "32" }, { "name" : "33 - Center/Median- __ - Final outlet three outlet close proximity", "code" : "33" }, { "name" : "34 - Center/Median - __ - Final outlet four outlet close proximity", "code" : "34" }, { "name" : "39 - Center/Median - __ - Use to archive a system Admin Only", "code" : "39" }, { "name" : "40 - Right - __ - No Prefix", "code" : "40" }, { "name" : "41 - Right - R - Realignment", "code" : "41" }, { "name" : "42 - Right - * - Signalized Intersection", "code" : "42" }, { "name" : "43 - Right - C - Commercial Lanes Paralleling Main Highway", "code" : "43" }, { "name" : "44 - Right - D - Duplication (Due to meandering County Line)", "code" : "44" }, { "name" : "45 - Right - G - Reposting Duplicate PM and End of Route", "code" : "45" }, { "name" : "46 - Right - H - Realignment of Duplication", "code" : "46" }, { "name" : "47 - Right - L - Overlap due to Correction or Change", "code" : "47" }, { "name" : "48 - Right - M - Realignment of Prior Realignment", "code" : "48" }, { "name" : "49 - Right - N - Realignment of M Mileage", "code" : "49" }, { "name" : "50 - Right - S - Spur", "code" : "50" }, { "name" : "51 - Right - T - Temporary Connection", "code" : "51" }, { "name" : "52 - Right - __ - Final outlet two outlet close proximity", "code" : "52" }, { "name" : "53 - Right - __ - Final outlet three outlet close proximity", "code" : "53" }, { "name" : "54 - Right - __ - Final outlet four outlet close proximity", "code" : "54" }, { "name" : "59 - Right - __ - Use to archive a system Admin Only", "code" : "59" }, { "name" : "60 - Ramp/Auxiliary Rd on Left - __ - No Prefix", "code" : "60" }, { "name" : "61 - Ramp/Auxiliary Rd on Left - R - Realignment", "code" : "61" }, { "name" : "62 - Ramp/Auxiliary Rd on Left - * - Signalized Intersection", "code" : "62" }, { "name" : "63 - Ramp/Auxiliary Rd on Left - C - Commercial Lanes Paralleling Main Highway", "code" : "63" }, { "name" : "64 - Ramp/Auxiliary Rd on Left - D - Duplication (Due to meandering County Line)", "code" : "64" }, { "name" : "65 - Ramp/Auxiliary Rd on Left - G - Reposting Duplicate PM and End of Route", "code" : "65" }, { "name" : "66 - Ramp/Auxiliary Rd on Left - H - Realignment of Duplication", "code" : "66" }, { "name" : "67 - Ramp/Auxiliary Rd on Left - L - Overlap due to Correction or Change", "code" : "67" }, { "name" : "68 - Ramp/Auxiliary Rd on Left - M - Realignment of Prior Realignment", "code" : "68" }, { "name" : "69 - Ramp/Auxiliary Rd on Left - N - Realignment of M Mileage", "code" : "69" }, { "name" : "70 - Ramp/Auxiliary Rd on Left - S - Spur", "code" : "70" }, { "name" : "71 - Ramp/Auxiliary Rd on Left - T - Temporary Connection", "code" : "71" }, { "name" : "72 - Ramp/Auxiliary Rd on Left - __ - Final outlet two outlets close proximity", "code" : "72" }, { "name" : "73 - Ramp/Auxiliary Rd on Left - __ - Final outlet three outlets close proximity", "code" : "73" }, { "name" : "74 - Ramp/Auxiliary Rd on Left - __ - Final outlet four outlets close proximity", "code" : "74" }, { "name" : "79 - Ramp/Auxiliary Rd on Left - __ - Use to archive a system Admin Only", "code" : "79" }, { "name" : "80 - Ramp/Auxiliary Rd on Right - __ - No Prefix", "code" : "80" }, { "name" : "81 - Ramp/Auxiliary Rd on Right - R - Realignment", "code" : "81" }, { "name" : "82 - Ramp/Auxiliary Rd on Right - * - Signalized Intersection", "code" : "82" }, { "name" : "83 - Ramp/Auxiliary Rd on Right - C - Commercial Lanes Paralleling Main Highway", "code" : "83" }, { "name" : "84 - Ramp/Auxiliary Rd on Right - D - Duplication (Due to meandering County Line)", "code" : "84" }, { "name" : "85 - Ramp/Auxiliary Rd on Right - G - Reposting Duplicate PM and End of Route", "code" : "85" }, { "name" : "86 - Ramp/Auxiliary Rd on Right - H - Realignment of Duplication", "code" : "86" }, { "name" : "87 - Ramp/Auxiliary Rd on Right - L - Overlap due to Correction or Change", "code" : "87" }, { "name" : "88 - Ramp/Auxiliary Rd on Right - M - Realignment of Prior Realignment", "code" : "88" }, { "name" : "89 - Ramp/Auxiliary Rd on Right - N - Realignment of M Mileage", "code" : "89" }, { "name" : "90 - Ramp/Auxiliary Rd on Right - S - Spur", "code" : "90" }, { "name" : "91 - Ramp/Auxiliary Rd on Right - T - Temporary Connection", "code" : "91" }, { "name" : "92 - Ramp/Auxiliary Rd on Right - __ - Final outlet two outlets close proximity", "code" : "92" }, { "name" : "93 - Ramp/Auxiliary Rd on Right - __ - Final outlet three outlets close proximity", "code" : "93" }, { "name" : "94 - Ramp/Auxiliary Rd on Right - __ - Final outlet four outlets close proximity", "code" : "94" }, { "name" : "99 - Ramp/Auxiliary Rd on Right - __ - Use to archive a system Admin Only", "code" : "99" } ] }, "defaultValue" : null }, { "name" : "Postmile", "type" : "esriFieldTypeDouble", "alias" : "Postmile", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DistrictMaintenance", "type" : "esriFieldTypeString", "alias" : "District Responsible for Maintenance", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "District", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "District 1", "code" : "01" }, { "name" : "District 2", "code" : "02" }, { "name" : "District 3", "code" : "03" }, { "name" : "District 4", "code" : "04" }, { "name" : "District 5", "code" : "05" }, { "name" : "District 6", "code" : "06" }, { "name" : "District 7", "code" : "07" }, { "name" : "District 8", "code" : "08" }, { "name" : "District 9", "code" : "09" }, { "name" : "District 10", "code" : "10" }, { "name" : "District 11", "code" : "11" }, { "name" : "District 12", "code" : "12" }, { "name" : "HQ", "code" : "13" } ] }, "defaultValue" : null }, { "name" : "Status", "type" : "esriFieldTypeSmallInteger", "alias" : "Status", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Active", "code" : 0 }, { "name" : "Inactive", "code" : 1 } ] }, "defaultValue" : 0 }, { "name" : "HealthScore", "type" : "esriFieldTypeSmallInteger", "alias" : "Health Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape1", "type" : "esriFieldTypeSmallInteger", "alias" : "Shape", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Shape", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Circular", "code" : 1 }, { "name" : "Box", "code" : 2 }, { "name" : "Elliptical", "code" : 3 }, { "name" : "Arch", "code" : 4 }, { "name" : "Arch top box", "code" : 5 }, { "name" : "Chute", "code" : 6 }, { "name" : "Rectangular", "code" : 7 }, { "name" : "Other", "code" : 8 }, { "name" : "N/A", "code" : -1 } ] }, "defaultValue" : 1 }, { "name" : "Material", "type" : "esriFieldTypeSmallInteger", "alias" : "Material", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Materials_Culverts", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "CSP", "code" : 1 }, { "name" : "RCP", "code" : 2 }, { "name" : "Composite", "code" : 6 }, { "name" : "Concrete", "code" : 7 }, { "name" : "HDPE", "code" : 8 }, { "name" : "Masonry", "code" : 9 }, { "name" : "PVC", "code" : 12 }, { "name" : "Wood", "code" : 13 }, { "name" : "WSP", "code" : 14 }, { "name" : "Other", "code" : 18 }, { "name" : "N/A", "code" : -1 } ] }, "defaultValue" : null }, { "name" : "CoatingType", "type" : "esriFieldTypeSmallInteger", "alias" : "Coating Type", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Materials_CulvertBottom", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Asphalt", "code" : 5 }, { "name" : "Concrete", "code" : 7 }, { "name" : "Liner", "code" : 15 }, { "name" : "None", "code" : 17 }, { "name" : "Other", "code" : 18 }, { "name" : "N/A", "code" : -1 } ] }, "defaultValue" : 17 }, { "name" : "CoatingTypeBottom", "type" : "esriFieldTypeSmallInteger", "alias" : "Coating Type Bottom", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Materials_CulvertBottom", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Asphalt", "code" : 5 }, { "name" : "Concrete", "code" : 7 }, { "name" : "Liner", "code" : 15 }, { "name" : "None", "code" : 17 }, { "name" : "Other", "code" : 18 }, { "name" : "N/A", "code" : -1 } ] }, "defaultValue" : 17 }, { "name" : "Diameter", "type" : "esriFieldTypeDouble", "alias" : "Culvert Diameter (ft)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 0 }, { "name" : "Width", "type" : "esriFieldTypeDouble", "alias" : "Culvert Width (ft)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 0 }, { "name" : "Height", "type" : "esriFieldTypeDouble", "alias" : "Culvert Height (ft)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 0 }, { "name" : "ConstructionDate", "type" : "esriFieldTypeDate", "alias" : "Date Constructed", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ReportLength", "type" : "esriFieldTypeDouble", "alias" : "Reported Culvert Length (ft)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CalcLength", "type" : "esriFieldTypeDouble", "alias" : "Calculated Culvert Length (ft)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : -1 }, { "name" : "MeasuredLength", "type" : "esriFieldTypeDouble", "alias" : "Measured Culvert Length (ft)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 0 }, { "name" : "TravelDirection", "type" : "esriFieldTypeString", "alias" : "Direction of Travel", "sqlType" : "sqlTypeOther", "length" : 6, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TravelDirection", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Northbound", "code" : "NB" }, { "name" : "Southbound", "code" : "SB" }, { "name" : "Eastbound", "code" : "EB" }, { "name" : "Westbound", "code" : "WB" }, { "name" : "Median", "code" : "Median" } ] }, "defaultValue" : null }, { "name" : "Side", "type" : "esriFieldTypeSmallInteger", "alias" : "Culvert Side", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "SIDE", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "RT", "code" : 1 }, { "name" : "LT", "code" : 2 }, { "name" : "Center", "code" : 3 }, { "name" : "N/A", "code" : -1 } ] }, "defaultValue" : 1 }, { "name" : "Barrel", "type" : "esriFieldTypeSmallInteger", "alias" : "Culvert Barrels", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 1 }, { "name" : "Orientation", "type" : "esriFieldTypeSmallInteger", "alias" : "Culvert Orientation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Orientation", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Transverse", "code" : 1 }, { "name" : "Longitudinal", "code" : 2 }, { "name" : "Skewed", "code" : 3 } ] }, "defaultValue" : 1 }, { "name" : "Skew", "type" : "esriFieldTypeSmallInteger", "alias" : "Culvert Skew", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "CSKEW", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "0", "code" : 1 }, { "name" : "1 - 22.5", "code" : 2 }, { "name" : "22.6 - 45.0", "code" : 3 }, { "name" : "45.1 - 90.0", "code" : 4 } ] }, "defaultValue" : 1 }, { "name" : "Slope", "type" : "esriFieldTypeSmallInteger", "alias" : "Slope of Culvert (%)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : -1 }, { "name" : "Sewer", "type" : "esriFieldTypeSmallInteger", "alias" : "Sewer", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "defaultValue" : 0 }, { "name" : "RoadwayType", "type" : "esriFieldTypeSmallInteger", "alias" : "Roadway Type", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "RoadwayType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Hwy", "code" : 1 }, { "name" : "Paved Rd", "code" : 2 }, { "name" : "Unpaved Rd", "code" : 3 }, { "name" : "Driveway", "code" : 4 }, { "name" : "Other", "code" : 5 } ] }, "defaultValue" : 1 }, { "name" : "LaneCrossings", "type" : "esriFieldTypeSmallInteger", "alias" : "Number of Roadway Lanes", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : -1 }, { "name" : "FishPassage", "type" : "esriFieldTypeSmallInteger", "alias" : "Fish Passage", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "defaultValue" : 0 }, { "name" : "WildlifePassage", "type" : "esriFieldTypeSmallInteger", "alias" : "Wildlife Passage", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "defaultValue" : 0 }, { "name" : "MaxFill", "type" : "esriFieldTypeDouble", "alias" : "Maximum Fill", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : -1 }, { "name" : "MinFill", "type" : "esriFieldTypeDouble", "alias" : "Minimum Fill", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : -1 }, { "name" : "QAQCStatus", "type" : "esriFieldTypeSmallInteger", "alias" : "QAQC Status", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "QAQCStatus", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Needs Review", "code" : 0 }, { "name" : "In Progress", "code" : 1 }, { "name" : "Approved", "code" : 2 }, { "name" : "Pending District QAQC", "code" : 3 }, { "name" : "Pending HQ QAQC", "code" : 4 }, { "name" : "Legacy Import - Location Update Required", "code" : 5 } ] }, "defaultValue" : 0 }, { "name" : "SB1Qualify", "type" : "esriFieldTypeSmallInteger", "alias" : "SB1 Qualify", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "Comment", "type" : "esriFieldTypeString", "alias" : "Comment", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "last_activitydate", "type" : "esriFieldTypeDate", "alias" : "Last Date of Activity", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_feasibleaction", "type" : "esriFieldTypeSmallInteger", "alias" : "Last Feasible Action Recommended", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "last_inspection", "type" : "esriFieldTypeDate", "alias" : "Last Date of Inspection", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_cleaning", "type" : "esriFieldTypeDate", "alias" : "Last Date of Cleaning", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_repair", "type" : "esriFieldTypeDate", "alias" : "Last Date of Repair", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_comment", "type" : "esriFieldTypeString", "alias" : "Last Comment Provided", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "last_cipeditor", "type" : "esriFieldTypeString", "alias" : "Last CIP Editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "last_cipeditdate", "type" : "esriFieldTypeDate", "alias" : "Last Date of CIP Edit", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_WWAInsp", "type" : "esriFieldTypeSmallInteger", "alias" : "Last Waterway Adequacy Inspection", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Condition", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "N/A", "code" : -1 }, { "name" : "No Deficiencies Found", "code" : 0 }, { "name" : "Good", "code" : 1 }, { "name" : "Fair", "code" : 2 }, { "name" : "Poor", "code" : 3 }, { "name" : "Severe", "code" : 4 } ] }, "defaultValue" : -1 }, { "name" : "last_AlignInsp", "type" : "esriFieldTypeSmallInteger", "alias" : "Last Alignment Inspection", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Condition", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "N/A", "code" : -1 }, { "name" : "No Deficiencies Found", "code" : 0 }, { "name" : "Good", "code" : 1 }, { "name" : "Fair", "code" : 2 }, { "name" : "Poor", "code" : 3 }, { "name" : "Severe", "code" : 4 } ] }, "defaultValue" : -1 }, { "name" : "last_JointInsp", "type" : "esriFieldTypeSmallInteger", "alias" : "Last Joint Inspection", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Condition", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "N/A", "code" : -1 }, { "name" : "No Deficiencies Found", "code" : 0 }, { "name" : "Good", "code" : 1 }, { "name" : "Fair", "code" : 2 }, { "name" : "Poor", "code" : 3 }, { "name" : "Severe", "code" : 4 } ] }, "defaultValue" : -1 }, { "name" : "last_MtrlInsp", "type" : "esriFieldTypeSmallInteger", "alias" : "Last Material Inspection", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Condition", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "N/A", "code" : -1 }, { "name" : "No Deficiencies Found", "code" : 0 }, { "name" : "Good", "code" : 1 }, { "name" : "Fair", "code" : 2 }, { "name" : "Poor", "code" : 3 }, { "name" : "Severe", "code" : 4 } ] }, "defaultValue" : -1 }, { "name" : "last_ShapeInsp", "type" : "esriFieldTypeSmallInteger", "alias" : "Last Geometric Shape Inspection", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Condition", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "N/A", "code" : -1 }, { "name" : "No Deficiencies Found", "code" : 0 }, { "name" : "Good", "code" : 1 }, { "name" : "Fair", "code" : 2 }, { "name" : "Poor", "code" : 3 }, { "name" : "Severe", "code" : 4 } ] }, "defaultValue" : -1 }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "created_user", "type" : "esriFieldTypeString", "alias" : "created_user", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "created_date", "type" : "esriFieldTypeDate", "alias" : "created_date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_edited_date", "type" : "esriFieldTypeDate", "alias" : "last_edited_date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "MaintStation", "type" : "esriFieldTypeString", "alias" : "Maintenance Station", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "MaintenanceStation", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "0056 - Crecent City - 641", "code" : "0056" }, { "name" : "0057 - Eureka/Bracut - 642", "code" : "0057" }, { "name" : "0058 - Willow Creek - 643", "code" : "0058" }, { "name" : "0059 - Orleans - 644", "code" : "0059" }, { "name" : "0060 - Idlewild - 645", "code" : "0060" }, { "name" : "0068 - Bridgeville - 662", "code" : "0068" }, { "name" : "0069 - Fortuna - 663", "code" : "0069" }, { "name" : "0070 - Garberville - 664", "code" : "0070" }, { "name" : "0071 - Leggett - 665", "code" : "0071" }, { "name" : "0072 - Willits - 667", "code" : "0072" }, { "name" : "0074 - Fort Bragg - 682", "code" : "0074" }, { "name" : "0075 - Boonville - 683", "code" : "0075" }, { "name" : "0076 - Manchester - 684", "code" : "0076" }, { "name" : "0077 - Ukiah - 687", "code" : "0077" }, { "name" : "0160 - Yreka - 612", "code" : "0160" }, { "name" : "0162 - Seaid - 615", "code" : "0162" }, { "name" : "0163 - Newell - 617", "code" : "0163" }, { "name" : "0164 - Grass Lake - 618", "code" : "0164" }, { "name" : "0166 - Redding East - 631", "code" : "0166" }, { "name" : "0167 - Redding Nortth - 632.", "code" : "0167" }, { "name" : "0168 - Red Bluff - 634", "code" : "0168" }, { "name" : "0169 - Gibson - 636", "code" : "0169" }, { "name" : "0170 - Mount Shasta - 637", "code" : "0170" }, { "name" : "0171 - Burney - 638", "code" : "0171" }, { "name" : "0173 - Trinity Center - 641", "code" : "0173" }, { "name" : "0174 - Weaverville - 642", "code" : "0174" }, { "name" : "0175 - Hayfork - 643", "code" : "0175" }, { "name" : "0176 - Platina - 644", "code" : "0176" }, { "name" : "0178 - Susanville East - 661", "code" : "0178" }, { "name" : "0179 - Susanville West - 661", "code" : "0179" }, { "name" : "0180 - Hat Creek - 664", "code" : "0180" }, { "name" : "0181 - Altura - 667", "code" : "0181" }, { "name" : "0182 - Adin - 668", "code" : "0182" }, { "name" : "0184 - Beckworth - 671", "code" : "0184" }, { "name" : "0186 - Pulga - 673", "code" : "0186" }, { "name" : "0187 - Chester - 674", "code" : "0187" }, { "name" : "0188 - Mineral - 675", "code" : "0188" }, { "name" : "0486 - Woodland - 611", "code" : "0486" }, { "name" : "0487 - West Sac - 612", "code" : "0487" }, { "name" : "0488 - Esparto - 613", "code" : "0488" }, { "name" : "0489 - Northgate - 614", "code" : "0489" }, { "name" : "0496 - Roseville - 626", "code" : "0496" }, { "name" : "0497 - East Sac - 627", "code" : "0497" }, { "name" : "0498 - Elk Grove - 628", "code" : "0498" }, { "name" : "0500 - South Lake - 631", "code" : "0500" }, { "name" : "0501 - Kyburz - 632", "code" : "0501" }, { "name" : "0502 - Placerville - 633", "code" : "0502" }, { "name" : "0505 - Rio Vista - 642", "code" : "0505" }, { "name" : "0520 - Chico - 711", "code" : "0520" }, { "name" : "0521 - Colusa - 712", "code" : "0521" }, { "name" : "0522 - Marysville - 714", "code" : "0522" }, { "name" : "0523 - Willows - 715", "code" : "0523" }, { "name" : "0526 - Auburn - 721", "code" : "0526" }, { "name" : "0527 - Whitmore - 722", "code" : "0527" }, { "name" : "0528 - Kingvale - 723", "code" : "0528" }, { "name" : "0529 - Truckee E/W - 724", "code" : "0529" }, { "name" : "0533 - Nevada City - 731", "code" : "0533" }, { "name" : "0535 - Downeville - 733", "code" : "0535" }, { "name" : "0536 - Sierraville - 734", "code" : "0536" }, { "name" : "0537 - Truckee N/S - 735", "code" : "0537" }, { "name" : "0538 - Tahoe City - 736", "code" : "0538" }, { "name" : "1006 - Rio Vista - 642", "code" : "1006" }, { "name" : "1053 - Hercules - 692", "code" : "1053" }, { "name" : "1055 - Walnut Creek - 694", "code" : "1055" }, { "name" : "1065 - Antioch - 704", "code" : "1065" }, { "name" : "1067 - San Leandro North - 707", "code" : "1067" }, { "name" : "1068 - Livermore - 708", "code" : "1068" }, { "name" : "1073 - Oakland - 715", "code" : "1073" }, { "name" : "1080 - San Leandro South - 724", "code" : "1080" }, { "name" : "1082 - Fremont - 726", "code" : "1082" }, { "name" : "1253 - Salinas South - 611", "code" : "1253" }, { "name" : "1254 - Monterey - 612", "code" : "1254" }, { "name" : "1255 - Salinas North - 613", "code" : "1255" }, { "name" : "1257 - Big Sur - 615", "code" : "1257" }, { "name" : "1258 - Willow Springs - 616", "code" : "1258" }, { "name" : "1261 - Santa Cruz North - 622", "code" : "1261" }, { "name" : "1262 - Santa Cruz South - 623", "code" : "1262" }, { "name" : "1263 - Saratoga Gap - 624", "code" : "1263" }, { "name" : "1265 - Hollister - 627", "code" : "1265" }, { "name" : "1268 - King City - 632", "code" : "1268" }, { "name" : "1269 - Cambria - 634", "code" : "1269" }, { "name" : "1270 - Shandon - 635", "code" : "1270" }, { "name" : "1271 - Templeton South - 636", "code" : "1271" }, { "name" : "1272 - Templeton LS - 637", "code" : "1272" }, { "name" : "1274 - San Luis Obispo - 641", "code" : "1274" }, { "name" : "1275 - Santa Maria North - 642", "code" : "1275" }, { "name" : "1276 - Cuyama - 643", "code" : "1276" }, { "name" : "1281 - Santa Barbara South - 653", "code" : "1281" }, { "name" : "1282 - Sata Barbara North - 654", "code" : "1282" }, { "name" : "1283 - Lompoc/Buelton - 655", "code" : "1283" }, { "name" : "1597 - Bakerfield 1 - 611", "code" : "1597" }, { "name" : "1599 - Bakerfield 2 - 613", "code" : "1599" }, { "name" : "1600 - Taft 1 - 615", "code" : "1600" }, { "name" : "1601 - Taft 1 - 616", "code" : "1601" }, { "name" : "1602 - Taft 2 - 617", "code" : "1602" }, { "name" : "1604 - Porterville SR - 621", "code" : "1604" }, { "name" : "1605 - Porterville 2 - 622", "code" : "1605" }, { "name" : "1606 - Wasco - 623", "code" : "1606" }, { "name" : "1608 - Bodfish - 626", "code" : "1608" }, { "name" : "1610 - Visalia 1 - 631", "code" : "1610" }, { "name" : "1611 - Visalia 2 - 632", "code" : "1611" }, { "name" : "1612 - Lemon Cove - 634", "code" : "1612" }, { "name" : "1613 - Pinehurst - 636", "code" : "1613" }, { "name" : "1617 - Lemoore - 641", "code" : "1617" }, { "name" : "1618 - Ketlleman City - 642", "code" : "1618" }, { "name" : "1619 - Coalinga - 643", "code" : "1619" }, { "name" : "1620 - Mendota - 644", "code" : "1620" }, { "name" : "1621 - Madera - 645", "code" : "1621" }, { "name" : "1624 - Fresno 1 - 651", "code" : "1624" }, { "name" : "1625 - Fresno 2 - 652", "code" : "1625" }, { "name" : "1626 - Coarsegold - 654", "code" : "1626" }, { "name" : "1627 - Shaver Lake - 655", "code" : "1627" }, { "name" : "1969 - Highland Park - 613", "code" : "1969" }, { "name" : "1975 - Altadena - 620", "code" : "1975" }, { "name" : "1976 - Chilao - 621", "code" : "1976" }, { "name" : "1977 - Aroyo Parkway - 622", "code" : "1977" }, { "name" : "1981 - San Fernando - 626", "code" : "1981" }, { "name" : "1984 - North Road #1 - 630", "code" : "1984" }, { "name" : "1985 - Lebec - 631", "code" : "1985" }, { "name" : "1986 - Lancaster - 632", "code" : "1986" }, { "name" : "1987 - North Road #2 - 633", "code" : "1987" }, { "name" : "1991 - North Hollywood - 638", "code" : "1991" }, { "name" : "1994 - Bellflower - 642", "code" : "1994" }, { "name" : "1995 - Cuyama - 643", "code" : "1995" }, { "name" : "1997 - Florance - 645", "code" : "1997" }, { "name" : "2002 - Rosemead - 651", "code" : "2002" }, { "name" : "2003 - East LA Road Crew - 652", "code" : "2003" }, { "name" : "2004 - Whittier - 657", "code" : "2004" }, { "name" : "2007 - Diamond Bar #1 - 662", "code" : "2007" }, { "name" : "2008 - Diamond Bar #2 - 663", "code" : "2008" }, { "name" : "2012 - Foothill #1 - 668", "code" : "2012" }, { "name" : "2013 - Foothill #2 - 669", "code" : "2013" }, { "name" : "2023 - Alameda - 681", "code" : "2023" }, { "name" : "2025 - Hollywood - 683", "code" : "2025" }, { "name" : "2029 - Route 047 Bridge - 691", "code" : "2029" }, { "name" : "2035 - Torrance - 701", "code" : "2035" }, { "name" : "2037 - Aviation - 703", "code" : "2037" }, { "name" : "2039 - South Road #2 - 705", "code" : "2039" }, { "name" : "2041 - South Road #1 - 707", "code" : "2041" }, { "name" : "2046 - Sawtelle - 713", "code" : "2046" }, { "name" : "2048 - Westdale - 715", "code" : "2048" }, { "name" : "2049 - Las Flores - 716", "code" : "2049" }, { "name" : "2052 - Tarzana - 719", "code" : "2052" }, { "name" : "2054 - Moonpark North - 722", "code" : "2054" }, { "name" : "2055 - Moonpark South - 723", "code" : "2055" }, { "name" : "2058 - Fillmore - 727", "code" : "2058" }, { "name" : "2059 - Ventura - 728", "code" : "2059" }, { "name" : "2060 - Ojai - 729", "code" : "2060" }, { "name" : "2064 - Big Sycamore - 734", "code" : "2064" }, { "name" : "2065 - Camarillo - 735", "code" : "2065" }, { "name" : "2346 - Victorville - 611", "code" : "2346" }, { "name" : "2347 - Cajon - 612", "code" : "2347" }, { "name" : "2349 - Paradise Valley - 615", "code" : "2349" }, { "name" : "2352 - Camp Angelus - 621", "code" : "2352" }, { "name" : "2353 - Dry Creek - 622", "code" : "2353" }, { "name" : "2354 - Dry Creek - 623", "code" : "2354" }, { "name" : "2355 - Panorama - 624", "code" : "2355" }, { "name" : "2356 - Fontana - 625", "code" : "2356" }, { "name" : "2358 - Barstow - 631", "code" : "2358" }, { "name" : "2359 - Mountain Pass - 632", "code" : "2359" }, { "name" : "2360 - Barstow - 633", "code" : "2360" }, { "name" : "2361 - Needles - 634", "code" : "2361" }, { "name" : "2362 - Essex - 635", "code" : "2362" }, { "name" : "2378 - Banning - 711", "code" : "2378" }, { "name" : "2379 - Hemet - 712", "code" : "2379" }, { "name" : "2380 - Keen Camp - 713", "code" : "2380" }, { "name" : "2382 - Elsinore - 716", "code" : "2382" }, { "name" : "2384 - Riverside - 721", "code" : "2384" }, { "name" : "2388 - Corona - 726", "code" : "2388" }, { "name" : "2389 - Temecula - 727", "code" : "2389" }, { "name" : "2391 - Colton - 731", "code" : "2391" }, { "name" : "2394 - Upland - 734", "code" : "2394" }, { "name" : "2397 - Indio - 741", "code" : "2397" }, { "name" : "2399 - Desert Center - 742", "code" : "2399" }, { "name" : "2400 - Blythe - 743", "code" : "2400" }, { "name" : "2402 - Vidal Junction - 745", "code" : "2402" }, { "name" : "2482 - Mojave - 611", "code" : "2482" }, { "name" : "2483 - Inyokern - 612", "code" : "2483" }, { "name" : "2485 - Inyokern - 612", "code" : "2485" }, { "name" : "2487 - Independence - 621", "code" : "2487" }, { "name" : "2488 - Bishop - 622", "code" : "2488" }, { "name" : "2489 - Death Valley - 623", "code" : "2489" }, { "name" : "2490 - Shoshone - 624", "code" : "2490" }, { "name" : "2493 - Mc Gee Creek - 631", "code" : "2493" }, { "name" : "2494 - Crestview - 632", "code" : "2494" }, { "name" : "2496 - Bridgeport - 634", "code" : "2496" }, { "name" : "2497 - Sonora Jct - 635", "code" : "2497" }, { "name" : "2615 - West Point - 651", "code" : "2615" }, { "name" : "2617 - Pinegrove - 653", "code" : "2617" }, { "name" : "2618 - Peddler Hill - 654", "code" : "2618" }, { "name" : "2619 - Caples Lake - 655", "code" : "2619" }, { "name" : "2620 - Woodfords - 656", "code" : "2620" }, { "name" : "2621 - Ione - 657", "code" : "2621" }, { "name" : "2624 - Sonora - 662", "code" : "2624" }, { "name" : "2625 - Groveland - 663", "code" : "2625" }, { "name" : "2626 - Long Barn - 664", "code" : "2626" }, { "name" : "2627 - Coulterville - 665", "code" : "2627" }, { "name" : "2629 - Cabbage Patch - 667", "code" : "2629" }, { "name" : "2632 - Modesto N/S - 672", "code" : "2632" }, { "name" : "2634 - Patterson - 674", "code" : "2634" }, { "name" : "2636 - Tracy - 676", "code" : "2636" }, { "name" : "2638 - Stockton East - 682", "code" : "2638" }, { "name" : "2640 - Stockton West - 684", "code" : "2640" }, { "name" : "2646 - Los Banos - 692", "code" : "2646" }, { "name" : "2647 - Merced East - 693", "code" : "2647" }, { "name" : "2648 - Merced West - 694", "code" : "2648" }, { "name" : "2649 - Midpines - 695", "code" : "2649" }, { "name" : "2875 - El Centro - 631", "code" : "2875" }, { "name" : "2876 - Brawley East - 632", "code" : "2876" }, { "name" : "2877 - Midway - 633", "code" : "2877" }, { "name" : "2878 - Brawley West - 634", "code" : "2878" }, { "name" : "2887 - Descano - 651", "code" : "2887" }, { "name" : "2888 - Lake Henshaw - 652", "code" : "2888" }, { "name" : "2889 - Boulevard - 653", "code" : "2889" }, { "name" : "2890 - Santee - 654", "code" : "2890" }, { "name" : "2897 - Kearny Mesa - 713", "code" : "2897" }, { "name" : "2903 - Escondido - 722", "code" : "2903" }, { "name" : "2904 - Carlsbad - 723", "code" : "2904" }, { "name" : "2919 - Chula Vista - 744", "code" : "2919" }, { "name" : "3069 - Orange - 624", "code" : "3069" }, { "name" : "3070 - Costa Mesa South - 625", "code" : "3070" }, { "name" : "3071 - San Juan - 626", "code" : "3071" }, { "name" : "3072 - Costa Mesa North - 627", "code" : "3072" }, { "name" : "3075 - Toll Road North - 632", "code" : "3075" }, { "name" : "3076 - Toll Road South - 633", "code" : "3076" }, { "name" : "4187 - Beckworth - 671", "code" : "4187" }, { "name" : "4436 - Shandon - 635", "code" : "4436" }, { "name" : "4504 - Stanton - 619", "code" : "4504" }, { "name" : "4667 - Brea - 620", "code" : "4667" }, { "name" : "0078 - Lakeport - 688", "code" : "0078" }, { "name" : "0079 - Clearlake Oaks - 689", "code" : "0079" }, { "name" : "N/A", "code" : "-1" } ] }, "defaultValue" : "-1" }, { "name" : "last_RoadInsp", "type" : "esriFieldTypeSmallInteger", "alias" : "Last Roadway Inspection", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Condition", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "N/A", "code" : -1 }, { "name" : "No Deficiencies Found", "code" : 0 }, { "name" : "Good", "code" : 1 }, { "name" : "Fair", "code" : 2 }, { "name" : "Poor", "code" : 3 }, { "name" : "Severe", "code" : 4 } ] }, "defaultValue" : -1 }, { "name" : "last_activitytype", "type" : "esriFieldTypeString", "alias" : "Last Type of Activity Performed", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ActivityType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "General Inspection", "code" : "CUL_INSP" }, { "name" : "Video Inspection Only", "code" : "CUL_VID" }, { "name" : "Support (QC)", "code" : "CUL_SUPP" }, { "name" : "Culvert Cleaning", "code" : "MTC_CULCLN" }, { "name" : "Culvert Cleaning - SB1 Authorized by HQ", "code" : "SB1_CULCLN" }, { "name" : "Culvert Repair", "code" : "MTC_CULRPR" }, { "name" : "Culvert Repair - SB1 Authorized by HQ", "code" : "SB1_CULRPR" } ] }, "defaultValue" : null }, { "name" : "ConditionOverall", "type" : "esriFieldTypeSmallInteger", "alias" : "Condition Overall", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ConditionOverall", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "N/A", "code" : -1 }, { "name" : "Poor", "code" : 0 }, { "name" : "Fair", "code" : 1 }, { "name" : "Good", "code" : 2 }, { "name" : "PI", "code" : -999 } ] }, "defaultValue" : null }, { "name" : "ConveyanceType", "type" : "esriFieldTypeSmallInteger", "alias" : "Conveyance Type", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ConveyanceType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Culvert", "code" : 1 }, { "name" : "Ditch", "code" : 2 }, { "name" : "Slotted Drain", "code" : 3 } ] }, "defaultValue" : null }, { "name" : "last_activityID", "type" : "esriFieldTypeString", "alias" : "Last Activity ID", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INET_latitude", "type" : "esriFieldTypeDouble", "alias" : "Inlet End Treatment Latitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INET_longitude", "type" : "esriFieldTypeDouble", "alias" : "Inlet End Treatment Longitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OUTET_latitude", "type" : "esriFieldTypeDouble", "alias" : "Outlet End Treatment Latitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OUTET_longitude", "type" : "esriFieldTypeDouble", "alias" : "Outlet End Treatment Longitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PartialInventory", "type" : "esriFieldTypeSmallInteger", "alias" : "Partial Inventory", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "defaultValue" : 0 }, { "name" : "RTL_Date", "type" : "esriFieldTypeDate", "alias" : "RTL Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Award_Date", "type" : "esriFieldTypeDate", "alias" : "Award Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Approval_Date", "type" : "esriFieldTypeDate", "alias" : "Approval Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ECWC_Date", "type" : "esriFieldTypeDate", "alias" : "ECWC Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "CCA_Date", "type" : "esriFieldTypeDate", "alias" : "CCA Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ReinspectionPriority", "type" : "esriFieldTypeSmallInteger", "alias" : "Reinspection Priority", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ReinspectPriorityFactor", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Low Priority - 7 Years", "code" : 1 }, { "name" : "Moderate Priority - 5 Years", "code" : 2 }, { "name" : "High Priority - 4 Years", "code" : 3 }, { "name" : "High Priority - 3 Years", "code" : 4 }, { "name" : "High Priority - 2 Years", "code" : 5 } ] }, "defaultValue" : null }, { "name" : "CulvertID", "type" : "esriFieldTypeString", "alias" : "Culvert ID", "sqlType" : "sqlTypeOther", "length" : 18, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__CIMS_COR__F4B70D856305F7BE", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_1381.CIMS_CORE_DATA_CULVERT2_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G45OUTETNO", "fields" : "OUTETNO", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G45SYSNO", "fields" : "SYSNO", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : { "timeZone" : "Pacific Standard Time", "timeZoneIANA" : "America/Los_Angeles", "respectsDaylightSaving" : false }, "types" : [], "templates" : [ { "name" : "Culvert", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "ReinspectionPriority" : null, "SYSNO" : null, "INETNO" : null, "OUTETNO" : null, "District" : null, "County" : null, "Route" : null, "PrefixCode" : null, "Postmile" : null, "DistrictMaintenance" : null, "Status" : 0, "HealthScore" : null, "Shape1" : 1, "Material" : null, "CoatingType" : 17, "CoatingTypeBottom" : 17, "Diameter" : 0, "Width" : 0, "Height" : 0, "ConstructionDate" : null, "ReportLength" : null, "CalcLength" : -1, "MeasuredLength" : 0, "TravelDirection" : null, "Side" : 1, "Barrel" : 1, "Orientation" : 1, "Skew" : 1, "Slope" : -1, "Sewer" : 0, "RoadwayType" : 1, "LaneCrossings" : -1, "FishPassage" : 0, "WildlifePassage" : 0, "MaxFill" : -1, "MinFill" : -1, "QAQCStatus" : 0, "SB1Qualify" : null, "Comment" : null, "last_activitydate" : null, "last_feasibleaction" : null, "last_inspection" : null, "last_cleaning" : null, "last_repair" : null, "last_comment" : null, "last_cipeditor" : null, "last_cipeditdate" : null, "last_WWAInsp" : -1, "last_AlignInsp" : -1, "last_JointInsp" : -1, "last_MtrlInsp" : -1, "last_ShapeInsp" : -1, "CulvertID" : null, "CCA_Date" : null, "ECWC_Date" : null, "Approval_Date" : null, "Award_Date" : null, "MaintStation" : "-1", "last_RoadInsp" : -1, "last_activitytype" : null, "ConditionOverall" : null, "ConveyanceType" : null, "last_activityID" : null, "INET_latitude" : null, "INET_longitude" : null, "OUTET_latitude" : null, "OUTET_longitude" : null, "PartialInventory" : 0, "RTL_Date" : 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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }