calands: units_with_maps: 1 row where ACCESS_TYP = 1, DES_TP = 2 and LABEL

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

1 row where ACCESS_TYP = 1, DES_TP = 2 and LABEL_NAME = "Salt Creek Beach County Park"

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
7930	7930	7929	{"type": "MultiPolygon", "coordinates": [[[[-117.72548, 33.48131], [-117.72452, 33.48145], [-117.72446, 33.48119], [-117.72395, 33.48016], [-117.72398, 33.48012], [-117.72336, 33.4795], [-117.72333, 33.47941], [-117.72336, 33.47868], [-117.72328, 33.47868], [-117.7231, 33.47813], [-117.72161, 33.47762], [-117.72145, 33.47746], [-117.72125, 33.47718], [-117.72108, 33.47707], [-117.72086, 33.47699], [-117.72064, 33.477], [-117.72041, 33.47707], [-117.72027, 33.47717], [-117.72021, 33.47724], [-117.72008, 33.47735], [-117.71991, 33.47743], [-117.71975, 33.47747], [-117.71969, 33.47754], [-117.71966, 33.47731], [-117.71958, 33.47706], [-117.71949, 33.47687], [-117.71933, 33.47657], [-117.71958, 33.4764], [-117.71972, 33.47633], [-117.72017, 33.47617], [-117.72059, 33.47608], [-117.7207, 33.47603], [-117.72075, 33.47598], [-117.72104, 33.47614], [-117.72111, 33.47614], [-117.72116, 33.47612], [-117.72125, 33.47604], [-117.72131, 33.47596], [-117.72133, 33.47589], [-117.72132, 33.4755], [-117.72116, 33.47511], [-117.72109, 33.47457], [-117.72114, 33.47428], [-117.72126, 33.47406], [-117.72131, 33.47375], [-117.72119, 33.47355], [-117.72083, 33.47339], [-117.72013, 33.47303], [-117.72003, 33.47295], [-117.71995, 33.47282], [-117.71983, 33.4727], [-117.71982, 33.47267], [-117.71986, 33.47266], [-117.71988, 33.47253], [-117.71864, 33.47072], [-117.7178, 33.46933], [-117.71763, 33.46924], [-117.71756, 33.46924], [-117.71756, 33.46918], [-117.71684, 33.46918], [-117.7166, 33.46927], [-117.71639, 33.4692], [-117.71607, 33.46922], [-117.71542, 33.46922], [-117.71549, 33.46914], [-117.71813, 33.46914], [-117.71825, 33.46933], [-117.71846, 33.46972], [-117.71862, 33.46995], [-117.71874, 33.47021], [-117.71884, 33.47034], [-117.71889, 33.4705], [-117.71908, 33.47069], [-117.71912, 33.47079], [-117.71927, 33.47101], [-117.71934, 33.47104], [-117.71953, 33.47137], [-117.71964, 33.47151], [-117.71968, 33.4716], [-117.71982, 33.47167], [-117.71991, 33.47185], [-117.72032, 33.47209], [-117.72052, 33.47231], [-117.72061, 33.47247], [-117.72071, 33.4728], [-117.72084, 33.47289], [-117.72098, 33.47317], [-117.72118, 33.47329], [-117.72146, 33.47342], [-117.72154, 33.47348], [-117.72165, 33.47365], [-117.7219, 33.47424], [-117.7219, 33.47428], [-117.72206, 33.47454], [-117.72209, 33.47468], [-117.72216, 33.47477], [-117.72219, 33.47493], [-117.72228, 33.47503], [-117.72242, 33.4754], [-117.72265, 33.47591], [-117.72271, 33.47605], [-117.72272, 33.47626], [-117.72279, 33.47633], [-117.72304, 33.47688], [-117.72319, 33.47707], [-117.72322, 33.47719], [-117.72335, 33.47734], [-117.72352, 33.47769], [-117.7238, 33.47848], [-117.72397, 33.47877], [-117.72404, 33.47905], [-117.72416, 33.47929], [-117.72436, 33.47984], [-117.72446, 33.48001], [-117.72456, 33.48027], [-117.72466, 33.48044], [-117.72479, 33.48074], [-117.72483, 33.48079], [-117.72493, 33.48082], [-117.72513, 33.48102], [-117.72535, 33.48114], [-117.72548, 33.48131]]], [[[-117.71875, 33.47865], [-117.71714, 33.47625], [-117.71803, 33.47583], [-117.7184, 33.47602], [-117.71861, 33.47614], [-117.71883, 33.47632], [-117.719, 33.47648], [-117.71911, 33.47661], [-117.71928, 33.47687], [-117.71941, 33.47716], [-117.71946, 33.47732], [-117.71951, 33.47762], [-117.71951, 33.47784], [-117.71949, 33.47813], [-117.71943, 33.4783], [-117.71937, 33.47839], [-117.71919, 33.47853], [-117.7189, 33.47866], [-117.71875, 33.47865]]], [[[-117.72425, 33.4818], [-117.72336, 33.48334], [-117.7219, 33.48208], [-117.72357, 33.48188], [-117.72425, 33.4818]]]]}	Open Access 1	10745	Salt Creek Beach County Park	24808	312	Orange, County of 142	County 3	County Agency 3	http://ocparks.com/	County 3	312	Orange, County of 138	County 3	County Agency 3		Orange 3	44.889	Salt Creek Beach County Park	0	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]);