superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Robertson Park", MNG_AGENCY = 388 and MNG_AG_TYP = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8833 | 8833 | 8832 | {"type": "MultiPolygon", "coordinates": [[[[-121.75351, 37.6671], [-121.75347, 37.66943], [-121.75222, 37.66956], [-121.7518, 37.67095], [-121.75163, 37.67111], [-121.74978, 37.66992], [-121.74978, 37.66658], [-121.75158, 37.66658], [-121.7518, 37.6666], [-121.75201, 37.66664], [-121.75216, 37.6667], [-121.75258, 37.66691], [-121.75283, 37.66701], [-121.75315, 37.66708], [-121.75351, 37.6671]]], [[[-121.76804, 37.67187], [-121.76786, 37.67184], [-121.76782, 37.67226], [-121.76721, 37.67219], [-121.76719, 37.67204], [-121.76607, 37.67215], [-121.76474, 37.67184], [-121.76409, 37.67193], [-121.76329, 37.67196], [-121.76223, 37.67195], [-121.76222, 37.67138], [-121.76128, 37.67111], [-121.76095, 37.67105], [-121.7606, 37.67102], [-121.75812, 37.67102], [-121.7581, 37.67099], [-121.75351, 37.67099], [-121.75358, 37.66698], [-121.75521, 37.66698], [-121.75761, 37.66704], [-121.75763, 37.66708], [-121.7621, 37.66709], [-121.76212, 37.6703], [-121.76373, 37.67101], [-121.7664, 37.67101], [-121.76663, 37.67089], [-121.76693, 37.67081], [-121.76707, 37.6708], [-121.768, 37.67079], [-121.76801, 37.67101], [-121.76711, 37.67102], [-121.76711, 37.6718], [-121.76801, 37.67182], [-121.76804, 37.67187]]], [[[-121.76857, 37.67267], [-121.76839, 37.67259], [-121.76834, 37.67252], [-121.76851, 37.67255], [-121.76856, 37.67262], [-121.76857, 37.67267]]]]} | Open Access 1 | Robertson Park | 24497 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.dst.ca.us/ | Special District 4 | 127.846 | Robertson 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]);