units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,925 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 2 sorted by PARK_URL descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP
These facets timed out: DES_TP
MNG_AGENCY >30
- San Diego, City of 503
- Los Angeles, City of 432
- San Jose, City of 247
- San Francisco, City and County of 238
- Sacramento, City of 216
- Ventura, City of 149
- Long Beach, City of 135
- Roseville, City of 123
- Oakland, City of 122
- Irvine, City of 100
- Fresno, City of 92
- Modesto, City of 78
- Stockton, City of 77
- Huntington Beach, City of 76
- Tracy, City of 73
- Santa Rosa, City of 72
- Chula Vista, City of 68
- Brentwood, City of 68
- Napa, City of 67
- Santa Cruz, City of 65
- Newport Beach, City of 65
- Poway, City of 64
- San Luis Obispo, City of 63
- Davis, City of 62
- Clovis, City of 61
- Manteca, City of 60
- Anaheim, City of 59
- Glendale, City of 59
- Riverside, City of 59
- Bakersfield, City of 59
- …
MNG_AG_TYP 1
- City Agency · 9,925 ✖
ACCESS_TYP 1
- Open Access · 9,925 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3110 | 3110 | 3109 | {"type": "Polygon", "coordinates": [[[-118.368, 34.09588], [-118.36753, 34.09588], [-118.36753, 34.09577], [-118.36799, 34.09577], [-118.368, 34.09588]]]} | Open Access 1 | 47991 | Havenhurst Park | 32412 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1375 | West Hollywood, City of 331 | City 2 | City Agency 2 | https://www.weho.org/Home/Components/FacilityDirectory/FacilityDirectory/19/773 | Los Angeles 6 | 0.129 | Havenhurst Park | 0 | Local Park 2 | 4 | |
11164 | 11164 | 11163 | {"type": "Polygon", "coordinates": [[[-118.34615, 34.09177], [-118.34615, 34.09186], [-118.34569, 34.09186], [-118.3457, 34.09177], [-118.34615, 34.09177]]]} | Open Access 1 | 47993 | Formosa Park | 32414 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1375 | West Hollywood, City of 331 | City 2 | City Agency 2 | https://www.weho.org/Home/Components/FacilityDirectory/FacilityDirectory/17/773 | Los Angeles 6 | 0.105 | Formosa Park | 2008 | Local Park 2 | 4 | |
10599 | 10599 | 10598 | {"type": "Polygon", "coordinates": [[[-122.44502, 37.45285], [-122.44494, 37.45344], [-122.44494, 37.45451], [-122.445, 37.45532], [-122.44411, 37.45541], [-122.44406, 37.4546], [-122.44284, 37.45476], [-122.4428, 37.4546], [-122.44263, 37.45462], [-122.44257, 37.45432], [-122.44041, 37.4546], [-122.43992, 37.4531], [-122.43998, 37.45304], [-122.43987, 37.4527], [-122.44219, 37.45241], [-122.44233, 37.45225], [-122.44492, 37.45192], [-122.44504, 37.4527], [-122.44502, 37.45285]]]} | Open Access 1 | 48637 | Poplar Beach | 33340 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 1128 | Half Moon Bay, City of 433 | City 2 | City Agency 2 | https://www.visithalfmoonbay.org/discover/poplar-beach | San Mateo 15 | 28.39 | Poplar Beach | 0 | Local Park 2 | 4 |
10621 | 10621 | 10620 | {"type": "Polygon", "coordinates": [[[-122.44604, 37.46514], [-122.44474, 37.46502], [-122.4448, 37.46461], [-122.44379, 37.46451], [-122.44452, 37.45959], [-122.44451, 37.45958], [-122.44382, 37.45967], [-122.44354, 37.45826], [-122.44345, 37.45827], [-122.44343, 37.45813], [-122.44351, 37.45811], [-122.44284, 37.45476], [-122.44407, 37.4546], [-122.44411, 37.45541], [-122.445, 37.45532], [-122.44514, 37.45654], [-122.44514, 37.45732], [-122.44526, 37.45784], [-122.44528, 37.45827], [-122.44461, 37.45834], [-122.4446, 37.45835], [-122.44481, 37.45961], [-122.445, 37.45984], [-122.4452, 37.46089], [-122.44544, 37.46227], [-122.44546, 37.46308], [-122.44557, 37.46346], [-122.44573, 37.46377], [-122.44593, 37.46432], [-122.44604, 37.46514]]]} | Open Access 1 | 48636 | Poplar Beach | 33340 | 1128 | Half Moon Bay, City of 439 | City 2 | City Agency 2 | http://www.half-moon-bay.ca.us/ | City 2 | 1128 | Half Moon Bay, City of 433 | City 2 | City Agency 2 | https://www.visithalfmoonbay.org/discover/poplar-beach | San Mateo 15 | 35.36 | Poplar Beach | 0 | Local Park 2 | 4 |
11453 | 11453 | 11452 | {"type": "Polygon", "coordinates": [[[-119.64146, 36.86082], [-119.64061, 36.86083], [-119.64054, 36.86081], [-119.64033, 36.86071], [-119.64039, 36.86063], [-119.64038, 36.86058], [-119.64034, 36.86054], [-119.64039, 36.86048], [-119.64043, 36.86049], [-119.64051, 36.8604], [-119.64048, 36.86038], [-119.64055, 36.86031], [-119.64068, 36.86025], [-119.64076, 36.86015], [-119.64076, 36.86006], [-119.64074, 36.85999], [-119.64069, 36.85994], [-119.6406, 36.85989], [-119.64045, 36.85988], [-119.64032, 36.85992], [-119.64025, 36.86], [-119.64022, 36.8601], [-119.64016, 36.86016], [-119.64014, 36.86015], [-119.64003, 36.86026], [-119.64004, 36.86027], [-119.63998, 36.86031], [-119.63993, 36.86029], [-119.63989, 36.86028], [-119.63977, 36.86035], [-119.63963, 36.86019], [-119.63964, 36.86015], [-119.64081, 36.85949], [-119.64109, 36.85938], [-119.64137, 36.85932], [-119.64141, 36.85934], [-119.64141, 36.85936], [-119.64144, 36.85937], [-119.64146, 36.86082]]]} | Open Access 1 | 48696 | Harlan Ranch Community Park | 33431 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | https://www.visitclovis.com/clovis-parks/ | Fresno 9 | 3.576 | Harlan Ranch Community Park | 0 | Local Park 2 | 4 |
12662 | 12662 | 12661 | {"type": "Polygon", "coordinates": [[[-121.20155, 37.78832], [-121.20155, 37.78832], [-121.19838, 37.78833], [-121.20016, 37.78641], [-121.20028, 37.78642], [-121.20056, 37.78639], [-121.20061, 37.78634], [-121.2015, 37.78686], [-121.20155, 37.78832]]]} | Open Access 1 | 48800 | Spreckels Park BMX | 33522 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | https://www.usabmx.com/tracks/1770/pages/24 | San Joaquin 39 | 9.989 | Spreckels Park BMX | None 1098 | ||
1062 | 1062 | 1061 | {"type": "MultiPolygon", "coordinates": [[[[-118.45673, 35.11371], [-118.45597, 35.11371], [-118.45593, 35.11377], [-118.45581, 35.11377], [-118.45578, 35.11371], [-118.45496, 35.11372], [-118.45493, 35.11377], [-118.45481, 35.11377], [-118.45478, 35.11372], [-118.45396, 35.11372], [-118.45393, 35.11377], [-118.45381, 35.11378], [-118.45377, 35.11372], [-118.4533, 35.11373], [-118.4533, 35.11405], [-118.45325, 35.1142], [-118.45294, 35.11456], [-118.45264, 35.11437], [-118.45246, 35.11418], [-118.45238, 35.11404], [-118.45233, 35.11388], [-118.45231, 35.11363], [-118.45234, 35.11342], [-118.45246, 35.11307], [-118.45265, 35.11274], [-118.45281, 35.11254], [-118.45313, 35.11274], [-118.45334, 35.11296], [-118.45335, 35.11356], [-118.45376, 35.11356], [-118.45378, 35.11354], [-118.45388, 35.11355], [-118.45395, 35.11353], [-118.45397, 35.11355], [-118.45476, 35.11355], [-118.45478, 35.11353], [-118.45488, 35.11355], [-118.45495, 35.11353], [-118.45497, 35.11355], [-118.45573, 35.11355], [-118.45575, 35.11353], [-118.45582, 35.11354], [-118.45592, 35.11353], [-118.45594, 35.11354], [-118.45672, 35.11354], [-118.45673, 35.11371]]], [[[-118.45822, 35.1139], [-118.45803, 35.11388], [-118.45779, 35.11378], [-118.45764, 35.11374], [-118.45703, 35.11373], [-118.45698, 35.11369], [-118.45698, 35.11358], [-118.45822, 35.11358], [-118.45822, 35.1139]]]]} | Open Access 1 | 48916 | Warrior Park | 33637 | 1467 | Tehachapi, City of 310 | City 2 | City Agency 2 | http://www.tehachapicityhall.com/ | City 2 | 1467 | Tehachapi, City of 307 | City 2 | City Agency 2 | https://www.tvrpd.org/ | Kern 36 | 5.909 | Warrior Park | 0 | Local Park 2 | 4 |
14220 | 14220 | 14219 | {"type": "Polygon", "coordinates": [[[-117.81871, 33.70241], [-117.81877, 33.70265], [-117.81878, 33.70282], [-117.81875, 33.70298], [-117.81862, 33.70333], [-117.81797, 33.70315], [-117.81755, 33.70299], [-117.81691, 33.70264], [-117.81689, 33.70253], [-117.81721, 33.70226], [-117.81758, 33.70204], [-117.81798, 33.70187], [-117.8183, 33.70178], [-117.8184, 33.70183], [-117.81843, 33.70182], [-117.81845, 33.70186], [-117.81843, 33.70189], [-117.81854, 33.70221], [-117.81852, 33.70225], [-117.81856, 33.70238], [-117.81863, 33.70238], [-117.81865, 33.70242], [-117.81871, 33.70241]]]} | Open Access 1 | 48852 | Victory Park | 33572 | 1360 | Tustin, City of 278 | City 2 | City Agency 2 | http://www.tustinca.org/departments/parksrec/index.html | City 2 | 1360 | Tustin, City of 274 | City 2 | City Agency 2 | https://www.tustinca.org/Facilities/Facility/Details/Victory-Park-6 | Orange 3 | 4.505 | Victory Park | 0 | Local Park 2 | 4 |
14131 | 14131 | 14130 | {"type": "Polygon", "coordinates": [[[-119.32522, 36.15647], [-119.32197, 36.1564], [-119.32208, 36.15273], [-119.32208, 36.15273], [-119.32522, 36.15647]]]} | Open Access 1 | 48851 | Elk Bayou Soccer Complex | 33571 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | https://www.tulare.ca.gov/Home/Components/FacilityDirectory/FacilityDirectory/22/155 | Tulare 29 | 14.659 | Elk Bayou Soccer Complex | 0 | Local Recreation Area 3 | 4 |
14702 | 14702 | 14701 | {"type": "Polygon", "coordinates": [[[-118.24012, 33.93118], [-118.24012, 33.93118], [-118.2401, 33.93246], [-118.23934, 33.931], [-118.23943, 33.93111], [-118.23957, 33.93117], [-118.24012, 33.93118]]]} | Open Access 1 | 45057 | Watts Serenity Park | 28919 | 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 | https://www.tpl.org/our-work/parks-for-people/fitness-zones/monitor-avenue-park | Los Angeles 6 | 1.147 | Watts Serenity Park | 0 | Local Park 2 | 4 |
15050 | 15050 | 15049 | {"type": "Polygon", "coordinates": [[[-118.31903, 34.101], [-118.31887, 34.101], [-118.31887, 34.10054], [-118.31903, 34.10054], [-118.31903, 34.101]]]} | Open Access 1 | 45719 | Carlton Way Pocket Park | 28612 | 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 | https://www.tpl.org/our-work/parks-for-people/carlton-way-pocket-park | Los Angeles 6 | 0.191 | Carlton Way PP | 0 | Local Park 2 | 4 |
4131 | 4131 | 4130 | {"type": "Polygon", "coordinates": [[[-118.54299, 34.19064], [-118.54284, 34.19074], [-118.54242, 34.19049], [-118.54196, 34.1903], [-118.54174, 34.19014], [-118.54291, 34.18966], [-118.54291, 34.19054], [-118.54299, 34.19064]]]} | Open Access 1 | 47400 | Los Angeles River and Aliso Creek Confluence Park | 31121 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.tpl.org/our-work/los-angeles-river-aliso-creek-confluence-project | Los Angeles 6 | 1.682 | Los Angeles River and Aliso Creek Confluence Park | 2016 | Local Park 2 | 4 |
11279 | 11279 | 11278 | {"type": "Polygon", "coordinates": [[[-118.15783, 34.11516], [-118.15741, 34.1155], [-118.15725, 34.11565], [-118.15722, 34.11553], [-118.15722, 34.11543], [-118.15741, 34.11524], [-118.15742, 34.11513], [-118.15783, 34.11513], [-118.15783, 34.11516]]]} | Open Access 1 | 48041 | Ironwork Historical Museum and Park | 32534 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | https://www.southpasadenaca.gov/government/departments/community-services/administration/south-pasadena-historical-museum | Los Angeles 6 | 0.327 | Ironwork Historical Museum and Park | 0 | Local Historic or Cultural Area 19 | 4 |
11165 | 11165 | 11164 | {"type": "Polygon", "coordinates": [[[-118.15596, 34.11789], [-118.15596, 34.11836], [-118.15571, 34.11836], [-118.15572, 34.11789], [-118.15596, 34.11789]]]} | Open Access 1 | 47994 | South Pasadena Community Garden and Demonstration Garden | 32415 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | https://www.southpasadenaca.gov/government/departments/community-services/administration/community-garden | Los Angeles 6 | 0.293 | South Pasadena Community Garden and Demonstration Garden | 2015 | Local Park 2 | 4 |
11232 | 11232 | 11231 | {"type": "Polygon", "coordinates": [[[-118.46481, 34.02853], [-118.4639, 34.02872], [-118.46352, 34.02864], [-118.46131, 34.02909], [-118.46102, 34.02931], [-118.46054, 34.02941], [-118.46045, 34.02911], [-118.46466, 34.02825], [-118.46471, 34.02825], [-118.46473, 34.02828], [-118.46481, 34.02853]]]} | Open Access 1 | 48030 | Ishihara Park | 32517 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | https://www.smgov.net/Departments/CCS/content.aspx?id=53687098200 | Los Angeles 6 | 2.358 | Ishihara Park | 2017 | Local Park 2 | 4 |
1746 | 1746 | 1745 | {"type": "Polygon", "coordinates": [[[-119.2751, 35.50217], [-119.2748, 35.50242], [-119.27445, 35.50212], [-119.27474, 35.50188], [-119.2751, 35.50217]]]} | Open Access 1 | 48487 | Town Square Park | 33197 | 1668 | Shafter, City of 418 | City 2 | City Agency 2 | http://www.shafter.com/73/Parks | City 2 | 1668 | Shafter, City of 412 | City 2 | City Agency 2 | https://www.shafter.com/73/Parks | Kern 36 | 0.43 | Town Square Park | 0 | Local Park 2 | 4 |
11163 | 11163 | 11162 | {"type": "Polygon", "coordinates": [[[-122.43003, 37.77971], [-122.42876, 37.77987], [-122.42861, 37.77913], [-122.42988, 37.77897], [-122.43003, 37.77971]]]} | Open Access 1 | 48006 | Ella Hill Hutch Center | 32433 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | https://www.sfparksalliance.org/our-parks/parks/ella-hill-hutch-center | San Francisco 13 | 2.344 | Ella Hill Hutch Ctr. | 0 | Local Recreation Area 3 | 4 |
4434 | 4434 | 4433 | {"type": "Polygon", "coordinates": [[[-121.95471, 37.32693], [-121.95432, 37.327], [-121.95364, 37.327], [-121.95364, 37.32676], [-121.95367, 37.32675], [-121.95377, 37.32665], [-121.95387, 37.32661], [-121.95415, 37.32662], [-121.95426, 37.3266], [-121.95437, 37.32654], [-121.95445, 37.32662], [-121.95471, 37.32662], [-121.95471, 37.32693]]]} | Open Access 1 | 48912 | Thomas Barrett Park | 33633 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | https://www.santaclaraca.gov/Home/Components/ServiceDirectory/ServiceDirectory/4116/2654 | Santa Clara 19 | 0.948 | Thomas Barrett Park | 0 | Local Park 2 | 4 |
11120 | 11120 | 11119 | {"type": "Polygon", "coordinates": [[[-117.86456, 33.73363], [-117.86494, 33.7337], [-117.865, 33.73375], [-117.86499, 33.73389], [-117.86456, 33.7339], [-117.86456, 33.73403], [-117.86354, 33.73405], [-117.86354, 33.73356], [-117.86456, 33.73363]]]} | Open Access 1 | 48687 | Pacific Electric Park | 33426 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | https://www.santa-ana.org/parks/parks-location/pacific-electric | Orange 3 | 1.404 | Pacific Electric Park | 2019 | Local Park 2 | 4 |
3979 | 3979 | 3978 | {"type": "Polygon", "coordinates": [[[-117.85936, 33.75016], [-117.85918, 33.75024], [-117.85907, 33.75004], [-117.85927, 33.75002], [-117.85936, 33.75016]]]} | Open Access 1 | 48845 | Garfield Exercise | 33565 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | https://www.santa-ana.org/parks/parks-location/garfield-exercise | Orange 3 | 0.096 | Garfield Exercise | None 344 |
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]);