units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, ACRES = "114.637", DES_TP = 3 and MNG_AGENCY = 496
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Conejo Open Space Conservation Agency · 1 ✖
DES_TP 1
- Local Recreation Area · 1 ✖
ACCESS_TYP 1
- Open Access · 1 ✖
| Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16101 | 16101 | 16100 | {"type": "Polygon", "coordinates": [[[-118.94687, 34.15506], [-118.94682, 34.15542], [-118.94662, 34.15586], [-118.94604, 34.15584], [-118.94573, 34.15595], [-118.94544, 34.15615], [-118.94502, 34.15634], [-118.9447, 34.15659], [-118.94436, 34.15649], [-118.94356, 34.15678], [-118.94323, 34.15687], [-118.94292, 34.15702], [-118.9425, 34.15734], [-118.94191, 34.15751], [-118.94187, 34.15828], [-118.94208, 34.15826], [-118.94212, 34.15865], [-118.94229, 34.15885], [-118.94205, 34.15907], [-118.94164, 34.15889], [-118.94083, 34.15897], [-118.94089, 34.15946], [-118.94077, 34.1597], [-118.94047, 34.15988], [-118.94012, 34.16038], [-118.94024, 34.1608], [-118.94007, 34.16075], [-118.93977, 34.16101], [-118.93964, 34.1612], [-118.93964, 34.16131], [-118.93909, 34.16173], [-118.9389, 34.16196], [-118.93867, 34.16216], [-118.93828, 34.16228], [-118.93741, 34.16294], [-118.93619, 34.16269], [-118.93566, 34.16288], [-118.93529, 34.16303], [-118.93521, 34.16336], [-118.93569, 34.16383], [-118.93606, 34.16387], [-118.93689, 34.16357], [-118.93685, 34.1639], [-118.93717, 34.16433], [-118.93661, 34.16448], [-118.93653, 34.16462], [-118.93598, 34.16481], [-118.93575, 34.16502], [-118.93556, 34.16525], [-118.93542, 34.16529], [-118.93485, 34.16499], [-118.93444, 34.16497], [-118.93399, 34.16528], [-118.93452, 34.16577], [-118.93472, 34.16581], [-118.93527, 34.16606], [-118.93476, 34.16656], [-118.93512, 34.16696], [-118.9355, 34.16694], [-118.93595, 34.16668], [-118.93613, 34.16687], [-118.93626, 34.16697], [-118.93603, 34.16739], [-118.93558, 34.16758], [-118.93528, 34.1678], [-118.93513, 34.16802], [-118.93312, 34.16705], [-118.93114, 34.16577], [-118.93115, 34.16216], [-118.93867, 34.16216], [-118.93869, 34.15602], [-118.94003, 34.1559], [-118.94245, 34.15513], [-118.94275, 34.15505], [-118.94615, 34.15448], [-118.94627, 34.15486], [-118.94652, 34.15506], [-118.94687, 34.15506]], [[-118.94146, 34.15612], [-118.94052, 34.15629], [-118.94027, 34.15639], [-118.94024, 34.15691], [-118.94087, 34.15704], [-118.94137, 34.15697], [-118.94136, 34.15688], [-118.94158, 34.15683], [-118.9418, 34.15673], [-118.94146, 34.15612]]]} | Open Access 1 | 13102 | Deer Ridge Open Space | 33719 | 2024 | Conejo Open Space Conservation Agency 504 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/deer-ridge.html | Ventura 8 | 114.637 | Deer Ridge OS | 0 | Local Recreation Area 3 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps(
id INT,
map,
ACCESS_TYP INT,
UNIT_ID INT,
UNIT_NAME TEXT,
SUID_NMA INT,
AGNCY_ID INT,
AGNCY_NAME INT,
AGNCY_LEV INT,
AGNCY_TYP INT,
AGNCY_WEB TEXT,
LAYER INT,
MNG_AG_ID INT,
MNG_AGENCY INT,
MNG_AG_LEV INT,
MNG_AG_TYP INT,
PARK_URL TEXT,
COUNTY INT,
ACRES REAL,
LABEL_NAME TEXT,
YR_EST INT,
DES_TP INT,
GAP_STS TEXT,
FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]),
FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]),
FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]),
FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]),
FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]),
FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
ON [units_with_maps] ([ACCESS_TYP]);