superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where MNG_AGENCY = 540 sorted by PARK_URL
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);