superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where AGNCY_WEB = "http://www.wcb.ca.gov/" and MNG_AG_LEV = 5
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_NAME
ACCESS_TYP 3
MNG_AG_TYP 1
MNG_AGENCY 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3054 | 3054 | 3053 | {"type": "Polygon", "coordinates": [[[-116.31868, 33.79469], [-116.31429, 33.79469], [-116.31426, 33.79104], [-116.31864, 33.79105], [-116.31868, 33.79469]]]} | Open Access 1 | Coachella Valley Preserve - WCB | 17455 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 40.561 | Coachella Valley Preserve - WCB | ||
3529 | 3529 | 3528 | {"type": "Polygon", "coordinates": [[[-124.18903, 40.79066], [-124.18902, 40.79082], [-124.18514, 40.7908], [-124.1852, 40.79064], [-124.18903, 40.79066]]]} | No Public Access 3 | Del Norte Street Pier | 18042 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 1.467 | Del Norte Street Pier | ||
7830 | 7830 | 7829 | {"type": "Polygon", "coordinates": [[[-122.38409, 37.66344], [-122.38388, 37.66372], [-122.38364, 37.66373], [-122.38343, 37.66386], [-122.38284, 37.66322], [-122.38239, 37.66304], [-122.38262, 37.6625], [-122.38292, 37.66223], [-122.38313, 37.66237], [-122.38329, 37.66223], [-122.38382, 37.66262], [-122.38391, 37.66314], [-122.38409, 37.66344]]]} | Open Access 1 | Oyster Point Park | 23284 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 3.878 | Oyster Point Park | ||
8516 | 8516 | 8515 | {"type": "Polygon", "coordinates": [[[-120.1217, 34.50899], [-120.1215, 34.51982], [-120.12123, 34.53056], [-120.11243, 34.53048], [-120.11238, 34.5342], [-120.10805, 34.53417], [-120.108, 34.53778], [-120.10865, 34.5378], [-120.09496, 34.53782], [-120.095, 34.53397], [-120.09499, 34.53395], [-120.09504, 34.53037], [-120.09508, 34.52981], [-120.09469, 34.52938], [-120.0943, 34.529], [-120.09418, 34.52877], [-120.09451, 34.52685], [-120.09508, 34.52677], [-120.09515, 34.52404], [-120.09518, 34.52331], [-120.09512, 34.51591], [-120.1129, 34.516], [-120.11298, 34.50877], [-120.1217, 34.50899]]]} | No Public Access 3 | Rancho Dos Vistas | 24143 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 1402.972 | Rancho Dos Vistas | ||
8655 | 8655 | 8654 | {"type": "Polygon", "coordinates": [[[-120.28838, 34.6322], [-120.28819, 34.63214], [-120.28749, 34.63204], [-120.28601, 34.6281], [-120.2848, 34.626], [-120.2853, 34.62489], [-120.28414, 34.61969], [-120.28535, 34.61953], [-120.28645, 34.62558], [-120.28607, 34.62653], [-120.28748, 34.62894], [-120.28838, 34.6322]]]} | Unknown Access 4 | RHR, Santa Rosa Creek | 24314 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 34.437 | RHR, Santa Rosa Creek | ||
14300 | 14300 | 14299 | {"type": "MultiPolygon", "coordinates": [[[[-116.24853, 33.84567], [-116.24851, 33.84812], [-116.24644, 33.84703], [-116.24644, 33.84565], [-116.24853, 33.84567]]], [[[-116.49291, 33.88957], [-116.4929, 33.89588], [-116.48423, 33.89587], [-116.48427, 33.8886], [-116.48806, 33.88856], [-116.49291, 33.88957]]], [[[-116.49292, 33.88852], [-116.49291, 33.8894], [-116.48878, 33.88856], [-116.49198, 33.88852], [-116.49292, 33.88852]]]]} | Unknown Access 4 | Unnamed site - California Wildlife Conservation Board | 28678 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 168.975 | |||
14301 | 14301 | 14300 | {"type": "Polygon", "coordinates": [[[-117.08544, 34.21542], [-117.08542, 34.22251], [-117.08407, 34.22245], [-117.08415, 34.22223], [-117.08413, 34.22191], [-117.0839, 34.22174], [-117.08329, 34.22154], [-117.08268, 34.22152], [-117.08221, 34.22141], [-117.08181, 34.22089], [-117.08145, 34.22017], [-117.08127, 34.21946], [-117.08113, 34.21914], [-117.08087, 34.21887], [-117.08049, 34.2187], [-117.08027, 34.21843], [-117.08021, 34.21815], [-117.0801, 34.21792], [-117.07994, 34.21776], [-117.07952, 34.21768], [-117.07906, 34.2178], [-117.07588, 34.219], [-117.07557, 34.21902], [-117.07495, 34.21901], [-117.07449, 34.21893], [-117.07394, 34.21892], [-117.07325, 34.21894], [-117.07251, 34.21904], [-117.07197, 34.21922], [-117.07435, 34.21745], [-117.07487, 34.21717], [-117.0755, 34.21664], [-117.07606, 34.21615], [-117.07698, 34.2154], [-117.07709, 34.21533], [-117.08106, 34.21533], [-117.08108, 34.21539], [-117.08544, 34.21542]]]} | Open Access 1 | Unnamed site - California Wildlife Conservation Board | 28679 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 117.168 |
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]);