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/default.asp?page_id=577"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
205 | 205 | 204 | {"type": "Polygon", "coordinates": [[[-121.53008, 36.01425], [-121.53002, 36.02521], [-121.52771, 36.02524], [-121.52771, 36.03951], [-121.52554, 36.03954], [-121.52552, 36.03952], [-121.5207, 36.03961], [-121.52077, 36.02532], [-121.52555, 36.02524], [-121.52557, 36.02162], [-121.51351, 36.0218], [-121.5136, 36.00743], [-121.51371, 36.00747], [-121.51387, 36.00747], [-121.51392, 36.00733], [-121.51409, 36.0073], [-121.51411, 36.00744], [-121.51416, 36.0075], [-121.51434, 36.00759], [-121.51452, 36.00761], [-121.51471, 36.00756], [-121.51489, 36.00755], [-121.51525, 36.00758], [-121.51561, 36.00767], [-121.5158, 36.0077], [-121.51599, 36.00779], [-121.51617, 36.00785], [-121.51634, 36.00778], [-121.51651, 36.00777], [-121.51654, 36.00792], [-121.51671, 36.00798], [-121.51707, 36.00806], [-121.51742, 36.00808], [-121.5178, 36.00813], [-121.51816, 36.00813], [-121.51835, 36.00805], [-121.51889, 36.00796], [-121.51906, 36.00791], [-121.5191, 36.00776], [-121.51909, 36.00762], [-121.51926, 36.00749], [-121.51943, 36.00745], [-121.51945, 36.00732], [-121.51962, 36.00742], [-121.51979, 36.0073], [-121.51997, 36.00738], [-121.51996, 36.00752], [-121.51983, 36.00766], [-121.51965, 36.00763], [-121.51956, 36.00776], [-121.51973, 36.00786], [-121.51986, 36.008], [-121.5198, 36.00814], [-121.51963, 36.00826], [-121.5196, 36.0084], [-121.51962, 36.00854], [-121.51999, 36.00896], [-121.52031, 36.00915], [-121.51964, 36.00902], [-121.51958, 36.00908], [-121.51867, 36.00861], [-121.51844, 36.00834], [-121.51799, 36.00827], [-121.51763, 36.00826], [-121.51692, 36.00819], [-121.51652, 36.00811], [-121.51574, 36.00788], [-121.51563, 36.0081], [-121.5163, 36.00831], [-121.51666, 36.0084], [-121.51733, 36.00849], [-121.51769, 36.00856], [-121.5179, 36.00863], [-121.5183, 36.00881], [-121.51934, 36.00938], [-121.51981, 36.0096], [-121.52028, 36.00973], [-121.52088, 36.00983], [-121.52172, 36.00985], [-121.52173, 36.01007], [-121.52326, 36.01053], [-121.52388, 36.01136], [-121.52476, 36.01163], [-121.52484, 36.01097], [-121.52491, 36.01093], [-121.52464, 36.01052], [-121.52434, 36.01019], [-121.5241, 36.01001], [-121.52394, 36.00991], [-121.52358, 36.00977], [-121.52349, 36.00981], [-121.52243, 36.00983], [-121.52241, 36.0096], [-121.52131, 36.0096], [-121.52111, 36.00959], [-121.52062, 36.00951], [-121.52069, 36.00935], [-121.52089, 36.00943], [-121.52126, 36.00945], [-121.52162, 36.00944], [-121.5218, 36.00933], [-121.52203, 36.00933], [-121.5222, 36.00944], [-121.52238, 36.00939], [-121.52256, 36.00947], [-121.52273, 36.00948], [-121.52292, 36.00962], [-121.52309, 36.00963], [-121.52328, 36.00962], [-121.52345, 36.00955], [-121.52363, 36.0096], [-121.524, 36.00974], [-121.52418, 36.00977], [-121.52456, 36.00977], [-121.52472, 36.00991], [-121.52474, 36.01006], [-121.52483, 36.0102], [-121.52496, 36.01034], [-121.52512, 36.01048], [-121.52523, 36.01061], [-121.52527, 36.01075], [-121.52534, 36.01089], [-121.52563, 36.01117], [-121.52562, 36.01432], [-121.53008, 36.01425]]]} | Open Access 1 | Limekiln State Park | http://www.parks.ca.gov/default.asp?page_id=577 | 1606 | 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 | 743.16 | Limekiln SP | 1994 |
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]);