calands: units_with_maps: 1 row where AGNCY_NAME = 391, DES_TP = 3 and MNG

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

1 row where AGNCY_NAME = 391, DES_TP = 3 and MNG_AGENCY = 174

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
15049	15049	15048	{"type": "Polygon", "coordinates": [[[-121.9967, 37.94255], [-121.99652, 37.94296], [-121.99619, 37.94352], [-121.99599, 37.944], [-121.99537, 37.94451], [-121.99465, 37.94464], [-121.99464, 37.94497], [-121.99426, 37.94561], [-121.99346, 37.9464], [-121.99311, 37.94657], [-121.99268, 37.94675], [-121.99238, 37.94686], [-121.99217, 37.94691], [-121.99194, 37.94667], [-121.99167, 37.9465], [-121.99143, 37.9464], [-121.99077, 37.9462], [-121.99081, 37.94611], [-121.99076, 37.94605], [-121.99073, 37.9459], [-121.9907, 37.94582], [-121.99051, 37.94563], [-121.99045, 37.94559], [-121.9903, 37.94545], [-121.99018, 37.94531], [-121.99012, 37.94508], [-121.99016, 37.94486], [-121.99012, 37.94479], [-121.99013, 37.94474], [-121.99022, 37.9447], [-121.9903, 37.94468], [-121.99027, 37.94462], [-121.99012, 37.94448], [-121.99008, 37.94449], [-121.99007, 37.94448], [-121.99006, 37.9444], [-121.99008, 37.94433], [-121.99014, 37.94426], [-121.99015, 37.94399], [-121.99013, 37.94387], [-121.99016, 37.94372], [-121.99014, 37.94368], [-121.99019, 37.94348], [-121.98994, 37.94317], [-121.98738, 37.9429], [-121.98721, 37.94315], [-121.98689, 37.94316], [-121.98665, 37.94352], [-121.98598, 37.94379], [-121.98467, 37.94399], [-121.98418, 37.93722], [-121.98166, 37.93529], [-121.98283, 37.93445], [-121.98246, 37.93314], [-121.98159, 37.93253], [-121.98162, 37.93214], [-121.98193, 37.93191], [-121.9967, 37.94255]]]}	Open Access 1	45720	Lime Ridge Open Space	14664	1066	Concord, City of 391	City 2	City Agency 2	http://www.ci.concord.ca.us/page.asp?pid=3002	City 2	1371	Walnut Creek, City of 174	City 2	City Agency 2	http://www.walnut-creek.org/citygov/depts/ps/openspace/limeridge.asp	Contra Costa 12	208.851	Lime Ridge OS	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]);