calands: units_with_maps: 2 rows where DES_TP = 3 and MNG

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

2 rows where DES_TP = 3 and MNG_AGENCY = 417

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
10494	10494	10493	{"type": "Polygon", "coordinates": [[[-120.63498, 35.13975], [-120.63483, 35.13986], [-120.63297, 35.1412], [-120.63286, 35.13966], [-120.63285, 35.13965], [-120.63273, 35.13972], [-120.63268, 35.13915], [-120.63297, 35.13913], [-120.63473, 35.13962], [-120.63498, 35.13975]]]}	Open Access 1	18600	Pismo Beach Sports Park	23746	1253	Pismo Beach, City of 423	City 2	City Agency 2	http://www.pismobeach.org/69/Parks-Halls	City 2	1253	Pismo Beach, City of 417	City 2	City Agency 2		San Luis Obispo 1	5.906	Pismo Beach Sports Park	0	Local Recreation Area 3	4
10503	10503	10502	{"type": "Polygon", "coordinates": [[[-120.7155, 35.17647], [-120.71532, 35.17671], [-120.71502, 35.17656], [-120.71492, 35.17653], [-120.71464, 35.17652], [-120.7144, 35.17646], [-120.71298, 35.17625], [-120.71214, 35.17602], [-120.712, 35.17597], [-120.71183, 35.17586], [-120.7115, 35.17559], [-120.71136, 35.17551], [-120.71117, 35.17544], [-120.71042, 35.1753], [-120.70961, 35.17522], [-120.70837, 35.17482], [-120.70817, 35.17477], [-120.70797, 35.17475], [-120.70779, 35.17475], [-120.70738, 35.17481], [-120.70727, 35.17481], [-120.70726, 35.17476], [-120.70732, 35.17476], [-120.70733, 35.17474], [-120.70729, 35.1747], [-120.70724, 35.17469], [-120.70745, 35.17424], [-120.70747, 35.17424], [-120.70734, 35.17411], [-120.70737, 35.17408], [-120.70761, 35.1742], [-120.70781, 35.17421], [-120.70781, 35.17419], [-120.70761, 35.17404], [-120.7077, 35.17404], [-120.70804, 35.17422], [-120.70812, 35.17423], [-120.70841, 35.17436], [-120.70857, 35.17448], [-120.70863, 35.17455], [-120.7089, 35.17474], [-120.70902, 35.1748], [-120.70923, 35.17481], [-120.70935, 35.17487], [-120.70968, 35.17501], [-120.7098, 35.17501], [-120.70979, 35.1749], [-120.70988, 35.17483], [-120.70993, 35.17472], [-120.70998, 35.17474], [-120.71015, 35.17471], [-120.71035, 35.17475], [-120.71045, 35.17483], [-120.71073, 35.17479], [-120.71088, 35.17466], [-120.71091, 35.17458], [-120.71088, 35.17451], [-120.71095, 35.17448], [-120.71105, 35.17449], [-120.71117, 35.17458], [-120.71157, 35.17478], [-120.71154, 35.17481], [-120.71163, 35.17486], [-120.71165, 35.17492], [-120.71177, 35.17498], [-120.71177, 35.17501], [-120.71187, 35.17512], [-120.71176, 35.17514], [-120.71177, 35.17519], [-120.71185, 35.17518], [-120.71195, 35.17539], [-120.71185, 35.17562], [-120.71195, 35.17576], [-120.71292, 35.17611], [-120.7146, 35.17641], [-120.7155, 35.17647]]]}	Open Access 1	18624	Bluff Coastal Trail	16196	1253	Pismo Beach, City of 423	City 2	City Agency 2	http://www.pismobeach.org/69/Parks-Halls	City 2	1253	Pismo Beach, City of 417	City 2	City Agency 2		San Luis Obispo 1	7.316	Bluff Coastal 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]);