{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "CEMETERY_PLOT_RECORDS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "name_key", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "length": 8, "domain": null }, { "name": "plot_code", "type": "esriFieldTypeString", "alias": "plot_code", "length": 64, "domain": null }, { "name": "ce_id", "type": "esriFieldTypeString", "alias": "ce_id", "length": 12, "domain": null }, { "name": "yyyymmdd_key", "type": "esriFieldTypeString", "alias": "yyyymmdd_key", "length": 8, "domain": null }, { "name": "name_key", "type": "esriFieldTypeString", "alias": "name_key", "length": 20, "domain": null }, { "name": "ce_unique_id", "type": "esriFieldTypeInteger", "alias": "ce_unique_id", "domain": null }, { "name": "key_4", "type": "esriFieldTypeString", "alias": "key_4", "length": 50, "domain": null }, { "name": "surname", "type": "esriFieldTypeString", "alias": "surname", "length": 50, "domain": null }, { "name": "first_names", "type": "esriFieldTypeString", "alias": "first_names", "length": 50, "domain": null }, { "name": "place_of_birth", "type": "esriFieldTypeString", "alias": "place_of_birth", "length": 50, "domain": null }, { "name": "place_of_death", "type": "esriFieldTypeString", "alias": "place_of_death", "length": 50, "domain": null }, { "name": "occupation", "type": "esriFieldTypeString", "alias": "occupation", "length": 60, "domain": null }, { "name": "from_address_1", "type": "esriFieldTypeString", "alias": "from_address_1", "length": 50, "domain": null }, { "name": "from_address_2", "type": "esriFieldTypeString", "alias": "from_address_2", "length": 50, "domain": null }, { "name": "nationality", "type": "esriFieldTypeString", "alias": "nationality", "length": 25, "domain": null }, { "name": "number_of_years_local", "type": "esriFieldTypeSmallInteger", "alias": "number_of_years_local", "domain": null }, { "name": "gender", "type": "esriFieldTypeString", "alias": "gender", "length": 1, "domain": null }, { "name": "marital_status", "type": "esriFieldTypeString", "alias": "marital_status", "length": 5, "domain": null }, { "name": "status", "type": "esriFieldTypeString", "alias": "status", "length": 2, "domain": null }, { "name": "page_no", "type": "esriFieldTypeString", "alias": "page_no", "length": 10, "domain": null }, { "name": "plot_no_1", "type": "esriFieldTypeString", "alias": "plot_no_1", "length": 15, "domain": null }, { "name": "plot_no_2", "type": "esriFieldTypeString", "alias": "plot_no_2", "length": 15, "domain": null }, { "name": "plot_id", "type": "esriFieldTypeString", "alias": "plot_id", "length": 12, "domain": null }, { "name": "cemetery_block", "type": "esriFieldTypeString", "alias": "cemetery_block", "length": 10, "domain": null }, { "name": "cremation_number", "type": "esriFieldTypeString", "alias": "cremation_number", "length": 10, "domain": null }, { "name": "grave_or_ashes", "type": "esriFieldTypeString", "alias": "grave_or_ashes", "length": 1, "domain": null }, { "name": "depth_of_grave", "type": "esriFieldTypeString", "alias": "depth_of_grave", "length": 2, "domain": null }, { "name": "plot_size", "type": "esriFieldTypeString", "alias": "plot_size", "length": 20, "domain": null }, { "name": "casket_size", "type": "esriFieldTypeString", "alias": "casket_size", "length": 20, "domain": null }, { "name": "reference", "type": "esriFieldTypeBigInteger", "alias": "reference", "domain": null }, { "name": "warranty_number", "type": "esriFieldTypeString", "alias": "warranty_number", "length": 6, "domain": null }, { "name": "warranty_date", "type": "esriFieldTypeString", "alias": "warranty_date", "length": 50, "domain": null }, { "name": "type_code", "type": "esriFieldTypeString", "alias": "type_code", "length": 4, "domain": null }, { "name": "cemetery_code", "type": "esriFieldTypeString", "alias": "cemetery_code", "length": 4, "domain": null }, { "name": "area_code", "type": "esriFieldTypeString", "alias": "area_code", "length": 16, "domain": null }, { "name": "section", "type": "esriFieldTypeString", "alias": "section", "length": 10, "domain": null }, { "name": "placement", "type": "esriFieldTypeString", "alias": "placement", "length": 60, "domain": null }, { "name": "gis_ref", "type": "esriFieldTypeString", "alias": "gis_ref", "length": 20, "domain": null }, { "name": "longitude", "type": "esriFieldTypeDouble", "alias": "longitude", "domain": null }, { "name": "latitude", "type": "esriFieldTypeDouble", "alias": "latitude", "domain": null }, { "name": "age", "type": "esriFieldTypeSmallInteger", "alias": "age", "domain": null }, { "name": "age_desc", "type": "esriFieldTypeString", "alias": "age_desc", "length": 10, "domain": null }, { "name": "age_months", "type": "esriFieldTypeSmallInteger", "alias": "age_months", "domain": null }, { "name": "date_of_birth", "type": "esriFieldTypeString", "alias": "date_of_birth", "length": 50, "domain": null }, { "name": "date_of_death", "type": "esriFieldTypeString", "alias": "date_of_death", "length": 50, "domain": null }, { "name": "certifying_doctor", "type": "esriFieldTypeString", "alias": "certifying_doctor", "length": 60, "domain": null }, { "name": "stillborn_detail", "type": "esriFieldTypeString", "alias": "stillborn_detail", "length": 60, "domain": null }, { "name": "date_of_interment", "type": "esriFieldTypeString", "alias": "date_of_interment", "length": 50, "domain": null }, { "name": "funeral_date", "type": "esriFieldTypeString", "alias": "funeral_date", "length": 50, "domain": null }, { "name": "funeral_time", "type": "esriFieldTypeSmallInteger", "alias": "funeral_time", "domain": null }, { "name": "date_of_purchase", "type": "esriFieldTypeString", "alias": "date_of_purchase", "length": 50, "domain": null }, { "name": "purchase_certificate_number", "type": "esriFieldTypeString", "alias": "purchase_certificate_number", "length": 10, "domain": null }, { "name": "purchase_receipt_number", "type": "esriFieldTypeString", "alias": "purchase_receipt_number", "length": 10, "domain": null }, { "name": "purchase_amount", "type": "esriFieldTypeDouble", "alias": "purchase_amount", "domain": null }, { "name": "purchaser_unique_id", "type": "esriFieldTypeInteger", "alias": "purchaser_unique_id", "domain": null }, { "name": "purchaser_name", "type": "esriFieldTypeString", "alias": "purchaser_name", "length": 40, "domain": null }, { "name": "purchaser_address_1", "type": "esriFieldTypeString", "alias": "purchaser_address_1", "length": 40, "domain": null }, { "name": "purchaser_address_2", "type": "esriFieldTypeString", "alias": "purchaser_address_2", "length": 40, "domain": null }, { "name": "reservation_date", "type": "esriFieldTypeDate", "alias": "reservation_date", "length": 8, "precision": 1, "domain": null }, { "name": "reservation_amount", "type": "esriFieldTypeDouble", "alias": "reservation_amount", "domain": null }, { "name": "reservation_detail", "type": "esriFieldTypeString", "alias": "reservation_detail", "length": 50, "domain": null }, { "name": "amount_2", "type": "esriFieldTypeDouble", "alias": "amount_2", "domain": null }, { "name": "old_money", "type": "esriFieldTypeString", "alias": "old_money", "length": 10, "domain": null }, { "name": "old_money_2", "type": "esriFieldTypeString", "alias": "old_money_2", "length": 10, "domain": null }, { "name": "amount_3", "type": "esriFieldTypeDouble", "alias": "amount_3", "domain": null }, { "name": "amount_4", "type": "esriFieldTypeDouble", "alias": "amount_4", "domain": null }, { "name": "amount_5", "type": "esriFieldTypeDouble", "alias": "amount_5", "domain": null }, { "name": "denomination_code", "type": "esriFieldTypeString", "alias": "denomination_code", "length": 4, "domain": null }, { "name": "cleric_name", "type": "esriFieldTypeString", "alias": "cleric_name", "length": 25, "domain": null }, { "name": "denomination_note", "type": "esriFieldTypeString", "alias": "denomination_note", "length": 40, "domain": null }, { "name": "funeral_director_code", "type": "esriFieldTypeString", "alias": "funeral_director_code", "length": 4, "domain": null }, { "name": "funeral_director_note", "type": "esriFieldTypeString", "alias": "funeral_director_note", "length": 50, "domain": null }, { "name": "rsa_yn", "type": "esriFieldTypeString", "alias": "rsa_yn", "length": 1, "domain": null }, { "name": "service_number", "type": "esriFieldTypeString", "alias": "service_number", "length": 20, "domain": null }, { "name": "reporting_codes", "type": "esriFieldTypeString", "alias": "reporting_codes", "length": 50, "domain": null }, { "name": "headstone_permit_no", "type": "esriFieldTypeString", "alias": "headstone_permit_no", "length": 20, "domain": null }, { "name": "headstone_permit_date", "type": "esriFieldTypeDate", "alias": "headstone_permit_date", "length": 8, "precision": 1, "domain": null }, { "name": "headstone_permit_issued_to", "type": "esriFieldTypeString", "alias": "headstone_permit_issued_to", "length": 40, "domain": null }, { "name": "headstone_ref", "type": "esriFieldTypeString", "alias": "headstone_ref", "length": 30, "domain": null }, { "name": "headstone_inscription_code", "type": "esriFieldTypeString", "alias": "headstone_inscription_code", "length": 30, "domain": null }, { "name": "date_added", "type": "esriFieldTypeString", "alias": "date_added", "length": 50, "domain": null }, { "name": "changed_date", "type": "esriFieldTypeString", "alias": "changed_date", "length": 50, "domain": null }, { "name": "web_ready_date", "type": "esriFieldTypeString", "alias": "web_ready_date", "length": 50, "domain": null }, { "name": "public_yn", "type": "esriFieldTypeString", "alias": "public_yn", "length": 1, "domain": null }, { "name": "review_accuracy_perc", "type": "esriFieldTypeSmallInteger", "alias": "review_accuracy_perc", "domain": null }, { "name": "review_accuracy_detail", "type": "esriFieldTypeString", "alias": "review_accuracy_detail", "length": 60, "domain": null }, { "name": "cause_of_death", "type": "esriFieldTypeString", "alias": "cause_of_death", "length": 60, "domain": null }, { "name": "delta", "type": "esriFieldTypeString", "alias": "delta", "length": 1, "domain": null }, { "name": "update_time", "type": "esriFieldTypeString", "alias": "update_time", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_270_plot_code", "fields": "plot_code", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Belongs to Plot", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "plot_code", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{079FE5B7-6783-4F54-9613-905096C5A247}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }