calands: units_with_maps: 2 rows where ACCESS_TYP = 1, COUNTY = 18 and MNG

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

2 rows where ACCESS_TYP = 1, COUNTY = 18 and MNG_AGENCY = 47

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
10039	10039	10038	{"type": "MultiPolygon", "coordinates": [[[[-122.22671, 40.19604], [-122.22645, 40.19618], [-122.22578, 40.19664], [-122.22536, 40.19732], [-122.22521, 40.19765], [-122.22498, 40.19793], [-122.22428, 40.19761], [-122.22436, 40.19745], [-122.22445, 40.19735], [-122.22459, 40.19723], [-122.22462, 40.19718], [-122.22463, 40.19708], [-122.22472, 40.19696], [-122.22477, 40.19678], [-122.22485, 40.19664], [-122.22514, 40.19628], [-122.22549, 40.1957], [-122.22566, 40.1955], [-122.2257, 40.19543], [-122.22618, 40.19592], [-122.22644, 40.19578], [-122.22671, 40.19604]]], [[[-122.22771, 40.19558], [-122.22711, 40.19584], [-122.22682, 40.19598], [-122.22654, 40.19569], [-122.22708, 40.19538], [-122.22715, 40.19544], [-122.22742, 40.19529], [-122.22771, 40.19558]]]]}	Open Access 1	17351	William B. Ide Adobe State Historic Park	1791	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=458	Tehama 18	5.795	William B. Ide Adobe SHP	1951	State Historic or Cultural Area 132	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]);