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 = 1977
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016 | 2016 | 2015 | {"type": "Polygon", "coordinates": [[[-122.40918, 37.59933], [-122.40913, 37.5994], [-122.4085, 37.59926], [-122.40864, 37.59886], [-122.40894, 37.59893], [-122.40893, 37.59904], [-122.40903, 37.59922], [-122.40907, 37.59925], [-122.40917, 37.59926], [-122.40918, 37.59933]]]} | Open Access 1 | Bill Mitchell Lions Park | https://www.ci.millbrae.ca.us/departments-services/public-works/parks-division/lion-bill-mitchell-park | 16107 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 0.477 | Bill Mitchell Lions Park | 1977 |
3456 | 3456 | 3455 | {"type": "Polygon", "coordinates": [[[-122.41374, 37.70263], [-122.41365, 37.70283], [-122.41296, 37.70284], [-122.413, 37.70307], [-122.41298, 37.70324], [-122.41292, 37.70342], [-122.41281, 37.70358], [-122.41189, 37.70309], [-122.41234, 37.70208], [-122.41268, 37.70218], [-122.41267, 37.70222], [-122.4128, 37.70225], [-122.41309, 37.70201], [-122.41335, 37.70208], [-122.41318, 37.70247], [-122.41374, 37.70263]]]} | Open Access 1 | David Rowe Park | 17944 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 3.516 | David Rowe Park | 1977 | |
5143 | 5143 | 5142 | {"type": "Polygon", "coordinates": [[[-121.89776, 37.45803], [-121.8975, 37.45832], [-121.8973, 37.4589], [-121.89716, 37.45941], [-121.89604, 37.45917], [-121.89599, 37.45904], [-121.89613, 37.45902], [-121.89668, 37.45911], [-121.89669, 37.45902], [-121.89625, 37.45894], [-121.89636, 37.45886], [-121.89644, 37.45877], [-121.89643, 37.45861], [-121.89639, 37.45854], [-121.89631, 37.45851], [-121.89625, 37.45853], [-121.89615, 37.45862], [-121.89604, 37.4585], [-121.89608, 37.4584], [-121.89617, 37.45826], [-121.89629, 37.45813], [-121.89643, 37.45802], [-121.89725, 37.45755], [-121.8973, 37.45754], [-121.89736, 37.45757], [-121.89776, 37.45803]]]} | Open Access 1 | Higuera Adobe Park | 19954 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 4.376 | Higuera Adobe Park | 1977 | |
5169 | 5169 | 5168 | {"type": "Polygon", "coordinates": [[[-122.45998, 37.69444], [-122.45997, 37.69606], [-122.45929, 37.69616], [-122.4594, 37.69697], [-122.45882, 37.69702], [-122.45876, 37.69737], [-122.45633, 37.6972], [-122.45644, 37.69551], [-122.45705, 37.69542], [-122.45816, 37.69609], [-122.45919, 37.69552], [-122.45914, 37.69444], [-122.45998, 37.69444]]]} | Open Access 1 | Hillside Park | 19980 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 14.008 | Hillside Park | 1977 | |
6051 | 6051 | 6050 | {"type": "Polygon", "coordinates": [[[-122.31425, 38.29491], [-122.31317, 38.29529], [-122.31275, 38.29453], [-122.31383, 38.29416], [-122.31425, 38.29491]]]} | Open Access 1 | Laurel Park | 21104 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 2.341 | Laurel Park | 1977 | |
7404 | 7404 | 7403 | {"type": "Polygon", "coordinates": [[[-121.84268, 37.39519], [-121.84107, 37.39567], [-121.84011, 37.39362], [-121.84086, 37.3934], [-121.84087, 37.39345], [-121.84081, 37.39351], [-121.84081, 37.39354], [-121.84075, 37.39358], [-121.84085, 37.39377], [-121.84055, 37.39387], [-121.84076, 37.39423], [-121.84078, 37.39423], [-121.84081, 37.39428], [-121.84087, 37.39429], [-121.84089, 37.3943], [-121.84132, 37.39431], [-121.84133, 37.39423], [-121.84138, 37.39422], [-121.84138, 37.39417], [-121.8413, 37.39415], [-121.8413, 37.39412], [-121.84128, 37.39411], [-121.84131, 37.39394], [-121.84129, 37.39388], [-121.84138, 37.39379], [-121.84143, 37.39382], [-121.84142, 37.39384], [-121.84145, 37.39386], [-121.84182, 37.39376], [-121.84182, 37.39372], [-121.84192, 37.39368], [-121.84238, 37.39468], [-121.84248, 37.39476], [-121.84268, 37.39519]]]} | Open Access 1 | Noble Park | 22780 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 6.863 | Noble Park | 1977 | |
7790 | 7790 | 7789 | {"type": "Polygon", "coordinates": [[[-121.85742, 37.36514], [-121.85473, 37.36697], [-121.85203, 37.36421], [-121.85465, 37.36245], [-121.85472, 37.36244], [-121.85742, 37.36514]]]} | Open Access 1 | Overfelt Botanical Gardens | 23270 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 29.812 | Overfelt Botanical Gardens | 1977 | |
9998 | 9998 | 9997 | {"type": "Polygon", "coordinates": [[[-121.83805, 37.30715], [-121.83802, 37.30722], [-121.83797, 37.30729], [-121.83797, 37.30749], [-121.83793, 37.30755], [-121.83786, 37.30756], [-121.83775, 37.30754], [-121.83748, 37.3067], [-121.83743, 37.30651], [-121.83768, 37.30643], [-121.83774, 37.30646], [-121.83778, 37.30649], [-121.83781, 37.3066], [-121.83791, 37.30676], [-121.83795, 37.30691], [-121.83801, 37.30703], [-121.83805, 37.30715]]]} | Open Access 1 | Stonegate Park | 25887 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.944 | Stonegate Park | 1977 | |
10367 | 10367 | 10366 | {"type": "Polygon", "coordinates": [[[-122.35256, 38.30267], [-122.35256, 38.30309], [-122.35243, 38.30311], [-122.35241, 38.30324], [-122.352, 38.30336], [-122.35131, 38.30326], [-122.35116, 38.30326], [-122.35036, 38.30355], [-122.3502, 38.30354], [-122.35002, 38.30343], [-122.34981, 38.30363], [-122.34967, 38.3037], [-122.34938, 38.30378], [-122.34928, 38.30375], [-122.34926, 38.3038], [-122.34877, 38.30371], [-122.34864, 38.30365], [-122.34856, 38.30368], [-122.34808, 38.30347], [-122.34813, 38.30339], [-122.34826, 38.30346], [-122.34842, 38.30351], [-122.34861, 38.30356], [-122.34899, 38.30361], [-122.34922, 38.30359], [-122.34936, 38.30355], [-122.34951, 38.30348], [-122.34966, 38.30338], [-122.34959, 38.30328], [-122.35043, 38.30295], [-122.35022, 38.3025], [-122.35128, 38.30192], [-122.35075, 38.3014], [-122.34988, 38.30078], [-122.34892, 38.30023], [-122.34864, 38.30025], [-122.34876, 38.30005], [-122.35003, 38.29971], [-122.35073, 38.29969], [-122.35189, 38.29978], [-122.35178, 38.30006], [-122.35058, 38.3005], [-122.35256, 38.30267]]]} | Open Access 1 | Timber Hill Park | 26368 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 14.727 | Timber Hill Park | 1977 |
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]);