superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where MNG_AGENCY = 583
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8310 | 8310 | 8309 | {"type": "Polygon", "coordinates": [[[-119.2115, 34.14498], [-119.21144, 34.1451], [-119.21107, 34.14541], [-119.21085, 34.14564], [-119.21076, 34.14577], [-119.21036, 34.14629], [-119.21009, 34.14666], [-119.20999, 34.14675], [-119.20965, 34.14675], [-119.21029, 34.14607], [-119.21007, 34.1459], [-119.21066, 34.14511], [-119.21066, 34.14509], [-119.21019, 34.14498], [-119.20968, 34.14508], [-119.20967, 34.1448], [-119.20939, 34.1449], [-119.20923, 34.14492], [-119.20903, 34.14498], [-119.20848, 34.14505], [-119.20719, 34.14501], [-119.20696, 34.14498], [-119.20618, 34.14493], [-119.20559, 34.14486], [-119.2047, 34.1448], [-119.20412, 34.14471], [-119.20317, 34.14468], [-119.20299, 34.14466], [-119.20291, 34.14496], [-119.20277, 34.14496], [-119.20078, 34.14437], [-119.20039, 34.14443], [-119.20004, 34.1448], [-119.19995, 34.14479], [-119.19953, 34.14467], [-119.19632, 34.14354], [-119.19595, 34.14346], [-119.19551, 34.14345], [-119.19531, 34.14358], [-119.19519, 34.14351], [-119.19504, 34.14345], [-119.19325, 34.14297], [-119.19281, 34.14283], [-119.19253, 34.14272], [-119.19215, 34.14254], [-119.19213, 34.14249], [-119.19217, 34.14241], [-119.19218, 34.14235], [-119.19216, 34.14223], [-119.19207, 34.14206], [-119.19191, 34.14191], [-119.19073, 34.14132], [-119.1907, 34.14133], [-119.19055, 34.14123], [-119.1904, 34.14143], [-119.19008, 34.14182], [-119.18738, 34.14024], [-119.18701, 34.14013], [-119.18703, 34.14009], [-119.18691, 34.14002], [-119.1872, 34.13969], [-119.18843, 34.14039], [-119.18921, 34.13945], [-119.1892, 34.13943], [-119.18897, 34.13931], [-119.19003, 34.1384], [-119.19478, 34.1407], [-119.19691, 34.14178], [-119.19859, 34.14257], [-119.19944, 34.14301], [-119.20034, 34.14353], [-119.2015, 34.14387], [-119.20213, 34.14416], [-119.2024, 34.14424], [-119.20259, 34.14426], [-119.2027, 34.14425], [-119.20296, 34.14417], [-119.20317, 34.14415], [-119.20328, 34.14417], [-119.20346, 34.14424], [-119.20376, 34.14433], [-119.20615, 34.14465], [-119.2073, 34.14478], [-119.20802, 34.14482], [-119.20852, 34.14484], [-119.20881, 34.14481], [-119.20899, 34.14477], [-119.2094, 34.14459], [-119.20952, 34.14456], [-119.2098, 34.14458], [-119.20989, 34.14456], [-119.20992, 34.1445], [-119.21, 34.14444], [-119.21012, 34.1444], [-119.21039, 34.14439], [-119.21049, 34.14443], [-119.21061, 34.14452], [-119.2107, 34.14464], [-119.21095, 34.14479], [-119.21125, 34.14486], [-119.21144, 34.14489], [-119.2115, 34.14498]]]} | Open Access 1 | Port Hueneme Beach Park | 23895 | 1259 | Port Hueneme, City of 583 | City 2 | City Agency 2 | http://www.ci.port-hueneme.ca.us/ | City 2 | 84.724 | Port Hueneme Beach Park | ||
8663 | 8663 | 8662 | {"type": "Polygon", "coordinates": [[[-119.19405, 34.15613], [-119.1939, 34.15658], [-119.19391, 34.15663], [-119.19397, 34.15665], [-119.19363, 34.15675], [-119.19376, 34.15637], [-119.19375, 34.15635], [-119.19303, 34.15658], [-119.19302, 34.1566], [-119.19316, 34.1569], [-119.19011, 34.15787], [-119.18975, 34.15804], [-119.18954, 34.15817], [-119.18941, 34.15828], [-119.18922, 34.15847], [-119.18905, 34.15871], [-119.18892, 34.15897], [-119.18886, 34.15919], [-119.18882, 34.15944], [-119.18881, 34.16091], [-119.18879, 34.16094], [-119.18613, 34.16092], [-119.1861, 34.16091], [-119.18611, 34.1596], [-119.18643, 34.1596], [-119.18645, 34.15955], [-119.18757, 34.15956], [-119.18782, 34.15915], [-119.18791, 34.15918], [-119.18796, 34.1591], [-119.18796, 34.15909], [-119.18788, 34.15905], [-119.18818, 34.15858], [-119.18926, 34.15752], [-119.19383, 34.15607], [-119.19405, 34.15613]]]} | Open Access 1 | Richard Barb Bubbling Springs | 24321 | 1259 | Port Hueneme, City of 583 | City 2 | City Agency 2 | http://www.ci.port-hueneme.ca.us/ | City 2 | 20.374 | Richard Barb Bubbling Springs |
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]);