units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and UNIT_NAME = "Jug Handle State Natural Reserve"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5187 | 5187 | 5186 | {"type": "MultiPolygon", "coordinates": [[[[-123.78065, 39.3808], [-123.77832, 39.38069], [-123.77834, 39.38249], [-123.77831, 39.3829], [-123.77605, 39.38242], [-123.77616, 39.38388], [-123.77492, 39.38378], [-123.77493, 39.38348], [-123.77385, 39.38345], [-123.77379, 39.38208], [-123.77504, 39.38217], [-123.77449, 39.38175], [-123.77435, 39.38146], [-123.77341, 39.38151], [-123.77329, 39.38204], [-123.7726, 39.3819], [-123.77135, 39.38189], [-123.77148, 39.37831], [-123.77176, 39.37302], [-123.77029, 39.37301], [-123.76991, 39.37268], [-123.76908, 39.37281], [-123.76908, 39.3727], [-123.76849, 39.37269], [-123.7685, 39.37249], [-123.7709, 39.37243], [-123.77173, 39.37243], [-123.77179, 39.3717], [-123.77179, 39.37116], [-123.7711, 39.37115], [-123.77107, 39.37183], [-123.77092, 39.37187], [-123.77047, 39.37181], [-123.7705, 39.37115], [-123.77044, 39.36946], [-123.77164, 39.36945], [-123.7718, 39.37116], [-123.7739, 39.37126], [-123.77637, 39.37143], [-123.77618, 39.37867], [-123.78058, 39.37891], [-123.78058, 39.38049], [-123.78065, 39.3808]]], [[[-123.78522, 39.36825], [-123.78083, 39.36804], [-123.78062, 39.36458], [-123.78503, 39.36474], [-123.78518, 39.3664], [-123.78522, 39.36825]]], [[[-123.82222, 39.38018], [-123.82212, 39.38021], [-123.82191, 39.3802], [-123.82189, 39.38023], [-123.82184, 39.38018], [-123.82176, 39.38017], [-123.8217, 39.38021], [-123.8217, 39.38027], [-123.82175, 39.38039], [-123.82172, 39.38045], [-123.82167, 39.3805], [-123.8216, 39.38052], [-123.82156, 39.38056], [-123.82153, 39.3807], [-123.82154, 39.38085], [-123.82142, 39.38099], [-123.82138, 39.38103], [-123.8213, 39.38102], [-123.82107, 39.38105], [-123.82083, 39.38102], [-123.8207, 39.38093], [-123.82059, 39.38095], [-123.82028, 39.3809], [-123.82014, 39.3809], [-123.82007, 39.38093], [-123.8201, 39.38119], [-123.82016, 39.38126], [-123.82022, 39.3814], [-123.82027, 39.38145], [-123.82051, 39.38159], [-123.82063, 39.3817], [-123.82069, 39.38201], [-123.82062, 39.38208], [-123.82054, 39.38211], [-123.82045, 39.38205], [-123.82035, 39.38204], [-123.8202, 39.38201], [-123.81993, 39.3819], [-123.81981, 39.38191], [-123.81974, 39.38197], [-123.81978, 39.38201], [-123.81973, 39.38202], [-123.81658, 39.381], [-123.81587, 39.3824], [-123.82026, 39.38364], [-123.82017, 39.38376], [-123.82017, 39.38409], [-123.82011, 39.38417], [-123.82005, 39.38423], [-123.81997, 39.38427], [-123.81986, 39.38429], [-123.81975, 39.38425], [-123.81971, 39.3843], [-123.81959, 39.38429], [-123.81955, 39.38431], [-123.81954, 39.38434], [-123.81961, 39.38441], [-123.81994, 39.38456], [-123.81997, 39.3846], [-123.81996, 39.38464], [-123.81991, 39.38467], [-123.81974, 39.38466], [-123.81962, 39.38468], [-123.81957, 39.38474], [-123.81967, 39.38491], [-123.81992, 39.3851], [-123.82001, 39.38515], [-123.82025, 39.38519], [-123.82031, 39.38524], [-123.82048, 39.38532], [-123.82054, 39.38543], [-123.8206, 39.38548], [-123.82065, 39.38561], [-123.82067, 39.38575], [-123.8208, 39.38592], [-123.82106, 39.38606], [-123.8211, 39.38611], [-123.82107, 39.38613], [-123.82099, 39.38613], [-123.82066, 39.38606], [-123.82062, 39.38606], [-123.82056, 39.38599], [-123.82046, 39.38593], [-123.82041, 39.38595], [-123.82042, 39.38603], [-123.82037, 39.38609], [-123.82031, 39.38611], [-123.82025, 39.3861], [-123.82022, 39.38612], [-123.82021, 39.38616], [-123.81972, 39.38601], [-123.81946, 39.38601], [-123.81944, 39.38606], [-123.81946, 39.38612], [-123.81942, 39.38613], [-123.81941, 39.38617], [-123.81922, 39.38617], [-123.81911, 39.38613], [-123.81905, 39.38616], [-123.81897, 39.38613], [-123.81892, 39.38615], [-123.81877, 39.3864], [-123.81871, 39.38645], [-123.81861, 39.38648], [-123.81856, 39.38652], [-123.81821, 39.38645], [-123.81804, 39.387], [-123.81693, 39.38671], [-123.81705, 39.38638], [-123.81721, 39.38603], [-123.8173, 39.38579], [-123.8154, 39.38534], [-123.81369, 39.3849], [-123.81385, 39.38445], [-123.81401, 39.38441], [-123.81404, 39.38434], [-123.81395, 39.38423], [-123.81413, 39.38376], [-123.81419, 39.38349], [-123.81457, 39.38328], [-123.81423, 39.38314], [-123.8144, 39.3825], [-123.81462, 39.38208], [-123.81507, 39.38048], [-123.81532, 39.37975], [-123.81049, 39.37932], [-123.80851, 39.37919], [-123.80842, 39.37843], [-123.80765, 39.37834], [-123.80764, 39.37835], [-123.80766, 39.37911], [-123.80765, 39.3793], [-123.80512, 39.37927], [-123.80129, 39.37935], [-123.80195, 39.37728], [-123.8022, 39.37663], [-123.80263, 39.37588], [-123.80262, 39.37587], [-123.7997, 39.37583], [-123.79574, 39.37582], [-123.7934, 39.37584], [-123.79342, 39.37678], [-123.793, 39.37681], [-123.79288, 39.37814], [-123.79274, 39.37938], [-123.78995, 39.3794], [-123.79005, 39.37491], [-123.79014, 39.37216], [-123.78978, 39.36677], [-123.7901, 39.36659], [-123.79037, 39.36689], [-123.79075, 39.3671], [-123.79108, 39.3671], [-123.79121, 39.36746], [-123.79148, 39.3677], [-123.79197, 39.36776], [-123.79206, 39.36771], [-123.79211, 39.36761], [-123.79208, 39.36845], [-123.79368, 39.36849], [-123.79929, 39.3685], [-123.79904, 39.36984], [-123.79907, 39.37224], [-123.80504, 39.37231], [-123.80784, 39.37232], [-123.80775, 39.37441], [-123.80928, 39.37459], [-123.8102, 39.37429], [-123.81113, 39.37496], [-123.81217, 39.37536], [-123.8159, 39.37529], [-123.81591, 39.37586], [-123.81634, 39.37586], [-123.81634, 39.37529], [-123.81628, 39.37495], [-123.81627, 39.37449], [-123.81616, 39.37393], [-123.81544, 39.37237], [-123.81521, 39.37202], [-123.81598, 39.37205], [-123.81641, 39.37218], [-123.81668, 39.37219], [-123.81692, 39.3723], [-123.81606, 39.37224], [-123.81551, 39.37222], [-123.8155, 39.37223], [-123.81555, 39.37237], [-123.81707, 39.37248], [-123.81722, 39.37302], [-123.81794, 39.37356], [-123.81807, 39.3735], [-123.81836, 39.37356], [-123.81856, 39.37356], [-123.8188, 39.37351], [-123.81904, 39.37348], [-123.81904, 39.37361], [-123.81931, 39.37367], [-123.81949, 39.37377], [-123.81966, 39.37377], [-123.81996, 39.37395], [-123.82016, 39.37393], [-123.82012, 39.3741], [-123.82016, 39.37425], [-123.82016, 39.37435], [-123.8202, 39.37446], [-123.82028, 39.37453], [-123.82057, 39.3747], [-123.82064, 39.37489], [-123.82085, 39.37498], [-123.82099, 39.37508], [-123.82113, 39.37508], [-123.82126, 39.37512], [-123.82135, 39.37509], [-123.8214, 39.37514], [-123.82164, 39.37525], [-123.82174, 39.37536], [-123.82188, 39.37559], [-123.82211, 39.37578], [-123.82217, 39.37585], [-123.8222, 39.37595], [-123.822, 39.37594], [-123.82184, 39.37585], [-123.82181, 39.37579], [-123.82171, 39.37576], [-123.82167, 39.37572], [-123.82149, 39.37574], [-123.82142, 39.37579], [-123.82133, 39.37579], [-123.82117, 39.37576], [-123.82104, 39.37568], [-123.82085, 39.37561], [-123.82058, 39.37562], [-123.8202, 39.3757], [-123.82017, 39.37572], [-123.82001, 39.37575], [-123.81996, 39.37577], [-123.81978, 39.37596], [-123.81975, 39.37616], [-123.81978, 39.37629], [-123.81956, 39.37643], [-123.81942, 39.37642], [-123.81904, 39.37643], [-123.81883, 39.37648], [-123.81857, 39.37646], [-123.81843, 39.37653], [-123.81835, 39.37663], [-123.81829, 39.37676], [-123.81828, 39.37703], [-123.81814, 39.37704], [-123.818, 39.37704], [-123.8178, 39.37693], [-123.8177, 39.37684], [-123.81751, 39.37679], [-123.81745, 39.37675], [-123.81738, 39.37673], [-123.81729, 39.37673], [-123.81726, 39.37683], [-123.81731, 39.3769], [-123.8174, 39.37693], [-123.8175, 39.37702], [-123.81778, 39.37716], [-123.81788, 39.37725], [-123.8181, 39.37736], [-123.81834, 39.37743], [-123.81881, 39.37739], [-123.81899, 39.37734], [-123.8191, 39.37736], [-123.81915, 39.37745], [-123.81915, 39.37749], [-123.81909, 39.37758], [-123.81891, 39.37795], [-123.81887, 39.378], [-123.81887, 39.37818], [-123.81891, 39.37827], [-123.81901, 39.37833], [-123.81906, 39.37835], [-123.81912, 39.37839], [-123.81924, 39.37843], [-123.81934, 39.3785], [-123.81953, 39.3787], [-123.81972, 39.37868], [-123.8198, 39.37874], [-123.81989, 39.37878], [-123.81998, 39.37874], [-123.82007, 39.37863], [-123.82018, 39.37854], [-123.82028, 39.37848], [-123.82055, 39.37842], [-123.82063, 39.37844], [-123.82073, 39.37852], [-123.82084, 39.37857], [-123.82089, 39.37864], [-123.82091, 39.37871], [-123.82091, 39.37878], [-123.82087, 39.37886], [-123.82073, 39.37895], [-123.82073, 39.37902], [-123.82098, 39.37909], [-123.8211, 39.37915], [-123.82116, 39.37922], [-123.82124, 39.37924], [-123.82131, 39.37921], [-123.82137, 39.37915], [-123.82152, 39.37912], [-123.82159, 39.37912], [-123.82175, 39.37919], [-123.82179, 39.37942], [-123.82194, 39.37947], [-123.82195, 39.37951], [-123.8219, 39.3796], [-123.82195, 39.37964], [-123.82201, 39.3796], [-123.82206, 39.37961], [-123.82208, 39.37963], [-123.82204, 39.3797], [-123.82217, 39.37977], [-123.82224, 39.37988], [-123.82226, 39.38], [-123.82222, 39.38018]], [[-123.81623, 39.37681], [-123.81622, 39.37679], [-123.8159, 39.37673], [-123.81589, 39.37674], [-123.81619, 39.37691], [-123.81623, 39.37681]]], [[[-123.82052, 39.39172], [-123.82045, 39.39178], [-123.82028, 39.3918], [-123.82016, 39.39179], [-123.82009, 39.39175], [-123.82002, 39.39174], [-123.81994, 39.39173], [-123.81989, 39.39177], [-123.81972, 39.39177], [-123.81961, 39.39183], [-123.81959, 39.39188], [-123.8196, 39.392], [-123.81955, 39.392], [-123.81931, 39.39194], [-123.81925, 39.39189], [-123.81917, 39.39186], [-123.81908, 39.39176], [-123.81863, 39.39154], [-123.81617, 39.39123], [-123.81538, 39.39114], [-123.81536, 39.39012], [-123.81537, 39.38977], [-123.81505, 39.38928], [-123.81274, 39.38894], [-123.81262, 39.38863], [-123.81319, 39.38871], [-123.8131, 39.38815], [-123.81315, 39.38787], [-123.81369, 39.38684], [-123.81403, 39.38685], [-123.81427, 39.38687], [-123.81445, 39.38694], [-123.81476, 39.38688], [-123.81494, 39.3869], [-123.81506, 39.38694], [-123.81522, 39.38693], [-123.81542, 39.38697], [-123.81581, 39.38712], [-123.81609, 39.38738], [-123.81657, 39.3875], [-123.81684, 39.38746], [-123.81701, 39.38749], [-123.81737, 39.3877], [-123.81736, 39.38773], [-123.81738, 39.38778], [-123.81743, 39.38787], [-123.81749, 39.38805], [-123.81754, 39.3881], [-123.81769, 39.3884], [-123.8178, 39.38857], [-123.81791, 39.38867], [-123.81801, 39.38873], [-123.8181, 39.38883], [-123.81821, 39.38885], [-123.8183, 39.38884], [-123.81843, 39.3888], [-123.81849, 39.3888], [-123.81852, 39.3888], [-123.81863, 39.38889], [-123.81879, 39.3889], [-123.81903, 39.38896], [-123.81909, 39.38898], [-123.8192, 39.38907], [-123.8193, 39.38909], [-123.81938, 39.38914], [-123.81954, 39.38932], [-123.81956, 39.38936], [-123.81944, 39.38941], [-123.81925, 39.3894], [-123.81906, 39.38932], [-123.81894, 39.38929], [-123.81861, 39.38914], [-123.81824, 39.38907], [-123.81817, 39.38914], [-123.81818, 39.38919], [-123.81817, 39.38923], [-123.81822, 39.38928], [-123.81823, 39.38932], [-123.81817, 39.38943], [-123.81795, 39.38955], [-123.81792, 39.38965], [-123.81793, 39.38976], [-123.81801, 39.38987], [-123.81809, 39.38994], [-123.81824, 39.39], [-123.81829, 39.39007], [-123.81821, 39.39018], [-123.81823, 39.39025], [-123.81835, 39.39027], [-123.81846, 39.39039], [-123.81854, 39.39041], [-123.81859, 39.3903], [-123.81875, 39.39036], [-123.81891, 39.39039], [-123.81904, 39.39047], [-123.81922, 39.39055], [-123.81944, 39.39062], [-123.81949, 39.39078], [-123.8196, 39.39088], [-123.81967, 39.39099], [-123.81977, 39.3911], [-123.81993, 39.39116], [-123.82003, 39.39124], [-123.82018, 39.39137], [-123.82021, 39.39145], [-123.82027, 39.39156], [-123.82043, 39.39166], [-123.8205, 39.39168], [-123.82052, 39.39172]]], [[[-123.82051, 39.37236], [-123.82051, 39.37243], [-123.82027, 39.37255], [-123.82018, 39.37258], [-123.81884, 39.37196], [-123.81894, 39.37171], [-123.82051, 39.37236]]]]} | Open Access 1 | 20491 | Jug Handle State Natural Reserve | 31545 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=441 | Mendocino 24 | 775.877 | Jug Handle SNR | 1976 | State Conservation Area 8 | 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]);