{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 3, "name": "DDOTSGIS.BRIDGE.INSPEVNT", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "BRMBridgeLines", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BRKEY", "composite": true, "catalogID": "{B56FDA44-3CED-4D6B-BA37-FD0950D880E0}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": 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, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "INSPNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "BRKEY", "type": "esriFieldTypeString", "alias": "BRKEY", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "BRKEY" }, { "name": "INSPKEY", "type": "esriFieldTypeString", "alias": "INSPKEY", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "INSPKEY" }, { "name": "INSPDATE", "type": "esriFieldTypeDate", "alias": "INSPDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSPDATE" }, { "name": "INSPNAME", "type": "esriFieldTypeString", "alias": "INSPNAME", "domain": null, "editable": true, "nullable": true, "length": 24, "defaultValue": null, "modelName": "INSPNAME" }, { "name": "INSPUSRKEY", "type": "esriFieldTypeString", "alias": "INSPUSRKEY", "domain": null, "editable": true, "nullable": false, "length": 4, "defaultValue": null, "modelName": "INSPUSRKEY" }, { "name": "REV_REQ", "type": "esriFieldTypeString", "alias": "REV_REQ", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "REV_REQ" }, { "name": "DET_UPD", "type": "esriFieldTypeString", "alias": "DET_UPD", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "DET_UPD" }, { "name": "INSPECTCONTROLID", "type": "esriFieldTypeString", "alias": "INSPECTCONTROLID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "INSPECTCONTROLID" }, { "name": "NBINSPDONE", "type": "esriFieldTypeString", "alias": "NBINSPDONE", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "NBINSPDONE" }, { "name": "BRINSPFREQ", "type": "esriFieldTypeSmallInteger", "alias": "BRINSPFREQ", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRINSPFREQ" }, { "name": "LASTINSP", "type": "esriFieldTypeDate", "alias": "LASTINSP", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTINSP" }, { "name": "NEXTINSP", "type": "esriFieldTypeDate", "alias": "NEXTINSP", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "NEXTINSP" }, { "name": "ELINSPDONE", "type": "esriFieldTypeString", "alias": "ELINSPDONE", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "ELINSPDONE" }, { "name": "ELINSPFREQ", "type": "esriFieldTypeSmallInteger", "alias": "ELINSPFREQ", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ELINSPFREQ" }, { "name": "ELINSPDATE", "type": "esriFieldTypeDate", "alias": "ELINSPDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ELINSPDATE" }, { "name": "ELNEXTDATE", "type": "esriFieldTypeDate", "alias": "ELNEXTDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ELNEXTDATE" }, { "name": "UWINSPREQ", "type": "esriFieldTypeString", "alias": "UWINSPREQ", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "UWINSPREQ" }, { "name": "UWINSPDONE", "type": "esriFieldTypeString", "alias": "UWINSPDONE", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "UWINSPDONE" }, { "name": "UWINSPFREQ", "type": "esriFieldTypeSmallInteger", "alias": "UWINSPFREQ", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UWINSPFREQ" }, { "name": "UWLASTINSP", "type": "esriFieldTypeDate", "alias": "UWLASTINSP", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "UWLASTINSP" }, { "name": "UWNEXTDATE", "type": "esriFieldTypeDate", "alias": "UWNEXTDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "UWNEXTDATE" }, { "name": "FCINSPREQ", "type": "esriFieldTypeString", "alias": "FCINSPREQ", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "FCINSPREQ" }, { "name": "FCINSPDONE", "type": "esriFieldTypeString", "alias": "FCINSPDONE", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "FCINSPDONE" }, { "name": "FCINSPFREQ", "type": "esriFieldTypeSmallInteger", "alias": "FCINSPFREQ", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FCINSPFREQ" }, { "name": "FCLASTINSP", "type": "esriFieldTypeDate", "alias": "FCLASTINSP", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FCLASTINSP" }, { "name": "FCNEXTDATE", "type": "esriFieldTypeDate", "alias": "FCNEXTDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FCNEXTDATE" }, { "name": "OSINSPREQ", "type": "esriFieldTypeString", "alias": "OSINSPREQ", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "OSINSPREQ" }, { "name": "OSINSPDONE", "type": "esriFieldTypeString", "alias": "OSINSPDONE", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "OSINSPDONE" }, { "name": "OSINSPFREQ", "type": "esriFieldTypeSmallInteger", "alias": "OSINSPFREQ", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OSINSPFREQ" }, { "name": "OSLASTINSP", "type": "esriFieldTypeDate", "alias": "OSLASTINSP", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "OSLASTINSP" }, { "name": "OSNEXTDATE", "type": "esriFieldTypeDate", "alias": "OSNEXTDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "OSNEXTDATE" }, { "name": "IETRIGGER", "type": "esriFieldTypeString", "alias": "IETRIGGER", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "IETRIGGER" }, { "name": "APPRDATE", "type": "esriFieldTypeDate", "alias": "APPRDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "APPRDATE" }, { "name": "RAILRATING", "type": "esriFieldTypeString", "alias": "RAILRATING", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "RAILRATING" }, { "name": "TRANSRATIN", "type": "esriFieldTypeString", "alias": "TRANSRATIN", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "TRANSRATIN" }, { "name": "ARAILRATIN", "type": "esriFieldTypeString", "alias": "ARAILRATIN", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "ARAILRATIN" }, { "name": "AENDRATING", "type": "esriFieldTypeString", "alias": "AENDRATING", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "AENDRATING" }, { "name": "OPPOSTCL", "type": "esriFieldTypeString", "alias": "OPPOSTCL", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "OPPOSTCL" }, { "name": "DECKGEOM", "type": "esriFieldTypeString", "alias": "DECKGEOM", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "DECKGEOM" }, { "name": "UNDERCLR", "type": "esriFieldTypeString", "alias": "UNDERCLR", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "UNDERCLR" }, { "name": "WATERADEQ", "type": "esriFieldTypeString", "alias": "WATERADEQ", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "WATERADEQ" }, { "name": "PIERPROT", "type": "esriFieldTypeString", "alias": "PIERPROT", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "PIERPROT" }, { "name": "SCOURCRIT", "type": "esriFieldTypeString", "alias": "SCOURCRIT", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "SCOURCRIT" }, { "name": "APPRALIGN", "type": "esriFieldTypeString", "alias": "APPRALIGN", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "APPRALIGN" }, { "name": "DKRATING", "type": "esriFieldTypeString", "alias": "DKRATING", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "DKRATING" }, { "name": "SUPRATING", "type": "esriFieldTypeString", "alias": "SUPRATING", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "SUPRATING" }, { "name": "SUBRATING", "type": "esriFieldTypeString", "alias": "SUBRATING", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "SUBRATING" }, { "name": "CHANRATING", "type": "esriFieldTypeString", "alias": "CHANRATING", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "CHANRATING" }, { "name": "CULVRATING", "type": "esriFieldTypeString", "alias": "CULVRATING", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "CULVRATING" }, { "name": "STRRATING", "type": "esriFieldTypeString", "alias": "STRRATING", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "STRRATING" }, { "name": "NBI_RATING", "type": "esriFieldTypeString", "alias": "NBI_RATING", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "NBI_RATING" }, { "name": "SUFF_RATE", "type": "esriFieldTypeSingle", "alias": "SUFF_RATE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SUFF_RATE" }, { "name": "SUFF_PREFX", "type": "esriFieldTypeString", "alias": "SUFF_PREFX", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "SUFF_PREFX" }, { "name": "INSPTYPE", "type": "esriFieldTypeString", "alias": "INSPTYPE", "domain": null, "editable": true, "nullable": false, "length": 1, "defaultValue": null, "modelName": "INSPTYPE" }, { "name": "INSPSTAT", "type": "esriFieldTypeString", "alias": "INSPSTAT", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "INSPSTAT" }, { "name": "DECKDISTR", "type": "esriFieldTypeDouble", "alias": "DECKDISTR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DECKDISTR" }, { "name": "BITRIGGER", "type": "esriFieldTypeString", "alias": "BITRIGGER", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "BITRIGGER" }, { "name": "RECWORKFLG", "type": "esriFieldTypeString", "alias": "RECWORKFLG", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "RECWORKFLG" }, { "name": "CREATEDATETIME", "type": "esriFieldTypeDate", "alias": "CREATEDATETIME", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATEDATETIME" }, { "name": "CREATEUSERKEY", "type": "esriFieldTypeString", "alias": "CREATEUSERKEY", "domain": null, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "CREATEUSERKEY" }, { "name": "MODTIME", "type": "esriFieldTypeDate", "alias": "MODTIME", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MODTIME" }, { "name": "USERKEY", "type": "esriFieldTypeString", "alias": "USERKEY", "domain": null, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "USERKEY" }, { "name": "DOCREFKEY", "type": "esriFieldTypeString", "alias": "DOCREFKEY", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DOCREFKEY" }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "NOTES", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "NOTES" }, { "name": "ELEMCONVERT", "type": "esriFieldTypeString", "alias": "ELEMCONVERT", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "ELEMCONVERT" }, { "name": "INSPEVNT_GD", "type": "esriFieldTypeString", "alias": "INSPEVNT_GD", "domain": null, "editable": true, "nullable": false, "length": 32, "defaultValue": null, "modelName": "INSPEVNT_GD" }, { "name": "INSPEVNT_LB", "type": "esriFieldTypeString", "alias": "INSPEVNT_LB", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "INSPEVNT_LB" }, { "name": "BRIDGE_GD", "type": "esriFieldTypeString", "alias": "BRIDGE_GD", "domain": null, "editable": true, "nullable": false, "length": 32, "defaultValue": null, "modelName": "BRIDGE_GD" }, { "name": "OSTYPE", "type": "esriFieldTypeString", "alias": "OSTYPE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OSTYPE" }, { "name": "SCHEDULE_NOTES", "type": "esriFieldTypeString", "alias": "SCHEDULE_NOTES", "domain": null, "editable": true, "nullable": true, "length": 3999, "defaultValue": null, "modelName": "SCHEDULE_NOTES" }, { "name": "ENGINEER_OF_RECORD", "type": "esriFieldTypeString", "alias": "ENGINEER_OF_RECORD", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "ENGINEER_OF_RECORD" }, { "name": "DATE_ENTERED", "type": "esriFieldTypeDate", "alias": "DATE_ENTERED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATE_ENTERED" }, { "name": "INSPUSRGUID", "type": "esriFieldTypeString", "alias": "INSPUSRGUID", "domain": null, "editable": true, "nullable": false, "length": 32, "defaultValue": null, "modelName": "INSPUSRGUID" }, { "name": "ENTERED_BY_GD", "type": "esriFieldTypeString", "alias": "ENTERED_BY_GD", "domain": null, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "ENTERED_BY_GD" }, { "name": "BRIDGE_CONDITION", "type": "esriFieldTypeString", "alias": "BRIDGE_CONDITION", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "BRIDGE_CONDITION" }, { "name": "HEALTH_INDEX", "type": "esriFieldTypeSingle", "alias": "HEALTH_INDEX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HEALTH_INDEX" } ], "indexes": [ { "name": "R587_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I16860INSPEVNT_G", "fields": "INSPEVNT_GD", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_16860_BRKEY", "fields": "BRKEY", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "DDOTSGIS.BRIDGE.INSPEVNT", "description": "", "prototype": { "attributes": { "BRIDGE_CONDITION": null, "HEALTH_INDEX": null, "BRKEY": null, "INSPKEY": null, "INSPDATE": null, "INSPNAME": null, "INSPUSRKEY": " ", "REV_REQ": null, "DET_UPD": null, "INSPECTCONTROLID": null, "NBINSPDONE": null, "BRINSPFREQ": null, "LASTINSP": null, "NEXTINSP": null, "ELINSPDONE": null, "ELINSPFREQ": null, "ELINSPDATE": null, "ELNEXTDATE": null, "UWINSPREQ": null, "UWINSPDONE": null, "UWINSPFREQ": null, "UWLASTINSP": null, "UWNEXTDATE": null, "FCINSPREQ": null, "FCINSPDONE": null, "FCINSPFREQ": null, "FCLASTINSP": null, "FCNEXTDATE": null, "OSINSPREQ": null, "OSINSPDONE": null, "OSINSPFREQ": null, "OSLASTINSP": null, "OSNEXTDATE": null, "IETRIGGER": null, "APPRDATE": null, "RAILRATING": null, "TRANSRATIN": null, "ARAILRATIN": null, "AENDRATING": null, "OPPOSTCL": null, "DECKGEOM": null, "UNDERCLR": null, "WATERADEQ": null, "PIERPROT": null, "SCOURCRIT": null, "APPRALIGN": null, "DKRATING": null, "SUPRATING": null, "SUBRATING": null, "CHANRATING": null, "CULVRATING": null, "STRRATING": null, "NBI_RATING": null, "SUFF_RATE": null, "SUFF_PREFX": null, "INSPTYPE": " ", "INSPSTAT": null, "DECKDISTR": null, "BITRIGGER": null, "RECWORKFLG": null, "CREATEDATETIME": null, "CREATEUSERKEY": null, "MODTIME": null, "USERKEY": null, "DOCREFKEY": null, "NOTES": null, "ELEMCONVERT": null, "INSPEVNT_GD": " ", "INSPEVNT_LB": null, "BRIDGE_GD": " ", "OSTYPE": null, "SCHEDULE_NOTES": null, "ENGINEER_OF_RECORD": null, "DATE_ENTERED": null, "INSPUSRGUID": " ", "ENTERED_BY_GD": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }