superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
28 rows where MNG_AGENCY = 176 sorted by AGNCY_WEB
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12264 | 12264 | 12263 | {"type": "Polygon", "coordinates": [[[-122.30734, 37.78918], [-122.30729, 37.7897], [-122.30701, 37.78969], [-122.30686, 37.78973], [-122.30677, 37.78959], [-122.3068, 37.78922], [-122.30689, 37.78916], [-122.30734, 37.78918]]]} | Open Access 1 | City View Skate Park | 30700 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 0.667 | City View Skate Park | ||
12409 | 12409 | 12408 | {"type": "Polygon", "coordinates": [[[-122.25802, 37.77742], [-122.25789, 37.77761], [-122.25799, 37.77766], [-122.25794, 37.77772], [-122.25743, 37.7775], [-122.25725, 37.77772], [-122.25655, 37.77745], [-122.2565, 37.77752], [-122.25631, 37.77744], [-122.25628, 37.77748], [-122.25611, 37.7774], [-122.25611, 37.77736], [-122.256, 37.77732], [-122.25597, 37.77735], [-122.2559, 37.77733], [-122.25586, 37.77738], [-122.25581, 37.77737], [-122.25572, 37.77749], [-122.25567, 37.77747], [-122.25562, 37.77755], [-122.25525, 37.77749], [-122.25531, 37.77737], [-122.25509, 37.77727], [-122.25514, 37.77717], [-122.25549, 37.77714], [-122.25582, 37.77714], [-122.25603, 37.77718], [-122.25662, 37.77742], [-122.25688, 37.77748], [-122.25718, 37.77748], [-122.25773, 37.77739], [-122.25786, 37.77739], [-122.25802, 37.77742]]]} | Open Access 1 | Marina Cove Waterfront Park | http://www.waterfrontaction.org/map/park_marina_cove.htm | 32424 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1.363 | Marina Cove Waterfront Park | |
12429 | 12429 | 12428 | {"type": "Polygon", "coordinates": [[[-122.2144, 37.79289], [-122.21423, 37.79313], [-122.21396, 37.793], [-122.21414, 37.79277], [-122.2144, 37.79289]]]} | Open Access 1 | Nicol Park | http://www2.oaklandnet.com/Government/o/opr/s/Parks/index.htm | 32425 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 0.207 | Nicol Park | |
12452 | 12452 | 12451 | {"type": "Polygon", "coordinates": [[[-122.18778, 37.75889], [-122.18778, 37.75889], [-122.18736, 37.75915], [-122.18749, 37.75896], [-122.18764, 37.75879], [-122.18778, 37.75889]]]} | Open Access 1 | Dolphin Mini Park | http://www2.oaklandnet.com/Government/o/opr/s/Parks/index.htm | 32426 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 0.099 | Dolphin MP | |
13099 | 13099 | 13098 | {"type": "Polygon", "coordinates": [[[-122.26313, 37.77627], [-122.26312, 37.77674], [-122.26073, 37.77666], [-122.2608, 37.77581], [-122.262, 37.77586], [-122.262, 37.7762], [-122.26313, 37.77627]]]} | Open Access 1 | Littlejohn Park | 33376 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 3.859 | Littlejohn Park | ||
13350 | 13350 | 13349 | {"type": "Polygon", "coordinates": [[[-122.2971, 37.78993], [-122.29707, 37.79023], [-122.29505, 37.79057], [-122.29505, 37.78997], [-122.29568, 37.79], [-122.29571, 37.78985], [-122.2971, 37.78993]]]} | Open Access 1 | Main Street Dog Park | 30702 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 2.364 | Main Street Dog Park | ||
13359 | 13359 | 13358 | {"type": "Polygon", "coordinates": [[[-122.29245, 37.77738], [-122.29241, 37.77968], [-122.292, 37.77973], [-122.29175, 37.77979], [-122.29165, 37.77978], [-122.29156, 37.77971], [-122.29141, 37.77947], [-122.29133, 37.77887], [-122.29138, 37.77735], [-122.29245, 37.77738]]]} | Open Access 1 | Main Street Soccer Field | 30710 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 6.059 | Main Street Soccer Field | ||
14206 | 14206 | 14205 | {"type": "Polygon", "coordinates": [[[-122.28869, 37.78989], [-122.28434, 37.79], [-122.28434, 37.78999], [-122.2844, 37.78926], [-122.28472, 37.78911], [-122.28521, 37.78928], [-122.28706, 37.78929], [-122.28729, 37.78923], [-122.28753, 37.78908], [-122.28867, 37.78906], [-122.28869, 37.78989]]]} | Open Access 1 | Estuary Park | https://www.alamedaca.gov/Departments/Recreation-Parks/Estuary-Park | 33465 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 7.718 | Estuary Park | 2017 |
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]);