superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where MNG_AG_TYP = 2 and YR_EST = 1998
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
209 | 209 | 208 | {"type": "Polygon", "coordinates": [[[-121.89428, 37.23794], [-121.89425, 37.23798], [-121.89372, 37.23825], [-121.89364, 37.23832], [-121.89355, 37.23842], [-121.89352, 37.23843], [-121.89349, 37.23841], [-121.89266, 37.23738], [-121.8926, 37.23734], [-121.89286, 37.2372], [-121.8927, 37.23699], [-121.89264, 37.23682], [-121.89285, 37.23678], [-121.89293, 37.23697], [-121.89334, 37.23689], [-121.89324, 37.23638], [-121.89339, 37.23647], [-121.89347, 37.23656], [-121.89357, 37.23685], [-121.89349, 37.23689], [-121.89352, 37.23696], [-121.89427, 37.23791], [-121.89428, 37.23794]]]} | Open Access 1 | Almaden Winery Park | 15391 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 3.616 | Almaden Winery Park | 1998 | |
1331 | 1331 | 1330 | {"type": "MultiPolygon", "coordinates": [[[[-121.8745, 37.24237], [-121.87114, 37.24308], [-121.86974, 37.24299], [-121.86921, 37.24284], [-121.86916, 37.24032], [-121.86917, 37.23982], [-121.87002, 37.23903], [-121.8703, 37.23842], [-121.86993, 37.23811], [-121.8704, 37.23743], [-121.87043, 37.23726], [-121.87031, 37.23705], [-121.87024, 37.23673], [-121.87044, 37.2367], [-121.87153, 37.2368], [-121.87286, 37.23664], [-121.87313, 37.23707], [-121.87327, 37.23783], [-121.87198, 37.23837], [-121.87207, 37.23927], [-121.87209, 37.23928], [-121.87353, 37.23875], [-121.87432, 37.24069], [-121.87452, 37.2413], [-121.87459, 37.24175], [-121.87458, 37.24219], [-121.8745, 37.24237]]], [[[-121.87421, 37.24683], [-121.87403, 37.248], [-121.87327, 37.24819], [-121.87217, 37.24946], [-121.87134, 37.24941], [-121.87124, 37.25039], [-121.86991, 37.25028], [-121.87066, 37.24708], [-121.87073, 37.2471], [-121.87233, 37.24556], [-121.87239, 37.24556], [-121.87276, 37.24568], [-121.87286, 37.24589], [-121.87288, 37.24654], [-121.873, 37.24659], [-121.87334, 37.24645], [-121.8734, 37.24649], [-121.87345, 37.24659], [-121.87352, 37.2466], [-121.87359, 37.24666], [-121.87362, 37.24675], [-121.8737, 37.24681], [-121.87388, 37.24683], [-121.87403, 37.24682], [-121.87421, 37.24683]]]]} | Open Access 1 | Almaden Lake | 15389 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 86.243 | Almaden Lake | 1998 | |
1437 | 1437 | 1436 | {"type": "MultiPolygon", "coordinates": [[[[-121.79422, 37.23369], [-121.79422, 37.23411], [-121.79394, 37.2341], [-121.79396, 37.23297], [-121.7941, 37.23298], [-121.79415, 37.23301], [-121.79415, 37.2334], [-121.79412, 37.23355], [-121.79415, 37.23363], [-121.79422, 37.23369]]], [[[-121.79425, 37.23083], [-121.79424, 37.23137], [-121.79415, 37.23143], [-121.79411, 37.23151], [-121.79411, 37.23157], [-121.79414, 37.2317], [-121.79414, 37.23196], [-121.79409, 37.23208], [-121.7941, 37.23215], [-121.79413, 37.23219], [-121.79422, 37.23227], [-121.79422, 37.23281], [-121.79396, 37.23281], [-121.79398, 37.23083], [-121.79425, 37.23083]]], [[[-121.79425, 37.23012], [-121.79425, 37.23066], [-121.79397, 37.23067], [-121.79398, 37.23012], [-121.79425, 37.23012]]]]} | Open Access 1 | Albertson Parkway | 15341 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 2.047 | Albertson Parkway | 1998 | |
2141 | 2141 | 2140 | {"type": "Polygon", "coordinates": [[[-121.87643, 37.24514], [-121.87505, 37.24548], [-121.87496, 37.24522], [-121.87496, 37.24514], [-121.87531, 37.24513], [-121.876, 37.24502], [-121.87635, 37.24494], [-121.87643, 37.24514]]]} | Open Access 1 | Chris Hotts Park | 17222 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.878 | Chris Hotts Park | 1998 | |
3624 | 3624 | 3623 | {"type": "Polygon", "coordinates": [[[-121.89406, 37.32792], [-121.89275, 37.32857], [-121.89265, 37.3285], [-121.8925, 37.32845], [-121.89138, 37.32763], [-121.8911, 37.32724], [-121.89105, 37.32715], [-121.89102, 37.32702], [-121.89101, 37.32684], [-121.89111, 37.3266], [-121.89112, 37.32646], [-121.89111, 37.32609], [-121.89113, 37.32566], [-121.89146, 37.32555], [-121.89168, 37.32557], [-121.89406, 37.32792]]]} | Open Access 1 | Discovery Meadow | 18164 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 11.492 | Discovery Meadow | 1998 | |
3980 | 3980 | 3979 | {"type": "Polygon", "coordinates": [[[-121.87932, 37.71033], [-121.87889, 37.71066], [-121.87865, 37.71097], [-121.8787, 37.71169], [-121.87816, 37.7125], [-121.87229, 37.71242], [-121.87235, 37.70994], [-121.87327, 37.70992], [-121.87444, 37.7098], [-121.87538, 37.70957], [-121.87712, 37.70894], [-121.87827, 37.70876], [-121.87927, 37.70879], [-121.87941, 37.70991], [-121.87932, 37.71033]]]} | Open Access 1 | Emerald Glen Park | 18614 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 49.117 | Emerald Glen Park | 1998 | |
4711 | 4711 | 4710 | {"type": "Polygon", "coordinates": [[[-121.90177, 37.31871], [-121.90143, 37.31907], [-121.90143, 37.31907], [-121.90145, 37.3187], [-121.90177, 37.31871]]]} | Open Access 1 | Gregory Plaza Tot Lot | 19501 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.146 | Gregory Plaza Tot Lot | 1998 | |
11921 | 11921 | 11920 | {"type": "MultiPolygon", "coordinates": [[[[-120.65113, 35.26821], [-120.65121, 35.26863], [-120.65115, 35.26905], [-120.65112, 35.2692], [-120.6511, 35.26907], [-120.65069, 35.26907], [-120.65068, 35.26823], [-120.65061, 35.26821], [-120.6506, 35.26808], [-120.64979, 35.26807], [-120.64979, 35.26784], [-120.6499, 35.26748], [-120.64949, 35.26732], [-120.64925, 35.26727], [-120.64799, 35.26587], [-120.64717, 35.26522], [-120.64705, 35.26501], [-120.64543, 35.26502], [-120.6463, 35.26418], [-120.6441, 35.26144], [-120.64438, 35.26143], [-120.64607, 35.26355], [-120.64648, 35.26403], [-120.6472, 35.26495], [-120.64806, 35.26558], [-120.65018, 35.26686], [-120.65007, 35.26689], [-120.65051, 35.26715], [-120.6505, 35.26723], [-120.65042, 35.26725], [-120.65017, 35.26742], [-120.65008, 35.26754], [-120.65021, 35.26759], [-120.65035, 35.26745], [-120.65045, 35.26738], [-120.65054, 35.26736], [-120.65064, 35.26737], [-120.65075, 35.26743], [-120.65084, 35.26751], [-120.65095, 35.26769], [-120.65107, 35.26796], [-120.65113, 35.26821]]], [[[-120.6551, 35.27467], [-120.65496, 35.27451], [-120.65502, 35.27417], [-120.65502, 35.27394], [-120.655, 35.27378], [-120.65496, 35.27356], [-120.65486, 35.27328], [-120.65477, 35.2731], [-120.65245, 35.26974], [-120.65236, 35.26973], [-120.65236, 35.26961], [-120.65211, 35.26932], [-120.65193, 35.26903], [-120.65131, 35.26903], [-120.65137, 35.26862], [-120.65123, 35.2679], [-120.65103, 35.2675], [-120.6509, 35.26736], [-120.65104, 35.26744], [-120.65135, 35.26774], [-120.65214, 35.26877], [-120.65262, 35.26946], [-120.65269, 35.26961], [-120.65408, 35.27162], [-120.65489, 35.27288], [-120.65481, 35.27293], [-120.65499, 35.2733], [-120.65518, 35.27398], [-120.65519, 35.2742], [-120.65518, 35.27438], [-120.6551, 35.27467]]]]} | Open Access 1 | Railroad Safety Trail | 28708 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 17.541 | Railroad Safety Trail | 1998 | |
13845 | 13845 | 13844 | {"type": "MultiPolygon", "coordinates": [[[[-121.88664, 37.23864], [-121.88642, 37.23872], [-121.88642, 37.23875], [-121.88623, 37.23882], [-121.88621, 37.23881], [-121.88605, 37.23887], [-121.88604, 37.23889], [-121.88582, 37.23898], [-121.88558, 37.23914], [-121.88569, 37.23945], [-121.88604, 37.24032], [-121.88343, 37.24172], [-121.88312, 37.24139], [-121.88231, 37.24182], [-121.88174, 37.24116], [-121.88166, 37.24124], [-121.88245, 37.24218], [-121.8805, 37.24322], [-121.88041, 37.24324], [-121.87886, 37.24438], [-121.87549, 37.24513], [-121.87551, 37.24536], [-121.87505, 37.24548], [-121.87496, 37.24525], [-121.87495, 37.24506], [-121.875, 37.24426], [-121.87512, 37.24341], [-121.87574, 37.2434], [-121.87692, 37.24332], [-121.87786, 37.24282], [-121.87904, 37.24232], [-121.87937, 37.24214], [-121.87967, 37.24193], [-121.88046, 37.24121], [-121.88073, 37.24103], [-121.88096, 37.2409], [-121.88179, 37.24049], [-121.88207, 37.24037], [-121.88342, 37.23991], [-121.88373, 37.23977], [-121.88403, 37.23961], [-121.8843, 37.23942], [-121.88458, 37.23916], [-121.88479, 37.23893], [-121.88504, 37.23861], [-121.88516, 37.23849], [-121.88541, 37.2383], [-121.88565, 37.23818], [-121.88606, 37.23807], [-121.88634, 37.23803], [-121.88646, 37.23805], [-121.88652, 37.2381], [-121.88664, 37.23864]]], [[[-121.90434, 37.22877], [-121.90427, 37.22967], [-121.90399, 37.23037], [-121.90361, 37.23118], [-121.9034, 37.23133], [-121.903, 37.23149], [-121.90293, 37.23154], [-121.90288, 37.2316], [-121.90284, 37.23167], [-121.90249, 37.23205], [-121.90274, 37.23206], [-121.90244, 37.23221], [-121.90228, 37.23238], [-121.902, 37.23246], [-121.90193, 37.23246], [-121.90181, 37.23258], [-121.90175, 37.23271], [-121.90145, 37.23298], [-121.90117, 37.23312], [-121.90061, 37.23332], [-121.89996, 37.23334], [-121.8996, 37.23363], [-121.89954, 37.23364], [-121.89906, 37.23292], [-121.89868, 37.23329], [-121.89862, 37.23324], [-121.89848, 37.23318], [-121.89819, 37.23314], [-121.8981, 37.23313], [-121.8977, 37.23324], [-121.89745, 37.23336], [-121.89727, 37.23352], [-121.89655, 37.23425], [-121.89589, 37.2348], [-121.89611, 37.23508], [-121.89399, 37.23616], [-121.89279, 37.23567], [-121.89163, 37.23626], [-121.89169, 37.23796], [-121.89026, 37.23961], [-121.88867, 37.23781], [-121.88855, 37.23792], [-121.88694, 37.23855], [-121.88682, 37.23805], [-121.88683, 37.23801], [-121.8872, 37.2379], [-121.88743, 37.2378], [-121.88829, 37.23734], [-121.88855, 37.23717], [-121.88879, 37.23697], [-121.88913, 37.23652], [-121.88928, 37.23634], [-121.88966, 37.236], [-121.88993, 37.23578], [-121.89016, 37.23563], [-121.89082, 37.23523], [-121.89207, 37.2345], [-121.89246, 37.23433], [-121.89323, 37.23409], [-121.89351, 37.23395], [-121.8939, 37.23372], [-121.89399, 37.23354], [-121.89424, 37.23322], [-121.89444, 37.23268], [-121.89467, 37.23234], [-121.89496, 37.23234], [-121.89496, 37.23239], [-121.89498, 37.23243], [-121.89504, 37.23247], [-121.8951, 37.23248], [-121.89591, 37.23249], [-121.89624, 37.23247], [-121.89643, 37.23243], [-121.89663, 37.23237], [-121.89681, 37.23229], [-121.89699, 37.23217], [-121.89703, 37.23216], [-121.89707, 37.23217], [-121.89719, 37.23225], [-121.89735, 37.23234], [-121.89759, 37.2324], [-121.89776, 37.23242], [-121.8979, 37.23242], [-121.89836, 37.23236], [-121.89857, 37.23234], [-121.89965, 37.23238], [-121.89986, 37.23237], [-121.90023, 37.23232], [-121.90057, 37.23223], [-121.90089, 37.23209], [-121.90122, 37.23189], [-121.90141, 37.23172], [-121.90164, 37.23146], [-121.90212, 37.23057], [-121.90235, 37.23023], [-121.90274, 37.22974], [-121.90284, 37.22956], [-121.90294, 37.22935], [-121.90303, 37.22892], [-121.90303, 37.2286], [-121.903, 37.22844], [-121.9027, 37.2274], [-121.90249, 37.22673], [-121.90316, 37.22625], [-121.90328, 37.22624], [-121.90336, 37.22628], [-121.90345, 37.22642], [-121.90356, 37.22669], [-121.9036, 37.22684], [-121.90358, 37.22749], [-121.90365, 37.22778], [-121.90374, 37.22778], [-121.90391, 37.22802], [-121.90401, 37.22851], [-121.90416, 37.22861], [-121.90434, 37.22877]]], [[[-121.91337, 37.21541], [-121.91338, 37.21573], [-121.9133, 37.21598], [-121.91283, 37.21682], [-121.91283, 37.21688], [-121.91264, 37.21704], [-121.91146, 37.21738], [-121.90988, 37.21769], [-121.90972, 37.21775], [-121.90936, 37.21795], [-121.90921, 37.21805], [-121.90907, 37.21818], [-121.90898, 37.21835], [-121.90896, 37.21847], [-121.90898, 37.2186], [-121.90906, 37.21877], [-121.90945, 37.21929], [-121.90958, 37.21953], [-121.90962, 37.21968], [-121.90963, 37.21981], [-121.9096, 37.21994], [-121.90954, 37.22007], [-121.90939, 37.22022], [-121.90915, 37.22038], [-121.9089, 37.22058], [-121.90879, 37.22068], [-121.90869, 37.22087], [-121.90861, 37.22116], [-121.90855, 37.22132], [-121.90845, 37.22147], [-121.90836, 37.22158], [-121.90828, 37.22164], [-121.90818, 37.22167], [-121.90742, 37.22181], [-121.90727, 37.22185], [-121.90707, 37.22197], [-121.90694, 37.22213], [-121.9059, 37.22399], [-121.90585, 37.22411], [-121.90583, 37.22424], [-121.90582, 37.22448], [-121.90585, 37.22464], [-121.90594, 37.22479], [-121.90618, 37.22508], [-121.90627, 37.22525], [-121.9061, 37.22548], [-121.90528, 37.22593], [-121.90453, 37.22627], [-121.90415, 37.22638], [-121.90407, 37.22636], [-121.90405, 37.22635], [-121.90398, 37.22619], [-121.90466, 37.22601], [-121.90536, 37.22565], [-121.90585, 37.22538], [-121.90603, 37.22522], [-121.90553, 37.22437], [-121.90571, 37.22391], [-121.90632, 37.22303], [-121.9067, 37.22208], [-121.90757, 37.22161], [-121.90795, 37.22167], [-121.90833, 37.22138], [-121.90835, 37.22089], [-121.90907, 37.22031], [-121.90929, 37.22021], [-121.90937, 37.21976], [-121.90935, 37.21926], [-121.90876, 37.21865], [-121.909, 37.21809], [-121.90978, 37.21752], [-121.91034, 37.21739], [-121.91118, 37.21728], [-121.91184, 37.21704], [-121.91219, 37.21698], [-121.91254, 37.21679], [-121.91282, 37.21654], [-121.91283, 37.21644], [-121.91298, 37.2163], [-121.9131, 37.21558], [-121.91301, 37.2153], [-121.91282, 37.2151], [-121.91245, 37.21453], [-121.9122, 37.21392], [-121.91196, 37.21364], [-121.91069, 37.2135], [-121.90989, 37.21358], [-121.9092, 37.21339], [-121.90897, 37.21268], [-121.90866, 37.21232], [-121.90677, 37.2109], [-121.9061, 37.21129], [-121.90478, 37.21127], [-121.90385, 37.21062], [-121.90349, 37.20986], [-121.90221, 37.2094], [-121.90166, 37.20902], [-121.9015, 37.20793], [-121.9001, 37.20744], [-121.89927, 37.20682], [-121.89887, 37.2068], [-121.89907, 37.20665], [-121.89937, 37.20666], [-121.90016, 37.20728], [-121.90167, 37.20782], [-121.90187, 37.20885], [-121.90237, 37.20926], [-121.90366, 37.20973], [-121.90406, 37.21051], [-121.90488, 37.2111], [-121.90598, 37.21111], [-121.90676, 37.21066], [-121.90786, 37.21151], [-121.90885, 37.21217], [-121.90914, 37.21254], [-121.90937, 37.21322], [-121.90988, 37.21339], [-121.91069, 37.21331], [-121.91168, 37.21341], [-121.91202, 37.21346], [-121.91214, 37.21358], [-121.91217, 37.21355], [-121.91233, 37.21362], [-121.91261, 37.21437], [-121.91282, 37.21463], [-121.91282, 37.2147], [-121.91293, 37.21478], [-121.91337, 37.21541]]]]} | Open Access 1 | Guadalupe Creek Parkchain | 31394 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 150.238 | Guadalupe Creek Parkchain | 1998 | |
15551 | 15551 | 15550 | {"type": "Polygon", "coordinates": [[[-118.09007, 33.81023], [-118.0898, 33.81023], [-118.08979, 33.81025], [-118.08952, 33.81025], [-118.08951, 33.81028], [-118.08939, 33.81028], [-118.08938, 33.81031], [-118.08901, 33.81031], [-118.08899, 33.81032], [-118.087, 33.81031], [-118.08681, 33.8103], [-118.08646, 33.81026], [-118.08528, 33.81025], [-118.08526, 33.80869], [-118.08528, 33.80858], [-118.08528, 33.80779], [-118.0838, 33.8078], [-118.08379, 33.80661], [-118.08225, 33.8066], [-118.0825, 33.80624], [-118.08262, 33.8061], [-118.08326, 33.80558], [-118.08379, 33.80511], [-118.08429, 33.80462], [-118.0848, 33.80407], [-118.08488, 33.80402], [-118.085, 33.80397], [-118.08519, 33.80394], [-118.08609, 33.80401], [-118.0878, 33.80432], [-118.08845, 33.8044], [-118.08878, 33.80441], [-118.08879, 33.80434], [-118.08978, 33.80435], [-118.09007, 33.81023]]]} | Open Access 1 | El Dorado Nature Center | 18502 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 87.566 | El Dorado Nature Ctr. | 1998 |
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]);