units_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)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST, GAP_STS
DES_TP 10
- 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
- None 1
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 | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
9223 | 9223 | 9222 | {"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 | 15344 | Channel Place Park | 17122 | 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.279 | Channel Place Park | 0 | Local Park 2 | 4 | |
4848 | 4848 | 4847 | {"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.93665, 33.62356], [-117.93691, 33.62355], [-117.93729, 33.62357], [-117.93748, 33.62359], [-117.93748, 33.62363]]]} | Open Access 1 | 47424 | Sunset Ridge Park | 31140 | 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.077 | Sunset Ridge Park | 0 | Local Park 2 | 4 | |
8905 | 8905 | 8904 | {"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 | 14605 | Sunset View Park | 26068 | 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.806 | Sunset View Park | 0 | Local Park 2 | 4 | |
7314 | 7314 | 7313 | {"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 | 6628 | 38th Street Park | 15197 | 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.922 | 38th Street Park | 0 | Local Park 2 | 4 | |
5373 | 5373 | 5372 | {"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 | 5699 | Newport Island Park | 22737 | 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.329 | Newport Island Park | 0 | Local Park 2 | 4 | |
6326 | 6326 | 6325 | {"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 | 47414 | Lake Street Park | 31130 | 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.059 | Lake Street Park | 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 | |
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 | |
4134 | 4134 | 4133 | {"type": "Polygon", "coordinates": [[[-117.92489, 33.60778], [-117.92468, 33.60878], [-117.92225, 33.60844], [-117.92237, 33.60782], [-117.92183, 33.60774], [-117.92183, 33.60768], [-117.92168, 33.60766], [-117.92169, 33.6076], [-117.92144, 33.60757], [-117.9215, 33.6073], [-117.92489, 33.60778]]]} | Open Access 1 | 47418 | Marina Park | 31135 | 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.25 | Marina 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 | |
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 | |
13911 | 13911 | 13910 | {"type": "Polygon", "coordinates": [[[-117.92126, 33.61221], [-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.61221]]]} | Open Access 1 | 36516 | Newport Beach holding 1 | 22733 | 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.098 | Newport Beach holding 1 | 0 | Local Other or Unknown 14 | 4 | |
6530 | 6530 | 6529 | {"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 | 2892 | Kings Road Park | 20664 | 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.409 | Kings Road Park | 0 | Local Park 2 | 4 | |
8925 | 8925 | 8924 | {"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.62094], [-117.90562, 33.62083], [-117.9045, 33.61996], [-117.90504, 33.61924], [-117.90516, 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 | 14661 | Castaways Park | 16947 | 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 | 16.767 | Castaways Park | 0 | Local Park 2 | 4 | |
7098 | 7098 | 7097 | {"type": "Polygon", "coordinates": [[[-117.90618, 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.90522, 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.62236], [-117.90459, 33.62217], [-117.90464, 33.62211], [-117.90487, 33.62202], [-117.90506, 33.62201], [-117.90506, 33.62198], [-117.90537, 33.622], [-117.90558, 33.62205], [-117.90616, 33.62228], [-117.90618, 33.62234]]]} | Open Access 1 | 6150 | Bob Henry Park | 16208 | 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 | 5.104 | Bob Henry 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 | |
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 | |
9199 | 9199 | 9198 | {"type": "Polygon", "coordinates": [[[-117.89951, 33.62209], [-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.89738, 33.62307], [-117.89734, 33.62311], [-117.89731, 33.62317], [-117.89733, 33.62325], [-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.89848, 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.62209]]]} | Open Access 1 | 15290 | Westcliff Park | 27387 | 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.984 | Westcliff Park | 0 | Local Park 2 | 4 | |
8844 | 8844 | 8843 | {"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 | 14438 | Balboa Island Park at Carroll Beek Community Center | 15771 | 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.279 | Balboa Island Park at Carroll Beek 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]);