superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where MNG_AGENCY = 431
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5990 | 5990 | 5989 | {"type": "MultiPolygon", "coordinates": [[[[-122.58022, 37.98301], [-122.58014, 37.98311], [-122.57993, 37.98309], [-122.57917, 37.98294], [-122.57907, 37.98292], [-122.57872, 37.98261], [-122.57838, 37.98254], [-122.57833, 37.98259], [-122.5782, 37.98251], [-122.5781, 37.98252], [-122.57801, 37.9826], [-122.57779, 37.98246], [-122.57791, 37.98233], [-122.57834, 37.98228], [-122.57848, 37.98228], [-122.57864, 37.98235], [-122.57887, 37.98237], [-122.57878, 37.98255], [-122.57895, 37.98269], [-122.57906, 37.98272], [-122.57908, 37.98268], [-122.5792, 37.98277], [-122.57919, 37.98281], [-122.57933, 37.98285], [-122.57947, 37.98287], [-122.57953, 37.98292], [-122.58022, 37.98301]]], [[[-122.57817, 37.98218], [-122.57799, 37.9822], [-122.5779, 37.98195], [-122.57804, 37.98182], [-122.57817, 37.98218]]]]} | Open Access 1 | Lansdale Park | 21015 | 1292 | San Anselmo, City of 431 | City 2 | City Agency 2 | http://www.townofsananselmo.org/index.aspx?nid=106 | City 2 | 1.162 | Lansdale Park | ||
6920 | 6920 | 6919 | {"type": "MultiPolygon", "coordinates": [[[[-122.56578, 37.98282], [-122.56573, 37.98336], [-122.56561, 37.98361], [-122.56539, 37.9835], [-122.56509, 37.98379], [-122.56509, 37.9838], [-122.56525, 37.9839], [-122.56491, 37.98426], [-122.56455, 37.98405], [-122.56454, 37.98372], [-122.56383, 37.98375], [-122.56303, 37.98382], [-122.56403, 37.98314], [-122.5649, 37.98298], [-122.56534, 37.98279], [-122.56578, 37.98282]]], [[[-122.5661, 37.98446], [-122.56571, 37.98423], [-122.56589, 37.98406], [-122.5659, 37.98416], [-122.56596, 37.9843], [-122.5661, 37.98446]]], [[[-122.56682, 37.98284], [-122.566, 37.98369], [-122.56578, 37.98356], [-122.56589, 37.98336], [-122.56596, 37.98255], [-122.5661, 37.98241], [-122.56645, 37.98262], [-122.5663, 37.98278], [-122.56631, 37.98279], [-122.56648, 37.98263], [-122.56682, 37.98284]]], [[[-122.56738, 37.98316], [-122.56621, 37.98435], [-122.56621, 37.98435], [-122.5661, 37.98416], [-122.56606, 37.98403], [-122.56606, 37.9839], [-122.56699, 37.98293], [-122.56738, 37.98316]]], [[[-122.56799, 37.98253], [-122.56746, 37.98306], [-122.56608, 37.98228], [-122.56663, 37.98173], [-122.5674, 37.98218], [-122.56742, 37.98218], [-122.56799, 37.98253]]]]} | Open Access 1 | Memorial Park | 22131 | 1292 | San Anselmo, City of 431 | City 2 | City Agency 2 | http://www.townofsananselmo.org/index.aspx?nid=106 | City 2 | 10.388 | Memorial Park | ||
7583 | 7583 | 7582 | {"type": "MultiPolygon", "coordinates": [[[[-122.57174, 37.9877], [-122.57157, 37.98793], [-122.5715, 37.98795], [-122.57136, 37.98792], [-122.57122, 37.98785], [-122.57112, 37.98781], [-122.5709, 37.98781], [-122.57063, 37.98785], [-122.57061, 37.98783], [-122.57079, 37.98761], [-122.57139, 37.98731], [-122.57174, 37.9877]]], [[[-122.57181, 37.98811], [-122.57174, 37.98818], [-122.5716, 37.98804], [-122.57162, 37.98803], [-122.57181, 37.98811]]]]} | Open Access 1 | Oak Park | 23000 | 1292 | San Anselmo, City of 431 | City 2 | City Agency 2 | http://www.townofsananselmo.org/index.aspx?nid=106 | City 2 | 0.94 | Oak Park | ||
8578 | 8578 | 8577 | {"type": "Polygon", "coordinates": [[[-122.56401, 37.98004], [-122.564, 37.98004], [-122.56078, 37.9797], [-122.56089, 37.97926], [-122.56361, 37.97889], [-122.56389, 37.9793], [-122.56396, 37.97945], [-122.56393, 37.97965], [-122.56386, 37.9797], [-122.56394, 37.97981], [-122.5639, 37.97985], [-122.56401, 37.98004]]]} | Open Access 1 | Red Hill Community Park | 24224 | 1292 | San Anselmo, City of 431 | City 2 | City Agency 2 | http://www.townofsananselmo.org/index.aspx?nid=106 | City 2 | 5.852 | Red Hill Community Park | ||
8841 | 8841 | 8840 | {"type": "Polygon", "coordinates": [[[-122.56804, 37.97383], [-122.56784, 37.97429], [-122.56769, 37.97449], [-122.56722, 37.97489], [-122.56704, 37.97479], [-122.56688, 37.97474], [-122.56674, 37.97443], [-122.56663, 37.97445], [-122.56646, 37.97411], [-122.56717, 37.97388], [-122.56754, 37.97362], [-122.56804, 37.97383]]]} | Open Access 1 | Robson-Harrington Park | 24506 | 1292 | San Anselmo, City of 431 | City 2 | City Agency 2 | http://www.townofsananselmo.org/index.aspx?nid=106 | City 2 | 2.611 | Robson-Harrington Park | ||
9131 | 9131 | 9130 | {"type": "Polygon", "coordinates": [[[-122.58094, 37.999], [-122.58055, 37.99895], [-122.58037, 37.99899], [-122.58045, 37.99893], [-122.58045, 37.99884], [-122.58014, 37.9986], [-122.57957, 37.9981], [-122.57879, 37.998], [-122.57748, 37.99775], [-122.57764, 37.99746], [-122.57825, 37.99747], [-122.57843, 37.99756], [-122.57858, 37.99759], [-122.5798, 37.99753], [-122.58022, 37.99749], [-122.58033, 37.99772], [-122.58027, 37.99806], [-122.58033, 37.99808], [-122.58032, 37.99841], [-122.58055, 37.99869], [-122.58094, 37.999]]]} | Open Access 1 | San Anselmo Lands 002 | 24826 | 1292 | San Anselmo, City of 431 | City 2 | City Agency 2 | http://www.townofsananselmo.org/index.aspx?nid=106 | City 2 | 3.946 | San Anselmo Lands 002 | ||
9535 | 9535 | 9534 | {"type": "MultiPolygon", "coordinates": [[[[-122.57832, 37.9871], [-122.57826, 37.98722], [-122.57819, 37.98723], [-122.57815, 37.9872], [-122.57811, 37.98703], [-122.57814, 37.987], [-122.57818, 37.987], [-122.57831, 37.98706], [-122.57832, 37.9871]]], [[[-122.57835, 37.98794], [-122.57828, 37.98797], [-122.57821, 37.98797], [-122.57821, 37.9879], [-122.57825, 37.98787], [-122.5783, 37.98788], [-122.57835, 37.98794]]], [[[-122.57854, 37.98687], [-122.57853, 37.9869], [-122.57837, 37.98697], [-122.57825, 37.98693], [-122.57822, 37.9869], [-122.57823, 37.98687], [-122.57825, 37.98685], [-122.57847, 37.98682], [-122.57852, 37.98683], [-122.57854, 37.98687]]]]} | Open Access 1 | SFDB - Butterfield Road Landscape | 25333 | 1292 | San Anselmo, City of 431 | City 2 | City Agency 2 | http://www.townofsananselmo.org/index.aspx?nid=106 | City 2 | 0.184 | SFDB - Butterfield Road Landscape | ||
9781 | 9781 | 9780 | {"type": "Polygon", "coordinates": [[[-122.56596, 37.99241], [-122.56243, 37.99431], [-122.56075, 37.99224], [-122.55765, 37.99387], [-122.55737, 37.99356], [-122.55831, 37.98957], [-122.55979, 37.9893], [-122.56022, 37.989], [-122.56046, 37.9892], [-122.56082, 37.98895], [-122.56122, 37.98958], [-122.56139, 37.98953], [-122.56142, 37.98967], [-122.56139, 37.9898], [-122.5613, 37.98991], [-122.56112, 37.99005], [-122.56105, 37.99012], [-122.561, 37.99021], [-122.56098, 37.9903], [-122.561, 37.99039], [-122.56104, 37.99048], [-122.56133, 37.99074], [-122.56165, 37.99053], [-122.56152, 37.99039], [-122.56264, 37.98956], [-122.56264, 37.98952], [-122.5626, 37.98948], [-122.56243, 37.9895], [-122.56232, 37.98949], [-122.56197, 37.98931], [-122.56214, 37.98925], [-122.56232, 37.98937], [-122.56242, 37.98929], [-122.56296, 37.98957], [-122.56319, 37.9901], [-122.56316, 37.99013], [-122.56335, 37.9907], [-122.56359, 37.99066], [-122.56374, 37.99052], [-122.56406, 37.98877], [-122.56426, 37.98866], [-122.56409, 37.98975], [-122.56401, 37.99036], [-122.56416, 37.99074], [-122.56596, 37.99241]]]} | Open Access 1 | Sorich Ranch Park | 25627 | 1292 | San Anselmo, City of 431 | City 2 | City Agency 2 | http://www.townofsananselmo.org/index.aspx?nid=106 | City 2 | 61.418 | Sorich Ranch Park |
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]);