superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LAYER = 9, MNG_AGENCY = 47 and PARK_NAME = "Silverwood Lake State Recreation Area"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15299 | 15299 | 15298 | {"type": "Polygon", "coordinates": [[[-117.3698, 34.28046], [-117.36975, 34.28951], [-117.3621, 34.28957], [-117.35116, 34.28962], [-117.35005, 34.28961], [-117.35001, 34.29052], [-117.34905, 34.2905], [-117.34899, 34.29146], [-117.34275, 34.29147], [-117.34278, 34.2939], [-117.34278, 34.29659], [-117.33719, 34.2966], [-117.33727, 34.30381], [-117.33731, 34.30383], [-117.33957, 34.30387], [-117.3396, 34.30571], [-117.33962, 34.30574], [-117.32543, 34.30576], [-117.32542, 34.30356], [-117.3254, 34.30355], [-117.32516, 34.30373], [-117.32481, 34.30356], [-117.32421, 34.30402], [-117.3237, 34.30376], [-117.32311, 34.30317], [-117.32217, 34.30299], [-117.32185, 34.30308], [-117.32146, 34.30304], [-117.32105, 34.30317], [-117.31996, 34.30369], [-117.31936, 34.30428], [-117.31911, 34.30422], [-117.31873, 34.30439], [-117.31818, 34.3044], [-117.31753, 34.30473], [-117.31673, 34.30519], [-117.31608, 34.30526], [-117.31563, 34.30498], [-117.31508, 34.30475], [-117.31433, 34.30452], [-117.31356, 34.30417], [-117.31204, 34.30384], [-117.3112, 34.30416], [-117.31119, 34.30513], [-117.31126, 34.30765], [-117.30681, 34.30772], [-117.30678, 34.30409], [-117.29814, 34.30412], [-117.29807, 34.29663], [-117.30346, 34.29678], [-117.30351, 34.29407], [-117.31649, 34.2941], [-117.31647, 34.28782], [-117.3208, 34.28787], [-117.32081, 34.28051], [-117.31871, 34.28048], [-117.31866, 34.27943], [-117.31867, 34.27875], [-117.31864, 34.27873], [-117.31862, 34.2787], [-117.31209, 34.27871], [-117.31213, 34.2768], [-117.30341, 34.27672], [-117.30336, 34.27501], [-117.29264, 34.27499], [-117.29263, 34.27304], [-117.2905, 34.27304], [-117.29055, 34.26962], [-117.29478, 34.26965], [-117.29472, 34.27034], [-117.29492, 34.27036], [-117.29492, 34.27049], [-117.29694, 34.27058], [-117.29699, 34.27149], [-117.31208, 34.2715], [-117.31207, 34.27236], [-117.31211, 34.27241], [-117.31463, 34.27244], [-117.31641, 34.27244], [-117.3164, 34.27315], [-117.31643, 34.27317], [-117.31644, 34.27341], [-117.3185, 34.27341], [-117.31849, 34.2741], [-117.3276, 34.27427], [-117.32762, 34.27515], [-117.32953, 34.2752], [-117.32954, 34.27593], [-117.32954, 34.27677], [-117.32829, 34.27679], [-117.32828, 34.27858], [-117.32829, 34.27961], [-117.32838, 34.27974], [-117.32911, 34.28019], [-117.33125, 34.28039], [-117.33125, 34.28038], [-117.33118, 34.28022], [-117.33119, 34.2799], [-117.33128, 34.27972], [-117.33156, 34.27937], [-117.3316, 34.27924], [-117.33151, 34.2792], [-117.33127, 34.27926], [-117.33108, 34.27927], [-117.33101, 34.27918], [-117.33086, 34.27883], [-117.33385, 34.27888], [-117.33387, 34.27857], [-117.33486, 34.27858], [-117.33493, 34.2761], [-117.33531, 34.27612], [-117.33588, 34.2762], [-117.33718, 34.2765], [-117.33755, 34.27661], [-117.33835, 34.2768], [-117.33934, 34.27708], [-117.3424, 34.27781], [-117.34271, 34.27791], [-117.34466, 34.27843], [-117.34515, 34.27859], [-117.3456, 34.27878], [-117.34664, 34.2793], [-117.34701, 34.27954], [-117.34819, 34.27964], [-117.34815, 34.28066], [-117.34852, 34.28107], [-117.34919, 34.28176], [-117.34962, 34.28214], [-117.34985, 34.28226], [-117.35047, 34.2825], [-117.35114, 34.28271], [-117.35209, 34.28298], [-117.35239, 34.28308], [-117.35364, 34.2834], [-117.35393, 34.28345], [-117.35452, 34.28363], [-117.35493, 34.28381], [-117.35527, 34.28402], [-117.35547, 34.28411], [-117.35559, 34.28418], [-117.3556, 34.28417], [-117.35562, 34.2805], [-117.36437, 34.28041], [-117.36867, 34.28043], [-117.3698, 34.28046]]]} | Open Access 1 | Silverwood Lake State Recreation Area | http://www.parks.ca.gov/?page_id=650 | 1838 | 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 | 3129.391 | Silverwood Lake SRA | 1978 |
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]);