mm-intelligence/montgomery-civic-data

---
license: cc-by-4.0
language:
- en
tags:
- civic-data
- montgomery-alabama
- open-data
- "311"
- government
- urban-planning
- public-safety
size_categories:
- 100K<n<1M
---

# Montgomery, Alabama — Civic Open Data

Cleaned and structured civic datasets from Montgomery, Alabama's Open Data Portal.

## Overview

This dataset collection contains 32 tables covering civic services, public safety, business licensing, property, infrastructure, and community resources for Montgomery, Alabama (population ~200,000).

**Total records:** ~916,000 across all tables
**Time range:** 2014–2026 (varies by table)
**Source:** [City of Montgomery Open Data Portal](https://opendata.montgomeryal.gov/)
**Curated by:** [MM Intelligence](https://mmintelligence.ai) — Montgomery, Alabama

## Datasets

### Core Civic Data
| File | Records | Description |
|------|---------|-------------|
| service_requests_311.csv | 207,630 | Non-emergency service requests (2021–present) |
| business_licenses.csv | 123,398 | Business licenses (one per license-year, 2014–present) |
| code_violations.csv | 78,942 | Code enforcement violations |
| construction_permits.csv | 43,419 | Building/construction permits |
| fire_rescue.csv | 55,727 | Fire/EMS incidents with response times |
| nuisance_cases.csv | 3,573 | Nuisance abatement cases |
| environmental_nuisance.csv | 330 | Environmental nuisance complaints |

### Public Safety
| File | Records | Description |
|------|---------|-------------|
| fire_responses_full.csv | 264,731 | Full fire response history with property loss, detector info, apparatus |
| emergency_911_calls.csv | 454 | Emergency 911 call records |
| hydrants.csv | 11,468 | Fire hydrant locations and status |

### Property & Housing
| File | Records | Description |
|------|---------|-------------|
| parcels_property.csv | 111,122 | Property parcels with owner, assessed value, land use |
| housing_condition.csv | 5,561 | Housing condition assessments |
| surplus_properties.csv | 89 | City surplus properties |

### Infrastructure & Transportation
| File | Records | Description |
|------|---------|-------------|
| paving_projects.csv | 960 | Road paving projects |
| infrastructure_projects.csv | 23 | Major infrastructure projects |
| intersection_upgrades.csv | 25 | Intersection improvement projects |
| tip_projects.csv | 59 | Transportation Improvement Program projects |
| ditch_cuts.csv | 1,043 | Ditch cut permits/records |
| fiber_optic_routes.csv | 79 | Fiber optic route segments |
| parking_zones.csv | 94 | Parking zones |

### Community & Government
| File | Records | Description |
|------|---------|-------------|
| facilities.csv | 4,097 | Public facilities (parks, schools, shelters, etc.) |
| neighborhoods.csv | 169 | Neighborhood boundaries |
| council_districts.csv | 9 | City council districts |
| census_demographics.csv | 108 | Census tract demographics |
| polling_places.csv | 39 | Polling place locations |
| voting_precincts.csv | 39 | Voting precinct information |
| neighborhood_grants.csv | 926 | Neighborhood grant awards |
| visitor_trends.csv | 1,460 | Tourism/visitor trend data |

### Utilities & Environmental
| File | Records | Description |
|------|---------|-------------|
| sanitation_zones.csv | 60 | Sanitation/trash collection zones and schedules |
| gas_wells.csv | 12 | Gas well locations |
| mosquito_spray_zones.csv | 17 | Mosquito spray zone boundaries |
| opportunity_zones.csv | 12 | Federal opportunity zones |

## Data Quality Notes

- **311 requests:** ~26% lack location data (phone/FAQ calls without geocoding)
- **Business licenses:** ~48% lack geocoding
- **Code violations:** `complaintrem` field is only ~13% filled
- **Construction permits:** ~26% have placeholder $10 estimated cost (electrical/mechanical trade permits)
- **Fire rescue:** District field contains fire zone codes, not council districts
- **Parcels:** Mailing addresses included; some records have null assessed values
- **Geometry excluded:** All geometry/shape columns have been excluded from CSVs; lat/lon columns are preserved where available

## Column Notes

- `objectid`, `ingested_at`, and `geom` columns have been excluded from all database-sourced tables
- ArcGIS-sourced tables (fire_responses_full, parcels_property) exclude OBJECTID and geometry
- Date/time fields from ArcGIS are converted from epoch milliseconds to ISO format (UTC)
- All column headers are lowercase

## License

This data is derived from publicly available government open data published by the City of Montgomery, Alabama. Published under CC-BY-4.0.

## Citation

If you use this dataset, please cite:

```bibtex
@dataset{montgomery_civic_data_2026,
title={Montgomery, Alabama Civic Open Data},
author={MM Intelligence},
year={2026},
url={https://huggingface.co/datasets/mm-intelligence/montgomery-civic-data},
note={Sourced from City of Montgomery Open Data Portal}
}
```

---
许可证：CC BY 4.0
语言：英语
标签：
- 市政数据
- 阿拉巴马州蒙哥马利
- 开放数据
- 311服务（311）
- 政府
- 城市规划
- 公共安全
数据规模：10万 < 记录数 < 100万
---

# 阿拉巴马州蒙哥马利市——市政开放数据

本数据集集合源自阿拉巴马州蒙哥马利市开放数据门户，经过清洗与结构化处理。

## 数据集概览

本数据集集合共包含32张数据表，覆盖阿拉巴马州蒙哥马利市（总人口约20万）的市政服务、公共安全、商业许可、不动产、基础设施与社区资源等领域。

**总记录数：** 所有数据表合计约91.6万条
**时间范围：** 2014年至2026年（各数据表时间范围有所差异）
**数据来源：** [蒙哥马利市开放数据门户](https://opendata.montgomeryal.gov/)
**整理方：** [MM Intelligence](https://mmintelligence.ai) — 阿拉巴马州蒙哥马利市

## 数据集列表

### 核心市政数据
| 文件名称 | 记录条数 | 数据描述 |
|--------|----------|----------|
| service_requests_311.csv | 207,630 | 311服务（311）非紧急请求（2021年至今） |
| business_licenses.csv | 123,398 | 商业许可（按许可-年度单条记录，2014年至今） |
| code_violations.csv | 78,942 | 代码合规违规案件 |
| construction_permits.csv | 43,419 | 建筑/施工许可 |
| fire_rescue.csv | 55,727 | 含响应时长的消防/紧急医疗服务事件 |
| nuisance_cases.csv | 3,573 | 妨害行为整治案件 |
| environmental_nuisance.csv | 330 | 环境妨害投诉 |

### 公共安全
| 文件名称 | 记录条数 | 数据描述 |
|--------|----------|----------|
| fire_responses_full.csv | 264,731 | 完整消防响应历史，含财产损失、探测器信息、消防装备数据 |
| emergency_911_calls.csv | 454 | 911紧急呼叫（911）记录 |
| hydrants.csv | 11,468 | 消防栓位置与状态数据 |

### 不动产与住房
| 文件名称 | 记录条数 | 数据描述 |
|--------|----------|----------|
| parcels_property.csv | 111,122 | 不动产地块数据，含所有者、评估价值、土地用途 |
| housing_condition.csv | 5,561 | 住房状况评估数据 |
| surplus_properties.csv | 89 | 市政府闲置不动产 |

### 基础设施与交通
| 文件名称 | 记录条数 | 数据描述 |
|--------|----------|----------|
| paving_projects.csv | 960 | 道路铺装项目 |
| infrastructure_projects.csv | 23 | 重大基础设施项目 |
| intersection_upgrades.csv | 25 | 路口改造项目 |
| tip_projects.csv | 59 | 交通改善计划（Transportation Improvement Program, TIP）项目 |
| ditch_cuts.csv | 1,043 | 沟渠开挖许可/记录 |
| fiber_optic_routes.csv | 79 | 光纤路由段数据 |
| parking_zones.csv | 94 | 停车区域数据 |

### 社区与政府
| 文件名称 | 记录条数 | 数据描述 |
|--------|----------|----------|
| facilities.csv | 4,097 | 公共设施（公园、学校、庇护所等） |
| neighborhoods.csv | 169 | 社区边界数据 |
| council_districts.csv | 9 | 市议会选区数据 |
| census_demographics.csv | 108 | 人口普查街区人口统计数据 |
| polling_places.csv | 39 | 投票站位置数据 |
| voting_precincts.csv | 39 | 投票分区信息 |
| neighborhood_grants.csv | 926 | 社区拨款奖励数据 |
| visitor_trends.csv | 1,460 | 旅游/访客趋势数据 |

### 公用事业与环境
| 文件名称 | 记录条数 | 数据描述 |
|--------|----------|----------|
| sanitation_zones.csv | 60 | 环卫/垃圾收集区域与排班表 |
| gas_wells.csv | 12 | 气井位置数据 |
| mosquito_spray_zones.csv | 17 | 蚊虫喷洒区域边界 |
| opportunity_zones.csv | 12 | 联邦机会区域 |

## 数据质量说明
- **311服务请求：** 约26%的记录缺失位置数据（未进行地理编码的电话/常见问题咨询呼叫）
- **商业许可：** 约48%的记录缺失地理编码信息
- **合规违规案件：** `complaintrem`字段仅约13%被填充
- **施工许可：** 约26%的记录使用占位符预估成本10美元（针对电气/机械行业许可）
- **消防救援数据：** `District`字段包含消防区域代码，而非市议会选区代码
- **不动产地块数据：** 包含邮寄地址；部分记录的评估价值为空
- **几何信息排除：** 所有CSV文件中已移除几何/形状列；保留可用的经纬度列

## 列说明
- `objectid`、`ingested_at`与`geom`列已从所有数据库来源的数据表中移除
- 来自ArcGIS的数据表（fire_responses_full、parcels_property）已移除OBJECTID与几何信息列
- ArcGIS来源的日期/时间字段已从纪元毫秒格式转换为UTC时区的ISO格式
- 所有列标题均为小写格式

## 许可协议
本数据集源自阿拉巴马州蒙哥马利市公开发布的政府开放数据，采用CC BY 4.0（知识共享署名4.0）协议发布。

## 引用方式
若您使用本数据集，请按以下方式引用：
bibtex
@dataset{montgomery_civic_data_2026,
title={Montgomery, Alabama Civic Open Data},
author={MM Intelligence},
year={2026},
url={https://huggingface.co/datasets/mm-intelligence/montgomery-civic-data},
note={Sourced from City of Montgomery Open Data Portal}
}