Archive
Machine verified 3 years old
- Parcels
- 134,983
- Fields
- 135
- Completeness
- 83%
- Download size
- 141 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
134,983 parcel features, 135 attributes, 83% weighted attribute fill. Reprojected to WGS 84 (EPSG:4326); geometries repaired where invalid. Point-in-time snapshot. No cross-county schema normalisation.
Columns in this file
| Field | Type | Filled | Example values |
|---|---|---|---|
| objectid | OFTInteger | 3242174, 3243324, 3243325 | |
| lowerasrpa | OFTString | 32149340, 32179105, 32219020 | |
| colparceli | OFTString | 32140003400, 32170001050, 32210000200 | |
| colcityblo | OFTInteger | 321400, 321700, 322100 | |
| colparcel | OFTInteger | 3400, 1050, 200 | |
| primaddrre | OFTInteger | 1, 1, 1 | |
| addrtype | OFTString | 3, 3, 3 | |
| lowaddrnum | OFTInteger | 555, 8201, 616 | |
| lowaddrsuf | OFTString | R, R, R | |
| highaddrnu | OFTInteger | 555, 8219, 616 | |
| highaddrsu | OFTString | R, R, R | |
| nlc | OFTReal | 709.0, 480.0, 1419.0 | |
| parity | OFTString | O, O, E | |
| stpredir | OFTString | S, S, E | |
| stname | OFTString | HURCK, ALABAMA, MARCEAU | |
| sttype | OFTString | ST, AV, ST | |
| stsufdir | OFTString | W, W, W | |
| stdunitnum | OFTString | 110, 1, 2 | |
| ownername | OFTString | CITY OF ST LOUIS, ICL SPECIALTY PRODUCTS INC, METROPOLITAN ST LOUIS SEWER DSITRICT | |
| ownername2 | OFTString | MICHAEL ROSENBLOOM, C/O DAVID M SCHWEN, TAX ACCOUNTING-4TH FLOOR | |
| owneraddr | OFTString | 1200 MARKET ST RM 311, 622 EMERSON RD SUITE 500, 2000 HAMPTON AVE | |
| ownercity | OFTString | ST LOUIS, ST LOUIS, ST LOUIS | |
| ownerstate | OFTString | MO, MO, MO | |
| ownercount | OFTString | USA, USA, USA | |
| ownerzip | OFTString | 63103, 63141, 63139 | |
| ownerrank | OFTString | P, OOM, ID M | |
| legaldesc1 | OFTString | C. B. 3214 HURCK, CB 3217 ALABAMA AVE, C.B. 3221 MARCEAU | |
| legaldesc2 | OFTString | 24 FT 6 IN X 130 FT 8 IN, 0.400 ACS, 32 FT / 36 FT 8 IN X 195 FT 1 1/2 IN | |
| legaldesc3 | OFTString | IVORY ADDN, J C IVORYS ADDN, /214 FT 01/2 IN | |
| legaldesc4 | OFTString | LOT 46, LOTS 112 THRU 128 & PT VAC STREETS, KENRICKS ADDN | |
| legaldesc5 | OFTString | LOT E-4, LOT 5, BD E-35 FT W OF PENNSYLVANIA AVE | |
| asrclassco | OFTInteger | 4, 200, 2 | |
| asrlanduse | OFTInteger | 1010, 3000, 1010 | |
| asrlandu_1 | OFTInteger | 0, 0, 0 | |
| redevphase | OFTInteger | 0, 0, 0 | |
| redevyeare | OFTInteger | 0, 0, 0 | |
| redevpha_1 | OFTInteger | 0, 0, 0 | |
| redevyea_1 | OFTInteger | 0, 0, 0 | |
| vacantlot | OFTInteger | 1, 1, 1 | |
| specbusdis | OFTInteger | 0, 0, 0 | |
| specbusd_1 | OFTInteger | 0, 0, 0 | |
| tifdist | OFTInteger | 0, 0, 0 | |
| lendingagc | OFTInteger | 0, 0, 0 | |
| condominiu | OFTInteger | 0, 0, 0 | |
| nbrofunits | OFTInteger | 0, 0, 0 | |
| nbrofapts | OFTInteger | 0, 0, 0 | |
| frontage | OFTReal | 19.0, 0.0, 34.330002 | |
| landarea | OFTInteger | 0, 17424, 0 | |
| recdailyda | OFTString | 1995-05-09, 2018-03-20, 1994-10-11 | |
| recdailynu | OFTInteger | 84, 201, 112 | |
| recbooknum | OFTString | 1132, 1096, 1132 | |
| recpagenum | OFTInteger | 1098, 0, 214 | |
| asdland | OFTReal | 550.0, 8400.0, 930.0 | |
| asdimprove | OFTReal | 0.0, 0.0, 0.0 | |
| asdtotal | OFTReal | 550.0, 8400.0, 930.0 | |
| billland | OFTReal | 0.0, 8400.0, 0.0 | |
| billimprov | OFTReal | 0.0, 0.0, 0.0 | |
| billtotal | OFTReal | 0.0, 8400.0, 0.0 | |
| aprland | OFTReal | 2900.0, 26100.0, 4900.0 | |
| costaprimp | OFTReal | 0.0, 0.0, 0.0 | |
| asmtappeal | OFTInteger | 0, 0, 0 | |
| asmtappe_1 | OFTInteger | 0, 0, 0 | |
| asmtappe_2 | OFTString | ||
| priorasdda | OFTString | 2015-10-04, 2015-10-04, 2015-10-04 | |
| priorasdla | OFTReal | 0.0, 0.0, 0.0 | |
| priorasdim | OFTReal | 0.0, 0.0, 0.0 | |
| priorasdto | OFTReal | 0.0, 0.0, 0.0 | |
| priortaxam | OFTReal | 0.0, 0.0, 0.0 | |
| cdalanduse | OFTInteger | 1010, 5811, 1010 | |
| cdalandu_1 | OFTInteger | 0, 0, 0 | |
| lrmsunitnu | OFTString | 110, 1, 2 | |
| zoning | OFTString | B, F, B | |
| nbrofbldgs | OFTInteger | 0, 0, 0 | |
| nbrofbld_1 | OFTInteger | 0, 0, 0 | |
| firstyearb | OFTInteger | 0, 0, 0 | |
| lastyearbu | OFTInteger | 0, 0, 0 | |
| ressalepri | OFTReal | 0.0, 0.0, 0.0 | |
| ressaledat | OFTString | 1999-08-26, 2004-03-11, 2016-03-29 | |
| vacbldgyea | OFTInteger | 1995, 0, 1995 | |
| geocityblo | OFTReal | 3214.0, 3217.0, 3221.0 | |
| ward10 | OFTInteger | 11, 11, 11 | |
| precinct10 | OFTInteger | 1, 1, 1 | |
| insparea10 | OFTInteger | 2, 2, 2 | |
| ward00 | OFTInteger | 11, 11, 11 | |
| precinct02 | OFTInteger | 1, 1, 1 | |
| precinct04 | OFTInteger | 1, 1, 1 | |
| nbrhd | OFTInteger | 2, 1, 2 | |
| cdadist | OFTInteger | 1, 1, 1 | |
| cdasubdist | OFTInteger | 48, 48, 48 | |
| policedist | OFTInteger | 1, 1, 1 | |
| censtract1 | OFTReal | 1015.0, 1015.0, 1015.0 | |
| censblock1 | OFTInteger | 4003, 2027, 4017 | |
| censblock0 | OFTReal | 1015.4004, 1015.5023, 1015.4006 | |
| ward90 | OFTInteger | 11, 11, 11 | |
| precinct90 | OFTInteger | 1, 11, 1 | |
| censblock9 | OFTReal | 1015.405, 1015.504, 1015.43 | |
| houseconsd | OFTInteger | 18, 18, 18 | |
| asrnbrhd | OFTInteger | 136, 108, 136 | |
| entzone | OFTInteger | 1, 1, 1 | |
| impactarea | OFTInteger | 2, 2, 2 | |
| ctdarea | OFTInteger | 0, 22, 0 | |
| leafarea | OFTInteger | 0, 0, 0 | |
| zip | OFTInteger | 63111, 63111, 63111 | |
| onfloodblo | OFTInteger | 0, 0, 0 | |
| specparcel | OFTString | X, C, X | |
| subparcelt | OFTString | Q, C, C | |
| nbrofsubac | OFTInteger | 0, 0, 0 | |
| nbrofcondo | OFTInteger | 0, 0, 0 | |
| lrmsparcel | OFTInteger | 1, 1, 1 | |
| acctprimar | OFTInteger | 1, 1, 1 | |
| handle | OFTString | 13214000340, 13217000105, 13221000020 | |
| ownerocc | OFTString | 1, X, 1 | |
| firstdate | OFTString | 2001-10-07, 2001-10-07, 2001-10-07 | |
| lastdate | OFTString | 2022-10-16, 2022-10-16, 2022-10-16 | |
| ownerupdat | OFTString | 1995-06-08, 2019-05-30, 1994-10-19 | |
| ownercode | OFTInteger | 0, 0, 0 | |
| siteaddr | OFTString | 555 HURCK ST, 8201 ALABAMA AV, 616 MARCEAU ST | |
| sqft | OFTInteger | 2454, 51316, 6609 | |
| parcelid | OFTString | 32149340000, 32179105000, 32219020000 | |
| ward | OFTInteger | 11, 11, 11 | |
| taxbalance | OFTReal | 0.0, 0.0, 0.0 | |
| propertycl | OFTInteger | 17, 12, 17 | |
| isabatedpr | OFTInteger | 0, 0, 0 | |
| abatements | OFTInteger | 0, 0, 0 | |
| abatemente | OFTInteger | 0, 0, 0 | |
| specbusd_2 | OFTInteger | 0, 0, 0 | |
| ward20 | OFTInteger | 1, 1, 1 | |
| precinct20 | OFTInteger | 12, 11, 12 | |
| insparea20 | OFTInteger | 0, 0, 0 | |
| censtract2 | OFTInteger | 1015, 1015, 1015 | |
| censblock2 | OFTInteger | 2059, 1026, 2061 | |
| maintzonew | OFTInteger | 11, 11, 11 | |
| transdevdi | OFTInteger | 0, 0, 0 | |
| starea() | OFTReal | 2454.293274, 51315.669556, 6609.153381 | |
| stlength() | OFTReal | 304.204492, 1150.184103, 480.382555 |