calands: units_with_maps: 1 row where ACCESS_TYP = 1, DES_TP = 15 and SUID

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

1 row where ACCESS_TYP = 1, DES_TP = 15 and SUID_NMA = 1451

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
16538	16538	16537	{"type": "Polygon", "coordinates": [[[-122.34977, 37.20981], [-122.34916, 37.21214], [-122.34933, 37.21369], [-122.34872, 37.2136], [-122.34845, 37.21377], [-122.34807, 37.21378], [-122.34764, 37.214], [-122.34708, 37.21344], [-122.34604, 37.21369], [-122.34543, 37.21434], [-122.34506, 37.21502], [-122.34482, 37.21519], [-122.34582, 37.2162], [-122.34561, 37.21635], [-122.34551, 37.21647], [-122.34527, 37.21683], [-122.34525, 37.21697], [-122.34522, 37.21711], [-122.34513, 37.21723], [-122.34511, 37.21737], [-122.34512, 37.21764], [-122.34505, 37.21777], [-122.34492, 37.21786], [-122.34476, 37.21793], [-122.34435, 37.21819], [-122.33888, 37.21271], [-122.33887, 37.21272], [-122.33886, 37.21602], [-122.33308, 37.21594], [-122.33309, 37.21849], [-122.33235, 37.21847], [-122.33236, 37.21495], [-122.332, 37.21495], [-122.33114, 37.21551], [-122.33084, 37.21563], [-122.33063, 37.21564], [-122.33043, 37.21577], [-122.32992, 37.21596], [-122.32944, 37.21617], [-122.32847, 37.21648], [-122.3282, 37.21654], [-122.32823, 37.2177], [-122.32785, 37.21772], [-122.32788, 37.21883], [-122.32831, 37.21884], [-122.32842, 37.22217], [-122.32358, 37.22219], [-122.3234, 37.22968], [-122.31913, 37.22961], [-122.31912, 37.22221], [-122.32358, 37.22218], [-122.32366, 37.2186], [-122.31453, 37.21857], [-122.31453, 37.22204], [-122.30558, 37.22201], [-122.3055, 37.22936], [-122.29686, 37.2292], [-122.27959, 37.22905], [-122.26177, 37.22779], [-122.26167, 37.22146], [-122.25808, 37.222], [-122.25808, 37.22147], [-122.25758, 37.22066], [-122.25714, 37.21873], [-122.25665, 37.2188], [-122.25667, 37.21556], [-122.26168, 37.21479], [-122.26168, 37.21116], [-122.2704, 37.21108], [-122.2705, 37.20758], [-122.2794, 37.20769], [-122.27919, 37.21471], [-122.27928, 37.21839], [-122.27939, 37.22195], [-122.29213, 37.22199], [-122.29216, 37.21491], [-122.29673, 37.21498], [-122.30146, 37.21503], [-122.30149, 37.21186], [-122.30562, 37.21187], [-122.30571, 37.20786], [-122.3146, 37.20787], [-122.3147, 37.20081], [-122.29706, 37.20079], [-122.28812, 37.20084], [-122.28812, 37.2005], [-122.28824, 37.20047], [-122.28867, 37.20021], [-122.28969, 37.19991], [-122.29002, 37.19973], [-122.29056, 37.19963], [-122.2908, 37.19951], [-122.29101, 37.19932], [-122.29117, 37.19895], [-122.29126, 37.19881], [-122.29138, 37.1987], [-122.29211, 37.19825], [-122.29252, 37.19794], [-122.29312, 37.19762], [-122.29333, 37.19746], [-122.29344, 37.19734], [-122.29353, 37.19723], [-122.29366, 37.19684], [-122.29377, 37.19671], [-122.29391, 37.19658], [-122.29427, 37.19632], [-122.29457, 37.19585], [-122.29504, 37.19559], [-122.29593, 37.19559], [-122.29643, 37.19603], [-122.29704, 37.19623], [-122.29705, 37.19622], [-122.29705, 37.19606], [-122.29656, 37.1959], [-122.29597, 37.1954], [-122.29498, 37.19542], [-122.29441, 37.19574], [-122.2941, 37.19622], [-122.29377, 37.19646], [-122.29347, 37.19675], [-122.29333, 37.19717], [-122.29326, 37.19726], [-122.29315, 37.19738], [-122.29299, 37.19749], [-122.2924, 37.19781], [-122.29198, 37.19812], [-122.29132, 37.19852], [-122.29116, 37.19864], [-122.29099, 37.19886], [-122.29082, 37.19923], [-122.29067, 37.19939], [-122.29048, 37.19948], [-122.28993, 37.19957], [-122.28959, 37.19976], [-122.28872, 37.20002], [-122.28825, 37.20025], [-122.28812, 37.20028], [-122.28812, 37.19749], [-122.29251, 37.19747], [-122.29256, 37.19429], [-122.29705, 37.19419], [-122.30632, 37.19408], [-122.3156, 37.19397], [-122.32019, 37.19396], [-122.32112, 37.19488], [-122.32131, 37.19476], [-122.32163, 37.19468], [-122.32178, 37.19461], [-122.32246, 37.19444], [-122.32261, 37.19438], [-122.32303, 37.19412], [-122.32334, 37.19399], [-122.32348, 37.1939], [-122.32359, 37.19378], [-122.32382, 37.19361], [-122.32394, 37.19346], [-122.32409, 37.1932], [-122.3242, 37.19311], [-122.32439, 37.19288], [-122.32443, 37.19278], [-122.32439, 37.19254], [-122.32416, 37.19215], [-122.32403, 37.19189], [-122.32399, 37.19173], [-122.324, 37.19161], [-122.32399, 37.19135], [-122.32395, 37.19122], [-122.32381, 37.19096], [-122.32377, 37.19085], [-122.32365, 37.19059], [-122.32364, 37.19046], [-122.32366, 37.19035], [-122.32374, 37.1901], [-122.32379, 37.18999], [-122.32394, 37.18986], [-122.32424, 37.18969], [-122.32475, 37.18946], [-122.32489, 37.18935], [-122.3251, 37.18913], [-122.32527, 37.18898], [-122.3254, 37.18892], [-122.32546, 37.18886], [-122.3257, 37.18874], [-122.32592, 37.18852], [-122.32605, 37.18842], [-122.32636, 37.1883], [-122.3265, 37.18821], [-122.32684, 37.18789], [-122.32697, 37.1878], [-122.3273, 37.18769], [-122.32745, 37.18762], [-122.32785, 37.1876], [-122.32803, 37.18757], [-122.32817, 37.18752], [-122.32856, 37.18731], [-122.32885, 37.18725], [-122.32938, 37.18724], [-122.32956, 37.1872], [-122.33001, 37.18698], [-122.33013, 37.1869], [-122.33048, 37.18661], [-122.33064, 37.1865], [-122.33094, 37.18622], [-122.33104, 37.18614], [-122.33134, 37.18598], [-122.3319, 37.18588], [-122.33245, 37.18582], [-122.33295, 37.18573], [-122.33328, 37.18563], [-122.33342, 37.18557], [-122.33354, 37.18549], [-122.33371, 37.18542], [-122.33417, 37.18544], [-122.3343, 37.18542], [-122.33513, 37.18513], [-122.33533, 37.18509], [-122.33545, 37.18509], [-122.33558, 37.18511], [-122.3358, 37.18521], [-122.33622, 37.18561], [-122.33665, 37.18588], [-122.3368, 37.18594], [-122.33702, 37.18598], [-122.33722, 37.18597], [-122.33742, 37.18594], [-122.33775, 37.18586], [-122.33789, 37.18588], [-122.33825, 37.18597], [-122.3386, 37.18599], [-122.33878, 37.18601], [-122.33987, 37.18626], [-122.34001, 37.18623], [-122.3401, 37.1862], [-122.33998, 37.18709], [-122.33969, 37.18759], [-122.33959, 37.18786], [-122.33971, 37.18818], [-122.34021, 37.18877], [-122.34053, 37.18934], [-122.34097, 37.19032], [-122.34108, 37.19083], [-122.34098, 37.19136], [-122.34117, 37.19189], [-122.34133, 37.19216], [-122.3415, 37.19227], [-122.34204, 37.19232], [-122.34225, 37.19243], [-122.34251, 37.19268], [-122.34285, 37.19323], [-122.34312, 37.19353], [-122.34404, 37.19418], [-122.34433, 37.19449], [-122.3462, 37.19734], [-122.34628, 37.19751], [-122.34635, 37.1978], [-122.34634, 37.19791], [-122.34632, 37.19797], [-122.34626, 37.19805], [-122.34619, 37.19811], [-122.34579, 37.19829], [-122.34553, 37.19837], [-122.34518, 37.19846], [-122.34501, 37.19853], [-122.34481, 37.19867], [-122.34472, 37.19876], [-122.34463, 37.1989], [-122.34453, 37.19896], [-122.34443, 37.19897], [-122.34409, 37.19893], [-122.34379, 37.19895], [-122.34357, 37.199], [-122.34325, 37.19911], [-122.34289, 37.1992], [-122.34238, 37.19927], [-122.34234, 37.19922], [-122.34231, 37.19924], [-122.34222, 37.19932], [-122.34219, 37.19938], [-122.34218, 37.19945], [-122.34225, 37.19973], [-122.34219, 37.19975], [-122.34232, 37.20029], [-122.34239, 37.20042], [-122.34249, 37.20053], [-122.3426, 37.20061], [-122.34273, 37.20068], [-122.34289, 37.20072], [-122.34405, 37.20097], [-122.34412, 37.2011], [-122.34433, 37.20116], [-122.3461, 37.20234], [-122.34626, 37.20254], [-122.3464, 37.20276], [-122.3466, 37.20301], [-122.34703, 37.20316], [-122.34719, 37.20341], [-122.34735, 37.20375], [-122.34725, 37.20416], [-122.34789, 37.20491], [-122.3481, 37.20534], [-122.34813, 37.20563], [-122.34828, 37.20591], [-122.34841, 37.20601], [-122.34939, 37.20812], [-122.34941, 37.20913], [-122.34977, 37.20981]]]}	Open Access 1	5031	Butano State Park	1451	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=536	San Mateo 15	4536.506	Butano SP	1956	State Park 15	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]);