units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1 and PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bonny-Doon-ER"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15585 | 15585 | 15584 | {"type": "MultiPolygon", "coordinates": [[[[-117.35883, 33.16883], [-117.35702, 33.16883], [-117.35637, 33.16803], [-117.35519, 33.16665], [-117.35505, 33.1665], [-117.35484, 33.16617], [-117.35473, 33.16595], [-117.35465, 33.16576], [-117.35569, 33.16575], [-117.35883, 33.16883]]], [[[-117.35685, 33.16908], [-117.35649, 33.1693], [-117.35658, 33.16943], [-117.35603, 33.16993], [-117.35584, 33.17022], [-117.35549, 33.17059], [-117.35533, 33.1704], [-117.35532, 33.1704], [-117.35481, 33.1712], [-117.35462, 33.17153], [-117.35373, 33.17208], [-117.35412, 33.17254], [-117.3528, 33.17254], [-117.35281, 33.17304], [-117.35321, 33.17351], [-117.35315, 33.17356], [-117.35314, 33.17358], [-117.35315, 33.17372], [-117.35313, 33.17381], [-117.35308, 33.1739], [-117.35301, 33.17396], [-117.35299, 33.17398], [-117.35283, 33.1738], [-117.35282, 33.1738], [-117.35281, 33.17451], [-117.35282, 33.17479], [-117.35224, 33.17479], [-117.35221, 33.17502], [-117.35219, 33.17506], [-117.3522, 33.17516], [-117.35218, 33.17518], [-117.35215, 33.17519], [-117.35203, 33.17505], [-117.35181, 33.17489], [-117.35165, 33.17482], [-117.35147, 33.17477], [-117.35127, 33.17474], [-117.35113, 33.17474], [-117.35034, 33.17485], [-117.3491, 33.1732], [-117.3492, 33.17312], [-117.34928, 33.1729], [-117.34929, 33.17264], [-117.3492, 33.1716], [-117.34912, 33.17145], [-117.3493, 33.17157], [-117.34932, 33.17156], [-117.34922, 33.17029], [-117.34921, 33.17028], [-117.34909, 33.17033], [-117.34961, 33.16906], [-117.3496, 33.16905], [-117.34953, 33.16905], [-117.34961, 33.16887], [-117.35008, 33.16887], [-117.35008, 33.16866], [-117.35033, 33.16846], [-117.35054, 33.16815], [-117.35063, 33.16789], [-117.35091, 33.16769], [-117.35188, 33.16716], [-117.35209, 33.16685], [-117.35214, 33.16621], [-117.35224, 33.16605], [-117.35275, 33.16606], [-117.35275, 33.16562], [-117.35386, 33.16562], [-117.35412, 33.16587], [-117.35475, 33.16663], [-117.35685, 33.16908]]], [[[-117.34931, 33.17565], [-117.34938, 33.17633], [-117.34937, 33.17656], [-117.34932, 33.17682], [-117.34928, 33.17695], [-117.34913, 33.17726], [-117.34895, 33.1775], [-117.34867, 33.17783], [-117.34845, 33.17805], [-117.34809, 33.17836], [-117.34778, 33.17859], [-117.3475, 33.17878], [-117.34684, 33.17913], [-117.34648, 33.17928], [-117.3461, 33.17941], [-117.34592, 33.17951], [-117.34557, 33.17953], [-117.34551, 33.17975], [-117.34493, 33.18001], [-117.34438, 33.18021], [-117.3425, 33.18039], [-117.34219, 33.1804], [-117.342, 33.18037], [-117.34178, 33.18031], [-117.34053, 33.17993], [-117.34045, 33.1799], [-117.3404, 33.17985], [-117.34039, 33.17981], [-117.3441, 33.17982], [-117.34411, 33.17962], [-117.34329, 33.17971], [-117.34064, 33.17967], [-117.34089, 33.17916], [-117.34179, 33.17816], [-117.34266, 33.17696], [-117.34299, 33.17669], [-117.34416, 33.17637], [-117.34436, 33.17621], [-117.34436, 33.17613], [-117.34427, 33.17612], [-117.34487, 33.17539], [-117.34524, 33.17514], [-117.34539, 33.17496], [-117.34588, 33.17421], [-117.34608, 33.17397], [-117.34639, 33.17381], [-117.34703, 33.1737], [-117.34748, 33.17355], [-117.34778, 33.17342], [-117.34927, 33.17537], [-117.34931, 33.17565]]], [[[-117.34175, 33.18048], [-117.34079, 33.18057], [-117.34044, 33.18044], [-117.34045, 33.1802], [-117.34048, 33.18009], [-117.3405, 33.18009], [-117.34175, 33.18048]]], [[[-117.34442, 33.18042], [-117.34329, 33.18073], [-117.34143, 33.18078], [-117.34105, 33.18071], [-117.34442, 33.18037], [-117.34442, 33.18042]]]]} | Open Access 1 | 12165 | Buena Vista Lagoon Ecological Reserve | 32069 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bonny-Doon-ER | San Diego 4 | 204.652 | Buena Vista Lagoon ER | 1968 | State Conservation Area 8 | 2 |
15613 | 15613 | 15612 | {"type": "MultiPolygon", "coordinates": [[[[-122.14305, 37.0513], [-122.1395, 37.05131], [-122.13951, 37.05094], [-122.13918, 37.05095], [-122.13845, 37.05095], [-122.13849, 37.04938], [-122.14122, 37.04783], [-122.14181, 37.04782], [-122.142, 37.04782], [-122.14219, 37.04786], [-122.14303, 37.04807], [-122.14305, 37.0513]]], [[[-122.14737, 37.05355], [-122.14736, 37.05496], [-122.14731, 37.05497], [-122.14736, 37.05865], [-122.14292, 37.05868], [-122.14208, 37.0586], [-122.14173, 37.05865], [-122.14168, 37.05847], [-122.14358, 37.05766], [-122.14376, 37.0574], [-122.14375, 37.05692], [-122.14297, 37.0564], [-122.14213, 37.05611], [-122.14075, 37.05577], [-122.14042, 37.05535], [-122.13962, 37.05492], [-122.13926, 37.05463], [-122.13838, 37.05374], [-122.13839, 37.05356], [-122.14737, 37.05355]]], [[[-122.14514, 37.04505], [-122.14291, 37.04506], [-122.14289, 37.04598], [-122.14249, 37.04606], [-122.14251, 37.04781], [-122.14201, 37.0477], [-122.1418, 37.04769], [-122.14119, 37.04771], [-122.13867, 37.04913], [-122.1385, 37.04894], [-122.13414, 37.04897], [-122.13416, 37.05008], [-122.13659, 37.05007], [-122.13667, 37.04967], [-122.13831, 37.04966], [-122.13821, 37.05376], [-122.13838, 37.05391], [-122.13937, 37.05492], [-122.14032, 37.05542], [-122.14066, 37.05587], [-122.14207, 37.05621], [-122.14289, 37.05649], [-122.14362, 37.05697], [-122.14362, 37.05737], [-122.14347, 37.05758], [-122.14152, 37.05841], [-122.14159, 37.05867], [-122.14136, 37.05872], [-122.1416, 37.05873], [-122.14071, 37.05887], [-122.14027, 37.05884], [-122.13999, 37.05889], [-122.13983, 37.05899], [-122.13854, 37.05898], [-122.13839, 37.05898], [-122.13838, 37.05872], [-122.13412, 37.05871], [-122.13419, 37.05491], [-122.13417, 37.05311], [-122.1244, 37.05325], [-122.12416, 37.04584], [-122.13411, 37.04584], [-122.13408, 37.0403], [-122.1385, 37.04028], [-122.13858, 37.04417], [-122.14511, 37.04413], [-122.14514, 37.04505]], [[-122.13847, 37.05493], [-122.136, 37.05491], [-122.13604, 37.05624], [-122.13757, 37.05621], [-122.13757, 37.05587], [-122.13847, 37.05588], [-122.13847, 37.05493]]]]} | Open Access 1 | 18918 | Bonny Doon Ecological Reserve | 32063 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bonny-Doon-ER | Santa Cruz 5 | 541.854 | Bonny Doon ER | 1993 | State Conservation Area 8 | 2 |
15630 | 15630 | 15629 | {"type": "MultiPolygon", "coordinates": [[[[-117.29825, 33.18063], [-117.29783, 33.18065], [-117.29745, 33.18085], [-117.29671, 33.18085], [-117.29633, 33.18069], [-117.29628, 33.18071], [-117.29615, 33.18052], [-117.29582, 33.18016], [-117.296, 33.18021], [-117.29618, 33.18015], [-117.29673, 33.18013], [-117.29708, 33.18012], [-117.29735, 33.18019], [-117.29803, 33.18015], [-117.29821, 33.1803], [-117.29825, 33.18063]]], [[[-117.32453, 33.1813], [-117.32445, 33.18133], [-117.32406, 33.18139], [-117.32366, 33.18143], [-117.32325, 33.18144], [-117.32279, 33.1814], [-117.32279, 33.17941], [-117.32127, 33.17943], [-117.32114, 33.17934], [-117.32052, 33.17935], [-117.31931, 33.18085], [-117.31918, 33.18078], [-117.31912, 33.1807], [-117.31908, 33.18062], [-117.31901, 33.18056], [-117.31892, 33.18054], [-117.31882, 33.18054], [-117.31873, 33.18058], [-117.31867, 33.18064], [-117.31864, 33.18072], [-117.31865, 33.1808], [-117.31769, 33.18058], [-117.31591, 33.18023], [-117.31152, 33.17969], [-117.3096, 33.17886], [-117.30906, 33.17869], [-117.30833, 33.17929], [-117.30803, 33.17921], [-117.30767, 33.1795], [-117.30694, 33.17957], [-117.30658, 33.17964], [-117.30636, 33.17963], [-117.30615, 33.1784], [-117.30601, 33.17682], [-117.31251, 33.17639], [-117.31339, 33.17412], [-117.3213, 33.17835], [-117.32119, 33.1785], [-117.3212, 33.17851], [-117.32128, 33.17851], [-117.32146, 33.17848], [-117.32166, 33.17853], [-117.32174, 33.17859], [-117.32186, 33.17877], [-117.32184, 33.1788], [-117.32194, 33.17892], [-117.322, 33.17896], [-117.32205, 33.17893], [-117.32222, 33.17915], [-117.3223, 33.17929], [-117.32247, 33.17933], [-117.32288, 33.17935], [-117.32293, 33.17953], [-117.32293, 33.17962], [-117.32289, 33.17973], [-117.3229, 33.17976], [-117.32303, 33.17989], [-117.32314, 33.17994], [-117.32326, 33.17994], [-117.32355, 33.18005], [-117.32371, 33.18001], [-117.32378, 33.18003], [-117.32413, 33.1799], [-117.32443, 33.17988], [-117.32453, 33.1813]]], [[[-117.34436, 33.17612], [-117.34436, 33.17621], [-117.34416, 33.17637], [-117.34299, 33.17669], [-117.34266, 33.17696], [-117.34179, 33.17816], [-117.34089, 33.17916], [-117.34065, 33.17966], [-117.34066, 33.17967], [-117.34329, 33.17971], [-117.34412, 33.17962], [-117.3441, 33.17982], [-117.34043, 33.1798], [-117.34183, 33.1778], [-117.34194, 33.17772], [-117.34206, 33.17759], [-117.34289, 33.17656], [-117.34298, 33.17646], [-117.34324, 33.17627], [-117.34356, 33.17613], [-117.34366, 33.17612], [-117.34436, 33.17612]]]]} | Open Access 1 | 44430 | Buena Vista Creek Ecological Reserve | 32068 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bonny-Doon-ER | San Diego 4 | 150.217 | Buena Vista Creek ER | 2007 | State Conservation Area 8 | 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]);