calands: units_with_maps: 3 rows where ACCESS_TYP = 1, MNG_AGENCY = 87, MNG_AG_TYP = 4 and YR

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

3 rows where ACCESS_TYP = 1, MNG_AGENCY = 87, MNG_AG_TYP = 4 and YR_EST = 1979

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
3621	3621	3620	{"type": "Polygon", "coordinates": [[[-122.13468, 38.02843], [-122.13427, 38.02977], [-122.13074, 38.03157], [-122.13026, 38.02906], [-122.13025, 38.02905], [-122.12946, 38.02945], [-122.12902, 38.02716], [-122.12945, 38.02692], [-122.13129, 38.02602], [-122.13153, 38.02637], [-122.13293, 38.02824], [-122.13468, 38.02843]]]}	Open Access 1	29404	Martinez Regional Shoreline	21926	209	California State Lands Commission 75	State 5	State Agency 5	http://www.slc.ca.gov/	Other State 5	2032	East Bay Regional Park District 87	Special District 4	Recreation/Parks District 4		Contra Costa 12	38.97	Martinez Reg. Shoreline	1979	Local Park 2	4
8696	8696	8695	{"type": "Polygon", "coordinates": [[[-122.02966, 37.62069], [-122.01871, 37.62941], [-122.01871, 37.62942], [-122.02246, 37.63228], [-122.0221, 37.63231], [-122.02192, 37.63234], [-122.02155, 37.63254], [-122.02107, 37.63312], [-122.02099, 37.63319], [-122.02082, 37.6333], [-122.0206, 37.63337], [-122.02036, 37.6334], [-122.01999, 37.63334], [-122.01835, 37.63465], [-122.00459, 37.6266], [-121.99509, 37.62093], [-121.9847, 37.61209], [-121.98515, 37.61158], [-121.98543, 37.61115], [-121.98581, 37.61083], [-121.98657, 37.61036], [-121.98686, 37.60994], [-121.9874, 37.60964], [-121.98853, 37.60819], [-121.98873, 37.60765], [-121.98898, 37.60712], [-121.9893, 37.60667], [-121.98968, 37.60651], [-121.99071, 37.60657], [-121.99114, 37.60679], [-121.99168, 37.60677], [-121.99236, 37.60682], [-121.99303, 37.60698], [-121.99392, 37.60678], [-121.99462, 37.60647], [-121.99545, 37.60627], [-121.99612, 37.60636], [-121.99813, 37.60696], [-121.99866, 37.60759], [-121.99932, 37.60795], [-121.9996, 37.60824], [-121.9998, 37.60832], [-122.00069, 37.60807], [-122.00126, 37.60823], [-122.00147, 37.60805], [-122.00156, 37.60786], [-122.00199, 37.60801], [-122.00222, 37.60794], [-122.00265, 37.60778], [-122.00274, 37.60765], [-122.0029, 37.60751], [-122.00315, 37.60723], [-122.00323, 37.60694], [-122.00339, 37.60683], [-122.00356, 37.60676], [-122.00377, 37.60671], [-122.00418, 37.60666], [-122.00437, 37.60648], [-122.00438, 37.60634], [-122.00448, 37.60595], [-122.00471, 37.6058], [-122.00492, 37.60588], [-122.0053, 37.60597], [-122.00548, 37.60608], [-122.0057, 37.60612], [-122.00605, 37.60597], [-122.00612, 37.60586], [-122.00631, 37.60576], [-122.0065, 37.60578], [-122.00685, 37.60603], [-122.00709, 37.60607], [-122.00739, 37.60601], [-122.00768, 37.60605], [-122.00773, 37.60616], [-122.00788, 37.60626], [-122.00823, 37.60643], [-122.00839, 37.60637], [-122.00881, 37.60648], [-122.00897, 37.60655], [-122.00937, 37.60677], [-122.00953, 37.6069], [-122.00957, 37.60712], [-122.01008, 37.6076], [-122.01426, 37.60466], [-122.01698, 37.60711], [-122.01739, 37.60675], [-122.01802, 37.60732], [-122.01811, 37.60735], [-122.01821, 37.60734], [-122.01826, 37.60731], [-122.01959, 37.60614], [-122.01961, 37.6061], [-122.01961, 37.60607], [-122.01951, 37.60596], [-122.01951, 37.60592], [-122.01975, 37.60613], [-122.01781, 37.60785], [-122.0177, 37.60819], [-122.01778, 37.60816], [-122.0179, 37.60816], [-122.01802, 37.60826], [-122.01787, 37.60835], [-122.0179, 37.60853], [-122.01785, 37.60869], [-122.01791, 37.60901], [-122.01792, 37.60958], [-122.01783, 37.61006], [-122.01753, 37.61059], [-122.02163, 37.61353], [-122.02247, 37.61427], [-122.02311, 37.61381], [-122.02457, 37.61509], [-122.02417, 37.61531], [-122.02385, 37.61545], [-122.02384, 37.61547], [-122.02541, 37.61685], [-122.02714, 37.61842], [-122.02717, 37.61841], [-122.02684, 37.61864], [-122.02684, 37.61865], [-122.0275, 37.61927], [-122.02784, 37.61904], [-122.02966, 37.62069]]]}	Open Access 1	15804	Dry Creek Pioneer Regional Park	30359	2032	East Bay Regional Park District 89	Special District 4	Recreation/Parks District 4	http://www.ebparks.org/	Special District 4	2032	East Bay Regional Park District 87	Special District 4	Recreation/Parks District 4	http://www.ebparks.org/parks/garin	Alameda 17	1689.782	Dry Creek Pioneer RP	1979	Local Park 2	4
16838	16838	16837	{"type": "Polygon", "coordinates": [[[-122.15519, 38.02387], [-122.1543, 38.02375], [-122.1543, 38.02373], [-122.15255, 38.0231], [-122.1516, 38.02282], [-122.14632, 38.02195], [-122.14591, 38.02221], [-122.14464, 38.02239], [-122.14331, 38.0225], [-122.14233, 38.0228], [-122.1421, 38.02301], [-122.1419, 38.02371], [-122.14158, 38.0239], [-122.1412, 38.02127], [-122.14133, 38.02125], [-122.14126, 38.02072], [-122.14109, 38.02073], [-122.14103, 38.02129], [-122.14143, 38.02404], [-122.14141, 38.0241], [-122.14095, 38.02429], [-122.14094, 38.02472], [-122.14103, 38.02493], [-122.14141, 38.02511], [-122.14132, 38.02522], [-122.13962, 38.02572], [-122.13935, 38.02633], [-122.13934, 38.02631], [-122.1396, 38.02559], [-122.13894, 38.02423], [-122.13766, 38.02374], [-122.13687, 38.02213], [-122.13542, 38.02257], [-122.13565, 38.02304], [-122.13554, 38.02308], [-122.1357, 38.02341], [-122.13343, 38.02433], [-122.1322, 38.02474], [-122.13291, 38.02585], [-122.13329, 38.02598], [-122.13363, 38.02598], [-122.13502, 38.02592], [-122.13468, 38.02843], [-122.13293, 38.02824], [-122.13153, 38.02637], [-122.13026, 38.02453], [-122.13021, 38.02443], [-122.12934, 38.02331], [-122.1294, 38.02327], [-122.1304, 38.02284], [-122.13133, 38.02233], [-122.13166, 38.02212], [-122.13166, 38.02211], [-122.13146, 38.02191], [-122.13253, 38.0212], [-122.13279, 38.02104], [-122.13369, 38.0206], [-122.13464, 38.02023], [-122.13563, 38.01995], [-122.1364, 38.01979], [-122.13711, 38.01967], [-122.13729, 38.01961], [-122.13758, 38.01957], [-122.13838, 38.0206], [-122.14089, 38.02039], [-122.1409, 38.02034], [-122.14125, 38.02031], [-122.14128, 38.02045], [-122.14135, 38.02045], [-122.1414, 38.02065], [-122.14159, 38.02063], [-122.14156, 38.02044], [-122.1419, 38.02041], [-122.14193, 38.02051], [-122.14369, 38.02037], [-122.14357, 38.01952], [-122.14469, 38.01979], [-122.1457, 38.02009], [-122.14571, 38.02034], [-122.14705, 38.0208], [-122.14799, 38.02115], [-122.14799, 38.02118], [-122.14906, 38.02159], [-122.15007, 38.02213], [-122.15023, 38.02219], [-122.15164, 38.02253], [-122.15519, 38.02387]], [[-122.14467, 38.02086], [-122.14549, 38.02087], [-122.1455, 38.02022], [-122.14467, 38.02021], [-122.14465, 38.02085], [-122.14467, 38.02086]]]}	Open Access 1	17725	Martinez Regional Shoreline	21926	2032	East Bay Regional Park District 89	Special District 4	Recreation/Parks District 4	http://www.ebparks.org/	Special District 4	2032	East Bay Regional Park District 87	Special District 4	Recreation/Parks District 4		Contra Costa 12	154.743	Martinez Reg. Shoreline	1979	Local Park 2	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]);