calands: units_with_maps: 8 rows where MNG_AG_TYP = 10 and PARK_URL = "https://www.truckeedonnerlandtrust.org/"

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

8 rows where MNG_AG_TYP = 10 and PARK_URL = "https://www.truckeedonnerlandtrust.org/"

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
4447	4447	4446	{"type": "Polygon", "coordinates": [[[-120.10779, 39.3011], [-120.10473, 39.3011], [-120.09986, 39.30107], [-120.10002, 39.29612], [-120.10026, 39.29048], [-120.10045, 39.28641], [-120.10379, 39.28646], [-120.10371, 39.28704], [-120.1031, 39.28967], [-120.10301, 39.29032], [-120.10298, 39.29084], [-120.103, 39.29136], [-120.10308, 39.29188], [-120.1032, 39.29243], [-120.1043, 39.29629], [-120.1045, 39.29685], [-120.10476, 39.2974], [-120.10499, 39.2978], [-120.10533, 39.29832], [-120.10681, 39.30022], [-120.10701, 39.30045], [-120.10723, 39.30066], [-120.10748, 39.30087], [-120.10779, 39.3011]]]}	Open Access 1	48990	Elizabethtown Meadows	33684	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/	Placer 35	141.248	Elizabethtown Meadows	Private Conservation 16	2
4904	4904	4903	{"type": "Polygon", "coordinates": [[[-120.29165, 39.28907], [-120.28251, 39.28896], [-120.28251, 39.28535], [-120.29164, 39.28546], [-120.29165, 39.28907]]]}	Restricted Access 2	48986	Hooper LaPlante	33681	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/	Placer 35	78.05	Hooper LaPlante	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
7877	7877	7876	{"type": "MultiPolygon", "coordinates": [[[[-120.41932, 39.50452], [-120.40996, 39.5045], [-120.40983, 39.49723], [-120.41144, 39.49703], [-120.41156, 39.49713], [-120.41186, 39.49733], [-120.41245, 39.49781], [-120.41304, 39.4986], [-120.41371, 39.49914], [-120.41445, 39.49948], [-120.41551, 39.49975], [-120.41757, 39.49998], [-120.41819, 39.49999], [-120.4186, 39.49998], [-120.41916, 39.4999], [-120.41917, 39.50318], [-120.41932, 39.50452]]], [[[-120.41916, 39.49969], [-120.41855, 39.49978], [-120.41819, 39.49979], [-120.41757, 39.49977], [-120.41561, 39.49951], [-120.41453, 39.49928], [-120.41386, 39.49895], [-120.41328, 39.49844], [-120.41274, 39.49765], [-120.41186, 39.497], [-120.41914, 39.49739], [-120.41916, 39.49969]]]]}	Open Access 1	48984	Coppins Meadow	33679	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/	Sierra 58	155.769	Coppins Meadow	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
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
8343	8343	8342	{"type": "MultiPolygon", "coordinates": [[[[-120.16113, 39.30443], [-120.161, 39.30681], [-120.16094, 39.30684], [-120.16084, 39.30685], [-120.16034, 39.30674], [-120.16016, 39.30673], [-120.15998, 39.30674], [-120.15982, 39.30607], [-120.15882, 39.30526], [-120.15875, 39.30526], [-120.15752, 39.30645], [-120.1574, 39.30791], [-120.15721, 39.30831], [-120.15671, 39.30878], [-120.15608, 39.30867], [-120.15588, 39.30865], [-120.15567, 39.30866], [-120.15538, 39.30872], [-120.15527, 39.30854], [-120.15463, 39.30867], [-120.15362, 39.30924], [-120.15401, 39.30966], [-120.15498, 39.30951], [-120.15519, 39.30979], [-120.15535, 39.31021], [-120.15339, 39.3103], [-120.15282, 39.31052], [-120.15294, 39.31152], [-120.15585, 39.31149], [-120.15575, 39.31182], [-120.15571, 39.31215], [-120.15569, 39.31218], [-120.15565, 39.3122], [-120.15565, 39.31223], [-120.15395, 39.31225], [-120.15336, 39.31222], [-120.15334, 39.31225], [-120.15285, 39.31227], [-120.15221, 39.31235], [-120.15158, 39.31248], [-120.15098, 39.31268], [-120.15078, 39.31272], [-120.1507, 39.31269], [-120.15061, 39.31274], [-120.15063, 39.31279], [-120.15027, 39.31296], [-120.15023, 39.31291], [-120.15006, 39.31303], [-120.15006, 39.31304], [-120.14993, 39.31311], [-120.14923, 39.31352], [-120.14917, 39.31377], [-120.14914, 39.31379], [-120.14913, 39.31357], [-120.14677, 39.31359], [-120.14677, 39.31324], [-120.14578, 39.31269], [-120.1443, 39.31271], [-120.14205, 39.31179], [-120.14207, 39.30815], [-120.14681, 39.30811], [-120.14679, 39.31176], [-120.15152, 39.31172], [-120.15157, 39.30806], [-120.15625, 39.30802], [-120.15637, 39.30444], [-120.16113, 39.30443]]], [[[-120.16094, 39.30991], [-120.1609, 39.31526], [-120.15064, 39.31538], [-120.15031, 39.31522], [-120.15031, 39.31447], [-120.14913, 39.31448], [-120.14914, 39.31421], [-120.14945, 39.31389], [-120.14968, 39.31384], [-120.15009, 39.31348], [-120.15032, 39.31331], [-120.15034, 39.31332], [-120.15053, 39.31326], [-120.1505, 39.3132], [-120.15081, 39.31303], [-120.15088, 39.31308], [-120.15098, 39.31303], [-120.15096, 39.31295], [-120.15127, 39.31282], [-120.15155, 39.31273], [-120.1516, 39.31274], [-120.15187, 39.31266], [-120.15187, 39.31264], [-120.15229, 39.31256], [-120.15293, 39.31249], [-120.15365, 39.31248], [-120.15368, 39.31251], [-120.15395, 39.3125], [-120.15405, 39.31247], [-120.15534, 39.31246], [-120.15611, 39.31244], [-120.1565, 39.31241], [-120.15659, 39.31243], [-120.15697, 39.31237], [-120.15697, 39.31235], [-120.15762, 39.31221], [-120.15824, 39.31201], [-120.15882, 39.31175], [-120.15884, 39.31177], [-120.15915, 39.31161], [-120.15914, 39.31158], [-120.15946, 39.31137], [-120.15951, 39.31141], [-120.1598, 39.3112], [-120.1602, 39.31084], [-120.16054, 39.31045], [-120.16058, 39.31046], [-120.16077, 39.31019], [-120.16094, 39.30991]]], [[[-120.16099, 39.307], [-120.16093, 39.30797], [-120.16094, 39.30883], [-120.16083, 39.30922], [-120.16069, 39.30956], [-120.16041, 39.31003], [-120.16034, 39.31017], [-120.16022, 39.31033], [-120.16005, 39.31049], [-120.15976, 39.31082], [-120.15947, 39.31106], [-120.15899, 39.31139], [-120.15846, 39.31167], [-120.15788, 39.3119], [-120.15728, 39.31207], [-120.15665, 39.31218], [-120.15602, 39.31222], [-120.15601, 39.31219], [-120.15596, 39.31217], [-120.15594, 39.31214], [-120.15596, 39.31194], [-120.15609, 39.31149], [-120.15666, 39.31143], [-120.15704, 39.31135], [-120.1574, 39.31125], [-120.15775, 39.31113], [-120.15809, 39.31098], [-120.15855, 39.31072], [-120.15883, 39.31051], [-120.15921, 39.31017], [-120.15953, 39.3098], [-120.15977, 39.30939], [-120.1594, 39.30872], [-120.15948, 39.30839], [-120.16009, 39.30815], [-120.16001, 39.30757], [-120.16004, 39.30719], [-120.16006, 39.3071], [-120.16, 39.30685], [-120.16019, 39.30684], [-120.16037, 39.30685], [-120.1607, 39.30694], [-120.1609, 39.30696], [-120.16099, 39.307]]]]}	Open Access 1	48989	Hopkins Ranch	33683	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/	Placer 35	218.873	Hopkins Ranch	Private Conservation 16	2
8344	8344	8343	{"type": "Polygon", "coordinates": [[[-120.14205, 39.31014], [-120.14205, 39.31179], [-120.14159, 39.31159], [-120.14142, 39.31155], [-120.14118, 39.31144], [-120.14071, 39.31122], [-120.14026, 39.31097], [-120.13962, 39.31056], [-120.13965, 39.31052], [-120.13913, 39.31012], [-120.13866, 39.30967], [-120.13837, 39.30935], [-120.13739, 39.30819], [-120.13759, 39.30818], [-120.13757, 39.30655], [-120.13761, 39.30664], [-120.13765, 39.30667], [-120.13764, 39.30672], [-120.1378, 39.30701], [-120.13801, 39.30727], [-120.13812, 39.30746], [-120.1382, 39.30766], [-120.13828, 39.30797], [-120.13839, 39.30823], [-120.13844, 39.30843], [-120.13858, 39.30862], [-120.13871, 39.30869], [-120.1392, 39.30878], [-120.13943, 39.30887], [-120.1397, 39.3089], [-120.1398, 39.30895], [-120.13993, 39.30905], [-120.14001, 39.30908], [-120.14026, 39.30914], [-120.14057, 39.30917], [-120.14068, 39.30921], [-120.14083, 39.3093], [-120.14133, 39.30954], [-120.14151, 39.30965], [-120.14167, 39.30977], [-120.14195, 39.31007], [-120.14205, 39.31014]]]}	Open Access 1	48991	Keilhofer	33685	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/	Placer 35	17.421	Keilhofer	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]);