units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where AGNCY_NAME = 587 and DES_TP = 4
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12214 | 12214 | 12213 | {"type": "MultiPolygon", "coordinates": [[[[-124.0922, 40.85233], [-124.09217, 40.85237], [-124.09208, 40.85261], [-124.09198, 40.85277], [-124.09195, 40.85289], [-124.09192, 40.85295], [-124.09191, 40.85305], [-124.09182, 40.85328], [-124.09181, 40.85336], [-124.09173, 40.85337], [-124.09169, 40.85341], [-124.09169, 40.85343], [-124.09173, 40.85348], [-124.09167, 40.85366], [-124.09157, 40.85371], [-124.09157, 40.85374], [-124.09162, 40.85379], [-124.09161, 40.85386], [-124.09154, 40.85392], [-124.09147, 40.85408], [-124.09139, 40.8543], [-124.09136, 40.85443], [-124.09125, 40.85461], [-124.09119, 40.85468], [-124.0911, 40.85476], [-124.09093, 40.85484], [-124.09088, 40.8549], [-124.09081, 40.8549], [-124.09077, 40.85493], [-124.09069, 40.85491], [-124.09058, 40.85492], [-124.08966, 40.8546], [-124.08891, 40.85519], [-124.08854, 40.85492], [-124.0858, 40.85304], [-124.08464, 40.85214], [-124.08416, 40.85171], [-124.08351, 40.85098], [-124.0832, 40.85056], [-124.08307, 40.85033], [-124.08348, 40.85033], [-124.08347, 40.85012], [-124.08388, 40.84935], [-124.08421, 40.84866], [-124.08428, 40.84847], [-124.08437, 40.84857], [-124.08442, 40.84867], [-124.08445, 40.84869], [-124.08445, 40.8488], [-124.0845, 40.84884], [-124.08457, 40.84887], [-124.08451, 40.84889], [-124.08454, 40.84892], [-124.08452, 40.84895], [-124.08462, 40.849], [-124.08463, 40.84906], [-124.08462, 40.8491], [-124.08468, 40.8492], [-124.0847, 40.8493], [-124.08472, 40.84932], [-124.08477, 40.84932], [-124.08488, 40.84929], [-124.08491, 40.8493], [-124.08493, 40.84933], [-124.08491, 40.84935], [-124.08487, 40.84935], [-124.08491, 40.84939], [-124.08488, 40.84946], [-124.0849, 40.84948], [-124.08499, 40.84946], [-124.08497, 40.8494], [-124.08498, 40.84938], [-124.085, 40.84942], [-124.08506, 40.84946], [-124.08527, 40.84947], [-124.0863, 40.84945], [-124.08703, 40.8494], [-124.08735, 40.84934], [-124.08737, 40.84938], [-124.08739, 40.84939], [-124.08747, 40.84932], [-124.08835, 40.84911], [-124.08866, 40.84906], [-124.08893, 40.84899], [-124.09039, 40.84871], [-124.09053, 40.84867], [-124.0906, 40.84866], [-124.09085, 40.84869], [-124.09104, 40.84876], [-124.09123, 40.84889], [-124.09137, 40.84909], [-124.09142, 40.8492], [-124.09144, 40.84928], [-124.09153, 40.84949], [-124.09164, 40.84995], [-124.09173, 40.85017], [-124.09176, 40.8503], [-124.09176, 40.85036], [-124.09182, 40.85046], [-124.09186, 40.85057], [-124.09196, 40.85099], [-124.09205, 40.85129], [-124.09213, 40.85139], [-124.09213, 40.85145], [-124.09218, 40.85155], [-124.09217, 40.85166], [-124.0922, 40.85178], [-124.09218, 40.85184], [-124.09223, 40.85202], [-124.09217, 40.85221], [-124.09217, 40.85225], [-124.09215, 40.85229], [-124.0922, 40.85233]]], [[[-124.09288, 40.86131], [-124.09233, 40.86198], [-124.08922, 40.86191], [-124.08921, 40.86125], [-124.08924, 40.86109], [-124.08936, 40.86058], [-124.08901, 40.8605], [-124.08951, 40.85919], [-124.08989, 40.85814], [-124.08992, 40.85752], [-124.0895, 40.85628], [-124.08941, 40.85607], [-124.08932, 40.8559], [-124.08918, 40.85571], [-124.08897, 40.85547], [-124.08919, 40.85561], [-124.0896, 40.85596], [-124.09038, 40.85673], [-124.09101, 40.85744], [-124.0915, 40.8581], [-124.09191, 40.85878], [-124.09215, 40.85924], [-124.09236, 40.85971], [-124.09243, 40.85988], [-124.09269, 40.8607], [-124.09277, 40.86087], [-124.09288, 40.86131]]], [[[-124.09302, 40.86339], [-124.09163, 40.863], [-124.09292, 40.86147], [-124.093, 40.86205], [-124.09303, 40.86246], [-124.09304, 40.86295], [-124.09302, 40.86339]]], [[[-124.10303, 40.86232], [-124.10334, 40.86264], [-124.10336, 40.8627], [-124.10336, 40.86281], [-124.1033, 40.86302], [-124.10326, 40.86308], [-124.10312, 40.86323], [-124.10288, 40.8634], [-124.1028, 40.86351], [-124.10277, 40.86358], [-124.10253, 40.86395], [-124.10204, 40.86408], [-124.10168, 40.86419], [-124.10189, 40.86465], [-124.10226, 40.86484], [-124.10237, 40.86492], [-124.10241, 40.86497], [-124.10243, 40.86513], [-124.10247, 40.8652], [-124.10292, 40.86556], [-124.10302, 40.86563], [-124.10308, 40.86571], [-124.10311, 40.8658], [-124.10309, 40.8659], [-124.10298, 40.86611], [-124.10292, 40.86618], [-124.10288, 40.86622], [-124.10275, 40.86627], [-124.10243, 40.86646], [-124.10239, 40.86695], [-124.10229, 40.86746], [-124.10181, 40.8675], [-124.10212, 40.86729], [-124.10215, 40.86708], [-124.10209, 40.86683], [-124.10224, 40.86614], [-124.10239, 40.86608], [-124.10246, 40.86575], [-124.10239, 40.86561], [-124.10216, 40.86535], [-124.10208, 40.86506], [-124.10164, 40.86479], [-124.09866, 40.86479], [-124.0984, 40.86542], [-124.0975, 40.86524], [-124.09736, 40.86557], [-124.09736, 40.86587], [-124.09543, 40.86547], [-124.09576, 40.86468], [-124.09314, 40.86393], [-124.09319, 40.86344], [-124.09322, 40.86268], [-124.09318, 40.86204], [-124.09306, 40.8613], [-124.09401, 40.86015], [-124.09505, 40.85893], [-124.0951, 40.85892], [-124.09517, 40.85895], [-124.09529, 40.85919], [-124.09541, 40.85934], [-124.09554, 40.85945], [-124.09574, 40.85955], [-124.09593, 40.85961], [-124.09638, 40.85966], [-124.09679, 40.85962], [-124.0968, 40.85961], [-124.09592, 40.85949], [-124.09568, 40.85939], [-124.09556, 40.85931], [-124.09543, 40.85916], [-124.0952, 40.85867], [-124.09512, 40.85863], [-124.09503, 40.85863], [-124.09496, 40.85867], [-124.09495, 40.8587], [-124.09495, 40.85883], [-124.09493, 40.85887], [-124.09387, 40.86011], [-124.09303, 40.86114], [-124.09295, 40.86086], [-124.09281, 40.86051], [-124.09262, 40.85988], [-124.09236, 40.85926], [-124.09209, 40.85874], [-124.09174, 40.85817], [-124.09137, 40.85765], [-124.09083, 40.85698], [-124.09047, 40.85659], [-124.09037, 40.85632], [-124.09158, 40.85532], [-124.09172, 40.8553], [-124.09178, 40.85527], [-124.09179, 40.85525], [-124.09178, 40.85521], [-124.0918, 40.85517], [-124.09191, 40.85507], [-124.09234, 40.85459], [-124.09283, 40.85414], [-124.09301, 40.85393], [-124.09315, 40.85381], [-124.09323, 40.85376], [-124.0934, 40.85372], [-124.0936, 40.85371], [-124.09385, 40.85375], [-124.09408, 40.85376], [-124.09499, 40.85403], [-124.09519, 40.85412], [-124.09576, 40.85429], [-124.09614, 40.85442], [-124.09623, 40.85447], [-124.09628, 40.85448], [-124.09634, 40.85452], [-124.09687, 40.8547], [-124.09726, 40.85486], [-124.09757, 40.85496], [-124.09828, 40.85524], [-124.09844, 40.85537], [-124.09857, 40.85553], [-124.09861, 40.85559], [-124.09862, 40.85579], [-124.09854, 40.85603], [-124.09843, 40.85622], [-124.09847, 40.85636], [-124.09846, 40.85643], [-124.09838, 40.85664], [-124.09823, 40.85662], [-124.09768, 40.85819], [-124.09827, 40.85834], [-124.09854, 40.85836], [-124.09888, 40.85836], [-124.09989, 40.85815], [-124.10004, 40.85815], [-124.10027, 40.85818], [-124.10047, 40.8583], [-124.10059, 40.8584], [-124.10061, 40.85846], [-124.09991, 40.8586], [-124.09982, 40.85879], [-124.09984, 40.85888], [-124.10008, 40.85926], [-124.1002, 40.8595], [-124.10025, 40.85956], [-124.10031, 40.8596], [-124.1004, 40.85964], [-124.10096, 40.85977], [-124.10103, 40.85981], [-124.10107, 40.85986], [-124.10074, 40.86022], [-124.10055, 40.86034], [-124.10046, 40.86045], [-124.10041, 40.86063], [-124.10041, 40.86091], [-124.10042, 40.86097], [-124.10088, 40.86186], [-124.10121, 40.86266], [-124.10134, 40.86277], [-124.10153, 40.86286], [-124.1017, 40.8629], [-124.10192, 40.8629], [-124.10223, 40.86276], [-124.10264, 40.8624], [-124.10272, 40.86234], [-124.10278, 40.86232], [-124.1029, 40.8623], [-124.10303, 40.86232]]]]} | Open Access 1 | 25405 | Arcata Marsh & Wildlife Sanctuary | 15570 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 316.49 | Arcata Marsh & Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 | |
| 14366 | 14366 | 14365 | {"type": "MultiPolygon", "coordinates": [[[[-124.0907, 40.87504], [-124.09043, 40.87498], [-124.09043, 40.87491], [-124.09035, 40.87489], [-124.0905, 40.87451], [-124.0907, 40.87504]]], [[[-124.09106, 40.87533], [-124.09096, 40.87542], [-124.09102, 40.87562], [-124.09096, 40.87576], [-124.09097, 40.87604], [-124.09089, 40.87657], [-124.09081, 40.8764], [-124.09075, 40.8762], [-124.09062, 40.87551], [-124.09044, 40.87505], [-124.09103, 40.87517], [-124.09106, 40.87533]]], [[[-124.09083, 40.87428], [-124.09074, 40.87443], [-124.09073, 40.87459], [-124.09067, 40.87467], [-124.09055, 40.87437], [-124.0906, 40.87423], [-124.09083, 40.87428]]]]} | Open Access 1 | 47025 | Dellanina Nature Preserve | 30674 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 1.331 | Dellanina Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
| 16781 | 16781 | 16780 | {"type": "Polygon", "coordinates": [[[-124.08173, 40.85366], [-124.08205, 40.85795], [-124.08204, 40.85906], [-124.08207, 40.86057], [-124.08202, 40.86085], [-124.08195, 40.86105], [-124.08189, 40.86114], [-124.08163, 40.8614], [-124.08149, 40.86151], [-124.0813, 40.86161], [-124.08108, 40.8617], [-124.08089, 40.86176], [-124.08045, 40.86184], [-124.08038, 40.85941], [-124.08034, 40.85885], [-124.0789, 40.85886], [-124.07895, 40.86166], [-124.07872, 40.86161], [-124.07846, 40.86153], [-124.07833, 40.86147], [-124.07833, 40.86145], [-124.07796, 40.86131], [-124.07763, 40.86114], [-124.07732, 40.86104], [-124.07701, 40.86099], [-124.07685, 40.86113], [-124.07634, 40.86087], [-124.07601, 40.86066], [-124.07575, 40.86044], [-124.07555, 40.86025], [-124.07351, 40.85798], [-124.07422, 40.85762], [-124.07362, 40.85567], [-124.07233, 40.85574], [-124.07226, 40.85358], [-124.07302, 40.85358], [-124.07299, 40.85048], [-124.07303, 40.84968], [-124.06907, 40.84969], [-124.06897, 40.84952], [-124.06746, 40.84753], [-124.07029, 40.84629], [-124.07029, 40.84627], [-124.06941, 40.8451], [-124.06943, 40.84508], [-124.06847, 40.8444], [-124.06704, 40.84256], [-124.0661, 40.84234], [-124.06497, 40.84145], [-124.06591, 40.84078], [-124.06643, 40.8412], [-124.06667, 40.84104], [-124.06696, 40.84128], [-124.06731, 40.84104], [-124.06894, 40.84233], [-124.07297, 40.8423], [-124.07297, 40.84018], [-124.07238, 40.84001], [-124.07216, 40.83988], [-124.07148, 40.83966], [-124.07063, 40.83907], [-124.07057, 40.83901], [-124.07033, 40.83899], [-124.07015, 40.83906], [-124.07008, 40.83903], [-124.07005, 40.83901], [-124.07005, 40.83896], [-124.07009, 40.83875], [-124.07015, 40.83869], [-124.07016, 40.83864], [-124.07016, 40.83859], [-124.07009, 40.83846], [-124.07041, 40.83803], [-124.07088, 40.8378], [-124.07057, 40.83747], [-124.07097, 40.83718], [-124.07299, 40.83865], [-124.07384, 40.83503], [-124.07993, 40.83507], [-124.08014, 40.83513], [-124.08081, 40.83521], [-124.08097, 40.83527], [-124.08109, 40.83536], [-124.08113, 40.83541], [-124.08122, 40.83563], [-124.08142, 40.83776], [-124.08153, 40.83871], [-124.08151, 40.84041], [-124.08148, 40.84617], [-124.0813, 40.84616], [-124.08129, 40.84617], [-124.0813, 40.84716], [-124.08128, 40.84882], [-124.08144, 40.8506], [-124.08146, 40.8506], [-124.08152, 40.85053], [-124.08161, 40.85091], [-124.08164, 40.85242], [-124.08173, 40.85366]], [[-124.07898, 40.84969], [-124.07899, 40.84968], [-124.07896, 40.8489], [-124.07788, 40.84904], [-124.07788, 40.8497], [-124.07898, 40.84969]]]} | Open Access 1 | 46882 | Jacoby Creek-Gannon Slough Wildlife Area | 30363 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 587.76 | Jacoby Creek-Gannon Slough Wildlife Area | 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]);