calands: units_with_maps: 2 rows where DES_TP = 3, MNG_AGENCY = 87 and UNIT

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

2 rows where DES_TP = 3, MNG_AGENCY = 87 and UNIT_NAME = "Lafayette/Moraga Trail"

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
3646	3646	3645	{"type": "Polygon", "coordinates": [[[-122.09719, 37.88699], [-122.0967, 37.88654], [-122.09593, 37.88668], [-122.09517, 37.88629], [-122.09471, 37.88637], [-122.09407, 37.88659], [-122.09356, 37.88625], [-122.09322, 37.88618], [-122.0933, 37.88612], [-122.0934, 37.8861], [-122.09615, 37.88602], [-122.09669, 37.88602], [-122.09723, 37.88606], [-122.09727, 37.88609], [-122.09728, 37.88613], [-122.09719, 37.88664], [-122.09719, 37.88699]]]}	Open Access 1	29549	Lafayette/Moraga Trail	20836	300	Contra Costa County Public Works Dept., County of 429	County 3	County Agency - Other 9	http://www.co.contra-costa.ca.us/227/Public-Works	County 3	2032	East Bay Regional Park District 87	Special District 4	Recreation/Parks District 4		Contra Costa 12	4.276	Lafayette/Moraga Trail	0	Local Recreation Area 3	4
12621	12621	12620	{"type": "MultiPolygon", "coordinates": [[[[-122.10336, 37.88915], [-122.10325, 37.88929], [-122.09952, 37.88684], [-122.09906, 37.88657], [-122.09871, 37.8864], [-122.09832, 37.88626], [-122.09812, 37.88621], [-122.09789, 37.88617], [-122.09798, 37.88599], [-122.09846, 37.88612], [-122.09878, 37.88625], [-122.09907, 37.88638], [-122.09965, 37.88671], [-122.10336, 37.88915]]], [[[-122.1019, 37.86205], [-122.09983, 37.86557], [-122.09945, 37.86633], [-122.09932, 37.86665], [-122.0991, 37.8673], [-122.09905, 37.86718], [-122.09902, 37.86708], [-122.09902, 37.86693], [-122.09904, 37.86683], [-122.09942, 37.86591], [-122.09959, 37.86561], [-122.10171, 37.86198], [-122.1019, 37.86205]]], [[[-122.10312, 37.8574], [-122.10291, 37.8578], [-122.10264, 37.85858], [-122.10249, 37.85922], [-122.10222, 37.86073], [-122.10215, 37.86103], [-122.10202, 37.8614], [-122.10184, 37.86175], [-122.10186, 37.86166], [-122.10186, 37.86153], [-122.10177, 37.86092], [-122.10174, 37.86061], [-122.10175, 37.86053], [-122.1018, 37.86052], [-122.10189, 37.85867], [-122.10206, 37.85862], [-122.1022, 37.85863], [-122.10237, 37.85834], [-122.10243, 37.85804], [-122.10203, 37.85798], [-122.10216, 37.85747], [-122.10262, 37.85738], [-122.10272, 37.85714], [-122.10312, 37.8574]]], [[[-122.11101, 37.89088], [-122.11069, 37.89095], [-122.11037, 37.89099], [-122.11005, 37.89101], [-122.10971, 37.89099], [-122.10651, 37.89056], [-122.10567, 37.89038], [-122.10492, 37.89015], [-122.10424, 37.88986], [-122.10384, 37.88965], [-122.10339, 37.88938], [-122.10349, 37.88924], [-122.10392, 37.88949], [-122.10446, 37.88977], [-122.10501, 37.89], [-122.1057, 37.89022], [-122.1066, 37.8904], [-122.10953, 37.89081], [-122.10981, 37.89083], [-122.1101, 37.89084], [-122.1104, 37.89082], [-122.11069, 37.89078], [-122.11099, 37.89072], [-122.11101, 37.89088]]]]}	Open Access 1	29414	Lafayette/Moraga Trail	20836	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	14.096	Lafayette/Moraga Trail	0	Local Recreation Area 3	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]);