units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 1 and LABEL_NAME = "Ridgeview Park"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AG_TYP
MNG_AGENCY 6
DES_TP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3186 | 3186 | 3185 | {"type": "Polygon", "coordinates": [[[-121.97524, 38.38991], [-121.97523, 38.38996], [-121.97491, 38.39019], [-121.97457, 38.39046], [-121.97438, 38.39066], [-121.97412, 38.391], [-121.97374, 38.39084], [-121.97236, 38.39046], [-121.97306, 38.38966], [-121.97336, 38.38929], [-121.9738, 38.38898], [-121.97412, 38.3888], [-121.97524, 38.38991]]]} | Open Access 1 | 22102 | Ridgeview Park | 24361 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 7.844 | Ridgeview Park | 0 | Local Park 2 | 4 | |
3881 | 3881 | 3880 | {"type": "Polygon", "coordinates": [[[-121.08686, 38.67117], [-121.08649, 38.67114], [-121.08644, 38.67143], [-121.08638, 38.67163], [-121.08619, 38.67155], [-121.08591, 38.67149], [-121.08522, 38.67145], [-121.08502, 38.67141], [-121.0848, 38.67134], [-121.08458, 38.67124], [-121.08483, 38.67096], [-121.08454, 38.67067], [-121.08451, 38.67031], [-121.08457, 38.6703], [-121.08459, 38.67013], [-121.08451, 38.6701], [-121.08468, 38.66971], [-121.08446, 38.66955], [-121.08426, 38.66953], [-121.08428, 38.66921], [-121.08469, 38.66917], [-121.08467, 38.66889], [-121.08437, 38.66833], [-121.08293, 38.66772], [-121.08259, 38.66712], [-121.08212, 38.66619], [-121.08201, 38.66555], [-121.08178, 38.66542], [-121.08187, 38.66533], [-121.08197, 38.66525], [-121.08214, 38.66515], [-121.08218, 38.66546], [-121.08261, 38.66638], [-121.08292, 38.66712], [-121.08337, 38.66754], [-121.08477, 38.66832], [-121.08514, 38.66836], [-121.08554, 38.6683], [-121.08555, 38.66804], [-121.08579, 38.66805], [-121.08604, 38.66812], [-121.08625, 38.66824], [-121.08639, 38.66838], [-121.08647, 38.66848], [-121.08653, 38.66868], [-121.08655, 38.66925], [-121.08664, 38.66966], [-121.08623, 38.66973], [-121.08622, 38.66974], [-121.08636, 38.67023], [-121.08647, 38.67051], [-121.08686, 38.67117]]]} | Open Access 1 | 35713 | Ridgeview Park | 30310 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 17.979 | Ridgeview Park | 0 | Local Park 2 | 4 | |
4348 | 4348 | 4347 | {"type": "Polygon", "coordinates": [[[-121.47463, 41.94817], [-121.47463, 41.94844], [-121.47419, 41.94844], [-121.47419, 41.94817], [-121.47463, 41.94817]]]} | Open Access 1 | 45654 | Ridgeview Park | 28470 | 1704 | Tulelake, City of 719 | City 2 | City Agency 2 | City 2 | 1704 | Tulelake, City of 702 | City 2 | City Agency 2 | Siskiyou 28 | 0.275 | Ridgeview Park | 0 | Local Park 2 | 4 | ||
7993 | 7993 | 7992 | {"type": "Polygon", "coordinates": [[[-122.14304, 38.19095], [-122.14273, 38.1911], [-122.14244, 38.19273], [-122.1424, 38.19282], [-122.14233, 38.19284], [-122.14197, 38.1927], [-122.14176, 38.19259], [-122.14156, 38.19252], [-122.14126, 38.19248], [-122.1408, 38.19248], [-122.14062, 38.19246], [-122.14051, 38.19243], [-122.14051, 38.19235], [-122.14104, 38.19081], [-122.14151, 38.19087], [-122.14213, 38.19078], [-122.14284, 38.19063], [-122.14304, 38.19095]]]} | Open Access 1 | 10988 | Ridgeview Park | 24359 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 8.277 | Ridgeview Park | 0 | Local Park 2 | 4 | |
9166 | 9166 | 9165 | {"type": "Polygon", "coordinates": [[[-122.42826, 40.56759], [-122.42796, 40.56791], [-122.42804, 40.56814], [-122.42794, 40.56816], [-122.42779, 40.56783], [-122.42747, 40.56764], [-122.42634, 40.56741], [-122.42596, 40.56709], [-122.42536, 40.56709], [-122.42511, 40.56735], [-122.42509, 40.56783], [-122.42553, 40.5688], [-122.42545, 40.56879], [-122.42523, 40.56839], [-122.42492, 40.56848], [-122.42368, 40.56848], [-122.4237, 40.56621], [-122.42486, 40.56621], [-122.42485, 40.56667], [-122.42649, 40.5667], [-122.42676, 40.56621], [-122.42689, 40.56626], [-122.42734, 40.56651], [-122.42751, 40.56672], [-122.4269, 40.56671], [-122.42663, 40.56685], [-122.42641, 40.56688], [-122.4264, 40.56698], [-122.42688, 40.56732], [-122.4277, 40.56758], [-122.42826, 40.56759]]]} | Open Access 1 | 15214 | Ridgeview Park | 24360 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 10.736 | Ridgeview Park | 0 | Local Park 2 | 4 | |
15180 | 15180 | 15179 | {"type": "Polygon", "coordinates": [[[-117.90199, 34.14495], [-117.9019, 34.14501], [-117.90172, 34.14521], [-117.90151, 34.14503], [-117.90138, 34.14481], [-117.90099, 34.14377], [-117.90127, 34.14368], [-117.90127, 34.14369], [-117.90118, 34.14374], [-117.90114, 34.14383], [-117.90122, 34.14412], [-117.9012, 34.14414], [-117.9012, 34.14423], [-117.90126, 34.14431], [-117.90125, 34.14437], [-117.90127, 34.14446], [-117.90134, 34.14451], [-117.90144, 34.14454], [-117.90179, 34.14443], [-117.90182, 34.14443], [-117.90185, 34.14447], [-117.90183, 34.14453], [-117.90167, 34.14466], [-117.90154, 34.14484], [-117.90155, 34.14492], [-117.90159, 34.145], [-117.90164, 34.14503], [-117.90168, 34.14503], [-117.9019, 34.14489], [-117.90195, 34.14489], [-117.90199, 34.14495]]]} | Open Access 1 | 46062 | Ridgeview Park | 29404 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?nid=1232 | Los Angeles 6 | 0.676 | Ridgeview 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]);