calands: units_with_maps: 11 rows where DES_TP = 2, MNG_AGENCY = 601 and MNG_AG

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

11 rows where DES_TP = 2, MNG_AGENCY = 601 and MNG_AG_LEV = 2

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
3276	3276	3275	{"type": "Polygon", "coordinates": [[[-116.30936, 33.6529], [-116.30904, 33.6529], [-116.30905, 33.65265], [-116.3091, 33.65262], [-116.30936, 33.65263], [-116.30936, 33.6529]]]}	Open Access 1	39079	Velasco Park	26843	1161	La Quinta, City of 612	City 2	City Agency 2	http://www.la-quinta.org/your-government/community-services/city-parks	City 2	1161	La Quinta, City of 601	City 2	City Agency 2	Riverside 10	0.218	Velasco Park	Local Park 2	4
3396	3396	3395	{"type": "Polygon", "coordinates": [[[-116.29449, 33.68896], [-116.29449, 33.6884], [-116.2944, 33.68838], [-116.29436, 33.68835], [-116.2946, 33.68835], [-116.29465, 33.68839], [-116.29466, 33.68892], [-116.29462, 33.68895], [-116.29449, 33.68896]]]}	Open Access 1	24643	Saguaro Park	24784	1161	La Quinta, City of 612	City 2	City Agency 2	http://www.la-quinta.org/your-government/community-services/city-parks	City 2	1161	La Quinta, City of 601	City 2	City Agency 2	Riverside 10	0.259	Saguaro Park	Local Park 2	4
3424	3424	3423	{"type": "Polygon", "coordinates": [[[-116.28611, 33.71638], [-116.28603, 33.71638], [-116.28603, 33.71592], [-116.28555, 33.71592], [-116.28554, 33.71639], [-116.28186, 33.71641], [-116.28184, 33.71468], [-116.2861, 33.71466], [-116.28611, 33.71638]]]}	Open Access 1	25150	La Quinta Park	20802	1161	La Quinta, City of 612	City 2	City Agency 2	http://www.la-quinta.org/your-government/community-services/city-parks	City 2	1161	La Quinta, City of 601	City 2	City Agency 2	Riverside 10	18.115	La Quinta Park	Local Park 2	4
10750	10750	10749	{"type": "Polygon", "coordinates": [[[-116.30351, 33.67104], [-116.30351, 33.67248], [-116.30234, 33.67247], [-116.30196, 33.67252], [-116.30178, 33.67256], [-116.3018, 33.67191], [-116.30183, 33.67187], [-116.30195, 33.67188], [-116.302, 33.67183], [-116.30199, 33.67117], [-116.3024, 33.67116], [-116.3024, 33.67097], [-116.30338, 33.67096], [-116.30351, 33.67104]]]}	Open Access 1	19972	Fritz Burns Park	19127	1161	La Quinta, City of 612	City 2	City Agency 2	http://www.la-quinta.org/your-government/community-services/city-parks	City 2	1161	La Quinta, City of 601	City 2	City Agency 2	Riverside 10	5.975	Fritz Burns Park	Local Park 2	4
11364	11364	11363	{"type": "Polygon", "coordinates": [[[-116.31944, 33.65617], [-116.31918, 33.65617], [-116.3185, 33.65418], [-116.31837, 33.65365], [-116.3183, 33.65322], [-116.31823, 33.65242], [-116.31819, 33.65218], [-116.31798, 33.64925], [-116.31902, 33.64959], [-116.3191, 33.6499], [-116.31863, 33.6518], [-116.31858, 33.65226], [-116.31858, 33.65271], [-116.31862, 33.65302], [-116.31868, 33.65332], [-116.31944, 33.65617]]]}	Open Access 1	22151	Bear Creek Park	15922	1161	La Quinta, City of 612	City 2	City Agency 2	http://www.la-quinta.org/your-government/community-services/city-parks	City 2	1161	La Quinta, City of 601	City 2	City Agency 2	Riverside 10	8.932	Bear Creek Park	Local Park 2	4
11987	11987	11986	{"type": "Polygon", "coordinates": [[[-116.28792, 33.72583], [-116.28784, 33.7259], [-116.2878, 33.72599], [-116.28783, 33.72619], [-116.28783, 33.7267], [-116.28778, 33.72675], [-116.28649, 33.72675], [-116.28641, 33.72668], [-116.2864, 33.72548], [-116.28771, 33.72547], [-116.28792, 33.72583]]]}	Open Access 1	24640	Adams Park	15261	1161	La Quinta, City of 612	City 2	City Agency 2	http://www.la-quinta.org/your-government/community-services/city-parks	City 2	1161	La Quinta, City of 601	City 2	City Agency 2	Riverside 10	4.604	Adams Park	Local Park 2	4
11988	11988	11987	{"type": "Polygon", "coordinates": [[[-116.28859, 33.71998], [-116.28844, 33.72003], [-116.28827, 33.72003], [-116.2881, 33.71999], [-116.28795, 33.7199], [-116.28785, 33.71979], [-116.2878, 33.71967], [-116.28778, 33.71958], [-116.28778, 33.71935], [-116.28783, 33.7193], [-116.28805, 33.7193], [-116.28815, 33.71932], [-116.28833, 33.7194], [-116.2884, 33.71941], [-116.28844, 33.71973], [-116.28859, 33.71998]]]}	Open Access 1	24641	Desert Pride Park	18113	1161	La Quinta, City of 612	City 2	City Agency 2	http://www.la-quinta.org/your-government/community-services/city-parks	City 2	1161	La Quinta, City of 601	City 2	City Agency 2	Riverside 10	1.052	Desert Pride Park	Local Park 2	4
11989	11989	11988	{"type": "Polygon", "coordinates": [[[-116.30097, 33.68143], [-116.30036, 33.68198], [-116.3002, 33.6821], [-116.29947, 33.68258], [-116.29933, 33.68264], [-116.29917, 33.68266], [-116.29895, 33.68263], [-116.29771, 33.68223], [-116.29677, 33.68185], [-116.29669, 33.6818], [-116.29655, 33.68165], [-116.2965, 33.68162], [-116.29643, 33.68163], [-116.29642, 33.68159], [-116.29694, 33.68146], [-116.29745, 33.68136], [-116.29748, 33.68138], [-116.29743, 33.68146], [-116.29742, 33.68151], [-116.29744, 33.68156], [-116.29758, 33.68172], [-116.29777, 33.682], [-116.29785, 33.68207], [-116.29793, 33.68211], [-116.29812, 33.68215], [-116.29901, 33.68208], [-116.29932, 33.68201], [-116.29959, 33.68193], [-116.29973, 33.68185], [-116.29985, 33.68173], [-116.29993, 33.68158], [-116.29996, 33.68143], [-116.30097, 33.68143]]]}	Open Access 1	24642	Seasons Park	25270	1161	La Quinta, City of 612	City 2	City Agency 2	http://www.la-quinta.org/your-government/community-services/city-parks	City 2	1161	La Quinta, City of 601	City 2	City Agency 2	Riverside 10	5.136	Seasons Park	Local Park 2	4
14064	14064	14063	{"type": "Polygon", "coordinates": [[[-116.2919, 33.72053], [-116.29174, 33.72073], [-116.29161, 33.72096], [-116.29155, 33.72125], [-116.29155, 33.72158], [-116.29147, 33.72165], [-116.29073, 33.72165], [-116.29073, 33.7216], [-116.29122, 33.72159], [-116.29121, 33.72119], [-116.29072, 33.72119], [-116.29072, 33.72029], [-116.29158, 33.7203], [-116.29168, 33.72034], [-116.2919, 33.72053]]]}	Open Access 1	39072	Pioneer Park	23723	1161	La Quinta, City of 612	City 2	City Agency 2	http://www.la-quinta.org/your-government/community-services/city-parks	City 2	1161	La Quinta, City of 601	City 2	City Agency 2	Riverside 10	2.687	Pioneer Park	Local Park 2	4
14066	14066	14065	{"type": "Polygon", "coordinates": [[[-116.27203, 33.72897], [-116.27196, 33.72903], [-116.2714, 33.72904], [-116.27139, 33.72857], [-116.2709, 33.72857], [-116.27089, 33.72682], [-116.27164, 33.72682], [-116.27165, 33.72754], [-116.27166, 33.72766], [-116.27174, 33.72789], [-116.27194, 33.72816], [-116.272, 33.72832], [-116.27203, 33.72847], [-116.27203, 33.72897]]]}	Open Access 1	39074	Monticello Park	22439	1161	La Quinta, City of 612	City 2	City Agency 2	http://www.la-quinta.org/your-government/community-services/city-parks	City 2	1161	La Quinta, City of 601	City 2	City Agency 2	Riverside 10	4.623	Monticello Park	Local Park 2	4
14068	14068	14067	{"type": "Polygon", "coordinates": [[[-116.30786, 33.66029], [-116.30786, 33.66042], [-116.30753, 33.66042], [-116.30753, 33.65987], [-116.30781, 33.65987], [-116.30786, 33.65989], [-116.30786, 33.66029]]]}	Open Access 1	39077	Eisenhower Park	18473	1161	La Quinta, City of 612	City 2	City Agency 2	http://www.la-quinta.org/your-government/community-services/city-parks	City 2	1161	La Quinta, City of 601	City 2	City Agency 2	Riverside 10	0.461	Eisenhower Park	Local Park 2	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]);