units_with_maps

Table actions

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

9 rows where GAP_STS = 2, MNG_AGENCY = 257 and MNG_AG_TYP = 12

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME, YR_EST

ACCESS_TYP 2

MNG_AG_TYP 1

  • Non Profit - Conservation · 9 ✖

MNG_AGENCY 1

  • Marin Audubon Society · 9 ✖
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
799 799 798 {"type": "MultiPolygon", "coordinates": [[[[-122.49991, 37.92691], [-122.49942, 37.92654], [-122.49818, 37.92572], [-122.49764, 37.92506], [-122.49509, 37.9251], [-122.49504, 37.92293], [-122.49312, 37.92144], [-122.49266, 37.92106], [-122.49265, 37.92043], [-122.49443, 37.92114], [-122.4948, 37.92124], [-122.49531, 37.9213], [-122.49545, 37.92131], [-122.49582, 37.92128], [-122.49619, 37.92123], [-122.49656, 37.92115], [-122.49691, 37.92104], [-122.4973, 37.92089], [-122.49736, 37.92428], [-122.49981, 37.92613], [-122.49991, 37.92691]]], [[[-122.50704, 37.92484], [-122.50678, 37.92501], [-122.50662, 37.92499], [-122.50631, 37.92523], [-122.5058, 37.92533], [-122.50532, 37.92522], [-122.50562, 37.92509], [-122.50587, 37.92491], [-122.50632, 37.9244], [-122.50704, 37.92484]]]]} No Public Access 3 5189 Triangle Marsh 26529 3039 Marin Audubon Society 261 Non Profit 6 Non Profit - Conservation 12 http://www.marinaudubon.org Non Governmental Organization 10 3039 Marin Audubon Society 257 Non Profit 6 Non Profit - Conservation 12   Marin 23 33.876 Triangle Marsh 1999 Private Conservation 16 2
3739 3739 3738 {"type": "Polygon", "coordinates": [[[-122.53527, 38.06893], [-122.5352, 38.06916], [-122.53501, 38.06911], [-122.53442, 38.06923], [-122.53406, 38.06927], [-122.53308, 38.06944], [-122.53252, 38.06952], [-122.53229, 38.06957], [-122.53239, 38.06949], [-122.53251, 38.06943], [-122.5325, 38.06937], [-122.53297, 38.06927], [-122.53439, 38.06908], [-122.53527, 38.06893]]]} No Public Access 3 31028 Marin Audubon Society 21815 3039 Marin Audubon Society 261 Non Profit 6 Non Profit - Conservation 12 http://www.marinaudubon.org Non Governmental Organization 10 3039 Marin Audubon Society 257 Non Profit 6 Non Profit - Conservation 12   Marin 23 1.098 Marin Audubon Society 0 Private Conservation 16 2
6751 6751 6750 {"type": "Polygon", "coordinates": [[[-122.49667, 37.96721], [-122.49568, 37.97019], [-122.49389, 37.96873], [-122.49305, 37.96873], [-122.49385, 37.96635], [-122.49592, 37.96699], [-122.49667, 37.96721]]]} Open Access 1 5187 San Rafael Tidelands 30323 3039 Marin Audubon Society 261 Non Profit 6 Non Profit - Conservation 12 http://www.marinaudubon.org Non Governmental Organization 10 3039 Marin Audubon Society 257 Non Profit 6 Non Profit - Conservation 12   Marin 23 18.615 San Rafael Tidelands 1978 Private Conservation 16 2
7549 7549 7548 {"type": "Polygon", "coordinates": [[[-122.53979, 38.10963], [-122.53744, 38.11165], [-122.53683, 38.11126], [-122.53618, 38.11188], [-122.53521, 38.11136], [-122.53668, 38.10863], [-122.53979, 38.10963]]]} No Public Access 3 9514 Simmons Slough Wildlife Corridor 25509 3039 Marin Audubon Society 261 Non Profit 6 Non Profit - Conservation 12 http://www.marinaudubon.org Non Governmental Organization 10 3039 Marin Audubon Society 257 Non Profit 6 Non Profit - Conservation 12   Marin 23 18.529 Simmons Slough Wildlife Corridor 2000 Private Conservation 16 2
9640 9640 9639 {"type": "Polygon", "coordinates": [[[-122.4913, 37.96048], [-122.49049, 37.9606], [-122.48972, 37.96061], [-122.48972, 37.96425], [-122.48836, 37.96425], [-122.48826, 37.9606], [-122.48723, 37.96061], [-122.48721, 37.95839], [-122.49058, 37.95832], [-122.4913, 37.96048]]]} Open Access 1 16223 Marin Audubon Society 30324 3039 Marin Audubon Society 261 Non Profit 6 Non Profit - Conservation 12 http://www.marinaudubon.org Non Governmental Organization 10 3039 Marin Audubon Society 257 Non Profit 6 Non Profit - Conservation 12   Marin 23 32.569 Marin Audubon Society 0 Private Conservation 16 2
10114 10114 10113 {"type": "Polygon", "coordinates": [[[-122.53779, 38.10614], [-122.53642, 38.10869], [-122.53378, 38.10777], [-122.53215, 38.10972], [-122.52925, 38.10817], [-122.52924, 38.10813], [-122.52644, 38.10663], [-122.52538, 38.10642], [-122.53356, 38.09886], [-122.53488, 38.09956], [-122.53421, 38.10043], [-122.53508, 38.10121], [-122.53369, 38.1021], [-122.53464, 38.10304], [-122.5349, 38.10315], [-122.53403, 38.10478], [-122.53779, 38.10614]]]} No Public Access 3 17569 Marin Audubon- Simmons Slough Wildlife Corridor 21814 3039 Marin Audubon Society 261 Non Profit 6 Non Profit - Conservation 12 http://www.marinaudubon.org Non Governmental Organization 10 3039 Marin Audubon Society 257 Non Profit 6 Non Profit - Conservation 12   Marin 23 145.444 Marin Audubon- Simmons Slough Wildlife Corridor 2000 Private Conservation 16 2
12992 12992 12991 {"type": "Polygon", "coordinates": [[[-122.52978, 37.8954], [-122.52954, 37.89543], [-122.52847, 37.89519], [-122.52798, 37.89489], [-122.5279, 37.89438], [-122.52814, 37.89335], [-122.52828, 37.89337], [-122.52811, 37.89431], [-122.52822, 37.89474], [-122.52855, 37.89493], [-122.52945, 37.89515], [-122.52977, 37.89515], [-122.52978, 37.8954]]]} No Public Access 3 31029 Marin Audubon Society 21815 3039 Marin Audubon Society 261 Non Profit 6 Non Profit - Conservation 12 http://www.marinaudubon.org Non Governmental Organization 10 3039 Marin Audubon Society 257 Non Profit 6 Non Profit - Conservation 12   Marin 23 1.819 Marin Audubon Society 0 Private Conservation 16 2
13743 13743 13742 {"type": "MultiPolygon", "coordinates": [[[[-122.4961, 38.10684], [-122.49608, 38.10697], [-122.49572, 38.10695], [-122.49574, 38.10681], [-122.4961, 38.10684]]], [[[-122.52407, 38.12472], [-122.52414, 38.12502], [-122.52415, 38.12518], [-122.52414, 38.12534], [-122.52408, 38.12561], [-122.52393, 38.12591], [-122.51977, 38.13124], [-122.51972, 38.1312], [-122.51871, 38.1312], [-122.51823, 38.13096], [-122.52223, 38.12588], [-122.52228, 38.12578], [-122.52228, 38.12567], [-122.52226, 38.1256], [-122.5222, 38.12553], [-122.522, 38.12539], [-122.5219, 38.12528], [-122.52187, 38.1252], [-122.52185, 38.12506], [-122.52172, 38.12483], [-122.5216, 38.12454], [-122.52147, 38.12408], [-122.52139, 38.12396], [-122.52132, 38.12392], [-122.52121, 38.12387], [-122.52103, 38.12386], [-122.52094, 38.12388], [-122.5205, 38.12404], [-122.52042, 38.12409], [-122.52037, 38.12416], [-122.52034, 38.12425], [-122.52033, 38.12433], [-122.52036, 38.12442], [-122.52067, 38.12499], [-122.52076, 38.12525], [-122.5208, 38.12552], [-122.5208, 38.12572], [-122.52077, 38.12592], [-122.52072, 38.12611], [-122.52061, 38.12637], [-122.52043, 38.12667], [-122.5204, 38.12683], [-122.52037, 38.12693], [-122.52024, 38.12709], [-122.52008, 38.1272], [-122.51988, 38.12726], [-122.51969, 38.12728], [-122.51948, 38.12724], [-122.51931, 38.12717], [-122.51918, 38.12707], [-122.51908, 38.12694], [-122.51903, 38.12679], [-122.51904, 38.12666], [-122.51908, 38.12653], [-122.51944, 38.12607], [-122.51951, 38.12589], [-122.51954, 38.12571], [-122.51953, 38.12559], [-122.5195, 38.12547], [-122.51927, 38.12496], [-122.5192, 38.12476], [-122.51913, 38.12442], [-122.5191, 38.12436], [-122.51903, 38.12427], [-122.51893, 38.12421], [-122.51881, 38.12418], [-122.51871, 38.12417], [-122.51855, 38.1242], [-122.51807, 38.12442], [-122.51799, 38.12452], [-122.51796, 38.12463], [-122.51841, 38.12896], [-122.51841, 38.12908], [-122.51837, 38.12922], [-122.51829, 38.12933], [-122.51817, 38.12945], [-122.51807, 38.12951], [-122.51785, 38.12959], [-122.51725, 38.12967], [-122.51696, 38.127], [-122.51684, 38.12614], [-122.51676, 38.12535], [-122.51644, 38.12355], [-122.51647, 38.12333], [-122.51877, 38.12225], [-122.51881, 38.12248], [-122.51959, 38.12323], [-122.52033, 38.1233], [-122.52058, 38.12356], [-122.52063, 38.12353], [-122.52078, 38.12364], [-122.52153, 38.12312], [-122.5216, 38.12312], [-122.52175, 38.12325], [-122.52187, 38.12338], [-122.52195, 38.12353], [-122.52196, 38.12365], [-122.52198, 38.12423], [-122.522, 38.1244], [-122.52205, 38.12456], [-122.52212, 38.12472], [-122.52232, 38.12504], [-122.52233, 38.1251], [-122.5223, 38.12518], [-122.5223, 38.12522], [-122.52232, 38.12527], [-122.52236, 38.12531], [-122.52247, 38.12533], [-122.52256, 38.12529], [-122.52261, 38.12521], [-122.5226, 38.12516], [-122.52258, 38.12512], [-122.52286, 38.12491], [-122.52354, 38.12462], [-122.52393, 38.12464], [-122.52407, 38.12472]], [[-122.52387, 38.12521], [-122.52389, 38.1252], [-122.52387, 38.12479], [-122.52335, 38.12483], [-122.52335, 38.12485], [-122.52387, 38.12521]]], [[[-122.52774, 38.12624], [-122.5273, 38.12616], [-122.52619, 38.12578], [-122.52617, 38.12545], [-122.5267, 38.12518], [-122.52679, 38.12529], [-122.52689, 38.12535], [-122.52716, 38.12539], [-122.52727, 38.12536], [-122.52763, 38.12596], [-122.52774, 38.12624]]], [[[-122.54098, 38.12226], [-122.54096, 38.12226], [-122.54066, 38.12196], [-122.54053, 38.12175], [-122.54067, 38.12195], [-122.54098, 38.12226]]]]} No Public Access 3 36240 Petaluma Marsh 28571 3039 Marin Audubon Society 261 Non Profit 6 Non Profit - Conservation 12 http://www.marinaudubon.org Non Governmental Organization 10 3039 Marin Audubon Society 257 Non Profit 6 Non Profit - Conservation 12   Marin 23 70.563 Petaluma Marsh 0 Private Conservation 16 2
13745 13745 13744 {"type": "Polygon", "coordinates": [[[-122.57967, 38.18569], [-122.57956, 38.18584], [-122.57954, 38.18596], [-122.57958, 38.18615], [-122.5797, 38.18658], [-122.5797, 38.18666], [-122.57967, 38.18701], [-122.57962, 38.1871], [-122.57953, 38.18715], [-122.57927, 38.18724], [-122.57872, 38.18719], [-122.57855, 38.18714], [-122.57787, 38.18686], [-122.57754, 38.18674], [-122.57708, 38.18646], [-122.57681, 38.18637], [-122.57645, 38.18632], [-122.57619, 38.18624], [-122.57585, 38.18609], [-122.57551, 38.18601], [-122.57503, 38.18592], [-122.57473, 38.18589], [-122.57454, 38.18585], [-122.5745, 38.18579], [-122.5745, 38.18572], [-122.57457, 38.18561], [-122.57475, 38.18545], [-122.57495, 38.18524], [-122.57503, 38.1851], [-122.5751, 38.18485], [-122.57514, 38.18449], [-122.57513, 38.18423], [-122.57509, 38.1841], [-122.57493, 38.18378], [-122.57466, 38.18343], [-122.57425, 38.18321], [-122.57377, 38.18308], [-122.57331, 38.18303], [-122.57294, 38.18304], [-122.57262, 38.18306], [-122.57223, 38.18326], [-122.57167, 38.18337], [-122.57131, 38.18341], [-122.57079, 38.1834], [-122.57066, 38.18344], [-122.57052, 38.18354], [-122.57044, 38.18369], [-122.57041, 38.18409], [-122.57048, 38.18427], [-122.5707, 38.18448], [-122.57259, 38.18544], [-122.57291, 38.18567], [-122.57306, 38.18593], [-122.5731, 38.18613], [-122.57305, 38.18636], [-122.57297, 38.18655], [-122.57279, 38.18675], [-122.57248, 38.18699], [-122.57222, 38.18711], [-122.57162, 38.18722], [-122.57133, 38.18723], [-122.57108, 38.18719], [-122.57078, 38.18708], [-122.57057, 38.1869], [-122.57039, 38.18667], [-122.57022, 38.18641], [-122.56999, 38.18586], [-122.56979, 38.18532], [-122.56962, 38.18501], [-122.56934, 38.18459], [-122.56908, 38.18431], [-122.56864, 38.18394], [-122.5682, 38.18365], [-122.56779, 38.18345], [-122.56698, 38.18321], [-122.56617, 38.18295], [-122.56579, 38.1828], [-122.56556, 38.18265], [-122.56544, 38.18243], [-122.56545, 38.18215], [-122.56561, 38.18155], [-122.56593, 38.18093], [-122.56632, 38.18024], [-122.56659, 38.17961], [-122.56703, 38.17907], [-122.56746, 38.17867], [-122.56825, 38.17811], [-122.56857, 38.17779], [-122.56868, 38.17765], [-122.56875, 38.1775], [-122.56881, 38.17732], [-122.56883, 38.17719], [-122.56879, 38.17693], [-122.56903, 38.17696], [-122.56956, 38.17697], [-122.56992, 38.17701], [-122.57017, 38.177], [-122.57029, 38.17694], [-122.57051, 38.17673], [-122.57098, 38.17624], [-122.57123, 38.17583], [-122.57167, 38.17647], [-122.57136, 38.17833], [-122.57426, 38.17772], [-122.57967, 38.18569]]]} No Public Access 3 36254 Petaluma Marsh 28571 3039 Marin Audubon Society 261 Non Profit 6 Non Profit - Conservation 12 http://www.marinaudubon.org Non Governmental Organization 10 3039 Marin Audubon Society 257 Non Profit 6 Non Profit - Conservation 12   Marin 23 188.086 Petaluma Marsh 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]);