units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1 and UNIT_NAME = "Riverside Park"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 2
ACCESS_TYP 1
- Open Access · 5 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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]);