superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13,512 rows where ACCESS_TYP = 1
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 346
- San Diego, City of 345
- California Department of Fish and Wildlife 208
- San Jose, City of 177
- San Francisco, City and County of 165
- Sacramento, City of 163
- Ventura, City of 141
- California Department of Parks and Recreation 139
- Los Angeles, County of 117
- Long Beach, City of 111
- Mountains Recreation and Conservation Authority 110
- Roseville, City of 97
- San Diego, County of 91
- Oakland, City of 83
- Irvine, City of 80
- Fresno, City of 78
- Consumnes Community Services District 76
- Huntington Beach, City of 61
- Orange, County of 61
- Santa Barbara, County of 59
- Hayward Area Recreation and Park District 59
- Poway, City of 58
- Stockton, City of 58
- Tracy, City of 57
- Santa Cruz, City of 55
- Chula Vista, City of 55
- Modesto, City of 54
- Lake, County of 53
- Encinitas, City of 51
- Davis, City of 51
- …
MNG_AG_TYP 28
- City Agency 7,381
- County Agency 728
- Recreation/Parks District 668
- State Agency 418
- Community Services District 147
- County Agency - Parks 146
- Open Space District 139
- Non Profit - Land Trust 127
- Federal Agency 97
- Water District 69
- Cemetery District 46
- Non Profit - Conservation 39
- Flood District 29
- Port/Harbor District 27
- Non Profit - Other 27
- County Agency - Other 14
- Irrigation District 6
- Special District - Other 6
- Sanitation District 5
- Non Profit - Cemetery District 5
- Joint Powers Authority 2
- Other 2
- Conservation District 2
- Non Profit - Education 2
- Airport District 1
- Metropolitan Planning Organization 1
- Utility 1
- Transportation Agency 1
ACCESS_TYP 1
- Open Access · 10,136 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3817 | 3817 | 3816 | {"type": "Polygon", "coordinates": [[[-119.29971, 34.28152], [-119.2996, 34.28215], [-119.2993, 34.28211], [-119.29919, 34.28195], [-119.29903, 34.28195], [-119.299, 34.28177], [-119.29904, 34.28154], [-119.29917, 34.28154], [-119.29919, 34.28146], [-119.29971, 34.28152]]]} | Open Access 1 | Eastwood Park | 18404 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.918 | Eastwood Park | ||
3818 | 3818 | 3817 | {"type": "Polygon", "coordinates": [[[-122.54672, 37.88164], [-122.54632, 37.88222], [-122.54589, 37.88254], [-122.54547, 37.88191], [-122.54505, 37.88169], [-122.54439, 37.88158], [-122.54375, 37.88128], [-122.54384, 37.88108], [-122.54411, 37.88099], [-122.54487, 37.88104], [-122.54549, 37.88137], [-122.54632, 37.88105], [-122.54637, 37.88107], [-122.54665, 37.88126], [-122.54672, 37.88164]]]} | Open Access 1 | Eastwood Park | 18405 | 2261 | Tamalpais Community Services District 708 | Special District 4 | Community Services District 17 | http://www.tcsd.us/ | Special District 4 | 5.017 | Eastwood Park | ||
3819 | 3819 | 3818 | {"type": "Polygon", "coordinates": [[[-118.08707, 34.14127], [-118.08706, 34.1421], [-118.08635, 34.14211], [-118.08635, 34.14204], [-118.08628, 34.14203], [-118.08607, 34.14179], [-118.08603, 34.14173], [-118.08594, 34.14163], [-118.08453, 34.14025], [-118.08436, 34.14002], [-118.08426, 34.13981], [-118.08387, 34.13867], [-118.08386, 34.13849], [-118.08413, 34.13849], [-118.08414, 34.1389], [-118.08447, 34.1389], [-118.08445, 34.13992], [-118.08449, 34.14005], [-118.08458, 34.14016], [-118.0847, 34.14024], [-118.08486, 34.14028], [-118.08596, 34.14027], [-118.08595, 34.14115], [-118.0861, 34.14128], [-118.08707, 34.14127]]]} | Open Access 1 | Eaton Blanche Park | http://www.cityofpasadena.net/PublicWorks/Eaton_Blanche_Park/ | 18406 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 5.79 | Eaton Blanche Park | |
3820 | 3820 | 3819 | {"type": "Polygon", "coordinates": [[[-122.28216, 37.48306], [-122.28213, 37.48341], [-122.28125, 37.48399], [-122.28098, 37.48407], [-122.28012, 37.48408], [-122.27956, 37.48417], [-122.27897, 37.48435], [-122.27847, 37.48457], [-122.27684, 37.48566], [-122.27673, 37.48548], [-122.27626, 37.48571], [-122.27552, 37.48575], [-122.27487, 37.48656], [-122.27458, 37.4865], [-122.2745, 37.48663], [-122.27439, 37.48677], [-122.27428, 37.48687], [-122.27401, 37.48704], [-122.27265, 37.4858], [-122.27186, 37.48639], [-122.27102, 37.48642], [-122.27109, 37.48583], [-122.27075, 37.48584], [-122.27014, 37.48553], [-122.26998, 37.48542], [-122.26985, 37.48526], [-122.26982, 37.48512], [-122.26986, 37.48499], [-122.26994, 37.4849], [-122.26999, 37.48503], [-122.27023, 37.48497], [-122.27018, 37.48461], [-122.27027, 37.48455], [-122.2703, 37.4845], [-122.2703, 37.48445], [-122.27027, 37.4844], [-122.27022, 37.48435], [-122.27009, 37.48433], [-122.26975, 37.48379], [-122.26969, 37.48369], [-122.26984, 37.48362], [-122.26984, 37.48351], [-122.26959, 37.48313], [-122.26957, 37.48306], [-122.26952, 37.48301], [-122.26946, 37.48298], [-122.26937, 37.48297], [-122.2693, 37.48298], [-122.26907, 37.48253], [-122.2691, 37.48232], [-122.27137, 37.48247], [-122.27265, 37.48204], [-122.27293, 37.48224], [-122.27387, 37.48258], [-122.27414, 37.48276], [-122.27434, 37.48286], [-122.27428, 37.48296], [-122.27457, 37.4833], [-122.27501, 37.48346], [-122.27515, 37.48338], [-122.27538, 37.48358], [-122.27536, 37.48394], [-122.27546, 37.48419], [-122.2757, 37.48438], [-122.27653, 37.4849], [-122.27736, 37.48388], [-122.27793, 37.48391], [-122.27875, 37.48321], [-122.27959, 37.48341], [-122.28, 37.48339], [-122.28018, 37.48301], [-122.28045, 37.483], [-122.2806, 37.48301], [-122.28093, 37.4831], [-122.28086, 37.48332], [-122.28119, 37.48355], [-122.28182, 37.48346], [-122.28207, 37.48326], [-122.28209, 37.48307], [-122.28216, 37.48306]]]} | Open Access 1 | Eaton Park | 18411 | 1295 | San Carlos, City of 432 | City 2 | City Agency 2 | http://www.cityofsancarlos.org/depts/pr/default.asp | City 2 | 65.363 | Eaton Park | 1969 | |
3821 | 3821 | 3820 | {"type": "Polygon", "coordinates": [[[-119.78805, 36.73876], [-119.78766, 36.73903], [-119.78676, 36.73821], [-119.78714, 36.73794], [-119.78805, 36.73876]]]} | Open Access 1 | Eaton Plaza | 18412 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1.378 | Eaton Plaza | ||
3822 | 3822 | 3821 | {"type": "Polygon", "coordinates": [[[-121.80841, 39.76956], [-121.80823, 39.76957], [-121.80747, 39.77004], [-121.80747, 39.77006], [-121.80758, 39.77016], [-121.80642, 39.76929], [-121.80643, 39.76853], [-121.80708, 39.76853], [-121.80745, 39.7689], [-121.80751, 39.76892], [-121.80751, 39.76895], [-121.80766, 39.76908], [-121.80801, 39.76933], [-121.80841, 39.76956]]]} | Open Access 1 | Eaton Road Preserve | 18413 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 3.754 | Eaton Road Preserve | ||
3823 | 3823 | 3822 | {"type": "Polygon", "coordinates": [[[-120.6932, 35.16643], [-120.69269, 35.16666], [-120.69224, 35.16612], [-120.69268, 35.16592], [-120.6929, 35.16617], [-120.69292, 35.16624], [-120.69296, 35.16631], [-120.69304, 35.16636], [-120.6932, 35.16643]]]} | Open Access 1 | Ebb Tide Park | 18415 | 1253 | Pismo Beach, City of 417 | City 2 | City Agency 2 | http://www.pismobeach.org/69/Parks-Halls | City 2 | 0.813 | Ebb Tide Park | ||
3824 | 3824 | 3823 | {"type": "Polygon", "coordinates": [[[-119.06569, 34.35201], [-119.0652, 34.35216], [-119.06493, 34.35158], [-119.06533, 34.35146], [-119.06546, 34.35151], [-119.06569, 34.35201]]]} | Open Access 1 | Ebell Park | 18416 | 1674 | Santa Paula, City of 186 | City 2 | City Agency 2 | http://www.ci.santa-paula.ca.us/ | City 2 | 0.804 | Ebell Park | ||
3827 | 3827 | 3826 | {"type": "Polygon", "coordinates": [[[-117.89958, 33.76217], [-117.89942, 33.76258], [-117.89938, 33.76277], [-117.89924, 33.76363], [-117.89922, 33.76392], [-117.89854, 33.76383], [-117.89853, 33.76343], [-117.89856, 33.76335], [-117.89876, 33.76312], [-117.89885, 33.76298], [-117.89887, 33.76283], [-117.89891, 33.76271], [-117.89947, 33.76213], [-117.89958, 33.76217]]]} | Open Access 1 | Edna Park | 18451 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 2.29 | Edna Park | ||
3828 | 3828 | 3827 | {"type": "MultiPolygon", "coordinates": [[[[-118.02678, 34.14829], [-118.02546, 34.14831], [-118.02542, 34.14582], [-118.02556, 34.14582], [-118.02561, 34.14591], [-118.02569, 34.14602], [-118.02628, 34.14738], [-118.02639, 34.14739], [-118.02678, 34.14829]]], [[[-118.02669, 34.14612], [-118.02669, 34.14614], [-118.02638, 34.14616], [-118.02639, 34.14695], [-118.02597, 34.14598], [-118.02608, 34.14575], [-118.02607, 34.1457], [-118.02629, 34.14579], [-118.02631, 34.14593], [-118.02669, 34.14612]]]]} | Open Access 1 | Eisenhower Memorial Park | 18472 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 5.385 | Eisenhower Memorial Park | ||
3829 | 3829 | 3828 | {"type": "Polygon", "coordinates": [[[-117.21501, 33.59236], [-117.21477, 33.5923], [-117.21456, 33.59232], [-117.21445, 33.59236], [-117.21437, 33.59241], [-117.21425, 33.59255], [-117.21422, 33.59264], [-117.21421, 33.59274], [-117.21423, 33.59284], [-117.21427, 33.59293], [-117.21434, 33.59301], [-117.21476, 33.59338], [-117.2143, 33.59375], [-117.21415, 33.59432], [-117.21381, 33.59458], [-117.21363, 33.5947], [-117.21353, 33.59459], [-117.21337, 33.59411], [-117.21338, 33.59388], [-117.21304, 33.59323], [-117.21289, 33.59312], [-117.21307, 33.59294], [-117.21312, 33.59286], [-117.21314, 33.59278], [-117.21314, 33.59268], [-117.21312, 33.5926], [-117.21307, 33.59251], [-117.21301, 33.59243], [-117.21288, 33.59235], [-117.21276, 33.59231], [-117.21258, 33.5923], [-117.21242, 33.59234], [-117.21232, 33.5924], [-117.21224, 33.59247], [-117.21177, 33.59307], [-117.21164, 33.593], [-117.21226, 33.59228], [-117.21262, 33.59195], [-117.21262, 33.59194], [-117.2124, 33.59195], [-117.21225, 33.59199], [-117.21211, 33.59207], [-117.21198, 33.59219], [-117.21173, 33.59249], [-117.21168, 33.59269], [-117.21153, 33.59293], [-117.21122, 33.59263], [-117.21105, 33.59242], [-117.21096, 33.59227], [-117.21126, 33.59214], [-117.21104, 33.59175], [-117.21118, 33.59169], [-117.21166, 33.59155], [-117.21187, 33.59139], [-117.21195, 33.59115], [-117.2119, 33.59097], [-117.21176, 33.59082], [-117.21148, 33.59073], [-117.21122, 33.59077], [-117.21055, 33.59105], [-117.21086, 33.59078], [-117.21124, 33.59055], [-117.21165, 33.59027], [-117.21299, 33.58924], [-117.2137, 33.58989], [-117.21337, 33.59015], [-117.21352, 33.5903], [-117.21363, 33.59033], [-117.21358, 33.59042], [-117.21359, 33.5905], [-117.21364, 33.59058], [-117.21374, 33.59065], [-117.21352, 33.59089], [-117.21364, 33.59101], [-117.2136, 33.59106], [-117.21501, 33.59236]]]} | Open Access 1 | Echo Canyon Park | 18419 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 23.421 | Echo Canyon Park | ||
3830 | 3830 | 3829 | {"type": "Polygon", "coordinates": [[[-120.57104, 34.97032], [-120.57096, 34.97044], [-120.57051, 34.97024], [-120.57058, 34.97012], [-120.57104, 34.97032]]]} | Open Access 1 | Guadalupe holding 10 | 19546 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.174 | Guadalupe holding 10 | |||
3831 | 3831 | 3830 | {"type": "Polygon", "coordinates": [[[-120.58052, 34.96254], [-120.58034, 34.96267], [-120.57983, 34.9626], [-120.57981, 34.9625], [-120.58012, 34.96231], [-120.58041, 34.96249], [-120.58052, 34.96254]]]} | Open Access 1 | Guadalupe holding 2 | 19547 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.371 | Guadalupe holding 2 | |||
3832 | 3832 | 3831 | {"type": "Polygon", "coordinates": [[[-120.5712, 34.97007], [-120.57104, 34.97032], [-120.57058, 34.97012], [-120.5709, 34.96963], [-120.57109, 34.96971], [-120.57095, 34.96996], [-120.5712, 34.97007]]]} | Open Access 1 | Guadalupe holding 3 | 19548 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.517 | Guadalupe holding 3 | |||
3833 | 3833 | 3832 | {"type": "Polygon", "coordinates": [[[-120.57089, 34.97056], [-120.57073, 34.9708], [-120.57028, 34.97061], [-120.57051, 34.97024], [-120.57088, 34.9704], [-120.57082, 34.97051], [-120.57089, 34.97056]]]} | Open Access 1 | Guadalupe holding 4 | 19549 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.501 | Guadalupe holding 4 | |||
3834 | 3834 | 3833 | {"type": "Polygon", "coordinates": [[[-120.58072, 34.9624], [-120.58052, 34.96254], [-120.58041, 34.96249], [-120.58049, 34.96217], [-120.58062, 34.96216], [-120.58072, 34.9624]]]} | Open Access 1 | Guadalupe holding 5 | 19550 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.189 | Guadalupe holding 5 | |||
3835 | 3835 | 3834 | {"type": "MultiPolygon", "coordinates": [[[[-118.2613, 34.07601], [-118.26125, 34.07604], [-118.2612, 34.07602], [-118.26112, 34.07591], [-118.26102, 34.07582], [-118.26081, 34.07569], [-118.26037, 34.07551], [-118.25977, 34.07536], [-118.25903, 34.07504], [-118.25894, 34.07498], [-118.25888, 34.0749], [-118.25884, 34.07481], [-118.25882, 34.07471], [-118.25883, 34.07463], [-118.25887, 34.07454], [-118.25975, 34.07314], [-118.26013, 34.07126], [-118.25977, 34.07004], [-118.26122, 34.07068], [-118.26127, 34.07161], [-118.26159, 34.07307], [-118.26147, 34.07551], [-118.26144, 34.07566], [-118.26139, 34.07583], [-118.2613, 34.07601]]], [[[-118.26027, 34.06816], [-118.25981, 34.0689], [-118.25922, 34.06869], [-118.25963, 34.068], [-118.26026, 34.06813], [-118.26027, 34.06816]]], [[[-118.26098, 34.06919], [-118.26054, 34.06907], [-118.26011, 34.06902], [-118.26, 34.06897], [-118.26049, 34.06818], [-118.26075, 34.06823], [-118.26098, 34.06919]]]]} | Open Access 1 | Echo Park | 18420 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 26.703 | Echo Park | ||
3837 | 3837 | 3836 | {"type": "Polygon", "coordinates": [[[-118.09204, 33.87619], [-118.09159, 33.8762], [-118.09157, 33.87591], [-118.09149, 33.87562], [-118.09116, 33.87468], [-118.09115, 33.87461], [-118.09117, 33.87459], [-118.09117, 33.87417], [-118.09142, 33.87482], [-118.09146, 33.87483], [-118.09179, 33.87547], [-118.09204, 33.87619]]]} | Open Access 1 | Ecology Park | 18422 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1.382 | Ecology Park | ||
3838 | 3838 | 3837 | {"type": "Polygon", "coordinates": [[[-121.15031, 38.67504], [-121.15026, 38.67659], [-121.15029, 38.67661], [-121.15029, 38.67829], [-121.14833, 38.67827], [-121.14833, 38.67783], [-121.14832, 38.67773], [-121.14825, 38.67755], [-121.14811, 38.67737], [-121.14855, 38.67711], [-121.14855, 38.67707], [-121.14857, 38.67705], [-121.14833, 38.67661], [-121.14442, 38.6766], [-121.14442, 38.67481], [-121.14733, 38.67377], [-121.14777, 38.67356], [-121.14817, 38.67332], [-121.14919, 38.67436], [-121.14985, 38.67401], [-121.15031, 38.67389], [-121.15031, 38.67504]]]} | Open Access 1 | Ed Mitchell Park | 18423 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 43.359 | Ed Mitchell Park | ||
3839 | 3839 | 3838 | {"type": "Polygon", "coordinates": [[[-114.60887, 34.84403], [-114.60794, 34.84403], [-114.60775, 34.84394], [-114.60799, 34.84357], [-114.60647, 34.84285], [-114.60713, 34.84191], [-114.60887, 34.84274], [-114.60887, 34.84403]]]} | Open Access 1 | Ed Parry Park | 18424 | 1220 | Needles, City of 276 | City 2 | City Agency 2 | http://www.cityofneedles.com/Pages/Departments-Services/Parks/Parks.html | City 2 | 7.205 | Ed Parry 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]);