units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, AGNCY_TYP = 12 and AGNCY_WEB = "http://www.sandiegoaudubon.org/"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6275 | 6275 | 6274 | {"type": "Polygon", "coordinates": [[[-116.88449, 32.9177], [-116.88442, 32.91819], [-116.88434, 32.91843], [-116.88422, 32.91866], [-116.88382, 32.91883], [-116.88374, 32.91886], [-116.88364, 32.91887], [-116.88353, 32.91892], [-116.88342, 32.919], [-116.88329, 32.91915], [-116.88323, 32.91919], [-116.88322, 32.91923], [-116.88261, 32.91942], [-116.88176, 32.91965], [-116.88175, 32.91967], [-116.88048, 32.92002], [-116.87996, 32.92023], [-116.87923, 32.92062], [-116.87894, 32.92081], [-116.87862, 32.92107], [-116.8761, 32.92338], [-116.87568, 32.92378], [-116.87552, 32.92398], [-116.87355, 32.92403], [-116.87354, 32.92387], [-116.87288, 32.92386], [-116.8671, 32.92734], [-116.86707, 32.92253], [-116.86293, 32.92261], [-116.8629, 32.91899], [-116.85859, 32.91904], [-116.84121, 32.91914], [-116.84119, 32.9155], [-116.85857, 32.91537], [-116.85906, 32.91535], [-116.86072, 32.91536], [-116.86073, 32.91535], [-116.86072, 32.91264], [-116.86927, 32.9126], [-116.87363, 32.91259], [-116.87362, 32.91458], [-116.88181, 32.91446], [-116.88184, 32.91632], [-116.88279, 32.91634], [-116.88275, 32.91768], [-116.88449, 32.9177]]]} | Restricted Access 2 | 1366 | Silverwood Wildlife Sanctuary | 25502 | 3064 | San Diego Audubon Society 831 | Non Profit 6 | Non Profit - Conservation 12 | http://www.sandiegoaudubon.org/ | Non Governmental Organization 10 | 3064 | San Diego Audubon Society 811 | Non Profit 6 | Non Profit - Conservation 12 | http://www.sandiegoaudubon.org/our-work/sanctuaries/silverwood-wildlife-sanctuary | San Diego 4 | 709.224 | Silverwood Wildlife 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]);