superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where MNG_AG_TYP = 7 and YR_EST = 1978 sorted by YR_EST
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1583 | 1583 | 1582 | {"type": "Polygon", "coordinates": [[[-122.45793, 38.29742], [-122.45765, 38.29926], [-122.45762, 38.29937], [-122.45758, 38.29944], [-122.45669, 38.29951], [-122.45533, 38.29937], [-122.45551, 38.29826], [-122.45577, 38.29826], [-122.45582, 38.29787], [-122.45582, 38.29775], [-122.45579, 38.29751], [-122.45582, 38.29721], [-122.45793, 38.29742]]]} | Open Access 1 | Arnold Park | 15603 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 11.313 | Arnold Park | 1978 | |
5016 | 5016 | 5015 | {"type": "Polygon", "coordinates": [[[-122.66499, 38.21258], [-122.66493, 38.21342], [-122.66496, 38.21991], [-122.65569, 38.21981], [-122.65572, 38.21288], [-122.65887, 38.21287], [-122.65922, 38.2125], [-122.66047, 38.21133], [-122.66499, 38.21258]]]} | Open Access 1 | Helen Putnam Park | 19799 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 168.099 | Helen Putnam Park | 1978 | |
9769 | 9769 | 9768 | {"type": "Polygon", "coordinates": [[[-122.52557, 38.35429], [-122.52528, 38.35428], [-122.52481, 38.35462], [-122.52536, 38.35545], [-122.52539, 38.35575], [-122.52503, 38.35602], [-122.52486, 38.35606], [-122.52475, 38.35616], [-122.52477, 38.35651], [-122.52474, 38.35681], [-122.52468, 38.35709], [-122.52456, 38.35736], [-122.52425, 38.35777], [-122.52421, 38.35787], [-122.52416, 38.35806], [-122.52425, 38.35824], [-122.52281, 38.35888], [-122.52259, 38.35915], [-122.52234, 38.35954], [-122.52237, 38.35965], [-122.52336, 38.35959], [-122.5236, 38.36051], [-122.52408, 38.36046], [-122.52412, 38.3607], [-122.52368, 38.36077], [-122.52378, 38.36121], [-122.52255, 38.36143], [-122.5227, 38.36212], [-122.52131, 38.36288], [-122.52164, 38.3638], [-122.52138, 38.36391], [-122.5212, 38.36404], [-122.52104, 38.36424], [-122.52107, 38.36437], [-122.52114, 38.36446], [-122.52119, 38.36447], [-122.52126, 38.36458], [-122.52072, 38.36467], [-122.51873, 38.36548], [-122.51876, 38.36587], [-122.51774, 38.3664], [-122.5171, 38.36564], [-122.514, 38.36719], [-122.51335, 38.36655], [-122.51271, 38.36695], [-122.51234, 38.36659], [-122.51065, 38.36488], [-122.51199, 38.36403], [-122.51199, 38.36401], [-122.51098, 38.36304], [-122.50966, 38.36392], [-122.50786, 38.36203], [-122.50409, 38.35769], [-122.5035, 38.35687], [-122.50362, 38.35661], [-122.50486, 38.35638], [-122.50626, 38.35783], [-122.50884, 38.36007], [-122.5115, 38.36128], [-122.51253, 38.36145], [-122.51698, 38.36], [-122.51733, 38.35999], [-122.52143, 38.35607], [-122.52185, 38.35259], [-122.52229, 38.35282], [-122.52313, 38.35341], [-122.52273, 38.35355], [-122.52311, 38.35406], [-122.52331, 38.35389], [-122.52472, 38.35344], [-122.52557, 38.35429]]]} | Open Access 1 | Sonoma Valley Regional Park | 25619 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 254.456 | Sonoma Valley RP | 1978 |
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]);