units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15 rows where DES_TP = 3, MNG_AGENCY = 113 and MNG_AG_LEV = 2
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 15
MNG_AGENCY 1
- Fullerton, City of · 15 ✖
DES_TP 1
- Local Recreation Area · 15 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
6003 | 6003 | 6002 | {"type": "Polygon", "coordinates": [[[-117.9268, 33.89343], [-117.92673, 33.89381], [-117.92554, 33.89382], [-117.92558, 33.89251], [-117.92583, 33.89233], [-117.9259, 33.89215], [-117.92642, 33.8921], [-117.9268, 33.89343]]]} | Open Access 1 | 770 | Fullerton Tennis Center | 33372 | 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.416 | Fullerton Tennis Ctr. | 0 | Local Recreation Area 3 | 4 | |
6058 | 6058 | 6057 | {"type": "Polygon", "coordinates": [[[-117.92255, 33.8956], [-117.9225, 33.89563], [-117.92242, 33.89571], [-117.92243, 33.89577], [-117.92247, 33.89585], [-117.92248, 33.89597], [-117.92243, 33.89601], [-117.92237, 33.89602], [-117.92232, 33.89606], [-117.92237, 33.89629], [-117.92232, 33.89637], [-117.92231, 33.89644], [-117.9221, 33.89653], [-117.9219, 33.89663], [-117.92186, 33.8967], [-117.92184, 33.89681], [-117.92143, 33.89682], [-117.92143, 33.89749], [-117.92138, 33.89756], [-117.92093, 33.89803], [-117.92067, 33.89839], [-117.92067, 33.89869], [-117.92064, 33.89891], [-117.91996, 33.89895], [-117.91999, 33.89885], [-117.91999, 33.89877], [-117.91998, 33.89841], [-117.91998, 33.89699], [-117.91996, 33.89691], [-117.91994, 33.89687], [-117.91989, 33.89682], [-117.91965, 33.89665], [-117.91949, 33.89661], [-117.91868, 33.89667], [-117.91831, 33.89664], [-117.91795, 33.89652], [-117.91734, 33.89618], [-117.91705, 33.89615], [-117.91692, 33.89616], [-117.91683, 33.89618], [-117.91642, 33.89639], [-117.91623, 33.8966], [-117.91624, 33.89667], [-117.91621, 33.89679], [-117.91606, 33.89688], [-117.91597, 33.89698], [-117.91583, 33.8971], [-117.9157, 33.89717], [-117.91571, 33.89575], [-117.92006, 33.89558], [-117.92255, 33.8956]]]} | Open Access 1 | 765 | Fullerton Sports Complex | 19145 | 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 | 22.491 | Fullerton Sports Complex | 0 | Local Recreation Area 3 | 4 | |
7290 | 7290 | 7289 | {"type": "Polygon", "coordinates": [[[-117.97673, 33.90641], [-117.9767, 33.90644], [-117.97664, 33.90637], [-117.9765, 33.90631], [-117.97642, 33.90626], [-117.97638, 33.90594], [-117.97628, 33.90577], [-117.97605, 33.90575], [-117.97595, 33.90571], [-117.97586, 33.90562], [-117.97578, 33.90546], [-117.97571, 33.90524], [-117.97566, 33.90504], [-117.97543, 33.90475], [-117.97542, 33.90466], [-117.97549, 33.90455], [-117.97559, 33.90451], [-117.97572, 33.9045], [-117.97604, 33.90473], [-117.97616, 33.9049], [-117.97628, 33.90511], [-117.97632, 33.90524], [-117.97632, 33.90533], [-117.97635, 33.9054], [-117.97645, 33.90557], [-117.97649, 33.90575], [-117.97673, 33.90641]]]} | Open Access 1 | 7134 | 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 | 2.106 | City of Fullerton OS | 0 | Local Recreation Area 3 | 4 | |
7367 | 7367 | 7366 | {"type": "Polygon", "coordinates": [[[-117.97195, 33.89573], [-117.97185, 33.89613], [-117.97161, 33.89675], [-117.97149, 33.89687], [-117.97084, 33.89835], [-117.9703, 33.89888], [-117.97025, 33.89903], [-117.97009, 33.89903], [-117.97175, 33.89609], [-117.97178, 33.89573], [-117.97195, 33.89573]]]} | Open Access 1 | 6764 | 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.863 | City of Fullerton OS | 0 | Local Recreation Area 3 | 4 | |
7416 | 7416 | 7415 | {"type": "Polygon", "coordinates": [[[-117.88318, 33.90438], [-117.88315, 33.90461], [-117.88307, 33.90489], [-117.88292, 33.90527], [-117.88271, 33.90571], [-117.88257, 33.90604], [-117.88244, 33.90628], [-117.88215, 33.90665], [-117.8818, 33.90626], [-117.88176, 33.90592], [-117.88318, 33.90438]]]} | Open Access 1 | 6991 | 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 | 2.815 | City of Fullerton OS | 0 | Local Recreation Area 3 | 4 | |
15651 | 15651 | 15650 | {"type": "Polygon", "coordinates": [[[-117.92866, 33.89741], [-117.92882, 33.89797], [-117.92866, 33.89899], [-117.92858, 33.89939], [-117.9284, 33.89986], [-117.9283, 33.90048], [-117.92833, 33.90094], [-117.92835, 33.90216], [-117.92806, 33.90241], [-117.92794, 33.9026], [-117.92782, 33.90285], [-117.92789, 33.90288], [-117.9279, 33.90291], [-117.92781, 33.90302], [-117.9277, 33.9032], [-117.92761, 33.90344], [-117.92753, 33.90373], [-117.92731, 33.90489], [-117.92713, 33.90576], [-117.92694, 33.90573], [-117.92669, 33.905], [-117.92544, 33.90564], [-117.92569, 33.9054], [-117.92485, 33.90469], [-117.92436, 33.90485], [-117.92358, 33.90507], [-117.92102, 33.90616], [-117.92255, 33.90495], [-117.9231, 33.90426], [-117.92225, 33.90389], [-117.9208, 33.90429], [-117.91838, 33.90369], [-117.91643, 33.90441], [-117.91697, 33.90527], [-117.91723, 33.90563], [-117.91661, 33.906], [-117.91638, 33.9061], [-117.91608, 33.90635], [-117.91599, 33.90644], [-117.91597, 33.90666], [-117.91591, 33.90694], [-117.91599, 33.9071], [-117.91639, 33.90737], [-117.9165, 33.90748], [-117.91741, 33.90864], [-117.91682, 33.90936], [-117.91585, 33.90911], [-117.91587, 33.90892], [-117.91585, 33.9087], [-117.9158, 33.90844], [-117.91565, 33.90813], [-117.91565, 33.90737], [-117.91479, 33.90656], [-117.91478, 33.9065], [-117.91495, 33.90578], [-117.91552, 33.90519], [-117.91512, 33.90406], [-117.914, 33.90357], [-117.91408, 33.90356], [-117.91405, 33.90301], [-117.92042, 33.90291], [-117.92104, 33.9032], [-117.92165, 33.90284], [-117.9233, 33.90281], [-117.92395, 33.90322], [-117.92419, 33.903], [-117.92478, 33.90242], [-117.92545, 33.90204], [-117.92462, 33.90094], [-117.92431, 33.90085], [-117.92499, 33.90051], [-117.92625, 33.90048], [-117.92705, 33.89942], [-117.92638, 33.89873], [-117.92586, 33.89916], [-117.92559, 33.89875], [-117.92565, 33.89751], [-117.92502, 33.89756], [-117.92475, 33.89873], [-117.92401, 33.89851], [-117.92397, 33.89859], [-117.92398, 33.89926], [-117.92302, 33.89914], [-117.92231, 33.89932], [-117.92197, 33.89983], [-117.92155, 33.89925], [-117.92203, 33.89917], [-117.92261, 33.89901], [-117.92316, 33.89878], [-117.92376, 33.89842], [-117.92436, 33.89784], [-117.9253, 33.89671], [-117.92571, 33.89644], [-117.92618, 33.89618], [-117.92651, 33.89606], [-117.92665, 33.89614], [-117.92714, 33.89625], [-117.92701, 33.89671], [-117.92702, 33.89673], [-117.92798, 33.89658], [-117.92793, 33.89672], [-117.92771, 33.89701], [-117.92866, 33.89741]]]} | Restricted Access 2 | 760 | Fullerton Municipal Golf Course | 32990 | 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 | 120.084 | Fullerton Municipal GC | 0 | Local Recreation Area 3 | 4 | |
16049 | 16049 | 16048 | {"type": "Polygon", "coordinates": [[[-117.98213, 33.89964], [-117.98201, 33.89994], [-117.9816, 33.90037], [-117.98186, 33.90053], [-117.98179, 33.90061], [-117.9815, 33.90046], [-117.98131, 33.90082], [-117.98106, 33.90164], [-117.98108, 33.90177], [-117.98124, 33.90184], [-117.98118, 33.90188], [-117.98106, 33.90183], [-117.9807, 33.9019], [-117.98061, 33.90176], [-117.98098, 33.90167], [-117.98103, 33.90155], [-117.98112, 33.90128], [-117.98115, 33.90098], [-117.98077, 33.90095], [-117.98063, 33.90112], [-117.98056, 33.90106], [-117.98036, 33.90105], [-117.9805, 33.90077], [-117.9805, 33.90075], [-117.98034, 33.90071], [-117.98029, 33.90071], [-117.98009, 33.90061], [-117.97983, 33.9006], [-117.97978, 33.90057], [-117.97953, 33.90058], [-117.97948, 33.90056], [-117.97928, 33.90062], [-117.97921, 33.9006], [-117.97904, 33.90069], [-117.979, 33.90068], [-117.97878, 33.90079], [-117.97859, 33.9009], [-117.97855, 33.90091], [-117.97842, 33.90106], [-117.9784, 33.90107], [-117.9783, 33.90121], [-117.97803, 33.90179], [-117.97828, 33.90196], [-117.97798, 33.90224], [-117.97789, 33.90228], [-117.97783, 33.90236], [-117.97773, 33.90242], [-117.97759, 33.90283], [-117.97662, 33.90283], [-117.97661, 33.90027], [-117.97673, 33.90028], [-117.97672, 33.90056], [-117.97714, 33.90057], [-117.97733, 33.90051], [-117.97736, 33.90052], [-117.97757, 33.90046], [-117.97775, 33.9004], [-117.97789, 33.90031], [-117.97792, 33.90031], [-117.97804, 33.9002], [-117.97808, 33.9002], [-117.97818, 33.90008], [-117.97823, 33.90005], [-117.97827, 33.90005], [-117.97841, 33.89998], [-117.97868, 33.89993], [-117.97868, 33.89984], [-117.97874, 33.89966], [-117.97888, 33.89947], [-117.97894, 33.89943], [-117.97896, 33.89927], [-117.97901, 33.89928], [-117.97908, 33.89915], [-117.97915, 33.89914], [-117.97929, 33.89906], [-117.97936, 33.89906], [-117.97943, 33.89901], [-117.97963, 33.89902], [-117.97977, 33.89886], [-117.9796, 33.8987], [-117.97979, 33.89877], [-117.9803, 33.89908], [-117.9803, 33.89912], [-117.98011, 33.89926], [-117.98009, 33.89928], [-117.97999, 33.89928], [-117.97994, 33.8993], [-117.97988, 33.89937], [-117.97989, 33.89946], [-117.97994, 33.89951], [-117.97984, 33.89974], [-117.98009, 33.89994], [-117.98043, 33.89981], [-117.98068, 33.8996], [-117.98075, 33.89941], [-117.98046, 33.89925], [-117.98047, 33.89922], [-117.98053, 33.89922], [-117.98078, 33.8993], [-117.98109, 33.89933], [-117.98106, 33.8995], [-117.98094, 33.89964], [-117.98073, 33.89971], [-117.98062, 33.89984], [-117.98098, 33.90006], [-117.98103, 33.90013], [-117.9811, 33.90016], [-117.98108, 33.9003], [-117.98139, 33.90049], [-117.98152, 33.90039], [-117.98165, 33.90025], [-117.98169, 33.90012], [-117.98198, 33.8997], [-117.98168, 33.8995], [-117.98172, 33.89949], [-117.98213, 33.89964]]]} | Open Access 1 | 6735 | 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 | 19.452 | City of Fullerton OS | 0 | Local Recreation Area 3 | 4 | |
16061 | 16061 | 16060 | {"type": "Polygon", "coordinates": [[[-117.97023, 33.89917], [-117.97021, 33.89933], [-117.96963, 33.89958], [-117.96963, 33.89989], [-117.96957, 33.89995], [-117.96904, 33.90024], [-117.96849, 33.90017], [-117.96744, 33.89986], [-117.96725, 33.89995], [-117.96756, 33.90066], [-117.96714, 33.90117], [-117.96635, 33.9012], [-117.96579, 33.90102], [-117.9654, 33.90083], [-117.9654, 33.90054], [-117.96535, 33.90033], [-117.96484, 33.90015], [-117.96465, 33.90027], [-117.96412, 33.90014], [-117.96316, 33.89986], [-117.96307, 33.8998], [-117.96295, 33.8998], [-117.96294, 33.89954], [-117.96284, 33.8995], [-117.96283, 33.89946], [-117.96323, 33.89943], [-117.96365, 33.89935], [-117.96366, 33.89936], [-117.96353, 33.89951], [-117.96373, 33.89956], [-117.96383, 33.89961], [-117.9642, 33.89992], [-117.96457, 33.90005], [-117.9648, 33.90009], [-117.96496, 33.90007], [-117.96506, 33.90008], [-117.96518, 33.90012], [-117.9653, 33.90019], [-117.96543, 33.9003], [-117.96556, 33.90049], [-117.96554, 33.90065], [-117.9656, 33.90076], [-117.96565, 33.90079], [-117.96574, 33.9008], [-117.96644, 33.90074], [-117.96644, 33.90068], [-117.96672, 33.90064], [-117.9668, 33.90061], [-117.96685, 33.90057], [-117.9669, 33.9005], [-117.96693, 33.90042], [-117.96693, 33.90028], [-117.96682, 33.89988], [-117.96682, 33.89976], [-117.96684, 33.89967], [-117.96691, 33.89953], [-117.96729, 33.89906], [-117.96767, 33.8992], [-117.96803, 33.89924], [-117.97023, 33.89917]]]} | Open Access 1 | 6922 | 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 | 11.203 | City of Fullerton OS | 0 | Local Recreation Area 3 | 4 | |
16066 | 16066 | 16065 | {"type": "Polygon", "coordinates": [[[-117.98464, 33.89987], [-117.98274, 33.90258], [-117.98262, 33.9026], [-117.98228, 33.90251], [-117.98194, 33.90248], [-117.98182, 33.90243], [-117.9817, 33.90245], [-117.98157, 33.90245], [-117.98153, 33.90239], [-117.98158, 33.90208], [-117.98162, 33.90205], [-117.9816, 33.90232], [-117.98229, 33.90238], [-117.98258, 33.90233], [-117.9828, 33.90217], [-117.98331, 33.90152], [-117.98301, 33.90136], [-117.9832, 33.90111], [-117.98353, 33.90126], [-117.98425, 33.90027], [-117.98434, 33.89998], [-117.984, 33.89981], [-117.98401, 33.89972], [-117.98397, 33.89964], [-117.98401, 33.8996], [-117.984, 33.89931], [-117.98295, 33.89932], [-117.98278, 33.89925], [-117.98273, 33.89925], [-117.98263, 33.8992], [-117.98212, 33.89921], [-117.98215, 33.89914], [-117.98222, 33.89916], [-117.98426, 33.89914], [-117.98427, 33.89969], [-117.98464, 33.89987]]]} | Open Access 1 | 7034 | 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 | 3.083 | City of Fullerton OS | 0 | Local Recreation Area 3 | 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]);