superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows sorted by LAYER
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 5,438
- County Agency 1,102
- Recreation/Parks District 1,091
- State Agency 872
- Non Profit - Land Trust 511
- Federal Agency 254
- Open Space District 241
- County Agency - Parks 218
- Home Owners Association 200
- Community Services District 193
- Water District 187
- Non Profit - Conservation 119
- Flood District 94
- Cemetery District 61
- Non Profit - Other 44
- School District 38
- County Agency - Other 32
- Port/Harbor District 32
- Irrigation District 24
- Special District - Other 15
- Commercial 14
- Sanitation District 9
- Joint Powers Authority 8
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- California Department of Fish and Wildlife 394
- San Diego, City of 336
- Los Angeles, City of 292
- California Department of Parks and Recreation 276
- Mountains Recreation and Conservation Authority 181
- Los Angeles, County of 171
- East Bay Regional Park District 132
- Ventura, City of 129
- San Diego, County of 120
- San Jose, City of 116
- San Francisco, City and County of 106
- Sacramento, City of 101
- Long Beach, City of 97
- Consumnes Community Services District 92
- Santa Barbara, County of 89
- Hayward Area Recreation and Park District 84
- Roseville, City of 84
- Orange, County of 82
- Valley-Wide Recreation and Park District 67
- United States National Park Service 65
- Los Angeles - Department of Parks and Recreation, County of 63
- Fresno, City of 58
- Poway, City of 57
- Lake, County of 56
- United States Fish and Wildlife Service 55
- Rancho Simi Recreation and Park District 53
- Butte, County of 53
- Torrance, City of 52
- Santa Cruz, County of 50
- University of California 50
- …
ACCESS_TYP 4
- Open Access 8,880
- Restricted Access 991
- No Public Access 713
- Unknown Access 247
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER ▼ | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6980 | 6980 | 6979 | {"type": "Polygon", "coordinates": [[[-117.29165, 33.03944], [-117.29132, 33.03948], [-117.29118, 33.03833], [-117.29147, 33.03831], [-117.29165, 33.03944]]]} | Open Access 1 | Mildred Macpherson Mini-Park | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks | 22214 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 0.914 | Mildred Macpherson Mini-Park | |
6981 | 6981 | 6980 | {"type": "Polygon", "coordinates": [[[-121.05612, 37.69647], [-121.05471, 37.69648], [-121.05466, 37.69477], [-121.05611, 37.69474], [-121.05612, 37.69647]]]} | Open Access 1 | Mildred Perkins Park | 22215 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 5.937 | Mildred Perkins Park | ||
6983 | 6983 | 6982 | {"type": "Polygon", "coordinates": [[[-121.28289, 37.8229], [-121.2829, 37.82343], [-121.28288, 37.82346], [-121.28283, 37.82348], [-121.28224, 37.82348], [-121.28223, 37.82286], [-121.28282, 37.82286], [-121.28288, 37.82288], [-121.28289, 37.8229]]]} | Open Access 1 | Milestone Park | 22220 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 0.989 | Milestone Park | ||
6985 | 6985 | 6984 | {"type": "Polygon", "coordinates": [[[-121.99072, 37.77668], [-121.99044, 37.77695], [-121.98929, 37.77606], [-121.98814, 37.77604], [-121.98826, 37.77573], [-121.98834, 37.77549], [-121.98841, 37.77517], [-121.98844, 37.77492], [-121.99072, 37.77668]]]} | Open Access 1 | Mill Creek Hollow | 22223 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 3.524 | Mill Creek Hollow | ||
6988 | 6988 | 6987 | {"type": "Polygon", "coordinates": [[[-117.27592, 34.08551], [-117.27587, 34.08552], [-117.27587, 34.08575], [-117.27585, 34.08578], [-117.27582, 34.0858], [-117.27321, 34.0858], [-117.2732, 34.0828], [-117.27456, 34.08281], [-117.27456, 34.08462], [-117.27592, 34.08464], [-117.27592, 34.08551]]]} | Open Access 1 | Mill Park | 22229 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 14.294 | Mill Park | ||
6989 | 6989 | 6988 | {"type": "Polygon", "coordinates": [[[-119.06334, 34.36551], [-119.06233, 34.36579], [-119.06207, 34.36471], [-119.06305, 34.36444], [-119.06319, 34.36496], [-119.06322, 34.36516], [-119.06334, 34.36551]]]} | Open Access 1 | Mill Park | 22230 | 1674 | Santa Paula, City of 186 | City 2 | City Agency 2 | http://www.ci.santa-paula.ca.us/ | City 2 | 2.85 | Mill Park | ||
6990 | 6990 | 6989 | {"type": "Polygon", "coordinates": [[[-122.54015, 37.90017], [-122.54007, 37.90023], [-122.53885, 37.89915], [-122.53877, 37.89918], [-122.53812, 37.89862], [-122.53817, 37.89859], [-122.53817, 37.89857], [-122.53707, 37.89755], [-122.53715, 37.8975], [-122.54015, 37.90017]]]} | Open Access 1 | Mill Valley holding 1 | 22232 | 1204 | Mill Valley, City of 223 | City 2 | City Agency 2 | http://www.cityofmillvalley.org/Index.aspx?page=416 | City 2 | 1.149 | Mill Valley holding 1 | ||
6991 | 6991 | 6990 | {"type": "MultiPolygon", "coordinates": [[[[-122.52193, 37.91437], [-122.52122, 37.91441], [-122.52077, 37.91497], [-122.52075, 37.91564], [-122.52094, 37.91597], [-122.52066, 37.91613], [-122.5205, 37.91553], [-122.52063, 37.91523], [-122.52061, 37.91501], [-122.52074, 37.9147], [-122.52095, 37.91441], [-122.52118, 37.91393], [-122.52152, 37.91416], [-122.52193, 37.91437]]], [[[-122.52358, 37.91236], [-122.52323, 37.91296], [-122.52327, 37.91357], [-122.52336, 37.91366], [-122.52233, 37.91333], [-122.52169, 37.91355], [-122.5213, 37.91382], [-122.52128, 37.9138], [-122.52167, 37.91353], [-122.52216, 37.91336], [-122.52269, 37.91291], [-122.52332, 37.91232], [-122.52358, 37.91236]]], [[[-122.52406, 37.91453], [-122.52381, 37.91458], [-122.52354, 37.9146], [-122.52357, 37.91411], [-122.52384, 37.91412], [-122.52406, 37.91453]]], [[[-122.52567, 37.90731], [-122.52557, 37.90816], [-122.52545, 37.90865], [-122.52522, 37.90935], [-122.52466, 37.91037], [-122.52379, 37.90976], [-122.52386, 37.90971], [-122.5239, 37.90973], [-122.52417, 37.90979], [-122.52467, 37.91005], [-122.52512, 37.90909], [-122.52528, 37.90861], [-122.52539, 37.90811], [-122.52542, 37.90757], [-122.52541, 37.90754], [-122.52536, 37.90752], [-122.52477, 37.90751], [-122.52477, 37.9073], [-122.52567, 37.90731]]], [[[-122.52459, 37.91048], [-122.52445, 37.91076], [-122.52412, 37.91078], [-122.52412, 37.91024], [-122.52404, 37.91009], [-122.52459, 37.91048]]], [[[-122.52465, 37.91552], [-122.52427, 37.91542], [-122.5242, 37.91493], [-122.52409, 37.91468], [-122.52415, 37.91465], [-122.52465, 37.91552]]], [[[-122.52679, 37.91515], [-122.52674, 37.91529], [-122.52665, 37.91541], [-122.52561, 37.91629], [-122.52552, 37.91641], [-122.52547, 37.91655], [-122.52497, 37.91573], [-122.52533, 37.91554], [-122.52556, 37.91527], [-122.52587, 37.91521], [-122.526, 37.91517], [-122.52615, 37.91479], [-122.52596, 37.91458], [-122.52542, 37.91423], [-122.52544, 37.91404], [-122.526, 37.91406], [-122.52604, 37.91421], [-122.52611, 37.91431], [-122.52661, 37.91472], [-122.52671, 37.91483], [-122.52678, 37.91496], [-122.52679, 37.91515]]], [[[-122.52622, 37.90858], [-122.52616, 37.90867], [-122.52607, 37.90873], [-122.52567, 37.90861], [-122.52582, 37.90784], [-122.52606, 37.90792], [-122.52616, 37.90786], [-122.52601, 37.90813], [-122.52599, 37.90825], [-122.52601, 37.90834], [-122.52605, 37.90841], [-122.52611, 37.90848], [-122.5262, 37.90854], [-122.52622, 37.90858]]]]} | Open Access 1 | Mill Valley Lands 001 | 22233 | 1204 | Mill Valley, City of 223 | City 2 | City Agency 2 | http://www.cityofmillvalley.org/Index.aspx?page=416 | City 2 | 11.748 | Mill Valley Lands 001 | ||
6992 | 6992 | 6991 | {"type": "MultiPolygon", "coordinates": [[[[-122.56686, 37.90399], [-122.56556, 37.90444], [-122.5654, 37.90423], [-122.56514, 37.90416], [-122.56505, 37.90401], [-122.56488, 37.90418], [-122.56472, 37.90425], [-122.56439, 37.90432], [-122.56421, 37.90434], [-122.56391, 37.90432], [-122.56353, 37.90438], [-122.56348, 37.90436], [-122.56345, 37.90429], [-122.56346, 37.90397], [-122.56358, 37.90378], [-122.56364, 37.90363], [-122.56371, 37.90359], [-122.56394, 37.90328], [-122.56393, 37.90326], [-122.56377, 37.90332], [-122.56382, 37.90306], [-122.56437, 37.90265], [-122.56482, 37.90304], [-122.56428, 37.90354], [-122.56476, 37.90389], [-122.56559, 37.90318], [-122.56559, 37.90386], [-122.56606, 37.90381], [-122.56638, 37.90383], [-122.56686, 37.90399]]], [[[-122.56496, 37.90436], [-122.56493, 37.90444], [-122.56474, 37.9048], [-122.56452, 37.90505], [-122.56412, 37.9049], [-122.56412, 37.90486], [-122.56496, 37.90436]]]]} | Open Access 1 | Mill Valley Lands 003 | 22234 | 1204 | Mill Valley, City of 223 | City 2 | City Agency 2 | http://www.cityofmillvalley.org/Index.aspx?page=416 | City 2 | 6.391 | Mill Valley Lands 003 | ||
6995 | 6995 | 6994 | {"type": "Polygon", "coordinates": [[[-118.26713, 34.15245], [-118.26713, 34.15277], [-118.2668, 34.15277], [-118.2668, 34.15246], [-118.26713, 34.15245]]]} | Open Access 1 | Milford Mini Park | 22221 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 0.264 | Milford MP | ||
6998 | 6998 | 6997 | {"type": "Polygon", "coordinates": [[[-122.54807, 37.9076], [-122.5477, 37.9077], [-122.54767, 37.90763], [-122.54751, 37.90744], [-122.54734, 37.90731], [-122.54718, 37.90725], [-122.54716, 37.90719], [-122.54716, 37.90716], [-122.54723, 37.90719], [-122.5476, 37.90693], [-122.54792, 37.90723], [-122.54807, 37.9076]]]} | Open Access 1 | Mill Velley City Park | 22237 | 1204 | Mill Valley, City of 223 | City 2 | City Agency 2 | http://www.cityofmillvalley.org/Index.aspx?page=416 | City 2 | 0.822 | Mill Velley City Park | ||
6999 | 6999 | 6998 | {"type": "Polygon", "coordinates": [[[-122.54893, 37.90997], [-122.54852, 37.9102], [-122.54769, 37.90923], [-122.5476, 37.90906], [-122.54817, 37.90886], [-122.54825, 37.90904], [-122.54847, 37.90938], [-122.54893, 37.90997]]]} | Open Access 1 | Miller Grove Park | 22239 | 1204 | Mill Valley, City of 223 | City 2 | City Agency 2 | http://www.cityofmillvalley.org/Index.aspx?page=416 | City 2 | 1.74 | Miller Grove Park | ||
7000 | 7000 | 6999 | {"type": "Polygon", "coordinates": [[[-114.60526, 33.60286], [-114.60326, 33.60289], [-114.60322, 33.60059], [-114.60521, 33.60056], [-114.60526, 33.60286]]]} | Open Access 1 | Miller Park | 22240 | 1032 | Blythe, City of 339 | City 2 | City Agency 2 | http://www.cityofblythe.ca.gov/88/Parks-Department | City 2 | 11.645 | Miller Park | ||
7001 | 7001 | 7000 | {"type": "Polygon", "coordinates": [[[-117.43451, 34.10096], [-117.43301, 34.10097], [-117.43284, 34.10095], [-117.43283, 34.09946], [-117.43395, 34.09946], [-117.43395, 34.1], [-117.43451, 34.1], [-117.43451, 34.10096]]]} | Open Access 1 | Miller Park | 22242 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 5.606 | Miller Park | ||
7002 | 7002 | 7001 | {"type": "Polygon", "coordinates": [[[-121.58063, 37.01244], [-121.57971, 37.01271], [-121.57897, 37.01108], [-121.5799, 37.0108], [-121.58063, 37.01244]]]} | Open Access 1 | Miller Park | 22243 | 1118 | Gilroy, City of 401 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 4.181 | Miller Park | ||
7003 | 7003 | 7002 | {"type": "Polygon", "coordinates": [[[-118.86313, 34.27395], [-118.86268, 34.27401], [-118.86263, 34.27389], [-118.86243, 34.27377], [-118.86231, 34.27367], [-118.86222, 34.27365], [-118.86173, 34.27375], [-118.86156, 34.27385], [-118.86157, 34.2739], [-118.86154, 34.27398], [-118.86121, 34.27422], [-118.86114, 34.27423], [-118.86108, 34.27409], [-118.86095, 34.27399], [-118.86078, 34.27394], [-118.86064, 34.27388], [-118.86054, 34.27388], [-118.86042, 34.27393], [-118.86037, 34.27389], [-118.8603, 34.2734], [-118.86042, 34.27334], [-118.86049, 34.27327], [-118.86052, 34.27313], [-118.86076, 34.27301], [-118.86124, 34.27284], [-118.86133, 34.27278], [-118.86149, 34.27265], [-118.86165, 34.27243], [-118.86173, 34.27237], [-118.86189, 34.27233], [-118.86219, 34.27234], [-118.8629, 34.27227], [-118.86283, 34.27276], [-118.86285, 34.27315], [-118.86289, 34.27336], [-118.86295, 34.27356], [-118.86303, 34.27377], [-118.86313, 34.27395]]]} | Open Access 1 | Miller Park | 22244 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 8.21 | Miller Park | ||
7008 | 7008 | 7007 | {"type": "Polygon", "coordinates": [[[-122.37691, 37.72997], [-122.37659, 37.73005], [-122.37631, 37.73007], [-122.376, 37.73004], [-122.37574, 37.72998], [-122.37573, 37.72996], [-122.37596, 37.72969], [-122.37631, 37.72937], [-122.37639, 37.72939], [-122.37665, 37.72955], [-122.37687, 37.72986], [-122.37691, 37.72997]]]} | Open Access 1 | Milton Myer Recreation Center | 22256 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.223 | Milton Myer Rec. Ctr. | ||
7009 | 7009 | 7008 | {"type": "Polygon", "coordinates": [[[-119.18097, 34.19734], [-119.18096, 34.19804], [-119.17997, 34.19803], [-119.17997, 34.19733], [-119.18097, 34.19734]]]} | Open Access 1 | Plaza Park | 23787 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1.75 | Plaza Park | ||
7010 | 7010 | 7009 | {"type": "Polygon", "coordinates": [[[-122.50442, 37.94676], [-122.50391, 37.94749], [-122.5037, 37.94768], [-122.50326, 37.94774], [-122.50285, 37.94773], [-122.50208, 37.94805], [-122.5017, 37.9478], [-122.50173, 37.94767], [-122.50192, 37.94576], [-122.50391, 37.94619], [-122.50442, 37.94676]]]} | Open Access 1 | Milwok Park | 22257 | 1170 | Larkspur, City of 444 | City 2 | City Agency 2 | http://www.ci.larkspur.ca.us/index.aspx?nid=207 | City 2 | 10.077 | Milwok Park | ||
7011 | 7011 | 7010 | {"type": "Polygon", "coordinates": [[[-117.65166, 33.64041], [-117.6516, 33.64043], [-117.65136, 33.64074], [-117.65134, 33.64074], [-117.65137, 33.64044], [-117.65136, 33.6404], [-117.65133, 33.64039], [-117.65115, 33.64037], [-117.65106, 33.64039], [-117.65096, 33.64041], [-117.65085, 33.64049], [-117.65019, 33.64026], [-117.65016, 33.64028], [-117.6501, 33.64051], [-117.65006, 33.6405], [-117.65007, 33.64024], [-117.65001, 33.64023], [-117.64985, 33.64028], [-117.64982, 33.64013], [-117.64986, 33.63997], [-117.64989, 33.63991], [-117.65003, 33.63977], [-117.6502, 33.6395], [-117.65028, 33.63915], [-117.65029, 33.63879], [-117.65025, 33.63869], [-117.65003, 33.63841], [-117.64991, 33.63833], [-117.64961, 33.63823], [-117.64965, 33.63817], [-117.64994, 33.63824], [-117.65022, 33.63806], [-117.65071, 33.63857], [-117.65113, 33.63893], [-117.65127, 33.63908], [-117.6514, 33.63933], [-117.65151, 33.63979], [-117.65153, 33.64005], [-117.65166, 33.64041]]]} | Open Access 1 | Minaya Park | 22258 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 6.426 | Minaya Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);