units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
28 rows where MNG_AGENCY = 176 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
PARK_URL 3 ✖
DES_TP 2
MNG_AG_TYP 1
- City Agency 28
MNG_AGENCY 1
- Alameda, City of · 28 ✖
ACCESS_TYP 1
- Open Access 28
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4104 | 4104 | 4103 | {"type": "Polygon", "coordinates": [[[-122.28814, 37.78267], [-122.28814, 37.78306], [-122.28666, 37.78304], [-122.28669, 37.78184], [-122.28791, 37.78185], [-122.28808, 37.78232], [-122.28799, 37.78241], [-122.28798, 37.78247], [-122.28798, 37.78253], [-122.28804, 37.78262], [-122.28814, 37.78267]]]} | Open Access 1 | 47045 | Bayport Park | 30695 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 4.003 | Bayport Park | 0 | Local Park 2 | 4 | |
4062 | 4062 | 4061 | {"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 | 47050 | City View Skate Park | 30700 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 0.667 | City View Skate Park | 0 | Local Recreation Area 3 | 4 | |
1965 | 1965 | 1964 | {"type": "Polygon", "coordinates": [[[-122.23947, 37.7313], [-122.23907, 37.73176], [-122.2378, 37.73113], [-122.23824, 37.73064], [-122.23947, 37.7313]]]} | Open Access 1 | 15113 | Doc Harrington Park | 18177 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 2.094 | Doc Harrington Park | 0 | Local Park 2 | 4 | |
10007 | 10007 | 10006 | {"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 | 48003 | Dolphin Mini Park | 32426 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/s/Parks/index.htm | Alameda 17 | 0.099 | Dolphin MP | 0 | Local Park 2 | 4 |
3429 | 3429 | 3428 | {"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.28707, 37.78929], [-122.28729, 37.78923], [-122.28753, 37.78908], [-122.28867, 37.78906], [-122.28869, 37.78989]]]} | Open Access 1 | 48739 | Estuary Park | 33465 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | https://www.alamedaca.gov/Departments/Recreation-Parks/Estuary-Park | Alameda 17 | 7.72 | Estuary Park | 2017 | Local Park 2 | 4 |
1754 | 1754 | 1753 | {"type": "Polygon", "coordinates": [[[-122.26219, 37.76826], [-122.26215, 37.76912], [-122.26062, 37.76844], [-122.26111, 37.76773], [-122.26212, 37.76817], [-122.26217, 37.76821], [-122.26219, 37.76826]]]} | Open Access 1 | 13146 | Franklin Park | 19060 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 2.958 | Franklin Park | 0 | Local Park 2 | 4 | |
1964 | 1964 | 1963 | {"type": "Polygon", "coordinates": [[[-122.23324, 37.73433], [-122.23167, 37.73513], [-122.2312, 37.73448], [-122.23129, 37.73391], [-122.23247, 37.73335], [-122.23324, 37.73433]]]} | Open Access 1 | 15110 | Godfrey Park | 19352 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 4.982 | Godfrey Park | 0 | Local Park 2 | 4 | |
9117 | 9117 | 9116 | {"type": "Polygon", "coordinates": [[[-122.24546, 37.75964], [-122.24348, 37.76197], [-122.24301, 37.76171], [-122.24489, 37.75945], [-122.24502, 37.75937], [-122.24519, 37.75934], [-122.24534, 37.75941], [-122.24542, 37.75951], [-122.24546, 37.75964]]]} | Open Access 1 | 15116 | Jackson Park | 20319 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 4.117 | Jackson Park | 0 | Local Park 2 | 4 | |
1968 | 1968 | 1967 | {"type": "Polygon", "coordinates": [[[-122.24109, 37.75354], [-122.2401, 37.75443], [-122.23818, 37.75321], [-122.2392, 37.7522], [-122.24109, 37.75354]]]} | Open Access 1 | 15123 | Krusi Park | 20727 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 7.492 | Krusi Park | 2000 | Local Park 2 | 4 | |
10041 | 10041 | 10040 | {"type": "Polygon", "coordinates": [[[-122.24373, 37.73674], [-122.24351, 37.73714], [-122.24297, 37.73711], [-122.24273, 37.73767], [-122.24217, 37.73747], [-122.24208, 37.73723], [-122.24179, 37.73692], [-122.2417, 37.73666], [-122.24136, 37.73673], [-122.24101, 37.73658], [-122.24098, 37.73654], [-122.24098, 37.73648], [-122.241, 37.73644], [-122.24115, 37.73634], [-122.24117, 37.73624], [-122.24118, 37.73621], [-122.24128, 37.7362], [-122.2418, 37.73629], [-122.24373, 37.73674]]]} | Open Access 1 | 17369 | Leydecker Park | 21200 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 4.34 | Leydecker Park | 0 | Local Park 2 | 4 | |
1969 | 1969 | 1968 | {"type": "Polygon", "coordinates": [[[-122.23152, 37.75852], [-122.2309, 37.75909], [-122.22784, 37.75697], [-122.22846, 37.75639], [-122.23152, 37.75852]]]} | Open Access 1 | 15126 | Lincoln Park | 21260 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 7.412 | Lincoln Park | 0 | Local Park 2 | 4 | |
8450 | 8450 | 8449 | {"type": "Polygon", "coordinates": [[[-122.29151, 37.78681], [-122.29141, 37.78693], [-122.29105, 37.78704], [-122.29094, 37.78269], [-122.29085, 37.78011], [-122.29097, 37.78014], [-122.29109, 37.7802], [-122.29115, 37.78028], [-122.29119, 37.78039], [-122.29123, 37.78128], [-122.29125, 37.78243], [-122.29129, 37.78618], [-122.29132, 37.78619], [-122.29151, 37.78681]]]} | Open Access 1 | 13132 | Linear Park | 21304 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 5.152 | Linear Park | 0 | Local Park 2 | 4 | |
8453 | 8453 | 8452 | {"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 | 13138 | Littlejohn Park | 33376 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 3.857 | Littlejohn Park | 0 | Local Park 2 | 4 | |
8455 | 8455 | 8454 | {"type": "Polygon", "coordinates": [[[-122.28152, 37.77443], [-122.2815, 37.77517], [-122.28088, 37.77516], [-122.28091, 37.77442], [-122.28152, 37.77443]]]} | Open Access 1 | 13142 | Longfellow Park | 21454 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 1.103 | Longfellow Park | 0 | Local Park 2 | 4 | |
4101 | 4101 | 4100 | {"type": "Polygon", "coordinates": [[[-122.2971, 37.78993], [-122.29707, 37.79023], [-122.29505, 37.79057], [-122.29505, 37.78997], [-122.29569, 37.79], [-122.29571, 37.78985], [-122.2971, 37.78993]]]} | Open Access 1 | 47052 | Main Street Dog Park | 30702 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 2.363 | Main Street Dog Park | 0 | Local Park 2 | 4 | |
14448 | 14448 | 14447 | {"type": "Polygon", "coordinates": [[[-122.29245, 37.77738], [-122.29241, 37.77968], [-122.292, 37.77973], [-122.29174, 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 | 47059 | Main Street Soccer Field | 30710 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 6.06 | Main Street Soccer Field | 0 | Local Recreation Area 3 | 4 | |
10003 | 10003 | 10002 | {"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.25612, 37.77736], [-122.256, 37.77732], [-122.25597, 37.77735], [-122.2559, 37.77732], [-122.25586, 37.77738], [-122.25581, 37.77736], [-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 | 48001 | Marina Cove Waterfront Park | 32424 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | http://www.waterfrontaction.org/map/park_marina_cove.htm | Alameda 17 | 1.356 | Marina Cove Waterfront Park | 0 | Local Park 2 | 4 |
8452 | 8452 | 8451 | {"type": "MultiPolygon", "coordinates": [[[[-122.27092, 37.78439], [-122.27092, 37.7846], [-122.26927, 37.78477], [-122.26925, 37.78493], [-122.26898, 37.78493], [-122.26885, 37.78501], [-122.26867, 37.78488], [-122.26868, 37.78426], [-122.26831, 37.78386], [-122.26821, 37.78334], [-122.26766, 37.78307], [-122.26688, 37.783], [-122.26625, 37.78305], [-122.266, 37.78318], [-122.26564, 37.78359], [-122.2653, 37.78363], [-122.26562, 37.78327], [-122.26573, 37.78305], [-122.26594, 37.78303], [-122.26602, 37.78292], [-122.26605, 37.78276], [-122.26639, 37.78276], [-122.26649, 37.7828], [-122.26668, 37.78278], [-122.26681, 37.78268], [-122.2671, 37.78272], [-122.26737, 37.78267], [-122.26756, 37.78268], [-122.26788, 37.78266], [-122.26808, 37.78282], [-122.26839, 37.78289], [-122.26853, 37.78299], [-122.26849, 37.78316], [-122.26854, 37.7835], [-122.2689, 37.78375], [-122.2689, 37.784], [-122.26911, 37.78425], [-122.26908, 37.78438], [-122.26921, 37.78454], [-122.26959, 37.78456], [-122.27007, 37.78448], [-122.27027, 37.78453], [-122.27056, 37.7845], [-122.27064, 37.78452], [-122.27084, 37.78446], [-122.27092, 37.78439]]], [[[-122.27219, 37.78578], [-122.27203, 37.78587], [-122.27168, 37.78588], [-122.2715, 37.7859], [-122.27143, 37.78624], [-122.27106, 37.7869], [-122.27031, 37.78663], [-122.27053, 37.78625], [-122.27055, 37.78618], [-122.27135, 37.78609], [-122.27135, 37.78569], [-122.27155, 37.78568], [-122.2719, 37.78549], [-122.27219, 37.78578]]]]} | Open Access 1 | 13136 | Marina Park | 21831 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 7.15 | Marina Park | 0 | Local Park 2 | 4 | |
11577 | 11577 | 11576 | {"type": "Polygon", "coordinates": [[[-122.24488, 37.77056], [-122.2443, 37.77142], [-122.24359, 37.77111], [-122.24418, 37.77026], [-122.24488, 37.77056]]]} | Open Access 1 | 23672 | McKinley Park | 22046 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 1.901 | McKinley Park | 0 | Local Park 2 | 4 | |
4107 | 4107 | 4106 | {"type": "Polygon", "coordinates": [[[-122.30486, 37.78899], [-122.30487, 37.78905], [-122.3047, 37.79053], [-122.30344, 37.79025], [-122.30345, 37.79004], [-122.30357, 37.79001], [-122.30361, 37.78948], [-122.30357, 37.78946], [-122.30359, 37.7889], [-122.30486, 37.78899]]]} | Open Access 1 | 47048 | Multipurpose Field | 30698 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 4.381 | Multipurpose Field | 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]);