calands: units_with_maps: 4 rows where DES_TP = 3, GAP_STS = 4 and MNG

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

4 rows where DES_TP = 3, GAP_STS = 4 and MNG_AGENCY = 726

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	YR_EST	DES_TP	GAP_STS
11316	11316	11315	{"type": "Polygon", "coordinates": [[[-120.23983, 37.96099], [-120.23982, 37.96122], [-120.23954, 37.96122], [-120.23954, 37.96099], [-120.23983, 37.96099]]]}	Open Access 1	48052	Bay Street Tot Lot	32546	2169	Tuolumne Park and Recreation District 741	Special District 4	Recreation/Parks District 4	http://www.tuolumnerecreation.com/	Special District 4	2169	Tuolumne Park and Recreation District 726	Special District 4	Recreation/Parks District 4	https://www.tuolumnerecreation.com/TPRD_facilities.html	Tuolumne 21	0.163	Bay Street Tot Lot	2011	Local Recreation Area 3	4
11367	11367	11366	{"type": "Polygon", "coordinates": [[[-120.18086, 37.99455], [-120.18082, 37.99822], [-120.18026, 37.99868], [-120.1788, 37.99869], [-120.17953, 37.99809], [-120.17867, 37.99728], [-120.17833, 37.99763], [-120.17708, 37.99617], [-120.1795, 37.99458], [-120.18086, 37.99455]]]}	Open Access 1	48060	River Ranch Campground	32552	2169	Tuolumne Park and Recreation District 741	Special District 4	Recreation/Parks District 4	http://www.tuolumnerecreation.com/	Special District 4	2169	Tuolumne Park and Recreation District 726	Special District 4	Recreation/Parks District 4	https://www.tuolumnerecreation.com/TPRD_facilities.html	Tuolumne 21	24.283	River Ranch Campground	1960	Local Recreation Area 3	4
11368	11368	11367	{"type": "Polygon", "coordinates": [[[-120.23945, 37.95996], [-120.23944, 37.96062], [-120.23874, 37.96061], [-120.23875, 37.95996], [-120.23945, 37.95996]]]}	Open Access 1	48061	Jerry Whitehead Field	32553	2169	Tuolumne Park and Recreation District 741	Special District 4	Recreation/Parks District 4	http://www.tuolumnerecreation.com/	Special District 4	2169	Tuolumne Park and Recreation District 726	Special District 4	Recreation/Parks District 4		Tuolumne 21	1.102	Jerry Whitehead Field	0	Local Recreation Area 3	4
16792	16792	16791	{"type": "MultiPolygon", "coordinates": [[[[-120.23998, 37.95949], [-120.23997, 37.95991], [-120.23892, 37.95991], [-120.23892, 37.95953], [-120.23981, 37.95953], [-120.23998, 37.95949]]], [[[-120.26892, 37.96427], [-120.26882, 37.96433], [-120.26877, 37.96423], [-120.26884, 37.96418], [-120.26892, 37.96427]]], [[[-120.27003, 37.96481], [-120.26974, 37.96467], [-120.26921, 37.96408], [-120.26916, 37.96411], [-120.26906, 37.96403], [-120.26928, 37.9639], [-120.27003, 37.96481]]], [[[-120.30446, 37.97107], [-120.3044, 37.97145], [-120.30426, 37.97135], [-120.30363, 37.97066], [-120.30353, 37.97036], [-120.30314, 37.96985], [-120.30363, 37.96986], [-120.30414, 37.97067], [-120.30446, 37.97107]]], [[[-120.2998, 37.96957], [-120.29949, 37.96941], [-120.29843, 37.96904], [-120.29833, 37.96899], [-120.29815, 37.96884], [-120.29806, 37.96871], [-120.29798, 37.9685], [-120.29799, 37.96818], [-120.29801, 37.96798], [-120.29801, 37.96787], [-120.29796, 37.96776], [-120.29791, 37.96768], [-120.29776, 37.96755], [-120.29762, 37.96748], [-120.29738, 37.96742], [-120.29721, 37.96739], [-120.29702, 37.9674], [-120.29668, 37.96746], [-120.2966, 37.96749], [-120.29625, 37.96754], [-120.29607, 37.96754], [-120.29573, 37.96753], [-120.2956, 37.96749], [-120.2953, 37.9675], [-120.29503, 37.96757], [-120.29479, 37.96769], [-120.29452, 37.9679], [-120.29423, 37.96809], [-120.29387, 37.96822], [-120.29365, 37.96825], [-120.29344, 37.96825], [-120.29334, 37.96823], [-120.29308, 37.96816], [-120.2911, 37.96694], [-120.29082, 37.96674], [-120.29065, 37.96665], [-120.29043, 37.96659], [-120.29025, 37.96658], [-120.29001, 37.9666], [-120.28962, 37.96669], [-120.28864, 37.967], [-120.2871, 37.96746], [-120.28691, 37.96757], [-120.28673, 37.96771], [-120.28663, 37.9678], [-120.28652, 37.96794], [-120.28644, 37.96808], [-120.28636, 37.96835], [-120.28635, 37.96844], [-120.28637, 37.96869], [-120.28643, 37.96891], [-120.28658, 37.96921], [-120.2867, 37.96937], [-120.28771, 37.97031], [-120.288, 37.97069], [-120.28819, 37.97098], [-120.28832, 37.97121], [-120.28858, 37.97142], [-120.28911, 37.97191], [-120.28935, 37.97217], [-120.28964, 37.97254], [-120.28992, 37.97298], [-120.29004, 37.97332], [-120.29006, 37.97356], [-120.29003, 37.97385], [-120.28993, 37.97408], [-120.28976, 37.97434], [-120.28945, 37.97466], [-120.28914, 37.9749], [-120.28895, 37.97502], [-120.28858, 37.97524], [-120.28835, 37.97534], [-120.28803, 37.97543], [-120.28773, 37.97545], [-120.28754, 37.97544], [-120.28724, 37.97538], [-120.28712, 37.97534], [-120.28691, 37.97525], [-120.28597, 37.97469], [-120.28578, 37.97551], [-120.28556, 37.97552], [-120.28568, 37.97459], [-120.28567, 37.97448], [-120.28562, 37.97442], [-120.28501, 37.97385], [-120.28496, 37.97378], [-120.28478, 37.97356], [-120.28471, 37.97345], [-120.28469, 37.97338], [-120.28454, 37.97304], [-120.28429, 37.97252], [-120.28413, 37.97237], [-120.28398, 37.97227], [-120.28379, 37.97211], [-120.28356, 37.97196], [-120.28346, 37.97186], [-120.28329, 37.97156], [-120.2831, 37.97097], [-120.28298, 37.97075], [-120.28279, 37.97057], [-120.28253, 37.97042], [-120.28238, 37.97036], [-120.2822, 37.97032], [-120.28206, 37.97033], [-120.28185, 37.97042], [-120.28138, 37.9707], [-120.28088, 37.97122], [-120.28079, 37.97134], [-120.28042, 37.97169], [-120.28027, 37.97177], [-120.28004, 37.97183], [-120.27995, 37.97181], [-120.27996, 37.97172], [-120.27995, 37.97171], [-120.27922, 37.9719], [-120.27903, 37.97193], [-120.27874, 37.97195], [-120.27859, 37.97193], [-120.27848, 37.97186], [-120.2784, 37.97183], [-120.2782, 37.9717], [-120.27795, 37.97147], [-120.27783, 37.97133], [-120.27773, 37.97116], [-120.27771, 37.97107], [-120.27772, 37.9709], [-120.27779, 37.97069], [-120.27787, 37.97052], [-120.27802, 37.97033], [-120.27874, 37.96953], [-120.27893, 37.96925], [-120.27945, 37.96817], [-120.27982, 37.9673], [-120.27988, 37.96702], [-120.27987, 37.96688], [-120.27989, 37.96676], [-120.27986, 37.96668], [-120.27979, 37.96651], [-120.2797, 37.9664], [-120.27944, 37.96617], [-120.2793, 37.96612], [-120.27921, 37.96606], [-120.27903, 37.96598], [-120.27879, 37.9659], [-120.27856, 37.96585], [-120.27817, 37.96586], [-120.27787, 37.96596], [-120.27774, 37.96603], [-120.27734, 37.96631], [-120.27646, 37.96743], [-120.27633, 37.96752], [-120.27614, 37.96761], [-120.27577, 37.96773], [-120.27541, 37.96779], [-120.2751, 37.96781], [-120.27479, 37.9678], [-120.27423, 37.96774], [-120.27383, 37.96767], [-120.27357, 37.96755], [-120.27352, 37.96752], [-120.27348, 37.96747], [-120.27379, 37.96733], [-120.27408, 37.96743], [-120.27437, 37.96749], [-120.27473, 37.96752], [-120.27519, 37.96751], [-120.27545, 37.96747], [-120.27562, 37.96743], [-120.27579, 37.96736], [-120.27602, 37.96721], [-120.27668, 37.96644], [-120.277, 37.96612], [-120.27724, 37.96593], [-120.27757, 37.96571], [-120.2778, 37.9656], [-120.2781, 37.96552], [-120.27838, 37.96552], [-120.27856, 37.96553], [-120.27886, 37.9656], [-120.27905, 37.96567], [-120.27927, 37.96578], [-120.27969, 37.96604], [-120.27983, 37.96616], [-120.27994, 37.96619], [-120.28006, 37.96632], [-120.28016, 37.96645], [-120.28025, 37.96666], [-120.28025, 37.96695], [-120.28021, 37.96706], [-120.28017, 37.96728], [-120.27966, 37.96833], [-120.27937, 37.96897], [-120.27933, 37.96913], [-120.27927, 37.96927], [-120.2792, 37.96941], [-120.27905, 37.96965], [-120.27883, 37.9699], [-120.27829, 37.97045], [-120.27813, 37.97069], [-120.27808, 37.97083], [-120.27805, 37.97098], [-120.27805, 37.97106], [-120.27812, 37.97123], [-120.27815, 37.97128], [-120.27837, 37.97148], [-120.2785, 37.97155], [-120.27871, 37.97162], [-120.27881, 37.97163], [-120.27937, 37.97161], [-120.28004, 37.97147], [-120.28014, 37.97144], [-120.28031, 37.97135], [-120.28055, 37.97114], [-120.28081, 37.97102], [-120.28085, 37.97095], [-120.28132, 37.97054], [-120.28144, 37.97046], [-120.28181, 37.97011], [-120.28203, 37.97003], [-120.2824, 37.96997], [-120.28253, 37.97], [-120.2827, 37.97008], [-120.28305, 37.97034], [-120.28319, 37.97047], [-120.28332, 37.97062], [-120.28339, 37.97068], [-120.28355, 37.97098], [-120.28356, 37.97107], [-120.28368, 37.97147], [-120.28382, 37.97169], [-120.28396, 37.97186], [-120.28427, 37.97207], [-120.28459, 37.97239], [-120.2847, 37.97261], [-120.2848, 37.97275], [-120.28481, 37.97281], [-120.28509, 37.97331], [-120.28512, 37.97336], [-120.28514, 37.97342], [-120.28541, 37.9738], [-120.28579, 37.97423], [-120.28586, 37.97427], [-120.28592, 37.97435], [-120.28602, 37.97445], [-120.28685, 37.97497], [-120.28701, 37.97504], [-120.28725, 37.97511], [-120.28766, 37.97516], [-120.28799, 37.9751], [-120.28821, 37.97503], [-120.28883, 37.97468], [-120.28908, 37.97451], [-120.28922, 37.97438], [-120.28946, 37.9741], [-120.28954, 37.97391], [-120.28958, 37.97374], [-120.28945, 37.97369], [-120.28939, 37.97364], [-120.28938, 37.97356], [-120.28943, 37.97345], [-120.28957, 37.97339], [-120.28958, 37.97324], [-120.28951, 37.97307], [-120.28935, 37.97279], [-120.28917, 37.97256], [-120.28903, 37.9724], [-120.28826, 37.97168], [-120.28807, 37.97153], [-120.28783, 37.97128], [-120.28743, 37.97059], [-120.28707, 37.9702], [-120.28631, 37.96952], [-120.28601, 37.9691], [-120.28592, 37.96878], [-120.2859, 37.9684], [-120.28596, 37.96799], [-120.28602, 37.96783], [-120.28611, 37.9677], [-120.28627, 37.96752], [-120.28648, 37.96736], [-120.28676, 37.96721], [-120.28691, 37.96715], [-120.28932, 37.96645], [-120.2895, 37.96638], [-120.28993, 37.96627], [-120.29017, 37.96627], [-120.29053, 37.96629], [-120.29081, 37.96638], [-120.29104, 37.96647], [-120.29332, 37.96789], [-120.29362, 37.96795], [-120.29374, 37.96795], [-120.29404, 37.96787], [-120.29415, 37.9678], [-120.29456, 37.96751], [-120.29468, 37.96744], [-120.29505, 37.96729], [-120.29523, 37.96725], [-120.2955, 37.96723], [-120.29634, 37.9673], [-120.29701, 37.96717], [-120.29735, 37.96716], [-120.29758, 37.96717], [-120.2978, 37.96723], [-120.29809, 37.96736], [-120.29822, 37.96746], [-120.29835, 37.96762], [-120.2984, 37.96773], [-120.29842, 37.96782], [-120.2984, 37.96837], [-120.29844, 37.96852], [-120.2985, 37.9686], [-120.29863, 37.96872], [-120.29879, 37.96882], [-120.2998, 37.96919], [-120.2998, 37.96957]]], [[[-120.18548, 37.99156], [-120.18544, 37.9952], [-120.18086, 37.99522], [-120.18089, 37.99158], [-120.18548, 37.99156]]]]}	Open Access 1	611	Tuolumne Park and Recreation District	26578	2169	Tuolumne Park and Recreation District 741	Special District 4	Recreation/Parks District 4	http://www.tuolumnerecreation.com/	Special District 4	2169	Tuolumne Park and Recreation District 726	Special District 4	Recreation/Parks District 4		Tuolumne 21	85.399	Tuolumne Park and Rec. District	0	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]);