calands: units_with_maps: 29 rows where DES_TP = 2, MNG_AGENCY = 218 and MNG_AG

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

29 rows where DES_TP = 2, MNG_AGENCY = 218 and MNG_AG_TYP = 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	PARK_URL	COUNTY	ACRES	LABEL_NAME	DES_TP	GAP_STS
2940	2940	2939	{"type": "Polygon", "coordinates": [[[-116.9599, 33.78116], [-116.9599, 33.78189], [-116.95989, 33.78191], [-116.95986, 33.78192], [-116.95894, 33.78192], [-116.95894, 33.78116], [-116.9599, 33.78116]]]}	Open Access 1	19957	Hofmann Park	32965	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2		Riverside 10	1.866	Hofmann Park	Local Park 2	4
3758	3758	3757	{"type": "MultiPolygon", "coordinates": [[[[-116.98153, 33.77753], [-116.98137, 33.77744], [-116.98119, 33.77737], [-116.981, 33.77733], [-116.98078, 33.77731], [-116.98075, 33.77726], [-116.98075, 33.77705], [-116.98097, 33.77713], [-116.98116, 33.77724], [-116.98153, 33.77753]]], [[[-116.98447, 33.78005], [-116.98386, 33.78005], [-116.9838, 33.78003], [-116.98378, 33.77999], [-116.98377, 33.7797], [-116.98375, 33.77957], [-116.98368, 33.77941], [-116.98355, 33.77922], [-116.98416, 33.77972], [-116.98447, 33.78005]]], [[[-116.98632, 33.77936], [-116.98628, 33.77942], [-116.98594, 33.77947], [-116.98594, 33.77914], [-116.98508, 33.77914], [-116.98507, 33.77777], [-116.98565, 33.77777], [-116.98566, 33.77785], [-116.98607, 33.77785], [-116.98609, 33.77888], [-116.98614, 33.77907], [-116.98632, 33.77936]]]]}	Open Access 1	34898	Lynden Trail Park	21608	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2		Riverside 10	4.615	Lynden Trail Park	Local Park 2	4
3759	3759	3758	{"type": "Polygon", "coordinates": [[[-116.99361, 33.78554], [-116.99306, 33.78554], [-116.99289, 33.78542], [-116.9927, 33.78531], [-116.9924, 33.78518], [-116.99218, 33.78511], [-116.99217, 33.78509], [-116.99089, 33.78477], [-116.99087, 33.78479], [-116.98953, 33.78445], [-116.98952, 33.78232], [-116.98959, 33.78225], [-116.98983, 33.78225], [-116.98988, 33.78229], [-116.98988, 33.78255], [-116.9899, 33.78269], [-116.99017, 33.7837], [-116.99023, 33.78384], [-116.99037, 33.78404], [-116.99056, 33.78422], [-116.99068, 33.78431], [-116.9909, 33.78442], [-116.99125, 33.78452], [-116.99116, 33.7848], [-116.99224, 33.78506], [-116.99257, 33.78518], [-116.99259, 33.78518], [-116.99264, 33.78521], [-116.9927, 33.78523], [-116.99271, 33.78526], [-116.99296, 33.78541], [-116.99361, 33.78541], [-116.99361, 33.78554]]]}	Open Access 1	34899	Bolander Park	16236	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2		Riverside 10	4.841	Bolander Park	Local Park 2	4
3842	3842	3841	{"type": "Polygon", "coordinates": [[[-117.01532, 33.78362], [-117.0139, 33.78363], [-117.01408, 33.7834], [-117.01418, 33.78331], [-117.01424, 33.78315], [-117.01446, 33.78269], [-117.0146, 33.78223], [-117.01465, 33.78198], [-117.01467, 33.78168], [-117.01467, 33.78078], [-117.0147, 33.78058], [-117.01466, 33.78048], [-117.01466, 33.78011], [-117.01522, 33.78011], [-117.01529, 33.78017], [-117.01532, 33.78362]]]}	Open Access 1	45431	Catalpa Park	28229	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	Riverside 10	6.935	Catalpa Park	Local Park 2	4
3844	3844	3843	{"type": "Polygon", "coordinates": [[[-116.96921, 33.78085], [-116.96805, 33.78184], [-116.96692, 33.78091], [-116.96758, 33.78035], [-116.9692, 33.78035], [-116.96921, 33.78085]]]}	Open Access 1	45450	Francisco Estudillo Heritage Park	28249	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	Riverside 10	5.384	Francisco Estudillo Heritage Park	Local Park 2	4
3976	3976	3975	{"type": "Polygon", "coordinates": [[[-116.94659, 33.76477], [-116.94658, 33.76514], [-116.94648, 33.76514], [-116.94647, 33.76484], [-116.94577, 33.76473], [-116.9458, 33.76466], [-116.94623, 33.76474], [-116.94659, 33.76477]]]}	Open Access 1	48843	Rsi Park	33563	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2	https://www.sanjacintoca.gov/community/parks_facilities/parks/r_s_i_park	Riverside 10	0.23	Rsi Park	Local Park 2	4
4323	4323	4322	{"type": "Polygon", "coordinates": [[[-117.01978, 33.78361], [-117.01948, 33.78361], [-117.0194, 33.78364], [-117.01932, 33.78356], [-117.0192, 33.78352], [-117.01898, 33.78355], [-117.01865, 33.78354], [-117.0186, 33.7835], [-117.01861, 33.78297], [-117.01866, 33.78293], [-117.01896, 33.78293], [-117.01917, 33.78296], [-117.01926, 33.78295], [-117.01933, 33.78291], [-117.01935, 33.78292], [-117.01977, 33.78292], [-117.01978, 33.78361]]]}	Open Access 1	45432	Terrazzo Park	28228	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	Riverside 10	1.882	Terrazzo Park	Local Park 2	4
4324	4324	4323	{"type": "Polygon", "coordinates": [[[-117.00334, 33.7746], [-117.00259, 33.7746], [-117.00259, 33.77419], [-117.00281, 33.77421], [-117.00289, 33.77419], [-117.00295, 33.77414], [-117.00302, 33.77419], [-117.00333, 33.77419], [-117.00334, 33.7746]]]}	Open Access 1	45436	Solana II Park	28230	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	Riverside 10	0.776	Solana II Park	Local Park 2	4
4455	4455	4454	{"type": "Polygon", "coordinates": [[[-116.92363, 33.76592], [-116.92305, 33.7664], [-116.92281, 33.76619], [-116.92324, 33.76594], [-116.9234, 33.76582], [-116.92352, 33.76583], [-116.92363, 33.76592]]]}	Open Access 1	48395	Belicia Park	32960	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2	http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304452	Riverside 10	0.472	Belicia Park	Local Park 2	4
4550	4550	4549	{"type": "Polygon", "coordinates": [[[-116.96087, 33.7857], [-116.9601, 33.7857], [-116.9601, 33.78506], [-116.96035, 33.78527], [-116.96087, 33.7857]]]}	Open Access 1	24659	Druding Park	18276	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2		Riverside 10	0.63	Druding Park	Local Park 2	4
4792	4792	4791	{"type": "Polygon", "coordinates": [[[-116.96266, 33.79047], [-116.96174, 33.79124], [-116.96034, 33.79008], [-116.96121, 33.78934], [-116.96266, 33.79047]]]}	Open Access 1	48267	Sallee Park	32819	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2		Riverside 10	5.326	Sallee Park	Local Park 2	4
4841	4841	4840	{"type": "Polygon", "coordinates": [[[-116.95082, 33.76272], [-116.95023, 33.76243], [-116.95039, 33.76233], [-116.95042, 33.76227], [-116.95043, 33.76223], [-116.95039, 33.76215], [-116.94999, 33.76177], [-116.95014, 33.76153], [-116.95081, 33.76152], [-116.95082, 33.76272]]]}	Open Access 1	48398	Hafliger Park	32964	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2	http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304536	Riverside 10	1.6	Hafliger Park	Local Park 2	4
5627	5627	5626	{"type": "MultiPolygon", "coordinates": [[[[-116.99518, 33.78996], [-116.99517, 33.79002], [-116.99479, 33.79022], [-116.99456, 33.78993], [-116.99375, 33.79008], [-116.99374, 33.78929], [-116.99403, 33.78928], [-116.99432, 33.7892], [-116.99449, 33.78959], [-116.99484, 33.78947], [-116.99493, 33.78961], [-116.99518, 33.78996]]], [[[-116.99698, 33.79061], [-116.99687, 33.79067], [-116.99675, 33.79077], [-116.99657, 33.79097], [-116.99628, 33.79097], [-116.99585, 33.79054], [-116.99511, 33.78955], [-116.99499, 33.78932], [-116.99493, 33.78906], [-116.99493, 33.78803], [-116.99698, 33.79061]]]]}	Open Access 1	45438	Sandelwood Park	28231	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	Riverside 10	7.842	Sandelwood Park	Local Park 2	4
13923	13923	13922	{"type": "MultiPolygon", "coordinates": [[[[-116.93123, 33.79803], [-116.93092, 33.79811], [-116.93094, 33.79821], [-116.931, 33.79833], [-116.93119, 33.79858], [-116.93115, 33.79861], [-116.93049, 33.79779], [-116.9302, 33.79793], [-116.93018, 33.79789], [-116.93046, 33.79774], [-116.93028, 33.79746], [-116.93018, 33.79727], [-116.93001, 33.79686], [-116.92972, 33.79579], [-116.92996, 33.7958], [-116.93001, 33.79586], [-116.93, 33.79598], [-116.92994, 33.79617], [-116.92998, 33.79626], [-116.93007, 33.79632], [-116.93005, 33.79662], [-116.93029, 33.79664], [-116.93039, 33.79668], [-116.93048, 33.79673], [-116.93053, 33.79681], [-116.93066, 33.79711], [-116.93074, 33.79732], [-116.93081, 33.79763], [-116.93086, 33.79795], [-116.93121, 33.79793], [-116.93123, 33.79803]]], [[[-116.93157, 33.79599], [-116.93105, 33.7962], [-116.93088, 33.79609], [-116.93074, 33.79602], [-116.93059, 33.79597], [-116.93031, 33.79591], [-116.93023, 33.79618], [-116.9302, 33.79618], [-116.93014, 33.79611], [-116.93017, 33.79587], [-116.93025, 33.79582], [-116.93148, 33.79593], [-116.93155, 33.79597], [-116.93157, 33.79599]]]]}	Open Access 1	48838	Soboba Springs Park	33558	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2	http://sanjacintoca.hosted.civiclive.com/community/parks_facilities/parks/soboba_springs_park	Riverside 10	2.944	Soboba Springs Park	Local Park 2	4
14877	14877	14876	{"type": "Polygon", "coordinates": [[[-116.989, 33.7964], [-116.98899, 33.79696], [-116.98805, 33.79697], [-116.988, 33.79693], [-116.98799, 33.7964], [-116.989, 33.7964]]]}	Open Access 1	45444	Daniel Najera Park	28235	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	Riverside 10	1.438	Daniel Najera Park	Local Park 2	4
14886	14886	14885	{"type": "Polygon", "coordinates": [[[-116.9851, 33.79461], [-116.98504, 33.79466], [-116.98414, 33.79467], [-116.98411, 33.79447], [-116.98399, 33.79416], [-116.98396, 33.79397], [-116.98397, 33.79371], [-116.98405, 33.79342], [-116.9841, 33.79318], [-116.98412, 33.79277], [-116.98509, 33.79277], [-116.9851, 33.79461]]]}	Open Access 1	45443	Warneke Park	28236	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	Riverside 10	5.012	Warneke Park	Local Park 2	4
14888	14888	14887	{"type": "Polygon", "coordinates": [[[-117.02407, 33.78613], [-117.02397, 33.78608], [-117.02257, 33.7863], [-117.02248, 33.78627], [-117.0225, 33.78621], [-117.02249, 33.78616], [-117.02242, 33.78598], [-117.02228, 33.7854], [-117.02231, 33.78535], [-117.0225, 33.78532], [-117.02327, 33.78531], [-117.0235, 33.78533], [-117.02359, 33.78531], [-117.02366, 33.78527], [-117.02375, 33.78533], [-117.02405, 33.78533], [-117.02407, 33.78613]]]}	Open Access 1	45433	Tamarisk Park	28227	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	Riverside 10	3.725	Tamarisk Park	Local Park 2	4
14889	14889	14888	{"type": "Polygon", "coordinates": [[[-117.00648, 33.77991], [-117.00478, 33.77992], [-117.00469, 33.77986], [-117.00469, 33.77968], [-117.00474, 33.77964], [-117.00499, 33.77962], [-117.00523, 33.77956], [-117.00541, 33.77949], [-117.00559, 33.77939], [-117.00576, 33.77926], [-117.00589, 33.77912], [-117.006, 33.77896], [-117.00608, 33.77878], [-117.00648, 33.77888], [-117.00648, 33.77991]]]}	Open Access 1	45434	Ward Park	28226	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	Riverside 10	2.854	Ward Park	Local Park 2	4
14890	14890	14889	{"type": "Polygon", "coordinates": [[[-117.00038, 33.7932], [-117.00038, 33.79349], [-116.99823, 33.7935], [-116.99822, 33.79141], [-116.99856, 33.79141], [-116.99857, 33.7917], [-116.99892, 33.79169], [-116.99893, 33.79205], [-116.99897, 33.79218], [-116.99903, 33.79232], [-116.99918, 33.7925], [-116.99965, 33.79294], [-116.99981, 33.79304], [-116.99999, 33.79312], [-117.00017, 33.79318], [-117.00038, 33.7932]]]}	Open Access 1	45437	Aaron J. Ward Park	28234	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	Riverside 10	5.84	Aaron J. Ward Park	Local Park 2	4
14891	14891	14890	{"type": "MultiPolygon", "coordinates": [[[[-116.99448, 33.78593], [-116.99442, 33.78606], [-116.99434, 33.78617], [-116.99428, 33.78618], [-116.99418, 33.78613], [-116.99403, 33.78601], [-116.99391, 33.78586], [-116.99386, 33.78573], [-116.99383, 33.78554], [-116.99423, 33.78554], [-116.99448, 33.78593]]], [[[-116.99619, 33.78721], [-116.99501, 33.78721], [-116.99493, 33.78715], [-116.99491, 33.78689], [-116.99484, 33.78666], [-116.9947, 33.78647], [-116.99452, 33.78631], [-116.99451, 33.78626], [-116.99467, 33.78604], [-116.99474, 33.786], [-116.9948, 33.786], [-116.99481, 33.78628], [-116.99497, 33.78636], [-116.9955, 33.78635], [-116.9955, 33.78657], [-116.99547, 33.78675], [-116.99551, 33.78685], [-116.99558, 33.78691], [-116.99568, 33.78694], [-116.99591, 33.78691], [-116.99618, 33.78691], [-116.99619, 33.78721]]]]}	Open Access 1	45440	Cutting Park	28233	1416	San Jacinto, City of 222	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	City 2	1416	San Jacinto, City of 218	City 2	City Agency 2	http://www.ci.san-jacinto.ca.us/residents/parks.html	Riverside 10	2.836	Cutting 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]);