units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
57 rows where DES_TP = 2, MNG_AG_TYP = 2 and YR_EST = 1973
This data as json, copyable, CSV (advanced)
MNG_AGENCY 17
- Milpitas, City of 13
- Fremont, City of 10
- Newark, City of 8
- Santa Clara, City of 5
- Redwood City, City of 4
- San Mateo, City of 2
- San Bruno, City of 2
- Napa, City of 2
- Los Altos, City of 2
- Mountain View, City of 2
- San Jose, City of 1
- Palo Alto, City of 1
- Belmont, City of 1
- Menlo Park, City of 1
- Lafayette, City of 1
- Millbrae, City of 1
- Saratoga, City of 1
MNG_AG_TYP 1
- City Agency · 57 ✖
DES_TP 1
- Local Park · 57 ✖
ACCESS_TYP 1
- Open Access 57
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
525 | 525 | 524 | {"type": "Polygon", "coordinates": [[[-122.28056, 37.51666], [-122.27928, 37.5168], [-122.27927, 37.51676], [-122.27901, 37.5168], [-122.2788, 37.51686], [-122.27858, 37.51694], [-122.27812, 37.5172], [-122.27801, 37.51738], [-122.2779, 37.51753], [-122.27782, 37.51767], [-122.27777, 37.51779], [-122.27768, 37.51815], [-122.27757, 37.51845], [-122.2773, 37.5182], [-122.27733, 37.51818], [-122.27729, 37.51815], [-122.27737, 37.51806], [-122.27653, 37.5173], [-122.27651, 37.5173], [-122.27646, 37.51725], [-122.27647, 37.51723], [-122.27643, 37.5172], [-122.27659, 37.51717], [-122.27668, 37.51694], [-122.27696, 37.51665], [-122.27662, 37.5163], [-122.27952, 37.5138], [-122.28056, 37.51666]]]} | Open Access 1 | 1741 | Twin Pines Park | 26622 | 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 | 19.848 | Twin Pines Park | 1973 | Local Park 2 | 4 | |
536 | 536 | 535 | {"type": "Polygon", "coordinates": [[[-122.15574, 37.44328], [-122.1555, 37.44352], [-122.15524, 37.44335], [-122.15548, 37.44311], [-122.15574, 37.44328]]]} | Open Access 1 | 15226 | Scott Park | 25205 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 0.258 | Scott Park | 1973 | Local Park 2 | 4 | |
620 | 620 | 619 | {"type": "Polygon", "coordinates": [[[-121.90776, 37.25402], [-121.90738, 37.25423], [-121.90704, 37.25406], [-121.90677, 37.2541], [-121.90671, 37.25396], [-121.90666, 37.2539], [-121.90622, 37.2536], [-121.90607, 37.25347], [-121.90602, 37.25341], [-121.90597, 37.25326], [-121.906, 37.2529], [-121.90599, 37.25284], [-121.90585, 37.25248], [-121.90672, 37.25225], [-121.90776, 37.25402]]]} | Open Access 1 | 2365 | Branham Park | 16332 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 4.919 | Branham Park | 1973 | Local Park 2 | 4 | |
786 | 786 | 785 | {"type": "Polygon", "coordinates": [[[-122.10174, 37.85993], [-122.10174, 37.86191], [-122.10034, 37.86391], [-122.09999, 37.86392], [-122.09965, 37.86438], [-122.09912, 37.86403], [-122.09873, 37.86468], [-122.09828, 37.8651], [-122.09781, 37.86516], [-122.09794, 37.8657], [-122.09807, 37.86602], [-122.0979, 37.86635], [-122.09797, 37.86662], [-122.09815, 37.8669], [-122.09776, 37.86746], [-122.09806, 37.86777], [-122.09807, 37.86819], [-122.09803, 37.86883], [-122.09759, 37.86962], [-122.09705, 37.86926], [-122.09627, 37.8684], [-122.0955, 37.86773], [-122.09513, 37.86732], [-122.09484, 37.86714], [-122.09459, 37.86673], [-122.0961, 37.86643], [-122.09667, 37.86596], [-122.09734, 37.86507], [-122.09768, 37.86456], [-122.09766, 37.86387], [-122.09799, 37.86358], [-122.09332, 37.86072], [-122.09488, 37.86046], [-122.09586, 37.86008], [-122.09628, 37.86048], [-122.09757, 37.86078], [-122.09879, 37.86062], [-122.10029, 37.86018], [-122.10174, 37.85993]]]} | Open Access 1 | 5101 | Lafayette Community Park | 20830 | 1163 | Lafayette, City of 236 | City 2 | City Agency 2 | http://www.ci.lafayette.ca.us/index.aspx?page=87 | City 2 | 1163 | Lafayette, City of 232 | City 2 | City Agency 2 | Contra Costa 12 | 70.977 | Lafayette Community Park | 1973 | Local Park 2 | 4 | |
1501 | 1501 | 1500 | {"type": "Polygon", "coordinates": [[[-122.01802, 37.53174], [-122.0169, 37.53312], [-122.01436, 37.53181], [-122.01549, 37.53039], [-122.01802, 37.53174]]]} | Open Access 1 | 12740 | Birch Grove Park | 16116 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 12.218 | Birch Grove Park | 1973 | Local Park 2 | 4 | |
1511 | 1511 | 1510 | {"type": "Polygon", "coordinates": [[[-122.05125, 37.54145], [-122.05097, 37.54229], [-122.05084, 37.54249], [-122.05067, 37.54266], [-122.04921, 37.54073], [-122.04898, 37.54054], [-122.04953, 37.54009], [-122.04957, 37.54009], [-122.04963, 37.54011], [-122.04965, 37.54009], [-122.05123, 37.5414], [-122.05125, 37.54145]]]} | Open Access 1 | 12752 | Mirabeau Park | 22280 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 6.07 | Mirabeau Park | 1973 | Local Park 2 | 4 | |
1545 | 1545 | 1544 | {"type": "Polygon", "coordinates": [[[-121.92081, 37.47824], [-121.92042, 37.47893], [-121.91967, 37.47868], [-121.91913, 37.47883], [-121.91902, 37.47896], [-121.91873, 37.47891], [-121.91828, 37.47906], [-121.91812, 37.47925], [-121.91824, 37.47946], [-121.91842, 37.47985], [-121.9173, 37.48026], [-121.91631, 37.47851], [-121.91682, 37.47833], [-121.9171, 37.47884], [-121.91744, 37.47892], [-121.91786, 37.47879], [-121.91967, 37.47812], [-121.92003, 37.47831], [-121.92062, 37.47809], [-121.92078, 37.47818], [-121.92081, 37.47821], [-121.92081, 37.47824]]]} | Open Access 1 | 12981 | Booster Park | 16273 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 8.178 | Booster Park | 1973 | Local Park 2 | 4 | |
1644 | 1644 | 1643 | {"type": "Polygon", "coordinates": [[[-121.96249, 37.39315], [-121.96184, 37.39343], [-121.96118, 37.39246], [-121.96183, 37.39218], [-121.96249, 37.39315]]]} | Open Access 1 | 14134 | Agnew Park | 15287 | 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 | Santa Clara 19 | 1.999 | Agnew Park | 1973 | Local Park 2 | 4 | |
1647 | 1647 | 1646 | {"type": "Polygon", "coordinates": [[[-121.99345, 37.34515], [-121.99312, 37.3453], [-121.99136, 37.34629], [-121.99125, 37.34633], [-121.99079, 37.34645], [-121.99029, 37.34667], [-121.99012, 37.34679], [-121.98981, 37.34711], [-121.98982, 37.3452], [-121.99311, 37.34513], [-121.99345, 37.34515]]]} | Open Access 1 | 14174 | Earl R. Carmichael Park | 18352 | 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 | Santa Clara 19 | 8.11 | Earl R. Carmichael Park | 1973 | Local Park 2 | 4 | |
1697 | 1697 | 1696 | {"type": "Polygon", "coordinates": [[[-122.04168, 37.53797], [-122.04001, 37.53932], [-122.03814, 37.53786], [-122.0383, 37.53775], [-122.03857, 37.53796], [-122.0392, 37.5381], [-122.03926, 37.53805], [-122.03939, 37.53805], [-122.03948, 37.538], [-122.03952, 37.53789], [-122.03956, 37.53785], [-122.04084, 37.53698], [-122.04089, 37.53697], [-122.04093, 37.53698], [-122.04107, 37.53716], [-122.0413, 37.53755], [-122.04141, 37.5377], [-122.04154, 37.53784], [-122.04168, 37.53797]]]} | Open Access 1 | 12774 | Mayhews Landing Park | 21977 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 8.356 | Mayhews Landing Park | 1973 | Local Park 2 | 4 | |
1716 | 1716 | 1715 | {"type": "Polygon", "coordinates": [[[-122.01159, 37.54533], [-122.01151, 37.54542], [-122.01126, 37.54529], [-122.01121, 37.54529], [-122.01094, 37.54515], [-122.01092, 37.54508], [-122.01075, 37.54499], [-122.01066, 37.545], [-122.01051, 37.54492], [-122.01035, 37.54512], [-122.01046, 37.54522], [-122.01042, 37.54527], [-122.01034, 37.54524], [-122.0101, 37.5453], [-122.01001, 37.54541], [-122.00973, 37.54527], [-122.00993, 37.54502], [-122.00997, 37.54503], [-122.01024, 37.5447], [-122.01, 37.54457], [-122.01005, 37.54451], [-122.01048, 37.54474], [-122.0105, 37.54479], [-122.01071, 37.54489], [-122.01076, 37.54489], [-122.01103, 37.54503], [-122.01105, 37.54508], [-122.01125, 37.54518], [-122.01129, 37.54517], [-122.01159, 37.54533]]]} | Open Access 1 | 12873 | Plaza Park | 23782 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 1.095 | Plaza Park | 1973 | Local Park 2 | 4 | |
1744 | 1744 | 1743 | {"type": "Polygon", "coordinates": [[[-121.88461, 37.43237], [-121.88435, 37.43242], [-121.88427, 37.4322], [-121.88428, 37.43213], [-121.88432, 37.43208], [-121.88439, 37.43203], [-121.88449, 37.43201], [-121.88461, 37.43237]]]} | Open Access 1 | 14998 | Selwyn Park | 25293 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 0.227 | Selwyn Park | 1973 | Local Park 2 | 4 | |
1751 | 1751 | 1750 | {"type": "Polygon", "coordinates": [[[-121.98462, 37.5346], [-121.98436, 37.5349], [-121.98351, 37.53593], [-121.98325, 37.53578], [-121.98309, 37.53561], [-121.98301, 37.53546], [-121.98399, 37.53428], [-121.98462, 37.5346]]]} | Open Access 1 | 13032 | Noll Park | 22784 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 2.784 | Noll Park | 1973 | Local Park 2 | 4 | |
1950 | 1950 | 1949 | {"type": "Polygon", "coordinates": [[[-121.87669, 37.4267], [-121.87498, 37.42707], [-121.87494, 37.42706], [-121.87495, 37.42699], [-121.87476, 37.42644], [-121.87469, 37.42638], [-121.87473, 37.42633], [-121.87455, 37.42582], [-121.8745, 37.42579], [-121.87451, 37.42571], [-121.87432, 37.42517], [-121.8743, 37.42514], [-121.87425, 37.4251], [-121.87428, 37.42506], [-121.8741, 37.42453], [-121.87423, 37.42451], [-121.87438, 37.42468], [-121.87441, 37.42469], [-121.87517, 37.42452], [-121.87517, 37.4243], [-121.87527, 37.42428], [-121.8754, 37.42466], [-121.87527, 37.42488], [-121.87547, 37.4251], [-121.87542, 37.42514], [-121.87538, 37.42518], [-121.87537, 37.42522], [-121.87539, 37.42528], [-121.87581, 37.42574], [-121.87588, 37.42577], [-121.87589, 37.42582], [-121.87629, 37.42626], [-121.87636, 37.42627], [-121.87637, 37.42635], [-121.87669, 37.4267]]]} | Open Access 1 | 15011 | Murphy Park | 22608 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 7.798 | Murphy Park | 1973 | Local Park 2 | 4 | |
5040 | 5040 | 5039 | {"type": "Polygon", "coordinates": [[[-122.09876, 37.4007], [-122.09756, 37.40264], [-122.0975, 37.40268], [-122.09744, 37.40267], [-122.0967, 37.40237], [-122.09438, 37.40146], [-122.09631, 37.39834], [-122.09737, 37.39876], [-122.09675, 37.39978], [-122.09672, 37.39987], [-122.09693, 37.39997], [-122.09876, 37.4007]]]} | Open Access 1 | 91 | Rengstorff Park | 24294 | 1218 | Mountain View, City of 460 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | Santa Clara 19 | 22.617 | Rengstorff Park | 1973 | Local Park 2 | 4 | |
5098 | 5098 | 5097 | {"type": "Polygon", "coordinates": [[[-122.25555, 37.52901], [-122.25518, 37.52934], [-122.2546, 37.52891], [-122.25483, 37.52871], [-122.25485, 37.52865], [-122.25506, 37.52866], [-122.25555, 37.52901]]]} | Open Access 1 | 13902 | Portside Park | 23914 | 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.831 | Portside Park | 1973 | Local Park 2 | 4 | |
5099 | 5099 | 5098 | {"type": "Polygon", "coordinates": [[[-122.25293, 37.53131], [-122.2526, 37.5316], [-122.25233, 37.53161], [-122.25197, 37.53135], [-122.25228, 37.53108], [-122.25237, 37.53112], [-122.25245, 37.53112], [-122.25252, 37.5311], [-122.25259, 37.53106], [-122.25293, 37.53131]]]} | Open Access 1 | 13904 | Sandpiper Point Park | 25021 | 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.784 | Sandpiper Point Park | 1973 | Local Park 2 | 4 | |
5100 | 5100 | 5099 | {"type": "Polygon", "coordinates": [[[-122.25491, 37.52957], [-122.25453, 37.52991], [-122.25419, 37.52966], [-122.25424, 37.52957], [-122.25423, 37.52947], [-122.25447, 37.52926], [-122.25491, 37.52957]]]} | Open Access 1 | 13906 | Starboard Park | 25803 | 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.62 | Starboard Park | 1973 | Local Park 2 | 4 | |
5418 | 5418 | 5417 | {"type": "Polygon", "coordinates": [[[-121.8988, 37.45054], [-121.8986, 37.45066], [-121.89844, 37.45038], [-121.89824, 37.45045], [-121.89799, 37.45049], [-121.89792, 37.4502], [-121.89827, 37.45014], [-121.89814, 37.44962], [-121.89803, 37.44943], [-121.8956, 37.44692], [-121.89593, 37.4469], [-121.89822, 37.44927], [-121.89829, 37.44931], [-121.89836, 37.4494], [-121.89846, 37.44943], [-121.89854, 37.44942], [-121.89861, 37.44938], [-121.89867, 37.44929], [-121.8988, 37.44927], [-121.899, 37.44927], [-121.89915, 37.44931], [-121.89919, 37.44933], [-121.89921, 37.4494], [-121.8988, 37.45054]]]} | Open Access 1 | 14971 | Sandalwood Park | 25014 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 4.668 | Sandalwood Park | 1973 | Local Park 2 | 4 | |
6016 | 6016 | 6015 | {"type": "Polygon", "coordinates": [[[-122.21219, 37.43296], [-122.21168, 37.433], [-122.21126, 37.43301], [-122.2108, 37.43298], [-122.21028, 37.43286], [-122.20983, 37.43272], [-122.2094, 37.43252], [-122.20901, 37.43238], [-122.20853, 37.43223], [-122.20811, 37.43215], [-122.20783, 37.43243], [-122.20732, 37.43216], [-122.20858, 37.43058], [-122.20888, 37.43058], [-122.20903, 37.43073], [-122.20908, 37.43093], [-122.20928, 37.4311], [-122.20954, 37.43115], [-122.21018, 37.43117], [-122.21054, 37.4312], [-122.21098, 37.43195], [-122.21106, 37.43249], [-122.21159, 37.43261], [-122.21201, 37.4326], [-122.21219, 37.43296]]]} | Open Access 1 | 695 | Sharon Hill Park | 25362 | 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 | 12.961 | Sharon Hill Park | 1973 | 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]);