units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 4 and PARK_URL = "http://www.sdparks.org/content/sdparks/en/park-pages/DelDiosHighlands.html"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7603 | 7603 | 7602 | {"type": "MultiPolygon", "coordinates": [[[[-117.14805, 33.08584], [-117.14789, 33.0859], [-117.14775, 33.08597], [-117.14704, 33.08645], [-117.14671, 33.08662], [-117.14508, 33.08435], [-117.13959, 33.08443], [-117.13958, 33.08442], [-117.13958, 33.08754], [-117.13651, 33.08756], [-117.12968, 33.08756], [-117.12962, 33.09117], [-117.12315, 33.09115], [-117.12313, 33.08756], [-117.11888, 33.08755], [-117.11889, 33.08746], [-117.11885, 33.08602], [-117.1189, 33.08492], [-117.11888, 33.08399], [-117.11911, 33.08376], [-117.11915, 33.08376], [-117.11941, 33.08344], [-117.11939, 33.08342], [-117.1194, 33.08339], [-117.11947, 33.0833], [-117.11965, 33.083], [-117.11982, 33.08265], [-117.11992, 33.08237], [-117.12041, 33.08055], [-117.12047, 33.08025], [-117.12056, 33.07972], [-117.12075, 33.07971], [-117.12076, 33.07899], [-117.12108, 33.07898], [-117.12106, 33.07836], [-117.12084, 33.07835], [-117.1211, 33.07661], [-117.12112, 33.07652], [-117.12116, 33.07652], [-117.1212, 33.07624], [-117.12126, 33.07623], [-117.12136, 33.07562], [-117.12131, 33.0756], [-117.12133, 33.07547], [-117.1213, 33.07546], [-117.12141, 33.07449], [-117.12151, 33.07448], [-117.12178, 33.07265], [-117.1219, 33.07198], [-117.12179, 33.07194], [-117.12245, 33.06783], [-117.12255, 33.06782], [-117.12257, 33.06767], [-117.12265, 33.06739], [-117.12276, 33.06717], [-117.1229, 33.06695], [-117.12283, 33.06691], [-117.1229, 33.06681], [-117.12305, 33.06665], [-117.12318, 33.06653], [-117.12349, 33.06632], [-117.12368, 33.06617], [-117.12387, 33.06596], [-117.12401, 33.06571], [-117.12412, 33.0657], [-117.12411, 33.06544], [-117.12415, 33.06519], [-117.12415, 33.06479], [-117.12423, 33.06438], [-117.12603, 33.06455], [-117.12788, 33.06455], [-117.12814, 33.0646], [-117.12826, 33.0646], [-117.12862, 33.06454], [-117.12897, 33.06451], [-117.12907, 33.06454], [-117.12925, 33.06468], [-117.12939, 33.06474], [-117.12952, 33.06476], [-117.1298, 33.06475], [-117.13004, 33.06483], [-117.13017, 33.06485], [-117.1304, 33.06485], [-117.13053, 33.06486], [-117.13064, 33.0649], [-117.13091, 33.06506], [-117.12933, 33.06755], [-117.1271, 33.06756], [-117.12711, 33.07295], [-117.12718, 33.0802], [-117.13631, 33.08017], [-117.13631, 33.08116], [-117.13629, 33.08152], [-117.13633, 33.08392], [-117.13957, 33.08391], [-117.13955, 33.08019], [-117.14401, 33.08032], [-117.14803, 33.08027], [-117.14803, 33.08388], [-117.14805, 33.08584]]], [[[-117.13193, 33.06024], [-117.1319, 33.06349], [-117.13096, 33.06498], [-117.13069, 33.06483], [-117.13055, 33.06478], [-117.13042, 33.06477], [-117.1302, 33.06477], [-117.13006, 33.06475], [-117.1298, 33.06467], [-117.12954, 33.06467], [-117.12941, 33.06466], [-117.12927, 33.06459], [-117.12914, 33.06448], [-117.129, 33.06443], [-117.12886, 33.06443], [-117.12866, 33.06445], [-117.12833, 33.06451], [-117.12823, 33.06452], [-117.12769, 33.06443], [-117.12734, 33.0643], [-117.12689, 33.06409], [-117.12647, 33.06398], [-117.12639, 33.06391], [-117.12638, 33.06383], [-117.12642, 33.06376], [-117.12671, 33.06361], [-117.12679, 33.06353], [-117.12685, 33.06345], [-117.12688, 33.06336], [-117.12692, 33.0627], [-117.1271, 33.06259], [-117.12723, 33.06248], [-117.12759, 33.06209], [-117.12771, 33.06199], [-117.12786, 33.06191], [-117.12802, 33.06185], [-117.12849, 33.06178], [-117.12867, 33.06172], [-117.12883, 33.06164], [-117.12904, 33.06148], [-117.12933, 33.06112], [-117.12945, 33.06102], [-117.12965, 33.06092], [-117.13193, 33.06024]]]]} | Open Access 1 | 7314 | Del Dios Highlands Preserve | 10675 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/DelDiosHighlands.html | San Diego 4 | 781.705 | Del Dios Highlands Preserve | 0 | Local Conservation Area 4 | 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]);