superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where MNG_AGENCY = 540 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1827 | 1827 | 1826 | {"type": "MultiPolygon", "coordinates": [[[[-121.77039, 38.68764], [-121.77038, 38.68822], [-121.77033, 38.68825], [-121.76935, 38.68824], [-121.76936, 38.68781], [-121.7694, 38.68763], [-121.77039, 38.68764]]], [[[-121.77039, 38.68738], [-121.77039, 38.68759], [-121.76942, 38.68758], [-121.76951, 38.6874], [-121.76953, 38.68729], [-121.76958, 38.68725], [-121.76963, 38.68725], [-121.77008, 38.68735], [-121.77039, 38.68738]]]]} | Open Access 1 | Beamer Park | 15917 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 2.063 | Beamer Park | ||
3023 | 3023 | 3022 | {"type": "MultiPolygon", "coordinates": [[[[-121.79303, 38.68953], [-121.79303, 38.68978], [-121.793, 38.68976], [-121.79182, 38.68975], [-121.79135, 38.68992], [-121.79135, 38.68994], [-121.79148, 38.69015], [-121.79152, 38.69017], [-121.79134, 38.69024], [-121.79109, 38.6903], [-121.79059, 38.69035], [-121.79055, 38.69034], [-121.79052, 38.69031], [-121.79042, 38.69003], [-121.79023, 38.68971], [-121.7902, 38.68954], [-121.7902, 38.6895], [-121.79023, 38.68952], [-121.79133, 38.68953], [-121.79135, 38.6895], [-121.79136, 38.68927], [-121.79133, 38.68924], [-121.79145, 38.68925], [-121.79143, 38.68927], [-121.79142, 38.6895], [-121.79145, 38.68953], [-121.793, 38.68954], [-121.79303, 38.68953]]], [[[-121.79678, 38.69034], [-121.79678, 38.69045], [-121.79643, 38.69046], [-121.79642, 38.69086], [-121.79652, 38.69115], [-121.79652, 38.69146], [-121.79647, 38.69151], [-121.79645, 38.69156], [-121.79646, 38.69163], [-121.79652, 38.69168], [-121.79651, 38.69198], [-121.7963, 38.69198], [-121.79631, 38.6917], [-121.79622, 38.69165], [-121.79624, 38.69158], [-121.79622, 38.69151], [-121.79631, 38.69146], [-121.79631, 38.69099], [-121.79623, 38.69094], [-121.79625, 38.69086], [-121.79623, 38.69081], [-121.79619, 38.69076], [-121.79618, 38.69049], [-121.79463, 38.69047], [-121.79463, 38.69026], [-121.79458, 38.69021], [-121.79463, 38.69013], [-121.79462, 38.69006], [-121.79458, 38.69002], [-121.79463, 38.68997], [-121.79463, 38.68976], [-121.79324, 38.68975], [-121.79324, 38.68959], [-121.79463, 38.68959], [-121.79464, 38.68938], [-121.79459, 38.68934], [-121.79463, 38.6893], [-121.79464, 38.68925], [-121.79463, 38.68919], [-121.79459, 38.68914], [-121.79464, 38.68909], [-121.79465, 38.68857], [-121.79482, 38.68857], [-121.79482, 38.6891], [-121.79487, 38.68914], [-121.79483, 38.68919], [-121.79482, 38.68925], [-121.79483, 38.6893], [-121.79488, 38.68935], [-121.79488, 38.68959], [-121.79526, 38.6896], [-121.79526, 38.68985], [-121.79537, 38.6899], [-121.79536, 38.68996], [-121.79538, 38.69002], [-121.79526, 38.69009], [-121.79526, 38.69032], [-121.79678, 38.69034]]], [[[-121.7977, 38.69031], [-121.7977, 38.69039], [-121.79695, 38.69039], [-121.79695, 38.69031], [-121.7977, 38.69031]]]]} | Open Access 1 | Cline Park | 17427 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 6.798 | Cline Park | ||
9869 | 9869 | 9868 | {"type": "Polygon", "coordinates": [[[-121.72875, 38.64797], [-121.72864, 38.65335], [-121.72639, 38.65334], [-121.72638, 38.65153], [-121.71966, 38.65152], [-121.71964, 38.65159], [-121.7104, 38.65156], [-121.7105, 38.64787], [-121.72282, 38.64792], [-121.72283, 38.649], [-121.72589, 38.649], [-121.72593, 38.64795], [-121.72875, 38.64797]]]} | Unknown Access 4 | Spring Lake | 25739 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 160.736 | Spring Lake | ||
5443 | 5443 | 5442 | {"type": "Polygon", "coordinates": [[[-121.73582, 38.65115], [-121.73581, 38.65136], [-121.73578, 38.6514], [-121.73571, 38.65147], [-121.73569, 38.65155], [-121.7357, 38.65164], [-121.7358, 38.65176], [-121.73579, 38.65203], [-121.73492, 38.65202], [-121.73489, 38.65297], [-121.73349, 38.65293], [-121.73353, 38.6513], [-121.73352, 38.65111], [-121.73582, 38.65115]]]} | Open Access 1 | Jack Slaven Park | 20308 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 7.946 | Jack Slaven Park | ||
944 | 944 | 943 | {"type": "Polygon", "coordinates": [[[-121.74692, 38.67152], [-121.74691, 38.67166], [-121.74661, 38.67166], [-121.74659, 38.67169], [-121.7463, 38.67169], [-121.74624, 38.67161], [-121.74616, 38.67155], [-121.7462, 38.67152], [-121.74692, 38.67152]]]} | Open Access 1 | Avignon Park | 33578 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 0.252 | Avignon Park | ||
8387 | 8387 | 8386 | {"type": "Polygon", "coordinates": [[[-121.75633, 38.66505], [-121.75632, 38.66646], [-121.75516, 38.66645], [-121.7552, 38.66623], [-121.75517, 38.66615], [-121.75511, 38.66608], [-121.75564, 38.66566], [-121.75565, 38.66505], [-121.75633, 38.66505]]]} | Open Access 1 | Prairie Park | 23976 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 2.97 | Prairie Park | ||
2561 | 2561 | 2560 | {"type": "Polygon", "coordinates": [[[-121.76079, 38.67012], [-121.76077, 38.67026], [-121.7607, 38.67044], [-121.76061, 38.67057], [-121.76043, 38.67077], [-121.76033, 38.67095], [-121.76028, 38.67111], [-121.76026, 38.67128], [-121.76023, 38.67131], [-121.76019, 38.67132], [-121.75856, 38.6713], [-121.75858, 38.6701], [-121.76079, 38.67012]]]} | Open Access 1 | Campbell Park | 16780 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 5.57 | Campbell Park | ||
2324 | 2324 | 2323 | {"type": "Polygon", "coordinates": [[[-121.76346, 38.66679], [-121.76344, 38.66826], [-121.76095, 38.66821], [-121.76099, 38.66679], [-121.76346, 38.66679]]]} | Open Access 1 | Buchignani Field | 16471 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 8.604 | Buchignani Field | ||
10452 | 10452 | 10451 | {"type": "Polygon", "coordinates": [[[-121.76736, 38.65829], [-121.76658, 38.65828], [-121.76656, 38.65823], [-121.76613, 38.65822], [-121.76614, 38.65775], [-121.76699, 38.65793], [-121.76727, 38.65791], [-121.76736, 38.65829]]]} | Open Access 1 | Tredway Park | 26521 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 1.121 | Tredway Park | ||
4404 | 4404 | 4403 | {"type": "Polygon", "coordinates": [[[-121.76831, 38.67754], [-121.76829, 38.67864], [-121.76724, 38.67863], [-121.76725, 38.67808], [-121.76746, 38.67808], [-121.76748, 38.67805], [-121.76765, 38.67805], [-121.76766, 38.67753], [-121.76831, 38.67754]]]} | Open Access 1 | Freeman Park | 19093 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 2.257 | Freeman Park | ||
4108 | 4108 | 4107 | {"type": "Polygon", "coordinates": [[[-121.76949, 38.66654], [-121.76949, 38.66668], [-121.76897, 38.66668], [-121.76896, 38.66711], [-121.76896, 38.6678], [-121.76948, 38.66781], [-121.76948, 38.66784], [-121.76792, 38.66784], [-121.76793, 38.66653], [-121.76949, 38.66654]]]} | Open Access 1 | Everman Park | 18769 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 3.446 | Everman Park | ||
3723 | 3723 | 3722 | {"type": "Polygon", "coordinates": [[[-121.76987, 38.69786], [-121.76986, 38.699], [-121.76561, 38.69894], [-121.76562, 38.69712], [-121.76987, 38.69786]]]} | Open Access 1 | Dubach Park | 18290 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 14.992 | Dubach Park | ||
1336 | 1336 | 1335 | {"type": "Polygon", "coordinates": [[[-121.77067, 38.68632], [-121.77066, 38.68637], [-121.77063, 38.68642], [-121.77053, 38.68646], [-121.77042, 38.68644], [-121.77037, 38.68639], [-121.77036, 38.68635], [-121.77036, 38.6863], [-121.7704, 38.68625], [-121.7705, 38.68622], [-121.77061, 38.68624], [-121.77065, 38.68628], [-121.77067, 38.68632]]]} | Open Access 1 | Beamer Circle Park | 15916 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 0.138 | Beamer Circle Park | ||
3289 | 3289 | 3288 | {"type": "Polygon", "coordinates": [[[-121.77493, 38.65574], [-121.77492, 38.65597], [-121.77485, 38.65623], [-121.77475, 38.65641], [-121.77452, 38.65676], [-121.77443, 38.65693], [-121.77437, 38.65712], [-121.77434, 38.65734], [-121.77431, 38.65819], [-121.7743, 38.65822], [-121.77423, 38.65825], [-121.77401, 38.65818], [-121.77387, 38.65811], [-121.77366, 38.65798], [-121.77347, 38.65789], [-121.77329, 38.65786], [-121.77302, 38.65785], [-121.77306, 38.65573], [-121.77493, 38.65574]]]} | Open Access 1 | Crawford Park | 17761 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 8.276 | Crawford Park | ||
9830 | 9830 | 9829 | {"type": "Polygon", "coordinates": [[[-121.77705, 38.66552], [-121.77598, 38.66551], [-121.7759, 38.66527], [-121.77496, 38.66526], [-121.77497, 38.66478], [-121.77639, 38.66479], [-121.7764, 38.66475], [-121.77639, 38.66468], [-121.77631, 38.66459], [-121.77661, 38.66468], [-121.777, 38.6647], [-121.77704, 38.66472], [-121.77705, 38.66476], [-121.77705, 38.66552]]]} | Open Access 1 | Southland Park | 25692 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 3.241 | Southland Park | ||
11386 | 11386 | 11385 | {"type": "Polygon", "coordinates": [[[-121.77937, 38.67216], [-121.77936, 38.67377], [-121.77932, 38.67379], [-121.77838, 38.67379], [-121.77836, 38.67377], [-121.77838, 38.67215], [-121.77934, 38.67215], [-121.77937, 38.67216]]]} | Open Access 1 | Woodland holding 1 | 27720 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 3.887 | Woodland holding 1 | ||
2532 | 2532 | 2531 | {"type": "Polygon", "coordinates": [[[-121.78147, 38.68367], [-121.78135, 38.68378], [-121.78134, 38.68468], [-121.77826, 38.68466], [-121.77822, 38.68465], [-121.7782, 38.68462], [-121.77821, 38.68357], [-121.77863, 38.68357], [-121.77864, 38.68366], [-121.78147, 38.68367]]]} | Open Access 1 | Camarena Fields | 16746 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 7.649 | Camarena Fields | ||
2917 | 2917 | 2916 | {"type": "Polygon", "coordinates": [[[-121.78275, 38.68463], [-121.78272, 38.68467], [-121.78268, 38.68468], [-121.78134, 38.68468], [-121.78135, 38.68377], [-121.78159, 38.68358], [-121.78266, 38.68358], [-121.78268, 38.68384], [-121.78274, 38.68426], [-121.78275, 38.68463]]]} | Open Access 1 | Clark Field | 17387 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 3.522 | Clark Field | ||
11407 | 11407 | 11406 | {"type": "Polygon", "coordinates": [[[-121.79336, 38.65917], [-121.79333, 38.66134], [-121.79301, 38.6614], [-121.79266, 38.66138], [-121.79239, 38.66126], [-121.79198, 38.66105], [-121.79195, 38.6611], [-121.79178, 38.661], [-121.79153, 38.66067], [-121.79158, 38.66034], [-121.79175, 38.65984], [-121.79195, 38.65945], [-121.79202, 38.65913], [-121.79331, 38.65914], [-121.79336, 38.65917]]]} | Open Access 1 | Woodside Park | 27743 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 8.183 | Woodside Park | ||
5503 | 5503 | 5502 | {"type": "Polygon", "coordinates": [[[-121.79616, 38.69283], [-121.79614, 38.69282], [-121.79614, 38.69276], [-121.79611, 38.6927], [-121.79613, 38.69268], [-121.79613, 38.6924], [-121.79609, 38.69236], [-121.79578, 38.69236], [-121.7956, 38.69248], [-121.79507, 38.69248], [-121.79508, 38.69228], [-121.79514, 38.69225], [-121.79616, 38.69226], [-121.79616, 38.69283]]]} | Open Access 1 | Jeff Roddy Park | 20377 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 0.484 | Jeff Roddy 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]);