superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where MNG_AG_TYP = 2 and PARK_NAME = "Wildwood 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11220 | 11220 | 11219 | {"type": "Polygon", "coordinates": [[[-121.80608, 39.76755], [-121.80419, 39.76528], [-121.80279, 39.76367], [-121.80358, 39.76323], [-121.80417, 39.76268], [-121.80426, 39.76274], [-121.80495, 39.76259], [-121.80525, 39.76249], [-121.80535, 39.76249], [-121.80539, 39.76252], [-121.80554, 39.76278], [-121.80578, 39.7633], [-121.80587, 39.76356], [-121.80597, 39.76392], [-121.80605, 39.76446], [-121.80608, 39.76755]]]} | Open Access 1 | Wildwood Park | 27520 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 19.794 | Wildwood Park | ||
11221 | 11221 | 11220 | {"type": "Polygon", "coordinates": [[[-117.27856, 34.17011], [-117.27837, 34.16963], [-117.27812, 34.16909], [-117.27778, 34.16851], [-117.27754, 34.16817], [-117.27728, 34.16784], [-117.27701, 34.16753], [-117.27661, 34.16713], [-117.27629, 34.16684], [-117.27584, 34.16649], [-117.27549, 34.16623], [-117.27511, 34.166], [-117.27473, 34.16578], [-117.27419, 34.16551], [-117.27364, 34.16527], [-117.27321, 34.16511], [-117.27854, 34.16512], [-117.27856, 34.17011]]]} | Open Access 1 | Wildwood Park | 27521 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 23.111 | Wildwood Park | ||
11222 | 11222 | 11221 | {"type": "Polygon", "coordinates": [[[-122.03638, 37.25821], [-122.03593, 37.25874], [-122.03597, 37.25918], [-122.03594, 37.25923], [-122.03589, 37.25925], [-122.03554, 37.25925], [-122.03493, 37.25809], [-122.03453, 37.25824], [-122.03447, 37.25816], [-122.03424, 37.25825], [-122.03421, 37.25833], [-122.03411, 37.25826], [-122.03489, 37.25761], [-122.03528, 37.2575], [-122.03535, 37.25755], [-122.03535, 37.25758], [-122.03543, 37.25755], [-122.03563, 37.25759], [-122.03569, 37.25752], [-122.03636, 37.25777], [-122.03625, 37.25777], [-122.03609, 37.25782], [-122.0361, 37.25788], [-122.0362, 37.2581], [-122.03638, 37.25821]]]} | Open Access 1 | Wildwood Park | 27522 | 1326 | Saratoga, City of 513 | City 2 | City Agency 2 | http://www.saratoga.ca.us/cityhall/pw/parks/default.asp | City 2 | 4.494 | Wildwood Park | 1968 | |
11223 | 11223 | 11222 | {"type": "Polygon", "coordinates": [[[-117.2368, 33.20483], [-117.23693, 33.20506], [-117.23694, 33.20515], [-117.23692, 33.20532], [-117.23689, 33.20539], [-117.2366, 33.20577], [-117.2364, 33.20609], [-117.23565, 33.20588], [-117.2361, 33.20519], [-117.2368, 33.20483]]]} | Open Access 1 | Wildwood Park | http://www.cityofvista.com/services/parks-and-facilities | 27523 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 2.221 | Wildwood Park | |
11224 | 11224 | 11223 | {"type": "MultiPolygon", "coordinates": [[[[-117.00876, 34.01403], [-117.00847, 34.01408], [-117.00827, 34.01415], [-117.00803, 34.01428], [-117.00786, 34.01441], [-117.00773, 34.01456], [-117.00763, 34.01473], [-117.00757, 34.01491], [-117.00755, 34.01512], [-117.00748, 34.01517], [-117.00748, 34.01529], [-117.0042, 34.01527], [-117.00417, 34.01412], [-117.00484, 34.01389], [-117.00517, 34.01359], [-117.0064, 34.01388], [-117.008, 34.01403], [-117.00876, 34.01403]]], [[[-117.01091, 34.01525], [-117.00967, 34.01531], [-117.0079, 34.0153], [-117.00791, 34.01517], [-117.00785, 34.01513], [-117.00784, 34.01506], [-117.00786, 34.01493], [-117.0079, 34.01482], [-117.00798, 34.01467], [-117.00806, 34.01456], [-117.00817, 34.01446], [-117.00827, 34.01438], [-117.00852, 34.01428], [-117.00956, 34.01406], [-117.01027, 34.01412], [-117.0109, 34.01408], [-117.01091, 34.01525]]]]} | Open Access 1 | Wildwood Park | 27524 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 21.305 | Wildwood 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]);