superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
82 rows where MNG_AGENCY = 138 sorted by SUID_NMA
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
7722 | 7722 | 7721 | {"type": "Polygon", "coordinates": [[[-117.62942, 33.68702], [-117.62839, 33.68717], [-117.62837, 33.68738], [-117.62818, 33.6877], [-117.62813, 33.68775], [-117.62743, 33.68762], [-117.62754, 33.6872], [-117.6276, 33.68684], [-117.62873, 33.68685], [-117.62887, 33.68684], [-117.62926, 33.68677], [-117.6293, 33.6868], [-117.62942, 33.68702]]]} | Open Access 1 | Orange holding 3 | 23170 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 2.453 | Orange holding 3 | ||
7723 | 7723 | 7722 | {"type": "Polygon", "coordinates": [[[-117.63087, 33.67292], [-117.63058, 33.67337], [-117.6304, 33.67329], [-117.63037, 33.67331], [-117.63009, 33.67319], [-117.62988, 33.67335], [-117.62977, 33.6733], [-117.62957, 33.67326], [-117.62939, 33.67329], [-117.62916, 33.6734], [-117.62909, 33.67337], [-117.62914, 33.67323], [-117.62913, 33.67308], [-117.62914, 33.67295], [-117.62924, 33.67274], [-117.62944, 33.67259], [-117.62946, 33.67244], [-117.62955, 33.67229], [-117.63087, 33.67292]]]} | Open Access 1 | Orange holding 4 | 23171 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 2.905 | Orange holding 4 | ||
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 | ||
7725 | 7725 | 7724 | {"type": "Polygon", "coordinates": [[[-117.63726, 33.57438], [-117.63727, 33.57449], [-117.63717, 33.57496], [-117.63702, 33.57514], [-117.63615, 33.57531], [-117.63567, 33.5756], [-117.63515, 33.57558], [-117.63505, 33.57538], [-117.63485, 33.57548], [-117.63422, 33.57516], [-117.63384, 33.57494], [-117.63357, 33.57506], [-117.63345, 33.57529], [-117.63341, 33.57524], [-117.63358, 33.57484], [-117.63367, 33.57479], [-117.63511, 33.57517], [-117.63594, 33.57518], [-117.63671, 33.5749], [-117.63726, 33.57438]]]} | Open Access 1 | Orange holding 6 | 23173 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 2.929 | Orange holding 6 | ||
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 | ||
7727 | 7727 | 7726 | {"type": "Polygon", "coordinates": [[[-117.62419, 33.69092], [-117.62398, 33.69096], [-117.62396, 33.69093], [-117.62377, 33.69096], [-117.62351, 33.69104], [-117.62298, 33.69101], [-117.62301, 33.69097], [-117.62305, 33.69074], [-117.6231, 33.69026], [-117.62314, 33.69005], [-117.62321, 33.6899], [-117.62345, 33.6895], [-117.62353, 33.68947], [-117.62395, 33.68963], [-117.62408, 33.69006], [-117.62399, 33.69007], [-117.62398, 33.69008], [-117.62419, 33.69092]]]} | Open Access 1 | Orange holding 8 | 23175 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 3.388 | Orange holding 8 | ||
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 | ||
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 | ||
15102 | 15102 | 15101 | {"type": "MultiPolygon", "coordinates": [[[[-117.98117, 33.89542], [-117.97405, 33.89546], [-117.97397, 33.89408], [-117.97475, 33.89292], [-117.97555, 33.89247], [-117.97658, 33.89193], [-117.97814, 33.89115], [-117.98082, 33.89176], [-117.98095, 33.89188], [-117.98104, 33.8934], [-117.98106, 33.89341], [-117.98108, 33.89376], [-117.98117, 33.89542]]], [[[-117.98255, 33.89564], [-117.98255, 33.89624], [-117.98175, 33.89662], [-117.98157, 33.89727], [-117.98143, 33.8974], [-117.98144, 33.89741], [-117.9822, 33.89742], [-117.9822, 33.89909], [-117.98156, 33.89884], [-117.9814, 33.89921], [-117.98089, 33.89916], [-117.98071, 33.89911], [-117.98054, 33.89903], [-117.98087, 33.89862], [-117.98094, 33.89832], [-117.98086, 33.89811], [-117.98047, 33.89805], [-117.98037, 33.89816], [-117.98022, 33.89816], [-117.97982, 33.89811], [-117.97956, 33.8982], [-117.97916, 33.89823], [-117.97901, 33.89828], [-117.97891, 33.89827], [-117.97866, 33.89841], [-117.97826, 33.89847], [-117.97808, 33.8987], [-117.97782, 33.8989], [-117.97772, 33.89911], [-117.97762, 33.89923], [-117.97754, 33.89939], [-117.97719, 33.89944], [-117.97716, 33.89937], [-117.97694, 33.8992], [-117.97686, 33.89925], [-117.9767, 33.89929], [-117.97661, 33.89935], [-117.97661, 33.89744], [-117.97665, 33.89568], [-117.98007, 33.89565], [-117.98009, 33.89567], [-117.98132, 33.89567], [-117.98134, 33.89564], [-117.98255, 33.89564]]]]} | Open Access 1 | Ralph B. Clark Regional Park | 24097 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 104.858 | Ralph B. Clark RP |
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]);