superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where MNG_AGENCY = 383, MNG_AG_TYP = 4 and YR_EST = 1997
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- Recreation/Parks District · 3 ✖
MNG_AGENCY 1
- Sonoma County Agricultural Preservation and Open Space District · 3 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3638 | 3638 | 3637 | {"type": "Polygon", "coordinates": [[[-122.74565, 38.48914], [-122.74561, 38.49073], [-122.74474, 38.49073], [-122.74477, 38.48913], [-122.74565, 38.48914]]]} | Restricted Access 2 | Dogbane Preserve | 18185 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 3.336 | Dogbane Preserve | 1997 | |
13749 | 13749 | 13748 | {"type": "Polygon", "coordinates": [[[-122.65381, 38.41605], [-122.6538, 38.41625], [-122.64751, 38.4163], [-122.64864, 38.4159], [-122.64852, 38.41328], [-122.64851, 38.41268], [-122.64841, 38.41182], [-122.65085, 38.41247], [-122.65115, 38.41257], [-122.65126, 38.41264], [-122.65151, 38.41287], [-122.65161, 38.41299], [-122.65187, 38.41345], [-122.65199, 38.4136], [-122.65215, 38.41375], [-122.65228, 38.41382], [-122.65039, 38.41376], [-122.65041, 38.41606], [-122.65381, 38.41605]]]} | No Public Access 3 | Keegan & Coppin | 31258 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 24.712 | Keegan & Coppin | 1997 | |
13751 | 13751 | 13750 | {"type": "Polygon", "coordinates": [[[-122.69492, 38.37231], [-122.69492, 38.37488], [-122.69038, 38.3749], [-122.69035, 38.37399], [-122.68595, 38.37401], [-122.68591, 38.37239], [-122.68608, 38.37239], [-122.68646, 38.37245], [-122.68855, 38.37237], [-122.68995, 38.37236], [-122.69035, 38.37234], [-122.69327, 38.37234], [-122.69492, 38.37231]]]} | No Public Access 3 | Young-Armos | 31260 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 45.004 | Young-Armos | 1997 |
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]);