units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where MNG_AGENCY = 252 and MNG_AG_TYP = 2 sorted by UNIT_ID
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 | |
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 | |
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 | |||
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 | |
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 | |
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 | |
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 | |
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 | |
8047 | 8047 | 8046 | {"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 | 11752 | Tex Spruiell Park | 26273 | 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 | 9.811 | Tex Spruiell Park | 0 | Local Park 2 | 4 | |
8048 | 8048 | 8047 | {"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.75171, 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 | 11764 | Lester J. Knott Park | 21183 | 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.308 | Lester J. Knott Park | 0 | Local Park 2 | 4 | |
8049 | 8049 | 8048 | {"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.69462], [-121.77084, 37.69463], [-121.77096, 37.69622]]]} | Open Access 1 | 11775 | Vista Meadows Park | 27178 | 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.432 | Vista Meadows Park | 0 | Local Park 2 | 4 | |
8051 | 8051 | 8050 | {"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.71719], [-121.74568, 37.71716], [-121.74689, 37.7185]]]} | Open Access 1 | 11787 | Marlin A. Pound Park | 21878 | 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 | 9.509 | Marlin A. Pound Park | 0 | Local Park 2 | 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 | |
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 | |||
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 | |||
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 |
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]);