units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
28 rows where MNG_AGENCY = 176
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
9124 | 9124 | 9123 | {"type": "Polygon", "coordinates": [[[-122.23778, 37.75118], [-122.23718, 37.75114], [-122.23698, 37.75109], [-122.23672, 37.75097], [-122.23649, 37.75078], [-122.23634, 37.75049], [-122.23631, 37.75027], [-122.23635, 37.74995], [-122.23643, 37.75001], [-122.23642, 37.75024], [-122.23778, 37.75118]]]} | Open Access 1 | 15128 | Towata Park | 26482 | 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.271 | Towata Park | 0 | Local Park 2 | 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 |
10004 | 10004 | 10003 | {"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 | 48002 | Nicol Park | 32425 | 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.207 | Nicol 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 |
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 | |
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 | |
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 |
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]);