{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "Sewer Manhole Archive 2010 - 2016", "type": "Feature Layer", "description": "Manhole features connect two or more pipes and control the flow of water in the network through pipe elevations. Manhole invert elevations are stored on the pipes, instead of the manholes themselves.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102659, "latestWkid": 2237, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -17791300, "falseY": -41645400, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 240, 240, 240, 0 ], "size": 22, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 240, 240, 240, 0 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -9191923.11991644, "ymin": 3230660.345620947, "xmax": -9158850.52300784, "ymax": 3270558.420150861, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 1.4892314192838538E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 20, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "HIGHELEV", "type": "esriFieldTypeDouble", "alias": "High Pipe Elevation", "domain": null }, { "name": "INVERT", "type": "esriFieldTypeDouble", "alias": "Invert", "domain": null }, { "name": "INVERTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Elevation", "domain": null }, { "name": "RIMELEV", "type": "esriFieldTypeDouble", "alias": "Rim Elevation", "domain": null }, { "name": "CVTYPE", "type": "esriFieldTypeString", "alias": "Cover Type", "length": 20, "domain": { "type": "codedValue", "name": "piManholeCoverType_1", "description": "List of infrastructure Manhole Cover Types", "codedValues": [ { "name": "27\" Diameter", "code": "27\" Diameter" }, { "name": "42\" Diameter", "code": "42\" Diameter" }, { "name": "Large - Water Tight", "code": "Large - Water Tight" }, { "name": "Non-District", "code": "Non-District" }, { "name": "Other", "code": "Other" }, { "name": "Rectangular", "code": "Rectangular" }, { "name": "Standard", "code": "Standard" }, { "name": "Standard W/ Ears", "code": "Standard W/ Ears" }, { "name": "Standard W/ Lock", "code": "Standard W/ Lock" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Water Tight", "code": "Water Tight" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WALLMAT", "type": "esriFieldTypeString", "alias": "Wall Material", "length": 25, "domain": { "type": "codedValue", "name": "ssPipeMaterial", "description": "Sewer Stormwater Pipe Material (NASSCO)", "codedValues": [ { "name": "Asbestos Cement", "code": "AC" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Concrete pipe (non-reinforced)", "code": "CP" }, { "name": "Concrete Segments (bolted)", "code": "CSB" }, { "name": "Concrete Segments (unbolted)", "code": "CSU" }, { "name": "Corrugated metal pipe", "code": "CMP" }, { "name": "Ductile Iron Pipe", "code": "DIP" }, { "name": "Fiberglass reinforced pipe", "code": "FRP" }, { "name": "Glass reinforced cement", "code": "GRC" }, { "name": "Pitch fiber (Orangeburg)", "code": "OB" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "PolyVinyl Chloride", "code": "PVC" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Reinforced concrete pipe", "code": "RCP" }, { "name": "Reinforced Plastic Pipe (Truss Pipe)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Transite", "code": "TTE" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Other", "code": "ZZZ" }, { "name": "Not known", "code": "XXX" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MHTYPE", "type": "esriFieldTypeString", "alias": "Manhole Type", "length": 15, "domain": { "type": "codedValue", "name": "piManholeType_1", "description": "List of infrastructure Manhole Types", "codedValues": [ { "name": "Conflict", "code": "CONFLICT" }, { "name": "Diversion", "code": "DIV" }, { "name": "Drop", "code": "DRP" }, { "name": "Discharge", "code": "DSC" }, { "name": "Other", "code": "OTH" }, { "name": "Sedimentation", "code": "SED" }, { "name": "Split", "code": "SPL" }, { "name": "Standard", "code": "STD" }, { "name": "Sump", "code": "SUMP" }, { "name": "Terminal", "code": "TRM" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "Manhole Condition", "length": 10, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CUTDEPTH", "type": "esriFieldTypeDouble", "alias": "Pavement Cut Depth", "domain": null }, { "name": "FLOWDIR", "type": "esriFieldTypeString", "alias": "Flow Direction", "length": 5, "domain": { "type": "codedValue", "name": "Direction", "description": "The direction the sign is facing", "codedValues": [ { "name": "East", "code": "East" }, { "name": "North", "code": "North" }, { "name": "South", "code": "South" }, { "name": "West", "code": "West" }, { "name": "Northeast", "code": "Northeast" }, { "name": "Northwest", "code": "Northwest" }, { "name": "Southeast", "code": "Southeast" }, { "name": "Southwest", "code": "Southwest" }, { "name": "Notrheast/Northwest", "code": "Notrheast/Northwest" }, { "name": "Southeast/Southwest", "code": "Southeast/Southwest" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LINED", "type": "esriFieldTypeString", "alias": "Lined", "length": 3, "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GPSDATE", "type": "esriFieldTypeDate", "alias": "GPS Date", "length": 8, "domain": null }, { "name": "WATERTYPE", "type": "esriFieldTypeString", "alias": "Water Type", "length": 30, "domain": { "type": "codedValue", "name": "ssWaterType", "description": "Sanitary sewer water type", "codedValues": [ { "name": "Treated Water", "code": "Treated" }, { "name": "Combined Waste Water", "code": "Combined" }, { "name": "Potable Water", "code": "Potable" }, { "name": "Raw Water", "code": "Raw" }, { "name": "Reclaimed Water", "code": "Reclaimed" }, { "name": "Salt Water", "code": "Salt" }, { "name": "Sewage", "code": "Sewage" }, { "name": "Storm Runoff", "code": "Storm" }, { "name": "Waste Water Effluent", "code": "Effluent" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "AssetOwner_7", "description": "The owner of the asset", "codedValues": [ { "name": "Federal", "code": -4 }, { "name": "State", "code": -3 }, { "name": "Other", "code": -2 }, { "name": "Private", "code": -1 }, { "name": "Tampa", "code": 1 }, { "name": "Hillsborough County", "code": 2 }, { "name": "FDOT", "code": 3 }, { "name": "MacDill AFB", "code": 4 }, { "name": "SWTDD", "code": 5 }, { "name": "Parks Dept", "code": 6 }, { "name": "Temple Terrace", "code": 7 }, { "name": "Tampa Bay Water", "code": 8 }, { "name": "Aviation Authority", "code": 9 }, { "name": "Expressway Authority", "code": 10 }, { "name": "Port Authority", "code": 11 }, { "name": "USF", "code": 12 }, { "name": "Facilities", "code": 13 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "AssetManager_7", "description": "The manager of the asset", "codedValues": [ { "name": "Federal", "code": -4 }, { "name": "State", "code": -3 }, { "name": "Other", "code": -2 }, { "name": "Private", "code": -1 }, { "name": "Tampa", "code": 1 }, { "name": "Hillsborough County", "code": 2 }, { "name": "FDOT", "code": 3 }, { "name": "MacDill AFB", "code": 4 }, { "name": "SWTDD", "code": 5 }, { "name": "Parks Dept", "code": 6 }, { "name": "Temple Terrace", "code": 7 }, { "name": "Tampa Bay Water", "code": 8 }, { "name": "Aviation Authority", "code": 9 }, { "name": "Expressway Authority", "code": 10 }, { "name": "Port Authority", "code": 11 }, { "name": "USF", "code": 12 }, { "name": "Facilities", "code": 13 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SUMFLOW", "type": "esriFieldTypeDouble", "alias": "Flow Summary", "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "NODEREF", "type": "esriFieldTypeString", "alias": "Node Ref", "length": 20, "domain": null }, { "name": "MHDEPTH", "type": "esriFieldTypeDouble", "alias": "Manhole Depth", "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 200, "domain": null }, { "name": "FILENUMBER", "type": "esriFieldTypeString", "alias": "File Number", "length": 20, "domain": null }, { "name": "REHAB", "type": "esriFieldTypeString", "alias": "Rehab", "length": 20, "domain": null }, { "name": "REHABDATE", "type": "esriFieldTypeDate", "alias": "Rehab Date", "length": 8, "domain": null }, { "name": "AncillaryRole", "type": "esriFieldTypeSmallInteger", "alias": "AncillaryRole", "domain": { "type": "codedValue", "name": "AncillaryRoleDomain", "description": "", "codedValues": [ { "name": "None", "code": 0 }, { "name": "Source", "code": 1 }, { "name": "Sink", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "ASBUILT_LINK", "type": "esriFieldTypeString", "alias": "AsBuilt Link", "length": 250, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 20, "domain": { "type": "codedValue", "name": "piManholeLocation_1", "description": "List of infrastructure Manhole Locations\n", "codedValues": [ { "name": "Main Highway - Urban (State/Arterial Roads)", "code": "A" }, { "name": "Main Highway - Suburban/rural (Secondary Roads)", "code": "B" }, { "name": "Light Highway (local roads)", "code": "C" }, { "name": "Easement/right of way", "code": "D" }, { "name": "Woods", "code": "E" }, { "name": "Sidewalk", "code": "F" }, { "name": "Parking lot", "code": "G" }, { "name": "Alley", "code": "H" }, { "name": "Ditch", "code": "I" }, { "name": "Building", "code": "J" }, { "name": "Creek", "code": "K" }, { "name": "Railway", "code": "L" }, { "name": "Airport", "code": "M" }, { "name": "Yard", "code": "Y" }, { "name": "Other - give details in field 39", "code": "Z" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LININGTYPE", "type": "esriFieldTypeString", "alias": "Lining Material", "length": 20, "domain": null }, { "name": "LININGDATE", "type": "esriFieldTypeDate", "alias": "Lining Date", "length": 8, "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "Consequnce of Failure", "domain": null }, { "name": "MHRATING", "type": "esriFieldTypeDouble", "alias": "MACP Rating", "domain": null }, { "name": "CUESSCORE", "type": "esriFieldTypeDouble", "alias": "CUES Total Score", "domain": null }, { "name": "SCHINSPECT", "type": "esriFieldTypeString", "alias": "Schedule Inspection", "length": 5, "domain": { "type": "codedValue", "name": "ScheduledInspection", "description": "", "codedValues": [ { "name": "Inspected", "code": "I" }, { "name": "Not Scheduled", "code": "N" }, { "name": "Scheduled", "code": "S" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMPINSPECT", "type": "esriFieldTypeString", "alias": "Inspection Complete", "length": 5, "domain": { "type": "codedValue", "name": "Yes or No_1", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INFLUENTELEV1", "type": "esriFieldTypeDouble", "alias": "Influent Elevation 1", "domain": null }, { "name": "INFLUENTELEV2", "type": "esriFieldTypeDouble", "alias": "Influent Elevation 2", "domain": null }, { "name": "INFLUENTELEV3", "type": "esriFieldTypeDouble", "alias": "Influent Elevation 3", "domain": null }, { "name": "INFLUENTELEV4", "type": "esriFieldTypeDouble", "alias": "Influent Elevation 4", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R711_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_711", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_3324_FACILIT", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S692_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "ssManholeInspectionArchive", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BE1FA369-F68F-46F4-B938-AD86F64EC55B}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "Sewer Manhole Archive 2016-2020", "type": "Feature Layer", "description": "

Manhole features connect two or more pipes and control the flow of water in the network through pipe elevations. Manhole invert elevations are stored on the pipes, instead of the manholes themselves.<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102659, "latestWkid": 2237, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -17791300, "falseY": -41645400, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 0, 0, 0 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 100, 100, 100, 0 ], "width": 0.1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -9192042.428334951, "ymin": 3230659.1408236586, "xmax": -9158850.408080602, "ymax": 3270558.4204111947, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 1.4892314192838538E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 20, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "HIGHELEV", "type": "esriFieldTypeDouble", "alias": "High Pipe Elevation", "domain": null }, { "name": "INVERT", "type": "esriFieldTypeDouble", "alias": "Invert", "domain": null }, { "name": "INVERTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Elevation", "domain": null }, { "name": "RIMELEV", "type": "esriFieldTypeDouble", "alias": "Rim Elevation", "domain": null }, { "name": "CVTYPE", "type": "esriFieldTypeString", "alias": "Cover Type", "length": 20, "domain": { "type": "codedValue", "name": "piManholeCoverType_1", "description": "List of infrastructure Manhole Cover Types", "codedValues": [ { "name": "27\" Diameter", "code": "27\" Diameter" }, { "name": "42\" Diameter", "code": "42\" Diameter" }, { "name": "Large - Water Tight", "code": "Large - Water Tight" }, { "name": "Non-District", "code": "Non-District" }, { "name": "Other", "code": "Other" }, { "name": "Rectangular", "code": "Rectangular" }, { "name": "Standard", "code": "Standard" }, { "name": "Standard W/ Ears", "code": "Standard W/ Ears" }, { "name": "Standard W/ Lock", "code": "Standard W/ Lock" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Water Tight", "code": "Water Tight" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WALLMAT", "type": "esriFieldTypeString", "alias": "Wall Material", "length": 25, "domain": { "type": "codedValue", "name": "ssPipeMaterial", "description": "Sewer Stormwater Pipe Material (NASSCO)", "codedValues": [ { "name": "Asbestos Cement", "code": "AC" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Concrete pipe (non-reinforced)", "code": "CP" }, { "name": "Concrete Segments (bolted)", "code": "CSB" }, { "name": "Concrete Segments (unbolted)", "code": "CSU" }, { "name": "Corrugated metal pipe", "code": "CMP" }, { "name": "Ductile Iron Pipe", "code": "DIP" }, { "name": "Fiberglass reinforced pipe", "code": "FRP" }, { "name": "Glass reinforced cement", "code": "GRC" }, { "name": "Pitch fiber (Orangeburg)", "code": "OB" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "PolyVinyl Chloride", "code": "PVC" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Reinforced concrete pipe", "code": "RCP" }, { "name": "Reinforced Plastic Pipe (Truss Pipe)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Transite", "code": "TTE" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Other", "code": "ZZZ" }, { "name": "Not known", "code": "XXX" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MHTYPE", "type": "esriFieldTypeString", "alias": "Manhole Type", "length": 15, "domain": { "type": "codedValue", "name": "piManholeType_2", "description": "List of infrastructure Manhole Types", "codedValues": [ { "name": "Back Flow Preventer", "code": "BFP" }, { "name": "Conflict", "code": "CONFLICT" }, { "name": "Diversion", "code": "DIV" }, { "name": "Drop", "code": "DRP" }, { "name": "Discharge", "code": "DSC" }, { "name": "Other", "code": "OTH" }, { "name": "Sedimentation", "code": "SED" }, { "name": "Split", "code": "SPL" }, { "name": "Standard", "code": "STD" }, { "name": "Sump", "code": "SUMP" }, { "name": "Terminal", "code": "TRM" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "Manhole Condition", "length": 10, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CUTDEPTH", "type": "esriFieldTypeDouble", "alias": "Pavement Cut Depth", "domain": null }, { "name": "FLOWDIR", "type": "esriFieldTypeString", "alias": "Flow Direction", "length": 5, "domain": { "type": "codedValue", "name": "ssManholeFlowDirection", "description": "Sewer Stormwater Manhole Flow Direction", "codedValues": [ { "name": "North", "code": "North" }, { "name": "South", "code": "South" }, { "name": "East", "code": "East" }, { "name": "West", "code": "West" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LINED", "type": "esriFieldTypeString", "alias": "Lined", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GPSDATE", "type": "esriFieldTypeDate", "alias": "GPS Date", "length": 8, "domain": null }, { "name": "WATERTYPE", "type": "esriFieldTypeString", "alias": "Water Type", "length": 30, "domain": { "type": "codedValue", "name": "ssWaterType", "description": "Sanitary sewer water type", "codedValues": [ { "name": "Treated Water", "code": "Treated" }, { "name": "Combined Waste Water", "code": "Combined" }, { "name": "Potable Water", "code": "Potable" }, { "name": "Raw Water", "code": "Raw" }, { "name": "Reclaimed Water", "code": "Reclaimed" }, { "name": "Salt Water", "code": "Salt" }, { "name": "Sewage", "code": "Sewage" }, { "name": "Storm Runoff", "code": "Storm" }, { "name": "Waste Water Effluent", "code": "Effluent" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "AssetOwner_10", "description": "The owner of the asset", "codedValues": [ { "name": "Federal", "code": -4 }, { "name": "State", "code": -3 }, { "name": "Other", "code": -2 }, { "name": "Private", "code": -1 }, { "name": "Tampa", "code": 1 }, { "name": "Hillsborough County", "code": 2 }, { "name": "FDOT", "code": 3 }, { "name": "MacDill AFB", "code": 4 }, { "name": "SWTDD", "code": 5 }, { "name": "Parks Dept", "code": 6 }, { "name": "Temple Terrace", "code": 7 }, { "name": "Tampa Bay Water", "code": 8 }, { "name": "Aviation Authority", "code": 9 }, { "name": "Expressway Authority", "code": 10 }, { "name": "Port Authority", "code": 11 }, { "name": "USF", "code": 12 }, { "name": "Facilities", "code": 13 }, { "name": "CSX", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "AssetManager_10", "description": "The manager of the asset", "codedValues": [ { "name": "Federal", "code": -4 }, { "name": "State", "code": -3 }, { "name": "Other", "code": -2 }, { "name": "Private", "code": -1 }, { "name": "Tampa", "code": 1 }, { "name": "Hillsborough County", "code": 2 }, { "name": "FDOT", "code": 3 }, { "name": "MacDill AFB", "code": 4 }, { "name": "SWTDD", "code": 5 }, { "name": "Parks Dept", "code": 6 }, { "name": "Temple Terrace", "code": 7 }, { "name": "Tampa Bay Water", "code": 8 }, { "name": "Aviation Authority", "code": 9 }, { "name": "Expressway Authority", "code": 10 }, { "name": "Port Authority", "code": 11 }, { "name": "USF", "code": 12 }, { "name": "Facilities", "code": 13 }, { "name": "CSX", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SUMFLOW", "type": "esriFieldTypeDouble", "alias": "Flow Summary", "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "NODEREF", "type": "esriFieldTypeString", "alias": "Node Ref", "length": 20, "domain": null }, { "name": "MHDEPTH", "type": "esriFieldTypeDouble", "alias": "Manhole Depth", "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 200, "domain": null }, { "name": "FILENUMBER", "type": "esriFieldTypeString", "alias": "File Number", "length": 50, "domain": null }, { "name": "REHAB", "type": "esriFieldTypeString", "alias": "Rehab", "length": 20, "domain": { "type": "codedValue", "name": "MH Rehab", "description": "Manhole Rehab Description", "codedValues": [ { "name": "Calcium Aluminate", "code": "Calcium Aluminate" }, { "name": "Epoxy", "code": "Epoxy" }, { "name": "FRP Liner", "code": "FRP Liner" }, { "name": "IET Liner", "code": "IET Liner" }, { "name": "MS 10000 ConShield", "code": "MS 10000 ConShield" }, { "name": "Polyurethane", "code": "Polyurethane" }, { "name": "T-Lock", "code": "T-Lock" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REHABDATE", "type": "esriFieldTypeDate", "alias": "Rehab Date", "length": 8, "domain": null }, { "name": "AncillaryRole", "type": "esriFieldTypeSmallInteger", "alias": "Ancillary Role", "domain": { "type": "codedValue", "name": "AncillaryRoleDomain", "description": "", "codedValues": [ { "name": "None", "code": 0 }, { "name": "Source", "code": 1 }, { "name": "Sink", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ASBUILT_LINK", "type": "esriFieldTypeString", "alias": "AsBuilt Link", "length": 250, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 20, "domain": { "type": "codedValue", "name": "piManholeLocation_1", "description": "List of infrastructure Manhole Locations\n", "codedValues": [ { "name": "Main Highway - Urban (State/Arterial Roads)", "code": "A" }, { "name": "Main Highway - Suburban/rural (Secondary Roads)", "code": "B" }, { "name": "Light Highway (local roads)", "code": "C" }, { "name": "Easement/right of way", "code": "D" }, { "name": "Woods", "code": "E" }, { "name": "Sidewalk", "code": "F" }, { "name": "Parking lot", "code": "G" }, { "name": "Alley", "code": "H" }, { "name": "Ditch", "code": "I" }, { "name": "Building", "code": "J" }, { "name": "Creek", "code": "K" }, { "name": "Railway", "code": "L" }, { "name": "Airport", "code": "M" }, { "name": "Yard", "code": "Y" }, { "name": "Other - give details in field 39", "code": "Z" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LININGTYPE", "type": "esriFieldTypeString", "alias": "Lining Material", "length": 20, "domain": null }, { "name": "LININGDATE", "type": "esriFieldTypeDate", "alias": "Lining Date", "length": 8, "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "Consequnce of Failure", "domain": null }, { "name": "MHRATING", "type": "esriFieldTypeDouble", "alias": "MACP Rating", "domain": null }, { "name": "CUESSCORE", "type": "esriFieldTypeDouble", "alias": "CUES Total Score", "domain": null }, { "name": "SCHINSPECT", "type": "esriFieldTypeString", "alias": "Schedule Inspection", "length": 5, "domain": { "type": "codedValue", "name": "ScheduledInspection_1", "description": "", "codedValues": [ { "name": "Inspected", "code": "I" }, { "name": "Not Scheduled", "code": "N" }, { "name": "Scheduled", "code": "S" }, { "name": "UFV", "code": "U" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMPINSPECT", "type": "esriFieldTypeString", "alias": "Inspection Complete", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INFLUENTELEV1", "type": "esriFieldTypeDouble", "alias": "Influent Elevation 1", "domain": null }, { "name": "INFLUENTELEV2", "type": "esriFieldTypeDouble", "alias": "Influent Elevation 2", "domain": null }, { "name": "INFLUENTELEV3", "type": "esriFieldTypeDouble", "alias": "Influent Elevation 3", "domain": null }, { "name": "INFLUENTELEV4", "type": "esriFieldTypeDouble", "alias": "Influent Elevation 4", "domain": null }, { "name": "LIKELIHOODOFFAILURE", "type": "esriFieldTypeSmallInteger", "alias": "Likelihood of Failure", "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": { "type": "codedValue", "name": "Status_1", "description": "Stauts of work", "codedValues": [ { "name": "PLANNED", "code": "0" }, { "name": "WO ISSUED", "code": "1" }, { "name": "COMPLETED", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RISKOFFAILURE", "type": "esriFieldTypeSmallInteger", "alias": "Risk of Failure", "domain": null }, { "name": "REHABDETAIL", "type": "esriFieldTypeString", "alias": "Rehab Detail", "length": 255, "domain": null }, { "name": "DATUMSOURCE", "type": "esriFieldTypeString", "alias": "Datum Source", "length": 50, "domain": null }, { "name": "ORGASBUILT", "type": "esriFieldTypeString", "alias": "Original As-Built", "length": 50, "domain": null }, { "name": "CVRINSERTTYPE", "type": "esriFieldTypeString", "alias": "Cover Insert Type", "length": 20, "domain": { "type": "codedValue", "name": "NASSCO_InsertType", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Metal", "code": "Metal" }, { "name": "Other", "code": "Other" }, { "name": "Plastic", "code": "Plastic" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RECWTRDISCHARGE", "type": "esriFieldTypeString", "alias": "Reclaimed Water Discharge", "length": 10, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R1588_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G6452FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1530_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "ssManholeInspection2020", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D1E9461B-EA37-453C-86EE-5193810E4962}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "Sewer Manhole Inspection Archive 2010 - 2016", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 10, "domain": null }, { "name": "STARTDATETIME", "type": "esriFieldTypeDate", "alias": "Start Date Time", "length": 8, "domain": null }, { "name": "WORKKEY", "type": "esriFieldTypeString", "alias": "Work Order #", "length": 50, "domain": null }, { "name": "PURPOSE", "type": "esriFieldTypeString", "alias": "Purpose of Inspection", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_Purposes", "description": "", "codedValues": [ { "name": "Manitenance Related", "code": "Manitenance Related" }, { "name": "Inflitration/Inflow Investigation", "code": "Inflitration/Inflow Investigation" }, { "name": "Post Rehabilitation Survey", "code": "Post Rehabilitation Survey" }, { "name": "Pre-Rehabilitation Survey", "code": "Pre-Rehabilitation Survey" }, { "name": "Pre-Acceptance", "code": "Pre-Acceptance" }, { "name": "Routine Assessment", "code": "Routine Assessment" }, { "name": "Capital Improvement Program Assessment", "code": "Capital Improvement Program Assessment" }, { "name": "Re-Inspection", "code": "Re-Inspection" }, { "name": "Not Known", "code": "Not Known" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GROUNDCONDITION", "type": "esriFieldTypeString", "alias": "Ground Condition", "length": 10, "domain": { "type": "codedValue", "name": "NASSCO_Weather", "description": "", "codedValues": [ { "name": "Damp", "code": "Damp" }, { "name": "Dry", "code": "Dry" }, { "name": "Heavy Rain", "code": "Heavy Rain" }, { "name": "Light Rain", "code": "Light Rain" }, { "name": "Saturated", "code": "Saturated" }, { "name": "Very Dry", "code": "Very Dry" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MANHOLELOCATION", "type": "esriFieldTypeString", "alias": "Manhole Location", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_Manlocation", "description": "", "codedValues": [ { "name": "Main Highway - Urban", "code": "Main Highway - Urban" }, { "name": "Main Highway - Suburban/Rural", "code": "Main Highway - Suburban/Rural" }, { "name": "Light Highway", "code": "Light Highway" }, { "name": "Easement/Right of Way", "code": "Easement/Right of Way" }, { "name": "Woods", "code": "Woods" }, { "name": "Sidewalk", "code": "Sidewalk" }, { "name": "Driveway", "code": "Driveway" }, { "name": "Parking Lot", "code": "Parking Lot" }, { "name": "Alley", "code": "Alley" }, { "name": "Ditch", "code": "Ditch" }, { "name": "Building", "code": "Building" }, { "name": "Creek", "code": "Creek" }, { "name": "Railway", "code": "Railway" }, { "name": "Airport", "code": "Airport" }, { "name": "Yard", "code": "Yard" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SURFACETYPE", "type": "esriFieldTypeString", "alias": "Surface Type", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_ManholeSurfaceType", "description": "", "codedValues": [ { "name": "Asphalt", "code": "Asphalt" }, { "name": "Concrete Collar", "code": "Concrete Collar" }, { "name": "Grass/Dirt", "code": "Grass/Dirt" }, { "name": "Gravel", "code": "Gravel" }, { "name": "Brick", "code": "Brick" }, { "name": "Concrete Pavement", "code": "Concrete Pavement" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RUNOFF", "type": "esriFieldTypeString", "alias": "Potential for Runoff", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Potential_Runoff", "description": "", "codedValues": [ { "name": "Inundated", "code": "Inundated" }, { "name": "None", "code": "None" }, { "name": "Ponding", "code": "Ponding" }, { "name": "Sheeting", "code": "Sheeting" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSSTATUS", "type": "esriFieldTypeString", "alias": "Inspection Status", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Inspection_Status", "description": "", "codedValues": [ { "name": "Buried or Marked", "code": "Buried or Marked" }, { "name": "In Traffic", "code": "In Traffic" }, { "name": "No Access No Found", "code": "No Access No Found" }, { "name": "Not Opened", "code": "Not Opened" }, { "name": "Remote Inspection", "code": "Remote Inspection" }, { "name": "Surchared/Debris", "code": "Surchared/Debris" }, { "name": "Surface Inspection", "code": "Surface Inspection" }, { "name": "Descent Inspection", "code": "Descent Inspection" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MHSURFALIGN", "type": "esriFieldTypeString", "alias": "Manhole Even with Surface", "length": 50, "domain": null }, { "name": "MHHEIGHT", "type": "esriFieldTypeDouble", "alias": "Inches Above or Below", "domain": null }, { "name": "COVERTYPE", "type": "esriFieldTypeString", "alias": "Cover Type", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_CoverType", "description": "", "codedValues": [ { "name": "Double Cover", "code": "Double Cover" }, { "name": "Lamp", "code": "Lamp" }, { "name": "Mascotte", "code": "Mascotte" }, { "name": "Oversized", "code": "Oversized" }, { "name": "Standard", "code": "Standard" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COVERSIZE", "type": "esriFieldTypeString", "alias": "Cover Size", "length": 5, "domain": null }, { "name": "COVERFIT", "type": "esriFieldTypeString", "alias": "Cover Rim Fit", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Cover_Frame_Fit", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Oversized", "code": "Oversized" }, { "name": "Rocks/Wobbles", "code": "Rocks/Wobbles" }, { "name": "Undersized", "code": "Undersized" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COVERCOND", "type": "esriFieldTypeString", "alias": "Cover Condition", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_CoverCondition", "description": "", "codedValues": [ { "name": "Sound", "code": "Sound" }, { "name": "Cracked", "code": "Cracked" }, { "name": "Broken", "code": "Broken" }, { "name": "Missing", "code": "Missing" }, { "name": "Corroded/Pitted", "code": "Corroded/Pitted" }, { "name": "Bolts Missing", "code": "Bolts Missing" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INVERTRIMDIST", "type": "esriFieldTypeString", "alias": "Invert Rim Distance (Feet to Nearest Tenth)", "length": 30, "domain": null }, { "name": "COVERCOND2", "type": "esriFieldTypeString", "alias": "Additional Cover Conditions", "length": 50, "domain": null }, { "name": "INSERTTYPE", "type": "esriFieldTypeString", "alias": "Cover Insert Type", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_InsertType", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Metal", "code": "Metal" }, { "name": "Other", "code": "Other" }, { "name": "Plastic", "code": "Plastic" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSERTCOND", "type": "esriFieldTypeString", "alias": "Insert Conditions", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_InsertCondition", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Sound", "code": "Sound" }, { "name": "Poorly Fitted", "code": "Poorly Fitted" }, { "name": "Cracked/Torn/Holes", "code": "Cracked/Torn/Holes" }, { "name": "Leaking", "code": "Leaking" }, { "name": "Insert Fell", "code": "Insert Fell" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSERTCOND2", "type": "esriFieldTypeString", "alias": "Additional Insert Conditions", "length": 50, "domain": null }, { "name": "SURCHARGE", "type": "esriFieldTypeString", "alias": "Evidence of Surcharge", "length": 5, "domain": { "type": "codedValue", "name": "Yes or No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SURCHARGEHEIGHT", "type": "esriFieldTypeString", "alias": "Height Surcharge from Invert", "length": 50, "domain": null }, { "name": "FRAMEADJ", "type": "esriFieldTypeString", "alias": "Adjustment Ring Type", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_FrameAdjustmentType", "description": "", "codedValues": [ { "name": "No Value", "code": "No Value" }, { "name": "Adjustable", "code": "Adjustable" }, { "name": "Solid", "code": "Solid" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ADJRINGCOND", "type": "esriFieldTypeString", "alias": "Adjustment Ring Condition", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_AdjustmentRingCondition", "description": "", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Broken", "code": "Broken" }, { "name": "Corroded/Pitted/Worn", "code": "Corroded/Pitted/Worn" }, { "name": "Cracked", "code": "Cracked" }, { "name": "Poor Installation", "code": "Poor Installation" }, { "name": "Sound", "code": "Sound" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ADJRINGCOND2", "type": "esriFieldTypeString", "alias": "Additional Frame Conditions", "length": 50, "domain": null }, { "name": "FRAMETYPE", "type": "esriFieldTypeString", "alias": "Frame Material", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_Materials", "description": "", "codedValues": [ { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Ductile Iron", "code": "Ductile Iron" }, { "name": "Plastic/Steel Composite", "code": "Plastic/Steel Composite" }, { "name": "Steel Pipe", "code": "Steel Pipe" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FRAMECOND", "type": "esriFieldTypeString", "alias": "Frame Condition", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_FrameCondition", "description": "", "codedValues": [ { "name": "Sound", "code": "Sound" }, { "name": "Cracked", "code": "Cracked" }, { "name": "Broken", "code": "Broken" }, { "name": "Missing", "code": "Missing" }, { "name": "Corroded/Pitted/Worn", "code": "Corroded/Pitted/Worn" }, { "name": "Coated", "code": "Coated" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FRAMECOND2", "type": "esriFieldTypeString", "alias": "Additional Frame Conditions", "length": 50, "domain": null }, { "name": "FRAMESEALCOND", "type": "esriFieldTypeString", "alias": "Frame to Manhole Seal", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_FrameSealCondition", "description": "", "codedValues": [ { "name": "Sound", "code": "Sound" }, { "name": "Cracked", "code": "Cracked" }, { "name": "Loose/Not Attached", "code": "Loose/Not Attached" }, { "name": "Offset", "code": "Offset" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FRAMEOFFSET", "type": "esriFieldTypeDouble", "alias": "Frame Offset", "domain": null }, { "name": "FRAMESEALCOND2", "type": "esriFieldTypeString", "alias": "Additional Seal Conditions", "length": 50, "domain": null }, { "name": "SEALINFLOW", "type": "esriFieldTypeString", "alias": "Frame Seal Inflow", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Inflow_Infiltration", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Infil Stained", "code": "Infil Stained" }, { "name": "Infil Weeper", "code": "Infil Weeper" }, { "name": "Infil Dripper", "code": "Infil Dripper" }, { "name": "Infil Runner", "code": "Infil Runner" }, { "name": "Infil Gusher", "code": "Infil Gusher" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHIMNEYTYPE", "type": "esriFieldTypeString", "alias": "Chimney Material", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_ChimneyMaterial", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Brick", "code": "Brick" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Concrete Pipe (non-reinforced)", "code": "Concrete Pipe (non-reinforced)" }, { "name": "Concrete Ring", "code": "Concrete Ring" }, { "name": "Ductile Iron Pipe", "code": "Ductile Iron Pipe" }, { "name": "Fiberglass Reinforced Pipe", "code": "Fiberglass Reinforced Pipe" }, { "name": "Glass Reinforced Cement", "code": "Glass Reinforced Cement" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHIMNEYLINETYPE", "type": "esriFieldTypeString", "alias": "Chimney Lining Material", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Linings", "description": "", "codedValues": [ { "name": "Bitumastic", "code": "Bitumastic" }, { "name": "Cementitious", "code": "Cementitious" }, { "name": "Cured in Place", "code": "Cured in Place" }, { "name": "Epoxy", "code": "Epoxy" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "None - No Coating", "code": "None - No Coating" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Polymer", "code": "Polymer" }, { "name": "Rubber", "code": "Rubber" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHIMNEYCOND", "type": "esriFieldTypeString", "alias": "Chimney Condition", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_ChimneyCondition", "description": "", "codedValues": [ { "name": "No Defects Observed", "code": "No Defects Observed" }, { "name": "Crack", "code": "Crack" }, { "name": "Fracture", "code": "Fracture" }, { "name": "Hole", "code": "Hole" }, { "name": "Brick - mortar missing", "code": "Brick - mortar missing" }, { "name": "Brick - displaced", "code": "Brick - displaced" }, { "name": "Brick - missing", "code": "Brick - missing" }, { "name": "Surface Damage - deterioration", "code": "Surface Damage - deterioration" }, { "name": "Surface Damage - rebar showing", "code": "Surface Damage - rebar showing" }, { "name": "Surface Damage - missing wall", "code": "Surface Damage - missing wall" }, { "name": "Liner/Coating - peeling/bulging", "code": "Liner/Coating - peeling/bulging" }, { "name": "Liner/Coating - detached", "code": "Liner/Coating - detached" }, { "name": "Deposits - encrustation", "code": "Deposits - encrustation" }, { "name": "Deposits - grease", "code": "Deposits - grease" }, { "name": "Deposits - ragging", "code": "Deposits - ragging" }, { "name": "Roots - fine", "code": "Roots - fine" }, { "name": "Roots - medium", "code": "Roots - medium" }, { "name": "Roots - ball", "code": "Roots - ball" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHIMNEYINFILTRATE", "type": "esriFieldTypeString", "alias": "Chimney Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Inflow_Infiltration", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Infil Stained", "code": "Infil Stained" }, { "name": "Infil Weeper", "code": "Infil Weeper" }, { "name": "Infil Dripper", "code": "Infil Dripper" }, { "name": "Infil Runner", "code": "Infil Runner" }, { "name": "Infil Gusher", "code": "Infil Gusher" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONEMATERIAL", "type": "esriFieldTypeString", "alias": "Cone Material", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_ConeMaterial", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Brick", "code": "Brick" }, { "name": "Fiberglass Reinforced Pipe", "code": "Fiberglass Reinforced Pipe" }, { "name": "Glass Reinforced Pipe", "code": "Glass Reinforced Pipe" }, { "name": "Reinforced Concrete Pipe", "code": "Reinforced Concrete Pipe" }, { "name": "Segmented Block", "code": "Segmented Block" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Brick/Concrete", "code": "Brick/Concrete" }, { "name": "Lined/Coating", "code": "Lined/Coating" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONETYPE", "type": "esriFieldTypeString", "alias": "Cone Type", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Cone_Types", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Conical Centered", "code": "Conical Centered" }, { "name": "Conical Off Centered", "code": "Conical Off Centered" }, { "name": "Flattop", "code": "Flattop" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONELINETYPE", "type": "esriFieldTypeString", "alias": "Cone Lining Material", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Linings", "description": "", "codedValues": [ { "name": "Bitumastic", "code": "Bitumastic" }, { "name": "Cementitious", "code": "Cementitious" }, { "name": "Cured in Place", "code": "Cured in Place" }, { "name": "Epoxy", "code": "Epoxy" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "None - No Coating", "code": "None - No Coating" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Polymer", "code": "Polymer" }, { "name": "Rubber", "code": "Rubber" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONECOND", "type": "esriFieldTypeString", "alias": "Cone Condition", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_ConeCondition", "description": "", "codedValues": [ { "name": "No Defects Observed", "code": "No Defects Observed" }, { "name": "Crack", "code": "Crack" }, { "name": "Fracture", "code": "Fracture" }, { "name": "Hole", "code": "Hole" }, { "name": "Brick - mortar missing", "code": "Brick - mortar missing" }, { "name": "Brick - displaced", "code": "Brick - displaced" }, { "name": "Brick - missing", "code": "Brick - missing" }, { "name": "Surface Damage - deterioration", "code": "Surface Damage - deterioration" }, { "name": "Surface Damage - rebar showing", "code": "Surface Damage - rebar showing" }, { "name": "Surface Damage - missing wall", "code": "Surface Damage - missing wall" }, { "name": "Liner/Coating - peeling/bulging", "code": "Liner/Coating - peeling/bulging" }, { "name": "Liner/Coating - detached", "code": "Liner/Coating - detached" }, { "name": "Deposits - encrustation", "code": "Deposits - encrustation" }, { "name": "Deposits - grease", "code": "Deposits - grease" }, { "name": "Deposits - ragging", "code": "Deposits - ragging" }, { "name": "Roots - fine", "code": "Roots - fine" }, { "name": "Roots - medium", "code": "Roots - medium" }, { "name": "Roots - ball", "code": "Roots - ball" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONEINFILTRATE", "type": "esriFieldTypeString", "alias": "Cone Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Inflow_Infiltration", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Infil Stained", "code": "Infil Stained" }, { "name": "Infil Weeper", "code": "Infil Weeper" }, { "name": "Infil Dripper", "code": "Infil Dripper" }, { "name": "Infil Runner", "code": "Infil Runner" }, { "name": "Infil Gusher", "code": "Infil Gusher" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BARRELTYPE", "type": "esriFieldTypeString", "alias": "Wall Material", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_WallMaterial", "description": "", "codedValues": [ { "name": "Brick", "code": "Brick" }, { "name": "Fiberglass Reinforced Pipe", "code": "Fiberglass Reinforced Pipe" }, { "name": "Glass Reinforced Cement", "code": "Glass Reinforced Cement" }, { "name": "Reinforced Concrete Pipe", "code": "Reinforced Concrete Pipe" }, { "name": "Segmented Block", "code": "Segmented Block" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Brick/Concrete", "code": "Brick/Concrete" }, { "name": "Lined/Coating", "code": "Lined/Coating" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BARRELLINETYPE", "type": "esriFieldTypeString", "alias": "Barrel Lining Material", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Linings", "description": "", "codedValues": [ { "name": "Bitumastic", "code": "Bitumastic" }, { "name": "Cementitious", "code": "Cementitious" }, { "name": "Cured in Place", "code": "Cured in Place" }, { "name": "Epoxy", "code": "Epoxy" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "None - No Coating", "code": "None - No Coating" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Polymer", "code": "Polymer" }, { "name": "Rubber", "code": "Rubber" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BARRELCOND", "type": "esriFieldTypeString", "alias": "Wall Condition", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_WallCondition", "description": "", "codedValues": [ { "name": "No Defects Observed", "code": "No Defects Observed" }, { "name": "Crack", "code": "Crack" }, { "name": "Fracture", "code": "Fracture" }, { "name": "Hole", "code": "Hole" }, { "name": "Brick - mortar missing", "code": "Brick - mortar missing" }, { "name": "Brick - displaced", "code": "Brick - displaced" }, { "name": "Brick - missing", "code": "Brick - missing" }, { "name": "Surface Damage - deterioration", "code": "Surface Damage - deterioration" }, { "name": "Surface Damage - rebar showing", "code": "Surface Damage - rebar showing" }, { "name": "Surface Damage - missing wall", "code": "Surface Damage - missing wall" }, { "name": "Liner/Coating - peeling/bulging", "code": "Liner/Coating - peeling/bulging" }, { "name": "Liner/Coating - detached", "code": "Liner/Coating - detached" }, { "name": "Deposits - encrustation", "code": "Deposits - encrustation" }, { "name": "Deposits - grease", "code": "Deposits - grease" }, { "name": "Deposits - ragging", "code": "Deposits - ragging" }, { "name": "Roots - fine", "code": "Roots - fine" }, { "name": "Roots - medium", "code": "Roots - medium" }, { "name": "Roots - ball", "code": "Roots - ball" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BARRELINFILTRATE", "type": "esriFieldTypeString", "alias": "Wall Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Inflow_Infiltration", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Infil Stained", "code": "Infil Stained" }, { "name": "Infil Weeper", "code": "Infil Weeper" }, { "name": "Infil Dripper", "code": "Infil Dripper" }, { "name": "Infil Runner", "code": "Infil Runner" }, { "name": "Infil Gusher", "code": "Infil Gusher" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BENCHTYPE", "type": "esriFieldTypeString", "alias": "Bench Material", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_BenchMaterial", "description": "", "codedValues": [ { "name": "Brick", "code": "Brick" }, { "name": "Vitirified Clay Pipe", "code": "Vitirified Clay Pipe" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Lined/Coating", "code": "Lined/Coating" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BENCHLINETYPE", "type": "esriFieldTypeString", "alias": "Bench Lining Material", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Linings", "description": "", "codedValues": [ { "name": "Bitumastic", "code": "Bitumastic" }, { "name": "Cementitious", "code": "Cementitious" }, { "name": "Cured in Place", "code": "Cured in Place" }, { "name": "Epoxy", "code": "Epoxy" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "None - No Coating", "code": "None - No Coating" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Polymer", "code": "Polymer" }, { "name": "Rubber", "code": "Rubber" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BENCHCOND", "type": "esriFieldTypeString", "alias": "Bench Condition", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_BenchCondition", "description": "", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BENCHDEPOSITS", "type": "esriFieldTypeString", "alias": "Bench Deposits", "length": 50, "domain": { "type": "codedValue", "name": "ssBenchDeposits", "description": "", "codedValues": [ { "name": "Deposits - encrustation", "code": "Deposits - encrustation" }, { "name": "Deposits - grease", "code": "Deposits - grease" }, { "name": "Deposits settled- ragging/sanitary", "code": "Deposits settled- ragging/sanitary" }, { "name": "Deposits settled- fine/sand", "code": "Deposits settled- fine/sand" }, { "name": "Deposits settled- gravel/rocks/brick", "code": "Deposits settled- gravel/rocks/brick" }, { "name": "Deposits settled- hard/compacted", "code": "Deposits settled- hard/compacted" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" }, { "name": "Sand", "code": "Sand" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BENCHDEPOSITSDEPTH", "type": "esriFieldTypeDouble", "alias": "Depth of Deposits", "domain": null }, { "name": "BENCHINFILTRATE", "type": "esriFieldTypeString", "alias": "Bench Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Inflow_Infiltration", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Infil Stained", "code": "Infil Stained" }, { "name": "Infil Weeper", "code": "Infil Weeper" }, { "name": "Infil Dripper", "code": "Infil Dripper" }, { "name": "Infil Runner", "code": "Infil Runner" }, { "name": "Infil Gusher", "code": "Infil Gusher" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNELTYPE", "type": "esriFieldTypeString", "alias": "Channel Material", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_ChannelType", "description": "", "codedValues": [ { "name": "Brick", "code": "Brick" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Ductile Iron", "code": "Ductile Iron" }, { "name": "Polyvinyl Chloride", "code": "Polyvinyl Chloride" }, { "name": "Reinforced Concrete Pipe", "code": "Reinforced Concrete Pipe" }, { "name": "Steel Pipe", "code": "Steel Pipe" }, { "name": "Vitrified Clay Pipe", "code": "Vitrified Clay Pipe" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Lined/Coating", "code": "Lined/Coating" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNELLINETYPE", "type": "esriFieldTypeString", "alias": "Channel Lining Material", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Linings", "description": "", "codedValues": [ { "name": "Bitumastic", "code": "Bitumastic" }, { "name": "Cementitious", "code": "Cementitious" }, { "name": "Cured in Place", "code": "Cured in Place" }, { "name": "Epoxy", "code": "Epoxy" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "None - No Coating", "code": "None - No Coating" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Polymer", "code": "Polymer" }, { "name": "Rubber", "code": "Rubber" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNELCOND", "type": "esriFieldTypeString", "alias": "Channel Condition", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_ChannelCondition", "description": "", "codedValues": [ { "name": "No Defects Observed", "code": "No Defects Observed" }, { "name": "Crack", "code": "Crack" }, { "name": "Fracture", "code": "Fracture" }, { "name": "Hole", "code": "Hole" }, { "name": "Brick - mortar missing", "code": "Brick - mortar missing" }, { "name": "Brick - displaced", "code": "Brick - displaced" }, { "name": "Brick - missing", "code": "Brick - missing" }, { "name": "Liner/Coating - peeling/bulging", "code": "Liner/Coating - peeling/bulging" }, { "name": "Liner/Coating - detached", "code": "Liner/Coating - detached" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNELDEPOSITS", "type": "esriFieldTypeString", "alias": "Flow Channel Deposits", "length": 50, "domain": { "type": "codedValue", "name": "ssChannelDeposits", "description": "", "codedValues": [ { "name": "Deposits - encrustation", "code": "Deposits - encrustation" }, { "name": "Deposits - grease", "code": "Deposits - grease" }, { "name": "Deposits settled - ragging/sanitary", "code": "Deposits settled - ragging/sanitary" }, { "name": "Deposits settled - fine/sand", "code": "Deposits settled - fine/sand" }, { "name": "Deposits settled - gravel/rocks/brick", "code": "Deposits settled - gravel/rocks/brick" }, { "name": "Deposits settled - hard/compacted", "code": "Deposits settled - hard/compacted" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" }, { "name": "Sand", "code": "Sand" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNELDEPOSITSDEPTH", "type": "esriFieldTypeDouble", "alias": "Depth of Deposits", "domain": null }, { "name": "CHANNELINFILTRATE", "type": "esriFieldTypeString", "alias": "Channel Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Inflow_Infiltration", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Infil Stained", "code": "Infil Stained" }, { "name": "Infil Weeper", "code": "Infil Weeper" }, { "name": "Infil Dripper", "code": "Infil Dripper" }, { "name": "Infil Runner", "code": "Infil Runner" }, { "name": "Infil Gusher", "code": "Infil Gusher" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SEALCOND", "type": "esriFieldTypeString", "alias": "Pipe Seal Condition", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_PipeSealCond", "description": "", "codedValues": [ { "name": "No Seal", "code": "No Seal" }, { "name": "Sound", "code": "Sound" }, { "name": "Sand/Water Infiltration", "code": "Sand/Water Infiltration" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PROJECT2", "type": "esriFieldTypeString", "alias": "Additional Project Information", "length": 50, "domain": null }, { "name": "WORKREQUEST", "type": "esriFieldTypeString", "alias": "Work Request Submitted", "length": 50, "domain": { "type": "codedValue", "name": "Yes or No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PROJECT", "type": "esriFieldTypeString", "alias": "Purpose of Work Request", "length": 50, "domain": { "type": "codedValue", "name": "ssWorkRequest", "description": "", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Cleaning", "code": "Cleaning" }, { "name": "Rehabilitation", "code": "Rehabilitation" }, { "name": "Replacement", "code": "Replacement" }, { "name": "Access", "code": "Access" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMPINSPECT", "type": "esriFieldTypeString", "alias": "Inspection Complete", "length": 50, "domain": null }, { "name": "ID", "type": "esriFieldTypeString", "alias": "Legacy Access ID", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "ENDDATETIME", "type": "esriFieldTypeDate", "alias": "ENDDATETIME", "length": 8, "domain": null }, { "name": "INSPECTID", "type": "esriFieldTypeString", "alias": "INSPECTID", "length": 10, "domain": null }, { "name": "UFV", "type": "esriFieldTypeString", "alias": "UFV", "length": 50, "domain": null }, { "name": "CANNOTLOCATE", "type": "esriFieldTypeString", "alias": "CANNOTLOCATE", "length": 15, "domain": null }, { "name": "UFVCOMMENTS", "type": "esriFieldTypeString", "alias": "UFVCOMMENTS", "length": 150, "domain": null } ], "indexes": [ { "name": "R716_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_716", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_3607_FACILIT", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "ssManholeArchive", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BE1FA369-F68F-46F4-B938-AD86F64EC55B}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "Sewer Manhole Inspection Archive 2010 - 2016__ATTACH", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null } ], "indexes": [ { "name": "R717_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_717", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_3608_REL_GLO", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "Sewer Manhole Inspection Archive 2016 - 2020", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 10, "domain": null }, { "name": "STARTDATETIME", "type": "esriFieldTypeDate", "alias": "Start Date Time", "length": 8, "domain": null }, { "name": "WORKKEY", "type": "esriFieldTypeString", "alias": "Work Order #", "length": 50, "domain": null }, { "name": "PURPOSE", "type": "esriFieldTypeString", "alias": "Purpose of Inspection", "length": 50, "domain": null }, { "name": "GROUNDCONDITION", "type": "esriFieldTypeString", "alias": "Ground Condition", "length": 10, "domain": { "type": "codedValue", "name": "NASSCO_Weather", "description": "", "codedValues": [ { "name": "Damp", "code": "Damp" }, { "name": "Dry", "code": "Dry" }, { "name": "Heavy Rain", "code": "Heavy Rain" }, { "name": "Light Rain", "code": "Light Rain" }, { "name": "Saturated", "code": "Saturated" }, { "name": "Very Dry", "code": "Very Dry" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MANHOLELOCATION", "type": "esriFieldTypeString", "alias": "Manhole Location", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_Manlocation", "description": "", "codedValues": [ { "name": "Main Highway - Urban", "code": "Main Highway - Urban" }, { "name": "Main Highway - Suburban/Rural", "code": "Main Highway - Suburban/Rural" }, { "name": "Light Highway", "code": "Light Highway" }, { "name": "Easement/Right of Way", "code": "Easement/Right of Way" }, { "name": "Woods", "code": "Woods" }, { "name": "Sidewalk", "code": "Sidewalk" }, { "name": "Driveway", "code": "Driveway" }, { "name": "Parking Lot", "code": "Parking Lot" }, { "name": "Alley", "code": "Alley" }, { "name": "Ditch", "code": "Ditch" }, { "name": "Building", "code": "Building" }, { "name": "Creek", "code": "Creek" }, { "name": "Railway", "code": "Railway" }, { "name": "Airport", "code": "Airport" }, { "name": "Yard", "code": "Yard" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SURFACETYPE", "type": "esriFieldTypeString", "alias": "Surface Type", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_ManholeSurfaceType", "description": "", "codedValues": [ { "name": "Asphalt", "code": "Asphalt" }, { "name": "Concrete Collar", "code": "Concrete Collar" }, { "name": "Grass/Dirt", "code": "Grass/Dirt" }, { "name": "Gravel", "code": "Gravel" }, { "name": "Brick", "code": "Brick" }, { "name": "Concrete Pavement", "code": "Concrete Pavement" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RUNOFF", "type": "esriFieldTypeString", "alias": "Potential for Runoff", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Potential_Runoff", "description": "", "codedValues": [ { "name": "Inundated", "code": "Inundated" }, { "name": "None", "code": "None" }, { "name": "Ponding", "code": "Ponding" }, { "name": "Sheeting", "code": "Sheeting" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSSTATUS", "type": "esriFieldTypeString", "alias": "Inspection Status", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Inspection_Status", "description": "", "codedValues": [ { "name": "Buried or Marked", "code": "Buried or Marked" }, { "name": "In Traffic", "code": "In Traffic" }, { "name": "No Access No Found", "code": "No Access No Found" }, { "name": "Not Opened", "code": "Not Opened" }, { "name": "Remote Inspection", "code": "Remote Inspection" }, { "name": "Surchared/Debris", "code": "Surchared/Debris" }, { "name": "Surface Inspection", "code": "Surface Inspection" }, { "name": "Descent Inspection", "code": "Descent Inspection" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MHSURFALIGN", "type": "esriFieldTypeString", "alias": "Manhole Even with Surface", "length": 50, "domain": null }, { "name": "MHHEIGHT", "type": "esriFieldTypeDouble", "alias": "Inches Above or Below", "domain": null }, { "name": "COVERTYPE", "type": "esriFieldTypeString", "alias": "Cover Type", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_CoverType", "description": "", "codedValues": [ { "name": "Double Cover", "code": "Double Cover" }, { "name": "Lamp", "code": "Lamp" }, { "name": "Mascotte", "code": "Mascotte" }, { "name": "Oversized", "code": "Oversized" }, { "name": "Standard", "code": "Standard" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COVERSIZE", "type": "esriFieldTypeString", "alias": "Cover Size", "length": 5, "domain": null }, { "name": "COVERFIT", "type": "esriFieldTypeString", "alias": "Cover Rim Fit", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Cover_Frame_Fit", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Oversized", "code": "Oversized" }, { "name": "Rocks/Wobbles", "code": "Rocks/Wobbles" }, { "name": "Undersized", "code": "Undersized" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COVERCOND", "type": "esriFieldTypeString", "alias": "Cover Condition", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_CoverCondition", "description": "", "codedValues": [ { "name": "Sound", "code": "Sound" }, { "name": "Cracked", "code": "Cracked" }, { "name": "Broken", "code": "Broken" }, { "name": "Missing", "code": "Missing" }, { "name": "Corroded/Pitted", "code": "Corroded/Pitted" }, { "name": "Bolts Missing", "code": "Bolts Missing" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INVERTRIMDIST", "type": "esriFieldTypeString", "alias": "Invert Rim Distance (Feet to Nearest Tenth)", "length": 30, "domain": null }, { "name": "COVERCOND2", "type": "esriFieldTypeString", "alias": "Additional Cover Conditions", "length": 50, "domain": null }, { "name": "INSERTTYPE", "type": "esriFieldTypeString", "alias": "Rain Dish Identifier", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_InsertType", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Metal", "code": "Metal" }, { "name": "Other", "code": "Other" }, { "name": "Plastic", "code": "Plastic" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSERTCOND", "type": "esriFieldTypeString", "alias": "Insert Conditions", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_InsertCondition", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Sound", "code": "Sound" }, { "name": "Poorly Fitted", "code": "Poorly Fitted" }, { "name": "Cracked/Torn/Holes", "code": "Cracked/Torn/Holes" }, { "name": "Leaking", "code": "Leaking" }, { "name": "Insert Fell", "code": "Insert Fell" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSERTCOND2", "type": "esriFieldTypeString", "alias": "Additional Insert Conditions", "length": 50, "domain": null }, { "name": "SURCHARGE", "type": "esriFieldTypeString", "alias": "Evidence of Surcharge", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SURCHARGEHEIGHT", "type": "esriFieldTypeString", "alias": "Height Surcharge from Invert", "length": 50, "domain": null }, { "name": "FRAMEADJ", "type": "esriFieldTypeString", "alias": "Adjustment Ring Type", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_FrameAdjustmentType", "description": "", "codedValues": [ { "name": "No Value", "code": "No Value" }, { "name": "Adjustable", "code": "Adjustable" }, { "name": "Solid", "code": "Solid" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ADJRINGCOND", "type": "esriFieldTypeString", "alias": "Adjustment Ring Condition", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_AdjustmentRingCondition", "description": "", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Broken", "code": "Broken" }, { "name": "Corroded/Pitted/Worn", "code": "Corroded/Pitted/Worn" }, { "name": "Cracked", "code": "Cracked" }, { "name": "Poor Installation", "code": "Poor Installation" }, { "name": "Sound", "code": "Sound" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ADJRINGCOND2", "type": "esriFieldTypeString", "alias": "Additional Ring Conditions", "length": 50, "domain": null }, { "name": "FRAMETYPE", "type": "esriFieldTypeString", "alias": "Frame Material", "length": 50, "domain": null }, { "name": "FRAMECOND", "type": "esriFieldTypeString", "alias": "Frame Condition", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_FrameCondition", "description": "", "codedValues": [ { "name": "Sound", "code": "Sound" }, { "name": "Cracked", "code": "Cracked" }, { "name": "Broken", "code": "Broken" }, { "name": "Missing", "code": "Missing" }, { "name": "Corroded/Pitted/Worn", "code": "Corroded/Pitted/Worn" }, { "name": "Coated", "code": "Coated" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FRAMECOND2", "type": "esriFieldTypeString", "alias": "Additional Frame Conditions", "length": 50, "domain": null }, { "name": "FRAMESEALCOND", "type": "esriFieldTypeString", "alias": "Frame to Manhole Seal", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_FrameSealCondition", "description": "", "codedValues": [ { "name": "Sound", "code": "Sound" }, { "name": "Cracked", "code": "Cracked" }, { "name": "Loose/Not Attached", "code": "Loose/Not Attached" }, { "name": "Offset", "code": "Offset" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FRAMEOFFSET", "type": "esriFieldTypeDouble", "alias": "Frame Offset", "domain": null }, { "name": "FRAMESEALCOND2", "type": "esriFieldTypeString", "alias": "Additional Seal Conditions", "length": 50, "domain": null }, { "name": "SEALINFLOW", "type": "esriFieldTypeString", "alias": "Frame Seal Inflow", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Inflow_Infiltration", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Infil Stained", "code": "Infil Stained" }, { "name": "Infil Weeper", "code": "Infil Weeper" }, { "name": "Infil Dripper", "code": "Infil Dripper" }, { "name": "Infil Runner", "code": "Infil Runner" }, { "name": "Infil Gusher", "code": "Infil Gusher" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHIMNEYTYPE", "type": "esriFieldTypeString", "alias": "Chimney Material", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_ChimneyMaterial", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Brick", "code": "Brick" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Concrete Pipe (non-reinforced)", "code": "Concrete Pipe (non-reinforced)" }, { "name": "Concrete Ring", "code": "Concrete Ring" }, { "name": "Ductile Iron Pipe", "code": "Ductile Iron Pipe" }, { "name": "Fiberglass Reinforced Pipe", "code": "Fiberglass Reinforced Pipe" }, { "name": "Glass Reinforced Cement", "code": "Glass Reinforced Cement" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHIMNEYLINETYPE", "type": "esriFieldTypeString", "alias": "Chimney Lining Material", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Linings", "description": "", "codedValues": [ { "name": "Bitumastic", "code": "Bitumastic" }, { "name": "Cementitious", "code": "Cementitious" }, { "name": "Cured in Place", "code": "Cured in Place" }, { "name": "Epoxy", "code": "Epoxy" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "None - No Coating", "code": "None - No Coating" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Polymer", "code": "Polymer" }, { "name": "Rubber", "code": "Rubber" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHIMNEYCOND", "type": "esriFieldTypeString", "alias": "Chimney Condition", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_ChimneyCondition", "description": "", "codedValues": [ { "name": "No Defects Observed", "code": "No Defects Observed" }, { "name": "Crack", "code": "Crack" }, { "name": "Fracture", "code": "Fracture" }, { "name": "Hole", "code": "Hole" }, { "name": "Brick - mortar missing", "code": "Brick - mortar missing" }, { "name": "Brick - displaced", "code": "Brick - displaced" }, { "name": "Brick - missing", "code": "Brick - missing" }, { "name": "Surface Damage - deterioration", "code": "Surface Damage - deterioration" }, { "name": "Surface Damage - rebar showing", "code": "Surface Damage - rebar showing" }, { "name": "Surface Damage - missing wall", "code": "Surface Damage - missing wall" }, { "name": "Liner/Coating - peeling/bulging", "code": "Liner/Coating - peeling/bulging" }, { "name": "Liner/Coating - detached", "code": "Liner/Coating - detached" }, { "name": "Deposits - encrustation", "code": "Deposits - encrustation" }, { "name": "Deposits - grease", "code": "Deposits - grease" }, { "name": "Deposits - ragging", "code": "Deposits - ragging" }, { "name": "Roots - fine", "code": "Roots - fine" }, { "name": "Roots - medium", "code": "Roots - medium" }, { "name": "Roots - ball", "code": "Roots - ball" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHIMNEYINFILTRATE", "type": "esriFieldTypeString", "alias": "Chimney Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Inflow_Infiltration", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Infil Stained", "code": "Infil Stained" }, { "name": "Infil Weeper", "code": "Infil Weeper" }, { "name": "Infil Dripper", "code": "Infil Dripper" }, { "name": "Infil Runner", "code": "Infil Runner" }, { "name": "Infil Gusher", "code": "Infil Gusher" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONEMATERIAL", "type": "esriFieldTypeString", "alias": "Cone Material", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_ConeMaterial", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Brick", "code": "Brick" }, { "name": "Fiberglass Reinforced Pipe", "code": "Fiberglass Reinforced Pipe" }, { "name": "Glass Reinforced Pipe", "code": "Glass Reinforced Pipe" }, { "name": "Reinforced Concrete Pipe", "code": "Reinforced Concrete Pipe" }, { "name": "Segmented Block", "code": "Segmented Block" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Brick/Concrete", "code": "Brick/Concrete" }, { "name": "Lined/Coating", "code": "Lined/Coating" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONETYPE", "type": "esriFieldTypeString", "alias": "Cone Type", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Cone_Types", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Conical Centered", "code": "Conical Centered" }, { "name": "Conical Off Centered", "code": "Conical Off Centered" }, { "name": "Flattop", "code": "Flattop" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONELINETYPE", "type": "esriFieldTypeString", "alias": "Cone Lining Material", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Linings", "description": "", "codedValues": [ { "name": "Bitumastic", "code": "Bitumastic" }, { "name": "Cementitious", "code": "Cementitious" }, { "name": "Cured in Place", "code": "Cured in Place" }, { "name": "Epoxy", "code": "Epoxy" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "None - No Coating", "code": "None - No Coating" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Polymer", "code": "Polymer" }, { "name": "Rubber", "code": "Rubber" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONECOND", "type": "esriFieldTypeString", "alias": "Cone Condition", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_ConeCondition", "description": "", "codedValues": [ { "name": "No Defects Observed", "code": "No Defects Observed" }, { "name": "Crack", "code": "Crack" }, { "name": "Fracture", "code": "Fracture" }, { "name": "Hole", "code": "Hole" }, { "name": "Brick - mortar missing", "code": "Brick - mortar missing" }, { "name": "Brick - displaced", "code": "Brick - displaced" }, { "name": "Brick - missing", "code": "Brick - missing" }, { "name": "Surface Damage - deterioration", "code": "Surface Damage - deterioration" }, { "name": "Surface Damage - rebar showing", "code": "Surface Damage - rebar showing" }, { "name": "Surface Damage - missing wall", "code": "Surface Damage - missing wall" }, { "name": "Liner/Coating - peeling/bulging", "code": "Liner/Coating - peeling/bulging" }, { "name": "Liner/Coating - detached", "code": "Liner/Coating - detached" }, { "name": "Deposits - encrustation", "code": "Deposits - encrustation" }, { "name": "Deposits - grease", "code": "Deposits - grease" }, { "name": "Deposits - ragging", "code": "Deposits - ragging" }, { "name": "Roots - fine", "code": "Roots - fine" }, { "name": "Roots - medium", "code": "Roots - medium" }, { "name": "Roots - ball", "code": "Roots - ball" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONEINFILTRATE", "type": "esriFieldTypeString", "alias": "Cone Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Inflow_Infiltration", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Infil Stained", "code": "Infil Stained" }, { "name": "Infil Weeper", "code": "Infil Weeper" }, { "name": "Infil Dripper", "code": "Infil Dripper" }, { "name": "Infil Runner", "code": "Infil Runner" }, { "name": "Infil Gusher", "code": "Infil Gusher" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BARRELTYPE", "type": "esriFieldTypeString", "alias": "Wall Material", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_WallMaterial", "description": "", "codedValues": [ { "name": "Brick", "code": "Brick" }, { "name": "Fiberglass Reinforced Pipe", "code": "Fiberglass Reinforced Pipe" }, { "name": "Glass Reinforced Cement", "code": "Glass Reinforced Cement" }, { "name": "Reinforced Concrete Pipe", "code": "Reinforced Concrete Pipe" }, { "name": "Segmented Block", "code": "Segmented Block" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Brick/Concrete", "code": "Brick/Concrete" }, { "name": "Lined/Coating", "code": "Lined/Coating" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BARRELLINETYPE", "type": "esriFieldTypeString", "alias": "Wall Lining Material", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Linings", "description": "", "codedValues": [ { "name": "Bitumastic", "code": "Bitumastic" }, { "name": "Cementitious", "code": "Cementitious" }, { "name": "Cured in Place", "code": "Cured in Place" }, { "name": "Epoxy", "code": "Epoxy" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "None - No Coating", "code": "None - No Coating" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Polymer", "code": "Polymer" }, { "name": "Rubber", "code": "Rubber" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BARRELCOND", "type": "esriFieldTypeString", "alias": "Wall Condition", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_WallCondition", "description": "", "codedValues": [ { "name": "No Defects Observed", "code": "No Defects Observed" }, { "name": "Crack", "code": "Crack" }, { "name": "Fracture", "code": "Fracture" }, { "name": "Hole", "code": "Hole" }, { "name": "Brick - mortar missing", "code": "Brick - mortar missing" }, { "name": "Brick - displaced", "code": "Brick - displaced" }, { "name": "Brick - missing", "code": "Brick - missing" }, { "name": "Surface Damage - deterioration", "code": "Surface Damage - deterioration" }, { "name": "Surface Damage - rebar showing", "code": "Surface Damage - rebar showing" }, { "name": "Surface Damage - missing wall", "code": "Surface Damage - missing wall" }, { "name": "Liner/Coating - peeling/bulging", "code": "Liner/Coating - peeling/bulging" }, { "name": "Liner/Coating - detached", "code": "Liner/Coating - detached" }, { "name": "Deposits - encrustation", "code": "Deposits - encrustation" }, { "name": "Deposits - grease", "code": "Deposits - grease" }, { "name": "Deposits - ragging", "code": "Deposits - ragging" }, { "name": "Roots - fine", "code": "Roots - fine" }, { "name": "Roots - medium", "code": "Roots - medium" }, { "name": "Roots - ball", "code": "Roots - ball" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BARRELINFILTRATE", "type": "esriFieldTypeString", "alias": "Wall Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Inflow_Infiltration", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Infil Stained", "code": "Infil Stained" }, { "name": "Infil Weeper", "code": "Infil Weeper" }, { "name": "Infil Dripper", "code": "Infil Dripper" }, { "name": "Infil Runner", "code": "Infil Runner" }, { "name": "Infil Gusher", "code": "Infil Gusher" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BENCHTYPE", "type": "esriFieldTypeString", "alias": "Bench Material", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_BenchMaterial", "description": "", "codedValues": [ { "name": "Brick", "code": "Brick" }, { "name": "Vitirified Clay Pipe", "code": "Vitirified Clay Pipe" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Lined/Coating", "code": "Lined/Coating" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BENCHLINETYPE", "type": "esriFieldTypeString", "alias": "Bench Lining Material", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Linings", "description": "", "codedValues": [ { "name": "Bitumastic", "code": "Bitumastic" }, { "name": "Cementitious", "code": "Cementitious" }, { "name": "Cured in Place", "code": "Cured in Place" }, { "name": "Epoxy", "code": "Epoxy" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "None - No Coating", "code": "None - No Coating" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Polymer", "code": "Polymer" }, { "name": "Rubber", "code": "Rubber" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BENCHCOND", "type": "esriFieldTypeString", "alias": "Bench Condition", "length": 50, "domain": null }, { "name": "BENCHDEPOSITS", "type": "esriFieldTypeString", "alias": "Bench Deposits", "length": 50, "domain": { "type": "codedValue", "name": "ssBenchDeposits", "description": "", "codedValues": [ { "name": "Deposits - encrustation", "code": "Deposits - encrustation" }, { "name": "Deposits - grease", "code": "Deposits - grease" }, { "name": "Deposits settled- ragging/sanitary", "code": "Deposits settled- ragging/sanitary" }, { "name": "Deposits settled- fine/sand", "code": "Deposits settled- fine/sand" }, { "name": "Deposits settled- gravel/rocks/brick", "code": "Deposits settled- gravel/rocks/brick" }, { "name": "Deposits settled- hard/compacted", "code": "Deposits settled- hard/compacted" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" }, { "name": "Sand", "code": "Sand" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BENCHDEPOSITSDEPTH", "type": "esriFieldTypeDouble", "alias": "Depth of Deposits", "domain": null }, { "name": "BENCHINFILTRATE", "type": "esriFieldTypeString", "alias": "Bench Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Inflow_Infiltration", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Infil Stained", "code": "Infil Stained" }, { "name": "Infil Weeper", "code": "Infil Weeper" }, { "name": "Infil Dripper", "code": "Infil Dripper" }, { "name": "Infil Runner", "code": "Infil Runner" }, { "name": "Infil Gusher", "code": "Infil Gusher" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNELTYPE", "type": "esriFieldTypeString", "alias": "Channel Material", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_ChannelType", "description": "", "codedValues": [ { "name": "Brick", "code": "Brick" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Ductile Iron", "code": "Ductile Iron" }, { "name": "Polyvinyl Chloride", "code": "Polyvinyl Chloride" }, { "name": "Reinforced Concrete Pipe", "code": "Reinforced Concrete Pipe" }, { "name": "Steel Pipe", "code": "Steel Pipe" }, { "name": "Vitrified Clay Pipe", "code": "Vitrified Clay Pipe" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Lined/Coating", "code": "Lined/Coating" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNELLINETYPE", "type": "esriFieldTypeString", "alias": "Channel Lining Material", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Linings", "description": "", "codedValues": [ { "name": "Bitumastic", "code": "Bitumastic" }, { "name": "Cementitious", "code": "Cementitious" }, { "name": "Cured in Place", "code": "Cured in Place" }, { "name": "Epoxy", "code": "Epoxy" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "None - No Coating", "code": "None - No Coating" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Polymer", "code": "Polymer" }, { "name": "Rubber", "code": "Rubber" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNELCOND", "type": "esriFieldTypeString", "alias": "Channel Condition", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_ChannelCondition", "description": "", "codedValues": [ { "name": "No Defects Observed", "code": "No Defects Observed" }, { "name": "Crack", "code": "Crack" }, { "name": "Fracture", "code": "Fracture" }, { "name": "Hole", "code": "Hole" }, { "name": "Brick - mortar missing", "code": "Brick - mortar missing" }, { "name": "Brick - displaced", "code": "Brick - displaced" }, { "name": "Brick - missing", "code": "Brick - missing" }, { "name": "Liner/Coating - peeling/bulging", "code": "Liner/Coating - peeling/bulging" }, { "name": "Liner/Coating - detached", "code": "Liner/Coating - detached" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNELDEPOSITS", "type": "esriFieldTypeString", "alias": "Flow Channel Deposits", "length": 50, "domain": { "type": "codedValue", "name": "ssChannelDeposits", "description": "", "codedValues": [ { "name": "Deposits - encrustation", "code": "Deposits - encrustation" }, { "name": "Deposits - grease", "code": "Deposits - grease" }, { "name": "Deposits settled - ragging/sanitary", "code": "Deposits settled - ragging/sanitary" }, { "name": "Deposits settled - fine/sand", "code": "Deposits settled - fine/sand" }, { "name": "Deposits settled - gravel/rocks/brick", "code": "Deposits settled - gravel/rocks/brick" }, { "name": "Deposits settled - hard/compacted", "code": "Deposits settled - hard/compacted" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" }, { "name": "Sand", "code": "Sand" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHANNELDEPOSITSDEPTH", "type": "esriFieldTypeDouble", "alias": "Depth of Deposits", "domain": null }, { "name": "CHANNELINFILTRATE", "type": "esriFieldTypeString", "alias": "Channel Infiltration", "length": 50, "domain": { "type": "codedValue", "name": "MACP_Inflow_Infiltration", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Infil Stained", "code": "Infil Stained" }, { "name": "Infil Weeper", "code": "Infil Weeper" }, { "name": "Infil Dripper", "code": "Infil Dripper" }, { "name": "Infil Runner", "code": "Infil Runner" }, { "name": "Infil Gusher", "code": "Infil Gusher" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SEALCOND", "type": "esriFieldTypeString", "alias": "Pipe Seal Condition", "length": 50, "domain": { "type": "codedValue", "name": "NASSCO_PipeSealCond", "description": "", "codedValues": [ { "name": "No Seal", "code": "No Seal" }, { "name": "Sound", "code": "Sound" }, { "name": "Sand/Water Infiltration", "code": "Sand/Water Infiltration" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PROJECT2", "type": "esriFieldTypeString", "alias": "Additional Project Information", "length": 50, "domain": null }, { "name": "WORKREQUEST", "type": "esriFieldTypeString", "alias": "Work Request Submitted", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PROJECT", "type": "esriFieldTypeString", "alias": "Purpose of Work Request", "length": 50, "domain": { "type": "codedValue", "name": "ssWorkStatus", "description": "Status of Wastewater Work Status", "codedValues": [ { "name": "Access", "code": "Access" }, { "name": "Cleaning", "code": "Cleaning" }, { "name": "Rehabilitation", "code": "Rehabilitation" }, { "name": "Replacement", "code": "Replacement" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMPINSPECT", "type": "esriFieldTypeString", "alias": "Inspection Complete", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ID", "type": "esriFieldTypeString", "alias": "Legacy Access ID", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "ENDDATETIME", "type": "esriFieldTypeDate", "alias": "ENDDATETIME", "length": 8, "domain": null }, { "name": "INSPECTID", "type": "esriFieldTypeString", "alias": "INSPECTID", "length": 10, "domain": null }, { "name": "UFV", "type": "esriFieldTypeString", "alias": "Unable to Inspect", "length": 50, "domain": { "type": "codedValue", "name": "ssUFV", "description": "", "codedValues": [ { "name": "Paved Over", "code": "Paved Over" }, { "name": "No Access", "code": "No Access" }, { "name": "Obstruction", "code": "Obstruction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CANNOTLOCATE", "type": "esriFieldTypeString", "alias": "Cannot Locate", "length": 15, "domain": { "type": "codedValue", "name": "ssCannotLocate", "description": "", "codedValues": [ { "name": "Cannot Locate", "code": "Cannot Locate" }, { "name": "No Value", "code": "No Value" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "UFVCOMMENTS", "type": "esriFieldTypeString", "alias": "Addition Comments", "length": 300, "domain": null } ], "indexes": [ { "name": "R1589_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1589", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G6456FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "ssManholeInspect2020", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D1E9461B-EA37-453C-86EE-5193810E4962}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "Sewer Manhole Inspection Archive 2016 - 2020__ATTACH", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null } ], "indexes": [ { "name": "R1590_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1590", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G6457REL_GLOBALI", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }