Name: Sales

Display Field: Date_of_Sale

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:

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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GID ( type: esriFieldTypeInteger, alias: GID )
• SID ( type: esriFieldTypeInteger, alias: SID )
• PID ( type: esriFieldTypeString, alias: PID, length: 15 )
• Date_of_Sale ( type: esriFieldTypeDate, alias: Date_of_Sale, length: 8 )
• Year_of_Sale ( type: esriFieldTypeString, alias: Year_of_Sale, length: 4 )
• Sale_Amt ( type: esriFieldTypeDouble, alias: Sale_Amt )
• Sale_Amt_Adj ( type: esriFieldTypeDouble, alias: Sale_Amt_Adj )
• Sale_Ratio ( type: esriFieldTypeDouble, alias: Sale_Ratio )
• Transaction_Type ( type: esriFieldTypeString, alias: Transaction_Type, length: 254 )
• Transaction_Desc ( type: esriFieldTypeString, alias: Transaction_Desc, length: 254 )
• Transaction_Desc_Code ( type: esriFieldTypeInteger, alias: Transaction_Desc_Code )
• Recorded_ID ( type: esriFieldTypeString, alias: Recorded_ID, length: 55 )
• Quality ( type: esriFieldTypeString, alias: Quality, length: 2 )
• Seller ( type: esriFieldTypeString, alias: Seller, length: 101 )
• Buyer ( type: esriFieldTypeString, alias: Buyer, length: 101 )
• Sale_Remarks ( type: esriFieldTypeString, alias: Sale_Remarks, length: 1000 )
• Last_Sale_Flag ( type: esriFieldTypeSmallInteger, alias: Last_Sale_Flag )
• Abstract_Code ( type: esriFieldTypeInteger, alias: Abstract_Code )
• Abstract_Desc ( type: esriFieldTypeString, alias: Abstract_Desc, length: 20 )

Relationships:

• Parcel (0) -- Related To: City Owned Parcels (4)
• Parcel (1) -- Related To: Parcels (0)
• Parcel (2) -- Related To: Tax Information (1)

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

  Iteminfo   Thumbnail   Metadata