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 ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13723 | 13723 | 13722 | {"type": "Polygon", "coordinates": [[[-117.87133, 33.59796], [-117.87133, 33.59796], [-117.87119, 33.59799], [-117.8713, 33.59788], [-117.87133, 33.59796]]]} | Open Access 1 | Corona del Mar Pocket Park | 31210 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.015 | Corona del Mar PP | ||
13646 | 13646 | 13645 | {"type": "Polygon", "coordinates": [[[-117.89511, 33.61062], [-117.89508, 33.61063], [-117.89507, 33.61067], [-117.89499, 33.61066], [-117.89481, 33.61061], [-117.89479, 33.61058], [-117.89492, 33.61057], [-117.89511, 33.61061], [-117.89511, 33.61062]]]} | Open Access 1 | Myrtle Park | 31137 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.047 | Myrtle Park | ||
6481 | 6481 | 6480 | {"type": "Polygon", "coordinates": [[[-117.88405, 33.59813], [-117.884, 33.59813], [-117.88389, 33.59805], [-117.88384, 33.59799], [-117.88386, 33.59796], [-117.88404, 33.59799], [-117.88405, 33.59813]]]} | Open Access 1 | M Street Park | 21618 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.056 | M Street 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 | ||
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 | ||
13645 | 13645 | 13644 | {"type": "Polygon", "coordinates": [[[-117.89054, 33.59896], [-117.89013, 33.59896], [-117.89013, 33.59888], [-117.89015, 33.59884], [-117.89012, 33.59877], [-117.89015, 33.59873], [-117.89054, 33.59896]]]} | Open Access 1 | Miramar Park | 31136 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.125 | Miramar 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 | ||
7735 | 7735 | 7734 | {"type": "Polygon", "coordinates": [[[-117.88129, 33.66139], [-117.88076, 33.66102], [-117.88076, 33.66102], [-117.88085, 33.66093], [-117.88129, 33.66124], [-117.88125, 33.66131], [-117.88129, 33.66139]]]} | Open Access 1 | Orchard Drive Park | 23186 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.184 | Orchard Drive 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 | ||
5489 | 5489 | 5488 | {"type": "Polygon", "coordinates": [[[-117.866, 33.60265], [-117.86593, 33.6027], [-117.86573, 33.6025], [-117.86554, 33.60226], [-117.86554, 33.60222], [-117.86556, 33.60219], [-117.86577, 33.60204], [-117.86574, 33.60213], [-117.86574, 33.60229], [-117.86576, 33.60238], [-117.86584, 33.60251], [-117.86596, 33.60258], [-117.866, 33.60265]]]} | Open Access 1 | Jasmine Creek Park | 20367 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.208 | Jasmine Creek Park | ||
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 | ||
4523 | 4523 | 4522 | {"type": "MultiPolygon", "coordinates": [[[[-117.92987, 33.61876], [-117.92979, 33.61914], [-117.92968, 33.6191], [-117.92985, 33.61876], [-117.92987, 33.61876]]], [[[-117.93059, 33.61792], [-117.93044, 33.61839], [-117.93035, 33.61837], [-117.93034, 33.61834], [-117.93036, 33.61789], [-117.93059, 33.61792]]]]} | Open Access 1 | Gateway Park | 19238 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.272 | Gateway 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. | ||
5791 | 5791 | 5790 | {"type": "Polygon", "coordinates": [[[-117.88723, 33.5983], [-117.88719, 33.59833], [-117.88651, 33.59833], [-117.88649, 33.59832], [-117.88647, 33.59829], [-117.88647, 33.59812], [-117.88651, 33.59809], [-117.8872, 33.59828], [-117.88723, 33.5983]]]} | Open Access 1 | L Street Park | 20737 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.282 | L 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 | ||
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 | ||
13660 | 13660 | 13659 | {"type": "Polygon", "coordinates": [[[-117.8698, 33.61245], [-117.86977, 33.61249], [-117.86973, 33.61271], [-117.86967, 33.61278], [-117.86956, 33.61288], [-117.86936, 33.61299], [-117.86932, 33.61303], [-117.86918, 33.61319], [-117.86913, 33.61331], [-117.86907, 33.61336], [-117.86898, 33.61338], [-117.86895, 33.61336], [-117.86895, 33.61331], [-117.86899, 33.61324], [-117.86909, 33.61317], [-117.86916, 33.6131], [-117.86927, 33.61293], [-117.86945, 33.61277], [-117.86951, 33.6127], [-117.86957, 33.61257], [-117.86957, 33.6125], [-117.8696, 33.61245], [-117.86973, 33.61238], [-117.8698, 33.61245]]]} | Open Access 1 | Dog Park | 31129 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.431 | Dog Park | ||
7661 | 7661 | 7660 | {"type": "MultiPolygon", "coordinates": [[[[-117.87424, 33.60258], [-117.87399, 33.60284], [-117.8737, 33.60264], [-117.87395, 33.60238], [-117.87424, 33.60258]]], [[[-117.87457, 33.60281], [-117.87432, 33.60307], [-117.87404, 33.60287], [-117.8743, 33.60262], [-117.87457, 33.60281]]]]} | Open Access 1 | Old School Park | 23103 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.62 | Old School Park | ||
6957 | 6957 | 6956 | {"type": "Polygon", "coordinates": [[[-117.87971, 33.65598], [-117.87969, 33.65616], [-117.87963, 33.6562], [-117.87928, 33.65615], [-117.87891, 33.65616], [-117.8791, 33.65598], [-117.87918, 33.65596], [-117.87922, 33.65593], [-117.87928, 33.6558], [-117.87952, 33.65556], [-117.87959, 33.65556], [-117.87966, 33.65568], [-117.87971, 33.6558], [-117.87971, 33.65598]]]} | Open Access 1 | Mesa Birch Park | 22172 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.707 | Mesa Birch 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 |
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]);