calands: units_with_maps: 1 row where ACCESS_TYP = 1, DES_TP = 652 and MNG_AG

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

1 row where ACCESS_TYP = 1, DES_TP = 652 and MNG_AG_TYP = 2

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
7824	7824	7823	{"type": "Polygon", "coordinates": [[[-122.48429, 37.59997], [-122.48425, 37.601], [-122.48421, 37.60101], [-122.4842, 37.60205], [-122.48412, 37.602], [-122.48403, 37.60201], [-122.48397, 37.60205], [-122.48394, 37.60211], [-122.48396, 37.60216], [-122.48402, 37.60223], [-122.48411, 37.60228], [-122.4842, 37.6023], [-122.48415, 37.60367], [-122.48402, 37.60963], [-122.48335, 37.60962], [-122.48332, 37.61013], [-122.48313, 37.61014], [-122.4831, 37.6103], [-122.48256, 37.6103], [-122.48249, 37.6119], [-122.48246, 37.6119], [-122.48238, 37.61232], [-122.48272, 37.61233], [-122.48273, 37.61229], [-122.48315, 37.61229], [-122.48314, 37.61277], [-122.48303, 37.61278], [-122.48252, 37.61276], [-122.48199, 37.61266], [-122.48134, 37.61243], [-122.48126, 37.61234], [-122.48116, 37.61227], [-122.48103, 37.61221], [-122.48089, 37.61218], [-122.48074, 37.61218], [-122.48061, 37.61219], [-122.48047, 37.61224], [-122.48036, 37.61231], [-122.47961, 37.6123], [-122.47909, 37.6122], [-122.47875, 37.61208], [-122.47859, 37.6119], [-122.47827, 37.6117], [-122.47848, 37.6108], [-122.4789, 37.61085], [-122.4794, 37.60871], [-122.47855, 37.60858], [-122.47861, 37.60831], [-122.47826, 37.60826], [-122.47819, 37.60853], [-122.47751, 37.60844], [-122.47713, 37.61021], [-122.47686, 37.61018], [-122.47657, 37.61147], [-122.47641, 37.61149], [-122.47635, 37.61155], [-122.47618, 37.61162], [-122.47618, 37.61166], [-122.47533, 37.61154], [-122.47481, 37.61139], [-122.47418, 37.6113], [-122.47403, 37.61126], [-122.47349, 37.61072], [-122.47378, 37.61056], [-122.47373, 37.61048], [-122.47355, 37.60974], [-122.47356, 37.60954], [-122.47386, 37.60909], [-122.47364, 37.60881], [-122.47337, 37.60872], [-122.47302, 37.60882], [-122.47276, 37.60919], [-122.47259, 37.60927], [-122.47174, 37.60903], [-122.47143, 37.60916], [-122.47171, 37.60937], [-122.47166, 37.60941], [-122.4714, 37.60922], [-122.47045, 37.60878], [-122.47613, 37.59749], [-122.47623, 37.59759], [-122.47619, 37.59761], [-122.4766, 37.59832], [-122.4769, 37.59821], [-122.4777, 37.59904], [-122.47843, 37.59869], [-122.478, 37.59788], [-122.47832, 37.59775], [-122.47897, 37.59755], [-122.47939, 37.59738], [-122.48018, 37.59787], [-122.48024, 37.5982], [-122.48026, 37.59853], [-122.47991, 37.59846], [-122.47966, 37.59844], [-122.47941, 37.59848], [-122.47918, 37.59856], [-122.47898, 37.59869], [-122.47859, 37.5992], [-122.47859, 37.59922], [-122.47939, 37.59952], [-122.47966, 37.59916], [-122.48033, 37.59932], [-122.4805, 37.59928], [-122.48076, 37.59944], [-122.48085, 37.59934], [-122.48093, 37.59923], [-122.48122, 37.59929], [-122.48122, 37.59937], [-122.48191, 37.59934], [-122.4822, 37.59946], [-122.48364, 37.59971], [-122.48359, 37.59995], [-122.48429, 37.59997]]]}	Open Access 1	9277	Sweeney Ridge	8294	1239	Pacifica, City of 409	City 2	City Agency 2	http://www.cityofpacifica.org/depts/rec_department/default.asp	City 2	1239	Pacifica, City of 403	City 2	City Agency 2	http://www.cityofpacifica.org/depts/rec_department/parksbeaches/beach_and_park_info_and_rules/sweeny/default.asp	San Mateo 15	327.796	Sweeney Ridge		None 652

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