calands: units_with_maps: 3 rows where COUNTY = 18 and DES

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

3 rows where COUNTY = 18 and DES_TP = 39

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
2573	2573	2572	{"type": "Polygon", "coordinates": [[[-122.22395, 40.26271], [-122.2237, 40.26323], [-122.22328, 40.26376], [-122.22186, 40.26304], [-122.22219, 40.26302], [-122.22269, 40.26218], [-122.22395, 40.26271]]]}	Open Access 1	17891	Bend Bridge Public Access	32046	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		Tehama 18	3.867	Bend Bridge PA	0	State Recreation Area 39	4
12280	12280	12279	{"type": "Polygon", "coordinates": [[[-122.01675, 39.96925], [-122.01628, 39.96961], [-122.0158, 39.96979], [-122.01445, 39.96984], [-122.01447, 39.9697], [-122.01532, 39.96964], [-122.01591, 39.96951], [-122.0165, 39.96916], [-122.01675, 39.96925]]]}	Open Access 1	25907	Deer Creek Fishing Access	32147	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		Tehama 18	1.1	Deer Creek FA	0	State Recreation Area 39	4
16632	16632	16631	{"type": "MultiPolygon", "coordinates": [[[[-122.09227, 39.91089], [-122.09213, 39.91104], [-122.09203, 39.91135], [-122.09186, 39.91155], [-122.09156, 39.91179], [-122.09149, 39.91188], [-122.09144, 39.912], [-122.09138, 39.91209], [-122.09132, 39.91212], [-122.09116, 39.91215], [-122.09109, 39.91219], [-122.09102, 39.91226], [-122.09101, 39.91233], [-122.09095, 39.91238], [-122.09083, 39.91244], [-122.09063, 39.91253], [-122.09056, 39.91258], [-122.09048, 39.9127], [-122.09041, 39.91276], [-122.09015, 39.91291], [-122.08978, 39.91316], [-122.08946, 39.91345], [-122.08901, 39.91399], [-122.0887, 39.91426], [-122.08831, 39.91499], [-122.08793, 39.91535], [-122.08736, 39.91585], [-122.08713, 39.91627], [-122.0868, 39.91677], [-122.08641, 39.91725], [-122.08623, 39.91768], [-122.08612, 39.91805], [-122.08525, 39.91904], [-122.08506, 39.91874], [-122.0846, 39.9176], [-122.08424, 39.91703], [-122.08341, 39.91652], [-122.08313, 39.91564], [-122.0831, 39.91502], [-122.08289, 39.91444], [-122.08251, 39.91385], [-122.08211, 39.91339], [-122.08365, 39.9128], [-122.0858, 39.9122], [-122.08937, 39.91067], [-122.0896, 39.91062], [-122.09057, 39.9117], [-122.09225, 39.91077], [-122.09227, 39.91089]]], [[[-122.1048, 39.92143], [-122.10061, 39.92133], [-122.10129, 39.92241], [-122.10149, 39.92317], [-122.08648, 39.92293], [-122.08606, 39.9227], [-122.08596, 39.92256], [-122.08581, 39.92247], [-122.08552, 39.92222], [-122.0854, 39.92207], [-122.08591, 39.92088], [-122.08662, 39.92028], [-122.08589, 39.91972], [-122.0859, 39.9197], [-122.08608, 39.91963], [-122.08618, 39.91948], [-122.08649, 39.91931], [-122.0872, 39.91875], [-122.08764, 39.91837], [-122.088, 39.91783], [-122.08825, 39.91753], [-122.08863, 39.91716], [-122.08903, 39.91693], [-122.08945, 39.91673], [-122.08971, 39.91656], [-122.08993, 39.91655], [-122.09012, 39.91646], [-122.09036, 39.91647], [-122.09056, 39.91645], [-122.09075, 39.91639], [-122.09095, 39.91628], [-122.09108, 39.91617], [-122.09117, 39.91605], [-122.09123, 39.91596], [-122.09127, 39.91583], [-122.09133, 39.91573], [-122.09143, 39.91562], [-122.09156, 39.91551], [-122.09174, 39.9154], [-122.09228, 39.91514], [-122.09273, 39.9149], [-122.09335, 39.91449], [-122.09373, 39.91419], [-122.09408, 39.91387], [-122.09441, 39.91354], [-122.09471, 39.91319], [-122.09497, 39.91282], [-122.09509, 39.91258], [-122.09513, 39.91246], [-122.09515, 39.91229], [-122.09514, 39.91208], [-122.09509, 39.91184], [-122.0951, 39.91166], [-122.09509, 39.91138], [-122.09502, 39.91114], [-122.09472, 39.91055], [-122.09466, 39.91049], [-122.09429, 39.91022], [-122.09356, 39.90973], [-122.09353, 39.90968], [-122.09353, 39.90957], [-122.09373, 39.90977], [-122.09495, 39.91049], [-122.09735, 39.91269], [-122.1, 39.91393], [-122.09753, 39.91388], [-122.0979, 39.91444], [-122.09826, 39.91547], [-122.09841, 39.91603], [-122.09877, 39.91616], [-122.09887, 39.91629], [-122.09903, 39.91635], [-122.09937, 39.91682], [-122.09924, 39.91718], [-122.09926, 39.91769], [-122.09932, 39.91783], [-122.0994, 39.91787], [-122.10005, 39.91786], [-122.1001, 39.91801], [-122.10026, 39.91801], [-122.10051, 39.91896], [-122.10042, 39.91908], [-122.10073, 39.91937], [-122.1013, 39.91965], [-122.10221, 39.92025], [-122.10223, 39.92035], [-122.10292, 39.92125], [-122.10478, 39.92129], [-122.1048, 39.92143]]]]}	Open Access 1	17318	Woodson Bridge State Recreation Area	1792	204	California Department of Parks and Recreation 48	State 5	State Agency 5	http://www.parks.ca.gov/	California Department of Parks and Recreation 9	204	California Department of Parks and Recreation 47	State 5	State Agency 5	http://www.parks.ca.gov/?page_id=459	Tehama 18	348.024	Woodson Bridge SRA	1959	State Recreation Area 39	4

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]);