AndreaBozzo/ceres-open-data-index huggingface dataset:
Water Services

ESRI map Fields: OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID ) TUMMS_ID ( type: esriFieldTypeString , alias: TUMMS_ID , length: 16 ) OWNER_CODE ( type: esriFieldTypeString , alias: Owner , length: 6 , Coded Values: [COE: City Of Everett] , [PUD: PUD] , [NAVY: Navy] , ...6 more... ) DIAMETER ( type: esriFieldTypeDouble , alias: Diam (in) , Range: [-1, 28] ) PIPE_MATERIAL_CODE ( type: esriFieldTypeString , alias: Material , length: 6 , Coded Values: [AC: Asbestos Cement] , [BR: Brick] , [CAS: Cast Iron] , ...11 more... ) INSTALLATION_DATE ( type: esriFieldTypeSmallInteger , alias: Install , Range: [1893, 2016] ) SERVICE_CONNECTION_TYPE_CODE ( type: esriFieldTypeString , alias: Type , length: 6 , Coded Values: [STD: Standard] , [FS: Fire] , [IRR: Irrigation] , ...1 more... ) METERED ( type: esriFieldTypeString , alias: Metered , length: 1 , Coded Values: [Y: Yes] , [N: No] ) SHAPE ( type: esriFieldTypeGeometry , alias: Shape ) GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 ) SHAPE.STLength() ( type: esriFieldTypeDouble , alias: SHAPE.STLength() )
Water Quality Index

Monthly water quality index at active sampling sites. The Water Quality Index, or WQI, is a number ranging from 1 to 100; a higher number indicates better water quality. In general, stations scoring 80 and above met expectations for water quality and are of lowest concern, scores 40 to 80 indicate moderate concern, and water quality at stations with scores below 40 did not meet expectations and are of highest concern. Data is available from https://ecology.wa.gov/Research-Data/Monitoring-assessment/River-stream-monitoring/Water-quality-monitoring/Using-river-stream-water-quality-data
Violent Crime Rates with Comparisons

Violent crime rates for Everett, Snohomish County, Washington State, and the US as reported by the FBI's National Incident-Based Reporting System (NIBRS) program. The violent crime rate is defined as the number of reported violent crimes per 100,000 residents. Violent crime figures include the offenses of murder, rape, robbery, and aggravated assault. Note that County population figures come from the US Census Bureau's American Community Survey.
Underground Storage Tank Decommissioning

Records of Everett Fire Department (EFD) permits related to decommissioning of residential heating oil tanks. Records from 2023 to current are from the City of Everett's CentralSquare Community Development permitting system. Data prior to 2023 comes from legacy systems and may also contain commercial decommissioning, installations, or missing/incomplete fields but represents all known records held by EFD. Official decommissioning of residential heating oil tanks became a state requirement in 1996. If no records exist, it may indicate that it occurred prior to 1996 (in which case EFD likely will not have a record), or that it was an unpermitted abandonment. The Washington State Department of Ecology maintains records for commercial tanks and tanks over 1,100 gallons at https://apps.ecology.wa.gov/cleanupsearch/reports/ust.
Sewer Service

ESRI Map Fields: OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID ) TUMMS_ID ( type: esriFieldTypeString , alias: TUMMS_ID , length: 16 ) OWNER_CODE ( type: esriFieldTypeString , alias: Owner , length: 6 , Coded Values: [COE: City Of Everett] , [PUD: PUD] , [NAVY: Navy] , ...11 more... ) DIAMETER ( type: esriFieldTypeDouble , alias: Diam (in) , Range: [-1, 18] ) PIPE_MATERIAL_CODE ( type: esriFieldTypeString , alias: Material , length: 6 , Coded Values: [BR: Brick] , [CAS: Cast Iron] , [CCP: Concrete Cylinder Pipe] , ...12 more... ) INSTALLATION_DATE ( type: esriFieldTypeInteger , alias: Install , Range: [1893, 2050] ) STATION ( type: esriFieldTypeString , alias: Station , length: 5 ) SHAPE ( type: esriFieldTypeGeometry , alias: Shape ) GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 ) SHAPE.STLength() ( type: esriFieldTypeDouble , alias: SHAPE.STLength() )
Police Incidents

Police Incidents represent all calls for police responses. These include burglary and trespass reports, assaults, drug related calls, thefts, vandalism, and reports of suspicious activity. Officer initiated activity such as traffic stops is also included in police incidents. Addresses and Geolocation have been partially obfuscated to the nearest 100 block to protect the privacy of individuals. When mapped this may make the data appear to happen at an intersection when it actually happens within that block. For incidents that do not have an exact block number or the address was typed in by dispatch incorrectly the obfuscation method may place the item much further away than the actual location. Some incidents will result in a police report, which can be found in the dataset "Police Cases." Case reports involving domestic violence, child abuse, or sex offenses involving minors have been removed from this data set. Incidents designated as Collisions are included in this dataset and should be classified as what was reported to the 911 dispatcher. In order to track verified collisions a Police Traffic Collision Report (PTCR) is completed, which results in a case being created.
ROW Areas

The Rows data set is a thematic layer depicting rights of way holding boundaries based on individual acquisitions. This layer is only complete on a date forward basis from final conversion (5/24/2002). Some back conversion has occurred, however, there are no present plans to perform complete backfile conversion. Rights of way entities may overlap completely or partially. Rights of way polygons/regions have been created for almost all rights of way to assist with cartographic applications only. This data layer is currently being reviewed for redesign of content and naming of the data set and attributes.
Housing Affordability

Quarterly median housing prices and Housing Affordability Index from Snohomish County and the state of Washington, per the University of Washington Runstad Department of Real Estate. Data available at: https://wcrer.be.uw.edu/archived-reports/. The Housing Affordability Index measures whether or not a typical family earns enough income to qualify for a mortgage loan on a typical home. A value of 100 means that a family with the median income has exactly enough income to qualify for a mortgage on a median-priced home. For example, a composite HAI of 120.0 means a family earning the median family income has 120% of the income necessary to qualify for a conventional loan covering 80 percent of a median-priced existing single-family home.
Everett Transit - Bus Stop Utilization

Daily average bus stop utilization. How to read our bus stop descriptions: most stops are located at intersections, on the street that is listed first in the description. The notations in the "< >" brackets show the direction of the bus and location of the stop relative to the intersection. For example, the stop at "SE EVERETT MALL WAY & 7TH AVE SE " is on SE Everett Mall Way, close to the intersection with 7th Ave SE. The bus will travel eastbound on SE Everett Mall Way, and it is far side of the intersection, so the bus will cross 7th Ave SE to reach the stop. EB - eastbound; WB - westbound; SB -southbound; NB - northbound ll FS - far side of the intersection, NS - nearside of the intersection, MB - midblock
Drainage Mains

ESRI Map Fields: OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID ) TUMMS_ID ( type: esriFieldTypeString , alias: TUMMS_ID , length: 16 ) OWNER_CODE ( type: esriFieldTypeString , alias: Owner , length: 6 , Coded Values: [COE: City Of Everett] , [PUD: PUD] , [NAVY: Navy] , ...11 more... ) DIAMETER ( type: esriFieldTypeDouble , alias: Diam (in) , Range: [-1, 180] ) PIPE_MATERIAL_CODE ( type: esriFieldTypeString , alias: Material , length: 6 , Coded Values: [BR: Brick] , [CAS: Cast Iron] , [CCP: Concrete Cylinder Pipe] , ...12 more... ) INSTALLATION_DATE ( type: esriFieldTypeInteger , alias: Install Date , Range: [1893, 2050] ) WORK_ORDER_NO ( type: esriFieldTypeString , alias: Work Order , length: 10 ) LINE_SEGMENT_TYPE_CODE ( type: esriFieldTypeString , alias: Type , length: 6 , Coded Values: [GM: Gravity Main] , [FM: Force Main] , [STD: Standard Service] , ...2 more... ) DRAINAGE_BASIN_CODE ( type: esriFieldTypeString , alias: Drainage Basin , length: 8 , Coded Values: [36THST: 36TH STREET COMBINE] , [DWNTWN: DOWNTOWN AREA] , [PIGEON1: PIGEON CR NO.1] , ...25 more... ) SHAPE ( type: esriFieldTypeGeometry , alias: Shape ) AREA_DESIGNATOR_CODE ( type: esriFieldTypeString , alias: Area Designator , length: 6 ) GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 ) SHAPE.STLength() ( type: esriFieldTypeDouble , alias: SHAPE.STLength() )
Domestic Violence Reported

Number of domestic violence offenses per 1,000 residents. Domestic violence includes any violence of one family member against another family member. Family can include spouses, former spouses, parents who have children in common regardless of marital status, adults who live in the same household, as well as parents and their children. Many offenses occur without arresting perpetrators. Data is available from: https://www.dshs.wa.gov/ffa/research-and-data-analysis/county-and-state
Crime Statistics, Washington State NIBRS Crimes Dataset 2016 - 2019

This dataset reports National Incident Based Reporting System (NIBRS) crime statistics from most Washington law enforcement agencies since 2016. The data is a "shapshot" of crime statistics as they were originally reported to the Washington Association of Sheriffs and Police Chiefs (WASPC) and the FBI. Data displayed should not be compared to statistics reported by the FBI as those statistics have been converted to the Summary Reporting System (SRS).
Building Footprint

Fields: OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID ) SHAPE ( type: esriFieldTypeGeometry , alias: SHAPE ) ADD_NO ( type: esriFieldTypeString , alias: Address No , length: 10 ) HALF ( type: esriFieldTypeString , alias: Unit , length: 10 ) ST_PRE ( type: esriFieldTypeString , alias: Street Prefix , length: 2 ) ST_NM ( type: esriFieldTypeString , alias: Street Name , length: 30 ) ST_SUFX ( type: esriFieldTypeString , alias: Street Suffix , length: 4 ) ST_POST ( type: esriFieldTypeString , alias: Street Post Direction , length: 2 ) ADD_LINK ( type: esriFieldTypeInteger , alias: Street , Coded Values: [1401: 1ST ST] , [270: 1ST AVE W] , [1399: 1ST AVE SE] , ...1918 more... ) ZIPCODE ( type: esriFieldTypeInteger , alias: Zipcode ) ADDRESS_ID ( type: esriFieldTypeInteger , alias: Master Address ID ) USE_ ( type: esriFieldTypeSmallInteger , alias: USE , Coded Values: [10: Mobile Home / Trailer] , [11: Single Family Residence] , [12: Duplex] , ...9 more... ) COMMENTS ( type: esriFieldTypeString , alias: COMMENTS , length: 255 ) SHAPE.STArea() ( type: esriFieldTypeDouble , alias: SHAPE.STArea() ) SHAPE.STLength() ( type: esriFieldTypeDouble , alias: SHAPE.STLength() ) GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 ) CODE ( type: esriFieldTypeString , alias: CODE , length: 6 ) FEATURE_ID ( type: esriFieldTypeInteger , alias: FEATURE_ID ) GIS_ID ( type: esriFieldTypeString , alias: GIS_ID , length: 16 )
Access to Healthy Food

Percentage of total population within a designated area that is identified as both “low income” and having “low access” to healthy food. Low income is defined as Low income is defined as having an annual family income at or below 200 percent of the Federal poverty threshold. Low access is defined as population that is beyond 1 mile for urban areas or 10 miles for rural areas from a supermarket. Note that there are many ways to measure food access for individuals and for neighborhoods, and many ways to define which areas are food deserts (neighborhoods that lack healthy food sources). Explore the USDA Food Access Research Atlas for more information: https://www.ers.usda.gov/data-products/food-access-research-atlas/.