superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
65 rows where ACCESS_TYP = 1, LAYER = 2 and MNG_AGENCY = 52
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1343 | 1343 | 1342 | {"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 | 38th Street Park | 15197 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.922 | 38th Street Park | ||
| 1596 | 1596 | 1595 | {"type": "Polygon", "coordinates": [[[-117.85946, 33.634], [-117.85948, 33.63441], [-117.85935, 33.63552], [-117.8593, 33.63562], [-117.85881, 33.63619], [-117.85882, 33.63629], [-117.85886, 33.63639], [-117.85897, 33.63653], [-117.85908, 33.6366], [-117.85919, 33.63664], [-117.85944, 33.63667], [-117.85941, 33.63701], [-117.85935, 33.637], [-117.85929, 33.63705], [-117.85887, 33.63704], [-117.85886, 33.63702], [-117.85886, 33.63682], [-117.85864, 33.63666], [-117.85845, 33.63648], [-117.85847, 33.63616], [-117.85839, 33.6359], [-117.85816, 33.63579], [-117.85774, 33.63521], [-117.85789, 33.63512], [-117.85802, 33.635], [-117.85815, 33.63486], [-117.85827, 33.63468], [-117.85839, 33.63442], [-117.85849, 33.6341], [-117.85852, 33.63394], [-117.85852, 33.63379], [-117.85849, 33.63353], [-117.85855, 33.63331], [-117.85855, 33.6332], [-117.85852, 33.63308], [-117.85843, 33.63287], [-117.85814, 33.63262], [-117.85808, 33.63219], [-117.85798, 33.63194], [-117.85789, 33.63179], [-117.85751, 33.63134], [-117.85764, 33.63116], [-117.8577, 33.63098], [-117.8577, 33.63074], [-117.85774, 33.63052], [-117.85773, 33.63018], [-117.85778, 33.62994], [-117.85796, 33.62978], [-117.85802, 33.62952], [-117.85859, 33.6296], [-117.85917, 33.62962], [-117.85907, 33.63001], [-117.85881, 33.63027], [-117.85856, 33.6306], [-117.8585, 33.63078], [-117.85849, 33.631], [-117.85853, 33.63122], [-117.85864, 33.63143], [-117.8588, 33.63161], [-117.85906, 33.63183], [-117.85915, 33.63232], [-117.8592, 33.63271], [-117.85925, 33.63289], [-117.85928, 33.6331], [-117.85939, 33.63344], [-117.8594, 33.63379], [-117.85938, 33.63397], [-117.85946, 33.634]]]} | Open Access 1 | Arroyo Park | 15615 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 18.392 | Arroyo Park | ||
| 1714 | 1714 | 1713 | {"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.61554], [-117.89018, 33.61539], [-117.89068, 33.61564], [-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.89112, 33.61462], [-117.891, 33.61454], [-117.89084, 33.6145], [-117.89066, 33.61444], [-117.89044, 33.61441], [-117.89041, 33.61439], [-117.89035, 33.61433], [-117.89018, 33.6143], [-117.89004, 33.61433], [-117.88981, 33.61442], [-117.88968, 33.61453], [-117.88966, 33.61452], [-117.89069, 33.61325], [-117.89077, 33.61318], [-117.89086, 33.61314], [-117.89096, 33.61312], [-117.89107, 33.61312], [-117.89435, 33.61364], [-117.89434, 33.61373], [-117.89514, 33.614]]]} | Open Access 1 | Back Bay View Park | 15751 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 10.657 | Back Bay View Park | ||
| 1737 | 1737 | 1736 | {"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 | Balboa Island Park at Carroll Beek Community Center | 15771 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.279 | Balboa Island Park at Carroll Beek Community Ctr. | ||
| 1805 | 1805 | 1804 | {"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 | Bayview Park | 15902 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1.991 | Bayview Park | ||
| 1843 | 1843 | 1842 | {"type": "MultiPolygon", "coordinates": [[[[-117.87277, 33.59691], [-117.87259, 33.59708], [-117.87225, 33.5969], [-117.87241, 33.59671], [-117.87277, 33.59691]]], [[[-117.87361, 33.59735], [-117.87343, 33.59752], [-117.87272, 33.59715], [-117.8729, 33.59698], [-117.8734, 33.59722], [-117.87361, 33.59735]]], [[[-117.87442, 33.59782], [-117.87425, 33.59799], [-117.87356, 33.59762], [-117.87372, 33.59744], [-117.87442, 33.59782]]], [[[-117.87765, 33.59996], [-117.87753, 33.60014], [-117.8752, 33.59854], [-117.87436, 33.59808], [-117.87453, 33.59788], [-117.87536, 33.59825], [-117.87553, 33.59837], [-117.87609, 33.59883], [-117.87627, 33.59901], [-117.87639, 33.59916], [-117.87674, 33.59945], [-117.8774, 33.59978], [-117.87764, 33.59992], [-117.87765, 33.59996]]]]} | Open Access 1 | Bayside Park | 15897 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 3.524 | Bayside Park | ||
| 1900 | 1900 | 1899 | {"type": "Polygon", "coordinates": [[[-117.8785, 33.60028], [-117.87806, 33.60073], [-117.87786, 33.60084], [-117.87749, 33.60122], [-117.87699, 33.60086], [-117.87695, 33.60081], [-117.87698, 33.60076], [-117.87721, 33.60066], [-117.87743, 33.60053], [-117.87756, 33.60038], [-117.8778, 33.60002], [-117.87786, 33.60001], [-117.87806, 33.60003], [-117.87847, 33.59996], [-117.87837, 33.60002], [-117.87828, 33.60017], [-117.8785, 33.60028]]]} | Open Access 1 | Begonia Park | 15955 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 2.147 | Begonia Park | ||
| 1995 | 1995 | 1994 | {"type": "Polygon", "coordinates": [[[-117.88503, 33.63009], [-117.88492, 33.63054], [-117.88457, 33.63087], [-117.8844, 33.63098], [-117.88427, 33.63103], [-117.8841, 33.63106], [-117.88263, 33.63112], [-117.88253, 33.63115], [-117.88207, 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.88468, 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.88026, 33.6317], [-117.87975, 33.63121], [-117.87955, 33.63087], [-117.87928, 33.63058], [-117.87925, 33.63028], [-117.87851, 33.62913], [-117.87825, 33.629], [-117.87804, 33.62901], [-117.87801, 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.8811, 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.62992], [-117.8842, 33.62989], [-117.88503, 33.63009]]]} | Open Access 1 | Big Canyon Park | 16076 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 39.154 | Big Canyon Park | ||
| 2100 | 2100 | 2099 | {"type": "Polygon", "coordinates": [[[-117.90617, 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.90521, 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.62235], [-117.90459, 33.62216], [-117.90464, 33.62211], [-117.90487, 33.62202], [-117.90505, 33.62201], [-117.90507, 33.62198], [-117.90537, 33.622], [-117.90558, 33.62205], [-117.90616, 33.62228], [-117.90617, 33.62234]]]} | Open Access 1 | Bob Henry Park | 16208 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 5.104 | Bob Henry Park | ||
| 2128 | 2128 | 2127 | {"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 | Bolsa Park | 16247 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.197 | Bolsa Park | ||
| 2143 | 2143 | 2142 | {"type": "MultiPolygon", "coordinates": [[[[-117.85528, 33.62737], [-117.85512, 33.62771], [-117.85494, 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.85037, 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.85802, 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.85964, 33.62877], [-117.86099, 33.62921]]], [[[-117.86191, 33.62918], [-117.86119, 33.62842], [-117.86097, 33.62824], [-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.62198], [-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.86103, 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 | Bonita Canyon Sports Park | 16258 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 44.726 | Bonita Canyon Sports Park | ||
| 2348 | 2348 | 2347 | {"type": "MultiPolygon", "coordinates": [[[[-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.62241], [-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.62418], [-117.85593, 33.62441], [-117.856, 33.62443], [-117.85599, 33.62454], [-117.85612, 33.62456], [-117.85613, 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.85562, 33.62669], [-117.85567, 33.62642], [-117.85575, 33.6264], [-117.85581, 33.62637], [-117.85587, 33.62629], [-117.85588, 33.62622], [-117.85586, 33.62613], [-117.8559, 33.6259], [-117.85596, 33.62575], [-117.85595, 33.62567], [-117.85592, 33.62562], [-117.8558, 33.62555], [-117.85589, 33.62504], [-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.85534, 33.62383], [-117.85509, 33.62379], [-117.85513, 33.6235], [-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.85497, 33.62261], [-117.85503, 33.62236], [-117.85502, 33.62206], [-117.85507, 33.62202], [-117.8551, 33.62196], [-117.8551, 33.62179], [-117.85514, 33.62155], [-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]]], [[[-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.61673], [-117.85957, 33.61688], [-117.85955, 33.61696], [-117.85946, 33.61697], [-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.61758], [-117.85859, 33.61761], [-117.85848, 33.6177], [-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.85798, 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.85703, 33.61979], [-117.85705, 33.61989], [-117.85667, 33.62021], [-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.61931], [-117.85705, 33.61929], [-117.8574, 33.61888], [-117.85739, 33.61879], [-117.85746, 33.61878], [-117.85753, 33.61873], [-117.85793, 33.61824], [-117.85795, 33.61817], [-117.85793, 33.61811], [-117.85774, 33.61794], [-117.8582, 33.61756], [-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]]]]} | Open Access 1 | Buffalo Hills Park | 16498 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 22.418 | Buffalo Hills Park | ||
| 2685 | 2685 | 2684 | {"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.62093], [-117.90562, 33.62083], [-117.9045, 33.61996], [-117.90504, 33.61924], [-117.90515, 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 | Castaways Park | 16947 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 16.769 | Castaways Park | ||
| 2831 | 2831 | 2830 | {"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 | Channel Place Park | 17122 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1.279 | Channel Place Park | ||
| 3022 | 3022 | 3021 | {"type": "MultiPolygon", "coordinates": [[[[-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.92334, 33.62226], [-117.9237, 33.6228], [-117.9237, 33.62326]]], [[[-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 | Cliff Drive Park | 17424 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 4.15 | Cliff Drive Park | ||
| 3061 | 3061 | 3060 | {"type": "MultiPolygon", "coordinates": [[[[-117.80272, 33.60494], [-117.80257, 33.60508], [-117.80245, 33.60522], [-117.80236, 33.60538], [-117.80228, 33.60563], [-117.80219, 33.60568], [-117.80193, 33.6057], [-117.80176, 33.60564], [-117.80168, 33.60564], [-117.80161, 33.60568], [-117.80157, 33.60574], [-117.80156, 33.60578], [-117.80153, 33.60578], [-117.80122, 33.60547], [-117.80127, 33.60546], [-117.80142, 33.60537], [-117.80164, 33.60534], [-117.80203, 33.60512], [-117.80219, 33.60512], [-117.80221, 33.60509], [-117.8023, 33.60507], [-117.80232, 33.60503], [-117.80247, 33.60504], [-117.80272, 33.60494]]], [[[-117.80538, 33.60332], [-117.80535, 33.60351], [-117.80537, 33.6037], [-117.80536, 33.60374], [-117.80524, 33.60397], [-117.80519, 33.60412], [-117.80486, 33.60453], [-117.80474, 33.60472], [-117.80445, 33.60547], [-117.80441, 33.60562], [-117.80439, 33.60581], [-117.80437, 33.60585], [-117.80431, 33.60587], [-117.80416, 33.60587], [-117.80399, 33.60582], [-117.80346, 33.6057], [-117.80295, 33.60565], [-117.80256, 33.60565], [-117.80248, 33.60557], [-117.80252, 33.60547], [-117.80261, 33.6053], [-117.80272, 33.60518], [-117.80355, 33.60448], [-117.80376, 33.60428], [-117.8039, 33.6041], [-117.80403, 33.60388], [-117.80425, 33.60324], [-117.80434, 33.60303], [-117.8044, 33.60295], [-117.80455, 33.60296], [-117.8047, 33.60298], [-117.80484, 33.60304], [-117.80536, 33.60328], [-117.80538, 33.60332]]]]} | Open Access 1 | Coastal Peak Park | 17465 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 11.204 | Coastal Peak Park | ||
| 3805 | 3805 | 3804 | {"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 | Eastbluff Park | 18389 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 13.734 | Eastbluff Park | ||
| 4038 | 4038 | 4037 | {"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.62031], [-117.92089, 33.62015], [-117.92158, 33.62047]]]} | Open Access 1 | Ensign View Park | 18682 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 2.136 | Ensign View Park | ||
| 4464 | 4464 | 4463 | {"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 | Galaxy View Park | 19171 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.948 | Galaxy View Park | ||
| 4523 | 4523 | 4522 | {"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.61834], [-117.93036, 33.61789], [-117.93059, 33.61792]]]]} | Open Access 1 | Gateway Park | 19238 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.272 | Gateway 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]);