units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LAYER = 9 and SUID_NMA = 1473
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
DES_TP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16580 | 16580 | 16579 | {"type": "Polygon", "coordinates": [[[-121.20233, 37.69646], [-121.20125, 37.69682], [-121.20085, 37.69701], [-121.19977, 37.69724], [-121.19873, 37.69714], [-121.19745, 37.69721], [-121.19677, 37.69703], [-121.19421, 37.69603], [-121.19372, 37.69607], [-121.19235, 37.69561], [-121.19146, 37.69569], [-121.18947, 37.6937], [-121.18434, 37.69448], [-121.18435, 37.69615], [-121.18448, 37.69842], [-121.18354, 37.69994], [-121.18248, 37.70086], [-121.18249, 37.70097], [-121.18216, 37.70199], [-121.18198, 37.70236], [-121.18187, 37.70277], [-121.18193, 37.70288], [-121.1819, 37.70298], [-121.18208, 37.70313], [-121.1818, 37.70313], [-121.1816, 37.70297], [-121.18179, 37.70232], [-121.18196, 37.70194], [-121.18228, 37.70096], [-121.18224, 37.70033], [-121.18066, 37.70053], [-121.18057, 37.70104], [-121.17881, 37.70189], [-121.17863, 37.70191], [-121.17837, 37.702], [-121.17818, 37.70211], [-121.17793, 37.70232], [-121.17774, 37.70244], [-121.17753, 37.70253], [-121.17736, 37.70259], [-121.17725, 37.70259], [-121.17705, 37.70251], [-121.17696, 37.70237], [-121.17701, 37.70221], [-121.17712, 37.70203], [-121.1772, 37.70183], [-121.17717, 37.70167], [-121.17704, 37.70151], [-121.17656, 37.7012], [-121.1765, 37.70115], [-121.17648, 37.7007], [-121.1763, 37.69986], [-121.17629, 37.69961], [-121.17631, 37.69946], [-121.17635, 37.69931], [-121.17638, 37.69924], [-121.17658, 37.69906], [-121.1767, 37.69898], [-121.17697, 37.69888], [-121.17711, 37.69885], [-121.17727, 37.69884], [-121.17751, 37.69885], [-121.17786, 37.69888], [-121.17831, 37.69896], [-121.17888, 37.69897], [-121.17913, 37.6989], [-121.17943, 37.69888], [-121.17955, 37.69881], [-121.17964, 37.69878], [-121.17976, 37.69878], [-121.18005, 37.69882], [-121.18061, 37.69887], [-121.18084, 37.69895], [-121.18099, 37.69902], [-121.18114, 37.69907], [-121.18132, 37.6991], [-121.18158, 37.69911], [-121.18177, 37.69908], [-121.18176, 37.69904], [-121.18217, 37.6989], [-121.18249, 37.69862], [-121.18263, 37.69825], [-121.18278, 37.69747], [-121.18276, 37.69722], [-121.1826, 37.69688], [-121.18233, 37.69662], [-121.18202, 37.69637], [-121.18173, 37.69622], [-121.18103, 37.69606], [-121.18067, 37.696], [-121.18043, 37.69592], [-121.18027, 37.69569], [-121.18025, 37.69542], [-121.18036, 37.69509], [-121.18051, 37.69476], [-121.18046, 37.69445], [-121.18043, 37.69397], [-121.18049, 37.69367], [-121.18074, 37.69342], [-121.18107, 37.69341], [-121.18176, 37.69368], [-121.18226, 37.69377], [-121.18273, 37.69366], [-121.18326, 37.69344], [-121.18355, 37.6933], [-121.18395, 37.69305], [-121.18408, 37.69267], [-121.18405, 37.69243], [-121.18354, 37.6921], [-121.18325, 37.69189], [-121.18275, 37.69167], [-121.1824, 37.69165], [-121.182, 37.69176], [-121.18151, 37.69195], [-121.1812, 37.69223], [-121.18093, 37.69259], [-121.18078, 37.69292], [-121.18042, 37.69316], [-121.18007, 37.69316], [-121.17964, 37.69305], [-121.17937, 37.69282], [-121.1791, 37.69249], [-121.17887, 37.69205], [-121.17879, 37.69169], [-121.17884, 37.69137], [-121.17894, 37.69116], [-121.17916, 37.6909], [-121.17946, 37.69062], [-121.17992, 37.69043], [-121.18026, 37.69035], [-121.18054, 37.69044], [-121.18105, 37.69049], [-121.18131, 37.69046], [-121.18228, 37.6904], [-121.18257, 37.69036], [-121.18283, 37.69016], [-121.18289, 37.68997], [-121.18292, 37.68977], [-121.18276, 37.68958], [-121.18238, 37.68948], [-121.18202, 37.6894], [-121.18175, 37.68926], [-121.18153, 37.68905], [-121.18115, 37.68851], [-121.18098, 37.68824], [-121.18094, 37.68798], [-121.18112, 37.68784], [-121.18158, 37.68774], [-121.18213, 37.6877], [-121.18252, 37.68771], [-121.18285, 37.68777], [-121.18333, 37.68798], [-121.18384, 37.68806], [-121.1852, 37.68887], [-121.18556, 37.68885], [-121.18576, 37.68869], [-121.18598, 37.68843], [-121.18619, 37.68804], [-121.18622, 37.68779], [-121.18644, 37.68756], [-121.18668, 37.68743], [-121.18707, 37.68744], [-121.18743, 37.6876], [-121.18772, 37.68784], [-121.18791, 37.68808], [-121.18799, 37.68846], [-121.18798, 37.68885], [-121.1878, 37.68905], [-121.1876, 37.68923], [-121.18747, 37.68949], [-121.18747, 37.68969], [-121.18771, 37.68996], [-121.18802, 37.69008], [-121.18835, 37.69009], [-121.18865, 37.68997], [-121.1889, 37.68974], [-121.18911, 37.68951], [-121.18951, 37.68921], [-121.18968, 37.68927], [-121.18986, 37.68952], [-121.18984, 37.68967], [-121.18909, 37.69075], [-121.18898, 37.69107], [-121.18895, 37.69122], [-121.18895, 37.69138], [-121.18904, 37.69162], [-121.18915, 37.69175], [-121.18936, 37.69189], [-121.18962, 37.69199], [-121.18994, 37.69203], [-121.19023, 37.6919], [-121.19045, 37.69159], [-121.19053, 37.6911], [-121.19057, 37.69103], [-121.19069, 37.6909], [-121.19091, 37.69076], [-121.19115, 37.69052], [-121.19127, 37.69031], [-121.1915, 37.69021], [-121.19182, 37.69026], [-121.19198, 37.69045], [-121.19205, 37.69085], [-121.19201, 37.69117], [-121.1921, 37.69163], [-121.19227, 37.69212], [-121.19249, 37.6925], [-121.19287, 37.69273], [-121.19328, 37.69302], [-121.19359, 37.69347], [-121.19371, 37.69378], [-121.19363, 37.69414], [-121.19363, 37.69419], [-121.19374, 37.69456], [-121.19414, 37.69476], [-121.1944, 37.69478], [-121.19473, 37.69477], [-121.19502, 37.69484], [-121.1955, 37.69484], [-121.19602, 37.69478], [-121.19628, 37.69462], [-121.19666, 37.69425], [-121.19679, 37.69392], [-121.19674, 37.69367], [-121.19645, 37.69323], [-121.1964, 37.69287], [-121.19646, 37.69253], [-121.19678, 37.69231], [-121.19744, 37.69201], [-121.19761, 37.69163], [-121.19759, 37.69125], [-121.19761, 37.69088], [-121.19776, 37.69062], [-121.19794, 37.69039], [-121.19829, 37.69021], [-121.19881, 37.69014], [-121.19927, 37.69012], [-121.19954, 37.69024], [-121.19986, 37.69055], [-121.20024, 37.69107], [-121.20048, 37.69148], [-121.20078, 37.69172], [-121.20105, 37.692], [-121.20126, 37.69251], [-121.20133, 37.69307], [-121.20099, 37.69347], [-121.2003, 37.69387], [-121.20023, 37.69394], [-121.19989, 37.69399], [-121.19964, 37.6941], [-121.19938, 37.69444], [-121.1992, 37.69477], [-121.19914, 37.69512], [-121.19919, 37.69558], [-121.19939, 37.69593], [-121.19968, 37.69606], [-121.20013, 37.69595], [-121.20042, 37.6958], [-121.20088, 37.69576], [-121.20102, 37.69578], [-121.20118, 37.69578], [-121.20162, 37.696], [-121.20208, 37.69604], [-121.20233, 37.69646]]]} | Open Access 1 | 17371 | Caswell Memorial State Park | 1473 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=557 | San Joaquin 39 | 294.134 | Caswell Memorial SP | 1952 | State Park 15 | 4 |
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]);