superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where MNG_AGENCY = 95
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6140 | 6140 | 6139 | {"type": "Polygon", "coordinates": [[[-119.24595, 34.44555], [-119.24595, 34.44579], [-119.24588, 34.44576], [-119.24587, 34.44578], [-119.24584, 34.44702], [-119.24548, 34.447], [-119.24555, 34.4477], [-119.24476, 34.44776], [-119.24471, 34.44736], [-119.24461, 34.44736], [-119.2446, 34.44737], [-119.24464, 34.44777], [-119.24451, 34.44778], [-119.24444, 34.44729], [-119.24429, 34.4473], [-119.24428, 34.4474], [-119.24354, 34.44739], [-119.24415, 34.44738], [-119.24411, 34.44707], [-119.24406, 34.44702], [-119.244, 34.44685], [-119.24426, 34.44685], [-119.24428, 34.44666], [-119.24456, 34.44663], [-119.24447, 34.44614], [-119.24434, 34.44606], [-119.24428, 34.44573], [-119.24451, 34.44561], [-119.24469, 34.44559], [-119.2447, 34.44555], [-119.24471, 34.44531], [-119.2445, 34.44522], [-119.24416, 34.44514], [-119.24358, 34.4451], [-119.2436, 34.44402], [-119.24525, 34.44348], [-119.24593, 34.44235], [-119.2459, 34.44426], [-119.24536, 34.44426], [-119.24535, 34.44427], [-119.24547, 34.44483], [-119.24542, 34.44484], [-119.24542, 34.4449], [-119.24588, 34.44516], [-119.24587, 34.44551], [-119.24595, 34.44555]]]} | Open Access 1 | Libbey Park | https://www.ojairec.com/parks-and-facilities/city-parks/libbey-park/ | 21201 | 1231 | Ojai, City of 95 | City 2 | City Agency 2 | http://www.ojairec.com/ | City 2 | 17.406 | Libbey Park | |
9371 | 9371 | 9370 | {"type": "Polygon", "coordinates": [[[-119.23698, 34.4506], [-119.23695, 34.45232], [-119.23694, 34.45239], [-119.23691, 34.45246], [-119.23683, 34.45254], [-119.23606, 34.45308], [-119.23529, 34.45315], [-119.23533, 34.45069], [-119.23698, 34.4506]]]} | Open Access 1 | Sarzotti Park | 25162 | 1231 | Ojai, City of 95 | City 2 | City Agency 2 | http://www.ojairec.com/ | City 2 | 9.472 | Sarzotti Park | ||
13351 | 13351 | 13350 | {"type": "Polygon", "coordinates": [[[-119.25049, 34.44744], [-119.25048, 34.44744], [-119.2496, 34.4475], [-119.25043, 34.44685], [-119.25049, 34.44744]]]} | Open Access 1 | Cluff Vista Park | 30703 | 1231 | Ojai, City of 95 | City 2 | City Agency 2 | http://www.ojairec.com/ | City 2 | 0.656 | Cluff Vista Park | ||
13352 | 13352 | 13351 | {"type": "Polygon", "coordinates": [[[-119.26105, 34.44077], [-119.26101, 34.44093], [-119.26086, 34.44126], [-119.26068, 34.44144], [-119.26051, 34.44155], [-119.26032, 34.44164], [-119.25961, 34.44198], [-119.25924, 34.44214], [-119.259, 34.44173], [-119.25965, 34.44153], [-119.26032, 34.44125], [-119.26055, 34.44112], [-119.26105, 34.44077]]]} | Open Access 1 | Rotary Community Park | 30704 | 1231 | Ojai, City of 95 | City 2 | City Agency 2 | http://www.ojairec.com/ | City 2 | 1.948 | Rotary Community Park | ||
13353 | 13353 | 13352 | {"type": "Polygon", "coordinates": [[[-119.26155, 34.44189], [-119.26153, 34.44196], [-119.26055, 34.44183], [-119.26057, 34.44177], [-119.26061, 34.44174], [-119.26085, 34.4416], [-119.26093, 34.44159], [-119.26125, 34.44176], [-119.26155, 34.44189]]]} | Open Access 1 | Weinberger Memorial Garden | 30705 | 1231 | Ojai, City of 95 | City 2 | City Agency 2 | http://www.ojairec.com/ | City 2 | 0.438 | Weinberger Memorial Garden | ||
13355 | 13355 | 13354 | {"type": "Polygon", "coordinates": [[[-119.24147, 34.44813], [-119.24145, 34.44942], [-119.24039, 34.44949], [-119.24062, 34.44906], [-119.2405, 34.44882], [-119.24081, 34.44818], [-119.24147, 34.44813]]]} | Open Access 1 | Ojai Skate Park | 30707 | 1231 | Ojai, City of 95 | City 2 | City Agency 2 | http://www.ojairec.com/ | City 2 | 2.795 | Ojai Skate Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);