Name: PROPERTY SALES (CAMA)

Display Field: SSL

Type: Table

Geometry Type: N/A

Description: This is a public extract of a database used for sending tax bills. It is also known as the tax assessment roll. Dataset contains full field names for a better user experience.

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ROW_NUMBER ( type: esriFieldTypeInteger, alias: ROW_NUMBER, editable: true, nullable: true, defaultValue: null, modelName: ROW_NUMBER )
• SSL ( type: esriFieldTypeString, alias: SSL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SSL )
• SALE_DATE ( type: esriFieldTypeDate, alias: SALE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SALE_DATE )
• SALE_PRICE ( type: esriFieldTypeDouble, alias: SALE_PRICE, editable: true, nullable: true, defaultValue: null, modelName: SALE_PRICE )
• QUALIFIED ( type: esriFieldTypeString, alias: QUALIFIED, editable: true, nullable: true, length: 10, defaultValue: null, modelName: QUALIFIED )
• SALE_CODE ( type: esriFieldTypeString, alias: SALE_CODE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SALE_CODE )
• SALE_CURR_OWNER ( type: esriFieldTypeString, alias: SALE_CURR_OWNER, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SALE_CURR_OWNER )
• GIS_LAST_MOD_DTTM ( type: esriFieldTypeDate, alias: GIS_LAST_MOD_DTTM, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GIS_LAST_MOD_DTTM )

Templates:

• Name: PROPERTY SALES (CAMA)
  Description:
  Prototype:
  SALE_CURR_OWNER: null
  GIS_LAST_MOD_DTTM: null
  ROW_NUMBER: null
  SSL: null
  SALE_DATE: null
  SALE_PRICE: null
  QUALIFIED: null
  SALE_CODE: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DCGIS.CONDORELATE (32) -- Related To: CONDORELATE (52)
• DCGIS.OwnerPLY (3) -- Related To: Owner Polygons (Common Ownership Layer) (40)
• DCGIS.OwnerPLY (14) -- Related To: District Land (RPTA Ownership) (49)
• DCGIS.OwnerPLY (24) -- Related To: Federal Land (RPTA Ownership) (50)

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata