superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where ACCESS_TYP = 1 and MNG_AGENCY = 38 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1880 | 1880 | 1879 | {"type": "MultiPolygon", "coordinates": [[[[-120.44563, 34.6289], [-120.44556, 34.62931], [-120.44504, 34.6301], [-120.44501, 34.6307], [-120.44122, 34.63067], [-120.44123, 34.6295], [-120.44288, 34.62952], [-120.44464, 34.62878], [-120.44563, 34.6289]]], [[[-120.44655, 34.63243], [-120.44654, 34.63391], [-120.44274, 34.63388], [-120.44275, 34.63239], [-120.44153, 34.63238], [-120.44155, 34.63089], [-120.44517, 34.63093], [-120.44531, 34.63098], [-120.44529, 34.632], [-120.44537, 34.63218], [-120.44612, 34.63242], [-120.44655, 34.63243]]]]} | Open Access 1 | Beattie Park | 15938 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 43.199 | Beattie Park | ||
2746 | 2746 | 2745 | {"type": "MultiPolygon", "coordinates": [[[[-120.45773, 34.63741], [-120.45773, 34.63769], [-120.45726, 34.63768], [-120.45727, 34.63741], [-120.45773, 34.63741]]], [[[-120.45774, 34.63692], [-120.45773, 34.63719], [-120.45727, 34.63719], [-120.45727, 34.63692], [-120.45774, 34.63692]]]]} | Open Access 1 | Centennial Park | 17023 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 0.642 | Centennial Park | ||
3804 | 3804 | 3803 | {"type": "MultiPolygon", "coordinates": [[[[-120.46631, 34.656], [-120.46631, 34.65631], [-120.46521, 34.65579], [-120.46496, 34.6557], [-120.46479, 34.65567], [-120.46441, 34.65564], [-120.46083, 34.65564], [-120.46084, 34.65536], [-120.46457, 34.65537], [-120.46476, 34.65538], [-120.46501, 34.65543], [-120.46528, 34.65552], [-120.46631, 34.656]]], [[[-120.47501, 34.65624], [-120.47501, 34.65677], [-120.47483, 34.65677], [-120.47481, 34.65667], [-120.47474, 34.65659], [-120.47464, 34.65654], [-120.47452, 34.65652], [-120.46659, 34.65645], [-120.4666, 34.65617], [-120.47501, 34.65624]]]]} | Open Access 1 | East/West Channel Bike Path | 18387 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 9.857 | East/West Channel Bike Path | ||
9092 | 9092 | 9091 | {"type": "MultiPolygon", "coordinates": [[[[-120.46865, 34.63751], [-120.46863, 34.63892], [-120.46689, 34.6389], [-120.46691, 34.63749], [-120.46865, 34.63751]]], [[[-120.47057, 34.63592], [-120.47056, 34.63741], [-120.46885, 34.6374], [-120.46883, 34.63734], [-120.46691, 34.63732], [-120.46693, 34.63589], [-120.47057, 34.63592]]]]} | Open Access 1 | Ryon Park | 24763 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 19.612 | Ryon Park | ||
6338 | 6338 | 6337 | {"type": "Polygon", "coordinates": [[[-120.43525, 34.6351], [-120.43509, 34.63554], [-120.43525, 34.63607], [-120.43523, 34.63638], [-120.43497, 34.63671], [-120.43491, 34.63688], [-120.43475, 34.637], [-120.43464, 34.63713], [-120.4346, 34.63731], [-120.43466, 34.63749], [-120.43477, 34.63761], [-120.43493, 34.63771], [-120.43448, 34.63775], [-120.43436, 34.63705], [-120.43452, 34.63632], [-120.43454, 34.63613], [-120.43454, 34.63601], [-120.43451, 34.63582], [-120.43446, 34.63567], [-120.43433, 34.63543], [-120.43525, 34.6351]]]} | Open Access 1 | Lompoc holding 12 | 21423 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 3.385 | Lompoc holding 12 | ||
6342 | 6342 | 6341 | {"type": "Polygon", "coordinates": [[[-120.43629, 34.64], [-120.43609, 34.64011], [-120.43523, 34.63954], [-120.43457, 34.63831], [-120.43448, 34.63776], [-120.43493, 34.63771], [-120.43511, 34.63843], [-120.43571, 34.63942], [-120.43582, 34.63979], [-120.43601, 34.63994], [-120.43629, 34.64]]]} | Open Access 1 | Lompoc holding 16 | 21427 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 2.692 | Lompoc holding 16 | ||
6348 | 6348 | 6347 | {"type": "Polygon", "coordinates": [[[-120.4419, 34.65701], [-120.44087, 34.65701], [-120.44017, 34.65588], [-120.44101, 34.65643], [-120.4419, 34.65701]]]} | Open Access 1 | Lompoc holding 9 | 21435 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1.466 | Lompoc holding 9 | ||
8184 | 8184 | 8183 | {"type": "Polygon", "coordinates": [[[-120.44383, 34.64848], [-120.44381, 34.64997], [-120.44255, 34.64995], [-120.44256, 34.64847], [-120.44383, 34.64848]]]} | Open Access 1 | Pioneer Park | 23724 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 4.711 | Pioneer Park | ||
13072 | 13072 | 13071 | {"type": "Polygon", "coordinates": [[[-120.44863, 34.66551], [-120.44853, 34.6679], [-120.44856, 34.67117], [-120.44719, 34.67074], [-120.44611, 34.67003], [-120.44498, 34.66914], [-120.4443, 34.66829], [-120.44427, 34.66787], [-120.44428, 34.66667], [-120.44863, 34.66551]]]} | Open Access 1 | Riverbend Park | http://www.cityoflompoc.com/parks_rec/river.htm | 30314 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 42.798 | Riverbend Park | |
5586 | 5586 | 5585 | {"type": "Polygon", "coordinates": [[[-120.45135, 34.64228], [-120.45134, 34.64331], [-120.44908, 34.64329], [-120.44909, 34.64226], [-120.45135, 34.64228]]]} | Open Access 1 | Johns-Manville Park | 20474 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 5.855 | Johns-Manville Park | ||
6346 | 6346 | 6345 | {"type": "Polygon", "coordinates": [[[-120.45331, 34.65345], [-120.45328, 34.65553], [-120.4529, 34.65553], [-120.45289, 34.65395], [-120.45288, 34.65374], [-120.45277, 34.65345], [-120.45331, 34.65345]]]} | Open Access 1 | Lompoc holding 5 | 21431 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 2.15 | Lompoc holding 5 | ||
6339 | 6339 | 6338 | {"type": "Polygon", "coordinates": [[[-120.45415, 34.65559], [-120.45415, 34.65562], [-120.45328, 34.65574], [-120.45328, 34.65558], [-120.45415, 34.65559]]]} | Open Access 1 | Lompoc holding 13 | 21424 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 0.2 | Lompoc holding 13 | ||
6337 | 6337 | 6336 | {"type": "Polygon", "coordinates": [[[-120.45474, 34.63166], [-120.45474, 34.63208], [-120.45449, 34.63208], [-120.45449, 34.6318], [-120.45474, 34.63166]]]} | Open Access 1 | Lompoc holding 11 | 21422 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 0.216 | Lompoc holding 11 | ||
6345 | 6345 | 6344 | {"type": "Polygon", "coordinates": [[[-120.45534, 34.63198], [-120.45534, 34.63209], [-120.45504, 34.63209], [-120.45504, 34.63198], [-120.45534, 34.63198]]]} | Open Access 1 | Lompoc holding 4 | 21430 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 0.082 | Lompoc holding 4 | ||
6347 | 6347 | 6346 | {"type": "Polygon", "coordinates": [[[-120.45534, 34.63177], [-120.45534, 34.63198], [-120.45481, 34.63197], [-120.45481, 34.63177], [-120.45534, 34.63177]]]} | Open Access 1 | Lompoc holding 8 | 21434 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 0.275 | Lompoc holding 8 | ||
6336 | 6336 | 6335 | {"type": "Polygon", "coordinates": [[[-120.45601, 34.63164], [-120.45551, 34.63164], [-120.45551, 34.63143], [-120.45581, 34.63142], [-120.45601, 34.63144], [-120.45601, 34.63164]]]} | Open Access 1 | Lompoc holding 1 | 21420 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 0.264 | Lompoc holding 1 | ||
6344 | 6344 | 6343 | {"type": "Polygon", "coordinates": [[[-120.45602, 34.63102], [-120.45601, 34.6313], [-120.45541, 34.63129], [-120.45542, 34.63102], [-120.45602, 34.63102]]]} | Open Access 1 | Lompoc holding 3 | 21429 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 0.413 | Lompoc holding 3 | ||
6340 | 6340 | 6339 | {"type": "Polygon", "coordinates": [[[-120.45638, 34.65553], [-120.45638, 34.65556], [-120.45536, 34.65571], [-120.45528, 34.65585], [-120.45482, 34.65579], [-120.45328, 34.65609], [-120.45328, 34.65606], [-120.45452, 34.65581], [-120.45638, 34.65553]]]} | Open Access 1 | Lompoc holding 14 | 21425 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 0.317 | Lompoc holding 14 | ||
5271 | 5271 | 5270 | {"type": "Polygon", "coordinates": [[[-120.45638, 34.6553], [-120.45638, 34.65537], [-120.45512, 34.65556], [-120.45512, 34.65548], [-120.45638, 34.6553]]]} | Open Access 1 | Lompoc holding 6 | 21432 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 0.234 | Lompoc holding 6 | ||
6341 | 6341 | 6340 | {"type": "Polygon", "coordinates": [[[-120.45658, 34.63103], [-120.45653, 34.63116], [-120.45657, 34.63126], [-120.45658, 34.63136], [-120.45601, 34.6313], [-120.45602, 34.63102], [-120.45658, 34.63103]]]} | Open Access 1 | Lompoc holding 15 | 21426 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 0.418 | Lompoc 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]);