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 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
DES_TP 2
ACCESS_TYP 2
MNG_AG_TYP 1
- Non Profit - Conservation · 12 ✖
MNG_AGENCY 1
- National Audubon Society · 12 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
7599 | 7599 | 7598 | {"type": "Polygon", "coordinates": [[[-117.35825, 33.16477], [-117.35811, 33.16484], [-117.35793, 33.16488], [-117.35776, 33.16502], [-117.35773, 33.16507], [-117.35761, 33.1652], [-117.35715, 33.1652], [-117.35715, 33.16625], [-117.35629, 33.16543], [-117.35617, 33.16533], [-117.35607, 33.16521], [-117.35598, 33.1652], [-117.35586, 33.16509], [-117.35548, 33.16483], [-117.35555, 33.16478], [-117.3555, 33.16464], [-117.35547, 33.16431], [-117.35558, 33.16437], [-117.35557, 33.16441], [-117.35563, 33.16466], [-117.35569, 33.16472], [-117.35576, 33.16486], [-117.35757, 33.16474], [-117.3576, 33.16476], [-117.35792, 33.16464], [-117.35803, 33.16453], [-117.35825, 33.16477]]]} | Open Access 1 | 7307 | Buena Vista Lagoon and Nature Center | 16487 | 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 | http://bvaudubon.org/nature-center/ | San Diego 4 | 3.999 | Buena Vista Lagoon and Nature Ctr. | 0 | Private Recreation or Education 65 | 4 |
12627 | 12627 | 12626 | {"type": "Polygon", "coordinates": [[[-121.59056, 38.93189], [-121.5906, 38.93226], [-121.5905, 38.93257], [-121.58881, 38.9345], [-121.58881, 38.93507], [-121.58837, 38.93799], [-121.58941, 38.93802], [-121.58918, 38.93942], [-121.5886, 38.94166], [-121.58757, 38.94166], [-121.5872, 38.94279], [-121.58627, 38.94382], [-121.58599, 38.9453], [-121.58627, 38.94629], [-121.58627, 38.94645], [-121.58543, 38.95098], [-121.58543, 38.95121], [-121.58153, 38.95118], [-121.58154, 38.94959], [-121.5814, 38.94798], [-121.58105, 38.94658], [-121.58131, 38.94392], [-121.58114, 38.94224], [-121.58144, 38.94044], [-121.58217, 38.93847], [-121.5824, 38.93679], [-121.58241, 38.93581], [-121.58258, 38.93403], [-121.58245, 38.9327], [-121.58218, 38.93214], [-121.58228, 38.93118], [-121.58258, 38.92952], [-121.58295, 38.92734], [-121.58271, 38.92592], [-121.58192, 38.92389], [-121.58068, 38.92187], [-121.58329, 38.92253], [-121.58302, 38.92368], [-121.5833, 38.92433], [-121.58386, 38.92526], [-121.58628, 38.9281], [-121.58753, 38.92948], [-121.58931, 38.93031], [-121.58967, 38.93045], [-121.58962, 38.93068], [-121.58981, 38.9309], [-121.58977, 38.93102], [-121.59056, 38.93189]]]} | Open Access 1 | 29423 | Bobelaine Sanctuary | 7436 | 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 | http://www.sacramentoaudubon.org/bobelainesanctuary.html | Sutter 47 | 353.691 | Bobelaine Sanctuary | 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]);