units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 8 and YR_EST = 2001
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16725 | 16725 | 16724 | {"type": "MultiPolygon", "coordinates": [[[[-116.8234, 32.66794], [-116.82272, 32.66769], [-116.8225, 32.66759], [-116.82242, 32.66755], [-116.82217, 32.66737], [-116.82204, 32.66723], [-116.82224, 32.66731], [-116.82286, 32.66749], [-116.82307, 32.66759], [-116.82324, 32.66773], [-116.82337, 32.66788], [-116.8234, 32.66794]]], [[[-116.82644, 32.67056], [-116.82623, 32.67054], [-116.82594, 32.67046], [-116.8257, 32.67032], [-116.82555, 32.67019], [-116.82552, 32.67015], [-116.82569, 32.67027], [-116.82591, 32.67038], [-116.82622, 32.6705], [-116.82644, 32.67056]]], [[[-116.82519, 32.66985], [-116.82454, 32.67018], [-116.82431, 32.67027], [-116.824, 32.67035], [-116.82374, 32.67039], [-116.82338, 32.6704], [-116.82295, 32.67034], [-116.82263, 32.67025], [-116.8224, 32.67016], [-116.82021, 32.66892], [-116.81982, 32.66873], [-116.81951, 32.66862], [-116.81706, 32.66787], [-116.81664, 32.66777], [-116.81628, 32.66773], [-116.81604, 32.66772], [-116.81566, 32.66773], [-116.81529, 32.66777], [-116.81505, 32.66782], [-116.81471, 32.66792], [-116.8143, 32.6681], [-116.81387, 32.66835], [-116.81349, 32.66866], [-116.8133, 32.66887], [-116.81307, 32.66917], [-116.81212, 32.67091], [-116.81179, 32.67146], [-116.81154, 32.67177], [-116.81141, 32.6719], [-116.8112, 32.67208], [-116.81098, 32.67223], [-116.81077, 32.67235], [-116.81037, 32.67253], [-116.80998, 32.67265], [-116.80967, 32.67271], [-116.80944, 32.67274], [-116.80764, 32.67285], [-116.80716, 32.67284], [-116.80687, 32.67281], [-116.80646, 32.67275], [-116.80619, 32.67268], [-116.80564, 32.67251], [-116.80524, 32.67234], [-116.80493, 32.67218], [-116.80448, 32.6719], [-116.80422, 32.67171], [-116.7972, 32.66593], [-116.80495, 32.66579], [-116.80484, 32.65407], [-116.80647, 32.65459], [-116.80676, 32.65472], [-116.80698, 32.65489], [-116.80711, 32.655], [-116.80725, 32.65517], [-116.80731, 32.65528], [-116.80855, 32.65787], [-116.80876, 32.65819], [-116.80899, 32.65844], [-116.81141, 32.66069], [-116.81156, 32.66086], [-116.81157, 32.66087], [-116.81164, 32.66095], [-116.81164, 32.66096], [-116.8118, 32.66115], [-116.81275, 32.66268], [-116.81287, 32.66281], [-116.81341, 32.66317], [-116.81338, 32.66321], [-116.81451, 32.66403], [-116.81505, 32.66424], [-116.81542, 32.66434], [-116.81569, 32.6644], [-116.81625, 32.66446], [-116.81678, 32.66446], [-116.81827, 32.66429], [-116.81855, 32.66425], [-116.81904, 32.66423], [-116.81956, 32.66428], [-116.81993, 32.66435], [-116.8201, 32.6644], [-116.82012, 32.66436], [-116.82027, 32.66441], [-116.82095, 32.66493], [-116.82107, 32.66505], [-116.82119, 32.66523], [-116.8213, 32.66547], [-116.82164, 32.6668], [-116.82177, 32.66708], [-116.82192, 32.66727], [-116.82217, 32.66752], [-116.82247, 32.66771], [-116.82345, 32.66809], [-116.82366, 32.6682], [-116.82391, 32.66836], [-116.8241, 32.66852], [-116.82426, 32.66869], [-116.82519, 32.66985]]], [[[-116.78798, 32.66539], [-116.78798, 32.66542], [-116.78796, 32.66543], [-116.78747, 32.66558], [-116.78694, 32.66581], [-116.78643, 32.66611], [-116.78608, 32.66636], [-116.7859, 32.66651], [-116.78557, 32.66684], [-116.78413, 32.66865], [-116.78391, 32.66888], [-116.7839, 32.6689], [-116.78371, 32.66909], [-116.78047, 32.67193], [-116.78014, 32.67215], [-116.77985, 32.6723], [-116.77954, 32.67243], [-116.77929, 32.67251], [-116.77886, 32.6726], [-116.77864, 32.67263], [-116.77806, 32.67264], [-116.77761, 32.67258], [-116.77724, 32.67249], [-116.77645, 32.67171], [-116.77636, 32.67152], [-116.77601, 32.67039], [-116.77589, 32.67028], [-116.77583, 32.67024], [-116.77574, 32.67014], [-116.77568, 32.67002], [-116.7756, 32.66981], [-116.77553, 32.66968], [-116.77511, 32.66925], [-116.77491, 32.66893], [-116.78015, 32.66896], [-116.77965, 32.65689], [-116.78797, 32.65701], [-116.78798, 32.66148], [-116.78558, 32.66146], [-116.78557, 32.66147], [-116.78583, 32.66536], [-116.78798, 32.66539]]], [[[-116.85638, 32.70082], [-116.85655, 32.69777], [-116.85353, 32.69774], [-116.85357, 32.69771], [-116.85367, 32.69771], [-116.85373, 32.69766], [-116.85374, 32.69763], [-116.85378, 32.6976], [-116.85385, 32.69757], [-116.8553, 32.69721], [-116.85718, 32.69657], [-116.8573, 32.69651], [-116.85743, 32.69643], [-116.85745, 32.69643], [-116.85762, 32.6963], [-116.85888, 32.69513], [-116.85892, 32.69512], [-116.85899, 32.69512], [-116.86034, 32.69649], [-116.86049, 32.69661], [-116.8605, 32.69664], [-116.86214, 32.69832], [-116.86251, 32.69867], [-116.86258, 32.69875], [-116.8672, 32.70348], [-116.86715, 32.70345], [-116.8564, 32.70324], [-116.85638, 32.70082]]], [[[-116.85879, 32.69494], [-116.85878, 32.69498], [-116.85745, 32.69621], [-116.8572, 32.69637], [-116.85709, 32.69642], [-116.85528, 32.69704], [-116.85389, 32.69739], [-116.85367, 32.69746], [-116.85353, 32.69747], [-116.85347, 32.69756], [-116.85326, 32.69774], [-116.82221, 32.69751], [-116.82221, 32.6986], [-116.82223, 32.70109], [-116.83054, 32.70109], [-116.83061, 32.71182], [-116.82474, 32.71172], [-116.82473, 32.71171], [-116.82226, 32.71167], [-116.82224, 32.71159], [-116.81567, 32.71163], [-116.81555, 32.71149], [-116.81552, 32.71142], [-116.81547, 32.71108], [-116.81543, 32.71097], [-116.81445, 32.7098], [-116.81451, 32.70975], [-116.81456, 32.70966], [-116.81456, 32.70959], [-116.81452, 32.70952], [-116.81412, 32.70934], [-116.81385, 32.70926], [-116.81371, 32.70917], [-116.8129, 32.71164], [-116.81197, 32.71164], [-116.81199, 32.7081], [-116.80781, 32.70811], [-116.80787, 32.70446], [-116.80054, 32.7045], [-116.80053, 32.70451], [-116.80034, 32.70448], [-116.80033, 32.7045], [-116.79497, 32.70459], [-116.79499, 32.70112], [-116.79086, 32.7012], [-116.79089, 32.70466], [-116.78839, 32.7047], [-116.78832, 32.70462], [-116.78822, 32.70456], [-116.78798, 32.70449], [-116.78772, 32.70437], [-116.78741, 32.70396], [-116.78711, 32.70376], [-116.78702, 32.70373], [-116.78684, 32.70352], [-116.78672, 32.70343], [-116.78655, 32.70335], [-116.78646, 32.70325], [-116.78641, 32.70314], [-116.78289, 32.70317], [-116.78289, 32.7013], [-116.77532, 32.70138], [-116.77528, 32.694], [-116.77612, 32.68793], [-116.77618, 32.68684], [-116.77616, 32.68336], [-116.78066, 32.68329], [-116.78067, 32.68328], [-116.77631, 32.68322], [-116.7763, 32.68332], [-116.77197, 32.68321], [-116.77194, 32.67613], [-116.78046, 32.67613], [-116.78028, 32.67227], [-116.78069, 32.67197], [-116.78397, 32.66909], [-116.78431, 32.66872], [-116.78431, 32.6687], [-116.78558, 32.66711], [-116.78565, 32.66704], [-116.78566, 32.66702], [-116.78592, 32.66674], [-116.78619, 32.66651], [-116.78652, 32.66626], [-116.78676, 32.66611], [-116.78718, 32.66589], [-116.78747, 32.66576], [-116.7878, 32.66564], [-116.78832, 32.66551], [-116.7886, 32.66546], [-116.78907, 32.6654], [-116.78973, 32.66539], [-116.79083, 32.66548], [-116.7913, 32.6655], [-116.79285, 32.66546], [-116.79297, 32.66915], [-116.7944, 32.66913], [-116.79441, 32.66954], [-116.79775, 32.66946], [-116.79766, 32.66654], [-116.8007, 32.66904], [-116.80405, 32.67181], [-116.80438, 32.67206], [-116.80468, 32.67225], [-116.80497, 32.6724], [-116.8055, 32.67264], [-116.80575, 32.67273], [-116.80626, 32.67287], [-116.80684, 32.67297], [-116.80727, 32.67301], [-116.80772, 32.67301], [-116.80964, 32.67289], [-116.81002, 32.67281], [-116.81028, 32.67274], [-116.81064, 32.67261], [-116.81096, 32.67244], [-116.81127, 32.67224], [-116.81155, 32.67201], [-116.81177, 32.67178], [-116.81194, 32.67157], [-116.81229, 32.67099], [-116.81322, 32.66929], [-116.81347, 32.66895], [-116.81362, 32.6688], [-116.81363, 32.66878], [-116.81384, 32.66859], [-116.81401, 32.66846], [-116.81419, 32.66835], [-116.81447, 32.6682], [-116.81476, 32.66809], [-116.81505, 32.668], [-116.81539, 32.66792], [-116.8157, 32.66789], [-116.81607, 32.66788], [-116.81635, 32.6679], [-116.81686, 32.66799], [-116.81945, 32.66877], [-116.81988, 32.66894], [-116.82006, 32.66903], [-116.82222, 32.67026], [-116.82258, 32.67041], [-116.82296, 32.67051], [-116.82333, 32.67056], [-116.82367, 32.67056], [-116.82412, 32.6705], [-116.82438, 32.67043], [-116.82462, 32.67034], [-116.82531, 32.66998], [-116.82537, 32.67009], [-116.82548, 32.67026], [-116.82571, 32.67045], [-116.82594, 32.67056], [-116.82612, 32.67062], [-116.82628, 32.67065], [-116.8266, 32.67065], [-116.82682, 32.6706], [-116.82847, 32.67059], [-116.82849, 32.67067], [-116.82946, 32.67065], [-116.82984, 32.67067], [-116.83051, 32.67074], [-116.83112, 32.67086], [-116.83181, 32.67105], [-116.83221, 32.6712], [-116.83279, 32.67145], [-116.83316, 32.67165], [-116.83362, 32.67193], [-116.83409, 32.67227], [-116.83448, 32.67261], [-116.83488, 32.67303], [-116.83489, 32.67305], [-116.83934, 32.67824], [-116.83956, 32.67851], [-116.83971, 32.67876], [-116.83983, 32.67901], [-116.83997, 32.6794], [-116.84006, 32.67979], [-116.84023, 32.68087], [-116.84034, 32.68133], [-116.84042, 32.68152], [-116.84055, 32.68179], [-116.84076, 32.68213], [-116.84105, 32.68248], [-116.84124, 32.68267], [-116.84146, 32.68286], [-116.84188, 32.68315], [-116.84212, 32.68329], [-116.84242, 32.68342], [-116.83955, 32.68728], [-116.84653, 32.69112], [-116.84833, 32.6885], [-116.84993, 32.68621], [-116.85085, 32.6871], [-116.85092, 32.68706], [-116.85212, 32.68819], [-116.85661, 32.69271], [-116.85878, 32.69491], [-116.85879, 32.69494]], [[-116.80195, 32.70275], [-116.80344, 32.70208], [-116.80343, 32.70144], [-116.80314, 32.70143], [-116.80294, 32.7014], [-116.80274, 32.70139], [-116.8026, 32.7014], [-116.80243, 32.70145], [-116.80226, 32.70146], [-116.80188, 32.70141], [-116.80176, 32.70143], [-116.80164, 32.70149], [-116.80154, 32.70151], [-116.8014, 32.70151], [-116.80118, 32.70146], [-116.8011, 32.70148], [-116.80102, 32.70152], [-116.80094, 32.70166], [-116.80088, 32.70182], [-116.80084, 32.70248], [-116.80087, 32.70265], [-116.80095, 32.70278], [-116.80099, 32.70291], [-116.80102, 32.70324], [-116.80103, 32.70348], [-116.801, 32.70355], [-116.80095, 32.70361], [-116.80053, 32.7039], [-116.80052, 32.7041], [-116.80182, 32.7035], [-116.80195, 32.70275]], [[-116.8081, 32.69991], [-116.80816, 32.69736], [-116.80341, 32.69735], [-116.80344, 32.70098], [-116.80664, 32.70093], [-116.80665, 32.70074], [-116.8081, 32.69991]], [[-116.81334, 32.67937], [-116.81335, 32.67935], [-116.81009, 32.67666], [-116.80957, 32.67625], [-116.80926, 32.67932], [-116.81334, 32.67937]]]]} | Open Access 1 | 7373 | Hollenbeck Canyon Wildlife Area | 30451 | 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/Hollenbeck-Canyon-WA | San Diego 4 | 6871.161 | Hollenbeck Canyon Wildlife Area | 2001 | 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]);