Name: CEMETERY_PLOT_RECORDS
Display Field: name_key
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID, length: 8
)
-
plot_code
(
type: esriFieldTypeString, alias: plot_code, length: 64
)
-
ce_id
(
type: esriFieldTypeString, alias: ce_id, length: 12
)
-
yyyymmdd_key
(
type: esriFieldTypeString, alias: yyyymmdd_key, length: 8
)
-
name_key
(
type: esriFieldTypeString, alias: name_key, length: 20
)
-
ce_unique_id
(
type: esriFieldTypeInteger, alias: ce_unique_id
)
-
key_4
(
type: esriFieldTypeString, alias: key_4, length: 50
)
-
surname
(
type: esriFieldTypeString, alias: surname, length: 50
)
-
first_names
(
type: esriFieldTypeString, alias: first_names, length: 50
)
-
place_of_birth
(
type: esriFieldTypeString, alias: place_of_birth, length: 50
)
-
place_of_death
(
type: esriFieldTypeString, alias: place_of_death, length: 50
)
-
occupation
(
type: esriFieldTypeString, alias: occupation, length: 60
)
-
from_address_1
(
type: esriFieldTypeString, alias: from_address_1, length: 50
)
-
from_address_2
(
type: esriFieldTypeString, alias: from_address_2, length: 50
)
-
nationality
(
type: esriFieldTypeString, alias: nationality, length: 25
)
-
number_of_years_local
(
type: esriFieldTypeSmallInteger, alias: number_of_years_local
)
-
gender
(
type: esriFieldTypeString, alias: gender, length: 1
)
-
marital_status
(
type: esriFieldTypeString, alias: marital_status, length: 5
)
-
status
(
type: esriFieldTypeString, alias: status, length: 2
)
-
page_no
(
type: esriFieldTypeString, alias: page_no, length: 10
)
-
plot_no_1
(
type: esriFieldTypeString, alias: plot_no_1, length: 15
)
-
plot_no_2
(
type: esriFieldTypeString, alias: plot_no_2, length: 15
)
-
plot_id
(
type: esriFieldTypeString, alias: plot_id, length: 12
)
-
cemetery_block
(
type: esriFieldTypeString, alias: cemetery_block, length: 10
)
-
cremation_number
(
type: esriFieldTypeString, alias: cremation_number, length: 10
)
-
grave_or_ashes
(
type: esriFieldTypeString, alias: grave_or_ashes, length: 1
)
-
depth_of_grave
(
type: esriFieldTypeString, alias: depth_of_grave, length: 2
)
-
plot_size
(
type: esriFieldTypeString, alias: plot_size, length: 20
)
-
casket_size
(
type: esriFieldTypeString, alias: casket_size, length: 20
)
-
reference
(
type: esriFieldTypeBigInteger, alias: reference
)
-
warranty_number
(
type: esriFieldTypeString, alias: warranty_number, length: 6
)
-
warranty_date
(
type: esriFieldTypeString, alias: warranty_date, length: 50
)
-
type_code
(
type: esriFieldTypeString, alias: type_code, length: 4
)
-
cemetery_code
(
type: esriFieldTypeString, alias: cemetery_code, length: 4
)
-
area_code
(
type: esriFieldTypeString, alias: area_code, length: 16
)
-
section
(
type: esriFieldTypeString, alias: section, length: 10
)
-
placement
(
type: esriFieldTypeString, alias: placement, length: 60
)
-
gis_ref
(
type: esriFieldTypeString, alias: gis_ref, length: 20
)
-
longitude
(
type: esriFieldTypeDouble, alias: longitude
)
-
latitude
(
type: esriFieldTypeDouble, alias: latitude
)
-
age
(
type: esriFieldTypeSmallInteger, alias: age
)
-
age_desc
(
type: esriFieldTypeString, alias: age_desc, length: 10
)
-
age_months
(
type: esriFieldTypeSmallInteger, alias: age_months
)
-
date_of_birth
(
type: esriFieldTypeString, alias: date_of_birth, length: 50
)
-
date_of_death
(
type: esriFieldTypeString, alias: date_of_death, length: 50
)
-
certifying_doctor
(
type: esriFieldTypeString, alias: certifying_doctor, length: 60
)
-
stillborn_detail
(
type: esriFieldTypeString, alias: stillborn_detail, length: 60
)
-
date_of_interment
(
type: esriFieldTypeString, alias: date_of_interment, length: 50
)
-
funeral_date
(
type: esriFieldTypeString, alias: funeral_date, length: 50
)
-
funeral_time
(
type: esriFieldTypeSmallInteger, alias: funeral_time
)
-
date_of_purchase
(
type: esriFieldTypeString, alias: date_of_purchase, length: 50
)
-
purchase_certificate_number
(
type: esriFieldTypeString, alias: purchase_certificate_number, length: 10
)
-
purchase_receipt_number
(
type: esriFieldTypeString, alias: purchase_receipt_number, length: 10
)
-
purchase_amount
(
type: esriFieldTypeDouble, alias: purchase_amount
)
-
purchaser_unique_id
(
type: esriFieldTypeInteger, alias: purchaser_unique_id
)
-
purchaser_name
(
type: esriFieldTypeString, alias: purchaser_name, length: 40
)
-
purchaser_address_1
(
type: esriFieldTypeString, alias: purchaser_address_1, length: 40
)
-
purchaser_address_2
(
type: esriFieldTypeString, alias: purchaser_address_2, length: 40
)
-
reservation_date
(
type: esriFieldTypeDate, alias: reservation_date, length: 8, precision: 1
)
-
reservation_amount
(
type: esriFieldTypeDouble, alias: reservation_amount
)
-
reservation_detail
(
type: esriFieldTypeString, alias: reservation_detail, length: 50
)
-
amount_2
(
type: esriFieldTypeDouble, alias: amount_2
)
-
old_money
(
type: esriFieldTypeString, alias: old_money, length: 10
)
-
old_money_2
(
type: esriFieldTypeString, alias: old_money_2, length: 10
)
-
amount_3
(
type: esriFieldTypeDouble, alias: amount_3
)
-
amount_4
(
type: esriFieldTypeDouble, alias: amount_4
)
-
amount_5
(
type: esriFieldTypeDouble, alias: amount_5
)
-
denomination_code
(
type: esriFieldTypeString, alias: denomination_code, length: 4
)
-
cleric_name
(
type: esriFieldTypeString, alias: cleric_name, length: 25
)
-
denomination_note
(
type: esriFieldTypeString, alias: denomination_note, length: 40
)
-
funeral_director_code
(
type: esriFieldTypeString, alias: funeral_director_code, length: 4
)
-
funeral_director_note
(
type: esriFieldTypeString, alias: funeral_director_note, length: 50
)
-
rsa_yn
(
type: esriFieldTypeString, alias: rsa_yn, length: 1
)
-
service_number
(
type: esriFieldTypeString, alias: service_number, length: 20
)
-
reporting_codes
(
type: esriFieldTypeString, alias: reporting_codes, length: 50
)
-
headstone_permit_no
(
type: esriFieldTypeString, alias: headstone_permit_no, length: 20
)
-
headstone_permit_date
(
type: esriFieldTypeDate, alias: headstone_permit_date, length: 8, precision: 1
)
-
headstone_permit_issued_to
(
type: esriFieldTypeString, alias: headstone_permit_issued_to, length: 40
)
-
headstone_ref
(
type: esriFieldTypeString, alias: headstone_ref, length: 30
)
-
headstone_inscription_code
(
type: esriFieldTypeString, alias: headstone_inscription_code, length: 30
)
-
date_added
(
type: esriFieldTypeString, alias: date_added, length: 50
)
-
changed_date
(
type: esriFieldTypeString, alias: changed_date, length: 50
)
-
web_ready_date
(
type: esriFieldTypeString, alias: web_ready_date, length: 50
)
-
public_yn
(
type: esriFieldTypeString, alias: public_yn, length: 1
)
-
review_accuracy_perc
(
type: esriFieldTypeSmallInteger, alias: review_accuracy_perc
)
-
review_accuracy_detail
(
type: esriFieldTypeString, alias: review_accuracy_detail, length: 60
)
-
cause_of_death
(
type: esriFieldTypeString, alias: cause_of_death, length: 60
)
-
delta
(
type: esriFieldTypeString, alias: delta, length: 1
)
-
update_time
(
type: esriFieldTypeString, alias: update_time, length: 50
)
Relationships:
Supported Operations:
Query
Query Attachments
Query Analytic
Query Related Records
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata