units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, AGNCY_NAME = 142 and DES_TP = 3
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 1
ACCESS_TYP 1
- Open Access · 3 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5200 | 5200 | 5199 | {"type": "MultiPolygon", "coordinates": [[[[-117.67339, 33.63513], [-117.67274, 33.63562], [-117.67252, 33.63583], [-117.67227, 33.63618], [-117.67222, 33.63633], [-117.67221, 33.63656], [-117.67246, 33.63654], [-117.67268, 33.63669], [-117.67244, 33.63722], [-117.6725, 33.63728], [-117.67219, 33.6375], [-117.67205, 33.63786], [-117.67164, 33.63811], [-117.67151, 33.63824], [-117.67119, 33.63911], [-117.67077, 33.63963], [-117.67087, 33.6397], [-117.67099, 33.6397], [-117.67073, 33.63992], [-117.67073, 33.63982], [-117.67051, 33.63964], [-117.67033, 33.63966], [-117.66992, 33.64057], [-117.66954, 33.64096], [-117.66945, 33.64111], [-117.66885, 33.64158], [-117.66848, 33.64251], [-117.66832, 33.64266], [-117.66798, 33.64287], [-117.66827, 33.64325], [-117.66818, 33.64358], [-117.66789, 33.64361], [-117.66762, 33.64368], [-117.66672, 33.64404], [-117.66673, 33.64407], [-117.66671, 33.64409], [-117.66663, 33.64436], [-117.66654, 33.64454], [-117.66653, 33.64478], [-117.66671, 33.64513], [-117.66644, 33.64529], [-117.66621, 33.6455], [-117.66576, 33.64614], [-117.66609, 33.64631], [-117.66561, 33.64698], [-117.66528, 33.64684], [-117.665, 33.64719], [-117.6645, 33.64762], [-117.6641, 33.64793], [-117.66394, 33.64812], [-117.66366, 33.64852], [-117.66336, 33.64919], [-117.66328, 33.64947], [-117.66326, 33.64975], [-117.66333, 33.65004], [-117.66269, 33.6505], [-117.66179, 33.65181], [-117.66136, 33.65233], [-117.66137, 33.65234], [-117.66167, 33.65252], [-117.66134, 33.6529], [-117.66134, 33.65292], [-117.66102, 33.65276], [-117.66085, 33.65298], [-117.66065, 33.65342], [-117.66055, 33.65389], [-117.66055, 33.65437], [-117.66061, 33.6548], [-117.66, 33.65484], [-117.65976, 33.65482], [-117.65968, 33.65519], [-117.65928, 33.65561], [-117.65938, 33.65626], [-117.65867, 33.65672], [-117.65831, 33.6571], [-117.65831, 33.65768], [-117.65798, 33.65901], [-117.6576, 33.65927], [-117.65734, 33.65879], [-117.65697, 33.65874], [-117.657, 33.65856], [-117.6572, 33.65837], [-117.65731, 33.65822], [-117.65742, 33.65803], [-117.65754, 33.65771], [-117.65792, 33.65713], [-117.65795, 33.65704], [-117.65875, 33.65555], [-117.65935, 33.65425], [-117.6601, 33.65256], [-117.66033, 33.65196], [-117.66043, 33.65158], [-117.66057, 33.65085], [-117.66076, 33.65005], [-117.66086, 33.64976], [-117.66102, 33.64943], [-117.66128, 33.64905], [-117.66152, 33.64873], [-117.66183, 33.6484], [-117.66393, 33.64652], [-117.66437, 33.64608], [-117.66523, 33.64506], [-117.66547, 33.64484], [-117.66577, 33.64461], [-117.66577, 33.64459], [-117.66548, 33.64438], [-117.66545, 33.64438], [-117.66567, 33.6442], [-117.66566, 33.64374], [-117.66572, 33.64358], [-117.66587, 33.64342], [-117.66625, 33.6431], [-117.6666, 33.64292], [-117.66687, 33.64298], [-117.66717, 33.64284], [-117.66729, 33.64269], [-117.66785, 33.64256], [-117.66798, 33.64247], [-117.66821, 33.64209], [-117.66812, 33.64196], [-117.66796, 33.64192], [-117.66805, 33.64171], [-117.66802, 33.64162], [-117.66807, 33.64159], [-117.66811, 33.64152], [-117.66814, 33.64135], [-117.66831, 33.64116], [-117.66842, 33.6411], [-117.66876, 33.64094], [-117.66886, 33.64086], [-117.66935, 33.64026], [-117.66943, 33.64], [-117.66943, 33.6396], [-117.6695, 33.63936], [-117.66957, 33.63925], [-117.66977, 33.63906], [-117.66982, 33.63904], [-117.66988, 33.63904], [-117.67001, 33.63894], [-117.67, 33.63892], [-117.66998, 33.63894], [-117.66997, 33.63892], [-117.66999, 33.63889], [-117.67037, 33.63855], [-117.67046, 33.63843], [-117.67051, 33.63831], [-117.67053, 33.63818], [-117.67052, 33.63791], [-117.67054, 33.6378], [-117.67058, 33.6377], [-117.67066, 33.63759], [-117.67085, 33.6374], [-117.67092, 33.63729], [-117.671, 33.6371], [-117.67106, 33.63699], [-117.6712, 33.63685], [-117.67138, 33.63672], [-117.67148, 33.63663], [-117.67155, 33.63652], [-117.67161, 33.63639], [-117.67164, 33.63626], [-117.67164, 33.63614], [-117.67158, 33.63589], [-117.67158, 33.63579], [-117.67161, 33.63567], [-117.67173, 33.63547], [-117.67182, 33.63538], [-117.67193, 33.63531], [-117.67206, 33.63526], [-117.67235, 33.63519], [-117.6725, 33.63512], [-117.67257, 33.63507], [-117.6726, 33.635], [-117.67261, 33.63493], [-117.6726, 33.63486], [-117.67254, 33.63481], [-117.67278, 33.63461], [-117.67339, 33.63513]]], [[[-117.65995, 33.65983], [-117.65924, 33.66003], [-117.65848, 33.66011], [-117.65819, 33.66003], [-117.65767, 33.65947], [-117.65796, 33.65928], [-117.65824, 33.65925], [-117.65828, 33.65934], [-117.65852, 33.65956], [-117.65987, 33.65959], [-117.65995, 33.65983]]], [[[-117.65959, 33.65875], [-117.65959, 33.65888], [-117.65889, 33.65885], [-117.65891, 33.65877], [-117.65895, 33.65874], [-117.65959, 33.65875]]], [[[-117.68678, 33.6252], [-117.68659, 33.62536], [-117.68659, 33.62543], [-117.68657, 33.62543], [-117.6865, 33.62548], [-117.68648, 33.62556], [-117.68633, 33.62556], [-117.68596, 33.62587], [-117.68596, 33.62595], [-117.68587, 33.62599], [-117.68582, 33.62606], [-117.68573, 33.62605], [-117.68526, 33.62643], [-117.68532, 33.62649], [-117.6852, 33.62658], [-117.6852, 33.62666], [-117.68522, 33.6267], [-117.68503, 33.62686], [-117.68514, 33.62696], [-117.68497, 33.62711], [-117.68497, 33.62718], [-117.68491, 33.62718], [-117.68483, 33.62723], [-117.68481, 33.62727], [-117.68481, 33.62734], [-117.68486, 33.6274], [-117.68446, 33.62773], [-117.68449, 33.62782], [-117.6844, 33.62787], [-117.68438, 33.62792], [-117.68439, 33.628], [-117.68436, 33.62801], [-117.68428, 33.62816], [-117.68412, 33.62838], [-117.68425, 33.62864], [-117.68444, 33.62881], [-117.6843, 33.62881], [-117.68415, 33.62878], [-117.68372, 33.62864], [-117.6836, 33.62862], [-117.68339, 33.62862], [-117.68323, 33.62865], [-117.68151, 33.62911], [-117.68136, 33.62913], [-117.68106, 33.62924], [-117.67999, 33.63011], [-117.67993, 33.63022], [-117.67988, 33.63034], [-117.67987, 33.63061], [-117.67992, 33.63077], [-117.68004, 33.63097], [-117.67952, 33.63048], [-117.67922, 33.63072], [-117.67927, 33.6308], [-117.67924, 33.63082], [-117.67922, 33.63086], [-117.67908, 33.63084], [-117.67885, 33.63102], [-117.67886, 33.63105], [-117.67863, 33.63124], [-117.67868, 33.63134], [-117.67862, 33.63138], [-117.67861, 33.63143], [-117.67849, 33.63141], [-117.67825, 33.63159], [-117.67834, 33.63168], [-117.67811, 33.63188], [-117.67811, 33.63192], [-117.67802, 33.63196], [-117.678, 33.63201], [-117.67792, 33.632], [-117.67767, 33.63219], [-117.6777, 33.63223], [-117.67752, 33.6324], [-117.67757, 33.63256], [-117.67752, 33.63258], [-117.67747, 33.63264], [-117.67747, 33.63268], [-117.67753, 33.63274], [-117.67752, 33.63277], [-117.67754, 33.63279], [-117.67746, 33.63292], [-117.67756, 33.63303], [-117.67736, 33.63326], [-117.67738, 33.63333], [-117.67733, 33.63335], [-117.67728, 33.63341], [-117.67728, 33.63347], [-117.67732, 33.63351], [-117.67726, 33.63356], [-117.67694, 33.63395], [-117.67628, 33.63376], [-117.67616, 33.63382], [-117.67608, 33.63378], [-117.67598, 33.63378], [-117.6759, 33.63385], [-117.6758, 33.63381], [-117.67533, 33.63387], [-117.67534, 33.63383], [-117.67638, 33.633], [-117.67634, 33.63293], [-117.67668, 33.63278], [-117.67654, 33.63259], [-117.67676, 33.63247], [-117.67682, 33.63237], [-117.67692, 33.63222], [-117.67707, 33.63206], [-117.67732, 33.63185], [-117.67736, 33.63187], [-117.67755, 33.63172], [-117.67752, 33.63169], [-117.67758, 33.63163], [-117.67741, 33.6315], [-117.67752, 33.6313], [-117.67762, 33.631], [-117.67774, 33.63077], [-117.67784, 33.63066], [-117.67822, 33.63049], [-117.67843, 33.63045], [-117.67858, 33.63041], [-117.67873, 33.63033], [-117.67922, 33.62995], [-117.67936, 33.62983], [-117.67953, 33.62966], [-117.67974, 33.62941], [-117.67996, 33.6291], [-117.68007, 33.62885], [-117.68026, 33.62851], [-117.68036, 33.6284], [-117.68043, 33.6283], [-117.68046, 33.62814], [-117.68045, 33.62796], [-117.68041, 33.62781], [-117.68036, 33.62767], [-117.68023, 33.6275], [-117.68052, 33.62727], [-117.68196, 33.62851], [-117.68348, 33.62728], [-117.68366, 33.62698], [-117.68422, 33.62639], [-117.68449, 33.62599], [-117.68467, 33.62614], [-117.68476, 33.62613], [-117.68482, 33.62606], [-117.68492, 33.62614], [-117.6866, 33.62477], [-117.68678, 33.6252]]], [[[-117.68005, 33.63097], [-117.68008, 33.631], [-117.68008, 33.63101], [-117.68008, 33.63101], [-117.68005, 33.63097]]], [[[-117.6958, 33.61292], [-117.69566, 33.61315], [-117.69531, 33.6131], [-117.69534, 33.61303], [-117.69537, 33.61282], [-117.69535, 33.6126], [-117.69529, 33.6124], [-117.69517, 33.6122], [-117.695, 33.61203], [-117.69481, 33.61188], [-117.69458, 33.61178], [-117.69392, 33.61163], [-117.69373, 33.61158], [-117.69351, 33.61149], [-117.69334, 33.6114], [-117.6932, 33.61128], [-117.69295, 33.61101], [-117.69265, 33.61115], [-117.69293, 33.611], [-117.69283, 33.61082], [-117.69273, 33.61049], [-117.69274, 33.61034], [-117.69272, 33.60982], [-117.69276, 33.60956], [-117.69286, 33.60933], [-117.69371, 33.60809], [-117.69478, 33.60647], [-117.69406, 33.60611], [-117.69396, 33.60604], [-117.69397, 33.60564], [-117.69405, 33.6057], [-117.69417, 33.60568], [-117.6942, 33.60573], [-117.69427, 33.60577], [-117.69435, 33.60577], [-117.69441, 33.60573], [-117.69449, 33.60587], [-117.69489, 33.60609], [-117.69498, 33.60608], [-117.69501, 33.60616], [-117.69508, 33.6062], [-117.69518, 33.6062], [-117.6952, 33.60618], [-117.69553, 33.60618], [-117.69519, 33.60656], [-117.69537, 33.60666], [-117.6946, 33.60724], [-117.69315, 33.60938], [-117.69309, 33.60949], [-117.69303, 33.60965], [-117.69301, 33.60987], [-117.69302, 33.61041], [-117.69306, 33.61064], [-117.69316, 33.61084], [-117.6933, 33.61103], [-117.69349, 33.61119], [-117.6937, 33.61131], [-117.69395, 33.6114], [-117.69456, 33.61153], [-117.69472, 33.61159], [-117.69488, 33.61165], [-117.69503, 33.61174], [-117.69525, 33.6119], [-117.69539, 33.61206], [-117.69554, 33.61229], [-117.69562, 33.61252], [-117.69566, 33.61279], [-117.6958, 33.61292]]], [[[-117.69774, 33.60765], [-117.6977, 33.60775], [-117.69716, 33.60756], [-117.69725, 33.60735], [-117.69747, 33.6071], [-117.6976, 33.60676], [-117.69762, 33.60675], [-117.69765, 33.60675], [-117.69772, 33.60697], [-117.69768, 33.60698], [-117.69764, 33.60702], [-117.69761, 33.60709], [-117.69752, 33.60709], [-117.6973, 33.60734], [-117.69774, 33.60765]]], [[[-117.70033, 33.60529], [-117.6999, 33.60538], [-117.69965, 33.60541], [-117.69945, 33.60555], [-117.69944, 33.60551], [-117.69969, 33.60533], [-117.69981, 33.6053], [-117.69995, 33.60531], [-117.69999, 33.6053], [-117.70005, 33.60525], [-117.70006, 33.60516], [-117.70033, 33.60529]]], [[[-117.71085, 33.59544], [-117.71082, 33.59549], [-117.71058, 33.59556], [-117.71037, 33.59593], [-117.71035, 33.59601], [-117.71028, 33.5976], [-117.71024, 33.59776], [-117.71014, 33.59793], [-117.70997, 33.5981], [-117.70937, 33.5984], [-117.70891, 33.5987], [-117.70874, 33.59888], [-117.70816, 33.59962], [-117.70764, 33.60037], [-117.70749, 33.60051], [-117.70706, 33.60056], [-117.70696, 33.6006], [-117.70696, 33.60061], [-117.70704, 33.60069], [-117.70466, 33.60241], [-117.70299, 33.60304], [-117.70259, 33.60311], [-117.70246, 33.60262], [-117.70286, 33.60255], [-117.70332, 33.60226], [-117.70443, 33.60183], [-117.70473, 33.60156], [-117.70501, 33.6009], [-117.70616, 33.60032], [-117.70682, 33.60018], [-117.70777, 33.59954], [-117.70807, 33.59917], [-117.70852, 33.59842], [-117.70868, 33.5984], [-117.70907, 33.59813], [-117.70966, 33.59784], [-117.70974, 33.59778], [-117.70981, 33.59767], [-117.70985, 33.59756], [-117.70993, 33.59575], [-117.71015, 33.59517], [-117.71085, 33.59544]]]]} | Open Access 1 | 15865 | Aliso Creek Greenbelt | 15372 | 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 | 138.055 | Aliso Creek Greenbelt | 0 | Local Recreation Area 3 | 4 | |
| 8037 | 8037 | 8036 | {"type": "Polygon", "coordinates": [[[-117.958, 33.63182], [-117.95451, 33.6433], [-117.95349, 33.6469], [-117.95241, 33.65046], [-117.95155, 33.65368], [-117.95038, 33.65777], [-117.95028, 33.65793], [-117.94621, 33.67223], [-117.94617, 33.67255], [-117.94536, 33.67535], [-117.94493, 33.67669], [-117.94386, 33.67968], [-117.94311, 33.68154], [-117.94229, 33.68339], [-117.94154, 33.68494], [-117.94051, 33.68687], [-117.93973, 33.68823], [-117.93913, 33.68922], [-117.93869, 33.68993], [-117.93683, 33.69276], [-117.93581, 33.69429], [-117.93582, 33.69431], [-117.9359, 33.69431], [-117.93313, 33.69845], [-117.92833, 33.70568], [-117.92833, 33.70579], [-117.92731, 33.70727], [-117.92712, 33.70753], [-117.92709, 33.70753], [-117.92639, 33.70861], [-117.92207, 33.7151], [-117.92123, 33.7164], [-117.9211, 33.71664], [-117.92059, 33.71741], [-117.92048, 33.71762], [-117.91981, 33.71877], [-117.91981, 33.71881], [-117.91892, 33.72044], [-117.91825, 33.72178], [-117.91786, 33.72259], [-117.91691, 33.72472], [-117.9162, 33.72648], [-117.91584, 33.72746], [-117.91541, 33.72869], [-117.9144, 33.73232], [-117.91384, 33.73467], [-117.91357, 33.736], [-117.91301, 33.7392], [-117.9128, 33.7403], [-117.91221, 33.74282], [-117.912, 33.74358], [-117.91151, 33.74504], [-117.91144, 33.74517], [-117.91113, 33.74593], [-117.91067, 33.74698], [-117.91005, 33.74823], [-117.90945, 33.74933], [-117.90864, 33.75065], [-117.90789, 33.75177], [-117.90656, 33.75354], [-117.90503, 33.7554], [-117.90226, 33.75865], [-117.90214, 33.75866], [-117.90165, 33.75931], [-117.90048, 33.76105], [-117.90013, 33.76123], [-117.89983, 33.76149], [-117.8997, 33.76164], [-117.89951, 33.76195], [-117.89925, 33.76227], [-117.89894, 33.76261], [-117.89884, 33.76282], [-117.89882, 33.76292], [-117.89863, 33.76327], [-117.89646, 33.76588], [-117.89573, 33.76715], [-117.89556, 33.76716], [-117.8953, 33.7676], [-117.89523, 33.76768], [-117.89431, 33.76867], [-117.89313, 33.76987], [-117.89313, 33.76982], [-117.89312, 33.76982], [-117.89224, 33.77081], [-117.89223, 33.77069], [-117.89222, 33.77069], [-117.8914, 33.77167], [-117.89145, 33.77171], [-117.89009, 33.77404], [-117.88867, 33.77668], [-117.88803, 33.77812], [-117.88599, 33.78204], [-117.88592, 33.78204], [-117.88584, 33.78222], [-117.88555, 33.78272], [-117.88519, 33.78316], [-117.88483, 33.78355], [-117.88466, 33.78368], [-117.88428, 33.78403], [-117.88403, 33.78432], [-117.88373, 33.78477], [-117.88355, 33.78502], [-117.88344, 33.78523], [-117.88341, 33.78534], [-117.88339, 33.78774], [-117.88332, 33.78801], [-117.88249, 33.78996], [-117.88222, 33.79073], [-117.88217, 33.79077], [-117.88156, 33.79234], [-117.88115, 33.79342], [-117.88108, 33.79364], [-117.88107, 33.79376], [-117.88017, 33.796], [-117.87966, 33.79747], [-117.87885, 33.79943], [-117.87873, 33.79956], [-117.87848, 33.79969], [-117.87832, 33.79983], [-117.87795, 33.8005], [-117.87788, 33.80068], [-117.87787, 33.80083], [-117.87788, 33.80096], [-117.87719, 33.80256], [-117.8771, 33.80253], [-117.87701, 33.80268], [-117.87626, 33.80429], [-117.87602, 33.80496], [-117.8759, 33.80535], [-117.87573, 33.80574], [-117.87572, 33.80589], [-117.87535, 33.80653], [-117.87444, 33.80847], [-117.87429, 33.80875], [-117.8742, 33.80882], [-117.87353, 33.81006], [-117.87348, 33.8102], [-117.8732, 33.81072], [-117.87312, 33.81083], [-117.87285, 33.81134], [-117.87278, 33.8116], [-117.87279, 33.81229], [-117.87293, 33.81232], [-117.87362, 33.81232], [-117.87287, 33.81453], [-117.87287, 33.81476], [-117.8729, 33.81518], [-117.87284, 33.81544], [-117.87218, 33.81733], [-117.87207, 33.81755], [-117.87062, 33.82121], [-117.8693, 33.82654], [-117.86844, 33.82875], [-117.86712, 33.83254], [-117.86698, 33.83272], [-117.8659, 33.83586], [-117.86586, 33.8363], [-117.86475, 33.83966], [-117.85966, 33.84293], [-117.85664, 33.84459], [-117.85525, 33.84529], [-117.85407, 33.84582], [-117.85245, 33.8465], [-117.85157, 33.84683], [-117.85077, 33.84711], [-117.85073, 33.84712], [-117.85072, 33.84711], [-117.84188, 33.85001], [-117.84213, 33.84913], [-117.83795, 33.84947], [-117.83756, 33.84952], [-117.83642, 33.84975], [-117.83521, 33.84992], [-117.83521, 33.84994], [-117.83648, 33.8509], [-117.837, 33.85139], [-117.83744, 33.85174], [-117.83743, 33.85184], [-117.83625, 33.85184], [-117.83619, 33.85403], [-117.83603, 33.85403], [-117.83587, 33.85476], [-117.83571, 33.85494], [-117.8354, 33.85511], [-117.83462, 33.85522], [-117.83431, 33.8553], [-117.83387, 33.85545], [-117.83341, 33.85564], [-117.83293, 33.8559], [-117.83224, 33.85645], [-117.83107, 33.85766], [-117.83084, 33.85782], [-117.83056, 33.85794], [-117.83026, 33.85798], [-117.82863, 33.85771], [-117.82849, 33.85826], [-117.82606, 33.85828], [-117.82584, 33.85775], [-117.82324, 33.85776], [-117.82323, 33.85812], [-117.81836, 33.85814], [-117.81835, 33.85815], [-117.81843, 33.85872], [-117.81842, 33.85909], [-117.81826, 33.85909], [-117.8131, 33.85798], [-117.81309, 33.85799], [-117.81309, 33.85805], [-117.81049, 33.8581], [-117.80027, 33.85684], [-117.79073, 33.85799], [-117.79025, 33.85801], [-117.78569, 33.85882], [-117.78515, 33.85893], [-117.78442, 33.8591], [-117.78324, 33.8594], [-117.7823, 33.8597], [-117.7813, 33.86007], [-117.7808, 33.86029], [-117.77812, 33.86158], [-117.77135, 33.86488], [-117.77053, 33.86526], [-117.76967, 33.8657], [-117.76882, 33.8661], [-117.76672, 33.86711], [-117.76628, 33.86734], [-117.76518, 33.86786], [-117.76248, 33.86919], [-117.7611, 33.86982], [-117.75927, 33.87055], [-117.75884, 33.8707], [-117.75782, 33.87105], [-117.75634, 33.87152], [-117.75548, 33.87183], [-117.754, 33.87242], [-117.75219, 33.87321], [-117.75135, 33.87366], [-117.74981, 33.87456], [-117.74964, 33.87468], [-117.74945, 33.87509], [-117.74893, 33.87504], [-117.74868, 33.87569], [-117.74794, 33.87438], [-117.7482, 33.8742], [-117.75061, 33.87276], [-117.75204, 33.87204], [-117.75307, 33.87158], [-117.75429, 33.87107], [-117.75511, 33.87076], [-117.75663, 33.87024], [-117.75847, 33.86967], [-117.76192, 33.86821], [-117.7804, 33.85924], [-117.78223, 33.85854], [-117.78352, 33.85813], [-117.78471, 33.85783], [-117.78572, 33.85763], [-117.78959, 33.85695], [-117.79028, 33.85663], [-117.79138, 33.85661], [-117.79232, 33.85645], [-117.79927, 33.85518], [-117.80152, 33.85486], [-117.80247, 33.85482], [-117.80299, 33.85479], [-117.80328, 33.85476], [-117.80518, 33.85489], [-117.80578, 33.8549], [-117.80615, 33.85488], [-117.80617, 33.85508], [-117.80682, 33.85519], [-117.80926, 33.85575], [-117.80974, 33.85582], [-117.81047, 33.85585], [-117.81182, 33.8558], [-117.81264, 33.8557], [-117.81338, 33.85557], [-117.81435, 33.85536], [-117.81694, 33.85459], [-117.82124, 33.85329], [-117.82318, 33.85261], [-117.82455, 33.85186], [-117.82491, 33.85164], [-117.82755, 33.84997], [-117.83017, 33.84902], [-117.83129, 33.84869], [-117.83416, 33.84798], [-117.83482, 33.84768], [-117.83531, 33.84751], [-117.83579, 33.84743], [-117.83748, 33.8471], [-117.84525, 33.84543], [-117.84527, 33.84551], [-117.84667, 33.84524], [-117.84746, 33.84498], [-117.8486, 33.84465], [-117.84926, 33.84444], [-117.84979, 33.84426], [-117.85089, 33.84386], [-117.85218, 33.84332], [-117.85277, 33.84304], [-117.8546, 33.84208], [-117.85458, 33.84205], [-117.85551, 33.84162], [-117.85923, 33.83895], [-117.8604, 33.83772], [-117.86154, 33.83667], [-117.86217, 33.83533], [-117.86224, 33.83534], [-117.8624, 33.83504], [-117.86241, 33.83432], [-117.86296, 33.83333], [-117.86323, 33.83269], [-117.86342, 33.83216], [-117.86489, 33.82779], [-117.86556, 33.82681], [-117.86569, 33.82649], [-117.86851, 33.81806], [-117.86901, 33.81649], [-117.86929, 33.81567], [-117.86928, 33.81565], [-117.86909, 33.81565], [-117.86999, 33.8131], [-117.87073, 33.81167], [-117.87193, 33.80902], [-117.87199, 33.80901], [-117.87328, 33.80622], [-117.87376, 33.80588], [-117.87375, 33.80537], [-117.87444, 33.80386], [-117.87475, 33.80322], [-117.87552, 33.80169], [-117.87705, 33.79857], [-117.87738, 33.7987], [-117.87827, 33.79681], [-117.87841, 33.7959], [-117.87847, 33.79562], [-117.87875, 33.79468], [-117.87921, 33.79372], [-117.87974, 33.79249], [-117.88021, 33.79112], [-117.88037, 33.791], [-117.88049, 33.79012], [-117.88101, 33.78921], [-117.88131, 33.78873], [-117.8814, 33.78798], [-117.88147, 33.7876], [-117.88148, 33.78698], [-117.88153, 33.78697], [-117.88153, 33.78535], [-117.88158, 33.785], [-117.88167, 33.78469], [-117.88181, 33.78432], [-117.882, 33.784], [-117.88252, 33.78336], [-117.88326, 33.78273], [-117.8835, 33.78247], [-117.88398, 33.78186], [-117.88418, 33.78153], [-117.88418, 33.78049], [-117.8848, 33.78049], [-117.88525, 33.77965], [-117.88579, 33.77854], [-117.8858, 33.77839], [-117.88577, 33.77823], [-117.88713, 33.7756], [-117.88773, 33.77368], [-117.88785, 33.7734], [-117.88846, 33.77289], [-117.88872, 33.77255], [-117.88913, 33.77192], [-117.88929, 33.77151], [-117.88949, 33.77138], [-117.88992, 33.77058], [-117.89017, 33.76993], [-117.88992, 33.76948], [-117.89174, 33.76706], [-117.89302, 33.76519], [-117.8934, 33.76471], [-117.89368, 33.76486], [-117.89696, 33.76234], [-117.89709, 33.7624], [-117.89712, 33.76238], [-117.89742, 33.76251], [-117.89762, 33.76229], [-117.89831, 33.76168], [-117.89893, 33.76094], [-117.89856, 33.76071], [-117.89917, 33.76041], [-117.90267, 33.75622], [-117.90302, 33.75571], [-117.90343, 33.7552], [-117.90422, 33.75428], [-117.90433, 33.75428], [-117.90537, 33.75302], [-117.90613, 33.75205], [-117.90664, 33.75135], [-117.90764, 33.74986], [-117.90818, 33.74898], [-117.9086, 33.74824], [-117.90961, 33.74622], [-117.91009, 33.74511], [-117.91065, 33.74354], [-117.91082, 33.74298], [-117.91099, 33.7424], [-117.91118, 33.74162], [-117.9116, 33.73961], [-117.91215, 33.73649], [-117.91254, 33.73448], [-117.91271, 33.73374], [-117.91305, 33.73238], [-117.91336, 33.73125], [-117.91473, 33.72725], [-117.91502, 33.72724], [-117.91646, 33.72299], [-117.91662, 33.72263], [-117.91756, 33.7207], [-117.91863, 33.7187], [-117.91987, 33.7165], [-117.92103, 33.71469], [-117.9249, 33.70884], [-117.92944, 33.70202], [-117.92959, 33.70177], [-117.93155, 33.69882], [-117.93667, 33.69119], [-117.93666, 33.69117], [-117.93609, 33.69093], [-117.93639, 33.69044], [-117.93695, 33.6896], [-117.9379, 33.68807], [-117.93844, 33.68712], [-117.93935, 33.68548], [-117.9404, 33.68342], [-117.94098, 33.68218], [-117.94175, 33.68041], [-117.94247, 33.67853], [-117.943, 33.67701], [-117.94336, 33.67592], [-117.94375, 33.67459], [-117.94453, 33.67186], [-117.94455, 33.67167], [-117.94451, 33.67145], [-117.94451, 33.67131], [-117.9444, 33.67119], [-117.94442, 33.67113], [-117.94454, 33.67108], [-117.94526, 33.66852], [-117.94686, 33.66245], [-117.94829, 33.65775], [-117.94828, 33.65774], [-117.94797, 33.65774], [-117.94895, 33.65432], [-117.9495, 33.65229], [-117.95, 33.65228], [-117.95044, 33.65129], [-117.95032, 33.65063], [-117.95069, 33.65025], [-117.95264, 33.64375], [-117.95257, 33.6435], [-117.95271, 33.64349], [-117.95276, 33.64333], [-117.95288, 33.64311], [-117.95634, 33.63093], [-117.95649, 33.63099], [-117.95655, 33.63092], [-117.958, 33.63182]]]} | Open Access 1 | 11403 | Santa Ana River Trail | 29296 | 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 | http://www.santaanarivertrail.org/home.html | Orange 3 | 1909.063 | Santa Ana River Trail | 0 | Local Recreation Area 3 | 4 |
| 16210 | 16210 | 16209 | {"type": "Polygon", "coordinates": [[[-117.79786, 33.79687], [-117.79697, 33.79689], [-117.79699, 33.80001], [-117.79692, 33.80257], [-117.79603, 33.80165], [-117.79601, 33.80166], [-117.79605, 33.80244], [-117.79636, 33.8025], [-117.79654, 33.80249], [-117.79645, 33.80291], [-117.797, 33.80302], [-117.7972, 33.8029], [-117.79765, 33.80341], [-117.79758, 33.80342], [-117.79731, 33.80361], [-117.79716, 33.80362], [-117.79714, 33.80366], [-117.79648, 33.80353], [-117.79628, 33.80414], [-117.79612, 33.80457], [-117.7957, 33.80529], [-117.79569, 33.8058], [-117.79585, 33.80604], [-117.79574, 33.80649], [-117.7957, 33.80634], [-117.79568, 33.80618], [-117.79562, 33.80602], [-117.79552, 33.80588], [-117.79541, 33.80577], [-117.79533, 33.80572], [-117.79549, 33.80554], [-117.79545, 33.80531], [-117.7951, 33.80438], [-117.79474, 33.80371], [-117.79303, 33.80422], [-117.79285, 33.80399], [-117.79248, 33.80302], [-117.79273, 33.80195], [-117.7926, 33.8016], [-117.79241, 33.80164], [-117.79254, 33.80095], [-117.79256, 33.80077], [-117.79255, 33.8004], [-117.79249, 33.80003], [-117.79245, 33.79986], [-117.79225, 33.79934], [-117.79175, 33.79836], [-117.79166, 33.798], [-117.79161, 33.7976], [-117.79159, 33.79734], [-117.7916, 33.79702], [-117.79164, 33.79674], [-117.79175, 33.79638], [-117.79183, 33.79615], [-117.79242, 33.79519], [-117.79266, 33.79463], [-117.79284, 33.79395], [-117.79288, 33.79333], [-117.79301, 33.79279], [-117.79313, 33.7925], [-117.7934, 33.79209], [-117.79418, 33.79178], [-117.79474, 33.79176], [-117.79538, 33.79184], [-117.79635, 33.7925], [-117.79678, 33.79246], [-117.79704, 33.79294], [-117.79723, 33.79294], [-117.79729, 33.79329], [-117.79749, 33.79434], [-117.79657, 33.79485], [-117.79655, 33.79592], [-117.79786, 33.79687]]]} | Open Access 1 | 44429 | Orange County Open Space | 23152 | 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 | 141.749 | Orange County 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]);