superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 388, MNG_AG_TYP = 4 and PARK_NAME = "Sycamore Grove Park"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Recreation/Parks District · 1 ✖
MNG_AGENCY 1
- Livermore Area Recreation and Park District · 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
640 | 640 | 639 | {"type": "Polygon", "coordinates": [[[-121.78658, 37.62857], [-121.78639, 37.62859], [-121.78639, 37.629], [-121.78301, 37.63081], [-121.78301, 37.63221], [-121.78168, 37.63162], [-121.78099, 37.63201], [-121.77771, 37.63469], [-121.77856, 37.63573], [-121.77897, 37.63582], [-121.77921, 37.63623], [-121.77965, 37.63653], [-121.77979, 37.63678], [-121.77901, 37.63755], [-121.78164, 37.63973], [-121.78238, 37.64025], [-121.78297, 37.64099], [-121.78298, 37.64103], [-121.78298, 37.64187], [-121.78303, 37.64198], [-121.783, 37.64511], [-121.78017, 37.64511], [-121.78015, 37.64456], [-121.77334, 37.64016], [-121.77441, 37.63942], [-121.77441, 37.63939], [-121.7655, 37.63598], [-121.7649, 37.63596], [-121.76378, 37.63796], [-121.76341, 37.63779], [-121.76341, 37.63776], [-121.76197, 37.63689], [-121.76193, 37.63691], [-121.761, 37.63635], [-121.76005, 37.63603], [-121.75954, 37.63572], [-121.7589, 37.635], [-121.75806, 37.63426], [-121.75585, 37.63251], [-121.75566, 37.63222], [-121.75562, 37.63187], [-121.75547, 37.63119], [-121.75543, 37.63067], [-121.75555, 37.63037], [-121.75597, 37.62978], [-121.75602, 37.62951], [-121.75839, 37.62951], [-121.7587, 37.63008], [-121.75854, 37.63151], [-121.75914, 37.63199], [-121.75989, 37.63222], [-121.76148, 37.63231], [-121.76343, 37.63202], [-121.76358, 37.63204], [-121.76381, 37.63203], [-121.76409, 37.63198], [-121.76519, 37.6316], [-121.76571, 37.63146], [-121.7663, 37.63135], [-121.76661, 37.63132], [-121.76696, 37.63133], [-121.76731, 37.6314], [-121.76839, 37.6317], [-121.76951, 37.63212], [-121.76974, 37.63218], [-121.77001, 37.63222], [-121.77003, 37.63221], [-121.77003, 37.6315], [-121.77034, 37.63139], [-121.77076, 37.63138], [-121.77119, 37.63148], [-121.77159, 37.6317], [-121.77259, 37.63185], [-121.77328, 37.63181], [-121.77317, 37.63095], [-121.77286, 37.62999], [-121.77233, 37.62864], [-121.77225, 37.62807], [-121.77203, 37.62782], [-121.77003, 37.62782], [-121.77003, 37.62239], [-121.78373, 37.62241], [-121.78377, 37.62256], [-121.78454, 37.62258], [-121.7849, 37.62297], [-121.78524, 37.62373], [-121.78524, 37.62423], [-121.78591, 37.62585], [-121.78588, 37.62623], [-121.78639, 37.62692], [-121.78657, 37.62688], [-121.78658, 37.62857]]]} | Open Access 1 | Sycamore Grove Park | http://www.larpd.org/open_space/sycamore.html | 5294 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.dst.ca.us/ | Special District 4 | 731.015 | Sycamore Grove 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]);