calands: units_with_maps: 4 rows where COUNTY = 23 and DES

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

4 rows where COUNTY = 23 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	COUNTY	ACRES	LABEL_NAME	DES_TP	GAP_STS
1642	1642	1641	{"type": "MultiPolygon", "coordinates": [[[[-122.91501, 38.23223], [-122.91436, 38.23304], [-122.91323, 38.23292], [-122.91298, 38.23269], [-122.91332, 38.23235], [-122.91362, 38.23199], [-122.91396, 38.23141], [-122.91403, 38.23117], [-122.91417, 38.23093], [-122.91444, 38.23065], [-122.91472, 38.2304], [-122.91498, 38.23013], [-122.91479, 38.23083], [-122.91501, 38.23223]]], [[[-122.92228, 38.22119], [-122.92219, 38.22138], [-122.9222, 38.2214], [-122.92205, 38.22171], [-122.921, 38.22207], [-122.92063, 38.22229], [-122.91984, 38.22279], [-122.9192, 38.22313], [-122.91832, 38.22349], [-122.91766, 38.22384], [-122.9169, 38.22438], [-122.91676, 38.22491], [-122.91692, 38.22544], [-122.91697, 38.2261], [-122.91706, 38.22669], [-122.9171, 38.22705], [-122.91691, 38.22739], [-122.9167, 38.22796], [-122.91636, 38.22833], [-122.91608, 38.22869], [-122.9155, 38.22952], [-122.91512, 38.22995], [-122.91571, 38.22916], [-122.91592, 38.2289], [-122.91618, 38.22848], [-122.91635, 38.22809], [-122.91629, 38.22676], [-122.91608, 38.22537], [-122.91611, 38.22521], [-122.91622, 38.22491], [-122.91629, 38.22477], [-122.91649, 38.22449], [-122.91673, 38.22425], [-122.91702, 38.22406], [-122.91779, 38.22361], [-122.91846, 38.22313], [-122.91928, 38.22288], [-122.9198, 38.22249], [-122.92014, 38.22228], [-122.92196, 38.22151], [-122.92215, 38.22137], [-122.92228, 38.22119]]]]}	Open Access 1	1917	Keys Creek Fishing Access	32194	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	Marin 23	15.8	Keys Creek FA	State Recreation Area 39	4
4993	4993	4992	{"type": "Polygon", "coordinates": [[[-122.81055, 38.06495], [-122.8078, 38.06673], [-122.80522, 38.06556], [-122.80528, 38.06519], [-122.80528, 38.06493], [-122.80569, 38.06503], [-122.8064, 38.06528], [-122.80677, 38.06539], [-122.80723, 38.06548], [-122.80745, 38.06551], [-122.80796, 38.06549], [-122.80838, 38.06544], [-122.80872, 38.06538], [-122.80973, 38.0651], [-122.80996, 38.06507], [-122.81035, 38.06463], [-122.81043, 38.06451], [-122.81053, 38.06442], [-122.81055, 38.06495]]]}	Open Access 1	2042	Point Reyes Station Public Access	32268	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	Marin 23	9.7	Point Reyes Station PA	State Recreation Area 39	4
15636	15636	15635	{"type": "Polygon", "coordinates": [[[-122.84086, 38.1053], [-122.83932, 38.10885], [-122.83927, 38.10871], [-122.83925, 38.1086], [-122.83954, 38.10779], [-122.83973, 38.10583], [-122.84007, 38.10548], [-122.84012, 38.10544], [-122.84019, 38.10536], [-122.84024, 38.10522], [-122.84022, 38.10512], [-122.84018, 38.10503], [-122.8401, 38.10496], [-122.83999, 38.1049], [-122.83912, 38.10455], [-122.83903, 38.1045], [-122.83892, 38.10439], [-122.83886, 38.10426], [-122.83858, 38.10384], [-122.83847, 38.10372], [-122.83837, 38.10365], [-122.8382, 38.10357], [-122.83801, 38.10354], [-122.83756, 38.10354], [-122.83742, 38.10352], [-122.83732, 38.10348], [-122.83723, 38.10343], [-122.83716, 38.10336], [-122.83712, 38.10327], [-122.8371, 38.10313], [-122.83727, 38.10224], [-122.83732, 38.10214], [-122.83731, 38.10201], [-122.83727, 38.10192], [-122.83719, 38.10185], [-122.83647, 38.10098], [-122.83635, 38.10086], [-122.83625, 38.10079], [-122.83614, 38.10073], [-122.83596, 38.10066], [-122.83565, 38.10059], [-122.83517, 38.10059], [-122.835, 38.10053], [-122.83487, 38.10045], [-122.8348, 38.10037], [-122.83475, 38.10028], [-122.8342, 38.09949], [-122.83412, 38.09933], [-122.83399, 38.09917], [-122.83388, 38.09907], [-122.83378, 38.09901], [-122.83301, 38.09862], [-122.83287, 38.09852], [-122.83272, 38.09836], [-122.8327, 38.09829], [-122.83261, 38.09814], [-122.83243, 38.09798], [-122.8322, 38.09785], [-122.83154, 38.09766], [-122.83108, 38.0975], [-122.83072, 38.09742], [-122.8297, 38.09728], [-122.82957, 38.09728], [-122.8294, 38.09722], [-122.82927, 38.09713], [-122.82919, 38.097], [-122.82913, 38.09661], [-122.82914, 38.09652], [-122.82922, 38.09639], [-122.82952, 38.09614], [-122.82968, 38.09603], [-122.8298, 38.09589], [-122.82988, 38.09572], [-122.82988, 38.09554], [-122.82987, 38.09546], [-122.82978, 38.09529], [-122.82885, 38.09403], [-122.82858, 38.09378], [-122.82825, 38.09359], [-122.82803, 38.09341], [-122.82794, 38.09331], [-122.82783, 38.09315], [-122.82741, 38.09271], [-122.82698, 38.09243], [-122.82682, 38.09238], [-122.82665, 38.09236], [-122.82637, 38.0924], [-122.82603, 38.09259], [-122.82592, 38.09259], [-122.82581, 38.09256], [-122.8257, 38.09246], [-122.82568, 38.09241], [-122.82569, 38.09227], [-122.82563, 38.09213], [-122.82551, 38.09202], [-122.82534, 38.09195], [-122.82515, 38.09183], [-122.82504, 38.0917], [-122.82496, 38.09155], [-122.82489, 38.09146], [-122.82476, 38.09135], [-122.82466, 38.0913], [-122.82444, 38.09121], [-122.82425, 38.09119], [-122.82358, 38.09093], [-122.82314, 38.09074], [-122.82262, 38.09045], [-122.8225, 38.09042], [-122.82226, 38.09044], [-122.82207, 38.09053], [-122.82197, 38.09066], [-122.82148, 38.09112], [-122.82135, 38.09123], [-122.82108, 38.09138], [-122.82085, 38.09147], [-122.82061, 38.09154], [-122.81956, 38.09165], [-122.82049, 38.09129], [-122.82139, 38.08918], [-122.82504, 38.09074], [-122.82604, 38.09126], [-122.82666, 38.09164], [-122.82725, 38.09203], [-122.82818, 38.09274], [-122.82886, 38.09336], [-122.82948, 38.09401], [-122.82977, 38.09435], [-122.83018, 38.09487], [-122.83042, 38.09521], [-122.83038, 38.0953], [-122.8321, 38.09721], [-122.83174, 38.09716], [-122.83171, 38.09725], [-122.83231, 38.09736], [-122.8379, 38.10183], [-122.84071, 38.10517], [-122.84086, 38.1053]]]}	Open Access 1	1665	Tomales Bay Fishing Access	32327	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	Marin 23	52.616	Tomales Bay FA	State Recreation Area 39	4
15646	15646	15645	{"type": "Polygon", "coordinates": [[[-122.81955, 38.06281], [-122.81919, 38.0628], [-122.81891, 38.06285], [-122.81842, 38.06298], [-122.81768, 38.06309], [-122.81685, 38.06315], [-122.81634, 38.06311], [-122.81511, 38.06299], [-122.81302, 38.06306], [-122.81281, 38.06305], [-122.81271, 38.06303], [-122.8126, 38.06297], [-122.81766, 38.06154], [-122.81852, 38.06235], [-122.81913, 38.06261], [-122.81955, 38.06281]]]}	Open Access 1	29598	White House Pool Fishing Access	32349	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	Marin 23	12.717	White House Pool FA	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]);