units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where COUNTY = 3, DES_TP = 4 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_WEB
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6315 | 6315 | 6314 | {"type": "Polygon", "coordinates": [[[-117.86333, 33.59631], [-117.86331, 33.59648], [-117.86322, 33.59664], [-117.86301, 33.59672], [-117.8622, 33.59742], [-117.862, 33.5974], [-117.86195, 33.59745], [-117.86184, 33.59817], [-117.86171, 33.59828], [-117.86054, 33.59802], [-117.86026, 33.59798], [-117.85997, 33.59797], [-117.85969, 33.59799], [-117.85929, 33.59809], [-117.85902, 33.59821], [-117.85878, 33.59836], [-117.85858, 33.59854], [-117.85841, 33.59876], [-117.85829, 33.59899], [-117.85816, 33.5993], [-117.85804, 33.59964], [-117.85797, 33.6], [-117.8579, 33.60046], [-117.85785, 33.60065], [-117.85753, 33.60085], [-117.85708, 33.60101], [-117.8568, 33.60118], [-117.8566, 33.60138], [-117.85646, 33.60161], [-117.85571, 33.60347], [-117.85531, 33.60384], [-117.85515, 33.60418], [-117.85509, 33.60456], [-117.85498, 33.60455], [-117.85466, 33.60466], [-117.85427, 33.60512], [-117.85429, 33.60545], [-117.85432, 33.6056], [-117.8536, 33.60579], [-117.85335, 33.60584], [-117.85323, 33.6058], [-117.85308, 33.60582], [-117.85301, 33.60592], [-117.85262, 33.60599], [-117.85252, 33.60618], [-117.85207, 33.60608], [-117.85196, 33.60607], [-117.85151, 33.60622], [-117.85147, 33.60626], [-117.85146, 33.60623], [-117.8512, 33.60618], [-117.85119, 33.60616], [-117.85044, 33.606], [-117.85049, 33.60723], [-117.85047, 33.60728], [-117.85043, 33.6073], [-117.84976, 33.60737], [-117.84909, 33.60738], [-117.84843, 33.60733], [-117.84777, 33.60723], [-117.84512, 33.6066], [-117.84516, 33.60647], [-117.84502, 33.60636], [-117.84493, 33.60624], [-117.84472, 33.60583], [-117.84467, 33.60578], [-117.84459, 33.60574], [-117.84451, 33.60573], [-117.84443, 33.60575], [-117.84429, 33.60579], [-117.84411, 33.60589], [-117.84398, 33.60601], [-117.84397, 33.60618], [-117.84389, 33.6063], [-117.84318, 33.60614], [-117.84273, 33.60606], [-117.84273, 33.60594], [-117.84263, 33.60582], [-117.84242, 33.60576], [-117.84238, 33.60558], [-117.84232, 33.6055], [-117.84211, 33.60542], [-117.8416, 33.60541], [-117.84152, 33.60538], [-117.84139, 33.60529], [-117.84132, 33.60527], [-117.8412, 33.60528], [-117.84113, 33.60531], [-117.84084, 33.60551], [-117.84067, 33.60568], [-117.84054, 33.60575], [-117.84039, 33.60576], [-117.84029, 33.60573], [-117.83993, 33.60557], [-117.83967, 33.60539], [-117.83954, 33.60542], [-117.83942, 33.60564], [-117.8394, 33.60578], [-117.83941, 33.60594], [-117.83868, 33.60599], [-117.83795, 33.60609], [-117.83766, 33.60509], [-117.83684, 33.60506], [-117.83551, 33.60529], [-117.83537, 33.60568], [-117.83537, 33.60579], [-117.83523, 33.60576], [-117.83511, 33.60576], [-117.83482, 33.60584], [-117.83477, 33.60588], [-117.83458, 33.60583], [-117.83429, 33.60585], [-117.83385, 33.60603], [-117.83371, 33.60611], [-117.83355, 33.60636], [-117.83355, 33.60688], [-117.83359, 33.60704], [-117.83368, 33.60725], [-117.83373, 33.60751], [-117.83379, 33.60769], [-117.83335, 33.6079], [-117.83289, 33.60808], [-117.83218, 33.60831], [-117.83205, 33.60788], [-117.8321, 33.60755], [-117.83213, 33.60708], [-117.83212, 33.60695], [-117.83204, 33.60676], [-117.83195, 33.60665], [-117.83184, 33.60656], [-117.83171, 33.60649], [-117.83148, 33.60644], [-117.83128, 33.60643], [-117.83096, 33.60646], [-117.83074, 33.60623], [-117.83046, 33.60618], [-117.83021, 33.60581], [-117.82912, 33.60587], [-117.82852, 33.606], [-117.82813, 33.60577], [-117.82797, 33.60547], [-117.82803, 33.60521], [-117.82853, 33.60471], [-117.82896, 33.60501], [-117.83045, 33.60481], [-117.8308, 33.60484], [-117.83111, 33.60469], [-117.83219, 33.60489], [-117.83305, 33.60522], [-117.83409, 33.60471], [-117.83494, 33.604], [-117.83497, 33.60326], [-117.83459, 33.60296], [-117.83449, 33.60252], [-117.83459, 33.60233], [-117.83427, 33.60159], [-117.83416, 33.60148], [-117.83418, 33.60146], [-117.83445, 33.60161], [-117.83449, 33.60171], [-117.83459, 33.60179], [-117.83467, 33.60192], [-117.83482, 33.602], [-117.83489, 33.602], [-117.83493, 33.60201], [-117.83501, 33.60207], [-117.83514, 33.60221], [-117.8352, 33.60222], [-117.83559, 33.60213], [-117.83574, 33.60221], [-117.83586, 33.60243], [-117.83592, 33.6025], [-117.836, 33.60254], [-117.8362, 33.60262], [-117.83629, 33.60264], [-117.83647, 33.60265], [-117.83652, 33.60266], [-117.83655, 33.6027], [-117.83654, 33.60278], [-117.83659, 33.60283], [-117.83656, 33.60289], [-117.83646, 33.60298], [-117.83657, 33.60306], [-117.83659, 33.60312], [-117.83668, 33.6032], [-117.83693, 33.60309], [-117.83707, 33.60311], [-117.83745, 33.6031], [-117.83782, 33.60304], [-117.83821, 33.6029], [-117.83849, 33.60298], [-117.83849, 33.60304], [-117.83867, 33.60306], [-117.83869, 33.60299], [-117.83887, 33.60291], [-117.839, 33.60279], [-117.8403, 33.60307], [-117.8414, 33.60299], [-117.84173, 33.60255], [-117.84108, 33.60126], [-117.84079, 33.60099], [-117.84022, 33.601], [-117.84019, 33.60075], [-117.83968, 33.60044], [-117.83853, 33.60036], [-117.83858, 33.59984], [-117.8382, 33.5993], [-117.83822, 33.59921], [-117.838, 33.59902], [-117.83826, 33.59885], [-117.83826, 33.59848], [-117.83811, 33.59812], [-117.83856, 33.59785], [-117.83775, 33.59733], [-117.83782, 33.59708], [-117.83816, 33.59644], [-117.83733, 33.59575], [-117.83814, 33.59561], [-117.84057, 33.59836], [-117.84095, 33.59912], [-117.84207, 33.59924], [-117.84324, 33.59988], [-117.84293, 33.60052], [-117.84307, 33.60113], [-117.84356, 33.60152], [-117.84461, 33.60192], [-117.84643, 33.60227], [-117.8472, 33.60219], [-117.84809, 33.6035], [-117.85012, 33.60333], [-117.85103, 33.60263], [-117.85151, 33.60294], [-117.85268, 33.60294], [-117.85345, 33.60248], [-117.85391, 33.60229], [-117.85447, 33.60166], [-117.85477, 33.60109], [-117.85462, 33.60055], [-117.85405, 33.60038], [-117.85374, 33.60006], [-117.85507, 33.59976], [-117.85565, 33.59926], [-117.85591, 33.59886], [-117.85583, 33.5988], [-117.85631, 33.59819], [-117.86034, 33.59613], [-117.86035, 33.59616], [-117.86047, 33.59616], [-117.86052, 33.59612], [-117.86133, 33.59643], [-117.86231, 33.59614], [-117.86333, 33.59631]]]} | Open Access 1 | 47407 | Buck Gully Reserve | 31124 | 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 | 297.218 | Buck Gully Reserve | 0 | Local Conservation Area 4 | 2 | |
| 7684 | 7684 | 7683 | {"type": "Polygon", "coordinates": [[[-117.91483, 33.89333], [-117.91442, 33.89338], [-117.91416, 33.89346], [-117.91399, 33.89343], [-117.91384, 33.89343], [-117.9137, 33.89351], [-117.91357, 33.89352], [-117.91304, 33.89344], [-117.91277, 33.89349], [-117.91253, 33.89355], [-117.91228, 33.89357], [-117.91183, 33.89357], [-117.91137, 33.89349], [-117.91111, 33.89342], [-117.91016, 33.89373], [-117.91015, 33.89435], [-117.91268, 33.89473], [-117.91311, 33.89535], [-117.91246, 33.8956], [-117.91168, 33.89579], [-117.90701, 33.89588], [-117.90698, 33.89935], [-117.90543, 33.89938], [-117.90536, 33.89937], [-117.9053, 33.89917], [-117.90536, 33.89896], [-117.90535, 33.89891], [-117.9053, 33.89884], [-117.9052, 33.89877], [-117.9051, 33.89874], [-117.90497, 33.89874], [-117.90492, 33.89868], [-117.90491, 33.89864], [-117.90467, 33.8984], [-117.90447, 33.89826], [-117.90432, 33.89803], [-117.9043, 33.89793], [-117.90431, 33.89785], [-117.90423, 33.89771], [-117.90421, 33.89769], [-117.90416, 33.8977], [-117.90414, 33.89774], [-117.90419, 33.8978], [-117.90419, 33.89787], [-117.9043, 33.89814], [-117.90488, 33.89871], [-117.90493, 33.89901], [-117.90497, 33.89906], [-117.90506, 33.89912], [-117.9051, 33.89918], [-117.90512, 33.89929], [-117.90512, 33.89938], [-117.90503, 33.89942], [-117.90171, 33.89948], [-117.89996, 33.89947], [-117.89942, 33.89948], [-117.89924, 33.89945], [-117.89878, 33.89943], [-117.89847, 33.89938], [-117.89795, 33.89934], [-117.89749, 33.89926], [-117.89717, 33.89924], [-117.89675, 33.89914], [-117.8966, 33.89913], [-117.89639, 33.8991], [-117.89624, 33.89905], [-117.89612, 33.89905], [-117.89604, 33.89903], [-117.89497, 33.89874], [-117.89466, 33.89864], [-117.89422, 33.89847], [-117.89365, 33.8983], [-117.89368, 33.89823], [-117.8938, 33.8982], [-117.89392, 33.89814], [-117.89406, 33.89804], [-117.89413, 33.89784], [-117.89413, 33.89766], [-117.89407, 33.89734], [-117.89359, 33.89642], [-117.89348, 33.89625], [-117.89321, 33.89624], [-117.8927, 33.89632], [-117.89217, 33.89622], [-117.89195, 33.89624], [-117.89188, 33.89534], [-117.89199, 33.89534], [-117.89233, 33.89561], [-117.89256, 33.89565], [-117.89281, 33.89564], [-117.89309, 33.89569], [-117.89341, 33.89578], [-117.89366, 33.89589], [-117.89397, 33.89607], [-117.89446, 33.89632], [-117.89501, 33.89592], [-117.8958, 33.89622], [-117.89596, 33.89582], [-117.89606, 33.89549], [-117.89626, 33.89519], [-117.89645, 33.89418], [-117.89652, 33.89371], [-117.89641, 33.89351], [-117.89617, 33.8933], [-117.89595, 33.8933], [-117.89563, 33.89325], [-117.89476, 33.8933], [-117.89453, 33.8933], [-117.89405, 33.89318], [-117.89386, 33.89317], [-117.89339, 33.89321], [-117.89325, 33.89315], [-117.89289, 33.89293], [-117.89269, 33.89277], [-117.89251, 33.8927], [-117.89258, 33.89285], [-117.89273, 33.89304], [-117.89274, 33.89343], [-117.89281, 33.89385], [-117.89296, 33.89416], [-117.89322, 33.89449], [-117.89344, 33.89468], [-117.89461, 33.89542], [-117.89453, 33.89555], [-117.89437, 33.89568], [-117.89411, 33.89579], [-117.89399, 33.89576], [-117.89414, 33.89547], [-117.89352, 33.89522], [-117.89313, 33.89497], [-117.89271, 33.8948], [-117.89225, 33.89466], [-117.89204, 33.89463], [-117.8919, 33.89463], [-117.89181, 33.89451], [-117.89174, 33.89398], [-117.89169, 33.89326], [-117.89176, 33.89243], [-117.8964, 33.89262], [-117.89706, 33.89319], [-117.89744, 33.89366], [-117.89752, 33.89385], [-117.89746, 33.89404], [-117.89735, 33.8942], [-117.89731, 33.89436], [-117.89734, 33.89447], [-117.89734, 33.89462], [-117.89733, 33.89482], [-117.89728, 33.89503], [-117.89717, 33.89523], [-117.89702, 33.89544], [-117.89673, 33.89569], [-117.89663, 33.89591], [-117.89666, 33.89602], [-117.89673, 33.89591], [-117.89693, 33.89569], [-117.89726, 33.89542], [-117.89787, 33.89515], [-117.89817, 33.89509], [-117.89861, 33.89498], [-117.8989, 33.89464], [-117.89943, 33.89496], [-117.89963, 33.89514], [-117.89999, 33.89532], [-117.90024, 33.89548], [-117.90041, 33.89547], [-117.90056, 33.89543], [-117.90069, 33.89515], [-117.90085, 33.89513], [-117.90154, 33.89519], [-117.90236, 33.89478], [-117.90264, 33.89443], [-117.90279, 33.89451], [-117.90339, 33.89425], [-117.90352, 33.89427], [-117.90381, 33.89402], [-117.90417, 33.89382], [-117.9043, 33.89386], [-117.90438, 33.89382], [-117.90439, 33.89345], [-117.90481, 33.89291], [-117.9049, 33.89281], [-117.9052, 33.89285], [-117.90531, 33.89293], [-117.90549, 33.89311], [-117.90572, 33.89319], [-117.90639, 33.89309], [-117.90679, 33.8931], [-117.90705, 33.89316], [-117.90731, 33.89315], [-117.90744, 33.89308], [-117.90765, 33.89308], [-117.90787, 33.89303], [-117.9081, 33.89285], [-117.90815, 33.89267], [-117.90809, 33.89256], [-117.90786, 33.89248], [-117.90767, 33.89246], [-117.90789, 33.89237], [-117.90812, 33.89241], [-117.90825, 33.89248], [-117.90837, 33.89258], [-117.90847, 33.89261], [-117.90861, 33.89255], [-117.90914, 33.8924], [-117.90959, 33.89236], [-117.91479, 33.89234], [-117.91483, 33.89333]]]} | Open Access 1 | 7631 | Panorama Nature Reserve | 4066 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 219.655 | Panorama Nature Reserve | 0 | Local Conservation Area 4 | 2 | |
| 7901 | 7901 | 7900 | {"type": "Polygon", "coordinates": [[[-117.95261, 33.89908], [-117.9526, 33.89956], [-117.95255, 33.89978], [-117.9525, 33.89992], [-117.9524, 33.90012], [-117.95175, 33.90019], [-117.95156, 33.90033], [-117.95142, 33.9005], [-117.95098, 33.90079], [-117.95065, 33.90125], [-117.94932, 33.90117], [-117.94926, 33.90118], [-117.94923, 33.90132], [-117.94933, 33.90169], [-117.94929, 33.90187], [-117.94909, 33.90193], [-117.94865, 33.90197], [-117.94839, 33.90209], [-117.94829, 33.90217], [-117.94816, 33.90222], [-117.94793, 33.90221], [-117.94787, 33.90219], [-117.94768, 33.90207], [-117.94752, 33.90206], [-117.94741, 33.90208], [-117.94732, 33.90212], [-117.94713, 33.90224], [-117.94706, 33.9025], [-117.94712, 33.90256], [-117.94724, 33.90274], [-117.94739, 33.90291], [-117.94764, 33.90304], [-117.94762, 33.90309], [-117.94765, 33.90311], [-117.94781, 33.90312], [-117.94828, 33.90377], [-117.94812, 33.90449], [-117.9478, 33.9046], [-117.94737, 33.9048], [-117.947, 33.9048], [-117.94651, 33.90469], [-117.94579, 33.90442], [-117.94503, 33.90436], [-117.94472, 33.90431], [-117.94389, 33.90395], [-117.94361, 33.90368], [-117.9433, 33.9033], [-117.943, 33.90278], [-117.943, 33.90266], [-117.94306, 33.9024], [-117.94319, 33.90219], [-117.94337, 33.90199], [-117.94355, 33.90164], [-117.94359, 33.90141], [-117.94359, 33.90134], [-117.94355, 33.90128], [-117.94347, 33.90126], [-117.94325, 33.90126], [-117.94321, 33.90133], [-117.94288, 33.90133], [-117.94227, 33.90126], [-117.94215, 33.90127], [-117.94187, 33.90119], [-117.94189, 33.8994], [-117.94205, 33.89918], [-117.94405, 33.89916], [-117.94737, 33.89917], [-117.94761, 33.89959], [-117.94784, 33.89974], [-117.94838, 33.90001], [-117.94866, 33.90023], [-117.94906, 33.90052], [-117.94931, 33.90064], [-117.94931, 33.90066], [-117.94943, 33.90075], [-117.9495, 33.90091], [-117.95016, 33.90099], [-117.9503, 33.90097], [-117.95054, 33.90086], [-117.95038, 33.90053], [-117.95046, 33.9005], [-117.95066, 33.90078], [-117.95092, 33.90069], [-117.95134, 33.90036], [-117.95204, 33.89996], [-117.95223, 33.89975], [-117.95244, 33.89927], [-117.9525, 33.89906], [-117.95261, 33.89908]]]} | Open Access 1 | 10158 | Robert E. Ward Nature Preserve | 24486 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 76.163 | Robert E. Ward Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
| 8077 | 8077 | 8076 | {"type": "Polygon", "coordinates": [[[-117.83152, 33.67279], [-117.83133, 33.67315], [-117.83052, 33.67296], [-117.83016, 33.67265], [-117.82986, 33.67252], [-117.82273, 33.67034], [-117.823, 33.6703], [-117.82332, 33.6703], [-117.82367, 33.67033], [-117.8246, 33.67054], [-117.83152, 33.67279]]]} | Open Access 1 | 12290 | Culverdale Wilderness Park | 17856 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 7.092 | Culverdale Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
| 9241 | 9241 | 9240 | {"type": "MultiPolygon", "coordinates": [[[[-117.65602, 33.64685], [-117.65577, 33.6472], [-117.65581, 33.64737], [-117.65578, 33.64761], [-117.65568, 33.64788], [-117.65527, 33.64851], [-117.65552, 33.64862], [-117.65563, 33.64846], [-117.65581, 33.6485], [-117.65582, 33.64875], [-117.65566, 33.64879], [-117.65543, 33.6489], [-117.65525, 33.64901], [-117.65514, 33.64912], [-117.65511, 33.64913], [-117.655, 33.6491], [-117.65427, 33.64871], [-117.65397, 33.64853], [-117.65385, 33.64864], [-117.65377, 33.6486], [-117.65374, 33.64861], [-117.65368, 33.64897], [-117.6536, 33.64897], [-117.65352, 33.64868], [-117.6535, 33.64863], [-117.65348, 33.64862], [-117.65344, 33.64863], [-117.65303, 33.64899], [-117.65296, 33.64893], [-117.65396, 33.64811], [-117.65438, 33.64772], [-117.6548, 33.64725], [-117.65505, 33.64691], [-117.65527, 33.64659], [-117.65534, 33.64657], [-117.65602, 33.64685]]], [[[-117.65926, 33.63996], [-117.6591, 33.64019], [-117.65911, 33.6402], [-117.659, 33.64038], [-117.65902, 33.6404], [-117.65893, 33.64059], [-117.65895, 33.6406], [-117.65886, 33.64077], [-117.65882, 33.64114], [-117.65877, 33.64134], [-117.65879, 33.64139], [-117.65884, 33.64141], [-117.65895, 33.64162], [-117.65871, 33.64171], [-117.65825, 33.64227], [-117.6586, 33.64257], [-117.65845, 33.6427], [-117.65832, 33.64286], [-117.658, 33.64342], [-117.65766, 33.64417], [-117.65752, 33.64439], [-117.65724, 33.64474], [-117.65704, 33.64529], [-117.65678, 33.64577], [-117.65652, 33.6464], [-117.65642, 33.6466], [-117.6563, 33.64678], [-117.6554, 33.64642], [-117.65537, 33.64636], [-117.65561, 33.64584], [-117.65623, 33.64443], [-117.65684, 33.64276], [-117.65686, 33.64262], [-117.657, 33.64229], [-117.65718, 33.64176], [-117.6574, 33.64125], [-117.65763, 33.64082], [-117.65795, 33.64035], [-117.65815, 33.64011], [-117.6584, 33.63983], [-117.65868, 33.63958], [-117.65875, 33.63958], [-117.65926, 33.63996]]], [[[-117.66255, 33.63664], [-117.66237, 33.63666], [-117.66223, 33.63685], [-117.66224, 33.63686], [-117.66215, 33.63702], [-117.66215, 33.63703], [-117.66203, 33.63719], [-117.66205, 33.63721], [-117.66193, 33.63736], [-117.66194, 33.63738], [-117.66182, 33.63755], [-117.66183, 33.63756], [-117.6616, 33.63787], [-117.66161, 33.63789], [-117.66151, 33.63804], [-117.66143, 33.63823], [-117.66144, 33.63825], [-117.66136, 33.63842], [-117.66138, 33.63844], [-117.66125, 33.63876], [-117.66116, 33.63892], [-117.66117, 33.63894], [-117.66078, 33.63952], [-117.66027, 33.64019], [-117.65953, 33.63993], [-117.65938, 33.63986], [-117.65876, 33.63943], [-117.65876, 33.63935], [-117.6596, 33.63853], [-117.65998, 33.63812], [-117.66067, 33.63733], [-117.66119, 33.63663], [-117.66142, 33.63625], [-117.66149, 33.63622], [-117.66186, 33.63631], [-117.66249, 33.63632], [-117.66252, 33.63637], [-117.66255, 33.63664]]], [[[-117.66643, 33.62971], [-117.66574, 33.63028], [-117.66575, 33.63037], [-117.66593, 33.63051], [-117.66584, 33.6309], [-117.66574, 33.63095], [-117.66569, 33.63106], [-117.66536, 33.63095], [-117.66491, 33.63181], [-117.66458, 33.63227], [-117.66446, 33.63238], [-117.66447, 33.6324], [-117.66433, 33.63257], [-117.66433, 33.63259], [-117.66425, 33.63279], [-117.66427, 33.63281], [-117.66418, 33.63301], [-117.66419, 33.63303], [-117.66407, 33.63319], [-117.66407, 33.63322], [-117.66408, 33.63322], [-117.66405, 33.63344], [-117.6641, 33.63369], [-117.66428, 33.63378], [-117.66386, 33.63445], [-117.66404, 33.63467], [-117.66416, 33.63475], [-117.66415, 33.63486], [-117.66421, 33.63495], [-117.66432, 33.63498], [-117.66452, 33.63502], [-117.665, 33.63521], [-117.66521, 33.63524], [-117.66523, 33.63529], [-117.66523, 33.63542], [-117.66516, 33.6356], [-117.66507, 33.63574], [-117.66505, 33.63576], [-117.66501, 33.63576], [-117.66435, 33.63546], [-117.66426, 33.63544], [-117.66405, 33.63542], [-117.66388, 33.63544], [-117.66371, 33.63549], [-117.66349, 33.63561], [-117.66294, 33.63608], [-117.66272, 33.63614], [-117.66239, 33.63617], [-117.66205, 33.63617], [-117.66181, 33.63614], [-117.66155, 33.63608], [-117.66153, 33.63601], [-117.66154, 33.63598], [-117.66206, 33.63481], [-117.66288, 33.63343], [-117.66318, 33.63287], [-117.66403, 33.63097], [-117.66433, 33.6304], [-117.66464, 33.62993], [-117.66498, 33.62953], [-117.66538, 33.62977], [-117.66575, 33.62935], [-117.66594, 33.62946], [-117.66643, 33.62971]]], [[[-117.67486, 33.62716], [-117.67396, 33.6271], [-117.67373, 33.62765], [-117.6732, 33.62749], [-117.67304, 33.62788], [-117.67241, 33.62791], [-117.67208, 33.62803], [-117.67195, 33.62805], [-117.67182, 33.62805], [-117.67171, 33.628], [-117.67126, 33.62757], [-117.67114, 33.62749], [-117.67102, 33.62745], [-117.67087, 33.62746], [-117.67077, 33.62754], [-117.67055, 33.62779], [-117.6702, 33.62805], [-117.67013, 33.62808], [-117.67013, 33.6281], [-117.67027, 33.6282], [-117.66999, 33.6284], [-117.66917, 33.62841], [-117.66887, 33.62855], [-117.66869, 33.62859], [-117.66854, 33.62857], [-117.66814, 33.6288], [-117.66787, 33.62885], [-117.66757, 33.6288], [-117.6675, 33.62897], [-117.66691, 33.62916], [-117.66646, 33.62943], [-117.66589, 33.62912], [-117.66563, 33.62896], [-117.66563, 33.62885], [-117.66586, 33.62865], [-117.66622, 33.62837], [-117.66679, 33.62801], [-117.6669, 33.62813], [-117.66721, 33.62828], [-117.66726, 33.62828], [-117.66777, 33.62805], [-117.66779, 33.62802], [-117.66787, 33.6279], [-117.66811, 33.62779], [-117.66876, 33.62779], [-117.66891, 33.62766], [-117.66904, 33.62761], [-117.66913, 33.6276], [-117.66926, 33.62763], [-117.66977, 33.62783], [-117.67001, 33.62745], [-117.67005, 33.62729], [-117.67006, 33.62712], [-117.67001, 33.62696], [-117.67017, 33.62694], [-117.67361, 33.62681], [-117.674, 33.6268], [-117.67443, 33.62682], [-117.67482, 33.62684], [-117.67491, 33.62687], [-117.67492, 33.62696], [-117.67486, 33.62716]]]]} | Open Access 1 | 15361 | Wilderness Glen Park | 27508 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 90.299 | Wilderness Glen Park | 0 | Local Conservation Area 4 | 2 |
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]);