units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,414 rows where AGNCY_LEV = 2 and DES_TP = 3 sorted by COUNTY
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AG_TYP, DES_TP
MNG_AGENCY >30
- San Diego, City of 209
- Los Angeles, City of 115
- San Francisco, City and County of 80
- San Luis Obispo, City of 24
- Glendale, City of 24
- Davis, City of 23
- Long Beach, City of 23
- Sacramento, City of 18
- San Jose, City of 17
- Vacaville, City of 17
- Santa Clarita, City of 17
- Oakland, City of 16
- Thousand Oaks, City of 16
- Fullerton, City of 15
- Santa Cruz, City of 14
- San Marcos, City of 14
- Tiburon, Town of 13
- Poway, City of 12
- San Bernardino, City of 12
- Carlsbad, City of 11
- Mission Viejo, City of 11
- Fresno, City of 10
- Oceanside, City of 10
- Riverside, City of 9
- Irvine, City of 9
- Roseville, City of 9
- Santa Barbara, City of 8
- South San Francisco, City of 8
- Escondido, City of 8
- Chico, City of 8
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
147 | 147 | 146 | {"type": "Polygon", "coordinates": [[[-120.67593, 35.28455], [-120.67267, 35.28527], [-120.67227, 35.28492], [-120.67159, 35.28308], [-120.67151, 35.28307], [-120.67145, 35.27945], [-120.67281, 35.27944], [-120.67281, 35.27961], [-120.67591, 35.28176], [-120.67593, 35.28455]]]} | Open Access 1 | 383 | San Luis Mountain Open Space | 24932 | 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 | 49.053 | San Luis Mtn. OS | 0 | Local Recreation Area 3 | 4 | |
278 | 278 | 277 | {"type": "Polygon", "coordinates": [[[-120.66515, 35.26662], [-120.66466, 35.26653], [-120.66436, 35.26666], [-120.66427, 35.26653], [-120.66393, 35.26612], [-120.66379, 35.266], [-120.66357, 35.26587], [-120.66337, 35.26579], [-120.66315, 35.26574], [-120.66292, 35.26572], [-120.66252, 35.26572], [-120.66262, 35.26536], [-120.66261, 35.26497], [-120.66004, 35.26496], [-120.66011, 35.26356], [-120.65886, 35.26356], [-120.65883, 35.26352], [-120.65904, 35.26352], [-120.65905, 35.26351], [-120.659, 35.26347], [-120.6588, 35.26341], [-120.65852, 35.26335], [-120.65797, 35.26314], [-120.65777, 35.26304], [-120.65767, 35.26291], [-120.6573, 35.26264], [-120.65721, 35.26255], [-120.65717, 35.2625], [-120.65683, 35.26235], [-120.65661, 35.26231], [-120.6564, 35.26215], [-120.65633, 35.26207], [-120.65617, 35.26197], [-120.65608, 35.26186], [-120.65599, 35.26184], [-120.65583, 35.26163], [-120.65493, 35.26108], [-120.6544, 35.25768], [-120.65583, 35.25766], [-120.65584, 35.2577], [-120.65524, 35.25788], [-120.65526, 35.25821], [-120.65719, 35.26012], [-120.65825, 35.26135], [-120.65927, 35.26221], [-120.66054, 35.2628], [-120.66113, 35.26331], [-120.66475, 35.2634], [-120.66476, 35.26499], [-120.66513, 35.265], [-120.66515, 35.26662]], [[-120.66016, 35.26352], [-120.66016, 35.2635], [-120.66011, 35.26351], [-120.66012, 35.26352], [-120.66016, 35.26352]]]} | Open Access 1 | 946 | South Hills Open Space | 25656 | 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 | 58.628 | South Hills OS | 0 | Local Recreation Area 3 | 4 | |
2886 | 2886 | 2885 | {"type": "Polygon", "coordinates": [[[-120.65576, 35.25766], [-120.65408, 35.25768], [-120.65407, 35.25753], [-120.65421, 35.25737], [-120.65447, 35.25723], [-120.65475, 35.2571], [-120.65516, 35.25694], [-120.65534, 35.25701], [-120.65529, 35.25714], [-120.65563, 35.25729], [-120.65576, 35.25766]]]} | Open Access 1 | 1000 | South St Water Tank / Open Space | 25679 | 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 | 2.019 | South St Water Tank / OS | 0 | Local Recreation Area 3 | 4 | |
3534 | 3534 | 3533 | {"type": "Polygon", "coordinates": [[[-120.60822, 35.11477], [-120.60789, 35.11477], [-120.60766, 35.11474], [-120.60738, 35.11468], [-120.60693, 35.11464], [-120.6007, 35.11463], [-120.60066, 35.1146], [-120.60065, 35.11457], [-120.60063, 35.1127], [-120.60796, 35.11271], [-120.60821, 35.11292], [-120.60822, 35.11477]]]} | Open Access 1 | 28101 | Soto Sports Complex | 33130 | 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 | 36.63 | Soto Sports Complex | 0 | Local Recreation Area 3 | 4 | |
5525 | 5525 | 5524 | {"type": "Polygon", "coordinates": [[[-120.64638, 35.29111], [-120.64605, 35.29112], [-120.64578, 35.2913], [-120.64578, 35.29163], [-120.64528, 35.29166], [-120.64483, 35.29192], [-120.64445, 35.29207], [-120.64409, 35.29225], [-120.64375, 35.29245], [-120.64345, 35.29265], [-120.64344, 35.29262], [-120.64305, 35.29277], [-120.64306, 35.29272], [-120.64346, 35.29252], [-120.64355, 35.29243], [-120.64361, 35.29245], [-120.6437, 35.29244], [-120.64375, 35.29241], [-120.6438, 35.29235], [-120.64407, 35.29219], [-120.64439, 35.29203], [-120.64488, 35.29183], [-120.645, 35.29176], [-120.64525, 35.29155], [-120.64562, 35.29112], [-120.64612, 35.29079], [-120.64638, 35.29111]]]} | Open Access 1 | 379 | San Luis Drive Open Space | 24931 | 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.278 | San Luis Drive OS | 0 | Local Recreation Area 3 | 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 | |
6334 | 6334 | 6333 | {"type": "MultiPolygon", "coordinates": [[[[-120.64648, 35.26403], [-120.6472, 35.26495], [-120.64806, 35.26558], [-120.65018, 35.26686], [-120.65005, 35.26688], [-120.65051, 35.26715], [-120.6505, 35.26724], [-120.65042, 35.26725], [-120.65016, 35.26742], [-120.65007, 35.26754], [-120.65021, 35.26759], [-120.65035, 35.26745], [-120.65045, 35.26738], [-120.65055, 35.26736], [-120.65064, 35.26737], [-120.65075, 35.26743], [-120.65084, 35.26751], [-120.65095, 35.26769], [-120.65107, 35.26796], [-120.65113, 35.26821], [-120.65121, 35.26863], [-120.65115, 35.26905], [-120.65112, 35.2692], [-120.6511, 35.26907], [-120.65069, 35.26907], [-120.65068, 35.26822], [-120.65061, 35.26821], [-120.65061, 35.26808], [-120.64979, 35.26807], [-120.64979, 35.26784], [-120.64983, 35.26767], [-120.6499, 35.26748], [-120.64949, 35.26732], [-120.64925, 35.26727], [-120.64799, 35.26586], [-120.64717, 35.26522], [-120.64705, 35.26501], [-120.64543, 35.26502], [-120.64631, 35.26418], [-120.6441, 35.26144], [-120.64438, 35.26143], [-120.64607, 35.26355], [-120.64648, 35.26403]]], [[[-120.6551, 35.27467], [-120.65496, 35.27451], [-120.65502, 35.27417], [-120.65502, 35.27394], [-120.655, 35.27378], [-120.65496, 35.27356], [-120.65486, 35.27327], [-120.65477, 35.2731], [-120.65245, 35.26974], [-120.65236, 35.26973], [-120.65236, 35.26961], [-120.65211, 35.26932], [-120.65193, 35.26903], [-120.65131, 35.26903], [-120.65137, 35.26862], [-120.65123, 35.2679], [-120.65103, 35.2675], [-120.6509, 35.26736], [-120.65104, 35.26744], [-120.65135, 35.26773], [-120.65214, 35.26877], [-120.65262, 35.26946], [-120.65269, 35.26961], [-120.65408, 35.27162], [-120.65489, 35.27288], [-120.65481, 35.27292], [-120.65499, 35.2733], [-120.65518, 35.27398], [-120.65519, 35.2742], [-120.65518, 35.27438], [-120.6551, 35.27467]]]]} | Open Access 1 | 1645 | Railroad Safety Trail | 28708 | 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 | 17.512 | Railroad Safety Trail | 1998 | Local Recreation Area 3 | 4 | |
8233 | 8233 | 8232 | {"type": "Polygon", "coordinates": [[[-120.64907, 35.25038], [-120.64905, 35.25181], [-120.64766, 35.25297], [-120.64745, 35.25312], [-120.64703, 35.25335], [-120.64593, 35.25381], [-120.64506, 35.25159], [-120.64478, 35.25108], [-120.64579, 35.25068], [-120.64582, 35.25067], [-120.64586, 35.2507], [-120.64593, 35.25081], [-120.64699, 35.25038], [-120.64907, 35.25038]]]} | Open Access 1 | 12564 | Damon-Garcia Sports Complex | 17901 | 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 | 23.938 | Damon-Garcia Sports Complex | 0 | Local Recreation Area 3 | 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 | |
9668 | 9668 | 9667 | {"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 | 16311 | 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 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1.045 | Future Railroad Area Bike Path | 0 | Local Recreation Area 3 | 4 | |
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 | |
9916 | 9916 | 9915 | {"type": "Polygon", "coordinates": [[[-120.64423, 35.26637], [-120.64385, 35.26695], [-120.64332, 35.26783], [-120.64217, 35.26752], [-120.64322, 35.26607], [-120.64423, 35.26637]]]} | Open Access 1 | 17059 | Johnson Playground | 20481 | 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 | 4.62 | Johnson Playground | 0 | Local Recreation Area 3 | 4 | |
10001 | 10001 | 10000 | {"type": "Polygon", "coordinates": [[[-120.69525, 35.26886], [-120.6937, 35.26989], [-120.68692, 35.2747], [-120.67655, 35.26563], [-120.67781, 35.26464], [-120.6796, 35.26336], [-120.67868, 35.26254], [-120.68042, 35.26128], [-120.68079, 35.26105], [-120.68124, 35.26082], [-120.68347, 35.25987], [-120.68631, 35.26287], [-120.68735, 35.26367], [-120.68737, 35.26373], [-120.68736, 35.26378], [-120.68716, 35.26395], [-120.68713, 35.26399], [-120.68712, 35.26406], [-120.68716, 35.26412], [-120.68726, 35.26416], [-120.68748, 35.26415], [-120.68777, 35.26417], [-120.68823, 35.26428], [-120.68855, 35.26442], [-120.69317, 35.26757], [-120.69328, 35.26763], [-120.69334, 35.26759], [-120.69525, 35.26886]]]} | Open Access 1 | 17201 | Laguna Lake Park/Open Space | 11381 | 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 | http://www.slocity.org/parksandrecreation/lagunapark.asp | San Luis Obispo 1 | 325.156 | Laguna Lake Park/OS | 0 | Local Recreation Area 3 | 4 |
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 | |
10494 | 10494 | 10493 | {"type": "Polygon", "coordinates": [[[-120.63498, 35.13975], [-120.63483, 35.13986], [-120.63297, 35.1412], [-120.63286, 35.13966], [-120.63285, 35.13965], [-120.63273, 35.13972], [-120.63268, 35.13915], [-120.63297, 35.13913], [-120.63473, 35.13962], [-120.63498, 35.13975]]]} | Open Access 1 | 18600 | Pismo Beach Sports Park | 23746 | 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 | 5.906 | Pismo Beach Sports Park | 0 | Local Recreation Area 3 | 4 | |
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 | |
12383 | 12383 | 12382 | {"type": "Polygon", "coordinates": [[[-120.61031, 35.12154], [-120.61029, 35.12194], [-120.60969, 35.12191], [-120.60971, 35.12151], [-120.61031, 35.12154]]]} | Open Access 1 | 26519 | South County Skate Park | 25645 | 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.608 | South County Skate Park | 0 | Local Recreation Area 3 | 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 | |
14244 | 14244 | 14243 | {"type": "Polygon", "coordinates": [[[-120.68941, 35.62133], [-120.68841, 35.62138], [-120.68834, 35.62056], [-120.68933, 35.6205], [-120.68941, 35.62133]]]} | Open Access 1 | 44139 | Robbins Field | 24479 | 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 | 2.046 | Robbins Field | 0 | Local Recreation Area 3 | 4 | |
15614 | 15614 | 15613 | {"type": "Polygon", "coordinates": [[[-120.69362, 35.30163], [-120.69354, 35.30866], [-120.68482, 35.30867], [-120.68259, 35.30864], [-120.68091, 35.3078], [-120.68035, 35.30734], [-120.68035, 35.30591], [-120.68242, 35.30688], [-120.68532, 35.30728], [-120.68779, 35.30649], [-120.68779, 35.30648], [-120.68721, 35.30482], [-120.68701, 35.30425], [-120.68698, 35.3042], [-120.68686, 35.30423], [-120.68632, 35.30421], [-120.68601, 35.30447], [-120.68549, 35.30454], [-120.68542, 35.30431], [-120.68529, 35.30408], [-120.68576, 35.30389], [-120.68652, 35.30346], [-120.68829, 35.30193], [-120.68831, 35.30221], [-120.68841, 35.30246], [-120.68869, 35.30255], [-120.68916, 35.30294], [-120.68933, 35.30303], [-120.69003, 35.30297], [-120.69027, 35.30265], [-120.69057, 35.30236], [-120.69055, 35.30214], [-120.6902, 35.30167], [-120.68969, 35.30163], [-120.68924, 35.30163], [-120.68922, 35.3016], [-120.68922, 35.30149], [-120.68911, 35.30138], [-120.68915, 35.30134], [-120.68928, 35.30134], [-120.68929, 35.30159], [-120.69362, 35.30163]]]} | Open Access 1 | 15820 | Ferrini Ranch Open Space | 18886 | 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 | 134.048 | Ferrini Ranch OS | 0 | Local Recreation Area 3 | 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]);