units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
66 rows where MNG_AGENCY = 22 and MNG_AG_TYP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, YR_EST, GAP_STS
DES_TP 16
- Local Recreation Area 26
- Local Park 21
- Local Other or Unknown 6
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
LAYER 2 ✖
- City 64
- Other State 2
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency · 66 ✖
MNG_AGENCY 1
- San Luis Obispo, City of · 66 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4656 | 4656 | 4655 | {"type": "Polygon", "coordinates": [[[-120.65374, 35.27663], [-120.65364, 35.27676], [-120.65352, 35.27662], [-120.65365, 35.27654], [-120.65374, 35.27663]]]} | Open Access 1 | 36580 | Unnamed site - San Luis Obispo, City of | 28661 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.06 | 0 | Local Other or Unknown 14 | 4 | ||
6147 | 6147 | 6146 | {"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 | 1140 | 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 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.077 | Stoneridge Development OS | 0 | Local Recreation Area 3 | 4 | |
1577 | 1577 | 1576 | {"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 | 13290 | Demonstration Garden | 18081 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.116 | Demonstration Garden | 0 | Local Park 2 | 4 | |
40 | 40 | 39 | {"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 | 127 | 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 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.123 | Rockview Right-of-Way | None 7 | |||
8107 | 8107 | 8106 | {"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 | 12200 | Anholm Park | 15499 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.132 | Anholm Park | 0 | Local Park 2 | 4 | |
4581 | 4581 | 4580 | {"type": "Polygon", "coordinates": [[[-120.68305, 35.25007], [-120.68298, 35.25011], [-120.68277, 35.25009], [-120.68274, 35.25012], [-120.68269, 35.25007], [-120.68285, 35.24982], [-120.68305, 35.25007]]]} | Open Access 1 | 35336 | Unnamed site - San Luis Obispo, City of | 28661 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.137 | 0 | Local Other or Unknown 14 | 4 | ||
10380 | 10380 | 10379 | {"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 | 18320 | 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 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.152 | Osos Street MP | 0 | Local Park 2 | 4 | |
5892 | 5892 | 5891 | {"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 | 471 | 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 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.179 | Brook St Park | 0 | Local Park 2 | 4 | |
9266 | 9266 | 9265 | {"type": "Polygon", "coordinates": [[[-120.65309, 35.28478], [-120.65265, 35.28513], [-120.65267, 35.28516], [-120.6525, 35.28528], [-120.65261, 35.28492], [-120.65298, 35.28474], [-120.65306, 35.28476], [-120.65306, 35.28477], [-120.65309, 35.28478]]]} | Open Access 1 | 15459 | Elsford Park | 18604 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.233 | Elsford Park | 0 | Local Park 2 | 4 | |
13211 | 13211 | 13210 | {"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 | 35247 | Cheng Park | 28552 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.288 | Cheng Park | 0 | Local Park 2 | 4 | |
458 | 458 | 457 | {"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 | 920 | 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 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.314 | Buena Vista Park | 0 | Local Park 2 | 4 | |
9508 | 9508 | 9507 | {"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 | 17375 | 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 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.329 | Lizzie Street OS | 0 | Local Recreation Area 3 | 4 | |
16111 | 16111 | 16110 | {"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 | 14405 | 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 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.336 | El Capitan OS | 0 | Local Recreation Area 3 | 4 | |
6240 | 6240 | 6239 | {"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.27208], [-120.65028, 35.27205], [-120.65048, 35.27232]]]} | Open Access 1 | 1314 | 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 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.442 | Terrace Hill Water Tank | None 505 | |||
9723 | 9723 | 9722 | {"type": "Polygon", "coordinates": [[[-120.66585, 35.27882], [-120.66574, 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 | 17859 | 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 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.487 | Mission Plaza OS | 0 | Local Recreation Area 3 | 4 | |
2747 | 2747 | 2746 | {"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 | 18428 | 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 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.506 | Part of Exposition Park (3) | None 228 | |||
1631 | 1631 | 1630 | {"type": "Polygon", "coordinates": [[[-120.68013, 35.26112], [-120.67995, 35.26126], [-120.67904, 35.26056], [-120.67918, 35.26044], [-120.68006, 35.26111], [-120.68013, 35.26112]]]} | Open Access 1 | 12445 | Dalidio | 17897 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.516 | Dalidio | None 131 | |||
7801 | 7801 | 7800 | {"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 | 12682 | Dana Adobe | 17907 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.62 | Dana Adobe | None 649 | |||
10158 | 10158 | 10157 | {"type": "Polygon", "coordinates": [[[-120.67031, 35.27347], [-120.67028, 35.27355], [-120.67023, 35.27353], [-120.67001, 35.27385], [-120.66985, 35.27411], [-120.66952, 35.27407], [-120.66965, 35.2734], [-120.67031, 35.27347]]]} | Open Access 1 | 17711 | 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 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.823 | Matthews OS | 0 | Local Recreation Area 3 | 4 | |
1391 | 1391 | 1390 | {"type": "Polygon", "coordinates": [[[-120.66879, 35.28386], [-120.66872, 35.28416], [-120.66854, 35.28442], [-120.66814, 35.28394], [-120.66815, 35.28392], [-120.66805, 35.2838], [-120.66825, 35.28346], [-120.66825, 35.28341], [-120.66879, 35.28386]]]} | Open Access 1 | 8567 | Community Garden | 17568 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.961 | Community Garden | 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]);