superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where MNG_AG_TYP = 2 and YR_EST = 1980
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
754 | 754 | 753 | {"type": "Polygon", "coordinates": [[[-121.81675, 37.33738], [-121.81662, 37.33744], [-121.81652, 37.3375], [-121.81637, 37.33766], [-121.81631, 37.33779], [-121.81629, 37.33789], [-121.81629, 37.33799], [-121.81632, 37.33808], [-121.80608, 37.34136], [-121.80603, 37.34134], [-121.80305, 37.33809], [-121.80305, 37.33807], [-121.80298, 37.33798], [-121.80134, 37.33613], [-121.8011, 37.33581], [-121.80108, 37.33574], [-121.80111, 37.33567], [-121.80115, 37.33563], [-121.80158, 37.3355], [-121.80194, 37.33536], [-121.80226, 37.3352], [-121.80259, 37.33498], [-121.80377, 37.33405], [-121.80417, 37.33375], [-121.80428, 37.33368], [-121.80458, 37.33353], [-121.80485, 37.33342], [-121.80537, 37.33326], [-121.80567, 37.33321], [-121.80599, 37.33318], [-121.80648, 37.33319], [-121.80692, 37.33325], [-121.80771, 37.33342], [-121.80815, 37.33346], [-121.80854, 37.33347], [-121.80902, 37.33342], [-121.80942, 37.33334], [-121.80978, 37.33323], [-121.81024, 37.33304], [-121.81027, 37.3331], [-121.81052, 37.333], [-121.81058, 37.33299], [-121.81063, 37.333], [-121.81067, 37.33303], [-121.81086, 37.33336], [-121.81099, 37.33349], [-121.81116, 37.33357], [-121.81131, 37.33361], [-121.81141, 37.33361], [-121.81151, 37.3336], [-121.8134, 37.33323], [-121.81414, 37.33373], [-121.81422, 37.33379], [-121.81675, 37.33738]]]} | Open Access 1 | Lake Cunningham | http://www.sanjoseca.gov/Facilities/Facility/Details/179 | 11172 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 201.677 | Lake Cunningham | 1980 |
2203 | 2203 | 2202 | {"type": "Polygon", "coordinates": [[[-121.91133, 37.3038], [-121.91123, 37.3038], [-121.91097, 37.30388], [-121.90824, 37.30511], [-121.90819, 37.30509], [-121.90757, 37.30397], [-121.90756, 37.30393], [-121.90758, 37.30385], [-121.90764, 37.3038], [-121.90819, 37.30361], [-121.90826, 37.30356], [-121.9083, 37.30351], [-121.90832, 37.30346], [-121.9083, 37.30333], [-121.9083, 37.30327], [-121.90832, 37.30322], [-121.90839, 37.30317], [-121.90993, 37.30256], [-121.91003, 37.30249], [-121.91012, 37.30238], [-121.91112, 37.30232], [-121.91131, 37.30232], [-121.91133, 37.3038]]]} | Open Access 1 | Bramhall | 16328 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 14.618 | Bramhall | 1980 | |
2494 | 2494 | 2493 | {"type": "Polygon", "coordinates": [[[-121.81872, 37.23996], [-121.81869, 37.24127], [-121.8181, 37.24107], [-121.81777, 37.241], [-121.81742, 37.24099], [-121.81736, 37.24095], [-121.81724, 37.24045], [-121.81706, 37.23993], [-121.81872, 37.23996]]]} | Open Access 1 | Calero Park | 16680 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 4.064 | Calero Park | 1980 | |
2701 | 2701 | 2700 | {"type": "Polygon", "coordinates": [[[-121.87631, 37.40276], [-121.87599, 37.40296], [-121.87594, 37.40287], [-121.87584, 37.40275], [-121.87572, 37.40268], [-121.87554, 37.4026], [-121.87545, 37.40254], [-121.87456, 37.40155], [-121.87443, 37.40145], [-121.87422, 37.40134], [-121.87408, 37.40129], [-121.87384, 37.40126], [-121.87369, 37.40126], [-121.87353, 37.40129], [-121.87331, 37.40137], [-121.87154, 37.40238], [-121.87135, 37.40245], [-121.87107, 37.40248], [-121.87083, 37.40256], [-121.87028, 37.40286], [-121.87021, 37.40285], [-121.86956, 37.40213], [-121.86942, 37.40207], [-121.86929, 37.40208], [-121.86659, 37.40363], [-121.86648, 37.40364], [-121.86643, 37.40363], [-121.86638, 37.40358], [-121.86565, 37.4026], [-121.86496, 37.4016], [-121.86511, 37.40159], [-121.86517, 37.40165], [-121.86521, 37.40166], [-121.86527, 37.40166], [-121.86534, 37.40161], [-121.86534, 37.40154], [-121.86538, 37.4015], [-121.86584, 37.40127], [-121.8659, 37.40127], [-121.86596, 37.40131], [-121.86627, 37.40174], [-121.86641, 37.40187], [-121.86649, 37.40191], [-121.86664, 37.40199], [-121.8668, 37.40203], [-121.86696, 37.40206], [-121.8672, 37.40205], [-121.86743, 37.402], [-121.86766, 37.40189], [-121.86873, 37.40129], [-121.86887, 37.40123], [-121.86914, 37.40118], [-121.86929, 37.40114], [-121.8699, 37.4008], [-121.86996, 37.40082], [-121.87035, 37.40125], [-121.87054, 37.40138], [-121.87068, 37.40144], [-121.87091, 37.4015], [-121.87108, 37.40151], [-121.87124, 37.4015], [-121.8714, 37.40146], [-121.87162, 37.40137], [-121.87371, 37.40016], [-121.87375, 37.40013], [-121.87377, 37.40008], [-121.87387, 37.40009], [-121.87423, 37.39987], [-121.87494, 37.40039], [-121.87514, 37.40056], [-121.87531, 37.40075], [-121.87546, 37.40095], [-121.8757, 37.40137], [-121.87631, 37.40276]]]} | Open Access 1 | Cataldi | 16968 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 32.699 | Cataldi | 1980 | |
5888 | 5888 | 5887 | {"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 | Laguna Vista | 20869 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1.998 | Laguna Vista | 1980 | |
6194 | 6194 | 6193 | {"type": "Polygon", "coordinates": [[[-122.45367, 37.70696], [-122.45263, 37.70735], [-122.4524, 37.70684], [-122.45315, 37.70655], [-122.45367, 37.70696]]]} | Open Access 1 | Lincoln Park | 21263 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1.286 | Lincoln Park | 1980 | |
8113 | 8113 | 8112 | {"type": "Polygon", "coordinates": [[[-121.89654, 37.43718], [-121.89655, 37.43724], [-121.89628, 37.43811], [-121.89623, 37.43823], [-121.89614, 37.43834], [-121.89603, 37.43843], [-121.89583, 37.43853], [-121.89539, 37.43862], [-121.89515, 37.4387], [-121.89502, 37.43878], [-121.8949, 37.43888], [-121.89477, 37.43906], [-121.89472, 37.43921], [-121.89403, 37.44263], [-121.89408, 37.44287], [-121.89402, 37.44291], [-121.89371, 37.44287], [-121.89499, 37.43651], [-121.896, 37.437], [-121.89622, 37.43708], [-121.89649, 37.43714], [-121.89654, 37.43718]]]} | Open Access 1 | Peter T. Gill Park | 23630 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 9.81 | Peter T. Gill Park | 1980 | |
8225 | 8225 | 8224 | {"type": "Polygon", "coordinates": [[[-121.86047, 37.35798], [-121.86039, 37.35799], [-121.85985, 37.35783], [-121.85954, 37.35777], [-121.85736, 37.35764], [-121.85711, 37.35765], [-121.85691, 37.35767], [-121.85672, 37.35771], [-121.85651, 37.35778], [-121.85668, 37.35763], [-121.8588, 37.3562], [-121.85878, 37.35623], [-121.85879, 37.35626], [-121.86046, 37.35796], [-121.86047, 37.35798]]]} | Open Access 1 | Plata Arroyo | 23771 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 6.812 | Plata Arroyo | 1980 | |
9842 | 9842 | 9841 | {"type": "Polygon", "coordinates": [[[-121.92594, 37.3438], [-121.92465, 37.3447], [-121.92459, 37.34464], [-121.92486, 37.34438], [-121.9254, 37.34394], [-121.92553, 37.34388], [-121.92575, 37.34382], [-121.92594, 37.3438]]]} | Open Access 1 | Southside Community Center | 25697 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.528 | Southside Community Ctr. | 1980 | |
11969 | 11969 | 11968 | {"type": "Polygon", "coordinates": [[[-122.46717, 37.65442], [-122.46684, 37.65445], [-122.46683, 37.65457], [-122.46653, 37.65456], [-122.46654, 37.65449], [-122.46649, 37.65441], [-122.46641, 37.65438], [-122.46632, 37.65439], [-122.46624, 37.65412], [-122.46683, 37.65403], [-122.46688, 37.65431], [-122.46682, 37.65432], [-122.46683, 37.6544], [-122.46717, 37.65438], [-122.46717, 37.65442]]]} | Open Access 1 | Lycett Tot Lot | 28798 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.605 | Lycett Tot Lot | 1980 | |
12748 | 12748 | 12747 | {"type": "MultiPolygon", "coordinates": [[[[-118.16911, 33.76371], [-118.16907, 33.76395], [-118.16889, 33.76393], [-118.16893, 33.76369], [-118.16911, 33.76371]]], [[[-118.17, 33.76384], [-118.16997, 33.76404], [-118.16979, 33.76401], [-118.16982, 33.76382], [-118.17, 33.76384]]], [[[-118.17089, 33.76396], [-118.17086, 33.76416], [-118.17068, 33.76414], [-118.17072, 33.76393], [-118.17089, 33.76396]]], [[[-118.17176, 33.76423], [-118.17175, 33.7643], [-118.17157, 33.76428], [-118.17158, 33.76412], [-118.17159, 33.76412], [-118.17167, 33.76419], [-118.17176, 33.76423]]], [[[-118.17268, 33.76419], [-118.17265, 33.76435], [-118.17248, 33.76433], [-118.1725, 33.76417], [-118.17268, 33.76419]]], [[[-118.17358, 33.76431], [-118.17354, 33.76452], [-118.17346, 33.76449], [-118.17336, 33.7645], [-118.1734, 33.76428], [-118.17358, 33.76431]]], [[[-118.17447, 33.76442], [-118.17443, 33.76465], [-118.17439, 33.76464], [-118.17435, 33.76461], [-118.17425, 33.76462], [-118.17429, 33.7644], [-118.17447, 33.76442]]], [[[-118.17536, 33.76454], [-118.17533, 33.76475], [-118.17515, 33.76473], [-118.17519, 33.76452], [-118.17536, 33.76454]]], [[[-118.17626, 33.76466], [-118.17623, 33.76484], [-118.17605, 33.76482], [-118.17608, 33.76464], [-118.17626, 33.76466]]], [[[-118.17716, 33.76478], [-118.17711, 33.76501], [-118.17694, 33.76498], [-118.17698, 33.76475], [-118.17716, 33.76478]]], [[[-118.17805, 33.76489], [-118.17801, 33.76512], [-118.17783, 33.7651], [-118.17787, 33.76487], [-118.17805, 33.76489]]], [[[-118.17895, 33.76501], [-118.17891, 33.76521], [-118.17873, 33.76519], [-118.17877, 33.76499], [-118.17895, 33.76501]]], [[[-118.17984, 33.76513], [-118.1798, 33.76535], [-118.17962, 33.76533], [-118.17966, 33.7651], [-118.17984, 33.76513]]], [[[-118.18074, 33.76524], [-118.18068, 33.76554], [-118.18063, 33.76552], [-118.1805, 33.76551], [-118.18056, 33.76522], [-118.18074, 33.76524]]], [[[-118.18164, 33.76534], [-118.18157, 33.76571], [-118.18151, 33.76569], [-118.18139, 33.76569], [-118.18145, 33.76534], [-118.18164, 33.76534]]]]} | Open Access 1 | Mini-Parks at 1st Place through 15th Place | 29924 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.51 | Mini-Parks at 1st Place through 15th Place | 1980 | |
13476 | 13476 | 13475 | {"type": "Polygon", "coordinates": [[[-115.58573, 32.79079], [-115.58572, 32.7924], [-115.58483, 32.7924], [-115.58482, 32.79079], [-115.58573, 32.79079]]]} | Open Access 1 | Leeper Park | http://www.cityofelcentro.org | 32619 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 3.692 | Leeper Park | 1980 |
13929 | 13929 | 13928 | {"type": "Polygon", "coordinates": [[[-122.17218, 39.7377], [-122.17216, 39.73975], [-122.16882, 39.73975], [-122.16886, 39.73637], [-122.17218, 39.7377]]]} | Open Access 1 | Lely Park | http://www.cityoforland.com/govt/dept/recreation/parks.asp | 32530 | 1441 | Orland, City of 578 | City 2 | City Agency 2 | http://www.cityoforland.com/govt/dept/recreation/parks.asp | City 2 | 21.299 | Lely Park | 1980 |
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]);