{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "Ancillary_Structures_Inspections", "type": "Table", "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": "DBO.Ancillary_Structures", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GlobalID_rel", "composite": true, "catalogID": "{E0D0BF33-44C3-4BA4-97DB-4C8DB4191DDD}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1712082538000 }, "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, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "LSS_ConsultantName_txt", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "LSS_InspectionId_s", "type": "esriFieldTypeString", "alias": "LSS_InspectionId_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_InspectionId_s" }, { "name": "LSS_InventoryId_s", "type": "esriFieldTypeString", "alias": "LSS_InventoryId_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_InventoryId_s" }, { "name": "LSS_InspectionTypeId_s", "type": "esriFieldTypeString", "alias": "LSS_InspectionTypeId_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_InspectionTypeId_s" }, { "name": "LSS_InspectionDate_d", "type": "esriFieldTypeDate", "alias": "LSS_InspectionDate_d", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LSS_InspectionDate_d" }, { "name": "LSS_DistHWYEngineerId_L", "type": "esriFieldTypeInteger", "alias": "LSS_DistHWYEngineerId_L", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LSS_DistHWYEngineerId_L" }, { "name": "LSS_Weather_s", "type": "esriFieldTypeString", "alias": "LSS_Weather_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_Weather_s" }, { "name": "LSS_AirTempF_s", "type": "esriFieldTypeString", "alias": "LSS_AirTempF_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_AirTempF_s" }, { "name": "LSS_TeamLeaderId_L", "type": "esriFieldTypeInteger", "alias": "LSS_TeamLeaderId_L", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LSS_TeamLeaderId_L" }, { "name": "LSS_ProjectManagerId_L", "type": "esriFieldTypeInteger", "alias": "LSS_ProjectManagerId_L", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LSS_ProjectManagerId_L" }, { "name": "LSS_ConsultantName_txt", "type": "esriFieldTypeString", "alias": "LSS_ConsultantName_txt", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_ConsultantName_txt" }, { "name": "LSS_Cracks_b", "type": "esriFieldTypeSmallInteger", "alias": "LSS_Cracks_b", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LSS_Cracks_b" }, { "name": "LSS_CondFoundationCurr_s", "type": "esriFieldTypeString", "alias": "LSS_CondFoundationCurr_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_CondFoundationCurr_s" }, { "name": "LSS_CondFoundationPrev_s", "type": "esriFieldTypeString", "alias": "LSS_CondFoundationPrev_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_CondFoundationPrev_s" }, { "name": "LSS_CondStructureCurr_s", "type": "esriFieldTypeString", "alias": "LSS_CondStructureCurr_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_CondStructureCurr_s" }, { "name": "LSS_CondStructurePrev_s", "type": "esriFieldTypeString", "alias": "LSS_CondStructurePrev_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_CondStructurePrev_s" }, { "name": "LSS_StructAttachmentsCurr_s", "type": "esriFieldTypeString", "alias": "LSS_StructAttachmentsCurr_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_StructAttachmentsCurr_s" }, { "name": "LSS_StructAttachmentsPrev_s", "type": "esriFieldTypeString", "alias": "LSS_StructAttachmentsPrev_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_StructAttachmentsPrev_s" }, { "name": "LSS_CondSignPanelsCurr_s", "type": "esriFieldTypeString", "alias": "LSS_CondSignPanelsCurr_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_CondSignPanelsCurr_s" }, { "name": "LSS_CondSignPanelsPrev_s", "type": "esriFieldTypeString", "alias": "LSS_CondSignPanelsPrev_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_CondSignPanelsPrev_s" }, { "name": "LSS_CondTrafficSafetyCurr_s", "type": "esriFieldTypeString", "alias": "LSS_CondTrafficSafetyCurr_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_CondTrafficSafetyCurr_s" }, { "name": "LSS_CondTrafficSafetyPrev_s", "type": "esriFieldTypeString", "alias": "LSS_CondTrafficSafetyPrev_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_CondTrafficSafetyPrev_s" }, { "name": "LSS_CondLuminaireCurr_s", "type": "esriFieldTypeString", "alias": "LSS_CondLuminaireCurr_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_CondLuminaireCurr_s" }, { "name": "LSS_CondLuminairePrev_s", "type": "esriFieldTypeString", "alias": "LSS_CondLuminairePrev_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_CondLuminairePrev_s" }, { "name": "LSS_CondOverallCurr_s", "type": "esriFieldTypeString", "alias": "LSS_CondOverallCurr_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_CondOverallCurr_s" }, { "name": "LSS_CondOverallPrev_s", "type": "esriFieldTypeString", "alias": "LSS_CondOverallPrev_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_CondOverallPrev_s" }, { "name": "LSS_Recommendations_txt", "type": "esriFieldTypeString", "alias": "LSS_Recommendations_txt", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_Recommendations_txt" }, { "name": "LSS_TotalAccessibilityHours_r", "type": "esriFieldTypeDouble", "alias": "LSS_TotalAccessibilityHours_r", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LSS_TotalAccessibilityHours_r" }, { "name": "LSS_Plans_b", "type": "esriFieldTypeSmallInteger", "alias": "LSS_Plans_b", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LSS_Plans_b" }, { "name": "LSS_Photos_b", "type": "esriFieldTypeSmallInteger", "alias": "LSS_Photos_b", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LSS_Photos_b" }, { "name": "LSS_DateOfPhotos_d", "type": "esriFieldTypeDate", "alias": "LSS_DateOfPhotos_d", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LSS_DateOfPhotos_d" }, { "name": "LSS_FieldTestPerformed_txt", "type": "esriFieldTypeString", "alias": "LSS_FieldTestPerformed_txt", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_FieldTestPerformed_txt" }, { "name": "LSS_GeneralComments_txt", "type": "esriFieldTypeString", "alias": "LSS_GeneralComments_txt", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "LSS_GeneralComments_txt" }, { "name": "LSS_CsrRating_txt", "type": "esriFieldTypeString", "alias": "LSS_CsrRating_txt", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_CsrRating_txt" }, { "name": "LSS_CsrRatingYear_txt", "type": "esriFieldTypeString", "alias": "LSS_CsrRatingYear_txt", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_CsrRatingYear_txt" }, { "name": "LSS_LanesUnderStructure_txt", "type": "esriFieldTypeString", "alias": "LSS_LanesUnderStructure_txt", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_LanesUnderStructure_txt" }, { "name": "LSS_ADT_s", "type": "esriFieldTypeString", "alias": "LSS_ADT_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_ADT_s" }, { "name": "LSS_ADTYear_s", "type": "esriFieldTypeString", "alias": "LSS_ADTYear_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_ADTYear_s" }, { "name": "LSS_AdditionalComments_txt", "type": "esriFieldTypeString", "alias": "LSS_AdditionalComments_txt", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "LSS_AdditionalComments_txt" }, { "name": "LSS_Complete_b", "type": "esriFieldTypeSmallInteger", "alias": "LSS_Complete_b", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LSS_Complete_b" }, { "name": "LSS_CompleteDate_d", "type": "esriFieldTypeDate", "alias": "LSS_CompleteDate_d", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LSS_CompleteDate_d" }, { "name": "LSS_Reviewed_L", "type": "esriFieldTypeInteger", "alias": "LSS_Reviewed_L", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LSS_Reviewed_L" }, { "name": "LSS_ReviewDate_d", "type": "esriFieldTypeString", "alias": "LSS_ReviewDate_d", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_ReviewDate_d" }, { "name": "LSS_Approved_L", "type": "esriFieldTypeDouble", "alias": "LSS_Approved_L", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LSS_Approved_L" }, { "name": "LSS_ApprovedDate_d", "type": "esriFieldTypeDate", "alias": "LSS_ApprovedDate_d", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LSS_ApprovedDate_d" }, { "name": "LSS_CreatedBy_s", "type": "esriFieldTypeString", "alias": "LSS_CreatedBy_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_CreatedBy_s" }, { "name": "LSS_CreatedISODate_s", "type": "esriFieldTypeString", "alias": "LSS_CreatedISODate_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_CreatedISODate_s" }, { "name": "LSS_ModifiedBy_s", "type": "esriFieldTypeString", "alias": "LSS_ModifiedBy_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_ModifiedBy_s" }, { "name": "LSS_ModifiedISODate_s", "type": "esriFieldTypeString", "alias": "LSS_ModifiedISODate_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_ModifiedISODate_s" }, { "name": "LSS_ApprovalComments_txt", "type": "esriFieldTypeString", "alias": "LSS_ApprovalComments_txt", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_ApprovalComments_txt" }, { "name": "LSS_DMeterNotes_txt", "type": "esriFieldTypeString", "alias": "LSS_DMeterNotes_txt", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_DMeterNotes_txt" }, { "name": "LSS_Inspection_UUIDKey_s", "type": "esriFieldTypeString", "alias": "LSS_Inspection_UUIDKey_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_Inspection_UUIDKey_s" }, { "name": "LSS_Damage_d", "type": "esriFieldTypeDate", "alias": "LSS_Damage_d", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LSS_Damage_d" }, { "name": "LSS_DamageBy_s", "type": "esriFieldTypeString", "alias": "LSS_DamageBy_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_DamageBy_s" }, { "name": "LSS_DamageAccidentReport_B", "type": "esriFieldTypeSmallInteger", "alias": "LSS_DamageAccidentReport_B", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LSS_DamageAccidentReport_B" }, { "name": "LSS_DamageReimbursementNo_s", "type": "esriFieldTypeString", "alias": "LSS_DamageReimbursementNo_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_DamageReimbursementNo_s" }, { "name": "LSS_DamageCause_txt", "type": "esriFieldTypeString", "alias": "LSS_DamageCause_txt", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_DamageCause_txt" }, { "name": "LSS_DamBostonCopyForwardTo_s", "type": "esriFieldTypeString", "alias": "LSS_DamBostonCopyForwardTo_s", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_DamBostonCopyForwardTo_s" }, { "name": "LSS_DamBostonOffice_d", "type": "esriFieldTypeString", "alias": "LSS_DamBostonOffice_d", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_DamBostonOffice_d" }, { "name": "LSS_DamBostonOfficeRemarks_txt", "type": "esriFieldTypeString", "alias": "LSS_DamBostonOfficeRemarks_txt", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSS_DamBostonOfficeRemarks_txt" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "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": "created_date", "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" }, { "name": "GlobalID_rel", "type": "esriFieldTypeGUID", "alias": "GlobalID_rel", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GlobalID_rel" } ], "indexes": [ { "name": "UUID_4169", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R4169_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_11148_Global", "fields": "GlobalID_rel", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Ancillary_Structures_Inspections", "description": "", "prototype": { "attributes": { "LSS_DamBostonOfficeRemarks_txt": null, "GlobalID_rel": null, "LSS_InspectionId_s": null, "LSS_InventoryId_s": null, "LSS_InspectionTypeId_s": null, "LSS_InspectionDate_d": null, "LSS_DistHWYEngineerId_L": null, "LSS_Weather_s": null, "LSS_AirTempF_s": null, "LSS_TeamLeaderId_L": null, "LSS_ProjectManagerId_L": null, "LSS_ConsultantName_txt": null, "LSS_Cracks_b": null, "LSS_CondFoundationCurr_s": null, "LSS_CondFoundationPrev_s": null, "LSS_CondStructureCurr_s": null, "LSS_CondStructurePrev_s": null, "LSS_StructAttachmentsCurr_s": null, "LSS_StructAttachmentsPrev_s": null, "LSS_CondSignPanelsCurr_s": null, "LSS_CondSignPanelsPrev_s": null, "LSS_CondTrafficSafetyCurr_s": null, "LSS_CondTrafficSafetyPrev_s": null, "LSS_CondLuminaireCurr_s": null, "LSS_CondLuminairePrev_s": null, "LSS_CondOverallCurr_s": null, "LSS_CondOverallPrev_s": null, "LSS_Recommendations_txt": null, "LSS_TotalAccessibilityHours_r": null, "LSS_Plans_b": null, "LSS_Photos_b": null, "LSS_DateOfPhotos_d": null, "LSS_FieldTestPerformed_txt": null, "LSS_GeneralComments_txt": null, "LSS_CsrRating_txt": null, "LSS_CsrRatingYear_txt": null, "LSS_LanesUnderStructure_txt": null, "LSS_ADT_s": null, "LSS_ADTYear_s": null, "LSS_AdditionalComments_txt": null, "LSS_Complete_b": null, "LSS_CompleteDate_d": null, "LSS_Reviewed_L": null, "LSS_ReviewDate_d": null, "LSS_Approved_L": null, "LSS_ApprovedDate_d": null, "LSS_CreatedBy_s": null, "LSS_CreatedISODate_s": null, "LSS_ModifiedBy_s": null, "LSS_ModifiedISODate_s": null, "LSS_ApprovalComments_txt": null, "LSS_DMeterNotes_txt": null, "LSS_Inspection_UUIDKey_s": null, "LSS_Damage_d": null, "LSS_DamageBy_s": null, "LSS_DamageAccidentReport_B": null, "LSS_DamageReimbursementNo_s": null, "LSS_DamageCause_txt": null, "LSS_DamBostonCopyForwardTo_s": null, "LSS_DamBostonOffice_d": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract,ChangeTracking", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }