Archive
Machine verified 5 years old
- Parcels
- 282,102
- Fields
- 42
- Completeness
- 83%
- Download size
- 237 MB
Take the file
Available formats
- gpkg GeoPackage One SQLite file, full-length field names, real CRS metadata, no sidecar files to lose.
- shp Shapefile The format every desktop GIS reads without being asked, and the one most county assessors still publish.
Public records, redistributed as received. No licence fee, no attribution required.
What the checks found
282,102 parcel features, 42 attributes, 83% weighted attribute fill. Reprojected to WGS 84 (EPSG:4326); geometries repaired where invalid. Attribute fill rates measured on a 200,000-feature sample. Point-in-time snapshot. No cross-county schema normalisation.
Columns in this file
| Field | Type | Filled | Example values |
|---|---|---|---|
| PARCEL_ID | OFTString | 5513011, 5513011, 3558082 | |
| SITUS | OFTString | 1513E-1513F YORK ST, 1513E-1513F YORK ST, 350E CHURCH ST | |
| ADDR_NUMBE | OFTString | 1513, 1513, 350 | |
| STREET_PRE | OFTString | E, E, E | |
| STREET_NAM | OFTString | 1513F YORK, 1513F YORK, CHURCH | |
| STREET_SUF | OFTString | E, E, E | |
| STREET_TYP | OFTString | St, St, St | |
| SITUS_CITY | OFTString | SAN FRANCISCO, SAN FRANCISCO, SAN FRANCISCO | |
| SITUS_ZIP | OFTString | 94114, 94114, 94115 | |
| ADDR_SEC_U | OFTString | LOWER, STE, STE | |
| ADDR_SE_01 | OFTString | 101, 101, 101 | |
| OWNER | OFTString | PATRICK MICHAEL QUINLAN FMLY REVOC TR, QUINLAN PATRICK M FAMILY REVOC, WILLIAM C CHILES LVG TR | |
| TRANS_DATE | OFTDate | 1990-12-13, 2000-03-21, 2009-04-21 | |
| SALE_PRICE | OFTReal | 0.0, 0.0, 260500.0 | |
| BLDG_SQFT | OFTInteger64 | 0, 0, 1150 | |
| LAND_USE_C | OFTString | Vacant Lot Residential, Vacant Lot Residential, Condominium | |
| LAND_US_01 | OFTString | Residential, Residential, Residential | |
| LAND_COVER | OFTString | {"22": 1, "23": 1}, {"22": 1, "23": 1}, {"24": 4} | |
| MKT_VAL_LA | OFTReal | 183333.0, 183333.0, 226360.0 | |
| MKT_VAL_BL | OFTReal | 0.0, 0.0, 194828.0 | |
| ZIP_CODE | OFTString | 94110, 94110, 94114 | |
| BUILDINGS | OFTInteger64 | 0, 0, 0 | |
| TOTAL_BATH | OFTReal | 0.0, 0.0, 2.0 | |
| BEDROOMS | OFTInteger64 | 0, 0, 2 | |
| TOTAL_ROOM | OFTInteger64 | 0, 0, 5 | |
| YEAR_BUILT | OFTInteger64 | 0, 0, 1981 | |
| MAIL_ADDRE | OFTString | SAN FRANCISCO CA 94112, OAKLAND CA 94611, SAN FRANCISCO CA 94114 | |
| MAIL_AD_01 | OFTString | 225 SADOWA ST, 301 OAKLAND AVE, 350 CHURCH ST APT E | |
| OWNER_OCCU | OFTString | F, F, F | |
| USPS_RESID | OFTString | ?, ?, ? | |
| CENSUS_TRA | OFTInteger64 | 25100, 25100, 20300 | |
| CENSUS_BLK | OFTInteger | 1, 1, 3 | |
| CENSUS_BLO | OFTInteger | 1006, 1006, 3002 | |
| AREA_METER | OFTReal | 623.702747011486, 623.702747011486, 1733.43433654613 | |
| PLACE_GNIS | OFTInteger64 | 2411786, 2411786, 2411786 | |
| ELEVATION | OFTString | {"max": 0.0, "min": 0.0, "mean": 0.0}, {"max": 0.0, "min": 0.0, "mean": 0.0}, {"max": 0.0, "min": 0.0, "mean": 0.0} | |
| ROBUST_ID | OFTString | AAAXu7l3NYFxGzry, AAAXu8B5VYK7T8cK, AAAXu-PKANXK2Y-l | |
| CALC_ACREA | OFTReal | 0.154123185814008, 0.154123185814008, 0.428348958903914 | |
| COUNTY_NAM | OFTString | San Francisco, San Francisco, San Francisco | |
| COUNTY_FIP | OFTInteger64 | 6075, 6075, 6075 | |
| STATE_ABBR | OFTString | CA, CA, CA | |
| CTY_ROW_ID | OFTInteger64 | 145067, 145066, 158946 |