units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 1 and MNG_AGENCY = 574
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3101 | 3101 | 3100 | {"type": "Polygon", "coordinates": [[[-122.54604, 39.88145], [-122.5458, 39.88281], [-122.54366, 39.88282], [-122.54397, 39.88098], [-122.54604, 39.88145]]]} | Open Access 1 | 48690 | Simpson-Finnell Park | 33429 | 367 | Tehama, County of 582 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | https://www.co.tehama.ca.us/simpson-finnell-park | Tehama 18 | 8.049 | Simpson-Finnell Park | 0 | Local Park 2 | 4 |
3855 | 3855 | 3854 | {"type": "Polygon", "coordinates": [[[-122.13624, 40.16726], [-122.13608, 40.16757], [-122.13608, 40.16789], [-122.13579, 40.16833], [-122.13525, 40.16893], [-122.13502, 40.16922], [-122.13467, 40.1694], [-122.13392, 40.1697], [-122.13353, 40.16995], [-122.13318, 40.17051], [-122.13307, 40.17111], [-122.13021, 40.17111], [-122.13094, 40.17091], [-122.13251, 40.17066], [-122.13277, 40.17057], [-122.13318, 40.17011], [-122.13339, 40.16963], [-122.13448, 40.16788], [-122.13496, 40.16757], [-122.13539, 40.16737], [-122.13586, 40.16728], [-122.13624, 40.16726]]]} | Open Access 1 | 45504 | Cone Grove Park | 28336 | 367 | Tehama, County of 582 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/cone-grove-park | Tehama 18 | 10.282 | Cone Grove Park | 0 | Local Park 2 | 4 |
4055 | 4055 | 4054 | {"type": "Polygon", "coordinates": [[[-122.30883, 40.14508], [-122.30881, 40.14591], [-122.30838, 40.14651], [-122.30818, 40.14666], [-122.30791, 40.14682], [-122.306, 40.14747], [-122.30603, 40.14724], [-122.30583, 40.14724], [-122.30582, 40.14753], [-122.30406, 40.1481], [-122.30412, 40.14504], [-122.30883, 40.14508]]]} | Open Access 1 | 44417 | Ridgeway Park | 24362 | 367 | Tehama, County of 582 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | Tehama 18 | 24.281 | Ridgeway Park | 0 | Local Park 2 | 4 | |
4219 | 4219 | 4218 | {"type": "Polygon", "coordinates": [[[-122.11797, 40.03123], [-122.11791, 40.03135], [-122.11783, 40.03163], [-122.11781, 40.03191], [-122.11764, 40.03248], [-122.11763, 40.03275], [-122.11756, 40.03306], [-122.11552, 40.03307], [-122.11426, 40.03337], [-122.11309, 40.03337], [-122.11307, 40.0296], [-122.11571, 40.02933], [-122.11667, 40.03121], [-122.11797, 40.03123]]]} | Open Access 1 | 44979 | Mill Creek Park | 22224 | 367 | Tehama, County of 582 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | Tehama 18 | 34.399 | Mill Creek Park | 0 | Local Park 2 | 4 | |
4812 | 4812 | 4811 | {"type": "Polygon", "coordinates": [[[-122.11291, 40.02963], [-122.11291, 40.03329], [-122.11092, 40.0333], [-122.11089, 40.03065], [-122.11223, 40.02981], [-122.11291, 40.02963]]]} | Open Access 1 | 48689 | Unnamed Site - Tehama, County of | 33428 | 367 | Tehama, County of 582 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | Tehama 18 | 15.209 | 0 | Local Other or Unknown 14 | 4 | ||
14958 | 14958 | 14957 | {"type": "Polygon", "coordinates": [[[-122.14993, 40.05946], [-122.14908, 40.05981], [-122.14838, 40.05879], [-122.14924, 40.05843], [-122.14993, 40.05946]]]} | Open Access 1 | 45564 | Gerber Park | 28392 | 367 | Tehama, County of 582 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/gerber-park | Tehama 18 | 2.613 | Gerber Park | 0 | Local Park 2 | 4 |
15013 | 15013 | 15012 | {"type": "Polygon", "coordinates": [[[-122.09227, 39.91075], [-122.09061, 39.91171], [-122.0895, 39.91054], [-122.08863, 39.90939], [-122.08995, 39.90859], [-122.0914, 39.90935], [-122.0916, 39.90961], [-122.09108, 39.90984], [-122.09107, 39.90985], [-122.09144, 39.91], [-122.09203, 39.91045], [-122.09227, 39.91075]]]} | Open Access 1 | 45666 | Tehama River County Park | 28483 | 367 | Tehama, County of 582 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/tehama-county-river-park | Tehama 18 | 13.662 | Tehama River County Park | 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]);