The District of Columbia

Cama Residential Point

Cama Residential Point

by DC Office of Tax and Revenue on weekly

Keywords
About: Residential, Housing, Property, Government, Real Property, planningCadastre
Taking place at: Washington, D.C., District of Columbia, DC, DC GIS, DCGIS

Abstract

Computer Assisted Mass Appraisal (CAMA) database. The dataset contains attribution on housing characteristics for residential properties, and was created as part of the DC Geographic Information System (DC GIS) for the D.C. Office of the Chief Technology Officer (OCTO) and participating D.C. government agencies.

All DC GIS data is stored and exported in Maryland State Plane coordinates NAD 83 meters.

METADATA CONTENT IS IN PROCESS OF VALIDATION AND SUBJECT TO CHANGE.

Purpose

This data is used for the planning and management of Washington, D.C. by local government agencies.

Use constraints

Acknowledgment of the DC Geographic Information Systems Program (DC GIS). The District of Columbia Government makes no claims as to the completeness, accuracy or content of any data contained hereon, and makes no representation of any kind, including, but not limited to, the warranty of the accuracy or fitness for a particular use, nor are any such warranties to be implied or inferred with respect to the information or data furnished herein.

Point of contact

GIS Data Coordinator
in D.C. Office of the Chief Technology Officer

441 4th St NW, Suite 930 South
Washington DC, 20001, USA

fax: (202) 727-5660
hours: 8:30 am - 5 pm

Credits

DC Office of Tax and Revenue (OTR) Computer Assisted Mass Appraisal Database

Data accuracy

Accuracy
Data believed to be complete and accurate, subject to change. Validated by source and/or responsible agency.

Logical consistency
In process of validation by source and/or responsible agency.

Completeness
Data believed to be complete and accurate, subject to change. Validated by source and/or responsible agency.

Horizontal positional accuracy
In process of validation by source and/or responsible agency. Points placed within parcels shown on tax map scans.

Vertical positional accuracy
N/A

Lineage / Sources

Lineage / Processes
GIS Data Coordinator
in Office of the Chief Technology Officer

441 4th St NW, Suite 930 South
Washington DC, 20001, USA

fax: 202-727-5660
hours: 8:30am - 5:30pm
OTR provides a dump of the Computer Assisted Mass Appraisal (CAMA) Data quarterly in MS Access database format. The database consists of the following tables:

Comm_Extract (Commercial)
Condo_Extract (Condos)
Res_Extract (Residential)

Each CAMA table contains an SSL field. However, there are multiple records per SSL creating a many-to-one relate with the ownerpoint dataset. Thus, the tabular gets processed first to generate unique records per SSL. Staff generated the the unique record tables through four steps:

1 - Copy the table structure of the existing CAMA tables.
2 - Build three select queries to access the unique records.
3 - Change the select queries to append queries and define them to append the filtered records to the new templates.
4 - Run the append queries to create the unique record tables.

Next, staff joined each unique record table to the ownerpoint to spatially enable each CAMA data type: commercial, condo, and residential. As part of this process, staff created a slimmed down version of the ownerpoint table since most of the fields are not used. Staff generated the feature classes by:

1 - Establishing GIS data architecture for spatial data and create the base real property layers for this process.
2 - Generating the spatial layers for the CAMA data by joining them to the slimmed down version of the owner point layer.
3 - Stripping Date Fields from ownerpoints.
4 - Selecting all of the records with a CAMA SSL value and creating a layer from the selected features.
5 - Exporting the selection layer to a new feature class.
6 - Incorporating and updating metadata.

These steps are run on all three CAMA tables.

in OCTO



Added LIVING column which contains the livable square footage of a residence.

Distribution

Most DC GIS datasets can be downloaded from "http://dcgis.dc.gov" on the data center page. Orders can also be made by contacting OCTO GIS at "dcgis@dc.gov", especially for datasets not available for download.

Distribution liability
Acknowledgment of the DC Geographic Information Systems Program (DC GIS). The District of Columbia Government makes no claims as to the completeness, accuracy or content of any data contained hereon, and makes no representation of any kind, including, but not limited to, the warranty of the accuracy or fitness for a particular use, nor are any such warranties to be implied or inferred with respect to the information or data furnished herein.

Distributed by
GIS Data Coordinator
in D.C. Office of the Chief Technology Officer

441 4th St NW, Suite 930 South
Washington DC, 20001, USA

fax: (202) 727-5660
hours: 8:30 am - 5 pm

Entity

CamaResPt

Attributes

  • Grade / ESRI
    grade code
  • Cndtn / ESRI
    condition code
  • Extwall / ESRI
    exterior wall code
  • Roof / ESRI
    roof type code
  • SSL
    square suffix and lot of property
  • BLDG_NUM
  • STYLE
  • STYLE_D
  • STRUCT
  • STRUCT_D
  • Bldg_Num
    building number on property (1 is primary dwelling)
  • GRADE
  • GRADE_D
  • CNDTN
  • CNDTN_D
  • EXTWALL
  • EXTWALL_D
  • ROOF
  • ROOF_D
  • BATHRM
  • HF_BATHRM
  • HEAT
  • HEAT_D
  • NUM_UNITS
  • Style
    style code
  • INTWALL
  • INTWALL_D
  • ROOMS
  • BEDRM
  • KITCHENS
  • FIREPLACES
  • Style_D
    style description
  • YR_RMDL
  • Struct
    structure code
  • STORIES
  • SALEDATE
  • PRICE
  • Grade_D
    grade description
  • QUALIFIED
  • Cndtn_D
    condition description
  • SALE_NUM
  • Extwall_D / ESRI
    exterior wall description
  • SHAPE / ESRI
    Feature geometry.
  • Bathrm
    number of bathrooms
  • Struct_D
    structure description
  • Roof_D / ESRI
    roof type description
  • GBA
    gross building area in square feet
  • Hf_Bathrm
    number of half bathrooms
  • Heat
    heat type code
  • Heat_D
    heating type description
  • Num_Units
    number of units
  • AC
    air conditioning in residence
  • Intwall
    interior wall code
  • Intwall_D
    interior wall description
  • Rooms
    number of rooms
  • Bedrm
    number of bedrooms
  • Kitchens
    number of kitchens
  • Fireplaces
    number of fireplaces
  • AYB
    The earliest time the main portion of the building was built. It is not affected by subsequent construction.
  • Yr_Rmdl
    last year residence was remodeled
  • EYB
    The calculated or apparent year, that an improvement was built that is most often more recent than actual year built.
  • Stories
    number of stories in primary dwelling
  • Saledate
    date of most recent sale
  • Price
    price of most recent sale
  • Qualified
    qualified
  • Sale_Num
    sale number (always 1 to get most recent sale)
  • USECODE
    property use code
  • LANDAREA
    land area of property in square feet
  • PREMISEADD
    property premise address
  • UNITNUMBER
    unit number
  • OWNERNAME
    property owner name
  • OWNNAME2
    second property owner name
  • X_COORD
    x coordinate of owner point
  • Y_COORD
    y coordinate of owner point
  • Shape / ESRI
    Feature geometry.
  • EXE_CODE

Metadata

FGDC Content Standards for Digital Geospatial Metadata / FGDC-STD-001-1998 as of 20121011

Provided by
GIS Data Coordinator
in D.C. Office of the Chief Technology Officer

441 4th St NW, Suite 930 South
Washington DC, 20001, USA

phone: REQUIRED: The telephone number by which individuals can speak to the organization or individual.
fax: (202) 727-5660
hours: 8:30 am - 5 pm