DCGIS.CamaCommPt
Metadata also available as
Metadata:
- Identification_Information:
-
- Citation:
-
- Citation_Information:
-
- Originator: DC Office of Tax and Revenue
- Publication_Date: weekly
- Title: DCGIS.CamaCommPt
- Geospatial_Data_Presentation_Form: vector digital data
- Publication_Information:
-
- Publisher: DC GIS
- Other_Citation_Details: DC GIS updates CAMA data on a weekly basis.
- Online_Linkage:
-
<http://dcatlas.dcgis.dc.gov/catalog/download.asp?downloadName=CamaCommPt&downloadTYPE=ESRI>
- Online_Linkage:
-
<http://dcatlas.dcgis.dc.gov/catalog/download.asp?downloadName=CamaCommPt&downloadTYPE=KMZ>
- Larger_Work_Citation:
-
- Citation_Information:
-
- Originator: DC GIS
- Title: DC Geographic Information System
- Geospatial_Data_Presentation_Form: vector digital data
- Description:
-
- Abstract:
-
Computer Assisted Mass Appraisal (CAMA) database. The dataset contains attribution on housing characteristics for commercial 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.
- Supplemental_Information:
-
Most lots have one building in the cama file, assigned BLDG_NUM of one in the table. For parcels where multiple buildings exist, the primary building (such as the main residence) is assigned BLDG_NUM = 1. The other buildings or structures have BLDG_NUM values in random sequential order. After the primary structure, there is no way to associate BLDG_NUM > 2 records with any particular structure on the lot.
- Time_Period_of_Content:
-
- Time_Period_Information:
-
- Single_Date/Time:
-
- Calendar_Date: weekly
- Currentness_Reference: publication date
- Status:
-
- Progress: Complete
- Maintenance_and_Update_Frequency: As needed
- Spatial_Domain:
-
- Bounding_Coordinates:
-
- West_Bounding_Coordinate: -77.113918
- East_Bounding_Coordinate: -76.910347
- North_Bounding_Coordinate: 38.989982
- South_Bounding_Coordinate: 38.816500
- Keywords:
-
- Theme:
-
- Theme_Keyword_Thesaurus: none
- Theme_Keyword: Commercial
- Theme_Keyword: Housing
- Theme_Keyword: Property
- Theme_Keyword: Government
- Theme_Keyword: Real Property
- Theme_Keyword: planningCadastre
- Place:
-
- Place_Keyword: Washington, D.C.
- Place_Keyword: District of Columbia
- Place_Keyword: DC
- Place_Keyword: DC GIS
- Place_Keyword: DCGIS
- Use_Constraints:
-
For data terms and conditions, go to <http://dc.gov/page/terms-and-conditions-use-district-data>
- Point_of_Contact:
-
- Contact_Information:
-
- Contact_Organization_Primary:
-
- Contact_Organization: D.C. Office of the Chief Technology Officer
- Contact_Person: GIS Data Coordinator
- Contact_Address:
-
- Address_Type: mailing and physical address
- Address: 441 4th St NW, Suite 930 South
- City: Washington
- State_or_Province: DC
- Postal_Code: 20001
- Country: USA
- Contact_Facsimile_Telephone: (202) 727-5660
- Contact_Electronic_Mail_Address: dcgis@dc.gov
- Hours_of_Service: 8:30 am - 5 pm
- Data_Set_Credit:
-
DC Office of Tax and Revenue (OTR) Computer Assisted Mass Appraisal Database
- Native_Data_Set_Environment:
-
Microsoft Windows 2000 Version 5.0 (Build 2195) Service Pack 4; ESRI ArcCatalog 9.2.6.1500
- Data_Quality_Information:
-
- Attribute_Accuracy:
-
- Attribute_Accuracy_Report:
-
Data believed to be complete and accurate, subject to change. Validated by source and/or responsible agency.
- Logical_Consistency_Report: In process of validation by source and/or responsible agency.
- Completeness_Report:
-
Data believed to be complete and accurate, subject to change. Validated by source and/or responsible agency.
- Positional_Accuracy:
-
- Horizontal_Positional_Accuracy:
-
- Horizontal_Positional_Accuracy_Report:
-
In process of validation by source and/or responsible agency. Points placed within parcels shown on tax map scans.
- Vertical_Positional_Accuracy:
-
- Vertical_Positional_Accuracy_Report: N/A
- Lineage:
-
- Source_Information:
-
- Source_Citation:
-
- Citation_Information:
-
- Originator: DC Office of Tax and Revenue (OTR)
- Publication_Date: 2005
- Title: Computer Assisted Mass Appraisal Database
- Online_Linkage: <http://cfo.dc.gov/>
- Type_of_Source_Media: database
- Source_Time_Period_of_Content:
-
- Time_Period_Information:
-
- Single_Date/Time:
-
- Calendar_Date: 03/20/2003
- Source_Currentness_Reference: publication date
- Source_Citation_Abbreviation: Computer Assisted Mass Appraisal Database
- Source_Contribution: locations and attributes
- Source_Information:
-
- Source_Citation:
-
- Citation_Information:
-
- Originator: DC Office of Tax and Revenue
- Publication_Date: 2005
- Title: Ownerpoint
- Online_Linkage: <http://cfo.dc.gov>
- Type_of_Source_Media: database
- Source_Citation_Abbreviation: ownerpoint
- Source_Contribution: location and attribution
- Process_Step:
-
- Process_Description:
-
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.
- Process_Date: 10/12/05
- Process_Contact:
-
- Contact_Information:
-
- Contact_Organization_Primary:
-
- Contact_Organization: Office of the Chief Technology Officer
- Contact_Person: GIS Data Coordinator
- Contact_Address:
-
- Address_Type: mailing and physical address
- Address: 200 I Street SE, 5th Floor
- City: Washington
- State_or_Province: DC
- Postal_Code: 20001
- Country: USA
- Contact_Facsimile_Telephone: 202-727-5660
- Contact_Electronic_Mail_Address: dcgis@dc.gov
- Hours_of_Service: 8:30am - 5:30pm
- Process_Step:
-
- Process_Description: Metadata imported.
- Source_Used_Citation_Abbreviation: W:\DCGISDATA_WORKSPACE\OTR\CamaCommPt.xml
- Process_Step:
-
- Process_Description: Metadata imported.
- Source_Used_Citation_Abbreviation: E:\DataLoad091507\camacomm
- Process_Step:
-
- Process_Description: Metadata imported.
- Source_Used_Citation_Abbreviation: C:\temp\camacomm.xml
- Process_Step:
-
- Process_Description: Metadata imported.
- Source_Used_Citation_Abbreviation: C:\temp\CamaCommPt_old.xml
- Process_Step:
-
- Process_Description: Metadata imported.
- Source_Used_Citation_Abbreviation: C:\temp\comm.xml
- Process_Step:
-
- Process_Description: Metadata imported.
- Source_Used_Citation_Abbreviation: C:\temp\camacomm.xml
- Process_Step:
-
- Process_Description: Metadata imported.
- Source_Used_Citation_Abbreviation: C:\temp\CamaComm.xml
- Spatial_Data_Organization_Information:
-
- Direct_Spatial_Reference_Method: Vector
- Point_and_Vector_Object_Information:
-
- SDTS_Terms_Description:
-
- SDTS_Point_and_Vector_Object_Type: Entity point
- Point_and_Vector_Object_Count: 19286
- Spatial_Reference_Information:
-
- Horizontal_Coordinate_System_Definition:
-
- Planar:
-
- Grid_Coordinate_System:
-
- Grid_Coordinate_System_Name: State Plane Coordinate System
- State_Plane_Coordinate_System:
-
- SPCS_Zone_Identifier: 1900
- Lambert_Conformal_Conic:
-
- Standard_Parallel: 38.300000
- Standard_Parallel: 39.450000
- Longitude_of_Central_Meridian: -77.000000
- Latitude_of_Projection_Origin: 37.666667
- False_Easting: 400000.000000
- False_Northing: 0.000000
- Planar_Coordinate_Information:
-
- Planar_Coordinate_Encoding_Method: coordinate pair
- Coordinate_Representation:
-
- Abscissa_Resolution: 0.000011
- Ordinate_Resolution: 0.000011
- Planar_Distance_Units: meters
- Geodetic_Model:
-
- Horizontal_Datum_Name: North American Datum of 1983
- Ellipsoid_Name: Geodetic Reference System 80
- Semi-major_Axis: 6378137.000000
- Denominator_of_Flattening_Ratio: 298.257222
- Vertical_Coordinate_System_Definition:
-
- Altitude_System_Definition:
-
- Altitude_Resolution: 1.000000
- Altitude_Encoding_Method:
-
Explicit elevation coordinate included with horizontal coordinates
- Entity_and_Attribute_Information:
-
- Detailed_Description:
-
- Entity_Type:
-
- Entity_Type_Label: DCGIS.CamaCommPt
- Attribute:
-
- Attribute_Label: OBJECTID
- Attribute_Definition: Internal feature number.
- Attribute_Definition_Source: ESRI
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Sequential unique whole numbers that are automatically generated.
- Attribute:
-
- Attribute_Label: SSL
- Attribute_Definition: square suffix and lot
- Attribute:
-
- Attribute_Label: BLDG_NUM
- Attribute:
-
- Attribute_Label: SECT_NUM
- Attribute:
-
- Attribute_Label: Bldg_Num
- Attribute_Definition: building number on property
- Attribute:
-
- Attribute_Label: STRUCT_CL
- Attribute:
-
- Attribute_Label: STRUCT_CL_D
- Attribute:
-
- Attribute_Label: GRADE
- Attribute:
-
- Attribute_Label: GRADE_D
- Attribute:
-
- Attribute_Label: EXTWALL
- Attribute:
-
- Attribute_Label: EXTWALL_D
- Attribute:
-
- Attribute_Label: WALL_HGT
- Attribute:
-
- Attribute_Label: NUM_UNITS
- Attribute:
-
- Attribute_Label: SALEDATE
- Attribute:
-
- Attribute_Label: PRICE
- Attribute:
-
- Attribute_Label: QUALIFIED
- Attribute:
-
- Attribute_Label: Sect_Num
- Attribute_Definition: section number
- Attribute:
-
- Attribute_Label: YR_RMDL
- Attribute:
-
- Attribute_Label: GBA
- Attribute_Definition: gross building area in square feet
- Attribute:
-
- Attribute_Label: SALE_NUM
- Attribute:
-
- Attribute_Label: Struct_Cl
- Attribute_Definition: structure class code
- Attribute:
-
- Attribute_Label: Struct_Cl_D
- Attribute_Definition: structure type description
- Attribute:
-
- Attribute_Label: Grade
- Attribute_Definition: grade class
- Attribute:
-
- Attribute_Label: Grade_D
- Attribute_Definition: grade description
- Attribute:
-
- Attribute_Label: Extwall
- Attribute_Definition: extwall code
- Attribute:
-
- Attribute_Label: Extwall_D
- Attribute_Definition: exterior wall description
- Attribute:
-
- Attribute_Label: Wall_Hgt
- Attribute_Definition: wall height
- Attribute:
-
- Attribute_Label: Num_Units
- Attribute_Definition: number of units
- Attribute:
-
- Attribute_Label: Saledate
- Attribute_Definition: date of last sale
- Attribute:
-
- Attribute_Label: SHAPE
- Attribute_Definition: Feature geometry.
- Attribute_Definition_Source: ESRI
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Coordinates defining the features.
- Attribute:
-
- Attribute_Label: Price
- Attribute_Definition: price of last sale
- Attribute:
-
- Attribute_Label: Qualified
- Attribute_Definition: qualified
- Attribute:
-
- Attribute_Label: AYB
- Attribute_Definition:
-
The earliest time the main portion of the building was built. It is not affected by subsequent construction.
- Attribute:
-
- Attribute_Label: Yr_Rmdl
- Attribute_Definition: year structure was remodeled
- Attribute:
-
- Attribute_Label: EYB
- Attribute_Definition:
-
The calculated or apparent year, that an improvement was built that is most often more recent than actual year built.
- Attribute:
-
- Attribute_Label: Sale_Num
- Attribute_Definition: sale number
- Attribute:
-
- Attribute_Label: USECODE
- Attribute_Definition: property use code
- Attribute:
-
- Attribute_Label: PREMISEADD
- Attribute_Definition: property premise address
- Attribute:
-
- Attribute_Label: LANDAREA
- Attribute_Definition: property land area
- Attribute:
-
- Attribute_Label: UNITNUMBER
- Attribute_Definition: unit number
- Attribute:
-
- Attribute_Label: OWNERNAME
- Attribute_Definition: property owner name
- Attribute:
-
- Attribute_Label: OWNNAME2
- Attribute_Definition: second property owner name
- Attribute:
-
- Attribute_Label: X_COORD
- Attribute_Definition: x coordinate of owner point
- Attribute:
-
- Attribute_Label: Y_COORD
- Attribute_Definition: y coordinate of owner point
- Attribute:
-
- Attribute_Label: Shape
- Attribute_Definition: Feature geometry.
- Attribute_Definition_Source: ESRI
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Coordinates defining the features.
- Attribute:
-
- Attribute_Label: EXE_CODE
- Attribute_Definition: exe code (blank)
- Distribution_Information:
-
- Distributor:
-
- Contact_Information:
-
- Contact_Organization_Primary:
-
- Contact_Organization: D.C. Office of the Chief Technology Officer
- Contact_Person: GIS Data Coordinator
- Contact_Address:
-
- Address_Type: mailing and physical address
- Address: 200 I Street SE, 5th Floor
- City: Washington
- State_or_Province: DC
- Postal_Code: 20001
- Country: USA
- Contact_Facsimile_Telephone: (202) 727-5660
- Contact_Electronic_Mail_Address: dcgis@dc.gov
- Hours_of_Service: 8:30 am - 5 pm
- Resource_Description: Downloadable Data
- Distribution_Liability:
-
For data terms and conditions, go to <http://dc.gov/page/terms-and-conditions-use-district-data>
- Standard_Order_Process:
-
- Digital_Form:
-
- Digital_Transfer_Information:
-
- Transfer_Size: 24.894
- Ordering_Instructions: All data is available at <http://opendata.dc.gov>
- Metadata_Reference_Information:
-
- Metadata_Date: 20111121
- Metadata_Review_Date: 10/15/05
- Metadata_Contact:
-
- Contact_Information:
-
- Contact_Organization_Primary:
-
- Contact_Organization: D.C. Office of the Chief Technology Officer
- Contact_Person: GIS Data Coordinator
- Contact_Address:
-
- Address_Type: mailing and physical address
- Address: 200 I Street SE, 5th Floor
- City: Washington
- State_or_Province: DC
- Postal_Code: 20001
- Country: USA
- Contact_Voice_Telephone:
-
REQUIRED: The telephone number by which individuals can speak to the organization or individual.
- Contact_Facsimile_Telephone: (202) 727-5660
- Contact_Electronic_Mail_Address: dcgis@dc.gov
- Hours_of_Service: 8:30 am - 5 pm
- Metadata_Standard_Name: FGDC Content Standards for Digital Geospatial Metadata
- Metadata_Standard_Version: FGDC-STD-001-1998
- Metadata_Time_Convention: local time
- Metadata_Extensions:
-
- Online_Linkage: <http://www.esri.com/metadata/esriprof80.html>
- Profile_Name: ESRI Metadata Profile
- Metadata_Extensions:
-
- Online_Linkage: <http://www.esri.com/metadata/esriprof80.html>
- Profile_Name: ESRI Metadata Profile
Generated by mp version 2.9.12 on Thu Jun 25 15:16:06 2015