superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2 and PARK_URL = "https://ucnrs.org/reserves/mclaughlin-natural-reserve/"
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11902 | 11902 | 11901 | {"type": "MultiPolygon", "coordinates": [[[[-122.41361, 38.86493], [-122.4059, 38.8649], [-122.40598, 38.86091], [-122.40128, 38.86083], [-122.40125, 38.86271], [-122.39731, 38.86263], [-122.39714, 38.86295], [-122.39704, 38.8611], [-122.39687, 38.85729], [-122.39454, 38.85725], [-122.39218, 38.85724], [-122.39215, 38.8538], [-122.39568, 38.85382], [-122.39686, 38.8538], [-122.39835, 38.85371], [-122.39876, 38.85408], [-122.39926, 38.85447], [-122.39956, 38.85456], [-122.39985, 38.85463], [-122.40005, 38.85475], [-122.40023, 38.85493], [-122.40058, 38.85545], [-122.40104, 38.85604], [-122.40121, 38.85615], [-122.40151, 38.85641], [-122.40303, 38.85665], [-122.4032, 38.85648], [-122.40351, 38.85657], [-122.40679, 38.85797], [-122.40702, 38.85812], [-122.40943, 38.85996], [-122.40964, 38.86008], [-122.41038, 38.86041], [-122.41066, 38.8606], [-122.4109, 38.86083], [-122.4109, 38.86097], [-122.411, 38.86098], [-122.41104, 38.86105], [-122.41215, 38.86347], [-122.41234, 38.86382], [-122.4126, 38.86414], [-122.4128, 38.86433], [-122.41303, 38.86451], [-122.41361, 38.86493]], [[-122.39929, 38.85639], [-122.39688, 38.85633], [-122.39687, 38.85727], [-122.39928, 38.85729], [-122.39929, 38.85639]]], [[[-122.39926, 38.85396], [-122.39926, 38.85396], [-122.39886, 38.85369], [-122.39924, 38.85364], [-122.39926, 38.85396]]], [[[-122.41094, 38.85388], [-122.4109, 38.86064], [-122.41064, 38.86043], [-122.41045, 38.86031], [-122.40971, 38.85998], [-122.40952, 38.85988], [-122.40712, 38.85804], [-122.40688, 38.85789], [-122.40358, 38.85648], [-122.40329, 38.85638], [-122.40383, 38.85582], [-122.40383, 38.8558], [-122.40339, 38.85564], [-122.40303, 38.85564], [-122.40277, 38.85567], [-122.40247, 38.85568], [-122.402, 38.85586], [-122.40174, 38.85591], [-122.4014, 38.85577], [-122.40121, 38.85547], [-122.40099, 38.85506], [-122.40085, 38.85472], [-122.40053, 38.85448], [-122.40009, 38.85431], [-122.39986, 38.85425], [-122.39967, 38.85404], [-122.39955, 38.85379], [-122.41094, 38.85388]]], [[[-122.44673, 38.8798], [-122.44347, 38.87981], [-122.44345, 38.87995], [-122.44277, 38.87981], [-122.43966, 38.8804], [-122.43894, 38.88033], [-122.43696, 38.87922], [-122.43486, 38.87902], [-122.43409, 38.87868], [-122.43283, 38.8773], [-122.43267, 38.87716], [-122.43248, 38.87704], [-122.43216, 38.8769], [-122.43193, 38.87684], [-122.4317, 38.8768], [-122.43146, 38.87678], [-122.43125, 38.87679], [-122.43105, 38.87682], [-122.42927, 38.87726], [-122.42901, 38.87732], [-122.4288, 38.87734], [-122.42857, 38.87735], [-122.42823, 38.87731], [-122.42801, 38.87725], [-122.42771, 38.87711], [-122.4265, 38.87633], [-122.42616, 38.87617], [-122.42316, 38.87531], [-122.42289, 38.87522], [-122.42264, 38.8751], [-122.42241, 38.87497], [-122.42222, 38.87482], [-122.42204, 38.87465], [-122.42183, 38.87437], [-122.42173, 38.87417], [-122.42109, 38.87254], [-122.42092, 38.87226], [-122.42069, 38.872], [-122.4204, 38.87177], [-122.42006, 38.87159], [-122.41823, 38.87085], [-122.41796, 38.87073], [-122.41771, 38.87058], [-122.41748, 38.87042], [-122.41728, 38.87024], [-122.4171, 38.87004], [-122.41688, 38.86972], [-122.41623, 38.86846], [-122.41606, 38.86816], [-122.41431, 38.86544], [-122.4141, 38.86519], [-122.41381, 38.86493], [-122.41291, 38.86426], [-122.41262, 38.86397], [-122.41247, 38.86376], [-122.41228, 38.86343], [-122.41116, 38.86099], [-122.41548, 38.86112], [-122.41551, 38.85757], [-122.42008, 38.85771], [-122.42945, 38.85792], [-122.42944, 38.87069], [-122.43174, 38.87069], [-122.4321, 38.87105], [-122.43243, 38.87134], [-122.43274, 38.87195], [-122.43308, 38.87236], [-122.4334, 38.87257], [-122.43375, 38.87276], [-122.43413, 38.87264], [-122.43498, 38.87277], [-122.4339, 38.87337], [-122.4331, 38.87389], [-122.4331, 38.87391], [-122.43337, 38.87416], [-122.43348, 38.87422], [-122.43351, 38.8744], [-122.43748, 38.87427], [-122.43935, 38.87519], [-122.44673, 38.8798]]], [[[-122.42422, 38.87573], [-122.42408, 38.87585], [-122.41522, 38.87548], [-122.41522, 38.87045], [-122.4174, 38.87051], [-122.41776, 38.87075], [-122.41802, 38.87089], [-122.42, 38.87169], [-122.42023, 38.87181], [-122.42044, 38.87195], [-122.42062, 38.87211], [-122.42078, 38.87229], [-122.42091, 38.87247], [-122.421, 38.87268], [-122.4216, 38.87421], [-122.42178, 38.87453], [-122.42203, 38.87482], [-122.42235, 38.87507], [-122.42259, 38.87521], [-122.42284, 38.87532], [-122.42311, 38.87541], [-122.42422, 38.87573]]]]} | Restricted Access 2 | McLaughlin Natural Reserve | https://ucnrs.org/reserves/mclaughlin-natural-reserve/ | 33195 | 217 | University of California 51 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 1138.159 | McLaughlin Natural Reserve |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);