{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 13, "name": "brookdale.DBO.BROOKDALEGRAVES", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "BrookdaleLots", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Lot_Number", "composite": false, "catalogID": "{4B9EB1B1-35F0-4D45-9054-FCF5DBF41B55}" }, { "id": 3, "name": "brookdale.DBO.BrookdaleLots", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Lot_Number", "composite": false, "catalogID": "{B8423412-8BAE-4D4D-8375-0DD7CB2978BF}" }, { "id": 2, "name": "maine_relate1", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID", "composite": false, "catalogID": "{CD4AE14D-9C65-46D3-BD62-963EC96B8B42}" } ], "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": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "globalid", "displayField": "Lot_Number", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "lot_number", "type": "esriFieldTypeString", "alias": "Lot_Number", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "lot_number" }, { "name": "grave_number", "type": "esriFieldTypeString", "alias": "Grave_Number", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "grave_number" }, { "name": "vaulttype", "type": "esriFieldTypeString", "alias": "VaultType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "vaulttype" }, { "name": "depth", "type": "esriFieldTypeString", "alias": "Depth", "domain": { "type": "codedValue", "name": "BurialDepth", "description": "Burial Depth", "codedValues": [ { "name": "Ashes", "code": "Ashes" }, { "name": "2'0\"", "code": "2'0\"" }, { "name": "2'3\"", "code": "2'3\"" }, { "name": "2'6\"", "code": "2'6\"" }, { "name": "2'9\"", "code": "2'9\"" }, { "name": "3'0\"", "code": "3'0\"" }, { "name": "3'3\"", "code": "3'3\"" }, { "name": "3'6\"", "code": "3'6\"" }, { "name": "3'9\"", "code": "3'9\"" }, { "name": "4'0\"", "code": "4'0\"" }, { "name": "4'3\"", "code": "4'3\"" }, { "name": "4'6\"", "code": "4'6\"" }, { "name": "4'9\"", "code": "4'9\"" }, { "name": "5'0\"", "code": "5'0\"" }, { "name": "5'3\"", "code": "5'3\"" }, { "name": "5'6\"", "code": "5'6\"" }, { "name": "5'9\"", "code": "5'9\"" }, { "name": "6'0\"", "code": "6'0\"" }, { "name": "6'3\"", "code": "6'3\"" }, { "name": "6'6\"", "code": "6'6\"" }, { "name": "6'9\"", "code": "6'9\"" }, { "name": "7'0\"", "code": "7'0\"" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "depth" }, { "name": "deceased_last", "type": "esriFieldTypeString", "alias": "Deceased_Last", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "deceased_last" }, { "name": "deceased_first", "type": "esriFieldTypeString", "alias": "Deceased_First", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "deceased_first" }, { "name": "deceased_title", "type": "esriFieldTypeString", "alias": "Deceased_Title", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "deceased_title" }, { "name": "deathdate", "type": "esriFieldTypeDate", "alias": "DeathDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "deathdate" }, { "name": "ageatdeath_yr", "type": "esriFieldTypeSmallInteger", "alias": "AgeAtDeath_Yr", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ageatdeath_yr" }, { "name": "ageatdeath_mo", "type": "esriFieldTypeSmallInteger", "alias": "AgeAtDeath_Mo", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ageatdeath_mo" }, { "name": "ageatdeath_day", "type": "esriFieldTypeSmallInteger", "alias": "AgeAtDeath_Day", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ageatdeath_day" }, { "name": "burialdate", "type": "esriFieldTypeDate", "alias": "BurialDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "burialdate" }, { "name": "lk_add", "type": "esriFieldTypeString", "alias": "LK_Add", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "lk_add" }, { "name": "lk_town", "type": "esriFieldTypeString", "alias": "LK_Town", "domain": null, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "lk_town" }, { "name": "lk_state", "type": "esriFieldTypeString", "alias": "LK_State", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "lk_state" }, { "name": "lk_country", "type": "esriFieldTypeString", "alias": "LK_Country", "domain": null, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "lk_country" }, { "name": "town_of_death", "type": "esriFieldTypeString", "alias": "Town_of_Death", "domain": null, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "Veteran" }, { "name": "state_of_death", "type": "esriFieldTypeString", "alias": "State_of_Death", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "state_of_death" }, { "name": "veteran", "type": "esriFieldTypeString", "alias": "Veteran", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Veteran" }, { "name": "legalrep_last", "type": "esriFieldTypeString", "alias": "LegalRep_Last", "domain": null, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "legalrep_last" }, { "name": "legalrep_first", "type": "esriFieldTypeString", "alias": "LegalRep_First", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "legalrep_first" }, { "name": "legalrep_title", "type": "esriFieldTypeString", "alias": "LegalRep_Title", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "legalrep_title" }, { "name": "legalrep_add", "type": "esriFieldTypeString", "alias": "LegalRep_Add", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "legalrep_add" }, { "name": "legalrep_town", "type": "esriFieldTypeString", "alias": "LegalRep_Town", "domain": null, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "legalrep_town" }, { "name": "legalrep_state", "type": "esriFieldTypeString", "alias": "LegalRep_State", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "legalrep_state" }, { "name": "undertaker", "type": "esriFieldTypeString", "alias": "Undertaker", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "undertaker" }, { "name": "openingfee", "type": "esriFieldTypeInteger", "alias": "OpeningFee", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "openingfee" }, { "name": "overtimefee", "type": "esriFieldTypeInteger", "alias": "OvertimeFee", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "overtimefee" }, { "name": "remarks", "type": "esriFieldTypeString", "alias": "Remarks", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "remarks" }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "occupied", "type": "esriFieldTypeSmallInteger", "alias": "Occupied", "domain": { "type": "codedValue", "name": "BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Occupied" }, { "name": "gravetype", "type": "esriFieldTypeString", "alias": "Grave Type", "domain": { "type": "codedValue", "name": "GraveType", "description": "Grave Types", "codedValues": [ { "name": "Ashes", "code": "Ashes" }, { "name": "Other", "code": "Other" }, { "name": "Single", "code": "Single" }, { "name": "Double", "code": "Double" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "GraveType" }, { "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": "totalcost", "type": "esriFieldTypeInteger", "alias": "Total Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "totalcost" }, { "name": "totalgravecost", "type": "esriFieldTypeInteger", "alias": "Total Grave Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "totalgravecost" }, { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "guid", "type": "esriFieldTypeInteger", "alias": "guid", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "guid" } ], "indexes": [ { "name": "g30lot_number", "isAscending": true, "isUnique": false, "description": "", "fields": "lot_number" }, { "name": "i30guid", "isAscending": true, "isUnique": false, "description": "", "fields": "guid" }, { "name": "r16_sde_rowid_uk", "isAscending": true, "isUnique": true, "description": "", "fields": "objectid" }, { "name": "uuid_16", "isAscending": true, "isUnique": true, "description": "", "fields": "globalid" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "brookdale.DBO.BROOKDALEGRAVES", "description": "", "prototype": { "attributes": { "totalgravecost": null, "lot_number": null, "grave_number": null, "vaulttype": null, "depth": null, "deceased_last": null, "deceased_first": null, "deceased_title": null, "deathdate": null, "ageatdeath_yr": null, "ageatdeath_mo": null, "ageatdeath_day": null, "burialdate": null, "lk_add": null, "lk_town": null, "lk_state": null, "lk_country": null, "town_of_death": null, "state_of_death": null, "veteran": null, "legalrep_last": null, "legalrep_first": null, "legalrep_title": null, "legalrep_add": null, "legalrep_town": null, "legalrep_state": null, "undertaker": null, "openingfee": null, "overtimefee": null, "remarks": null, "guid": null, "occupied": null, "gravetype": null, "totalcost": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }