calands: units_with_maps: 1 row where MNG_AG_TYP = 5 and PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Carrizo-Canyon-ER"

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"

Search:

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	id	map	ACCESS_TYP	UNIT_ID	UNIT_NAME	SUID_NMA	AGNCY_ID	AGNCY_NAME	AGNCY_LEV	AGNCY_TYP	AGNCY_WEB	LAYER	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	PARK_URL	COUNTY	ACRES	LABEL_NAME	YR_EST	DES_TP	GAP_STS
15627	15627	15626	{"type": "Polygon", "coordinates": [[[-116.42554, 33.65613], [-116.40815, 33.65615], [-116.4081, 33.66326], [-116.40812, 33.66778], [-116.4078, 33.66759], [-116.40722, 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.6592], [-116.39958, 33.65933], [-116.39982, 33.65946], [-116.39991, 33.6595], [-116.40019, 33.65951], [-116.40075, 33.65936], [-116.40088, 33.65924], [-116.40104, 33.65881], [-116.40094, 33.65849], [-116.40067, 33.65827], [-116.40014, 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.65634], [-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.65614], [-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.62862], [-116.40369, 33.62711], [-116.40367, 33.6271], [-116.41474, 33.62705], [-116.4147, 33.63165], [-116.41344, 33.63165], [-116.41344, 33.63436], [-116.41238, 33.63437], [-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.42112, 33.64946], [-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.42435, 33.64233], [-116.42463, 33.64156], [-116.42551, 33.6416], [-116.42554, 33.65613]]]}	Open Access 1	25903	Carrizo Canyon Ecological Reserve	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	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/Lands/Places-to-Visit/Carrizo-Canyon-ER	Riverside 10	1065.517	Carrizo Canyon ER	1978	State Conservation Area 8	2

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);