calands: units_with_maps: 3 rows where ACCESS_TYP = 1, DES_TP = 3 and MNG

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

3 rows where ACCESS_TYP = 1, DES_TP = 3 and MNG_AGENCY = 350

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	DES_TP	GAP_STS
12828	12828	12827	{"type": "Polygon", "coordinates": [[[-117.58625, 33.44551], [-117.58557, 33.44622], [-117.58549, 33.44617], [-117.58496, 33.44596], [-117.58428, 33.44582], [-117.58375, 33.44578], [-117.58067, 33.44586], [-117.58103, 33.44459], [-117.58195, 33.44112], [-117.58257, 33.44124], [-117.58285, 33.44132], [-117.5832, 33.44145], [-117.58339, 33.44165], [-117.58327, 33.44187], [-117.58437, 33.44285], [-117.58523, 33.44342], [-117.58538, 33.4436], [-117.5855, 33.44492], [-117.58594, 33.44501], [-117.58607, 33.44511], [-117.58625, 33.44551]]]}	Open Access 1	30277	Richard T. Steed Memorial Park/ Sports Park	24327	1296	San Clemente, City of 353	City 2	City Agency 2	http://ci.san-clemente.ca.us/recreation-community	City 2	1296	San Clemente, City of 350	City 2	City Agency 2		Orange 3	41.789	Richard T. Steed Memorial Park/ Sports Park	Local Recreation Area 3	4
13496	13496	13495	{"type": "Polygon", "coordinates": [[[-117.61267, 33.45818], [-117.61235, 33.45862], [-117.61242, 33.45866], [-117.6122, 33.45896], [-117.61217, 33.45895], [-117.61187, 33.45933], [-117.61189, 33.45935], [-117.61164, 33.45962], [-117.61136, 33.45988], [-117.61091, 33.46023], [-117.61058, 33.46044], [-117.61005, 33.46072], [-117.6077, 33.46174], [-117.60716, 33.462], [-117.60666, 33.4623], [-117.60562, 33.46305], [-117.60511, 33.4634], [-117.60478, 33.4636], [-117.60468, 33.46358], [-117.60409, 33.46281], [-117.60379, 33.46232], [-117.60362, 33.46197], [-117.60347, 33.4616], [-117.60329, 33.46104], [-117.60325, 33.46083], [-117.6033, 33.46081], [-117.60311, 33.45993], [-117.60308, 33.45981], [-117.60303, 33.45981], [-117.60295, 33.45954], [-117.60303, 33.45951], [-117.60297, 33.45933], [-117.60275, 33.45878], [-117.60266, 33.4588], [-117.60234, 33.4582], [-117.61267, 33.45818]]]}	Open Access 1	48826	Vista Hermosa Sports Park	33545	1296	San Clemente, City of 353	City 2	City Agency 2	http://ci.san-clemente.ca.us/recreation-community	City 2	1296	San Clemente, City of 350	City 2	City Agency 2	https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/61/2783	Orange 3	80.721	Vista Hermosa Sports Park	Local Recreation Area 3	4
13544	13544	13543	{"type": "Polygon", "coordinates": [[[-117.63464, 33.44433], [-117.63368, 33.44513], [-117.63359, 33.44529], [-117.63357, 33.44527], [-117.63343, 33.44529], [-117.63333, 33.44533], [-117.63317, 33.44552], [-117.63307, 33.44557], [-117.63301, 33.44552], [-117.63294, 33.44537], [-117.63296, 33.44526], [-117.63278, 33.44448], [-117.63247, 33.44421], [-117.63228, 33.44418], [-117.63214, 33.44405], [-117.63214, 33.444], [-117.63222, 33.44385], [-117.63236, 33.44332], [-117.6324, 33.44296], [-117.63253, 33.44286], [-117.63261, 33.44289], [-117.63314, 33.4433], [-117.63313, 33.44335], [-117.63427, 33.4443], [-117.63438, 33.44434], [-117.63448, 33.44433], [-117.63456, 33.44428], [-117.63464, 33.44433]]]}	Open Access 1	48827	Jim Johnson Memorial Sports Park	33546	6132	Marblehead Development Partners LLC 1045	Private 7	Home Owners Association 16		Private 14	1296	San Clemente, City of 350	City 2	City Agency 2	https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/187/2783	Orange 3	7.375	Jim Johnson Memorial Sports Park	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]);