units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
50 rows where DES_TP = 2, MNG_AGENCY = 52 and MNG_AG_TYP = 2 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
6321 | 6321 | 6320 | {"type": "MultiPolygon", "coordinates": [[[[-117.87072, 33.61203], [-117.86969, 33.61297], [-117.86943, 33.61322], [-117.8692, 33.61349], [-117.86893, 33.61389], [-117.86882, 33.6139], [-117.86845, 33.61374], [-117.86875, 33.61344], [-117.86902, 33.61312], [-117.86938, 33.61262], [-117.86949, 33.61244], [-117.86946, 33.61223], [-117.8698, 33.61162], [-117.86988, 33.6116], [-117.87012, 33.61165], [-117.87035, 33.61172], [-117.87057, 33.61181], [-117.87059, 33.61194], [-117.87072, 33.61203]], [[-117.86977, 33.61244], [-117.86973, 33.61238], [-117.8696, 33.61245], [-117.86957, 33.6125], [-117.86957, 33.61257], [-117.86951, 33.6127], [-117.86945, 33.61277], [-117.86927, 33.61293], [-117.86916, 33.6131], [-117.86909, 33.61318], [-117.86899, 33.61325], [-117.86895, 33.61331], [-117.86896, 33.61336], [-117.86901, 33.61339], [-117.86907, 33.61336], [-117.86915, 33.61328], [-117.86918, 33.6132], [-117.86932, 33.61303], [-117.86936, 33.61299], [-117.86956, 33.61288], [-117.86967, 33.61278], [-117.86973, 33.61271], [-117.86975, 33.61264], [-117.86977, 33.61252], [-117.86979, 33.61245], [-117.86977, 33.61244]]], [[[-117.87349, 33.60827], [-117.87244, 33.60984], [-117.87214, 33.61027], [-117.87164, 33.61089], [-117.87109, 33.61149], [-117.87106, 33.61148], [-117.87097, 33.61156], [-117.87087, 33.61158], [-117.87063, 33.61147], [-117.87025, 33.61134], [-117.87021, 33.61125], [-117.87084, 33.6101], [-117.87188, 33.60836], [-117.87236, 33.60747], [-117.87279, 33.60778], [-117.87277, 33.60781], [-117.87299, 33.60797], [-117.87303, 33.60794], [-117.87349, 33.60827]]]]} | Open Access 1 | 47412 | Civic Center Park | 31128 | 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.286 | Civic Ctr. 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
6324 | 6324 | 6323 | {"type": "Polygon", "coordinates": [[[-117.84273, 33.60606], [-117.84233, 33.60601], [-117.84193, 33.60598], [-117.84011, 33.60593], [-117.83941, 33.60594], [-117.8394, 33.60578], [-117.83942, 33.60564], [-117.83954, 33.60542], [-117.83967, 33.60539], [-117.83994, 33.60557], [-117.84034, 33.60575], [-117.84049, 33.60576], [-117.84059, 33.60573], [-117.84067, 33.60568], [-117.84084, 33.60551], [-117.84114, 33.60531], [-117.8412, 33.60528], [-117.84132, 33.60527], [-117.84139, 33.60529], [-117.84152, 33.60538], [-117.8416, 33.60541], [-117.84212, 33.60542], [-117.84232, 33.6055], [-117.84238, 33.60558], [-117.84242, 33.60576], [-117.84263, 33.60582], [-117.84273, 33.60594], [-117.84273, 33.60606]]]} | Open Access 1 | 47410 | Canyon Watch Park | 31125 | 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.694 | Canyon Watch Park | 0 | Local Park 2 | 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 | |
6349 | 6349 | 6348 | {"type": "Polygon", "coordinates": [[[-117.84516, 33.60647], [-117.84512, 33.6066], [-117.84389, 33.6063], [-117.84397, 33.60618], [-117.84398, 33.60601], [-117.84411, 33.60589], [-117.84429, 33.60579], [-117.84447, 33.60574], [-117.84455, 33.60573], [-117.84463, 33.60576], [-117.84472, 33.60583], [-117.84493, 33.60624], [-117.84502, 33.60636], [-117.84516, 33.60647]]]} | Open Access 1 | 47501 | Harbor Watch Park | 31216 | 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 | http://nbgis.newportbeachca.gov/gispub/recreation/facilities/default.aspx | Orange 3 | 1.529 | Harbor Watch 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 | |
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 | |
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 | |
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 | |
6490 | 6490 | 6489 | {"type": "Polygon", "coordinates": [[[-117.866, 33.60265], [-117.86593, 33.6027], [-117.86573, 33.6025], [-117.86554, 33.60226], [-117.86554, 33.60222], [-117.86556, 33.60219], [-117.86577, 33.60204], [-117.86574, 33.60213], [-117.86574, 33.60229], [-117.86576, 33.60238], [-117.86584, 33.60251], [-117.86596, 33.60258], [-117.866, 33.60265]]]} | Open Access 1 | 2405 | Jasmine Creek Park | 20367 | 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.207 | Jasmine Creek Park | 0 | Local Park 2 | 4 | |
6325 | 6325 | 6324 | {"type": "Polygon", "coordinates": [[[-117.8698, 33.61245], [-117.86978, 33.61248], [-117.86973, 33.61271], [-117.86967, 33.61278], [-117.86956, 33.61288], [-117.86936, 33.61299], [-117.86932, 33.61303], [-117.86918, 33.6132], [-117.86913, 33.61331], [-117.86907, 33.61336], [-117.86898, 33.61338], [-117.86895, 33.61336], [-117.86895, 33.61331], [-117.86899, 33.61324], [-117.86909, 33.61318], [-117.86916, 33.6131], [-117.86927, 33.61293], [-117.86945, 33.61277], [-117.86951, 33.6127], [-117.86957, 33.61257], [-117.86957, 33.6125], [-117.8696, 33.61245], [-117.86973, 33.61238], [-117.86978, 33.61244], [-117.8698, 33.61245]]]} | Open Access 1 | 47413 | Dog Park | 31129 | 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.43 | Dog Park | 0 | Local Park 2 | 4 | |
461 | 461 | 460 | {"type": "Polygon", "coordinates": [[[-117.87133, 33.59796], [-117.87133, 33.59796], [-117.87119, 33.59799], [-117.8713, 33.59788], [-117.87133, 33.59796]]]} | Open Access 1 | 47411 | Corona del Mar Pocket Park | 31210 | 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.015 | Corona del Mar PP | 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 |
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]);