← 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.: 60642; 3226; 93749
- attrs->>'AppCode' | string | 5000/11 | values: C2R; C3F; C2; C3P; C3N; GP; C3R; SP; C1; VF; VP
- attrs->>'AppId' | number | 5000/4707 | e.g.: 61704; 57532; 56779
- attrs->>'AppNo' | string | 5000/4707 | e.g.: 2019-1509; 2018-0372; 2017-2209
- attrs->>'AppStatus' | string | 5000/3 | values: Action Form Completed; Being Reviewed; Awaiting Completeness
- attrs->>'AppSubmitDate' | number | 5000/935 | e.g.: 1533513600000; 1615161600000; 1539561600000
- attrs->>'DocName' | string | 5000/4643 | e.g.: REGISTRY.DWG; REGISTRY_FILE.DWG; Registry_Jasmine Heights Sec 9 registry revised  2018-02-19_
- attrs->>'ImportDate' | number | 5000/220 | e.g.: 1744394453000; 1786356066000; 1776686466000
- attrs->>'LotCount' | number | 5000/195 | e.g.: 0; 2; 3
- attrs->>'PCDate' | number | 5000/339 | e.g.: 1694044800000; 1368057600000; 1534377600000
- attrs->>'RecordationRegistryUploaded' | number | 5000/2 | values: 0; 1
- attrs->>'RecordationStatus' | null | 316/7 | values: Collected; Recorded; Sent; Submitted; Incomplete; Returned; Complete & Accepted
- attrs->>'ReserveCount' | number | 5000/29 | e.g.: 1; 0; 2
- attrs->>'ReserveSize' | number | 5000/2692 | e.g.: 0; 0.0046; 0.0092
- attrs->>'ReviewCycle' | string | 5000/339 | e.g.: 2013-10; 2023-18; 2018-17
- attrs->>'SubdivisionName' | string | 5000/3784 | e.g.: Jasmine Heights ; Sunterra; Elyson
- attrs->>'SubdivisionSectionNo' | string | 5000/79 | e.g.: 0; 1; 2
- attrs->>'UploadDate' | number | 5000/4707 | e.g.: 1566828178000; 1519120196000; 1539621771000
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.