{
"currentVersion": 10.91,
"cimVersion": "2.9.0",
"id": 1,
"name": "ADA_Facilities_Table",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": {
"creationDateField": "created_date",
"creatorField": "created_user",
"editDateField": "last_edited_date",
"editorField": "last_edited_user",
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
}
},
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": true,
"relationships": [
{
"id": 0,
"name": "cityWorks.DBO.ADA_Facilities",
"relatedTableId": 0,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleDestination",
"keyField": "Location",
"composite": false
}
],
"isDataVersioned": true,
"isDataArchived": true,
"infoInEstimates": [
"count"
],
"isDataBranchVersioned": true,
"isDataReplicaTracked": true,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": true,
"startArchivingMoment": 1673622197000
},
"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
},
"hasMetadata": true,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": true,
"supportsOidReservation": true,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "GlobalID",
"displayField": "OBJECTID",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "Owned__Leased",
"type": "esriFieldTypeString",
"alias": "Owned/ Leased",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Owned__Leased"
},
{
"name": "cityWorks.DBO.ADA_Facilities_Table.Area",
"type": "esriFieldTypeString",
"alias": "cityWorks.DBO.ADA_Facilities_Table.Area",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "cityWorks.DBO.ADA_Facilities_Table.Area"
},
{
"name": "Room_space",
"type": "esriFieldTypeString",
"alias": "Room/space",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Room_space"
},
{
"name": "Room_Space_Description",
"type": "esriFieldTypeString",
"alias": "Room/Space Description",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Room_Space_Description"
},
{
"name": "Room_Space_Type",
"type": "esriFieldTypeString",
"alias": "Room/Space Type",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Room_Space_Type"
},
{
"name": "Element",
"type": "esriFieldTypeString",
"alias": "Element",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Element"
},
{
"name": "Element_Description",
"type": "esriFieldTypeString",
"alias": "Element Description",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Element_Description"
},
{
"name": "Latitude",
"type": "esriFieldTypeDouble",
"alias": "Latitude",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "Latitude"
},
{
"name": "Longitude",
"type": "esriFieldTypeDouble",
"alias": "Longitude",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "Longitude"
},
{
"name": "Attribute",
"type": "esriFieldTypeString",
"alias": "Attribute",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Attribute"
},
{
"name": "Attribute_Description",
"type": "esriFieldTypeString",
"alias": "Attribute Description",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Attribute_Description"
},
{
"name": "On_Site_Value",
"type": "esriFieldTypeString",
"alias": "On-Site Value",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "On_Site_Value"
},
{
"name": "Compliant",
"type": "esriFieldTypeString",
"alias": "Compliant",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Compliant"
},
{
"name": "Program_Access_",
"type": "esriFieldTypeString",
"alias": "Program Access?",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Program_Access_"
},
{
"name": "Finding",
"type": "esriFieldTypeString",
"alias": "Finding",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Finding"
},
{
"name": "Photo_Reference_Number",
"type": "esriFieldTypeString",
"alias": "Photo Reference Number",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Photo_Reference_Number"
},
{
"name": "Priority",
"type": "esriFieldTypeString",
"alias": "Priority",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Priority"
},
{
"name": "Recommendation",
"type": "esriFieldTypeString",
"alias": "Recommendation",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Recommendation"
},
{
"name": "Recommended_Value",
"type": "esriFieldTypeString",
"alias": "Recommended Value",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Recommended_Value"
},
{
"name": "Element_Citation",
"type": "esriFieldTypeString",
"alias": "Element_Citation",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Element_Citation"
},
{
"name": "Mitigation_Difficulty",
"type": "esriFieldTypeString",
"alias": "Mitigation Difficulty",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Mitigation_Difficulty"
},
{
"name": "Milestone_Date",
"type": "esriFieldTypeString",
"alias": "Milestone Date",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Milestone_Date"
},
{
"name": "Milestone_Months",
"type": "esriFieldTypeInteger",
"alias": "Milestone Months",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "Milestone_Months"
},
{
"name": "Suggested_Net_Priority__1__High",
"type": "esriFieldTypeInteger",
"alias": "Suggested Net Priority (1- High to 15-Low)",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "Suggested_Net_Priority__1__High"
},
{
"name": "Resolution_Status",
"type": "esriFieldTypeString",
"alias": "Resolution Status",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Resolution_Status"
},
{
"name": "Resolution_Comments",
"type": "esriFieldTypeString",
"alias": "Resolution Comments",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Resolution_Comments"
},
{
"name": "Column1",
"type": "esriFieldTypeInteger",
"alias": "Column1",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "Column1"
},
{
"name": "Column2",
"type": "esriFieldTypeString",
"alias": "Column2",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Column2"
},
{
"name": "Column3",
"type": "esriFieldTypeString",
"alias": "Column3",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "Column3"
},
{
"name": "FacilityID",
"type": "esriFieldTypeString",
"alias": "FacilityID",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "FacilityID"
},
{
"name": "Location",
"type": "esriFieldTypeString",
"alias": "Location",
"domain": null,
"editable": true,
"nullable": true,
"length": 250,
"defaultValue": null,
"modelName": "Location"
},
{
"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"
}
],
"indexes": [
{
"name": "UUID_97",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "GDB_138_Location",
"fields": "Location",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "R97_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": false,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "Mountain Standard Time",
"respectsDaylightSaving": false
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "ADA_Facilities_Table",
"description": "",
"prototype": {
"attributes": {
"Location": null,
"Owned__Leased": null,
"cityWorks.DBO.ADA_Facilities_Table.Area": null,
"Room_space": null,
"Room_Space_Description": null,
"Room_Space_Type": null,
"Element": null,
"Element_Description": null,
"Latitude": null,
"Longitude": null,
"Attribute": null,
"Attribute_Description": null,
"On_Site_Value": null,
"Compliant": null,
"Program_Access_": null,
"Finding": null,
"Photo_Reference_Number": null,
"Priority": null,
"Recommendation": null,
"Recommended_Value": null,
"Element_Citation": null,
"Mitigation_Difficulty": null,
"Milestone_Date": null,
"Milestone_Months": null,
"Suggested_Net_Priority__1__High": null,
"Resolution_Status": null,
"Resolution_Comments": null,
"Column1": null,
"Column2": null,
"Column3": null,
"FacilityID": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 2000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb",
"capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking",
"useStandardizedQueries": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 2000,
"maxRecordCountFactor": 1,
"serviceItemId": "fe2f127ad50446aaaf1b6a01231f073e"
}