superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, LABEL_NAME = "Murphy" and MNG_AGENCY = 169
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7290 | 7290 | 7289 | {"type": "Polygon", "coordinates": [[[-121.6547, 36.1411], [-121.65326, 36.1411], [-121.65289, 36.14044], [-121.65268, 36.13993], [-121.65204, 36.14043], [-121.65076, 36.1392], [-121.64971, 36.13814], [-121.64917, 36.13763], [-121.64917, 36.13645], [-121.64931, 36.13643], [-121.64941, 36.13605], [-121.64917, 36.13595], [-121.64918, 36.13411], [-121.64925, 36.13426], [-121.64931, 36.13451], [-121.64931, 36.13486], [-121.64923, 36.13501], [-121.64923, 36.13511], [-121.64928, 36.13518], [-121.64936, 36.13525], [-121.64964, 36.1352], [-121.64974, 36.13526], [-121.64977, 36.13534], [-121.64978, 36.13559], [-121.64987, 36.13576], [-121.64995, 36.13592], [-121.64997, 36.13607], [-121.64987, 36.13611], [-121.64981, 36.1362], [-121.64978, 36.13651], [-121.64979, 36.13666], [-121.64981, 36.13673], [-121.65003, 36.13683], [-121.65027, 36.1369], [-121.65037, 36.13695], [-121.65043, 36.13702], [-121.65071, 36.13716], [-121.65092, 36.13732], [-121.65107, 36.13738], [-121.65136, 36.1376], [-121.65148, 36.13765], [-121.65191, 36.13777], [-121.65211, 36.13779], [-121.65233, 36.13785], [-121.65242, 36.13786], [-121.65281, 36.1381], [-121.65291, 36.13825], [-121.65306, 36.13841], [-121.65317, 36.13856], [-121.65324, 36.13873], [-121.65328, 36.13897], [-121.65333, 36.13904], [-121.65333, 36.13912], [-121.6534, 36.13927], [-121.65361, 36.13949], [-121.65371, 36.13955], [-121.65373, 36.13963], [-121.65374, 36.13971], [-121.65362, 36.13987], [-121.65359, 36.14004], [-121.6536, 36.1403], [-121.6537, 36.14053], [-121.65382, 36.1407], [-121.65403, 36.14081], [-121.65423, 36.14084], [-121.65433, 36.14088], [-121.6547, 36.1411]]]} | Restricted Access 2 | Murphy | 22606 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 24.918 | Murphy |
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]);