superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where MNG_AGENCY = 38 sorted by LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6348 | 6348 | 6347 | {"type": "Polygon", "coordinates": [[[-120.4419, 34.65701], [-120.44087, 34.65701], [-120.44017, 34.65588], [-120.44101, 34.65643], [-120.4419, 34.65701]]]} | Open Access 1 | Lompoc holding 9 | 21435 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1.466 | Lompoc holding 9 | ||
8184 | 8184 | 8183 | {"type": "Polygon", "coordinates": [[[-120.44383, 34.64848], [-120.44381, 34.64997], [-120.44255, 34.64995], [-120.44256, 34.64847], [-120.44383, 34.64848]]]} | Open Access 1 | Pioneer Park | 23724 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 4.711 | Pioneer Park | ||
13072 | 13072 | 13071 | {"type": "Polygon", "coordinates": [[[-120.44863, 34.66551], [-120.44853, 34.6679], [-120.44856, 34.67117], [-120.44719, 34.67074], [-120.44611, 34.67003], [-120.44498, 34.66914], [-120.4443, 34.66829], [-120.44427, 34.66787], [-120.44428, 34.66667], [-120.44863, 34.66551]]]} | Open Access 1 | Riverbend Park | http://www.cityoflompoc.com/parks_rec/river.htm | 30314 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 42.798 | Riverbend Park | |
9092 | 9092 | 9091 | {"type": "MultiPolygon", "coordinates": [[[[-120.46865, 34.63751], [-120.46863, 34.63892], [-120.46689, 34.6389], [-120.46691, 34.63749], [-120.46865, 34.63751]]], [[[-120.47057, 34.63592], [-120.47056, 34.63741], [-120.46885, 34.6374], [-120.46883, 34.63734], [-120.46691, 34.63732], [-120.46693, 34.63589], [-120.47057, 34.63592]]]]} | Open Access 1 | Ryon Park | 24763 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 19.612 | Ryon Park | ||
8822 | 8822 | 8821 | {"type": "Polygon", "coordinates": [[[-120.47173, 34.64553], [-120.47171, 34.64701], [-120.47055, 34.647], [-120.47057, 34.64552], [-120.47173, 34.64553]]]} | Open Access 1 | Thompson Park | 26315 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 4.345 | Thompson Park | ||
1674 | 1674 | 1673 | {"type": "Polygon", "coordinates": [[[-120.47471, 34.6314], [-120.4747, 34.63191], [-120.47317, 34.6319], [-120.47317, 34.63139], [-120.47471, 34.6314]]]} | Open Access 1 | Westvale Street Park | 27431 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1.963 | Westvale Street 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]);