Name: Grave Transactions

Display Field: TransactionType

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: dd72859e88e24343869d0ff5b04490ea

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:

N/A

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: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: TransactionType

Fields:

• survey_submitter ( type: esriFieldTypeString, alias: Survey Submitter, length: 255 )
• graveupdate ( type: esriFieldTypeSmallInteger, alias: Grave Update Successful , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• graveupdateerror ( type: esriFieldTypeString, alias: Reason For Not Updating Grave, length: 255 )
• CEMETERY ( type: esriFieldTypeString, alias: Cemetery, length: 50 )
• BLOCK ( type: esriFieldTypeString, alias: Block, length: 10 )
• LOT ( type: esriFieldTypeString, alias: Lot, length: 10 )
• GRAVE ( type: esriFieldTypeString, alias: Grave, length: 10 )
• GRAVETYPE ( type: esriFieldTypeString, alias: Grave Type, length: 50 , Coded Values: [Infant: Infant] , [Cremation: Cremation] , [Double: Double Deep] , ...7 more... )
• STATUS ( type: esriFieldTypeString, alias: Status, length: 10 , Coded Values: [Available: Available] , [Sold: Sold] , [Closed: Closed] , ...1 more... )
• IOOF ( type: esriFieldTypeString, alias: IOOF Identifier, length: 50 )
• DOLNAME ( type: esriFieldTypeString, alias: Deed Owner Last Name, length: 255 )
• DOFNAME ( type: esriFieldTypeString, alias: Deed Owner First Name, length: 255 )
• DOMNAME ( type: esriFieldTypeString, alias: Deed Owner Middle Name, length: 255 )
• DOADDRESS ( type: esriFieldTypeString, alias: Deed Owner Address, length: 255 )
• GR_SOLD ( type: esriFieldTypeDate, alias: Date Grave Sold, length: 8 )
• LAND ( type: esriFieldTypeDouble, alias: Land Price )
• CARE ( type: esriFieldTypeDouble, alias: Endowment Care )
• LINER_SOLD ( type: esriFieldTypeDate, alias: Liner Sold, length: 8 )
• LINER_COST ( type: esriFieldTypeDouble, alias: Liner Cost )
• GRAVENOTES ( type: esriFieldTypeString, alias: Grave Notes, length: 500 )
• BP ( type: esriFieldTypeString, alias: Burial Permit Number, length: 50 )
• AGE ( type: esriFieldTypeString, alias: Age, length: 50 )
• BLNAME ( type: esriFieldTypeString, alias: Buried Last Name, length: 255 )
• BFNAME ( type: esriFieldTypeString, alias: Buried First Name, length: 255 )
• BMNAME ( type: esriFieldTypeString, alias: Buried Middle Name, length: 255 )
• DOB ( type: esriFieldTypeString, alias: Date of Birth, length: 50 )
• DOD ( type: esriFieldTypeString, alias: Data of Death, length: 50 )
• DOI ( type: esriFieldTypeString, alias: Date of Interment, length: 50 )
• POB ( type: esriFieldTypeString, alias: Place of Birth, length: 255 )
• POD ( type: esriFieldTypeString, alias: Place of Death, length: 255 )
• BURIALNOTES ( type: esriFieldTypeString, alias: Burial Notes, length: 255 )
• TYPEBURIAL ( type: esriFieldTypeString, alias: Type of Burial, length: 50 , Coded Values: [Regular: Regular] , [Cremation: Cremation] , [1st Double Deep: 1st Double Deep] , ...1 more... )
• BP2 ( type: esriFieldTypeString, alias: Burial Permit Number, length: 50 )
• AGE2 ( type: esriFieldTypeString, alias: Age, length: 50 )
• BLNAME2 ( type: esriFieldTypeString, alias: Buried Last Name, length: 255 )
• BFNAME2 ( type: esriFieldTypeString, alias: Buried First Name, length: 255 )
• BMNAME2 ( type: esriFieldTypeString, alias: Buried Middle Name, length: 255 )
• DOB2 ( type: esriFieldTypeString, alias: Date of Birth, length: 50 )
• DOD2 ( type: esriFieldTypeString, alias: Data of Death, length: 50 )
• DOI2 ( type: esriFieldTypeString, alias: Date of Interment, length: 50 )
• POB2 ( type: esriFieldTypeString, alias: Place of Birth, length: 255 )
• POD2 ( type: esriFieldTypeString, alias: Place of Death, length: 255 )
• BURIALNOTES2 ( type: esriFieldTypeString, alias: Burial Notes, length: 255 )
• TYPEBURIAL2 ( type: esriFieldTypeString, alias: Type of Burial, length: 50 , Coded Values: [Regular: Regular] , [Cremation: Cremation] , [1st Double Deep: 1st Double Deep] , ...1 more... )
• BP3 ( type: esriFieldTypeString, alias: Burial Permit Number, length: 50 )
• AGE3 ( type: esriFieldTypeString, alias: Age, length: 50 )
• BLNAME3 ( type: esriFieldTypeString, alias: Buried Last Name, length: 255 )
• BFNAME3 ( type: esriFieldTypeString, alias: Buried First Name, length: 255 )
• BMNAME3 ( type: esriFieldTypeString, alias: Buried Middle Name, length: 255 )
• DOB3 ( type: esriFieldTypeString, alias: Date of Birth, length: 50 )
• DOD3 ( type: esriFieldTypeString, alias: Data of Death, length: 50 )
• DOI3 ( type: esriFieldTypeString, alias: Date of Interment, length: 50 )
• POB3 ( type: esriFieldTypeString, alias: Place of Birth, length: 255 )
• POD3 ( type: esriFieldTypeString, alias: Place of Death, length: 255 )
• BURIALNOTES3 ( type: esriFieldTypeString, alias: Burial Notes, length: 255 )
• TYPEBURIAL3 ( type: esriFieldTypeString, alias: Type of Burial, length: 50 , Coded Values: [Regular: Regular] , [Cremation: Cremation] , [1st Double Deep: 1st Double Deep] , ...1 more... )
• BP4 ( type: esriFieldTypeString, alias: Burial Permit Number, length: 50 )
• AGE4 ( type: esriFieldTypeString, alias: Age, length: 50 )
• BLNAME4 ( type: esriFieldTypeString, alias: Buried Last Name, length: 255 )
• BFNAME4 ( type: esriFieldTypeString, alias: Buried First Name, length: 255 )
• BMNAME4 ( type: esriFieldTypeString, alias: Buried Middle Name, length: 255 )
• DOB4 ( type: esriFieldTypeString, alias: Date of Birth, length: 50 )
• DOD4 ( type: esriFieldTypeString, alias: Data of Death, length: 50 )
• DOI4 ( type: esriFieldTypeString, alias: Date of Interment, length: 50 )
• POB4 ( type: esriFieldTypeString, alias: Place of Birth, length: 255 )
• POD4 ( type: esriFieldTypeString, alias: Place of Death, length: 255 )
• BURIALNOTES4 ( type: esriFieldTypeString, alias: Burial Notes, length: 255 )
• TYPEBURIAL4 ( type: esriFieldTypeString, alias: Type of Burial, length: 50 , Coded Values: [Regular: Regular] , [Cremation: Cremation] , [1st Double Deep: 1st Double Deep] , ...1 more... )
• FOR_JOIN ( type: esriFieldTypeString, alias: FOR_JOIN, length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• LastNames ( type: esriFieldTypeString, alias: Last Names, length: 200 )
• FirstNames ( type: esriFieldTypeString, alias: First Names, length: 200 )
• DisplayName ( type: esriFieldTypeString, alias: Display Name, length: 255 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GraveID ( type: esriFieldTypeString, alias: Grave ID, length: 255 )
• Veteran ( type: esriFieldTypeSmallInteger, alias: Grave of a Veteran , Coded Values: [0: No] , [1: Yes] )
• DeedOwnerDisplayName ( type: esriFieldTypeString, alias: Deed Owner Name, length: 255 )
• TransactionType ( type: esriFieldTypeInteger, alias: Grave Transaction Type )
• GraveGlobalID ( type: esriFieldTypeGUID, alias: Grave Global ID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Previous_DOLNAME ( type: esriFieldTypeString, alias: Previous Deed Owner Last Name, length: 255 )
• Previous_DOFNAME ( type: esriFieldTypeString, alias: Previous Deed Owner First Name, length: 255 )
• Previous_DOMNAME ( type: esriFieldTypeString, alias: Previous Deed Owner Middle Name, length: 255 )
• Previous_DOADDRESS ( type: esriFieldTypeString, alias: Previous Deed Owner Address, length: 255 )
• New_STATUS ( type: esriFieldTypeString, alias: Current Status, length: 255 , Coded Values: [Available: Available] , [Sold: Sold] , [Closed: Closed] , ...1 more... )

Types:

ID: 0
Name: Unknown
Domains:
• GRAVETYPE:
  Inherited
• STATUS:
  Inherited
• TYPEBURIAL:
  Inherited
• TYPEBURIAL2:
  Inherited
• TYPEBURIAL3:
  Inherited
• TYPEBURIAL4:
  Inherited
• Veteran:
  Inherited
• graveupdate:
  Inherited

---

ID: 10
Name: Grave Sale
Domains:
• GRAVETYPE:
  Inherited
• STATUS:
  Inherited
• TYPEBURIAL:
  Inherited
• TYPEBURIAL2:
  Inherited
• TYPEBURIAL3:
  Inherited
• TYPEBURIAL4:
  Inherited
• Veteran:
  Inherited

---

ID: 20
Name: Burial
Domains:
• GRAVETYPE:
  Inherited
• STATUS:
  Inherited
• TYPEBURIAL:
  Inherited
• TYPEBURIAL2:
  Inherited
• TYPEBURIAL3:
  Inherited
• TYPEBURIAL4:
  Inherited
• Veteran:
  Inherited

---

ID: 21
Name: Disinterment
Domains:
• GRAVETYPE:
  Inherited
• STATUS:
  Inherited
• TYPEBURIAL:
  Inherited
• TYPEBURIAL2:
  Inherited
• TYPEBURIAL3:
  Inherited
• TYPEBURIAL4:
  Inherited
• Veteran:
  Inherited

---

ID: 11
Name: Grave Purchase
Domains:
• GRAVETYPE:
  Inherited
• STATUS:
  Inherited
• TYPEBURIAL:
  Inherited
• TYPEBURIAL2:
  Inherited
• TYPEBURIAL3:
  Inherited
• TYPEBURIAL4:
  Inherited
• Veteran:
  Inherited

---

Relationships:

• Grave (0) -- Related To: Grave of a Veteran (3)
• Grave (1) -- Related To: Graves (0)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata