superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
122 rows where MNG_AGENCY = 56 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: ACRES, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12398 | 12398 | 12397 | {"type": "Polygon", "coordinates": [[[-122.33381, 37.80525], [-122.33311, 37.80588], [-122.33301, 37.80592], [-122.33294, 37.80586], [-122.3326, 37.80603], [-122.33238, 37.80574], [-122.33271, 37.80549], [-122.33265, 37.80541], [-122.33289, 37.80523], [-122.33297, 37.80522], [-122.33381, 37.80525]]]} | Open Access 1 | Port View Park | 32419 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.431 | Port View Park | ||
12407 | 12407 | 12406 | {"type": "Polygon", "coordinates": [[[-122.30253, 37.80789], [-122.30246, 37.8081], [-122.3024, 37.80817], [-122.30212, 37.80803], [-122.30219, 37.80782], [-122.30253, 37.80789]]]} | Open Access 1 | Bertha Port Park | 32420 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.218 | Bertha Port Park | ||
9815 | 9815 | 9814 | {"type": "Polygon", "coordinates": [[[-122.30053, 37.80331], [-122.30039, 37.80354], [-122.29548, 37.80242], [-122.29654, 37.80233], [-122.29877, 37.80267], [-122.30053, 37.80331]]]} | Open Access 1 | South Prescott Park | 25676 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 4.268 | South Prescott Park | ||
3315 | 3315 | 3314 | {"type": "Polygon", "coordinates": [[[-122.29722, 37.80377], [-122.29719, 37.80383], [-122.29678, 37.80373], [-122.2968, 37.80366], [-122.29722, 37.80377]]]} | Open Access 1 | Cresent Park | 17799 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.074 | Cresent Park | ||
11285 | 11285 | 11284 | {"type": "Polygon", "coordinates": [[[-122.29695, 37.81202], [-122.29654, 37.81255], [-122.29589, 37.81221], [-122.29631, 37.8117], [-122.29695, 37.81202]]]} | Open Access 1 | Willow Mini Park | 27580 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.135 | Willow MP | ||
8466 | 8466 | 8465 | {"type": "Polygon", "coordinates": [[[-122.29549, 37.81605], [-122.29454, 37.81724], [-122.29214, 37.81603], [-122.29309, 37.81485], [-122.29549, 37.81605]]]} | Open Access 1 | Raimondi Park | 24081 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 9.659 | Raimondi Park | ||
3389 | 3389 | 3388 | {"type": "Polygon", "coordinates": [[[-122.29309, 37.81022], [-122.29302, 37.81041], [-122.29246, 37.81029], [-122.29225, 37.81086], [-122.29189, 37.81078], [-122.29186, 37.81081], [-122.29176, 37.81079], [-122.29189, 37.81039], [-122.29198, 37.80998], [-122.29309, 37.81022]]]} | Open Access 1 | Cypress Freeway Memorial Park | 17873 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.281 | Cypress Freeway Memorial Park | ||
10977 | 10977 | 10976 | {"type": "Polygon", "coordinates": [[[-122.29076, 37.80888], [-122.29052, 37.80959], [-122.28941, 37.8093], [-122.28911, 37.80883], [-122.28908, 37.8086], [-122.28911, 37.80855], [-122.29076, 37.80888]]]} | Open Access 1 | Wade Johnson Park | 27206 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 2.538 | Wade Johnson Park | ||
3521 | 3521 | 3520 | {"type": "Polygon", "coordinates": [[[-122.28859, 37.81185], [-122.28813, 37.81311], [-122.28611, 37.81266], [-122.28528, 37.8123], [-122.28569, 37.81119], [-122.28859, 37.81185]]]} | Open Access 1 | DeFremery Park | 18017 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 9.427 | DeFremery Park | 1910 | |
6437 | 6437 | 6436 | {"type": "Polygon", "coordinates": [[[-122.28586, 37.80805], [-122.28546, 37.8093], [-122.28276, 37.80878], [-122.28328, 37.80749], [-122.28586, 37.80805]]]} | Open Access 1 | Lowell Park | 21557 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 8.709 | Lowell Park | ||
8307 | 8307 | 8306 | {"type": "Polygon", "coordinates": [[[-122.28464, 37.82278], [-122.28462, 37.82284], [-122.2835, 37.82424], [-122.2833, 37.82419], [-122.28387, 37.82261], [-122.28464, 37.82278]]]} | Open Access 1 | Poplar Park | 23893 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 2.036 | Poplar Park | ||
4624 | 4624 | 4623 | {"type": "Polygon", "coordinates": [[[-122.28429, 37.8453], [-122.28401, 37.84534], [-122.28346, 37.84522], [-122.28281, 37.8452], [-122.28279, 37.84516], [-122.28227, 37.84523], [-122.28208, 37.84463], [-122.284, 37.8444], [-122.28429, 37.8453]]]} | Open Access 1 | Golden Gate Recreation Center | 19360 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 3.496 | Golden Gate Rec. Ctr. | ||
10558 | 10558 | 10557 | {"type": "Polygon", "coordinates": [[[-122.28292, 37.82599], [-122.2825, 37.82589], [-122.28278, 37.82555], [-122.28278, 37.82555], [-122.28292, 37.82599]]]} | Open Access 1 | Union Plaza | 26658 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.211 | Union Plaza | ||
4251 | 4251 | 4250 | {"type": "Polygon", "coordinates": [[[-122.28288, 37.82617], [-122.28288, 37.82617], [-122.28212, 37.82633], [-122.28239, 37.82603], [-122.28288, 37.82617]]]} | Open Access 1 | Fitzgerald Park | 18930 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.225 | Fitzgerald Park | ||
6810 | 6810 | 6809 | {"type": "Polygon", "coordinates": [[[-122.28067, 37.81793], [-122.28059, 37.81813], [-122.28026, 37.81805], [-122.28033, 37.81785], [-122.28067, 37.81793]]]} | Open Access 1 | McClymonds Mini Park | 22003 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.175 | McClymonds MP | ||
6716 | 6716 | 6715 | {"type": "Polygon", "coordinates": [[[-122.28016, 37.80965], [-122.2799, 37.81031], [-122.27832, 37.80965], [-122.2787, 37.80906], [-122.28016, 37.80965]]]} | Open Access 1 | Marston Campbell Park | 21899 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 2.771 | Marston Campbell Park | ||
5509 | 5509 | 5508 | {"type": "Polygon", "coordinates": [[[-122.27921, 37.80074], [-122.2789, 37.80123], [-122.27797, 37.80087], [-122.27828, 37.80037], [-122.27921, 37.80074]]]} | Open Access 1 | Jefferson Square | 20383 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.376 | Jefferson Square | ||
9564 | 9564 | 9563 | {"type": "Polygon", "coordinates": [[[-122.27768, 37.82309], [-122.27768, 37.82309], [-122.27758, 37.82337], [-122.27747, 37.82304], [-122.27768, 37.82309]]]} | Open Access 1 | St Andrews Plaza | 25761 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.078 | St Andrews Plaza | ||
5869 | 5869 | 5868 | {"type": "Polygon", "coordinates": [[[-122.27749, 37.80349], [-122.27719, 37.80399], [-122.27626, 37.80362], [-122.27656, 37.80312], [-122.27749, 37.80349]]]} | Open Access 1 | Lafayette Square | 20833 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.388 | Lafayette Square | ||
6218 | 6218 | 6217 | {"type": "Polygon", "coordinates": [[[-122.27638, 37.8329], [-122.27622, 37.83345], [-122.2759, 37.83342], [-122.27602, 37.83283], [-122.27638, 37.8329]]]} | Open Access 1 | Linden Park | 21291 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.493 | Linden 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]);