units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where MNG_AGENCY = 252 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12085 | 12085 | 12084 | {"type": "Polygon", "coordinates": [[[-121.76103, 37.68457], [-121.76065, 37.68496], [-121.76058, 37.68498], [-121.76052, 37.68495], [-121.7605, 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 | 24930 | Madeira Park | 21648 | 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 | 0.3 | Madeira Park | 0 | Local Park 2 | 4 | |
14191 | 14191 | 14190 | {"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 | 44024 | Centennial Park | 17022 | 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 | 0.579 | Centennial 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 | |
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 | |
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 | |
12086 | 12086 | 12085 | {"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 | 24931 | Portola Park | 23911 | 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.434 | Portola 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 | |
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 | |
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 | |
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 | |
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 | |||
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 | |
10965 | 10965 | 10964 | {"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 | 21944 | Big Trees Park | 16094 | 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.198 | Big Trees Park | 0 | Local Park 2 | 4 | |
8171 | 8171 | 8170 | {"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 | 12681 | Maitland R. Heary | 21696 | 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.609 | Maitland R. Heary | None 682 | |||
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 | |
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 | |||
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 | |
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 | |
11286 | 11286 | 11285 | {"type": "Polygon", "coordinates": [[[-121.74672, 37.7097], [-121.74641, 37.70988], [-121.74454, 37.71006], [-121.74453, 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.74484, 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 | 21967 | Ralph T. Wattenburger Park | 24104 | 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.362 | Ralph T. Wattenburger 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 |
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]);