units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where COUNTY = 17 and MNG_AGENCY = 252
This data as json, copyable, CSV (advanced)
DES_TP 10
- Local Park 23
- Local Recreation Area 3
- Local Other or Unknown 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 35
MNG_AGENCY 1
- Livermore, City of · 35 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
781 | 781 | 780 | {"type": "Polygon", "coordinates": [[[-121.83892, 37.69284], [-121.83892, 37.69497], [-121.83838, 37.69541], [-121.83777, 37.69567], [-121.83724, 37.69614], [-121.83653, 37.69638], [-121.83615, 37.6966], [-121.8359, 37.6971], [-121.83545, 37.69735], [-121.83435, 37.69759], [-121.83308, 37.69793], [-121.83316, 37.69844], [-121.83289, 37.69879], [-121.83205, 37.69921], [-121.83202, 37.6983], [-121.82998, 37.69835], [-121.82998, 37.70055], [-121.82094, 37.70062], [-121.81888, 37.69912], [-121.81883, 37.69713], [-121.82405, 37.69676], [-121.8243, 37.69635], [-121.82403, 37.6952], [-121.82983, 37.6953], [-121.83021, 37.69279], [-121.83892, 37.69284]]]} | Restricted Access 2 | 5062 | Las Positas Golf Course | 33002 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 216.12 | Las Positas GC | 0 | Local Recreation Area 3 | 4 | |
813 | 813 | 812 | {"type": "Polygon", "coordinates": [[[-121.78193, 37.67297], [-121.78197, 37.67334], [-121.78197, 37.67383], [-121.78189, 37.67423], [-121.78035, 37.67389], [-121.78048, 37.67298], [-121.78193, 37.67297]]]} | Open Access 1 | 5241 | Mocho Park | 22336 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 4.098 | Mocho Park | 0 | Local Park 2 | 4 | |
816 | 816 | 815 | {"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.80188, 37.67901], [-121.80281, 37.67855], [-121.80429, 37.6779], [-121.80478, 37.67824]]]} | Open Access 1 | 5263 | Arroyo Mocho | 15613 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 10.963 | Arroyo Mocho | None 75 | |||
1390 | 1390 | 1389 | {"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 | 12195 | Jack Williams | 20314 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 3.928 | Jack Williams | None 118 | |||
1559 | 1559 | 1558 | {"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 | 11955 | Hagemann | 19593 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 7.49 | Hagemann | None 123 | |||
1561 | 1561 | 1560 | {"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 | 11728 | Bothwell Recreation Center | 16293 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 2.176 | Bothwell Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
1563 | 1563 | 1562 | {"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.73025, 37.71073], [-121.73028, 37.71077], [-121.73027, 37.71106], [-121.72938, 37.71104], [-121.72938, 37.71078], [-121.72931, 37.71071], [-121.72936, 37.71067], [-121.72938, 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.72994, 37.70971], [-121.73028, 37.70971]]]} | Open Access 1 | 11799 | Bill Clark Park | 16103 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 2.877 | Bill Clark Park | 0 | Local Park 2 | 4 | |
1565 | 1565 | 1564 | {"type": "Polygon", "coordinates": [[[-121.72258, 37.71363], [-121.72258, 37.71376], [-121.72183, 37.71376], [-121.72183, 37.71365], [-121.7218, 37.71363], [-121.72077, 37.71362], [-121.72074, 37.71356], [-121.72062, 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.71283], [-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 | 11809 | Northfront Park | 22869 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 2.748 | Northfront Park | 0 | Local Park 2 | 4 | |
1572 | 1572 | 1571 | {"type": "Polygon", "coordinates": [[[-121.80467, 37.66589], [-121.80441, 37.66607], [-121.80426, 37.66621], [-121.80388, 37.66612], [-121.80372, 37.66579], [-121.80323, 37.66563], [-121.80336, 37.66437], [-121.80455, 37.66433], [-121.80467, 37.66589]]]} | Open Access 1 | 12075 | Ida Holm | 20171 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 5.144 | Ida Holm | None 125 | |||
2455 | 2455 | 2454 | {"type": "Polygon", "coordinates": [[[-121.72196, 37.71808], [-121.72194, 37.71842], [-121.72181, 37.7184], [-121.72162, 37.71847], [-121.72163, 37.71854], [-121.72155, 37.71852], [-121.72141, 37.71855], [-121.72096, 37.71856], [-121.72059, 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.72071, 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.72156, 37.71805], [-121.72196, 37.71808]]]} | Open Access 1 | 12357 | Summit Park | 25966 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 3.907 | Summit Park | 0 | Local Park 2 | 4 | |
2497 | 2497 | 2496 | {"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.77806, 37.67357], [-121.77751, 37.67545], [-121.77661, 37.67525], [-121.77663, 37.67487], [-121.776, 37.67457], [-121.77489, 37.67428], [-121.77458, 37.67395], [-121.77465, 37.67363], [-121.77378, 37.67351], [-121.77373, 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.77122, 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.78012, 37.67384], [-121.78189, 37.67423], [-121.78196, 37.67411], [-121.78283, 37.67445], [-121.78361, 37.67491]]]} | Open Access 1 | 17532 | Madeiros Parkway | 21649 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 51.175 | Madeiros Parkway | 0 | Local Recreation Area 3 | 4 | |
2531 | 2531 | 2530 | {"type": "Polygon", "coordinates": [[[-121.79849, 37.66228], [-121.79847, 37.66427], [-121.79591, 37.66427], [-121.79593, 37.66227], [-121.79849, 37.66228]]]} | Open Access 1 | 17741 | Max Baer Park | 21963 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 12.386 | Max Baer Park | 0 | Local Park 2 | 4 | |
2882 | 2882 | 2881 | {"type": "Polygon", "coordinates": [[[-121.79106, 37.67722], [-121.79029, 37.67754], [-121.78871, 37.6778], [-121.78807, 37.67784], [-121.78741, 37.67737], [-121.78811, 37.67727], [-121.78838, 37.67755], [-121.78901, 37.67751], [-121.78842, 37.67665], [-121.78831, 37.67628], [-121.78917, 37.67597], [-121.78992, 37.67604], [-121.79005, 37.67635], [-121.79039, 37.67668], [-121.79075, 37.67693], [-121.79106, 37.67722]]]} | Open Access 1 | 22290 | Unknown park - Livermore, City of | 28714 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 8.284 | 0 | Local Other or Unknown 14 | 4 | ||
6774 | 6774 | 6773 | {"type": "Polygon", "coordinates": [[[-121.77487, 37.67169], [-121.77451, 37.67172], [-121.77298, 37.67169], [-121.77301, 37.67168], [-121.7731, 37.67089], [-121.77257, 37.6708], [-121.77246, 37.6697], [-121.77349, 37.66996], [-121.77483, 37.66997], [-121.77487, 37.67169]]]} | Open Access 1 | 5248 | Sunset Park | 26056 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 8.983 | Sunset Park | 0 | Local Park 2 | 4 | |
6776 | 6776 | 6775 | {"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 | 5255 | Sunken Gardens | 25999 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 7.908 | Sunken Gardens | 0 | Local Park 2 | 4 | |
7575 | 7575 | 7574 | {"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 | 11679 | Al Caffodio Park | 15307 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 2.005 | Al Caffodio Park | 0 | Local Park 2 | 4 | |
7872 | 7872 | 7871 | {"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 | 11690 | El Padro Park | 18523 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 4.988 | El Padro Park | 0 | Local Park 2 | 4 | |
7958 | 7958 | 7957 | {"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 | 11713 | Carnegie Park | 16884 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 1.643 | Carnegie Park | 0 | Local Park 2 | 4 | |
8007 | 8007 | 8006 | {"type": "Polygon", "coordinates": [[[-121.742, 37.67795], [-121.74137, 37.67796], [-121.74142, 37.6767], [-121.7416, 37.67668], [-121.74159, 37.67618], [-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 | 11740 | Almond Park | 15397 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 5.234 | Almond Park | 0 | Local Park 2 | 4 | |
8039 | 8039 | 8038 | {"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 | 11702 | Karl Wente Park | 20554 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 3.145 | Karl Wente Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);