superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where ACCESS_TYP = 1 and MNG_AGENCY = 267
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 10
MNG_AGENCY 1
- Yucca Valley, Town of · 10 ✖
ACCESS_TYP 1
- Open Access · 10 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1017 | 1017 | 1016 | {"type": "Polygon", "coordinates": [[[-116.4312, 34.12789], [-116.42859, 34.12788], [-116.42859, 34.12743], [-116.42823, 34.12742], [-116.42823, 34.12697], [-116.42837, 34.12695], [-116.42837, 34.1262], [-116.42908, 34.1262], [-116.4291, 34.12615], [-116.4312, 34.12616], [-116.4312, 34.12789]]]} | Open Access 1 | Brehm Park | 32817 | 1356 | Yucca Valley, Town of 267 | City 2 | City Agency 2 | http://www.yucca-valley.org/ | City 2 | 12.198 | Brehm Park | ||
5461 | 5461 | 5460 | {"type": "Polygon", "coordinates": [[[-116.45116, 34.11294], [-116.44916, 34.11324], [-116.44915, 34.11212], [-116.45112, 34.11212], [-116.45116, 34.11217], [-116.45116, 34.11294]]]} | Open Access 1 | Jacobs Park | 20330 | 1356 | Yucca Valley, Town of 267 | City 2 | City Agency 2 | http://www.yucca-valley.org/ | City 2 | 4.908 | Jacobs Park | ||
6494 | 6494 | 6493 | {"type": "Polygon", "coordinates": [[[-116.37894, 34.08414], [-116.37884, 34.08451], [-116.37865, 34.08576], [-116.37769, 34.08566], [-116.37766, 34.08572], [-116.37743, 34.0857], [-116.37721, 34.08562], [-116.37698, 34.0855], [-116.3768, 34.08534], [-116.37678, 34.08504], [-116.37662, 34.0849], [-116.37686, 34.08472], [-116.37708, 34.08459], [-116.37747, 34.0844], [-116.37794, 34.08425], [-116.37838, 34.08417], [-116.37894, 34.08414]]]} | Open Access 1 | Machris Park | 21632 | 1356 | Yucca Valley, Town of 267 | City 2 | City Agency 2 | http://www.yucca-valley.org/ | City 2 | 6.646 | Machris Park | ||
7451 | 7451 | 7450 | {"type": "Polygon", "coordinates": [[[-116.47959, 34.1208], [-116.47955, 34.12807], [-116.47505, 34.12808], [-116.4751, 34.12079], [-116.47959, 34.1208]]]} | Open Access 1 | North Park | 22843 | 1356 | Yucca Valley, Town of 267 | City 2 | City Agency 2 | http://www.yucca-valley.org/ | City 2 | 82.796 | North Park | ||
7936 | 7936 | 7935 | {"type": "Polygon", "coordinates": [[[-116.37877, 34.14016], [-116.37839, 34.14017], [-116.37837, 34.14025], [-116.37741, 34.14026], [-116.37741, 34.13957], [-116.37873, 34.13957], [-116.37877, 34.13962], [-116.37877, 34.14016]]]} | Open Access 1 | Paradise Park | 23406 | 1356 | Yucca Valley, Town of 267 | City 2 | City Agency 2 | http://www.yucca-valley.org/ | City 2 | 2.268 | Paradise Park | ||
8635 | 8635 | 8634 | {"type": "Polygon", "coordinates": [[[-116.44281, 34.1207], [-116.44281, 34.12071], [-116.44174, 34.12069], [-116.44269, 34.12043], [-116.44281, 34.1207]]]} | Open Access 1 | Remembrance Park | 24287 | 1356 | Yucca Valley, Town of 267 | City 2 | City Agency 2 | http://www.yucca-valley.org/ | City 2 | 0.372 | Remembrance Park | ||
9502 | 9502 | 9501 | {"type": "Polygon", "coordinates": [[[-116.42252, 34.12603], [-116.42248, 34.12605], [-116.42248, 34.12774], [-116.42145, 34.12774], [-116.42143, 34.12785], [-116.42062, 34.12785], [-116.42062, 34.12584], [-116.42252, 34.12547], [-116.42252, 34.12603]]]} | Open Access 1 | Sunnyslope Park and BMX Track | 33259 | 1356 | Yucca Valley, Town of 267 | City 2 | City Agency 2 | http://www.yucca-valley.org/ | City 2 | 10.082 | Sunnyslope Park and BMX Track | ||
9812 | 9812 | 9811 | {"type": "Polygon", "coordinates": [[[-116.40101, 34.07618], [-116.40101, 34.07975], [-116.39666, 34.07975], [-116.39664, 34.08004], [-116.39238, 34.08002], [-116.39255, 34.07801], [-116.39256, 34.07638], [-116.39663, 34.07639], [-116.39665, 34.07617], [-116.40101, 34.07618]]]} | Open Access 1 | South Park | 25674 | 1356 | Yucca Valley, Town of 267 | City 2 | City Agency 2 | http://www.yucca-valley.org/ | City 2 | 77.725 | South Park | ||
11552 | 11552 | 11551 | {"type": "Polygon", "coordinates": [[[-116.42114, 34.12538], [-116.41861, 34.12588], [-116.41816, 34.12599], [-116.41782, 34.12609], [-116.4179, 34.12605], [-116.41796, 34.12598], [-116.41798, 34.12591], [-116.41797, 34.12583], [-116.41718, 34.12477], [-116.41723, 34.12444], [-116.41739, 34.12455], [-116.41741, 34.12455], [-116.41749, 34.12374], [-116.41762, 34.12368], [-116.4181, 34.1236], [-116.41834, 34.12358], [-116.41857, 34.12361], [-116.41867, 34.12359], [-116.41874, 34.12351], [-116.41898, 34.12342], [-116.41899, 34.12345], [-116.41902, 34.12345], [-116.41917, 34.12375], [-116.42028, 34.12341], [-116.42047, 34.12338], [-116.42061, 34.12369], [-116.42069, 34.12396], [-116.42069, 34.12462], [-116.42079, 34.12462], [-116.42092, 34.12507], [-116.42105, 34.12506], [-116.42114, 34.12538]]]} | Open Access 1 | Yucca Valley Community Center Park Complex | 33208 | 1356 | Yucca Valley, Town of 267 | City 2 | City Agency 2 | http://www.yucca-valley.org/ | City 2 | 18.19 | Yucca Valley Community Ctr. Park Complex | ||
11560 | 11560 | 11559 | {"type": "Polygon", "coordinates": [[[-116.40704, 34.09993], [-116.40701, 34.10044], [-116.40669, 34.10048], [-116.4059, 34.10067], [-116.40549, 34.10068], [-116.4055, 34.09916], [-116.40621, 34.09919], [-116.40642, 34.09925], [-116.40681, 34.09941], [-116.40686, 34.09947], [-116.40692, 34.09978], [-116.40704, 34.09993]]]} | Open Access 1 | Essig Park | 33209 | 1356 | Yucca Valley, Town of 267 | City 2 | City Agency 2 | http://www.yucca-valley.org/ | City 2 | 4.998 | Essig 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]);