superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
75 rows where ACCESS_TYP = 1, MNG_AGENCY = 138 and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- County Agency · 55 ✖
MNG_AGENCY 1
- Orange, County of · 55 ✖
ACCESS_TYP 1
- Open Access · 55 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5200 | 5200 | 5199 | {"type": "Polygon", "coordinates": [[[-117.81409, 33.75983], [-117.81374, 33.7598], [-117.81367, 33.75975], [-117.81366, 33.75914], [-117.81378, 33.75944], [-117.81391, 33.75962], [-117.81409, 33.75983]]]} | Open Access 1 | Holderman Park | 20027 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 0.282 | Holderman Park | ||
5991 | 5991 | 5990 | {"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.46401], [-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 | Lantern Bay Park | 21016 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 15.065 | Lantern Bay Park | ||
6511 | 6511 | 6510 | {"type": "Polygon", "coordinates": [[[-117.83186, 33.93971], [-117.82753, 33.93963], [-117.82736, 33.93638], [-117.818, 33.93613], [-117.81809, 33.93271], [-117.818, 33.93243], [-117.82665, 33.93257], [-117.83156, 33.93319], [-117.83186, 33.93971]]]} | Open Access 1 | Olinda Regional Park | 23117 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 161.947 | Olinda RP | ||
7085 | 7085 | 7084 | {"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 | Modjeska Home and Garden | 22342 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 4.244 | Modjeska Home and Garden | ||
7367 | 7367 | 7366 | {"type": "Polygon", "coordinates": [[[-117.89824, 33.61741], [-117.89741, 33.61921], [-117.89533, 33.61943], [-117.8951, 33.61942], [-117.89488, 33.61939], [-117.89455, 33.6193], [-117.89435, 33.61921], [-117.89417, 33.61909], [-117.89393, 33.61888], [-117.89516, 33.61634], [-117.89531, 33.616], [-117.89466, 33.61532], [-117.89308, 33.61513], [-117.89234, 33.61565], [-117.89193, 33.6178], [-117.89194, 33.61783], [-117.89187, 33.61801], [-117.89277, 33.61917], [-117.89283, 33.61943], [-117.89273, 33.61944], [-117.89253, 33.61941], [-117.89187, 33.61905], [-117.89152, 33.61909], [-117.89138, 33.61948], [-117.89105, 33.61996], [-117.89105, 33.62014], [-117.89111, 33.6202], [-117.89057, 33.62076], [-117.89063, 33.62082], [-117.89049, 33.62084], [-117.89043, 33.62074], [-117.89046, 33.62071], [-117.89015, 33.62006], [-117.89006, 33.6198], [-117.89001, 33.6195], [-117.89, 33.6192], [-117.89003, 33.61898], [-117.89008, 33.61879], [-117.8902, 33.6185], [-117.89067, 33.61772], [-117.89074, 33.61756], [-117.89083, 33.61725], [-117.89087, 33.61699], [-117.89087, 33.61685], [-117.89085, 33.61669], [-117.89081, 33.61654], [-117.891, 33.61517], [-117.89233, 33.61421], [-117.89341, 33.61391], [-117.89514, 33.614], [-117.89689, 33.61476], [-117.89824, 33.61741]]]} | Open Access 1 | Newport Dunes Aquatic Park | 22736 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 66.729 | Newport Dunes Aquatic Park | ||
7507 | 7507 | 7506 | {"type": "Polygon", "coordinates": [[[-117.97887, 33.74548], [-117.9787, 33.7455], [-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 | Roger Stanton Park | 24560 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 0.75 | Roger Stanton Park | ||
7695 | 7695 | 7694 | {"type": "Polygon", "coordinates": [[[-117.63308, 33.68047], [-117.63275, 33.68098], [-117.63268, 33.68098], [-117.63235, 33.6812], [-117.63229, 33.68167], [-117.63149, 33.68159], [-117.63135, 33.68156], [-117.63122, 33.68152], [-117.63106, 33.68143], [-117.63107, 33.68139], [-117.63124, 33.6812], [-117.63246, 33.68007], [-117.63255, 33.68007], [-117.63308, 33.68047]]]} | Open Access 1 | Orange holding 1 | 23155 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 3.944 | Orange holding 1 | ||
7696 | 7696 | 7695 | {"type": "Polygon", "coordinates": [[[-117.64491, 33.56844], [-117.64472, 33.56847], [-117.64447, 33.56847], [-117.64433, 33.56843], [-117.64421, 33.56756], [-117.6448, 33.56756], [-117.64491, 33.56844]]]} | Open Access 1 | Orange holding 10 | 23157 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 1.33 | Orange holding 10 | ||
7697 | 7697 | 7696 | {"type": "Polygon", "coordinates": [[[-117.64456, 33.55733], [-117.64456, 33.55832], [-117.64446, 33.55917], [-117.64411, 33.55996], [-117.64407, 33.55994], [-117.64408, 33.5599], [-117.64402, 33.55988], [-117.64398, 33.55992], [-117.64392, 33.55989], [-117.64388, 33.55994], [-117.64407, 33.56004], [-117.64406, 33.56007], [-117.64384, 33.55998], [-117.64352, 33.55741], [-117.64456, 33.55733]]]} | Open Access 1 | Orange holding 11 | 23158 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 5.151 | Orange holding 11 | ||
7698 | 7698 | 7697 | {"type": "Polygon", "coordinates": [[[-117.63832, 33.55179], [-117.63825, 33.55193], [-117.63806, 33.55195], [-117.63749, 33.55165], [-117.63722, 33.55113], [-117.63732, 33.55058], [-117.63776, 33.55016], [-117.63796, 33.55008], [-117.63803, 33.55011], [-117.63826, 33.55094], [-117.63832, 33.55179]]]} | Open Access 1 | Orange holding 12 | 23159 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 3.606 | Orange holding 12 | ||
7699 | 7699 | 7698 | {"type": "Polygon", "coordinates": [[[-117.63733, 33.55174], [-117.6369, 33.55203], [-117.63667, 33.55227], [-117.63653, 33.55225], [-117.63646, 33.55234], [-117.63651, 33.55243], [-117.63629, 33.55265], [-117.63566, 33.55222], [-117.63428, 33.55282], [-117.63399, 33.55224], [-117.6338, 33.55163], [-117.63384, 33.55152], [-117.63396, 33.55146], [-117.63704, 33.55126], [-117.63716, 33.55152], [-117.63733, 33.55174]]]} | Open Access 1 | Orange holding 13 | 23160 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 8.813 | Orange holding 13 | ||
7700 | 7700 | 7699 | {"type": "Polygon", "coordinates": [[[-117.64422, 33.55212], [-117.64418, 33.55263], [-117.64416, 33.55266], [-117.64412, 33.55267], [-117.64351, 33.55263], [-117.6435, 33.5526], [-117.64355, 33.55204], [-117.64422, 33.55212]]]} | Open Access 1 | Orange holding 14 | 23161 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 0.99 | Orange holding 14 | ||
7701 | 7701 | 7700 | {"type": "Polygon", "coordinates": [[[-117.63356, 33.5534], [-117.63355, 33.55342], [-117.63311, 33.55365], [-117.63308, 33.55364], [-117.63287, 33.55333], [-117.6327, 33.553], [-117.63271, 33.55298], [-117.63319, 33.55282], [-117.63322, 33.55283], [-117.63338, 33.55312], [-117.63356, 33.5534]]]} | Open Access 1 | Orange holding 15 | 23162 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 1.023 | Orange holding 15 | ||
7715 | 7715 | 7714 | {"type": "Polygon", "coordinates": [[[-117.63608, 33.56053], [-117.63599, 33.56078], [-117.63595, 33.56079], [-117.63584, 33.561], [-117.63553, 33.56083], [-117.63503, 33.56079], [-117.63423, 33.56105], [-117.63372, 33.56095], [-117.63375, 33.56083], [-117.63376, 33.56069], [-117.63371, 33.56049], [-117.63382, 33.5605], [-117.63433, 33.56033], [-117.6345, 33.56025], [-117.63477, 33.56004], [-117.63505, 33.55994], [-117.6351, 33.55995], [-117.63526, 33.56024], [-117.63598, 33.56045], [-117.636, 33.5605], [-117.63608, 33.56053]]]} | Open Access 1 | Orange holding 16 | 23163 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 3.723 | Orange holding 16 | ||
7716 | 7716 | 7715 | {"type": "Polygon", "coordinates": [[[-117.64438, 33.54846], [-117.64365, 33.54864], [-117.64349, 33.5483], [-117.64349, 33.54828], [-117.64352, 33.54825], [-117.64416, 33.54807], [-117.64421, 33.54807], [-117.64424, 33.5481], [-117.64438, 33.54846]]]} | Open Access 1 | Orange holding 17 | 23164 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 0.821 | Orange holding 17 | ||
7717 | 7717 | 7716 | {"type": "Polygon", "coordinates": [[[-117.63313, 33.56218], [-117.63304, 33.56249], [-117.63298, 33.56252], [-117.63183, 33.56229], [-117.6318, 33.56224], [-117.63188, 33.56194], [-117.63193, 33.5619], [-117.6331, 33.56213], [-117.63313, 33.56218]]]} | Open Access 1 | Orange holding 18 | 23165 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 1.289 | Orange holding 18 | ||
7718 | 7718 | 7717 | {"type": "Polygon", "coordinates": [[[-117.77775, 33.76416], [-117.77773, 33.7642], [-117.7774, 33.76452], [-117.77704, 33.76493], [-117.77697, 33.76495], [-117.77687, 33.7649], [-117.77712, 33.76457], [-117.77646, 33.76411], [-117.77593, 33.76388], [-117.77537, 33.76368], [-117.77447, 33.76339], [-117.77528, 33.76259], [-117.77535, 33.76253], [-117.77543, 33.76254], [-117.77664, 33.76338], [-117.77667, 33.76338], [-117.77774, 33.76413], [-117.77775, 33.76416]]]} | Open Access 1 | Orange holding 19 | 23166 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 6.64 | Orange holding 19 | ||
7719 | 7719 | 7718 | {"type": "Polygon", "coordinates": [[[-117.62881, 33.68711], [-117.62823, 33.68765], [-117.62818, 33.6877], [-117.62837, 33.68738], [-117.62838, 33.68717], [-117.62881, 33.68711]]]} | Open Access 1 | Orange holding 2 | 23167 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 0.227 | Orange holding 2 | ||
7720 | 7720 | 7719 | {"type": "Polygon", "coordinates": [[[-117.63374, 33.56465], [-117.63372, 33.56475], [-117.63293, 33.56513], [-117.63284, 33.56515], [-117.63278, 33.5651], [-117.63282, 33.56505], [-117.63252, 33.5646], [-117.63244, 33.56458], [-117.63241, 33.56453], [-117.63243, 33.56448], [-117.6333, 33.56407], [-117.63336, 33.56409], [-117.63374, 33.56465]]]} | Open Access 1 | Orange holding 20 | 23168 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 2.059 | Orange holding 20 | ||
7721 | 7721 | 7720 | {"type": "Polygon", "coordinates": [[[-117.63393, 33.55687], [-117.63377, 33.55721], [-117.63341, 33.55741], [-117.63334, 33.55739], [-117.63329, 33.55683], [-117.63343, 33.55627], [-117.6335, 33.55627], [-117.63383, 33.55651], [-117.63393, 33.55687]]]} | Open Access 1 | Orange holding 21 | 23169 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 1.278 | Orange holding 21 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);