building_footprints_pdx |
Table Description | |
Table Jurisdiction | |
Column Sort | Column Name | Column Alias | Column Type | Column Size | Domain Value(s) | Column Description |
1 | OBJECTID | | Numeric | 8 | | A unique ID for each building polygon (generated by the GIS software); these IDs can change. | 1 | SOURCE | SOURCE | String | 30 | Aerial Photos | 6" resolution regional aerial photos.
| X | Lidar-Derived | Building was digitzed automatically from most recent LiDAR data (2004, 2005, 0r 2007)
| X | LUR/Building Permit | Land use review or building permit information, including site plans
| X | Other | Other reference source (see notes)
| X | Photogrammetrics | Derived from 1990's photogrammetric information.
| X | 3D Model | 3D model provided by developer (usually a SketchUp model)
| X | | The reference source used to map the building (same domain as the HGT_SOURCE attribute) | 1 | STATE_ID | STATE_ID | String | 20 | | The state ID of the primary taxlot on which the building resides (usually derived from the center of the building polygon). | 1 | SURF_SRC | SURF_SRC | String | 30 | LiDAR DEM | Surface elevation derived from a 3' resolution LiDAR surface elevation model generated from 2004 through 2007 bare earth LiDAR point returns. Vertical accuracy is generally within +/- 15cm (~6") for relatively flat areas not obscured by vegetation, +/- .7m (~2.5') where in areas of steep slopes or surfaces covered by vegetation.
| X | 2001 DEM | A 10' resolution DEM generated from a 2001 DTM created from 2001 aerial photos. Surface elevations derived from the 2001 DEM are within +/- 5' in most cases.
| X | | The source information for the surface elevation | 1 | BLDG_ADDR | BLDG_ADDR | String | 50 | | The building's street address | 1 | BLDG_NAME | BLDG_NAME | String | 150 | | The building name (if known) | 1 | NUM_STORY | NUM_STORY | Integer | 2 | | The maximum number of building stories (if known) | 1 | BLDG_SQFT | BLDG_SQFT | Integer | 4 | | The building square footage (if known, usually gross) | 1 | YEAR_BUILT | YEAR_BUILT | Integer | 2 | | The year construction of the building was completed (if known) | 1 | BLDG_TYPE | BLDG_TYPE | String | 30 | | The type of building (house, garage, etc.). Not yet populated. Domain to-be-determined. | 1 | BLDG_ID | BLDG_ID | String | 30 | | The unique building ID. This is the master identifier for the building. These IDs do not change and will not be reused. | 1 | BLDG_USE | BLDG_USE | String | 30 | Commercial General | General commercial use
| X | Commercial Grocery | Grocery store or market
| X | Commercial Hotel | Hotel or motel use.
| X | Commercial Restaurant | Restaurant or bar use
| X | Commercial Office | Commercial Office use
| X | Commercial Retail | Commercial Retail use
| X | Industrial | Industrial use
| X | Institutional | Institutional use including hospitals and universities
| X | Multi Family Residential | Multi family residential use (including condos, apartments, 3 or more unit plexes)
| X | Parking | Structured parking
| X | Single Family Residential | Single Family Residential (including ADUs, rowhouses, and duplexes)
| X | Vacant | Vacant | X | | Predominant building use. Not consistently populated outside Portland's Central City. | 1 | ROOF_ELEV | ROOF_ELEV | Numeric | 8 | | The maximum roof elevation (above NAVD88 datum) of the building footprint in feet. | 1 | AVG_HEIGHT | AVG_HEIGHT | Numeric | 8 | | The maximum average height of the building footprint in feet. | 1 | HEIGHT_SRC | HEIGHT_SRC | String | 30 | Aerial Photos | Building Height estimated from 6" aerial photos (flown every year) | X | Field Estimate | Building height estimated in the field (by counting stories, for example). | X | Field Measurement | Building height estimated in the field using a laser range-finder or other measurement method. | X | Inferred from Assessor Sqft | Building height inferred from County Assessor square footage. Total assessed square footage is divided by the footprint square footage and the result multiplied by average floor height. Used for single-family buildings only. | X | Lidar DSM | Building height manually derived from 2004 to 2007 LiDAR first-return "digital surface model" (DSM) | X | Lidar-Derived | Building heights automatically derived from 2004 to 2007 LiDAR data by Watershed Sciences using the process described in the data lineage section above. | X | LUR/Building Permit | Building height information derived from documents and plans submitted as part of the land-use review (LUR) and building permit process. | X | Oblique Aerials | Building height information derived from oblique aerial photos and "street view" photos accessible in Bing, Google Earth, and Google Maps. | X | Other | Building height information derived from a non-standard source (refer to notes) | X | Photogrammetrics | Building height derived from photogrammetric data derived from aerial photos flown from 1987 to 1994. | X | 3D Model | Building height information derived from a digital 3D model provided by the developer (usually in SketchUp format). | X | | The reference data source used to derive the height and elevation of the building or portion of a building. | 1 | SURF_ELEV | SURF_ELEV | Numeric | 8 | | The average surface elevation (above NAVD88 datum) of the land beneath the building footprint in feet. | 1 | CREATEDATE | CREATEDATE | Date | 8 | | The date that the building was originally mapped (added to the GIS data, if known) | 1 | MOD_DATE | MOD_DATE | Date | 8 | | The date of the most recent edits to the building footprint (if known) | 1 | MOD_NAME | MOD_NAME | String | 50 | | The initials of the person that last edited the building or portion of a building | 1 | FIELD_DATE | FIELD_DATE | Date | 8 | | The date of any field visit to the building | 1 | REVIEW | REVIEW | String | 30 | | "T" indicates the building or portion of the building needs to be reviewed for mapping and/or height accuracy. | 1 | NOTES | NOTES | String | 150 | | Notes and comments related to the building or portion of a building | 1 | SUBAREA | SUBAREA | String | 30 | City of Portland | City of Portland maintenance area
| X | Metro | Metro regional maintenance area
| X | | Names of regional data-maintenance subareas | 1 | LAT_CTR | LAT_CTR | Numeric | 8 | | Latitude of the center of the building footprint | 1 | LONG_CTR | LONG_CTR | Numeric | 8 | | Longitude of the center of the building footprint | 1 | WSUNIQUEID | WSUNIQUEID | String | 30 | | Unique ID assigned by Watershed Sciences for buildings automatically derived from LiDAR (no longer used) | 1 | BPS_BLDGID | BPS_BLDGID | Integer | 4 | | Old BPS unique building ID (no longer used) | 1 | BLDG_NUMB | BLDG_NUMB | Integer | 2 | | The building number. Each building on a single parcel receives a unique number, starting with #1. These numbers are used to construct the unique building ID. | 1 | SQFT_SRC | SQFT_SRC | String | 50 | | Source of square footage information | 1 | STORY_SRC | STORY_SRC | String | 50 | | Source of number of stories | 1 | STRUC_TYPE | STRUC_TYPE | String | 30 | Reinforced Masonry | Reinforced masonry construction
| X | Steel Framed | Steel framed construction
| X | Unreinforced Masonry | Unreinforced masonry construction
| X | Wood Framed | Wood framed building
| X | | The predominant construction method used to build the structure. | 1 | STRUC_COND | STRUC_COND | String | 30 | Unsafe | Structure deemed unsafe by the Portland Fire Bureau
| X | | The general condition of the structure. | 1 | ROOF_TYPE | ROOF_TYPE | String | 15 | Complex | Complex structure with no consistent features.
| X | Flat | Flat roof
| X | Multi-level Flat | Flat roof with multiple levels (portions of the building are different heights)
| X | Pitched | Pitched roof
| X | | The basic roof structure type. Automatically populated for all LiDAR-derived buildings, manually populated for other buildings on a case-by-case basis. | 1 | ORIENT | ORIENT | Numeric | 8 | | The orientation angle of the building along it's longest axis. Automatically populated for all LiDAR-derived buildings, manually populated for other buildings on a case-by-case basis. | 1 | VOLUME | VOLUME | Integer | 4 | | Estimated volume of building (in cubic feet). Calculated by multiplying the footprint area by the average building height. | 1 | CREATED_BY | CREATED_BY | String | 50 | BPS | City of Portland Bureau of Planning and Sustainability
| X | CGIS | City of Portland Corporate GIS group
| X | City of Beaverton | | X | City of Gresham | | X | City of Hillsboro | | X | City of Lake Oswego | | X | City of Portland | Building created by other City of Portland organization
| X | City of Tualitan | | X | City of West Linn | | X | Metro | | X | Oregon City | | X | PPR | City of Portland Parks and Recreation
| X | Watershed Sciences | Building automatically derived from LiDAR by LiDAR consultant Watershed Sciences
| X | | Name of agency that originally mapped the building | 1 | SOURCE_REF | SOURCE_REF | String | 50 | | Additional details about the mapping source (e.g., the date of LiDAR data used, the LUR/building permit case number, etc.) | 1 | MAX_HEIGHT | MAX_HEIGHT | Numeric | 8 | | The maximum roof height of the building footprint in feet. Consistently populated for LiDAR-derived buildings only. | 1 | MIN_HEIGHT | MIN_HEIGHT | Numeric | 8 | | The minimum roof height of the building footprint in feet. Consistently populated for LiDAR-derived buildings only. | 1 | BLDG_STAT | BLDG_STAT | String | 50 | Demolished | Demolished building
| X | Existing | Existing building (or under construction)
| X | Proposed | Proposed building (not yet under construction)
| X | | The status of the building | 1 | UNITS_SRC | UNITS_SRC | String | 30 | County Assessor Database | Derived from tax asessor information.
| X | Developer | Unit information received directly from developer..
| X | Development Capacity GIS Model | Units estimated by BPS buildable lands inventory GIS development capacity model.
| X | LUR/Building Footprint | Derived from land use review or building permit information.
| X | Metro MFR Inventory | Units derived from Metro's regional mult-family inventory.
| X | Marketing Information/Research | Source is online research of the building (we googled it).
| X | | Source of the residential unit information. | 1 | UNITS_RES | UNITS_RES | Integer | 2 | | Total number of residential units in the building. Derived from building permit information, tax assessment information, and Metro's regional multi-family inventory. In the case of the latter, which is parcel-based, units are assigned to buildings based on weighted building square footage. | 1 | OCCUP_CAP | OCCUP_CAP | Integer | 2 | | Maximum building occupancy (where known). | 1 | OCCUP_SRC | OCCUP_SRC | String | 50 | Portland Parks Bureau | | X | Portland Fire Bureau | | X | | Source of maximum building occupancy information. | 1 | ADA_ACCESS | ADA_ACCESS | String | 5 | | "T" indicates the building is ADA accessible (where known). | 1 | SURF_OFF | SURF_OFF | Numeric | 8 | | | 1 | SURF_ADJ | SURF_ADJ | Numeric | 8 | | | 1 | PROPKEY | PROPKEY | Integer | 4 | | | 1 | EDIT_STAT | EDIT_STAT | String | 50 | | | 1 | DATA_SOURCE | DATA_SOURCE | String | 5 | | | 1 | RETIRED_BY | RETIRED_BY | String | 50 | | | 1 | RETIRED_DATE | RETIRED_DATE | Date | 8 | | |