calands: units_with_maps: 6 rows where COUNTY = 35 and MNG

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

6 rows where COUNTY = 35 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
3726	3726	3725	{"type": "Polygon", "coordinates": [[[-120.49309, 39.22971], [-120.49301, 39.24425], [-120.47413, 39.24417], [-120.47436, 39.2297], [-120.49309, 39.22971]]]}	Open Access 1	44723	Snow Mountain	13418	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		Placer 35	646.107	Snow Mtn.	Private Conservation 16	2
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
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
12895	12895	12894	{"type": "Polygon", "coordinates": [[[-120.40911, 39.31635], [-120.3998, 39.31639], [-120.38819, 39.31639], [-120.38819, 39.31604], [-120.38589, 39.31601], [-120.3859, 39.31548], [-120.38236, 39.31549], [-120.38235, 39.31597], [-120.38113, 39.31596], [-120.38111, 39.31642], [-120.3797, 39.31643], [-120.37969, 39.31657], [-120.3572, 39.31661], [-120.35657, 39.31635], [-120.35629, 39.31625], [-120.35591, 39.31615], [-120.35562, 39.31609], [-120.35522, 39.31605], [-120.35491, 39.31605], [-120.35347, 39.31612], [-120.35355, 39.31568], [-120.35331, 39.31568], [-120.35309, 39.31565], [-120.35282, 39.31559], [-120.35257, 39.3155], [-120.34747, 39.31352], [-120.34676, 39.31319], [-120.3461, 39.31281], [-120.34687, 39.31155], [-120.348, 39.31059], [-120.35097, 39.30932], [-120.35356, 39.30891], [-120.35348, 39.30538], [-120.35344, 39.30192], [-120.36257, 39.30197], [-120.3625, 39.29483], [-120.36247, 39.28761], [-120.3717, 39.28755], [-120.3766, 39.28742], [-120.38127, 39.28733], [-120.38122, 39.28047], [-120.38111, 39.27337], [-120.3905, 39.27317], [-120.39981, 39.27301], [-120.39979, 39.28736], [-120.38591, 39.28734], [-120.38588, 39.29096], [-120.38573, 39.29461], [-120.39037, 39.29461], [-120.39034, 39.29821], [-120.39495, 39.29823], [-120.39507, 39.30178], [-120.40436, 39.30181], [-120.40899, 39.30184], [-120.4091, 39.30542], [-120.40911, 39.31635]], [[-120.39242, 39.30178], [-120.39229, 39.30118], [-120.39082, 39.30033], [-120.39015, 39.30029], [-120.38933, 39.29924], [-120.38879, 39.29932], [-120.38846, 39.29897], [-120.38809, 39.29829], [-120.3885, 39.29781], [-120.38776, 39.29688], [-120.38598, 39.29709], [-120.38586, 39.29696], [-120.38577, 39.2961], [-120.38605, 39.29609], [-120.38598, 39.29531], [-120.38571, 39.29485], [-120.38542, 39.29445], [-120.3849, 39.29492], [-120.38476, 39.29482], [-120.38557, 39.29408], [-120.38384, 39.29319], [-120.38346, 39.29358], [-120.38332, 39.29446], [-120.38325, 39.29446], [-120.38324, 39.29431], [-120.38281, 39.29379], [-120.38197, 39.29382], [-120.38136, 39.29497], [-120.38184, 39.29536], [-120.38151, 39.29557], [-120.38097, 39.29582], [-120.38101, 39.296], [-120.38006, 39.29642], [-120.38001, 39.29635], [-120.37993, 39.29638], [-120.37997, 39.29646], [-120.37977, 39.29656], [-120.37959, 39.29669], [-120.37945, 39.2968], [-120.37927, 39.29698], [-120.37869, 39.29776], [-120.37857, 39.29795], [-120.3785, 39.29811], [-120.37845, 39.29826], [-120.37842, 39.29854], [-120.37845, 39.2997], [-120.37851, 39.30002], [-120.37867, 39.30053], [-120.37883, 39.30086], [-120.37905, 39.30119], [-120.37956, 39.30181], [-120.37885, 39.30183], [-120.37864, 39.30155], [-120.37803, 39.3004], [-120.37671, 39.30042], [-120.3767, 39.30043], [-120.37684, 39.30188], [-120.3728, 39.30198], [-120.37286, 39.30016], [-120.37174, 39.30015], [-120.37155, 39.30201], [-120.36714, 39.30196], [-120.36258, 39.30198], [-120.3627, 39.30559], [-120.36275, 39.30916], [-120.36733, 39.3092], [-120.37193, 39.3092], [-120.37655, 39.30918], [-120.38119, 39.30905], [-120.38116, 39.3122], [-120.38137, 39.31224], [-120.38125, 39.31265], [-120.38324, 39.31297], [-120.38476, 39.31239], [-120.38495, 39.31209], [-120.38601, 39.31212], [-120.38684, 39.31226], [-120.38727, 39.31242], [-120.38853, 39.31306], [-120.38845, 39.31316], [-120.38734, 39.31261], [-120.38707, 39.31318], [-120.38796, 39.31363], [-120.38792, 39.31401], [-120.3889, 39.31409], [-120.38949, 39.31395], [-120.38949, 39.3133], [-120.3892, 39.31329], [-120.38919, 39.31316], [-120.38906, 39.31315], [-120.38905, 39.31287], [-120.3888, 39.31273], [-120.38972, 39.31161], [-120.38983, 39.31103], [-120.38984, 39.31089], [-120.38985, 39.31088], [-120.38985, 39.30892], [-120.38989, 39.30856], [-120.39, 39.3082], [-120.39031, 39.30772], [-120.39057, 39.30739], [-120.39107, 39.30693], [-120.39129, 39.30652], [-120.39141, 39.30604], [-120.39133, 39.30565], [-120.39135, 39.30546], [-120.39149, 39.30501], [-120.39148, 39.305], [-120.3915, 39.30491], [-120.39204, 39.30337], [-120.39242, 39.30214], [-120.39248, 39.30213], [-120.39242, 39.30178]], [[-120.3859, 39.31298], [-120.38591, 39.31297], [-120.38583, 39.31277], [-120.38515, 39.31292], [-120.38523, 39.31312], [-120.3859, 39.31298]]]}	Open Access 1	44701	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	Placer 35	2782.195	Royal Gorge	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]);