superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1, MNG_AGENCY = 434 and YR_EST = 1940
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
66 | 66 | 65 | {"type": "Polygon", "coordinates": [[[-122.40576, 37.63377], [-122.40541, 37.63374], [-122.40526, 37.63285], [-122.40564, 37.63282], [-122.40576, 37.63377]]]} | Open Access 1 | 7th Avenue and Walnut Park | 15213 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 0.806 | 7th Avenue and Walnut Park | 1940 | |
104 | 104 | 103 | {"type": "Polygon", "coordinates": [[[-122.40517, 37.62935], [-122.40481, 37.62939], [-122.40477, 37.62877], [-122.40516, 37.62875], [-122.40517, 37.62935]]]} | Open Access 1 | 7th Avenue Park | 15214 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 0.556 | 7th Avenue Park | 1940 | |
5074 | 5074 | 5073 | {"type": "Polygon", "coordinates": [[[-122.41355, 37.63561], [-122.41355, 37.63561], [-122.41334, 37.63565], [-122.41336, 37.63552], [-122.41342, 37.63547], [-122.41351, 37.63555], [-122.41355, 37.63561]]]} | Open Access 1 | Herman Tot Lot | 19867 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 0.055 | Herman Tot Lot | 1940 | |
8316 | 8316 | 8315 | {"type": "Polygon", "coordinates": [[[-122.41128, 37.62838], [-122.41123, 37.62888], [-122.41123, 37.62888], [-122.41096, 37.62843], [-122.41128, 37.62838]]]} | Open Access 1 | Posy Park | 23918 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 0.191 | Posy Park | 1940 | |
9158 | 9158 | 9157 | {"type": "Polygon", "coordinates": [[[-122.42029, 37.61328], [-122.41978, 37.61352], [-122.42007, 37.61395], [-122.41969, 37.61397], [-122.41819, 37.61396], [-122.41797, 37.61398], [-122.41777, 37.61402], [-122.41684, 37.61436], [-122.41657, 37.61449], [-122.41644, 37.61459], [-122.41627, 37.61474], [-122.41581, 37.61531], [-122.41392, 37.61739], [-122.41261, 37.61578], [-122.41261, 37.61577], [-122.41259, 37.61574], [-122.41283, 37.61557], [-122.41515, 37.61373], [-122.41687, 37.61283], [-122.41984, 37.61265], [-122.42029, 37.61328]]]} | Open Access 1 | San Bruno City Park | 24839 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 29.152 | San Bruno City Park | 1940 |
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]);