units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where COUNTY = 24 and MNG_AGENCY = 776
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5143 | 5143 | 5142 | {"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 | 44983 | Observatory Park Trail | 23046 | 1413 | Ukiah, City of 796 | City 2 | City Agency 2 | http://www.cityofukiah.com/recreation/ | City 2 | 1413 | Ukiah, City of 776 | City 2 | City Agency 2 | Mendocino 24 | 2.559 | Observatory Park Trail | 0 | Local Recreation Area 3 | 4 | |
11932 | 11932 | 11931 | {"type": "Polygon", "coordinates": [[[-123.22308, 39.15217], [-123.22221, 39.15218], [-123.22214, 39.15121], [-123.22179, 39.15122], [-123.22179, 39.1513], [-123.2213, 39.15129], [-123.22064, 39.15207], [-123.22029, 39.15192], [-123.22076, 39.15107], [-123.22095, 39.15112], [-123.2211, 39.15084], [-123.2211, 39.15083], [-123.22067, 39.15069], [-123.22112, 39.15002], [-123.22208, 39.14999], [-123.22215, 39.14955], [-123.22223, 39.14958], [-123.22224, 39.14953], [-123.22226, 39.14954], [-123.22231, 39.1496], [-123.22235, 39.1496], [-123.22236, 39.14972], [-123.22272, 39.14973], [-123.22283, 39.14978], [-123.22302, 39.14976], [-123.22298, 39.14998], [-123.22307, 39.14999], [-123.22312, 39.15119], [-123.22308, 39.15217]]]} | Open Access 1 | 24546 | Giorno Park/Anton Stadium | 19301 | 1413 | Ukiah, City of 796 | City 2 | City Agency 2 | http://www.cityofukiah.com/recreation/ | City 2 | 1413 | Ukiah, City of 776 | City 2 | City Agency 2 | Mendocino 24 | 10.198 | Giorno Park/Anton Stadium | None 1049 | |||
11933 | 11933 | 11932 | {"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 | 24547 | McGarvey Park | 22032 | 1413 | Ukiah, City of 796 | City 2 | City Agency 2 | http://www.cityofukiah.com/recreation/ | City 2 | 1413 | Ukiah, City of 776 | City 2 | City Agency 2 | Mendocino 24 | 0.926 | McGarvey Park | 0 | Local Park 2 | 4 | |
11934 | 11934 | 11933 | {"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 | 24548 | Oak Manor Park | 22986 | 1413 | Ukiah, City of 796 | City 2 | City Agency 2 | http://www.cityofukiah.com/recreation/ | City 2 | 1413 | Ukiah, City of 776 | City 2 | City Agency 2 | Mendocino 24 | 4.526 | Oak Manor Park | 0 | Local Park 2 | 4 | |
11935 | 11935 | 11934 | {"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 | 24549 | Todd Grove Park | 26383 | 1413 | Ukiah, City of 796 | City 2 | City Agency 2 | http://www.cityofukiah.com/recreation/ | City 2 | 1413 | Ukiah, City of 776 | City 2 | City Agency 2 | Mendocino 24 | 9.42 | Todd Grove Park | 0 | Local Park 2 | 4 | |
11936 | 11936 | 11935 | {"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.19305, 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.19776, 39.15951], [-123.19793, 39.16065], [-123.198, 39.16129], [-123.19803, 39.16147]]]} | Open Access 1 | 24550 | Ukiah Softball Complex | 26646 | 1413 | Ukiah, City of 796 | City 2 | City Agency 2 | http://www.cityofukiah.com/recreation/ | City 2 | 1413 | Ukiah, City of 776 | City 2 | City Agency 2 | Mendocino 24 | 20.165 | Ukiah Softball Complex | 0 | Local Recreation Area 3 | 4 | |
11937 | 11937 | 11936 | {"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 | 24551 | Vinewood Park | 27133 | 1413 | Ukiah, City of 796 | City 2 | City Agency 2 | http://www.cityofukiah.com/recreation/ | City 2 | 1413 | Ukiah, City of 776 | City 2 | City Agency 2 | Mendocino 24 | 4.763 | Vinewood Park | 0 | Local Park 2 | 4 | |
14231 | 14231 | 14230 | {"type": "Polygon", "coordinates": [[[-123.20606, 39.14817], [-123.20523, 39.14828], [-123.20523, 39.14823], [-123.20524, 39.14815], [-123.20521, 39.14809], [-123.20506, 39.14793], [-123.20522, 39.1479], [-123.20523, 39.14774], [-123.20532, 39.14765], [-123.20544, 39.14767], [-123.20548, 39.14771], [-123.20592, 39.14763], [-123.20606, 39.14817]]]} | Open Access 1 | 48853 | Hudson-Carpenter Park | 33573 | 1413 | Ukiah, City of 796 | City 2 | City Agency 2 | http://www.cityofukiah.com/recreation/ | City 2 | 1413 | Ukiah, City of 776 | City 2 | City Agency 2 | https://www.cityofukiah.com/parks-facilities/ | Mendocino 24 | 1.056 | Hudson-Carpenter Park | 0 | Local Park 2 | 4 |
14250 | 14250 | 14249 | {"type": "Polygon", "coordinates": [[[-123.18507, 39.14617], [-123.18355, 39.14629], [-123.18334, 39.14633], [-123.18285, 39.14639], [-123.18261, 39.1464], [-123.18255, 39.14638], [-123.18247, 39.14631], [-123.18244, 39.14618], [-123.18243, 39.14541], [-123.18235, 39.14482], [-123.18242, 39.14451], [-123.1826, 39.14446], [-123.18327, 39.14459], [-123.18469, 39.14438], [-123.18482, 39.14492], [-123.18507, 39.14617]]]} | Open Access 1 | 48854 | Riverside Park | 33574 | 1413 | Ukiah, City of 796 | City 2 | City Agency 2 | http://www.cityofukiah.com/recreation/ | City 2 | 1413 | Ukiah, City of 776 | City 2 | City Agency 2 | https://www.cityofukiah.com/parks-facilities/ | Mendocino 24 | 10.577 | Riverside Park | 0 | Local Park 2 | 4 |
14988 | 14988 | 14987 | {"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 | 45628 | Orchard Park | 28451 | 1413 | Ukiah, City of 796 | City 2 | City Agency 2 | http://www.cityofukiah.com/recreation/ | City 2 | 1413 | Ukiah, City of 776 | City 2 | City Agency 2 | http://www.cityofukiah.com/parks-facilities/ | Mendocino 24 | 0.77 | Orchard Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);