units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
428 rows where COUNTY = 15 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_LEV, GAP_STS
MNG_AGENCY >30
- Redwood City, City of 38
- San Mateo, City of 37
- Daly City, City of 27
- Midpeninsula Regional Open Space District 27
- San Mateo County Parks and Recreation Dept., County of 25
- South San Francisco, City of 24
- California Department of Parks and Recreation 23
- Peninsula Open Space Trust 23
- Foster City, City of 21
- Pacifica, City of 20
- San Bruno, City of 20
- Belmont, City of 18
- Millbrae, City of 15
- Menlo Park, City of 14
- San Carlos, City of 14
- Burlingame, City of 9
- Half Moon Bay, City of 8
- Coastside Land Trust 8
- California Department of Fish and Wildlife 6
- East Palo Alto, City of 6
- San Francisco - Public Utilities Commission, City and County of 5
- United States Fish and Wildlife Service 5
- Sempervirens Fund 5
- United States National Park Service 4
- Brisbane, City of 4
- Colma, City of 4
- California State Coastal Conservancy 2
- United States Bureau of Land Management 1
- San Francisco, City and County of 1
- Save the Redwoods League 1
- …
DES_TP >30
- Local Park 219
- Local Recreation Area 37
- Private Conservation 37
- Local Conservation Area 32
- State Park 16
- State Conservation Area 8
- Local Other or Unknown 8
- National Recreation Area 4
- Private Agricultural 4
- Conservation Area 3
- Local Historic or Cultural Area 3
- State Historic or Cultural Area 3
- State Recreation Area 2
- National Wildlife Refuge 2
- National Public Lands 1
- None 1
- Local Resource Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 12
ACCESS_TYP 4
- Open Access 353
- No Public Access 44
- Restricted Access 30
- Unknown Access 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15921 | 15921 | 15920 | {"type": "Polygon", "coordinates": [[[-122.34943, 37.42376], [-122.34901, 37.4238], [-122.34867, 37.42379], [-122.34867, 37.42379], [-122.34943, 37.42376]]]} | Open Access 1 | 17888 | Purisima Creek Redwoods Open Space Preserve | 6528 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_purisima.asp | San Mateo 15 | 0.029 | Purisima Creek Redwoods OSP | 1982 | Local Conservation Area 4 | 2 |
8826 | 8826 | 8825 | {"type": "Polygon", "coordinates": [[[-122.41355, 37.63561], [-122.41355, 37.63561], [-122.41334, 37.63565], [-122.41336, 37.63552], [-122.41342, 37.63547], [-122.41351, 37.63555], [-122.41355, 37.63561]]]} | Open Access 1 | 14387 | Herman Tot Lot | 19867 | 1294 | San Bruno, City of 440 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | San Mateo 15 | 0.056 | Herman Tot Lot | 1940 | Local Recreation Area 3 | 4 | |
13028 | 13028 | 13027 | {"type": "Polygon", "coordinates": [[[-122.47784, 37.51093], [-122.47784, 37.51093], [-122.4775, 37.51077], [-122.4778, 37.51075], [-122.47784, 37.51093]]]} | Open Access 1 | 34870 | Coastside Land Trust | 17467 | 3029 | Coastside Land Trust 678 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.coastsidelandtrust.org | Non Governmental Organization 10 | 3029 | Coastside Land Trust 668 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.069 | Coastside Land Trust | 0 | Private Conservation 16 | 2 | |
1149 | 1149 | 1148 | {"type": "Polygon", "coordinates": [[[-122.46654, 37.70822], [-122.46654, 37.70827], [-122.46585, 37.70826], [-122.46585, 37.70822], [-122.46654, 37.70822]]]} | Restricted Access 2 | 6734 | Hillcrest And Ocean View Lots | 19962 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Mateo 15 | 0.08 | Hillcrest And Ocean View Lots | 0 | Local Other or Unknown 14 | 4 | |
4231 | 4231 | 4230 | {"type": "Polygon", "coordinates": [[[-122.31412, 37.26649], [-122.31377, 37.26649], [-122.31369, 37.26638], [-122.31401, 37.26638], [-122.31412, 37.26649]]]} | No Public Access 3 | 29758 | Kraynick | 20724 | 3054 | Peninsula Open Space Trust 338 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.092 | Kraynick | 0 | Private Conservation 16 | 2 | |
3300 | 3300 | 3299 | {"type": "Polygon", "coordinates": [[[-122.29705, 37.50541], [-122.29705, 37.50546], [-122.29697, 37.50559], [-122.29687, 37.50551], [-122.29678, 37.50541], [-122.29685, 37.50536], [-122.29697, 37.50534], [-122.29703, 37.50536], [-122.29705, 37.50541]]]} | Open Access 1 | 48212 | Hastings Tot Lot | 32752 | 1025 | Belmont, City of 198 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | San Mateo 15 | 0.096 | Hastings Tot Lot | 0 | Local Recreation Area 3 | 4 | |
12422 | 12422 | 12421 | {"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 | 27027 | Colma Historical | 17523 | 1456 | Colma, City of 968 | City 2 | City Agency 2 | http://www.colma.ca.gov/ | City 2 | 1456 | Colma, City of 934 | City 2 | City Agency 2 | San Mateo 15 | 0.098 | Colma Historical | 0 | Local Historic or Cultural Area 19 | 4 | |
3410 | 3410 | 3409 | {"type": "Polygon", "coordinates": [[[-122.40457, 37.61584], [-122.40447, 37.6159], [-122.40423, 37.61562], [-122.40433, 37.61557], [-122.40457, 37.61584]]]} | Open Access 1 | 24974 | Lomita Park | 21415 | 1294 | San Bruno, City of 440 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | San Mateo 15 | 0.099 | Lomita Park | 0 | Local Park 2 | 4 | |
13027 | 13027 | 13026 | {"type": "Polygon", "coordinates": [[[-122.47788, 37.51058], [-122.47771, 37.51062], [-122.47766, 37.51034], [-122.47781, 37.51035], [-122.47788, 37.51058]]]} | Open Access 1 | 34869 | Coastside Land Trust | 17467 | 3029 | Coastside Land Trust 678 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.coastsidelandtrust.org | Non Governmental Organization 10 | 3029 | Coastside Land Trust 668 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.104 | Coastside Land Trust | 0 | Private Conservation 16 | 2 | |
12579 | 12579 | 12578 | {"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 | 29141 | College View Park | 17514 | 1025 | Belmont, City of 198 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | San Mateo 15 | 0.113 | College View Park | 0 | Local Park 2 | 4 | |
3751 | 3751 | 3750 | {"type": "Polygon", "coordinates": [[[-122.43183, 37.44426], [-122.43175, 37.44427], [-122.43168, 37.44373], [-122.43176, 37.44372], [-122.43183, 37.44426]]]} | Open Access 1 | 34834 | Coastside Land Trust | 17467 | 3029 | Coastside Land Trust 678 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.coastsidelandtrust.org | Non Governmental Organization 10 | 3029 | Coastside Land Trust 668 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.114 | Coastside Land Trust | 0 | Private Conservation 16 | 2 | |
1693 | 1693 | 1692 | {"type": "Polygon", "coordinates": [[[-122.49248, 37.63035], [-122.49247, 37.63053], [-122.49221, 37.63053], [-122.49218, 37.63034], [-122.49248, 37.63035]]]} | Open Access 1 | 14655 | Palmetto Mini Park | 23354 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 0.124 | Palmetto MP | 0 | Local Park 2 | 4 | |
6648 | 6648 | 6647 | {"type": "Polygon", "coordinates": [[[-122.25869, 37.50458], [-122.25837, 37.50483], [-122.25826, 37.50475], [-122.25858, 37.5045], [-122.25869, 37.50458]]]} | Open Access 1 | 14355 | Laurel Street Park | 21106 | 1295 | San Carlos, City of 438 | City 2 | City Agency 2 | http://www.cityofsancarlos.org/depts/pr/default.asp | City 2 | 1295 | San Carlos, City of 432 | City 2 | City Agency 2 | San Mateo 15 | 0.131 | Laurel Street Park | 1996 | Local Park 2 | 4 | |
11450 | 11450 | 11449 | {"type": "Polygon", "coordinates": [[[-122.28821, 37.52187], [-122.28809, 37.52198], [-122.28808, 37.52195], [-122.28782, 37.52178], [-122.28799, 37.5217], [-122.28809, 37.5217], [-122.28813, 37.52177], [-122.28821, 37.52187]]]} | Open Access 1 | 29140 | Patricia Wharton Park | 23511 | 1025 | Belmont, City of 198 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | San Mateo 15 | 0.132 | Patricia Wharton Park | 0 | Local Park 2 | 4 | |
8660 | 8660 | 8659 | {"type": "Polygon", "coordinates": [[[-122.22487, 37.48152], [-122.22446, 37.48126], [-122.2246, 37.48107], [-122.2246, 37.48107], [-122.22487, 37.48152]]]} | Open Access 1 | 13898 | Main Street Park | 21693 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 0.14 | Main Street Park | 1940 | Local Park 2 | 4 | |
4824 | 4824 | 4823 | {"type": "Polygon", "coordinates": [[[-122.27833, 37.55285], [-122.27813, 37.55301], [-122.27808, 37.55297], [-122.27791, 37.55293], [-122.27762, 37.55297], [-122.27772, 37.55285], [-122.27776, 37.55283], [-122.27801, 37.55287], [-122.27833, 37.55285]]]} | Open Access 1 | 48930 | Unknown park - Foster City, City of | 33649 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 0.149 | 0 | Local Other or Unknown 14 | 4 | ||
6216 | 6216 | 6215 | {"type": "Polygon", "coordinates": [[[-122.44181, 37.62294], [-122.44167, 37.62295], [-122.44149, 37.62283], [-122.44155, 37.62271], [-122.44171, 37.62265], [-122.44177, 37.62264], [-122.44181, 37.62294]]]} | Open Access 1 | 14396 | Glenview Park | 19338 | 1294 | San Bruno, City of 440 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | San Mateo 15 | 0.16 | Glenview Park | 1961 | Local Park 2 | 4 | |
3301 | 3301 | 3300 | {"type": "Polygon", "coordinates": [[[-122.30031, 37.51802], [-122.3004, 37.51805], [-122.30041, 37.51812], [-122.30018, 37.51835], [-122.30004, 37.51807], [-122.30031, 37.51802]]]} | Open Access 1 | 48213 | Semeria Park | 32753 | 1025 | Belmont, City of 198 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | San Mateo 15 | 0.165 | Semeria Park | 0 | Local Park 2 | 4 | |
9317 | 9317 | 9316 | {"type": "Polygon", "coordinates": [[[-122.44233, 37.6272], [-122.4423, 37.62756], [-122.44226, 37.62762], [-122.4421, 37.62755], [-122.44212, 37.62752], [-122.44216, 37.62718], [-122.44233, 37.6272]]]} | Open Access 1 | 15533 | Catalpa Tot Lot | 16969 | 1294 | San Bruno, City of 440 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | San Mateo 15 | 0.174 | Catalpa Tot Lot | 1962 | Local Recreation Area 3 | 4 | |
12420 | 12420 | 12419 | {"type": "Polygon", "coordinates": [[[-122.4602, 37.68387], [-122.45987, 37.68387], [-122.45987, 37.68365], [-122.4602, 37.68363], [-122.4602, 37.68387]]]} | Open Access 1 | 27025 | Bark Park | 15815 | 1456 | Colma, City of 968 | City 2 | City Agency 2 | http://www.colma.ca.gov/ | City 2 | 1456 | Colma, City of 934 | City 2 | City Agency 2 | San Mateo 15 | 0.187 | Bark Park | 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]);