units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
50 rows where DES_TP = 2 and MNG_AGENCY = 52 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 50
MNG_AGENCY 1
- Newport Beach, City of · 50 ✖
DES_TP 1
- Local Park · 50 ✖
ACCESS_TYP 1
- Open Access 50
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
6858 | 6858 | 6857 | {"type": "Polygon", "coordinates": [[[-117.85946, 33.634], [-117.85948, 33.63441], [-117.85935, 33.63552], [-117.8593, 33.63562], [-117.85881, 33.63618], [-117.85882, 33.63629], [-117.85886, 33.63639], [-117.85897, 33.63653], [-117.85908, 33.6366], [-117.8592, 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.63443], [-117.85849, 33.6341], [-117.85852, 33.63394], [-117.85852, 33.63379], [-117.85849, 33.63353], [-117.85855, 33.63332], [-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.63115], [-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.85882, 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 | 5492 | Arroyo Park | 15615 | 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 | 18.387 | Arroyo 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 | |
6519 | 6519 | 6518 | {"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 | 2757 | Bayside Park | 15897 | 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 | 3.525 | Bayside 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 | |
6550 | 6550 | 6549 | {"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.87827, 33.60018], [-117.8785, 33.60028]]]} | Open Access 1 | 3277 | Begonia Park | 15955 | 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.145 | Begonia 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
5299 | 5299 | 5298 | {"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.80242, 33.60505], [-117.80248, 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.60398], [-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.80417, 33.60587], [-117.80399, 33.60582], [-117.80347, 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 | 4555 | Coastal Peak Park | 17465 | 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.202 | Coastal Peak 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 | |
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 | |
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 | |
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 | |
6267 | 6267 | 6266 | {"type": "Polygon", "coordinates": [[[-117.86393, 33.6158], [-117.86396, 33.61584], [-117.86399, 33.61608], [-117.86385, 33.61657], [-117.86336, 33.6171], [-117.86315, 33.61702], [-117.86293, 33.61695], [-117.86265, 33.6169], [-117.86252, 33.61689], [-117.86252, 33.61682], [-117.8628, 33.61672], [-117.8628, 33.6167], [-117.86293, 33.6166], [-117.86304, 33.61648], [-117.8631, 33.61623], [-117.86307, 33.61615], [-117.86283, 33.61601], [-117.8627, 33.616], [-117.8624, 33.61583], [-117.86207, 33.61531], [-117.86174, 33.61544], [-117.86165, 33.61527], [-117.86197, 33.61514], [-117.8619, 33.61498], [-117.86172, 33.61469], [-117.86085, 33.61396], [-117.86081, 33.61389], [-117.86068, 33.61383], [-117.85994, 33.61332], [-117.86117, 33.61313], [-117.86149, 33.61351], [-117.86182, 33.61382], [-117.86215, 33.614], [-117.86221, 33.61409], [-117.86235, 33.61453], [-117.86264, 33.61493], [-117.86286, 33.61544], [-117.86305, 33.61551], [-117.86377, 33.61562], [-117.86389, 33.61581], [-117.86393, 33.6158]]]} | Open Access 1 | 1398 | Harbor View Nature Park | 19667 | 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.037 | Harbor View Nature Park | 0 | Local Park 2 | 4 | |
6480 | 6480 | 6479 | {"type": "Polygon", "coordinates": [[[-117.88244, 33.60781], [-117.88204, 33.60814], [-117.88177, 33.60826], [-117.88164, 33.60833], [-117.88166, 33.60837], [-117.88145, 33.60853], [-117.88142, 33.60852], [-117.88129, 33.60865], [-117.88132, 33.60869], [-117.88122, 33.60882], [-117.88116, 33.609], [-117.88112, 33.60904], [-117.87903, 33.6076], [-117.87967, 33.60695], [-117.87971, 33.60694], [-117.88115, 33.60734], [-117.88169, 33.60757], [-117.88244, 33.60781]]]} | Open Access 1 | 2293 | Irvine Terrace Park | 20271 | 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 | 8.547 | Irvine Terrace 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]);