Fields inventoried
Schema evidence
Field inventory across CKAN and ArcGIS.
This view turns public CKAN datastore metadata and selected ArcGIS layer metadata into a field-level handoff inventory. It records field names, labels, types, source links, endpoint links, and sample-record coverage counts without inventing definitions.
Datasets/layers covered
CKAN datastore fields
ArcGIS layer fields
Field inventory export
The generated CSV keeps schema metadata, sample-record coverage counts, and source URLs together for implementation planning and City owner review.
Download field inventory CSVHandoff stance
- Use source metadata first; do not write guessed field definitions.
- Flag display-label cleanup separately from source-system facts.
- Preserve direct CKAN and ArcGIS metadata links for every field group.
- Use sample coverage counts to prioritize validation with source owners.
Top field types
| Type | Fields |
|---|---|
| text | 122 |
| esriFieldTypeString | 121 |
| esriFieldTypeInteger | 42 |
| esriFieldTypeDate | 32 |
| esriFieldTypeDouble | 12 |
| esriFieldTypeOID | 12 |
| numeric | 9 |
| esriFieldTypeSmallInteger | 6 |
Top schema owners
| Owner | Fields |
|---|---|
| Enterprise GIS | 311 |
| Planning Building and Code Enforcement | 17 |
| Fire | 15 |
| Police | 15 |
| Information Technology | 10 |
Representative field inventory
The full export covers all fields returned in the current selected source pull. The table below shows representative high-value launch datasets and layers.
| Dataset/layer | Field | Type | Coverage |
|---|---|---|---|
| 311 Service Request Data | Incident_ID | text | 5 of 5 |
| 311 Service Request Data | Status | text | 5 of 5 |
| 311 Service Request Data | Source | text | 5 of 5 |
| 311 Service Request Data | Category | text | 5 of 5 |
| 311 Service Request Data | Service Type | text | 5 of 5 |
| 311 Service Request Data | Latitude | text | 5 of 5 |
| 311 Service Request Data | Longitude | text | 5 of 5 |
| 311 Service Request Data | Date Created | text | 5 of 5 |
| 311 Service Request Data | Date Last Updated | text | 5 of 5 |
| 311 Service Request Data | Department | text | 5 of 5 |
| Affordable Rental Housing | X | text | 5 of 5 |
| Affordable Rental Housing | Y | text | 5 of 5 |
| Affordable Rental Housing | OBJECTID | text | 5 of 5 |
| Affordable Rental Housing | FACILITYID | text | 5 of 5 |
| Average Daily Traffic | OBJECTID | esriFieldTypeOID | 5 of 5 |
| Average Daily Traffic | FACILITYID | esriFieldTypeString | 5 of 5 |
| Average Daily Traffic | INTID | esriFieldTypeInteger | 5 of 5 |
| Average Daily Traffic | LATITUDE | esriFieldTypeDouble | 5 of 5 |
| Average Daily Traffic | LONGITUDE | esriFieldTypeDouble | 5 of 5 |
| Average Daily Traffic | COUNTDATE | esriFieldTypeDate | 5 of 5 |
| Average Daily Traffic | ADT | esriFieldTypeInteger | 5 of 5 |
| Average Daily Traffic | STREETONE | esriFieldTypeString | 5 of 5 |
| Average Daily Traffic | DIRECTION | esriFieldTypeString | 5 of 5 |
| Average Daily Traffic | STREETTWO | esriFieldTypeString | 5 of 5 |