units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
64 rows where AGNCY_ID = 1224 and MNG_AGENCY = 52
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
DES_TP 9
- Local Park 50
- Local Recreation Area 7
- Local Conservation Area 1
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 64
MNG_AGENCY 1
- Newport Beach, City of · 64 ✖
ACCESS_TYP 1
- Open Access 64
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
126 | 126 | 125 | {"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.62032], [-117.92089, 33.62015], [-117.92158, 33.62047]]]} | Open Access 1 | 318 | Ensign View Park | 18682 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 2.134 | Ensign View Park | 0 | Local Park 2 | 4 | |
168 | 168 | 167 | {"type": "Polygon", "coordinates": [[[-117.89514, 33.614], [-117.89456, 33.61397], [-117.89358, 33.61385], [-117.8935, 33.61387], [-117.89229, 33.61421], [-117.89219, 33.61426], [-117.89104, 33.61503], [-117.89096, 33.61513], [-117.89091, 33.61526], [-117.89088, 33.61554], [-117.89077, 33.61565], [-117.89026, 33.61591], [-117.88975, 33.61562], [-117.88988, 33.61545], [-117.89005, 33.61555], [-117.89018, 33.61539], [-117.89068, 33.61565], [-117.89078, 33.61558], [-117.89081, 33.61554], [-117.89085, 33.61536], [-117.8908, 33.61528], [-117.89079, 33.61519], [-117.8908, 33.61509], [-117.89113, 33.61463], [-117.891, 33.61454], [-117.89084, 33.6145], [-117.89066, 33.61444], [-117.89044, 33.61441], [-117.89041, 33.61439], [-117.89036, 33.61433], [-117.89018, 33.6143], [-117.89004, 33.61433], [-117.8898, 33.61442], [-117.88968, 33.61453], [-117.88966, 33.61452], [-117.89069, 33.61325], [-117.89076, 33.61318], [-117.89086, 33.61314], [-117.89096, 33.61312], [-117.89107, 33.61312], [-117.89435, 33.61364], [-117.89433, 33.61373], [-117.89514, 33.614]]]} | Open Access 1 | 536 | Back Bay View Park | 15751 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 10.648 | Back Bay View Park | 0 | Local Park 2 | 4 | |
299 | 299 | 298 | {"type": "Polygon", "coordinates": [[[-117.89118, 33.62744], [-117.89109, 33.6275], [-117.89102, 33.62758], [-117.89077, 33.62794], [-117.89073, 33.62809], [-117.89075, 33.62825], [-117.8904, 33.62835], [-117.8906, 33.62779], [-117.89072, 33.62716], [-117.8909, 33.6271], [-117.89118, 33.62744]]]} | Open Access 1 | 803 | Galaxy View Park | 19171 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.948 | Galaxy View Park | 0 | Local Park 2 | 4 | |
346 | 346 | 345 | {"type": "Polygon", "coordinates": [[[-117.83498, 33.59186], [-117.83357, 33.592], [-117.83332, 33.59203], [-117.83324, 33.59168], [-117.83368, 33.59129], [-117.8341, 33.59125], [-117.83427, 33.59117], [-117.83438, 33.59126], [-117.83475, 33.59141], [-117.83496, 33.59132], [-117.83498, 33.59186]]]} | Open Access 1 | 47415 | Los Trancos Canyon View Park (Upper) | 31132 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 2.623 | Los Trancos Canyon View Park (Upper) | None 35 | |||
395 | 395 | 394 | {"type": "Polygon", "coordinates": [[[-117.87117, 33.60242], [-117.87116, 33.60245], [-117.8711, 33.60256], [-117.87077, 33.60296], [-117.86932, 33.60201], [-117.86916, 33.60225], [-117.86863, 33.60202], [-117.86867, 33.60194], [-117.86798, 33.60161], [-117.86806, 33.60149], [-117.86816, 33.60138], [-117.86847, 33.60115], [-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.86794, 33.6002], [-117.86799, 33.60018], [-117.86804, 33.6002], [-117.86887, 33.60078], [-117.869, 33.60082], [-117.86968, 33.60129], [-117.86963, 33.60134], [-117.86963, 33.60135], [-117.87103, 33.60229], [-117.87117, 33.60242]]]} | Open Access 1 | 1168 | Grant Howald Park & CYC | 19435 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 9.005 | Grant Howald Park & CYC | None 40 | |||
461 | 461 | 460 | {"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 | 47411 | Corona del Mar Pocket Park | 31210 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.015 | Corona del Mar PP | 0 | Local Park 2 | 4 | |
598 | 598 | 597 | {"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 | 4130 | Lido Park | 21228 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.157 | Lido Park | 0 | Local Park 2 | 4 | |
638 | 638 | 637 | {"type": "Polygon", "coordinates": [[[-117.88386, 33.59796], [-117.88404, 33.59799], [-117.88405, 33.59813], [-117.884, 33.59813], [-117.88389, 33.59805], [-117.88384, 33.59799], [-117.88386, 33.59796]]]} | Open Access 1 | 4921 | M Street Park | 21618 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.056 | M Street Park | 0 | Local Park 2 | 4 | |
765 | 765 | 764 | {"type": "Polygon", "coordinates": [[[-117.88503, 33.63009], [-117.88493, 33.63054], [-117.88456, 33.63087], [-117.8844, 33.63098], [-117.88427, 33.63103], [-117.8841, 33.63106], [-117.88263, 33.63112], [-117.88253, 33.63115], [-117.88206, 33.63138], [-117.88279, 33.63178], [-117.88289, 33.63186], [-117.88295, 33.63192], [-117.883, 33.63202], [-117.88302, 33.63212], [-117.88308, 33.63273], [-117.88312, 33.63284], [-117.88322, 33.63295], [-117.88329, 33.63301], [-117.8846, 33.63364], [-117.88467, 33.63377], [-117.88483, 33.63395], [-117.88461, 33.63407], [-117.88448, 33.6339], [-117.88271, 33.63315], [-117.8824, 33.63265], [-117.88259, 33.63222], [-117.88182, 33.63176], [-117.88079, 33.63166], [-117.88049, 33.6317], [-117.88027, 33.6317], [-117.87975, 33.63121], [-117.87955, 33.63087], [-117.87928, 33.63058], [-117.87925, 33.63029], [-117.87852, 33.62913], [-117.87825, 33.629], [-117.87804, 33.62901], [-117.87802, 33.62898], [-117.87782, 33.62903], [-117.87737, 33.62921], [-117.87721, 33.62923], [-117.87699, 33.6293], [-117.87664, 33.62918], [-117.87761, 33.62757], [-117.87822, 33.62674], [-117.87836, 33.62695], [-117.87841, 33.62732], [-117.87879, 33.6275], [-117.87934, 33.62797], [-117.87967, 33.62852], [-117.88023, 33.62895], [-117.88053, 33.62966], [-117.88079, 33.62984], [-117.88109, 33.62989], [-117.8824, 33.62957], [-117.88277, 33.62964], [-117.88345, 33.63013], [-117.88367, 33.63011], [-117.8839, 33.62992], [-117.88411, 33.62993], [-117.8842, 33.62989], [-117.88503, 33.63009]]]} | Open Access 1 | 4965 | Big Canyon Park | 16076 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 39.132 | Big Canyon Park | 0 | Local Park 2 | 4 | |
908 | 908 | 907 | {"type": "MultiPolygon", "coordinates": [[[[-117.87425, 33.60258], [-117.87399, 33.60284], [-117.8737, 33.60264], [-117.87395, 33.60238], [-117.87425, 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 | 6362 | Old School Park | 23103 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.62 | Old School Park | 0 | Local Park 2 | 4 | |
942 | 942 | 941 | {"type": "MultiPolygon", "coordinates": [[[[-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], [-117.89533, 33.62496]]], [[[-117.89512, 33.62537], [-117.89436, 33.62602], [-117.89436, 33.62603], [-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.62594], [-117.89455, 33.62546], [-117.89512, 33.62537]]]]} | Open Access 1 | 5956 | North Star Beach | 22859 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 11.265 | North Star Beach | 0 | Local Park 2 | 4 | |
1053 | 1053 | 1052 | {"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.61835], [-117.93036, 33.61789], [-117.93059, 33.61792]]]]} | Open Access 1 | 5654 | Gateway Park | 19238 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.272 | Gateway Park | 0 | Local Park 2 | 4 | |
1287 | 1287 | 1286 | {"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 | 5709 | Newport Shores Park | 22740 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.211 | Newport Shores Park | 0 | Local Park 2 | 4 | |
1304 | 1304 | 1303 | {"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 | 7321 | Bolsa Park | 16247 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.197 | Bolsa Park | 0 | Local Park 2 | 4 | |
1369 | 1369 | 1368 | {"type": "Polygon", "coordinates": [[[-117.90004, 33.60061], [-117.8997, 33.60129], [-117.89766, 33.60064], [-117.89775, 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.89926, 33.60034], [-117.90004, 33.60061]]]} | Open Access 1 | 8249 | Peninsula Park | 23579 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 4.539 | Peninsula Park | 0 | Local Park 2 | 4 | |
1738 | 1738 | 1737 | {"type": "Polygon", "coordinates": [[[-117.84482, 33.61091], [-117.84442, 33.6108], [-117.84419, 33.6107], [-117.84396, 33.61058], [-117.8442, 33.61028], [-117.84435, 33.6102], [-117.84453, 33.61016], [-117.84464, 33.61024], [-117.84461, 33.61032], [-117.84464, 33.61041], [-117.8447, 33.61045], [-117.84478, 33.61046], [-117.84482, 33.61091]]]} | Open Access 1 | 12947 | Spyglass Hill Reservoir Park | 25757 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.949 | Spyglass Hill Reservoir Park | 0 | Local Park 2 | 4 | |
1745 | 1745 | 1744 | {"type": "Polygon", "coordinates": [[[-117.92184, 33.60768], [-117.92172, 33.60823], [-117.92104, 33.60813], [-117.92107, 33.60796], [-117.9206, 33.60789], [-117.92068, 33.60751], [-117.92184, 33.60768]]]} | Open Access 1 | 15014 | Veterans Memorial Park | 27029 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 1.457 | Veterans Memorial Park | 0 | Local Park 2 | 4 | |
2352 | 2352 | 2351 | {"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.85227, 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 | 11189 | San Miguel Park | 24958 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 7.292 | San Miguel Park | 0 | Local Park 2 | 4 | |
2828 | 2828 | 2827 | {"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 | 47419 | Miramar Park | 31136 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.125 | Miramar Park | 0 | Local Park 2 | 4 | |
4093 | 4093 | 4092 | {"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.90352, 33.63246], [-117.90368, 33.63231], [-117.90419, 33.63263]]]} | Open Access 1 | 47498 | Mariners Park and VJ Community Center | 31213 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 7.141 | Mariners Park and VJ Community Ctr. | 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]);