units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where COUNTY = 4 and YR_EST = 2007
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 2
DES_TP 2
ACCESS_TYP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14636 | 14636 | 14635 | {"type": "MultiPolygon", "coordinates": [[[[-117.25819, 33.13745], [-117.25858, 33.13781], [-117.25859, 33.13785], [-117.25859, 33.13788], [-117.25856, 33.13792], [-117.25826, 33.13803], [-117.25778, 33.13817], [-117.25578, 33.13853], [-117.2555, 33.13856], [-117.25509, 33.13854], [-117.25435, 33.1384], [-117.25396, 33.13837], [-117.25147, 33.13844], [-117.25109, 33.13848], [-117.25085, 33.13853], [-117.25058, 33.13862], [-117.25, 33.1389], [-117.24976, 33.13899], [-117.24955, 33.13905], [-117.24879, 33.13919], [-117.24842, 33.1393], [-117.24805, 33.13948], [-117.24745, 33.13987], [-117.24712, 33.14001], [-117.24677, 33.14011], [-117.24635, 33.14015], [-117.24589, 33.13338], [-117.24693, 33.13467], [-117.24867, 33.1356], [-117.24982, 33.13599], [-117.25209, 33.13589], [-117.25234, 33.13565], [-117.25248, 33.13269], [-117.25261, 33.13298], [-117.25278, 33.13326], [-117.253, 33.13351], [-117.25348, 33.134], [-117.25456, 33.13548], [-117.2547, 33.13565], [-117.25487, 33.13581], [-117.2552, 33.13604], [-117.25559, 33.13623], [-117.25591, 33.13632], [-117.25674, 33.13648], [-117.25695, 33.13654], [-117.2572, 33.13664], [-117.2574, 33.13676], [-117.25736, 33.13684], [-117.25745, 33.13712], [-117.25754, 33.13725], [-117.25765, 33.13735], [-117.25782, 33.13745], [-117.25811, 33.13751], [-117.25819, 33.13745]]], [[[-117.26726, 33.13981], [-117.26721, 33.14096], [-117.26718, 33.14217], [-117.26266, 33.14528], [-117.26179, 33.1458], [-117.24672, 33.1458], [-117.24663, 33.1439], [-117.24743, 33.14452], [-117.24845, 33.14495], [-117.249, 33.14504], [-117.25026, 33.14502], [-117.2506, 33.14498], [-117.25517, 33.14497], [-117.25613, 33.14421], [-117.25627, 33.1439], [-117.25644, 33.14391], [-117.25674, 33.14366], [-117.2572, 33.14348], [-117.25734, 33.14345], [-117.2575, 33.14347], [-117.25804, 33.14364], [-117.25818, 33.14365], [-117.25842, 33.14362], [-117.25862, 33.14365], [-117.25877, 33.14371], [-117.25919, 33.14399], [-117.25975, 33.14407], [-117.25995, 33.14397], [-117.26031, 33.14352], [-117.26033, 33.14337], [-117.26018, 33.14303], [-117.25985, 33.14274], [-117.25983, 33.14199], [-117.25976, 33.1418], [-117.25964, 33.14163], [-117.25948, 33.1415], [-117.25927, 33.14139], [-117.25904, 33.14132], [-117.25883, 33.14129], [-117.25815, 33.14129], [-117.25746, 33.14138], [-117.25664, 33.14144], [-117.25649, 33.14025], [-117.25649, 33.13984], [-117.25644, 33.1397], [-117.25635, 33.13959], [-117.25622, 33.13951], [-117.2561, 33.13948], [-117.25594, 33.13947], [-117.25549, 33.13959], [-117.25529, 33.13978], [-117.25514, 33.13918], [-117.25515, 33.13884], [-117.25517, 33.13881], [-117.25521, 33.13879], [-117.25546, 33.13879], [-117.25579, 33.13877], [-117.25778, 33.13841], [-117.25809, 33.13833], [-117.25839, 33.13824], [-117.25885, 33.13805], [-117.25893, 33.13806], [-117.25907, 33.13819], [-117.25911, 33.1383], [-117.25967, 33.13853], [-117.25983, 33.13864], [-117.25993, 33.13867], [-117.26004, 33.13867], [-117.26035, 33.13858], [-117.26092, 33.13836], [-117.26121, 33.13835], [-117.26111, 33.13681], [-117.26114, 33.13681], [-117.26177, 33.13645], [-117.26199, 33.13641], [-117.26207, 33.13625], [-117.2623, 33.1361], [-117.26246, 33.13602], [-117.26265, 33.13601], [-117.26283, 33.13581], [-117.26331, 33.13562], [-117.26352, 33.1356], [-117.26378, 33.13575], [-117.26491, 33.13572], [-117.26567, 33.13603], [-117.26438, 33.138], [-117.26571, 33.13987], [-117.26726, 33.13981]]], [[[-117.26107, 33.13612], [-117.26089, 33.1361], [-117.26047, 33.1362], [-117.25916, 33.13639], [-117.25858, 33.1364], [-117.25739, 33.1363], [-117.25727, 33.1363], [-117.25721, 33.13639], [-117.25681, 33.13625], [-117.25598, 33.1361], [-117.2556, 33.13597], [-117.2554, 33.13588], [-117.25518, 33.13574], [-117.25502, 33.1356], [-117.25484, 33.13542], [-117.25371, 33.13386], [-117.25321, 33.13336], [-117.25301, 33.13312], [-117.25287, 33.1329], [-117.25274, 33.13262], [-117.25327, 33.13291], [-117.25402, 33.13366], [-117.255, 33.13445], [-117.25599, 33.13519], [-117.25749, 33.13536], [-117.25908, 33.13548], [-117.25998, 33.13548], [-117.26099, 33.13502], [-117.26107, 33.13612]]], [[[-117.2677, 33.13206], [-117.26703, 33.13277], [-117.267, 33.13362], [-117.26742, 33.134], [-117.26607, 33.13473], [-117.26507, 33.13531], [-117.26491, 33.13536], [-117.2648, 33.13529], [-117.26466, 33.1351], [-117.26468, 33.13502], [-117.26494, 33.1348], [-117.26499, 33.13464], [-117.26511, 33.13451], [-117.26537, 33.13411], [-117.2657, 33.13382], [-117.26577, 33.13364], [-117.26602, 33.13248], [-117.26628, 33.13169], [-117.26646, 33.13148], [-117.2677, 33.13206]]]]} | Open Access 1 | 44868 | Carlsbad Oaks North Preserve | 28253 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/portfolio_page/carlsbad-oaks/ | San Diego 4 | 331.194 | Carlsbad Oaks North Preserve | 2007 | Private Conservation 16 | 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]);