calands: units_with_maps: 8 rows where COUNTY = 4, DES_TP = 3 and MNG_AG

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

8 rows where COUNTY = 4, DES_TP = 3 and MNG_AG_ID = 1102

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
240	240	239	{"type": "Polygon", "coordinates": [[[-117.08384, 33.16747], [-117.08271, 33.16759], [-117.08326, 33.16655], [-117.08332, 33.16648], [-117.08345, 33.1664], [-117.08359, 33.16635], [-117.08368, 33.16634], [-117.08367, 33.16648], [-117.08368, 33.16662], [-117.08384, 33.16747]]]}	Open Access 1	645	City of Escondido Open Space	17312	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	2.034	City of Escondido OS	Local Recreation Area 3	4
1730	1730	1729	{"type": "Polygon", "coordinates": [[[-117.08435, 33.17012], [-117.08438, 33.17027], [-117.08433, 33.17032], [-117.082, 33.17124], [-117.08208, 33.17105], [-117.08221, 33.17108], [-117.08271, 33.17089], [-117.08333, 33.17055], [-117.0842, 33.17013], [-117.08435, 33.17012]]]}	Open Access 1	12924	City of Escondido Open Space	17312	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	0.911	City of Escondido OS	Local Recreation Area 3	4
4913	4913	4912	{"type": "Polygon", "coordinates": [[[-117.0835, 33.16545], [-117.08297, 33.16569], [-117.08281, 33.16578], [-117.08258, 33.16596], [-117.0824, 33.16616], [-117.0823, 33.16631], [-117.08099, 33.1689], [-117.08055, 33.16784], [-117.08057, 33.16783], [-117.0806, 33.16791], [-117.08073, 33.16802], [-117.08107, 33.16808], [-117.08126, 33.1679], [-117.0813, 33.16781], [-117.08104, 33.16772], [-117.08106, 33.16768], [-117.08136, 33.16777], [-117.08181, 33.16687], [-117.08187, 33.16673], [-117.0819, 33.16659], [-117.08189, 33.16635], [-117.0818, 33.16611], [-117.08154, 33.16625], [-117.08156, 33.16621], [-117.08344, 33.16511], [-117.0835, 33.16545]]]}	Open Access 1	12921	City of Escondido Open Space	17312	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	3.546	City of Escondido OS	Local Recreation Area 3	4
4915	4915	4914	{"type": "Polygon", "coordinates": [[[-117.08135, 33.16636], [-117.08112, 33.1665], [-117.08077, 33.16723], [-117.08057, 33.16742], [-117.08047, 33.16756], [-117.08057, 33.16782], [-117.08055, 33.16784], [-117.0802, 33.167], [-117.08128, 33.16637], [-117.08135, 33.16636]]]}	Open Access 1	12925	City of Escondido Open Space	17312	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	1.075	City of Escondido OS	Local Recreation Area 3	4
6021	6021	6020	{"type": "Polygon", "coordinates": [[[-117.09032, 33.16855], [-117.09013, 33.16916], [-117.08888, 33.17318], [-117.08881, 33.17309], [-117.08922, 33.17174], [-117.08935, 33.17106], [-117.08962, 33.17044], [-117.08971, 33.17017], [-117.08973, 33.16987], [-117.08969, 33.16963], [-117.08924, 33.16964], [-117.08917, 33.16947], [-117.08972, 33.1694], [-117.08988, 33.16933], [-117.08991, 33.16921], [-117.08957, 33.16847], [-117.08962, 33.16834], [-117.08975, 33.16834], [-117.08977, 33.16836], [-117.08986, 33.16835], [-117.09023, 33.16843], [-117.09032, 33.16855]]]}	Open Access 1	694	City of Escondido Open Space	17312	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	2.827	City of Escondido OS	Local Recreation Area 3	4
9911	9911	9910	{"type": "Polygon", "coordinates": [[[-117.08784, 33.16292], [-117.08766, 33.16301], [-117.08764, 33.16311], [-117.08733, 33.16327], [-117.08703, 33.1634], [-117.08533, 33.16436], [-117.08531, 33.16463], [-117.08614, 33.16695], [-117.08671, 33.16777], [-117.08676, 33.16801], [-117.08668, 33.16843], [-117.08677, 33.16863], [-117.08682, 33.16885], [-117.08701, 33.16933], [-117.08698, 33.16938], [-117.08688, 33.16936], [-117.08685, 33.16937], [-117.08646, 33.16833], [-117.08611, 33.16841], [-117.08592, 33.16863], [-117.08565, 33.16874], [-117.08537, 33.16882], [-117.08451, 33.16922], [-117.0843, 33.16813], [-117.08477, 33.16806], [-117.08548, 33.16786], [-117.08572, 33.16781], [-117.08576, 33.16782], [-117.08605, 33.16771], [-117.08616, 33.16749], [-117.08577, 33.16643], [-117.08575, 33.1663], [-117.08537, 33.16528], [-117.08428, 33.16511], [-117.08423, 33.16493], [-117.08413, 33.16472], [-117.08498, 33.16422], [-117.08497, 33.16419], [-117.0876, 33.16268], [-117.0877, 33.1627], [-117.08784, 33.16292]]]}	Open Access 1	643	City of Escondido Open Space	17312	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	12.097	City of Escondido OS	Local Recreation Area 3	4
14670	14670	14669	{"type": "MultiPolygon", "coordinates": [[[[-117.05334, 33.14072], [-117.052, 33.14174], [-117.05186, 33.14187], [-117.05187, 33.14191], [-117.04901, 33.14418], [-117.04851, 33.14452], [-117.04849, 33.14452], [-117.04716, 33.14528], [-117.047, 33.14503], [-117.04826, 33.14426], [-117.04825, 33.14423], [-117.04853, 33.14406], [-117.05037, 33.14262], [-117.05045, 33.14259], [-117.05073, 33.14237], [-117.05076, 33.1423], [-117.05316, 33.1404], [-117.05324, 33.14058], [-117.05327, 33.14057], [-117.05334, 33.14072]]], [[[-117.06021, 33.13542], [-117.06016, 33.13545], [-117.0602, 33.13557], [-117.06005, 33.13562], [-117.06002, 33.13559], [-117.05878, 33.13609], [-117.05872, 33.13619], [-117.05868, 33.13606], [-117.05867, 33.13605], [-117.05764, 33.1365], [-117.05703, 33.13685], [-117.05678, 33.13703], [-117.05654, 33.13722], [-117.05619, 33.13758], [-117.05513, 33.13885], [-117.05498, 33.13909], [-117.05478, 33.1393], [-117.05407, 33.14016], [-117.05383, 33.14042], [-117.05366, 33.14057], [-117.05367, 33.14061], [-117.05357, 33.1407], [-117.05335, 33.14025], [-117.05351, 33.14015], [-117.05365, 33.14003], [-117.05546, 33.13784], [-117.05545, 33.13782], [-117.05556, 33.13767], [-117.05558, 33.13767], [-117.05606, 33.13714], [-117.05634, 33.13691], [-117.05671, 33.13664], [-117.05693, 33.1365], [-117.05744, 33.13624], [-117.05795, 33.13603], [-117.05797, 33.13605], [-117.05848, 33.13584], [-117.05849, 33.13582], [-117.05844, 33.13576], [-117.06006, 33.13509], [-117.06017, 33.13526], [-117.06021, 33.13542]]]]}	Open Access 1	48308	Escondido Creek Trail	32877	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2	https://www.escondido.org/Data/Sites/1/media/PDFs/BikingEscondido.pdf	San Diego 4	15.735	Escondido Creek Trail	Local Recreation Area 3	4
16217	16217	16216	{"type": "Polygon", "coordinates": [[[-117.14604, 33.16753], [-117.14568, 33.16832], [-117.14568, 33.16839], [-117.14137, 33.16834], [-117.1414, 33.16739], [-117.14061, 33.16658], [-117.14096, 33.16596], [-117.14048, 33.16411], [-117.14004, 33.1621], [-117.14023, 33.16217], [-117.14033, 33.16218], [-117.14079, 33.16211], [-117.1411, 33.1621], [-117.14137, 33.16215], [-117.14156, 33.16223], [-117.14169, 33.16234], [-117.14177, 33.16245], [-117.14184, 33.16259], [-117.14188, 33.16273], [-117.14187, 33.16285], [-117.14183, 33.16297], [-117.14178, 33.16306], [-117.14167, 33.16317], [-117.14168, 33.16329], [-117.14171, 33.1633], [-117.14189, 33.1633], [-117.1421, 33.16337], [-117.14218, 33.16342], [-117.1423, 33.16353], [-117.14243, 33.16362], [-117.14253, 33.16364], [-117.14279, 33.16359], [-117.14292, 33.1636], [-117.14302, 33.16367], [-117.14316, 33.16387], [-117.14335, 33.16399], [-117.14343, 33.16402], [-117.14354, 33.16401], [-117.14409, 33.16385], [-117.14429, 33.16385], [-117.14558, 33.16436], [-117.14574, 33.16445], [-117.14582, 33.16446], [-117.14584, 33.16451], [-117.14584, 33.16519], [-117.14582, 33.16537], [-117.14581, 33.166], [-117.14596, 33.16649], [-117.14598, 33.16664], [-117.14597, 33.16709], [-117.14604, 33.16753]]]}	No Public Access 3	44872	City of Escondido Open Space	17311	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	63.739	City of Escondido 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]);