units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
65 rows where MNG_AGENCY = 52 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14510 | 14510 | 14509 | {"type": "Polygon", "coordinates": [[[-117.86267, 33.64909], [-117.86194, 33.64709], [-117.86197, 33.64568], [-117.862, 33.64568], [-117.862, 33.64573], [-117.86204, 33.64578], [-117.86211, 33.64582], [-117.86267, 33.64583], [-117.86309, 33.6458], [-117.86336, 33.64575], [-117.86363, 33.64567], [-117.86368, 33.64567], [-117.86372, 33.6457], [-117.8638, 33.64593], [-117.86392, 33.64669], [-117.86398, 33.64689], [-117.86406, 33.64708], [-117.86447, 33.64777], [-117.86448, 33.64781], [-117.86446, 33.64784], [-117.86439, 33.64789], [-117.86428, 33.64793], [-117.86413, 33.64804], [-117.86405, 33.64814], [-117.86313, 33.6488], [-117.86267, 33.64909]]]} | Open Access 1 | 47406 | Bonita Creek Park and Community Center | 31123 | 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 | 14.269 | Bonita Creek Park and Community Ctr. | 0 | Local Recreation Area 3 | 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 | |
12790 | 12790 | 12789 | {"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 | 30221 | Orchard Drive Park | 23186 | 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.184 | Orchard Drive Park | 0 | Local Park 2 | 4 | |
12789 | 12789 | 12788 | {"type": "Polygon", "coordinates": [[[-117.87971, 33.65599], [-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.65599]]]} | Open Access 1 | 30220 | Mesa Birch Park | 22172 | 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.707 | Mesa Birch Park | 0 | Local Park 2 | 4 | |
12788 | 12788 | 12787 | {"type": "Polygon", "coordinates": [[[-117.87411, 33.65187], [-117.87364, 33.65234], [-117.87338, 33.65216], [-117.87333, 33.65216], [-117.87331, 33.65209], [-117.87326, 33.65206], [-117.87319, 33.65205], [-117.87312, 33.65208], [-117.87308, 33.65213], [-117.87307, 33.65218], [-117.87281, 33.65212], [-117.87253, 33.65194], [-117.87254, 33.65162], [-117.87276, 33.65157], [-117.87298, 33.65154], [-117.87336, 33.65157], [-117.8736, 33.65162], [-117.87377, 33.65168], [-117.87393, 33.65176], [-117.87411, 33.65187]]]} | Open Access 1 | 30219 | Bayview Park | 15902 | 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.991 | Bayview Park | 0 | Local Park 2 | 4 | |
10610 | 10610 | 10609 | {"type": "Polygon", "coordinates": [[[-117.88288, 33.6414], [-117.88255, 33.6417], [-117.88232, 33.64203], [-117.8822, 33.64229], [-117.88213, 33.64252], [-117.88209, 33.64277], [-117.88204, 33.64279], [-117.88185, 33.64279], [-117.88179, 33.64221], [-117.88156, 33.64162], [-117.88149, 33.6415], [-117.87839, 33.64039], [-117.87718, 33.64097], [-117.8771, 33.64072], [-117.87709, 33.64054], [-117.87711, 33.64036], [-117.87717, 33.64019], [-117.87748, 33.63961], [-117.87767, 33.63936], [-117.87774, 33.63928], [-117.87791, 33.63914], [-117.87817, 33.63898], [-117.87842, 33.63888], [-117.87876, 33.6388], [-117.87922, 33.64009], [-117.88288, 33.6414]]]} | Open Access 1 | 18893 | Eastbluff Park | 18389 | 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 | 13.725 | Eastbluff Park | 0 | Local Park 2 | 4 | |
10317 | 10317 | 10316 | {"type": "MultiPolygon", "coordinates": [[[[-117.8706, 33.59013], [-117.87007, 33.59064], [-117.86982, 33.5906], [-117.86959, 33.59053], [-117.8691, 33.59032], [-117.869, 33.59031], [-117.86885, 33.59034], [-117.86877, 33.5904], [-117.86871, 33.5905], [-117.86868, 33.59094], [-117.86866, 33.59102], [-117.86861, 33.59106], [-117.86852, 33.5911], [-117.86843, 33.59106], [-117.86835, 33.59042], [-117.86852, 33.59], [-117.86847, 33.5899], [-117.86856, 33.58971], [-117.8687, 33.58967], [-117.8688, 33.58974], [-117.86914, 33.5899], [-117.87023, 33.59023], [-117.87031, 33.59023], [-117.87038, 33.59021], [-117.87057, 33.5901], [-117.8706, 33.59013]]], [[[-117.87892, 33.59465], [-117.87812, 33.59539], [-117.87812, 33.59531], [-117.87806, 33.59527], [-117.87806, 33.59524], [-117.87775, 33.59511], [-117.87751, 33.5951], [-117.87731, 33.59512], [-117.87749, 33.59492], [-117.87749, 33.59491], [-117.8774, 33.5949], [-117.87659, 33.59464], [-117.87665, 33.59455], [-117.87628, 33.59442], [-117.87591, 33.59438], [-117.87523, 33.59415], [-117.87502, 33.59405], [-117.87474, 33.59381], [-117.8746, 33.59372], [-117.87347, 33.59324], [-117.87344, 33.59319], [-117.87347, 33.59314], [-117.87347, 33.59313], [-117.87336, 33.5931], [-117.87331, 33.59312], [-117.87326, 33.59315], [-117.87292, 33.593], [-117.87227, 33.59253], [-117.87219, 33.59241], [-117.87283, 33.59177], [-117.87592, 33.59277], [-117.87567, 33.59302], [-117.87567, 33.59304], [-117.87609, 33.59303], [-117.87629, 33.59301], [-117.87655, 33.59295], [-117.87738, 33.59271], [-117.87752, 33.59264], [-117.87777, 33.59345], [-117.87737, 33.59387], [-117.87833, 33.59418], [-117.87892, 33.59465]]], [[[-117.879, 33.5953], [-117.87875, 33.59556], [-117.87849, 33.59528], [-117.87876, 33.59503], [-117.879, 33.5953]]], [[[-117.87931, 33.59682], [-117.87926, 33.59686], [-117.87883, 33.59624], [-117.87918, 33.59589], [-117.87931, 33.59682]]], [[[-117.8791, 33.59522], [-117.87897, 33.59509], [-117.87907, 33.59499], [-117.87907, 33.59499], [-117.8791, 33.59522]]], [[[-117.92258, 33.605], [-117.92234, 33.60631], [-117.9205, 33.60596], [-117.91953, 33.60583], [-117.91983, 33.60447], [-117.92177, 33.60487], [-117.92258, 33.605]]]]} | Open Access 1 | 18153 | Corona del Mar State Beach | 30629 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.parks.ca.gov/default.asp?page_id=652 | Orange 3 | 35.886 | Corona del Mar SB | 1947 | None 903 | |
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 | |
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 | |
9196 | 9196 | 9195 | {"type": "MultiPolygon", "coordinates": [[[[-117.94969, 33.62624], [-117.94958, 33.62636], [-117.94798, 33.62544], [-117.94766, 33.6253], [-117.94733, 33.6252], [-117.94731, 33.62523], [-117.94706, 33.62519], [-117.9469, 33.62513], [-117.94687, 33.62515], [-117.94658, 33.62509], [-117.94645, 33.6251], [-117.94609, 33.62504], [-117.94592, 33.62478], [-117.94549, 33.62395], [-117.94576, 33.6241], [-117.9462, 33.62432], [-117.9486, 33.62565], [-117.94891, 33.6258], [-117.94969, 33.62624]]], [[[-117.95249, 33.62804], [-117.95195, 33.62773], [-117.94969, 33.62643], [-117.9498, 33.62629], [-117.95143, 33.6272], [-117.95259, 33.62791], [-117.95259, 33.62793], [-117.95249, 33.62804]]], [[[-117.95641, 33.63022], [-117.95636, 33.63028], [-117.95425, 33.62911], [-117.95263, 33.62812], [-117.95273, 33.62801], [-117.95275, 33.628], [-117.95641, 33.63022]]]]} | Open Access 1 | 15264 | West Newport Park | 27370 | 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 | 6.289 | West Newport Park | 0 | Local Park 2 | 4 | |
9191 | 9191 | 9190 | {"type": "Polygon", "coordinates": [[[-117.88213, 33.59545], [-117.88199, 33.59549], [-117.88212, 33.59589], [-117.88179, 33.59596], [-117.8815, 33.59507], [-117.88175, 33.59512], [-117.88176, 33.59507], [-117.8818, 33.59508], [-117.88182, 33.59513], [-117.88205, 33.5952], [-117.88213, 33.59545]]]} | Open Access 1 | 15256 | West Jetty View Park | 27365 | 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.855 | West Jetty View 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 | |
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 | |
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 | |
8350 | 8350 | 8349 | {"type": "Polygon", "coordinates": [[[-117.84757, 33.61287], [-117.84709, 33.61286], [-117.84708, 33.61282], [-117.84703, 33.6128], [-117.8469, 33.61279], [-117.84658, 33.61231], [-117.84724, 33.61224], [-117.84742, 33.61225], [-117.84764, 33.6123], [-117.84767, 33.61232], [-117.84768, 33.61236], [-117.84757, 33.61287]]]} | Open Access 1 | 12935 | Spyglass Hill Park | 25756 | 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.299 | Spyglass Hill Park | 0 | Local Park 2 | 4 | |
8291 | 8291 | 8290 | {"type": "MultiPolygon", "coordinates": [[[[-117.86159, 33.61556], [-117.86096, 33.61581], [-117.86073, 33.61601], [-117.86063, 33.61601], [-117.86055, 33.61605], [-117.8601, 33.61644], [-117.86006, 33.61649], [-117.86006, 33.61655], [-117.85982, 33.61676], [-117.85976, 33.61672], [-117.85957, 33.61689], [-117.85955, 33.61696], [-117.85946, 33.61696], [-117.8594, 33.61699], [-117.85893, 33.61739], [-117.85889, 33.61743], [-117.85888, 33.61751], [-117.85889, 33.61756], [-117.85893, 33.61761], [-117.85875, 33.61746], [-117.85859, 33.61759], [-117.85859, 33.6176], [-117.85847, 33.61771], [-117.85853, 33.61776], [-117.85843, 33.61784], [-117.85868, 33.61805], [-117.85866, 33.61807], [-117.85864, 33.61815], [-117.85855, 33.61815], [-117.85849, 33.61817], [-117.85801, 33.61858], [-117.85798, 33.61863], [-117.85799, 33.61871], [-117.8579, 33.61873], [-117.85773, 33.61887], [-117.85773, 33.61889], [-117.85778, 33.61893], [-117.85759, 33.6191], [-117.85758, 33.61929], [-117.85752, 33.61932], [-117.85708, 33.6197], [-117.85702, 33.61979], [-117.85705, 33.61989], [-117.85667, 33.62022], [-117.85649, 33.6203], [-117.85633, 33.62051], [-117.8559, 33.62028], [-117.85607, 33.62006], [-117.85626, 33.62016], [-117.8564, 33.61997], [-117.85638, 33.61984], [-117.85647, 33.61978], [-117.85685, 33.61937], [-117.85688, 33.6193], [-117.85705, 33.61929], [-117.8574, 33.61888], [-117.85739, 33.61879], [-117.85746, 33.61878], [-117.85752, 33.61873], [-117.85793, 33.61824], [-117.85795, 33.61817], [-117.85792, 33.6181], [-117.85774, 33.61794], [-117.8582, 33.61755], [-117.85829, 33.61757], [-117.85839, 33.61754], [-117.85955, 33.61655], [-117.8596, 33.61648], [-117.85979, 33.61646], [-117.86015, 33.61615], [-117.86018, 33.61596], [-117.86071, 33.61551], [-117.86088, 33.61558], [-117.86109, 33.6154], [-117.86143, 33.61527], [-117.86159, 33.61556]]], [[[-117.8571, 33.62114], [-117.85688, 33.62151], [-117.85679, 33.62161], [-117.85675, 33.62185], [-117.85667, 33.62186], [-117.8566, 33.62188], [-117.85653, 33.62194], [-117.8565, 33.62199], [-117.85651, 33.62216], [-117.85646, 33.62242], [-117.85641, 33.62256], [-117.85643, 33.62262], [-117.85646, 33.62267], [-117.85652, 33.62271], [-117.85658, 33.62273], [-117.85651, 33.62299], [-117.8566, 33.62324], [-117.85651, 33.62329], [-117.85646, 33.62337], [-117.85646, 33.62352], [-117.85643, 33.62376], [-117.85637, 33.62392], [-117.85638, 33.62398], [-117.85643, 33.62405], [-117.85634, 33.62412], [-117.85614, 33.6241], [-117.85612, 33.62418], [-117.85597, 33.62417], [-117.85593, 33.62442], [-117.856, 33.62443], [-117.85598, 33.62454], [-117.85612, 33.62456], [-117.85612, 33.6246], [-117.8562, 33.62461], [-117.85622, 33.62457], [-117.85642, 33.6246], [-117.85641, 33.62461], [-117.85633, 33.62462], [-117.85623, 33.62466], [-117.85618, 33.62472], [-117.85616, 33.62478], [-117.85618, 33.62492], [-117.85613, 33.62519], [-117.85608, 33.62533], [-117.85611, 33.62542], [-117.85619, 33.62549], [-117.85615, 33.62575], [-117.85619, 33.62606], [-117.85613, 33.62615], [-117.85613, 33.6263], [-117.85608, 33.62655], [-117.85602, 33.62669], [-117.85603, 33.62678], [-117.85606, 33.62683], [-117.85601, 33.62687], [-117.85578, 33.62714], [-117.85454, 33.62674], [-117.85457, 33.62657], [-117.85563, 33.62669], [-117.85567, 33.62642], [-117.85575, 33.6264], [-117.85581, 33.62637], [-117.85587, 33.62629], [-117.85588, 33.62623], [-117.85586, 33.62613], [-117.8559, 33.62589], [-117.85596, 33.62575], [-117.85595, 33.62567], [-117.85592, 33.62562], [-117.85587, 33.62558], [-117.8558, 33.62555], [-117.85589, 33.62503], [-117.85578, 33.62496], [-117.85581, 33.62488], [-117.8558, 33.62476], [-117.85584, 33.6245], [-117.8559, 33.62436], [-117.8559, 33.62427], [-117.85584, 33.62419], [-117.85575, 33.62415], [-117.85531, 33.62409], [-117.85535, 33.62383], [-117.85509, 33.62379], [-117.85514, 33.62349], [-117.85503, 33.62343], [-117.85506, 33.62335], [-117.85505, 33.62323], [-117.85509, 33.62298], [-117.85516, 33.6228], [-117.85514, 33.62271], [-117.8551, 33.62266], [-117.85504, 33.62263], [-117.85497, 33.62261], [-117.85503, 33.62237], [-117.85502, 33.62206], [-117.85507, 33.62202], [-117.8551, 33.62196], [-117.8551, 33.62179], [-117.85514, 33.62154], [-117.85519, 33.62143], [-117.85519, 33.62137], [-117.85535, 33.62126], [-117.8554, 33.621], [-117.85536, 33.6207], [-117.85541, 33.62064], [-117.85542, 33.62055], [-117.8555, 33.62053], [-117.85564, 33.62035], [-117.8571, 33.62114]]]]} | Open Access 1 | 12684 | Buffalo Hills Park | 16498 | 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 | 22.386 | Buffalo Hills Park | 0 | Local Park 2 | 4 | |
7710 | 7710 | 7709 | {"type": "MultiPolygon", "coordinates": [[[[-117.85528, 33.62737], [-117.85512, 33.62771], [-117.85493, 33.62817], [-117.85485, 33.62821], [-117.85431, 33.62807], [-117.85385, 33.62797], [-117.85346, 33.62791], [-117.85297, 33.62786], [-117.85262, 33.62785], [-117.85196, 33.62787], [-117.85144, 33.62793], [-117.85086, 33.62804], [-117.84982, 33.6283], [-117.84977, 33.62827], [-117.84956, 33.6274], [-117.8496, 33.62734], [-117.85038, 33.62707], [-117.85038, 33.62705], [-117.85084, 33.62693], [-117.85128, 33.62684], [-117.85167, 33.62679], [-117.85241, 33.62675], [-117.8531, 33.62677], [-117.85392, 33.62689], [-117.8541, 33.62692], [-117.85442, 33.627], [-117.85523, 33.62726], [-117.85528, 33.62737]]], [[[-117.86099, 33.62921], [-117.85988, 33.62926], [-117.85987, 33.62924], [-117.85905, 33.62926], [-117.85843, 33.62921], [-117.85801, 33.62915], [-117.858, 33.62917], [-117.85748, 33.62906], [-117.85688, 33.62887], [-117.85641, 33.6287], [-117.85616, 33.62859], [-117.85537, 33.62835], [-117.85528, 33.62827], [-117.85563, 33.62746], [-117.85574, 33.62742], [-117.85622, 33.62759], [-117.85778, 33.6279], [-117.85833, 33.62799], [-117.85992, 33.62813], [-117.85963, 33.62876], [-117.86099, 33.62921]]], [[[-117.86191, 33.62918], [-117.86118, 33.62842], [-117.86097, 33.62823], [-117.86069, 33.62805], [-117.86033, 33.62792], [-117.86016, 33.62788], [-117.86035, 33.62761], [-117.86067, 33.62697], [-117.86081, 33.62647], [-117.86078, 33.62612], [-117.86074, 33.62521], [-117.86068, 33.62474], [-117.86023, 33.62329], [-117.86013, 33.62198], [-117.86037, 33.62199], [-117.86042, 33.62174], [-117.86048, 33.62129], [-117.86055, 33.62104], [-117.8603, 33.62065], [-117.86052, 33.62055], [-117.86071, 33.62036], [-117.86076, 33.62029], [-117.86084, 33.6201], [-117.86093, 33.6198], [-117.86147, 33.61991], [-117.86116, 33.62058], [-117.86105, 33.62093], [-117.86089, 33.62157], [-117.86083, 33.62201], [-117.8608, 33.62277], [-117.86083, 33.62325], [-117.86092, 33.6238], [-117.86102, 33.62428], [-117.86131, 33.62535], [-117.86158, 33.62667], [-117.86184, 33.62781], [-117.86212, 33.62888], [-117.86212, 33.62902], [-117.8621, 33.62908], [-117.86201, 33.62915], [-117.86191, 33.62918]]]]} | Open Access 1 | 7785 | Bonita Canyon Sports Park | 16258 | 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 | 44.715 | Bonita Canyon Sports Park | 0 | Local Recreation Area 3 | 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 | |
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 | |
6884 | 6884 | 6883 | {"type": "MultiPolygon", "coordinates": [[[[-117.9237, 33.6228], [-117.9237, 33.62326], [-117.92361, 33.6234], [-117.92352, 33.62348], [-117.92347, 33.62349], [-117.92332, 33.62349], [-117.92317, 33.62339], [-117.92316, 33.62333], [-117.92317, 33.62316], [-117.92309, 33.62302], [-117.92296, 33.62292], [-117.9228, 33.62287], [-117.92264, 33.62286], [-117.92247, 33.62291], [-117.92216, 33.62314], [-117.92203, 33.62321], [-117.92177, 33.62327], [-117.92158, 33.62328], [-117.92137, 33.62325], [-117.92123, 33.6232], [-117.92119, 33.62318], [-117.92117, 33.62314], [-117.92118, 33.6231], [-117.92136, 33.62291], [-117.92148, 33.62285], [-117.92198, 33.62287], [-117.92221, 33.62285], [-117.92258, 33.62276], [-117.92295, 33.62254], [-117.92316, 33.62235], [-117.92335, 33.62213], [-117.92333, 33.62226], [-117.9237, 33.6228]]], [[[-117.92517, 33.6225], [-117.92411, 33.62251], [-117.92393, 33.62196], [-117.92421, 33.62206], [-117.92446, 33.62211], [-117.92481, 33.6221], [-117.9251, 33.62204], [-117.92517, 33.6225]]]]} | Open Access 1 | 5621 | Cliff Drive Park | 17424 | 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.149 | Cliff Drive Park | 0 | Local Park 2 | 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]);