superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and PARK_URL = "http://www.parks.ca.gov/?page_id=445"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15141 | 15141 | 15140 | {"type": "MultiPolygon", "coordinates": [[[[-123.82042, 39.3656], [-123.81449, 39.36459], [-123.8143, 39.36357], [-123.81498, 39.36349], [-123.81489, 39.36304], [-123.8142, 39.36312], [-123.81418, 39.36306], [-123.8135, 39.36293], [-123.81305, 39.36291], [-123.81265, 39.36295], [-123.80922, 39.36296], [-123.80921, 39.36325], [-123.80899, 39.3633], [-123.80886, 39.36295], [-123.80875, 39.36258], [-123.80867, 39.36222], [-123.80861, 39.36167], [-123.80861, 39.36148], [-123.80874, 39.36073], [-123.80868, 39.36046], [-123.80874, 39.35826], [-123.80933, 39.35838], [-123.80953, 39.35836], [-123.81038, 39.35899], [-123.81054, 39.3596], [-123.81134, 39.3609], [-123.81169, 39.36109], [-123.81261, 39.36109], [-123.81301, 39.3608], [-123.81317, 39.36075], [-123.81338, 39.3606], [-123.81352, 39.36053], [-123.81368, 39.36049], [-123.81411, 39.3604], [-123.81445, 39.36036], [-123.81479, 39.36038], [-123.81502, 39.36041], [-123.81515, 39.36046], [-123.81535, 39.3606], [-123.81563, 39.36085], [-123.81575, 39.36092], [-123.81589, 39.36097], [-123.8161, 39.361], [-123.81623, 39.36099], [-123.81635, 39.36095], [-123.81649, 39.36084], [-123.81656, 39.36075], [-123.8166, 39.36056], [-123.81658, 39.36042], [-123.81652, 39.36023], [-123.81643, 39.36002], [-123.81612, 39.35945], [-123.8161, 39.35937], [-123.81612, 39.35926], [-123.816, 39.35923], [-123.81604, 39.35908], [-123.81612, 39.35895], [-123.81623, 39.35887], [-123.81637, 39.35882], [-123.81648, 39.35881], [-123.81661, 39.35882], [-123.81684, 39.35889], [-123.81699, 39.35898], [-123.8172, 39.3592], [-123.81742, 39.35935], [-123.81764, 39.35944], [-123.81778, 39.35944], [-123.81825, 39.35968], [-123.81821, 39.35973], [-123.81814, 39.35993], [-123.81814, 39.36014], [-123.81808, 39.36009], [-123.81799, 39.36009], [-123.81784, 39.36012], [-123.81764, 39.36026], [-123.81718, 39.36062], [-123.8168, 39.36112], [-123.81668, 39.36136], [-123.81665, 39.36156], [-123.8168, 39.36173], [-123.81688, 39.36177], [-123.81679, 39.3618], [-123.81661, 39.36179], [-123.8165, 39.36181], [-123.81649, 39.36182], [-123.81653, 39.36184], [-123.81667, 39.36184], [-123.81698, 39.36189], [-123.8172, 39.36197], [-123.81753, 39.36205], [-123.81792, 39.36209], [-123.81804, 39.36214], [-123.81814, 39.36222], [-123.81823, 39.36233], [-123.81857, 39.36258], [-123.81875, 39.36266], [-123.81901, 39.36291], [-123.81911, 39.36306], [-123.81936, 39.36367], [-123.81934, 39.36386], [-123.81914, 39.36382], [-123.81912, 39.36388], [-123.81922, 39.36404], [-123.81932, 39.36407], [-123.81941, 39.36406], [-123.81943, 39.36398], [-123.81951, 39.36388], [-123.81957, 39.36388], [-123.81968, 39.36391], [-123.81988, 39.36402], [-123.82003, 39.3642], [-123.82014, 39.3644], [-123.82014, 39.36449], [-123.82007, 39.36452], [-123.81988, 39.36447], [-123.81977, 39.36442], [-123.81969, 39.36441], [-123.81965, 39.36443], [-123.81963, 39.36452], [-123.8197, 39.36472], [-123.81977, 39.36486], [-123.81979, 39.36509], [-123.81984, 39.36512], [-123.81991, 39.36505], [-123.82009, 39.36499], [-123.82015, 39.36502], [-123.82029, 39.36502], [-123.82038, 39.36506], [-123.82041, 39.36514], [-123.82036, 39.36541], [-123.82026, 39.36551], [-123.82028, 39.36555], [-123.82042, 39.36557], [-123.82042, 39.3656]]], [[[-123.81368, 39.35413], [-123.81245, 39.35415], [-123.81234, 39.3567], [-123.81251, 39.3576], [-123.81213, 39.35749], [-123.8118, 39.35746], [-123.81131, 39.35748], [-123.8108, 39.35736], [-123.8107, 39.35736], [-123.81044, 39.35749], [-123.81004, 39.35756], [-123.81003, 39.35758], [-123.80924, 39.35716], [-123.80895, 39.35715], [-123.80897, 39.35543], [-123.80929, 39.35561], [-123.81078, 39.35561], [-123.8108, 39.35557], [-123.81115, 39.35557], [-123.81117, 39.35561], [-123.81184, 39.35561], [-123.81186, 39.35405], [-123.81362, 39.35405], [-123.81368, 39.35413]]], [[[-123.81603, 39.35971], [-123.81625, 39.3601], [-123.81638, 39.36044], [-123.81638, 39.36056], [-123.81635, 39.3607], [-123.81631, 39.36076], [-123.8162, 39.36082], [-123.81611, 39.36084], [-123.81602, 39.36083], [-123.81584, 39.36077], [-123.81574, 39.3607], [-123.81541, 39.36041], [-123.81522, 39.3603], [-123.81495, 39.36023], [-123.81457, 39.3602], [-123.81418, 39.36022], [-123.81354, 39.36035], [-123.8133, 39.36044], [-123.81294, 39.36067], [-123.81238, 39.36086], [-123.81182, 39.36083], [-123.81151, 39.36065], [-123.81067, 39.35927], [-123.81053, 39.3587], [-123.81078, 39.35854], [-123.8109, 39.35854], [-123.81098, 39.35857], [-123.81179, 39.35934], [-123.81239, 39.35957], [-123.81226, 39.35978], [-123.81227, 39.3598], [-123.81295, 39.36004], [-123.81316, 39.35967], [-123.81247, 39.35942], [-123.81197, 39.35922], [-123.81177, 39.3591], [-123.81114, 39.3585], [-123.811, 39.35842], [-123.81089, 39.3584], [-123.81078, 39.3584], [-123.81033, 39.35853], [-123.80954, 39.35814], [-123.81001, 39.35786], [-123.8108, 39.35781], [-123.81094, 39.35778], [-123.81271, 39.35827], [-123.81284, 39.35838], [-123.81304, 39.35883], [-123.81347, 39.35899], [-123.81422, 39.35917], [-123.81467, 39.35919], [-123.81545, 39.35969], [-123.816, 39.3598], [-123.81603, 39.35971]]]]} | Open Access 1 | Caspar Headlands State Beach | http://www.parks.ca.gov/?page_id=445 | 1467 | 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 | 126.687 | Caspar Headlands SB | 1972 |
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]);