units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, DES_TP = 2 and LABEL_NAME = "Maxwell Farms RP"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16356 | 16356 | 16355 | {"type": "Polygon", "coordinates": [[[-122.48498, 38.29995], [-122.48499, 38.30014], [-122.48496, 38.30023], [-122.48485, 38.30037], [-122.48477, 38.3005], [-122.48441, 38.3008], [-122.48396, 38.30112], [-122.48388, 38.30121], [-122.48383, 38.30135], [-122.48383, 38.30148], [-122.48385, 38.30158], [-122.48421, 38.30244], [-122.4842, 38.30251], [-122.48418, 38.30255], [-122.48383, 38.30261], [-122.48128, 38.30272], [-122.47925, 38.30275], [-122.47887, 38.30272], [-122.47774, 38.30275], [-122.47743, 38.30274], [-122.47727, 38.30269], [-122.477, 38.30259], [-122.47674, 38.30254], [-122.47651, 38.30253], [-122.4762, 38.30256], [-122.47609, 38.30253], [-122.47519, 38.30158], [-122.4751, 38.30145], [-122.47504, 38.30133], [-122.47498, 38.30114], [-122.47497, 38.30102], [-122.47497, 38.30081], [-122.47498, 38.30077], [-122.475, 38.30077], [-122.47502, 38.30064], [-122.47767, 38.30091], [-122.47746, 38.29989], [-122.47693, 38.29884], [-122.48187, 38.29845], [-122.48143, 38.29788], [-122.48129, 38.29749], [-122.48071, 38.29723], [-122.47973, 38.29729], [-122.48056, 38.29647], [-122.48135, 38.29698], [-122.48158, 38.29719], [-122.48184, 38.29757], [-122.48191, 38.29782], [-122.48197, 38.29811], [-122.48204, 38.29832], [-122.48217, 38.29852], [-122.48241, 38.29867], [-122.48329, 38.29884], [-122.48353, 38.2989], [-122.48374, 38.299], [-122.48401, 38.29914], [-122.48442, 38.2994], [-122.48468, 38.2996], [-122.48498, 38.29995]]]} | Open Access 1 | 17744 | Maxwell Farms Regional Park | 21969 | 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 | 78.864 | Maxwell Farms RP | 0 | 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]);