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=545"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15115 | 15115 | 15114 | {"type": "Polygon", "coordinates": [[[-121.87069, 36.94019], [-121.86966, 36.94078], [-121.86919, 36.9404], [-121.86859, 36.9397], [-121.86848, 36.93935], [-121.86811, 36.93884], [-121.86699, 36.93758], [-121.86643, 36.93721], [-121.86637, 36.93722], [-121.86599, 36.93691], [-121.86636, 36.93651], [-121.86509, 36.93478], [-121.86474, 36.93483], [-121.86336, 36.93309], [-121.86319, 36.93316], [-121.86278, 36.93284], [-121.86235, 36.93321], [-121.86045, 36.93232], [-121.8607, 36.93192], [-121.8607, 36.9319], [-121.86213, 36.93166], [-121.86214, 36.93164], [-121.86121, 36.93044], [-121.86033, 36.92938], [-121.85931, 36.9279], [-121.85795, 36.92554], [-121.85686, 36.92399], [-121.85605, 36.9225], [-121.85513, 36.92109], [-121.85436, 36.91983], [-121.85428, 36.91967], [-121.85426, 36.91968], [-121.85358, 36.92094], [-121.85326, 36.92086], [-121.8529, 36.9207], [-121.85282, 36.92059], [-121.85262, 36.92063], [-121.85248, 36.92074], [-121.85246, 36.92088], [-121.85235, 36.92099], [-121.85222, 36.92127], [-121.85206, 36.92127], [-121.85196, 36.92116], [-121.8518, 36.92138], [-121.8517, 36.92138], [-121.85163, 36.92112], [-121.85139, 36.92103], [-121.85117, 36.92097], [-121.85062, 36.92121], [-121.84999, 36.92236], [-121.85058, 36.92257], [-121.85051, 36.92268], [-121.85052, 36.9227], [-121.85146, 36.92303], [-121.85156, 36.92292], [-121.85215, 36.92313], [-121.85179, 36.92346], [-121.84892, 36.9225], [-121.84918, 36.922], [-121.84857, 36.92178], [-121.84928, 36.92043], [-121.84638, 36.91715], [-121.84521, 36.91586], [-121.84861, 36.91493], [-121.84885, 36.9153], [-121.8505, 36.91507], [-121.85068, 36.91535], [-121.85151, 36.91523], [-121.85135, 36.91494], [-121.85152, 36.91491], [-121.85153, 36.91489], [-121.84965, 36.91216], [-121.84938, 36.91158], [-121.84874, 36.91075], [-121.84826, 36.91006], [-121.84848, 36.90998], [-121.84877, 36.91031], [-121.84897, 36.91058], [-121.84918, 36.91084], [-121.84958, 36.91143], [-121.85033, 36.91232], [-121.8517, 36.91456], [-121.85185, 36.91474], [-121.85197, 36.91492], [-121.852, 36.915], [-121.85206, 36.91522], [-121.8522, 36.91555], [-121.85242, 36.91586], [-121.85285, 36.91672], [-121.85333, 36.91762], [-121.85341, 36.91782], [-121.85359, 36.91817], [-121.85365, 36.91827], [-121.85398, 36.91889], [-121.8544, 36.91958], [-121.85451, 36.91972], [-121.8551, 36.92067], [-121.85532, 36.92098], [-121.85571, 36.92158], [-121.85584, 36.9218], [-121.85591, 36.92188], [-121.85661, 36.92297], [-121.85679, 36.9232], [-121.85699, 36.92353], [-121.85721, 36.92383], [-121.85764, 36.92456], [-121.8579, 36.92493], [-121.85813, 36.92532], [-121.85859, 36.92593], [-121.85876, 36.92621], [-121.85917, 36.92676], [-121.85981, 36.92768], [-121.8612, 36.92941], [-121.86165, 36.93001], [-121.86212, 36.93057], [-121.86241, 36.93103], [-121.86286, 36.93161], [-121.86688, 36.93638], [-121.87069, 36.94019]]]} | Open Access 1 | Manresa State Beach | http://www.parks.ca.gov/?page_id=545 | 1619 | 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 | 140.212 | Manresa SB | 1948 |
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]);