superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where MNG_AGENCY = 776
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6832 | 6832 | 6831 | {"type": "Polygon", "coordinates": [[[-123.21197, 39.1479], [-123.21127, 39.14804], [-123.21114, 39.1475], [-123.21183, 39.14738], [-123.21197, 39.1479]]]} | Open Access 1 | McGarvey Park | 22032 | 1413 | Ukiah, City of 776 | City 2 | City Agency 2 | http://www.cityofukiah.com/recreation/ | City 2 | 0.926 | McGarvey Park | ||
7568 | 7568 | 7567 | {"type": "Polygon", "coordinates": [[[-123.19386, 39.14724], [-123.19337, 39.14723], [-123.19227, 39.14734], [-123.19201, 39.14546], [-123.19224, 39.14543], [-123.19277, 39.14585], [-123.19307, 39.14606], [-123.19316, 39.14619], [-123.19357, 39.14691], [-123.19386, 39.14724]]]} | Open Access 1 | Oak Manor Park | 22986 | 1413 | Ukiah, City of 776 | City 2 | City Agency 2 | http://www.cityofukiah.com/recreation/ | City 2 | 4.526 | Oak Manor Park | ||
7614 | 7614 | 7613 | {"type": "Polygon", "coordinates": [[[-123.21229, 39.1384], [-123.21159, 39.13851], [-123.21138, 39.13701], [-123.21209, 39.1369], [-123.21229, 39.1384]]]} | Open Access 1 | Observatory Park Trail | 23046 | 1413 | Ukiah, City of 776 | City 2 | City Agency 2 | http://www.cityofukiah.com/recreation/ | City 2 | 2.559 | Observatory Park Trail | ||
10377 | 10377 | 10376 | {"type": "Polygon", "coordinates": [[[-123.22136, 39.15252], [-123.22095, 39.15405], [-123.22088, 39.15409], [-123.22035, 39.15418], [-123.21818, 39.15212], [-123.21982, 39.15189], [-123.22136, 39.15252]]]} | Open Access 1 | Todd Grove Park | 26383 | 1413 | Ukiah, City of 776 | City 2 | City Agency 2 | http://www.cityofukiah.com/recreation/ | City 2 | 9.419 | Todd Grove Park | ||
10546 | 10546 | 10545 | {"type": "Polygon", "coordinates": [[[-123.19803, 39.16147], [-123.19777, 39.16132], [-123.19706, 39.16098], [-123.19584, 39.16063], [-123.19504, 39.16045], [-123.19363, 39.1604], [-123.19299, 39.15994], [-123.19205, 39.15918], [-123.19306, 39.15931], [-123.19354, 39.15926], [-123.19472, 39.15902], [-123.19543, 39.15884], [-123.19602, 39.15882], [-123.19676, 39.15886], [-123.1977, 39.15864], [-123.19794, 39.1595], [-123.19777, 39.15951], [-123.19776, 39.15952], [-123.19793, 39.16065], [-123.198, 39.16129], [-123.19803, 39.16147]]]} | Open Access 1 | Ukiah Softball Complex | 26646 | 1413 | Ukiah, City of 776 | City 2 | City Agency 2 | http://www.cityofukiah.com/recreation/ | City 2 | 20.166 | Ukiah Softball Complex | ||
10910 | 10910 | 10909 | {"type": "Polygon", "coordinates": [[[-123.21346, 39.16223], [-123.21127, 39.16243], [-123.21123, 39.16233], [-123.21122, 39.1622], [-123.21148, 39.16163], [-123.21151, 39.16146], [-123.21148, 39.16135], [-123.21291, 39.16125], [-123.21309, 39.16122], [-123.21346, 39.16223]]]} | Open Access 1 | Vinewood Park | 27133 | 1413 | Ukiah, City of 776 | City 2 | City Agency 2 | http://www.cityofukiah.com/recreation/ | City 2 | 4.763 | Vinewood Park | ||
11814 | 11814 | 11813 | {"type": "Polygon", "coordinates": [[[-123.19726, 39.14138], [-123.19722, 39.14143], [-123.19694, 39.14157], [-123.19683, 39.14169], [-123.1965, 39.14159], [-123.19646, 39.14116], [-123.19716, 39.14113], [-123.19726, 39.14138]]]} | Open Access 1 | Orchard Park | http://www.cityofukiah.com/parks-facilities/ | 28451 | 1413 | Ukiah, City of 776 | City 2 | City Agency 2 | http://www.cityofukiah.com/recreation/ | City 2 | 0.77 | Orchard 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]);