superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where MNG_AGENCY = 540 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
11396 | 11396 | 11395 | {"type": "Polygon", "coordinates": [[[-121.79646, 38.69226], [-121.79646, 38.6925], [-121.79632, 38.69257], [-121.79628, 38.69262], [-121.79625, 38.69269], [-121.79625, 38.69276], [-121.79628, 38.69285], [-121.79627, 38.69346], [-121.79619, 38.69352], [-121.79616, 38.69351], [-121.79621, 38.69345], [-121.79621, 38.69285], [-121.79616, 38.69282], [-121.79616, 38.69226], [-121.79646, 38.69226]]]} | Open Access 1 | Woodland West Park | 27727 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 0.377 | Woodland West 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 | ||
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 | ||
10027 | 10027 | 10026 | {"type": "Polygon", "coordinates": [[[-121.80105, 38.66332], [-121.80104, 38.66354], [-121.79985, 38.66353], [-121.7995, 38.6636], [-121.79944, 38.66364], [-121.79847, 38.66384], [-121.79826, 38.66384], [-121.79827, 38.66331], [-121.79836, 38.66324], [-121.80097, 38.66327], [-121.80102, 38.66328], [-121.80105, 38.66332]]]} | Open Access 1 | Streng Pond Park | 25922 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 2.51 | Streng Pond 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
4920 | 4920 | 4919 | {"type": "Polygon", "coordinates": [[[-121.79776, 38.68261], [-121.79775, 38.68351], [-121.79513, 38.68348], [-121.79518, 38.68346], [-121.7952, 38.68342], [-121.79521, 38.68268], [-121.79514, 38.68257], [-121.79776, 38.68261]]]} | Open Access 1 | Harris Park | 19696 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 5.534 | Harris Park | ||
4509 | 4509 | 4508 | {"type": "Polygon", "coordinates": [[[-121.80076, 38.69286], [-121.80076, 38.69294], [-121.79978, 38.69294], [-121.79939, 38.69299], [-121.79918, 38.69305], [-121.79865, 38.6933], [-121.79854, 38.6934], [-121.79871, 38.69364], [-121.7986, 38.69364], [-121.79846, 38.69357], [-121.79831, 38.69353], [-121.79817, 38.69352], [-121.79798, 38.69352], [-121.7979, 38.69346], [-121.7979, 38.69345], [-121.79793, 38.69347], [-121.79813, 38.69347], [-121.79957, 38.69274], [-121.79965, 38.69275], [-121.79973, 38.69273], [-121.79978, 38.6927], [-121.7998, 38.69264], [-121.79999, 38.69264], [-121.80001, 38.69273], [-121.80037, 38.69273], [-121.80039, 38.69286], [-121.80076, 38.69286]]]} | Open Access 1 | Gary Traynham Park | 19230 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 1.093 | Gary Traynham 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 | ||
4210 | 4210 | 4209 | {"type": "Polygon", "coordinates": [[[-121.79786, 38.67109], [-121.79563, 38.67107], [-121.79564, 38.66933], [-121.79781, 38.66934], [-121.79786, 38.66936], [-121.79787, 38.6694], [-121.79786, 38.67109]]]} | Open Access 1 | Ferns Park | 18882 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 9.284 | Ferns 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 | ||
3455 | 3455 | 3454 | {"type": "Polygon", "coordinates": [[[-121.80257, 38.65901], [-121.80257, 38.65944], [-121.80253, 38.65958], [-121.80253, 38.66038], [-121.80191, 38.66038], [-121.80164, 38.66041], [-121.80121, 38.66082], [-121.80008, 38.66009], [-121.79986, 38.65997], [-121.7996, 38.65989], [-121.79972, 38.65954], [-121.79827, 38.65952], [-121.79824, 38.65929], [-121.79906, 38.659], [-121.80006, 38.65901], [-121.80092, 38.65886], [-121.80094, 38.65854], [-121.80251, 38.65857], [-121.80255, 38.65859], [-121.80257, 38.65863], [-121.80257, 38.65879], [-121.80244, 38.6588], [-121.80243, 38.659], [-121.80257, 38.65901]]]} | Open Access 1 | David Douglass Park | 17941 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 12.865 | David Douglass 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 | ||
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 | ||
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 |
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]);