units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 25 and PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Jacinto-WA"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7991 | 7991 | 7990 | {"type": "MultiPolygon", "coordinates": [[[[-117.1563, 33.83729], [-117.15629, 33.83862], [-117.156, 33.83863], [-117.15549, 33.83867], [-117.15459, 33.83879], [-117.15421, 33.83877], [-117.1546, 33.83853], [-117.15499, 33.83826], [-117.1563, 33.83729]]], [[[-117.06834, 33.85545], [-117.0682, 33.85554], [-117.06783, 33.85493], [-117.06716, 33.85438], [-117.06624, 33.85408], [-117.06615, 33.85403], [-117.06683, 33.85285], [-117.06593, 33.85173], [-117.0646, 33.85133], [-117.0645, 33.85126], [-117.0642, 33.85065], [-117.06364, 33.85047], [-117.06302, 33.85011], [-117.06254, 33.85019], [-117.06246, 33.85018], [-117.06179, 33.84991], [-117.06088, 33.84989], [-117.06081, 33.84987], [-117.05992, 33.84934], [-117.05995, 33.84914], [-117.06009, 33.84928], [-117.0609, 33.84975], [-117.06183, 33.84977], [-117.06252, 33.85006], [-117.06305, 33.84997], [-117.06373, 33.85035], [-117.06433, 33.85054], [-117.06465, 33.8512], [-117.06603, 33.85162], [-117.06707, 33.85287], [-117.06635, 33.85398], [-117.06725, 33.85426], [-117.06797, 33.85485], [-117.06834, 33.85545]]], [[[-117.20405, 33.85731], [-117.20406, 33.8575], [-117.2038, 33.85877], [-117.20365, 33.85905], [-117.2025, 33.86005], [-117.20099, 33.86076], [-117.19718, 33.86139], [-117.19679, 33.85893], [-117.19652, 33.85785], [-117.19578, 33.85574], [-117.19494, 33.85366], [-117.19429, 33.85162], [-117.19216, 33.84908], [-117.18903, 33.84648], [-117.18329, 33.84201], [-117.17884, 33.83882], [-117.17887, 33.83865], [-117.18053, 33.83752], [-117.18034, 33.83751], [-117.18086, 33.83728], [-117.18086, 33.83727], [-117.17374, 33.83736], [-117.17373, 33.83753], [-117.16501, 33.8376], [-117.16192, 33.8402], [-117.16156, 33.84004], [-117.16118, 33.83989], [-117.15976, 33.83943], [-117.15938, 33.83934], [-117.15903, 33.83922], [-117.16061, 33.83764], [-117.16938, 33.83358], [-117.16938, 33.83195], [-117.1737, 33.8323], [-117.18136, 33.83298], [-117.18983, 33.8415], [-117.19038, 33.84207], [-117.19027, 33.84216], [-117.19027, 33.84218], [-117.1904, 33.84229], [-117.19052, 33.8422], [-117.19142, 33.84281], [-117.19143, 33.84386], [-117.19261, 33.84454], [-117.1931, 33.84377], [-117.19352, 33.84395], [-117.19398, 33.84413], [-117.19445, 33.84428], [-117.19492, 33.84442], [-117.19541, 33.84453], [-117.1959, 33.84462], [-117.1964, 33.84469], [-117.1969, 33.84474], [-117.19692, 33.84652], [-117.19969, 33.84745], [-117.2003, 33.84802], [-117.20035, 33.84924], [-117.20032, 33.85023], [-117.20047, 33.8518], [-117.20322, 33.85575], [-117.20335, 33.85597], [-117.20402, 33.8573], [-117.20405, 33.85731]]], [[[-117.0742, 33.8613], [-117.0685, 33.86454], [-117.06494, 33.86016], [-117.06354, 33.85847], [-117.068, 33.85583], [-117.06824, 33.85596], [-117.06812, 33.8562], [-117.06909, 33.85732], [-117.0695, 33.85747], [-117.06947, 33.85768], [-117.06912, 33.85853], [-117.07061, 33.86021], [-117.07203, 33.86068], [-117.0724, 33.86119], [-117.0742, 33.8613]]], [[[-117.06835, 33.86461], [-117.06308, 33.86761], [-117.05822, 33.86162], [-117.06338, 33.85856], [-117.06472, 33.86016], [-117.06835, 33.86461]]], [[[-117.09475, 33.86013], [-117.09461, 33.87098], [-117.08815, 33.87102], [-117.08607, 33.86742], [-117.08607, 33.8673], [-117.08497, 33.86555], [-117.08336, 33.86617], [-117.08027, 33.86118], [-117.08185, 33.86042], [-117.08177, 33.86027], [-117.08608, 33.86024], [-117.09475, 33.86013]]], [[[-117.06254, 33.8672], [-117.05987, 33.86874], [-117.06023, 33.86921], [-117.05759, 33.8707], [-117.05278, 33.86482], [-117.05808, 33.8617], [-117.06254, 33.8672]]], [[[-117.0869, 33.87293], [-117.08687, 33.87299], [-117.0868, 33.87419], [-117.08599, 33.87466], [-117.08501, 33.87462], [-117.08403, 33.87544], [-117.08384, 33.87531], [-117.08463, 33.87464], [-117.08641, 33.8732], [-117.0866, 33.87311], [-117.08667, 33.87284], [-117.08615, 33.87157], [-117.08593, 33.87119], [-117.08432, 33.86924], [-117.08405, 33.86899], [-117.0839, 33.86905], [-117.08127, 33.87052], [-117.07886, 33.86757], [-117.08077, 33.8665], [-117.08078, 33.86648], [-117.08066, 33.86639], [-117.07878, 33.86745], [-117.07399, 33.86158], [-117.07439, 33.86134], [-117.07439, 33.86133], [-117.07418, 33.86116], [-117.07249, 33.86106], [-117.07214, 33.86057], [-117.07072, 33.8601], [-117.0693, 33.85851], [-117.06963, 33.8577], [-117.06966, 33.85739], [-117.06919, 33.85721], [-117.0683, 33.85618], [-117.06843, 33.85591], [-117.06814, 33.85574], [-117.06828, 33.85566], [-117.06862, 33.85587], [-117.06848, 33.85617], [-117.0693, 33.8571], [-117.06983, 33.8573], [-117.06978, 33.85776], [-117.06948, 33.85849], [-117.07082, 33.85999], [-117.07128, 33.85999], [-117.07236, 33.86035], [-117.07269, 33.8608], [-117.07433, 33.8609], [-117.07619, 33.86237], [-117.07732, 33.86304], [-117.0789, 33.86451], [-117.07951, 33.86473], [-117.07992, 33.86533], [-117.08155, 33.86676], [-117.08255, 33.86744], [-117.08444, 33.86913], [-117.08607, 33.87113], [-117.08628, 33.87145], [-117.0869, 33.87293]]], [[[-117.05743, 33.87078], [-117.05075, 33.87458], [-117.04773, 33.87191], [-117.04711, 33.87144], [-117.04486, 33.8697], [-117.04483, 33.86959], [-117.04724, 33.86809], [-117.05262, 33.86491], [-117.05743, 33.87078]]], [[[-116.99959, 33.87495], [-116.99959, 33.87495], [-116.99272, 33.87503], [-116.99323, 33.87413], [-116.9935, 33.87382], [-116.9944, 33.87267], [-116.99572, 33.87142], [-116.99938, 33.8696], [-116.99959, 33.87495]]], [[[-117.00735, 33.8603], [-117.00085, 33.86036], [-116.99846, 33.86033], [-116.99894, 33.86725], [-116.99896, 33.86726], [-116.99907, 33.86884], [-116.99475, 33.87092], [-116.99406, 33.87172], [-116.99323, 33.87263], [-116.99241, 33.8739], [-116.992, 33.8749], [-116.98639, 33.8749], [-116.98634, 33.88152], [-116.98204, 33.88168], [-116.9819, 33.88871], [-116.958, 33.88917], [-116.95799, 33.87496], [-116.94882, 33.87496], [-116.94894, 33.88915], [-116.94065, 33.88912], [-116.92916, 33.88928], [-116.92916, 33.88606], [-116.92431, 33.88614], [-116.9116, 33.88629], [-116.91153, 33.88152], [-116.91364, 33.88132], [-116.91363, 33.88067], [-116.91498, 33.88058], [-116.91485, 33.87952], [-116.91699, 33.87948], [-116.91704, 33.87869], [-116.92427, 33.87863], [-116.92429, 33.86565], [-116.91991, 33.86541], [-116.91978, 33.85668], [-116.9243, 33.85666], [-116.92458, 33.85271], [-116.93274, 33.85278], [-116.93275, 33.85283], [-116.93324, 33.85284], [-116.93326, 33.85278], [-116.94081, 33.85284], [-116.9408, 33.84544], [-116.94573, 33.84543], [-116.94577, 33.83093], [-116.98083, 33.8309], [-116.98086, 33.83845], [-116.99159, 33.83856], [-116.9953, 33.84222], [-116.99666, 33.84337], [-116.99857, 33.84412], [-117.00075, 33.84523], [-117.00242, 33.84668], [-117.00392, 33.84828], [-117.00599, 33.85], [-117.00708, 33.8516], [-117.00735, 33.8603]], [[-116.95424, 33.86087], [-116.96002, 33.86084], [-116.96245, 33.85789], [-116.96195, 33.8572], [-116.96025, 33.85675], [-116.95761, 33.85676], [-116.95707, 33.85693], [-116.95537, 33.8577], [-116.95515, 33.85776], [-116.95245, 33.85954], [-116.95138, 33.86019], [-116.95082, 33.86047], [-116.95011, 33.86074], [-116.94886, 33.86096], [-116.94819, 33.86101], [-116.94761, 33.861], [-116.94665, 33.86071], [-116.9457, 33.86004], [-116.94518, 33.85941], [-116.94514, 33.85933], [-116.94175, 33.85776], [-116.93993, 33.85687], [-116.938, 33.8568], [-116.93754, 33.85676], [-116.93689, 33.85655], [-116.93627, 33.85637], [-116.93414, 33.85559], [-116.93299, 33.85471], [-116.93298, 33.85467], [-116.93233, 33.85474], [-116.93231, 33.85479], [-116.92958, 33.8552], [-116.92907, 33.85541], [-116.9254, 33.85676], [-116.92549, 33.85799], [-116.92581, 33.85876], [-116.93245, 33.86744], [-116.93398, 33.86882], [-116.93517, 33.8693], [-116.93837, 33.86897], [-116.94424, 33.86628], [-116.94518, 33.86537], [-116.94866, 33.86478], [-116.95424, 33.86087]]], [[[-117.08832, 33.90461], [-117.08773, 33.90415], [-117.08773, 33.90415], [-117.08805, 33.90415], [-117.08819, 33.90442], [-117.08832, 33.90461]]], [[[-117.12096, 33.90659], [-117.11678, 33.90661], [-117.11677, 33.91094], [-117.10357, 33.91106], [-117.09705, 33.91116], [-117.09678, 33.91117], [-117.09651, 33.9112], [-117.09624, 33.91126], [-117.09598, 33.91133], [-117.09551, 33.91154], [-117.09532, 33.91152], [-117.09231, 33.90778], [-117.09236, 33.90765], [-117.09339, 33.90711], [-117.09362, 33.90702], [-117.09386, 33.90695], [-117.0941, 33.9069], [-117.09436, 33.90687], [-117.10202, 33.9068], [-117.10233, 33.90684], [-117.10244, 33.90681], [-117.10252, 33.90675], [-117.10255, 33.90666], [-117.1025, 33.90646], [-117.10248, 33.90366], [-117.10249, 33.90331], [-117.10257, 33.90326], [-117.12086, 33.9032], [-117.12095, 33.90326], [-117.12096, 33.90659]]], [[[-117.15795, 33.83978], [-117.15374, 33.84436], [-117.15349, 33.84512], [-117.15337, 33.84523], [-117.15153, 33.85099], [-117.14801, 33.8537], [-117.13878, 33.86045], [-117.13855, 33.86702], [-117.13017, 33.87373], [-117.1299, 33.88164], [-117.1348, 33.88996], [-117.13663, 33.89569], [-117.13367, 33.90293], [-117.13455, 33.90497], [-117.13158, 33.90747], [-117.13196, 33.90811], [-117.13287, 33.90768], [-117.13319, 33.90869], [-117.13648, 33.91045], [-117.13704, 33.91021], [-117.13744, 33.91019], [-117.13816, 33.91018], [-117.13851, 33.91059], [-117.13994, 33.91118], [-117.13981, 33.91292], [-117.1375, 33.9122], [-117.13383, 33.91004], [-117.13346, 33.90979], [-117.13314, 33.91014], [-117.13294, 33.9103], [-117.13273, 33.91045], [-117.13249, 33.91057], [-117.13224, 33.91067], [-117.13198, 33.91075], [-117.13171, 33.91081], [-117.1313, 33.91085], [-117.12641, 33.91087], [-117.12641, 33.90658], [-117.12125, 33.90659], [-117.12123, 33.90326], [-117.12134, 33.9032], [-117.12993, 33.90314], [-117.12999, 33.90318], [-117.13, 33.90317], [-117.12999, 33.90292], [-117.12993, 33.90298], [-117.12133, 33.90303], [-117.12122, 33.90292], [-117.12119, 33.89118], [-117.1234, 33.88922], [-117.12946, 33.88932], [-117.12955, 33.89433], [-117.12961, 33.8954], [-117.12963, 33.8954], [-117.12972, 33.88571], [-117.12822, 33.88493], [-117.12501, 33.8789], [-117.12499, 33.87891], [-117.12495, 33.88181], [-117.12105, 33.88184], [-117.12106, 33.88914], [-117.12109, 33.90261], [-117.12095, 33.90261], [-117.12094, 33.90293], [-117.12084, 33.90303], [-117.11976, 33.90304], [-117.11975, 33.90313], [-117.10357, 33.90318], [-117.10356, 33.90314], [-117.10234, 33.90313], [-117.10228, 33.89854], [-117.10227, 33.89853], [-117.10215, 33.89861], [-117.10222, 33.90366], [-117.10224, 33.9065], [-117.10217, 33.90659], [-117.09459, 33.90666], [-117.09432, 33.90668], [-117.09378, 33.90677], [-117.09352, 33.90684], [-117.09327, 33.90693], [-117.09303, 33.90704], [-117.09222, 33.90749], [-117.09209, 33.90749], [-117.0917, 33.90709], [-117.08912, 33.90501], [-117.08896, 33.90486], [-117.08871, 33.90452], [-117.08861, 33.90433], [-117.08853, 33.90414], [-117.09467, 33.90408], [-117.09468, 33.90368], [-117.09479, 33.90359], [-117.09479, 33.90358], [-117.08837, 33.9037], [-117.08829, 33.90345], [-117.08816, 33.90318], [-117.08802, 33.90296], [-117.08776, 33.90265], [-117.08397, 33.89865], [-117.08377, 33.89873], [-117.08303, 33.89795], [-117.0821, 33.89638], [-117.08237, 33.89626], [-117.08219, 33.89589], [-117.08204, 33.89551], [-117.08195, 33.89526], [-117.08167, 33.89427], [-117.08146, 33.8938], [-117.08133, 33.89356], [-117.08109, 33.89375], [-117.08066, 33.89323], [-117.08029, 33.89293], [-117.08041, 33.8928], [-117.08045, 33.89273], [-117.07802, 33.8911], [-117.07747, 33.89077], [-117.07739, 33.89083], [-117.07704, 33.89069], [-117.07665, 33.89058], [-117.07519, 33.89022], [-117.07437, 33.89008], [-117.07178, 33.8897], [-117.07138, 33.88961], [-117.0705, 33.88924], [-117.07065, 33.88901], [-117.07105, 33.87877], [-117.07031, 33.87867], [-117.07029, 33.87806], [-117.06919, 33.87783], [-117.06782, 33.87738], [-117.06731, 33.87754], [-117.06666, 33.87744], [-117.06378, 33.87749], [-117.06243, 33.87774], [-117.06144, 33.87774], [-117.05967, 33.8776], [-117.05966, 33.87782], [-117.0596, 33.87782], [-117.05855, 33.8783], [-117.05592, 33.87824], [-117.05523, 33.87743], [-117.05466, 33.8771], [-117.05468, 33.87502], [-117.05481, 33.87498], [-117.05483, 33.87486], [-117.05455, 33.87493], [-117.05451, 33.87716], [-117.05509, 33.8775], [-117.05582, 33.87838], [-117.05861, 33.87844], [-117.05964, 33.87796], [-117.06318, 33.87789], [-117.06424, 33.87765], [-117.06429, 33.88545], [-117.0641, 33.88546], [-117.05801, 33.88067], [-117.05771, 33.88037], [-117.05664, 33.87914], [-117.05643, 33.87894], [-117.05092, 33.8748], [-117.05103, 33.87457], [-117.05751, 33.87089], [-117.05874, 33.87239], [-117.05892, 33.87237], [-117.05893, 33.87235], [-117.05766, 33.87081], [-117.06302, 33.86778], [-117.06401, 33.86899], [-117.06415, 33.86894], [-117.06416, 33.86892], [-117.06316, 33.8677], [-117.06843, 33.86471], [-117.0727, 33.86992], [-117.07297, 33.87005], [-117.07297, 33.87003], [-117.06858, 33.86463], [-117.07384, 33.86166], [-117.07863, 33.86753], [-117.07364, 33.87037], [-117.07363, 33.87038], [-117.07377, 33.87045], [-117.07873, 33.86765], [-117.08113, 33.8706], [-117.07903, 33.87179], [-117.07837, 33.87158], [-117.07526, 33.87125], [-117.07525, 33.87127], [-117.076, 33.87168], [-117.07718, 33.8718], [-117.07761, 33.87194], [-117.07835, 33.87169], [-117.07925, 33.87198], [-117.0798, 33.87314], [-117.08204, 33.87432], [-117.08288, 33.87483], [-117.08304, 33.87491], [-117.08402, 33.87564], [-117.08758, 33.87811], [-117.08956, 33.87821], [-117.09094, 33.8765], [-117.09233, 33.87664], [-117.10106, 33.88338], [-117.10173, 33.88218], [-117.10588, 33.87746], [-117.10682, 33.87666], [-117.11351, 33.87244], [-117.11469, 33.87105], [-117.11663, 33.87073], [-117.11849, 33.87156], [-117.11926, 33.8713], [-117.12039, 33.87071], [-117.12108, 33.87072], [-117.12106, 33.86984], [-117.12114, 33.8693], [-117.11617, 33.87017], [-117.11659, 33.86913], [-117.11658, 33.86912], [-117.11369, 33.87052], [-117.11149, 33.8693], [-117.10978, 33.86967], [-117.10902, 33.87008], [-117.10827, 33.87042], [-117.10714, 33.87035], [-117.10676, 33.87037], [-117.10689, 33.87028], [-117.1069, 33.87027], [-117.10571, 33.8699], [-117.10073, 33.86684], [-117.09582, 33.87115], [-117.09487, 33.87115], [-117.09485, 33.86048], [-117.10832, 33.85564], [-117.10862, 33.84534], [-117.12076, 33.8452], [-117.12096, 33.84566], [-117.12087, 33.85182], [-117.12088, 33.85183], [-117.12444, 33.85047], [-117.12585, 33.84926], [-117.12975, 33.84571], [-117.12973, 33.8457], [-117.12356, 33.85043], [-117.12122, 33.8513], [-117.1212, 33.84616], [-117.12118, 33.84593], [-117.12114, 33.84564], [-117.12108, 33.84535], [-117.12101, 33.84512], [-117.12681, 33.84507], [-117.12393, 33.84204], [-117.13424, 33.84225], [-117.14016, 33.84174], [-117.1442, 33.84117], [-117.14656, 33.84075], [-117.14895, 33.84048], [-117.15027, 33.84016], [-117.15115, 33.84], [-117.15385, 33.83956], [-117.15511, 33.83959], [-117.15627, 33.83959], [-117.15747, 33.8397], [-117.15795, 33.83978]], [[-117.12996, 33.84524], [-117.12995, 33.84525], [-117.12996, 33.84552], [-117.13024, 33.84526], [-117.12996, 33.84524]], [[-117.09942, 33.88651], [-117.09943, 33.88653], [-117.09965, 33.88635], [-117.09966, 33.88633], [-117.09942, 33.88651]]]]} | Open Access 1 | 10956 | San Jacinto Wildlife Area | 30498 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Jacinto-WA | Riverside 10 | 18353.002 | San Jacinto Wildlife Area | 1982 | 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]);