calands: units_with_maps: 9 rows where DES_TP = 3, LAYER = 2 and MNG

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

9 rows where DES_TP = 3, LAYER = 2 and MNG_AGENCY = 185

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
2926	2926	2925	{"type": "Polygon", "coordinates": [[[-117.44729, 33.93129], [-117.44564, 33.93223], [-117.44557, 33.93222], [-117.44446, 33.93087], [-117.44445, 33.93083], [-117.44448, 33.9308], [-117.44622, 33.92979], [-117.44646, 33.93007], [-117.44651, 33.93028], [-117.44658, 33.93041], [-117.44729, 33.93129]]]}	Open Access 1	19857	Don Lorenzi Sports Park	18207	1279	Riverside, City of 189	City 2	City Agency 2	http://www.riversideca.gov/park_rec/	City 2	1279	Riverside, City of 185	City 2	City Agency 2	Riverside 10	9.204	Don Lorenzi Sports Park	Local Recreation Area 3	4
3188	3188	3187	{"type": "Polygon", "coordinates": [[[-117.33536, 33.9812], [-117.33535, 33.98219], [-117.33523, 33.98258], [-117.33522, 33.98284], [-117.33513, 33.9829], [-117.33282, 33.98289], [-117.33281, 33.98294], [-117.33261, 33.98294], [-117.33261, 33.98289], [-117.33248, 33.98289], [-117.33246, 33.98294], [-117.33221, 33.98294], [-117.3322, 33.98289], [-117.33128, 33.98289], [-117.33124, 33.98286], [-117.33125, 33.98119], [-117.33284, 33.9812], [-117.33536, 33.9812]]]}	Open Access 1	22126	Riverside Sports Center	24460	1279	Riverside, City of 189	City 2	City Agency 2	http://www.riversideca.gov/park_rec/	City 2	1279	Riverside, City of 185	City 2	City Agency 2	Riverside 10	17.499	Riverside Sports Ctr.	Local Recreation Area 3	4
5463	5463	5462	{"type": "Polygon", "coordinates": [[[-117.35709, 33.97285], [-117.35709, 33.97395], [-117.356, 33.97398], [-117.35595, 33.97467], [-117.35505, 33.97466], [-117.35504, 33.97285], [-117.35709, 33.97285]]]}	Open Access 1	6271	Bobby Bonds Park and Sports Complex	16213	1279	Riverside, City of 189	City 2	City Agency 2	http://www.riversideca.gov/park_rec/	City 2	1279	Riverside, City of 185	City 2	City Agency 2	Riverside 10	7.442	Bobby Bonds Park and Sports Complex	Local Recreation Area 3	4
9396	9396	9395	{"type": "Polygon", "coordinates": [[[-117.44487, 33.92816], [-117.44309, 33.92917], [-117.44256, 33.92851], [-117.44257, 33.92847], [-117.44432, 33.92748], [-117.44487, 33.92816]]]}	Open Access 1	18711	Don Lorenzi Sports Center	18206	1279	Riverside, City of 189	City 2	City Agency 2	http://www.riversideca.gov/park_rec/	City 2	1279	Riverside, City of 185	City 2	City Agency 2	Riverside 10	4.492	Don Lorenzi Sports Ctr.	Local Recreation Area 3	4
10703	10703	10702	{"type": "MultiPolygon", "coordinates": [[[[-117.45748, 33.93032], [-117.45696, 33.93055], [-117.45685, 33.9303], [-117.45635, 33.9303], [-117.45634, 33.92971], [-117.45667, 33.92988], [-117.45692, 33.92988], [-117.45719, 33.92984], [-117.45748, 33.93032]]], [[[-117.46005, 33.93408], [-117.45945, 33.93387], [-117.45903, 33.93388], [-117.45891, 33.93342], [-117.45839, 33.93258], [-117.45813, 33.93269], [-117.45809, 33.93262], [-117.45833, 33.9325], [-117.45785, 33.93171], [-117.45762, 33.93157], [-117.45742, 33.93157], [-117.45754, 33.93125], [-117.45743, 33.93101], [-117.45709, 33.93091], [-117.45701, 33.93071], [-117.45758, 33.93047], [-117.45766, 33.93059], [-117.45798, 33.93077], [-117.45806, 33.93088], [-117.45868, 33.93185], [-117.45891, 33.93175], [-117.45898, 33.93186], [-117.45875, 33.93198], [-117.4592, 33.93271], [-117.45924, 33.93286], [-117.45933, 33.93298], [-117.45956, 33.93287], [-117.45967, 33.93295], [-117.45957, 33.93316], [-117.4598, 33.93348], [-117.45976, 33.93354], [-117.45977, 33.93361], [-117.4598, 33.93366], [-117.45989, 33.93372], [-117.45993, 33.93376], [-117.46002, 33.93393], [-117.46005, 33.93408]]]]}	Open Access 1	19859	El Dorado Open Space Park	18503	1279	Riverside, City of 189	City 2	City Agency 2	http://www.riversideca.gov/park_rec/	City 2	1279	Riverside, City of 185	City 2	City Agency 2	Riverside 10	8.427	El Dorado OS Park	Local Recreation Area 3	4
14846	14846	14845	{"type": "Polygon", "coordinates": [[[-117.4311, 33.90173], [-117.43346, 33.90466], [-117.43347, 33.90469], [-117.43345, 33.90471], [-117.43013, 33.90662], [-117.43009, 33.90663], [-117.43006, 33.90661], [-117.42888, 33.90516], [-117.42945, 33.90482], [-117.42825, 33.90334], [-117.4311, 33.90173]]]}	Open Access 1	45361	Arlington Heights Sports Park Picnic Area	15588	1279	Riverside, City of 189	City 2	City Agency 2	http://www.riversideca.gov/park_rec/	City 2	1279	Riverside, City of 185	City 2	City Agency 2	Riverside 10	34.333	Arlington Heights Sports Park Picnic Area	Local Recreation Area 3	4
15714	15714	15713	{"type": "Polygon", "coordinates": [[[-117.38221, 34.00104], [-117.38076, 34.00281], [-117.37982, 34.00246], [-117.37662, 34.00097], [-117.37602, 34.00067], [-117.37477, 33.99998], [-117.37651, 33.99723], [-117.37697, 33.99738], [-117.37768, 33.99739], [-117.37769, 33.99741], [-117.38159, 33.99982], [-117.38173, 34.0003], [-117.38151, 34.00061], [-117.38221, 34.00104]]]}	Restricted Access 2	30000	Fairmount Park Golf Course	33094	1279	Riverside, City of 189	City 2	City Agency 2	http://www.riversideca.gov/park_rec/	City 2	1279	Riverside, City of 185	City 2	City Agency 2	Riverside 10	55.983	Fairmount Park GC	Local Recreation Area 3	4
16184	16184	16183	{"type": "Polygon", "coordinates": [[[-117.31978, 33.96039], [-117.31974, 33.9609], [-117.31968, 33.96095], [-117.31927, 33.96088], [-117.31898, 33.96081], [-117.3189, 33.96076], [-117.31846, 33.96064], [-117.31744, 33.96024], [-117.31672, 33.96039], [-117.31629, 33.96031], [-117.31548, 33.9604], [-117.315, 33.96042], [-117.3143, 33.96034], [-117.31376, 33.9604], [-117.31372, 33.96037], [-117.31375, 33.95792], [-117.31407, 33.95785], [-117.31439, 33.95776], [-117.31494, 33.95755], [-117.31525, 33.95797], [-117.3168, 33.958], [-117.31679, 33.9592], [-117.31861, 33.95961], [-117.31924, 33.95929], [-117.31926, 33.95944], [-117.31931, 33.95957], [-117.31939, 33.95969], [-117.31957, 33.95987], [-117.31969, 33.96005], [-117.31975, 33.96017], [-117.31978, 33.96039]]]}	Open Access 1	25075	Quail Run Open Space	24052	1279	Riverside, City of 189	City 2	City Agency 2	http://www.riversideca.gov/park_rec/	City 2	1279	Riverside, City of 185	City 2	City Agency 2	Riverside 10	27.591	Quail Run OS	Local Recreation Area 3	4
17040	17040	17039	{"type": "MultiPolygon", "coordinates": [[[[-117.45663, 33.95565], [-117.45632, 33.95587], [-117.45598, 33.95604], [-117.45559, 33.95619], [-117.45518, 33.95628], [-117.4551, 33.95629], [-117.45398, 33.95629], [-117.45397, 33.95621], [-117.45293, 33.95622], [-117.4533, 33.95591], [-117.45356, 33.9556], [-117.45389, 33.95566], [-117.45399, 33.95566], [-117.45399, 33.95458], [-117.45538, 33.95457], [-117.45593, 33.95505], [-117.45662, 33.95554], [-117.45663, 33.95565]]], [[[-117.46118, 33.95825], [-117.45644, 33.9549], [-117.45602, 33.95457], [-117.45558, 33.95416], [-117.45532, 33.95387], [-117.45508, 33.95357], [-117.45486, 33.95325], [-117.45468, 33.95293], [-117.45472, 33.95285], [-117.45507, 33.95274], [-117.45536, 33.95269], [-117.45743, 33.95268], [-117.45803, 33.95369], [-117.45885, 33.95382], [-117.46023, 33.95608], [-117.46069, 33.95728], [-117.46071, 33.95727], [-117.46062, 33.95703], [-117.46072, 33.95701], [-117.46118, 33.95825]]]]}	Restricted Access 2	30001	Van Buren Golf Center	33095	1279	Riverside, City of 189	City 2	City Agency 2	http://www.riversideca.gov/park_rec/	City 2	1279	Riverside, City of 185	City 2	City Agency 2	Riverside 10	41.11	Van Buren Golf Ctr.	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]);