superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
63 rows where MNG_AGENCY = 22 and MNG_AG_TYP = 2 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14945 | 14945 | 14944 | {"type": "Polygon", "coordinates": [[[-120.65509, 35.2621], [-120.65487, 35.26189], [-120.65504, 35.26178], [-120.65504, 35.26178], [-120.65509, 35.2621]]]} | Open Access 1 | Stoneridge Development Open Space | 25895 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.077 | Stoneridge Development OS | ||
3556 | 3556 | 3555 | {"type": "Polygon", "coordinates": [[[-120.65678, 35.27035], [-120.65649, 35.27035], [-120.65653, 35.27006], [-120.65655, 35.27006], [-120.65678, 35.27035]]]} | Open Access 1 | Demonstration Garden | 18081 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.116 | Demonstration Garden | ||
8877 | 8877 | 8876 | {"type": "Polygon", "coordinates": [[[-120.6535, 35.26278], [-120.65337, 35.26287], [-120.65316, 35.26262], [-120.6533, 35.26255], [-120.6535, 35.26278]]]} | Open Access 1 | Rockview Right-of-Way | 24536 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.123 | Rockview Right-of-Way | ||
1504 | 1504 | 1503 | {"type": "Polygon", "coordinates": [[[-120.66794, 35.28932], [-120.66778, 35.28934], [-120.66772, 35.289], [-120.66786, 35.28898], [-120.66794, 35.28932]]]} | Open Access 1 | Anholm Park | 15499 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.131 | Anholm Park | ||
7792 | 7792 | 7791 | {"type": "Polygon", "coordinates": [[[-120.65641, 35.27609], [-120.65609, 35.27575], [-120.65632, 35.27561], [-120.65632, 35.27561], [-120.65641, 35.27609]]]} | Open Access 1 | Osos Street Mini Park | 23238 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.152 | Osos Street MP | ||
2276 | 2276 | 2275 | {"type": "Polygon", "coordinates": [[[-120.67182, 35.26907], [-120.67141, 35.26903], [-120.67144, 35.26882], [-120.67171, 35.26885], [-120.67182, 35.26907]]]} | Open Access 1 | Brook St Park | 16418 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.178 | Brook St Park | ||
3969 | 3969 | 3968 | {"type": "Polygon", "coordinates": [[[-120.65309, 35.28478], [-120.65265, 35.28512], [-120.65267, 35.28516], [-120.6525, 35.28528], [-120.65261, 35.28492], [-120.65298, 35.28474], [-120.65306, 35.28476], [-120.65309, 35.28478]]]} | Open Access 1 | Elsford Park | 18604 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.234 | Elsford Park | ||
11870 | 11870 | 11869 | {"type": "Polygon", "coordinates": [[[-120.65903, 35.28087], [-120.65874, 35.28105], [-120.65843, 35.2807], [-120.65888, 35.2807], [-120.65903, 35.28087]]]} | Open Access 1 | Cheng Park | 28552 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.288 | Cheng Park | ||
2344 | 2344 | 2343 | {"type": "Polygon", "coordinates": [[[-120.64894, 35.29378], [-120.64887, 35.29382], [-120.64879, 35.29381], [-120.64876, 35.29378], [-120.64868, 35.29364], [-120.64866, 35.29354], [-120.64866, 35.29345], [-120.64872, 35.29336], [-120.64877, 35.29332], [-120.64882, 35.2933], [-120.64889, 35.29332], [-120.64892, 35.29336], [-120.64896, 35.29346], [-120.64898, 35.29362], [-120.64894, 35.29378]]]} | Open Access 1 | Buena Vista Park | 16494 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.314 | Buena Vista Park | ||
14891 | 14891 | 14890 | {"type": "Polygon", "coordinates": [[[-120.64765, 35.28009], [-120.64706, 35.28043], [-120.64684, 35.28024], [-120.64756, 35.28002], [-120.64765, 35.28009]]]} | Open Access 1 | Lizzie Street Open Space | 21387 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.328 | Lizzie Street OS | ||
3893 | 3893 | 3892 | {"type": "Polygon", "coordinates": [[[-120.6396, 35.24762], [-120.63946, 35.24768], [-120.63938, 35.24778], [-120.63955, 35.2481], [-120.63925, 35.24822], [-120.63916, 35.24774], [-120.63956, 35.24759], [-120.6396, 35.24762]]]} | Open Access 1 | El Capitan Open Space | 18485 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.337 | El Capitan OS | ||
10273 | 10273 | 10272 | {"type": "Polygon", "coordinates": [[[-120.65048, 35.27232], [-120.65015, 35.27225], [-120.65007, 35.27225], [-120.64975, 35.27174], [-120.65003, 35.2716], [-120.65004, 35.27181], [-120.65022, 35.27207], [-120.65028, 35.27205], [-120.65048, 35.27232]]]} | Open Access 1 | Terrace Hill Water Tank | 26258 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.443 | Terrace Hill Water Tank | ||
7068 | 7068 | 7067 | {"type": "Polygon", "coordinates": [[[-120.66585, 35.27882], [-120.66573, 35.27879], [-120.66561, 35.27879], [-120.66488, 35.27923], [-120.66485, 35.27919], [-120.66488, 35.27903], [-120.6649, 35.27899], [-120.66497, 35.27894], [-120.66518, 35.27881], [-120.66563, 35.27858], [-120.66585, 35.27882]]]} | Open Access 1 | Mission Plaza Open Space | 22308 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.487 | Mission Plaza OS | ||
7994 | 7994 | 7993 | {"type": "Polygon", "coordinates": [[[-120.66515, 35.26775], [-120.66469, 35.26776], [-120.66468, 35.26753], [-120.66465, 35.26734], [-120.66515, 35.26732], [-120.66515, 35.26775]]]} | Open Access 1 | Part of Exposition Park (3) | 23484 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.506 | Part of Exposition Park (3) | ||
3408 | 3408 | 3407 | {"type": "Polygon", "coordinates": [[[-120.68013, 35.26112], [-120.67995, 35.26126], [-120.67904, 35.26056], [-120.67918, 35.26044], [-120.68005, 35.26111], [-120.68013, 35.26112]]]} | Open Access 1 | Dalidio | 17897 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.516 | Dalidio | ||
3351 | 3351 | 3350 | {"type": "Polygon", "coordinates": [[[-120.66948, 35.27794], [-120.66942, 35.27805], [-120.66924, 35.27827], [-120.66871, 35.27798], [-120.66901, 35.27765], [-120.66948, 35.27794]]]} | Open Access 1 | Dana Adobe | 17907 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.619 | Dana Adobe | ||
6765 | 6765 | 6764 | {"type": "Polygon", "coordinates": [[[-120.67031, 35.27347], [-120.67028, 35.27355], [-120.67023, 35.27354], [-120.67001, 35.27385], [-120.66985, 35.27411], [-120.66952, 35.27407], [-120.66965, 35.2734], [-120.67031, 35.27347]]]} | Open Access 1 | Matthews Open Space | 21957 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.824 | Matthews OS | ||
3131 | 3131 | 3130 | {"type": "Polygon", "coordinates": [[[-120.66879, 35.28386], [-120.66872, 35.28416], [-120.66854, 35.28442], [-120.66814, 35.28394], [-120.66814, 35.28392], [-120.66805, 35.2838], [-120.66825, 35.28346], [-120.66825, 35.28341], [-120.66879, 35.28386]]]} | Open Access 1 | Community Garden | 17568 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 0.961 | Community Garden | ||
4456 | 4456 | 4455 | {"type": "Polygon", "coordinates": [[[-120.65128, 35.26695], [-120.65108, 35.26705], [-120.6498, 35.2662], [-120.64958, 35.266], [-120.64939, 35.26574], [-120.64957, 35.26564], [-120.64973, 35.26588], [-120.64997, 35.2661], [-120.65128, 35.26695]]]} | Open Access 1 | Future Railroad Area Bike Path | 19160 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1.045 | Future Railroad Area Bike Path | ||
10003 | 10003 | 10002 | {"type": "Polygon", "coordinates": [[[-120.65583, 35.26164], [-120.65564, 35.26199], [-120.6555, 35.26196], [-120.65536, 35.26197], [-120.65525, 35.26201], [-120.65509, 35.2621], [-120.65493, 35.26108], [-120.65583, 35.26164]]]} | Open Access 1 | Stoneridge Development Park | 25896 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1.191 | Stoneridge Development 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]);