units_with_maps

Table actions

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

1 row where ACCESS_TYP = 4, AGNCY_TYP = 10 and MNG_AGENCY = 492

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Mendocino Land Trust · 1 ✖

ACCESS_TYP 1

  • Unknown Access · 1 ✖
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
3997 3997 3996 {"type": "MultiPolygon", "coordinates": [[[[-123.41974, 39.40958], [-123.41971, 39.41004], [-123.41961, 39.41068], [-123.41961, 39.41086], [-123.42009, 39.41226], [-123.42016, 39.41249], [-123.42017, 39.41254], [-123.42014, 39.4126], [-123.41996, 39.41277], [-123.4196, 39.41306], [-123.41918, 39.41332], [-123.41917, 39.41315], [-123.41925, 39.4096], [-123.41974, 39.40958]]], [[[-123.42502, 39.41343], [-123.42496, 39.41356], [-123.42481, 39.41372], [-123.42462, 39.41382], [-123.42433, 39.41389], [-123.42395, 39.41386], [-123.42383, 39.41386], [-123.42403, 39.4137], [-123.42421, 39.41349], [-123.42432, 39.41333], [-123.42439, 39.41302], [-123.42436, 39.41285], [-123.42428, 39.41259], [-123.42419, 39.41243], [-123.42394, 39.41213], [-123.42333, 39.41113], [-123.42309, 39.41079], [-123.42302, 39.41058], [-123.42303, 39.41046], [-123.42441, 39.41035], [-123.42458, 39.41098], [-123.42457, 39.41109], [-123.42437, 39.41154], [-123.42416, 39.4119], [-123.42414, 39.41215], [-123.42424, 39.41241], [-123.42491, 39.41307], [-123.42498, 39.4132], [-123.42502, 39.41343]]], [[[-123.43275, 39.41761], [-123.43185, 39.41718], [-123.4317, 39.41708], [-123.43161, 39.417], [-123.43156, 39.41691], [-123.43152, 39.41669], [-123.43156, 39.4165], [-123.43166, 39.41629], [-123.43185, 39.41572], [-123.43275, 39.41761]]], [[[-123.43767, 39.41665], [-123.4376, 39.41888], [-123.43737, 39.4187], [-123.43708, 39.41859], [-123.43676, 39.41855], [-123.43611, 39.41858], [-123.43713, 39.41725], [-123.43569, 39.41667], [-123.43767, 39.41665]]], [[[-123.4374, 39.41943], [-123.43731, 39.41961], [-123.43722, 39.41967], [-123.43713, 39.41971], [-123.43699, 39.41973], [-123.43681, 39.41974], [-123.43662, 39.41973], [-123.43644, 39.41968], [-123.43561, 39.4194], [-123.43621, 39.41889], [-123.43625, 39.41882], [-123.43675, 39.4188], [-123.43699, 39.41883], [-123.43719, 39.4189], [-123.43735, 39.41903], [-123.43741, 39.41916], [-123.43742, 39.41931], [-123.4374, 39.41943]]], [[[-123.42407, 39.41301], [-123.42402, 39.41324], [-123.42394, 39.41335], [-123.42377, 39.41355], [-123.42346, 39.4138], [-123.42334, 39.41383], [-123.42313, 39.41383], [-123.4221, 39.41366], [-123.42194, 39.41366], [-123.4217, 39.41371], [-123.42151, 39.41377], [-123.42093, 39.41413], [-123.42061, 39.41437], [-123.42029, 39.41464], [-123.41998, 39.41497], [-123.4199, 39.4151], [-123.41982, 39.41528], [-123.4198, 39.41543], [-123.41979, 39.41567], [-123.41985, 39.4159], [-123.41999, 39.41623], [-123.42027, 39.41661], [-123.42042, 39.41675], [-123.42067, 39.41691], [-123.42136, 39.41727], [-123.42171, 39.4176], [-123.42197, 39.41791], [-123.42202, 39.41799], [-123.42208, 39.41817], [-123.42216, 39.41854], [-123.42218, 39.41881], [-123.42217, 39.41906], [-123.4221, 39.41962], [-123.42211, 39.41974], [-123.42222, 39.41992], [-123.42236, 39.42006], [-123.42257, 39.42017], [-123.42284, 39.42029], [-123.42292, 39.42033], [-123.42316, 39.4206], [-123.42325, 39.42073], [-123.4233, 39.42085], [-123.4233, 39.42097], [-123.42325, 39.4211], [-123.42318, 39.42122], [-123.42307, 39.4213], [-123.4228, 39.4214], [-123.42232, 39.42147], [-123.42213, 39.42144], [-123.42196, 39.42137], [-123.42179, 39.42127], [-123.42165, 39.42117], [-123.42144, 39.42094], [-123.42121, 39.42063], [-123.42112, 39.42036], [-123.42112, 39.42029], [-123.42115, 39.42021], [-123.42139, 39.41992], [-123.42156, 39.41961], [-123.42165, 39.41939], [-123.42175, 39.41902], [-123.42176, 39.41873], [-123.42171, 39.41857], [-123.42165, 39.41847], [-123.42151, 39.4183], [-123.42127, 39.41808], [-123.421, 39.41793], [-123.42066, 39.41779], [-123.42046, 39.41777], [-123.4203, 39.41772], [-123.42004, 39.41755], [-123.41983, 39.41747], [-123.41937, 39.41735], [-123.41922, 39.41727], [-123.41916, 39.41366], [-123.41981, 39.41325], [-123.4202, 39.41294], [-123.42042, 39.41272], [-123.42048, 39.41257], [-123.42048, 39.41246], [-123.4204, 39.41219], [-123.41992, 39.41083], [-123.41992, 39.4107], [-123.42003, 39.41006], [-123.42006, 39.40957], [-123.42352, 39.40953], [-123.42334, 39.40956], [-123.42315, 39.40963], [-123.42309, 39.40967], [-123.42299, 39.40979], [-123.42284, 39.41001], [-123.42272, 39.41025], [-123.4227, 39.41061], [-123.42276, 39.41082], [-123.4228, 39.4109], [-123.42304, 39.41124], [-123.42366, 39.41224], [-123.4239, 39.41254], [-123.42398, 39.41268], [-123.42405, 39.4129], [-123.42407, 39.41301]]], [[[-123.43757, 39.41975], [-123.43757, 39.42032], [-123.43489, 39.42036], [-123.43503, 39.42411], [-123.43485, 39.42411], [-123.43471, 39.42373], [-123.43442, 39.42344], [-123.43367, 39.42296], [-123.43348, 39.42286], [-123.43334, 39.42273], [-123.43326, 39.42255], [-123.43332, 39.42222], [-123.43352, 39.42143], [-123.43361, 39.42092], [-123.43336, 39.42048], [-123.43275, 39.42019], [-123.43127, 39.41938], [-123.43106, 39.41917], [-123.431, 39.41904], [-123.43101, 39.41891], [-123.43103, 39.41878], [-123.43111, 39.41861], [-123.43119, 39.41853], [-123.43135, 39.41848], [-123.43163, 39.41847], [-123.43188, 39.41849], [-123.43213, 39.41853], [-123.43241, 39.41861], [-123.43331, 39.41891], [-123.43372, 39.41985], [-123.43534, 39.41981], [-123.43546, 39.41962], [-123.43632, 39.41991], [-123.43655, 39.41997], [-123.43681, 39.41999], [-123.43703, 39.41998], [-123.43724, 39.41994], [-123.43741, 39.41987], [-123.43757, 39.41975]]], [[[-123.43436, 39.42412], [-123.4328, 39.42416], [-123.4329, 39.42602], [-123.4261, 39.42607], [-123.426, 39.42423], [-123.42371, 39.42426], [-123.42362, 39.42242], [-123.4192, 39.42247], [-123.41909, 39.42059], [-123.41925, 39.42057], [-123.41921, 39.41757], [-123.41972, 39.4177], [-123.41989, 39.41777], [-123.42015, 39.41794], [-123.42037, 39.418], [-123.42056, 39.41803], [-123.42084, 39.41814], [-123.42104, 39.41825], [-123.42125, 39.41845], [-123.42137, 39.41859], [-123.42144, 39.41874], [-123.42143, 39.41899], [-123.42134, 39.41934], [-123.42127, 39.41951], [-123.4211, 39.4198], [-123.42085, 39.42012], [-123.4208, 39.42028], [-123.42081, 39.4204], [-123.42091, 39.42073], [-123.42117, 39.42108], [-123.42142, 39.42134], [-123.42178, 39.42157], [-123.42203, 39.42168], [-123.42232, 39.42171], [-123.42287, 39.42164], [-123.42307, 39.42158], [-123.42325, 39.42151], [-123.42342, 39.42137], [-123.42354, 39.4212], [-123.42362, 39.421], [-123.42361, 39.4208], [-123.42355, 39.42065], [-123.42343, 39.42047], [-123.42326, 39.42027], [-123.42315, 39.42016], [-123.42303, 39.42008], [-123.42274, 39.41997], [-123.42258, 39.41988], [-123.42249, 39.41979], [-123.42242, 39.41967], [-123.42249, 39.41907], [-123.4225, 39.4188], [-123.42247, 39.41852], [-123.42239, 39.41812], [-123.42232, 39.41791], [-123.42226, 39.41779], [-123.42197, 39.41745], [-123.42158, 39.41709], [-123.42085, 39.4167], [-123.42063, 39.41657], [-123.42054, 39.41648], [-123.42028, 39.41613], [-123.42016, 39.41584], [-123.42011, 39.41565], [-123.42011, 39.41545], [-123.42014, 39.41533], [-123.42019, 39.4152], [-123.42026, 39.4151], [-123.42054, 39.41478], [-123.42084, 39.41454], [-123.42119, 39.41429], [-123.42168, 39.41398], [-123.422, 39.41391], [-123.42208, 39.41391], [-123.42304, 39.41407], [-123.42266, 39.41423], [-123.42198, 39.4144], [-123.4218, 39.41449], [-123.42155, 39.41489], [-123.42151, 39.41504], [-123.4215, 39.41522], [-123.42154, 39.41535], [-123.42163, 39.41548], [-123.42169, 39.41551], [-123.422, 39.41562], [-123.42237, 39.41573], [-123.42269, 39.41576], [-123.42279, 39.41579], [-123.42316, 39.41601], [-123.42374, 39.41653], [-123.42381, 39.41687], [-123.42399, 39.41722], [-123.42426, 39.41756], [-123.42479, 39.41816], [-123.42492, 39.41827], [-123.42506, 39.41836], [-123.42576, 39.41864], [-123.42595, 39.41876], [-123.42609, 39.41892], [-123.42624, 39.41916], [-123.42636, 39.41947], [-123.42646, 39.4196], [-123.42672, 39.41973], [-123.42717, 39.41987], [-123.42731, 39.41994], [-123.42742, 39.42], [-123.42762, 39.42017], [-123.42765, 39.42023], [-123.42767, 39.4203], [-123.42766, 39.42047], [-123.42757, 39.42077], [-123.42746, 39.42091], [-123.42734, 39.421], [-123.427, 39.4212], [-123.42684, 39.42131], [-123.4267, 39.42147], [-123.4266, 39.42169], [-123.42661, 39.42188], [-123.42672, 39.42211], [-123.42674, 39.42222], [-123.42674, 39.4225], [-123.42677, 39.42271], [-123.42686, 39.4229], [-123.42776, 39.42376], [-123.42852, 39.42437], [-123.42877, 39.42449], [-123.42909, 39.42454], [-123.42944, 39.42454], [-123.42971, 39.42447], [-123.42992, 39.42435], [-123.42997, 39.42431], [-123.43008, 39.42416], [-123.43015, 39.42384], [-123.43013, 39.42366], [-123.43007, 39.4235], [-123.42995, 39.42332], [-123.42973, 39.42318], [-123.42952, 39.42309], [-123.42933, 39.42307], [-123.42869, 39.42305], [-123.42844, 39.423], [-123.42823, 39.42289], [-123.42787, 39.42253], [-123.4278, 39.42242], [-123.42776, 39.42232], [-123.42768, 39.42188], [-123.42771, 39.42179], [-123.42794, 39.42155], [-123.42872, 39.42107], [-123.42871, 39.42078], [-123.42854, 39.42087], [-123.42796, 39.42121], [-123.42771, 39.42137], [-123.42757, 39.42151], [-123.42743, 39.42167], [-123.42738, 39.42178], [-123.42736, 39.42188], [-123.4274, 39.42211], [-123.42745, 39.42236], [-123.42751, 39.42252], [-123.42761, 39.42267], [-123.42802, 39.42308], [-123.42831, 39.42322], [-123.42864, 39.4233], [-123.42942, 39.42333], [-123.42955, 39.42338], [-123.4297, 39.42349], [-123.42978, 39.42359], [-123.42981, 39.4237], [-123.42983, 39.42383], [-123.42977, 39.42409], [-123.42971, 39.42416], [-123.42956, 39.42425], [-123.42936, 39.4243], [-123.42912, 39.4243], [-123.42891, 39.42426], [-123.42872, 39.42418], [-123.428, 39.4236], [-123.42714, 39.42277], [-123.42708, 39.42266], [-123.42705, 39.42249], [-123.42706, 39.4222], [-123.42703, 39.42205], [-123.42693, 39.42183], [-123.42692, 39.42173], [-123.42699, 39.42158], [-123.42708, 39.42147], [-123.42755, 39.42119], [-123.4277, 39.42108], [-123.42787, 39.42086], [-123.42796, 39.42056], [-123.42799, 39.42026], [-123.42796, 39.42015], [-123.42789, 39.42004], [-123.42765, 39.41983], [-123.42749, 39.41973], [-123.42731, 39.41965], [-123.42686, 39.41951], [-123.4267, 39.41943], [-123.42665, 39.41937], [-123.42653, 39.41905], [-123.42636, 39.4188], [-123.42619, 39.4186], [-123.42593, 39.41843], [-123.42523, 39.41815], [-123.42514, 39.41809], [-123.42504, 39.41801], [-123.42453, 39.41743], [-123.42428, 39.41711], [-123.42412, 39.4168], [-123.42406, 39.41651], [-123.42401, 39.41639], [-123.42384, 39.41623], [-123.42337, 39.41583], [-123.42293, 39.41557], [-123.42277, 39.41552], [-123.42246, 39.41549], [-123.42213, 39.4154], [-123.42187, 39.4153], [-123.42184, 39.41526], [-123.42182, 39.41518], [-123.42185, 39.41498], [-123.42206, 39.41465], [-123.42211, 39.41462], [-123.42279, 39.41445], [-123.42325, 39.41426], [-123.42361, 39.41414], [-123.42384, 39.41411], [-123.42398, 39.41411], [-123.42437, 39.41414], [-123.42476, 39.41405], [-123.42505, 39.41388], [-123.42523, 39.41369], [-123.42534, 39.41348], [-123.42534, 39.41342], [-123.42529, 39.41315], [-123.4252, 39.41295], [-123.42452, 39.41229], [-123.42446, 39.41211], [-123.42447, 39.41197], [-123.42466, 39.41163], [-123.42489, 39.41112], [-123.42489, 39.41094], [-123.42466, 39.41009], [-123.42456, 39.40988], [-123.42444, 39.40972], [-123.42422, 39.4096], [-123.42402, 39.40953], [-123.42849, 39.40945], [-123.42849, 39.41175], [-123.42832, 39.41185], [-123.42811, 39.41201], [-123.42793, 39.41231], [-123.42782, 39.41259], [-123.4276, 39.41354], [-123.42751, 39.4141], [-123.42746, 39.41427], [-123.42739, 39.41443], [-123.42725, 39.41467], [-123.42703, 39.41495], [-123.42685, 39.41512], [-123.42667, 39.41535], [-123.4266, 39.41557], [-123.42658, 39.41577], [-123.4266, 39.416], [-123.42665, 39.41621], [-123.42698, 39.41738], [-123.42754, 39.41919], [-123.42765, 39.41933], [-123.42786, 39.4195], [-123.4281, 39.41965], [-123.42872, 39.41993], [-123.42883, 39.42002], [-123.42893, 39.42019], [-123.42897, 39.42046], [-123.42929, 39.42045], [-123.42929, 39.42038], [-123.42924, 39.42012], [-123.42916, 39.41997], [-123.42908, 39.41987], [-123.42891, 39.41973], [-123.42829, 39.41945], [-123.42808, 39.41931], [-123.42789, 39.41917], [-123.42784, 39.41911], [-123.42729, 39.41732], [-123.42696, 39.41617], [-123.4269, 39.41578], [-123.42692, 39.41561], [-123.42696, 39.41545], [-123.42711, 39.41526], [-123.42729, 39.41509], [-123.42753, 39.41479], [-123.42768, 39.41453], [-123.42777, 39.41434], [-123.42782, 39.41414], [-123.42791, 39.41358], [-123.42813, 39.41264], [-123.42823, 39.4124], [-123.42837, 39.41216], [-123.42853, 39.41203], [-123.42873, 39.41192], [-123.42896, 39.41183], [-123.42917, 39.4118], [-123.42942, 39.41179], [-123.42959, 39.41182], [-123.43038, 39.41234], [-123.43081, 39.41328], [-123.43085, 39.41367], [-123.4309, 39.41381], [-123.43112, 39.4141], [-123.4317, 39.41518], [-123.43135, 39.41623], [-123.43125, 39.41645], [-123.4312, 39.41668], [-123.43122, 39.41684], [-123.43126, 39.417], [-123.43135, 39.41714], [-123.43148, 39.41726], [-123.43166, 39.41738], [-123.43291, 39.41798], [-123.43317, 39.41859], [-123.43253, 39.41838], [-123.43221, 39.41829], [-123.43193, 39.41824], [-123.43165, 39.41822], [-123.43127, 39.41824], [-123.43101, 39.41833], [-123.43082, 39.4185], [-123.43072, 39.41874], [-123.43069, 39.4189], [-123.43069, 39.41909], [-123.43078, 39.4193], [-123.43105, 39.41956], [-123.43277, 39.4205], [-123.43316, 39.42107], [-123.43289, 39.42177], [-123.43277, 39.42231], [-123.4327, 39.42272], [-123.4328, 39.42299], [-123.43303, 39.42316], [-123.43397, 39.42365], [-123.4343, 39.42394], [-123.43436, 39.42412]]]]} Unknown Access 4 46795 Noyo River Redwoods Property 30250 3128 Mendocino Land Trust 500 Non Profit 6 Non Profit - Land Trust 10 http://mendocinolandtrust.org/ Non Governmental Organization 10 3128 Mendocino Land Trust 492 Non Profit 6 Non Profit - Land Trust 10   Mendocino 24 416.183 Noyo River Redwoods Property 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]);