Cama Residential PointCama 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 / ProcessesGIS 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