AndreaBozzo/ceres-open-data-index huggingface dataset:
Multifamily Housing Construction Sites

This dataset contains multifamily affordable and market-rate housing sites (typically 5+ units) in the City of Detroit that have been built or rehabbed since 2015, or are currently under construction. Most sites are rental housing, though some are for sale. The data are collected from developers, other government departments and agencies, and proprietary data sources in order to track new multifamily and affordable housing construction and rehabilitation occurring in throughout the city, in service of the City's multifamily affordable housing goals. Data are compiled by various teams within the Housing and Revitalization Department (HRD), led by the Preservation Team. This dataset reflects HRD's current knowledge of multifamily units under construction in the city and will be updated as the department's knowledge changes. For more information about the City's multifamily affordable housing policies and goals, visit here.Affordability level for affordable units are measured by the percentage of the Area Median Income (AMI) that a household could earn for that unit to be considered affordable for them. For example, a unit that rents at a 60% AMI threshold would be affordable to a household earning 60% or less of the median income for the area. Rent affordability is typically defined as housing costs consuming 30% or less of monthly income. Regulated housing programs are designed to serve households based on certain income benchmarks relative to AMI, and these income benchmarks vary based on household size. Detroit city's AMI levels are set by the Department of Housing and Urban Development (HUD) for the Detroit-Warren-Livonia, MI Metro Fair Market Rent (FMR) area. For more information on AMI in Detroit, visit [here].
Bike Lanes

This dataset is maintained by the City of Detroit’s Department of Public Works (DPW), Complete Streets Division. It is based on the Michigan Geographic Framework (Version 12b) and uses the regional road network to identify roadways with existing bicycle facilities across Southeast Michigan. The data captures existing bicycle routes; local, county, regional, state, and national, as well as the various types of bicycle facilities. Bicycle Facility Definitions: Bike Lanes: Designated painted lanes on the road for biking, marked with lines, bike symbols, and signs to separate cyclists from vehicle traffic. Signed Routes: Bike routes marked only with signs (no pavement markings), often used for neighborhood connectors. Share the Road Routes: Routes with signs and bike symbols on pavement. Indicating cyclists and motorists may use the full road. Shared-Use Paths: Off-street paths shared by cyclists, pedestrians, and other non-motorized users (ex: scooters). Protected Bike Lanes: Bike lanes that are physically separated from traffic, usually with delineators or concrete barriers. Buffered Bike Lanes: Painted buffered space between vehicle traffic lane and bike lane. Route Type Defintions: On -Road: Bicycle route located within the street right-of-way shared between cyclists and motorists. On-Road Adjacent: Bicycle route located within the street right-of-way separated by paint, buffer, curb, parking lane. These routes allow cyclists to travel separated from vehicle traffic. Off-Street: Bicycle route on an independent path or trail separated from streets and motor vehicle traffic. For a better visual experience, please use the [interactive map].
Joe Louis Greenway Route Segments

The Joe Louis Greenway (JLG) is a recreational pathway that will unify Detroit’s neighborhoods, people and parks. This dataset represents the approximate route of the Joe Louis Greenway. It is meant as a line representation of the route, not the dimensions. The JLG route is divided into segments, which are annotated with the segment name, the neighborhood and broader district where it is located, a current development phase (open, under construction, funded, or unfunded), and type (e.g., off-street or on-street). The 30-mile greenway will connect parks and neighborhoods across the city, allowing residents to travel safely from McNichols to the riverfront—all without a car—through a combination of new trails, on-street protected bike lanes and links to existing trails like the Dequindre Cut and the RiverWalk. The greenway includes the cities of Dearborn, Hamtramck, and Highland Park, linking them to larger trail systems that crisscross the entire state and pass through five City of Detroit council districts.
Pedestrian Bridges

This inventory of Detroit pedestrian bridges and their condition assessments is derived from the Michigan Department of Transportation (MDOT) and includes pedestrian bridges that span State of Michigan roadways only. Inspections of pedestrian bridges over State of Michigan routes are performed on a risk-based interval by MDOT, not to exceed 24 months. While not governed by the National Bridge Inspection Standards, these inspections are performed to maintain safety of the traveled way and to provide information needed for asset management. Routine Inspections of the entire structure may be supplemented by Special Inspections of Bridge Components that require more frequent monitoring. Condition ratings for pedestrian bridges are evaluated following the National Bridge Inventory Condition Ratings in a similar manner to vehicle bridges. These ratings are based on a 0-9 scale, where 0 is "Failed condition" and 9, "Excellent condition". Condition ratings are assigned for the deck, superstructure and substructure of each bridge or for each culvert. A culvert is a structure that allows passage under a roadway and has a short span (less than 20 feet).
Right of Way Act 51 Map

The Act51 Map Layer represents the road network that the City of Detroit reports to the Michigan Department of Transportation on a annual basis. The Act51 Map Layer identifies road jurisdictions for permitting and planning. Public Act 51 of 1951 created the Michigan Transportation Fund (MTF), and it is the main road funding source for most cities and villages. This Act defines the formula by which Michigan distributes money for road maintenance to cities, villages, and counties. Under Act 51, county roads can be classified as either primary or local roads. City and village streets can be classified as either major or local streets. Primary roads and major streets are selected by the counties, cities and villages on the basis of the greatest general importance to each respective local agency.
Right of Way Maintenance Agreements

For more information please visit the Maps and Records [website]. This data represents legal agreements that the Department of Public Works has made with property owners related to the maintenance of certain streets and/or alleys. Maintenance Agreements are created when the property owner has identified a certain street and/or alley as being critical to how the property operates. Examples include using an alley for access to parking for a business, loading zones for commercial establishments, private improvements to streets and/or alleys that are not standard to City construction methods, and all other approved encroachments.
Detroit Safe Access to Transit

Detroit Safe Access to Transit (DSAT) deploys safety countermeasures at 56 bus stop intersections with a history of fatal or serious injury crashes involving pedestrians or cyclists. In 2023, the City of Detroit was awarded a $24.8 million Safe Streets for All (SS4A) grant from the U.S. Department of Transportation (USDOT). In addition to safety countermeasures, DSAT also implements ADA improvements, and safety training for DDOT operators. The work is divided into two bus stop types: Safer Bus Stops - high crash intersections without transfers. Safer Transfers - high crash signalized intersections that operate as transfer locations between routes. Safety improvements can include: +Permanent transit islands + Certain transit amenities +Sidewalk widening + ADA improvements +Signal improvements +Lighting upgrades + Pavement markings + Centerline hardening
Detroit Safe Routes to School Projects

Safe Routes to School (SRTS) aims to create routes for children of all ages and abilities to bike, walk, and roll to school in a safe and secure environment. The program works to create a safer environment by reducing traffic hazards in the roadway and encourages physical activity children need to maintain good health. Providing avenues for children to walk and bike to school can promote a child's sense of independence and increase learning readiness in the classroom. The SRTS grant program is funded by the U.S. Department of Transportation and administered by the Michigan Department of Transportation (MDOT). The program funds both physical infrastructure improvements near schools (for example, sidewalk repairs, improved crosswalks, and signage), as well as educational activities to encourage walking and biking. Interested schools work with the City of Detroit's Complete Streets team to identify needed and priority improvements at their schools and then apply for grant funding through MDOT. More information about the program is available from the [Complete Streets' Safe Routes to School webpage]. Each row in the dataset represents a school that has participated in the SRTS program, and includes the School Name, Address, Status of the SRTS project, Award Date, Construction Start and Completion Dates, the State of Michigan Center for Educational Performance and Information (CEPI) Educational Entity Master (EEM) database Entity ID, the Council District and Neighborhood where the school is located, and Address and Parcel IDs. School name, address, and Entity ID data was sourced from the City of Detroit's [Primary and Secondary Schools ]dataset, which is based on a subset of the State of Michigan Center for Educational Performance and Information (CEPI) Educational Entity Master (EEM) database.
Safe Streets for Detroit Corridors

Safety improvement corridors funded through Detroit’s 2022 Safe Streets for All Award (SS4A). Safe Streets for Detroit (SS4D) is a response to a dramatic 88% increase in Detroit’s traffic fatality rate from 2017 to 2020, highlighting the urgent need for action. To address this crisis, the City of Detroit applied for and was awarded a $24.8 million SS4D grant from the U.S. Department of Transportation (USDOT). This funding supports a citywide effort to redesign streets for safety and accessibility. A total of 31 miles of safety improvements will be delivered across 17 priority corridors throughout the city. The work is divided into two types of safety protective corridors: Rapid Implementation - Quick-build, lower-cost measures to deliver safety benefits. These can include upgraded pavement markings, paint-and-post curb bump-outs, signage, and signal timing improvements. Enhanced Protection - Permanent infrastructure safety improvements that can include concrete curb bump-outs, improved bike lanes, and pedestrian refuge islands.
Annual Life Safety Fire Inspections

Annual Life Safety Fire Inspections are conducted by the [Detroit Fire Department (DFD) Fire Marshal Division] in accordance with Chapter 18 of the Detroit City Code, the Detroit Fire Prevention and Protection Code. Inspections occur as a part of routine daily district work in support of the core mission of the DFD Fire Marshal Division to provide the citizens and visitors of Detroit with the highest level of fire prevention using standards and guidelines set forth by the Michigan Building Code, City Ordinance and the NFPA (National Fire Protection Association). Inspections are also conducted to fulfill City of Detroit (CoD) Business Licensing requirements. Business owners required to obtain or renew a CoD Business License from Buildings, Safety Engineering, and Environment Department (BSEED) must get a Fire Permit from the Fire Marshal division as a part of the licensing process. The Permit certifies that the business premises have undergone and passed a Life Safety Fire Inspection. Each record in this dataset represents a fire inspection occurrence. There are scenarios where an inspection ID is associated with more than one record. This may indicate that there was a violation on the initial or previous inspection(s), which would result in a reinspection.
Fire Investigations

The [DFD Fire Investigation Division (FID)] is tasked with investigating all intentional (arson) and accidental fires to determine the origin, cause, and circumstances of fires within the city. Fire investigations serve not only to document the circumstances associated with fires, but also contribute to development and implementation of fire prevention strategies and programs. Fire investigations are conducted according to the City of Detroit Fire Prevention and Protection Code (Detroit City Code Chapter 18), the State of Michigan Fire Prevention Code (Act 207 of 1941), and NFPA (National Fire Protection Association) Standards 921 (Guide for Fire and Explosion Investigations) and 1033 (Professional Qualifications for Fire Investigator). Each row in the dataset represents a fire investigation, and includes data about investigation status, when and where the fire occurred, when the investigation started, the primary cause (‘determination’) of the fire, and civilian injuries and fatalities associated with the fire. Fire Investigation records can be linked to [Fire Incident] records using the fire incident number. Note that if DFD was not called to the fire under investigation (about 2-3% of investigations), a fire incident number is not included in the investigation record. This occurs if, for example, DPD rather than DFD is dispatched because a fire that was extinguished is reported. The Fire Investigations dataset is updated daily and includes records from 2019 to the present.
Project Green Light Locations

The Project Green Light Locations data set documents private businesses and other organizations that participate in [Project Green Light Detroit], a program started on January 1, 2016 as a partnership between local businesses, the City of Detroit and community groups. Local businesses and organizations that participate in this program have installed real-time camera connections with Detroit Police Department headquarters and visibly communicate their participation to the public through project-specific green lights and signage at each participating location. PGL locations have grown in number and diversity from eight gas stations at the inception of the program in 2016 to include a growing number of retail and service-based businesses, residential facilities such as apartment complexes and nursing homes, and community organizations such as houses of worship. The PGLL dataset records location-level data and includes the business or organization name, address, business type, corresponding police precinct, and the date a location went live with a real-time camera connection to DPD. Records in the data set have been enriched through geocoding to enable us to map address locations. If a business or organization has multiple participating locations, a record for each location is included in the data set.
City of Detroit Contracted Stabilizations

The stabilization process includes data collection, trash removal, and board-up services. Each record represents a property that is under contract for stabilization services by the City of Detroit. For more information please refer to the [Construction and Demolition Department] page on the City of Detroit's website. Once a property is contracted for stablization, it will then go through the stablizition process and eventually be marked as a completed stabilization once the process is complete.
DLBA Auction Sales

Detroit Land Bank Authority (DLBA) program helps organizations purchase houses and/or vacant land at discounted prices. The dataset provides information on the properties that have been successfully sold by the DLBA to organizations or individuals through auction. The Detroit Land Bank Authority (DLBA) works directly with individual buyers, as well as Community Partner organizations and developers to achieve their mission to return the city's blighted and vacant properties to productive use. They utilize a variety of sales programs to make homeownership and land purchases accessible to Detroiters. One of these programs is the auction program. Each row in the dataset represents a DLBA-acquired home that has been sold through auction and includes data about the closing date, sale price, and location information such as address, parcel ID, and neighborhood. Point geometry is used to identify the location of the address associated with each property. More information about the Auction Sales program is available through the [DLBA 'Structures' program] and [Frequently Asked Questions (FAQ)] pages. Click [here] for the Analytics Hub visualization of this dataset.
DLBA Own It Now Sales

The Detroit Land Bank Authority's (DLBA) Own It Now (OIN) program offers vacant homes for sale with a minimum offer price of $1,000. Homes are available on the DLBA website for sale 24 hours a day, 7 days a week and may be offered on at any time. Homes are sold as is and buyers are required to rehab the houses and ensure that they are occupied. The dataset provides information on the properties that have been successfully sold by the DLBA through the OIN program. The Detroit Land Bank Authority (DLBA) works directly with individual buyers, as well as Community Partner organizations and developers to achieve their mission to return the city's blighted and vacant properties to productive use. They utilize a variety of sales programs to make homeownership and land purchases accessible to Detroiters. One of these programs is Own it Now (OIN). Each row in the dataset represents an OIN home and includes data about the sale status, closing date for sold homes, sale price, and location information such as: address; parcel ID; and neighborhood. For more information about the DLBA's sales programs please visit their [website]. Click [here] for the Analytics Hub visualization of this dataset.
DLBA Project Sales

This dataset contains sale information for properties sold by the Detroit Land Bank Authority (DLBA) through the Community Partner and Economic Development sales programs. The Community Partner program enables programs organizations purchase houses and/or vacant land at discounted prices for home rehab projects, urban gardening, green space projects or any use that enhances the quality of life in neighborhoods. The Economic Development program partners with locally based real estate companies to market properties that support infill development, are guided by City of Detroit planning studies, or adjacent to City-owned parcels that may be co-marketed for specialized development. Each row in the dataset represents a DLBA-acquired home that has been sold to a community partner or economic development program and includes data about the closing date, sale price, and location information such as address, parcel ID, and neighborhood. For more information about the DLBA's Community Partnership program [click here]. For more information about the DLBA's Projects program [click here]. Click [here] for the Analytics Hub visualization of this dataset.
DLBA Vacant Land Program Sales

Detroit Land Bank Authority (DLBA) Land Reuse Programs are designed to activate vacant land and provide low cost land ownership opportunities for residents. Programs offered by the DLBA include the Side Lots program, through which residents may purchase lots immediately adjacent to their home as well as programs for Neighborhood Lots, Oversized Lots, and Accessory Structure Lots. This dataset provides information on properties that have been sold by the DLBA through the Land Reuse Programs. Each row in the dataset represents a DLBA-acquired property that has been sold through a land reuse program and includes data about the closing date, sale price, parcel number, and location. Location information includes the property's street address, neighborhood, council district, and the geographical coordinates associated with the street address. The geographical coordinates are used to map the location of lots using point geometry. More information about the Auction Sales program is available through the DLBA [Land Reuse Programs] and [Frequently Asked Questions (FAQ)] pages. Click [here] for the Analytics Hub visualization of this dataset.
Property Sales

The Office of the Assessor compiles property sales data to perform an annual property sales study to adjust calculated costs of property values based on local market conditions. This dataset includes property sales data obtained for annual sales studies from 2018 to the present. While only Valid Arm's Length transactions that occurred in the two years prior to when a given sales study is finalized are included in each study, this dataset includes all sales transactions obtained to perform the sales studies, whether or not the sales transactions met inclusion criteria for a study. More information about the [Sales Study] is available from the Office of the Assessor. Values in categorical fields such as 'Sales Instrument' are recorded based on State of Michigan CAMA standards at the time the value was recorded. Some variation in field value codes occurs over time as a related CAMA standard is updated. CAMA standards are available from the [State of Michigan Department of Treasury State Tax Commission]. [Click here] for the Analytics Hub visualization of Property Sales.
Energy Water Benchmarking Ordinance - Buildings

The verified list of buildings in Detroit that are over 25,000 square feet and thus fall under the [Energy and Water Benchmarking Ordinance] passed by City Council in 2023. This dataset includes building information, emissions/energy scores, and geospatial data of each building footprint. When Property ID and Energy Star Name values are non-null, this indicates a record and/or energy usage data is present in [Energy Star Portfolio Manager] that tracks building energy and/or water usage over time.
Energy Water Benchmarking Ordinance - Usage

Energy and water usage data for City-owned buildings. Each record represents usage over a particular time period with the type of usage indicated including electricity, gas, steam, or water. In the future this dataset will include usage data for all buildings in Detroit that are over 25,000 square feet and thus fall under the [Energy and Water Benchmarking Ordinance] passed by City Council in 2023. This usage data is sourced from [Energy Star Portfolio Manager] and is updated on a daily basis. This usage data is related to buildings represented in the [Energy Water Benchmarking Ordinance - Buildings Dataset].
Traffic Crashes

The State of Michigan's criteria for a crash is a motor vehicle that was in transport and on the roadway, that resulted in death, injury, or property damage of $1,000 or more. Traffic crashes in this dataset are derived from SEMCOG's Open Data Portal. Each row in the dataset represents a traffic crash that includes data about when and where the crash occurred, road conditions, number of individuals involved in the crash, and various factors that apply to the crash (Train, Bus, Deer, etc.). Also included is the number of injuries and fatalities that are associated with the crash.