superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
65 rows where MNG_AGENCY = 52 and MNG_AG_TYP = 2 sorted by map descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 65 ✖
MNG_AGENCY 1
- Newport Beach, City of · 65 ✖
ACCESS_TYP 1
- Open Access 65
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7369 | 7369 | 7368 | {"type": "Polygon", "coordinates": [[[-117.9478, 33.62663], [-117.9478, 33.62663], [-117.94751, 33.62698], [-117.94748, 33.62644], [-117.9478, 33.62663]]]} | Open Access 1 | Newport Shores Park | 22740 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.211 | Newport Shores Park | ||
2831 | 2831 | 2830 | {"type": "Polygon", "coordinates": [[[-117.93779, 33.62105], [-117.93766, 33.6216], [-117.93705, 33.62146], [-117.93662, 33.62098], [-117.93669, 33.62088], [-117.93779, 33.62105]]]} | Open Access 1 | Channel Place Park | 17122 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1.279 | Channel Place Park | ||
13647 | 13647 | 13646 | {"type": "Polygon", "coordinates": [[[-117.93748, 33.62363], [-117.93728, 33.62371], [-117.9371, 33.62381], [-117.93693, 33.62393], [-117.9367, 33.62416], [-117.93646, 33.62403], [-117.93612, 33.6238], [-117.93624, 33.6237], [-117.93632, 33.62366], [-117.93648, 33.6236], [-117.93664, 33.62356], [-117.93691, 33.62355], [-117.93729, 33.62357], [-117.93748, 33.62359], [-117.93748, 33.62363]]]} | Open Access 1 | Sunset Ridge Park | 31140 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1.077 | Sunset Ridge Park | ||
8606 | 8606 | 8605 | {"type": "Polygon", "coordinates": [[[-117.93644, 33.62307], [-117.9363, 33.62323], [-117.93443, 33.62303], [-117.93221, 33.62313], [-117.93221, 33.62308], [-117.93443, 33.62298], [-117.93576, 33.62311], [-117.93585, 33.6231], [-117.9359, 33.62307], [-117.93596, 33.62299], [-117.93597, 33.62292], [-117.93644, 33.62307]]]} | Open Access 1 | Sunset View Park | 26068 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.805 | Sunset View Park | ||
1343 | 1343 | 1342 | {"type": "Polygon", "coordinates": [[[-117.93517, 33.61789], [-117.93509, 33.61794], [-117.93498, 33.61796], [-117.93491, 33.61795], [-117.93482, 33.61791], [-117.93424, 33.61727], [-117.93418, 33.61712], [-117.93418, 33.61708], [-117.93421, 33.61704], [-117.93424, 33.61702], [-117.93439, 33.61697], [-117.93516, 33.61784], [-117.93517, 33.61789]]]} | Open Access 1 | 38th Street Park | 15197 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.922 | 38th Street Park | ||
7368 | 7368 | 7367 | {"type": "Polygon", "coordinates": [[[-117.93448, 33.6189], [-117.93422, 33.61907], [-117.93394, 33.61875], [-117.9342, 33.61859], [-117.93448, 33.6189]]]} | Open Access 1 | Newport Island Park | 22737 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.329 | Newport Island Park | ||
13661 | 13661 | 13660 | {"type": "Polygon", "coordinates": [[[-117.93428, 33.61823], [-117.93424, 33.61826], [-117.93394, 33.61792], [-117.93398, 33.6179], [-117.93428, 33.61823]]]} | Open Access 1 | Lake Street Park | 31130 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.059 | Lake Street Park | ||
6165 | 6165 | 6164 | {"type": "Polygon", "coordinates": [[[-117.92689, 33.61603], [-117.92681, 33.61619], [-117.92653, 33.6162], [-117.92643, 33.61603], [-117.92689, 33.61603]]]} | Open Access 1 | Lido Park | 21228 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.156 | Lido Park | ||
2128 | 2128 | 2127 | {"type": "Polygon", "coordinates": [[[-117.92564, 33.62824], [-117.92557, 33.62842], [-117.92508, 33.6285], [-117.92518, 33.62839], [-117.9252, 33.62829], [-117.92525, 33.62831], [-117.92564, 33.62824]]]} | Open Access 1 | Bolsa Park | 16247 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.197 | Bolsa Park | ||
13644 | 13644 | 13643 | {"type": "Polygon", "coordinates": [[[-117.92489, 33.60778], [-117.92468, 33.60878], [-117.92225, 33.60844], [-117.92236, 33.60782], [-117.92183, 33.60774], [-117.92183, 33.60768], [-117.92168, 33.60766], [-117.92168, 33.6076], [-117.92144, 33.60757], [-117.9215, 33.6073], [-117.92489, 33.60778]]]} | Open Access 1 | Marina Park | 31135 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 7.255 | Marina Park | ||
10814 | 10814 | 10813 | {"type": "Polygon", "coordinates": [[[-117.92184, 33.60768], [-117.92172, 33.60823], [-117.92104, 33.60813], [-117.92106, 33.60796], [-117.9206, 33.60789], [-117.92068, 33.60751], [-117.92184, 33.60768]]]} | Open Access 1 | Veterans Memorial Park | 27029 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1.458 | Veterans Memorial Park | ||
4038 | 4038 | 4037 | {"type": "Polygon", "coordinates": [[[-117.92158, 33.62047], [-117.92075, 33.62131], [-117.92059, 33.62077], [-117.92003, 33.62037], [-117.92034, 33.62006], [-117.92071, 33.62031], [-117.92089, 33.62015], [-117.92158, 33.62047]]]} | Open Access 1 | Ensign View Park | 18682 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 2.136 | Ensign View Park | ||
7364 | 7364 | 7363 | {"type": "Polygon", "coordinates": [[[-117.92126, 33.6122], [-117.92123, 33.61223], [-117.92099, 33.61213], [-117.92098, 33.61208], [-117.92101, 33.61201], [-117.92107, 33.61195], [-117.92113, 33.612], [-117.92126, 33.6122]]]} | Open Access 1 | Newport Beach holding 1 | 22733 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.098 | Newport Beach holding 1 | ||
5747 | 5747 | 5746 | {"type": "Polygon", "coordinates": [[[-117.91824, 33.6176], [-117.91811, 33.61786], [-117.91789, 33.61778], [-117.91766, 33.61777], [-117.91767, 33.61741], [-117.91824, 33.6176]]]} | Open Access 1 | Kings Road Park | 20664 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.409 | Kings Road Park | ||
2685 | 2685 | 2684 | {"type": "Polygon", "coordinates": [[[-117.90744, 33.61952], [-117.90744, 33.61987], [-117.9074, 33.62011], [-117.90732, 33.62033], [-117.90721, 33.62055], [-117.90672, 33.62141], [-117.90634, 33.62126], [-117.90634, 33.62122], [-117.90624, 33.62118], [-117.90634, 33.621], [-117.90634, 33.62087], [-117.9063, 33.6208], [-117.90599, 33.62067], [-117.90582, 33.62074], [-117.90571, 33.62093], [-117.90562, 33.62083], [-117.9045, 33.61996], [-117.90504, 33.61924], [-117.90515, 33.6189], [-117.90511, 33.61808], [-117.90601, 33.61785], [-117.90647, 33.61786], [-117.90677, 33.61794], [-117.90689, 33.61826], [-117.90725, 33.61904], [-117.90734, 33.61938], [-117.90744, 33.61952]]]} | Open Access 1 | Castaways Park | 16947 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 16.769 | Castaways Park | ||
2100 | 2100 | 2099 | {"type": "Polygon", "coordinates": [[[-117.90617, 33.62234], [-117.90575, 33.62311], [-117.90557, 33.62333], [-117.90548, 33.62358], [-117.90542, 33.62363], [-117.90531, 33.62377], [-117.9052, 33.62372], [-117.90521, 33.62354], [-117.90518, 33.62344], [-117.90511, 33.62332], [-117.90486, 33.62323], [-117.90428, 33.62307], [-117.90398, 33.62292], [-117.90394, 33.62284], [-117.90426, 33.62273], [-117.90442, 33.62262], [-117.90454, 33.62247], [-117.90457, 33.62235], [-117.90459, 33.62216], [-117.90464, 33.62211], [-117.90487, 33.62202], [-117.90505, 33.62201], [-117.90507, 33.62198], [-117.90537, 33.622], [-117.90558, 33.62205], [-117.90616, 33.62228], [-117.90617, 33.62234]]]} | Open Access 1 | Bob Henry Park | 16208 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 5.104 | Bob Henry Park | ||
13721 | 13721 | 13720 | {"type": "Polygon", "coordinates": [[[-117.90419, 33.63263], [-117.90311, 33.63371], [-117.90243, 33.63323], [-117.90214, 33.63297], [-117.90198, 33.63277], [-117.90184, 33.63256], [-117.90169, 33.63222], [-117.90161, 33.63187], [-117.90159, 33.63163], [-117.90196, 33.6316], [-117.90221, 33.63156], [-117.90351, 33.63246], [-117.90368, 33.63231], [-117.90419, 33.63263]]]} | Open Access 1 | Mariners Park and VJ Community Center | 31213 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 7.143 | Mariners Park and VJ Community Ctr. | ||
6844 | 6844 | 6843 | {"type": "Polygon", "coordinates": [[[-117.90004, 33.60061], [-117.8997, 33.60129], [-117.89766, 33.60064], [-117.89774, 33.6005], [-117.89762, 33.60045], [-117.89793, 33.59997], [-117.89813, 33.60006], [-117.89822, 33.59994], [-117.89828, 33.59992], [-117.89928, 33.60027], [-117.89927, 33.60034], [-117.90004, 33.60061]]]} | Open Access 1 | Peninsula Park | 23579 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 4.542 | Peninsula Park | ||
11124 | 11124 | 11123 | {"type": "Polygon", "coordinates": [[[-117.89951, 33.62208], [-117.89873, 33.62219], [-117.89842, 33.62226], [-117.89814, 33.62236], [-117.89787, 33.6225], [-117.89762, 33.62265], [-117.89743, 33.62283], [-117.89748, 33.62305], [-117.89737, 33.62307], [-117.89734, 33.62311], [-117.89731, 33.62317], [-117.89733, 33.62326], [-117.89744, 33.62336], [-117.89711, 33.6238], [-117.89694, 33.62397], [-117.89678, 33.6239], [-117.89695, 33.62354], [-117.897, 33.62335], [-117.89703, 33.62301], [-117.89707, 33.62287], [-117.89714, 33.62275], [-117.8973, 33.62258], [-117.89795, 33.62213], [-117.89849, 33.6218], [-117.89863, 33.62174], [-117.89887, 33.62171], [-117.89904, 33.62172], [-117.89913, 33.62175], [-117.8992, 33.62181], [-117.89951, 33.62208]]]} | Open Access 1 | Westcliff Park | 27387 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 2.985 | Westcliff Park | ||
1737 | 1737 | 1736 | {"type": "Polygon", "coordinates": [[[-117.89841, 33.60599], [-117.89815, 33.60629], [-117.89792, 33.60615], [-117.89821, 33.60581], [-117.89841, 33.60599]]]} | Open Access 1 | Balboa Island Park at Carroll Beek Community Center | 15771 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.279 | Balboa Island Park at Carroll Beek Community Ctr. |
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]);