units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
44 rows where MNG_AGENCY = 31 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9141 | 9141 | 9140 | {"type": "Polygon", "coordinates": [[[-121.87868, 37.65679], [-121.87863, 37.65684], [-121.87856, 37.65689], [-121.87801, 37.657], [-121.87784, 37.65705], [-121.87769, 37.65714], [-121.87758, 37.65724], [-121.87752, 37.65721], [-121.87815, 37.65662], [-121.87863, 37.6567], [-121.87867, 37.65673], [-121.87868, 37.65679]]]} | Open Access 1 | 15271 | Civic Park | 17372 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 0.563 | Civic Park | 0 | Local Park 2 | 4 | |
9265 | 9265 | 9264 | {"type": "Polygon", "coordinates": [[[-121.87743, 37.66136], [-121.87705, 37.66208], [-121.87682, 37.66199], [-121.87683, 37.66197], [-121.87682, 37.66193], [-121.87705, 37.66136], [-121.87711, 37.66126], [-121.87743, 37.66136]]]} | Open Access 1 | 15455 | Veterans Plaza | 27060 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 0.595 | Veterans Plaza | 0 | Local Park 2 | 4 | |
9282 | 9282 | 9281 | {"type": "Polygon", "coordinates": [[[-121.87494, 37.65914], [-121.87422, 37.6598], [-121.87396, 37.65962], [-121.87468, 37.65896], [-121.87494, 37.65914]]]} | Open Access 1 | 15463 | Delucchi Park | 18079 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 0.731 | Delucchi Park | 0 | Local Park 2 | 4 | |
9252 | 9252 | 9251 | {"type": "Polygon", "coordinates": [[[-121.89397, 37.67515], [-121.89395, 37.67527], [-121.89376, 37.67545], [-121.89348, 37.67556], [-121.89341, 37.67537], [-121.89323, 37.67523], [-121.89234, 37.67522], [-121.89234, 37.67507], [-121.89287, 37.67507], [-121.89288, 37.67514], [-121.89397, 37.67515]]]} | Open Access 1 | 15446 | Heatherlark Park | 19786 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 0.742 | Heatherlark Park | 0 | Local Park 2 | 4 | |
1993 | 1993 | 1992 | {"type": "Polygon", "coordinates": [[[-121.87403, 37.65996], [-121.87324, 37.66069], [-121.87298, 37.66051], [-121.87377, 37.65978], [-121.87403, 37.65996]]]} | Open Access 1 | 15277 | Lions Wayside Park | 21328 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 0.804 | Lions Wayside Park | 0 | Local Park 2 | 4 | |
11569 | 11569 | 11568 | {"type": "Polygon", "coordinates": [[[-121.85913, 37.66996], [-121.85864, 37.67006], [-121.85845, 37.66932], [-121.85888, 37.66925], [-121.85913, 37.66996]]]} | Open Access 1 | 23664 | BMX Facility | 16201 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 0.847 | BMX Facility | None 1030 | |||
9277 | 9277 | 9276 | {"type": "Polygon", "coordinates": [[[-121.8838, 37.66917], [-121.88337, 37.66981], [-121.88292, 37.66957], [-121.88313, 37.66928], [-121.88296, 37.66872], [-121.88345, 37.66858], [-121.8838, 37.66917]]]} | Open Access 1 | 15452 | Harvest Park | 19723 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 1.567 | Harvest Park | 0 | Local Park 2 | 4 | |
9286 | 9286 | 9285 | {"type": "Polygon", "coordinates": [[[-121.86652, 37.65941], [-121.86612, 37.66004], [-121.86508, 37.65957], [-121.86553, 37.65894], [-121.86652, 37.65941]]]} | Open Access 1 | 15469 | McKinley Park | 22047 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 2.047 | McKinley Park | 0 | Local Park 2 | 4 | |
9256 | 9256 | 9255 | {"type": "Polygon", "coordinates": [[[-121.8862, 37.68633], [-121.8843, 37.6869], [-121.88257, 37.68739], [-121.88056, 37.68806], [-121.88019, 37.68815], [-121.88, 37.68814], [-121.87747, 37.68635], [-121.8774, 37.68618], [-121.87946, 37.68766], [-121.8797, 37.68789], [-121.88008, 37.68805], [-121.88048, 37.688], [-121.88253, 37.68731], [-121.88284, 37.68722], [-121.88291, 37.68699], [-121.88326, 37.68702], [-121.88357, 37.68699], [-121.88425, 37.6868], [-121.88427, 37.68682], [-121.886, 37.6863], [-121.8862, 37.68633]]]} | Open Access 1 | 15413 | Sutter Creek Gate Park | 26084 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 2.197 | Sutter Creek Gate Park | 0 | Local Park 2 | 4 | |
9186 | 9186 | 9185 | {"type": "Polygon", "coordinates": [[[-121.88873, 37.69503], [-121.88788, 37.69574], [-121.8871, 37.69516], [-121.88798, 37.69443], [-121.88873, 37.69503]]]} | Open Access 1 | 15251 | Owens Plaza Park | 23276 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 2.554 | Owens Plaza Park | 0 | Local Park 2 | 4 | |
13781 | 13781 | 13780 | {"type": "Polygon", "coordinates": [[[-121.86242, 37.67993], [-121.86223, 37.67999], [-121.86182, 37.68021], [-121.86175, 37.68021], [-121.86156, 37.68003], [-121.8614, 37.67992], [-121.8612, 37.67984], [-121.86096, 37.67978], [-121.86097, 37.67923], [-121.86135, 37.67899], [-121.86162, 37.67876], [-121.86169, 37.67876], [-121.86172, 37.67878], [-121.86149, 37.67898], [-121.8621, 37.67943], [-121.86221, 37.67955], [-121.86234, 37.67986], [-121.86242, 37.67993]]]} | Open Access 1 | 36328 | Pleasanton holding 1 | 23804 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 2.66 | Pleasanton holding 1 | 0 | Local Other or Unknown 14 | 4 | |
9255 | 9255 | 9254 | {"type": "Polygon", "coordinates": [[[-121.87788, 37.68315], [-121.87643, 37.68352], [-121.87618, 37.68275], [-121.87762, 37.68246], [-121.87788, 37.68315]]]} | Open Access 1 | 15412 | Bicentennial Park | 16065 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 2.747 | Bicentennial Park | 0 | Local Park 2 | 4 | |
9197 | 9197 | 9196 | {"type": "Polygon", "coordinates": [[[-121.88663, 37.67994], [-121.88658, 37.68116], [-121.88644, 37.6813], [-121.88546, 37.68088], [-121.8855, 37.67988], [-121.88663, 37.67994]]]} | Open Access 1 | 15265 | Woodthrush Park | 27749 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 3.297 | Woodthrush Park | 0 | Local Park 2 | 4 | |
9276 | 9276 | 9275 | {"type": "Polygon", "coordinates": [[[-121.88627, 37.67414], [-121.88627, 37.67462], [-121.88625, 37.67466], [-121.88621, 37.67468], [-121.88577, 37.67469], [-121.88559, 37.67473], [-121.88544, 37.67479], [-121.88525, 37.67491], [-121.88509, 37.67508], [-121.88499, 37.67527], [-121.88495, 37.67548], [-121.88451, 37.67547], [-121.88458, 37.67544], [-121.88462, 37.6754], [-121.88463, 37.67516], [-121.8847, 37.67509], [-121.88472, 37.67501], [-121.88468, 37.67491], [-121.88458, 37.67485], [-121.88458, 37.67469], [-121.8843, 37.67468], [-121.88431, 37.67456], [-121.88448, 37.67442], [-121.88448, 37.67414], [-121.88627, 37.67414]]]} | Open Access 1 | 15449 | Walnut Grove Park | 27231 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 3.453 | Walnut Grove Park | 0 | Local Park 2 | 4 | |
9258 | 9258 | 9257 | {"type": "Polygon", "coordinates": [[[-121.91748, 37.67551], [-121.91697, 37.67568], [-121.91623, 37.67439], [-121.91451, 37.67491], [-121.91436, 37.67469], [-121.91537, 37.67446], [-121.91538, 37.67433], [-121.91695, 37.67405], [-121.91699, 37.67425], [-121.91694, 37.67437], [-121.91748, 37.67551]]]} | Open Access 1 | 15418 | Oakhill Park | 23028 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 3.484 | Oakhill Park | 0 | Local Park 2 | 4 | |
9289 | 9289 | 9288 | {"type": "Polygon", "coordinates": [[[-121.85656, 37.66294], [-121.85641, 37.66331], [-121.85608, 37.66315], [-121.85569, 37.66322], [-121.85554, 37.66342], [-121.8556, 37.66364], [-121.85545, 37.66393], [-121.85512, 37.66409], [-121.85492, 37.66412], [-121.8546, 37.66419], [-121.85432, 37.66405], [-121.85418, 37.66405], [-121.85397, 37.66408], [-121.85398, 37.6634], [-121.85656, 37.66294]]]} | Open Access 1 | 15475 | Tawny Park | 26198 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 3.542 | Tawny Park | 0 | Local Park 2 | 4 | |
9271 | 9271 | 9270 | {"type": "Polygon", "coordinates": [[[-121.91123, 37.66511], [-121.90939, 37.66585], [-121.90889, 37.66483], [-121.90929, 37.66467], [-121.90961, 37.66481], [-121.91004, 37.6649], [-121.91048, 37.66487], [-121.91099, 37.66471], [-121.91123, 37.66511]]]} | Open Access 1 | 15437 | Meadowlark Park | 22090 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 3.577 | Meadowlark Park | 0 | Local Park 2 | 4 | |
9231 | 9231 | 9230 | {"type": "Polygon", "coordinates": [[[-121.85036, 37.65762], [-121.84964, 37.65799], [-121.84955, 37.65798], [-121.84914, 37.65786], [-121.84905, 37.6582], [-121.84875, 37.65815], [-121.84864, 37.65811], [-121.84855, 37.65812], [-121.84834, 37.65768], [-121.84763, 37.65711], [-121.84817, 37.65719], [-121.8486, 37.65721], [-121.84898, 37.65717], [-121.84946, 37.65708], [-121.84975, 37.65705], [-121.84979, 37.65744], [-121.85021, 37.65742], [-121.85036, 37.65762]]]} | Open Access 1 | 15478 | Vintage Hills Park | 27146 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 3.86 | Vintage Hills Park | 0 | Local Park 2 | 4 | |
8525 | 8525 | 8524 | {"type": "Polygon", "coordinates": [[[-121.85977, 37.69562], [-121.85969, 37.69728], [-121.85872, 37.6973], [-121.85841, 37.69714], [-121.85853, 37.69673], [-121.85848, 37.69604], [-121.85861, 37.69577], [-121.85907, 37.69559], [-121.85977, 37.69562]]]} | Open Access 1 | 15392 | Meadows Park | 22098 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 4.869 | Meadows Park | 0 | Local Park 2 | 4 | |
9273 | 9273 | 9272 | {"type": "Polygon", "coordinates": [[[-121.90762, 37.66974], [-121.90641, 37.67016], [-121.90629, 37.66994], [-121.90608, 37.66966], [-121.90591, 37.66939], [-121.90574, 37.66904], [-121.90569, 37.66872], [-121.90696, 37.66847], [-121.90762, 37.66974]]]} | Open Access 1 | 15440 | Del Prado Park | 18047 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 4.872 | Del Prado 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]);