units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where DES_TP = 2, MNG_AGENCY = 138 and MNG_AG_TYP = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL
ACCESS_TYP 2
MNG_AG_TYP 1
- County Agency · 43 ✖
MNG_AGENCY 1
- Orange, County of · 43 ✖
DES_TP 1
- Local Park · 43 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
349 | 349 | 348 | {"type": "Polygon", "coordinates": [[[-117.81409, 33.75983], [-117.81374, 33.7598], [-117.81369, 33.75976], [-117.81367, 33.75975], [-117.81366, 33.75914], [-117.81378, 33.75944], [-117.81391, 33.75962], [-117.81409, 33.75983]]]} | Open Access 1 | 959 | Holderman Park | 20027 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 0.281 | Holderman Park | 0 | Local Park 2 | 4 | |
7781 | 7781 | 7780 | {"type": "Polygon", "coordinates": [[[-117.64544, 33.44089], [-117.64521, 33.44122], [-117.64472, 33.44093], [-117.64482, 33.44062], [-117.64519, 33.44075], [-117.64544, 33.44089]]]} | Open Access 1 | 8672 | Poche Beach Park | 23820 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 0.6 | Poche Beach Park | 0 | Local Park 2 | 4 | |
2917 | 2917 | 2916 | {"type": "Polygon", "coordinates": [[[-117.97887, 33.74548], [-117.9787, 33.74549], [-117.97867, 33.74567], [-117.97867, 33.74584], [-117.9787, 33.74593], [-117.97872, 33.74606], [-117.97848, 33.74607], [-117.97846, 33.74505], [-117.97886, 33.74505], [-117.97887, 33.74548]]]} | Open Access 1 | 19011 | Roger Stanton Park | 24560 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 0.748 | Roger Stanton Park | 0 | Local Park 2 | 4 | |
639 | 639 | 638 | {"type": "Polygon", "coordinates": [[[-117.88348, 33.60245], [-117.88321, 33.60315], [-117.88242, 33.60231], [-117.88295, 33.60212], [-117.88348, 33.60245]]]} | Open Access 1 | 2654 | Bayside Drive Beach | 15893 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 1.344 | Bayside Drive Beach | 0 | Local Park 2 | 4 | |
2697 | 2697 | 2696 | {"type": "Polygon", "coordinates": [[[-117.80432, 33.54625], [-117.80431, 33.54636], [-117.80425, 33.54646], [-117.80426, 33.54653], [-117.80399, 33.54715], [-117.80384, 33.54717], [-117.80374, 33.54724], [-117.80339, 33.54663], [-117.80347, 33.54661], [-117.80351, 33.54656], [-117.80354, 33.54652], [-117.80361, 33.54645], [-117.80363, 33.54639], [-117.80376, 33.54626], [-117.80381, 33.54617], [-117.80386, 33.54614], [-117.80407, 33.54613], [-117.80418, 33.54616], [-117.80432, 33.54625]]]} | Open Access 1 | 18271 | Crescent Bay Point Park | 17792 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 1.554 | Crescent Bay Point Park | 0 | Local Park 2 | 4 | |
4877 | 4877 | 4876 | {"type": "MultiPolygon", "coordinates": [[[[-117.73308, 33.48522], [-117.73289, 33.48521], [-117.73229, 33.48504], [-117.7323, 33.485], [-117.73242, 33.48488], [-117.73261, 33.48494], [-117.73285, 33.4851], [-117.73308, 33.4852], [-117.73308, 33.48522]]], [[[-117.73417, 33.48423], [-117.73424, 33.48433], [-117.73428, 33.48455], [-117.73438, 33.48473], [-117.73445, 33.48482], [-117.73459, 33.48494], [-117.7347, 33.48509], [-117.73475, 33.48525], [-117.73475, 33.48545], [-117.73472, 33.48565], [-117.73466, 33.48576], [-117.73453, 33.48585], [-117.73434, 33.48592], [-117.73422, 33.486], [-117.73406, 33.48604], [-117.73397, 33.48609], [-117.73394, 33.48617], [-117.73395, 33.48622], [-117.73401, 33.48623], [-117.73402, 33.48629], [-117.73394, 33.48637], [-117.73382, 33.48647], [-117.73383, 33.48592], [-117.73445, 33.48556], [-117.73437, 33.48497], [-117.73387, 33.48435], [-117.73396, 33.48425], [-117.73402, 33.48421], [-117.73409, 33.4842], [-117.73417, 33.48423]]]]} | Open Access 1 | 14749 | Three Arch Cove Beach | 26330 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 1.921 | Three Arch Cove Beach | 0 | Local Park 2 | 4 | |
6629 | 6629 | 6628 | {"type": "Polygon", "coordinates": [[[-117.61031, 33.64797], [-117.61017, 33.64805], [-117.60994, 33.64812], [-117.60981, 33.64818], [-117.60961, 33.64834], [-117.60957, 33.64841], [-117.60956, 33.64848], [-117.6096, 33.64857], [-117.60991, 33.64887], [-117.61001, 33.64902], [-117.61003, 33.64908], [-117.61, 33.64911], [-117.60957, 33.64928], [-117.60952, 33.64936], [-117.60953, 33.64945], [-117.60924, 33.64954], [-117.60928, 33.64947], [-117.60912, 33.64938], [-117.609, 33.64924], [-117.6092, 33.64915], [-117.60923, 33.64911], [-117.60917, 33.64897], [-117.60904, 33.6488], [-117.60899, 33.64862], [-117.60894, 33.64857], [-117.6091, 33.64835], [-117.60916, 33.64831], [-117.60923, 33.64833], [-117.60934, 33.64843], [-117.60942, 33.64844], [-117.60956, 33.64815], [-117.60969, 33.64818], [-117.60975, 33.6481], [-117.60982, 33.64806], [-117.60987, 33.64799], [-117.60993, 33.64798], [-117.6101, 33.6479], [-117.61025, 33.64796], [-117.61029, 33.64795], [-117.61031, 33.64797]]]} | Open Access 1 | 4357 | Estrella Vista Park | 18731 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.124 | Estrella Vista Park | 0 | Local Park 2 | 4 | |
12974 | 12974 | 12973 | {"type": "Polygon", "coordinates": [[[-117.70336, 33.46304], [-117.70315, 33.46314], [-117.70309, 33.46314], [-117.70304, 33.46313], [-117.70269, 33.46299], [-117.7024, 33.46291], [-117.70217, 33.46291], [-117.70183, 33.46292], [-117.70152, 33.46295], [-117.70114, 33.46296], [-117.70088, 33.4629], [-117.70063, 33.4628], [-117.7, 33.4624], [-117.6998, 33.46235], [-117.69981, 33.4623], [-117.6991, 33.46214], [-117.69895, 33.46208], [-117.69898, 33.46201], [-117.70336, 33.46304]]]} | Open Access 1 | 30536 | Dana Cove Park | 17908 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.383 | Dana Cove Park | 0 | Local Park 2 | 4 | |
12982 | 12982 | 12981 | {"type": "Polygon", "coordinates": [[[-117.88557, 33.90604], [-117.88552, 33.9061], [-117.88537, 33.90606], [-117.88523, 33.90589], [-117.8851, 33.9056], [-117.88475, 33.90521], [-117.88437, 33.90554], [-117.88411, 33.9054], [-117.88466, 33.90489], [-117.88471, 33.90482], [-117.8847, 33.90456], [-117.88463, 33.90446], [-117.88463, 33.9043], [-117.88473, 33.90417], [-117.88498, 33.90406], [-117.8852, 33.90402], [-117.88534, 33.90411], [-117.88542, 33.90436], [-117.88526, 33.90474], [-117.88526, 33.90495], [-117.88544, 33.9058], [-117.88557, 33.90604]]]} | Open Access 1 | 30439 | Craig Regional Park | 17752 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.996 | Craig RP | 0 | Local Park 2 | 4 | |
12977 | 12977 | 12976 | {"type": "Polygon", "coordinates": [[[-117.78424, 33.86528], [-117.78305, 33.86527], [-117.78304, 33.8649], [-117.78267, 33.86486], [-117.78237, 33.86485], [-117.78238, 33.86457], [-117.78242, 33.86453], [-117.78244, 33.86454], [-117.78255, 33.86453], [-117.7837, 33.8643], [-117.78397, 33.86429], [-117.78402, 33.86476], [-117.78407, 33.86489], [-117.7841, 33.86489], [-117.78419, 33.86506], [-117.78423, 33.86516], [-117.78424, 33.86528]]]} | Open Access 1 | 30443 | Woodgate Park | 27710 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 3.092 | Woodgate Park | 0 | Local Park 2 | 4 | |
9945 | 9945 | 9944 | {"type": "Polygon", "coordinates": [[[-117.75367, 33.87309], [-117.7534, 33.8731], [-117.75323, 33.87313], [-117.75305, 33.87321], [-117.75276, 33.87329], [-117.75249, 33.8734], [-117.7522, 33.87353], [-117.75193, 33.87367], [-117.75157, 33.87392], [-117.75115, 33.87428], [-117.75095, 33.87452], [-117.7508, 33.87474], [-117.7507, 33.87478], [-117.74982, 33.87457], [-117.75063, 33.8741], [-117.75188, 33.87343], [-117.75274, 33.87301], [-117.75361, 33.87262], [-117.75367, 33.87309]]]} | Open Access 1 | 47963 | Yorba Regional Park | 27778 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.ocparks.com/parks/yorba | Orange 3 | 3.53 | Yorba RP | 0 | Local Park 2 | 4 |
720 | 720 | 719 | {"type": "Polygon", "coordinates": [[[-117.64606, 33.71715], [-117.64569, 33.71705], [-117.6455, 33.71693], [-117.64478, 33.71604], [-117.64591, 33.71499], [-117.64598, 33.71518], [-117.64608, 33.71555], [-117.64612, 33.7158], [-117.64612, 33.71618], [-117.64606, 33.71715]]]} | Open Access 1 | 5401 | Modjeska Home and Garden | 22342 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 4.245 | Modjeska Home and Garden | 0 | Local Park 2 | 4 | |
1731 | 1731 | 1730 | {"type": "MultiPolygon", "coordinates": [[[[-117.81129, 33.76654], [-117.81097, 33.77124], [-117.8108, 33.77342], [-117.81067, 33.77342], [-117.81095, 33.76974], [-117.81117, 33.76654], [-117.81129, 33.76654]]], [[[-117.81175, 33.75996], [-117.81146, 33.76454], [-117.81131, 33.76637], [-117.81119, 33.76638], [-117.81132, 33.76454], [-117.81133, 33.76422], [-117.8115, 33.76143], [-117.81161, 33.75995], [-117.81175, 33.75996]]]]} | Open Access 1 | 12930 | Esplanade Park | 18714 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 4.697 | Esplanade Park | 0 | Local Park 2 | 4 | |
8270 | 8270 | 8269 | {"type": "Polygon", "coordinates": [[[-117.71813, 33.46914], [-117.71782, 33.46914], [-117.71759, 33.46875], [-117.71627, 33.4669], [-117.71623, 33.46688], [-117.71581, 33.46699], [-117.71576, 33.46684], [-117.71616, 33.46674], [-117.71618, 33.46673], [-117.71618, 33.46669], [-117.71605, 33.46642], [-117.71602, 33.4663], [-117.71589, 33.46599], [-117.71512, 33.46478], [-117.71464, 33.46368], [-117.71535, 33.46391], [-117.71545, 33.46419], [-117.71551, 33.4647], [-117.71576, 33.46533], [-117.71605, 33.46569], [-117.71634, 33.46625], [-117.71644, 33.46654], [-117.71691, 33.46711], [-117.71701, 33.46745], [-117.71715, 33.46761], [-117.71731, 33.46791], [-117.71741, 33.46805], [-117.71749, 33.46833], [-117.71763, 33.46861], [-117.71779, 33.4688], [-117.71797, 33.46895], [-117.71813, 33.46914]]]} | Open Access 1 | 12658 | Silver Strand Beach County Park | 25495 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.163 | Silver Strand Beach County Park | 0 | Local Park 2 | 4 | |
11325 | 11325 | 11324 | {"type": "Polygon", "coordinates": [[[-117.71884, 33.57576], [-117.71881, 33.57578], [-117.71873, 33.57603], [-117.71834, 33.57736], [-117.71799, 33.57769], [-117.7177, 33.57776], [-117.71697, 33.5773], [-117.71696, 33.57726], [-117.7171, 33.57705], [-117.71724, 33.57692], [-117.71744, 33.57679], [-117.71759, 33.57667], [-117.71771, 33.57652], [-117.71775, 33.5765], [-117.71782, 33.57635], [-117.71788, 33.57615], [-117.71789, 33.57604], [-117.71787, 33.57583], [-117.71784, 33.57569], [-117.71784, 33.57561], [-117.71795, 33.57538], [-117.71804, 33.57492], [-117.71858, 33.57549], [-117.71849, 33.57547], [-117.71841, 33.57548], [-117.71836, 33.5755], [-117.71832, 33.57555], [-117.7183, 33.5756], [-117.71834, 33.57569], [-117.71842, 33.57574], [-117.71849, 33.57574], [-117.71873, 33.57565], [-117.71884, 33.57576]]]} | Open Access 1 | 22038 | Springdale Park | 25746 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.781 | Springdale Park | 0 | Local Park 2 | 4 | |
8133 | 8133 | 8132 | {"type": "Polygon", "coordinates": [[[-117.71925, 33.56722], [-117.71925, 33.56736], [-117.71915, 33.56784], [-117.71894, 33.5685], [-117.71855, 33.56855], [-117.71852, 33.56887], [-117.71822, 33.56895], [-117.71714, 33.56676], [-117.71752, 33.56632], [-117.71893, 33.56711], [-117.71925, 33.56722]]]} | Open Access 1 | 12312 | Foxborough Park | 19036 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 7.537 | Foxborough Park | 0 | Local Park 2 | 4 | |
12988 | 12988 | 12987 | {"type": "MultiPolygon", "coordinates": [[[[-117.94078, 33.72981], [-117.94076, 33.72992], [-117.94065, 33.72997], [-117.94042, 33.72998], [-117.94018, 33.72995], [-117.93999, 33.73001], [-117.93965, 33.73022], [-117.93923, 33.73019], [-117.93905, 33.73009], [-117.939, 33.73], [-117.93904, 33.72987], [-117.93924, 33.72965], [-117.93929, 33.72954], [-117.93926, 33.72947], [-117.93917, 33.7294], [-117.93901, 33.72944], [-117.93881, 33.72953], [-117.93866, 33.72957], [-117.93843, 33.7295], [-117.9382, 33.72936], [-117.93814, 33.72924], [-117.93813, 33.72902], [-117.93826, 33.72888], [-117.93844, 33.72881], [-117.93862, 33.72866], [-117.93864, 33.72849], [-117.9386, 33.72838], [-117.9386, 33.72826], [-117.93866, 33.72817], [-117.93888, 33.72811], [-117.93937, 33.72832], [-117.93961, 33.72845], [-117.93968, 33.72854], [-117.9397, 33.7287], [-117.93975, 33.72889], [-117.93986, 33.729], [-117.94003, 33.72911], [-117.94034, 33.72921], [-117.94056, 33.7293], [-117.94064, 33.7294], [-117.94071, 33.72968], [-117.94078, 33.72981]]], [[[-117.94051, 33.71887], [-117.94046, 33.71902], [-117.94034, 33.71915], [-117.94015, 33.71919], [-117.9399, 33.7192], [-117.93971, 33.71917], [-117.93953, 33.71918], [-117.93936, 33.7193], [-117.93932, 33.71929], [-117.93906, 33.71943], [-117.93888, 33.71943], [-117.93871, 33.71935], [-117.93864, 33.71924], [-117.93864, 33.71908], [-117.93877, 33.71885], [-117.93875, 33.71864], [-117.93877, 33.71852], [-117.93887, 33.71841], [-117.93923, 33.71842], [-117.93936, 33.71837], [-117.93944, 33.71815], [-117.93955, 33.71808], [-117.9397, 33.71805], [-117.93983, 33.71807], [-117.93998, 33.71812], [-117.94011, 33.71824], [-117.94014, 33.71842], [-117.9403, 33.71855], [-117.94046, 33.71864], [-117.94051, 33.71887]]]]} | Open Access 1 | 30460 | Mile Square Regional Park | 22217 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 11.59 | Mile Square RP | 0 | Local Park 2 | 4 | |
6570 | 6570 | 6569 | {"type": "MultiPolygon", "coordinates": [[[[-117.69044, 33.46418], [-117.69034, 33.46429], [-117.69023, 33.46447], [-117.69002, 33.46503], [-117.68829, 33.46459], [-117.68888, 33.46407], [-117.68896, 33.46406], [-117.68911, 33.46414], [-117.68937, 33.46441], [-117.68946, 33.46447], [-117.68962, 33.4645], [-117.68977, 33.46451], [-117.68996, 33.46447], [-117.69008, 33.46442], [-117.69044, 33.46418]]], [[[-117.69419, 33.46413], [-117.69416, 33.46417], [-117.69406, 33.46424], [-117.69374, 33.46433], [-117.69359, 33.4644], [-117.69355, 33.46427], [-117.69347, 33.46415], [-117.69334, 33.46406], [-117.69324, 33.46402], [-117.69313, 33.46401], [-117.69291, 33.46402], [-117.69269, 33.464], [-117.69209, 33.46393], [-117.69148, 33.46393], [-117.69151, 33.46387], [-117.69148, 33.4638], [-117.6914, 33.46375], [-117.69133, 33.46374], [-117.69118, 33.46379], [-117.69098, 33.4638], [-117.69085, 33.46382], [-117.69069, 33.46388], [-117.69039, 33.46403], [-117.69004, 33.46427], [-117.68981, 33.46437], [-117.68966, 33.46438], [-117.68956, 33.46436], [-117.68947, 33.46432], [-117.68911, 33.46392], [-117.68911, 33.46386], [-117.68941, 33.46363], [-117.68956, 33.46354], [-117.68997, 33.46325], [-117.69023, 33.4631], [-117.69063, 33.46296], [-117.69143, 33.46279], [-117.69352, 33.46272], [-117.69359, 33.46279], [-117.69359, 33.46298], [-117.69361, 33.46311], [-117.69368, 33.46339], [-117.69375, 33.46357], [-117.69395, 33.46387], [-117.69419, 33.46413]]]]} | Open Access 1 | 3587 | Lantern Bay Park | 21016 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 15.065 | Lantern Bay Park | 0 | Local Park 2 | 4 | |
16364 | 16364 | 16363 | {"type": "Polygon", "coordinates": [[[-117.78127, 33.86017], [-117.78126, 33.86048], [-117.78076, 33.86071], [-117.76229, 33.86967], [-117.76089, 33.87029], [-117.75995, 33.87067], [-117.7585, 33.8712], [-117.75664, 33.8718], [-117.75577, 33.87211], [-117.75492, 33.87244], [-117.75365, 33.87297], [-117.75361, 33.87262], [-117.75407, 33.87242], [-117.75549, 33.87185], [-117.75646, 33.87151], [-117.75743, 33.87119], [-117.75748, 33.87124], [-117.75843, 33.87093], [-117.75937, 33.87059], [-117.76077, 33.87004], [-117.76213, 33.86943], [-117.78035, 33.86059], [-117.78127, 33.86017]]]} | Open Access 1 | 47964 | Yorba Regional Park | 27778 | 2420 | Orange County Flood Control District 1171 | Special District 4 | Flood District 8 | http://www.ocflood.com/ | Special District 4 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.ocparks.com/parks/yorba | Orange 3 | 22.503 | Yorba RP | 0 | Local Park 2 | 4 |
11426 | 11426 | 11425 | {"type": "Polygon", "coordinates": [[[-117.72332, 33.5635], [-117.72297, 33.56336], [-117.72223, 33.56295], [-117.72187, 33.56267], [-117.72153, 33.56236], [-117.72132, 33.5621], [-117.72113, 33.56181], [-117.72104, 33.56147], [-117.72087, 33.56092], [-117.7207, 33.56059], [-117.7207, 33.56051], [-117.7206, 33.56017], [-117.72038, 33.55978], [-117.72018, 33.55956], [-117.71985, 33.5593], [-117.71958, 33.55916], [-117.71884, 33.55882], [-117.71903, 33.55868], [-117.7184, 33.55712], [-117.71842, 33.55691], [-117.71838, 33.55634], [-117.71839, 33.55617], [-117.71845, 33.55603], [-117.71842, 33.55601], [-117.71858, 33.55577], [-117.71876, 33.55579], [-117.71875, 33.55589], [-117.71927, 33.55597], [-117.7193, 33.55588], [-117.71994, 33.55599], [-117.71998, 33.55618], [-117.71981, 33.55721], [-117.71994, 33.55777], [-117.72054, 33.55825], [-117.7218, 33.56002], [-117.72219, 33.56026], [-117.72224, 33.56043], [-117.72228, 33.56042], [-117.72238, 33.56071], [-117.72252, 33.56116], [-117.72209, 33.56196], [-117.72211, 33.5622], [-117.72214, 33.56232], [-117.72234, 33.56265], [-117.72257, 33.5629], [-117.72257, 33.56293], [-117.72332, 33.5635]]]} | Open Access 1 | 22280 | Hillview Park | 19992 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 24.716 | Hillview 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]);