superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
82 rows where MNG_AGENCY = 138 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
8264 | 8264 | 8263 | {"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 | Poche Beach Park | 23820 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 0.599 | Poche Beach 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 | ||
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 | ||
7724 | 7724 | 7723 | {"type": "Polygon", "coordinates": [[[-117.63857, 33.57457], [-117.63787, 33.57431], [-117.63727, 33.57449], [-117.63726, 33.57438], [-117.63751, 33.574], [-117.63751, 33.57405], [-117.63754, 33.57408], [-117.63777, 33.57416], [-117.63788, 33.57415], [-117.63799, 33.57409], [-117.63806, 33.57413], [-117.63814, 33.57414], [-117.63825, 33.57418], [-117.63855, 33.57422], [-117.63857, 33.57457]]]} | Open Access 1 | Orange holding 5 | 23172 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 0.87 | Orange holding 5 | ||
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 | ||
7726 | 7726 | 7725 | {"type": "Polygon", "coordinates": [[[-117.63554, 33.54852], [-117.63528, 33.54875], [-117.63505, 33.549], [-117.63502, 33.54901], [-117.63462, 33.54878], [-117.6346, 33.54874], [-117.63495, 33.54837], [-117.63516, 33.54819], [-117.63522, 33.5482], [-117.63553, 33.5485], [-117.63554, 33.54852]]]} | Open Access 1 | Orange holding 7 | 23174 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 1.005 | Orange holding 7 | ||
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 | ||
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 | ||
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 | ||
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 | ||
1839 | 1839 | 1838 | {"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 | Bayside Drive Beach | 15893 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 1.344 | Bayside Drive Beach | ||
7728 | 7728 | 7727 | {"type": "Polygon", "coordinates": [[[-117.63605, 33.54568], [-117.63574, 33.54607], [-117.6355, 33.54619], [-117.63546, 33.54618], [-117.63543, 33.54597], [-117.63539, 33.54497], [-117.63543, 33.54495], [-117.6355, 33.54496], [-117.63596, 33.54523], [-117.63605, 33.54568]]]} | Open Access 1 | Orange holding 9 | 23176 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 1.436 | Orange holding 9 | ||
3310 | 3310 | 3309 | {"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 | Crescent Bay Point Park | 17792 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 1.554 | Crescent Bay Point Park | ||
10327 | 10327 | 10326 | {"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.73284, 33.48509], [-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.48483], [-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.73398, 33.48609], [-117.73394, 33.48617], [-117.73396, 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.48555], [-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 | Three Arch Cove Beach | 26330 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 1.925 | Three Arch Cove Beach | ||
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 | ||
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 | ||
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 | ||
3400 | 3400 | 3399 | {"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.6998, 33.46229], [-117.6991, 33.46214], [-117.69895, 33.46208], [-117.69898, 33.46201], [-117.70336, 33.46304]]]} | Open Access 1 | Dana Cove Park | 17908 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 2.384 | Dana Cove Park |
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]);