superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, MNG_AG_TYP = 4 and YR_EST = 2007
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13762 | 13762 | 13761 | {"type": "Polygon", "coordinates": [[[-123.08436, 38.41731], [-123.08339, 38.41781], [-123.08307, 38.41824], [-123.07891, 38.419], [-123.07696, 38.41946], [-123.0755, 38.41958], [-123.07523, 38.41971], [-123.0749, 38.41972], [-123.07391, 38.42022], [-123.07362, 38.42069], [-123.07155, 38.41916], [-123.07123, 38.4189], [-123.07012, 38.41946], [-123.05, 38.41394], [-123.04996, 38.41276], [-123.05159, 38.40942], [-123.05189, 38.40885], [-123.05599, 38.39896], [-123.05744, 38.39899], [-123.06296, 38.39893], [-123.07062, 38.39889], [-123.0766, 38.3989], [-123.07661, 38.39927], [-123.07777, 38.40065], [-123.07788, 38.40203], [-123.0783, 38.40265], [-123.0803, 38.40324], [-123.08065, 38.40337], [-123.08077, 38.40419], [-123.08137, 38.40521], [-123.08169, 38.40551], [-123.08067, 38.40628], [-123.08286, 38.40896], [-123.08208, 38.40935], [-123.08436, 38.41731]]]} | Restricted Access 2 | Wright Hill (Poff) Ranch Preserve | 31269 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 1311.071 | Wright Hill (Poff) Ranch Preserve | 2007 |
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]);