units_with_maps

Table actions

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

6 rows where ACCESS_TYP = 1, COUNTY = 35 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 6 ✖
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
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. 0 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 0 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 0 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 0 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 0 Private Conservation 16 2
15148 15148 15147 {"type": "MultiPolygon", "coordinates": [[[[-120.41957, 39.20187], [-120.4169, 39.21534], [-120.4075, 39.2155], [-120.39824, 39.21551], [-120.40113, 39.22913], [-120.38195, 39.22954], [-120.37973, 39.21554], [-120.36287, 39.21575], [-120.36267, 39.22994], [-120.3575, 39.22992], [-120.34426, 39.22975], [-120.34426, 39.22825], [-120.34441, 39.21377], [-120.32839, 39.21429], [-120.32899, 39.20107], [-120.34482, 39.20103], [-120.34478, 39.20247], [-120.35234, 39.20247], [-120.35053, 39.18017], [-120.35009, 39.17281], [-120.34973, 39.16545], [-120.34941, 39.15824], [-120.34919, 39.15288], [-120.349, 39.14735], [-120.34886, 39.14376], [-120.36876, 39.14361], [-120.36801, 39.1291], [-120.35794, 39.12885], [-120.34815, 39.12868], [-120.34857, 39.13618], [-120.34878, 39.14199], [-120.33091, 39.14182], [-120.33022, 39.12723], [-120.34808, 39.12751], [-120.34775, 39.12113], [-120.34739, 39.1135], [-120.36773, 39.11396], [-120.36793, 39.10676], [-120.3676, 39.09886], [-120.38773, 39.09918], [-120.38759, 39.11378], [-120.37751, 39.11395], [-120.36774, 39.11397], [-120.36773, 39.11398], [-120.3679, 39.12173], [-120.36801, 39.12909], [-120.37794, 39.12928], [-120.38774, 39.12921], [-120.38806, 39.13639], [-120.38842, 39.14358], [-120.36876, 39.14362], [-120.36957, 39.15815], [-120.35927, 39.15824], [-120.35956, 39.16914], [-120.37014, 39.16917], [-120.37033, 39.17276], [-120.37065, 39.18017], [-120.3719, 39.20244], [-120.37657, 39.20243], [-120.37625, 39.19484], [-120.38104, 39.19484], [-120.38084, 39.18746], [-120.38574, 39.18741], [-120.3857, 39.18373], [-120.39066, 39.18369], [-120.39065, 39.18737], [-120.39989, 39.18729], [-120.40931, 39.18725], [-120.40928, 39.20208], [-120.41957, 39.20187]], [[-120.40087, 39.2021], [-120.40086, 39.20209], [-120.39789, 39.20215], [-120.3906, 39.20226], [-120.39063, 39.19106], [-120.38579, 39.1911], [-120.38583, 39.19479], [-120.38104, 39.19485], [-120.38125, 39.20242], [-120.38208, 39.20242], [-120.38091, 39.20906], [-120.37974, 39.21554], [-120.38901, 39.21574], [-120.39823, 39.2155], [-120.40087, 39.2021]]], [[[-120.45621, 39.20083], [-120.45598, 39.21519], [-120.44679, 39.21526], [-120.44217, 39.21531], [-120.43751, 39.21546], [-120.43762, 39.20166], [-120.44631, 39.20136], [-120.45621, 39.20083]]]]} Open Access 1 45990 American River Headwaters 29161 3003 American River Conservancy 604 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/ Non Governmental Organization 10 3003 American River Conservancy 593 Non Profit 6 Non Profit - Land Trust 10 http://northernsierrapartnership.org/american-river-headwaters/ Placer 35 10210.918 American River Headwaters 0 Private Conservation 16 2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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