calands: units_with_maps: 1 row where ACCESS_TYP = 1 and DES

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

1 row where ACCESS_TYP = 1 and DES_TP = 436

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
5345	5345	5344	{"type": "MultiPolygon", "coordinates": [[[[-122.04487, 37.92375], [-122.04325, 37.92444], [-122.04241, 37.92353], [-122.04218, 37.92331], [-122.04209, 37.92319], [-122.04195, 37.92293], [-122.04189, 37.92273], [-122.04178, 37.92279], [-122.04185, 37.92185], [-122.04078, 37.92068], [-122.04106, 37.92052], [-122.04106, 37.92051], [-122.03841, 37.9195], [-122.03811, 37.91916], [-122.03924, 37.91785], [-122.03932, 37.91782], [-122.03941, 37.91784], [-122.03962, 37.91803], [-122.04028, 37.91877], [-122.04032, 37.91875], [-122.04487, 37.92375]]], [[[-122.04196, 37.91688], [-122.04194, 37.91691], [-122.04095, 37.91792], [-122.04082, 37.91802], [-122.04059, 37.91816], [-122.04027, 37.91831], [-122.04019, 37.91831], [-122.03987, 37.91791], [-122.04019, 37.91754], [-122.04019, 37.91742], [-122.04029, 37.91742], [-122.04039, 37.91729], [-122.04039, 37.91708], [-122.04118, 37.91707], [-122.04118, 37.91678], [-122.04144, 37.9167], [-122.04154, 37.91658], [-122.04178, 37.91672], [-122.04195, 37.91684], [-122.04196, 37.91688]]], [[[-122.04523, 37.9226], [-122.04449, 37.92314], [-122.04043, 37.91869], [-122.04047, 37.91866], [-122.04035, 37.91851], [-122.04036, 37.91847], [-122.04085, 37.91822], [-122.04112, 37.91802], [-122.04213, 37.917], [-122.04221, 37.917], [-122.04255, 37.91718], [-122.04367, 37.91785], [-122.04396, 37.918], [-122.04433, 37.9181], [-122.04452, 37.91813], [-122.04491, 37.91814], [-122.04513, 37.91812], [-122.04508, 37.91841], [-122.04509, 37.9188], [-122.04521, 37.91903], [-122.04491, 37.92074], [-122.04461, 37.921], [-122.0449, 37.92177], [-122.04519, 37.92216], [-122.04523, 37.9226]]], [[[-122.04699, 37.92134], [-122.04543, 37.92246], [-122.04539, 37.92211], [-122.0451, 37.92171], [-122.04484, 37.92104], [-122.04506, 37.92086], [-122.04539, 37.91901], [-122.04529, 37.91881], [-122.04526, 37.91874], [-122.04525, 37.91842], [-122.04531, 37.91811], [-122.04552, 37.919], [-122.04544, 37.91906], [-122.04698, 37.92067], [-122.04661, 37.92093], [-122.04699, 37.92134]]]]}	Open Access 1	16911	Heather Farms	19781	1371	Walnut Creek, City of 178	City 2	City Agency 2	http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp	City 2	1371	Walnut Creek, City of 174	City 2	City Agency 2		Contra Costa 12	76.728	Heather Farms		None 436

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]);