units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
64 rows where AGNCY_LEV = 2 and MNG_AGENCY = 52 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
DES_TP 5
- Local Park 37
- Local Recreation Area 4
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 44
MNG_AGENCY 1
- Newport Beach, City of · 44 ✖
ACCESS_TYP 1
- Open Access 44
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);