DCGIS.CamaResPt
Metadata also available as
Metadata:
- Identification_Information:
-
- Citation:
-
- Citation_Information:
-
- Originator: DC Office of Tax and Revenue
- Publication_Date: weekly
- Title: DCGIS.CamaResPt
- 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:
-
Server=10.1.11.144; Service=5151; User=dcgis; Version=SDE.DEFAULT
- 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 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.
- 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.113874
- East_Bounding_Coordinate: -76.909770
- North_Bounding_Coordinate: 38.995599
- South_Bounding_Coordinate: 38.819649
- Keywords:
-
- Theme:
-
- Theme_Keyword_Thesaurus: none
- Theme_Keyword: Residential
- 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: [email protected]
- 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 XP Version 5.1 (Build 2600) Service Pack 3; ESRI ArcCatalog 9.3.1.4000
- 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: [email protected]
- Hours_of_Service: 8:30am - 5:30pm
- Process_Step:
-
- Process_Description:
-
Added LIVING column which contains the livable square footage of a residence.
- Process_Date: 20111121
- Process_Contact:
-
- Contact_Information:
-
- Contact_Organization_Primary:
-
- Contact_Organization: OCTO
- Process_Step:
-
- Process_Description: Metadata imported.
- Source_Used_Citation_Abbreviation: C:\temp\CamaResPt.xml
- Process_Date: 20111121
- Process_Time: 16050800
- 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: 105932
- 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.CamaResPt
- 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 of property
- Attribute:
-
- Attribute_Label: BLDG_NUM
- Attribute:
-
- Attribute_Label: STYLE
- Attribute:
-
- Attribute_Label: STYLE_D
- Attribute:
-
- Attribute_Label: STRUCT
- Attribute:
-
- Attribute_Label: STRUCT_D
- Attribute:
-
- Attribute_Label: Bldg_Num
- Attribute_Definition: building number on property (1 is primary dwelling)
- Attribute:
-
- Attribute_Label: GRADE
- Attribute:
-
- Attribute_Label: GRADE_D
- Attribute:
-
- Attribute_Label: CNDTN
- Attribute:
-
- Attribute_Label: CNDTN_D
- Attribute:
-
- Attribute_Label: EXTWALL
- Attribute:
-
- Attribute_Label: EXTWALL_D
- Attribute:
-
- Attribute_Label: ROOF
- Attribute:
-
- Attribute_Label: ROOF_D
- Attribute:
-
- Attribute_Label: BATHRM
- Attribute:
-
- Attribute_Label: HF_BATHRM
- Attribute:
-
- Attribute_Label: HEAT
- Attribute:
-
- Attribute_Label: HEAT_D
- Attribute:
-
- Attribute_Label: NUM_UNITS
- Attribute:
-
- Attribute_Label: Style
- Attribute_Definition: style code
- Attribute:
-
- Attribute_Label: INTWALL
- Attribute:
-
- Attribute_Label: INTWALL_D
- Attribute:
-
- Attribute_Label: ROOMS
- Attribute:
-
- Attribute_Label: BEDRM
- Attribute:
-
- Attribute_Label: KITCHENS
- Attribute:
-
- Attribute_Label: FIREPLACES
- Attribute:
-
- Attribute_Label: Style_D
- Attribute_Definition: style description
- Attribute:
-
- Attribute_Label: YR_RMDL
- Attribute:
-
- Attribute_Label: Struct
- Attribute_Definition: structure code
- Attribute:
-
- Attribute_Label: STORIES
- Attribute:
-
- Attribute_Label: SALEDATE
- Attribute:
-
- Attribute_Label: PRICE
- Attribute:
-
- Attribute_Label: QUALIFIED
- Attribute:
-
- Attribute_Label: SALE_NUM
- Attribute:
-
- Attribute_Label: SHAPE
- Attribute_Definition: Feature geometry.
- Attribute_Definition_Source: ESRI
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Coordinates defining the features.
- Attribute:
-
- Attribute_Label: Struct_D
- Attribute_Definition: structure description
- Attribute:
-
- Attribute_Label: Roof_D
- Attribute_Definition: roof type description
- Attribute:
-
- Attribute_Label: GBA
- Attribute_Definition: gross building area in square feet
- Attribute:
-
- Attribute_Label: Grade
- Attribute_Definition: grade code
- Attribute:
-
- Attribute_Label: Grade_D
- Attribute_Definition: grade description
- Attribute:
-
- Attribute_Label: Cndtn
- Attribute_Definition: condition code
- Attribute:
-
- Attribute_Label: Cndtn_D
- Attribute_Definition: condition description
- Attribute:
-
- Attribute_Label: Extwall
- Attribute_Definition: exterior wall code
- Attribute:
-
- Attribute_Label: Extwall_D
- Attribute_Definition: exterior wall description
- Attribute_Definition_Source: ESRI
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Coordinates defining the features.
- Attribute:
-
- Attribute_Label: Roof
- Attribute_Definition: roof type code
- Attribute_Definition_Source: ESRI
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Coordinates defining the features.
- Attribute:
-
- Attribute_Label: Bathrm
- Attribute_Definition: number of bathrooms
- Attribute:
-
- Attribute_Label: Hf_Bathrm
- Attribute_Definition: number of half bathrooms
- Attribute:
-
- Attribute_Label: Heat
- Attribute_Definition: heat type code
- Attribute:
-
- Attribute_Label: Heat_D
- Attribute_Definition: heating type description
- Attribute:
-
- Attribute_Label: Num_Units
- Attribute_Definition: number of units
- Attribute:
-
- Attribute_Label: AC
- Attribute_Definition: air conditioning in residence
- Attribute:
-
- Attribute_Label: Intwall
- Attribute_Definition: interior wall code
- Attribute:
-
- Attribute_Label: Intwall_D
- Attribute_Definition: interior wall description
- Attribute:
-
- Attribute_Label: Rooms
- Attribute_Definition: number of rooms
- Attribute:
-
- Attribute_Label: Bedrm
- Attribute_Definition: number of bedrooms
- Attribute:
-
- Attribute_Label: Kitchens
- Attribute_Definition: number of kitchens
- Attribute:
-
- Attribute_Label: Fireplaces
- Attribute_Definition: number of fireplaces
- 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: last year residence 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: Stories
- Attribute_Definition: number of stories in primary dwelling
- Attribute:
-
- Attribute_Label: Saledate
- Attribute_Definition: date of most recent sale
- Attribute:
-
- Attribute_Label: Price
- Attribute_Definition: price of most recent sale
- Attribute:
-
- Attribute_Label: Qualified
- Attribute_Definition: qualified
- Attribute:
-
- Attribute_Label: Sale_Num
- Attribute_Definition: sale number (always 1 to get most recent sale)
- Attribute:
-
- Attribute_Label: USECODE
- Attribute_Definition: property use code
- Attribute:
-
- Attribute_Label: LANDAREA
- Attribute_Definition: land area of property in square feet
- Attribute:
-
- Attribute_Label: PREMISEADD
- Attribute_Definition: property premise address
- 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
- 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: [email protected]
- 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: [email protected]
- 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
- 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:07 2015