{ "extent": { "ymin": -90, "xmin": -180, "ymax": 90, "xmax": 180, "spatialReference": {"wkid": 4326}, "type": "extent" }, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "hasStaticData": false, "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "uniquerowid", "role": "esriRelRoleOrigin", "composite": true, "name": "ssMH_Conditions_drop_repeat_1", "relatedTableId": 1, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "uniquerowid", "role": "esriRelRoleOrigin", "composite": true, "name": "ssMH_Conditions_drop_repeat_2", "relatedTableId": 2, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "uniquerowid", "role": "esriRelRoleOrigin", "composite": true, "name": "ssMH_Conditions_drop_repeat_3", "relatedTableId": 3, "id": 2, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "uniquerowid", "role": "esriRelRoleOrigin", "composite": true, "name": "ssMH_Conditions_drop_repeat_4", "relatedTableId": 4, "id": 3, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "hasZ": false, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "ssMH_Conditions", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniquerowid", "length": 38, "alias": "RowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "survey_date_time", "length": 29, "alias": "Today's date & time (autopopulated)", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facility_id", "length": 255, "alias": "What is the ssManhole ID? (automatically passed from map)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "note1", "length": 255, "alias": "*** For this inspection to be properly mapped, it is vital that you FIND and FACE NORTH when you take pictures and identify pipe locations. Refer to the GIS if necessary (top is north = 12 o'clock) ***", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_297c2a4af6ee4022aa0b9d7adea4eb7b_cvd_purpose", "type": "codedValue", "codedValues": [ { "code": "routine_inspection", "name": "routine inspection" }, { "code": "camera_truck", "name": "as part of camera inspection" }, { "code": "pre-rehab_inspection", "name": "pre-rehab inspection" }, { "code": "rehab_maintenance", "name": "rehab maintenance" }, { "code": "post-rehab_inspection", "name": "post-rehab inspection" }, { "code": "suspected_infiltration", "name": "suspected infiltration" }, { "code": "unknown", "name": "unknown" } ] }, "name": "purpose", "length": 255, "alias": "What is the purpose for the inspection?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_297c2a4af6ee4022aa0b9d7adea4eb7b_cvd_context", "type": "codedValue", "codedValues": [ { "code": "alley", "name": "alley" }, { "code": "building", "name": "building (inside)" }, { "code": "creek", "name": "creek (waterway)" }, { "code": "curb", "name": "curb" }, { "code": "ditch", "name": "ditch" }, { "code": "parking_lot", "name": "parking lot" }, { "code": "roadway", "name": "roadway" }, { "code": "sidewalk", "name": "sidewalk" }, { "code": "woods", "name": "woods" }, { "code": "yard", "name": "yard" }, { "code": "other", "name": "other" } ] }, "name": "context", "length": 255, "alias": "Where is the ssManhole situated?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_297c2a4af6ee4022aa0b9d7adea4eb7b_cvd_surrounding_area", "type": "codedValue", "codedValues": [ { "code": "0", "name": "no observed problems" }, { "code": "7", "name": "problem (vandalism)" }, { "code": "8", "name": "problem (debris)" }, { "code": "9", "name": "problem (erosion)" }, { "code": "10", "name": "problem (sinkhole)" }, { "code": "4", "name": "problem (other)" } ] }, "name": "surrounding_area", "length": 255, "alias": "What is the condition of the immediate area? (select the worst)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_297c2a4af6ee4022aa0b9d7adea4eb7b_cvd_lid", "type": "codedValue", "codedValues": [ { "code": "0", "name": "no defects (or not applicable)" }, { "code": "6", "name": "bad--bent" }, { "code": "7", "name": "bad--broken (cracked)" }, { "code": "8", "name": "bad--broken (loose/poor fit)" }, { "code": "9", "name": "bad--broken (deformed)" }, { "code": "10", "name": "bad--broken (fractured)" }, { "code": "5", "name": "bad--broken (other)" } ] }, "name": "lid", "length": 255, "alias": "What is the condition of the lid? (select the worst)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lid_size", "length": 255, "alias": "Measure and record the diameter of the lid (in inches and fraction, e.g., 23-1/2)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "note_2", "length": 255, "alias": "*** From this point forward, the inspection will require opening the ssManhole lid ***", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "adjustment_rings", "alias": "How many adjustment rings are between the steel manhole frame and the top of the manhole wall?", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "adjust_ring_size", "length": 255, "alias": "Measure and record the combined height (in inches) of the adjustment rings from top of cone to bottom of frame (e.g. 16 in).", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_297c2a4af6ee4022aa0b9d7adea4eb7b_cvd_wall_material", "type": "codedValue", "codedValues": [ { "code": "concrete", "name": "concrete" }, { "code": "block", "name": "masonry (block)" }, { "code": "brick", "name": "masonry (brick)" }, { "code": "stone", "name": "masonry (stone)" }, { "code": "sprayed_lining", "name": "sprayed lining (epoxy or other)" }, { "code": "other", "name": "other" } ] }, "name": "wall_material", "length": 255, "alias": "What material are the walls made of?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_297c2a4af6ee4022aa0b9d7adea4eb7b_cvd_wall_condition", "type": "codedValue", "codedValues": [ { "code": "0", "name": "no defects (or not applicable)" }, { "code": "2", "name": "bad--reinforcement (visible)" }, { "code": "3", "name": "bad--reinforcement (corroded)" }, { "code": "4", "name": "bad--reinforcement (projecting)" }, { "code": "5", "name": "bad--surface (rough/spalling)" }, { "code": "6", "name": "bad--broken (cracked)" }, { "code": "7", "name": "bad--broken (factured)" }, { "code": "8", "name": "bad--infiltration" }, { "code": "9", "name": "bad--bowing (sagging)" }, { "code": "10", "name": "bad--broken (gaps/missing)" } ] }, "name": "wall_condition", "length": 255, "alias": "What is the condition of the walls? (select the worst)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_297c2a4af6ee4022aa0b9d7adea4eb7b_cvd_stairs", "type": "codedValue", "codedValues": [ { "code": "0", "name": "no defects (or not applicable)" }, { "code": "6", "name": "bad--bent" }, { "code": "7", "name": "bad--broken (cracked)" }, { "code": "8", "name": "bad--broken (loose/poor fit)" }, { "code": "9", "name": "bad--broken (deformed)" }, { "code": "10", "name": "bad--broken (missing)" }, { "code": "5", "name": "bad--broken (other)" } ] }, "name": "stairs", "length": 255, "alias": "What is the condition of the stairs? (select the worst)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_297c2a4af6ee4022aa0b9d7adea4eb7b_cvd_invert", "type": "codedValue", "codedValues": [ { "code": "0", "name": "good (no defects)" }, { "code": "4", "name": "bad--reinforcement (projecting)" }, { "code": "5", "name": "bad--surface (rough/spalling)" }, { "code": "6", "name": "bad--bowing (sagging)" }, { "code": "7", "name": "bad--broken (cracked)" }, { "code": "8", "name": "bad--broken (factured)" }, { "code": "9", "name": "bad--broken gaps/missing)" }, { "code": "10", "name": "bad--illicit discharge (chemicals or other)" } ] }, "name": "invert", "length": 255, "alias": "What is the condition of the invert? (select the worst)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_297c2a4af6ee4022aa0b9d7adea4eb7b_cvd_infiltration", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "yes--illicit discharge (notify WPC admin)" }, { "code": "no", "name": "no illicit discharge" } ] }, "name": "infiltration", "length": 255, "alias": "Is infiltration observed in an area OTHER THAN than an INFLOW PIPE?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pipes_number", "alias": "How many sewer pipes do you see coming into the manhole? (include drop pipes that are above the invert)", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pipe_outflow_position", "alias": "FACING NORTH (with 12 o'clock at top ) what is the clock position of the OUTFLOW pipe?", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pipe1_inflow_position", "alias": "FACING NORTH (with 12 o'clock at top) what is the clock position of the FIRST INFLOW pipe?", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_297c2a4af6ee4022aa0b9d7adea4eb7b_cvd_drop_1", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "yes" }, { "code": "no", "name": "no" } ] }, "name": "drop_1", "length": 255, "alias": "Is this pipe a DROP PIPE?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pipe2_inflow_position", "alias": "FACING NORTH (with 12 o'clock at top) what is the clock position of the SECOND INFLOW pipe? (select ZERO if not applicable)", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_297c2a4af6ee4022aa0b9d7adea4eb7b_cvd_drop_2", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "yes" }, { "code": "no", "name": "no" } ] }, "name": "drop_2", "length": 255, "alias": "Is this pipe a DROP PIPE?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pipe3_inflow_position", "alias": "FACING NORTH (with 12 o'clock at top) what is the clock position of the THIRD INFLOW pipe? (select ZERO if not applicable)", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_297c2a4af6ee4022aa0b9d7adea4eb7b_cvd_drop_3", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "yes" }, { "code": "no", "name": "no" } ] }, "name": "drop_3", "length": 255, "alias": "Is this pipe a DROP PIPE?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pipe4_inflow_position", "alias": "FACING NORTH (with 12 o'clock at top) what is the clock position of the FOURTH INFLOW pipe? (select ZERO if not applicable)", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_297c2a4af6ee4022aa0b9d7adea4eb7b_cvd_drop_4", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "yes" }, { "code": "no", "name": "no" } ] }, "name": "drop_4", "length": 255, "alias": "Is this pipe a DROP PIPE?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_297c2a4af6ee4022aa0b9d7adea4eb7b_cvd_inspection_status", "type": "codedValue", "codedValues": [ { "code": "completed", "name": "inspection--completed" }, { "code": "incomplete_buried", "name": "inspection--incomplete (buried & marked)" }, { "code": "incomplete_unlocated", "name": "inspection--incomplete (could not find)" }, { "code": "incomplete_unopenable", "name": "inspection--incomplete (could not open)" }, { "code": "incomplete_inaccessible", "name": "inspection--incomplete (no access)" }, { "code": "incomplete_submerged", "name": "inspection--incomplete (submerged)" }, { "code": "incomplete_traffic", "name": "inspection--incomplete (traffic)" } ] }, "name": "inspection_status", "length": 255, "alias": "In the inspection complete?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_297c2a4af6ee4022aa0b9d7adea4eb7b_cvd_maintenance_reqd", "type": "codedValue", "codedValues": [ { "code": "maint_not_required", "name": "no--maintenance not required" }, { "code": "deposits", "name": "yes--attached deposits" }, { "code": "infiltration", "name": "yes--infiltration" }, { "code": "ingress", "name": "yes--ingress (silt/sand)" }, { "code": "obstruction", "name": "yes--obstruction" }, { "code": "other", "name": "yes--other" }, { "code": "rocks", "name": "yes--rocks" }, { "code": "roots", "name": "yes--roots" }, { "code": "vermin", "name": "yes--vermin" } ] }, "name": "maintenance_reqd", "length": 255, "alias": "Is maintenance required?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_297c2a4af6ee4022aa0b9d7adea4eb7b_cvd_maintenance_status", "type": "codedValue", "codedValues": [ { "code": "maint_status_not_required", "name": "no--maintenance not required" }, { "code": "clean_completed", "name": "cleaning--completed" }, { "code": "clean_incomplete", "name": "cleaning--incomplete (reschedule)" }, { "code": "repair_completed", "name": "repair--completed" }, { "code": "repair_incomplete", "name": "repair--incomplete (reschedule)" }, { "code": "vacuum_completed", "name": "vacuum--completed" }, { "code": "vacuum_incomplete", "name": "vacuum--incomplete (reschedule)" } ] }, "name": "maintenance_status", "length": 255, "alias": "Is maintenance completed?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inspect_notes", "length": 255, "alias": "Add any additional comments that woud be helpful for this inspection:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total", "alias": "Condition Score (automatically calculated from inspection choices)", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_297c2a4af6ee4022aa0b9d7adea4eb7b_cvd_accessible", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "yes" }, { "code": "no", "name": "no" } ] }, "name": "accessible", "length": 255, "alias": "Is the ssManhole accessible for inspection?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inaccessible", "length": 255, "alias": "If the ssManhole is NOT accessible--provide an explanation of what the problem is, then press the checkmark below to save and map the incomplete survey:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "invert_depth", "length": 255, "alias": "Measure and record distance from Rim to the bottom of the invert (OUTFLOW PIPE) (e.g., 14 ft-6 in)--Leave as \"0\" is you cannot determine the depth", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": false, "indexes": [ { "name": "r110_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAcsending": true }, { "name": "uuid_110", "isUnique": true, "description": "", "fields": "globalid", "isAcsending": true }, { "name": "a68_ix1", "isUnique": false, "description": "", "fields": "shape", "isAcsending": true } ], "supportedAppendSourceFilterFormats": "featureService", "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "GUIDFormat": "O", "minScale": 0, "hasAttachments": true, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "allowUpdateWithoutMValues": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Query,Update,Uploads,Delete,Sync,Extract", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 255, 255, 0, 255 ], "width": 1 }, "color": [ 255, 0, 0, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "description": "Survey Data Locations", "label": "ssMH_Conditions", "type": "simple" }, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true, "serviceItemId": "5a71baf857c5421ca3a64da09d10e417" }