superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 1 and PARK_NAME = "Weston Park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11101 | 11101 | 11100 | {"type": "Polygon", "coordinates": [[[-119.05992, 35.27041], [-119.05991, 35.2711], [-119.05985, 35.27115], [-119.0596, 35.27115], [-119.05932, 35.27117], [-119.05905, 35.27123], [-119.05885, 35.27129], [-119.05859, 35.27139], [-119.05837, 35.27152], [-119.05816, 35.27166], [-119.05801, 35.2718], [-119.05792, 35.27181], [-119.05761, 35.27158], [-119.05761, 35.27069], [-119.05757, 35.27042], [-119.05762, 35.27036], [-119.05985, 35.27035], [-119.05992, 35.27041]]]} | Open Access 1 | Weston Park | 27413 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 5.967 | Weston Park | ||
11144 | 11144 | 11143 | {"type": "MultiPolygon", "coordinates": [[[[-116.96508, 33.7484], [-116.96418, 33.74841], [-116.96418, 33.74775], [-116.96426, 33.7477], [-116.96499, 33.7477], [-116.96507, 33.74775], [-116.96508, 33.7484]]], [[[-116.96508, 33.74928], [-116.96419, 33.74929], [-116.96418, 33.74858], [-116.96508, 33.74857], [-116.96508, 33.74928]]]]} | Open Access 1 | Weston Park | 27414 | 1132 | Hemet, City of 139 | City 2 | City Agency 2 | http://www.cityofhemet.org/index.aspx?nid=95 | City 2 | 3.22 | Weston Park | ||
11145 | 11145 | 11144 | {"type": "Polygon", "coordinates": [[[-117.20878, 33.92995], [-117.20869, 33.93002], [-117.20851, 33.93004], [-117.20839, 33.93007], [-117.20832, 33.93003], [-117.20827, 33.92988], [-117.20813, 33.92963], [-117.20797, 33.92942], [-117.20768, 33.92911], [-117.2076, 33.92895], [-117.20755, 33.9288], [-117.20755, 33.92834], [-117.20759, 33.9283], [-117.20869, 33.92829], [-117.20877, 33.92837], [-117.20878, 33.92995]]]} | Open Access 1 | Weston Park | 27415 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 4.151 | Weston Park | ||
13716 | 13716 | 13715 | {"type": "Polygon", "coordinates": [[[-121.30865, 37.90889], [-121.30746, 37.909], [-121.30481, 37.90915], [-121.30474, 37.9091], [-121.30473, 37.90886], [-121.3046, 37.90803], [-121.30443, 37.90751], [-121.30415, 37.90675], [-121.30828, 37.90633], [-121.30839, 37.90763], [-121.30845, 37.90806], [-121.30845, 37.90826], [-121.30851, 37.90835], [-121.30861, 37.90839], [-121.30865, 37.90889]]]} | Open Access 1 | Weston Park | 31211 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 23.889 | Weston 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]);