units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
58 rows where MNG_AGENCY = 113 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME, GAP_STS
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
282 | 282 | 281 | {"type": "Polygon", "coordinates": [[[-117.89382, 33.88608], [-117.89375, 33.8862], [-117.89366, 33.88628], [-117.89357, 33.88634], [-117.89345, 33.88638], [-117.89184, 33.88657], [-117.89171, 33.88659], [-117.89162, 33.88663], [-117.89142, 33.88677], [-117.89085, 33.88747], [-117.89075, 33.88764], [-117.89069, 33.88781], [-117.89029, 33.88783], [-117.89023, 33.8878], [-117.8901, 33.88716], [-117.89051, 33.88706], [-117.89064, 33.88674], [-117.89088, 33.88669], [-117.89106, 33.88662], [-117.89167, 33.88626], [-117.89176, 33.88622], [-117.89298, 33.88609], [-117.89312, 33.88604], [-117.89324, 33.88597], [-117.89338, 33.88584], [-117.89382, 33.88608]]]} | Open Access 1 | 756 | Fullerton Creek Greenbelt | 19143 | 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 | 4.418 | Fullerton Creek Greenbelt | 0 | Local Recreation Area 3 | 4 | |
717 | 717 | 716 | {"type": "Polygon", "coordinates": [[[-117.92419, 33.88391], [-117.92408, 33.88412], [-117.92397, 33.88429], [-117.92354, 33.88397], [-117.92333, 33.88404], [-117.92297, 33.88442], [-117.92231, 33.88498], [-117.92231, 33.88499], [-117.92279, 33.88538], [-117.92229, 33.8858], [-117.92197, 33.88601], [-117.92171, 33.88614], [-117.92123, 33.88634], [-117.92078, 33.8865], [-117.92073, 33.8865], [-117.92066, 33.88644], [-117.9205, 33.88616], [-117.92054, 33.88613], [-117.92028, 33.88566], [-117.92023, 33.88566], [-117.92021, 33.88554], [-117.92022, 33.88548], [-117.92027, 33.88542], [-117.9204, 33.88533], [-117.92058, 33.88525], [-117.92067, 33.88517], [-117.92073, 33.88504], [-117.92073, 33.88495], [-117.92071, 33.88487], [-117.92063, 33.88477], [-117.91997, 33.88433], [-117.91994, 33.8843], [-117.91993, 33.88424], [-117.92209, 33.88471], [-117.92255, 33.88401], [-117.9228, 33.8839], [-117.92419, 33.88391]]]} | Open Access 1 | 4247 | Lions Field | 21314 | 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 | 10.364 | Lions Field | 0 | Local Recreation Area 3 | 4 | |
873 | 873 | 872 | {"type": "Polygon", "coordinates": [[[-117.93298, 33.87239], [-117.93299, 33.87368], [-117.93293, 33.87371], [-117.93199, 33.87372], [-117.93199, 33.87369], [-117.93201, 33.87368], [-117.93199, 33.8724], [-117.93298, 33.87239]]]} | Open Access 1 | 5644 | Ford Park | 18986 | 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 | 3.29 | Ford Park | 0 | Local Park 2 | 4 | |
889 | 889 | 888 | {"type": "Polygon", "coordinates": [[[-117.94313, 33.86297], [-117.94253, 33.86297], [-117.94252, 33.86266], [-117.94195, 33.86267], [-117.94195, 33.862], [-117.94199, 33.86199], [-117.94204, 33.86196], [-117.94216, 33.86195], [-117.94235, 33.8619], [-117.94244, 33.86185], [-117.94267, 33.86168], [-117.94313, 33.86205], [-117.94313, 33.86297]]]} | Open Access 1 | 5733 | Nicolas Park | 22752 | 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 | 2.839 | Nicolas Park | 0 | Local Park 2 | 4 | |
998 | 998 | 997 | {"type": "Polygon", "coordinates": [[[-117.983, 33.89971], [-117.983, 33.89998], [-117.98289, 33.90017], [-117.98289, 33.90029], [-117.98284, 33.90035], [-117.98284, 33.90042], [-117.98281, 33.90043], [-117.98264, 33.90066], [-117.98257, 33.90091], [-117.98247, 33.90093], [-117.98244, 33.90096], [-117.98241, 33.90106], [-117.98208, 33.90151], [-117.98207, 33.90158], [-117.98217, 33.90163], [-117.98217, 33.90165], [-117.98242, 33.90178], [-117.98243, 33.90186], [-117.98236, 33.90194], [-117.9823, 33.90195], [-117.98238, 33.90183], [-117.98225, 33.90171], [-117.98219, 33.90169], [-117.98212, 33.90172], [-117.9821, 33.90194], [-117.98194, 33.90193], [-117.98198, 33.90164], [-117.98192, 33.90163], [-117.98199, 33.90149], [-117.98215, 33.90097], [-117.98217, 33.90082], [-117.98195, 33.90069], [-117.98205, 33.90059], [-117.98233, 33.90075], [-117.98264, 33.90041], [-117.98274, 33.90027], [-117.9829, 33.89994], [-117.98291, 33.89979], [-117.98259, 33.89973], [-117.98263, 33.89969], [-117.983, 33.89971]]]} | Open Access 1 | 6747 | City of Fullerton Open Space | 17314 | 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 | 1.259 | City of Fullerton OS | 0 | Local Recreation Area 3 | 4 | |
1098 | 1098 | 1097 | {"type": "Polygon", "coordinates": [[[-117.92986, 33.86435], [-117.92876, 33.86437], [-117.92876, 33.86349], [-117.92985, 33.86348], [-117.92986, 33.86435]]]} | Open Access 1 | 9922 | Richman Park | 24338 | 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 | 2.446 | Richman Park | 0 | Local Park 2 | 4 | |
1131 | 1131 | 1130 | {"type": "Polygon", "coordinates": [[[-117.95528, 33.87307], [-117.95525, 33.87309], [-117.95481, 33.87321], [-117.95455, 33.87326], [-117.95425, 33.87328], [-117.95421, 33.87325], [-117.9542, 33.87238], [-117.95425, 33.87232], [-117.95425, 33.87207], [-117.95433, 33.87204], [-117.95437, 33.87199], [-117.95437, 33.87193], [-117.95435, 33.8719], [-117.95467, 33.8719], [-117.95468, 33.8721], [-117.9551, 33.8721], [-117.95512, 33.87268], [-117.95516, 33.87283], [-117.95528, 33.87307]]]} | Open Access 1 | 6622 | Adlena Park | 15266 | 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 | 2.836 | Adlena Park | 0 | Local Park 2 | 4 | |
1260 | 1260 | 1259 | {"type": "Polygon", "coordinates": [[[-117.94028, 33.86813], [-117.93751, 33.86817], [-117.93748, 33.86675], [-117.93903, 33.86673], [-117.93904, 33.86678], [-117.94015, 33.86677], [-117.94014, 33.86701], [-117.94015, 33.86728], [-117.94017, 33.86737], [-117.94023, 33.8675], [-117.94026, 33.86761], [-117.94028, 33.86813]]]} | Open Access 1 | 5674 | Independence Park | 20191 | 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 | 9.627 | Independence Park | 0 | Local Park 2 | 4 | |
1533 | 1533 | 1532 | {"type": "Polygon", "coordinates": [[[-117.92836, 33.90467], [-117.92815, 33.9048], [-117.9281, 33.90476], [-117.92804, 33.90473], [-117.92797, 33.90475], [-117.92791, 33.9048], [-117.92753, 33.90466], [-117.92763, 33.90412], [-117.92794, 33.90402], [-117.92836, 33.90467]]]} | Open Access 1 | 11140 | San Juan Park | 24919 | 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 | 1.044 | San Juan Park | 0 | Local Park 2 | 4 | |
1757 | 1757 | 1756 | {"type": "Polygon", "coordinates": [[[-117.90873, 33.87477], [-117.90712, 33.87478], [-117.90712, 33.87424], [-117.90716, 33.8742], [-117.90749, 33.8742], [-117.90757, 33.87422], [-117.90872, 33.8742], [-117.90873, 33.87477]]]} | Open Access 1 | 13081 | Byerrum Park | 16616 | 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 | 2.299 | Byerrum Park | 0 | Local Park 2 | 4 | |
3711 | 3711 | 3710 | {"type": "Polygon", "coordinates": [[[-117.92322, 33.87248], [-117.92321, 33.87287], [-117.92272, 33.87287], [-117.92272, 33.87248], [-117.92322, 33.87248]]]} | Open Access 1 | 30310 | Downtown Plaza | 18256 | 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 | 0.493 | Downtown Plaza | 0 | Local Park 2 | 4 | |
4013 | 4013 | 4012 | {"type": "Polygon", "coordinates": [[[-117.95468, 33.86909], [-117.95385, 33.86908], [-117.95384, 33.86891], [-117.95335, 33.8689], [-117.95334, 33.86852], [-117.95468, 33.86851], [-117.95468, 33.86909]]]} | Open Access 1 | 20676 | Pooch Park | 23890 | 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 | 1.697 | Pooch Park | 0 | Local Park 2 | 4 | |
4377 | 4377 | 4376 | {"type": "Polygon", "coordinates": [[[-117.95103, 33.89252], [-117.95065, 33.89253], [-117.95003, 33.89257], [-117.94996, 33.89212], [-117.94981, 33.89213], [-117.94979, 33.89207], [-117.94994, 33.892], [-117.9499, 33.89172], [-117.95102, 33.89171], [-117.95103, 33.89252]]]} | Open Access 1 | 10296 | Roger Chaffee Park | 24558 | 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 | 2.259 | Roger Chaffee Park | 0 | Local Park 2 | 4 | |
4959 | 4959 | 4958 | {"type": "Polygon", "coordinates": [[[-117.88353, 33.89776], [-117.88331, 33.89827], [-117.88238, 33.89767], [-117.88239, 33.89693], [-117.88353, 33.89776]]]} | Open Access 1 | 7009 | City of Fullerton Open Space | 17314 | 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 | 1.864 | City of Fullerton OS | 0 | Local Recreation Area 3 | 4 | |
5192 | 5192 | 5191 | {"type": "Polygon", "coordinates": [[[-117.94549, 33.87542], [-117.94548, 33.8764], [-117.94546, 33.87698], [-117.94376, 33.87684], [-117.94367, 33.87682], [-117.94362, 33.87677], [-117.94347, 33.87634], [-117.9434, 33.87595], [-117.94312, 33.8753], [-117.94359, 33.8752], [-117.94542, 33.87532], [-117.94545, 33.87534], [-117.94546, 33.87542], [-117.94549, 33.87542]]]} | Open Access 1 | 5550 | Muckenthaler Cultural Center | 22582 | 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 | 8.615 | Muckenthaler Cultural Ctr. | 0 | Local Recreation Area 3 | 4 | |
5514 | 5514 | 5513 | {"type": "Polygon", "coordinates": [[[-117.92438, 33.88131], [-117.9245, 33.88275], [-117.92433, 33.88354], [-117.92419, 33.88391], [-117.9228, 33.8839], [-117.92255, 33.88401], [-117.9221, 33.88471], [-117.91993, 33.88424], [-117.92016, 33.88335], [-117.92017, 33.88322], [-117.92013, 33.88308], [-117.9198, 33.88233], [-117.91977, 33.88218], [-117.92002, 33.88129], [-117.92093, 33.88128], [-117.92093, 33.88133], [-117.92086, 33.88134], [-117.92087, 33.88149], [-117.92118, 33.88148], [-117.92118, 33.88134], [-117.92098, 33.88134], [-117.92098, 33.88128], [-117.92421, 33.88127], [-117.92422, 33.8813], [-117.92438, 33.88131]]]} | Open Access 1 | 1833 | Hillcrest Park | 19969 | 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 | 33.004 | Hillcrest Park | 0 | Local Park 2 | 4 | |
5732 | 5732 | 5731 | {"type": "MultiPolygon", "coordinates": [[[[-117.9492, 33.88555], [-117.94863, 33.88611], [-117.94801, 33.88656], [-117.94717, 33.88705], [-117.94643, 33.88751], [-117.94463, 33.88859], [-117.94422, 33.88811], [-117.9452, 33.88758], [-117.94735, 33.88646], [-117.94757, 33.88633], [-117.94798, 33.88599], [-117.94822, 33.88574], [-117.94851, 33.88532], [-117.94855, 33.8853], [-117.94864, 33.88531], [-117.9492, 33.88555]]], [[[-117.95502, 33.87975], [-117.95351, 33.8803], [-117.95296, 33.88059], [-117.9523, 33.88103], [-117.9521, 33.88121], [-117.95184, 33.88145], [-117.95135, 33.88206], [-117.95073, 33.88206], [-117.95066, 33.88201], [-117.95065, 33.88199], [-117.95068, 33.88195], [-117.95101, 33.88158], [-117.95154, 33.88105], [-117.95192, 33.88074], [-117.95246, 33.88034], [-117.95308, 33.87995], [-117.95454, 33.87916], [-117.95502, 33.87975]]]]} | Open Access 1 | 2262 | Bastanchury Greenbelt | 15858 | 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 | 13.539 | Bastanchury Greenbelt | 0 | Local Recreation Area 3 | 4 | |
5879 | 5879 | 5878 | {"type": "Polygon", "coordinates": [[[-117.97279, 33.88354], [-117.97261, 33.88413], [-117.972, 33.88412], [-117.9719, 33.88422], [-117.97193, 33.88435], [-117.97208, 33.88454], [-117.97217, 33.88471], [-117.97227, 33.88494], [-117.97225, 33.88493], [-117.97208, 33.88457], [-117.97193, 33.88438], [-117.97164, 33.88404], [-117.97158, 33.88394], [-117.97147, 33.88371], [-117.9714, 33.88344], [-117.97137, 33.88329], [-117.97136, 33.88245], [-117.97132, 33.88232], [-117.97128, 33.88225], [-117.97113, 33.88209], [-117.97093, 33.88198], [-117.9708, 33.88194], [-117.97064, 33.88192], [-117.97006, 33.88198], [-117.96907, 33.88205], [-117.96901, 33.88204], [-117.96899, 33.88201], [-117.96903, 33.882], [-117.96904, 33.88195], [-117.97007, 33.88193], [-117.97008, 33.88182], [-117.97133, 33.8818], [-117.97188, 33.88135], [-117.97186, 33.88058], [-117.97233, 33.88058], [-117.97235, 33.8831], [-117.97279, 33.88354]]]} | Open Access 1 | 270 | Emery Park | 18625 | 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 | 9.034 | Emery 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]);