{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 15, "name": "Cemetery Master Table", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user", "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false } }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "Graves", "relatedTableId": 8, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "LinkID", "composite": false, "catalogID": "{64B533F4-558F-4CEC-8960-514412659914}" } ], "isDataVersioned": true, "isDataArchived": false, "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, "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": "GlobalID", "displayField": "DLastName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Block", "type": "esriFieldTypeSmallInteger", "alias": "Block", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Block" }, { "name": "BlockDirection", "type": "esriFieldTypeString", "alias": "Block Direction", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "BlockDirection" }, { "name": "Lot", "type": "esriFieldTypeSmallInteger", "alias": "Lot", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Lot" }, { "name": "Tract", "type": "esriFieldTypeString", "alias": "Tract", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "Tract" }, { "name": "Grave", "type": "esriFieldTypeSmallInteger", "alias": "Grave", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Grave" }, { "name": "Segment", "type": "esriFieldTypeString", "alias": "Segment", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "Segment" }, { "name": "Lvl", "type": "esriFieldTypeSmallInteger", "alias": "Level", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Lvl" }, { "name": "DLastName", "type": "esriFieldTypeString", "alias": "Deceased Last Name", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "DLastName" }, { "name": "DFirstName", "type": "esriFieldTypeString", "alias": "Deceased First Name", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "DFirstName" }, { "name": "DMiddleName", "type": "esriFieldTypeString", "alias": "Deceased Middle Name", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "DMiddleName" }, { "name": "DAdditionalName", "type": "esriFieldTypeString", "alias": "DAdditionalName", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "DAdditionalName" }, { "name": "DeathCause", "type": "esriFieldTypeString", "alias": "Cause of Death", "domain": null, "editable": true, "nullable": true, "length": 79, "defaultValue": null, "modelName": "DeathCause" }, { "name": "BurialNumber", "type": "esriFieldTypeInteger", "alias": "BurialNumber", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BurialNumber" }, { "name": "Age", "type": "esriFieldTypeSmallInteger", "alias": "Age", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Age" }, { "name": "BirthPlace", "type": "esriFieldTypeString", "alias": "Birth Place", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "BirthPlace" }, { "name": "DeathPlace", "type": "esriFieldTypeString", "alias": "Death Place", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "DeathPlace" }, { "name": "Sex", "type": "esriFieldTypeString", "alias": "Gender", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "Sex" }, { "name": "Veteran", "type": "esriFieldTypeString", "alias": "Veterans Code", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Veteran" }, { "name": "Mortuary", "type": "esriFieldTypeString", "alias": "Mortuary", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Mortuary" }, { "name": "VaultCo", "type": "esriFieldTypeString", "alias": "Vault Company", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "VaultCo" }, { "name": "OLastName", "type": "esriFieldTypeString", "alias": "Owner Last Name", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "OLastName" }, { "name": "OFirstName", "type": "esriFieldTypeString", "alias": "Owner First Name", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "OFirstName" }, { "name": "OMiddleName", "type": "esriFieldTypeString", "alias": "Owner Middle Name", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "OMiddleName" }, { "name": "OAddress", "type": "esriFieldTypeString", "alias": "Owner Address", "domain": null, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "OAddress" }, { "name": "OCity", "type": "esriFieldTypeString", "alias": "Owner City", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "OCity" }, { "name": "OZip", "type": "esriFieldTypeInteger", "alias": "Owner Zip", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OZip" }, { "name": "OPhone", "type": "esriFieldTypeDouble", "alias": "Owner Phone", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OPhone" }, { "name": "OrderNumber", "type": "esriFieldTypeInteger", "alias": "OrderNumber", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OrderNumber" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Comments" }, { "name": "PurchaseAmount", "type": "esriFieldTypeDouble", "alias": "Purchase Amount", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseAmount" }, { "name": "TypeOfHeadstone", "type": "esriFieldTypeString", "alias": "TypeOfHeadstone", "domain": null, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "TypeOfHeadstone" }, { "name": "HeadStoneMaterial", "type": "esriFieldTypeString", "alias": "Head Stone Material", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "HeadStoneMaterial" }, { "name": "HeadStoneColor", "type": "esriFieldTypeString", "alias": "Head Stone Color", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "HeadStoneColor" }, { "name": "HeadStoneDesc", "type": "esriFieldTypeString", "alias": "Stone Description", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "HeadStoneDesc" }, { "name": "LinkID", "type": "esriFieldTypeString", "alias": "LinkID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LinkID" }, { "name": "VeteranComments", "type": "esriFieldTypeString", "alias": "VeteranComments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "VeteranComments" }, { "name": "DFullName", "type": "esriFieldTypeString", "alias": "Deceased Full Name", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "DFullName" }, { "name": "OFullName", "type": "esriFieldTypeString", "alias": "Owner Full Name", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "OFullName" }, { "name": "URL", "type": "esriFieldTypeString", "alias": "URL", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "URL" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "BirthDate", "type": "esriFieldTypeDate", "alias": "BirthDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "BirthDate" }, { "name": "DeathDate", "type": "esriFieldTypeDate", "alias": "DeathDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DeathDate" }, { "name": "BurialDate", "type": "esriFieldTypeDate", "alias": "BurialDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "BurialDate" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "PurchaseDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "Obituary", "type": "esriFieldTypeString", "alias": "Obituary", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Obituary" } ], "indexes": [ { "name": "R1005_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "GDB_12278_LinkID", "isAscending": true, "isUnique": false, "description": "", "fields": "LinkID" }, { "name": "UUID_1005", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID" }, { "name": "UUID_OID_1005", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID,OBJECTID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Mountain Standard Time", "timeZoneIANA": "America/Denver", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Mountain Standard Time", "timeZoneIANA": "America/Denver", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "Cemetery Master Table", "description": "", "prototype": { "attributes": { "PurchaseDate": null, "BurialDate": null, "Block": null, "BlockDirection": null, "Lot": null, "Tract": null, "Grave": null, "Segment": null, "Lvl": null, "DLastName": null, "DFirstName": null, "DMiddleName": null, "DAdditionalName": null, "DeathCause": null, "BurialNumber": null, "Age": null, "BirthPlace": null, "DeathPlace": null, "Sex": null, "Veteran": null, "Mortuary": null, "VaultCo": null, "OLastName": null, "OFirstName": null, "OMiddleName": null, "OAddress": null, "OCity": null, "OZip": null, "OPhone": null, "OrderNumber": null, "Comments": null, "PurchaseAmount": null, "TypeOfHeadstone": null, "HeadStoneMaterial": null, "HeadStoneColor": null, "HeadStoneDesc": null, "LinkID": null, "VeteranComments": null, "DFullName": null, "OFullName": null, "URL": null, "Obituary": null, "BirthDate": null, "DeathDate": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Update,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }