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 = "Palomar Mountain State Park"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6782 | 6782 | 6781 | {"type": "MultiPolygon", "coordinates": [[[[-116.92828, 33.33989], [-116.92819, 33.34295], [-116.91087, 33.3428], [-116.91078, 33.34648], [-116.91508, 33.34654], [-116.91504, 33.35015], [-116.91483, 33.35742], [-116.91054, 33.35745], [-116.90625, 33.3575], [-116.90637, 33.35385], [-116.90369, 33.35384], [-116.90209, 33.35386], [-116.90215, 33.35019], [-116.89792, 33.35022], [-116.89802, 33.34068], [-116.89739, 33.33931], [-116.89658, 33.33931], [-116.89646, 33.33921], [-116.88936, 33.33929], [-116.88933, 33.33533], [-116.88935, 33.32868], [-116.88784, 33.32864], [-116.88506, 33.32861], [-116.88497, 33.32498], [-116.89331, 33.3251], [-116.89349, 33.32551], [-116.8937, 33.32574], [-116.89392, 33.32591], [-116.89486, 33.32637], [-116.89563, 33.32662], [-116.89575, 33.32668], [-116.89591, 33.32679], [-116.89625, 33.32717], [-116.89645, 33.32732], [-116.89661, 33.3274], [-116.89677, 33.32745], [-116.89713, 33.32751], [-116.89752, 33.32755], [-116.89819, 33.32771], [-116.89846, 33.32781], [-116.89896, 33.32802], [-116.8993, 33.32836], [-116.89951, 33.32864], [-116.89959, 33.32864], [-116.89974, 33.32881], [-116.90005, 33.329], [-116.90126, 33.32955], [-116.90135, 33.3296], [-116.9015, 33.32975], [-116.90159, 33.32994], [-116.90164, 33.33001], [-116.90204, 33.33042], [-116.90329, 33.33111], [-116.90356, 33.33131], [-116.90387, 33.33151], [-116.90414, 33.33162], [-116.90431, 33.33166], [-116.90476, 33.33172], [-116.90498, 33.33173], [-116.90511, 33.33174], [-116.90645, 33.33219], [-116.90657, 33.33225], [-116.90663, 33.3323], [-116.90671, 33.33241], [-116.90706, 33.33279], [-116.90725, 33.33291], [-116.90748, 33.33303], [-116.90787, 33.33311], [-116.90816, 33.33311], [-116.90851, 33.33304], [-116.90886, 33.33294], [-116.90888, 33.33311], [-116.90884, 33.33322], [-116.90878, 33.33332], [-116.90866, 33.33343], [-116.90848, 33.33355], [-116.90827, 33.33372], [-116.9078, 33.33415], [-116.90766, 33.33431], [-116.90753, 33.33454], [-116.90747, 33.33478], [-116.90746, 33.33494], [-116.90747, 33.33504], [-116.9075, 33.3351], [-116.90758, 33.33518], [-116.90806, 33.33546], [-116.9081, 33.33552], [-116.90815, 33.33562], [-116.90813, 33.33578], [-116.90779, 33.33669], [-116.9078, 33.3368], [-116.90786, 33.33693], [-116.90839, 33.33754], [-116.90846, 33.33759], [-116.90859, 33.33763], [-116.90908, 33.3376], [-116.90925, 33.33768], [-116.90929, 33.33775], [-116.90931, 33.33784], [-116.90924, 33.33809], [-116.90925, 33.33821], [-116.90936, 33.33832], [-116.90974, 33.33851], [-116.90982, 33.33858], [-116.90986, 33.33865], [-116.90989, 33.33872], [-116.90997, 33.3391], [-116.91012, 33.3393], [-116.91016, 33.33942], [-116.91033, 33.3401], [-116.91032, 33.34036], [-116.91026, 33.34054], [-116.91016, 33.3407], [-116.91006, 33.34082], [-116.90988, 33.34096], [-116.90982, 33.34107], [-116.90979, 33.34108], [-116.90919, 33.34095], [-116.90887, 33.34092], [-116.90856, 33.34095], [-116.908, 33.34107], [-116.9079, 33.34107], [-116.90782, 33.34103], [-116.90773, 33.34095], [-116.90765, 33.3409], [-116.90744, 33.34085], [-116.90727, 33.34077], [-116.90714, 33.34066], [-116.90704, 33.34061], [-116.90694, 33.3406], [-116.90616, 33.34066], [-116.90603, 33.34066], [-116.90593, 33.34063], [-116.9058, 33.34055], [-116.90556, 33.3402], [-116.90547, 33.34011], [-116.90532, 33.34002], [-116.90515, 33.33999], [-116.905, 33.33998], [-116.90483, 33.34], [-116.90453, 33.34009], [-116.90395, 33.34007], [-116.90374, 33.34008], [-116.90354, 33.34011], [-116.90338, 33.34018], [-116.90317, 33.34029], [-116.90296, 33.34048], [-116.90288, 33.34059], [-116.90243, 33.34134], [-116.9023, 33.34147], [-116.90194, 33.34176], [-116.90175, 33.34182], [-116.90162, 33.34189], [-116.90152, 33.34197], [-116.90148, 33.34203], [-116.90132, 33.34245], [-116.90128, 33.34263], [-116.90131, 33.34288], [-116.90144, 33.34314], [-116.90147, 33.34312], [-116.90151, 33.34309], [-116.90152, 33.34301], [-116.90146, 33.34292], [-116.90142, 33.34276], [-116.90141, 33.34257], [-116.90154, 33.34218], [-116.90158, 33.34209], [-116.90166, 33.342], [-116.90177, 33.34193], [-116.90196, 33.34187], [-116.90213, 33.34176], [-116.90225, 33.34168], [-116.90247, 33.34148], [-116.90262, 33.34129], [-116.90304, 33.34059], [-116.90317, 33.34045], [-116.90334, 33.34032], [-116.90354, 33.34023], [-116.90375, 33.34019], [-116.90394, 33.34018], [-116.90454, 33.34021], [-116.90485, 33.34011], [-116.90501, 33.34009], [-116.90521, 33.3401], [-116.90529, 33.34013], [-116.90538, 33.34019], [-116.90545, 33.34026], [-116.9057, 33.34063], [-116.90579, 33.34069], [-116.90597, 33.34075], [-116.90616, 33.34077], [-116.90696, 33.34071], [-116.90702, 33.34072], [-116.90707, 33.34074], [-116.90728, 33.34092], [-116.9076, 33.34101], [-116.90774, 33.34113], [-116.90789, 33.34118], [-116.90802, 33.34118], [-116.90861, 33.34105], [-116.90893, 33.34104], [-116.90912, 33.34104], [-116.9092, 33.34107], [-116.90923, 33.34106], [-116.90995, 33.34124], [-116.90994, 33.34115], [-116.90996, 33.34106], [-116.91016, 33.3409], [-116.91028, 33.34075], [-116.9104, 33.34055], [-116.91045, 33.34038], [-116.91046, 33.34011], [-116.91026, 33.3393], [-116.9102, 33.3392], [-116.9101, 33.33907], [-116.91, 33.33865], [-116.90992, 33.3385], [-116.90974, 33.33838], [-116.90944, 33.33823], [-116.90938, 33.33819], [-116.90937, 33.33811], [-116.90944, 33.33784], [-116.90942, 33.33771], [-116.90936, 33.33762], [-116.90924, 33.33754], [-116.90912, 33.3375], [-116.90902, 33.33749], [-116.90856, 33.33751], [-116.90852, 33.33749], [-116.90823, 33.33718], [-116.90796, 33.33685], [-116.90793, 33.33672], [-116.90794, 33.33663], [-116.90826, 33.33581], [-116.90827, 33.33561], [-116.90822, 33.33546], [-116.90814, 33.33537], [-116.90803, 33.33529], [-116.90765, 33.33508], [-116.90761, 33.33504], [-116.9076, 33.33499], [-116.9076, 33.33482], [-116.9077, 33.33449], [-116.9079, 33.33423], [-116.90827, 33.33387], [-116.90886, 33.33342], [-116.90893, 33.33331], [-116.90901, 33.33311], [-116.90901, 33.333], [-116.90898, 33.3329], [-116.90963, 33.33265], [-116.90979, 33.33255], [-116.90988, 33.33247], [-116.90998, 33.33254], [-116.91011, 33.33269], [-116.91022, 33.33277], [-116.91044, 33.33285], [-116.91061, 33.33295], [-116.91072, 33.33302], [-116.91089, 33.33317], [-116.91098, 33.33327], [-116.91103, 33.33337], [-116.91103, 33.33344], [-116.91097, 33.33362], [-116.91097, 33.33373], [-116.911, 33.33384], [-116.91107, 33.33399], [-116.91116, 33.33408], [-116.91152, 33.33435], [-116.91178, 33.33457], [-116.91203, 33.33482], [-116.91233, 33.33516], [-116.91244, 33.33527], [-116.9127, 33.33546], [-116.91288, 33.33555], [-116.9136, 33.33587], [-116.91408, 33.33613], [-116.91439, 33.33625], [-116.91455, 33.33629], [-116.91493, 33.33631], [-116.91524, 33.33629], [-116.9157, 33.33615], [-116.91611, 33.3361], [-116.91662, 33.3361], [-116.91674, 33.33612], [-116.91692, 33.33619], [-116.917, 33.33624], [-116.9171, 33.33633], [-116.91722, 33.33653], [-116.91727, 33.3367], [-116.91727, 33.33682], [-116.91725, 33.33693], [-116.91719, 33.33707], [-116.91688, 33.33753], [-116.91684, 33.33765], [-116.91686, 33.33788], [-116.91691, 33.338], [-116.9173, 33.33863], [-116.91746, 33.33879], [-116.91819, 33.33926], [-116.91832, 33.33927], [-116.91892, 33.33921], [-116.91909, 33.33921], [-116.91939, 33.33927], [-116.91957, 33.33934], [-116.91973, 33.33943], [-116.91992, 33.3396], [-116.92006, 33.33979], [-116.92019, 33.33992], [-116.92057, 33.34015], [-116.92167, 33.34051], [-116.92204, 33.34061], [-116.92228, 33.3407], [-116.92263, 33.34087], [-116.923, 33.34114], [-116.92322, 33.34123], [-116.92346, 33.34132], [-116.92382, 33.34139], [-116.92414, 33.34143], [-116.92446, 33.34143], [-116.92459, 33.3414], [-116.92466, 33.34136], [-116.92469, 33.34132], [-116.92473, 33.34117], [-116.92455, 33.34078], [-116.92446, 33.34063], [-116.9243, 33.34044], [-116.92398, 33.34018], [-116.92381, 33.33996], [-116.9238, 33.33992], [-116.92381, 33.33989], [-116.92386, 33.33983], [-116.9244, 33.33983], [-116.92488, 33.33996], [-116.92507, 33.33998], [-116.92513, 33.33997], [-116.92521, 33.33995], [-116.92529, 33.33988], [-116.92537, 33.33968], [-116.92542, 33.33961], [-116.92552, 33.33957], [-116.92571, 33.3395], [-116.92613, 33.33941], [-116.92668, 33.33939], [-116.92687, 33.33941], [-116.92704, 33.33945], [-116.92755, 33.33966], [-116.92795, 33.33985], [-116.92812, 33.33988], [-116.92828, 33.33989]]], [[[-116.89401, 33.32511], [-116.89396, 33.32546], [-116.89395, 33.32563], [-116.89392, 33.32562], [-116.89372, 33.3254], [-116.89367, 33.32533], [-116.8936, 33.32511], [-116.89401, 33.32511]]], [[[-116.92851, 33.33186], [-116.92834, 33.33726], [-116.92828, 33.33978], [-116.92813, 33.33978], [-116.92801, 33.33975], [-116.92761, 33.33956], [-116.92711, 33.33935], [-116.9267, 33.33928], [-116.92611, 33.3393], [-116.92553, 33.33944], [-116.92538, 33.3395], [-116.92529, 33.33957], [-116.92523, 33.33965], [-116.92521, 33.33977], [-116.92518, 33.33981], [-116.92514, 33.33986], [-116.92505, 33.33987], [-116.92474, 33.33981], [-116.92442, 33.33972], [-116.92385, 33.33971], [-116.92377, 33.33975], [-116.92367, 33.33987], [-116.92368, 33.33997], [-116.9237, 33.34002], [-116.92389, 33.34026], [-116.92418, 33.3405], [-116.92433, 33.34067], [-116.92442, 33.3408], [-116.9246, 33.34117], [-116.92458, 33.34125], [-116.92455, 33.34129], [-116.9245, 33.34132], [-116.92408, 33.34132], [-116.92385, 33.34129], [-116.92331, 33.34115], [-116.9231, 33.34106], [-116.92268, 33.34077], [-116.92233, 33.34059], [-116.92058, 33.34003], [-116.92039, 33.33992], [-116.92015, 33.33971], [-116.92001, 33.33952], [-116.91987, 33.33939], [-116.91972, 33.33929], [-116.91956, 33.33921], [-116.91922, 33.33911], [-116.91906, 33.3391], [-116.91892, 33.3391], [-116.91832, 33.33917], [-116.91819, 33.33913], [-116.91755, 33.33871], [-116.91737, 33.33853], [-116.91702, 33.33794], [-116.91698, 33.33783], [-116.91697, 33.33769], [-116.917, 33.33756], [-116.91729, 33.33715], [-116.91739, 33.33692], [-116.9174, 33.33682], [-116.91739, 33.33663], [-116.91733, 33.33648], [-116.91726, 33.33633], [-116.91706, 33.33614], [-116.91691, 33.33605], [-116.91677, 33.33601], [-116.91666, 33.33599], [-116.91633, 33.33598], [-116.91602, 33.336], [-116.91567, 33.33604], [-116.91516, 33.33619], [-116.91485, 33.33621], [-116.91457, 33.33618], [-116.91436, 33.33612], [-116.91415, 33.33604], [-116.91367, 33.33577], [-116.91298, 33.33547], [-116.91281, 33.33538], [-116.91252, 33.33518], [-116.91211, 33.33473], [-116.91185, 33.33448], [-116.91155, 33.33423], [-116.91122, 33.33398], [-116.91116, 33.3339], [-116.91111, 33.33378], [-116.9111, 33.33366], [-116.91116, 33.33349], [-116.91117, 33.3334], [-116.91109, 33.33321], [-116.91092, 33.33303], [-116.91076, 33.3329], [-116.91058, 33.33279], [-116.91034, 33.33268], [-116.90997, 33.33239], [-116.90983, 33.33236], [-116.90961, 33.33253], [-116.90921, 33.33269], [-116.90871, 33.33287], [-116.90847, 33.33294], [-116.90814, 33.333], [-116.90798, 33.333], [-116.90773, 33.33298], [-116.90752, 33.33292], [-116.90727, 33.33279], [-116.90718, 33.33273], [-116.90708, 33.33265], [-116.90673, 33.33223], [-116.90661, 33.33214], [-116.90648, 33.33208], [-116.90518, 33.33164], [-116.90499, 33.33161], [-116.90469, 33.33161], [-116.90446, 33.33158], [-116.90418, 33.33152], [-116.9039, 33.3314], [-116.9034, 33.33105], [-116.90212, 33.33034], [-116.90178, 33.32998], [-116.90171, 33.32987], [-116.9016, 33.32967], [-116.90151, 33.32958], [-116.90143, 33.32951], [-116.90132, 33.32945], [-116.90013, 33.3289], [-116.89984, 33.32872], [-116.89975, 33.32864], [-116.91115, 33.32847], [-116.92371, 33.32843], [-116.92368, 33.33192], [-116.92805, 33.33191], [-116.92851, 33.33186]]]]} | Open Access 1 | 5322 | Palomar Mountain State Park | 1670 | 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=637 | San Diego 4 | 1870.348 | Palomar Mtn. SP | 1932 | State Park 15 | 4 |
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]);