units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 4,629
- State Agency 706
- Recreation/Parks District 704
- County Agency 603
- Federal Agency 283
- Non Profit - Land Trust 253
- Open Space District 188
- Community Services District 150
- County Agency - Parks 138
- Water District 130
- Home Owners Association 119
- Non Profit - Conservation 90
- Flood District 54
- School District 29
- Irrigation District 26
- Non Profit - Other 21
- Cemetery District 13
- County Agency - Other 12
- Special District - Other 11
- Port/Harbor District 10
- Commercial 8
- Joint Powers Authority 7
- Sanitation District 5
- Other 5
- Transportation Agency 5
- Conservation District 4
- Non Profit - Education 3
- Mitigation Bank 2
- Metropolitan Planning Organization 1
- Home Owners Associatin 1
- …
MNG_AGENCY >30
- California Department of Parks and Recreation 274
- California Department of Fish and Wildlife 268
- San Diego, City of 207
- Los Angeles, City of 157
- Sacramento, City of 145
- Mountains Recreation and Conservation Authority 127
- East Bay Regional Park District 127
- Ventura, City of 113
- Roseville, City of 97
- Consumnes Community Services District 86
- San Jose, City of 85
- Los Angeles, County of 75
- California State Lands Commission 66
- United States Fish and Wildlife Service 65
- United States Bureau of Land Management 64
- San Francisco, City and County of 63
- United States Forest Service 61
- Long Beach, City of 61
- Davis, City of 56
- Stockton, City of 56
- Orange, County of 54
- Hayward Area Recreation and Park District 51
- Santa Barbara, County of 49
- Modesto, City of 48
- Irvine, City of 47
- Poway, City of 46
- Tracy, City of 46
- Manteca, City of 45
- Butte, County of 45
- Rocklin, City of 44
- …
DES_TP >30
- Local Park 3,940
- Local Recreation Area 1,145
- Local Other or Unknown 720
- Private Conservation 299
- Local Conservation Area 266
- State Conservation Area 254
- State Park 158
- Private Recreation or Education 148
- State Resource Management Area 94
- State Recreation Area 88
- National Wildlife Refuge 59
- National Forest 56
- State Historic or Cultural Area 50
- National Public Lands 41
- Recreation Management Area 32
- Local Historic or Cultural Area 29
- National Monument or Landmark 24
- National Recreation Area 19
- State Other or Unknown 19
- National Park 14
- Local Resource Management Area 13
- Federal Other or Unknown 13
- Conservation Area 9
- Private Agricultural 9
- Private Other or Unknown 9
- Resource Management Area 7
- Historic or Cultural Area 4
- Area of Critical Environmental Concern 4
- Wilderness Area 2
- State Wilderness 1
- …
ACCESS_TYP 4
- Open Access 6,867
- Restricted Access 694
- No Public Access 468
- Unknown Access 182
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8858 | 8858 | 8857 | {"type": "Polygon", "coordinates": [[[-120.70034, 35.19238], [-120.70034, 35.19247], [-120.69736, 35.19188], [-120.69769, 35.19026], [-120.6994, 35.19064], [-120.69895, 35.19212], [-120.70034, 35.19238]]]} | No Public Access 3 | 14483 | TNC | 26376 | 3032 | Land Conservancy of San Luis Obispo County 506 | Non Profit 6 | Non Profit - Land Trust 10 | http://lcslo.org/ | Non Governmental Organization 10 | 3032 | Land Conservancy of San Luis Obispo County 498 | Non Profit 6 | Non Profit - Land Trust 10 | San Luis Obispo 1 | 7.119 | TNC | 0 | Private Conservation 16 | 2 | |
8859 | 8859 | 8858 | {"type": "Polygon", "coordinates": [[[-122.31425, 38.29491], [-122.31317, 38.29529], [-122.31275, 38.29453], [-122.31383, 38.29416], [-122.31425, 38.29491]]]} | Open Access 1 | 14485 | Laurel Park | 21104 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 2.342 | Laurel Park | 1977 | Local Park 2 | 4 | |
8860 | 8860 | 8859 | {"type": "Polygon", "coordinates": [[[-122.35256, 38.30267], [-122.35256, 38.30309], [-122.35243, 38.30311], [-122.35241, 38.30324], [-122.352, 38.30336], [-122.35131, 38.30326], [-122.35116, 38.30326], [-122.35036, 38.30355], [-122.3502, 38.30354], [-122.35002, 38.30343], [-122.34981, 38.30363], [-122.34967, 38.3037], [-122.34938, 38.30378], [-122.34928, 38.30375], [-122.34926, 38.3038], [-122.34877, 38.30371], [-122.34864, 38.30365], [-122.34856, 38.30368], [-122.34808, 38.30347], [-122.34813, 38.30339], [-122.34825, 38.30346], [-122.34842, 38.30351], [-122.34861, 38.30356], [-122.34899, 38.30361], [-122.34922, 38.30359], [-122.34936, 38.30355], [-122.34951, 38.30348], [-122.34967, 38.30338], [-122.34959, 38.30328], [-122.35044, 38.30295], [-122.35022, 38.3025], [-122.35129, 38.30192], [-122.35075, 38.3014], [-122.34988, 38.30078], [-122.34892, 38.30023], [-122.34864, 38.30025], [-122.34876, 38.30005], [-122.35003, 38.29971], [-122.35073, 38.29969], [-122.35189, 38.29978], [-122.35178, 38.30006], [-122.35057, 38.3005], [-122.35256, 38.30267]]]} | Open Access 1 | 14486 | Timber Hill Park | 26368 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 14.691 | Timber Hill Park | 1977 | Local Park 2 | 4 | |
8861 | 8861 | 8860 | {"type": "Polygon", "coordinates": [[[-122.04994, 37.23524], [-122.04538, 37.23524], [-122.04537, 37.23525], [-122.04557, 37.2357], [-122.04559, 37.23578], [-122.04558, 37.23587], [-122.04547, 37.23582], [-122.04516, 37.23587], [-122.04515, 37.23524], [-122.04233, 37.23524], [-122.04202, 37.2369], [-122.04223, 37.23745], [-122.04266, 37.23797], [-122.04254, 37.23814], [-122.04245, 37.23841], [-122.04243, 37.23856], [-122.04243, 37.23891], [-122.04239, 37.23913], [-122.04215, 37.23769], [-122.04046, 37.23696], [-122.04038, 37.23526], [-122.03129, 37.23551], [-122.03122, 37.23158], [-122.03602, 37.23153], [-122.03603, 37.23165], [-122.03666, 37.23183], [-122.03691, 37.23186], [-122.03774, 37.2316], [-122.03785, 37.23163], [-122.03801, 37.23163], [-122.03811, 37.23166], [-122.03856, 37.23201], [-122.0387, 37.23208], [-122.03888, 37.23208], [-122.03936, 37.23196], [-122.03951, 37.23194], [-122.03969, 37.23195], [-122.04003, 37.23202], [-122.04012, 37.23207], [-122.04019, 37.23215], [-122.04019, 37.23254], [-122.04023, 37.23265], [-122.04032, 37.23275], [-122.04046, 37.23283], [-122.04051, 37.23288], [-122.04053, 37.23294], [-122.04054, 37.2331], [-122.0406, 37.23321], [-122.0407, 37.2333], [-122.04083, 37.23335], [-122.04097, 37.23337], [-122.04109, 37.23336], [-122.04146, 37.23324], [-122.04159, 37.23321], [-122.04173, 37.23322], [-122.04198, 37.23326], [-122.04221, 37.23328], [-122.04259, 37.23325], [-122.04294, 37.23327], [-122.04408, 37.23337], [-122.04435, 37.23344], [-122.04455, 37.23355], [-122.0447, 37.23365], [-122.04482, 37.23378], [-122.04495, 37.23401], [-122.04499, 37.23414], [-122.04518, 37.23523], [-122.04537, 37.23524], [-122.04535, 37.23497], [-122.04519, 37.23412], [-122.04513, 37.23391], [-122.04504, 37.23375], [-122.04489, 37.23358], [-122.0447, 37.23343], [-122.04452, 37.23333], [-122.04433, 37.23326], [-122.04411, 37.23321], [-122.04296, 37.2331], [-122.04258, 37.23309], [-122.0422, 37.23312], [-122.04203, 37.2331], [-122.04174, 37.23305], [-122.0416, 37.23305], [-122.04138, 37.23308], [-122.04108, 37.23319], [-122.04099, 37.23321], [-122.04087, 37.23319], [-122.04077, 37.23312], [-122.04074, 37.23304], [-122.04073, 37.23291], [-122.04069, 37.2328], [-122.0406, 37.23271], [-122.04045, 37.23262], [-122.04041, 37.23256], [-122.04039, 37.23213], [-122.04036, 37.23205], [-122.0403, 37.23197], [-122.04016, 37.22775], [-122.04502, 37.22778], [-122.04969, 37.22778], [-122.04994, 37.23524]]]} | No Public Access 3 | 14487 | Stewart Ridge | 25848 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 261.985 | Stewart Ridge | 1990 | None 743 | ||
8862 | 8862 | 8861 | {"type": "Polygon", "coordinates": [[[-121.93261, 36.63166], [-121.93201, 36.63331], [-121.9294, 36.63268], [-121.92997, 36.63113], [-121.93025, 36.63117], [-121.93046, 36.63118], [-121.93084, 36.63115], [-121.93112, 36.6311], [-121.93131, 36.63103], [-121.9315, 36.63096], [-121.93171, 36.63084], [-121.93261, 36.63166]]]} | Open Access 1 | 14488 | El Carmelo Cemetery | 18487 | 1238 | Pacific Grove, City of 177 | City 2 | City Agency 2 | http://www.ci.pg.ca.us/index.aspx?page=140 | City 2 | 1238 | Pacific Grove, City of 173 | City 2 | City Agency 2 | Monterey 14 | 12.698 | El Carmelo Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
8863 | 8863 | 8862 | {"type": "Polygon", "coordinates": [[[-122.32243, 40.57834], [-122.32243, 40.57907], [-122.32199, 40.57906], [-122.32197, 40.57834], [-122.32243, 40.57834]]]} | Open Access 1 | 14489 | Ravenwood Park | 24200 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.771 | Ravenwood Park | 0 | Local Park 2 | 4 | |
8864 | 8864 | 8863 | {"type": "Polygon", "coordinates": [[[-122.3475, 38.30378], [-122.34725, 38.30408], [-122.34718, 38.30457], [-122.34657, 38.30439], [-122.34691, 38.30399], [-122.34744, 38.30372], [-122.3475, 38.30378]]]} | Open Access 1 | 14491 | Knolls Park | 20700 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.792 | Knolls Park | 0 | Local Park 2 | 4 | |
8865 | 8865 | 8864 | {"type": "Polygon", "coordinates": [[[-117.69397, 33.60743], [-117.69287, 33.60917], [-117.69277, 33.60937], [-117.69267, 33.60972], [-117.69267, 33.61031], [-117.69272, 33.6107], [-117.69286, 33.61099], [-117.69256, 33.61117], [-117.69249, 33.61102], [-117.69244, 33.61084], [-117.69237, 33.61078], [-117.69229, 33.61076], [-117.69217, 33.61041], [-117.69216, 33.6103], [-117.69218, 33.60972], [-117.69224, 33.60938], [-117.69171, 33.60924], [-117.69175, 33.60919], [-117.69241, 33.60802], [-117.69326, 33.60776], [-117.69348, 33.60733], [-117.6935, 33.60734], [-117.69351, 33.60736], [-117.69377, 33.60734], [-117.69397, 33.60743]]]} | Open Access 1 | 14623 | Sycamore Park | 26137 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 7.009 | Sycamore Park | 0 | Local Park 2 | 4 | |
8866 | 8866 | 8865 | {"type": "Polygon", "coordinates": [[[-121.96063, 37.28436], [-121.96048, 37.28438], [-121.96041, 37.2843], [-121.96029, 37.28428], [-121.96018, 37.28432], [-121.96012, 37.28441], [-121.96008, 37.28444], [-121.9586, 37.28465], [-121.9579, 37.28199], [-121.95721, 37.28139], [-121.95575, 37.2814], [-121.95575, 37.28072], [-121.95599, 37.28069], [-121.95626, 37.28062], [-121.95651, 37.28049], [-121.95685, 37.28025], [-121.95701, 37.28022], [-121.95715, 37.28028], [-121.9579, 37.28083], [-121.95956, 37.28238], [-121.9598, 37.28262], [-121.96001, 37.28288], [-121.9602, 37.28316], [-121.96042, 37.2836], [-121.96053, 37.2839], [-121.96063, 37.28436]]]} | Open Access 1 | 14514 | John D. Morgan Park | 20434 | 1043 | Campbell, City of 448 | City 2 | City Agency 2 | http://www.ci.campbell.ca.us/226/Recreation-Parks | City 2 | 1043 | Campbell, City of 442 | City 2 | City Agency 2 | Santa Clara 19 | 18.397 | John D. Morgan Park | 1972 | Local Park 2 | 4 | |
8867 | 8867 | 8866 | {"type": "Polygon", "coordinates": [[[-122.33929, 38.30424], [-122.33903, 38.30486], [-122.33905, 38.30487], [-122.33895, 38.30512], [-122.33886, 38.30508], [-122.33878, 38.30473], [-122.33867, 38.30465], [-122.33829, 38.30466], [-122.33834, 38.30486], [-122.33812, 38.30491], [-122.33806, 38.30453], [-122.33802, 38.30444], [-122.33792, 38.3043], [-122.33775, 38.3042], [-122.33755, 38.30416], [-122.3374, 38.30416], [-122.33716, 38.30428], [-122.33702, 38.30439], [-122.33695, 38.3044], [-122.3368, 38.30438], [-122.33644, 38.3044], [-122.33631, 38.30389], [-122.33659, 38.30418], [-122.33703, 38.30405], [-122.33784, 38.30373], [-122.33808, 38.30371], [-122.33808, 38.3037], [-122.33785, 38.30344], [-122.33792, 38.30341], [-122.33849, 38.30402], [-122.33929, 38.30424]]]} | Open Access 1 | 14492 | Buhman Park | 16499 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 3.637 | Buhman Park | 1973 | Local Park 2 | 4 | |
8868 | 8868 | 8867 | {"type": "Polygon", "coordinates": [[[-122.33567, 38.30958], [-122.33522, 38.30966], [-122.33532, 38.3104], [-122.33297, 38.31041], [-122.33211, 38.31037], [-122.33111, 38.31037], [-122.33107, 38.30984], [-122.33129, 38.30992], [-122.33246, 38.31018], [-122.33255, 38.31006], [-122.3326, 38.30993], [-122.33266, 38.30991], [-122.3329, 38.30995], [-122.33331, 38.31004], [-122.33365, 38.31009], [-122.33395, 38.31008], [-122.33429, 38.31003], [-122.33478, 38.30974], [-122.33469, 38.30948], [-122.33489, 38.30923], [-122.33483, 38.30889], [-122.33459, 38.30875], [-122.33448, 38.30854], [-122.33445, 38.30831], [-122.33403, 38.30832], [-122.33403, 38.30827], [-122.33444, 38.30822], [-122.33427, 38.30652], [-122.33403, 38.30651], [-122.33394, 38.30654], [-122.33387, 38.30664], [-122.33372, 38.30662], [-122.33366, 38.3065], [-122.33322, 38.30632], [-122.33315, 38.30584], [-122.33408, 38.30607], [-122.33445, 38.30621], [-122.3352, 38.30658], [-122.33547, 38.30668], [-122.33532, 38.30687], [-122.33535, 38.30714], [-122.3355, 38.30732], [-122.33546, 38.30744], [-122.33552, 38.30754], [-122.33567, 38.30958]]]} | Open Access 1 | 14494 | Century Oaks Park | 17077 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 13.721 | Century Oaks Park | 1973 | Local Park 2 | 4 | |
8869 | 8869 | 8868 | {"type": "Polygon", "coordinates": [[[-122.33053, 38.3066], [-122.32907, 38.3065], [-122.32912, 38.30616], [-122.32947, 38.3057], [-122.32974, 38.30576], [-122.33, 38.3059], [-122.33022, 38.30611], [-122.33039, 38.30631], [-122.33053, 38.3066]]]} | Open Access 1 | 14495 | Valley Park | 26798 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1.989 | Valley Park | 1967 | Local Park 2 | 4 | |
8870 | 8870 | 8869 | {"type": "Polygon", "coordinates": [[[-122.33, 38.30856], [-122.32952, 38.30883], [-122.32928, 38.30872], [-122.32914, 38.30862], [-122.32884, 38.30847], [-122.32883, 38.30838], [-122.32898, 38.3082], [-122.32944, 38.30793], [-122.33, 38.30856]]]} | Open Access 1 | 14496 | Kensington Park | 20614 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1.374 | Kensington Park | 0 | Local Park 2 | 4 | |
8871 | 8871 | 8870 | {"type": "Polygon", "coordinates": [[[-122.32162, 38.31524], [-122.31999, 38.31553], [-122.31989, 38.31532], [-122.3197, 38.31512], [-122.31949, 38.31494], [-122.32142, 38.31459], [-122.32162, 38.31524]]]} | Open Access 1 | 14497 | Sutherland Park | 26081 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 2.856 | Sutherland Park | 0 | Local Park 2 | 4 | |
8872 | 8872 | 8871 | {"type": "Polygon", "coordinates": [[[-122.3304, 38.32125], [-122.32953, 38.32172], [-122.32925, 38.32138], [-122.32925, 38.32131], [-122.32923, 38.32126], [-122.32918, 38.32123], [-122.3291, 38.3212], [-122.3288, 38.32085], [-122.32958, 38.32041], [-122.3304, 38.32125]]]} | Open Access 1 | 14498 | Dry Creek Park | 18281 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 2.513 | Dry Creek Park | 1974 | Local Park 2 | 4 | |
8873 | 8873 | 8872 | {"type": "Polygon", "coordinates": [[[-122.32945, 38.3266], [-122.32941, 38.32672], [-122.32935, 38.32684], [-122.32926, 38.32696], [-122.32913, 38.32708], [-122.32882, 38.32682], [-122.32839, 38.32706], [-122.32844, 38.32712], [-122.32828, 38.32721], [-122.32828, 38.32758], [-122.32821, 38.32762], [-122.3282, 38.32722], [-122.32823, 38.32715], [-122.32823, 38.32692], [-122.32818, 38.32691], [-122.32818, 38.32669], [-122.32823, 38.32667], [-122.32816, 38.32629], [-122.32808, 38.32629], [-122.32805, 38.32618], [-122.32771, 38.32622], [-122.32758, 38.32628], [-122.32753, 38.3262], [-122.32781, 38.32605], [-122.3279, 38.32614], [-122.32838, 38.32588], [-122.32853, 38.32596], [-122.32876, 38.32575], [-122.32877, 38.32576], [-122.32857, 38.32599], [-122.32879, 38.3261], [-122.32911, 38.3262], [-122.32903, 38.32654], [-122.32945, 38.3266]]]} | Open Access 1 | 14499 | Vineyard Park | 27138 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 2.639 | Vineyard Park | 0 | Local Park 2 | 4 | |
8874 | 8874 | 8873 | {"type": "Polygon", "coordinates": [[[-122.33408, 38.32945], [-122.33383, 38.32959], [-122.33356, 38.32968], [-122.33329, 38.32971], [-122.33309, 38.3297], [-122.3329, 38.32965], [-122.33275, 38.32959], [-122.33258, 38.32948], [-122.33247, 38.32938], [-122.3322, 38.32907], [-122.33205, 38.32892], [-122.33196, 38.3288], [-122.33187, 38.32864], [-122.33191, 38.32858], [-122.3333, 38.32843], [-122.3336, 38.32875], [-122.33351, 38.3288], [-122.33351, 38.32882], [-122.33408, 38.32945]]]} | Open Access 1 | 14500 | Vine Hill Park | 27131 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 4.181 | Vine Hill Park | 0 | Local Park 2 | 4 | |
8875 | 8875 | 8874 | {"type": "Polygon", "coordinates": [[[-117.93364, 33.72036], [-117.93326, 33.72049], [-117.93304, 33.7206], [-117.93284, 33.72076], [-117.93231, 33.72129], [-117.9323, 33.72071], [-117.93231, 33.72058], [-117.93231, 33.72007], [-117.93364, 33.72006], [-117.93364, 33.72036]]]} | Open Access 1 | 14501 | Stonecress Park | 25885 | 1111 | Fountain Valley, City of 273 | City 2 | City Agency 2 | http://www.fountainvalley.org/visitors/parks/ | City 2 | 1111 | Fountain Valley, City of 268 | City 2 | City Agency 2 | Orange 3 | 2.257 | Stonecress Park | 0 | Local Park 2 | 4 | |
8876 | 8876 | 8875 | {"type": "Polygon", "coordinates": [[[-118.40865, 34.21786], [-118.40539, 34.21786], [-118.4054, 34.21588], [-118.40546, 34.21584], [-118.40688, 34.21585], [-118.40856, 34.21746], [-118.40865, 34.21786]]]} | Open Access 1 | 14515 | Strathern Park North | 25909 | 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 | 12.718 | Strathern Park North | 0 | Local Park 2 | 4 | |
8877 | 8877 | 8876 | {"type": "Polygon", "coordinates": [[[-122.01681, 37.31623], [-122.0168, 37.31644], [-122.0164, 37.31668], [-122.01607, 37.31674], [-122.01577, 37.31726], [-122.01557, 37.31775], [-122.01363, 37.31777], [-122.01363, 37.31733], [-122.0137, 37.31732], [-122.01369, 37.31704], [-122.01379, 37.31703], [-122.01383, 37.31624], [-122.01498, 37.31627], [-122.01507, 37.31468], [-122.01624, 37.31472], [-122.0162, 37.31475], [-122.01625, 37.31503], [-122.01613, 37.31534], [-122.01612, 37.316], [-122.01639, 37.31618], [-122.01681, 37.31623]]]} | Open Access 1 | 14523 | Creekside Park | 17772 | 1076 | Cupertino, City of 195 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | Santa Clara 19 | 12.968 | Creekside Park | 1990 | 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]);