superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where MNG_AG_TYP = 2 and YR_EST = 1968
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_WEB
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
857 | 857 | 856 | {"type": "Polygon", "coordinates": [[[-121.96948, 37.42504], [-121.96911, 37.42631], [-121.96897, 37.42625], [-121.96621, 37.4255], [-121.96617, 37.42548], [-121.96616, 37.42544], [-121.96616, 37.42534], [-121.96673, 37.42526], [-121.9667, 37.42508], [-121.96711, 37.42501], [-121.96723, 37.42536], [-121.96863, 37.42514], [-121.96837, 37.42417], [-121.96898, 37.42432], [-121.96891, 37.42472], [-121.96948, 37.42504]]]} | Open Access 1 | Alviso Park | 15432 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 6.598 | Alviso Park | 1968 | |
2443 | 2443 | 2442 | {"type": "Polygon", "coordinates": [[[-122.1629, 37.36432], [-122.16229, 37.3647], [-122.16191, 37.36476], [-122.16185, 37.36454], [-122.16028, 37.36435], [-122.16046, 37.36512], [-122.15954, 37.36527], [-122.15962, 37.36576], [-122.15884, 37.36605], [-122.15821, 37.36623], [-122.15804, 37.36625], [-122.15788, 37.36621], [-122.15731, 37.36594], [-122.15714, 37.36581], [-122.15695, 37.36561], [-122.15689, 37.36552], [-122.15686, 37.36542], [-122.15684, 37.36518], [-122.15681, 37.36505], [-122.15673, 37.3649], [-122.15666, 37.36479], [-122.15564, 37.36365], [-122.15552, 37.36353], [-122.1553, 37.36338], [-122.15454, 37.36294], [-122.15444, 37.36285], [-122.15435, 37.36275], [-122.15391, 37.36215], [-122.1548, 37.36188], [-122.15486, 37.3613], [-122.15455, 37.36088], [-122.15433, 37.36066], [-122.15462, 37.35983], [-122.15468, 37.3598], [-122.15598, 37.36056], [-122.15779, 37.36015], [-122.15749, 37.35841], [-122.1567, 37.35775], [-122.15616, 37.35772], [-122.15574, 37.35834], [-122.15479, 37.35873], [-122.15459, 37.35836], [-122.15412, 37.35852], [-122.15396, 37.35773], [-122.1547, 37.35721], [-122.1545, 37.35675], [-122.15406, 37.3564], [-122.15371, 37.35589], [-122.15195, 37.35513], [-122.15199, 37.35454], [-122.15207, 37.35431], [-122.15222, 37.35412], [-122.15234, 37.35377], [-122.15211, 37.35335], [-122.15238, 37.35351], [-122.15435, 37.35486], [-122.15491, 37.3554], [-122.1555, 37.35525], [-122.15595, 37.35548], [-122.15607, 37.35557], [-122.15665, 37.3561], [-122.15686, 37.35627], [-122.1573, 37.35678], [-122.15757, 37.35701], [-122.15821, 37.35746], [-122.15835, 37.35753], [-122.15881, 37.35765], [-122.15879, 37.35799], [-122.15874, 37.35816], [-122.15869, 37.35844], [-122.15867, 37.35892], [-122.1587, 37.35929], [-122.15866, 37.35963], [-122.15841, 37.36002], [-122.15833, 37.36025], [-122.15816, 37.36059], [-122.15812, 37.36084], [-122.1582, 37.36124], [-122.15844, 37.36166], [-122.15871, 37.36198], [-122.15885, 37.362], [-122.15894, 37.36235], [-122.15932, 37.36231], [-122.15937, 37.36237], [-122.15941, 37.36238], [-122.15954, 37.3627], [-122.16023, 37.36295], [-122.16124, 37.36311], [-122.16158, 37.36318], [-122.16226, 37.36325], [-122.16236, 37.36364], [-122.1629, 37.36432]]]} | No Public Access 3 | Byrne Reserve | 16619 | 1187 | Los Altos Hills, Town of 819 | City 2 | City Agency 2 | http://www.losaltoshills.ca.gov/parks-and-recreation/parks-and-recreation | City 2 | 100.188 | Byrne Reserve | 1968 | |
2560 | 2560 | 2559 | {"type": "Polygon", "coordinates": [[[-121.94013, 37.28614], [-121.93949, 37.28697], [-121.93833, 37.28699], [-121.93878, 37.28638], [-121.93884, 37.28637], [-121.93913, 37.28596], [-121.93937, 37.28575], [-121.93964, 37.28558], [-121.93985, 37.2855], [-121.93958, 37.28586], [-121.94013, 37.28614]]]} | Open Access 1 | Campbell Park | 16779 | 1043 | Campbell, City of 442 | City 2 | City Agency 2 | http://www.ci.campbell.ca.us/226/Recreation-Parks | City 2 | 3.044 | Campbell Park | 1968 | |
2832 | 2832 | 2831 | {"type": "Polygon", "coordinates": [[[-118.10504, 33.76752], [-118.10503, 33.76755], [-118.10488, 33.7677], [-118.10487, 33.76774], [-118.10488, 33.76781], [-118.10496, 33.76788], [-118.10478, 33.76807], [-118.10463, 33.76829], [-118.10453, 33.76851], [-118.10446, 33.76881], [-118.10442, 33.76956], [-118.1044, 33.77171], [-118.10433, 33.77169], [-118.10426, 33.7717], [-118.1042, 33.77174], [-118.10418, 33.7718], [-118.1042, 33.77187], [-118.10426, 33.77192], [-118.10435, 33.77192], [-118.10441, 33.77189], [-118.1044, 33.77411], [-118.10409, 33.77412], [-118.10408, 33.77402], [-118.10409, 33.76939], [-118.10411, 33.76887], [-118.10418, 33.76857], [-118.1043, 33.76826], [-118.10441, 33.76807], [-118.10453, 33.7679], [-118.10471, 33.76769], [-118.10488, 33.76753], [-118.10488, 33.76751], [-118.10482, 33.76748], [-118.10486, 33.76746], [-118.105, 33.76749], [-118.10504, 33.76752]]]} | Open Access 1 | Channel View Park | 17123 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 5.302 | Channel View Park | 1968 | |
5589 | 5589 | 5588 | {"type": "Polygon", "coordinates": [[[-122.16402, 37.44949], [-122.16354, 37.44998], [-122.16245, 37.44929], [-122.16293, 37.4488], [-122.16402, 37.44949]]]} | Open Access 1 | Johnson Park | 20478 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 2.092 | Johnson Park | 1968 | |
5936 | 5936 | 5935 | {"type": "Polygon", "coordinates": [[[-121.99104, 37.31833], [-121.99006, 37.31807], [-121.98956, 37.31796], [-121.98887, 37.31783], [-121.98886, 37.31751], [-121.9889, 37.31748], [-121.98891, 37.31744], [-121.98887, 37.3173], [-121.98888, 37.31598], [-121.9893, 37.31588], [-121.9898, 37.31567], [-121.98986, 37.31569], [-121.9901, 37.31583], [-121.99032, 37.3159], [-121.99057, 37.31593], [-121.99093, 37.31593], [-121.99095, 37.31828], [-121.99104, 37.3183], [-121.99104, 37.31833]]]} | Open Access 1 | Mise | 22290 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 10.989 | Mise | 1968 | |
5976 | 5976 | 5975 | {"type": "MultiPolygon", "coordinates": [[[[-121.88339, 37.45608], [-121.88337, 37.4563], [-121.88338, 37.45677], [-121.88435, 37.4581], [-121.88439, 37.45824], [-121.88437, 37.45839], [-121.88411, 37.45895], [-121.88403, 37.45929], [-121.88405, 37.45947], [-121.8842, 37.45998], [-121.88427, 37.46011], [-121.88428, 37.46025], [-121.88426, 37.46033], [-121.88418, 37.46043], [-121.88411, 37.46048], [-121.88396, 37.46054], [-121.88309, 37.46065], [-121.88178, 37.46067], [-121.88137, 37.46076], [-121.88108, 37.46086], [-121.88083, 37.46088], [-121.88066, 37.46086], [-121.8805, 37.46082], [-121.88035, 37.46074], [-121.88025, 37.46066], [-121.88017, 37.46062], [-121.87999, 37.46055], [-121.87981, 37.46051], [-121.87961, 37.4605], [-121.87917, 37.46053], [-121.87856, 37.46052], [-121.8784, 37.46049], [-121.87804, 37.46039], [-121.87785, 37.46038], [-121.87772, 37.46041], [-121.87761, 37.46046], [-121.87747, 37.46057], [-121.87741, 37.46066], [-121.87729, 37.46096], [-121.87717, 37.46109], [-121.87706, 37.46115], [-121.87694, 37.46119], [-121.87674, 37.46119], [-121.87662, 37.46116], [-121.8765, 37.4611], [-121.8762, 37.46082], [-121.87607, 37.46075], [-121.87593, 37.4607], [-121.87578, 37.46068], [-121.87563, 37.46068], [-121.87548, 37.46071], [-121.87525, 37.46079], [-121.87514, 37.4608], [-121.87503, 37.46079], [-121.87488, 37.46072], [-121.8748, 37.46066], [-121.8747, 37.46049], [-121.87461, 37.46041], [-121.87362, 37.45984], [-121.87344, 37.45971], [-121.87206, 37.45854], [-121.87198, 37.45846], [-121.87193, 37.45832], [-121.87195, 37.45818], [-121.87204, 37.45805], [-121.87213, 37.45799], [-121.87224, 37.45795], [-121.87242, 37.45794], [-121.87485, 37.45908], [-121.87732, 37.45937], [-121.87879, 37.45978], [-121.88001, 37.45977], [-121.88283, 37.45912], [-121.88265, 37.45858], [-121.8803, 37.4566], [-121.88033, 37.45653], [-121.8803, 37.45623], [-121.88032, 37.45611], [-121.8804, 37.45588], [-121.88047, 37.45578], [-121.88057, 37.4557], [-121.88069, 37.45564], [-121.88087, 37.4556], [-121.88107, 37.45562], [-121.88145, 37.45576], [-121.88161, 37.4558], [-121.88178, 37.45582], [-121.88179, 37.45583], [-121.88202, 37.45582], [-121.88204, 37.4558], [-121.8826, 37.4557], [-121.88283, 37.456], [-121.88339, 37.45608]]], [[[-121.88252, 37.45558], [-121.88232, 37.45562], [-121.88213, 37.45555], [-121.88192, 37.45557], [-121.88187, 37.45561], [-121.88188, 37.45567], [-121.88178, 37.4557], [-121.88177, 37.45572], [-121.8815, 37.45567], [-121.88104, 37.45551], [-121.88083, 37.4555], [-121.88063, 37.45555], [-121.88045, 37.45566], [-121.88036, 37.45574], [-121.88031, 37.45583], [-121.88022, 37.45609], [-121.88019, 37.45622], [-121.88012, 37.45628], [-121.88009, 37.45632], [-121.88009, 37.45636], [-121.88015, 37.45643], [-121.88016, 37.45649], [-121.87827, 37.45541], [-121.87696, 37.45533], [-121.87678, 37.4554], [-121.87665, 37.45537], [-121.87645, 37.45535], [-121.87636, 37.45547], [-121.87557, 37.45586], [-121.8754, 37.4557], [-121.87528, 37.45562], [-121.87506, 37.45557], [-121.87468, 37.45575], [-121.87388, 37.45513], [-121.87366, 37.45498], [-121.8734, 37.45488], [-121.87276, 37.45472], [-121.87252, 37.4546], [-121.87234, 37.45443], [-121.87225, 37.4543], [-121.87217, 37.45409], [-121.87216, 37.45388], [-121.87222, 37.45367], [-121.87231, 37.45354], [-121.87249, 37.45339], [-121.87264, 37.45331], [-121.87283, 37.45325], [-121.87345, 37.45312], [-121.87612, 37.45241], [-121.87637, 37.45237], [-121.87663, 37.45234], [-121.87754, 37.45237], [-121.8777, 37.4524], [-121.87796, 37.45256], [-121.8781, 37.4526], [-121.87825, 37.4526], [-121.87839, 37.45256], [-121.87853, 37.45251], [-121.87865, 37.45243], [-121.87898, 37.45216], [-121.8791, 37.4521], [-121.87929, 37.45205], [-121.8795, 37.45206], [-121.87963, 37.4521], [-121.87976, 37.45216], [-121.88012, 37.45239], [-121.88033, 37.45256], [-121.88061, 37.45284], [-121.8821, 37.45502], [-121.88252, 37.45558]]]]} | Restricted Access 2 | Summit Pointe Golf Course | 33044 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 121.039 | Summit Pointe GC | 1968 | |
11222 | 11222 | 11221 | {"type": "Polygon", "coordinates": [[[-122.03638, 37.25821], [-122.03593, 37.25874], [-122.03597, 37.25918], [-122.03594, 37.25923], [-122.03589, 37.25925], [-122.03554, 37.25925], [-122.03493, 37.25809], [-122.03453, 37.25824], [-122.03447, 37.25816], [-122.03424, 37.25825], [-122.03421, 37.25833], [-122.03411, 37.25826], [-122.03489, 37.25761], [-122.03528, 37.2575], [-122.03535, 37.25755], [-122.03535, 37.25758], [-122.03543, 37.25755], [-122.03563, 37.25759], [-122.03569, 37.25752], [-122.03636, 37.25777], [-122.03625, 37.25777], [-122.03609, 37.25782], [-122.0361, 37.25788], [-122.0362, 37.2581], [-122.03638, 37.25821]]]} | Open Access 1 | Wildwood Park | 27522 | 1326 | Saratoga, City of 513 | City 2 | City Agency 2 | http://www.saratoga.ca.us/cityhall/pw/parks/default.asp | City 2 | 4.494 | Wildwood Park | 1968 | |
14022 | 14022 | 14021 | {"type": "Polygon", "coordinates": [[[-122.3999, 37.58571], [-122.39987, 37.58599], [-122.3996, 37.58686], [-122.39943, 37.58704], [-122.39939, 37.58702], [-122.39902, 37.58728], [-122.39888, 37.58699], [-122.39867, 37.58671], [-122.39849, 37.58655], [-122.39799, 37.58618], [-122.39778, 37.58598], [-122.39862, 37.58586], [-122.39976, 37.58546], [-122.3999, 37.58571]]]} | Open Access 1 | Mills Estates Park | https://www.ci.millbrae.ca.us/departments-services/public-works/parks-division/mills-estates-park | 32592 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 4.612 | Mills Estates Park | 1968 |
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]);