units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 640 and MNG_AG_TYP = 12
This data as json, copyable, CSV (advanced)
LABEL_NAME 12 ✖
- Audubon Society Lyford House OS Area 1
- Nat. Audubon Society 11 1
- Nat. Audubon Society 12 1
- Nat. Audubon Society 14 1
- Nat. Audubon Society 15 1
- Nat. Audubon Society 16 1
- Nat. Audubon Society 17 1
- Nat. Audubon Society 18 1
- Nat. Audubon Society 20 1
- Nat. Audubon Society 22 1
- Nat. Audubon Society 3 1
- Nat. Audubon Society 9 1
ACCESS_TYP 2
MNG_AG_TYP 1
- Non Profit - Conservation · 12 ✖
MNG_AGENCY 1
- National Audubon Society · 12 ✖
DES_TP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15947 | 15947 | 15946 | {"type": "Polygon", "coordinates": [[[-122.49954, 37.89424], [-122.49884, 37.89498], [-122.49752, 37.89514], [-122.49729, 37.89525], [-122.49639, 37.89483], [-122.49647, 37.89479], [-122.49673, 37.89397], [-122.49747, 37.89359], [-122.49821, 37.89349], [-122.49911, 37.89369], [-122.49954, 37.89424]]]} | No Public Access 3 | 5202 | Audubon Society Lyford House Open Space Area | 15705 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 9.091 | Audubon Society Lyford House OS Area | 0 | Private Conservation 16 | 2 | |
16380 | 16380 | 16379 | {"type": "Polygon", "coordinates": [[[-118.2968, 35.69602], [-118.29474, 35.69602], [-118.29474, 35.69437], [-118.29674, 35.69595], [-118.2968, 35.69602]]]} | Unknown Access 4 | 43028 | National Audubon Society 17 | 22646 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 4.294 | Nat. Audubon Society 17 | 0 | Private Conservation 16 | 2 | |
16516 | 16516 | 16515 | {"type": "Polygon", "coordinates": [[[-118.29012, 35.69205], [-118.28803, 35.69205], [-118.28803, 35.69251], [-118.2814, 35.6925], [-118.28132, 35.69068], [-118.2747, 35.69061], [-118.27464, 35.68696], [-118.27242, 35.68693], [-118.27242, 35.68512], [-118.2769, 35.68515], [-118.27693, 35.68874], [-118.29007, 35.68874], [-118.29008, 35.69014], [-118.29012, 35.69205]]]} | Unknown Access 4 | 36142 | National Audubon Society 18 | 22647 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 141.001 | Nat. Audubon Society 18 | 0 | Private Conservation 16 | 2 | |
16616 | 16616 | 16615 | {"type": "MultiPolygon", "coordinates": [[[[-118.29226, 35.67424], [-118.29028, 35.67426], [-118.29026, 35.67365], [-118.29076, 35.67366], [-118.29168, 35.67375], [-118.29226, 35.67408], [-118.29226, 35.67424]]], [[[-118.29062, 35.67315], [-118.29038, 35.67314], [-118.29037, 35.67301], [-118.29037, 35.67301], [-118.29062, 35.67315]]]]} | Unknown Access 4 | 43064 | National Audubon Society 20 | 22650 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 2.496 | Nat. Audubon Society 20 | 0 | Private Conservation 16 | 2 | |
16995 | 16995 | 16994 | {"type": "MultiPolygon", "coordinates": [[[[-118.32729, 35.67268], [-118.32554, 35.67299], [-118.32559, 35.67163], [-118.32667, 35.6723], [-118.32694, 35.67249], [-118.32729, 35.67268]]], [[[-118.33913, 35.6662], [-118.33753, 35.66683], [-118.33575, 35.66799], [-118.33412, 35.66986], [-118.33236, 35.67133], [-118.32783, 35.67255], [-118.32755, 35.67242], [-118.32729, 35.67228], [-118.32693, 35.67204], [-118.3256, 35.67122], [-118.32571, 35.66683], [-118.32574, 35.66363], [-118.32902, 35.66361], [-118.33069, 35.66324], [-118.33669, 35.66321], [-118.33666, 35.66368], [-118.33695, 35.66497], [-118.3391, 35.66591], [-118.33913, 35.6662]]], [[[-118.33451, 35.67194], [-118.33451, 35.67409], [-118.3266, 35.6742], [-118.32676, 35.67347], [-118.32829, 35.67307], [-118.32861, 35.67315], [-118.32902, 35.67322], [-118.32936, 35.67331], [-118.32971, 35.67337], [-118.33, 35.6734], [-118.33029, 35.6734], [-118.33058, 35.67339], [-118.33087, 35.67335], [-118.33148, 35.67318], [-118.33287, 35.67269], [-118.33292, 35.67279], [-118.3335, 35.67261], [-118.33375, 35.6725], [-118.33406, 35.67232], [-118.33431, 35.67214], [-118.33451, 35.67194]]], [[[-118.33452, 35.67084], [-118.33452, 35.67101], [-118.33429, 35.67122], [-118.33405, 35.67153], [-118.33385, 35.67174], [-118.33364, 35.6719], [-118.33337, 35.67205], [-118.33315, 35.67214], [-118.33271, 35.67227], [-118.33274, 35.67238], [-118.33134, 35.67287], [-118.33073, 35.67304], [-118.33067, 35.67305], [-118.33058, 35.67289], [-118.3302, 35.67291], [-118.32986, 35.67289], [-118.32976, 35.67304], [-118.32946, 35.67299], [-118.32904, 35.67289], [-118.33057, 35.67251], [-118.33314, 35.67175], [-118.33432, 35.67112], [-118.33452, 35.67084]]], [[[-118.33903, 35.667], [-118.33898, 35.67037], [-118.33489, 35.67031], [-118.33543, 35.66955], [-118.33642, 35.66855], [-118.33784, 35.66754], [-118.33903, 35.667]]]]} | Unknown Access 4 | 36166 | National Audubon Society 9 | 22659 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 264.275 | Nat. Audubon Society 9 | 0 | Private Conservation 16 | 2 | |
16996 | 16996 | 16995 | {"type": "MultiPolygon", "coordinates": [[[[-118.18308, 35.74613], [-118.18307, 35.74668], [-118.17417, 35.7468], [-118.16604, 35.74711], [-118.16564, 35.74343], [-118.17202, 35.74325], [-118.17204, 35.74501], [-118.17417, 35.74496], [-118.1801, 35.74487], [-118.1815, 35.74541], [-118.18202, 35.74564], [-118.18308, 35.74613]]], [[[-118.18308, 35.74581], [-118.18218, 35.74539], [-118.18088, 35.74486], [-118.18091, 35.74485], [-118.18087, 35.74309], [-118.18304, 35.74308], [-118.18308, 35.74581]]]]} | Unknown Access 4 | 43024 | National Audubon Society 11 | 22640 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 114.543 | Nat. Audubon Society 11 | 0 | Private Conservation 16 | 2 | |
16997 | 16997 | 16996 | {"type": "MultiPolygon", "coordinates": [[[[-118.30795, 35.66696], [-118.3079, 35.6734], [-118.30686, 35.67324], [-118.30399, 35.67358], [-118.30196, 35.67421], [-118.29905, 35.67422], [-118.2991, 35.66701], [-118.2991, 35.66489], [-118.30103, 35.66465], [-118.30104, 35.66566], [-118.30398, 35.66567], [-118.30399, 35.66695], [-118.30795, 35.66696]]], [[[-118.3079, 35.67385], [-118.3079, 35.67418], [-118.30372, 35.6742], [-118.30562, 35.67372], [-118.30749, 35.67378], [-118.3079, 35.67385]]]]} | Unknown Access 4 | 43025 | National Audubon Society 15 | 22644 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 173.319 | Nat. Audubon Society 15 | 0 | Private Conservation 16 | 2 | |
16998 | 16998 | 16997 | {"type": "Polygon", "coordinates": [[[-118.31679, 35.67415], [-118.31247, 35.67416], [-118.31243, 35.67061], [-118.30792, 35.67063], [-118.30795, 35.66668], [-118.31204, 35.66666], [-118.31679, 35.66529], [-118.31679, 35.67415]]]} | Unknown Access 4 | 43026 | National Audubon Society 14 | 22643 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 133.04 | Nat. Audubon Society 14 | 0 | Private Conservation 16 | 2 | |
17001 | 17001 | 17000 | {"type": "MultiPolygon", "coordinates": [[[[-118.25928, 35.67024], [-118.25921, 35.67026], [-118.25904, 35.67033], [-118.25865, 35.67053], [-118.25835, 35.67072], [-118.258, 35.67097], [-118.25768, 35.67124], [-118.25744, 35.67148], [-118.25696, 35.67205], [-118.25584, 35.67205], [-118.25583, 35.67252], [-118.25465, 35.67252], [-118.25467, 35.67066], [-118.25461, 35.66342], [-118.2582, 35.66342], [-118.25822, 35.66403], [-118.25906, 35.66405], [-118.25928, 35.67024]]], [[[-118.26209, 35.67064], [-118.25938, 35.67289], [-118.25934, 35.67204], [-118.25722, 35.67205], [-118.25745, 35.67176], [-118.25766, 35.67153], [-118.25789, 35.6713], [-118.25814, 35.67109], [-118.25841, 35.6709], [-118.25869, 35.67072], [-118.25899, 35.67056], [-118.25929, 35.67042], [-118.25931, 35.67065], [-118.26209, 35.67064]]], [[[-118.264, 35.67436], [-118.25943, 35.67436], [-118.25939, 35.67328], [-118.26257, 35.67064], [-118.26379, 35.67063], [-118.264, 35.67436]]]]} | Unknown Access 4 | 36112 | National Audubon Society 16 | 22645 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 135.112 | Nat. Audubon Society 16 | 0 | Private Conservation 16 | 2 | |
17004 | 17004 | 17003 | {"type": "MultiPolygon", "coordinates": [[[[-118.29467, 35.67377], [-118.29419, 35.67362], [-118.29189, 35.67317], [-118.29062, 35.67315], [-118.29037, 35.67301], [-118.29034, 35.67178], [-118.2902, 35.67177], [-118.29016, 35.66927], [-118.29248, 35.66885], [-118.29249, 35.67009], [-118.29464, 35.6701], [-118.29467, 35.67377]]], [[[-118.29434, 35.67423], [-118.29226, 35.67424], [-118.29226, 35.67408], [-118.29168, 35.67375], [-118.29272, 35.67385], [-118.29434, 35.67423]]]]} | Unknown Access 4 | 36101 | National Audubon Society 3 | 22653 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 42.725 | Nat. Audubon Society 3 | 0 | Private Conservation 16 | 2 | |
17005 | 17005 | 17004 | {"type": "MultiPolygon", "coordinates": [[[[-118.27949, 35.6743], [-118.27766, 35.67533], [-118.27639, 35.67657], [-118.27567, 35.67719], [-118.27431, 35.67791], [-118.27241, 35.67875], [-118.2724, 35.67795], [-118.27014, 35.67796], [-118.27242, 35.67433], [-118.27949, 35.6743]]], [[[-118.29007, 35.67426], [-118.29004, 35.67601], [-118.28531, 35.67602], [-118.28534, 35.67702], [-118.28094, 35.67704], [-118.281, 35.67803], [-118.27658, 35.67804], [-118.27673, 35.68152], [-118.27241, 35.68149], [-118.27241, 35.67948], [-118.27406, 35.67834], [-118.27537, 35.67772], [-118.2763, 35.67737], [-118.27703, 35.67702], [-118.27775, 35.67646], [-118.27821, 35.67605], [-118.27892, 35.67557], [-118.27928, 35.67501], [-118.28015, 35.6743], [-118.29007, 35.67426]]], [[[-118.30793, 35.67964], [-118.30557, 35.67965], [-118.30549, 35.67607], [-118.2989, 35.67609], [-118.29896, 35.67796], [-118.2921, 35.67798], [-118.29219, 35.67908], [-118.29025, 35.6794], [-118.29025, 35.67746], [-118.29028, 35.67426], [-118.29434, 35.67423], [-118.2958, 35.6747], [-118.29683, 35.675], [-118.29777, 35.67524], [-118.29874, 35.67537], [-118.30001, 35.67532], [-118.301, 35.67521], [-118.30188, 35.67485], [-118.30372, 35.6742], [-118.3079, 35.67418], [-118.30793, 35.67964]]], [[[-118.30196, 35.67421], [-118.30081, 35.67458], [-118.29936, 35.67488], [-118.29809, 35.67483], [-118.29611, 35.67423], [-118.30196, 35.67421]]]]} | Unknown Access 4 | 36106 | National Audubon Society 12 | 22641 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 302.293 | Nat. Audubon Society 12 | 0 | Private Conservation 16 | 2 | |
17006 | 17006 | 17005 | {"type": "Polygon", "coordinates": [[[-118.19254, 35.71776], [-118.1836, 35.71794], [-118.1836, 35.71704], [-118.18467, 35.71701], [-118.18468, 35.71528], [-118.18695, 35.71525], [-118.18695, 35.71442], [-118.18805, 35.71441], [-118.18805, 35.71353], [-118.19024, 35.71353], [-118.19022, 35.71063], [-118.19243, 35.71062], [-118.19254, 35.71776]]]} | Unknown Access 4 | 36107 | National Audubon Society 22 | 22651 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 89.965 | Nat. Audubon Society 22 | 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]);