superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,210 rows where MNG_AG_TYP = 2 sorted by MNG_AGENCY descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 465
- San Diego, City of 433
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 218
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 124
- Oakland, City of 122
- Irvine, City of 98
- Fresno, City of 94
- Modesto, City of 84
- Stockton, City of 81
- Santa Rosa, City of 79
- Huntington Beach, City of 76
- Tracy, City of 73
- Torrance, City of 72
- Santa Cruz, City of 69
- Chula Vista, City of 69
- Brentwood, City of 68
- Poway, City of 67
- Newport Beach, City of 65
- Santa Barbara, City of 64
- Davis, City of 64
- San Luis Obispo, City of 63
- Napa, City of 62
- Clovis, City of 62
- Bakersfield, City of 61
- Manteca, City of 60
- Anaheim, City of 59
- …
ACCESS_TYP 4
- Open Access 9,670
- Restricted Access 356
- No Public Access 155
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,210 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14122 | 14122 | 14121 | {"type": "Polygon", "coordinates": [[[-117.85818, 34.19361], [-117.85655, 34.19631], [-117.85599, 34.19646], [-117.85577, 34.1973], [-117.85578, 34.19593], [-117.85608, 34.19585], [-117.85744, 34.1936], [-117.85818, 34.19361]]]} | No Public Access 3 | Unnamed Site - Pasadena Department of Water and Power | 33667 | 1720 | Pasadena Department of Water and Power 1099 | City 2 | City Agency 2 | https://ww5.cityofpasadena.net/water-and-power/ | City 2 | 5.623 | |||
12584 | 12584 | 12583 | {"type": "Polygon", "coordinates": [[[-117.97481, 34.14373], [-117.9748, 34.14592], [-117.97454, 34.14593], [-117.97453, 34.14687], [-117.9745, 34.14687], [-117.9745, 34.1459], [-117.97472, 34.14589], [-117.97476, 34.14586], [-117.97476, 34.14373], [-117.97481, 34.14373]]]} | Open Access 1 | Lemon Trail | 29710 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 0.344 | Lemon Trail | ||
12585 | 12585 | 12584 | {"type": "Polygon", "coordinates": [[[-117.97472, 34.14357], [-117.97464, 34.14362], [-117.96441, 34.1437], [-117.96441, 34.14354], [-117.97458, 34.14347], [-117.97472, 34.14357]]]} | Open Access 1 | Royal Oaks Trail North | 29711 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 4.027 | Royal Oaks Trail North | ||
15622 | 15622 | 15621 | {"type": "Polygon", "coordinates": [[[-117.96999, 34.14575], [-117.9696, 34.14575], [-117.96915, 34.14556], [-117.96899, 34.14555], [-117.96898, 34.14547], [-117.96986, 34.1455], [-117.96996, 34.14548], [-117.96999, 34.14575]]]} | Open Access 1 | Civic Center Park | 32522 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 0.468 | Civic Ctr. Park | ||
11850 | 11850 | 11849 | {"type": "Polygon", "coordinates": [[[-122.83393, 41.61987], [-122.83324, 41.62052], [-122.83325, 41.62054], [-122.83331, 41.62054], [-122.83314, 41.62075], [-122.83212, 41.62027], [-122.83205, 41.62032], [-122.83181, 41.62017], [-122.83282, 41.61921], [-122.83393, 41.61987]]]} | Open Access 1 | Walker Field | 28497 | 1701 | Fort Jones, City of 1090 | City 2 | City Agency 2 | City 2 | 3.716 | Walker Field | |||
11730 | 11730 | 11729 | {"type": "Polygon", "coordinates": [[[-122.27139, 41.21224], [-122.27137, 41.21239], [-122.27096, 41.21242], [-122.27099, 41.2122], [-122.27139, 41.21224]]]} | Open Access 1 | Children's Park | 28333 | 1700 | Dunsmuir, City of 1082 | City 2 | City Agency 2 | http://ci.dunsmuir.ca.us/ | City 2 | 0.166 | Children's Park | ||
11559 | 11559 | 11558 | {"type": "Polygon", "coordinates": [[[-115.61857, 33.0338], [-115.61857, 33.035], [-115.6174, 33.035], [-115.6174, 33.0338], [-115.61857, 33.0338]]]} | Open Access 1 | Jake James Municipal Sports Park Development | 28025 | 1678 | Westmorland, City of 1076 | City 2 | City Agency 2 | http://www.cityofwestmorland.net/ | City 2 | 3.591 | Jake James Municipal Sports Park Development | ||
6449 | 6449 | 6448 | {"type": "Polygon", "coordinates": [[[-120.24958, 39.68178], [-120.24797, 39.68179], [-120.24795, 39.68118], [-120.24693, 39.68118], [-120.24691, 39.68182], [-120.24567, 39.68182], [-120.24567, 39.68073], [-120.24958, 39.68072], [-120.24958, 39.68178]]]} | Open Access 1 | Loyalton Park | 21571 | 1669 | Loyalton, City of 1002 | City 2 | City Agency 2 | http://www.cityofloyalton.com/ | City 2 | 8.36 | Loyalton Park | ||
2035 | 2035 | 2034 | {"type": "MultiPolygon", "coordinates": [[[[-118.39518, 37.3677], [-118.39443, 37.36772], [-118.39444, 37.36867], [-118.39297, 37.36869], [-118.39296, 37.36913], [-118.39236, 37.36914], [-118.39235, 37.36952], [-118.39077, 37.36954], [-118.39079, 37.36747], [-118.39075, 37.36733], [-118.39065, 37.36722], [-118.39056, 37.36716], [-118.39045, 37.36713], [-118.39024, 37.36712], [-118.39011, 37.36715], [-118.38999, 37.36721], [-118.38989, 37.36729], [-118.38971, 37.3675], [-118.38957, 37.36758], [-118.38942, 37.3676], [-118.38865, 37.3676], [-118.38863, 37.36759], [-118.38861, 37.36726], [-118.38856, 37.36687], [-118.38826, 37.3655], [-118.38822, 37.36523], [-118.38821, 37.36502], [-118.39085, 37.36498], [-118.39087, 37.36628], [-118.3933, 37.36627], [-118.39332, 37.36654], [-118.39517, 37.36652], [-118.39518, 37.3677]]], [[[-118.39051, 37.36954], [-118.38862, 37.36958], [-118.3886, 37.36772], [-118.38935, 37.36771], [-118.38948, 37.36769], [-118.38959, 37.36764], [-118.38969, 37.36757], [-118.38992, 37.36732], [-118.39001, 37.36727], [-118.39012, 37.36724], [-118.39029, 37.36723], [-118.39038, 37.36727], [-118.39046, 37.36732], [-118.3905, 37.36739], [-118.39052, 37.36747], [-118.39051, 37.36954]]]]} | Open Access 1 | Bishop Park | 16127 | 1466 | Bishop, City of 995 | City 2 | City Agency 2 | http://www.ca-bishop.us/departments/parks-and-recreation/ | City 2 | 50.137 | Bishop Park | ||
511 | 511 | 510 | {"type": "Polygon", "coordinates": [[[-117.36926, 34.42046], [-117.36922, 34.42053], [-117.36874, 34.42025], [-117.36926, 34.42025], [-117.36926, 34.42046]]]} | Open Access 1 | Dogwood Park | 33517 | 1687 | Hesperia, City of 993 | City 2 | City Agency 2 | http://cityofhesperia.us/ | City 2 | 0.193 | Dogwood Park | ||
6612 | 6612 | 6611 | {"type": "Polygon", "coordinates": [[[-117.34807, 34.39252], [-117.34644, 34.39297], [-117.34644, 34.39241], [-117.34645, 34.39239], [-117.34645, 34.39224], [-117.34644, 34.39223], [-117.34643, 34.39087], [-117.34807, 34.39088], [-117.34807, 34.39252]]]} | Open Access 1 | Maple Park | 21781 | 1687 | Hesperia, City of 993 | City 2 | City Agency 2 | http://cityofhesperia.us/ | City 2 | 7.716 | Maple Park | ||
8324 | 8324 | 8323 | {"type": "Polygon", "coordinates": [[[-120.46646, 39.8064], [-120.4655, 39.80642], [-120.46531, 39.80634], [-120.46485, 39.8061], [-120.46454, 39.80602], [-120.46421, 39.80597], [-120.46385, 39.80599], [-120.46339, 39.80605], [-120.46377, 39.80555], [-120.46349, 39.80538], [-120.46379, 39.80504], [-120.46357, 39.80482], [-120.46349, 39.80484], [-120.46315, 39.80507], [-120.46279, 39.80499], [-120.46276, 39.80495], [-120.46377, 39.80408], [-120.46384, 39.80406], [-120.46403, 39.80426], [-120.46435, 39.80441], [-120.46472, 39.80457], [-120.46496, 39.80483], [-120.46646, 39.8064]]]} | Open Access 1 | Portola City Park | 23905 | 1457 | Portola, City of 986 | City 2 | City Agency 2 | http://www.ci.portola.ca.us/parks-and-recreation.htm | City 2 | 8.554 | Portola City Park | ||
6247 | 6247 | 6246 | {"type": "Polygon", "coordinates": [[[-120.95949, 39.10159], [-120.95945, 39.10173], [-120.95943, 39.1019], [-120.95944, 39.10206], [-120.95949, 39.10232], [-120.95916, 39.10231], [-120.95914, 39.10235], [-120.95906, 39.10233], [-120.95821, 39.10235], [-120.95783, 39.10232], [-120.95727, 39.10236], [-120.95718, 39.10235], [-120.95704, 39.1023], [-120.95703, 39.10213], [-120.95737, 39.10186], [-120.95798, 39.10146], [-120.9586, 39.10103], [-120.95861, 39.101], [-120.95888, 39.10096], [-120.95898, 39.10097], [-120.95907, 39.10105], [-120.95918, 39.10124], [-120.95929, 39.10124], [-120.95949, 39.10159]]]} | Open Access 1 | Lions Children's Park | 21313 | 1455 | Colfax, City of 985 | City 2 | City Agency 2 | http://www.colfax-ca.gov/ | City 2 | 5.34 | Lions Children's Park | ||
4837 | 4837 | 4836 | {"type": "Polygon", "coordinates": [[[-122.12463, 40.02809], [-122.12351, 40.0282], [-122.12336, 40.02734], [-122.12448, 40.02722], [-122.12463, 40.02809]]]} | Open Access 1 | Halbert Park | 19599 | 1676 | Tehama, City of 976 | City 2 | City Agency 2 | http://www.cityoftehama.us/ | City 2 | 2.327 | Halbert Park | ||
8735 | 8735 | 8734 | {"type": "Polygon", "coordinates": [[[-122.1237, 40.02267], [-122.12257, 40.02279], [-122.12242, 40.02192], [-122.12354, 40.02181], [-122.1237, 40.02267]]]} | Open Access 1 | Tehama City Parks | 26220 | 1676 | Tehama, City of 976 | City 2 | City Agency 2 | http://www.cityoftehama.us/ | City 2 | 2.327 | Tehama City Parks | ||
6271 | 6271 | 6270 | {"type": "Polygon", "coordinates": [[[-120.64976, 40.41359], [-120.64933, 40.41358], [-120.64903, 40.41335], [-120.64894, 40.41443], [-120.64785, 40.41413], [-120.64787, 40.41406], [-120.64746, 40.41393], [-120.64745, 40.41391], [-120.64718, 40.41378], [-120.64719, 40.41371], [-120.64686, 40.41359], [-120.64682, 40.41365], [-120.64671, 40.41361], [-120.64675, 40.41353], [-120.64674, 40.4135], [-120.6464, 40.41308], [-120.64605, 40.41271], [-120.64614, 40.41239], [-120.64652, 40.41262], [-120.64737, 40.41246], [-120.64744, 40.41243], [-120.64902, 40.41302], [-120.64976, 40.41356], [-120.64976, 40.41359]]]} | Open Access 1 | Little Leage Park | 21342 | 1437 | Susanville, City of 975 | City 2 | City Agency 2 | http://www.cityofsusanville.org/ | City 2 | 8.67 | Little Leage Park | ||
6929 | 6929 | 6928 | {"type": "Polygon", "coordinates": [[[-120.65746, 40.41862], [-120.65737, 40.41884], [-120.65689, 40.41872], [-120.65681, 40.41889], [-120.65676, 40.41889], [-120.65672, 40.41904], [-120.65723, 40.41917], [-120.65707, 40.41957], [-120.65304, 40.41858], [-120.65356, 40.4172], [-120.65359, 40.41718], [-120.6569, 40.41799], [-120.65709, 40.41757], [-120.65715, 40.41759], [-120.65699, 40.418], [-120.65714, 40.41805], [-120.65712, 40.41811], [-120.65504, 40.41759], [-120.65488, 40.41797], [-120.65746, 40.41862]]]} | Open Access 1 | Memorial Park | 22140 | 1437 | Susanville, City of 975 | City 2 | City Agency 2 | http://www.cityofsusanville.org/ | City 2 | 11.554 | Memorial Park | ||
8791 | 8791 | 8790 | {"type": "Polygon", "coordinates": [[[-120.65267, 40.41073], [-120.6516, 40.41196], [-120.65147, 40.4118], [-120.65132, 40.41167], [-120.65058, 40.41121], [-120.65046, 40.41058], [-120.65049, 40.41027], [-120.65078, 40.40988], [-120.65178, 40.41035], [-120.65181, 40.41033], [-120.65267, 40.41073]]]} | Open Access 1 | Riverside Park | 24458 | 1437 | Susanville, City of 975 | City 2 | City Agency 2 | http://www.cityofsusanville.org/ | City 2 | 5.83 | Riverside Park | ||
10145 | 10145 | 10144 | {"type": "Polygon", "coordinates": [[[-120.65866, 40.41492], [-120.65846, 40.41525], [-120.65785, 40.41487], [-120.65713, 40.4142], [-120.65694, 40.41415], [-120.65669, 40.41415], [-120.65642, 40.41419], [-120.65538, 40.41461], [-120.65454, 40.41459], [-120.65442, 40.4145], [-120.65445, 40.41416], [-120.6546, 40.41418], [-120.65462, 40.41429], [-120.65474, 40.41428], [-120.65475, 40.41419], [-120.65541, 40.41425], [-120.65545, 40.41398], [-120.65556, 40.41397], [-120.65559, 40.41368], [-120.65758, 40.41388], [-120.65784, 40.41394], [-120.65802, 40.41405], [-120.65815, 40.41423], [-120.6582, 40.41433], [-120.65828, 40.41468], [-120.65831, 40.41475], [-120.65839, 40.4148], [-120.65866, 40.41492]]]} | Open Access 1 | Susan River Park | 26079 | 1437 | Susanville, City of 975 | City 2 | City Agency 2 | http://www.cityofsusanville.org/ | City 2 | 5.133 | Susan River Park | ||
3441 | 3441 | 3440 | {"type": "Polygon", "coordinates": [[[-124.26652, 40.57397], [-124.26609, 40.57438], [-124.26519, 40.5738], [-124.2651, 40.57372], [-124.26489, 40.57389], [-124.26428, 40.57333], [-124.26398, 40.5731], [-124.2646, 40.57245], [-124.26652, 40.57397]]]} | Open Access 1 | Fortuna holding 1 | 19012 | 1434 | Fortuna, City of 974 | City 2 | City Agency 2 | http://friendlyfortuna.com/index.aspx?nid=95 | City 2 | 4.431 | Fortuna holding 1 |
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]);