units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
428 rows where COUNTY = 15
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Redwood City, City of 37
- San Mateo, City of 35
- Daly City, City of 27
- Midpeninsula Regional Open Space District 27
- San Mateo County Parks and Recreation Dept., County of 23
- California Department of Parks and Recreation 22
- South San Francisco, City of 22
- Peninsula Open Space Trust 21
- Foster City, City of 21
- San Bruno, City of 20
- Pacifica, City of 19
- Belmont, City of 16
- Millbrae, City of 14
- San Carlos, City of 14
- Menlo Park, City of 12
- Burlingame, City of 8
- Half Moon Bay, City of 8
- Coastside Land Trust 8
- California Department of Fish and Wildlife 6
- East Palo Alto, City of 6
- Sempervirens Fund 5
- United States Fish and Wildlife Service 4
- United States National Park Service 4
- Brisbane, City of 4
- Colma, City of 4
- San Francisco - Public Utilities Commission, City and County of 3
- 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 206
- Local Recreation Area 37
- Private Conservation 35
- Local Conservation Area 32
- State Park 15
- State Conservation Area 8
- Local Other or Unknown 7
- National Recreation Area 4
- Private Agricultural 4
- Local Historic or Cultural Area 3
- State Historic or Cultural Area 3
- Conservation Area 2
- State Recreation Area 2
- National Wildlife Refuge 2
- National Public Lands 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
- None 1
- …
MNG_AG_TYP 12
MNG_AG_LEV 7 ✖
- City 271
- Non Profit 39
- Special District 31
- State 31
- County 26
- Federal 9
- Private 1
ACCESS_TYP 4
- Open Access 338
- No Public Access 41
- Restricted Access 28
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1789 | 1789 | 1788 | {"type": "Polygon", "coordinates": [[[-122.29403, 37.50902], [-122.29314, 37.50954], [-122.29231, 37.50864], [-122.29321, 37.50812], [-122.29358, 37.50853], [-122.29389, 37.50835], [-122.2939, 37.50837], [-122.2936, 37.50855], [-122.29403, 37.50902]]]} | Open Access 1 | 13487 | Belameda Park | 15963 | 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 | 3.025 | Belameda Park | 1960 | Local Park 2 | 4 | |
1794 | 1794 | 1793 | {"type": "Polygon", "coordinates": [[[-122.37855, 37.58883], [-122.37806, 37.5894], [-122.37803, 37.58941], [-122.37753, 37.58916], [-122.37733, 37.5891], [-122.37692, 37.58903], [-122.37678, 37.58897], [-122.37657, 37.58885], [-122.37674, 37.58868], [-122.37666, 37.5885], [-122.37681, 37.58814], [-122.37681, 37.58797], [-122.37705, 37.5877], [-122.3772, 37.58779], [-122.37775, 37.58781], [-122.37794, 37.58779], [-122.37754, 37.58828], [-122.37855, 37.58883]]]} | Open Access 1 | 13508 | Ray Park | 24204 | 1039 | Burlingame, City of 390 | City 2 | City Agency 2 | http://www.burlingame.org/index.aspx?page=33 | City 2 | 1039 | Burlingame, City of 384 | City 2 | City Agency 2 | San Mateo 15 | 4.291 | Ray Park | 1941 | Local Park 2 | 4 | |
1809 | 1809 | 1808 | {"type": "Polygon", "coordinates": [[[-122.46028, 37.70064], [-122.46009, 37.70065], [-122.45961, 37.70111], [-122.45957, 37.70032], [-122.46026, 37.70029], [-122.46028, 37.70064]]]} | Open Access 1 | 15603 | Edgewood Park | 18440 | 1078 | Daly City, City of 427 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | San Mateo 15 | 0.854 | Edgewood Park | 0 | Local Park 2 | 4 | |
1831 | 1831 | 1830 | {"type": "Polygon", "coordinates": [[[-122.25021, 37.5256], [-122.24964, 37.5261], [-122.2493, 37.52562], [-122.24918, 37.52553], [-122.24903, 37.52546], [-122.2489, 37.52543], [-122.24873, 37.52543], [-122.24826, 37.52554], [-122.24808, 37.52556], [-122.24787, 37.52556], [-122.2478, 37.52546], [-122.24787, 37.52541], [-122.24792, 37.52534], [-122.24799, 37.52472], [-122.24796, 37.52444], [-122.24786, 37.52424], [-122.24781, 37.5241], [-122.24779, 37.52394], [-122.2478, 37.52381], [-122.24792, 37.52383], [-122.24796, 37.524], [-122.24805, 37.52413], [-122.24924, 37.52518], [-122.24939, 37.52527], [-122.24954, 37.52533], [-122.24994, 37.52541], [-122.25021, 37.5256]]]} | Open Access 1 | 13927 | Mariner Park | 21853 | 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 | 4.052 | Mariner Park | 1978 | Local Park 2 | 4 | |
1833 | 1833 | 1832 | {"type": "Polygon", "coordinates": [[[-122.31523, 37.58098], [-122.31449, 37.58149], [-122.31363, 37.58076], [-122.31441, 37.58023], [-122.31523, 37.58098]]]} | Open Access 1 | 14016 | Harborview | 19669 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 2.434 | Harborview | 1961 | None 143 | ||
1834 | 1834 | 1833 | {"type": "Polygon", "coordinates": [[[-122.29139, 37.56829], [-122.29135, 37.56831], [-122.2913, 37.56829], [-122.29123, 37.56825], [-122.29109, 37.56813], [-122.29095, 37.56795], [-122.29089, 37.56778], [-122.29092, 37.56774], [-122.29111, 37.5678], [-122.29127, 37.56788], [-122.2914, 37.568], [-122.29143, 37.56813], [-122.29141, 37.56827], [-122.29139, 37.56829]]]} | Open Access 1 | 14019 | Marina Lagoon Wildlife Island | 21829 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 0.388 | Marina Lagoon Wildlife Island | 1962 | Local Conservation Area 4 | 2 | |
1836 | 1836 | 1835 | {"type": "Polygon", "coordinates": [[[-122.29796, 37.56767], [-122.29795, 37.56824], [-122.29718, 37.56827], [-122.29719, 37.56766], [-122.29738, 37.56766], [-122.29739, 37.5677], [-122.29776, 37.5677], [-122.29777, 37.56767], [-122.29796, 37.56767]]]} | Open Access 1 | 14064 | Dale Avenue | 17893 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.07 | Dale Avenue | 1961 | None 144 | ||
1837 | 1837 | 1836 | {"type": "Polygon", "coordinates": [[[-122.28058, 37.53709], [-122.28016, 37.53733], [-122.2797, 37.53729], [-122.27961, 37.53725], [-122.27952, 37.53716], [-122.27948, 37.53703], [-122.27948, 37.53675], [-122.27955, 37.53663], [-122.27955, 37.53658], [-122.27948, 37.53647], [-122.27946, 37.53631], [-122.27946, 37.53622], [-122.27951, 37.53606], [-122.27949, 37.53601], [-122.27954, 37.53596], [-122.28058, 37.53709]]]} | Open Access 1 | 14066 | Laguna Vista | 20869 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.998 | Laguna Vista | 1980 | None 145 | ||
1838 | 1838 | 1837 | {"type": "Polygon", "coordinates": [[[-122.30912, 37.57475], [-122.30887, 37.57498], [-122.30859, 37.57511], [-122.30813, 37.57488], [-122.30792, 37.57476], [-122.30772, 37.57507], [-122.30762, 37.57505], [-122.30754, 37.57507], [-122.3075, 37.57514], [-122.3075, 37.57519], [-122.30753, 37.57523], [-122.30727, 37.5754], [-122.30692, 37.57512], [-122.30759, 37.57461], [-122.30797, 37.57472], [-122.3083, 37.57478], [-122.3087, 37.5748], [-122.30912, 37.57475]]]} | Open Access 1 | 14068 | Ryder Court | 24760 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.407 | Ryder Court | 0 | Local Park 2 | 4 | |
1841 | 1841 | 1840 | {"type": "Polygon", "coordinates": [[[-122.29381, 37.54598], [-122.29325, 37.54661], [-122.29319, 37.54657], [-122.29232, 37.54575], [-122.29336, 37.54507], [-122.2935, 37.54518], [-122.29315, 37.5456], [-122.29381, 37.54598]]]} | Open Access 1 | 14077 | Bay Meadows West | 15876 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 2.436 | Bay Meadows West | 1962 | None 146 | ||
1842 | 1842 | 1841 | {"type": "Polygon", "coordinates": [[[-122.29185, 37.54671], [-122.29236, 37.54722], [-122.29185, 37.54752], [-122.29115, 37.5467], [-122.29145, 37.5465], [-122.2914, 37.54642], [-122.29154, 37.54633], [-122.29159, 37.54639], [-122.29155, 37.54645], [-122.29153, 37.54651], [-122.29155, 37.54658], [-122.29158, 37.54664], [-122.29164, 37.54668], [-122.29171, 37.54671], [-122.29185, 37.54671]]]} | Open Access 1 | 14079 | Bay Meadows East | 15873 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.371 | Bay Meadows East | 1962 | None 147 | ||
1843 | 1843 | 1842 | {"type": "MultiPolygon", "coordinates": [[[[-122.2915, 37.54521], [-122.29059, 37.54579], [-122.29059, 37.54581], [-122.29054, 37.54585], [-122.29049, 37.54587], [-122.29042, 37.54587], [-122.29036, 37.54584], [-122.29033, 37.5458], [-122.29033, 37.54573], [-122.29037, 37.54569], [-122.29042, 37.54565], [-122.29044, 37.54566], [-122.29135, 37.54507], [-122.2915, 37.54521]]], [[[-122.29268, 37.54444], [-122.29163, 37.54512], [-122.29149, 37.54498], [-122.29253, 37.5443], [-122.29268, 37.54444]]]]} | Open Access 1 | 14081 | Bay Meadows Linear | 15874 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.18 | Bay Meadows Linear | None 148 | |||
1844 | 1844 | 1843 | {"type": "Polygon", "coordinates": [[[-122.32314, 37.54969], [-122.32289, 37.54988], [-122.3213, 37.54842], [-122.32142, 37.54837], [-122.32155, 37.54836], [-122.32166, 37.54838], [-122.32176, 37.54843], [-122.32314, 37.54969]]]} | Open Access 1 | 14083 | Borel Park | 16283 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.55 | Borel Park | 1961 | Local Park 2 | 4 | |
1861 | 1861 | 1860 | {"type": "Polygon", "coordinates": [[[-122.26088, 37.56684], [-122.26085, 37.5669], [-122.26054, 37.56681], [-122.26027, 37.56733], [-122.26011, 37.56728], [-122.25951, 37.56706], [-122.25907, 37.56688], [-122.2594, 37.5664], [-122.2591, 37.56626], [-122.25914, 37.56621], [-122.25944, 37.56634], [-122.25968, 37.566], [-122.26038, 37.56628], [-122.26074, 37.5664], [-122.26056, 37.56675], [-122.26088, 37.56684]]]} | Open Access 1 | 14244 | Gull Park | 19566 | 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 | 3.159 | Gull Park | 1960 | Local Park 2 | 4 | |
1864 | 1864 | 1863 | {"type": "Polygon", "coordinates": [[[-122.25871, 37.55141], [-122.25744, 37.55142], [-122.25742, 37.5509], [-122.25749, 37.55086], [-122.2587, 37.55088], [-122.25871, 37.55141]]]} | Open Access 1 | 14263 | Ketch Park | 20636 | 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 | 1.671 | Ketch Park | 1960 | Local Park 2 | 4 | |
1865 | 1865 | 1864 | {"type": "Polygon", "coordinates": [[[-122.18669, 37.44885], [-122.18632, 37.44929], [-122.18592, 37.44908], [-122.18628, 37.44864], [-122.18669, 37.44885]]]} | Open Access 1 | 14291 | Fremont Park | 19099 | 1202 | Menlo Park, City of 221 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | San Mateo 15 | 0.623 | Fremont Park | 2000 | Local Park 2 | 4 | |
1867 | 1867 | 1866 | {"type": "Polygon", "coordinates": [[[-122.27003, 37.5051], [-122.26987, 37.50524], [-122.26967, 37.50515], [-122.26955, 37.505], [-122.26955, 37.5049], [-122.26958, 37.50477], [-122.2698, 37.50484], [-122.26984, 37.50489], [-122.26999, 37.50499], [-122.27003, 37.5051]]]} | Open Access 1 | 14358 | Hillcrest Circle Park | 19964 | 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.33 | Hillcrest Circle Park | 1996 | Local Park 2 | 4 | |
1868 | 1868 | 1867 | {"type": "Polygon", "coordinates": [[[-122.43844, 37.4616], [-122.43838, 37.46201], [-122.43776, 37.46195], [-122.43782, 37.46154], [-122.43844, 37.4616]]]} | Open Access 1 | 14359 | Ocean View Park | 23059 | 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 | San Mateo 15 | 0.618 | Ocean View Park | 0 | Local Park 2 | 4 | |
1869 | 1869 | 1868 | {"type": "Polygon", "coordinates": [[[-122.40706, 37.62384], [-122.40529, 37.62418], [-122.40408, 37.62412], [-122.40388, 37.62311], [-122.40617, 37.62255], [-122.40706, 37.62384]]]} | Open Access 1 | 14391 | Lions Park | 21323 | 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 | 8.503 | Lions Park | 1954 | Local Park 2 | 4 | |
1952 | 1952 | 1951 | {"type": "Polygon", "coordinates": [[[-122.47443, 37.66522], [-122.47438, 37.66525], [-122.47419, 37.66532], [-122.47379, 37.6654], [-122.47341, 37.66542], [-122.47303, 37.66538], [-122.47278, 37.66533], [-122.47057, 37.66475], [-122.46938, 37.66442], [-122.46933, 37.66439], [-122.46932, 37.66434], [-122.4694, 37.66397], [-122.46939, 37.66333], [-122.47008, 37.66331], [-122.47006, 37.66266], [-122.47124, 37.6622], [-122.47138, 37.66215], [-122.47145, 37.66215], [-122.4715, 37.66219], [-122.47173, 37.6626], [-122.47194, 37.66291], [-122.47218, 37.66321], [-122.4724, 37.66344], [-122.4727, 37.66373], [-122.473, 37.66398], [-122.47372, 37.66447], [-122.474, 37.66469], [-122.47422, 37.66491], [-122.47439, 37.66509], [-122.47444, 37.66516], [-122.47443, 37.66522]]]} | Open Access 1 | 16663 | Gellert Park | 19251 | 1078 | Daly City, City of 427 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | San Mateo 15 | 20.57 | Gellert Park | 1971 | 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]);