units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Whiskeytown-Shasta-Trinity NRA" and MNG_AGENCY = 59
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15803 | 15803 | 15802 | {"type": "Polygon", "coordinates": [[[-122.71133, 40.61643], [-122.71149, 40.61739], [-122.71147, 40.61801], [-122.71143, 40.61845], [-122.71132, 40.61911], [-122.71122, 40.61946], [-122.71099, 40.62011], [-122.71097, 40.6202], [-122.71089, 40.62057], [-122.71076, 40.62142], [-122.71074, 40.62165], [-122.71078, 40.6222], [-122.71085, 40.62249], [-122.71114, 40.62322], [-122.71121, 40.6234], [-122.71122, 40.62354], [-122.71107, 40.62433], [-122.711, 40.62455], [-122.71087, 40.62486], [-122.71088, 40.62487], [-122.71093, 40.62487], [-122.71028, 40.62598], [-122.71013, 40.62628], [-122.70975, 40.62674], [-122.70966, 40.62699], [-122.70971, 40.62737], [-122.71009, 40.62842], [-122.71027, 40.6288], [-122.71034, 40.62911], [-122.71018, 40.6296], [-122.71003, 40.63022], [-122.70998, 40.63036], [-122.70986, 40.63054], [-122.70977, 40.63114], [-122.70169, 40.63286], [-122.70156, 40.63443], [-122.69885, 40.63653], [-122.69878, 40.63781], [-122.69894, 40.63844], [-122.69651, 40.63891], [-122.69486, 40.63832], [-122.693, 40.63826], [-122.69116, 40.63886], [-122.69076, 40.63972], [-122.69051, 40.63953], [-122.68984, 40.63897], [-122.68844, 40.63955], [-122.68647, 40.63983], [-122.68452, 40.64085], [-122.68277, 40.64498], [-122.68288, 40.64624], [-122.68321, 40.64793], [-122.68546, 40.64801], [-122.68549, 40.65064], [-122.68552, 40.65098], [-122.68565, 40.65162], [-122.68268, 40.65161], [-122.68223, 40.65318], [-122.68122, 40.65379], [-122.68099, 40.6554], [-122.68035, 40.65639], [-122.67916, 40.65719], [-122.67799, 40.65991], [-122.67815, 40.66061], [-122.67752, 40.66092], [-122.67507, 40.66305], [-122.6717, 40.66368], [-122.66965, 40.66631], [-122.65169, 40.66612], [-122.65148, 40.67122], [-122.65145, 40.67217], [-122.65102, 40.68034], [-122.65106, 40.68072], [-122.63293, 40.68092], [-122.63291, 40.68044], [-122.63295, 40.67327], [-122.63263, 40.66945], [-122.62787, 40.66965], [-122.6231, 40.66983], [-122.62301, 40.66594], [-122.61369, 40.66604], [-122.61374, 40.66435], [-122.61373, 40.66434], [-122.60475, 40.66419], [-122.59555, 40.66395], [-122.59579, 40.66191], [-122.59112, 40.66189], [-122.58462, 40.66195], [-122.58181, 40.66194], [-122.57723, 40.66196], [-122.56334, 40.66227], [-122.56258, 40.6663], [-122.55775, 40.6663], [-122.53942, 40.66616], [-122.54161, 40.65081], [-122.5258, 40.65116], [-122.52499, 40.65115], [-122.52263, 40.65122], [-122.52256, 40.65016], [-122.5224, 40.64503], [-122.5221, 40.63649], [-122.52233, 40.632], [-122.52163, 40.63165], [-122.52006, 40.63074], [-122.51962, 40.63045], [-122.51902, 40.62997], [-122.51849, 40.62945], [-122.51805, 40.62888], [-122.51769, 40.62828], [-122.51751, 40.62786], [-122.51743, 40.62765], [-122.5173, 40.62722], [-122.51723, 40.62678], [-122.5172, 40.62656], [-122.51719, 40.62634], [-122.5172, 40.6259], [-122.51725, 40.62546], [-122.51729, 40.62524], [-122.51792, 40.62382], [-122.51839, 40.62304], [-122.51856, 40.62244], [-122.51856, 40.62174], [-122.5185, 40.62151], [-122.50899, 40.62134], [-122.50902, 40.61951], [-122.51368, 40.61964], [-122.51374, 40.61653], [-122.51392, 40.61029], [-122.51456, 40.6103], [-122.51457, 40.61029], [-122.51044, 40.60684], [-122.51025, 40.60665], [-122.51211, 40.60666], [-122.51398, 40.60815], [-122.51403, 40.60666], [-122.51472, 40.60665], [-122.51474, 40.60306], [-122.51201, 40.60303], [-122.50974, 40.60303], [-122.50974, 40.59954], [-122.50469, 40.59952], [-122.50497, 40.59214], [-122.50502, 40.58486], [-122.50521, 40.57767], [-122.50645, 40.56059], [-122.51498, 40.56028], [-122.51504, 40.5461], [-122.52413, 40.54614], [-122.52408, 40.54792], [-122.52401, 40.55315], [-122.52901, 40.55361], [-122.53641, 40.55418], [-122.54351, 40.55477], [-122.54334, 40.5618], [-122.55359, 40.56199], [-122.56157, 40.56207], [-122.56164, 40.55171], [-122.56621, 40.55151], [-122.56781, 40.55146], [-122.57092, 40.5514], [-122.57089, 40.55494], [-122.5802, 40.55501], [-122.58016, 40.55734], [-122.58079, 40.55785], [-122.58354, 40.55793], [-122.58418, 40.55827], [-122.58784, 40.55907], [-122.58834, 40.56162], [-122.58842, 40.5618], [-122.58989, 40.56172], [-122.58989, 40.56218], [-122.59036, 40.56316], [-122.59077, 40.56498], [-122.59342, 40.5667], [-122.59394, 40.56702], [-122.59679, 40.56584], [-122.5995, 40.56339], [-122.60011, 40.563], [-122.6066, 40.56524], [-122.60982, 40.56687], [-122.61399, 40.56677], [-122.61775, 40.56796], [-122.61776, 40.56795], [-122.61775, 40.56712], [-122.62853, 40.56731], [-122.63613, 40.5675], [-122.63606, 40.57013], [-122.63765, 40.57111], [-122.63824, 40.57138], [-122.63966, 40.57026], [-122.64015, 40.56991], [-122.64112, 40.57007], [-122.64165, 40.5697], [-122.64435, 40.57356], [-122.64651, 40.57476], [-122.64785, 40.57802], [-122.65548, 40.57798], [-122.65538, 40.58507], [-122.65643, 40.58579], [-122.6606, 40.58568], [-122.66179, 40.58667], [-122.66168, 40.58813], [-122.66285, 40.58967], [-122.66435, 40.59017], [-122.66682, 40.5889], [-122.67108, 40.58826], [-122.67316, 40.58787], [-122.67419, 40.57786], [-122.69326, 40.57776], [-122.69315, 40.57803], [-122.69305, 40.57823], [-122.6929, 40.57879], [-122.69286, 40.57929], [-122.69299, 40.57964], [-122.69302, 40.57991], [-122.69291, 40.58052], [-122.69298, 40.58067], [-122.69338, 40.58094], [-122.69392, 40.5812], [-122.69423, 40.58139], [-122.69448, 40.58151], [-122.6952, 40.58174], [-122.69551, 40.58188], [-122.69585, 40.58209], [-122.69623, 40.58252], [-122.69637, 40.58273], [-122.6973, 40.58347], [-122.69754, 40.58369], [-122.69863, 40.58442], [-122.6989, 40.58466], [-122.69957, 40.58512], [-122.69986, 40.58544], [-122.70015, 40.58569], [-122.70029, 40.58591], [-122.70037, 40.58619], [-122.70036, 40.58656], [-122.7004, 40.58685], [-122.70061, 40.5872], [-122.7009, 40.58754], [-122.70097, 40.58767], [-122.7009, 40.5879], [-122.70081, 40.58798], [-122.70055, 40.58818], [-122.70043, 40.58831], [-122.7003, 40.58846], [-122.70007, 40.58885], [-122.69991, 40.5892], [-122.69981, 40.58962], [-122.69978, 40.59011], [-122.70004, 40.59096], [-122.7002, 40.59134], [-122.70065, 40.59189], [-122.70081, 40.59212], [-122.70103, 40.59236], [-122.70125, 40.59251], [-122.70158, 40.5927], [-122.70193, 40.59299], [-122.70201, 40.59336], [-122.702, 40.59366], [-122.70194, 40.594], [-122.70187, 40.59422], [-122.70174, 40.59452], [-122.70147, 40.59498], [-122.70121, 40.59567], [-122.70122, 40.59579], [-122.70131, 40.59595], [-122.7022, 40.59673], [-122.70265, 40.59701], [-122.70294, 40.59714], [-122.70329, 40.59726], [-122.70351, 40.5974], [-122.70351, 40.59751], [-122.70346, 40.59773], [-122.70337, 40.59796], [-122.70332, 40.59818], [-122.70344, 40.59856], [-122.70358, 40.59889], [-122.70371, 40.59906], [-122.70388, 40.59918], [-122.7041, 40.5993], [-122.70438, 40.59943], [-122.70467, 40.59954], [-122.70493, 40.59968], [-122.70509, 40.59981], [-122.70538, 40.60019], [-122.70546, 40.60037], [-122.70551, 40.60056], [-122.70545, 40.60142], [-122.70541, 40.60171], [-122.70516, 40.6026], [-122.70495, 40.60328], [-122.70493, 40.6036], [-122.70499, 40.60392], [-122.70536, 40.60471], [-122.70551, 40.60495], [-122.70566, 40.60514], [-122.70583, 40.60521], [-122.70604, 40.60511], [-122.70622, 40.60506], [-122.70645, 40.60507], [-122.70661, 40.60514], [-122.70676, 40.60527], [-122.70696, 40.60575], [-122.70696, 40.60614], [-122.70689, 40.60677], [-122.70664, 40.60788], [-122.70648, 40.60866], [-122.70638, 40.60897], [-122.70617, 40.6093], [-122.70608, 40.60963], [-122.7061, 40.60975], [-122.70663, 40.61052], [-122.70685, 40.61081], [-122.70751, 40.61152], [-122.70762, 40.61159], [-122.70839, 40.61183], [-122.7087, 40.61191], [-122.70909, 40.61197], [-122.7101, 40.61215], [-122.71032, 40.61228], [-122.7104, 40.61234], [-122.71053, 40.61245], [-122.71066, 40.61261], [-122.71072, 40.61275], [-122.71076, 40.61301], [-122.71085, 40.6137], [-122.71087, 40.61399], [-122.71085, 40.61443], [-122.71095, 40.61508], [-122.71108, 40.61558], [-122.71133, 40.61643]]]} | Open Access 1 | 10486 | Whiskeytown-Shasta-Trinity National Recreation Area | 14303 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/whis/index.htm | Shasta 27 | 42235.009 | Whiskeytown-Shasta-Trinity NRA | 1965 | National Recreation Area 54 | 3 |
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]);