calands: units_with_maps: 9 rows where DES_TP = 3 and MNG

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

9 rows where DES_TP = 3 and MNG_AGENCY = 156

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
385	385	384	{"type": "Polygon", "coordinates": [[[-117.15388, 33.67064], [-117.15386, 33.67362], [-117.15375, 33.67366], [-117.15354, 33.67338], [-117.15342, 33.6733], [-117.15342, 33.67327], [-117.15317, 33.67312], [-117.15276, 33.67299], [-117.15275, 33.67297], [-117.15218, 33.67273], [-117.1521, 33.67268], [-117.15205, 33.67268], [-117.15209, 33.67232], [-117.15206, 33.67228], [-117.15172, 33.67207], [-117.15166, 33.67209], [-117.15161, 33.67209], [-117.15158, 33.67206], [-117.15137, 33.67206], [-117.15114, 33.67216], [-117.15096, 33.67243], [-117.15097, 33.67245], [-117.15093, 33.67262], [-117.15094, 33.67265], [-117.15089, 33.67283], [-117.15091, 33.67286], [-117.15091, 33.67306], [-117.15088, 33.67306], [-117.15083, 33.67326], [-117.15041, 33.67303], [-117.15016, 33.67299], [-117.14999, 33.67287], [-117.14973, 33.67259], [-117.14955, 33.67245], [-117.14936, 33.67232], [-117.14933, 33.67232], [-117.14914, 33.6722], [-117.14911, 33.6722], [-117.14903, 33.67215], [-117.14888, 33.67217], [-117.14849, 33.67226], [-117.1482, 33.67272], [-117.14817, 33.6727], [-117.14817, 33.67261], [-117.14814, 33.67256], [-117.1481, 33.67252], [-117.14802, 33.67247], [-117.14821, 33.67255], [-117.14865, 33.67182], [-117.14797, 33.67065], [-117.14945, 33.67065], [-117.14949, 33.67069], [-117.14974, 33.67069], [-117.14978, 33.67065], [-117.15154, 33.67065], [-117.15159, 33.67069], [-117.15184, 33.67069], [-117.15188, 33.67065], [-117.15388, 33.67064]]]}	Open Access 1	48338	Lago Vista Sports Park	32901	2171	Valley-Wide Recreation and Park District 160	Special District 4	Recreation/Parks District 4	https://www.gorecreation.org/	Special District 4	2171	Valley-Wide Recreation and Park District 156	Special District 4	Recreation/Parks District 4	https://www.gorecreation.org/lago-vista-sports-park	Riverside 10	28.451	Lago Vista Sports Park	Local Recreation Area 3	4
557	557	556	{"type": "Polygon", "coordinates": [[[-117.10253, 33.61115], [-117.1013, 33.61115], [-117.10128, 33.60911], [-117.10251, 33.60901], [-117.10253, 33.61115]]]}	Open Access 1	48384	Pourroy Fields	32948	2171	Valley-Wide Recreation and Park District 160	Special District 4	Recreation/Parks District 4	https://www.gorecreation.org/	Special District 4	2171	Valley-Wide Recreation and Park District 156	Special District 4	Recreation/Parks District 4	https://www.gorecreation.org/pourroy-fields	Riverside 10	6.552	Pourroy Fields	Local Recreation Area 3	4
6461	6461	6460	{"type": "Polygon", "coordinates": [[[-117.12666, 33.60337], [-117.12642, 33.60338], [-117.12634, 33.60344], [-117.12614, 33.60397], [-117.12609, 33.60403], [-117.126, 33.6041], [-117.12598, 33.60425], [-117.12589, 33.60441], [-117.12586, 33.6046], [-117.1258, 33.60466], [-117.1256, 33.60452], [-117.12526, 33.60422], [-117.1251, 33.60406], [-117.1251, 33.60402], [-117.12494, 33.60384], [-117.12488, 33.60381], [-117.12481, 33.60373], [-117.12455, 33.60333], [-117.12417, 33.60257], [-117.12433, 33.60226], [-117.12621, 33.60171], [-117.12635, 33.60165], [-117.12657, 33.60158], [-117.12657, 33.6023], [-117.12666, 33.60317], [-117.12666, 33.60337]]]}	Open Access 1	48389	Spencer's Crossing Sports Park	32953	2171	Valley-Wide Recreation and Park District 160	Special District 4	Recreation/Parks District 4	https://www.gorecreation.org/	Special District 4	2171	Valley-Wide Recreation and Park District 156	Special District 4	Recreation/Parks District 4	https://www.gorecreation.org/spencer-s-crossing-sports-park	Riverside 10	11.573	Spencer's Crossing Sports Park	Local Recreation Area 3	4
11842	11842	11841	{"type": "Polygon", "coordinates": [[[-116.89525, 33.7441], [-116.89337, 33.74412], [-116.89328, 33.74405], [-116.89328, 33.74281], [-116.89515, 33.74281], [-116.89518, 33.74327], [-116.89525, 33.74369], [-116.89525, 33.7441]]]}	Open Access 1	48257	Valle Vista Community Center Park	32811	2171	Valley-Wide Recreation and Park District 160	Special District 4	Recreation/Parks District 4	https://www.gorecreation.org/	Special District 4	2171	Valley-Wide Recreation and Park District 156	Special District 4	Recreation/Parks District 4	https://www.gorecreation.org/valle-vista-community-center	Riverside 10	6.351	Valle Vista Community Ctr. Park	Local Recreation Area 3	4
14072	14072	14071	{"type": "Polygon", "coordinates": [[[-117.16259, 33.65631], [-117.16258, 33.65695], [-117.16219, 33.65695], [-117.16219, 33.65684], [-117.16222, 33.65663], [-117.16219, 33.65655], [-117.16212, 33.65649], [-117.16201, 33.65647], [-117.16168, 33.65649], [-117.16168, 33.65618], [-117.16239, 33.65618], [-117.16247, 33.65627], [-117.16259, 33.65631]]]}	Open Access 1	39109	Menifee South Tot Lot	22155	2171	Valley-Wide Recreation and Park District 160	Special District 4	Recreation/Parks District 4	https://www.gorecreation.org/	Special District 4	2171	Valley-Wide Recreation and Park District 156	Special District 4	Recreation/Parks District 4		Riverside 10	1.114	Menifee South Tot Lot	Local Recreation Area 3	4
14089	14089	14088	{"type": "Polygon", "coordinates": [[[-117.13888, 33.74651], [-117.13887, 33.7486], [-117.1367, 33.74859], [-117.13669, 33.74665], [-117.13673, 33.74659], [-117.13697, 33.74659], [-117.13726, 33.74664], [-117.13732, 33.74663], [-117.13738, 33.74659], [-117.13741, 33.7465], [-117.13888, 33.74651]]]}	Open Access 1	39121	Marion V. Ashley Community Center	21864	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	2171	Valley-Wide Recreation and Park District 156	Special District 4	Recreation/Parks District 4		Riverside 10	11.364	Marion V. Ashley Community Ctr.	Local Recreation Area 3	4
14550	14550	14549	{"type": "Polygon", "coordinates": [[[-117.10104, 33.61814], [-117.10099, 33.61814], [-117.09946, 33.61994], [-117.09898, 33.61995], [-117.09889, 33.61989], [-117.09899, 33.61985], [-117.09924, 33.6196], [-117.09936, 33.61964], [-117.0994, 33.6196], [-117.09934, 33.61951], [-117.09946, 33.61938], [-117.09904, 33.61905], [-117.09888, 33.61919], [-117.09878, 33.61912], [-117.09873, 33.61915], [-117.09878, 33.61926], [-117.09857, 33.6194], [-117.0983, 33.6194], [-117.09822, 33.61937], [-117.09817, 33.61938], [-117.09814, 33.61941], [-117.09791, 33.61928], [-117.09793, 33.61925], [-117.09829, 33.61916], [-117.09853, 33.61889], [-117.09858, 33.61865], [-117.09868, 33.61843], [-117.09879, 33.61824], [-117.09903, 33.61795], [-117.09915, 33.61771], [-117.0992, 33.61745], [-117.09919, 33.61714], [-117.09914, 33.61694], [-117.09893, 33.61631], [-117.10101, 33.6163], [-117.10104, 33.61814]]]}	Open Access 1	48276	Abelia Sports Park	32831	2171	Valley-Wide Recreation and Park District 160	Special District 4	Recreation/Parks District 4	https://www.gorecreation.org/	Special District 4	2171	Valley-Wide Recreation and Park District 156	Special District 4	Recreation/Parks District 4		Riverside 10	15.608	Abelia Sports Park	Local Recreation Area 3	4
15723	15723	15722	{"type": "Polygon", "coordinates": [[[-116.96711, 33.7251], [-116.96673, 33.72511], [-116.96673, 33.72566], [-116.96295, 33.72571], [-116.96294, 33.7238], [-116.9636, 33.7238], [-116.96476, 33.72315], [-116.96711, 33.72285], [-116.96711, 33.7251]]]}	Restricted Access 2	48274	Echo Hills Golf Course	32829	2171	Valley-Wide Recreation and Park District 160	Special District 4	Recreation/Parks District 4	https://www.gorecreation.org/	Special District 4	2171	Valley-Wide Recreation and Park District 156	Special District 4	Recreation/Parks District 4		Riverside 10	25.113	Echo Hills GC	Local Recreation Area 3	4
16254	16254	16253	{"type": "Polygon", "coordinates": [[[-117.10095, 33.60539], [-117.10052, 33.6054], [-117.10037, 33.60502], [-117.10047, 33.60497], [-117.10048, 33.60498], [-117.10095, 33.60502], [-117.10095, 33.60539]]]}	Open Access 1	48330	Brookfield Open Space	32893	2171	Valley-Wide Recreation and Park District 160	Special District 4	Recreation/Parks District 4	https://www.gorecreation.org/	Special District 4	2171	Valley-Wide Recreation and Park District 156	Special District 4	Recreation/Parks District 4	https://www.gorecreation.org/brookfield-open-sp	Riverside 10	0.518	Brookfield 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]);