superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where ACCESS_TYP = 1 and MNG_AGENCY = 252
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
653 | 653 | 652 | {"type": "Polygon", "coordinates": [[[-121.742, 37.67795], [-121.74137, 37.67796], [-121.74142, 37.6767], [-121.7416, 37.67668], [-121.74158, 37.67619], [-121.73989, 37.6762], [-121.73988, 37.67577], [-121.74101, 37.6758], [-121.74102, 37.67538], [-121.74195, 37.67539], [-121.742, 37.67795]]]} | Open Access 1 | Almond Park | 15397 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 5.246 | Almond Park | ||
1426 | 1426 | 1425 | {"type": "Polygon", "coordinates": [[[-121.78691, 37.69219], [-121.78691, 37.69315], [-121.78629, 37.69315], [-121.78629, 37.6917], [-121.7865, 37.6917], [-121.78689, 37.69197], [-121.78685, 37.69202], [-121.78685, 37.69207], [-121.78686, 37.69212], [-121.78691, 37.69219]]]} | Open Access 1 | Al Caffodio Park | 15307 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 2.005 | Al Caffodio Park | ||
1594 | 1594 | 1593 | {"type": "Polygon", "coordinates": [[[-121.80478, 37.67824], [-121.80306, 37.67892], [-121.80129, 37.67953], [-121.80062, 37.67969], [-121.79957, 37.67975], [-121.79748, 37.67946], [-121.79627, 37.67965], [-121.7953, 37.67994], [-121.79396, 37.67982], [-121.79254, 37.67974], [-121.7915, 37.67976], [-121.79158, 37.67946], [-121.79158, 37.67939], [-121.79205, 37.6795], [-121.79326, 37.67955], [-121.79464, 37.67963], [-121.79547, 37.6796], [-121.79602, 37.67934], [-121.7967, 37.67905], [-121.79774, 37.6791], [-121.79887, 37.67934], [-121.79991, 37.67942], [-121.80079, 37.67936], [-121.80189, 37.67901], [-121.80281, 37.67855], [-121.80429, 37.6779], [-121.80478, 37.67824]]]} | Open Access 1 | Arroyo Mocho | 15613 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 10.964 | Arroyo Mocho | ||
1921 | 1921 | 1920 | {"type": "Polygon", "coordinates": [[[-121.76919, 37.67978], [-121.76812, 37.68013], [-121.76785, 37.67954], [-121.76896, 37.67926], [-121.76919, 37.67978]]]} | Open Access 1 | Carnegie Park | 16884 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1.643 | Carnegie Park | ||
2009 | 2009 | 2008 | {"type": "Polygon", "coordinates": [[[-121.72832, 37.68345], [-121.72746, 37.6839], [-121.72657, 37.68477], [-121.72515, 37.68373], [-121.72612, 37.68369], [-121.72822, 37.68333], [-121.72832, 37.68345]]]} | Open Access 1 | Big Trees Park | 16094 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 4.198 | Big Trees Park | ||
2013 | 2013 | 2012 | {"type": "Polygon", "coordinates": [[[-121.73028, 37.70971], [-121.73028, 37.71001], [-121.73025, 37.71008], [-121.73028, 37.71017], [-121.73028, 37.7106], [-121.73024, 37.71068], [-121.73028, 37.71077], [-121.73027, 37.71106], [-121.72938, 37.71104], [-121.72938, 37.71079], [-121.72931, 37.71071], [-121.72936, 37.71067], [-121.72937, 37.71062], [-121.72935, 37.71053], [-121.72935, 37.71011], [-121.72931, 37.70995], [-121.72932, 37.70991], [-121.72952, 37.70982], [-121.72967, 37.70984], [-121.72977, 37.70981], [-121.72981, 37.70977], [-121.72983, 37.70972], [-121.72982, 37.70966], [-121.7298, 37.70962], [-121.72994, 37.70956], [-121.72995, 37.7097], [-121.73028, 37.70971]]]} | Open Access 1 | Bill Clark Park | 16103 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 2.88 | Bill Clark Park | ||
2171 | 2171 | 2170 | {"type": "Polygon", "coordinates": [[[-121.76382, 37.67746], [-121.76279, 37.67776], [-121.76246, 37.67699], [-121.76349, 37.67669], [-121.76382, 37.67746]]]} | Open Access 1 | Bothwell Recreation Center | 16293 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 2.176 | Bothwell Rec. Ctr. | ||
2745 | 2745 | 2744 | {"type": "Polygon", "coordinates": [[[-121.77956, 37.67602], [-121.77956, 37.67602], [-121.77934, 37.67698], [-121.77899, 37.67624], [-121.77931, 37.67614], [-121.77956, 37.67602]]]} | Open Access 1 | Centennial Park | 17022 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 0.579 | Centennial Park | ||
2915 | 2915 | 2914 | {"type": "Polygon", "coordinates": [[[-121.72997, 37.72355], [-121.72992, 37.72359], [-121.72988, 37.72365], [-121.72989, 37.72372], [-121.72994, 37.72379], [-121.72993, 37.72423], [-121.72989, 37.72428], [-121.72988, 37.72435], [-121.7299, 37.72441], [-121.72997, 37.72447], [-121.72987, 37.7246], [-121.72725, 37.72458], [-121.72722, 37.72341], [-121.72758, 37.72342], [-121.72828, 37.7234], [-121.72864, 37.72329], [-121.72891, 37.72325], [-121.72978, 37.72328], [-121.72997, 37.72355]]]} | Open Access 1 | Christensen Park | 17224 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 8.119 | Christensen Park | ||
2984 | 2984 | 2983 | {"type": "Polygon", "coordinates": [[[-121.75428, 37.67606], [-121.75112, 37.67601], [-121.75112, 37.67523], [-121.75123, 37.67524], [-121.75125, 37.67523], [-121.75128, 37.67397], [-121.75353, 37.67399], [-121.75398, 37.67351], [-121.75428, 37.67606]]]} | Open Access 1 | Civic Center Park | 17360 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 14.936 | Civic Ctr. Park | ||
3910 | 3910 | 3909 | {"type": "Polygon", "coordinates": [[[-121.79462, 37.66508], [-121.79348, 37.66508], [-121.79249, 37.66509], [-121.79211, 37.66498], [-121.79231, 37.66456], [-121.79234, 37.66421], [-121.79461, 37.6642], [-121.79462, 37.66508]]]} | Open Access 1 | El Padro Park | 18523 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 4.987 | El Padro Park | ||
4831 | 4831 | 4830 | {"type": "Polygon", "coordinates": [[[-121.79619, 37.68269], [-121.79494, 37.68274], [-121.79497, 37.68061], [-121.79535, 37.68032], [-121.79617, 37.6799], [-121.7962, 37.68042], [-121.79619, 37.68269]]]} | Open Access 1 | Hagemann | 19593 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 7.489 | Hagemann | ||
5322 | 5322 | 5321 | {"type": "Polygon", "coordinates": [[[-121.80467, 37.66589], [-121.80441, 37.66607], [-121.80426, 37.66621], [-121.80388, 37.66612], [-121.80371, 37.66579], [-121.80323, 37.66563], [-121.80336, 37.66437], [-121.80455, 37.66433], [-121.80467, 37.66589]]]} | Open Access 1 | Ida Holm | 20171 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 5.144 | Ida Holm | ||
5447 | 5447 | 5446 | {"type": "Polygon", "coordinates": [[[-121.79075, 37.65873], [-121.78962, 37.65876], [-121.78926, 37.6589], [-121.78862, 37.65791], [-121.79066, 37.65786], [-121.79072, 37.65809], [-121.79075, 37.65873]]]} | Open Access 1 | Jack Williams | 20314 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 3.927 | Jack Williams | ||
5656 | 5656 | 5655 | {"type": "Polygon", "coordinates": [[[-121.77626, 37.66399], [-121.77623, 37.66402], [-121.7762, 37.66404], [-121.7749, 37.66404], [-121.77471, 37.66402], [-121.77471, 37.6632], [-121.77625, 37.66319], [-121.77626, 37.66399]]]} | Open Access 1 | Karl Wente Park | 20554 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 3.144 | Karl Wente Park | ||
6123 | 6123 | 6122 | {"type": "Polygon", "coordinates": [[[-121.75362, 37.69649], [-121.75323, 37.69694], [-121.75283, 37.69732], [-121.75234, 37.69713], [-121.75157, 37.69695], [-121.75161, 37.69663], [-121.7517, 37.69653], [-121.75168, 37.69645], [-121.75156, 37.69639], [-121.75143, 37.69643], [-121.75113, 37.69645], [-121.75108, 37.69639], [-121.75124, 37.69598], [-121.75166, 37.69612], [-121.75192, 37.69563], [-121.75362, 37.69649]]]} | Open Access 1 | Lester J. Knott Park | 21183 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 5.311 | Lester J. Knott Park | ||
6306 | 6306 | 6305 | {"type": "Polygon", "coordinates": [[[-121.78627, 37.68568], [-121.78621, 37.68743], [-121.78346, 37.68739], [-121.78349, 37.68561], [-121.78627, 37.68568]]]} | Open Access 1 | Livermore holding 1 | 21381 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 11.805 | Livermore holding 1 | ||
6507 | 6507 | 6506 | {"type": "Polygon", "coordinates": [[[-121.76103, 37.68457], [-121.76065, 37.68496], [-121.76058, 37.68498], [-121.76052, 37.68495], [-121.76051, 37.68491], [-121.76051, 37.68469], [-121.76053, 37.68465], [-121.76099, 37.68451], [-121.76101, 37.68452], [-121.76103, 37.68457]]]} | Open Access 1 | Madeira Park | 21648 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 0.3 | Madeira Park | ||
6508 | 6508 | 6507 | {"type": "Polygon", "coordinates": [[[-121.78361, 37.67491], [-121.7835, 37.67498], [-121.78311, 37.67502], [-121.78209, 37.67494], [-121.78073, 37.67462], [-121.78006, 37.67423], [-121.77944, 37.67395], [-121.77807, 37.67357], [-121.77751, 37.67545], [-121.77661, 37.67525], [-121.77663, 37.67486], [-121.776, 37.67457], [-121.77489, 37.67428], [-121.77458, 37.67395], [-121.77464, 37.67363], [-121.77378, 37.67351], [-121.77372, 37.67258], [-121.76847, 37.67254], [-121.76781, 37.67242], [-121.76786, 37.67183], [-121.76847, 37.67197], [-121.76995, 37.67158], [-121.77045, 37.67153], [-121.77105, 37.67156], [-121.77123, 37.6718], [-121.77298, 37.67169], [-121.77451, 37.67172], [-121.77516, 37.67167], [-121.77605, 37.67168], [-121.7769, 37.67172], [-121.77753, 37.67182], [-121.77823, 37.67197], [-121.77888, 37.67224], [-121.77907, 37.6725], [-121.77917, 37.67281], [-121.7792, 37.67316], [-121.77983, 37.67342], [-121.78022, 37.67342], [-121.78013, 37.67384], [-121.78188, 37.67423], [-121.78196, 37.67411], [-121.78283, 37.67445], [-121.78361, 37.67491]]]} | Open Access 1 | Madeiros Parkway | 21649 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 51.215 | Madeiros Parkway | ||
6541 | 6541 | 6540 | {"type": "Polygon", "coordinates": [[[-121.79126, 37.69513], [-121.79112, 37.69535], [-121.79108, 37.6955], [-121.79107, 37.69649], [-121.78994, 37.69649], [-121.78977, 37.69644], [-121.78913, 37.69618], [-121.7909, 37.69487], [-121.79123, 37.69509], [-121.79126, 37.69513]]]} | Open Access 1 | Maitland R. Heary | 21696 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 4.608 | Maitland R. Heary |
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]);