{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 0, "name": "Street_Pavement_Inspections_Table", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "PUBLICWORKS.GISADMIN.Sunrise_Streets_Ownership", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Seg_ID", "composite": false, "catalogID": "{39D914FB-AD5E-417A-80B6-D950E7F43F9D}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Street_Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Seg_ID", "type": "esriFieldTypeString", "alias": "Segment ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Seg_ID" }, { "name": "Street_Name", "type": "esriFieldTypeString", "alias": "Street Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Street_Name" }, { "name": "Seg_Start", "type": "esriFieldTypeString", "alias": "Street Segment Start", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Seg_Start" }, { "name": "Seg_End", "type": "esriFieldTypeString", "alias": "Street Segment End Limit", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Seg_End" }, { "name": "Funct_Class", "type": "esriFieldTypeString", "alias": "Functional Class", "domain": { "type": "codedValue", "name": "pwRoadFunctClass", "description": "Road Functional Class", "codedValues": [ { "name": "Arterial", "code": "Art" }, { "name": "Collector", "code": "Col" }, { "name": "Local", "code": "Loc" }, { "name": "Alley", "code": "All" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Funct_Class" }, { "name": "Ownship", "type": "esriFieldTypeString", "alias": "Street Ownership", "domain": { "type": "codedValue", "name": "pwRoadJurisdiction", "description": "Street Ownership", "codedValues": [ { "name": "City", "code": "Cty" }, { "name": "County", "code": "Cnty" }, { "name": "State", "code": "State" }, { "name": "Private", "code": "Prvt" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Ownship" }, { "name": "Width_FT", "type": "esriFieldTypeInteger", "alias": "Segment Width (Ft)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Width_FT" }, { "name": "Length_FT", "type": "esriFieldTypeInteger", "alias": "Segment Length (Ft)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Length_FT" }, { "name": "Area_SqFt", "type": "esriFieldTypeInteger", "alias": "Area (Square Feet)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Area_SqFt" }, { "name": "Lane_Num", "type": "esriFieldTypeSmallInteger", "alias": "Number of Lanes", "domain": { "type": "codedValue", "name": "pwLaneNum", "description": "Number of Lanes", "codedValues": [ { "name": "2 Lanes", "code": 2 }, { "name": "4 Lanes", "code": 4 }, { "name": "6 Lanes", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Lane_Num" }, { "name": "Pave_Type", "type": "esriFieldTypeString", "alias": "Pavement Type", "domain": { "type": "codedValue", "name": "pwPaveType", "description": "Pavement Type", "codedValues": [ { "name": "Asphalt", "code": "Asp" }, { "name": "Concrete", "code": "Con" }, { "name": "Brick", "code": "Brk" }, { "name": "Gravel", "code": "Grv" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Pave_Type" }, { "name": "PCI_Score", "type": "esriFieldTypeInteger", "alias": "PCI Score", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCI_Score" }, { "name": "Last_Inspect", "type": "esriFieldTypeDate", "alias": "Last Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Last_Inspect" }, { "name": "Distress_Type", "type": "esriFieldTypeString", "alias": "Distress Type", "domain": { "type": "codedValue", "name": "pwDistressType", "description": "Street Distress Type", "codedValues": [ { "name": "Alligator Cracking", "code": "AC" }, { "name": "Rutting", "code": "Rtt" }, { "name": "Potholes", "code": "Ph" }, { "name": "Longitudinal/Transverse Cracking", "code": "LTC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Distress_Type" }, { "name": "Rough_Index", "type": "esriFieldTypeInteger", "alias": "Roughness Index", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Rough_Index" }, { "name": "Last_Treat", "type": "esriFieldTypeString", "alias": "Last Treatment Type", "domain": { "type": "codedValue", "name": "pwTreatType", "description": "Last Treatment Type", "codedValues": [ { "name": "Slurry Seal", "code": "SS" }, { "name": "Mill and Overlay", "code": "MO" }, { "name": "Full Reconstruction", "code": "FR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Last_Treat" }, { "name": "Treat_Date", "type": "esriFieldTypeDate", "alias": "Last Treatment Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Treat_Date" }, { "name": "Est_Serv_Life", "type": "esriFieldTypeString", "alias": "Remaining Service Life (ERSL)", "domain": { "type": "codedValue", "name": "pwRemainServiceLife", "description": "Estimated Remaining Service Life (years)", "codedValues": [ { "name": "1 Year", "code": "1" }, { "name": "2 Years", "code": "2" }, { "name": "3 Years", "code": "3" }, { "name": "4 Years", "code": "4" }, { "name": "5 or more Years", "code": "5+" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Est_Serv_Life" } ], "indexes": [ { "name": "R178_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "GDB_291_Seg_ID", "isAscending": true, "isUnique": false, "description": "", "fields": "Seg_ID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Street_Pavement_Inspections_Table", "description": "", "prototype": { "attributes": { "Treat_Date": null, "Est_Serv_Life": null, "Seg_ID": null, "Street_Name": null, "Seg_Start": null, "Seg_End": null, "Funct_Class": null, "Ownship": null, "Width_FT": null, "Length_FT": null, "Area_SqFt": null, "Lane_Num": null, "Pave_Type": null, "PCI_Score": null, "Last_Inspect": null, "Distress_Type": null, "Rough_Index": null, "Last_Treat": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "38cfa77d3dbe4d8a966c029539f2d5c2" }