calands: units_with_maps: 2 rows where COUNTY = 26, MNG_AGENCY = 47 and MNG_AG

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

2 rows where COUNTY = 26, MNG_AGENCY = 47 and MNG_AG_TYP = 5

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
13135	13135	13134	{"type": "Polygon", "coordinates": [[[-122.15956, 38.05035], [-122.15934, 38.05064], [-122.15844, 38.05023], [-122.15866, 38.04993], [-122.15956, 38.05035]]]}	Open Access 1	35060	Benicia Capitol State Historic Park	1431	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=475	Solano 26	0.863	Benicia Capitol SHP	1951	State Historic or Cultural Area 132	4
16659	16659	16658	{"type": "Polygon", "coordinates": [[[-122.2051, 38.06835], [-122.20509, 38.06835], [-122.20506, 38.06798], [-122.20496, 38.06762], [-122.20478, 38.06728], [-122.20454, 38.06696], [-122.20423, 38.06669], [-122.20256, 38.06554], [-122.20241, 38.06545], [-122.20216, 38.06536], [-122.20222, 38.06523], [-122.20207, 38.06518], [-122.20198, 38.06533], [-122.20173, 38.06532], [-122.20103, 38.06536], [-122.20083, 38.06535], [-122.20063, 38.06532], [-122.20046, 38.06527], [-122.19975, 38.06496], [-122.19949, 38.06491], [-122.19931, 38.06491], [-122.19905, 38.06496], [-122.19881, 38.06507], [-122.19868, 38.06517], [-122.19837, 38.06549], [-122.19826, 38.0653], [-122.1971, 38.06557], [-122.1973, 38.06518], [-122.19636, 38.06487], [-122.19528, 38.06688], [-122.19535, 38.06691], [-122.19642, 38.07069], [-122.19953, 38.07633], [-122.19954, 38.07746], [-122.19953, 38.08275], [-122.1992, 38.08341], [-122.19785, 38.08291], [-122.19761, 38.08264], [-122.19624, 38.08225], [-122.19583, 38.08204], [-122.19532, 38.08174], [-122.19463, 38.08131], [-122.19407, 38.08094], [-122.19331, 38.08036], [-122.19279, 38.07989], [-122.19349, 38.07896], [-122.19365, 38.0788], [-122.19363, 38.07868], [-122.1936, 38.07863], [-122.19351, 38.07852], [-122.19339, 38.07841], [-122.1925, 38.07951], [-122.19245, 38.07959], [-122.19184, 38.07899], [-122.19146, 38.07857], [-122.19122, 38.07827], [-122.19188, 38.07756], [-122.19095, 38.07732], [-122.19073, 38.07723], [-122.19053, 38.07711], [-122.19035, 38.07698], [-122.19019, 38.07683], [-122.18975, 38.07637], [-122.18936, 38.07589], [-122.18926, 38.07587], [-122.1854, 38.07119], [-122.18489, 38.06964], [-122.18486, 38.06961], [-122.1847, 38.0698], [-122.18413, 38.06925], [-122.18359, 38.06866], [-122.18334, 38.06843], [-122.18313, 38.0678], [-122.18328, 38.06813], [-122.18341, 38.06838], [-122.18384, 38.0678], [-122.18561, 38.0686], [-122.1866, 38.06731], [-122.18914, 38.06872], [-122.18993, 38.0674], [-122.19034, 38.06692], [-122.19093, 38.06682], [-122.19118, 38.06644], [-122.19119, 38.06639], [-122.1918, 38.06559], [-122.19194, 38.06466], [-122.19236, 38.06408], [-122.19239, 38.06333], [-122.19228, 38.06204], [-122.19361, 38.06026], [-122.19408, 38.05999], [-122.19424, 38.05993], [-122.1944, 38.05996], [-122.19486, 38.06042], [-122.19502, 38.06052], [-122.19516, 38.06059], [-122.19551, 38.0607], [-122.19587, 38.06077], [-122.19609, 38.06067], [-122.19627, 38.06056], [-122.19657, 38.06057], [-122.19692, 38.06052], [-122.19723, 38.06058], [-122.19755, 38.06079], [-122.19789, 38.06093], [-122.19823, 38.06091], [-122.1984, 38.06079], [-122.19852, 38.06084], [-122.19895, 38.0609], [-122.19947, 38.06108], [-122.19975, 38.06107], [-122.19986, 38.0611], [-122.20001, 38.06125], [-122.20032, 38.06145], [-122.20055, 38.06153], [-122.20071, 38.0619], [-122.20079, 38.06191], [-122.20082, 38.06201], [-122.20099, 38.06221], [-122.20105, 38.06235], [-122.20116, 38.06247], [-122.20123, 38.06259], [-122.20113, 38.0628], [-122.20116, 38.063], [-122.2012, 38.0631], [-122.20118, 38.06333], [-122.20122, 38.06344], [-122.20118, 38.06396], [-122.20118, 38.06409], [-122.20116, 38.06421], [-122.20107, 38.06429], [-122.20107, 38.0644], [-122.20135, 38.06461], [-122.20164, 38.0646], [-122.20192, 38.0645], [-122.20212, 38.06427], [-122.20224, 38.06426], [-122.20238, 38.06432], [-122.20259, 38.06429], [-122.20282, 38.06419], [-122.20308, 38.0639], [-122.20319, 38.0639], [-122.20324, 38.06403], [-122.20328, 38.06484], [-122.20318, 38.06503], [-122.20328, 38.06524], [-122.20342, 38.06537], [-122.20372, 38.06547], [-122.20407, 38.06569], [-122.2041, 38.06609], [-122.20468, 38.0666], [-122.20487, 38.06665], [-122.20499, 38.06686], [-122.2051, 38.06699], [-122.2051, 38.06835]]]}	Open Access 1	18815	Benicia State Recreation Area	1433	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=476	Solano 26	456.027	Benicia SRA	1957	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]);