calands: units_with_maps: 1 row where ACCESS_TYP = 3, MNG_AGENCY = 87 and YR

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

1 row where ACCESS_TYP = 3, MNG_AGENCY = 87 and YR_EST = 1973

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
10558	10558	10557	{"type": "MultiPolygon", "coordinates": [[[[-122.3584, 37.99815], [-122.3514, 38.00338], [-122.3432, 38.00298], [-122.3431, 38.00652], [-122.3341, 38.0034], [-122.33203, 38.00348], [-122.33018, 38.00185], [-122.33075, 38.00159], [-122.33063, 38.00144], [-122.33068, 38.00136], [-122.33156, 38.00108], [-122.33262, 38.00088], [-122.33307, 38.00074], [-122.33462, 38.00065], [-122.33713, 38.00098], [-122.343, 38.0022], [-122.34362, 38.00221], [-122.34473, 38.00242], [-122.34604, 38.00263], [-122.3473, 38.00261], [-122.34911, 38.00227], [-122.35048, 38.00189], [-122.352, 38.00125], [-122.35365, 38.00032], [-122.35429, 37.99963], [-122.35457, 37.99936], [-122.35501, 37.99873], [-122.35571, 37.99794], [-122.35628, 37.99668], [-122.35627, 37.99661], [-122.35664, 37.99496], [-122.35667, 37.99491], [-122.35808, 37.995], [-122.3584, 37.99815]]], [[[-122.38412, 37.98233], [-122.38176, 37.98429], [-122.38018, 37.98429], [-122.38017, 37.98427], [-122.36415, 37.98434], [-122.36416, 37.98461], [-122.36294, 37.9865], [-122.36255, 37.9879], [-122.36111, 37.98801], [-122.35766, 37.98815], [-122.35779, 37.98666], [-122.35742, 37.9869], [-122.35781, 37.98254], [-122.35828, 37.98255], [-122.35836, 37.98174], [-122.3584, 37.98174], [-122.35861, 37.97938], [-122.35857, 37.97937], [-122.35861, 37.97896], [-122.36439, 37.97928], [-122.36468, 37.97908], [-122.36508, 37.9791], [-122.36508, 37.97853], [-122.36776, 37.97952], [-122.36772, 37.97971], [-122.36696, 37.98042], [-122.36961, 37.98235], [-122.38412, 37.98233]]], [[[-122.35842, 37.97873], [-122.35809, 37.98233], [-122.35783, 37.98232], [-122.35807, 37.97951], [-122.35817, 37.97871], [-122.35842, 37.97873]]]]}	No Public Access 3	18800	Point Pinole Regional Shoreline	23856	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	402.003	Point Pinole Reg. Shoreline	1973	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]);