superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where MNG_AGENCY = 640
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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]);