superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
65 rows where ACCESS_TYP = 1 and MNG_AGENCY = 52
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 45
MNG_AGENCY 1
- Newport Beach, City of · 45 ✖
ACCESS_TYP 1
- Open Access · 45 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4696 | 4696 | 4695 | {"type": "Polygon", "coordinates": [[[-117.87117, 33.60242], [-117.87116, 33.60245], [-117.8711, 33.60256], [-117.87077, 33.60296], [-117.86933, 33.60201], [-117.86916, 33.60225], [-117.86863, 33.60202], [-117.86866, 33.60194], [-117.86798, 33.60161], [-117.86806, 33.60149], [-117.86816, 33.60138], [-117.86847, 33.60116], [-117.86847, 33.60114], [-117.86778, 33.60071], [-117.86707, 33.60032], [-117.86748, 33.5999], [-117.86751, 33.59989], [-117.86759, 33.59991], [-117.86785, 33.60009], [-117.86788, 33.60012], [-117.86788, 33.60016], [-117.86793, 33.6002], [-117.86799, 33.60018], [-117.86804, 33.6002], [-117.86886, 33.60078], [-117.869, 33.60082], [-117.86968, 33.60129], [-117.86963, 33.60133], [-117.86964, 33.60135], [-117.87103, 33.60229], [-117.87117, 33.60242]]]} | Open Access 1 | Grant Howald Park & CYC | 19435 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 9.011 | Grant Howald Park & CYC | ||
4888 | 4888 | 4887 | {"type": "Polygon", "coordinates": [[[-117.86393, 33.6158], [-117.86396, 33.61585], [-117.86399, 33.61608], [-117.86385, 33.61657], [-117.86336, 33.6171], [-117.86315, 33.61702], [-117.86293, 33.61695], [-117.86265, 33.6169], [-117.86252, 33.61689], [-117.86252, 33.61682], [-117.86279, 33.61672], [-117.8628, 33.6167], [-117.86293, 33.6166], [-117.86304, 33.61648], [-117.8631, 33.61624], [-117.86307, 33.61615], [-117.86283, 33.61601], [-117.8627, 33.616], [-117.8624, 33.61583], [-117.86207, 33.61532], [-117.86174, 33.61544], [-117.86165, 33.61527], [-117.86197, 33.61513], [-117.8619, 33.61498], [-117.86172, 33.61469], [-117.86085, 33.61396], [-117.86081, 33.61389], [-117.86068, 33.61383], [-117.85994, 33.61332], [-117.86117, 33.61313], [-117.86149, 33.61351], [-117.86182, 33.61381], [-117.86215, 33.614], [-117.86221, 33.61409], [-117.86235, 33.61453], [-117.86264, 33.61493], [-117.86286, 33.61544], [-117.86305, 33.61551], [-117.86377, 33.61562], [-117.86389, 33.61581], [-117.86393, 33.6158]]]} | Open Access 1 | Harbor View Nature Park | 19667 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 10.045 | Harbor View Nature Park | ||
5349 | 5349 | 5348 | {"type": "Polygon", "coordinates": [[[-117.8722, 33.59222], [-117.87161, 33.59281], [-117.87148, 33.59263], [-117.87135, 33.59248], [-117.87115, 33.59212], [-117.87162, 33.59175], [-117.8722, 33.59222]]]} | Open Access 1 | Inspiration Point | 20222 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1.448 | Inspiration Point | ||
5410 | 5410 | 5409 | {"type": "Polygon", "coordinates": [[[-117.88244, 33.60781], [-117.88204, 33.60814], [-117.88165, 33.60832], [-117.88166, 33.60837], [-117.88145, 33.60853], [-117.88142, 33.60853], [-117.8813, 33.60865], [-117.88132, 33.60869], [-117.88122, 33.60882], [-117.88116, 33.609], [-117.88112, 33.60904], [-117.87903, 33.6076], [-117.87967, 33.60695], [-117.87971, 33.60694], [-117.88115, 33.60734], [-117.88169, 33.60757], [-117.88244, 33.60781]]]} | Open Access 1 | Irvine Terrace Park | 20271 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 8.553 | Irvine Terrace 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 | ||
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 | ||
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 | ||
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 | ||
6371 | 6371 | 6370 | {"type": "Polygon", "coordinates": [[[-117.87837, 33.59536], [-117.87829, 33.59549], [-117.87823, 33.59548], [-117.87796, 33.59574], [-117.87786, 33.59557], [-117.87787, 33.59553], [-117.87785, 33.5955], [-117.87783, 33.59546], [-117.87777, 33.59543], [-117.87718, 33.5953], [-117.87709, 33.59527], [-117.87713, 33.59521], [-117.87725, 33.59517], [-117.87731, 33.59512], [-117.87751, 33.5951], [-117.87769, 33.59511], [-117.87775, 33.59511], [-117.87786, 33.59515], [-117.87794, 33.5952], [-117.87806, 33.59524], [-117.87806, 33.59527], [-117.87812, 33.59531], [-117.87813, 33.59537], [-117.87817, 33.59535], [-117.87831, 33.59533], [-117.87837, 33.59536]]]} | Open Access 1 | Lookout Point | 21462 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.844 | Lookout Point | ||
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 | ||
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 | ||
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 | ||
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 | ||
7366 | 7366 | 7365 | {"type": "Polygon", "coordinates": [[[-117.89547, 33.62507], [-117.89512, 33.62537], [-117.89455, 33.62546], [-117.89418, 33.62594], [-117.89326, 33.6255], [-117.89307, 33.62508], [-117.89331, 33.6246], [-117.89335, 33.62458], [-117.89391, 33.62465], [-117.89473, 33.62505], [-117.8949, 33.62511], [-117.895, 33.62513], [-117.89516, 33.6251], [-117.89533, 33.62496], [-117.89547, 33.62507]]]} | Open Access 1 | Newport Aquatic Center | 22732 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 4.174 | Newport Aquatic Ctr. | ||
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 | ||
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 | ||
7470 | 7470 | 7469 | {"type": "MultiPolygon", "coordinates": [[[[-117.89512, 33.62537], [-117.89436, 33.62602], [-117.89436, 33.62604], [-117.89448, 33.6261], [-117.8943, 33.62622], [-117.89414, 33.62637], [-117.89399, 33.62655], [-117.8936, 33.62678], [-117.89295, 33.62699], [-117.89176, 33.62704], [-117.89137, 33.62694], [-117.89144, 33.6267], [-117.89157, 33.62648], [-117.89272, 33.62566], [-117.89298, 33.62568], [-117.89309, 33.62565], [-117.89323, 33.62558], [-117.89326, 33.6255], [-117.89417, 33.62593], [-117.89455, 33.62546], [-117.89512, 33.62537]]], [[[-117.89535, 33.62493], [-117.89533, 33.62496], [-117.89517, 33.6251], [-117.895, 33.62513], [-117.89474, 33.62505], [-117.89391, 33.62465], [-117.89335, 33.62458], [-117.8934, 33.62439], [-117.89349, 33.62395], [-117.89343, 33.62333], [-117.89533, 33.6249], [-117.89535, 33.62493]]]]} | Open Access 1 | North Star Beach | 22859 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 11.269 | North Star Beach | ||
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 | ||
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 | ||
7812 | 7812 | 7811 | {"type": "Polygon", "coordinates": [[[-117.85359, 33.61808], [-117.85184, 33.6207], [-117.8518, 33.62072], [-117.85175, 33.62071], [-117.85126, 33.62047], [-117.85098, 33.62026], [-117.85073, 33.62], [-117.85148, 33.61962], [-117.85164, 33.61951], [-117.85188, 33.61926], [-117.85228, 33.61923], [-117.85249, 33.61903], [-117.8526, 33.61887], [-117.85289, 33.61831], [-117.8527, 33.61799], [-117.85232, 33.61781], [-117.85204, 33.61758], [-117.85208, 33.61732], [-117.85201, 33.61705], [-117.85166, 33.6168], [-117.8515, 33.61672], [-117.85112, 33.61646], [-117.8512, 33.61642], [-117.85359, 33.61808]]]} | Open Access 1 | San Miguel Park | 24958 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 7.295 | San Miguel 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]);