units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, ACRES = "120.359" and DES_TP = 3
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16139 | 16139 | 16138 | {"type": "MultiPolygon", "coordinates": [[[[-118.89835, 34.20446], [-118.89833, 34.20453], [-118.89776, 34.20512], [-118.89749, 34.2053], [-118.89732, 34.20537], [-118.89718, 34.20545], [-118.89681, 34.20576], [-118.89652, 34.20547], [-118.89625, 34.20542], [-118.89603, 34.20524], [-118.89502, 34.20459], [-118.89454, 34.20554], [-118.89349, 34.20525], [-118.89363, 34.20469], [-118.89395, 34.20452], [-118.89406, 34.20415], [-118.89446, 34.20403], [-118.89448, 34.20377], [-118.89468, 34.20368], [-118.8951, 34.20367], [-118.89528, 34.20382], [-118.89552, 34.20391], [-118.89576, 34.20398], [-118.89618, 34.20405], [-118.89645, 34.20436], [-118.89634, 34.20446], [-118.89626, 34.20458], [-118.89622, 34.2047], [-118.89621, 34.20485], [-118.89597, 34.20471], [-118.89575, 34.20488], [-118.89608, 34.2051], [-118.89634, 34.2051], [-118.89691, 34.20516], [-118.89699, 34.20463], [-118.89718, 34.20446], [-118.89756, 34.20407], [-118.89803, 34.20427], [-118.89835, 34.20446]]], [[[-118.91047, 34.20671], [-118.91046, 34.20768], [-118.90903, 34.20768], [-118.90902, 34.20757], [-118.90849, 34.20758], [-118.90832, 34.2078], [-118.90878, 34.20921], [-118.90904, 34.20952], [-118.90867, 34.20972], [-118.90845, 34.20949], [-118.90821, 34.20931], [-118.90789, 34.20942], [-118.90747, 34.20947], [-118.90709, 34.20945], [-118.90683, 34.20939], [-118.90628, 34.20945], [-118.90603, 34.20932], [-118.90574, 34.20912], [-118.9053, 34.20876], [-118.90495, 34.20843], [-118.90451, 34.20835], [-118.90408, 34.20879], [-118.90294, 34.20824], [-118.90305, 34.20803], [-118.903, 34.20768], [-118.90291, 34.20749], [-118.90229, 34.20684], [-118.9013, 34.20626], [-118.90109, 34.20612], [-118.90028, 34.20584], [-118.90001, 34.20584], [-118.89978, 34.20574], [-118.89968, 34.20556], [-118.89972, 34.20546], [-118.89968, 34.20533], [-118.8995, 34.20507], [-118.8999, 34.20488], [-118.8999, 34.20487], [-118.89951, 34.20446], [-118.89864, 34.20374], [-118.8979, 34.20341], [-118.89761, 34.2034], [-118.89722, 34.20322], [-118.8969, 34.20286], [-118.8963, 34.20281], [-118.89609, 34.20254], [-118.8954, 34.20232], [-118.89552, 34.20223], [-118.89553, 34.19981], [-118.89622, 34.20038], [-118.89662, 34.20025], [-118.89669, 34.20045], [-118.89674, 34.20071], [-118.89736, 34.20069], [-118.89979, 34.2025], [-118.90049, 34.20329], [-118.90352, 34.20464], [-118.90505, 34.20489], [-118.9094, 34.20583], [-118.90964, 34.20681], [-118.90998, 34.20712], [-118.91047, 34.20671]], [[-118.89742, 34.20263], [-118.89753, 34.20263], [-118.89761, 34.2026], [-118.8977, 34.2025], [-118.89773, 34.20243], [-118.89769, 34.20228], [-118.89757, 34.20219], [-118.89751, 34.20217], [-118.89739, 34.20217], [-118.8973, 34.2022], [-118.89714, 34.20218], [-118.89711, 34.20222], [-118.89719, 34.2023], [-118.89717, 34.20236], [-118.89717, 34.20243], [-118.8972, 34.20252], [-118.89722, 34.20255], [-118.89728, 34.2026], [-118.89737, 34.20262], [-118.89736, 34.20267], [-118.8974, 34.20267], [-118.89742, 34.20263]]]]} | Open Access 1 | 17499 | Lynnmere Open Space | 21610 | 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 | Ventura 8 | 120.359 | Lynnmere 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]);