Name: PROPERTY SALES (CAMA)

Display Field: SSL

Type: Table

Geometry Type: N/A

Description: Public extract of the database used for sending tax assessment bills. It is also known as tax assessment roll. ITS stores comprehensive tax information such as ownership, mailing addresses, etc., of record lots, tax lots, parcels, condominiums, and federally owned lands such as reservations and appropriations. The ITS database also processes notices and tax bills. The linkage from the Vector Property layers to this database is SSL (Square, Suffix, and Lot).It should be noted that not all record lots have a direct 1:1 relationship to information in this database. The most obvious examples would be when a tax lot was created from existing record lots. In this case, only the tax lot would have linkage to the ITS database, not the underlying record lots (though they still exist). Another example would be reservations that have been converted into tax lots. The reservation still exists, however for taxation purposes it is referred to as a tax lot and has corresponding linkage to ITS.

Copyright Text: https://octo.dc.gov

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

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 )
• ROW_NUMBER ( type: esriFieldTypeInteger, alias: ROW_NUMBER )
• SSL ( type: esriFieldTypeString, alias: SSL, length: 50 )
• SALE_DATE ( type: esriFieldTypeDate, alias: SALE_DATE, length: 8 )
• SALE_PRICE ( type: esriFieldTypeDouble, alias: SALE_PRICE )
• QUALIFIED ( type: esriFieldTypeString, alias: QUALIFIED, length: 10 )
• SALE_CODE ( type: esriFieldTypeString, alias: SALE_CODE, length: 10 )
• SALE_CURR_OWNER ( type: esriFieldTypeString, alias: SALE_CURR_OWNER, length: 10 )
• GIS_LAST_MOD_DTTM ( type: esriFieldTypeDate, alias: GIS_LAST_MOD_DTTM, length: 8 )

Relationships:

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

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

  Iteminfo   Thumbnail   Metadata