superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows sorted by ACCESS_TYP
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 8,453
- County Agency 884
- Recreation/Parks District 878
- State Agency 693
- Non Profit - Land Trust 465
- Open Space District 203
- Home Owners Association 200
- Federal Agency 188
- County Agency - Parks 180
- Water District 165
- Community Services District 159
- Non Profit - Conservation 110
- Flood District 90
- Cemetery District 47
- School District 38
- Non Profit - Other 36
- County Agency - Other 28
- Port/Harbor District 28
- Irrigation District 16
- Commercial 10
- Sanitation District 9
- Special District - Other 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
- Los Angeles, City of 396
- San Diego, City of 380
- California Department of Fish and Wildlife 350
- San Jose, City of 194
- San Francisco, City and County of 184
- Sacramento, City of 181
- California Department of Parks and Recreation 165
- Mountains Recreation and Conservation Authority 157
- Los Angeles, County of 143
- Ventura, City of 143
- Long Beach, City of 131
- San Diego, County of 113
- Roseville, City of 112
- East Bay Regional Park District 111
- Oakland, City of 95
- Irvine, City of 88
- Fresno, City of 83
- Consumnes Community Services District 79
- Santa Barbara, County of 74
- Hayward Area Recreation and Park District 71
- Orange, County of 70
- Torrance, City of 70
- Stockton, City of 69
- Huntington Beach, City of 66
- Modesto, City of 65
- Tracy, City of 64
- Santa Cruz, City of 63
- Chula Vista, City of 62
- Poway, City of 61
- Santa Rosa, City of 59
- …
ACCESS_TYP 4
- Open Access 10,804
- Restricted Access 1,118
- No Public Access 754
- Unknown Access 254
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3084 | 3084 | 3083 | {"type": "MultiPolygon", "coordinates": [[[[-117.07929, 32.75187], [-117.07928, 32.75306], [-117.07847, 32.75306], [-117.07843, 32.75304], [-117.0784, 32.75299], [-117.07841, 32.75278], [-117.07845, 32.75266], [-117.0786, 32.75249], [-117.07929, 32.75187]]], [[[-117.08357, 32.75155], [-117.08352, 32.75157], [-117.08352, 32.7525], [-117.08356, 32.75252], [-117.08356, 32.75298], [-117.08332, 32.75306], [-117.08317, 32.75308], [-117.08165, 32.75308], [-117.08164, 32.75303], [-117.08042, 32.75302], [-117.0804, 32.75307], [-117.07989, 32.75305], [-117.07986, 32.753], [-117.07987, 32.75272], [-117.0797, 32.7518], [-117.07969, 32.75052], [-117.07966, 32.7505], [-117.07967, 32.74994], [-117.08202, 32.74993], [-117.08204, 32.75], [-117.08346, 32.75002], [-117.08348, 32.75006], [-117.08343, 32.7513], [-117.08356, 32.75132], [-117.08357, 32.75155]]]]} | Open Access 1 | Colina Del Sol Community Park | 17497 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 31.686 | Colina Del Sol Community Park | ||
3085 | 3085 | 3084 | {"type": "Polygon", "coordinates": [[[-122.41995, 37.74444], [-122.41985, 37.74459], [-122.41939, 37.7444], [-122.41948, 37.74426], [-122.41995, 37.74444]]]} | Open Access 1 | Coleridge Mini Park | 17494 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.207 | Coleridge MP | ||
3087 | 3087 | 3086 | {"type": "Polygon", "coordinates": [[[-122.19938, 37.75713], [-122.19924, 37.75722], [-122.19918, 37.75734], [-122.19815, 37.75822], [-122.19753, 37.7576], [-122.19759, 37.75714], [-122.19761, 37.75711], [-122.1977, 37.75643], [-122.19856, 37.7565], [-122.19859, 37.75649], [-122.19874, 37.7565], [-122.19938, 37.75713]]]} | Open Access 1 | Coliseum Gardens Park | 17499 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 4.999 | Coliseum Gardens Park | ||
3088 | 3088 | 3087 | {"type": "Polygon", "coordinates": [[[-118.09912, 33.77631], [-118.09911, 33.77677], [-118.09895, 33.77678], [-118.09833, 33.77779], [-118.09836, 33.7755], [-118.09894, 33.77631], [-118.09912, 33.77631]]]} | Open Access 1 | College Estates Park | 17500 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 2.301 | College Estates Park | ||
3089 | 3089 | 3088 | {"type": "Polygon", "coordinates": [[[-119.16371, 34.16633], [-119.1637, 34.16789], [-119.16212, 34.16788], [-119.16206, 34.16785], [-119.16204, 34.16782], [-119.16205, 34.16656], [-119.16205, 34.16636], [-119.16207, 34.16633], [-119.16209, 34.16632], [-119.16371, 34.16633]]]} | Open Access 1 | College Estates Park | 17501 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 6.527 | College Estates Park | ||
3090 | 3090 | 3089 | {"type": "Polygon", "coordinates": [[[-120.83251, 37.0478], [-120.8325, 37.04919], [-120.83102, 37.0492], [-120.83096, 37.04915], [-120.83095, 37.04844], [-120.83092, 37.04831], [-120.83088, 37.04825], [-120.83085, 37.04816], [-120.8313, 37.04813], [-120.83133, 37.04778], [-120.83251, 37.0478]]]} | Open Access 1 | College Green Park | 17503 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 5.009 | College Green Park | ||
3091 | 3091 | 3090 | {"type": "Polygon", "coordinates": [[[-122.04506, 37.65547], [-122.04503, 37.65551], [-122.04411, 37.65578], [-122.04333, 37.65598], [-122.04326, 37.65535], [-122.04327, 37.65533], [-122.04349, 37.65521], [-122.04358, 37.65514], [-122.04367, 37.65502], [-122.04374, 37.65486], [-122.04377, 37.65484], [-122.044, 37.65483], [-122.04414, 37.65481], [-122.04427, 37.65477], [-122.0445, 37.65467], [-122.04456, 37.65475], [-122.04463, 37.65513], [-122.04497, 37.65514], [-122.04499, 37.65533], [-122.04506, 37.65547]]]} | Open Access 1 | College Heights Park | 17504 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 3.294 | College Heights Park | ||
3092 | 3092 | 3091 | {"type": "Polygon", "coordinates": [[[-118.96741, 35.41248], [-118.96739, 35.41252], [-118.96733, 35.41253], [-118.96588, 35.41225], [-118.96567, 35.41223], [-118.96329, 35.41223], [-118.96325, 35.41219], [-118.96325, 35.41066], [-118.96331, 35.41062], [-118.96736, 35.41061], [-118.9674, 35.41065], [-118.96741, 35.41248]], [[-118.96437, 35.41145], [-118.96436, 35.41144], [-118.96398, 35.41144], [-118.96397, 35.41159], [-118.96436, 35.4116], [-118.96437, 35.41145]]]} | Open Access 1 | College Park | 17505 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 17.168 | College Park | ||
3093 | 3093 | 3092 | {"type": "Polygon", "coordinates": [[[-117.71447, 34.09304], [-117.71321, 34.09303], [-117.7132, 34.09279], [-117.71306, 34.09278], [-117.71304, 34.09303], [-117.7127, 34.09304], [-117.7127, 34.09382], [-117.71006, 34.09381], [-117.71007, 34.09306], [-117.71017, 34.09291], [-117.71021, 34.09275], [-117.71446, 34.09268], [-117.71447, 34.09304]]]} | Open Access 1 | College Park | 17506 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | City 2 | 8.582 | College Park | ||
3094 | 3094 | 3093 | {"type": "Polygon", "coordinates": [[[-121.75127, 38.54762], [-121.75021, 38.54761], [-121.75021, 38.54761], [-121.75024, 38.54751], [-121.75032, 38.54742], [-121.7507, 38.5472], [-121.75085, 38.54718], [-121.75111, 38.54725], [-121.75118, 38.5473], [-121.75125, 38.54745], [-121.75127, 38.54762]]]} | Open Access 1 | College Park | 17507 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 0.816 | College Park | ||
3095 | 3095 | 3094 | {"type": "Polygon", "coordinates": [[[-117.79666, 33.70592], [-117.79664, 33.70598], [-117.79635, 33.70627], [-117.79619, 33.70614], [-117.79468, 33.70508], [-117.79443, 33.70532], [-117.79308, 33.7044], [-117.79318, 33.70427], [-117.79187, 33.70334], [-117.79207, 33.70313], [-117.79214, 33.70311], [-117.79243, 33.70331], [-117.79264, 33.70349], [-117.79273, 33.70352], [-117.7928, 33.70351], [-117.79285, 33.70349], [-117.79292, 33.70342], [-117.79295, 33.70343], [-117.79348, 33.7038], [-117.79351, 33.70381], [-117.79358, 33.7039], [-117.7937, 33.70395], [-117.79381, 33.70402], [-117.79392, 33.7041], [-117.79402, 33.70421], [-117.79409, 33.70424], [-117.79418, 33.70425], [-117.79419, 33.70428], [-117.79472, 33.70465], [-117.79486, 33.70463], [-117.79492, 33.7047], [-117.79514, 33.70481], [-117.79662, 33.70585], [-117.79666, 33.70592]]]} | Open Access 1 | College Park | 17508 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 7.421 | College Park | ||
3096 | 3096 | 3095 | {"type": "Polygon", "coordinates": [[[-117.20187, 33.88492], [-117.2018, 33.88527], [-117.20042, 33.88512], [-117.19991, 33.88513], [-117.19955, 33.88521], [-117.19918, 33.88533], [-117.19887, 33.88551], [-117.19816, 33.88599], [-117.19788, 33.88627], [-117.19772, 33.88652], [-117.19751, 33.88627], [-117.19725, 33.8861], [-117.19692, 33.88591], [-117.19683, 33.88575], [-117.19714, 33.88561], [-117.19738, 33.88546], [-117.19799, 33.88517], [-117.19816, 33.88508], [-117.19837, 33.88486], [-117.19849, 33.88468], [-117.19859, 33.88457], [-117.19868, 33.8845], [-117.19878, 33.88446], [-117.19892, 33.88446], [-117.19919, 33.88452], [-117.1995, 33.88457], [-117.19982, 33.88459], [-117.2001, 33.88458], [-117.20077, 33.88457], [-117.20186, 33.88486], [-117.20187, 33.88492]]]} | Open Access 1 | College Park | 17510 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 8.921 | College Park | ||
3097 | 3097 | 3096 | {"type": "Polygon", "coordinates": [[[-119.15987, 34.17319], [-119.15982, 34.17321], [-119.15901, 34.17321], [-119.15889, 34.17311], [-119.15891, 34.17266], [-119.15866, 34.17237], [-119.1583, 34.17222], [-119.15652, 34.17235], [-119.1517, 34.1696], [-119.15172, 34.16795], [-119.15919, 34.168], [-119.15921, 34.16808], [-119.15937, 34.16808], [-119.15942, 34.16812], [-119.15975, 34.16896], [-119.15986, 34.16936], [-119.15991, 34.16971], [-119.15992, 34.17006], [-119.15989, 34.17315], [-119.15987, 34.17319]]]} | Open Access 1 | College Park | 17511 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 74.898 | College Park | ||
3098 | 3098 | 3097 | {"type": "Polygon", "coordinates": [[[-117.99996, 33.73891], [-117.99964, 33.73891], [-117.99932, 33.73914], [-117.9991, 33.73934], [-117.99859, 33.73889], [-117.99857, 33.7375], [-117.99908, 33.7375], [-117.99908, 33.73789], [-117.99928, 33.73813], [-117.99961, 33.73829], [-117.99995, 33.73829], [-117.99996, 33.73891]]]} | Open Access 1 | College Park | 17512 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 3.925 | College Park | ||
3099 | 3099 | 3098 | {"type": "Polygon", "coordinates": [[[-122.70518, 38.4452], [-122.70488, 38.44513], [-122.70485, 38.44509], [-122.70485, 38.44504], [-122.70498, 38.44494], [-122.70518, 38.4452]]]} | Open Access 1 | College Triangle Park | 17513 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 0.094 | College Triangle Park | ||
3100 | 3100 | 3099 | {"type": "Polygon", "coordinates": [[[-122.28568, 37.52012], [-122.28563, 37.52031], [-122.28561, 37.52033], [-122.28527, 37.52024], [-122.28529, 37.52022], [-122.28566, 37.52011], [-122.28568, 37.52012]]]} | Open Access 1 | College View Park | 17514 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 0.113 | College View Park | ||
3101 | 3101 | 3100 | {"type": "Polygon", "coordinates": [[[-118.01229, 33.72641], [-118.0119, 33.72641], [-118.01192, 33.72613], [-118.0119, 33.72607], [-118.01186, 33.72601], [-118.0118, 33.72598], [-118.01173, 33.72596], [-118.01142, 33.72599], [-118.01138, 33.72597], [-118.01136, 33.72594], [-118.01136, 33.72567], [-118.01141, 33.72551], [-118.01146, 33.72541], [-118.01169, 33.72513], [-118.01177, 33.72497], [-118.01181, 33.72481], [-118.01186, 33.72477], [-118.01215, 33.72476], [-118.01215, 33.72503], [-118.01227, 33.72504], [-118.01229, 33.72641]]]} | Open Access 1 | College View Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/college-view-park.cfm | 17515 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 2.594 | College View Park | |
3102 | 3102 | 3101 | {"type": "Polygon", "coordinates": [[[-118.84198, 34.29485], [-118.84175, 34.29544], [-118.84186, 34.29549], [-118.84166, 34.29591], [-118.84047, 34.29591], [-118.8404, 34.29587], [-118.84039, 34.29576], [-118.84044, 34.29557], [-118.84094, 34.29433], [-118.84168, 34.29469], [-118.84194, 34.29475], [-118.84198, 34.29485]]]} | Open Access 1 | College View Park | 17516 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 4.318 | College View Park | ||
3103 | 3103 | 3102 | {"type": "Polygon", "coordinates": [[[-117.48066, 33.91287], [-117.48064, 33.91295], [-117.47958, 33.9135], [-117.47841, 33.91207], [-117.47877, 33.91192], [-117.47881, 33.91196], [-117.47887, 33.91198], [-117.47899, 33.91197], [-117.47904, 33.91192], [-117.47912, 33.9118], [-117.4792, 33.91173], [-117.47953, 33.91154], [-117.47959, 33.91155], [-117.48066, 33.91287]]]} | Open Access 1 | Collett Park | 17517 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 5.616 | Collett Park | ||
3104 | 3104 | 3103 | {"type": "Polygon", "coordinates": [[[-122.45638, 37.68223], [-122.45632, 37.68224], [-122.45604, 37.68209], [-122.4562, 37.68199], [-122.45636, 37.68214], [-122.45638, 37.68223]]]} | Open Access 1 | Colma Historical | 17523 | 1456 | Colma, City of 934 | City 2 | City Agency 2 | http://www.colma.ca.gov/ | City 2 | 0.098 | Colma Historical |
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]);