{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "STM_StormMain", "type" : "Feature Layer", "serviceItemId" : "d13807ad6a9944f0bcd4ef5926e877e3", "displayField" : "GLOBALID", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1734465145391, "schemaLastEditDate" : 1734464614199, "dataLastEditDate" : 1734465145391 }, "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" : true, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 602200.83520507813, "ymin" : 4804865.2432250977, "xmax" : 609682.415222168, "ymax" : 4814567.6002197266, "spatialReference" : { "wkid" : 26917, "latestWkid" : 26917 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[58,122,165,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : true, "allowUpdateWithoutMValues" : true, "hasZ" : true, "enableZDefaults" : true, "zDefault" : 0, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GLOBALID_1", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "Objectid", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "ENABLED", "type" : "esriFieldTypeSmallInteger", "alias" : "Enabled", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "EnabledDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : 1 }, { "name" : "RMOHID", "type" : "esriFieldTypeInteger", "alias" : "Rmohid", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GLOBALID", "type" : "esriFieldTypeString", "alias" : "GLOBALID", "sqlType" : "sqlTypeOther", "length" : 16, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DATACAPTUREMETHOD", "type" : "esriFieldTypeString", "alias" : "DataCaptureMethod", "sqlType" : "sqlTypeOther", "length" : 40, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnDataCaptureMethod", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "AC DATA DIGITAL TRANSFER +/- 2 M", "code" : "AC DATA DIGITAL TRANSFER +/- 2 M" }, { "name" : "AC DATA MANUAL TRANSFER +/- 5 M", "code" : "AC DATA MANUAL TRANSFER +/- 5 M" }, { "name" : "DESIGN DATA DIGITAL TRANSFER +/- 2 M", "code" : "DESIGN DATA DIGITAL TRANSFER +/- 2 M" }, { "name" : "DESIGN DATA MANUAL TRANSFER +/- 5 M", "code" : "DESIGN DATA MANUAL TRANSFER +/- 5 M" }, { "name" : "RED LINE DRAWINGS +/- 5 M", "code" : "RED LINE DRAWINGS +/- 5 M" }, { "name" : "SITE PLANS +/- 5 M", "code" : "SITE PLANS +/- 5 M" }, { "name" : "MAINTENANCE REVISIONS +/- 5 M", "code" : "MAINTENANCE REVISIONS +/- 5 M" }, { "name" : "SURVEY GRADE GPS LOW +/- 1 M", "code" : "SURVEY GRADE GPS LOW +/- 1 M" }, { "name" : "SURVEY GRADE GPS HIGH +/- 0.1 M", "code" : "SURVEY GRADE GPS HIGH +/- 0.1 M" }, { "name" : "SURVEY GRADE TOTAL STATION +/- 0.025 M", "code" : "SURVEY GRADE TOTAL STATION +/- 0.025 M" }, { "name" : "VIDEO GRADE GPS HIGH SUB M", "code" : "VIDEO GRADE GPS HIGH SUB M" }, { "name" : "ORTHOPHOTO 1:500", "code" : "ORTHOPHOTO 1:500" }, { "name" : "ORTHOPHOTO 1:2000", "code" : "ORTHOPHOTO 1:2000" }, { "name" : "ORTHOPHOTO 1:5000", "code" : "ORTHOPHOTO 1:5000" }, { "name" : "ORTHOPHOTO 1:10000", "code" : "ORTHOPHOTO 1:10000" }, { "name" : "UNKNOWN", "code" : "UNKNOWN" }, { "name" : "ORTHOPHOTO 1:1000", "code" : "ORTHOPHOTO 1:1000" } ] }, "defaultValue" : null }, { "name" : "ADMINISTRATIVEAREA", "type" : "esriFieldTypeString", "alias" : "AdministrativeArea", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMOwner", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Regional Municipality of Halton", "code" : "HALTON" }, { "name" : "City of Burlington", "code" : "BURLINGTON" }, { "name" : "City of Hamilton", "code" : "HAMILTON" }, { "name" : "Region of Peel", "code" : "PEEL" }, { "name" : "Town of Halton Hills", "code" : "HALTON HILLS" }, { "name" : "Town of Oakville", "code" : "OAKVILLE" }, { "name" : "Town of Milton", "code" : "MILTON" }, { "name" : "Private", "code" : "PRIV" }, { "name" : "Unassumed", "code" : "UNAS" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "defaultValue" : "OAKVILLE" }, { "name" : "INSTALLDATE", "type" : "esriFieldTypeInteger", "alias" : "InstallDate", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "range", "name" : "DmnFMInstallDate", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "range" : [ 1900, 2030 ] }, "defaultValue" : null }, { "name" : "LIFECYCLESTATUS", "type" : "esriFieldTypeString", "alias" : "LifecycleStatus", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMLifeCycleStatus", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "In Service", "code" : "INSRV" }, { "name" : "Out Of Service", "code" : "OUTSRV" }, { "name" : "Proposed", "code" : "PROP" }, { "name" : "Temporary", "code" : "TEMP" } ] }, "defaultValue" : "INSRV" }, { "name" : "OPERATIONALAREA", "type" : "esriFieldTypeString", "alias" : "OperationalArea", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMOperationalArea", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Town of Oakville", "code" : "OAKVILLE" }, { "name" : "Town of Milton", "code" : "MILTON" }, { "name" : "Town of Halton Hills", "code" : "HALTON HILLS" }, { "name" : "City of Burlington", "code" : "BURLINGTON" }, { "name" : "Acton", "code" : "ACTON" }, { "name" : "Georgetown", "code" : "GEORGETOWN" }, { "name" : "Campbellville", "code" : "CAMPBELLVILLE" } ] }, "defaultValue" : "OAKVILLE" }, { "name" : "PROJECTNUMBER", "type" : "esriFieldTypeString", "alias" : "Projectnumber", "sqlType" : "sqlTypeOther", "length" : 75, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MAINTENANCERESPONSIBILITY", "type" : "esriFieldTypeString", "alias" : "Maintenanceresponsibility", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SUBTYPE", "type" : "esriFieldTypeInteger", "alias" : "Subtype", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 1 }, { "name" : "DESIGNLIFE", "type" : "esriFieldTypeInteger", "alias" : "Designlife", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USEFULLIFE", "type" : "esriFieldTypeInteger", "alias" : "Usefullife", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EXPECTEDYEAROFFAILURE", "type" : "esriFieldTypeInteger", "alias" : "Expectedyearoffailure", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HISTORICCOST", "type" : "esriFieldTypeDouble", "alias" : "Historiccost", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AMORTIZATIONDATE", "type" : "esriFieldTypeDate", "alias" : "Amortizationdate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "COMMENTS", "type" : "esriFieldTypeString", "alias" : "Comments", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UPSTREAMINVERT", "type" : "esriFieldTypeDouble", "alias" : "Upstreaminvert", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DOWNSTREAMINVERT", "type" : "esriFieldTypeDouble", "alias" : "Downstreaminvert", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SLOPE", "type" : "esriFieldTypeDouble", "alias" : "Slope", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DIAMETER", "type" : "esriFieldTypeInteger", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMstMainDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "0", "code" : 0 }, { "name" : "25", "code" : 25 }, { "name" : "50", "code" : 50 }, { "name" : "75", "code" : 75 }, { "name" : "90", "code" : 90 }, { "name" : "100", "code" : 100 }, { "name" : "120", "code" : 120 }, { "name" : "125", "code" : 125 }, { "name" : "150", "code" : 150 }, { "name" : "200", "code" : 200 }, { "name" : "250", "code" : 250 }, { "name" : "300", "code" : 300 }, { "name" : "325", "code" : 325 }, { "name" : "350", "code" : 350 }, { "name" : "375", "code" : 375 }, { "name" : "400", "code" : 400 }, { "name" : "425", "code" : 425 }, { "name" : "450", "code" : 450 }, { "name" : "475", "code" : 475 }, { "name" : "500", "code" : 500 }, { "name" : "525", "code" : 525 }, { "name" : "530", "code" : 530 }, { "name" : "535", "code" : 535 }, { "name" : "550", "code" : 550 }, { "name" : "575", "code" : 575 }, { "name" : "600", "code" : 600 }, { "name" : "610", "code" : 610 }, { "name" : "625", "code" : 625 }, { "name" : "650", "code" : 650 }, { "name" : "675", "code" : 675 }, { "name" : "700", "code" : 700 }, { "name" : "725", "code" : 725 }, { "name" : "735", "code" : 735 }, { "name" : "750", "code" : 750 }, { "name" : "775", "code" : 775 }, { "name" : "760", "code" : 760 }, { "name" : "800", "code" : 800 }, { "name" : "825", "code" : 825 }, { "name" : "850", "code" : 850 }, { "name" : "860", "code" : 860 }, { "name" : "875", "code" : 875 }, { "name" : "900", "code" : 900 }, { "name" : "925", "code" : 925 }, { "name" : "950", "code" : 950 }, { "name" : "965", "code" : 965 }, { "name" : "975", "code" : 975 }, { "name" : "1000", "code" : 1000 }, { "name" : "1025", "code" : 1025 }, { "name" : "1050", "code" : 1050 }, { "name" : "1075", "code" : 1075 }, { "name" : "1100", "code" : 1100 }, { "name" : "1120", "code" : 1120 }, { "name" : "1125", "code" : 1125 }, { "name" : "1130", "code" : 1130 }, { "name" : "1150", "code" : 1150 }, { "name" : "1200", "code" : 1200 }, { "name" : "1219", "code" : 1219 }, { "name" : "1220", "code" : 1220 }, { "name" : "1245", "code" : 1245 }, { "name" : "1300", "code" : 1300 }, { "name" : "1325", "code" : 1325 }, { "name" : "1345", "code" : 1345 }, { "name" : "1350", "code" : 1350 }, { "name" : "1400", "code" : 1400 }, { "name" : "1425", "code" : 1425 }, { "name" : "1430", "code" : 1430 }, { "name" : "1450", "code" : 1450 }, { "name" : "1500", "code" : 1500 }, { "name" : "1520", "code" : 1520 }, { "name" : "1525", "code" : 1525 }, { "name" : "1535", "code" : 1535 }, { "name" : "1600", "code" : 1600 }, { "name" : "1625", "code" : 1625 }, { "name" : "1650", "code" : 1650 }, { "name" : "1725", "code" : 1725 }, { "name" : "1750", "code" : 1750 }, { "name" : "1800", "code" : 1800 }, { "name" : "1829", "code" : 1829 }, { "name" : "1830", "code" : 1830 }, { "name" : "1875", "code" : 1875 }, { "name" : "1900", "code" : 1900 }, { "name" : "1920", "code" : 1920 }, { "name" : "1922", "code" : 1922 }, { "name" : "1930", "code" : 1930 }, { "name" : "1950", "code" : 1950 }, { "name" : "2075", "code" : 2075 }, { "name" : "2100", "code" : 2100 }, { "name" : "2110", "code" : 2110 }, { "name" : "2200", "code" : 2200 }, { "name" : "2250", "code" : 2250 }, { "name" : "2400", "code" : 2400 }, { "name" : "2490", "code" : 2490 }, { "name" : "2550", "code" : 2550 }, { "name" : "3000", "code" : 3000 }, { "name" : "3048", "code" : 3048 }, { "name" : "3070", "code" : 3070 }, { "name" : "3700", "code" : 3700 }, { "name" : "5000", "code" : 5000 }, { "name" : "6000", "code" : 6000 }, { "name" : "7315", "code" : 7315 }, { "name" : "9100", "code" : 9100 }, { "name" : "Unknown", "code" : 9999 } ] }, "defaultValue" : null }, { "name" : "HEIGHT", "type" : "esriFieldTypeInteger", "alias" : "Height", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WIDTH", "type" : "esriFieldTypeInteger", "alias" : "Width", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MEASUREDLENGTH", "type" : "esriFieldTypeDouble", "alias" : "Measuredlength", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MATERIAL", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMstPipeMaterial", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Asbestos Cement", "code" : "AC" }, { "name" : "Cast Iron", "code" : "CI" }, { "name" : "Concrete Coated Stainless Steel", "code" : "CCSS" }, { "name" : "Concrete Precast", "code" : "CONC" }, { "name" : "Concrete Pressure Pipe", "code" : "CPP" }, { "name" : "Corrugated Polyvinyl Chloride", "code" : "CPVC" }, { "name" : "Corrugated Steel Pipe Annular", "code" : "CSP" }, { "name" : "Corrugated Steel Pipe Helical", "code" : "CSPH" }, { "name" : "Ductile Iron", "code" : "DI" }, { "name" : "Extra Strength Vitrified Clay", "code" : "ESVC" }, { "name" : "Fibreglass Reinforced Plastic", "code" : "FRP" }, { "name" : "High Density Polyethlene", "code" : "HDPE" }, { "name" : "Polybuthylene", "code" : "PB" }, { "name" : "Polyethylene", "code" : "PE" }, { "name" : "Polypropylene", "code" : "PP" }, { "name" : "Polyvinyl Chloride", "code" : "PVC" }, { "name" : "Steel", "code" : "STL" }, { "name" : "Vitrified Clay", "code" : "VC" }, { "name" : "Unknown", "code" : "UNKN" }, { "name" : "Other", "code" : "OTH" } ] }, "defaultValue" : null }, { "name" : "PIPEMATERIALCLASS", "type" : "esriFieldTypeSmallInteger", "alias" : "PipeMaterialClass", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMstPipeMaterialClass", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "100 D", "code" : 1 }, { "name" : "140 D", "code" : 2 }, { "name" : "40 D", "code" : 3 }, { "name" : "50 D", "code" : 4 }, { "name" : "65 D", "code" : 5 }, { "name" : "Big 0", "code" : 6 }, { "name" : "C", "code" : 7 }, { "name" : "7", "code" : 8 }, { "name" : "6", "code" : 9 }, { "name" : "L", "code" : 10 }, { "name" : "Ii", "code" : 11 }, { "name" : "C-76 CL II", "code" : 12 }, { "name" : "C-76 CL III", "code" : 13 }, { "name" : "C-76 CL IV", "code" : 14 }, { "name" : "C-76 CL V", "code" : 15 }, { "name" : "Class 1", "code" : 16 }, { "name" : "Class 2", "code" : 17 }, { "name" : "Class 3", "code" : 18 }, { "name" : "Other", "code" : 19 }, { "name" : "Ribbed", "code" : 20 }, { "name" : "SDR 11", "code" : 21 }, { "name" : "SDR 13.5", "code" : 22 }, { "name" : "SDR 17", "code" : 23 }, { "name" : "SDR 18", "code" : 24 }, { "name" : "SDR 25", "code" : 25 }, { "name" : "SDR 26", "code" : 26 }, { "name" : "SDR 28", "code" : 27 }, { "name" : "SDR 35", "code" : 28 }, { "name" : "Unknown", "code" : 29 }, { "name" : "DR-14", "code" : 30 }, { "name" : "DR-18", "code" : 31 } ] }, "defaultValue" : null }, { "name" : "PIPESHAPE", "type" : "esriFieldTypeString", "alias" : "PipeShape", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMstPipeShape", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Arch", "code" : "ARCH" }, { "name" : "Egg", "code" : "EGG" }, { "name" : "Elliptical Horizontal", "code" : "ELH" }, { "name" : "Elliptical Vertical", "code" : "ELV" }, { "name" : "Horseshoe", "code" : "HOR" }, { "name" : "Irregular", "code" : "IRR" }, { "name" : "Rectangular", "code" : "RECT" }, { "name" : "Round", "code" : "RND" }, { "name" : "Square", "code" : "SQR" }, { "name" : "Unknown", "code" : "UNKN" }, { "name" : "Other", "code" : "OTH" } ] }, "defaultValue" : null }, { "name" : "BEDCLASS", "type" : "esriFieldTypeString", "alias" : "BedClass", "sqlType" : "sqlTypeOther", "length" : 7, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMstBedClass", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Class A", "code" : "CLASS A" }, { "name" : "Class B", "code" : "CLASS B" }, { "name" : "Class C", "code" : "CLASS C" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "defaultValue" : null }, { "name" : "DROPINVERTELEVATION", "type" : "esriFieldTypeDouble", "alias" : "Dropinvertelevation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DROPINVERTTYPE", "type" : "esriFieldTypeString", "alias" : "DropInvertType", "sqlType" : "sqlTypeOther", "length" : 6, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMstDropInvertType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Internal", "code" : "INT" }, { "name" : "External", "code" : "EXT" }, { "name" : "None", "code" : "NONE" } ] }, "defaultValue" : "NONE" }, { "name" : "DROPSTRUCTUREOPSD", "type" : "esriFieldTypeString", "alias" : "DropStructureOPSD", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMstOPSD1000", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "CB connection details", "code" : "STD 3-4" }, { "name" : "Cast-in-place MH drop structure, Tee", "code" : "1003.0100" }, { "name" : "Cast-in-place MH drop structure, Wye", "code" : "1003.0200" }, { "name" : "Drop structures for MHs", "code" : "STD 2-2" }, { "name" : "Internal drop structure for existing MH", "code" : "1003.0300" }, { "name" : "Internal drop structure for new MH", "code" : "1003.0310" }, { "name" : "Retired drop structure specification", "code" : "1001.0100" }, { "name" : "Sewer service connections for rigid main pipe sewer", "code" : "1006.0100" }, { "name" : "Sewer service connections for flexible main pipe sewer", "code" : "1006.0200" } ] }, "defaultValue" : null }, { "name" : "TRENCHOPSD", "type" : "esriFieldTypeString", "alias" : "TrenchOPSD", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMstOPSD800", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Flexible pipe embedment and backfill earth excavation", "code" : "0802.0100" }, { "name" : "Flexible pipe embedment and backfill rock excavation", "code" : "0802.0130" }, { "name" : "Flexible pipe embedment in embankment, original grouund: earth or rock", "code" : "0802.0140" }, { "name" : "Flexible pipe arch embedment and backfill, earth excavation", "code" : "0802.0200" }, { "name" : "Flexible pipe arch embedment and backfill, rock excavation", "code" : "0802.0230" }, { "name" : "Flexible pipe arch embedment in embankment, original grouund: earth or rock", "code" : "0802.0240" }, { "name" : "Rigid pipe bedding, cover and backfill, type 1 or 2 soil, earth excavation", "code" : "0802.0300" }, { "name" : "Rigid pipe bedding, cover and backfill, type 3 soil, earth excavation", "code" : "0802.0310" }, { "name" : "Rigid pipe bedding, cover and backfill, type 4 soil, earth excavation", "code" : "0802.0320" }, { "name" : "Rigid pipe bedding, cover and backfill, rock excavation", "code" : "0802.0330" }, { "name" : "Rigid pipe bedding and cover in embankment, original grouund: earth or rock", "code" : "0802.0340" }, { "name" : "Horizontal elliptical rigid pipe bedding, cover and backfill, type 1 or 2 soil, earth excavation", "code" : "0802.0500" }, { "name" : "Horizontal elliptical rigid pipe bedding, cover and backfill, type 3 soil, earth excavation", "code" : "0802.0510" }, { "name" : "Horizontal elliptical rigid pipe bedding, cover and backfill, type 4 soil, earth excavation", "code" : "0802.0520" }, { "name" : "Horizontal elliptical rigid pipe bedding, cover and backfill, rock excavation", "code" : "0802.0530" }, { "name" : "Horizontal elliptical rigid pipe bedding and cover in embankment, original ground: earth or rock", "code" : "0802.0540" }, { "name" : "Perforated pipe subdrain in granular tranch,stormmain connection @ structure", "code" : "0809.0100" } ] }, "defaultValue" : null }, { "name" : "REHABILITATIONDATE", "type" : "esriFieldTypeInteger", "alias" : "RehabilitationDate", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "range", "name" : "DmnFMInstallDate", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "range" : [ 1900, 2030 ] }, "defaultValue" : null }, { "name" : "STRUCTURALCONDITIONGRADE", "type" : "esriFieldTypeInteger", "alias" : "Structuralconditiongrade", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OPERATIONSCONDITIONGRADE", "type" : "esriFieldTypeInteger", "alias" : "Operationsconditiongrade", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RATINGYEAR", "type" : "esriFieldTypeInteger", "alias" : "Ratingyear", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREET", "type" : "esriFieldTypeString", "alias" : "Street", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ENVSTRUCTUREID", "type" : "esriFieldTypeInteger", "alias" : "Envstructureid", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LINING", "type" : "esriFieldTypeString", "alias" : "Lining", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMstLiningMaterial", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Woven Polyester", "code" : "WPE" }, { "name" : "High Density Polyethylene", "code" : "HDPE" }, { "name" : "Epoxy Resin", "code" : "EPOX" }, { "name" : "Polyvinyl Chloride", "code" : "PVC" }, { "name" : "Cement Mortar", "code" : "CMORTAR" }, { "name" : "Other", "code" : "OTH" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "defaultValue" : null }, { "name" : "ENTRY_UID", "type" : "esriFieldTypeString", "alias" : "Entry Uid", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ENTRY_WHEN", "type" : "esriFieldTypeDate", "alias" : "Entry When", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "PARENTID", "type" : "esriFieldTypeString", "alias" : "Parentid", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GISID", "type" : "esriFieldTypeInteger", "alias" : "Gisid", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PREFIXID", "type" : "esriFieldTypeString", "alias" : "Prefixid", "sqlType" : "sqlTypeOther", "length" : 24, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "PREFIXID", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Used for StormMain to set default value", "codedValues" : [ { "name" : "O_0200_", "code" : "O_0200_" }, { "name" : "O_0160_", "code" : "O_0160_" }, { "name" : "O_0120_", "code" : "O_0120_" }, { "name" : "O_0170_", "code" : "O_0170_" }, { "name" : "O_0130_", "code" : "O_0130_" }, { "name" : "O_0150_", "code" : "O_0150_" }, { "name" : "O_0110_", "code" : "O_0110_" }, { "name" : "O_0100_", "code" : "O_0100_" }, { "name" : "O_0210_", "code" : "O_0210_" }, { "name" : "O_0220_", "code" : "O_0220_" }, { "name" : "O_0060_", "code" : "O_0060_" }, { "name" : "O_0030_", "code" : "O_0030_" } ] }, "defaultValue" : null }, { "name" : "RECORDCONVCODE", "type" : "esriFieldTypeString", "alias" : "Recordconvcode", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GLOBALID_1", "type" : "esriFieldTypeGlobalID", "alias" : "GLOBALID_1", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "PROJECTSTATUS", "type" : "esriFieldTypeString", "alias" : "Projectstatus", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMstProjectStatus", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Project Status for Storm", "codedValues" : [ { "name" : "Pending", "code" : "P" }, { "name" : "Issued for Construction", "code" : "IC" }, { "name" : "As-Built", "code" : "AB" }, { "name" : "No Records", "code" : "NR" } ] }, "defaultValue" : null }, { "name" : "created_user", "type" : "esriFieldTypeString", "alias" : "created_user", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "created_date", "type" : "esriFieldTypeDate", "alias" : "created_date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_edited_user", "type" : "esriFieldTypeString", "alias" : "last_edited_user", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "last_edited_date", "type" : "esriFieldTypeDate", "alias" : "last_edited_date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "NextInspection", "type" : "esriFieldTypeSmallInteger", "alias" : "NextInspection", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Inspection", "type" : "esriFieldTypeString", "alias" : "Inspection", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Complete", "code" : "A" }, { "name" : "Not Complete", "code" : "B" }, { "name" : "Flushed", "code" : "C" }, { "name" : "Heavy Flushing Required", "code" : "D" }, { "name" : "Null", "code" : "E" } ] }, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__STM_STOR__F4B70D85BDB2EE65", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_19393.STM_STORMMAIN_STM_STORMMAIN_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GLOBALID_1", "fields" : "GLOBALID_1", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "STM_StormMain", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "last_edited_date" : null, "NextInspection" : null, "ENABLED" : 1, "RMOHID" : null, "GLOBALID" : null, "DATACAPTUREMETHOD" : null, "ADMINISTRATIVEAREA" : "OAKVILLE", "INSTALLDATE" : null, "LIFECYCLESTATUS" : "INSRV", "OPERATIONALAREA" : "OAKVILLE", "PROJECTNUMBER" : null, "MAINTENANCERESPONSIBILITY" : null, "SUBTYPE" : 1, "DESIGNLIFE" : null, "USEFULLIFE" : null, "EXPECTEDYEAROFFAILURE" : null, "HISTORICCOST" : null, "AMORTIZATIONDATE" : null, "COMMENTS" : null, "UPSTREAMINVERT" : null, "DOWNSTREAMINVERT" : null, "SLOPE" : null, "DIAMETER" : null, "HEIGHT" : null, "WIDTH" : null, "MEASUREDLENGTH" : null, "MATERIAL" : null, "PIPEMATERIALCLASS" : null, "PIPESHAPE" : null, "BEDCLASS" : null, "DROPINVERTELEVATION" : null, "DROPINVERTTYPE" : "NONE", "DROPSTRUCTUREOPSD" : null, "TRENCHOPSD" : null, "REHABILITATIONDATE" : null, "STRUCTURALCONDITIONGRADE" : null, "OPERATIONSCONDITIONGRADE" : null, "RATINGYEAR" : null, "STREET" : null, "ENVSTRUCTUREID" : null, "LINING" : null, "ENTRY_UID" : null, "ENTRY_WHEN" : null, "PARENTID" : null, "GISID" : null, "PREFIXID" : null, "RECORDCONVCODE" : null, "Inspection" : null, "PROJECTSTATUS" : null, "created_user" : null, "created_date" : null, "last_edited_user" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing", "subtypeField" : "Subtype", "defaultSubtypeCode" : 1, "subtypes" : [ { "code" : 3, "name" : "FoundationDrain", "defaultValues" : { "ENABLED" : 1, "RMOHID" : null, "GLOBALID" : null, "DATACAPTUREMETHOD" : null, "ADMINISTRATIVEAREA" : "OAKVILLE", "INSTALLDATE" : null, "LIFECYCLESTATUS" : "INSRV", "OPERATIONALAREA" : "OAKVILLE", "PROJECTNUMBER" : null, "MAINTENANCERESPONSIBILITY" : null, "SUBTYPE" : 3, "DESIGNLIFE" : null, "USEFULLIFE" : null, "EXPECTEDYEAROFFAILURE" : null, "HISTORICCOST" : null, "AMORTIZATIONDATE" : null, "COMMENTS" : null, "UPSTREAMINVERT" : null, "DOWNSTREAMINVERT" : null, "SLOPE" : null, "DIAMETER" : null, "HEIGHT" : null, "WIDTH" : null, "MEASUREDLENGTH" : null, "MATERIAL" : null, "PIPEMATERIALCLASS" : null, "PIPESHAPE" : null, "BEDCLASS" : null, "DROPINVERTELEVATION" : null, "DROPINVERTTYPE" : "NONE", "DROPSTRUCTUREOPSD" : null, "TRENCHOPSD" : null, "REHABILITATIONDATE" : null, "STRUCTURALCONDITIONGRADE" : null, "OPERATIONSCONDITIONGRADE" : null, "RATINGYEAR" : null, "STREET" : null, "ENVSTRUCTUREID" : null, "LINING" : null, "ENTRY_UID" : null, "ENTRY_WHEN" : null, "PARENTID" : null, "GISID" : null, "PREFIXID" : null, "RECORDCONVCODE" : null, "PROJECTSTATUS" : "P", "created_user" : null, "created_date" : null, "last_edited_user" : null, "last_edited_date" : null, "NextInspection" : null, "Inspection" : null }, "domains" : { "ENABLED" : { "type" : "codedValue", "name" : "EnabledDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "DATACAPTUREMETHOD" : { "type" : "codedValue", "name" : "DmnDataCaptureMethod", "codedValues" : [ { "name" : "AC DATA DIGITAL TRANSFER +/- 2 M", "code" : "AC DATA DIGITAL TRANSFER +/- 2 M" }, { "name" : "AC DATA MANUAL TRANSFER +/- 5 M", "code" : "AC DATA MANUAL TRANSFER +/- 5 M" }, { "name" : "DESIGN DATA DIGITAL TRANSFER +/- 2 M", "code" : "DESIGN DATA DIGITAL TRANSFER +/- 2 M" }, { "name" : "DESIGN DATA MANUAL TRANSFER +/- 5 M", "code" : "DESIGN DATA MANUAL TRANSFER +/- 5 M" }, { "name" : "RED LINE DRAWINGS +/- 5 M", "code" : "RED LINE DRAWINGS +/- 5 M" }, { "name" : "SITE PLANS +/- 5 M", "code" : "SITE PLANS +/- 5 M" }, { "name" : "MAINTENANCE REVISIONS +/- 5 M", "code" : "MAINTENANCE REVISIONS +/- 5 M" }, { "name" : "SURVEY GRADE GPS LOW +/- 1 M", "code" : "SURVEY GRADE GPS LOW +/- 1 M" }, { "name" : "SURVEY GRADE GPS HIGH +/- 0.1 M", "code" : "SURVEY GRADE GPS HIGH +/- 0.1 M" }, { "name" : "SURVEY GRADE TOTAL STATION +/- 0.025 M", "code" : "SURVEY GRADE TOTAL STATION +/- 0.025 M" }, { "name" : "VIDEO GRADE GPS HIGH SUB M", "code" : "VIDEO GRADE GPS HIGH SUB M" }, { "name" : "ORTHOPHOTO 1:500", "code" : "ORTHOPHOTO 1:500" }, { "name" : "ORTHOPHOTO 1:2000", "code" : "ORTHOPHOTO 1:2000" }, { "name" : "ORTHOPHOTO 1:5000", "code" : "ORTHOPHOTO 1:5000" }, { "name" : "ORTHOPHOTO 1:10000", "code" : "ORTHOPHOTO 1:10000" }, { "name" : "UNKNOWN", "code" : "UNKNOWN" }, { "name" : "ORTHOPHOTO 1:1000", "code" : "ORTHOPHOTO 1:1000" } ] }, "ADMINISTRATIVEAREA" : { "type" : "codedValue", "name" : "DmnFMOwner", "codedValues" : [ { "name" : "Regional Municipality of Halton", "code" : "HALTON" }, { "name" : "City of Burlington", "code" : "BURLINGTON" }, { "name" : "City of Hamilton", "code" : "HAMILTON" }, { "name" : "Region of Peel", "code" : "PEEL" }, { "name" : "Town of Halton Hills", "code" : "HALTON HILLS" }, { "name" : "Town of Oakville", "code" : "OAKVILLE" }, { "name" : "Town of Milton", "code" : "MILTON" }, { "name" : "Private", "code" : "PRIV" }, { "name" : "Unassumed", "code" : "UNAS" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "INSTALLDATE" : { "type" : "range", "name" : "DmnFMInstallDate", "range" : [ 1900, 2030 ] }, "LIFECYCLESTATUS" : { "type" : "codedValue", "name" : "DmnFMLifeCycleStatus", "codedValues" : [ { "name" : "In Service", "code" : "INSRV" }, { "name" : "Out Of Service", "code" : "OUTSRV" }, { "name" : "Proposed", "code" : "PROP" }, { "name" : "Temporary", "code" : "TEMP" } ] }, "OPERATIONALAREA" : { "type" : "codedValue", "name" : "DmnFMOperationalArea", "codedValues" : [ { "name" : "Town of Oakville", "code" : "OAKVILLE" }, { "name" : "Town of Milton", "code" : "MILTON" }, { "name" : "Town of Halton Hills", "code" : "HALTON HILLS" }, { "name" : "City of Burlington", "code" : "BURLINGTON" }, { "name" : "Acton", "code" : "ACTON" }, { "name" : "Georgetown", "code" : "GEORGETOWN" }, { "name" : "Campbellville", "code" : "CAMPBELLVILLE" } ] }, "DIAMETER" : { "type" : "codedValue", "name" : "DmnFMstMainDiameter", "codedValues" : [ { "name" : "0", "code" : 0 }, { "name" : "25", "code" : 25 }, { "name" : "50", "code" : 50 }, { "name" : "75", "code" : 75 }, { "name" : "90", "code" : 90 }, { "name" : "100", "code" : 100 }, { "name" : "120", "code" : 120 }, { "name" : "125", "code" : 125 }, { "name" : "150", "code" : 150 }, { "name" : "200", "code" : 200 }, { "name" : "250", "code" : 250 }, { "name" : "300", "code" : 300 }, { "name" : "325", "code" : 325 }, { "name" : "350", "code" : 350 }, { "name" : "375", "code" : 375 }, { "name" : "400", "code" : 400 }, { "name" : "425", "code" : 425 }, { "name" : "450", "code" : 450 }, { "name" : "475", "code" : 475 }, { "name" : "500", "code" : 500 }, { "name" : "525", "code" : 525 }, { "name" : "530", "code" : 530 }, { "name" : "535", "code" : 535 }, { "name" : "550", "code" : 550 }, { "name" : "575", "code" : 575 }, { "name" : "600", "code" : 600 }, { "name" : "610", "code" : 610 }, { "name" : "625", "code" : 625 }, { "name" : "650", "code" : 650 }, { "name" : "675", "code" : 675 }, { "name" : "700", "code" : 700 }, { "name" : "725", "code" : 725 }, { "name" : "735", "code" : 735 }, { "name" : "750", "code" : 750 }, { "name" : "775", "code" : 775 }, { "name" : "760", "code" : 760 }, { "name" : "800", "code" : 800 }, { "name" : "825", "code" : 825 }, { "name" : "850", "code" : 850 }, { "name" : "860", "code" : 860 }, { "name" : "875", "code" : 875 }, { "name" : "900", "code" : 900 }, { "name" : "925", "code" : 925 }, { "name" : "950", "code" : 950 }, { "name" : "965", "code" : 965 }, { "name" : "975", "code" : 975 }, { "name" : "1000", "code" : 1000 }, { "name" : "1025", "code" : 1025 }, { "name" : "1050", "code" : 1050 }, { "name" : "1075", "code" : 1075 }, { "name" : "1100", "code" : 1100 }, { "name" : "1120", "code" : 1120 }, { "name" : "1125", "code" : 1125 }, { "name" : "1130", "code" : 1130 }, { "name" : "1150", "code" : 1150 }, { "name" : "1200", "code" : 1200 }, { "name" : "1219", "code" : 1219 }, { "name" : "1220", "code" : 1220 }, { "name" : "1245", "code" : 1245 }, { "name" : "1300", "code" : 1300 }, { "name" : "1325", "code" : 1325 }, { "name" : "1345", "code" : 1345 }, { "name" : "1350", "code" : 1350 }, { "name" : "1400", "code" : 1400 }, { "name" : "1425", "code" : 1425 }, { "name" : "1430", "code" : 1430 }, { "name" : "1450", "code" : 1450 }, { "name" : "1500", "code" : 1500 }, { "name" : "1520", "code" : 1520 }, { "name" : "1525", "code" : 1525 }, { "name" : "1535", "code" : 1535 }, { "name" : "1600", "code" : 1600 }, { "name" : "1625", "code" : 1625 }, { "name" : "1650", "code" : 1650 }, { "name" : "1725", "code" : 1725 }, { "name" : "1750", "code" : 1750 }, { "name" : "1800", "code" : 1800 }, { "name" : "1829", "code" : 1829 }, { "name" : "1830", "code" : 1830 }, { "name" : "1875", "code" : 1875 }, { "name" : "1900", "code" : 1900 }, { "name" : "1920", "code" : 1920 }, { "name" : "1922", "code" : 1922 }, { "name" : "1930", "code" : 1930 }, { "name" : "1950", "code" : 1950 }, { "name" : "2075", "code" : 2075 }, { "name" : "2100", "code" : 2100 }, { "name" : "2110", "code" : 2110 }, { "name" : "2200", "code" : 2200 }, { "name" : "2250", "code" : 2250 }, { "name" : "2400", "code" : 2400 }, { "name" : "2490", "code" : 2490 }, { "name" : "2550", "code" : 2550 }, { "name" : "3000", "code" : 3000 }, { "name" : "3048", "code" : 3048 }, { "name" : "3070", "code" : 3070 }, { "name" : "3700", "code" : 3700 }, { "name" : "5000", "code" : 5000 }, { "name" : "6000", "code" : 6000 }, { "name" : "7315", "code" : 7315 }, { "name" : "9100", "code" : 9100 }, { "name" : "Unknown", "code" : 9999 } ] }, "MATERIAL" : { "type" : "codedValue", "name" : "DmnFMstPipeMaterial", "codedValues" : [ { "name" : "Asbestos Cement", "code" : "AC" }, { "name" : "Cast Iron", "code" : "CI" }, { "name" : "Concrete Coated Stainless Steel", "code" : "CCSS" }, { "name" : "Concrete Precast", "code" : "CONC" }, { "name" : "Concrete Pressure Pipe", "code" : "CPP" }, { "name" : "Corrugated Polyvinyl Chloride", "code" : "CPVC" }, { "name" : "Corrugated Steel Pipe Annular", "code" : "CSP" }, { "name" : "Corrugated Steel Pipe Helical", "code" : "CSPH" }, { "name" : "Ductile Iron", "code" : "DI" }, { "name" : "Extra Strength Vitrified Clay", "code" : "ESVC" }, { "name" : "Fibreglass Reinforced Plastic", "code" : "FRP" }, { "name" : "High Density Polyethlene", "code" : "HDPE" }, { "name" : "Polybuthylene", "code" : "PB" }, { "name" : "Polyethylene", "code" : "PE" }, { "name" : "Polypropylene", "code" : "PP" }, { "name" : "Polyvinyl Chloride", "code" : "PVC" }, { "name" : "Steel", "code" : "STL" }, { "name" : "Vitrified Clay", "code" : "VC" }, { "name" : "Unknown", "code" : "UNKN" }, { "name" : "Other", "code" : "OTH" } ] }, "PIPEMATERIALCLASS" : { "type" : "codedValue", "name" : "DmnFMstPipeMaterialClass", "codedValues" : [ { "name" : "100 D", "code" : 1 }, { "name" : "140 D", "code" : 2 }, { "name" : "40 D", "code" : 3 }, { "name" : "50 D", "code" : 4 }, { "name" : "65 D", "code" : 5 }, { "name" : "Big 0", "code" : 6 }, { "name" : "C", "code" : 7 }, { "name" : "7", "code" : 8 }, { "name" : "6", "code" : 9 }, { "name" : "L", "code" : 10 }, { "name" : "Ii", "code" : 11 }, { "name" : "C-76 CL II", "code" : 12 }, { "name" : "C-76 CL III", "code" : 13 }, { "name" : "C-76 CL IV", "code" : 14 }, { "name" : "C-76 CL V", "code" : 15 }, { "name" : "Class 1", "code" : 16 }, { "name" : "Class 2", "code" : 17 }, { "name" : "Class 3", "code" : 18 }, { "name" : "Other", "code" : 19 }, { "name" : "Ribbed", "code" : 20 }, { "name" : "SDR 11", "code" : 21 }, { "name" : "SDR 13.5", "code" : 22 }, { "name" : "SDR 17", "code" : 23 }, { "name" : "SDR 18", "code" : 24 }, { "name" : "SDR 25", "code" : 25 }, { "name" : "SDR 26", "code" : 26 }, { "name" : "SDR 28", "code" : 27 }, { "name" : "SDR 35", "code" : 28 }, { "name" : "Unknown", "code" : 29 }, { "name" : "DR-14", "code" : 30 }, { "name" : "DR-18", "code" : 31 } ] }, "PIPESHAPE" : { "type" : "codedValue", "name" : "DmnFMstPipeShape", "codedValues" : [ { "name" : "Arch", "code" : "ARCH" }, { "name" : "Egg", "code" : "EGG" }, { "name" : "Elliptical Horizontal", "code" : "ELH" }, { "name" : "Elliptical Vertical", "code" : "ELV" }, { "name" : "Horseshoe", "code" : "HOR" }, { "name" : "Irregular", "code" : "IRR" }, { "name" : "Rectangular", "code" : "RECT" }, { "name" : "Round", "code" : "RND" }, { "name" : "Square", "code" : "SQR" }, { "name" : "Unknown", "code" : "UNKN" }, { "name" : "Other", "code" : "OTH" } ] }, "BEDCLASS" : { "type" : "codedValue", "name" : "DmnFMstBedClass", "codedValues" : [ { "name" : "Class A", "code" : "CLASS A" }, { "name" : "Class B", "code" : "CLASS B" }, { "name" : "Class C", "code" : "CLASS C" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "DROPINVERTTYPE" : { "type" : "codedValue", "name" : "DmnFMstDropInvertType", "codedValues" : [ { "name" : "Internal", "code" : "INT" }, { "name" : "External", "code" : "EXT" }, { "name" : "None", "code" : "NONE" } ] }, "DROPSTRUCTUREOPSD" : { "type" : "codedValue", "name" : "DmnFMstOPSD1000", "codedValues" : [ { "name" : "CB connection details", "code" : "STD 3-4" }, { "name" : "Cast-in-place MH drop structure, Tee", "code" : "1003.0100" }, { "name" : "Cast-in-place MH drop structure, Wye", "code" : "1003.0200" }, { "name" : "Drop structures for MHs", "code" : "STD 2-2" }, { "name" : "Internal drop structure for existing MH", "code" : "1003.0300" }, { "name" : "Internal drop structure for new MH", "code" : "1003.0310" }, { "name" : "Retired drop structure specification", "code" : "1001.0100" }, { "name" : "Sewer service connections for rigid main pipe sewer", "code" : "1006.0100" }, { "name" : "Sewer service connections for flexible main pipe sewer", "code" : "1006.0200" } ] }, "TRENCHOPSD" : { "type" : "codedValue", "name" : "DmnFMstOPSD800", "codedValues" : [ { "name" : "Flexible pipe embedment and backfill earth excavation", "code" : "0802.0100" }, { "name" : "Flexible pipe embedment and backfill rock excavation", "code" : "0802.0130" }, { "name" : "Flexible pipe embedment in embankment, original grouund: earth or rock", "code" : "0802.0140" }, { "name" : "Flexible pipe arch embedment and backfill, earth excavation", "code" : "0802.0200" }, { "name" : "Flexible pipe arch embedment and backfill, rock excavation", "code" : "0802.0230" }, { "name" : "Flexible pipe arch embedment in embankment, original grouund: earth or rock", "code" : "0802.0240" }, { "name" : "Rigid pipe bedding, cover and backfill, type 1 or 2 soil, earth excavation", "code" : "0802.0300" }, { "name" : "Rigid pipe bedding, cover and backfill, type 3 soil, earth excavation", "code" : "0802.0310" }, { "name" : "Rigid pipe bedding, cover and backfill, type 4 soil, earth excavation", "code" : "0802.0320" }, { "name" : "Rigid pipe bedding, cover and backfill, rock excavation", "code" : "0802.0330" }, { "name" : "Rigid pipe bedding and cover in embankment, original grouund: earth or rock", "code" : "0802.0340" }, { "name" : "Horizontal elliptical rigid pipe bedding, cover and backfill, type 1 or 2 soil, earth excavation", "code" : "0802.0500" }, { "name" : "Horizontal elliptical rigid pipe bedding, cover and backfill, type 3 soil, earth excavation", "code" : "0802.0510" }, { "name" : "Horizontal elliptical rigid pipe bedding, cover and backfill, type 4 soil, earth excavation", "code" : "0802.0520" }, { "name" : "Horizontal elliptical rigid pipe bedding, cover and backfill, rock excavation", "code" : "0802.0530" }, { "name" : "Horizontal elliptical rigid pipe bedding and cover in embankment, original ground: earth or rock", "code" : "0802.0540" }, { "name" : "Perforated pipe subdrain in granular tranch,stormmain connection @ structure", "code" : "0809.0100" } ] }, "REHABILITATIONDATE" : { "type" : "range", "name" : "DmnFMInstallDate", "range" : [ 1900, 2030 ] }, "LINING" : { "type" : "codedValue", "name" : "DmnFMstLiningMaterial", "codedValues" : [ { "name" : "Woven Polyester", "code" : "WPE" }, { "name" : "High Density Polyethylene", "code" : "HDPE" }, { "name" : "Epoxy Resin", "code" : "EPOX" }, { "name" : "Polyvinyl Chloride", "code" : "PVC" }, { "name" : "Cement Mortar", "code" : "CMORTAR" }, { "name" : "Other", "code" : "OTH" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "PROJECTSTATUS" : { "type" : "codedValue", "name" : "DmnFMstProjectStatus", "description" : "Project Status for Storm", "codedValues" : [ { "name" : "Pending", "code" : "P" }, { "name" : "Issued for Construction", "code" : "IC" }, { "name" : "As-Built", "code" : "AB" }, { "name" : "No Records", "code" : "NR" } ] } } }, { "code" : 1, "name" : "Main", "defaultValues" : { "ENABLED" : 1, "RMOHID" : null, "GLOBALID" : null, "DATACAPTUREMETHOD" : null, "ADMINISTRATIVEAREA" : "OAKVILLE", "INSTALLDATE" : null, "LIFECYCLESTATUS" : "INSRV", "OPERATIONALAREA" : "OAKVILLE", "PROJECTNUMBER" : null, "MAINTENANCERESPONSIBILITY" : null, "SUBTYPE" : 1, "DESIGNLIFE" : null, "USEFULLIFE" : null, "EXPECTEDYEAROFFAILURE" : null, "HISTORICCOST" : null, "AMORTIZATIONDATE" : null, "COMMENTS" : null, "UPSTREAMINVERT" : null, "DOWNSTREAMINVERT" : null, "SLOPE" : null, "DIAMETER" : null, "HEIGHT" : null, "WIDTH" : null, "MEASUREDLENGTH" : null, "MATERIAL" : null, "PIPEMATERIALCLASS" : null, "PIPESHAPE" : null, "BEDCLASS" : null, "DROPINVERTELEVATION" : null, "DROPINVERTTYPE" : "NONE", "DROPSTRUCTUREOPSD" : null, "TRENCHOPSD" : null, "REHABILITATIONDATE" : null, "STRUCTURALCONDITIONGRADE" : null, "OPERATIONSCONDITIONGRADE" : null, "RATINGYEAR" : null, "STREET" : null, "ENVSTRUCTUREID" : null, "LINING" : null, "ENTRY_UID" : null, "ENTRY_WHEN" : null, "PARENTID" : null, "GISID" : null, "PREFIXID" : null, "RECORDCONVCODE" : null, "PROJECTSTATUS" : "P", "created_user" : null, "created_date" : null, "last_edited_user" : null, "last_edited_date" : null, "NextInspection" : null, "Inspection" : null }, "domains" : { "ENABLED" : { "type" : "codedValue", "name" : "EnabledDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "DATACAPTUREMETHOD" : { "type" : "codedValue", "name" : "DmnDataCaptureMethod", "codedValues" : [ { "name" : "AC DATA DIGITAL TRANSFER +/- 2 M", "code" : "AC DATA DIGITAL TRANSFER +/- 2 M" }, { "name" : "AC DATA MANUAL TRANSFER +/- 5 M", "code" : "AC DATA MANUAL TRANSFER +/- 5 M" }, { "name" : "DESIGN DATA DIGITAL TRANSFER +/- 2 M", "code" : "DESIGN DATA DIGITAL TRANSFER +/- 2 M" }, { "name" : "DESIGN DATA MANUAL TRANSFER +/- 5 M", "code" : "DESIGN DATA MANUAL TRANSFER +/- 5 M" }, { "name" : "RED LINE DRAWINGS +/- 5 M", "code" : "RED LINE DRAWINGS +/- 5 M" }, { "name" : "SITE PLANS +/- 5 M", "code" : "SITE PLANS +/- 5 M" }, { "name" : "MAINTENANCE REVISIONS +/- 5 M", "code" : "MAINTENANCE REVISIONS +/- 5 M" }, { "name" : "SURVEY GRADE GPS LOW +/- 1 M", "code" : "SURVEY GRADE GPS LOW +/- 1 M" }, { "name" : "SURVEY GRADE GPS HIGH +/- 0.1 M", "code" : "SURVEY GRADE GPS HIGH +/- 0.1 M" }, { "name" : "SURVEY GRADE TOTAL STATION +/- 0.025 M", "code" : "SURVEY GRADE TOTAL STATION +/- 0.025 M" }, { "name" : "VIDEO GRADE GPS HIGH SUB M", "code" : "VIDEO GRADE GPS HIGH SUB M" }, { "name" : "ORTHOPHOTO 1:500", "code" : "ORTHOPHOTO 1:500" }, { "name" : "ORTHOPHOTO 1:2000", "code" : "ORTHOPHOTO 1:2000" }, { "name" : "ORTHOPHOTO 1:5000", "code" : "ORTHOPHOTO 1:5000" }, { "name" : "ORTHOPHOTO 1:10000", "code" : "ORTHOPHOTO 1:10000" }, { "name" : "UNKNOWN", "code" : "UNKNOWN" }, { "name" : "ORTHOPHOTO 1:1000", "code" : "ORTHOPHOTO 1:1000" } ] }, "ADMINISTRATIVEAREA" : { "type" : "codedValue", "name" : "DmnFMOwner", "codedValues" : [ { "name" : "Regional Municipality of Halton", "code" : "HALTON" }, { "name" : "City of Burlington", "code" : "BURLINGTON" }, { "name" : "City of Hamilton", "code" : "HAMILTON" }, { "name" : "Region of Peel", "code" : "PEEL" }, { "name" : "Town of Halton Hills", "code" : "HALTON HILLS" }, { "name" : "Town of Oakville", "code" : "OAKVILLE" }, { "name" : "Town of Milton", "code" : "MILTON" }, { "name" : "Private", "code" : "PRIV" }, { "name" : "Unassumed", "code" : "UNAS" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "INSTALLDATE" : { "type" : "range", "name" : "DmnFMInstallDate", "range" : [ 1900, 2030 ] }, "LIFECYCLESTATUS" : { "type" : "codedValue", "name" : "DmnFMLifeCycleStatus", "codedValues" : [ { "name" : "In Service", "code" : "INSRV" }, { "name" : "Out Of Service", "code" : "OUTSRV" }, { "name" : "Proposed", "code" : "PROP" }, { "name" : "Temporary", "code" : "TEMP" } ] }, "OPERATIONALAREA" : { "type" : "codedValue", "name" : "DmnFMOperationalArea", "codedValues" : [ { "name" : "Town of Oakville", "code" : "OAKVILLE" }, { "name" : "Town of Milton", "code" : "MILTON" }, { "name" : "Town of Halton Hills", "code" : "HALTON HILLS" }, { "name" : "City of Burlington", "code" : "BURLINGTON" }, { "name" : "Acton", "code" : "ACTON" }, { "name" : "Georgetown", "code" : "GEORGETOWN" }, { "name" : "Campbellville", "code" : "CAMPBELLVILLE" } ] }, "DIAMETER" : { "type" : "codedValue", "name" : "DmnFMstMainDiameter", "codedValues" : [ { "name" : "0", "code" : 0 }, { "name" : "25", "code" : 25 }, { "name" : "50", "code" : 50 }, { "name" : "75", "code" : 75 }, { "name" : "90", "code" : 90 }, { "name" : "100", "code" : 100 }, { "name" : "120", "code" : 120 }, { "name" : "125", "code" : 125 }, { "name" : "150", "code" : 150 }, { "name" : "200", "code" : 200 }, { "name" : "250", "code" : 250 }, { "name" : "300", "code" : 300 }, { "name" : "325", "code" : 325 }, { "name" : "350", "code" : 350 }, { "name" : "375", "code" : 375 }, { "name" : "400", "code" : 400 }, { "name" : "425", "code" : 425 }, { "name" : "450", "code" : 450 }, { "name" : "475", "code" : 475 }, { "name" : "500", "code" : 500 }, { "name" : "525", "code" : 525 }, { "name" : "530", "code" : 530 }, { "name" : "535", "code" : 535 }, { "name" : "550", "code" : 550 }, { "name" : "575", "code" : 575 }, { "name" : "600", "code" : 600 }, { "name" : "610", "code" : 610 }, { "name" : "625", "code" : 625 }, { "name" : "650", "code" : 650 }, { "name" : "675", "code" : 675 }, { "name" : "700", "code" : 700 }, { "name" : "725", "code" : 725 }, { "name" : "735", "code" : 735 }, { "name" : "750", "code" : 750 }, { "name" : "775", "code" : 775 }, { "name" : "760", "code" : 760 }, { "name" : "800", "code" : 800 }, { "name" : "825", "code" : 825 }, { "name" : "850", "code" : 850 }, { "name" : "860", "code" : 860 }, { "name" : "875", "code" : 875 }, { "name" : "900", "code" : 900 }, { "name" : "925", "code" : 925 }, { "name" : "950", "code" : 950 }, { "name" : "965", "code" : 965 }, { "name" : "975", "code" : 975 }, { "name" : "1000", "code" : 1000 }, { "name" : "1025", "code" : 1025 }, { "name" : "1050", "code" : 1050 }, { "name" : "1075", "code" : 1075 }, { "name" : "1100", "code" : 1100 }, { "name" : "1120", "code" : 1120 }, { "name" : "1125", "code" : 1125 }, { "name" : "1130", "code" : 1130 }, { "name" : "1150", "code" : 1150 }, { "name" : "1200", "code" : 1200 }, { "name" : "1219", "code" : 1219 }, { "name" : "1220", "code" : 1220 }, { "name" : "1245", "code" : 1245 }, { "name" : "1300", "code" : 1300 }, { "name" : "1325", "code" : 1325 }, { "name" : "1345", "code" : 1345 }, { "name" : "1350", "code" : 1350 }, { "name" : "1400", "code" : 1400 }, { "name" : "1425", "code" : 1425 }, { "name" : "1430", "code" : 1430 }, { "name" : "1450", "code" : 1450 }, { "name" : "1500", "code" : 1500 }, { "name" : "1520", "code" : 1520 }, { "name" : "1525", "code" : 1525 }, { "name" : "1535", "code" : 1535 }, { "name" : "1600", "code" : 1600 }, { "name" : "1625", "code" : 1625 }, { "name" : "1650", "code" : 1650 }, { "name" : "1725", "code" : 1725 }, { "name" : "1750", "code" : 1750 }, { "name" : "1800", "code" : 1800 }, { "name" : "1829", "code" : 1829 }, { "name" : "1830", "code" : 1830 }, { "name" : "1875", "code" : 1875 }, { "name" : "1900", "code" : 1900 }, { "name" : "1920", "code" : 1920 }, { "name" : "1922", "code" : 1922 }, { "name" : "1930", "code" : 1930 }, { "name" : "1950", "code" : 1950 }, { "name" : "2075", "code" : 2075 }, { "name" : "2100", "code" : 2100 }, { "name" : "2110", "code" : 2110 }, { "name" : "2200", "code" : 2200 }, { "name" : "2250", "code" : 2250 }, { "name" : "2400", "code" : 2400 }, { "name" : "2490", "code" : 2490 }, { "name" : "2550", "code" : 2550 }, { "name" : "3000", "code" : 3000 }, { "name" : "3048", "code" : 3048 }, { "name" : "3070", "code" : 3070 }, { "name" : "3700", "code" : 3700 }, { "name" : "5000", "code" : 5000 }, { "name" : "6000", "code" : 6000 }, { "name" : "7315", "code" : 7315 }, { "name" : "9100", "code" : 9100 }, { "name" : "Unknown", "code" : 9999 } ] }, "MATERIAL" : { "type" : "codedValue", "name" : "DmnFMstPipeMaterial", "codedValues" : [ { "name" : "Asbestos Cement", "code" : "AC" }, { "name" : "Cast Iron", "code" : "CI" }, { "name" : "Concrete Coated Stainless Steel", "code" : "CCSS" }, { "name" : "Concrete Precast", "code" : "CONC" }, { "name" : "Concrete Pressure Pipe", "code" : "CPP" }, { "name" : "Corrugated Polyvinyl Chloride", "code" : "CPVC" }, { "name" : "Corrugated Steel Pipe Annular", "code" : "CSP" }, { "name" : "Corrugated Steel Pipe Helical", "code" : "CSPH" }, { "name" : "Ductile Iron", "code" : "DI" }, { "name" : "Extra Strength Vitrified Clay", "code" : "ESVC" }, { "name" : "Fibreglass Reinforced Plastic", "code" : "FRP" }, { "name" : "High Density Polyethlene", "code" : "HDPE" }, { "name" : "Polybuthylene", "code" : "PB" }, { "name" : "Polyethylene", "code" : "PE" }, { "name" : "Polypropylene", "code" : "PP" }, { "name" : "Polyvinyl Chloride", "code" : "PVC" }, { "name" : "Steel", "code" : "STL" }, { "name" : "Vitrified Clay", "code" : "VC" }, { "name" : "Unknown", "code" : "UNKN" }, { "name" : "Other", "code" : "OTH" } ] }, "PIPEMATERIALCLASS" : { "type" : "codedValue", "name" : "DmnFMstPipeMaterialClass", "codedValues" : [ { "name" : "100 D", "code" : 1 }, { "name" : "140 D", "code" : 2 }, { "name" : "40 D", "code" : 3 }, { "name" : "50 D", "code" : 4 }, { "name" : "65 D", "code" : 5 }, { "name" : "Big 0", "code" : 6 }, { "name" : "C", "code" : 7 }, { "name" : "7", "code" : 8 }, { "name" : "6", "code" : 9 }, { "name" : "L", "code" : 10 }, { "name" : "Ii", "code" : 11 }, { "name" : "C-76 CL II", "code" : 12 }, { "name" : "C-76 CL III", "code" : 13 }, { "name" : "C-76 CL IV", "code" : 14 }, { "name" : "C-76 CL V", "code" : 15 }, { "name" : "Class 1", "code" : 16 }, { "name" : "Class 2", "code" : 17 }, { "name" : "Class 3", "code" : 18 }, { "name" : "Other", "code" : 19 }, { "name" : "Ribbed", "code" : 20 }, { "name" : "SDR 11", "code" : 21 }, { "name" : "SDR 13.5", "code" : 22 }, { "name" : "SDR 17", "code" : 23 }, { "name" : "SDR 18", "code" : 24 }, { "name" : "SDR 25", "code" : 25 }, { "name" : "SDR 26", "code" : 26 }, { "name" : "SDR 28", "code" : 27 }, { "name" : "SDR 35", "code" : 28 }, { "name" : "Unknown", "code" : 29 }, { "name" : "DR-14", "code" : 30 }, { "name" : "DR-18", "code" : 31 } ] }, "PIPESHAPE" : { "type" : "codedValue", "name" : "DmnFMstPipeShape", "codedValues" : [ { "name" : "Arch", "code" : "ARCH" }, { "name" : "Egg", "code" : "EGG" }, { "name" : "Elliptical Horizontal", "code" : "ELH" }, { "name" : "Elliptical Vertical", "code" : "ELV" }, { "name" : "Horseshoe", "code" : "HOR" }, { "name" : "Irregular", "code" : "IRR" }, { "name" : "Rectangular", "code" : "RECT" }, { "name" : "Round", "code" : "RND" }, { "name" : "Square", "code" : "SQR" }, { "name" : "Unknown", "code" : "UNKN" }, { "name" : "Other", "code" : "OTH" } ] }, "BEDCLASS" : { "type" : "codedValue", "name" : "DmnFMstBedClass", "codedValues" : [ { "name" : "Class A", "code" : "CLASS A" }, { "name" : "Class B", "code" : "CLASS B" }, { "name" : "Class C", "code" : "CLASS C" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "DROPINVERTTYPE" : { "type" : "codedValue", "name" : "DmnFMstDropInvertType", "codedValues" : [ { "name" : "Internal", "code" : "INT" }, { "name" : "External", "code" : "EXT" }, { "name" : "None", "code" : "NONE" } ] }, "DROPSTRUCTUREOPSD" : { "type" : "codedValue", "name" : "DmnFMstOPSD1000", "codedValues" : [ { "name" : "CB connection details", "code" : "STD 3-4" }, { "name" : "Cast-in-place MH drop structure, Tee", "code" : "1003.0100" }, { "name" : "Cast-in-place MH drop structure, Wye", "code" : "1003.0200" }, { "name" : "Drop structures for MHs", "code" : "STD 2-2" }, { "name" : "Internal drop structure for existing MH", "code" : "1003.0300" }, { "name" : "Internal drop structure for new MH", "code" : "1003.0310" }, { "name" : "Retired drop structure specification", "code" : "1001.0100" }, { "name" : "Sewer service connections for rigid main pipe sewer", "code" : "1006.0100" }, { "name" : "Sewer service connections for flexible main pipe sewer", "code" : "1006.0200" } ] }, "TRENCHOPSD" : { "type" : "codedValue", "name" : "DmnFMstOPSD800", "codedValues" : [ { "name" : "Flexible pipe embedment and backfill earth excavation", "code" : "0802.0100" }, { "name" : "Flexible pipe embedment and backfill rock excavation", "code" : "0802.0130" }, { "name" : "Flexible pipe embedment in embankment, original grouund: earth or rock", "code" : "0802.0140" }, { "name" : "Flexible pipe arch embedment and backfill, earth excavation", "code" : "0802.0200" }, { "name" : "Flexible pipe arch embedment and backfill, rock excavation", "code" : "0802.0230" }, { "name" : "Flexible pipe arch embedment in embankment, original grouund: earth or rock", "code" : "0802.0240" }, { "name" : "Rigid pipe bedding, cover and backfill, type 1 or 2 soil, earth excavation", "code" : "0802.0300" }, { "name" : "Rigid pipe bedding, cover and backfill, type 3 soil, earth excavation", "code" : "0802.0310" }, { "name" : "Rigid pipe bedding, cover and backfill, type 4 soil, earth excavation", "code" : "0802.0320" }, { "name" : "Rigid pipe bedding, cover and backfill, rock excavation", "code" : "0802.0330" }, { "name" : "Rigid pipe bedding and cover in embankment, original grouund: earth or rock", "code" : "0802.0340" }, { "name" : "Horizontal elliptical rigid pipe bedding, cover and backfill, type 1 or 2 soil, earth excavation", "code" : "0802.0500" }, { "name" : "Horizontal elliptical rigid pipe bedding, cover and backfill, type 3 soil, earth excavation", "code" : "0802.0510" }, { "name" : "Horizontal elliptical rigid pipe bedding, cover and backfill, type 4 soil, earth excavation", "code" : "0802.0520" }, { "name" : "Horizontal elliptical rigid pipe bedding, cover and backfill, rock excavation", "code" : "0802.0530" }, { "name" : "Horizontal elliptical rigid pipe bedding and cover in embankment, original ground: earth or rock", "code" : "0802.0540" }, { "name" : "Perforated pipe subdrain in granular tranch,stormmain connection @ structure", "code" : "0809.0100" } ] }, "REHABILITATIONDATE" : { "type" : "range", "name" : "DmnFMInstallDate", "range" : [ 1900, 2030 ] }, "LINING" : { "type" : "codedValue", "name" : "DmnFMstLiningMaterial", "codedValues" : [ { "name" : "Woven Polyester", "code" : "WPE" }, { "name" : "High Density Polyethylene", "code" : "HDPE" }, { "name" : "Epoxy Resin", "code" : "EPOX" }, { "name" : "Polyvinyl Chloride", "code" : "PVC" }, { "name" : "Cement Mortar", "code" : "CMORTAR" }, { "name" : "Other", "code" : "OTH" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "PROJECTSTATUS" : { "type" : "codedValue", "name" : "DmnFMstProjectStatus", "description" : "Project Status for Storm", "codedValues" : [ { "name" : "Pending", "code" : "P" }, { "name" : "Issued for Construction", "code" : "IC" }, { "name" : "As-Built", "code" : "AB" }, { "name" : "No Records", "code" : "NR" } ] } } }, { "code" : 2, "name" : "Culvert", "defaultValues" : { "ENABLED" : 1, "RMOHID" : null, "GLOBALID" : null, "DATACAPTUREMETHOD" : null, "ADMINISTRATIVEAREA" : "OAKVILLE", "INSTALLDATE" : null, "LIFECYCLESTATUS" : "INSRV", "OPERATIONALAREA" : "OAKVILLE", "PROJECTNUMBER" : null, "MAINTENANCERESPONSIBILITY" : null, "SUBTYPE" : 2, "DESIGNLIFE" : null, "USEFULLIFE" : null, "EXPECTEDYEAROFFAILURE" : null, "HISTORICCOST" : null, "AMORTIZATIONDATE" : null, "COMMENTS" : null, "UPSTREAMINVERT" : null, "DOWNSTREAMINVERT" : null, "SLOPE" : null, "DIAMETER" : null, "HEIGHT" : null, "WIDTH" : null, "MEASUREDLENGTH" : null, "MATERIAL" : null, "PIPEMATERIALCLASS" : null, "PIPESHAPE" : null, "BEDCLASS" : null, "DROPINVERTELEVATION" : null, "DROPINVERTTYPE" : "NONE", "DROPSTRUCTUREOPSD" : null, "TRENCHOPSD" : null, "REHABILITATIONDATE" : null, "STRUCTURALCONDITIONGRADE" : null, "OPERATIONSCONDITIONGRADE" : null, "RATINGYEAR" : null, "STREET" : null, "ENVSTRUCTUREID" : null, "LINING" : null, "ENTRY_UID" : null, "ENTRY_WHEN" : null, "PARENTID" : null, "GISID" : null, "PREFIXID" : null, "RECORDCONVCODE" : null, "PROJECTSTATUS" : "P", "created_user" : null, "created_date" : null, "last_edited_user" : null, "last_edited_date" : null, "NextInspection" : null, "Inspection" : null }, "domains" : { "ENABLED" : { "type" : "codedValue", "name" : "EnabledDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "DATACAPTUREMETHOD" : { "type" : "codedValue", "name" : "DmnDataCaptureMethod", "codedValues" : [ { "name" : "AC DATA DIGITAL TRANSFER +/- 2 M", "code" : "AC DATA DIGITAL TRANSFER +/- 2 M" }, { "name" : "AC DATA MANUAL TRANSFER +/- 5 M", "code" : "AC DATA MANUAL TRANSFER +/- 5 M" }, { "name" : "DESIGN DATA DIGITAL TRANSFER +/- 2 M", "code" : "DESIGN DATA DIGITAL TRANSFER +/- 2 M" }, { "name" : "DESIGN DATA MANUAL TRANSFER +/- 5 M", "code" : "DESIGN DATA MANUAL TRANSFER +/- 5 M" }, { "name" : "RED LINE DRAWINGS +/- 5 M", "code" : "RED LINE DRAWINGS +/- 5 M" }, { "name" : "SITE PLANS +/- 5 M", "code" : "SITE PLANS +/- 5 M" }, { "name" : "MAINTENANCE REVISIONS +/- 5 M", "code" : "MAINTENANCE REVISIONS +/- 5 M" }, { "name" : "SURVEY GRADE GPS LOW +/- 1 M", "code" : "SURVEY GRADE GPS LOW +/- 1 M" }, { "name" : "SURVEY GRADE GPS HIGH +/- 0.1 M", "code" : "SURVEY GRADE GPS HIGH +/- 0.1 M" }, { "name" : "SURVEY GRADE TOTAL STATION +/- 0.025 M", "code" : "SURVEY GRADE TOTAL STATION +/- 0.025 M" }, { "name" : "VIDEO GRADE GPS HIGH SUB M", "code" : "VIDEO GRADE GPS HIGH SUB M" }, { "name" : "ORTHOPHOTO 1:500", "code" : "ORTHOPHOTO 1:500" }, { "name" : "ORTHOPHOTO 1:2000", "code" : "ORTHOPHOTO 1:2000" }, { "name" : "ORTHOPHOTO 1:5000", "code" : "ORTHOPHOTO 1:5000" }, { "name" : "ORTHOPHOTO 1:10000", "code" : "ORTHOPHOTO 1:10000" }, { "name" : "UNKNOWN", "code" : "UNKNOWN" }, { "name" : "ORTHOPHOTO 1:1000", "code" : "ORTHOPHOTO 1:1000" } ] }, "ADMINISTRATIVEAREA" : { "type" : "codedValue", "name" : "DmnFMOwner", "codedValues" : [ { "name" : "Regional Municipality of Halton", "code" : "HALTON" }, { "name" : "City of Burlington", "code" : "BURLINGTON" }, { "name" : "City of Hamilton", "code" : "HAMILTON" }, { "name" : "Region of Peel", "code" : "PEEL" }, { "name" : "Town of Halton Hills", "code" : "HALTON HILLS" }, { "name" : "Town of Oakville", "code" : "OAKVILLE" }, { "name" : "Town of Milton", "code" : "MILTON" }, { "name" : "Private", "code" : "PRIV" }, { "name" : "Unassumed", "code" : "UNAS" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "INSTALLDATE" : { "type" : "range", "name" : "DmnFMInstallDate", "range" : [ 1900, 2030 ] }, "LIFECYCLESTATUS" : { "type" : "codedValue", "name" : "DmnFMLifeCycleStatus", "codedValues" : [ { "name" : "In Service", "code" : "INSRV" }, { "name" : "Out Of Service", "code" : "OUTSRV" }, { "name" : "Proposed", "code" : "PROP" }, { "name" : "Temporary", "code" : "TEMP" } ] }, "OPERATIONALAREA" : { "type" : "codedValue", "name" : "DmnFMOperationalArea", "codedValues" : [ { "name" : "Town of Oakville", "code" : "OAKVILLE" }, { "name" : "Town of Milton", "code" : "MILTON" }, { "name" : "Town of Halton Hills", "code" : "HALTON HILLS" }, { "name" : "City of Burlington", "code" : "BURLINGTON" }, { "name" : "Acton", "code" : "ACTON" }, { "name" : "Georgetown", "code" : "GEORGETOWN" }, { "name" : "Campbellville", "code" : "CAMPBELLVILLE" } ] }, "DIAMETER" : { "type" : "codedValue", "name" : "DmnFMstMainDiameter", "codedValues" : [ { "name" : "0", "code" : 0 }, { "name" : "25", "code" : 25 }, { "name" : "50", "code" : 50 }, { "name" : "75", "code" : 75 }, { "name" : "90", "code" : 90 }, { "name" : "100", "code" : 100 }, { "name" : "120", "code" : 120 }, { "name" : "125", "code" : 125 }, { "name" : "150", "code" : 150 }, { "name" : "200", "code" : 200 }, { "name" : "250", "code" : 250 }, { "name" : "300", "code" : 300 }, { "name" : "325", "code" : 325 }, { "name" : "350", "code" : 350 }, { "name" : "375", "code" : 375 }, { "name" : "400", "code" : 400 }, { "name" : "425", "code" : 425 }, { "name" : "450", "code" : 450 }, { "name" : "475", "code" : 475 }, { "name" : "500", "code" : 500 }, { "name" : "525", "code" : 525 }, { "name" : "530", "code" : 530 }, { "name" : "535", "code" : 535 }, { "name" : "550", "code" : 550 }, { "name" : "575", "code" : 575 }, { "name" : "600", "code" : 600 }, { "name" : "610", "code" : 610 }, { "name" : "625", "code" : 625 }, { "name" : "650", "code" : 650 }, { "name" : "675", "code" : 675 }, { "name" : "700", "code" : 700 }, { "name" : "725", "code" : 725 }, { "name" : "735", "code" : 735 }, { "name" : "750", "code" : 750 }, { "name" : "775", "code" : 775 }, { "name" : "760", "code" : 760 }, { "name" : "800", "code" : 800 }, { "name" : "825", "code" : 825 }, { "name" : "850", "code" : 850 }, { "name" : "860", "code" : 860 }, { "name" : "875", "code" : 875 }, { "name" : "900", "code" : 900 }, { "name" : "925", "code" : 925 }, { "name" : "950", "code" : 950 }, { "name" : "965", "code" : 965 }, { "name" : "975", "code" : 975 }, { "name" : "1000", "code" : 1000 }, { "name" : "1025", "code" : 1025 }, { "name" : "1050", "code" : 1050 }, { "name" : "1075", "code" : 1075 }, { "name" : "1100", "code" : 1100 }, { "name" : "1120", "code" : 1120 }, { "name" : "1125", "code" : 1125 }, { "name" : "1130", "code" : 1130 }, { "name" : "1150", "code" : 1150 }, { "name" : "1200", "code" : 1200 }, { "name" : "1219", "code" : 1219 }, { "name" : "1220", "code" : 1220 }, { "name" : "1245", "code" : 1245 }, { "name" : "1300", "code" : 1300 }, { "name" : "1325", "code" : 1325 }, { "name" : "1345", "code" : 1345 }, { "name" : "1350", "code" : 1350 }, { "name" : "1400", "code" : 1400 }, { "name" : "1425", "code" : 1425 }, { "name" : "1430", "code" : 1430 }, { "name" : "1450", "code" : 1450 }, { "name" : "1500", "code" : 1500 }, { "name" : "1520", "code" : 1520 }, { "name" : "1525", "code" : 1525 }, { "name" : "1535", "code" : 1535 }, { "name" : "1600", "code" : 1600 }, { "name" : "1625", "code" : 1625 }, { "name" : "1650", "code" : 1650 }, { "name" : "1725", "code" : 1725 }, { "name" : "1750", "code" : 1750 }, { "name" : "1800", "code" : 1800 }, { "name" : "1829", "code" : 1829 }, { "name" : "1830", "code" : 1830 }, { "name" : "1875", "code" : 1875 }, { "name" : "1900", "code" : 1900 }, { "name" : "1920", "code" : 1920 }, { "name" : "1922", "code" : 1922 }, { "name" : "1930", "code" : 1930 }, { "name" : "1950", "code" : 1950 }, { "name" : "2075", "code" : 2075 }, { "name" : "2100", "code" : 2100 }, { "name" : "2110", "code" : 2110 }, { "name" : "2200", "code" : 2200 }, { "name" : "2250", "code" : 2250 }, { "name" : "2400", "code" : 2400 }, { "name" : "2490", "code" : 2490 }, { "name" : "2550", "code" : 2550 }, { "name" : "3000", "code" : 3000 }, { "name" : "3048", "code" : 3048 }, { "name" : "3070", "code" : 3070 }, { "name" : "3700", "code" : 3700 }, { "name" : "5000", "code" : 5000 }, { "name" : "6000", "code" : 6000 }, { "name" : "7315", "code" : 7315 }, { "name" : "9100", "code" : 9100 }, { "name" : "Unknown", "code" : 9999 } ] }, "MATERIAL" : { "type" : "codedValue", "name" : "DmnFMstPipeMaterial", "codedValues" : [ { "name" : "Asbestos Cement", "code" : "AC" }, { "name" : "Cast Iron", "code" : "CI" }, { "name" : "Concrete Coated Stainless Steel", "code" : "CCSS" }, { "name" : "Concrete Precast", "code" : "CONC" }, { "name" : "Concrete Pressure Pipe", "code" : "CPP" }, { "name" : "Corrugated Polyvinyl Chloride", "code" : "CPVC" }, { "name" : "Corrugated Steel Pipe Annular", "code" : "CSP" }, { "name" : "Corrugated Steel Pipe Helical", "code" : "CSPH" }, { "name" : "Ductile Iron", "code" : "DI" }, { "name" : "Extra Strength Vitrified Clay", "code" : "ESVC" }, { "name" : "Fibreglass Reinforced Plastic", "code" : "FRP" }, { "name" : "High Density Polyethlene", "code" : "HDPE" }, { "name" : "Polybuthylene", "code" : "PB" }, { "name" : "Polyethylene", "code" : "PE" }, { "name" : "Polypropylene", "code" : "PP" }, { "name" : "Polyvinyl Chloride", "code" : "PVC" }, { "name" : "Steel", "code" : "STL" }, { "name" : "Vitrified Clay", "code" : "VC" }, { "name" : "Unknown", "code" : "UNKN" }, { "name" : "Other", "code" : "OTH" } ] }, "PIPEMATERIALCLASS" : { "type" : "codedValue", "name" : "DmnFMstPipeMaterialClass", "codedValues" : [ { "name" : "100 D", "code" : 1 }, { "name" : "140 D", "code" : 2 }, { "name" : "40 D", "code" : 3 }, { "name" : "50 D", "code" : 4 }, { "name" : "65 D", "code" : 5 }, { "name" : "Big 0", "code" : 6 }, { "name" : "C", "code" : 7 }, { "name" : "7", "code" : 8 }, { "name" : "6", "code" : 9 }, { "name" : "L", "code" : 10 }, { "name" : "Ii", "code" : 11 }, { "name" : "C-76 CL II", "code" : 12 }, { "name" : "C-76 CL III", "code" : 13 }, { "name" : "C-76 CL IV", "code" : 14 }, { "name" : "C-76 CL V", "code" : 15 }, { "name" : "Class 1", "code" : 16 }, { "name" : "Class 2", "code" : 17 }, { "name" : "Class 3", "code" : 18 }, { "name" : "Other", "code" : 19 }, { "name" : "Ribbed", "code" : 20 }, { "name" : "SDR 11", "code" : 21 }, { "name" : "SDR 13.5", "code" : 22 }, { "name" : "SDR 17", "code" : 23 }, { "name" : "SDR 18", "code" : 24 }, { "name" : "SDR 25", "code" : 25 }, { "name" : "SDR 26", "code" : 26 }, { "name" : "SDR 28", "code" : 27 }, { "name" : "SDR 35", "code" : 28 }, { "name" : "Unknown", "code" : 29 }, { "name" : "DR-14", "code" : 30 }, { "name" : "DR-18", "code" : 31 } ] }, "PIPESHAPE" : { "type" : "codedValue", "name" : "DmnFMstPipeShape", "codedValues" : [ { "name" : "Arch", "code" : "ARCH" }, { "name" : "Egg", "code" : "EGG" }, { "name" : "Elliptical Horizontal", "code" : "ELH" }, { "name" : "Elliptical Vertical", "code" : "ELV" }, { "name" : "Horseshoe", "code" : "HOR" }, { "name" : "Irregular", "code" : "IRR" }, { "name" : "Rectangular", "code" : "RECT" }, { "name" : "Round", "code" : "RND" }, { "name" : "Square", "code" : "SQR" }, { "name" : "Unknown", "code" : "UNKN" }, { "name" : "Other", "code" : "OTH" } ] }, "BEDCLASS" : { "type" : "codedValue", "name" : "DmnFMstBedClass", "codedValues" : [ { "name" : "Class A", "code" : "CLASS A" }, { "name" : "Class B", "code" : "CLASS B" }, { "name" : "Class C", "code" : "CLASS C" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "DROPINVERTTYPE" : { "type" : "codedValue", "name" : "DmnFMstDropInvertType", "codedValues" : [ { "name" : "Internal", "code" : "INT" }, { "name" : "External", "code" : "EXT" }, { "name" : "None", "code" : "NONE" } ] }, "DROPSTRUCTUREOPSD" : { "type" : "codedValue", "name" : "DmnFMstOPSD1000", "codedValues" : [ { "name" : "CB connection details", "code" : "STD 3-4" }, { "name" : "Cast-in-place MH drop structure, Tee", "code" : "1003.0100" }, { "name" : "Cast-in-place MH drop structure, Wye", "code" : "1003.0200" }, { "name" : "Drop structures for MHs", "code" : "STD 2-2" }, { "name" : "Internal drop structure for existing MH", "code" : "1003.0300" }, { "name" : "Internal drop structure for new MH", "code" : "1003.0310" }, { "name" : "Retired drop structure specification", "code" : "1001.0100" }, { "name" : "Sewer service connections for rigid main pipe sewer", "code" : "1006.0100" }, { "name" : "Sewer service connections for flexible main pipe sewer", "code" : "1006.0200" } ] }, "TRENCHOPSD" : { "type" : "codedValue", "name" : "DmnFMstOPSD800", "codedValues" : [ { "name" : "Flexible pipe embedment and backfill earth excavation", "code" : "0802.0100" }, { "name" : "Flexible pipe embedment and backfill rock excavation", "code" : "0802.0130" }, { "name" : "Flexible pipe embedment in embankment, original grouund: earth or rock", "code" : "0802.0140" }, { "name" : "Flexible pipe arch embedment and backfill, earth excavation", "code" : "0802.0200" }, { "name" : "Flexible pipe arch embedment and backfill, rock excavation", "code" : "0802.0230" }, { "name" : "Flexible pipe arch embedment in embankment, original grouund: earth or rock", "code" : "0802.0240" }, { "name" : "Rigid pipe bedding, cover and backfill, type 1 or 2 soil, earth excavation", "code" : "0802.0300" }, { "name" : "Rigid pipe bedding, cover and backfill, type 3 soil, earth excavation", "code" : "0802.0310" }, { "name" : "Rigid pipe bedding, cover and backfill, type 4 soil, earth excavation", "code" : "0802.0320" }, { "name" : "Rigid pipe bedding, cover and backfill, rock excavation", "code" : "0802.0330" }, { "name" : "Rigid pipe bedding and cover in embankment, original grouund: earth or rock", "code" : "0802.0340" }, { "name" : "Horizontal elliptical rigid pipe bedding, cover and backfill, type 1 or 2 soil, earth excavation", "code" : "0802.0500" }, { "name" : "Horizontal elliptical rigid pipe bedding, cover and backfill, type 3 soil, earth excavation", "code" : "0802.0510" }, { "name" : "Horizontal elliptical rigid pipe bedding, cover and backfill, type 4 soil, earth excavation", "code" : "0802.0520" }, { "name" : "Horizontal elliptical rigid pipe bedding, cover and backfill, rock excavation", "code" : "0802.0530" }, { "name" : "Horizontal elliptical rigid pipe bedding and cover in embankment, original ground: earth or rock", "code" : "0802.0540" }, { "name" : "Perforated pipe subdrain in granular tranch,stormmain connection @ structure", "code" : "0809.0100" } ] }, "REHABILITATIONDATE" : { "type" : "range", "name" : "DmnFMInstallDate", "range" : [ 1900, 2030 ] }, "LINING" : { "type" : "codedValue", "name" : "DmnFMstLiningMaterial", "codedValues" : [ { "name" : "Woven Polyester", "code" : "WPE" }, { "name" : "High Density Polyethylene", "code" : "HDPE" }, { "name" : "Epoxy Resin", "code" : "EPOX" }, { "name" : "Polyvinyl Chloride", "code" : "PVC" }, { "name" : "Cement Mortar", "code" : "CMORTAR" }, { "name" : "Other", "code" : "OTH" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "PROJECTSTATUS" : { "type" : "codedValue", "name" : "DmnFMstProjectStatus", "description" : "Project Status for Storm", "codedValues" : [ { "name" : "Pending", "code" : "P" }, { "name" : "Issued for Construction", "code" : "IC" }, { "name" : "As-Built", "code" : "AB" }, { "name" : "No Records", "code" : "NR" } ] } } } ] } ], "tables" : [] }