units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where UNIT_NAME = "Riverside Park"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AG_TYP, DES_TP
MNG_AGENCY 6
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8855 | 8855 | 8854 | {"type": "Polygon", "coordinates": [[[-122.28531, 38.28691], [-122.28514, 38.28692], [-122.28511, 38.287], [-122.28434, 38.2872], [-122.28414, 38.2871], [-122.28374, 38.28832], [-122.28326, 38.29009], [-122.28277, 38.29067], [-122.28216, 38.29153], [-122.28202, 38.29182], [-122.28195, 38.29231], [-122.28197, 38.29287], [-122.2822, 38.29333], [-122.28306, 38.29468], [-122.28289, 38.29523], [-122.28294, 38.29461], [-122.2822, 38.29346], [-122.28196, 38.29299], [-122.28187, 38.29258], [-122.28192, 38.29252], [-122.28185, 38.29205], [-122.28193, 38.29163], [-122.28224, 38.2912], [-122.28315, 38.29007], [-122.28331, 38.28971], [-122.28368, 38.28816], [-122.28369, 38.28793], [-122.28384, 38.28745], [-122.2841, 38.28702], [-122.28419, 38.28694], [-122.28425, 38.28696], [-122.28431, 38.28688], [-122.28471, 38.2868], [-122.2848, 38.28684], [-122.28522, 38.28671], [-122.28519, 38.2868], [-122.28528, 38.28681], [-122.28531, 38.28691]]]} | No Public Access 3 | 14477 | Riverside Park | 24457 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 2.668 | Riverside Park | 0 | Local Park 2 | 4 | |
9740 | 9740 | 9739 | {"type": "Polygon", "coordinates": [[[-118.42497, 35.75303], [-118.42462, 35.75326], [-118.42442, 35.75341], [-118.42419, 35.75362], [-118.42398, 35.75384], [-118.42373, 35.75418], [-118.42356, 35.75449], [-118.42343, 35.75481], [-118.42332, 35.7552], [-118.42327, 35.75522], [-118.42306, 35.75522], [-118.42305, 35.75504], [-118.42321, 35.75489], [-118.42336, 35.7547], [-118.42351, 35.75447], [-118.42365, 35.75417], [-118.42384, 35.75362], [-118.42392, 35.75343], [-118.424, 35.75312], [-118.42397, 35.7527], [-118.42383, 35.75239], [-118.4238, 35.7521], [-118.42369, 35.75164], [-118.42424, 35.75165], [-118.42452, 35.75211], [-118.4247, 35.75244], [-118.42497, 35.75299], [-118.42497, 35.75303]]]} | Open Access 1 | 16533 | Riverside Park | 24454 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 4.275 | Riverside Park | 0 | Local Park 2 | 4 | |
10560 | 10560 | 10559 | {"type": "Polygon", "coordinates": [[[-120.94801, 37.64529], [-120.94714, 37.64529], [-120.94696, 37.64532], [-120.94678, 37.64537], [-120.94654, 37.64549], [-120.94479, 37.64665], [-120.94459, 37.64676], [-120.94438, 37.64684], [-120.94265, 37.64737], [-120.94262, 37.64729], [-120.94257, 37.64713], [-120.9426, 37.64708], [-120.94262, 37.64702], [-120.94261, 37.64536], [-120.94262, 37.64535], [-120.94262, 37.64515], [-120.94265, 37.64512], [-120.94291, 37.6451], [-120.94703, 37.64448], [-120.94796, 37.64447], [-120.94799, 37.64448], [-120.94801, 37.64451], [-120.94801, 37.64529]]]} | Open Access 1 | 18794 | Riverside Park | 24456 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 19.739 | Riverside Park | 0 | Local Park 2 | 4 | |
12223 | 12223 | 12222 | {"type": "Polygon", "coordinates": [[[-120.65267, 40.41073], [-120.6516, 40.41196], [-120.65146, 40.4118], [-120.65132, 40.41167], [-120.65058, 40.41121], [-120.65046, 40.41058], [-120.65049, 40.41027], [-120.65078, 40.40988], [-120.65179, 40.41035], [-120.65181, 40.41033], [-120.65267, 40.41073]]]} | Open Access 1 | 25417 | Riverside Park | 24458 | 1437 | Susanville, City of 1013 | City 2 | City Agency 2 | http://www.cityofsusanville.org/ | City 2 | 1437 | Susanville, City of 975 | City 2 | City Agency 2 | Lassen 54 | 5.83 | Riverside Park | 0 | Local Park 2 | 4 | |
12303 | 12303 | 12302 | {"type": "Polygon", "coordinates": [[[-120.06706, 36.96913], [-120.06617, 36.96914], [-120.06554, 36.96905], [-120.0649, 36.9689], [-120.06379, 36.96856], [-120.06329, 36.96848], [-120.06328, 36.96845], [-120.06372, 36.9684], [-120.06391, 36.96842], [-120.06572, 36.96897], [-120.0666, 36.96907], [-120.06685, 36.969], [-120.06701, 36.96907], [-120.06706, 36.96913]]]} | Open Access 1 | 25959 | Riverside Park | 24455 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 1.216 | Riverside 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 |
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]);