← All datasets

# curated.dev_plat_application
Plat applications by type (37,095 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.: 104043; 462679; 113118
- attrs->>'AppCode' | string | 5000/11 | values: C2R; C3F; C2; C3P; C3N; GP; C3R; SP; C1; VF; VP
- attrs->>'AppId' | number | 5000/4697 | e.g.: 58168; 61704; 55343
- attrs->>'AppNo' | string | 5000/4697 | e.g.: 2018-0842; 2019-1509; 2018-0372
- attrs->>'AppStatus' | string | 5000/5 | values: Action Form Completed; Being Reviewed; Awaiting Completeness; Awaiting Assignment; Check-In Complete
- attrs->>'AppSubmitDate' | number | 5000/1001 | e.g.: 1533513600000; 1398038400000; 1522627200000
- attrs->>'DocName' | string | 5000/4658 | e.g.: REGISTRY.DWG; Registry Revised_v1_58168.dwg; Registry_registry 2019-08-26_61704.dwg
- attrs->>'ImportDate' | number | 5000/255 | e.g.: 1744394453000; 1771840887000; 1753696862000
- attrs->>'LotCount' | number | 5000/197 | e.g.: 0; 2; 3
- attrs->>'PCDate' | number | 5000/340 | e.g.: 1534377600000; 1400112000000; 1472688000000
- attrs->>'RecordationRegistryUploaded' | number | 5000/2 | values: 0; 1
- attrs->>'RecordationStatus' | null | 351/7 | values: Collected; Recorded; Sent; Returned; Submitted; Incomplete; Complete & Accepted
- attrs->>'ReserveCount' | number | 5000/29 | e.g.: 1; 0; 2
- attrs->>'ReserveSize' | number | 5000/2685 | e.g.: 0; 0.0046; 1
- attrs->>'ReviewCycle' | string | 5000/340 | e.g.: 2018-17; 2014-10; 2016-18
- attrs->>'SubdivisionName' | string | 5000/3772 | e.g.: Jasmine Heights ; Champions Oak; Elyson
- attrs->>'SubdivisionSectionNo' | string | 5000/84 | e.g.: 0; 1; 2
- attrs->>'UploadDate' | number | 5000/4697 | e.g.: 1525251775000; 1566828178000; 1519120196000
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.