Data catalog / raw / arcgis_parcel
raw.arcgis_parcel
Parcels. 18,400 rows.
LayerRaw
Source systemArcGIS Enterprise
Data ownerData and Innovation Administrator
Data stewardKevin Tran
ClassificationInternal
RefreshWeekly
RetentionAll versions, 7 years
AccessRoles R1 to R5, row policy P-01
Lineage
SourceArcGIS Enterprise
Cleansedcleansed.arcgis_parcel
Curatedcurated.fact_permit
Curatedcurated.dim_parcel
Columns
| Column | Type | Classification |
|---|---|---|
parcel_id | text | |
site_address | text | Public |
zip | text | |
council_district | bigint | |
zoning | text | |
land_use | text | |
acres | double precision | |
lon | double precision | |
lat | double precision | |
modified_at | timestamp without time zone | |
_run_id | text | Load metadata |
_extracted_at | timestamp without time zone | Load metadata |
Quality rules
Rules run on the cleansed source tables upstream.
Sample rows
| parcel_id | site_address | zip | council_district | zoning | land_use | acres | lon | lat | modified_at | _run_id | _extracted_at |
|---|---|---|---|---|---|---|---|---|---|---|---|
| FBCAD-808156 | 6177 Industrial Blvd | 77479 | 4 | R-1 | Residential | 0.466 | -95.635605 | 29.584382 | 2024-02-29 10:52:00 | R-20261108-0200 | 2026-11-08 02:07:09 |
| FBCAD-440872 | 6364 Sweetwater Blvd | 77479 | 4 | R-2 | Residential | 0.082 | -95.690608 | 29.57149 | 2025-03-03 11:31:00 | R-20261108-0200 | 2026-11-08 02:07:09 |
| FBCAD-327307 | 19118 Lexington Blvd | 77479 | 4 | R-1 | Residential | 0.1 | -95.653114 | 29.595605 | 2024-06-29 07:56:00 | R-20261108-0200 | 2026-11-08 02:07:09 |
| FBCAD-996415 | 13013 New Territory Blvd | 77479 | 4 | R-1 | Residential | 1.029 | -95.651888 | 29.583061 | 2026-02-08 16:48:00 | R-20261108-0200 | 2026-11-08 02:07:09 |
| FBCAD-836148 | 10036 Kempner St | 77479 | 4 | PD | Residential | 0.392 | -95.684049 | 29.548097 | 2025-02-20 11:12:00 | R-20261108-0200 | 2026-11-08 02:07:09 |
Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.