superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and YR_EST = 1970
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
MNG_AGENCY 6
ACCESS_TYP 1
- Open Access · 7 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1996 | 1996 | 1995 | {"type": "Polygon", "coordinates": [[[-122.28634, 37.48596], [-122.28472, 37.48714], [-122.28549, 37.4878], [-122.28485, 37.48828], [-122.28461, 37.4881], [-122.28421, 37.48815], [-122.28328, 37.48773], [-122.28282, 37.48771], [-122.28311, 37.48727], [-122.28247, 37.48628], [-122.28141, 37.48627], [-122.28131, 37.48662], [-122.28168, 37.48719], [-122.28178, 37.48757], [-122.28183, 37.48786], [-122.28129, 37.48811], [-122.28062, 37.48864], [-122.27916, 37.48914], [-122.27859, 37.48926], [-122.27825, 37.4885], [-122.27793, 37.48827], [-122.27745, 37.48828], [-122.27681, 37.48873], [-122.27653, 37.4893], [-122.27607, 37.4889], [-122.2759, 37.48934], [-122.2748, 37.4889], [-122.27501, 37.48861], [-122.2757, 37.48893], [-122.27666, 37.48835], [-122.27684, 37.48736], [-122.27618, 37.48711], [-122.27602, 37.48735], [-122.2755, 37.48713], [-122.27626, 37.48661], [-122.27647, 37.48654], [-122.27659, 37.48676], [-122.27679, 37.48672], [-122.27698, 37.48674], [-122.27772, 37.48753], [-122.27811, 37.48826], [-122.2789, 37.48833], [-122.27917, 37.48779], [-122.27871, 37.48691], [-122.27798, 37.48621], [-122.27919, 37.48539], [-122.27978, 37.48516], [-122.28022, 37.48508], [-122.28133, 37.48519], [-122.28169, 37.48544], [-122.2817, 37.48541], [-122.28214, 37.48503], [-122.2827, 37.48443], [-122.2831, 37.48388], [-122.28339, 37.48326], [-122.28342, 37.48371], [-122.28364, 37.48452], [-122.28395, 37.48505], [-122.28451, 37.48559], [-122.28504, 37.48586], [-122.28572, 37.48588], [-122.28634, 37.48596]]]} | Open Access 1 | Big Canyon Park | 16077 | 1295 | San Carlos, City of 432 | City 2 | City Agency 2 | http://www.cityofsancarlos.org/depts/pr/default.asp | City 2 | 55.299 | Big Canyon Park | 1970 | |
5274 | 5274 | 5273 | {"type": "Polygon", "coordinates": [[[-122.6718, 38.45488], [-122.6715, 38.45491], [-122.67052, 38.45514], [-122.66999, 38.45567], [-122.66937, 38.45577], [-122.664, 38.4564], [-122.66196, 38.4572], [-122.66201, 38.45754], [-122.66181, 38.45757], [-122.66059, 38.45805], [-122.66056, 38.45805], [-122.65974, 38.45828], [-122.65973, 38.45625], [-122.6609, 38.4552], [-122.6609, 38.45518], [-122.66088, 38.45517], [-122.66193, 38.4541], [-122.66192, 38.45408], [-122.66197, 38.45406], [-122.66737, 38.45035], [-122.66768, 38.44951], [-122.66805, 38.44909], [-122.6682, 38.44925], [-122.66856, 38.44969], [-122.66934, 38.45101], [-122.6718, 38.45488]]]} | Open Access 1 | Howarth Park | 20122 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 111.55 | Howarth Park | 1970 | |
5732 | 5732 | 5731 | {"type": "Polygon", "coordinates": [[[-122.02155, 37.28917], [-122.01879, 37.28908], [-122.01896, 37.28635], [-122.01927, 37.28637], [-122.01962, 37.28677], [-122.02155, 37.28917]]]} | Open Access 1 | Kevin Moran Park | 20638 | 1326 | Saratoga, City of 513 | City 2 | City Agency 2 | http://www.saratoga.ca.us/cityhall/pw/parks/default.asp | City 2 | 10.276 | Kevin Moran Park | 1970 | |
6701 | 6701 | 6700 | {"type": "Polygon", "coordinates": [[[-122.25242, 37.52835], [-122.25194, 37.52876], [-122.25218, 37.52896], [-122.25152, 37.52954], [-122.25126, 37.52936], [-122.25077, 37.52979], [-122.25101, 37.53], [-122.25099, 37.53004], [-122.25099, 37.5301], [-122.25102, 37.53016], [-122.25107, 37.53021], [-122.25076, 37.53048], [-122.25068, 37.53043], [-122.25012, 37.53046], [-122.24915, 37.53133], [-122.24908, 37.5313], [-122.24808, 37.53219], [-122.2478, 37.53199], [-122.24802, 37.53178], [-122.24737, 37.53131], [-122.24892, 37.52996], [-122.24925, 37.53019], [-122.24948, 37.52999], [-122.2496, 37.53008], [-122.24968, 37.53007], [-122.25034, 37.5295], [-122.2506, 37.52967], [-122.25109, 37.52924], [-122.25085, 37.52905], [-122.25151, 37.52847], [-122.25177, 37.52865], [-122.25225, 37.52823], [-122.25242, 37.52835]]]} | Open Access 1 | Marlin Park | 21880 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 10.999 | Marlin Park | 1970 | |
9161 | 9161 | 9160 | {"type": "Polygon", "coordinates": [[[-122.28056, 37.50434], [-122.28023, 37.50445], [-122.27997, 37.50403], [-122.28033, 37.50392], [-122.28056, 37.50434]]]} | Open Access 1 | San Carlos Ave Neighborhood Park | 24844 | 1295 | San Carlos, City of 432 | City 2 | City Agency 2 | http://www.cityofsancarlos.org/depts/pr/default.asp | City 2 | 0.42 | San Carlos Ave Neighborhood Park | 1970 | |
10861 | 10861 | 10860 | {"type": "Polygon", "coordinates": [[[-122.33499, 37.58558], [-122.33435, 37.58606], [-122.33414, 37.58587], [-122.33432, 37.58575], [-122.33434, 37.58563], [-122.33475, 37.58536], [-122.33499, 37.58558]]]} | Open Access 1 | Victoria Park | 27078 | 1039 | Burlingame, City of 384 | City 2 | City Agency 2 | http://www.burlingame.org/index.aspx?page=33 | City 2 | 0.618 | Victoria Park | 1970 | |
14025 | 14025 | 14024 | {"type": "Polygon", "coordinates": [[[-122.4184, 37.60888], [-122.41819, 37.60887], [-122.41806, 37.60889], [-122.41726, 37.60916], [-122.41646, 37.60929], [-122.41644, 37.60926], [-122.4166, 37.60917], [-122.41668, 37.60909], [-122.41676, 37.60897], [-122.41686, 37.60875], [-122.41689, 37.60866], [-122.41688, 37.60847], [-122.41682, 37.60835], [-122.41562, 37.60661], [-122.41524, 37.60598], [-122.41429, 37.60425], [-122.41482, 37.60395], [-122.41507, 37.60389], [-122.41574, 37.60502], [-122.41588, 37.60505], [-122.4161, 37.6053], [-122.41616, 37.60556], [-122.4163, 37.60578], [-122.41648, 37.60593], [-122.41662, 37.60611], [-122.41699, 37.60641], [-122.41751, 37.6067], [-122.41763, 37.60683], [-122.41798, 37.60758], [-122.4182, 37.60776], [-122.41804, 37.60783], [-122.41779, 37.60848], [-122.41784, 37.60861], [-122.41803, 37.60881], [-122.41822, 37.60882], [-122.4184, 37.60888]]]} | Open Access 1 | Lomita Spur Trail | https://www.ci.millbrae.ca.us/home/showdocument?id=19758 | 32594 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 16.271 | Lomita Spur Trail | 1970 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);