superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where MNG_AGENCY = 640 and MNG_AG_TYP = 12
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- Non Profit - Conservation · 9 ✖
MNG_AGENCY 1
- National Audubon Society · 9 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15384 | 15384 | 15383 | {"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 | National Audubon Society 20 | 22650 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 2.494 | Nat. Audubon Society 20 | ||
15385 | 15385 | 15384 | {"type": "Polygon", "coordinates": [[[-118.19254, 35.71776], [-118.1836, 35.71794], [-118.1836, 35.71704], [-118.18467, 35.71701], [-118.18468, 35.71528], [-118.18694, 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 | National Audubon Society 22 | 22651 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 89.997 | Nat. Audubon Society 22 | ||
15386 | 15386 | 15385 | {"type": "Polygon", "coordinates": [[[-118.1829, 35.73595], [-118.17869, 35.7361], [-118.17866, 35.73247], [-118.18268, 35.73233], [-118.1829, 35.73595]]]} | Unknown Access 4 | National Audubon Society 23 | 22652 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 37.082 | Nat. Audubon Society 23 | ||
15392 | 15392 | 15391 | {"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.67179], [-118.2902, 35.67177], [-118.29016, 35.66927], [-118.29248, 35.66885], [-118.2925, 35.67009], [-118.29464, 35.6701], [-118.29467, 35.67377]]], [[[-118.29434, 35.67423], [-118.29226, 35.67424], [-118.29225, 35.67407], [-118.29168, 35.67375], [-118.29272, 35.67385], [-118.29434, 35.67423]]]]} | Unknown Access 4 | National Audubon Society 3 | 22653 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 42.737 | Nat. Audubon Society 3 | ||
15393 | 15393 | 15392 | {"type": "MultiPolygon", "coordinates": [[[[-118.2043, 35.49494], [-118.20434, 35.49511], [-118.20436, 35.49526], [-118.20435, 35.49577], [-118.20437, 35.49604], [-118.20442, 35.49637], [-118.20441, 35.49673], [-118.20436, 35.49699], [-118.20421, 35.49746], [-118.20412, 35.49806], [-118.20399, 35.49875], [-118.2038, 35.49939], [-118.20377, 35.49962], [-118.20377, 35.50008], [-118.20385, 35.50086], [-118.20408, 35.50174], [-118.20407, 35.50194], [-118.20403, 35.50207], [-118.20398, 35.50216], [-118.20123, 35.50216], [-118.20127, 35.49494], [-118.2043, 35.49494]]], [[[-118.2101, 35.50219], [-118.2042, 35.50216], [-118.20427, 35.50197], [-118.20428, 35.50175], [-118.20425, 35.50159], [-118.20405, 35.50084], [-118.20397, 35.50008], [-118.20397, 35.49964], [-118.20401, 35.4994], [-118.20419, 35.49878], [-118.20432, 35.49808], [-118.20441, 35.49748], [-118.20456, 35.49699], [-118.20461, 35.49672], [-118.20462, 35.4964], [-118.20457, 35.49599], [-118.20455, 35.49569], [-118.20456, 35.49526], [-118.2045, 35.49494], [-118.2101, 35.49494], [-118.2101, 35.50219]]]]} | Unknown Access 4 | National Audubon Society 5 | 22655 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 155.637 | Nat. Audubon Society 5 | ||
15397 | 15397 | 15396 | {"type": "MultiPolygon", "coordinates": [[[[-118.32506, 35.67338], [-118.32384, 35.674], [-118.32283, 35.67419], [-118.32277, 35.67419], [-118.32279, 35.67326], [-118.32286, 35.67325], [-118.32367, 35.67324], [-118.32441, 35.67334], [-118.32506, 35.67338]]], [[[-118.32559, 35.67153], [-118.32554, 35.67299], [-118.3248, 35.67294], [-118.32373, 35.67272], [-118.3228, 35.67274], [-118.32288, 35.66874], [-118.32302, 35.66909], [-118.32324, 35.6695], [-118.32351, 35.66989], [-118.32383, 35.67025], [-118.32419, 35.67059], [-118.32452, 35.67085], [-118.32559, 35.67153]]], [[[-118.32574, 35.66363], [-118.32571, 35.66683], [-118.32559, 35.67132], [-118.3246, 35.67068], [-118.32428, 35.67043], [-118.324, 35.67016], [-118.32369, 35.66981], [-118.32343, 35.66944], [-118.32325, 35.66911], [-118.32307, 35.6687], [-118.32297, 35.66835], [-118.32289, 35.66792], [-118.32293, 35.66363], [-118.32574, 35.66363]]]]} | Unknown Access 4 | National Audubon Society 7 | 22657 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 65.102 | Nat. Audubon Society 7 | ||
15526 | 15526 | 15525 | {"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.33272, 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.32987, 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 | National Audubon Society 9 | 22659 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 264.281 | Nat. Audubon Society 9 | ||
15588 | 15588 | 15587 | {"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.17205, 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.74484], [-118.18087, 35.74309], [-118.18304, 35.74308], [-118.18308, 35.74581]]]]} | Unknown Access 4 | National Audubon Society 11 | 22640 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 114.558 | Nat. Audubon Society 11 | ||
15597 | 15597 | 15596 | {"type": "MultiPolygon", "coordinates": [[[[-122.48737, 37.88444], [-122.48632, 37.88604], [-122.48238, 37.8846], [-122.4814, 37.88629], [-122.48068, 37.88606], [-122.48029, 37.8859], [-122.47745, 37.88485], [-122.47846, 37.88316], [-122.48122, 37.88414], [-122.48237, 37.88459], [-122.48336, 37.88288], [-122.48737, 37.88444]]], [[[-122.49343, 37.89369], [-122.49298, 37.89377], [-122.4913, 37.8926], [-122.49158, 37.89214], [-122.49343, 37.89369]]], [[[-122.49394, 37.89369], [-122.49366, 37.89367], [-122.49167, 37.89196], [-122.49188, 37.89166], [-122.49394, 37.89369]]], [[[-122.49543, 37.89412], [-122.49528, 37.89413], [-122.49512, 37.89406], [-122.49512, 37.89403], [-122.4923, 37.89097], [-122.49261, 37.8905], [-122.49521, 37.89278], [-122.49543, 37.89412]]], [[[-122.50011, 37.89408], [-122.49954, 37.89424], [-122.49911, 37.89369], [-122.49821, 37.89349], [-122.49747, 37.89359], [-122.49673, 37.89397], [-122.49647, 37.89479], [-122.49642, 37.89482], [-122.49621, 37.89467], [-122.49602, 37.89457], [-122.49616, 37.89407], [-122.49571, 37.89409], [-122.49547, 37.8927], [-122.49273, 37.8903], [-122.4931, 37.88965], [-122.49453, 37.88741], [-122.4975, 37.88853], [-122.49781, 37.88802], [-122.50011, 37.89408]]], [[[-122.50928, 37.87681], [-122.50822, 37.87751], [-122.50769, 37.87701], [-122.50875, 37.8763], [-122.50928, 37.87681]]], [[[-122.50932, 37.87892], [-122.50833, 37.87959], [-122.50816, 37.87951], [-122.50775, 37.87912], [-122.50879, 37.87841], [-122.50932, 37.87892]]]]} | No Public Access 3 | Richardson Bay Audubon Center & Sanctuary | 24329 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 123.816 | Richardson Bay Audubon Ctr. & Sanctuary |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);