calands: units_with_maps: 11 rows where ACCESS_TYP = 1, COUNTY = 30 and MNG

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

11 rows where ACCESS_TYP = 1, COUNTY = 30 and MNG_AGENCY = 663

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
3727	3727	3726	{"type": "Polygon", "coordinates": [[[-120.32345, 39.33671], [-120.3234, 39.34127], [-120.32299, 39.34101], [-120.32265, 39.34077], [-120.32228, 39.34045], [-120.32201, 39.34015], [-120.32153, 39.34008], [-120.32093, 39.34003], [-120.32032, 39.34001], [-120.31971, 39.34004], [-120.31923, 39.3401], [-120.31863, 39.3402], [-120.31805, 39.34034], [-120.31771, 39.34045], [-120.31717, 39.34065], [-120.31668, 39.34088], [-120.31619, 39.34104], [-120.31568, 39.34116], [-120.31508, 39.34124], [-120.31477, 39.34125], [-120.31439, 39.34124], [-120.31401, 39.34121], [-120.31363, 39.34115], [-120.31327, 39.34106], [-120.31298, 39.34097], [-120.31264, 39.34084], [-120.31231, 39.34069], [-120.31194, 39.34048], [-120.31154, 39.3402], [-120.30974, 39.33861], [-120.30976, 39.32935], [-120.30374, 39.32937], [-120.30257, 39.32779], [-120.30047, 39.327], [-120.3005, 39.32477], [-120.30262, 39.32573], [-120.30275, 39.32582], [-120.30359, 39.32655], [-120.30369, 39.32662], [-120.30385, 39.32668], [-120.30398, 39.32683], [-120.30532, 39.32712], [-120.30547, 39.32718], [-120.30564, 39.32721], [-120.30582, 39.32721], [-120.30698, 39.32728], [-120.30714, 39.32733], [-120.30729, 39.32734], [-120.30773, 39.32733], [-120.30793, 39.32728], [-120.30813, 39.32716], [-120.30826, 39.327], [-120.3083, 39.32687], [-120.30834, 39.32652], [-120.30839, 39.32651], [-120.30858, 39.32595], [-120.30977, 39.32581], [-120.30977, 39.32935], [-120.31894, 39.32949], [-120.31887, 39.3367], [-120.32345, 39.33671]]]}	Open Access 1	44733	Billy Mack Canyon	13404	3104	Truckee Donner Land Trust 673	Non Profit 6	Non Profit - Land Trust 10	http://www.tdlandtrust.org/	Non Governmental Organization 10	3104	Truckee Donner Land Trust 663	Non Profit 6	Non Profit - Land Trust 10		Nevada 30	332.597	Billy Mack Canyon	Private Conservation 16	2
3827	3827	3826	{"type": "Polygon", "coordinates": [[[-120.17654, 39.32492], [-120.17487, 39.32491], [-120.17493, 39.3262], [-120.17455, 39.3262], [-120.17317, 39.32605], [-120.17283, 39.32595], [-120.17234, 39.32577], [-120.1711, 39.32519], [-120.1711, 39.32516], [-120.17155, 39.32517], [-120.17157, 39.32479], [-120.17144, 39.32478], [-120.17146, 39.32437], [-120.17653, 39.32487], [-120.17654, 39.32492]]]}	Open Access 1	45265	Wintercreek Wetland	27653	3104	Truckee Donner Land Trust 673	Non Profit 6	Non Profit - Land Trust 10	http://www.tdlandtrust.org/	Non Governmental Organization 10	3104	Truckee Donner Land Trust 663	Non Profit 6	Non Profit - Land Trust 10		Nevada 30	11.926	Wintercreek Wetland	Private Conservation 16	2
4157	4157	4156	{"type": "Polygon", "coordinates": [[[-120.34514, 39.41737], [-120.34421, 39.41677], [-120.34406, 39.41676], [-120.32896, 39.41732], [-120.32908, 39.42472], [-120.32436, 39.42465], [-120.31983, 39.42454], [-120.32004, 39.43169], [-120.31949, 39.4321], [-120.3108, 39.43208], [-120.31057, 39.41725], [-120.32895, 39.41731], [-120.32887, 39.41663], [-120.32874, 39.40288], [-120.34493, 39.40292], [-120.34514, 39.41737]]]}	Open Access 1	44725	Independence Lake - Carpenter Ridge	13411	3104	Truckee Donner Land Trust 673	Non Profit 6	Non Profit - Land Trust 10	http://www.tdlandtrust.org/	Non Governmental Organization 10	3104	Truckee Donner Land Trust 663	Non Profit 6	Non Profit - Land Trust 10	http://tdlandtrust.org/trails-maps	Nevada 30	1023.517	Independence Lake - Carpenter Ridge	Private Conservation 16	2
7840	7840	7839	{"type": "Polygon", "coordinates": [[[-120.31439, 39.32589], [-120.30989, 39.32587], [-120.30989, 39.32587], [-120.3099, 39.32575], [-120.31057, 39.32566], [-120.31114, 39.3258], [-120.31114, 39.32582], [-120.31118, 39.32583], [-120.31147, 39.32585], [-120.31172, 39.32584], [-120.31196, 39.32579], [-120.31214, 39.32573], [-120.31231, 39.32565], [-120.31253, 39.3255], [-120.31271, 39.32531], [-120.31278, 39.32519], [-120.31276, 39.32517], [-120.31284, 39.32496], [-120.31289, 39.32477], [-120.31291, 39.32449], [-120.31283, 39.32391], [-120.31283, 39.32376], [-120.31286, 39.3236], [-120.31293, 39.32342], [-120.31302, 39.32328], [-120.3132, 39.32309], [-120.31345, 39.32296], [-120.31387, 39.32282], [-120.31401, 39.32274], [-120.31418, 39.3226], [-120.31432, 39.3224], [-120.31439, 39.32589]]]}	Open Access 1	48983	Black Wall	33678	3104	Truckee Donner Land Trust 673	Non Profit 6	Non Profit - Land Trust 10	http://www.tdlandtrust.org/	Non Governmental Organization 10	3104	Truckee Donner Land Trust 663	Non Profit 6	Non Profit - Land Trust 10	https://www.truckeedonnerlandtrust.org/	Nevada 30	11.753	Black Wall	Private Conservation 16	2
7895	7895	7894	{"type": "Polygon", "coordinates": [[[-120.29922, 39.32203], [-120.29646, 39.32199], [-120.29619, 39.32189], [-120.29604, 39.32171], [-120.29531, 39.32159], [-120.29539, 39.32128], [-120.29584, 39.32142], [-120.2959, 39.32131], [-120.29584, 39.32107], [-120.29593, 39.32107], [-120.296, 39.32135], [-120.29622, 39.32136], [-120.29622, 39.32149], [-120.2965, 39.32167], [-120.29679, 39.32181], [-120.29709, 39.32187], [-120.29719, 39.32187], [-120.29746, 39.32194], [-120.29812, 39.32159], [-120.29922, 39.32203]]]}	Open Access 1	48985	Creekside Woods	33680	3104	Truckee Donner Land Trust 673	Non Profit 6	Non Profit - Land Trust 10	http://www.tdlandtrust.org/	Non Governmental Organization 10	3104	Truckee Donner Land Trust 663	Non Profit 6	Non Profit - Land Trust 10	https://www.truckeedonnerlandtrust.org/	Nevada 30	2.295	Creekside Woods	Private Conservation 16	2
8040	8040	8039	{"type": "MultiPolygon", "coordinates": [[[[-120.41385, 39.31655], [-120.41384, 39.31921], [-120.41343, 39.31919], [-120.41282, 39.31875], [-120.41271, 39.31852], [-120.41259, 39.3185], [-120.41233, 39.31836], [-120.412, 39.31825], [-120.41182, 39.31811], [-120.41133, 39.31805], [-120.41101, 39.31794], [-120.41066, 39.3175], [-120.4103, 39.31718], [-120.40992, 39.317], [-120.40933, 39.31679], [-120.40872, 39.31671], [-120.40787, 39.31671], [-120.40744, 39.31683], [-120.40687, 39.3169], [-120.40612, 39.3169], [-120.40579, 39.31706], [-120.40456, 39.31715], [-120.40394, 39.31713], [-120.40334, 39.31705], [-120.40231, 39.31658], [-120.40209, 39.31651], [-120.40189, 39.31648], [-120.40153, 39.31647], [-120.40118, 39.31648], [-120.40085, 39.31661], [-120.4007, 39.31678], [-120.40012, 39.31706], [-120.39978, 39.31717], [-120.39977, 39.31629], [-120.41385, 39.31655]]], [[[-120.4117, 39.31863], [-120.41116, 39.31866], [-120.41086, 39.31879], [-120.4098, 39.31934], [-120.4091, 39.3195], [-120.40852, 39.31953], [-120.40761, 39.31939], [-120.40694, 39.31937], [-120.40597, 39.31958], [-120.40564, 39.3197], [-120.40535, 39.31977], [-120.40522, 39.31978], [-120.40482, 39.31977], [-120.40444, 39.31971], [-120.40431, 39.31968], [-120.40369, 39.31941], [-120.40314, 39.31933], [-120.40241, 39.31927], [-120.40115, 39.31902], [-120.40052, 39.31907], [-120.39978, 39.31934], [-120.39978, 39.31737], [-120.39992, 39.31755], [-120.40026, 39.31782], [-120.40048, 39.31823], [-120.40077, 39.31846], [-120.40164, 39.31848], [-120.40219, 39.31826], [-120.40327, 39.31838], [-120.40413, 39.31853], [-120.40459, 39.3189], [-120.40572, 39.31895], [-120.40642, 39.31906], [-120.407, 39.3191], [-120.40768, 39.31884], [-120.40809, 39.3185], [-120.40851, 39.31836], [-120.40912, 39.31812], [-120.41036, 39.31813], [-120.41111, 39.31851], [-120.4117, 39.31863]]], [[[-120.41384, 39.31927], [-120.41384, 39.31982], [-120.40913, 39.31988], [-120.39979, 39.31996], [-120.39978, 39.31941], [-120.40055, 39.31913], [-120.40118, 39.31909], [-120.4024, 39.31933], [-120.40313, 39.31938], [-120.40365, 39.31948], [-120.40432, 39.31974], [-120.40483, 39.31983], [-120.40535, 39.31983], [-120.40599, 39.31964], [-120.40698, 39.31943], [-120.40758, 39.31944], [-120.40854, 39.31959], [-120.40914, 39.31954], [-120.40985, 39.31939], [-120.41121, 39.31871], [-120.41184, 39.31868], [-120.41211, 39.31876], [-120.41278, 39.3188], [-120.41338, 39.31924], [-120.41384, 39.31927]]], [[[-120.41275, 39.31875], [-120.41208, 39.31869], [-120.41183, 39.31858], [-120.41117, 39.31846], [-120.41043, 39.31809], [-120.40998, 39.31805], [-120.40912, 39.31807], [-120.40806, 39.31843], [-120.40764, 39.3188], [-120.40701, 39.31904], [-120.40641, 39.319], [-120.40571, 39.31887], [-120.40464, 39.31883], [-120.40416, 39.31847], [-120.40307, 39.31828], [-120.40213, 39.3182], [-120.40164, 39.31843], [-120.40078, 39.31839], [-120.40056, 39.31821], [-120.4003, 39.31777], [-120.40002, 39.31752], [-120.39983, 39.31727], [-120.39984, 39.31723], [-120.39986, 39.3172], [-120.40016, 39.31712], [-120.40075, 39.31682], [-120.40091, 39.31666], [-120.4012, 39.31656], [-120.40153, 39.31654], [-120.40191, 39.31656], [-120.40209, 39.31659], [-120.4023, 39.31666], [-120.40258, 39.31677], [-120.40336, 39.3171], [-120.40395, 39.3172], [-120.40494, 39.3172], [-120.40583, 39.31711], [-120.40615, 39.31696], [-120.40689, 39.31695], [-120.40749, 39.3169], [-120.40788, 39.31677], [-120.40871, 39.31677], [-120.4093, 39.31686], [-120.41017, 39.3172], [-120.41034, 39.31732], [-120.41058, 39.31755], [-120.41078, 39.31782], [-120.41096, 39.31799], [-120.41136, 39.31811], [-120.41179, 39.31816], [-120.41199, 39.3183], [-120.41232, 39.31844], [-120.41253, 39.31856], [-120.41266, 39.31857], [-120.41275, 39.31875]]]]}	Open Access 1	48987	Royal Gorge	13417	3104	Truckee Donner Land Trust 673	Non Profit 6	Non Profit - Land Trust 10	http://www.tdlandtrust.org/	Non Governmental Organization 10	3104	Truckee Donner Land Trust 663	Non Profit 6	Non Profit - Land Trust 10	http://tdlandtrust.org/royal-gorge	Nevada 30	109.491	Royal Gorge	Private Conservation 16	2
8068	8068	8067	{"type": "Polygon", "coordinates": [[[-120.1983, 39.31826], [-120.19732, 39.31893], [-120.19724, 39.31898], [-120.19794, 39.3181], [-120.1983, 39.31826]]]}	Open Access 1	48988	Hoseit	33682	3104	Truckee Donner Land Trust 673	Non Profit 6	Non Profit - Land Trust 10	http://www.tdlandtrust.org/	Non Governmental Organization 10	3104	Truckee Donner Land Trust 663	Non Profit 6	Non Profit - Land Trust 10	https://www.truckeedonnerlandtrust.org/	Nevada 30	0.508	Hoseit	Private Conservation 16	2
11171	11171	11170	{"type": "Polygon", "coordinates": [[[-120.28244, 39.40266], [-120.28231, 39.40268], [-120.28233, 39.40632], [-120.27294, 39.40633], [-120.2729, 39.40267], [-120.2683, 39.40265], [-120.26824, 39.3989], [-120.2589, 39.39888], [-120.25877, 39.39522], [-120.25396, 39.39525], [-120.25388, 39.3879], [-120.25851, 39.38786], [-120.25866, 39.39153], [-120.26352, 39.3915], [-120.26339, 39.38783], [-120.27272, 39.38778], [-120.27276, 39.39143], [-120.27129, 39.39145], [-120.27079, 39.39143], [-120.26353, 39.3915], [-120.26365, 39.39517], [-120.27279, 39.39517], [-120.2728, 39.39515], [-120.27279, 39.39492], [-120.27492, 39.39514], [-120.27539, 39.39516], [-120.28214, 39.39514], [-120.28228, 39.40185], [-120.28244, 39.40266]]]}	Open Access 1	48008	Lower Carpenter Valley	32437	3104	Truckee Donner Land Trust 673	Non Profit 6	Non Profit - Land Trust 10	http://www.tdlandtrust.org/	Non Governmental Organization 10	3104	Truckee Donner Land Trust 663	Non Profit 6	Non Profit - Land Trust 10	http://tdlandtrust.org/carpenter-valley-0	Nevada 30	617.118	Lower Carpenter Valley	Private Conservation 16	2
14584	14584	14583	{"type": "Polygon", "coordinates": [[[-120.32338, 39.34317], [-120.32337, 39.34391], [-120.30973, 39.34397], [-120.30044, 39.34397], [-120.30043, 39.34032], [-120.29116, 39.34034], [-120.29115, 39.34396], [-120.28206, 39.3438], [-120.28198, 39.33642], [-120.27966, 39.33639], [-120.27965, 39.33476], [-120.28196, 39.33477], [-120.28191, 39.33037], [-120.2869, 39.33201], [-120.28798, 39.33307], [-120.28812, 39.33318], [-120.28832, 39.33329], [-120.28851, 39.33336], [-120.28871, 39.3334], [-120.28896, 39.33341], [-120.2892, 39.33338], [-120.28943, 39.33331], [-120.28967, 39.33319], [-120.28981, 39.33307], [-120.28994, 39.33291], [-120.29003, 39.33273], [-120.29006, 39.3326], [-120.29007, 39.3324], [-120.29163, 39.33241], [-120.2958, 39.32982], [-120.2958, 39.33668], [-120.30043, 39.33667], [-120.30044, 39.33031], [-120.30249, 39.3316], [-120.30448, 39.33444], [-120.30612, 39.33836], [-120.30973, 39.34078], [-120.31011, 39.34112], [-120.31043, 39.34138], [-120.31078, 39.34162], [-120.31114, 39.34184], [-120.31153, 39.34204], [-120.31193, 39.34222], [-120.31235, 39.34237], [-120.31288, 39.34253], [-120.31344, 39.34266], [-120.31389, 39.34273], [-120.31435, 39.34278], [-120.31481, 39.3428], [-120.31527, 39.34279], [-120.31573, 39.34277], [-120.31619, 39.34271], [-120.31663, 39.34263], [-120.31729, 39.34247], [-120.3183, 39.34214], [-120.31859, 39.34207], [-120.31895, 39.34201], [-120.31924, 39.34197], [-120.31962, 39.34196], [-120.31999, 39.34196], [-120.32028, 39.34199], [-120.32072, 39.34205], [-120.32101, 39.34212], [-120.32163, 39.34232], [-120.32195, 39.34246], [-120.32238, 39.3427], [-120.3226, 39.34285], [-120.32291, 39.3431], [-120.32338, 39.34317]]]}	Open Access 1	44734	Johnson Canyon	29289	3104	Truckee Donner Land Trust 673	Non Profit 6	Non Profit - Land Trust 10	http://www.tdlandtrust.org/	Non Governmental Organization 10	3104	Truckee Donner Land Trust 663	Non Profit 6	Non Profit - Land Trust 10	http://tdlandtrust.org/johnson-canyon	Nevada 30	641.093	Johnson Canyon	Private Conservation 16	2
14585	14585	14584	{"type": "Polygon", "coordinates": [[[-120.1985, 39.341], [-120.19845, 39.34424], [-120.17943, 39.34455], [-120.17943, 39.34424], [-120.17969, 39.34396], [-120.18014, 39.34412], [-120.18061, 39.34426], [-120.18171, 39.34424], [-120.18247, 39.3438], [-120.18272, 39.34372], [-120.18366, 39.34372], [-120.18416, 39.34369], [-120.18476, 39.34353], [-120.18527, 39.34319], [-120.18572, 39.34264], [-120.18598, 39.34247], [-120.18628, 39.34233], [-120.18721, 39.34214], [-120.18769, 39.34188], [-120.18792, 39.34173], [-120.18805, 39.34153], [-120.1888, 39.34074], [-120.18939, 39.3409], [-120.18979, 39.34087], [-120.19005, 39.34078], [-120.19057, 39.34047], [-120.19082, 39.33998], [-120.19107, 39.33982], [-120.19121, 39.33957], [-120.19121, 39.33919], [-120.19116, 39.33854], [-120.19179, 39.33851], [-120.1985, 39.341]]]}	Open Access 1	44735	Pineforest	23688	3104	Truckee Donner Land Trust 673	Non Profit 6	Non Profit - Land Trust 10	http://www.tdlandtrust.org/	Non Governmental Organization 10	3104	Truckee Donner Land Trust 663	Non Profit 6	Non Profit - Land Trust 10		Nevada 30	129.963	Pineforest	Private Conservation 16	2
14586	14586	14585	{"type": "Polygon", "coordinates": [[[-120.14177, 39.35025], [-120.14174, 39.35296], [-120.14057, 39.35297], [-120.14057, 39.35477], [-120.14173, 39.35477], [-120.14171, 39.35785], [-120.14068, 39.35831], [-120.1396, 39.35873], [-120.13963, 39.35209], [-120.13046, 39.35212], [-120.13046, 39.35028], [-120.13276, 39.35026], [-120.13814, 39.35026], [-120.13815, 39.35083], [-120.13887, 39.35083], [-120.13888, 39.35026], [-120.14177, 39.35025]], [[-120.13668, 39.35083], [-120.13667, 39.3514], [-120.1374, 39.3514], [-120.1374, 39.35083], [-120.13668, 39.35083]], [[-120.14103, 39.35141], [-120.14029, 39.3514], [-120.14029, 39.35197], [-120.14102, 39.35197], [-120.14103, 39.35141]]]}	Open Access 1	44737	Airport Flats	15301	3104	Truckee Donner Land Trust 673	Non Profit 6	Non Profit - Land Trust 10	http://www.tdlandtrust.org/	Non Governmental Organization 10	3104	Truckee Donner Land Trust 663	Non Profit 6	Non Profit - Land Trust 10		Nevada 30	72.37	Airport Flats	Private Conservation 16	2

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]);