units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
128 rows where COUNTY = 1 and MNG_AG_TYP = 2 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_TYP, MNG_AG_ID, YR_EST
DES_TP 19
- Local Park 73
- Local Recreation Area 32
- Local Other or Unknown 7
- Local Conservation Area 1
- None 1
- None 1
- Local Historic or Cultural 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
MNG_AGENCY 7
ACCESS_TYP 2
- Open Access 125
- Restricted Access 3
MNG_AG_TYP 1
- City Agency · 128 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4580 | 4580 | 4579 | {"type": "Polygon", "coordinates": [[[-120.65368, 35.25981], [-120.65355, 35.25973], [-120.65336, 35.25938], [-120.65327, 35.25852], [-120.65304, 35.25837], [-120.65297, 35.25826], [-120.65294, 35.25809], [-120.653, 35.2577], [-120.65339, 35.25769], [-120.65368, 35.25981]]]} | Open Access 1 | 35313 | 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 | 1.637 | 0 | Local Other or Unknown 14 | 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 | ||
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 | ||
4802 | 4802 | 4801 | {"type": "Polygon", "coordinates": [[[-120.66013, 35.63128], [-120.65942, 35.63268], [-120.65926, 35.63296], [-120.65904, 35.63322], [-120.65859, 35.63364], [-120.65798, 35.63378], [-120.6577, 35.63328], [-120.65709, 35.63251], [-120.65635, 35.63171], [-120.65613, 35.63141], [-120.656, 35.63112], [-120.65584, 35.6307], [-120.65575, 35.63011], [-120.65576, 35.62995], [-120.65587, 35.62993], [-120.65595, 35.62995], [-120.65595, 35.63027], [-120.65598, 35.63049], [-120.65603, 35.63073], [-120.6561, 35.63095], [-120.6562, 35.63117], [-120.65643, 35.63159], [-120.65674, 35.63195], [-120.65711, 35.63228], [-120.65757, 35.63281], [-120.65772, 35.63301], [-120.65818, 35.63275], [-120.65829, 35.63277], [-120.65841, 35.63275], [-120.65885, 35.63303], [-120.659, 35.63286], [-120.65945, 35.6323], [-120.66004, 35.63116], [-120.66012, 35.63122], [-120.66013, 35.63128]]]} | Open Access 1 | 48594 | Unknown park - Paso Robles, City of | 33303 | 1247 | Paso Robles, City of 118 | City 2 | City Agency 2 | http://www.prcity.com/government/departments/recreation/facilities/index.asp | City 2 | 1247 | Paso Robles, City of 115 | City 2 | City Agency 2 | San Luis Obispo 1 | 4.795 | 0 | Local Other or Unknown 14 | 4 | ||
12384 | 12384 | 12383 | {"type": "Polygon", "coordinates": [[[-120.61198, 35.11407], [-120.61192, 35.1148], [-120.60972, 35.11469], [-120.60972, 35.11439], [-120.60966, 35.11409], [-120.61027, 35.11394], [-120.61038, 35.11396], [-120.6107, 35.11398], [-120.61068, 35.114], [-120.61069, 35.11401], [-120.61198, 35.11407]]]} | Open Access 1 | 26521 | 16th Street Park | 15175 | 1452 | Grover Beach, City of 654 | City 2 | City Agency 2 | http://www.grover.org/index.aspx?nid=141 | City 2 | 1452 | Grover Beach, City of 643 | City 2 | City Agency 2 | San Luis Obispo 1 | 4.082 | 16th Street Park | 0 | Local Park 2 | 4 | |
12414 | 12414 | 12413 | {"type": "Polygon", "coordinates": [[[-120.85418, 35.36759], [-120.85413, 35.3676], [-120.85392, 35.3673], [-120.85407, 35.36728], [-120.85418, 35.36759]]]} | Open Access 1 | 27020 | Anchor Memorial Park | 15470 | 1453 | Morro Bay, City of 648 | City 2 | City Agency 2 | http://www.morro-bay.ca.us/index.aspx?nid=292 | City 2 | 1453 | Morro Bay, City of 638 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.081 | Anchor Memorial Park | 0 | Local Park 2 | 4 | |
12413 | 12413 | 12412 | {"type": "Polygon", "coordinates": [[[-120.8521, 35.36149], [-120.85186, 35.36149], [-120.85184, 35.36146], [-120.85128, 35.36146], [-120.85126, 35.36012], [-120.85143, 35.36012], [-120.85163, 35.36043], [-120.85188, 35.36091], [-120.85199, 35.36116], [-120.8521, 35.36149]]]} | Open Access 1 | 27019 | Anchor Street Park | 15471 | 1453 | Morro Bay, City of 648 | City 2 | City Agency 2 | http://www.morro-bay.ca.us/index.aspx?nid=292 | City 2 | 1453 | Morro Bay, City of 638 | City 2 | City Agency 2 | San Luis Obispo 1 | 1.792 | Anchor Street Park | 0 | Local Park 2 | 4 | |
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 | |
14185 | 14185 | 14184 | {"type": "Polygon", "coordinates": [[[-120.6696, 35.4669], [-120.66937, 35.46727], [-120.66919, 35.46762], [-120.66913, 35.46761], [-120.66897, 35.46805], [-120.66891, 35.46832], [-120.66888, 35.46856], [-120.66803, 35.46825], [-120.66739, 35.4682], [-120.66714, 35.46815], [-120.66828, 35.4673], [-120.6684, 35.46719], [-120.6685, 35.46705], [-120.66856, 35.46693], [-120.6686, 35.4668], [-120.66861, 35.46667], [-120.66881, 35.46665], [-120.66906, 35.46668], [-120.66925, 35.46674], [-120.6696, 35.4669]]]} | Open Access 1 | 44000 | Atascadero Lake Park | 15663 | 1012 | Atascadero, City of 549 | City 2 | City Agency 2 | http://www.atascadero.org/index.php?option=com_content&view=article&id=670&Itemid=584 | City 2 | 1012 | Atascadero, City of 542 | City 2 | City Agency 2 | San Luis Obispo 1 | 5.165 | Atascadero Lake Park | 0 | Local Park 2 | 4 | |
14192 | 14192 | 14191 | {"type": "Polygon", "coordinates": [[[-120.64741, 35.63952], [-120.64718, 35.64084], [-120.64712, 35.64141], [-120.64637, 35.64106], [-120.64222, 35.63949], [-120.64254, 35.63916], [-120.64347, 35.63754], [-120.64465, 35.63754], [-120.64465, 35.63686], [-120.64657, 35.63685], [-120.64669, 35.63773], [-120.6467, 35.63819], [-120.64669, 35.63833], [-120.64671, 35.63848], [-120.64678, 35.63862], [-120.64741, 35.63952]]]} | Open Access 1 | 44026 | Barney Schwartz Sports Park | 15824 | 1247 | Paso Robles, City of 118 | City 2 | City Agency 2 | http://www.prcity.com/government/departments/recreation/facilities/index.asp | City 2 | 1247 | Paso Robles, City of 115 | City 2 | City Agency 2 | San Luis Obispo 1 | 34.519 | Barney Schwartz Sports Park | 0 | Local Recreation Area 3 | 4 | |
12412 | 12412 | 12411 | {"type": "Polygon", "coordinates": [[[-120.84689, 35.3556], [-120.84558, 35.35562], [-120.84559, 35.3546], [-120.84551, 35.3544], [-120.84528, 35.35428], [-120.84515, 35.35423], [-120.84516, 35.35411], [-120.84516, 35.35357], [-120.84556, 35.35356], [-120.84573, 35.35379], [-120.84579, 35.354], [-120.84613, 35.35443], [-120.84621, 35.35466], [-120.84634, 35.35484], [-120.84632, 35.35491], [-120.84654, 35.35525], [-120.84689, 35.3556]]]} | Open Access 1 | 27018 | Bay Shore Bluffs | 15879 | 1453 | Morro Bay, City of 648 | City 2 | City Agency 2 | http://www.morro-bay.ca.us/index.aspx?nid=292 | City 2 | 1453 | Morro Bay, City of 638 | City 2 | City Agency 2 | San Luis Obispo 1 | 3.856 | Bay Shore Bluffs | None 1077 | |||
10503 | 10503 | 10502 | {"type": "Polygon", "coordinates": [[[-120.7155, 35.17647], [-120.71532, 35.17671], [-120.71502, 35.17656], [-120.71492, 35.17653], [-120.71464, 35.17652], [-120.7144, 35.17646], [-120.71298, 35.17625], [-120.71214, 35.17602], [-120.712, 35.17597], [-120.71183, 35.17586], [-120.7115, 35.17559], [-120.71136, 35.17551], [-120.71117, 35.17544], [-120.71042, 35.1753], [-120.70961, 35.17522], [-120.70837, 35.17482], [-120.70817, 35.17477], [-120.70797, 35.17475], [-120.70779, 35.17475], [-120.70738, 35.17481], [-120.70727, 35.17481], [-120.70726, 35.17476], [-120.70732, 35.17476], [-120.70733, 35.17474], [-120.70729, 35.1747], [-120.70724, 35.17469], [-120.70745, 35.17424], [-120.70747, 35.17424], [-120.70734, 35.17411], [-120.70737, 35.17408], [-120.70761, 35.1742], [-120.70781, 35.17421], [-120.70781, 35.17419], [-120.70761, 35.17404], [-120.7077, 35.17404], [-120.70804, 35.17422], [-120.70812, 35.17423], [-120.70841, 35.17436], [-120.70857, 35.17448], [-120.70863, 35.17455], [-120.7089, 35.17474], [-120.70902, 35.1748], [-120.70923, 35.17481], [-120.70935, 35.17487], [-120.70968, 35.17501], [-120.7098, 35.17501], [-120.70979, 35.1749], [-120.70988, 35.17483], [-120.70993, 35.17472], [-120.70998, 35.17474], [-120.71015, 35.17471], [-120.71035, 35.17475], [-120.71045, 35.17483], [-120.71073, 35.17479], [-120.71088, 35.17466], [-120.71091, 35.17458], [-120.71088, 35.17451], [-120.71095, 35.17448], [-120.71105, 35.17449], [-120.71117, 35.17458], [-120.71157, 35.17478], [-120.71154, 35.17481], [-120.71163, 35.17486], [-120.71165, 35.17492], [-120.71177, 35.17498], [-120.71177, 35.17501], [-120.71187, 35.17512], [-120.71176, 35.17514], [-120.71177, 35.17519], [-120.71185, 35.17518], [-120.71195, 35.17539], [-120.71185, 35.17562], [-120.71195, 35.17576], [-120.71292, 35.17611], [-120.7146, 35.17641], [-120.7155, 35.17647]]]} | Open Access 1 | 18624 | Bluff Coastal Trail | 16196 | 1253 | Pismo Beach, City of 423 | City 2 | City Agency 2 | http://www.pismobeach.org/69/Parks-Halls | City 2 | 1253 | Pismo Beach, City of 417 | City 2 | City Agency 2 | San Luis Obispo 1 | 7.316 | Bluff Coastal Trail | 0 | Local Recreation Area 3 | 4 | |
10649 | 10649 | 10648 | {"type": "Polygon", "coordinates": [[[-120.64029, 35.14711], [-120.6401, 35.14735], [-120.63945, 35.14699], [-120.63947, 35.14695], [-120.63938, 35.14688], [-120.63933, 35.14681], [-120.63919, 35.14658], [-120.63918, 35.1465], [-120.64029, 35.14711]]]} | Open Access 1 | 18979 | Boosinger Park | 16272 | 1253 | Pismo Beach, City of 423 | City 2 | City Agency 2 | http://www.pismobeach.org/69/Parks-Halls | City 2 | 1253 | Pismo Beach, City of 417 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.783 | Boosinger Park | 0 | Local Park 2 | 4 | |
5209 | 5209 | 5208 | {"type": "Polygon", "coordinates": [[[-120.64834, 35.27987], [-120.64777, 35.28012], [-120.64769, 35.28005], [-120.64693, 35.28028], [-120.64762, 35.28098], [-120.64659, 35.28143], [-120.64705, 35.28222], [-120.64729, 35.28232], [-120.64701, 35.28266], [-120.6462, 35.28292], [-120.64597, 35.28404], [-120.64486, 35.28361], [-120.64485, 35.2833], [-120.64358, 35.28331], [-120.64076, 35.28337], [-120.64085, 35.28694], [-120.63102, 35.28738], [-120.63113, 35.27994], [-120.64057, 35.2798], [-120.64326, 35.27863], [-120.64343, 35.27889], [-120.64348, 35.27962], [-120.64386, 35.27961], [-120.64429, 35.27923], [-120.64468, 35.27912], [-120.64499, 35.2792], [-120.64532, 35.27924], [-120.64567, 35.27918], [-120.64605, 35.2792], [-120.64675, 35.2796], [-120.6469, 35.27965], [-120.64704, 35.27963], [-120.64793, 35.27936], [-120.64834, 35.27987]]]} | Open Access 1 | 13 | Bowden Ranch | 16306 | 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 | 242.507 | Bowden Ranch | 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 | |
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 | |
15789 | 15789 | 15788 | {"type": "Polygon", "coordinates": [[[-120.69799, 35.30167], [-120.69787, 35.31108], [-120.69713, 35.3111], [-120.6962, 35.3114], [-120.69467, 35.31148], [-120.6936, 35.31138], [-120.69352, 35.30916], [-120.694, 35.30899], [-120.69429, 35.30883], [-120.69428, 35.3086], [-120.69385, 35.3083], [-120.69355, 35.3083], [-120.69362, 35.30163], [-120.69799, 35.30167]]]} | Open Access 1 | 1070 | Bunnell Open Space | 16505 | 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 | 104.136 | Bunnell OS | 0 | Local Recreation Area 3 | 4 | |
14207 | 14207 | 14206 | {"type": "Polygon", "coordinates": [[[-120.67156, 35.62056], [-120.67153, 35.62077], [-120.67139, 35.62097], [-120.67131, 35.62119], [-120.67099, 35.623], [-120.67099, 35.62312], [-120.67067, 35.62315], [-120.67046, 35.62335], [-120.66796, 35.62268], [-120.66794, 35.62125], [-120.67018, 35.62103], [-120.67156, 35.62056]]]} | Open Access 1 | 44070 | Centennial Park | 17026 | 1247 | Paso Robles, City of 118 | City 2 | City Agency 2 | http://www.prcity.com/government/departments/recreation/facilities/index.asp | City 2 | 1247 | Paso Robles, City of 115 | City 2 | City Agency 2 | San Luis Obispo 1 | 16.173 | Centennial 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 | |
12407 | 12407 | 12406 | {"type": "Polygon", "coordinates": [[[-120.57814, 35.12144], [-120.57791, 35.12153], [-120.57748, 35.12096], [-120.57813, 35.12143], [-120.57814, 35.12144]]]} | Open Access 1 | 27008 | Christmas Tree Island Park | 17229 | 1454 | Arroyo Grande, City of 611 | City 2 | City Agency 2 | http://www.arroyogrande.org/ | City 2 | 1454 | Arroyo Grande, City of 600 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.222 | Christmas Tree Island 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]);