superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Jack London SHP", MNG_AGENCY = 47 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency · 1 ✖
MNG_AGENCY 1
- California Department of Parks and Recreation · 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15197 | 15197 | 15196 | {"type": "Polygon", "coordinates": [[[-122.5738, 38.34345], [-122.57359, 38.35409], [-122.57349, 38.35789], [-122.56, 38.3579], [-122.56006, 38.35425], [-122.56457, 38.35417], [-122.56464, 38.35065], [-122.56046, 38.3507], [-122.5591, 38.35174], [-122.55832, 38.35244], [-122.55732, 38.35316], [-122.5569, 38.35276], [-122.55562, 38.35341], [-122.55508, 38.35371], [-122.55463, 38.35398], [-122.55459, 38.35417], [-122.55455, 38.35462], [-122.55441, 38.35495], [-122.55421, 38.35526], [-122.55208, 38.35689], [-122.55135, 38.35848], [-122.54927, 38.35797], [-122.54609, 38.35723], [-122.54577, 38.35871], [-122.54293, 38.35813], [-122.54367, 38.35768], [-122.54382, 38.35753], [-122.5439, 38.35735], [-122.54394, 38.35709], [-122.5439, 38.35666], [-122.54365, 38.35557], [-122.54346, 38.3556], [-122.54376, 38.35701], [-122.54376, 38.35723], [-122.5437, 38.3574], [-122.54364, 38.3575], [-122.54352, 38.3576], [-122.543, 38.35792], [-122.54267, 38.3581], [-122.54238, 38.3582], [-122.54216, 38.35823], [-122.54196, 38.35822], [-122.54172, 38.35817], [-122.54099, 38.35782], [-122.54063, 38.35772], [-122.54037, 38.3577], [-122.54014, 38.35773], [-122.54003, 38.35776], [-122.54005, 38.35758], [-122.54006, 38.35708], [-122.54014, 38.35611], [-122.54002, 38.35605], [-122.53992, 38.35786], [-122.53968, 38.35803], [-122.53891, 38.35878], [-122.53866, 38.35854], [-122.53938, 38.35763], [-122.53946, 38.35623], [-122.53723, 38.35566], [-122.53679, 38.35519], [-122.53688, 38.35499], [-122.5374, 38.355], [-122.53731, 38.35447], [-122.53675, 38.35426], [-122.53616, 38.35373], [-122.53648, 38.35341], [-122.5364, 38.35316], [-122.53699, 38.35288], [-122.53722, 38.35265], [-122.53585, 38.35082], [-122.53614, 38.3506], [-122.53721, 38.35047], [-122.53745, 38.35041], [-122.53844, 38.35141], [-122.53803, 38.3519], [-122.53759, 38.35328], [-122.54353, 38.3555], [-122.54354, 38.35548], [-122.54353, 38.35539], [-122.54355, 38.3553], [-122.54363, 38.35516], [-122.54427, 38.35455], [-122.54461, 38.35435], [-122.54584, 38.35516], [-122.54668, 38.35441], [-122.54702, 38.35442], [-122.54762, 38.35468], [-122.54787, 38.35493], [-122.54751, 38.35529], [-122.54817, 38.35614], [-122.54868, 38.35611], [-122.5498, 38.35595], [-122.55159, 38.35544], [-122.55192, 38.35527], [-122.55037, 38.35312], [-122.54983, 38.3525], [-122.54917, 38.35232], [-122.54912, 38.35213], [-122.54921, 38.35205], [-122.5491, 38.35179], [-122.5491, 38.35161], [-122.54912, 38.35152], [-122.54919, 38.35139], [-122.54932, 38.35131], [-122.54925, 38.35129], [-122.54937, 38.3512], [-122.54957, 38.35115], [-122.5497, 38.35104], [-122.54981, 38.35104], [-122.54994, 38.35088], [-122.55005, 38.35085], [-122.55028, 38.35067], [-122.55014, 38.35042], [-122.54926, 38.35009], [-122.54854, 38.35055], [-122.5477, 38.34935], [-122.54712, 38.34873], [-122.54653, 38.3482], [-122.54569, 38.34733], [-122.54519, 38.34736], [-122.54487, 38.34702], [-122.54448, 38.34729], [-122.54412, 38.34732], [-122.54365, 38.34757], [-122.54364, 38.34777], [-122.54349, 38.34789], [-122.5431, 38.34795], [-122.54261, 38.34782], [-122.54236, 38.34789], [-122.54234, 38.34801], [-122.54236, 38.34821], [-122.54244, 38.34836], [-122.54241, 38.34843], [-122.542, 38.34788], [-122.54003, 38.34754], [-122.53863, 38.34745], [-122.53759, 38.34729], [-122.53725, 38.34686], [-122.53611, 38.34616], [-122.53596, 38.34554], [-122.53638, 38.34508], [-122.53622, 38.34467], [-122.53551, 38.34465], [-122.53488, 38.34432], [-122.53432, 38.34407], [-122.53388, 38.34383], [-122.5334, 38.34346], [-122.53229, 38.34319], [-122.53173, 38.34259], [-122.53176, 38.34218], [-122.53209, 38.3415], [-122.53247, 38.34124], [-122.53322, 38.34112], [-122.53366, 38.34093], [-122.53406, 38.34067], [-122.53406, 38.34065], [-122.53319, 38.34015], [-122.53301, 38.34001], [-122.5328, 38.33975], [-122.5331, 38.33956], [-122.53371, 38.33914], [-122.534, 38.339], [-122.53486, 38.339], [-122.53517, 38.33909], [-122.53542, 38.3392], [-122.5362, 38.33944], [-122.53671, 38.33951], [-122.53699, 38.33936], [-122.53722, 38.33902], [-122.53712, 38.33823], [-122.53706, 38.33796], [-122.53888, 38.33734], [-122.5386, 38.33669], [-122.55288, 38.33176], [-122.55408, 38.33253], [-122.5573, 38.33967], [-122.56115, 38.33922], [-122.56392, 38.34121], [-122.56428, 38.34356], [-122.5738, 38.34345]], [[-122.54176, 38.33972], [-122.54111, 38.33935], [-122.54058, 38.33975], [-122.54044, 38.34001], [-122.53977, 38.33997], [-122.53944, 38.34095], [-122.54058, 38.34194], [-122.54143, 38.34173], [-122.54187, 38.3419], [-122.54211, 38.34093], [-122.5417, 38.34001], [-122.54246, 38.33991], [-122.5426, 38.33952], [-122.54176, 38.33972]]]} | Open Access 1 | Jack London State Historic Park | http://www.parks.ca.gov/default.asp?page_id=478 | 1578 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 1469.793 | Jack London SHP | 1959 |
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]);