units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,376 rows where DES_TP = 2 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 314
- San Diego, City of 278
- Sacramento, City of 192
- San Jose, City of 175
- San Francisco, City and County of 118
- Long Beach, City of 101
- Oakland, City of 99
- Los Angeles, County of 95
- Consumnes Community Services District 92
- Fresno, City of 83
- East Bay Regional Park District 76
- Modesto, City of 76
- Huntington Beach, City of 74
- Hayward Area Recreation and Park District 74
- Tracy, City of 69
- Santa Rosa, City of 68
- San Diego, County of 68
- Mountains Recreation and Conservation Authority 67
- Stockton, City of 67
- Roseville, City of 67
- Brentwood, City of 63
- Chula Vista, City of 60
- Irvine, City of 59
- Valley-Wide Recreation and Park District 57
- Bakersfield, City of 56
- Clovis, City of 54
- Manteca, City of 54
- Newport Beach, City of 50
- Anaheim, City of 49
- Riverside, City of 49
- …
MNG_AG_TYP 16
- City Agency 7,474
- Recreation/Parks District 704
- County Agency 648
- Community Services District 173
- County Agency - Parks 152
- Open Space District 75
- Water District 38
- School District 32
- Port/Harbor District 21
- Flood District 17
- Special District - Other 9
- County Agency - Other 7
- Cemetery District 3
- Irrigation District 1
- Sanitation District 1
- Joint Powers Authority 1
LAYER 10 ✖
ACCESS_TYP 4
- Open Access 9,064
- Restricted Access 210
- No Public Access 77
- Unknown Access 5
DES_TP 1
- Local Park · 9,356 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5790 | 5790 | 5789 | {"type": "MultiPolygon", "coordinates": [[[[-117.05865, 32.73857], [-117.05803, 32.73858], [-117.05803, 32.73858], [-117.05803, 32.73856], [-117.05825, 32.73832], [-117.05837, 32.73835], [-117.05865, 32.73857]]], [[[-117.07608, 32.7349], [-117.07553, 32.73603], [-117.07537, 32.7361], [-117.07502, 32.7362], [-117.07475, 32.73625], [-117.07425, 32.73628], [-117.07389, 32.73626], [-117.07368, 32.73623], [-117.07342, 32.73618], [-117.07295, 32.73604], [-117.07392, 32.73416], [-117.07397, 32.73212], [-117.07206, 32.7321], [-117.07202, 32.73303], [-117.06932, 32.733], [-117.06852, 32.73484], [-117.06333, 32.73515], [-117.06296, 32.73519], [-117.06243, 32.73529], [-117.06193, 32.73541], [-117.06145, 32.73556], [-117.06106, 32.73572], [-117.06065, 32.73591], [-117.0602, 32.73616], [-117.05974, 32.73646], [-117.05946, 32.73668], [-117.05898, 32.73711], [-117.05826, 32.73785], [-117.05827, 32.73787], [-117.05822, 32.7379], [-117.05815, 32.73791], [-117.05808, 32.7379], [-117.05804, 32.73788], [-117.05806, 32.73498], [-117.05829, 32.73483], [-117.05962, 32.7333], [-117.06222, 32.73142], [-117.06439, 32.73013], [-117.06626, 32.72932], [-117.06794, 32.72884], [-117.06794, 32.72935], [-117.07536, 32.72946], [-117.07535, 32.73054], [-117.07436, 32.73039], [-117.07431, 32.7322], [-117.07528, 32.73223], [-117.07525, 32.73371], [-117.0751, 32.7337], [-117.0749, 32.73396], [-117.07524, 32.73479], [-117.07525, 32.73489], [-117.07608, 32.7349]]], [[[-117.07739, 32.73587], [-117.07737, 32.73674], [-117.07678, 32.73675], [-117.07676, 32.73801], [-117.07523, 32.73805], [-117.07525, 32.7402], [-117.07485, 32.7404], [-117.07138, 32.74035], [-117.07141, 32.73924], [-117.07138, 32.73918], [-117.07133, 32.73912], [-117.07133, 32.73895], [-117.06827, 32.7393], [-117.06726, 32.73928], [-117.06724, 32.74028], [-117.06672, 32.74028], [-117.06671, 32.73846], [-117.05891, 32.73857], [-117.05887, 32.73852], [-117.05867, 32.73833], [-117.05842, 32.73814], [-117.05854, 32.73799], [-117.05857, 32.738], [-117.05908, 32.73745], [-117.05943, 32.7371], [-117.05966, 32.7369], [-117.05991, 32.73671], [-117.06041, 32.73638], [-117.0608, 32.73616], [-117.06136, 32.73591], [-117.06196, 32.7357], [-117.0625, 32.73556], [-117.06343, 32.73542], [-117.06534, 32.73529], [-117.06849, 32.73512], [-117.06912, 32.73512], [-117.06941, 32.73515], [-117.06966, 32.73521], [-117.07013, 32.73534], [-117.07282, 32.73631], [-117.07351, 32.73649], [-117.07402, 32.73655], [-117.07434, 32.73656], [-117.07465, 32.73654], [-117.07493, 32.7365], [-117.07521, 32.73644], [-117.07551, 32.73635], [-117.0763, 32.73602], [-117.07656, 32.73594], [-117.07693, 32.73587], [-117.07739, 32.73587]]]]} | Open Access 1 | 39 | Chollas Lake Community Park | 30046 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 341.762 | Chollas Lake Community Park | 0 | Local Park 2 | 4 | |
14 | 14 | 13 | {"type": "Polygon", "coordinates": [[[-122.03122, 36.97381], [-122.03122, 36.97381], [-122.03111, 36.97409], [-122.03105, 36.97384], [-122.03122, 36.97381]]]} | Open Access 1 | 42 | Rincon Park | 24369 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.055 | Rincon Park | 0 | Local Park 2 | 4 | |
15 | 15 | 14 | {"type": "Polygon", "coordinates": [[[-120.87737, 37.76176], [-120.87616, 37.76176], [-120.87611, 37.76172], [-120.8761, 37.76055], [-120.87615, 37.76051], [-120.87682, 37.76051], [-120.87688, 37.76054], [-120.87736, 37.76051], [-120.87737, 37.76176]]]} | Open Access 1 | 43 | William A. Fish Veterans Memorial Park | 27537 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 3.803 | William A. Fish Veterans Memorial Park | 0 | Local Park 2 | 4 | |
5792 | 5792 | 5791 | {"type": "Polygon", "coordinates": [[[-117.94385, 33.93367], [-117.94187, 33.93367], [-117.94187, 33.9329], [-117.94297, 33.93289], [-117.94343, 33.93281], [-117.94383, 33.93282], [-117.94385, 33.93284], [-117.94385, 33.93367]]]} | Open Access 1 | 44 | El Centro Park | 18489 | 1155 | La Habra, City of 203 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | Orange 3 | 4.032 | El Centro Park | 0 | Local Park 2 | 4 | |
5793 | 5793 | 5792 | {"type": "MultiPolygon", "coordinates": [[[[-117.19381, 32.75393], [-117.19314, 32.75468], [-117.19139, 32.75359], [-117.19142, 32.75354], [-117.19096, 32.75325], [-117.19099, 32.75319], [-117.1896, 32.75233], [-117.18989, 32.752], [-117.19175, 32.75315], [-117.19204, 32.75283], [-117.19381, 32.75393]]], [[[-117.19427, 32.7534], [-117.19392, 32.7538], [-117.19353, 32.75356], [-117.19387, 32.75316], [-117.19427, 32.7534]]]]} | Open Access 1 | 45 | Heritage Park | 19842 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Heritage.html | San Diego 4 | 8.454 | Heritage Park | 0 | Local Park 2 | 4 |
13 | 13 | 12 | {"type": "Polygon", "coordinates": [[[-120.84861, 37.76492], [-120.8483, 37.76505], [-120.84814, 37.76482], [-120.84845, 37.76468], [-120.84861, 37.76492]]]} | Open Access 1 | 49 | William Meyer Park | 27553 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 0.233 | William Meyer Park | 0 | Local Park 2 | 4 | |
5794 | 5794 | 5793 | {"type": "Polygon", "coordinates": [[[-117.69121, 33.59025], [-117.6909, 33.59048], [-117.69087, 33.59047], [-117.6908, 33.59046], [-117.6907, 33.59049], [-117.69068, 33.59055], [-117.69041, 33.59076], [-117.69052, 33.59083], [-117.69026, 33.59105], [-117.68995, 33.59081], [-117.68985, 33.59067], [-117.6898, 33.59062], [-117.68968, 33.5906], [-117.68957, 33.59064], [-117.68951, 33.59069], [-117.68879, 33.58992], [-117.69092, 33.58993], [-117.69121, 33.59025]]]} | Open Access 1 | 50 | El Conejo Park | 18493 | 1165 | Laguna Hills, City of 230 | City 2 | City Agency 2 | http://www.ci.laguna-hills.ca.us/ | City 2 | 1165 | Laguna Hills, City of 226 | City 2 | City Agency 2 | Orange 3 | 3.773 | El Conejo Park | 0 | Local Park 2 | 4 | |
5795 | 5795 | 5794 | {"type": "Polygon", "coordinates": [[[-117.13499, 32.75399], [-117.13391, 32.75399], [-117.13392, 32.75231], [-117.13395, 32.75221], [-117.13397, 32.7522], [-117.13398, 32.75045], [-117.13451, 32.75045], [-117.13451, 32.75112], [-117.13498, 32.75112], [-117.13499, 32.75399]]]} | Open Access 1 | 51 | North Park Community Park | 22844 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 8.653 | North Park Community Park | 0 | Local Park 2 | 4 | |
5797 | 5797 | 5796 | {"type": "Polygon", "coordinates": [[[-121.1509, 37.46277], [-121.1508, 37.46292], [-121.14988, 37.46396], [-121.14979, 37.46412], [-121.14974, 37.46424], [-121.14971, 37.46426], [-121.14957, 37.46426], [-121.14958, 37.46277], [-121.1509, 37.46277]]]} | Open Access 1 | 55 | Amaryllis Park | 15440 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 2.566 | Amaryllis Park | 0 | Local Park 2 | 4 | |
17 | 17 | 16 | {"type": "Polygon", "coordinates": [[[-118.12258, 34.69275], [-118.12251, 34.69275], [-118.1225, 34.69267], [-118.1217, 34.69267], [-118.12164, 34.69261], [-118.12164, 34.69054], [-118.12169, 34.69048], [-118.12257, 34.69049], [-118.12258, 34.69275]]]} | Open Access 1 | 56 | El Dorado Park | 18505 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | Los Angeles 6 | 5.137 | El Dorado Park | 0 | Local Park 2 | 4 | |
18 | 18 | 17 | {"type": "Polygon", "coordinates": [[[-118.95325, 34.18233], [-118.94954, 34.18265], [-118.94921, 34.18001], [-118.94982, 34.17958], [-118.95014, 34.17942], [-118.95045, 34.17932], [-118.95086, 34.17926], [-118.95165, 34.17922], [-118.9523, 34.17926], [-118.95325, 34.18233]]]} | Open Access 1 | 58 | Borchard Park | 16277 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 27.263 | Borchard Park | 0 | Local Park 2 | 4 | |
22 | 22 | 21 | {"type": "Polygon", "coordinates": [[[-119.79976, 36.71887], [-119.79974, 36.71947], [-119.79972, 36.71963], [-119.7977, 36.7196], [-119.79769, 36.71907], [-119.79807, 36.71906], [-119.79808, 36.71894], [-119.7991, 36.71892], [-119.79911, 36.71887], [-119.79976, 36.71887]]]} | Open Access 1 | 60 | Bigby VIlla Park | 16097 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 3.426 | Bigby VIlla Park | 0 | Local Park 2 | 4 | |
24 | 24 | 23 | {"type": "Polygon", "coordinates": [[[-118.15573, 34.02499], [-118.1555, 34.02576], [-118.15546, 34.0258], [-118.15538, 34.02582], [-118.15475, 34.02568], [-118.15469, 34.02564], [-118.15468, 34.02558], [-118.1549, 34.02485], [-118.15494, 34.02481], [-118.15501, 34.02479], [-118.15565, 34.02492], [-118.1557, 34.02495], [-118.15573, 34.02499]]]} | Open Access 1 | 62 | Atlantic Avenue Park | 15674 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 1.951 | Atlantic Avenue Park | 0 | Local Park 2 | 4 | |
16 | 16 | 15 | {"type": "Polygon", "coordinates": [[[-121.15169, 37.47476], [-121.15143, 37.47478], [-121.15101, 37.47485], [-121.15025, 37.47485], [-121.15026, 37.4736], [-121.15131, 37.4736], [-121.15156, 37.47359], [-121.15169, 37.47476]]]} | Open Access 1 | 66 | Ambercot Park | 15443 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 4.088 | Ambercot Park | 0 | Local Park 2 | 4 | |
5800 | 5800 | 5799 | {"type": "Polygon", "coordinates": [[[-122.2403, 37.47151], [-122.24004, 37.47181], [-122.24028, 37.47209], [-122.23817, 37.47371], [-122.23757, 37.47321], [-122.23697, 37.47352], [-122.23666, 37.47333], [-122.23611, 37.47364], [-122.23547, 37.47309], [-122.23574, 37.47276], [-122.23467, 37.47184], [-122.23503, 37.47158], [-122.23546, 37.47184], [-122.23776, 37.47011], [-122.23849, 37.47067], [-122.23953, 37.46994], [-122.23989, 37.47018], [-122.24025, 37.47086], [-122.24002, 37.47123], [-122.2403, 37.47151]]]} | Open Access 1 | 69 | Red Morton Community Park | 24226 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 30.176 | Red Morton Community Park | 1948 | Local Park 2 | 4 | |
5801 | 5801 | 5800 | {"type": "Polygon", "coordinates": [[[-120.44863, 34.66551], [-120.44853, 34.6679], [-120.44856, 34.67117], [-120.44719, 34.67074], [-120.44611, 34.67003], [-120.44498, 34.66914], [-120.4443, 34.66829], [-120.44427, 34.66788], [-120.44428, 34.66667], [-120.44863, 34.66551]]]} | Open Access 1 | 70 | Riverbend Park | 30314 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/river.htm | Santa Barbara 7 | 42.802 | Riverbend Park | 0 | Local Park 2 | 4 |
5802 | 5802 | 5801 | {"type": "Polygon", "coordinates": [[[-121.15135, 37.46576], [-121.15132, 37.46714], [-121.15127, 37.46718], [-121.15088, 37.46718], [-121.15078, 37.46715], [-121.15072, 37.46715], [-121.15063, 37.46719], [-121.1506, 37.46725], [-121.15028, 37.46725], [-121.15029, 37.46575], [-121.15059, 37.46575], [-121.15063, 37.46573], [-121.15072, 37.46575], [-121.15088, 37.46571], [-121.1513, 37.46572], [-121.15135, 37.46576]]]} | Open Access 1 | 71 | Aprigold Park | 15545 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 3.755 | Aprigold Park | 0 | Local Park 2 | 4 | |
5803 | 5803 | 5802 | {"type": "Polygon", "coordinates": [[[-118.66808, 34.19517], [-118.66804, 34.19881], [-118.66712, 34.1988], [-118.66711, 34.1986], [-118.66187, 34.19858], [-118.66196, 34.19793], [-118.6607, 34.19748], [-118.66049, 34.1971], [-118.66026, 34.19647], [-118.65986, 34.19603], [-118.65932, 34.19588], [-118.65877, 34.19529], [-118.65896, 34.19514], [-118.66089, 34.19511], [-118.66808, 34.19517]]]} | Open Access 1 | 72 | El Escorpion Park | 29037 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 66.947 | El Escorpion Park | 0 | Local Park 2 | 4 | |
16298 | 16298 | 16297 | {"type": "MultiPolygon", "coordinates": [[[[-122.16129, 37.80386], [-122.16095, 37.80388], [-122.1608, 37.80386], [-122.1606, 37.80378], [-122.16046, 37.80367], [-122.16129, 37.80367], [-122.16129, 37.80386]]], [[[-122.16181, 37.80392], [-122.16157, 37.80388], [-122.16156, 37.8032], [-122.1618, 37.80325], [-122.16181, 37.80392]]], [[[-122.17053, 37.80528], [-122.17052, 37.80358], [-122.16914, 37.80314], [-122.1692, 37.80274], [-122.16914, 37.80193], [-122.1688, 37.8016], [-122.16918, 37.8011], [-122.16905, 37.80099], [-122.16855, 37.80108], [-122.16841, 37.80094], [-122.16853, 37.80068], [-122.1686, 37.80041], [-122.16853, 37.80008], [-122.16839, 37.80007], [-122.16839, 37.79913], [-122.17047, 37.80007], [-122.17052, 37.80008], [-122.17051, 37.80013], [-122.17, 37.80113], [-122.16996, 37.80126], [-122.16997, 37.80145], [-122.1701, 37.802], [-122.17023, 37.80229], [-122.17051, 37.80267], [-122.17052, 37.80267], [-122.17068, 37.80286], [-122.17094, 37.80312], [-122.17101, 37.80323], [-122.17104, 37.80333], [-122.17115, 37.80388], [-122.17131, 37.80426], [-122.17132, 37.80438], [-122.17126, 37.80466], [-122.17121, 37.80476], [-122.17114, 37.80486], [-122.17094, 37.80502], [-122.17053, 37.80528]]], [[[-122.18156, 37.81948], [-122.18117, 37.81939], [-122.17714, 37.81626], [-122.17217, 37.81531], [-122.16651, 37.81295], [-122.15684, 37.81759], [-122.15285, 37.81546], [-122.1478, 37.81333], [-122.14067, 37.80489], [-122.13874, 37.80475], [-122.13869, 37.80461], [-122.13844, 37.80432], [-122.13838, 37.80424], [-122.13824, 37.80392], [-122.1381, 37.8037], [-122.13796, 37.8036], [-122.13772, 37.80345], [-122.13763, 37.80336], [-122.13757, 37.80312], [-122.13752, 37.80302], [-122.13745, 37.80292], [-122.13733, 37.80281], [-122.13696, 37.80266], [-122.13686, 37.80259], [-122.1368, 37.80246], [-122.13676, 37.80225], [-122.13666, 37.80208], [-122.13658, 37.80198], [-122.13645, 37.80186], [-122.13613, 37.80164], [-122.13608, 37.80159], [-122.136, 37.80145], [-122.13598, 37.80133], [-122.13597, 37.80113], [-122.13592, 37.80059], [-122.13574, 37.80012], [-122.13565, 37.79953], [-122.13559, 37.79932], [-122.13544, 37.79904], [-122.13543, 37.79896], [-122.13544, 37.79887], [-122.13547, 37.79879], [-122.13555, 37.79866], [-122.13558, 37.79858], [-122.13558, 37.79849], [-122.13553, 37.79839], [-122.13547, 37.79832], [-122.13537, 37.79827], [-122.13512, 37.79819], [-122.13426, 37.79803], [-122.13398, 37.79795], [-122.13351, 37.79772], [-122.13313, 37.79747], [-122.13274, 37.79726], [-122.13247, 37.79704], [-122.13227, 37.79692], [-122.1322, 37.79685], [-122.132, 37.79665], [-122.13178, 37.79635], [-122.13151, 37.79612], [-122.13143, 37.796], [-122.13137, 37.79586], [-122.13126, 37.79553], [-122.13124, 37.79546], [-122.13124, 37.7954], [-122.13126, 37.79536], [-122.13132, 37.79535], [-122.13144, 37.79541], [-122.13199, 37.7958], [-122.13211, 37.79586], [-122.13232, 37.79589], [-122.1326, 37.7959], [-122.13269, 37.79595], [-122.13293, 37.7964], [-122.13317, 37.79652], [-122.13325, 37.79659], [-122.1334, 37.79678], [-122.13355, 37.79692], [-122.13388, 37.79718], [-122.13397, 37.79724], [-122.13419, 37.79734], [-122.13429, 37.79734], [-122.13448, 37.79732], [-122.13463, 37.79727], [-122.1347, 37.79727], [-122.1348, 37.79729], [-122.13534, 37.79773], [-122.13556, 37.7978], [-122.13588, 37.79783], [-122.13651, 37.79781], [-122.13664, 37.79782], [-122.13672, 37.79786], [-122.13675, 37.79789], [-122.13682, 37.79828], [-122.1369, 37.79845], [-122.13704, 37.79857], [-122.13718, 37.79861], [-122.13731, 37.79858], [-122.13744, 37.79852], [-122.13768, 37.79829], [-122.138, 37.79788], [-122.13816, 37.79765], [-122.13828, 37.79753], [-122.13832, 37.79751], [-122.13837, 37.79753], [-122.13862, 37.79779], [-122.13879, 37.79806], [-122.13885, 37.79814], [-122.13903, 37.79829], [-122.13939, 37.79835], [-122.1396, 37.79836], [-122.13991, 37.79834], [-122.14037, 37.79835], [-122.14069, 37.79837], [-122.1408, 37.79849], [-122.14098, 37.79859], [-122.14116, 37.79864], [-122.14173, 37.79866], [-122.14185, 37.79872], [-122.14201, 37.79884], [-122.14253, 37.79934], [-122.14319, 37.79981], [-122.1432, 37.79996], [-122.14342, 37.79997], [-122.14378, 37.80024], [-122.144, 37.80034], [-122.14417, 37.80037], [-122.14516, 37.80038], [-122.14533, 37.80038], [-122.14565, 37.80033], [-122.14607, 37.80024], [-122.14621, 37.80018], [-122.14634, 37.80007], [-122.1465, 37.80035], [-122.14661, 37.80027], [-122.14653, 37.79998], [-122.14692, 37.79994], [-122.1469, 37.80019], [-122.14705, 37.80023], [-122.14709, 37.79994], [-122.1479, 37.79994], [-122.14821, 37.79988], [-122.14839, 37.79978], [-122.14873, 37.79952], [-122.14927, 37.79928], [-122.14937, 37.7992], [-122.14967, 37.7988], [-122.14982, 37.79863], [-122.15008, 37.79848], [-122.15044, 37.79834], [-122.15058, 37.79831], [-122.15082, 37.79833], [-122.15158, 37.7985], [-122.15223, 37.79847], [-122.15241, 37.79849], [-122.1526, 37.79853], [-122.15404, 37.79908], [-122.15431, 37.79919], [-122.1546, 37.79934], [-122.1552, 37.7999], [-122.15603, 37.80049], [-122.15634, 37.80085], [-122.15659, 37.80105], [-122.15682, 37.80126], [-122.15712, 37.80162], [-122.15753, 37.80201], [-122.15809, 37.8024], [-122.15835, 37.80255], [-122.15937, 37.8031], [-122.15992, 37.80342], [-122.16014, 37.8036], [-122.16034, 37.80382], [-122.16049, 37.80393], [-122.16068, 37.80401], [-122.16085, 37.80404], [-122.16144, 37.80403], [-122.16187, 37.80411], [-122.16196, 37.80417], [-122.16212, 37.80435], [-122.16234, 37.80451], [-122.16291, 37.80483], [-122.16352, 37.80501], [-122.16397, 37.80541], [-122.16404, 37.80546], [-122.16445, 37.80562], [-122.16496, 37.806], [-122.16508, 37.80608], [-122.16523, 37.80612], [-122.16557, 37.80617], [-122.16653, 37.80651], [-122.16704, 37.80658], [-122.16691, 37.807], [-122.16693, 37.80722], [-122.16887, 37.8072], [-122.16886, 37.8061], [-122.16912, 37.80603], [-122.16914, 37.8072], [-122.17053, 37.8072], [-122.17053, 37.80548], [-122.17114, 37.80511], [-122.17132, 37.80494], [-122.17139, 37.80484], [-122.17146, 37.8047], [-122.17152, 37.80436], [-122.1715, 37.80421], [-122.17134, 37.8038], [-122.17126, 37.80333], [-122.17121, 37.80319], [-122.17112, 37.80306], [-122.17083, 37.80276], [-122.17052, 37.80235], [-122.17052, 37.80149], [-122.17087, 37.80148], [-122.17149, 37.80054], [-122.17304, 37.80126], [-122.17799, 37.8037], [-122.17917, 37.80497], [-122.17913, 37.80502], [-122.17898, 37.80506], [-122.17883, 37.80513], [-122.17865, 37.80528], [-122.17856, 37.8054], [-122.17851, 37.80554], [-122.1785, 37.80568], [-122.17851, 37.80577], [-122.17777, 37.80667], [-122.17669, 37.80713], [-122.1765, 37.8071], [-122.17624, 37.80711], [-122.17599, 37.80718], [-122.17579, 37.80731], [-122.17565, 37.80748], [-122.1756, 37.80762], [-122.17558, 37.80775], [-122.17561, 37.80791], [-122.17445, 37.8098], [-122.17377, 37.80952], [-122.17322, 37.81037], [-122.17433, 37.81083], [-122.17548, 37.81459], [-122.1784, 37.81671], [-122.18035, 37.81815], [-122.1812, 37.81931], [-122.18156, 37.81948]]], [[[-122.18677, 37.82369], [-122.18636, 37.82361], [-122.18645, 37.82336], [-122.18667, 37.82341], [-122.18671, 37.82343], [-122.18674, 37.82362], [-122.18677, 37.82369]]], [[[-122.18668, 37.83046], [-122.18644, 37.83068], [-122.18616, 37.83084], [-122.18603, 37.83093], [-122.18645, 37.83026], [-122.18668, 37.83046]]]]} | Open Access 1 | 75 | Redwood Regional Park | 3307 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/redwood | Alameda 17 | 1114.113 | Redwood RP | 1939 | Local Park 2 | 4 |
20 | 20 | 19 | {"type": "Polygon", "coordinates": [[[-121.7511, 36.90667], [-121.74954, 36.9078], [-121.74933, 36.90761], [-121.75087, 36.90647], [-121.7511, 36.90667]]]} | Open Access 1 | 76 | River Park | 24419 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 1.349 | River 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]);