superunits_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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3001 | 3001 | 3000 | {"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 | Civic Park | 17372 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 0.563 | Civic Park | ||
10844 | 10844 | 10843 | {"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 | Veterans Plaza | 27060 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 0.595 | Veterans Plaza | ||
3555 | 3555 | 3554 | {"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 | Delucchi Park | 18079 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 0.731 | Delucchi Park | ||
5004 | 5004 | 5003 | {"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.89289, 37.67514], [-121.89397, 37.67515]]]} | Open Access 1 | Heatherlark Park | 19786 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 0.744 | Heatherlark Park | ||
6261 | 6261 | 6260 | {"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 | Lions Wayside Park | 21328 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 0.803 | Lions Wayside Park | ||
2093 | 2093 | 2092 | {"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 | BMX Facility | 16201 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 0.847 | BMX Facility | ||
4946 | 4946 | 4945 | {"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 | Harvest Park | 19723 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1.567 | Harvest Park | ||
925 | 925 | 924 | {"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 | McKinley Park | 22047 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 2.046 | McKinley Park | ||
10148 | 10148 | 10147 | {"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.88009, 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.88428, 37.68682], [-121.886, 37.6863], [-121.8862, 37.68633]]]} | Open Access 1 | Sutter Creek Gate Park | 26084 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 2.199 | Sutter Creek Gate Park | ||
7823 | 7823 | 7822 | {"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 | Owens Plaza Park | 23276 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 2.554 | Owens Plaza Park | ||
7020 | 7020 | 7019 | {"type": "Polygon", "coordinates": [[[-121.86242, 37.67993], [-121.86223, 37.67999], [-121.86182, 37.68021], [-121.86175, 37.68021], [-121.86156, 37.68003], [-121.86141, 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.8615, 37.67899], [-121.8621, 37.67943], [-121.86221, 37.67955], [-121.86234, 37.67985], [-121.86242, 37.67993]]]} | Open Access 1 | Pleasanton holding 1 | 23804 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 2.663 | Pleasanton holding 1 | ||
214 | 214 | 213 | {"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 | Bicentennial Park | 16065 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 2.746 | Bicentennial Park | ||
11411 | 11411 | 11410 | {"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 | Woodthrush Park | 27749 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 3.296 | Woodthrush Park | ||
11000 | 11000 | 10999 | {"type": "Polygon", "coordinates": [[[-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.88457, 37.67469], [-121.8843, 37.67468], [-121.88431, 37.67456], [-121.88448, 37.67442], [-121.88448, 37.67414], [-121.88627, 37.67414], [-121.88627, 37.67462]]]} | Open Access 1 | Walnut Grove Park | 27231 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 3.455 | Walnut Grove Park | ||
7602 | 7602 | 7601 | {"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 | Oakhill Park | 23028 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 3.493 | Oakhill Park | ||
10236 | 10236 | 10235 | {"type": "Polygon", "coordinates": [[[-121.85656, 37.66294], [-121.85641, 37.66331], [-121.85608, 37.66315], [-121.85568, 37.66323], [-121.85554, 37.66341], [-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 | Tawny Park | 26198 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 3.543 | Tawny Park | ||
6881 | 6881 | 6880 | {"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 | Meadowlark Park | 22090 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 3.577 | Meadowlark Park | ||
10924 | 10924 | 10923 | {"type": "Polygon", "coordinates": [[[-121.85036, 37.65762], [-121.84964, 37.65799], [-121.84955, 37.65798], [-121.84914, 37.65787], [-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 | Vintage Hills Park | 27146 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 3.866 | Vintage Hills Park | ||
6888 | 6888 | 6887 | {"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 | Meadows Park | 22098 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 4.868 | Meadows Park | ||
3538 | 3538 | 3537 | {"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 | Del Prado Park | 18047 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 4.872 | Del Prado 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]);