← All datasets
# curated.dev_final_plat
Recorded final plats (new subdivisions) (26,008 rows; category: Permits & development; geometry column `geom` (MultiPolygon, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 5000/5000 | e.g.: 461113; 97449; 13655
- attrs->>'AppCode' | string | 5000/6 | values: C2R; C3F; C2; SP; C1; VF
- attrs->>'AppId' | number | 5000/4697 | e.g.: 56891; 63381; 57532
- attrs->>'AppNo' | string | 5000/4697 | e.g.: 2017-2209; 2020-0192; 2018-0372
- attrs->>'AppStatus' | string | 5000/1 | values: Action Form Completed
- attrs->>'AppSubmitDate' | number | 5000/1024 | e.g.: 1533513600000; 1513296000000; 1376265600000
- attrs->>'DocName' | string | 5000/4656 | e.g.: Registry_registry_56891.dwg; Registry_registry 2020-02-07_63381.dwg; Registry_Jasmine Heights Sec 9 registry revised 2018-02-19_
- attrs->>'ImportDate' | number | 5000/241 | e.g.: 1744394453000; 1762171257000; 1768212060000
- attrs->>'LotCount' | number | 5000/168 | e.g.: 0; 2; 3
- attrs->>'PCDate' | number | 5000/339 | e.g.: 1519862400000; 1534377600000; 1527120000000
- attrs->>'RecordationRegistryUploaded' | number | 5000/2 | values: 0; 1
- attrs->>'RecordationStatus' | null | 429/8 | values: Collected; Recorded; Sent; Submitted; Returned; Complete & Accepted; Incomplete; Planner Assigned
- attrs->>'ReserveCount' | number | 5000/32 | e.g.: 1; 0; 2
- attrs->>'ReserveSize' | number | 5000/2779 | e.g.: 0; 0.0046; 0.0092
- attrs->>'ReviewCycle' | string | 5000/339 | e.g.: 2018-05; 2013-17; 2018-17
- attrs->>'SubdivisionName' | string | 5000/4106 | e.g.: Jasmine Heights ; Breckenridge West; Commons Waterway
- attrs->>'SubdivisionSectionNo' | string | 5000/68 | e.g.: 0; 1; 2
- attrs->>'UploadDate' | number | 5000/4697 | e.g.: 1513580583000; 1581073336000; 1519120196000
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.