superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where MNG_AGENCY = 477 sorted by SUID_NMA
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14408 | 14408 | 14407 | {"type": "Polygon", "coordinates": [[[-122.46627, 37.88243], [-122.46596, 37.8826], [-122.46576, 37.88273], [-122.46565, 37.88287], [-122.46555, 37.88303], [-122.4655, 37.88316], [-122.46552, 37.88329], [-122.46555, 37.88335], [-122.46561, 37.88343], [-122.46575, 37.88351], [-122.46532, 37.88373], [-122.46486, 37.88363], [-122.46499, 37.88319], [-122.4651, 37.8827], [-122.46546, 37.88242], [-122.4656, 37.88239], [-122.46621, 37.88245], [-122.46627, 37.88243]]]} | Open Access 1 | Town Hall Area Open Space | 31733 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1.96 | Town Hall Area OS | ||
14784 | 14784 | 14783 | {"type": "MultiPolygon", "coordinates": [[[[-122.47137, 37.88797], [-122.47086, 37.88811], [-122.47097, 37.8885], [-122.47118, 37.88878], [-122.4703, 37.88964], [-122.47019, 37.88961], [-122.47011, 37.8896], [-122.46998, 37.88962], [-122.46989, 37.88965], [-122.46768, 37.8882], [-122.46816, 37.88767], [-122.46817, 37.8876], [-122.46822, 37.88752], [-122.46823, 37.88748], [-122.4682, 37.88744], [-122.46814, 37.88745], [-122.46811, 37.88744], [-122.46811, 37.88734], [-122.4682, 37.88715], [-122.46834, 37.88694], [-122.46842, 37.88678], [-122.46846, 37.88666], [-122.46878, 37.88693], [-122.47011, 37.88547], [-122.47067, 37.88596], [-122.47051, 37.88637], [-122.47044, 37.88637], [-122.47038, 37.8864], [-122.47035, 37.88645], [-122.47035, 37.8865], [-122.47037, 37.88654], [-122.47041, 37.88657], [-122.47057, 37.88659], [-122.47077, 37.88678], [-122.47086, 37.8869], [-122.47092, 37.88707], [-122.47095, 37.88735], [-122.47047, 37.88729], [-122.47043, 37.88749], [-122.47098, 37.88756], [-122.47101, 37.88765], [-122.4711, 37.88776], [-122.47129, 37.88789], [-122.47137, 37.88797]]], [[[-122.47245, 37.88757], [-122.47182, 37.88815], [-122.47172, 37.88814], [-122.47158, 37.88803], [-122.47135, 37.88779], [-122.47125, 37.88771], [-122.47177, 37.8874], [-122.47173, 37.88693], [-122.47245, 37.88757]]]]} | Open Access 1 | Eavey Open Space Purchase | 31734 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 21.377 | Eavey OS Purchase | ||
14213 | 14213 | 14212 | {"type": "Polygon", "coordinates": [[[-122.46119, 37.8907], [-122.46073, 37.89172], [-122.45801, 37.89065], [-122.45771, 37.88931], [-122.45845, 37.88865], [-122.45857, 37.88869], [-122.45861, 37.88868], [-122.45879, 37.88885], [-122.45838, 37.88911], [-122.45896, 37.88978], [-122.45957, 37.89038], [-122.4598, 37.89053], [-122.46009, 37.89063], [-122.4603, 37.89067], [-122.46076, 37.89072], [-122.46083, 37.89038], [-122.46102, 37.89049], [-122.4611, 37.89062], [-122.46119, 37.8907]]]} | Open Access 1 | El Marinero Subdivision Open Space | 31735 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 9.306 | El Marinero Subdivision OS | ||
14785 | 14785 | 14784 | {"type": "Polygon", "coordinates": [[[-122.47243, 37.89254], [-122.47257, 37.89352], [-122.47254, 37.89366], [-122.47248, 37.89376], [-122.47239, 37.89385], [-122.47204, 37.89357], [-122.46989, 37.89271], [-122.46896, 37.89222], [-122.46913, 37.89201], [-122.46948, 37.89194], [-122.4698, 37.89157], [-122.46984, 37.89147], [-122.46987, 37.89126], [-122.46985, 37.8911], [-122.46982, 37.89099], [-122.46993, 37.89073], [-122.47067, 37.89096], [-122.47116, 37.89161], [-122.472, 37.89197], [-122.47189, 37.89212], [-122.47183, 37.89229], [-122.4718, 37.89246], [-122.47181, 37.8926], [-122.47243, 37.89254]]]} | Open Access 1 | Reed School District Open Space | 31736 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 11.787 | Reed School District OS | ||
14778 | 14778 | 14777 | {"type": "Polygon", "coordinates": [[[-122.49232, 37.90311], [-122.49225, 37.90325], [-122.49196, 37.90343], [-122.49196, 37.90348], [-122.49198, 37.90352], [-122.49199, 37.90386], [-122.49192, 37.90395], [-122.49199, 37.9041], [-122.492, 37.90455], [-122.49193, 37.90467], [-122.49204, 37.90475], [-122.49206, 37.9049], [-122.49223, 37.90502], [-122.4922, 37.90522], [-122.492, 37.90539], [-122.4919, 37.90567], [-122.49165, 37.90576], [-122.49045, 37.90632], [-122.48945, 37.90655], [-122.48859, 37.90739], [-122.48821, 37.90809], [-122.48808, 37.90799], [-122.48758, 37.90776], [-122.48678, 37.9079], [-122.4841, 37.90617], [-122.48226, 37.90505], [-122.48228, 37.90351], [-122.48236, 37.90347], [-122.4834, 37.90319], [-122.48405, 37.90377], [-122.48421, 37.90472], [-122.48714, 37.9047], [-122.48831, 37.9043], [-122.48958, 37.90411], [-122.48988, 37.90429], [-122.49138, 37.90373], [-122.49135, 37.90342], [-122.4917, 37.90341], [-122.49171, 37.90309], [-122.49189, 37.90289], [-122.49232, 37.90311]]]} | Open Access 1 | Atkinson Open Space Purchase | 31737 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 59.739 | Atkinson OS Purchase | ||
15 | 15 | 14 | {"type": "Polygon", "coordinates": [[[-122.49781, 37.89952], [-122.49774, 37.89961], [-122.49721, 37.9006], [-122.49629, 37.90023], [-122.49657, 37.89917], [-122.49687, 37.89929], [-122.49723, 37.89941], [-122.49781, 37.89952]]]} | Open Access 1 | Highlands Subdivision Open Space | 31738 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 3.056 | Highlands Subdivision OS | ||
11 | 11 | 10 | {"type": "Polygon", "coordinates": [[[-122.48901, 37.89521], [-122.4888, 37.89557], [-122.48822, 37.89497], [-122.4877, 37.89489], [-122.48636, 37.89374], [-122.48611, 37.89392], [-122.48646, 37.89424], [-122.48719, 37.89499], [-122.487, 37.89509], [-122.4865, 37.89457], [-122.48594, 37.89402], [-122.48532, 37.89353], [-122.48479, 37.89316], [-122.48493, 37.89301], [-122.4846, 37.89232], [-122.48478, 37.8918], [-122.48451, 37.89148], [-122.48438, 37.89133], [-122.48415, 37.89126], [-122.4841, 37.89121], [-122.4843, 37.8909], [-122.48771, 37.89414], [-122.48858, 37.89488], [-122.48901, 37.89521]]]} | Open Access 1 | McKegney Green | 31739 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 11.486 | McKegney Green | ||
12 | 12 | 11 | {"type": "MultiPolygon", "coordinates": [[[[-122.47229, 37.88394], [-122.47228, 37.88408], [-122.47155, 37.88354], [-122.47113, 37.88331], [-122.47071, 37.88311], [-122.46655, 37.88146], [-122.46617, 37.88128], [-122.46582, 37.88107], [-122.46549, 37.88084], [-122.46519, 37.88058], [-122.46485, 37.88023], [-122.46461, 37.87994], [-122.46398, 37.87905], [-122.46375, 37.87876], [-122.46349, 37.87828], [-122.46366, 37.87841], [-122.46393, 37.87866], [-122.46418, 37.87896], [-122.46473, 37.87971], [-122.46513, 37.88021], [-122.46543, 37.88051], [-122.46589, 37.88087], [-122.46654, 37.88124], [-122.46914, 37.88228], [-122.47044, 37.88282], [-122.47137, 37.88329], [-122.47177, 37.88352], [-122.47191, 37.88361], [-122.47229, 37.88394]]], [[[-122.48493, 37.89302], [-122.48479, 37.89316], [-122.48443, 37.89294], [-122.48443, 37.89291], [-122.48369, 37.89248], [-122.48336, 37.89224], [-122.48307, 37.89199], [-122.48301, 37.8919], [-122.4828, 37.89168], [-122.48218, 37.89088], [-122.4819, 37.89053], [-122.48142, 37.89016], [-122.48098, 37.8899], [-122.48092, 37.88992], [-122.48079, 37.88983], [-122.48052, 37.8897], [-122.47978, 37.88947], [-122.47892, 37.88905], [-122.47831, 37.88873], [-122.47672, 37.88778], [-122.4767, 37.88778], [-122.47506, 37.88663], [-122.47435, 37.88604], [-122.47238, 37.88426], [-122.47239, 37.88407], [-122.47364, 37.88519], [-122.4749, 37.88627], [-122.47624, 37.88729], [-122.47681, 37.88766], [-122.47834, 37.88856], [-122.47903, 37.88892], [-122.47991, 37.88929], [-122.48072, 37.88955], [-122.48094, 37.88965], [-122.48151, 37.88999], [-122.48174, 37.89016], [-122.48195, 37.89034], [-122.48214, 37.89054], [-122.48321, 37.89188], [-122.48365, 37.89224], [-122.48392, 37.89233], [-122.48424, 37.8926], [-122.48493, 37.89302]]]]} | Open Access 1 | Richardson Bay Lineal Park | 31740 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 11.346 | Richardson Bay Lineal Park | ||
13 | 13 | 12 | {"type": "Polygon", "coordinates": [[[-122.48493, 37.89302], [-122.48424, 37.8926], [-122.48392, 37.89233], [-122.48365, 37.89224], [-122.48351, 37.89213], [-122.48321, 37.89188], [-122.48243, 37.89091], [-122.48254, 37.89102], [-122.48261, 37.89097], [-122.48262, 37.8908], [-122.48269, 37.89064], [-122.48315, 37.89035], [-122.4833, 37.89039], [-122.48364, 37.89071], [-122.48415, 37.89126], [-122.48438, 37.89133], [-122.48478, 37.8918], [-122.4846, 37.89232], [-122.48493, 37.89302]]]} | Open Access 1 | South of the Knoll Park | 31741 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 6.521 | South of the Knoll Park | ||
18 | 18 | 17 | {"type": "Polygon", "coordinates": [[[-122.49207, 37.89502], [-122.49188, 37.89527], [-122.49079, 37.89555], [-122.49079, 37.89576], [-122.49092, 37.89579], [-122.49107, 37.8958], [-122.49135, 37.89577], [-122.49174, 37.89565], [-122.49186, 37.89557], [-122.49165, 37.8958], [-122.49148, 37.89584], [-122.49147, 37.89589], [-122.49077, 37.89627], [-122.49017, 37.89668], [-122.49009, 37.89668], [-122.49005, 37.89662], [-122.49015, 37.89626], [-122.49019, 37.89623], [-122.49024, 37.89622], [-122.49065, 37.89624], [-122.49071, 37.89602], [-122.49032, 37.89613], [-122.48994, 37.89615], [-122.48996, 37.89622], [-122.48981, 37.89665], [-122.48973, 37.89683], [-122.48963, 37.89701], [-122.48951, 37.89719], [-122.48936, 37.89734], [-122.48928, 37.89729], [-122.48902, 37.89749], [-122.48902, 37.8975], [-122.48907, 37.89755], [-122.48868, 37.89782], [-122.48855, 37.89788], [-122.48835, 37.89791], [-122.48816, 37.89789], [-122.48796, 37.89782], [-122.48779, 37.89769], [-122.48769, 37.89754], [-122.48766, 37.89745], [-122.48766, 37.89732], [-122.48779, 37.89686], [-122.48783, 37.89657], [-122.4878, 37.89631], [-122.48777, 37.89617], [-122.48768, 37.89597], [-122.48746, 37.89564], [-122.48724, 37.89534], [-122.487, 37.89509], [-122.48719, 37.895], [-122.48776, 37.89556], [-122.48817, 37.89532], [-122.4877, 37.89489], [-122.48822, 37.89497], [-122.48881, 37.89557], [-122.48954, 37.89554], [-122.48961, 37.89543], [-122.48971, 37.89544], [-122.49016, 37.89536], [-122.4916, 37.89498], [-122.49207, 37.89502]]]} | Open Access 1 | Blackie's Pasture | 31743 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 15.478 | Blackie's Pasture |
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]);