superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where MNG_AGENCY = 252 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10060 | 10060 | 10059 | {"type": "Polygon", "coordinates": [[[-121.72196, 37.71808], [-121.72194, 37.71842], [-121.72181, 37.7184], [-121.72163, 37.71847], [-121.72163, 37.71854], [-121.72155, 37.71852], [-121.72141, 37.71855], [-121.72096, 37.71856], [-121.72058, 37.71859], [-121.72004, 37.71861], [-121.71953, 37.7186], [-121.71947, 37.71856], [-121.71949, 37.71786], [-121.72046, 37.71786], [-121.72056, 37.71787], [-121.72063, 37.71792], [-121.72072, 37.71795], [-121.72079, 37.71794], [-121.72086, 37.71791], [-121.72093, 37.71782], [-121.72121, 37.71786], [-121.72132, 37.71791], [-121.72146, 37.71794], [-121.7215, 37.71799], [-121.72155, 37.71801], [-121.72157, 37.71805], [-121.72196, 37.71808]]]} | Open Access 1 | Summit Park | 25966 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 3.908 | Summit Park | ||
7477 | 7477 | 7476 | {"type": "Polygon", "coordinates": [[[-121.72258, 37.71363], [-121.72258, 37.71376], [-121.72183, 37.71376], [-121.72183, 37.71366], [-121.72179, 37.71363], [-121.72077, 37.71362], [-121.72074, 37.71356], [-121.72061, 37.71339], [-121.72027, 37.7135], [-121.72016, 37.71334], [-121.72004, 37.71323], [-121.72008, 37.71319], [-121.72015, 37.71298], [-121.72009, 37.71296], [-121.71968, 37.71294], [-121.71958, 37.71288], [-121.7195, 37.71286], [-121.71934, 37.71265], [-121.71955, 37.71276], [-121.71974, 37.71281], [-121.72069, 37.71282], [-121.72079, 37.71284], [-121.72087, 37.71288], [-121.72188, 37.71351], [-121.72201, 37.71356], [-121.72219, 37.71361], [-121.72237, 37.71363], [-121.72258, 37.71363]]]} | Open Access 1 | Northfront Park | 22869 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 2.751 | Northfront Park | ||
11250 | 11250 | 11249 | {"type": "Polygon", "coordinates": [[[-121.72427, 37.69548], [-121.72355, 37.69579], [-121.71877, 37.69641], [-121.71871, 37.69582], [-121.71871, 37.69523], [-121.71894, 37.69463], [-121.7199, 37.69464], [-121.72041, 37.69468], [-121.72074, 37.69475], [-121.72334, 37.69538], [-121.72384, 37.69546], [-121.72427, 37.69548]]]} | Open Access 1 | William J. (Bill) Payne | 27547 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 14.072 | William J. (Bill) Payne | ||
10300 | 10300 | 10299 | {"type": "Polygon", "coordinates": [[[-121.72782, 37.69124], [-121.72776, 37.69126], [-121.72695, 37.69117], [-121.7263, 37.69113], [-121.72456, 37.69115], [-121.72454, 37.69018], [-121.72455, 37.69016], [-121.72456, 37.6899], [-121.7252, 37.68989], [-121.72648, 37.68966], [-121.72652, 37.68981], [-121.72651, 37.6899], [-121.72656, 37.68996], [-121.72667, 37.69], [-121.72675, 37.68999], [-121.72687, 37.68989], [-121.72708, 37.68984], [-121.72731, 37.68981], [-121.72737, 37.68983], [-121.72751, 37.69033], [-121.72763, 37.6906], [-121.72781, 37.6909], [-121.72785, 37.69103], [-121.72784, 37.69117], [-121.72782, 37.69124]]]} | Open Access 1 | Tex Spruiell Park | 26273 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 9.811 | Tex Spruiell 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 | ||
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 | ||
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 | ||
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 | ||
8487 | 8487 | 8486 | {"type": "Polygon", "coordinates": [[[-121.74672, 37.7097], [-121.74641, 37.70988], [-121.74454, 37.71006], [-121.74452, 37.70962], [-121.74418, 37.70962], [-121.74415, 37.70936], [-121.74408, 37.70903], [-121.74408, 37.70891], [-121.74411, 37.70878], [-121.74417, 37.70865], [-121.74483, 37.7089], [-121.74498, 37.70886], [-121.74505, 37.70893], [-121.74515, 37.70895], [-121.74531, 37.7089], [-121.74562, 37.709], [-121.7459, 37.70911], [-121.74621, 37.70928], [-121.74648, 37.70947], [-121.74672, 37.7097]]]} | Open Access 1 | Ralph T. Wattenburger Park | 24104 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 5.365 | Ralph T. Wattenburger Park | ||
6699 | 6699 | 6698 | {"type": "Polygon", "coordinates": [[[-121.74689, 37.7185], [-121.74569, 37.71919], [-121.74534, 37.71898], [-121.74497, 37.71884], [-121.74352, 37.71849], [-121.74365, 37.71814], [-121.74373, 37.71799], [-121.74386, 37.71783], [-121.74405, 37.71768], [-121.7443, 37.71755], [-121.74518, 37.71725], [-121.74543, 37.7172], [-121.74568, 37.71716], [-121.74689, 37.7185]]]} | Open Access 1 | Marlin A. Pound Park | 21878 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 9.509 | Marlin A. Pound Park | ||
10086 | 10086 | 10085 | {"type": "Polygon", "coordinates": [[[-121.75112, 37.67523], [-121.75112, 37.67686], [-121.74896, 37.67681], [-121.74908, 37.67528], [-121.74961, 37.67529], [-121.75025, 37.67525], [-121.75072, 37.67531], [-121.75112, 37.67523]]]} | Open Access 1 | Sunken Gardens | 25999 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 7.908 | Sunken Gardens | ||
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 | ||
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 | ||
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 | ||
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. | ||
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 | ||
10930 | 10930 | 10929 | {"type": "Polygon", "coordinates": [[[-121.77096, 37.69622], [-121.77019, 37.69647], [-121.76984, 37.69647], [-121.76977, 37.69463], [-121.76988, 37.69432], [-121.7699, 37.69429], [-121.76993, 37.69428], [-121.77074, 37.69429], [-121.77074, 37.69461], [-121.77084, 37.69463], [-121.77096, 37.69622]]]} | Open Access 1 | Vista Meadows Park | 27178 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 5.432 | Vista Meadows Park | ||
10129 | 10129 | 10128 | {"type": "Polygon", "coordinates": [[[-121.77487, 37.67169], [-121.77451, 37.67172], [-121.77298, 37.67169], [-121.77301, 37.67167], [-121.7731, 37.6709], [-121.77257, 37.6708], [-121.77246, 37.6697], [-121.77349, 37.66996], [-121.77483, 37.66997], [-121.77487, 37.67169]]]} | Open Access 1 | Sunset Park | 26056 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 8.987 | Sunset Park | ||
8328 | 8328 | 8327 | {"type": "Polygon", "coordinates": [[[-121.77502, 37.69096], [-121.77333, 37.69096], [-121.77327, 37.69094], [-121.77319, 37.69087], [-121.7727, 37.68983], [-121.77502, 37.69096]]]} | Open Access 1 | Portola Park | 23911 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 2.433 | Portola Park | ||
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 |
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]);