units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,376 rows where DES_TP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 312
- San Diego, City of 281
- Sacramento, City of 192
- San Jose, City of 175
- San Francisco, City and County of 115
- Long Beach, City of 101
- Oakland, City of 99
- Los Angeles, County of 95
- Consumnes Community Services District 92
- Fresno, City of 80
- Modesto, City of 76
- East Bay Regional Park District 75
- Huntington Beach, City of 74
- Hayward Area Recreation and Park District 74
- Tracy, City of 69
- Santa Rosa, City of 68
- San Diego, County of 68
- Mountains Recreation and Conservation Authority 67
- Stockton, City of 67
- Roseville, City of 67
- Brentwood, City of 63
- Chula Vista, City of 60
- Irvine, City of 59
- Valley-Wide Recreation and Park District 57
- Bakersfield, City of 56
- Clovis, City of 54
- Manteca, City of 54
- Anaheim, City of 49
- Riverside, City of 49
- Newport Beach, City of 48
- …
MNG_AG_TYP 16
- City Agency 7,469
- Recreation/Parks District 703
- County Agency 650
- Community Services District 172
- County Agency - Parks 154
- Open Space District 75
- Water District 38
- School District 32
- Port/Harbor District 24
- Flood District 17
- Special District - Other 9
- County Agency - Other 7
- Cemetery District 3
- Irrigation District 1
- Sanitation District 1
- Joint Powers Authority 1
ACCESS_TYP 4
- Open Access 9,065
- Restricted Access 210
- No Public Access 76
- Unknown Access 5
DES_TP 1
- Local Park · 9,356 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8267 | 8267 | 8266 | {"type": "Polygon", "coordinates": [[[-118.04203, 34.17256], [-118.04202, 34.17268], [-118.04184, 34.17269], [-118.04181, 34.17267], [-118.04187, 34.17258], [-118.04201, 34.17259], [-118.04203, 34.17256]]]} | Open Access 1 | 12650 | Sierra Madre City Parkland | 12523 | 1333 | Sierra Madre, City of 311 | City 2 | City Agency 2 | http://www.cityofsierramadre.com/parks | City 2 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 0.047 | Sierra Madre City Parkland | 0 | Local Park 2 | 4 | |
9500 | 9500 | 9499 | {"type": "Polygon", "coordinates": [[[-122.42592, 37.73641], [-122.42567, 37.73661], [-122.42567, 37.73661], [-122.42574, 37.7364], [-122.42592, 37.73641]]]} | Open Access 1 | 15907 | Park St. Garden | 23439 | 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 | San Francisco 13 | 0.047 | Park St. Garden | 0 | Local Park 2 | 4 | |
11234 | 11234 | 11233 | {"type": "Polygon", "coordinates": [[[-118.15695, 34.11034], [-118.157, 34.11035], [-118.15703, 34.11042], [-118.15701, 34.11047], [-118.15695, 34.1105], [-118.1569, 34.11048], [-118.15687, 34.11042], [-118.15688, 34.11037], [-118.15695, 34.11034]]]} | Open Access 1 | 48040 | El Cerrito Circle Park | 32533 | 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 | Los Angeles 6 | 0.048 | El Cerrito Circle Park | 0 | Local Park 2 | 4 | |
793 | 793 | 792 | {"type": "Polygon", "coordinates": [[[-118.43173, 33.99148], [-118.43157, 33.99155], [-118.43154, 33.99132], [-118.43173, 33.99148], [-118.43173, 33.99148]]]} | Open Access 1 | 5165 | Maxella Parkette | 21967 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 0.051 | Maxella Parkette | 0 | Local Park 2 | 4 | |
6467 | 6467 | 6466 | {"type": "Polygon", "coordinates": [[[-116.98167, 33.93103], [-116.98167, 33.93103], [-116.98149, 33.93126], [-116.98149, 33.93103], [-116.98167, 33.93103]]]} | Open Access 1 | 39054 | Veterans Park | 27054 | 1415 | Beaumont, City of 802 | City 2 | City Agency 2 | http://www.ci.beaumont.ca.us/index.aspx?nid=33 | City 2 | 1415 | Beaumont, City of 782 | City 2 | City Agency 2 | Riverside 10 | 0.051 | Veterans Park | 0 | Local Park 2 | 4 | |
6967 | 6967 | 6966 | {"type": "Polygon", "coordinates": [[[-118.38992, 33.85746], [-118.38985, 33.85749], [-118.38978, 33.85725], [-118.38985, 33.85722], [-118.38992, 33.85746]]]} | Open Access 1 | 6104 | Ocean View Parkette | 29776 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.051 | Ocean View Parkette | 0 | Local Park 2 | 4 | |
3257 | 3257 | 3256 | {"type": "Polygon", "coordinates": [[[-122.27841, 37.90357], [-122.27835, 37.9037], [-122.2783, 37.90383], [-122.27824, 37.90357], [-122.27841, 37.90357]]]} | Open Access 1 | 48179 | Kensington Pocket Park | 32715 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 0.053 | Kensington PP | 0 | Local Park 2 | 4 | |
14 | 14 | 13 | {"type": "Polygon", "coordinates": [[[-122.03122, 36.97381], [-122.03122, 36.97381], [-122.03111, 36.97409], [-122.03105, 36.97384], [-122.03122, 36.97381]]]} | Open Access 1 | 42 | Rincon Park | 24369 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.055 | Rincon Park | 0 | Local Park 2 | 4 | |
2122 | 2122 | 2121 | {"type": "Polygon", "coordinates": [[[-122.40673, 37.74516], [-122.40672, 37.74526], [-122.4065, 37.74539], [-122.40645, 37.74534], [-122.40673, 37.74516]]]} | Open Access 1 | 15925 | Wolfe Lane Community Garden | 27672 | 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 | San Francisco 13 | 0.055 | Wolfe Lane Community Garden | 0 | Local Park 2 | 4 | |
5641 | 5641 | 5640 | {"type": "Polygon", "coordinates": [[[-118.22852, 34.08438], [-118.2285, 34.0844], [-118.22844, 34.0843], [-118.22835, 34.08422], [-118.22833, 34.08418], [-118.22835, 34.08399], [-118.22852, 34.08438]]]} | Open Access 1 | 46908 | Egret Park | 30449 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.055 | Egret Park | 0 | Local Park 2 | 4 | |
638 | 638 | 637 | {"type": "Polygon", "coordinates": [[[-117.88386, 33.59796], [-117.88404, 33.59799], [-117.88405, 33.59813], [-117.884, 33.59813], [-117.88389, 33.59805], [-117.88384, 33.59799], [-117.88386, 33.59796]]]} | Open Access 1 | 4921 | M Street Park | 21618 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.056 | M Street Park | 0 | Local Park 2 | 4 | |
2056 | 2056 | 2055 | {"type": "Polygon", "coordinates": [[[-122.41317, 37.74214], [-122.41315, 37.74224], [-122.41294, 37.74222], [-122.41295, 37.74212], [-122.41317, 37.74214]]]} | Open Access 1 | 15690 | Bernal Heights Community Garden | 16025 | 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 | San Francisco 13 | 0.056 | Bernal Heights Community Garden | 0 | Local Park 2 | 4 | |
2130 | 2130 | 2129 | {"type": "Polygon", "coordinates": [[[-122.41041, 37.79043], [-122.40994, 37.79049], [-122.40993, 37.79044], [-122.4104, 37.79038], [-122.41041, 37.79043]]]} | Open Access 1 | 15957 | Hooker Alley Community Garden | 20075 | 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 | San Francisco 13 | 0.056 | Hooker Alley Community Garden | 0 | Local Park 2 | 4 | |
2878 | 2878 | 2877 | {"type": "Polygon", "coordinates": [[[-118.31233, 34.03401], [-118.31231, 34.03394], [-118.31235, 34.03388], [-118.31242, 34.03384], [-118.31252, 34.03386], [-118.31252, 34.03389], [-118.31239, 34.03402], [-118.31236, 34.03402], [-118.31233, 34.03401]]]} | Open Access 1 | 18875 | Gramercy Park | 29322 | 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 | Los Angeles 6 | 0.056 | Gramercy Park | 0 | Local Park 2 | 4 | |
5806 | 5806 | 5805 | {"type": "Polygon", "coordinates": [[[-119.80869, 36.72619], [-119.80868, 36.72637], [-119.80843, 36.72637], [-119.80869, 36.72619], [-119.80869, 36.72619]]]} | Open Access 1 | 47301 | Merced & Trinity Pocket Park | 31008 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 0.056 | Merced & Trinity PP | 0 | Local Park 2 | 4 | |
8832 | 8832 | 8831 | {"type": "Polygon", "coordinates": [[[-121.6258, 39.1439], [-121.62555, 39.1439], [-121.62555, 39.14372], [-121.62559, 39.14374], [-121.6258, 39.1439]]]} | Open Access 1 | 16040 | Clark-Ainsley Mini-Park | 17385 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 0.056 | Clark-Ainsley Mini-Park | 0 | Local Park 2 | 4 | |
1300 | 1300 | 1299 | {"type": "Polygon", "coordinates": [[[-117.24193, 32.80867], [-117.24174, 32.80869], [-117.24161, 32.80874], [-117.24159, 32.80866], [-117.2419, 32.80859], [-117.24193, 32.80867]]]} | Open Access 1 | 7345 | Color Mini-Park | 30090 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.058 | Color Mini-Park | 0 | Local Park 2 | 4 | |
2656 | 2656 | 2655 | {"type": "Polygon", "coordinates": [[[-119.71595, 36.83585], [-119.71583, 36.83599], [-119.71584, 36.83571], [-119.71594, 36.83571], [-119.71595, 36.83585]]]} | Open Access 1 | 18148 | Tenaya Sun Ranch Park | 26240 | 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 | Fresno 9 | 0.058 | Tenaya Sun Ranch Park | 0 | Local Park 2 | 4 | |
6326 | 6326 | 6325 | {"type": "Polygon", "coordinates": [[[-117.93428, 33.61823], [-117.93424, 33.61826], [-117.93394, 33.61792], [-117.93398, 33.6179], [-117.93428, 33.61823]]]} | Open Access 1 | 47414 | Lake Street Park | 31130 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.059 | Lake Street Park | 0 | Local Park 2 | 4 | |
6843 | 6843 | 6842 | {"type": "Polygon", "coordinates": [[[-122.43359, 37.76495], [-122.43331, 37.76497], [-122.43331, 37.76488], [-122.43358, 37.76486], [-122.43359, 37.76495]]]} | Open Access 1 | 15927 | Noe & Beaver Mini Park | 22781 | 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 | San Francisco 13 | 0.059 | Noe & Beaver MP | 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]);