Layer: Building Points (ID: 34)

View In: ArcGIS Online Map Viewer

Name: Building Points

Display Field: building_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV>SEMCOG maintains three separate data layers that represent information on built structures in Southeast Michigan: building footprints, building points, and condominium points. The Building Footprintswere the first dataset collected. These were originally developed by using heads-up digitizing to trace the outlines of buildings in 2010 aerial photography. This process was repeated later using 2015 and 2019 imagery. Due to differences in spatial accuracy between the 2010 and later imagery sources, footprint polygons delineated using 2010 aerial photography may appear slightly shifted compared with imagery that is more recent. This dataset is current as of April 2019, and contains only three attributes: the unique building identifier, median height and the source of the footprint polygon. The Building Pointsdataset is a point layer representing a single point, at the center of the structure, for each building in Southeast Michigan as of April 2020. For buildings with an associated footprint polygon, the building point represents the centroid of the polygon. For newer structures, a point is placed at the approximate center of the structure as shown in recent imagery, as no footprint polygon yet exists. Since it is the building points that represent our most current universe of buildings in the region, this is the dataset on which we store the associated attributes of a building, mainly location and physical characteristics obtained from local assessing data and other sources. The Condominium Pointsdataset is also a point layer, with each point representing an attached condominium unit located within a building. Unlike site condominiums, attached condominiums are by definition only a portion of a single building, but as each unit can be individually owned they need to be tracked independently. To ensure an accurate match between condominium points and the building in which they are located, the condominium points are placed on the building centroid, and do not represent the actual physical location of the unit.Building AttributesAs stated above, SEMCOG maintains building attributes on the building points data layer. The condominium points and building footprints data layers have only a small subset of these attributes. Table B.1 list the current attributes of the buildings dataset:Table B.1Buildings Dataset Attributes<TABLE><TBODY><TR><TD>FIELD</TD><TD>TYPE</TD><TD>DESCRIPTION</TD></TR><TR><TD>BUILDING_ID</TD><TD>Long Integer</TD><TD>Unique identification number assigned to each building.</TD></TR><TR><TD>PARCEL_ID</TD><TD>Long Integer</TD><TD>Identification number of the parcel on which the building is located.</TD></TR><TR><TD>BUILD_TYPE</TD><TD>Integer</TD><TD>Building type. Please see page three for a detailed description of the types.</TD></TR><TR><TD>CITY_ID</TD><TD>Integer</TD><TD>Identification number of the municipality, or for Detroit, master plan neighborhood, in which the building is located.</TD></TR><TR><TD>APN</TD><TD>Varchar(24)</TD><TD>Tax assessing parcel number of the parcel on which the building is located.</TD></TR><TR><TD>RES_SQFT 3</TD><TD>Long Integer</TD><TD>Square footage devoted to residential use. </TD></TR><TR><TD>NONRES_SQFT 3</TD><TD>Long Integer</TD><TD>Square footage devoted to nonresidential activity.</TD></TR><TR><TD>YEAR_BUILT</TD><TD>Integer</TD><TD>Year structure was built. A value of 0 indicates the year built is unknown.</TD></TR><TR><TD>DEMOLISHED</TD><TD>Date</TD><TD>Date structure was demolished. Buildings existing in 2010 but since demolished are maintained in the master file.</TD></TR><TR><TD>HOUSING_UNITS</TD><TD>Integer</TD><TD>Number of residential housing units in the building.</TD></TR><TR><TD>STORIES</TD><TD>Float(5.2)</TD><TD>Number of stories. For single-family residential this number is expressed in quarter fractions from 1 to 3 stories: 1.00, 1.25, 1.50, etc.</TD></TR><TR><TD>LOADD1</TD><TD>Long Integer</TD><TD>Street number, or lowest number for an address range.</TD></TR><TR><TD>HIADD1</TD><TD>Long Integer</TD><TD>Highest street number for an address range. A value of 0 indicates a single address for the building.</TD></TR><TR><TD>STREET1</TD><TD>Varchar(32)</TD><TD>Street name on which the building is located.</TD></TR><TR><TD>LOADD2</TD><TD>Long Integer</TD><TD>Street number, or lowest number for an address range, of second street address.</TD></TR><TR><TD>HIADD2</TD><TD>Long Integer</TD><TD>Highest street number for an address range, of second street address. A value of 0 indicates a single second address for the building.</TD></TR><TR><TD>STREET2</TD><TD>Varchar(32)</TD><TD>Street name on which the building is located, of second street address.</TD></TR><TR><TD>ZIPCODE</TD><TD>Varchar(5)</TD><TD>USPS postal code for the building address.</TD></TR><TR><TD>AKA</TD><TD>Varchar(40)</TD><TD>Alternate name or business name of the structure, if known.</TD></TR><TR><TD>GQCAP</TD><TD>Integer</TD><TD>Maximum number of group quarters residents, if any.</TD></TR><TR><TD>CONDO_ID 1</TD><TD>Long Integer</TD><TD>Unique identification record assigned to each condominium record.</TD></TR><TR><TD>MEDIAN_HGT 2</TD><TD>Integer</TD><TD>Median height of the building from LiDAR surveys, NULL if unknown.</TD></TR><TR><TD>SOURCE 2</TD><TD>Varchar(10)</TD><TD>Source of footprint polygon: NEARMAP, OAKLAND, SANBORN or SEMCOG.</TD></TR></TBODY></TABLE>1. Attribute only in the Condominium Points layer. 2. Attribute only in the Building Footprints layer.3. Square footage evenly divisible by 100 is an estimate, based on size and/or type of building, if the true value is unknown.Building TypesSEMCOG’s building types are based on the 2017 North American Industrial Classification System (NAICS). This system classifies establishments based on economic activity, is widely accepted by the planning community, and used by SEMCOG in developing its long-range socioeconomic forecasts. Each of the 22 nonresidential building types represent one or more entire 3-digit NAICS sector groupings, except for five special types of building that do not fit within this system. These specific types of activity (movie theaters, libraries, dormitories, funeral services, and parking garages) have land use and trip generation characteristics that are different from the other types of activity in their respective NAICS sector and are therefore classified individually. More information on NAICS, including descriptions of the economic activity sectors, can be found at the <A href="http://www.census.gov/eos/www/naics/">Census Bureau’s NAICS web site</A>. There are also four residential building types, which assist us in tracking housing development over time. Residential types are based on a combination of units in structure, and ownership. Single-family homes and site condominiums typically contain only one unit, but there are traditional duplexes where one owner owns both units, that are also classified as single-family. Attached condo buildings contain two or more housing units in a single building, each of which shares one or more walls with an adjoining unit and can be independently owned. Multi-family housing or apartment buildings contain three or more units, all of which are owned by a single entity and intended as rental units. Figure B.1Distribution of Buildings by TypeAs seen in Figure B.1, 86.9 percent of all buildings are single-family homes, and only 5.8 percent of buildings are of any nonresidential building type.Mobile homes are a special building type, as we do not receive information on changes to mobile homes in a manufactured housing park through the building permits pipeline. We instead maintain a separate layer of points representing individual mobile homes in parks, updated periodically using imagery to denote if a trailer is still present at each point. Pseudo footprints for these points are generated via code and added to the buildings manually.There are structures that SEMCOG does not classify as buildings. To be considered a building, a structure must contain either a housing unit or a minimum of 250 square feet of nonresidential workspace. Therefore, garages, boathouses, and other accessory structures are not classified as buildings. A description of SEMCOG building types, including the relevant NAICS codes for the type, can be found in Table B.2:Table B.2Building Types by NAICS Sector<TABLE><TBODY><TR><TD>BUILD TYPE</TD><TD>DESCRIPTION</TD><TD>NAICS SECTORS</TD><TD>RGB</TD></TR><TR><TD>11</TD><TD>Educational</TD><TD>611</TD><TD>190-232-255</TD></TR><TR><TD>13</TD><TD>Religious and Civic</TD><TD>813</TD><TD>0-132-168</TD></TR><TR><TD>14</TD><TD>Governmental</TD><TD>921-928</TD><TD>0-76-115</TD></TR><TR><TD>21</TD><TD>Retail Building</TD><TD>441-454, 811-812</TD><TD>255-190-190</TD></TR><TR><TD>23</TD><TD>Office Building</TD><TD>511-551, 561</TD><TD>255-0-0</TD></TR><TR><TD>31</TD><TD>Manufacturing</TD><TD>311-339</TD><TD>194-158-215</TD></TR><TR><TD>32</TD><TD>Wholesale Trade</TD><TD>423-425</TD><TD>170-102-205</TD></TR><TR><TD>33</TD><TD>Warehouse and Storage</TD><TD>493</TD><TD>112-68-137</TD></TR><TR><TD>41</TD><TD>Transportation and Utility</TD><TD>221, 481-488, 562</TD><TD>204-204-204</TD></TR><TR><TD>42</TD><TD>Delivery Services</TD><TD>491-492</TD><TD>156-156-156</TD></TR><TR><TD>51</TD><TD>Health and Social Services</TD><TD>621, 624</TD><TD>214-157-188</TD></TR><TR><TD>52</TD><TD>Hospital</TD><TD>622</TD><TD>245-122-182</TD></TR><TR><TD>53</TD><TD>Residential Care Facility</TD><TD>623</TD><TD>137-68-101</TD></TR><TR><TD>61</TD><TD>Leisure Activity</TD><TD>711-713</TD><TD>137-205-102</TD></TR><TR><TD>63</TD><TD>Hotel and Motel</TD><TD>721</TD><TD>209-255-115</TD></TR><TR><TD>65</TD><TD>Eating and Drinking</TD><TD>722</TD><TD>85-255-0</TD></TR><TR><TD>71</TD><TD>Agricultural</TD><TD>111-213</TD><TD>255-255-0</TD></TR><TR><TD>81</TD><TD>Single-Family Housing</TD><TD>Residential</TD><TD>255-211-127</TD></TR><TR><TD>82</TD><TD>Attached Condo Building</TD><TD>Residential</TD><TD>230-152-0</TD></TR><TR><TD>83</TD><TD>Multi-Family Apartment</TD><TD>Residential</TD><TD>137-112-68</TD></TR><TR><TD>84</TD><TD>Mobile Home</TD><TD>Residential</TD><TD>137-68-68</TD></TR><TR><TD>91</TD><TD>Movie Theater</TD><TD>51213</TD><TD>168-0-0</TD></TR><TR><TD>92</TD><TD>Library</TD><TD>51912</TD><TD>0-197-255</TD></TR><TR><TD>93</TD><TD>Dormitory Quarters</TD><TD>72131</TD><TD>92-137-68</TD></TR><TR><TD>94</TD><TD>Funeral Services</TD><TD>81220</TD><TD>255-127-127</TD></TR><TR><TD>95</TD><TD>Parking Garage</TD><TD>81293</TD><TD>78-78-78</TD></TR></TBODY></TABLE>The RGB color values match SEMCOG’s typical map symbology for building types.Relationship between Buildings LayersCounty land parcel layers are used to assign the unique APN (Assessor Parcel Number), as well as parcel identifier, to each structure located on a parcel by means of spatial intersection between the parcels and buildings layers. However, there are counties which do not represent parcel splits in their parcel layer when large vacant parcels are developed into single-family subdivisions. In these cases, the polygon geometry of the original parent parcel is cloned once for each new child parcel. A geospatial intersection of buildings to parcels in this situation would lead to each building in the subdivision being assigned to whichever parcel polygon happened to be sitting on top of the stack of cloned parcels. In these cases we use other sources, such as building permits and developer site plans, to identify the APN of each new building, and then assign the parcel identifier by finding the land parcel with that APN. Figure B.2Primary Key Relationship of Buildings Layers<TABLE><TBODY><TR><TD>Land Parcels</TD><TD>Building Footprints</TD><TD>Building Points</TD><TD>Condominium Points</TD></TR><TR><TD>parcel_id (unique) -----></TD><TD>parcel_id---------------></TD><TD>parcel_id ---------------></TD><TD>parcel_id</TD></TR><TR><TD></TD><TD>building_id (unique) ---></TD><TD>building_id (unique) ---></TD><TD>building_id</TD></TR><TR><TD>APN (unique) ----------></TD><TD>APN --------------------></TD><TD>APN --------------------></TD><TD>APN (unique)</TD></TR><TR><TD></TD><TD></TD><TD></TD><TD>condo_id (unique)</TD></TR></TBODY></TABLE>The APN and parcel identifier are passed to each building on a parcel, with each building assigned a unique building identifier. Since building points are the centroid of building footprints, they share the same building identifier as they reference the same structure. Condominium records are assigned a unique condo identifier, and also the building identifier of the structure they are located within. By this process, each layer has a unique identifier, and can be related to the larger parent geography as needed.VersionsDataset Uploaded 05/10/2021 –Added footprint polygons for 5,851 building points that did not yet have a footprint. All building points now have an associated building footprint. Updated addresses for an additional 30 mobile home parks. Removed 640 buildings permitted but not constructed by April 1, 2020.Dataset Uploaded 01/05/2021 –Added missing buildings between 2,000 and 10,000 square feet in size identified in Nearmap’s building outlines layer. Added mobile home units back into the coverage, and updated addresses for 93 mobile home parks.Dataset Uploaded 08/18/2020 –Added missing buildings greater than 10,000 square feet identified in Nearmap’s building outlines layer. Updated address and zip code from staff research.Dataset Uploaded 07/08/2020 –Added buildings constructed from 4/1/2015 through 4/1/2020 to the dataset. Updated missing or default square feet and year built from assessing rolls.Last Update: 05/10/2021</DIV></DIV></DIV>

Service Item Id: 7040877f566f4ee180e649102fcb045b

Copyright Text: Southeast Michigan Council of Governments (SEMCOG)

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Size:

Angle:

XOffset:

YOffset:

Outline:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

objectid ( modelName: gid, nullable: false, defaultValue: null, editable: false, alias: gid, type: esriFieldTypeOID )
building_id ( modelName: building_id, nullable: true, editable: true, defaultValue: null, alias: building_id, type: esriFieldTypeInteger )
parcel_id ( modelName: parcel_id, nullable: true, editable: true, defaultValue: null, alias: parcel_id, type: esriFieldTypeInteger )
build_type ( modelName: build_type, nullable: true, editable: true, defaultValue: null, alias: build_type, type: esriFieldTypeSmallInteger )
city_id ( modelName: city_id, nullable: true, editable: true, defaultValue: null, alias: city_id, type: esriFieldTypeSmallInteger )
apn ( modelName: apn, nullable: true, editable: true, defaultValue: null, length: 24, alias: apn, type: esriFieldTypeString )
res_sqft ( modelName: res_sqft, nullable: true, editable: true, defaultValue: null, alias: res_sqft, type: esriFieldTypeInteger )
nonres_sqft ( modelName: nonres_sqft, nullable: true, editable: true, defaultValue: null, alias: nonres_sqft, type: esriFieldTypeInteger )
year_built ( modelName: year_built, nullable: true, editable: true, defaultValue: null, alias: year_built, type: esriFieldTypeSmallInteger )
demolished ( modelName: demolished, nullable: true, editable: true, defaultValue: null, length: 29, alias: demolished, type: esriFieldTypeDate )
housing_units ( modelName: housing_units, nullable: true, editable: true, defaultValue: null, alias: housing_units, type: esriFieldTypeSmallInteger )
stories ( modelName: stories, nullable: true, editable: true, defaultValue: null, alias: stories, type: esriFieldTypeDouble )
loadd1 ( modelName: loadd1, nullable: true, editable: true, defaultValue: null, alias: loadd1, type: esriFieldTypeInteger )
hiadd1 ( modelName: hiadd1, nullable: true, editable: true, defaultValue: null, alias: hiadd1, type: esriFieldTypeInteger )
street1 ( modelName: street1, nullable: true, editable: true, defaultValue: null, length: 32, alias: street1, type: esriFieldTypeString )
loadd2 ( modelName: loadd2, nullable: true, editable: true, defaultValue: null, alias: loadd2, type: esriFieldTypeInteger )
hiadd2 ( modelName: hiadd2, nullable: true, editable: true, defaultValue: null, alias: hiadd2, type: esriFieldTypeInteger )
street2 ( modelName: street2, nullable: true, editable: true, defaultValue: null, length: 32, alias: street2, type: esriFieldTypeString )
zipcode ( modelName: zipcode, nullable: true, editable: true, defaultValue: null, length: 5, alias: zipcode, type: esriFieldTypeString )
aka ( modelName: aka, nullable: true, editable: true, defaultValue: null, length: 40, alias: aka, type: esriFieldTypeString )
gqcap ( modelName: gqcap, nullable: true, editable: true, defaultValue: null, alias: gqcap, type: esriFieldTypeSmallInteger )

Templates:

Name: Building Points
Description:
Prototype:
Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations: Query Query Attachments Query Analytic Query Top Features Calculate Append Validate SQL Generate Renderer Return Updates Metadata