units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
73 rows where COUNTY = 1, DES_TP = 2 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
289 | 289 | 288 | {"type": "Polygon", "coordinates": [[[-120.65881, 35.61011], [-120.65607, 35.61011], [-120.65595, 35.6086], [-120.6588, 35.60866], [-120.65881, 35.61011]]]} | Open Access 1 | 781 | Sherwood Park | 25402 | 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 | 10.291 | Sherwood 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 | |
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 | |
1406 | 1406 | 1405 | {"type": "Polygon", "coordinates": [[[-120.70387, 35.26834], [-120.70338, 35.26878], [-120.70205, 35.27003], [-120.70103, 35.26884], [-120.70133, 35.26864], [-120.70172, 35.26839], [-120.70188, 35.26826], [-120.70205, 35.26816], [-120.70278, 35.26782], [-120.70301, 35.26763], [-120.70387, 35.26834]]]} | Open Access 1 | 17333 | Let It Be Park | 21184 | 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 | 7.933 | Let It Be Park | 0 | Local Park 2 | 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 | |
1791 | 1791 | 1790 | {"type": "Polygon", "coordinates": [[[-120.66766, 35.15231], [-120.66578, 35.15506], [-120.66539, 35.15491], [-120.66476, 35.15451], [-120.66432, 35.15427], [-120.66385, 35.1541], [-120.66305, 35.1539], [-120.66241, 35.15379], [-120.66247, 35.1537], [-120.66257, 35.15374], [-120.66266, 35.15375], [-120.66283, 35.15374], [-120.66287, 35.15372], [-120.66294, 35.15363], [-120.66302, 35.1536], [-120.66329, 35.15365], [-120.66341, 35.15364], [-120.66355, 35.15355], [-120.66364, 35.15345], [-120.66374, 35.15341], [-120.66411, 35.15353], [-120.66438, 35.15353], [-120.66447, 35.15345], [-120.66464, 35.15334], [-120.66472, 35.15325], [-120.6651, 35.15311], [-120.66512, 35.15311], [-120.66517, 35.15324], [-120.66534, 35.1533], [-120.66544, 35.15341], [-120.66549, 35.15342], [-120.66552, 35.1534], [-120.66547, 35.15327], [-120.66549, 35.15315], [-120.66547, 35.15308], [-120.66551, 35.15303], [-120.66571, 35.153], [-120.66598, 35.153], [-120.66614, 35.15305], [-120.66627, 35.15307], [-120.66635, 35.15306], [-120.66638, 35.15304], [-120.66641, 35.15297], [-120.66646, 35.15291], [-120.66653, 35.1529], [-120.66685, 35.15291], [-120.66689, 35.15279], [-120.66691, 35.15276], [-120.66709, 35.15268], [-120.66718, 35.15261], [-120.66728, 35.15238], [-120.66736, 35.15234], [-120.66766, 35.15231]]]} | Open Access 1 | 13490 | Dinosaur Caves Park | 18155 | 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 | 11.413 | Dinosaur Caves Park | 0 | Local Park 2 | 4 | |
2315 | 2315 | 2314 | {"type": "Polygon", "coordinates": [[[-120.62757, 35.24826], [-120.62753, 35.24834], [-120.62716, 35.24822], [-120.62709, 35.24832], [-120.62704, 35.24835], [-120.62675, 35.24845], [-120.6267, 35.24848], [-120.62669, 35.24859], [-120.62671, 35.24867], [-120.62679, 35.24871], [-120.62679, 35.24881], [-120.62681, 35.24888], [-120.62674, 35.24898], [-120.62645, 35.24913], [-120.62632, 35.24937], [-120.62632, 35.2496], [-120.62638, 35.24977], [-120.62618, 35.25003], [-120.6262, 35.25021], [-120.62562, 35.25022], [-120.62503, 35.25026], [-120.62371, 35.25045], [-120.62291, 35.25047], [-120.62293, 35.25022], [-120.62298, 35.25003], [-120.62334, 35.25036], [-120.62372, 35.25029], [-120.62391, 35.25023], [-120.62414, 35.25008], [-120.62416, 35.25006], [-120.62384, 35.24988], [-120.62385, 35.24985], [-120.62419, 35.25003], [-120.62428, 35.24994], [-120.62428, 35.24963], [-120.62442, 35.2494], [-120.62455, 35.24927], [-120.62523, 35.24884], [-120.62579, 35.2485], [-120.62578, 35.24849], [-120.62539, 35.24833], [-120.62564, 35.24819], [-120.62591, 35.24843], [-120.62621, 35.24825], [-120.62657, 35.24791], [-120.62666, 35.2477], [-120.62671, 35.2475], [-120.6267, 35.24714], [-120.62739, 35.24715], [-120.62735, 35.24756], [-120.6272, 35.24786], [-120.6272, 35.24799], [-120.62723, 35.24815], [-120.62757, 35.24826]]]} | Open Access 1 | 16992 | Islay Hill Park | 20284 | 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 | 11.306 | Islay Hill Park | 0 | Local Park 2 | 4 | |
2339 | 2339 | 2338 | {"type": "Polygon", "coordinates": [[[-120.69116, 35.62654], [-120.68891, 35.62666], [-120.68884, 35.62584], [-120.69109, 35.62572], [-120.69116, 35.62654]]]} | Open Access 1 | 18438 | Paso Robles City Park | 23502 | 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.612 | Paso Robles City Park | 0 | Local Park 2 | 4 | |
2377 | 2377 | 2376 | {"type": "Polygon", "coordinates": [[[-120.7032, 35.26459], [-120.70313, 35.26495], [-120.70303, 35.26496], [-120.70295, 35.26501], [-120.70291, 35.26507], [-120.70291, 35.26517], [-120.70268, 35.26549], [-120.70264, 35.26551], [-120.70213, 35.26546], [-120.70199, 35.26538], [-120.70188, 35.26538], [-120.70174, 35.26507], [-120.70158, 35.26512], [-120.70152, 35.26504], [-120.70168, 35.26481], [-120.70175, 35.26479], [-120.70181, 35.26476], [-120.70262, 35.2641], [-120.7032, 35.26459]]]} | Open Access 1 | 17192 | Laguna Hills Park | 20857 | 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 | 3.39 | Laguna Hills Park | 0 | Local Park 2 | 4 | |
2534 | 2534 | 2533 | {"type": "Polygon", "coordinates": [[[-120.66036, 35.26938], [-120.65818, 35.26938], [-120.65817, 35.2674], [-120.65853, 35.26738], [-120.65871, 35.26733], [-120.65883, 35.26728], [-120.65901, 35.26753], [-120.66031, 35.26772], [-120.66036, 35.26938]]]} | Open Access 1 | 17748 | Meadow Park | 22074 | 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 | 9.981 | Meadow Park | 0 | Local Park 2 | 4 | |
2720 | 2720 | 2719 | {"type": "Polygon", "coordinates": [[[-120.69856, 35.17257], [-120.69828, 35.17262], [-120.69803, 35.17272], [-120.69728, 35.17319], [-120.69723, 35.1732], [-120.69719, 35.17318], [-120.69653, 35.17256], [-120.69681, 35.17265], [-120.6971, 35.1727], [-120.69739, 35.17268], [-120.69772, 35.17261], [-120.69813, 35.17235], [-120.69793, 35.17213], [-120.6983, 35.17189], [-120.69851, 35.1721], [-120.69856, 35.17257]]]} | Open Access 1 | 18357 | Palisades Park | 23332 | 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 | 1.964 | Palisades Park | 0 | Local Park 2 | 4 | |
2733 | 2733 | 2732 | {"type": "Polygon", "coordinates": [[[-120.63591, 35.45381], [-120.63392, 35.45509], [-120.63393, 35.45511], [-120.63474, 35.45511], [-120.63461, 35.4552], [-120.63385, 35.4552], [-120.63394, 35.45588], [-120.63489, 35.45697], [-120.62841, 35.46093], [-120.62802, 35.46043], [-120.62751, 35.45987], [-120.62825, 35.45912], [-120.62848, 35.45892], [-120.62877, 35.45872], [-120.6289, 35.45859], [-120.62898, 35.45849], [-120.62954, 35.45757], [-120.62978, 35.45731], [-120.63002, 35.45712], [-120.63065, 35.45675], [-120.63098, 35.45659], [-120.63147, 35.45642], [-120.63159, 35.45634], [-120.63168, 35.45624], [-120.63172, 35.45616], [-120.63173, 35.45605], [-120.63174, 35.45507], [-120.63181, 35.45506], [-120.6319, 35.45408], [-120.63203, 35.45368], [-120.63253, 35.45293], [-120.63279, 35.45171], [-120.63287, 35.45096], [-120.63293, 35.45083], [-120.63303, 35.45072], [-120.63314, 35.45066], [-120.63494, 35.45298], [-120.63511, 35.45319], [-120.63548, 35.45352], [-120.63566, 35.45365], [-120.63591, 35.45381]]]} | Open Access 1 | 18371 | Paloma Creek Park | 23361 | 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 | 66.319 | Paloma Creek Park | 0 | Local Park 2 | 4 | |
3275 | 3275 | 3274 | {"type": "Polygon", "coordinates": [[[-120.57874, 35.12285], [-120.57868, 35.12291], [-120.57864, 35.12286], [-120.57789, 35.12326], [-120.57772, 35.12304], [-120.57762, 35.12296], [-120.5778, 35.12286], [-120.57841, 35.12275], [-120.57845, 35.12287], [-120.57873, 35.12277], [-120.57874, 35.12285]]]} | Open Access 1 | 48744 | Kiwanis Park | 33470 | 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.635 | Kiwanis Park | 0 | Local Park 2 | 4 | |
3492 | 3492 | 3491 | {"type": "Polygon", "coordinates": [[[-120.85193, 35.36067], [-120.85147, 35.36], [-120.85147, 35.35992], [-120.85086, 35.35894], [-120.85121, 35.35822], [-120.8513, 35.3584], [-120.85193, 35.36039], [-120.85195, 35.36057], [-120.85193, 35.36067]]]} | Open Access 1 | 27017 | Tidelands Park | 26348 | 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 | 2.1 | Tidelands Park | 0 | Local Park 2 | 4 | |
3514 | 3514 | 3513 | {"type": "Polygon", "coordinates": [[[-120.61439, 35.11511], [-120.61433, 35.11594], [-120.61209, 35.11583], [-120.61214, 35.115], [-120.61439, 35.11511]]]} | Open Access 1 | 26522 | Mentone Basin Park | 22157 | 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.654 | Mentone Basin Park | 0 | Local Park 2 | 4 | |
3670 | 3670 | 3669 | {"type": "Polygon", "coordinates": [[[-120.61242, 35.11026], [-120.61236, 35.11057], [-120.61232, 35.11061], [-120.61228, 35.11061], [-120.61184, 35.11056], [-120.61162, 35.11056], [-120.61162, 35.11015], [-120.61204, 35.11017], [-120.61239, 35.11023], [-120.61242, 35.11026]]]} | Open Access 1 | 44247 | Hero Community Park | 19875 | 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 | 0.771 | Hero Community Park | 0 | Local Park 2 | 4 | |
4294 | 4294 | 4293 | {"type": "MultiPolygon", "coordinates": [[[[-120.56623, 35.13207], [-120.56587, 35.13226], [-120.56577, 35.13369], [-120.56583, 35.13383], [-120.56555, 35.13367], [-120.56518, 35.13334], [-120.56536, 35.13185], [-120.56516, 35.13179], [-120.56518, 35.13175], [-120.56537, 35.13179], [-120.56539, 35.13144], [-120.56574, 35.13153], [-120.56584, 35.13167], [-120.56623, 35.13207]]], [[[-120.56924, 35.13231], [-120.56897, 35.13297], [-120.5688, 35.13299], [-120.56858, 35.13313], [-120.56822, 35.13349], [-120.56811, 35.1337], [-120.56806, 35.13376], [-120.56793, 35.1337], [-120.56811, 35.13331], [-120.5681, 35.13318], [-120.56805, 35.13302], [-120.56791, 35.13283], [-120.56743, 35.13266], [-120.56727, 35.13258], [-120.56748, 35.13193], [-120.56924, 35.13231]]]]} | Open Access 1 | 45333 | Terra de Oro Park | 26252 | 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 | 7.333 | Terra de Oro Park | 0 | Local Park 2 | 4 | |
5021 | 5021 | 5020 | {"type": "Polygon", "coordinates": [[[-120.68667, 35.15986], [-120.68655, 35.16088], [-120.68601, 35.16084], [-120.68614, 35.15961], [-120.68639, 35.15973], [-120.68654, 35.15979], [-120.68667, 35.15986]]]} | Open Access 1 | 1049 | Spyglass Park | 25760 | 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 | 1.557 | Spyglass Park | 0 | Local Park 2 | 4 | |
5180 | 5180 | 5179 | {"type": "Polygon", "coordinates": [[[-120.66936, 35.15233], [-120.66922, 35.15246], [-120.66878, 35.15229], [-120.66897, 35.15219], [-120.66927, 35.15227], [-120.66936, 35.15233]]]} | Open Access 1 | 17587 | Margo Dodd Park | 21806 | 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.201 | Margo Dodd 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 |
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]);