units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 3, COUNTY = 4, MNG_AG_TYP = 5 and YR_EST = 0
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, LAYER, GAP_STS
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1316 | 1316 | 1315 | {"type": "Polygon", "coordinates": [[[-116.74116, 32.57636], [-116.74114, 32.58363], [-116.73714, 32.58342], [-116.73291, 32.5834], [-116.73278, 32.58732], [-116.72047, 32.58718], [-116.72045, 32.58913], [-116.70751, 32.5894], [-116.69094, 32.5893], [-116.69082, 32.58084], [-116.69077, 32.57124], [-116.73696, 32.56738], [-116.73704, 32.56906], [-116.74116, 32.5691], [-116.74116, 32.5727], [-116.73707, 32.57263], [-116.73709, 32.57623], [-116.74116, 32.57636]]]} | No Public Access 3 | 7399 | Kuchamaa Experimental Forest | 20729 | 202 | California Department of Forestry and Fire Protection 346 | State 5 | State Agency 5 | http://www.fire.ca.gov/ | Other State 5 | 202 | California Department of Forestry and Fire Protection 343 | State 5 | State Agency 5 | San Diego 4 | 2363.684 | Kuchamaa Experimental Forest | 0 | None 113 | ||
| 3678 | 3678 | 3677 | {"type": "Polygon", "coordinates": [[[-117.17431, 33.05469], [-117.17231, 33.05468], [-117.17229, 33.05456], [-117.17224, 33.05445], [-117.17216, 33.05434], [-117.17206, 33.05426], [-117.17194, 33.05419], [-117.17181, 33.05416], [-117.17142, 33.05413], [-117.17121, 33.05407], [-117.17104, 33.05396], [-117.17068, 33.05363], [-117.17054, 33.05374], [-117.17047, 33.05382], [-117.1704, 33.05399], [-117.17038, 33.05408], [-117.1704, 33.05417], [-117.17059, 33.05467], [-117.17004, 33.05467], [-117.16999, 33.05106], [-117.172, 33.05106], [-117.17202, 33.0523], [-117.17429, 33.0523], [-117.17431, 33.05469]]]} | No Public Access 3 | 44356 | Escondido Creek | 32162 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 29.504 | Escondido Creek | 0 | State Resource Management Area 55 | 3 | |
| 3744 | 3744 | 3743 | {"type": "Polygon", "coordinates": [[[-117.00555, 32.56116], [-117.00554, 32.56472], [-117.00446, 32.56471], [-117.00445, 32.56601], [-117.00443, 32.56603], [-117.00418, 32.566], [-117.00401, 32.56588], [-117.00338, 32.56582], [-117.00337, 32.56469], [-117.00123, 32.56466], [-117.00126, 32.56109], [-117.00555, 32.56116]]]} | No Public Access 3 | 44877 | Anderprises TransNet Environmental Mitigation | 32283 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 42.881 | Anderprises TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
| 6243 | 6243 | 6242 | {"type": "Polygon", "coordinates": [[[-116.96211, 32.96295], [-116.95351, 32.96324], [-116.95342, 32.95961], [-116.94888, 32.95974], [-116.94878, 32.95602], [-116.94045, 32.9561], [-116.94043, 32.95977], [-116.93185, 32.95964], [-116.93185, 32.95601], [-116.92761, 32.95596], [-116.92763, 32.95203], [-116.93186, 32.95198], [-116.93182, 32.94121], [-116.92765, 32.94122], [-116.92248, 32.94033], [-116.9225, 32.94032], [-116.92218, 32.93627], [-116.92764, 32.93755], [-116.92764, 32.93401], [-116.93615, 32.93378], [-116.93618, 32.93562], [-116.94046, 32.93556], [-116.94047, 32.93366], [-116.9447, 32.93354], [-116.94886, 32.93352], [-116.94892, 32.94093], [-116.95334, 32.9409], [-116.9534, 32.94251], [-116.95366, 32.94251], [-116.95404, 32.94257], [-116.95419, 32.94253], [-116.95424, 32.9425], [-116.95433, 32.94237], [-116.95436, 32.94199], [-116.95436, 32.94189], [-116.95434, 32.94179], [-116.95417, 32.94158], [-116.95413, 32.94147], [-116.95414, 32.94141], [-116.95421, 32.94125], [-116.9543, 32.94118], [-116.95462, 32.94098], [-116.95478, 32.94093], [-116.9549, 32.9409], [-116.95518, 32.94089], [-116.95541, 32.94094], [-116.95553, 32.94095], [-116.95568, 32.94125], [-116.95518, 32.94132], [-116.95504, 32.94139], [-116.95494, 32.94146], [-116.95486, 32.94158], [-116.95481, 32.94169], [-116.95481, 32.94184], [-116.95484, 32.94192], [-116.95488, 32.94211], [-116.95483, 32.94232], [-116.95478, 32.94241], [-116.9547, 32.94251], [-116.95461, 32.94259], [-116.95445, 32.94268], [-116.95429, 32.94272], [-116.95411, 32.94274], [-116.95366, 32.94268], [-116.95324, 32.94271], [-116.95308, 32.94269], [-116.95286, 32.94263], [-116.9527, 32.94263], [-116.95253, 32.94268], [-116.9524, 32.94276], [-116.9513, 32.94378], [-116.95115, 32.94389], [-116.95109, 32.94392], [-116.95165, 32.94469], [-116.94886, 32.94473], [-116.94889, 32.95222], [-116.95298, 32.9522], [-116.95323, 32.95222], [-116.95318, 32.94851], [-116.95783, 32.94845], [-116.95798, 32.95947], [-116.96207, 32.95939], [-116.96211, 32.96295]]]} | No Public Access 3 | 1316 | San Vicente Highlands | 32296 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 1545.08 | San Vicente Highlands | 0 | State Resource Management Area 55 | 3 | |
| 7862 | 7862 | 7861 | {"type": "MultiPolygon", "coordinates": [[[[-116.94813, 32.58902], [-116.9452, 32.5891], [-116.94513, 32.5821], [-116.94581, 32.58211], [-116.9458, 32.58217], [-116.94582, 32.58248], [-116.94603, 32.58271], [-116.94635, 32.58283], [-116.94672, 32.58291], [-116.94705, 32.58296], [-116.94715, 32.58293], [-116.94748, 32.58333], [-116.94808, 32.58424], [-116.94542, 32.58527], [-116.94582, 32.58582], [-116.947, 32.58786], [-116.94813, 32.58902]]], [[[-116.96324, 32.58239], [-116.96221, 32.58238], [-116.96223, 32.58109], [-116.96255, 32.58146], [-116.96287, 32.58187], [-116.96324, 32.58239]]], [[[-116.97107, 32.58246], [-116.96665, 32.58242], [-116.96664, 32.58433], [-116.9656, 32.58432], [-116.96528, 32.5838], [-116.96527, 32.58366], [-116.96504, 32.58323], [-116.96479, 32.58282], [-116.96439, 32.58227], [-116.96379, 32.5813], [-116.96318, 32.58026], [-116.96293, 32.57991], [-116.96267, 32.57957], [-116.96225, 32.57912], [-116.96225, 32.57881], [-116.96235, 32.5788], [-116.96238, 32.57507], [-116.97088, 32.57514], [-116.97107, 32.58246]]]]} | No Public Access 3 | 47715 | Lonestar Ridge TransNet Environmental Mitigation | 31496 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 191.623 | Lonestar Ridge TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
| 12161 | 12161 | 12160 | {"type": "MultiPolygon", "coordinates": [[[[-116.89905, 32.95333], [-116.89, 32.95344], [-116.88151, 32.95355], [-116.8816, 32.96148], [-116.88116, 32.9615], [-116.88115, 32.96152], [-116.885, 32.9652], [-116.88908, 32.96899], [-116.88886, 32.96915], [-116.88806, 32.96953], [-116.88748, 32.96988], [-116.88714, 32.97015], [-116.88637, 32.97047], [-116.88496, 32.97038], [-116.88394, 32.97102], [-116.88384, 32.97134], [-116.88348, 32.97175], [-116.88356, 32.97201], [-116.88313, 32.97251], [-116.88289, 32.97259], [-116.88262, 32.97308], [-116.88259, 32.97326], [-116.88268, 32.9735], [-116.8831, 32.97377], [-116.88302, 32.97416], [-116.883, 32.9744], [-116.88309, 32.97464], [-116.88333, 32.97482], [-116.88365, 32.97502], [-116.88396, 32.9752], [-116.8848, 32.97528], [-116.88502, 32.97532], [-116.88523, 32.97541], [-116.8854, 32.97555], [-116.88529, 32.97581], [-116.88538, 32.97593], [-116.88558, 32.97612], [-116.88559, 32.97621], [-116.88546, 32.97641], [-116.88497, 32.9773], [-116.88513, 32.97767], [-116.88546, 32.97779], [-116.88569, 32.97807], [-116.88589, 32.97851], [-116.88585, 32.97869], [-116.88572, 32.97887], [-116.88574, 32.97923], [-116.88615, 32.98011], [-116.88646, 32.98026], [-116.88664, 32.98061], [-116.88691, 32.98074], [-116.88704, 32.98091], [-116.8871, 32.98113], [-116.88712, 32.98177], [-116.88739, 32.98276], [-116.88724, 32.98301], [-116.88737, 32.98363], [-116.88727, 32.98413], [-116.88743, 32.98493], [-116.88738, 32.98527], [-116.88734, 32.98618], [-116.88744, 32.98643], [-116.88739, 32.98664], [-116.88719, 32.98685], [-116.88719, 32.98709], [-116.88736, 32.98767], [-116.88731, 32.98807], [-116.8875, 32.98843], [-116.88729, 32.98881], [-116.88741, 32.98924], [-116.88717, 32.98984], [-116.88666, 32.99058], [-116.88661, 32.99098], [-116.88658, 32.99111], [-116.88666, 32.99133], [-116.88665, 32.9917], [-116.88654, 32.99221], [-116.88662, 32.99234], [-116.8864, 32.9939], [-116.87774, 32.99394], [-116.87771, 32.99394], [-116.8777, 32.99389], [-116.87565, 32.99388], [-116.87531, 32.98531], [-116.86673, 32.98548], [-116.86689, 32.99385], [-116.85049, 32.99367], [-116.85066, 32.99357], [-116.85055, 32.99344], [-116.85028, 32.99359], [-116.85006, 32.99368], [-116.8499, 32.99368], [-116.84983, 32.99285], [-116.84955, 32.98892], [-116.8484, 32.98898], [-116.84841, 32.98896], [-116.84841, 32.98895], [-116.84131, 32.98865], [-116.84128, 32.97835], [-116.84039, 32.96417], [-116.84829, 32.96324], [-116.84847, 32.94951], [-116.85033, 32.95109], [-116.85343, 32.95285], [-116.8537, 32.95281], [-116.85377, 32.95285], [-116.85671, 32.95243], [-116.85752, 32.95367], [-116.85831, 32.95552], [-116.85917, 32.95623], [-116.85986, 32.95615], [-116.86132, 32.95637], [-116.86287, 32.95522], [-116.86398, 32.95328], [-116.8659, 32.95241], [-116.86586, 32.95523], [-116.8735, 32.95511], [-116.87459, 32.95514], [-116.88011, 32.94845], [-116.87784, 32.94618], [-116.88568, 32.94618], [-116.88564, 32.94202], [-116.88949, 32.94174], [-116.89438, 32.94175], [-116.8944, 32.94591], [-116.89892, 32.94576], [-116.89905, 32.95333]], [[-116.85013, 32.98801], [-116.85065, 32.98657], [-116.84949, 32.98657], [-116.84954, 32.98837], [-116.84974, 32.98835], [-116.84991, 32.98827], [-116.85005, 32.98815], [-116.85013, 32.98801]]], [[[-116.90039, 32.98023], [-116.89618, 32.98029], [-116.89653, 32.98476], [-116.89236, 32.98489], [-116.89283, 32.98927], [-116.89317, 32.99393], [-116.88879, 32.99392], [-116.88686, 32.9939], [-116.88696, 32.99365], [-116.88691, 32.99352], [-116.88678, 32.9933], [-116.88692, 32.99229], [-116.88684, 32.99216], [-116.88694, 32.99173], [-116.88695, 32.9913], [-116.88688, 32.9911], [-116.88694, 32.99065], [-116.88743, 32.98995], [-116.88772, 32.98926], [-116.8876, 32.98884], [-116.88782, 32.98844], [-116.88761, 32.98803], [-116.88766, 32.98766], [-116.88748, 32.98706], [-116.88748, 32.98694], [-116.88767, 32.98674], [-116.88774, 32.98642], [-116.88764, 32.98615], [-116.88768, 32.98529], [-116.88772, 32.98492], [-116.88757, 32.98413], [-116.88767, 32.98363], [-116.88754, 32.98305], [-116.8877, 32.98279], [-116.88741, 32.98174], [-116.88739, 32.98111], [-116.88732, 32.98082], [-116.88711, 32.98055], [-116.88687, 32.98044], [-116.88669, 32.98009], [-116.88639, 32.97994], [-116.88603, 32.97917], [-116.88601, 32.97894], [-116.88614, 32.97878], [-116.88619, 32.97848], [-116.88595, 32.97795], [-116.88565, 32.97759], [-116.88537, 32.97748], [-116.88529, 32.97731], [-116.88572, 32.97653], [-116.88585, 32.97632], [-116.88591, 32.97618], [-116.88589, 32.97611], [-116.88568, 32.97589], [-116.88562, 32.97577], [-116.88574, 32.97564], [-116.88576, 32.97544], [-116.88552, 32.97514], [-116.88519, 32.97496], [-116.88454, 32.97497], [-116.88416, 32.97491], [-116.88367, 32.97459], [-116.88342, 32.97445], [-116.88331, 32.97435], [-116.88341, 32.97379], [-116.88335, 32.97365], [-116.88297, 32.97336], [-116.88293, 32.97329], [-116.88292, 32.97323], [-116.88293, 32.97317], [-116.88313, 32.97282], [-116.88333, 32.97276], [-116.8839, 32.97204], [-116.88384, 32.97183], [-116.88416, 32.9715], [-116.88425, 32.97121], [-116.88509, 32.97067], [-116.88647, 32.97077], [-116.88707, 32.97049], [-116.88737, 32.97033], [-116.88772, 32.97009], [-116.88829, 32.96974], [-116.88913, 32.96933], [-116.88931, 32.9692], [-116.89119, 32.97093], [-116.89186, 32.97159], [-116.89141, 32.97351], [-116.89084, 32.97584], [-116.9001, 32.97586], [-116.90039, 32.98023]]]]} | No Public Access 3 | 25240 | Canada de San Vicente | 32091 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 4998.226 | Canada de San Vicente | 0 | State Resource Management Area 55 | 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]);