superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
82 rows where MNG_AGENCY = 138
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4068 | 4068 | 4067 | {"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 | Esplanade Park | 18714 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 4.693 | Esplanade Park | ||
4074 | 4074 | 4073 | {"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.60927, 33.64946], [-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.60994, 33.64798], [-117.6101, 33.6479], [-117.61024, 33.64796], [-117.61029, 33.64795], [-117.61031, 33.64797]]]} | Open Access 1 | Estrella Vista Park | 18731 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 2.127 | Estrella Vista Park | ||
4148 | 4148 | 4147 | {"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.55977], [-117.72018, 33.55956], [-117.71984, 33.5593], [-117.71958, 33.55916], [-117.71884, 33.55882], [-117.71902, 33.55868], [-117.7184, 33.55712], [-117.71842, 33.55691], [-117.71838, 33.55634], [-117.71839, 33.55617], [-117.71845, 33.55604], [-117.71842, 33.55601], [-117.71858, 33.55577], [-117.71876, 33.55579], [-117.71876, 33.55589], [-117.71926, 33.55597], [-117.7193, 33.55588], [-117.71994, 33.55599], [-117.71998, 33.55618], [-117.71981, 33.55721], [-117.71994, 33.55776], [-117.72054, 33.55825], [-117.7218, 33.56002], [-117.72219, 33.56026], [-117.72224, 33.56042], [-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 | Hillview Park | 19992 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 24.723 | Hillview Park | ||
4355 | 4355 | 4354 | {"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 | Foxborough Park | 19036 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 7.538 | Foxborough Park | ||
4544 | 4544 | 4543 | {"type": "Polygon", "coordinates": [[[-117.87521, 33.89653], [-117.87521, 33.89758], [-117.87518, 33.89763], [-117.87514, 33.89764], [-117.87508, 33.89764], [-117.87503, 33.8976], [-117.87496, 33.89757], [-117.87445, 33.89756], [-117.87443, 33.89649], [-117.87514, 33.89647], [-117.87518, 33.89649], [-117.87521, 33.89653]]]} | Open Access 1 | George Key Ranch Historic Park | 19269 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 2.158 | George Key Ranch Historic Park | ||
5046 | 5046 | 5045 | {"type": "Polygon", "coordinates": [[[-117.69087, 33.64713], [-117.69085, 33.64716], [-117.69051, 33.64729], [-117.68995, 33.64727], [-117.68923, 33.64768], [-117.68869, 33.64759], [-117.68877, 33.64738], [-117.68882, 33.64717], [-117.68975, 33.64643], [-117.69027, 33.64681], [-117.69087, 33.64713]]]} | Open Access 1 | Heritage Hill Historic Site | 19835 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 3.228 | Heritage Hill Historic Site | ||
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 | ||
7365 | 7365 | 7364 | {"type": "Polygon", "coordinates": [[[-117.87081, 33.58987], [-117.87057, 33.5901], [-117.87047, 33.59017], [-117.87031, 33.59023], [-117.87023, 33.59023], [-117.86914, 33.5899], [-117.8688, 33.58974], [-117.86871, 33.58967], [-117.86857, 33.58971], [-117.86853, 33.58978], [-117.86837, 33.58952], [-117.86822, 33.58933], [-117.86799, 33.58913], [-117.86753, 33.58885], [-117.86748, 33.58879], [-117.86752, 33.58845], [-117.86743, 33.58829], [-117.86725, 33.58817], [-117.867, 33.58794], [-117.86685, 33.58788], [-117.86663, 33.58784], [-117.86629, 33.58758], [-117.86584, 33.58715], [-117.86554, 33.58681], [-117.86536, 33.58663], [-117.86504, 33.58617], [-117.86492, 33.58612], [-117.86475, 33.58608], [-117.8645, 33.58597], [-117.86432, 33.58592], [-117.86424, 33.5858], [-117.8642, 33.58564], [-117.86413, 33.58546], [-117.86417, 33.58532], [-117.86436, 33.585], [-117.86442, 33.58494], [-117.86438, 33.58489], [-117.86425, 33.58484], [-117.86379, 33.58483], [-117.86352, 33.58479], [-117.86325, 33.58471], [-117.86307, 33.58461], [-117.86285, 33.58452], [-117.86263, 33.5845], [-117.86238, 33.58444], [-117.86223, 33.58433], [-117.86267, 33.58392], [-117.86275, 33.58396], [-117.86292, 33.58397], [-117.86313, 33.58403], [-117.86336, 33.58412], [-117.86354, 33.58421], [-117.86366, 33.58425], [-117.86406, 33.58429], [-117.86428, 33.5843], [-117.86449, 33.58433], [-117.8647, 33.5844], [-117.86479, 33.58446], [-117.86494, 33.58459], [-117.86504, 33.58473], [-117.86508, 33.58492], [-117.86507, 33.58502], [-117.86504, 33.58511], [-117.865, 33.5852], [-117.86483, 33.58545], [-117.86484, 33.5855], [-117.86498, 33.58556], [-117.86524, 33.58564], [-117.86546, 33.58574], [-117.8656, 33.58589], [-117.86589, 33.58631], [-117.86607, 33.58648], [-117.86635, 33.5868], [-117.86676, 33.58719], [-117.86695, 33.58733], [-117.86715, 33.58739], [-117.86741, 33.58751], [-117.86763, 33.58773], [-117.86793, 33.58794], [-117.868, 33.58801], [-117.86813, 33.58825], [-117.86817, 33.58834], [-117.86817, 33.58855], [-117.86848, 33.58875], [-117.8687, 33.58896], [-117.86896, 33.58928], [-117.8691, 33.5895], [-117.86932, 33.5896], [-117.86954, 33.58966], [-117.86984, 33.58967], [-117.87045, 33.58972], [-117.87067, 33.58978], [-117.87081, 33.58987]]]} | Unknown Access 4 | Newport Beach Marine Life Refuge | 22734 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 16.207 | Newport Beach Marine Life Refuge | ||
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 |
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]);