units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 3, AGNCY_WEB = "http://www.marinaudubon.org" and MNG_AG_TYP = 12
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME, YR_EST
MNG_AG_TYP 1
- Non Profit - Conservation · 7 ✖
MNG_AGENCY 1
DES_TP 1
ACCESS_TYP 1
- No Public Access · 7 ✖
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 | |
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 | |
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
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]);