units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,084 rows where ACCESS_TYP = 1 and DES_TP = 2 sorted by AGNCY_TYP descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
MNG_AGENCY >30
- Los Angeles, City of 291
- San Diego, City of 274
- Sacramento, City of 190
- San Jose, City of 174
- San Francisco, City and County of 118
- Oakland, City of 99
- Long Beach, City of 98
- Consumnes Community Services District 92
- Los Angeles, County of 91
- Fresno, City of 82
- Huntington Beach, City of 74
- Modesto, City of 72
- Hayward Area Recreation and Park District 70
- Tracy, City of 69
- Santa Rosa, City of 67
- Stockton, City of 67
- San Diego, County of 66
- Roseville, City of 65
- Brentwood, City of 63
- Mountains Recreation and Conservation Authority 62
- Chula Vista, City of 60
- Irvine, City of 59
- Valley-Wide Recreation and Park District 57
- Bakersfield, City of 55
- Clovis, City of 54
- Manteca, City of 54
- Newport Beach, City of 50
- Anaheim, City of 49
- Riverside, City of 49
- East Bay Regional Park District 46
- …
DES_TP 1
- Local Park · 9,084 ✖
ACCESS_TYP 1
- Open Access · 9,084 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10862 | 10862 | 10861 | {"type": "Polygon", "coordinates": [[[-118.52166, 34.37788], [-118.52155, 34.37794], [-118.5216, 34.37802], [-118.52101, 34.37832], [-118.51896, 34.37592], [-118.51945, 34.37515], [-118.52016, 34.37582], [-118.52058, 34.37646], [-118.52104, 34.37623], [-118.52134, 34.37749], [-118.52166, 34.37788]]]} | Open Access 1 | 20660 | Creekview Park | 17788 | 6102 | The Master's College 959 | Private 7 | Education 35 | http://www.masters.edu/ | Private 14 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=411 | Los Angeles 6 | 8.223 | Creekview Park | 0 | Local Park 2 | 4 |
15228 | 15228 | 15227 | {"type": "Polygon", "coordinates": [[[-118.11833, 33.88205], [-118.11787, 33.88208], [-118.11777, 33.88205], [-118.11754, 33.88194], [-118.11747, 33.88184], [-118.11747, 33.88161], [-118.11833, 33.88205]]]} | Open Access 1 | 46284 | Bellflower Bike Trail Plaza | 29576 | 2077 | Los Angeles County Metropolitan Transportation Authority 1142 | Special District 4 | Transportation Agency 32 | http://www.metro.net | Special District 4 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 0.44 | Bellflower Bike Trail Plaza | 0 | Local Park 2 | 4 | |
15319 | 15319 | 15318 | {"type": "Polygon", "coordinates": [[[-117.99491, 34.13454], [-117.99491, 34.13492], [-117.99485, 34.13497], [-117.99432, 34.13496], [-117.99491, 34.13454]]]} | Open Access 1 | 46482 | Evergreen Plaza Park | 29759 | 2394 | Metro Gold Line Foothill Extension Construction Authority 1152 | Special District 4 | Transportation Agency 32 | http://www.foothillgoldline.org/about-us/construction-authority/ | Special District 4 | 1209 | Monrovia, City of 309 | City 2 | City Agency 2 | Los Angeles 6 | 0.318 | Evergreen Plaza Park | 2015 | Local Park 2 | 4 | |
11636 | 11636 | 11635 | {"type": "Polygon", "coordinates": [[[-121.39679, 38.62353], [-121.39677, 38.62509], [-121.39471, 38.62507], [-121.39517, 38.62469], [-121.39555, 38.62429], [-121.39587, 38.62388], [-121.3961, 38.62353], [-121.39679, 38.62353]]]} | Open Access 1 | 23963 | Seely Park | 25284 | 2192 | Fulton - El Camino 984 | Special District 4 | Special District - Other 26 | http://www.fecrecpark.com/index.htm | Special District 4 | 2192 | Fulton - El Camino 948 | Special District 4 | Special District - Other 24 | Sacramento 41 | 4.81 | Seely Park | 0 | Local Park 2 | 4 | |
11666 | 11666 | 11665 | {"type": "Polygon", "coordinates": [[[-121.41459, 38.61315], [-121.41258, 38.61312], [-121.41258, 38.61407], [-121.41181, 38.61406], [-121.41183, 38.61375], [-121.41241, 38.61319], [-121.41241, 38.61267], [-121.41458, 38.6127], [-121.41459, 38.61315]]]} | Open Access 1 | 23972 | Bellview Park | 15992 | 2192 | Fulton - El Camino 984 | Special District 4 | Special District - Other 26 | http://www.fecrecpark.com/index.htm | Special District 4 | 2192 | Fulton - El Camino 948 | Special District 4 | Special District - Other 24 | Sacramento 41 | 3.545 | Bellview Park | 0 | Local Park 2 | 4 | |
11672 | 11672 | 11671 | {"type": "Polygon", "coordinates": [[[-121.40835, 38.62349], [-121.40616, 38.62348], [-121.40616, 38.62206], [-121.40617, 38.62203], [-121.40621, 38.622], [-121.40625, 38.62199], [-121.40792, 38.622], [-121.40806, 38.62199], [-121.40823, 38.62194], [-121.40835, 38.62213], [-121.40835, 38.62349]]]} | Open Access 1 | 23964 | Bohemian Park | 16233 | 2192 | Fulton - El Camino 984 | Special District 4 | Special District - Other 26 | http://www.fecrecpark.com/index.htm | Special District 4 | 2192 | Fulton - El Camino 948 | Special District 4 | Special District - Other 24 | Sacramento 41 | 7.793 | Bohemian Park | 0 | Local Park 2 | 4 | |
11679 | 11679 | 11678 | {"type": "Polygon", "coordinates": [[[-121.42753, 38.60727], [-121.4274, 38.60767], [-121.42735, 38.6079], [-121.42733, 38.60801], [-121.42733, 38.60856], [-121.42569, 38.60856], [-121.42568, 38.60844], [-121.42541, 38.60842], [-121.42542, 38.60749], [-121.42547, 38.60723], [-121.42753, 38.60727]]]} | Open Access 1 | 23975 | Babcock Park | 15745 | 2192 | Fulton - El Camino 984 | Special District 4 | Special District - Other 26 | http://www.fecrecpark.com/index.htm | Special District 4 | 2192 | Fulton - El Camino 948 | Special District 4 | Special District - Other 24 | Sacramento 41 | 6.063 | Babcock Park | 0 | Local Park 2 | 4 | |
11680 | 11680 | 11679 | {"type": "Polygon", "coordinates": [[[-121.41056, 38.60659], [-121.41056, 38.60714], [-121.40937, 38.60713], [-121.40883, 38.60772], [-121.40883, 38.60803], [-121.40837, 38.60803], [-121.40837, 38.60806], [-121.40809, 38.60806], [-121.40808, 38.60814], [-121.40684, 38.60813], [-121.40629, 38.60794], [-121.40621, 38.60778], [-121.40835, 38.60733], [-121.40838, 38.60712], [-121.40905, 38.60713], [-121.40905, 38.60699], [-121.40893, 38.60687], [-121.40899, 38.60681], [-121.40901, 38.60677], [-121.409, 38.60673], [-121.40887, 38.60658], [-121.4092, 38.60658], [-121.40962, 38.60669], [-121.41022, 38.60659], [-121.41056, 38.60659]]]} | Open Access 1 | 23976 | Santa Anita Park | 25036 | 2192 | Fulton - El Camino 984 | Special District 4 | Special District - Other 26 | http://www.fecrecpark.com/index.htm | Special District 4 | 2192 | Fulton - El Camino 948 | Special District 4 | Special District - Other 24 | Sacramento 41 | 6.072 | Santa Anita Park | 0 | Local Park 2 | 4 | |
11684 | 11684 | 11683 | {"type": "Polygon", "coordinates": [[[-121.39391, 38.60316], [-121.3939, 38.60535], [-121.39175, 38.60532], [-121.39174, 38.60496], [-121.39056, 38.60494], [-121.39049, 38.60483], [-121.39047, 38.60352], [-121.39089, 38.60353], [-121.39089, 38.60343], [-121.39165, 38.60344], [-121.39166, 38.60313], [-121.39391, 38.60316]]]} | Open Access 1 | 23979 | Cottage Park | 17682 | 2192 | Fulton - El Camino 984 | Special District 4 | Special District - Other 26 | http://www.fecrecpark.com/index.htm | Special District 4 | 2192 | Fulton - El Camino 948 | Special District 4 | Special District - Other 24 | Sacramento 41 | 15.826 | Cottage Park | 0 | Local Park 2 | 4 | |
13663 | 13663 | 13662 | {"type": "Polygon", "coordinates": [[[-121.41513, 38.6044], [-121.41511, 38.60441], [-121.41512, 38.60684], [-121.41298, 38.60682], [-121.41298, 38.60718], [-121.41077, 38.60714], [-121.41077, 38.6036], [-121.41497, 38.60368], [-121.41497, 38.60412], [-121.41513, 38.60413], [-121.41513, 38.6044]]]} | Open Access 1 | 36029 | Howe Park | 20125 | 2192 | Fulton - El Camino 984 | Special District 4 | Special District - Other 26 | http://www.fecrecpark.com/index.htm | Special District 4 | 2192 | Fulton - El Camino 948 | Special District 4 | Special District - Other 24 | Sacramento 41 | 34.701 | Howe Park | 0 | Local Park 2 | 4 | |
14989 | 14989 | 14988 | {"type": "Polygon", "coordinates": [[[-117.3355, 34.59883], [-117.33556, 34.59885], [-117.33599, 34.59944], [-117.33599, 34.5995], [-117.33454, 34.60022], [-117.3345, 34.60023], [-117.33446, 34.60022], [-117.33402, 34.59962], [-117.33402, 34.59956], [-117.3355, 34.59883]]]} | Open Access 1 | 45634 | Oro Grande Park | 28514 | 2355 | County Service Area 42 1132 | Special District 4 | Special District - Other 26 | http://specialdistricts.org/index.aspx?page=404 | Special District 4 | 2355 | County Service Area 42 1087 | Special District 4 | Special District - Other 24 | San Bernardino 22 | 3.531 | Oro Grande Park | 0 | Local Park 2 | 4 | |
15011 | 15011 | 15010 | {"type": "Polygon", "coordinates": [[[-118.81765, 36.13081], [-118.81735, 36.13107], [-118.81709, 36.13088], [-118.81696, 36.13099], [-118.81693, 36.13097], [-118.81688, 36.13102], [-118.81664, 36.13084], [-118.81712, 36.13041], [-118.81765, 36.13081]]]} | Open Access 1 | 45663 | Springville Veterans Memorial Park | 28480 | 2353 | Springville Memorial District 1133 | Special District 4 | Special District - Other 26 | Special District 4 | 2353 | Springville Memorial District 1088 | Special District 4 | Special District - Other 24 | Tulare 29 | 0.831 | Springville Veterans Memorial Park | 0 | Local Park 2 | 4 | ||
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 | |
15256 | 15256 | 15255 | {"type": "MultiPolygon", "coordinates": [[[[-118.109, 33.88327], [-118.10866, 33.88327], [-118.10866, 33.88309], [-118.109, 33.88308], [-118.109, 33.88327]]], [[[-118.10902, 33.88416], [-118.10866, 33.88416], [-118.10866, 33.8838], [-118.10901, 33.8838], [-118.10902, 33.88416]]]]} | Open Access 1 | 46312 | Caruthers Park North | 29601 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | https://www.bellflower.org/home/index.asp?page=132 | Los Angeles 6 | 0.48 | Caruthers Park North | 0 | Local Park 2 | 4 | |
15317 | 15317 | 15316 | {"type": "Polygon", "coordinates": [[[-118.01167, 33.9126], [-118.01104, 33.91346], [-118.01104, 33.91426], [-118.01127, 33.91427], [-118.01118, 33.91432], [-118.01101, 33.91431], [-118.01083, 33.91482], [-118.00994, 33.91503], [-118.01023, 33.91471], [-118.01004, 33.91464], [-118.01004, 33.91461], [-118.01024, 33.91467], [-118.01043, 33.9143], [-118.0105, 33.91395], [-118.01056, 33.9133], [-118.01061, 33.91317], [-118.01081, 33.91298], [-118.01102, 33.91265], [-118.01073, 33.91253], [-118.01074, 33.9125], [-118.01102, 33.9126], [-118.01116, 33.91239], [-118.01149, 33.91179], [-118.01152, 33.91167], [-118.01166, 33.91167], [-118.01166, 33.912], [-118.01157, 33.9121], [-118.01157, 33.91245], [-118.01167, 33.91246], [-118.01167, 33.9126]]]} | Open Access 1 | 46499 | Oak Creek Park | 22960 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1158 | La Mirada, City of 323 | City 2 | City Agency 2 | Los Angeles 6 | 4.296 | Oak Creek Park | 0 | Local Park 2 | 4 | ||
14978 | 14978 | 14977 | {"type": "Polygon", "coordinates": [[[-121.50878, 38.25131], [-121.50859, 38.25132], [-121.50676, 38.25202], [-121.50797, 38.25004], [-121.5081, 38.2501], [-121.50805, 38.25044], [-121.5081, 38.2506], [-121.50859, 38.25106], [-121.50862, 38.25117], [-121.50878, 38.25131]]]} | Open Access 1 | 45599 | Locke Boarding House Park | 28425 | 2349 | Sacramento Housing and Redevelopment Agency 1129 | Joint 8 | Joint Powers Authority 24 | http://www.shra.org/ | Special District 4 | 2349 | Sacramento Housing and Redevelopment Agency 1084 | Joint 8 | Joint Powers Authority 23 | Sacramento 41 | 3.349 | Locke Boarding House Park | 0 | Local Park 2 | 4 | |
15201 | 15201 | 15200 | {"type": "Polygon", "coordinates": [[[-118.41981, 33.98441], [-118.4179, 33.98583], [-118.41786, 33.98591], [-118.41784, 33.98601], [-118.41786, 33.98605], [-118.41782, 33.98606], [-118.41773, 33.98597], [-118.41734, 33.98624], [-118.41726, 33.98615], [-118.41972, 33.98432], [-118.41981, 33.98441]]]} | Open Access 1 | 46080 | Milton Street Park | 29422 | 500 | Baldwin Hills Regional Conservation Authority 1140 | Joint 8 | Joint Powers Authority 24 | http://smmc.ca.gov/BHRCA.asp | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1.029 | Milton Street Park | 0 | Local Park 2 | 4 | |
15305 | 15305 | 15304 | {"type": "Polygon", "coordinates": [[[-118.10762, 34.09685], [-118.10762, 34.09685], [-118.10657, 34.09656], [-118.10761, 34.09622], [-118.10765, 34.09626], [-118.10762, 34.09685]]]} | Open Access 1 | 46474 | Plaza Park | 29747 | 3358 | Archdiocese of Los Angeles 1151 | Non Profit 6 | Non Profit - Other 22 | http://www.la-archdiocese.org/Pages/default.aspx | Non Governmental Organization 10 | 1301 | San Gabriel, City of 725 | City 2 | City Agency 2 | Los Angeles 6 | 0.869 | Plaza Park | 0 | Local Park 2 | 4 | |
16431 | 16431 | 16430 | {"type": "Polygon", "coordinates": [[[-117.83973, 34.08948], [-117.83939, 34.08989], [-117.83876, 34.08965], [-117.83843, 34.08942], [-117.83824, 34.08936], [-117.83808, 34.08936], [-117.83791, 34.08941], [-117.83777, 34.08951], [-117.8376, 34.08971], [-117.83744, 34.08977], [-117.83718, 34.0898], [-117.83699, 34.08985], [-117.83687, 34.08962], [-117.83699, 34.08957], [-117.83757, 34.08887], [-117.83804, 34.08872], [-117.83842, 34.08887], [-117.83904, 34.08915], [-117.83954, 34.08911], [-117.83973, 34.08948]]]} | Open Access 1 | 46301 | Walnut Creek Community Regional Park | 29589 | 3365 | Buddhist Compassion Relief Tzu Chi Foundation 1144 | Non Profit 6 | Non Profit - Other 22 | http://www.tzuchi.us/ | Non Governmental Organization 10 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Walnut_Creek_Community_Regional_Park | Los Angeles 6 | 4.239 | Walnut Creek Community RP | 0 | Local Park 2 | 4 |
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]);