units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where DES_TP = 2, MNG_AGENCY = 189 and YR_EST = 1978
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Sonoma County Regional Parks Dept., County of · 3 ✖
DES_TP 1
- Local Park · 3 ✖
ACCESS_TYP 1
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6817 | 6817 | 6816 | {"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.29827], [-122.45582, 38.29787], [-122.45582, 38.29775], [-122.45579, 38.29751], [-122.45582, 38.29721], [-122.45793, 38.29742]]]} | Open Access 1 | 5388 | Arnold Park | 15603 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 11.311 | Arnold Park | 1978 | Local Park 2 | 4 | |
9228 | 9228 | 9227 | {"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 | 16914 | Helen Putnam Park | 19799 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 168.099 | Helen Putnam Park | 1978 | Local Park 2 | 4 | |
16282 | 16282 | 16281 | {"type": "Polygon", "coordinates": [[[-122.52557, 38.35429], [-122.52529, 38.35427], [-122.5248, 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.52236, 38.35965], [-122.52336, 38.35959], [-122.5236, 38.36051], [-122.52408, 38.36046], [-122.52412, 38.3607], [-122.52367, 38.36077], [-122.52378, 38.36121], [-122.52254, 38.36143], [-122.5227, 38.36212], [-122.5213, 38.36288], [-122.52164, 38.3638], [-122.52138, 38.36391], [-122.5212, 38.36404], [-122.52104, 38.36425], [-122.52107, 38.36436], [-122.52115, 38.36446], [-122.52119, 38.36447], [-122.52126, 38.36458], [-122.52072, 38.36467], [-122.51872, 38.36549], [-122.51876, 38.36587], [-122.51774, 38.3664], [-122.51711, 38.36563], [-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.36008], [-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.52312, 38.35407], [-122.52331, 38.35389], [-122.52472, 38.35344], [-122.52557, 38.35429]]]} | Open Access 1 | 1008 | Sonoma Valley Regional Park | 25619 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 254.384 | Sonoma Valley RP | 1978 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);