calands: units_with_maps: 2 rows where COUNTY = 4, DES_TP = 65 and MNG_AG

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

2 rows where COUNTY = 4, DES_TP = 65 and MNG_AG_TYP = 20

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
5266	5266	5265	{"type": "Polygon", "coordinates": [[[-117.35459, 33.20901], [-117.35406, 33.21043], [-117.35407, 33.21045], [-117.35412, 33.21045], [-117.3539, 33.21053], [-117.35388, 33.21048], [-117.35389, 33.21042], [-117.35409, 33.20978], [-117.35417, 33.20964], [-117.35418, 33.20959], [-117.35417, 33.20953], [-117.35411, 33.20946], [-117.35404, 33.20943], [-117.35393, 33.20943], [-117.35337, 33.20918], [-117.35314, 33.20899], [-117.35395, 33.20875], [-117.35416, 33.20875], [-117.35447, 33.20877], [-117.35455, 33.20899], [-117.35459, 33.20901]]]}	Open Access 1	949	North County Humane Society and SPCA Dog Park	29112	3361	San Diego Humane Society and SPCA 803	Non Profit 6	Non Profit - Other 22	http://www.sdhumane.org/	Non Governmental Organization 10	3361	San Diego Humane Society and SPCA 783	Non Profit 6	Non Profit - Other 20	http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/dogpark.asp	San Diego 4	2.32	North County Humane Society and SPCA Dog Park	0	Private Recreation or Education 65	4
7613	7613	7612	{"type": "MultiPolygon", "coordinates": [[[[-116.98432, 32.76701], [-116.98411, 32.76731], [-116.98404, 32.76739], [-116.98377, 32.76752], [-116.9836, 32.76758], [-116.98348, 32.76759], [-116.98317, 32.76758], [-116.98293, 32.76749], [-116.98281, 32.76741], [-116.98257, 32.76721], [-116.9825, 32.7671], [-116.9825, 32.76698], [-116.98252, 32.76694], [-116.98265, 32.76674], [-116.98268, 32.76671], [-116.9829, 32.76674], [-116.98319, 32.76662], [-116.98334, 32.7666], [-116.98362, 32.76663], [-116.98411, 32.76677], [-116.98423, 32.76685], [-116.98432, 32.76701]]], [[[-116.98313, 32.76651], [-116.98288, 32.76661], [-116.98266, 32.76658], [-116.98257, 32.76662], [-116.98253, 32.76666], [-116.98238, 32.76693], [-116.98236, 32.76703], [-116.98238, 32.76715], [-116.98245, 32.76726], [-116.98277, 32.76752], [-116.98302, 32.76765], [-116.98294, 32.76763], [-116.98228, 32.76735], [-116.98219, 32.76715], [-116.98236, 32.76689], [-116.98254, 32.76651], [-116.98266, 32.76646], [-116.98313, 32.76651]]], [[[-116.98413, 32.76749], [-116.98404, 32.76755], [-116.98385, 32.76773], [-116.98381, 32.76769], [-116.98369, 32.76768], [-116.98333, 32.76772], [-116.98326, 32.7677], [-116.9835, 32.7677], [-116.98373, 32.76766], [-116.98405, 32.76752], [-116.98412, 32.76747], [-116.98413, 32.76749]]], [[[-116.98087, 32.76954], [-116.98087, 32.76954], [-116.98049, 32.76998], [-116.9807, 32.7694], [-116.98087, 32.76954]]], [[[-116.98059, 32.7693], [-116.98028, 32.77017], [-116.98022, 32.77025], [-116.98028, 32.77002], [-116.98028, 32.76978], [-116.98025, 32.76951], [-116.98022, 32.76942], [-116.98014, 32.76934], [-116.98008, 32.76931], [-116.97977, 32.76924], [-116.97988, 32.76911], [-116.98017, 32.76898], [-116.98059, 32.7693]]], [[[-116.98014, 32.76944], [-116.98017, 32.76955], [-116.9802, 32.76977], [-116.9802, 32.76996], [-116.98018, 32.77009], [-116.98013, 32.77025], [-116.98007, 32.77023], [-116.97955, 32.76984], [-116.97941, 32.76978], [-116.97929, 32.76976], [-116.97953, 32.76954], [-116.97972, 32.7693], [-116.98004, 32.76937], [-116.98014, 32.76944]]], [[[-116.98007, 32.77041], [-116.97968, 32.77033], [-116.97914, 32.77013], [-116.97923, 32.76989], [-116.97934, 32.7699], [-116.97948, 32.76997], [-116.98007, 32.77041]]]]}	Open Access 1	7353	Mt. Helix Park	22579	3024	Foundation for Preservation of Mt. Helix Nature Theatre 874	Non Profit 6	Non Profit - Other 22	http://www.mthelixpark.org/	Non Governmental Organization 10	3024	Foundation for Preservation of Mt. Helix Nature Theatre 852	Non Profit 6	Non Profit - Other 20	https://www.mthelixpark.org/	San Diego 4	6.584	Mt. Helix Park	0	Private Recreation or Education 65	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]);