units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1 and UNIT_NAME = "Volcan Mountain Wilderness Preserve"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AG_TYP
MNG_AGENCY 2
DES_TP 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16904 | 16904 | 16903 | {"type": "Polygon", "coordinates": [[[-116.60256, 33.11614], [-116.60251, 33.11629], [-116.6025, 33.11642], [-116.60251, 33.11657], [-116.60257, 33.11685], [-116.60258, 33.117], [-116.60257, 33.11722], [-116.60255, 33.11743], [-116.60256, 33.11766], [-116.6026, 33.11791], [-116.60279, 33.1185], [-116.60283, 33.11883], [-116.60281, 33.11911], [-116.60275, 33.11936], [-116.60235, 33.12066], [-116.60203, 33.12176], [-116.60181, 33.12225], [-116.60156, 33.12264], [-116.60149, 33.12276], [-116.60141, 33.12304], [-116.60137, 33.12331], [-116.59729, 33.12338], [-116.59745, 33.12582], [-116.59836, 33.12606], [-116.59831, 33.12672], [-116.5984, 33.12723], [-116.59856, 33.12787], [-116.59827, 33.12788], [-116.59829, 33.13385], [-116.59825, 33.13386], [-116.59825, 33.13536], [-116.58954, 33.13585], [-116.58956, 33.13743], [-116.58955, 33.1398], [-116.58984, 33.13987], [-116.59018, 33.1399], [-116.59043, 33.13989], [-116.59079, 33.13982], [-116.59097, 33.1399], [-116.59121, 33.14015], [-116.59132, 33.14024], [-116.59159, 33.14032], [-116.59206, 33.14036], [-116.59243, 33.14035], [-116.59276, 33.14024], [-116.59288, 33.14015], [-116.59301, 33.14001], [-116.59345, 33.1396], [-116.59359, 33.1396], [-116.5936, 33.13971], [-116.59354, 33.14001], [-116.59345, 33.14023], [-116.59334, 33.14043], [-116.59327, 33.14068], [-116.59366, 33.14037], [-116.59393, 33.14029], [-116.59414, 33.1403], [-116.59458, 33.14038], [-116.59477, 33.14049], [-116.59483, 33.14054], [-116.5949, 33.14068], [-116.59491, 33.1408], [-116.59498, 33.14091], [-116.59525, 33.14098], [-116.59573, 33.141], [-116.59628, 33.14097], [-116.59669, 33.1409], [-116.59708, 33.14078], [-116.59736, 33.14068], [-116.59629, 33.14299], [-116.59195, 33.14333], [-116.58527, 33.14393], [-116.58532, 33.14793], [-116.58097, 33.14827], [-116.58088, 33.14433], [-116.58525, 33.14393], [-116.58518, 33.14049], [-116.58576, 33.14155], [-116.58742, 33.1409], [-116.58577, 33.13801], [-116.58564, 33.13639], [-116.58331, 33.13704], [-116.58474, 33.13967], [-116.58504, 33.13966], [-116.58504, 33.14001], [-116.58079, 33.14029], [-116.5807, 33.13633], [-116.58033, 33.12927], [-116.58004, 33.12054], [-116.56782, 33.12137], [-116.56788, 33.12522], [-116.55932, 33.12575], [-116.55915, 33.12187], [-116.55967, 33.12183], [-116.55962, 33.1184], [-116.56364, 33.11824], [-116.56349, 33.10731], [-116.56766, 33.10716], [-116.56736, 33.09696], [-116.57145, 33.09689], [-116.57146, 33.09366], [-116.57968, 33.09373], [-116.58547, 33.09423], [-116.5858, 33.09441], [-116.58605, 33.09451], [-116.58624, 33.09454], [-116.58652, 33.09455], [-116.58676, 33.09458], [-116.58702, 33.09465], [-116.58731, 33.09478], [-116.58752, 33.09499], [-116.58772, 33.09551], [-116.58782, 33.09571], [-116.58796, 33.09586], [-116.58811, 33.09594], [-116.5883, 33.09599], [-116.58849, 33.096], [-116.589, 33.09591], [-116.58913, 33.10051], [-116.59584, 33.10112], [-116.59835, 33.10378], [-116.59974, 33.10508], [-116.59986, 33.10509], [-116.59991, 33.10863], [-116.60027, 33.10864], [-116.60031, 33.11052], [-116.59823, 33.11055], [-116.59823, 33.10864], [-116.58933, 33.10776], [-116.58917, 33.11307], [-116.59824, 33.11415], [-116.59825, 33.115], [-116.60256, 33.11614]], [[-116.57991, 33.09966], [-116.58453, 33.10009], [-116.58442, 33.09705], [-116.5798, 33.09663], [-116.57991, 33.09966]]]} | Open Access 1 | 10653 | Volcan Mountain Wilderness Preserve | 29261 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/VolcanMountain.html | San Diego 4 | 3013.276 | Volcan Mtn. Wilderness Preserve | 0 | Local Conservation Area 4 | 2 |
16917 | 16917 | 16916 | {"type": "MultiPolygon", "coordinates": [[[[-116.59408, 33.15137], [-116.5897, 33.15166], [-116.58967, 33.1474], [-116.5906, 33.14589], [-116.59217, 33.14588], [-116.59219, 33.14793], [-116.59401, 33.14784], [-116.59407, 33.15133], [-116.59408, 33.15137]]], [[[-116.60729, 33.13867], [-116.60595, 33.14048], [-116.60542, 33.14383], [-116.60515, 33.14379], [-116.60489, 33.14372], [-116.60467, 33.14363], [-116.60434, 33.14346], [-116.60408, 33.14337], [-116.60384, 33.14332], [-116.60345, 33.14327], [-116.60035, 33.14481], [-116.59837, 33.14496], [-116.59831, 33.14088], [-116.59792, 33.14069], [-116.59776, 33.14065], [-116.59759, 33.14064], [-116.59734, 33.14068], [-116.59708, 33.14078], [-116.59669, 33.1409], [-116.59628, 33.14097], [-116.59573, 33.14101], [-116.59525, 33.14098], [-116.59498, 33.14091], [-116.59491, 33.1408], [-116.5949, 33.14068], [-116.59486, 33.14058], [-116.59479, 33.1405], [-116.59469, 33.14043], [-116.59454, 33.14037], [-116.59404, 33.14029], [-116.59385, 33.1403], [-116.59366, 33.14037], [-116.59355, 33.14044], [-116.59325, 33.1407], [-116.59334, 33.14043], [-116.59342, 33.14027], [-116.59353, 33.14013], [-116.59361, 33.14016], [-116.59395, 33.13963], [-116.59383, 33.13914], [-116.59385, 33.1356], [-116.59825, 33.13536], [-116.59829, 33.13385], [-116.59827, 33.12787], [-116.6003, 33.12794], [-116.60103, 33.12798], [-116.60142, 33.12798], [-116.60155, 33.13262], [-116.60124, 33.1326], [-116.60134, 33.13326], [-116.60152, 33.13326], [-116.60171, 33.13324], [-116.60217, 33.13306], [-116.60256, 33.13297], [-116.6029, 33.13297], [-116.60297, 33.13299], [-116.60304, 33.13305], [-116.60311, 33.1332], [-116.60309, 33.13325], [-116.60306, 33.1333], [-116.60296, 33.13335], [-116.60279, 33.13339], [-116.60263, 33.13346], [-116.60252, 33.13353], [-116.60246, 33.13361], [-116.60244, 33.13368], [-116.60245, 33.13418], [-116.60241, 33.1344], [-116.60344, 33.13434], [-116.60353, 33.1343], [-116.60358, 33.13427], [-116.60367, 33.13401], [-116.60423, 33.13395], [-116.60462, 33.13382], [-116.60492, 33.13354], [-116.60483, 33.13294], [-116.60704, 33.13315], [-116.60729, 33.13867]]]]} | Open Access 1 | 46819 | Volcan Mountain Wilderness Preserve | 30284 | 3333 | Volcan Mountain Preserve Foundation 1182 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.volcanmt.org/acquisition-projects-accomplishments | Non Governmental Organization 10 | 3333 | Volcan Mountain Preserve Foundation 1120 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.volcanmt.org | San Diego 4 | 381.895 | Volcan Mtn. Wilderness Preserve | 0 | Private Conservation 16 | 2 |
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]);