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 = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Carrizo-Canyon-ER"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14475 | 14475 | 14474 | {"type": "Polygon", "coordinates": [[[-116.42554, 33.65613], [-116.40816, 33.65615], [-116.4081, 33.66326], [-116.40812, 33.66778], [-116.4078, 33.66759], [-116.40721, 33.6673], [-116.40663, 33.66716], [-116.40586, 33.66702], [-116.4054, 33.66696], [-116.40526, 33.66682], [-116.40502, 33.66648], [-116.40476, 33.66605], [-116.40457, 33.66578], [-116.40414, 33.66551], [-116.40369, 33.6655], [-116.40287, 33.66554], [-116.40249, 33.66553], [-116.40212, 33.66542], [-116.40178, 33.66521], [-116.40144, 33.66494], [-116.40101, 33.66452], [-116.40083, 33.66441], [-116.40052, 33.66433], [-116.40006, 33.66426], [-116.39962, 33.66406], [-116.39946, 33.66397], [-116.39933, 33.66385], [-116.39923, 33.66369], [-116.39917, 33.6633], [-116.39919, 33.66306], [-116.39921, 33.66234], [-116.3993, 33.66167], [-116.39926, 33.66134], [-116.39919, 33.66104], [-116.39909, 33.66087], [-116.39892, 33.66072], [-116.39754, 33.65978], [-116.39749, 33.65957], [-116.39748, 33.65938], [-116.39764, 33.6589], [-116.39781, 33.65878], [-116.39801, 33.65874], [-116.39839, 33.65868], [-116.39862, 33.65872], [-116.39882, 33.65877], [-116.39901, 33.65887], [-116.39925, 33.65905], [-116.3994, 33.65921], [-116.39958, 33.65933], [-116.39982, 33.65946], [-116.39991, 33.6595], [-116.40019, 33.6595], [-116.40075, 33.65936], [-116.40088, 33.65924], [-116.40104, 33.65881], [-116.40094, 33.65849], [-116.40067, 33.65827], [-116.40013, 33.6581], [-116.3992, 33.65798], [-116.3989, 33.65773], [-116.39871, 33.65736], [-116.39861, 33.65701], [-116.39857, 33.65659], [-116.39852, 33.65635], [-116.39833, 33.6562], [-116.39819, 33.65616], [-116.40003, 33.65614], [-116.40189, 33.65614], [-116.40227, 33.65658], [-116.40249, 33.6567], [-116.40277, 33.65675], [-116.40321, 33.65668], [-116.40347, 33.65654], [-116.40361, 33.65649], [-116.40371, 33.65642], [-116.40381, 33.65633], [-116.4039, 33.65614], [-116.40815, 33.65613], [-116.40816, 33.63434], [-116.40408, 33.63474], [-116.4035, 33.63519], [-116.40391, 33.63454], [-116.40408, 33.63422], [-116.40413, 33.63393], [-116.40414, 33.6335], [-116.40403, 33.63315], [-116.4039, 33.63286], [-116.40333, 33.63229], [-116.40288, 33.63192], [-116.40272, 33.6317], [-116.40271, 33.63144], [-116.40278, 33.63071], [-116.40284, 33.63051], [-116.40299, 33.63023], [-116.40313, 33.63002], [-116.40353, 33.62924], [-116.40363, 33.62861], [-116.40369, 33.62712], [-116.40367, 33.6271], [-116.41474, 33.62705], [-116.4147, 33.63165], [-116.41344, 33.63165], [-116.41344, 33.63436], [-116.41238, 33.63438], [-116.41239, 33.64159], [-116.41471, 33.6416], [-116.41477, 33.64261], [-116.41608, 33.64375], [-116.41608, 33.64408], [-116.41685, 33.64522], [-116.41786, 33.64647], [-116.41849, 33.64678], [-116.41935, 33.64747], [-116.42055, 33.64889], [-116.42111, 33.64945], [-116.42115, 33.64852], [-116.42122, 33.64156], [-116.42268, 33.64156], [-116.42304, 33.64212], [-116.42334, 33.64213], [-116.42359, 33.64231], [-116.42396, 33.64224], [-116.42434, 33.64233], [-116.42463, 33.64156], [-116.42551, 33.6416], [-116.42554, 33.65613]]]} | Open Access 1 | Carrizo Canyon Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Carrizo-Canyon-ER | 32105 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1065.767 | Carrizo Canyon ER | 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]);