{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 18, "name": "Retaining Wall", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CREATED_DATE", "creatorField": "CREATED_USER", "editDateField": "LAST_EDITED_DATE", "editorField": "LAST_EDITED_USER" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "RetainWall_Inspection", "relatedTableId": 19, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GLOBALID", "composite": false }, { "id": 1, "name": "Retaining_Wall_Defects", "relatedTableId": 20, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GLOBALID", "composite": false } ], "isDataVersioned": false, "isDataArchived": true, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1667697076000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "extent": { "xmin": -9787349.658121338, "ymin": 4563311.550441969, "xmax": -9436902.259723578, "ymax": 5117388.679794316, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 26916, "latestWkid": 26916, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 80, 175, 172, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "VENDOR_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "VENDOR_NAME", "type": "esriFieldTypeString", "alias": "Vendor name", "domain": { "type": "codedValue", "name": "d_retain_wall_vendor", "description": "", "codedValues": [ { "name": "WSP", "code": "WSP" }, { "name": "CTL", "code": "CTL" }, { "name": "Resource International", "code": "Resource International" }, { "name": "SELECT NAME", "code": "Undefined" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "VENDOR_NAME" }, { "name": "WORKFLOW_STATUS", "type": "esriFieldTypeSmallInteger", "alias": "Workflow Status", "domain": { "type": "codedValue", "name": "d_retain_wall_status", "description": "", "codedValues": [ { "name": "Collected", "code": 0 }, { "name": "Reviewed", "code": 1 }, { "name": "Returned", "code": 2 }, { "name": "Accepted", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "defaultValue": null, "modelName": "WORKFLOW_STATUS" }, { "name": "ARRIVAL_DATE_TIME", "type": "esriFieldTypeDate", "alias": "Arrival date and time", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ARRIVAL_DATE_TIME" }, { "name": "DEPARTURE_DATE_TIME", "type": "esriFieldTypeDate", "alias": "Departure date and time", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DEPARTURE_DATE_TIME" }, { "name": "OBSERVER_NAME", "type": "esriFieldTypeString", "alias": "Observer name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OBSERVER_NAME" }, { "name": "WEATHER_CONDITION", "type": "esriFieldTypeString", "alias": "Weather Condition", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "WEATHER_CONDITION" }, { "name": "WALL_TYPE", "type": "esriFieldTypeSmallInteger", "alias": "Wall Type", "domain": { "type": "codedValue", "name": "d_retain_wall_types", "description": "", "codedValues": [ { "name": "Masonary", "code": 0 }, { "name": "RC Cantilever", "code": 1 }, { "name": "RC Counterfort", "code": 2 }, { "name": "Prestressed Concrete", "code": 3 }, { "name": "Cantilever Sheet Pile", "code": 4 }, { "name": "Anchored Bulkhead", "code": 5 }, { "name": "Diaphram", "code": 6 }, { "name": "Bored Pile", "code": 7 }, { "name": "Soldier Pile", "code": 8 }, { "name": "Reinforced Earth", "code": 9 }, { "name": "MSE", "code": 10 }, { "name": "Timber", "code": 11 }, { "name": "Bin", "code": 12 }, { "name": "Wire", "code": 13 }, { "name": "Other", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WALL_TYPE" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" }, { "name": "ASSOC_FEATURE", "type": "esriFieldTypeSmallInteger", "alias": "Associated Feature", "domain": { "type": "codedValue", "name": "d_retain_wall_assocFeature", "description": "", "codedValues": [ { "name": "Bridge Abutment", "code": 0 }, { "name": "Roadway Ramps", "code": 1 }, { "name": "Railroad", "code": 2 }, { "name": "Roadway", "code": 3 }, { "name": "Wing Walls", "code": 4 }, { "name": "Slopes", "code": 5 }, { "name": "Waterway", "code": 6 }, { "name": "Trails/Sidewalk", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ASSOC_FEATURE" }, { "name": "INVENTORIED_FACING_DIRECTION", "type": "esriFieldTypeString", "alias": "Inventoried Facing Direction", "domain": { "type": "codedValue", "name": "d_retain_wall_direction", "description": "", "codedValues": [ { "name": "North", "code": "N" }, { "name": "Northeast", "code": "NE" }, { "name": "East", "code": "E" }, { "name": "Southeast", "code": "SE" }, { "name": "South", "code": "S" }, { "name": "Southwest", "code": "SW" }, { "name": "West", "code": "W" }, { "name": "Northwest", "code": "NW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "INVENTORIED_FACING_DIRECTION" }, { "name": "WALL_FACING_TYPE", "type": "esriFieldTypeString", "alias": "Wall Facing Type", "domain": { "type": "codedValue", "name": "d_retain_wall_facType", "description": "", "codedValues": [ { "name": "Precast Concrete Panel", "code": "Precast Concrete Panel" }, { "name": "Modular Block", "code": "Modular Block" }, { "name": "Wire Frame", "code": "Wire Frame" }, { "name": "Masonary", "code": "Masonary" }, { "name": "Wood Lagging", "code": "Wood Lagging" }, { "name": "Cast-in-place", "code": "Cast-in-place" }, { "name": "Shotcrete", "code": "Shotcrete" }, { "name": "Steel", "code": "Steel" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WALL_FACING_TYPE" }, { "name": "PANEL_HEIGHT", "type": "esriFieldTypeDouble", "alias": "Panel Height (deci. ft)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PANEL_HEIGHT" }, { "name": "PANEL_WIDTH", "type": "esriFieldTypeDouble", "alias": "Panel Width (dec. ft)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PANEL_WIDTH" }, { "name": "PANEL_SHAPE", "type": "esriFieldTypeString", "alias": "PANEL_SHAPE", "domain": { "type": "codedValue", "name": "d_retain_wall_panel_shape", "description": "", "codedValues": [ { "name": "Rectangular", "code": "Rectangular" }, { "name": "Cruciform", "code": "Cruciform" }, { "name": "Square", "code": "Square" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "PANEL_SHAPE" }, { "name": "WALL_DESIGN", "type": "esriFieldTypeString", "alias": "Wall Design Method", "domain": { "type": "codedValue", "name": "Wall_Design_Method", "description": "", "codedValues": [ { "name": "ASD", "code": "ASD" }, { "name": "LFD", "code": "LFD" }, { "name": "LRFD", "code": "LRFD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WALL_DESIGN" }, { "name": "WALL_VENDOR", "type": "esriFieldTypeString", "alias": "MSE Wall Vendor Name", "domain": { "type": "codedValue", "name": "MSE_Wall_Vendor", "description": "", "codedValues": [ { "name": "Sanders", "code": "Sanders" }, { "name": "Reco", "code": "Reco" }, { "name": "Sinewall", "code": "Sinewall" }, { "name": "Tricon", "code": "Tricon" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WALL_VENDOR" }, { "name": "BEGIN_EXPOSE_HEIGHT", "type": "esriFieldTypeInteger", "alias": "Exposed Height at Beginning", "domain": { "type": "range", "name": "Begin_EH", "description": "", "range": [ 0, 100 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BEGIN_EXPOSE_HEIGHT" }, { "name": "COMMENTS_OBSERVATION", "type": "esriFieldTypeString", "alias": "Comments / Observations", "domain": null, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "COMMENTS_OBSERVATION" }, { "name": "BREAK_EXPOSE_HEIGHT", "type": "esriFieldTypeInteger", "alias": "Expose Height at Break", "domain": { "type": "range", "name": "Break_EH", "description": "", "range": [ 0, 100 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BREAK_EXPOSE_HEIGHT" }, { "name": "TURN_EXPOSED_HEIGHT", "type": "esriFieldTypeInteger", "alias": "Exposed Height at Turn", "domain": { "type": "range", "name": "Turn_EH", "description": "", "range": [ 0, 100 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TURN_EXPOSED_HEIGHT" }, { "name": "END_EXPOSED_HEIGHT", "type": "esriFieldTypeInteger", "alias": "Exposed Height at End", "domain": { "type": "range", "name": "End_EH", "description": "", "range": [ 0, 100 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "END_EXPOSED_HEIGHT" }, { "name": "HEIGHT_ABOVE_SOIL", "type": "esriFieldTypeInteger", "alias": "Height above Retained Soil", "domain": { "type": "range", "name": "Height_above_soil", "description": "", "range": [ 0, 10 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HEIGHT_ABOVE_SOIL" }, { "name": "MAX_WALL_HEIGHT", "type": "esriFieldTypeInteger", "alias": "Maxium Wall Height", "domain": { "type": "range", "name": "Max_Wall_Height", "description": "", "range": [ 0, 150 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAX_WALL_HEIGHT" }, { "name": "WATER_DEPTH", "type": "esriFieldTypeInteger", "alias": "Water Table Depth", "domain": { "type": "range", "name": "WaterTable_Depth", "description": "", "range": [ 0, 100 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WATER_DEPTH" }, { "name": "BEARING_CAPACITY", "type": "esriFieldTypeInteger", "alias": "Bearing Capacity", "domain": { "type": "range", "name": "Bearing_Capacity", "description": "", "range": [ 1000, 10000 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BEARING_CAPACITY" }, { "name": "WALL_FACE_EXPOSED", "type": "esriFieldTypeInteger", "alias": "Exposed Wall Facing Area", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WALL_FACE_EXPOSED" }, { "name": "ERMS_LINK", "type": "esriFieldTypeString", "alias": "Field Elevation View", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ERMS_LINK" }, { "name": "FOUNDATION_INFO", "type": "esriFieldTypeString", "alias": "Foundation Improvement Information", "domain": null, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "FOUNDATION_INFO" }, { "name": "MAX_CONTACT_PRESSURE", "type": "esriFieldTypeInteger", "alias": "Maximum Contact Pressure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAX_CONTACT_PRESSURE" }, { "name": "COLLECTION_LOCATION", "type": "esriFieldTypeString", "alias": "Collection Location", "domain": { "type": "codedValue", "name": "Collection_Location", "description": "", "codedValues": [ { "name": "Office", "code": "Office" }, { "name": "Field", "code": "Field" }, { "name": "Field & Office", "code": "FH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "COLLECTION_LOCATION" }, { "name": "WALL_OWNER", "type": "esriFieldTypeString", "alias": "Retaining Wall Owner", "domain": { "type": "codedValue", "name": "Wall_Owner", "description": "", "codedValues": [ { "name": "LPA", "code": "LPA" }, { "name": "State", "code": "State" }, { "name": "Federal", "code": "Federal" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WALL_OWNER" }, { "name": "NBI", "type": "esriFieldTypeString", "alias": "NBI", "domain": null, "editable": true, "nullable": true, "length": 9, "defaultValue": null, "modelName": "NBI" }, { "name": "DES", "type": "esriFieldTypeString", "alias": "DES", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "DES" }, { "name": "PUBLICSAFETYRATING", "type": "esriFieldTypeString", "alias": "Public Safety Rating", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PUBLICSAFETYRATING" }, { "name": "WALL_CONDITION", "type": "esriFieldTypeSmallInteger", "alias": "Wall Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WALL_CONDITION" }, { "name": "ADDITIONAL_COMMENTS", "type": "esriFieldTypeString", "alias": "Additional Comments", "domain": null, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "ADDITIONAL_COMMENTS" }, { "name": "ROUTE_NAME", "type": "esriFieldTypeString", "alias": "Route Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ROUTE_NAME" }, { "name": "YEAER", "type": "esriFieldTypeSmallInteger", "alias": "Year", "domain": { "type": "range", "name": "Year", "description": "", "range": [ 1850, 2150 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YEAER" }, { "name": "DISTRICT", "type": "esriFieldTypeString", "alias": "District", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "DISTRICT" }, { "name": "WALL_ID", "type": "esriFieldTypeInteger", "alias": "WALL ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WALL_ID" }, { "name": "FACE_ID", "type": "esriFieldTypeString", "alias": "FACE ID", "domain": null, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "FACE_ID" }, { "name": "RETIRED_DATE", "type": "esriFieldTypeDate", "alias": "Date Retired", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RETIRED_DATE" }, { "name": "ASSET_NAME", "type": "esriFieldTypeString", "alias": "Asset Name", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ASSET_NAME" }, { "name": "ESRIGNSS_RECEIVER", "type": "esriFieldTypeString", "alias": "Receiver Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ESRIGNSS_RECEIVER" }, { "name": "ESRIGNSS_H_RMS", "type": "esriFieldTypeDouble", "alias": "Horizontal Accuracy (m)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_H_RMS" }, { "name": "ESRIGNSS_V_RMS", "type": "esriFieldTypeDouble", "alias": "Vertical Accuracy (m)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_V_RMS" }, { "name": "ESRIGNSS_LATITUDE", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_LATITUDE" }, { "name": "ESRIGNSS_LONGITUDE", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_LONGITUDE" }, { "name": "ESRIGNSS_ALTITUDE", "type": "esriFieldTypeDouble", "alias": "Altitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_ALTITUDE" }, { "name": "ESRIGNSS_PDOP", "type": "esriFieldTypeDouble", "alias": "PDOP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_PDOP" }, { "name": "ESRIGNSS_HDOP", "type": "esriFieldTypeDouble", "alias": "HDOP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_HDOP" }, { "name": "ESRIGNSS_VDOP", "type": "esriFieldTypeDouble", "alias": "VDOP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_VDOP" }, { "name": "ESRIGNSS_FIXTYPE", "type": "esriFieldTypeSmallInteger", "alias": "Fix Type", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_FIXTYPE" }, { "name": "ESRIGNSS_CORRECTIONAGE", "type": "esriFieldTypeDouble", "alias": "Correction Age", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_CORRECTIONAGE" }, { "name": "ESRIGNSS_STATIONID", "type": "esriFieldTypeSmallInteger", "alias": "Station ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_STATIONID" }, { "name": "ESRIGNSS_NUMSATS", "type": "esriFieldTypeSmallInteger", "alias": "Num Satellites", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_NUMSATS" }, { "name": "ESRIGNSS_FIXDATETIME", "type": "esriFieldTypeDate", "alias": "Fix Date Time", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ESRIGNSS_FIXDATETIME" }, { "name": "ESRIGNSS_AVG_H_RMS", "type": "esriFieldTypeDouble", "alias": "Average Horizontal Accuracy (m)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_AVG_H_RMS" }, { "name": "ESRIGNSS_AVG_V_RMS", "type": "esriFieldTypeDouble", "alias": "Average Vertical Accuracy (m)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_AVG_V_RMS" }, { "name": "ESRIGNSS_AVG_POSITIONS", "type": "esriFieldTypeInteger", "alias": "Average Positions", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_AVG_POSITIONS" }, { "name": "ESRIGNSS_H_STDDEV", "type": "esriFieldTypeDouble", "alias": "Standard Deviation (m)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_H_STDDEV" }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "Created User", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CREATED_USER" }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "Date Created", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATED_DATE" }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "Last Edited User", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LAST_EDITED_USER" }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "Last Edited Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_EDITED_DATE" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R308_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_308", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A108_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Retaining Wall", "description": "", "prototype": { "attributes": { "ESRIGNSS_H_STDDEV": null, "VENDOR_NAME": " ", "WORKFLOW_STATUS": 0, "ARRIVAL_DATE_TIME": null, "DEPARTURE_DATE_TIME": null, "OBSERVER_NAME": null, "WEATHER_CONDITION": null, "WALL_TYPE": null, "ESRIGNSS_AVG_POSITIONS": null, "ASSOC_FEATURE": null, "INVENTORIED_FACING_DIRECTION": null, "WALL_FACING_TYPE": null, "PANEL_HEIGHT": null, "PANEL_WIDTH": null, "PANEL_SHAPE": null, "WALL_DESIGN": null, "WALL_VENDOR": null, "BEGIN_EXPOSE_HEIGHT": null, "COMMENTS_OBSERVATION": null, "BREAK_EXPOSE_HEIGHT": null, "TURN_EXPOSED_HEIGHT": null, "END_EXPOSED_HEIGHT": null, "HEIGHT_ABOVE_SOIL": null, "MAX_WALL_HEIGHT": null, "WATER_DEPTH": null, "BEARING_CAPACITY": null, "WALL_FACE_EXPOSED": null, "ERMS_LINK": null, "FOUNDATION_INFO": null, "MAX_CONTACT_PRESSURE": null, "COLLECTION_LOCATION": null, "WALL_OWNER": null, "NBI": null, "DES": null, "PUBLICSAFETYRATING": null, "WALL_CONDITION": null, "ADDITIONAL_COMMENTS": null, "ROUTE_NAME": null, "YEAER": null, "DISTRICT": null, "WALL_ID": null, "FACE_ID": null, "RETIRED_DATE": null, "ASSET_NAME": null, "ESRIGNSS_RECEIVER": null, "ESRIGNSS_H_RMS": null, "ESRIGNSS_V_RMS": null, "ESRIGNSS_LATITUDE": null, "ESRIGNSS_LONGITUDE": null, "ESRIGNSS_ALTITUDE": null, "ESRIGNSS_PDOP": null, "ESRIGNSS_HDOP": null, "ESRIGNSS_VDOP": null, "ESRIGNSS_FIXTYPE": null, "ESRIGNSS_CORRECTIONAGE": null, "ESRIGNSS_STATIONID": null, "ESRIGNSS_NUMSATS": null, "ESRIGNSS_FIXDATETIME": null, "ESRIGNSS_AVG_H_RMS": null, "ESRIGNSS_AVG_V_RMS": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Sync,ChangeTracking", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "9779d9812d4f46c294863755756030b5" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 19, "name": "Retaining Wall Inspection", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "INSPECTION_DATE", "creatorField": "CREATED_USER", "editDateField": "LAST_EDITED_DATE", "editorField": "LAST_EDITED_USER" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "Retaining_Wall", "relatedTableId": 18, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "composite": false } ], "isDataVersioned": false, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1667697076000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "CREATED_USER", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "Created User", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CREATED_USER" }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "Last Edited User", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LAST_EDITED_USER" }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "Last Edited Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_EDITED_DATE" }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "Inspection Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSPECTION_DATE" }, { "name": "OVERALL_CONDITION", "type": "esriFieldTypeSmallInteger", "alias": "Wall Condition", "domain": { "type": "codedValue", "name": "d_wall_rating", "description": "inspection component ratings", "codedValues": [ { "name": "3 - Serious Condition", "code": 3 }, { "name": "4 - Poor Condition", "code": 4 }, { "name": "5 - Fair Condition", "code": 5 }, { "name": "6 - Satisfactory Condition", "code": 6 }, { "name": "7 - Good Condition", "code": 7 }, { "name": "8 - Very Good Condition", "code": 8 }, { "name": "9 - Excellent Condition", "code": 9 }, { "name": "N - Not Applicable", "code": -99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WALL_CONDITION" }, { "name": "FACE_CONDITION", "type": "esriFieldTypeSmallInteger", "alias": "Face Condition", "domain": { "type": "codedValue", "name": "d_wall_rating", "description": "inspection component ratings", "codedValues": [ { "name": "3 - Serious Condition", "code": 3 }, { "name": "4 - Poor Condition", "code": 4 }, { "name": "5 - Fair Condition", "code": 5 }, { "name": "6 - Satisfactory Condition", "code": 6 }, { "name": "7 - Good Condition", "code": 7 }, { "name": "8 - Very Good Condition", "code": 8 }, { "name": "9 - Excellent Condition", "code": 9 }, { "name": "N - Not Applicable", "code": -99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FACE_CONDITION" }, { "name": "VERTICALS_CONDITION", "type": "esriFieldTypeSmallInteger", "alias": "Vertical(s) Condition", "domain": { "type": "codedValue", "name": "d_wall_rating", "description": "inspection component ratings", "codedValues": [ { "name": "3 - Serious Condition", "code": 3 }, { "name": "4 - Poor Condition", "code": 4 }, { "name": "5 - Fair Condition", "code": 5 }, { "name": "6 - Satisfactory Condition", "code": 6 }, { "name": "7 - Good Condition", "code": 7 }, { "name": "8 - Very Good Condition", "code": 8 }, { "name": "9 - Excellent Condition", "code": 9 }, { "name": "N - Not Applicable", "code": -99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VERTICALS_CONDITION" }, { "name": "CAPS_CONDITION", "type": "esriFieldTypeSmallInteger", "alias": "Cap(s) Condition", "domain": { "type": "codedValue", "name": "d_wall_rating", "description": "inspection component ratings", "codedValues": [ { "name": "3 - Serious Condition", "code": 3 }, { "name": "4 - Poor Condition", "code": 4 }, { "name": "5 - Fair Condition", "code": 5 }, { "name": "6 - Satisfactory Condition", "code": 6 }, { "name": "7 - Good Condition", "code": 7 }, { "name": "8 - Very Good Condition", "code": 8 }, { "name": "9 - Excellent Condition", "code": 9 }, { "name": "N - Not Applicable", "code": -99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CAPS_CONDITION" }, { "name": "COMMENTS_OBSERVATION", "type": "esriFieldTypeString", "alias": "Comments / Observations", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "COMMENTS_OBSERVATION" }, { "name": "ADDITIONAL_COMMENTS", "type": "esriFieldTypeString", "alias": "Additional Comments", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "ADDITIONAL_COMMENTS" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "REL_GLOBALID" }, { "name": "MONTHS_UNTIL_NEXT_INSPECTION", "type": "esriFieldTypeSmallInteger", "alias": "MONTHS_UNTIL_NEXT_INSPECTION", "domain": { "type": "codedValue", "name": "d_monts_2_next_insp", "description": "months until next retaining wall inspection", "codedValues": [ { "name": "96 Months - 8 years", "code": 96 }, { "name": "72 Months - 6 Years", "code": 72 }, { "name": "48 Months - 4 Years", "code": 48 }, { "name": "24 Months - 2 Years", "code": 24 }, { "name": "12 Months - 1 Year", "code": 12 }, { "name": "6 Months", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MONTHS_UNTIL_NEXT_INSPECTION" } ], "indexes": [ { "name": "G7099REL_GLOBALI", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R310_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_310", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Retaining Wall Inspection", "description": "", "prototype": { "attributes": { "REL_GLOBALID": null, "MONTHS_UNTIL_NEXT_INSPECTION": null, "ADDITIONAL_COMMENTS": null, "COMMENTS_OBSERVATION": null, "CAPS_CONDITION": null, "OVERALL_CONDITION": null, "FACE_CONDITION": null, "VERTICALS_CONDITION": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Sync,ChangeTracking", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "9779d9812d4f46c294863755756030b5" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 20, "name": "Retaining Wall Defects", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CREATIONDATE", "creatorField": "CREATOR", "editDateField": "EDITDATE", "editorField": "EDITOR" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "Retaining_Wall", "relatedTableId": 18, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "REL_GUID", "composite": false } ], "isDataVersioned": false, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1667697076000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "DEFECT", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "DEFECT", "type": "esriFieldTypeSmallInteger", "alias": "DEFECT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEFECT" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" }, { "name": "REL_GUID", "type": "esriFieldTypeGUID", "alias": "REL_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "REL_GUID" }, { "name": "DEFECT_RATING", "type": "esriFieldTypeSmallInteger", "alias": "DEFECT_RATING", "domain": { "type": "codedValue", "name": "Wall_Condition", "description": "", "codedValues": [ { "name": "9 - EXCELLENT - Perfect condition, recently installed or repaired", "code": 9 }, { "name": "7 - GOOD - No repairs needed, list specific items to consider for next inspection", "code": 7 }, { "name": "5 - FAIR - Acceptable condition, increase inspection frequency", "code": 5 }, { "name": "3 - POOR - needs repair", "code": 3 }, { "name": "1 - CRITICAL - Feature is failing", "code": 1 }, { "name": "0 - Unknown / Not Found", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEFECT_RATING" }, { "name": "ESTIMATED_DEFECT_AREA", "type": "esriFieldTypeSmallInteger", "alias": "ESTIMATED DEFECT AREA (SQ FT)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESTIMATED_DEFECT_AREA" }, { "name": "ESTIMATED_DEFECT_LENGTH", "type": "esriFieldTypeSmallInteger", "alias": "ESTIMATED DEFECT LENGTH (FT)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESTIMATED_DEFECT_LENGTH" }, { "name": "WALL_PART_TYPE", "type": "esriFieldTypeSmallInteger", "alias": "WALL PART TYPE", "domain": { "type": "codedValue", "name": "WallPartType", "description": "", "codedValues": [ { "name": "Anchored Bulkhead - Anchorage", "code": 0 }, { "name": "Anchored Bulkhead - Horizontal Coping", "code": 1 }, { "name": "Anchored Bulkhead - Vertical Elements/Slip Joints", "code": 2 }, { "name": "Anchored Bulkhead - Vertical Support Columns", "code": 3 }, { "name": "Anchored Bulkhead - Wall Facing", "code": 4 }, { "name": "Bin - Horizontal Coping", "code": 10 }, { "name": "Bin - Vertical Elements/Slip Joints", "code": 11 }, { "name": "Bin - Vertical Support Columns", "code": 12 }, { "name": "Bin - Wall Facing", "code": 13 }, { "name": "Cantilever Sheet Pile - Horizontal Coping", "code": 20 }, { "name": "Cantilever Sheet Pile - Vertical Elements/Slip Joints", "code": 21 }, { "name": "Cantilever Sheet Pile - Vertical Support Columns", "code": 22 }, { "name": "Cantilever Sheet Pile - Wall Facing", "code": 23 }, { "name": "Masonary - Horizontal Coping", "code": 30 }, { "name": "Masonary - Vertical Elements/Slip Joints", "code": 31 }, { "name": "Masonary - Vertical Support Columns", "code": 32 }, { "name": "Masonary - Wall Facing", "code": 33 }, { "name": "MSE - Horizontal Coping", "code": 40 }, { "name": "MSE - Vertical Elements/Slip Joints", "code": 41 }, { "name": "MSE - Vertical Support Columns", "code": 42 }, { "name": "MSE - Wall Facing", "code": 43 }, { "name": "Prestressed Concrete - Horizontal Coping", "code": 50 }, { "name": "Prestressed Concrete - Vertical Elements/Slip Joints", "code": 51 }, { "name": "Prestressed Concrete - Vertical Support Columns", "code": 52 }, { "name": "Prestressed Concrete - Wall Facing", "code": 53 }, { "name": "Reinforced Concrete - Horizontal Coping", "code": 60 }, { "name": "Reinforced Concrete - Vertical Elements/Slip Joints", "code": 61 }, { "name": "Reinforced Concrete - Vertical Support Columns", "code": 62 }, { "name": "Reinforced Concrete - Wall Facing", "code": 63 }, { "name": "Other", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WALL_PART_TYPE" }, { "name": "ESTIMATED_DEFECT_WIDTH", "type": "esriFieldTypeSmallInteger", "alias": "ESTIMATED DEFECT WIDTH(FT)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESTIMATED_DEFECT_WIDTH" }, { "name": "DEFECT_LOCATION", "type": "esriFieldTypeString", "alias": "DEFECT LOCATION DESCRIPTION", "domain": null, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "DEFECT_LOCATION" }, { "name": "RETIRE_DATE", "type": "esriFieldTypeDate", "alias": "RETIRE DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RETIRE_DATE" }, { "name": "CREATIONDATE", "type": "esriFieldTypeDate", "alias": "CreationDate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CreationDate" }, { "name": "CREATOR", "type": "esriFieldTypeString", "alias": "Creator", "domain": null, "editable": false, "nullable": true, "length": 128, "defaultValue": null, "modelName": "Creator" }, { "name": "EDITDATE", "type": "esriFieldTypeDate", "alias": "EditDate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EditDate" }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "Editor", "domain": null, "editable": false, "nullable": true, "length": 128, "defaultValue": null, "modelName": "Editor" }, { "name": "RELATE", "type": "esriFieldTypeInteger", "alias": "Relate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Relate" } ], "indexes": [ { "name": "G7098REL_GUID", "fields": "REL_GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R309_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_309", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Retaining Wall Defects", "description": "", "prototype": { "attributes": { "RETIRE_DATE": null, "DEFECT": null, "RELATE": null, "REL_GUID": null, "DEFECT_RATING": null, "ESTIMATED_DEFECT_AREA": null, "ESTIMATED_DEFECT_LENGTH": null, "WALL_PART_TYPE": null, "ESTIMATED_DEFECT_WIDTH": null, "DEFECT_LOCATION": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Sync,ChangeTracking", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "9779d9812d4f46c294863755756030b5" } ] }