superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 43, MNG_AG_TYP = 4 and YR_EST = 1979
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Recreation/Parks District · 1 ✖
MNG_AGENCY 1
- Marin County Open Space 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14724 | 14724 | 14723 | {"type": "Polygon", "coordinates": [[[-122.62993, 38.11183], [-122.62914, 38.11182], [-122.62843, 38.11129], [-122.62798, 38.11109], [-122.62795, 38.11074], [-122.62809, 38.11038], [-122.62817, 38.11025], [-122.62824, 38.11004], [-122.62876, 38.10998], [-122.62888, 38.10952], [-122.62888, 38.10924], [-122.62864, 38.10872], [-122.6277, 38.1085], [-122.62751, 38.10872], [-122.6278, 38.10898], [-122.62776, 38.10901], [-122.62593, 38.10843], [-122.62615, 38.11061], [-122.62616, 38.11101], [-122.62534, 38.111], [-122.62471, 38.11113], [-122.62378, 38.1112], [-122.62363, 38.10989], [-122.62249, 38.10988], [-122.62242, 38.10942], [-122.62184, 38.10925], [-122.62128, 38.10932], [-122.62097, 38.11028], [-122.61822, 38.11056], [-122.61779, 38.11039], [-122.61673, 38.10903], [-122.61619, 38.10941], [-122.61599, 38.10868], [-122.61592, 38.1079], [-122.61586, 38.10742], [-122.61595, 38.10701], [-122.61661, 38.1068], [-122.61682, 38.10648], [-122.61827, 38.10705], [-122.61914, 38.10727], [-122.61944, 38.10644], [-122.62079, 38.10666], [-122.6208, 38.10782], [-122.6218, 38.10778], [-122.62255, 38.10762], [-122.62349, 38.10762], [-122.62359, 38.10701], [-122.6229, 38.10674], [-122.62296, 38.10671], [-122.62299, 38.10666], [-122.62377, 38.10679], [-122.62404, 38.10606], [-122.62424, 38.10611], [-122.62458, 38.10634], [-122.62698, 38.10605], [-122.6295, 38.10566], [-122.62969, 38.1056], [-122.62993, 38.11183]]]} | Open Access 1 | Verissimo Hills Open Space Preserve | 26995 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 114.888 | Verissimo Hills OSP | 1979 |
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]);