units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, AGNCY_TYP = 13 and MNG_AGENCY = 562
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Riverside County Habitat Conservation Agency · 1 ✖
DES_TP 1
ACCESS_TYP 1
- Open Access · 1 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15130 | 15130 | 15129 | {"type": "MultiPolygon", "coordinates": [[[[-117.01468, 33.56978], [-117.01467, 33.57292], [-117.01048, 33.57288], [-117.01049, 33.5727], [-117.01053, 33.57254], [-117.01059, 33.57238], [-117.01067, 33.57217], [-117.01091, 33.57173], [-117.01104, 33.57141], [-117.01152, 33.56982], [-117.01156, 33.56956], [-117.01157, 33.56933], [-117.01468, 33.56978]]], [[[-117.01477, 33.58748], [-117.00631, 33.58757], [-117.0063, 33.58009], [-117.01053, 33.58011], [-117.01056, 33.58377], [-117.01476, 33.58377], [-117.01477, 33.58748]]], [[[-117.01471, 33.58963], [-117.01454, 33.59546], [-117.01055, 33.59626], [-117.00707, 33.59625], [-117.00701, 33.59678], [-117.00705, 33.59736], [-117.00708, 33.5975], [-117.00718, 33.59766], [-117.00792, 33.5984], [-117.00107, 33.59836], [-117.00088, 33.59564], [-117.0003, 33.59563], [-117.00025, 33.59143], [-116.99806, 33.59065], [-116.99805, 33.58728], [-117.00201, 33.58742], [-117.00198, 33.59143], [-117.00341, 33.5912], [-117.00429, 33.59064], [-117.00476, 33.59047], [-117.00489, 33.59046], [-117.00504, 33.59047], [-117.00515, 33.59052], [-117.00523, 33.59056], [-117.0055, 33.59083], [-117.00557, 33.59093], [-117.00589, 33.59148], [-117.0081, 33.59298], [-117.01471, 33.58963]]], [[[-117.03151, 33.62354], [-117.03149, 33.62536], [-117.02339, 33.62564], [-117.01466, 33.62571], [-117.01467, 33.62211], [-117.02337, 33.62194], [-117.0277, 33.62183], [-117.02772, 33.62366], [-117.03151, 33.62354]]], [[[-116.99502, 33.63408], [-116.99496, 33.63746], [-116.99387, 33.63656], [-116.99371, 33.63645], [-116.99215, 33.63575], [-116.99189, 33.6356], [-116.99175, 33.63547], [-116.99164, 33.63533], [-116.99153, 33.63509], [-116.9915, 33.63483], [-116.99155, 33.63457], [-116.99169, 33.63434], [-116.99185, 33.63417], [-116.99502, 33.63408]]], [[[-117.01446, 33.64144], [-117.01444, 33.64221], [-117.01434, 33.64222], [-117.01432, 33.64401], [-117.01134, 33.64401], [-117.01257, 33.64221], [-117.01216, 33.64221], [-117.01127, 33.64351], [-117.01106, 33.64282], [-117.011, 33.64269], [-117.01091, 33.64257], [-117.0108, 33.64234], [-117.01077, 33.64223], [-117.01072, 33.64189], [-117.01103, 33.64169], [-117.01152, 33.64167], [-117.01201, 33.64175], [-117.01278, 33.64161], [-117.01391, 33.64158], [-117.01446, 33.64144]]], [[[-117.01903, 33.6275], [-117.01894, 33.63479], [-117.0146, 33.63486], [-117.01446, 33.64126], [-117.01388, 33.64142], [-117.01276, 33.64144], [-117.012, 33.64159], [-117.01154, 33.6415], [-117.01096, 33.64153], [-117.01052, 33.64181], [-117.01058, 33.64226], [-117.01061, 33.64239], [-117.01073, 33.64264], [-117.01082, 33.64276], [-117.01087, 33.64287], [-117.01112, 33.64372], [-117.01092, 33.64401], [-117.01004, 33.64401], [-117.01002, 33.64535], [-117.00984, 33.64556], [-117.00974, 33.6458], [-117.0096, 33.64629], [-117.00945, 33.6467], [-117.00936, 33.64687], [-117.00927, 33.64696], [-117.00875, 33.64724], [-117.00844, 33.64751], [-117.00824, 33.64766], [-117.008, 33.6478], [-117.00777, 33.6479], [-117.00766, 33.64793], [-117.00696, 33.64806], [-117.00667, 33.64814], [-117.00623, 33.64835], [-117.00563, 33.64846], [-117.00548, 33.64856], [-117.00537, 33.64868], [-117.00497, 33.64919], [-117.00466, 33.64956], [-117.00429, 33.64994], [-117.0035, 33.65035], [-117.00207, 33.65081], [-117.00061, 33.65044], [-117.00008, 33.65047], [-116.99929, 33.65007], [-116.99748, 33.64792], [-116.99655, 33.64712], [-116.99655, 33.6469], [-116.99397, 33.64132], [-116.99385, 33.64112], [-116.99365, 33.64083], [-116.99349, 33.64065], [-116.99321, 33.6404], [-116.99321, 33.64034], [-116.99511, 33.63881], [-116.9953, 33.63863], [-116.99538, 33.63853], [-116.99551, 33.63831], [-116.99599, 33.63707], [-116.99613, 33.6368], [-116.99627, 33.63664], [-116.99642, 33.63649], [-116.99703, 33.63603], [-116.99718, 33.63594], [-116.99727, 33.63498], [-116.99692, 33.63145], [-116.99171, 33.63297], [-116.99161, 33.6328], [-116.99155, 33.63265], [-116.99153, 33.63249], [-116.99155, 33.63225], [-116.99161, 33.63209], [-116.99211, 33.63117], [-116.99215, 33.63111], [-116.99221, 33.63106], [-116.99232, 33.631], [-116.99285, 33.63084], [-116.99308, 33.63072], [-116.99321, 33.63062], [-116.99332, 33.63049], [-116.9934, 33.63036], [-116.99345, 33.63023], [-116.99686, 33.63082], [-116.99656, 33.62778], [-117.01466, 33.62751], [-117.01903, 33.6275]]], [[[-116.99159, 33.64287], [-116.99432, 33.64274], [-116.99547, 33.64522], [-116.99544, 33.64528], [-116.99522, 33.64533], [-116.995, 33.64532], [-116.9941, 33.64512], [-116.99391, 33.6451], [-116.99373, 33.64511], [-116.99346, 33.64518], [-116.99306, 33.64538], [-116.99286, 33.64545], [-116.99241, 33.64551], [-116.99217, 33.64547], [-116.99209, 33.64548], [-116.99203, 33.64552], [-116.992, 33.64557], [-116.99199, 33.64562], [-116.99203, 33.64568], [-116.99209, 33.64572], [-116.99217, 33.64573], [-116.99241, 33.64565], [-116.99268, 33.64563], [-116.99292, 33.64559], [-116.99314, 33.64551], [-116.99353, 33.64532], [-116.99368, 33.64527], [-116.99383, 33.64525], [-116.99407, 33.64527], [-116.99497, 33.64547], [-116.99524, 33.64548], [-116.99548, 33.64543], [-116.99558, 33.64547], [-116.99654, 33.64753], [-116.99656, 33.64753], [-116.99655, 33.64735], [-116.99732, 33.64802], [-116.99915, 33.6502], [-117.00003, 33.65064], [-117.0006, 33.65061], [-117.00207, 33.65098], [-117.00359, 33.65049], [-117.00442, 33.65006], [-117.00482, 33.64966], [-117.00513, 33.64928], [-117.00553, 33.64877], [-117.00562, 33.64868], [-117.00572, 33.64861], [-117.0063, 33.6485], [-117.00675, 33.64829], [-117.00701, 33.64822], [-117.00772, 33.64809], [-117.00785, 33.64805], [-117.00811, 33.64794], [-117.00837, 33.64779], [-117.00859, 33.64762], [-117.00887, 33.64737], [-117.00939, 33.64709], [-117.00954, 33.64695], [-117.00963, 33.64676], [-117.00979, 33.64633], [-117.00993, 33.64585], [-117.01001, 33.64566], [-117.00997, 33.64943], [-117.01434, 33.64944], [-117.01423, 33.65661], [-117.03183, 33.65646], [-117.03202, 33.64928], [-117.03717, 33.64924], [-117.03716, 33.64745], [-117.03913, 33.64744], [-117.03915, 33.64923], [-117.04075, 33.64922], [-117.04076, 33.64921], [-117.04071, 33.64562], [-117.03188, 33.64568], [-117.03173, 33.64194], [-117.04068, 33.64201], [-117.04072, 33.64562], [-117.04942, 33.64558], [-117.04961, 33.64918], [-117.06677, 33.64892], [-117.0755, 33.64886], [-117.07594, 33.65621], [-117.07597, 33.66023], [-117.07589, 33.66028], [-117.07585, 33.66026], [-117.07513, 33.66074], [-117.07529, 33.66092], [-117.07439, 33.66146], [-117.07423, 33.66153], [-117.0741, 33.66135], [-117.07323, 33.66171], [-117.07301, 33.66185], [-117.0728, 33.662], [-117.07252, 33.66226], [-117.07192, 33.66301], [-117.07166, 33.66319], [-117.07146, 33.66328], [-117.07124, 33.66333], [-117.06984, 33.66338], [-117.06957, 33.66343], [-117.06931, 33.66352], [-117.06932, 33.66354], [-117.07226, 33.66351], [-117.07204, 33.66365], [-117.07181, 33.66376], [-117.07142, 33.66387], [-117.07115, 33.6639], [-117.06992, 33.66393], [-117.06978, 33.66396], [-117.06958, 33.66404], [-117.06941, 33.66417], [-117.06854, 33.66515], [-117.06732, 33.66631], [-117.06734, 33.67099], [-117.06703, 33.67873], [-117.068, 33.67928], [-117.06822, 33.67942], [-117.06842, 33.67958], [-117.06937, 33.68053], [-117.06998, 33.68127], [-117.0702, 33.6816], [-117.07038, 33.68194], [-117.07045, 33.68212], [-117.07058, 33.68248], [-117.07066, 33.68284], [-117.07092, 33.68438], [-117.071, 33.68464], [-117.07115, 33.68488], [-117.07124, 33.68499], [-117.07139, 33.68514], [-117.07164, 33.68531], [-117.07208, 33.68552], [-117.07168, 33.68553], [-117.07108, 33.68683], [-117.07101, 33.68716], [-117.07099, 33.68738], [-117.071, 33.68826], [-117.07098, 33.68827], [-117.07095, 33.68953], [-117.07093, 33.6897], [-117.07087, 33.68992], [-117.07077, 33.69013], [-117.07061, 33.69035], [-117.07043, 33.69052], [-117.07025, 33.69065], [-117.07002, 33.69077], [-117.06943, 33.69096], [-117.06898, 33.69116], [-117.06749, 33.69206], [-117.06706, 33.69226], [-117.06707, 33.69258], [-117.06582, 33.69284], [-117.06503, 33.69285], [-117.05997, 33.69515], [-117.05961, 33.69528], [-117.05935, 33.69534], [-117.05884, 33.69541], [-117.05845, 33.69542], [-117.05647, 33.6953], [-117.05599, 33.69529], [-117.05567, 33.69531], [-117.05221, 33.69569], [-117.0522, 33.69574], [-117.05101, 33.69587], [-117.05073, 33.69592], [-117.05019, 33.69607], [-117.04992, 33.69618], [-117.04991, 33.69634], [-117.04955, 33.6965], [-117.04914, 33.69674], [-117.04111, 33.69663], [-117.04117, 33.69863], [-117.04064, 33.69879], [-117.04024, 33.69893], [-117.03947, 33.69927], [-117.03875, 33.69967], [-117.03841, 33.69989], [-117.03807, 33.70014], [-117.03249, 33.70005], [-117.03248, 33.70014], [-117.02345, 33.70007], [-117.02356, 33.7038], [-117.02166, 33.70379], [-117.02166, 33.70554], [-117.02142, 33.70555], [-117.02125, 33.70557], [-117.02107, 33.70562], [-117.02092, 33.70568], [-117.02077, 33.70578], [-117.02064, 33.7059], [-117.02054, 33.70603], [-117.02047, 33.70618], [-117.01994, 33.70571], [-117.01979, 33.7049], [-117.01947, 33.70385], [-117.01946, 33.70384], [-117.01946, 33.70749], [-117.01513, 33.70752], [-117.01516, 33.71063], [-117.01445, 33.71091], [-117.0136, 33.71116], [-117.00304, 33.71123], [-116.99719, 33.71124], [-116.99682, 33.71109], [-116.99675, 33.71119], [-116.99567, 33.71073], [-116.99564, 33.70379], [-116.9956, 33.70017], [-116.98878, 33.70019], [-116.98875, 33.69655], [-116.98441, 33.69657], [-116.98429, 33.68571], [-116.97993, 33.68572], [-116.97993, 33.68558], [-116.98014, 33.68557], [-116.98008, 33.68551], [-116.98007, 33.68015], [-116.98009, 33.68008], [-116.98007, 33.68002], [-116.98003, 33.67998], [-116.98127, 33.67997], [-116.98128, 33.67946], [-116.98425, 33.67843], [-116.98425, 33.67483], [-116.98456, 33.67483], [-116.98484, 33.67488], [-116.98494, 33.67483], [-116.98497, 33.67475], [-116.98858, 33.67472], [-116.98859, 33.67702], [-116.98849, 33.67706], [-116.98852, 33.68548], [-116.98846, 33.68554], [-116.98847, 33.68555], [-116.98878, 33.68554], [-116.98878, 33.68553], [-116.98872, 33.68548], [-116.98868, 33.67487], [-116.98876, 33.6748], [-116.99295, 33.67476], [-116.99293, 33.67461], [-116.98858, 33.67464], [-116.98857, 33.6746], [-116.98453, 33.67463], [-116.98452, 33.67121], [-116.98463, 33.67123], [-116.98483, 33.6713], [-116.98489, 33.67131], [-116.98496, 33.67129], [-116.98502, 33.67125], [-116.98504, 33.67119], [-116.98503, 33.67113], [-116.98856, 33.6711], [-116.98812, 33.65662], [-116.97961, 33.65661], [-116.9798, 33.64937], [-116.98401, 33.64939], [-116.9861, 33.64604], [-116.98624, 33.64623], [-116.98687, 33.64756], [-116.98706, 33.64786], [-116.98722, 33.64803], [-116.98742, 33.64819], [-116.98764, 33.64831], [-116.9879, 33.64841], [-116.98801, 33.64848], [-116.98812, 33.64861], [-116.98818, 33.64876], [-116.98817, 33.64887], [-116.98815, 33.64895], [-116.9879, 33.64939], [-116.98797, 33.6494], [-116.98812, 33.65661], [-116.99235, 33.65662], [-116.99227, 33.64942], [-116.98814, 33.6494], [-116.98833, 33.64906], [-116.98839, 33.6489], [-116.9884, 33.64879], [-116.98838, 33.64868], [-116.98832, 33.64853], [-116.98825, 33.64843], [-116.98811, 33.64831], [-116.988, 33.64825], [-116.98775, 33.64816], [-116.98756, 33.64805], [-116.98738, 33.64791], [-116.98723, 33.64776], [-116.98707, 33.64749], [-116.98643, 33.64615], [-116.98636, 33.64605], [-116.9862, 33.64585], [-116.98764, 33.643], [-116.9883, 33.64293], [-116.9901, 33.64298], [-116.99159, 33.64287]], [[-117.01501, 33.70443], [-117.01502, 33.70452], [-117.01648, 33.70451], [-117.01648, 33.70377], [-117.01498, 33.70376], [-117.01497, 33.70336], [-117.01492, 33.70311], [-117.01487, 33.70298], [-117.01483, 33.70305], [-117.01479, 33.70324], [-117.01468, 33.70347], [-117.01407, 33.70387], [-117.01378, 33.70412], [-117.01366, 33.70416], [-117.01356, 33.70407], [-117.01345, 33.70392], [-117.01334, 33.70373], [-117.01338, 33.70335], [-117.01332, 33.70319], [-117.01311, 33.70286], [-117.01271, 33.70237], [-117.0125, 33.70206], [-117.0124, 33.70183], [-117.01233, 33.70173], [-117.01206, 33.70144], [-117.01154, 33.701], [-117.01137, 33.70074], [-117.0113, 33.7007], [-117.01124, 33.70068], [-117.01108, 33.70067], [-117.01068, 33.70083], [-117.01056, 33.7009], [-117.01047, 33.70098], [-117.0104, 33.70108], [-117.01036, 33.70119], [-117.01034, 33.70143], [-117.0103, 33.70166], [-117.01024, 33.70179], [-117.01017, 33.70189], [-117.0099, 33.70208], [-117.00976, 33.7022], [-117.00973, 33.70232], [-117.00983, 33.70253], [-117.00978, 33.70264], [-117.00968, 33.70275], [-117.01079, 33.70316], [-117.01089, 33.70316], [-117.01092, 33.70305], [-117.01101, 33.70293], [-117.01119, 33.70283], [-117.0114, 33.7028], [-117.01163, 33.70285], [-117.01174, 33.70291], [-117.01182, 33.703], [-117.01218, 33.70398], [-117.01233, 33.70418], [-117.01252, 33.70434], [-117.01313, 33.70469], [-117.01348, 33.70478], [-117.01415, 33.70478], [-117.0143, 33.70471], [-117.01446, 33.70455], [-117.01457, 33.70448], [-117.01469, 33.70445], [-117.01501, 33.70443]], [[-117.06346, 33.69289], [-117.06, 33.69295], [-117.06004, 33.69471], [-117.06367, 33.69327], [-117.06346, 33.69289]], [[-117.03224, 33.68925], [-117.03214, 33.68553], [-117.02349, 33.68555], [-117.02347, 33.69285], [-117.03232, 33.69294], [-117.03224, 33.68925]], [[-117.0148, 33.68556], [-117.01481, 33.68555], [-117.0148, 33.68542], [-117.00625, 33.68545], [-117.00595, 33.68546], [-117.00037, 33.6855], [-117.00038, 33.68563], [-117.0148, 33.68556]], [[-117.05389, 33.68187], [-117.05388, 33.68186], [-117.04954, 33.68189], [-117.04953, 33.68205], [-117.04954, 33.68206], [-117.05387, 33.68203], [-117.05389, 33.68187]]]]} | Open Access 1 | 48558 | Southwestern Riverside County Multi-Species Reserve | 33272 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 2122 | Riverside County Habitat Conservation Agency 562 | Special District 4 | Open Space District 6 | http://rchca.us/159/Reserves | Riverside 10 | 12774.114 | Southwestern Riverside County Multi-Species Reserve | 1992 | Local Conservation Area 4 | 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]);