calands: units_with_maps: 9 rows where ACCESS_TYP = 1, AGNCY_NAME = 123, COUNTY = 4 and DES

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

9 rows where ACCESS_TYP = 1, AGNCY_NAME = 123, COUNTY = 4 and DES_TP = 3

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	COUNTY	ACRES	LABEL_NAME	DES_TP	GAP_STS
5072	5072	5071	{"type": "Polygon", "coordinates": [[[-117.29151, 33.13914], [-117.29094, 33.13994], [-117.29087, 33.14012], [-117.29095, 33.14017], [-117.29055, 33.14137], [-117.28899, 33.14036], [-117.28835, 33.14107], [-117.28758, 33.14058], [-117.28903, 33.13896], [-117.28987, 33.13949], [-117.29102, 33.13866], [-117.2913, 33.13893], [-117.29151, 33.13909], [-117.29151, 33.13914]]]}	Open Access 1	822	Business Park Recreation Facility (Zone 5)	30004	1045	Carlsbad, City of 123	City 2	City Agency 2	http://www.carlsbadca.gov/services/depts/parks/default.asp	City 2	1045	Carlsbad, City of 120	City 2	City Agency 2	San Diego 4	12.987	Business Park Rec. Facility (Zone 5)	Local Recreation Area 3	4
5215	5215	5214	{"type": "Polygon", "coordinates": [[[-117.34113, 33.15608], [-117.34183, 33.15694], [-117.34184, 33.15698], [-117.34182, 33.15701], [-117.34113, 33.15742], [-117.34108, 33.15742], [-117.34104, 33.1574], [-117.34033, 33.15654], [-117.34113, 33.15608]]]}	Open Access 1	816	Chase Field	17153	1045	Carlsbad, City of 123	City 2	City Agency 2	http://www.carlsbadca.gov/services/depts/parks/default.asp	City 2	1045	Carlsbad, City of 120	City 2	City Agency 2	San Diego 4	2.723	Chase Field	Local Recreation Area 3	4
6024	6024	6023	{"type": "Polygon", "coordinates": [[[-117.29374, 33.13929], [-117.29267, 33.1393], [-117.29229, 33.13926], [-117.29214, 33.13922], [-117.29185, 33.13912], [-117.29165, 33.139], [-117.29149, 33.13887], [-117.29129, 33.13865], [-117.2935, 33.13738], [-117.29374, 33.13929]]]}	Open Access 1	828	Business Park Recreation Facility	16541	1045	Carlsbad, City of 123	City 2	City Agency 2	http://www.carlsbadca.gov/services/depts/parks/default.asp	City 2	1045	Carlsbad, City of 120	City 2	City Agency 2	San Diego 4	7.167	Business Park Rec. Facility	Local Recreation Area 3	4
6087	6087	6086	{"type": "Polygon", "coordinates": [[[-117.30606, 33.10595], [-117.30582, 33.10598], [-117.30555, 33.10596], [-117.30562, 33.10551], [-117.30557, 33.10548], [-117.30521, 33.10539], [-117.30525, 33.105], [-117.30526, 33.10463], [-117.30605, 33.10448], [-117.30606, 33.10595]]]}	Open Access 1	1113	Batiquitos Drive Open Space	15863	1045	Carlsbad, City of 123	City 2	City Agency 2	http://www.carlsbadca.gov/services/depts/parks/default.asp	City 2	1045	Carlsbad, City of 120	City 2	City Agency 2	San Diego 4	2.468	Batiquitos Drive OS	Local Recreation Area 3	4
6129	6129	6128	{"type": "Polygon", "coordinates": [[[-117.30647, 33.10234], [-117.30617, 33.10247], [-117.30636, 33.10281], [-117.30617, 33.10282], [-117.30617, 33.10266], [-117.30508, 33.10086], [-117.30526, 33.1008], [-117.30538, 33.10115], [-117.3057, 33.10108], [-117.30542, 33.10119], [-117.30544, 33.10127], [-117.3055, 33.10135], [-117.30588, 33.10197], [-117.30617, 33.10185], [-117.30619, 33.10187], [-117.30588, 33.10201], [-117.30614, 33.10245], [-117.30645, 33.10232], [-117.30647, 33.10234]]]}	Open Access 1	1114	Batiquitos Drive Open Space	15863	1045	Carlsbad, City of 123	City 2	City Agency 2	http://www.carlsbadca.gov/services/depts/parks/default.asp	City 2	1045	Carlsbad, City of 120	City 2	City Agency 2	San Diego 4	0.715	Batiquitos Drive OS	Local Recreation Area 3	4
6130	6130	6129	{"type": "Polygon", "coordinates": [[[-117.30489, 33.1026], [-117.30484, 33.10263], [-117.30464, 33.10265], [-117.30424, 33.1026], [-117.30451, 33.10256], [-117.30459, 33.10251], [-117.30466, 33.10246], [-117.3047, 33.1024], [-117.30471, 33.1023], [-117.30467, 33.10201], [-117.30452, 33.10151], [-117.30442, 33.10129], [-117.30412, 33.10081], [-117.3039, 33.10085], [-117.30378, 33.10059], [-117.30402, 33.10049], [-117.30403, 33.10047], [-117.30422, 33.1004], [-117.30466, 33.10131], [-117.30467, 33.10135], [-117.30481, 33.10171], [-117.30487, 33.10193], [-117.30489, 33.10221], [-117.3049, 33.10257], [-117.30489, 33.1026]]]}	Open Access 1	1115	Batiquitos Drive Open Space	15863	1045	Carlsbad, City of 123	City 2	City Agency 2	http://www.carlsbadca.gov/services/depts/parks/default.asp	City 2	1045	Carlsbad, City of 120	City 2	City Agency 2	San Diego 4	1.598	Batiquitos Drive OS	Local Recreation Area 3	4
15816	15816	15815	{"type": "Polygon", "coordinates": [[[-117.30512, 33.09899], [-117.30508, 33.10086], [-117.30508, 33.10146], [-117.30497, 33.10125], [-117.30494, 33.10114], [-117.30486, 33.10098], [-117.30445, 33.1], [-117.30439, 33.09991], [-117.30399, 33.09898], [-117.30512, 33.09899]]]}	Open Access 1	1116	Batiquitos Drive Open Space	15863	1045	Carlsbad, City of 123	City 2	City Agency 2	http://www.carlsbadca.gov/services/depts/parks/default.asp	City 2	1045	Carlsbad, City of 120	City 2	City Agency 2	San Diego 4	3.566	Batiquitos Drive OS	Local Recreation Area 3	4
15820	15820	15819	{"type": "Polygon", "coordinates": [[[-117.30392, 33.09963], [-117.30353, 33.09976], [-117.30314, 33.09969], [-117.30324, 33.09954], [-117.30324, 33.09935], [-117.30314, 33.09914], [-117.30301, 33.09907], [-117.30276, 33.099], [-117.30287, 33.09898], [-117.30372, 33.09898], [-117.30392, 33.09963]]]}	Open Access 1	1117	Batiquitos Drive Open Space	15863	1045	Carlsbad, City of 123	City 2	City Agency 2	http://www.carlsbadca.gov/services/depts/parks/default.asp	City 2	1045	Carlsbad, City of 120	City 2	City Agency 2	San Diego 4	1.277	Batiquitos Drive OS	Local Recreation Area 3	4
16020	16020	16019	{"type": "Polygon", "coordinates": [[[-117.24719, 33.08498], [-117.24511, 33.08569], [-117.24483, 33.08511], [-117.24479, 33.08506], [-117.24465, 33.08473], [-117.24408, 33.08356], [-117.24396, 33.08316], [-117.24407, 33.08242], [-117.24407, 33.08146], [-117.24415, 33.08123], [-117.24416, 33.08092], [-117.24457, 33.08092], [-117.24442, 33.08125], [-117.24448, 33.08142], [-117.24468, 33.08178], [-117.24468, 33.08182], [-117.24491, 33.08223], [-117.24513, 33.0833], [-117.24532, 33.08363], [-117.24561, 33.08401], [-117.24598, 33.0844], [-117.24602, 33.08441], [-117.24619, 33.08461], [-117.24651, 33.08479], [-117.24719, 33.08498]]]}	Open Access 1	5079	La Costa Canyon Open Space	20752	1045	Carlsbad, City of 123	City 2	City Agency 2	http://www.carlsbadca.gov/services/depts/parks/default.asp	City 2	1045	Carlsbad, City of 120	City 2	City Agency 2	San Diego 4	12.952	La Costa Canyon OS	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]);