units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

6 rows where ACCESS_TYP = 4 and AGNCY_WEB = "http://www.rivcoparks.org/"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

ACCESS_TYP 1

  • Unknown Access · 6 ✖
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
1584 1584 1583 {"type": "Polygon", "coordinates": [[[-117.09349, 33.56898], [-117.0926, 33.57066], [-117.08388, 33.57076], [-117.08394, 33.56909], [-117.09349, 33.56898]]]} Unknown Access 4 12140 French Valley Conservation Area, Expansion 1 19108 315 Riverside, County of 169 County 3 County Agency 3 http://www.rivcoparks.org/ County 3 315 Riverside, County of 165 County 3 County Agency 3   Riverside 10 38.849 French Valley Conservation Area, Expansion 1   None 128  
5589 5589 5588 {"type": "MultiPolygon", "coordinates": [[[[-117.31639, 33.6953], [-117.31635, 33.69561], [-117.31633, 33.69569], [-117.3163, 33.69571], [-117.31632, 33.6955], [-117.31631, 33.69534], [-117.31594, 33.69537], [-117.31592, 33.69538], [-117.31574, 33.69537], [-117.31571, 33.69539], [-117.31553, 33.69534], [-117.3153, 33.6952], [-117.31512, 33.69522], [-117.31503, 33.69526], [-117.31476, 33.69552], [-117.31443, 33.69569], [-117.31383, 33.6958], [-117.31368, 33.69593], [-117.31364, 33.69608], [-117.31361, 33.69625], [-117.31355, 33.6964], [-117.31344, 33.69654], [-117.31328, 33.69667], [-117.31326, 33.69671], [-117.31313, 33.69667], [-117.31303, 33.69689], [-117.31324, 33.69696], [-117.31297, 33.69761], [-117.31285, 33.69777], [-117.31286, 33.69781], [-117.31274, 33.69796], [-117.31275, 33.69801], [-117.31267, 33.6982], [-117.31269, 33.69825], [-117.31261, 33.69844], [-117.31263, 33.69849], [-117.31232, 33.6985], [-117.31228, 33.69878], [-117.31228, 33.69934], [-117.31217, 33.69939], [-117.3121, 33.69984], [-117.31209, 33.70031], [-117.31159, 33.70037], [-117.31143, 33.70065], [-117.31153, 33.70092], [-117.31154, 33.7013], [-117.31183, 33.70143], [-117.31253, 33.70148], [-117.31263, 33.70165], [-117.31269, 33.70186], [-117.31269, 33.70201], [-117.31283, 33.70211], [-117.31016, 33.70212], [-117.31015, 33.70437], [-117.30948, 33.70421], [-117.30905, 33.70422], [-117.30873, 33.70414], [-117.30802, 33.70393], [-117.30754, 33.70366], [-117.30723, 33.70357], [-117.30706, 33.70356], [-117.30739, 33.70329], [-117.3083, 33.70348], [-117.30818, 33.70272], [-117.30938, 33.70245], [-117.31079, 33.7014], [-117.31122, 33.70029], [-117.31185, 33.70011], [-117.31177, 33.69849], [-117.31161, 33.6985], [-117.31168, 33.70001], [-117.31109, 33.70018], [-117.31064, 33.70131], [-117.3093, 33.70232], [-117.30799, 33.70262], [-117.3081, 33.70329], [-117.30734, 33.70313], [-117.3056, 33.70454], [-117.30572, 33.70516], [-117.30514, 33.70516], [-117.30516, 33.70542], [-117.30442, 33.70566], [-117.30445, 33.70582], [-117.3015, 33.70585], [-117.30154, 33.70315], [-117.30153, 33.70223], [-117.30591, 33.70216], [-117.30588, 33.69857], [-117.31018, 33.69849], [-117.31016, 33.69487], [-117.31638, 33.69484], [-117.31639, 33.6953]]], [[[-117.31014, 33.69113], [-117.30429, 33.69122], [-117.30424, 33.68906], [-117.30415, 33.68905], [-117.30405, 33.6841], [-117.3101, 33.68401], [-117.31014, 33.69113]]], [[[-117.30638, 33.70411], [-117.30631, 33.70476], [-117.30632, 33.7049], [-117.30628, 33.70497], [-117.30595, 33.70515], [-117.30589, 33.70515], [-117.30578, 33.70459], [-117.30638, 33.70411]]], [[[-117.32739, 33.71393], [-117.32716, 33.72027], [-117.31861, 33.7203], [-117.31839, 33.72757], [-117.31126, 33.7276], [-117.31118, 33.72583], [-117.31162, 33.72582], [-117.31163, 33.72581], [-117.31115, 33.725], [-117.31105, 33.72502], [-117.31013, 33.72438], [-117.30997, 33.72377], [-117.31012, 33.71407], [-117.3188, 33.71403], [-117.32739, 33.71393]]], [[[-117.36159, 33.71668], [-117.35971, 33.71664], [-117.35975, 33.7135], [-117.36052, 33.71444], [-117.36112, 33.71589], [-117.36129, 33.71621], [-117.36152, 33.71654], [-117.36159, 33.71668]]], [[[-117.45455, 33.74791], [-117.45432, 33.74847], [-117.45404, 33.74872], [-117.45382, 33.74846], [-117.45382, 33.74819], [-117.45451, 33.74787], [-117.45455, 33.74791]]], [[[-117.46108, 33.7505], [-117.46077, 33.75067], [-117.46048, 33.7509], [-117.45889, 33.75254], [-117.45869, 33.75269], [-117.45844, 33.75282], [-117.45841, 33.75283], [-117.4583, 33.75281], [-117.45827, 33.75277], [-117.45859, 33.75261], [-117.45884, 33.75242], [-117.45898, 33.75241], [-117.45962, 33.75175], [-117.45961, 33.75163], [-117.46014, 33.75107], [-117.46029, 33.75106], [-117.46051, 33.75083], [-117.46072, 33.75067], [-117.46107, 33.75048], [-117.46108, 33.7505]]]]} Unknown Access 4 14103 Alberhill Conservation Area 15333 315 Riverside, County of 169 County 3 County Agency 3 http://www.rivcoparks.org/ County 3 315 Riverside, County of 165 County 3 County Agency 3   Riverside 10 685.557 Alberhill Conservation Area 0 Local Conservation Area 4 2
8096 8096 8095 {"type": "MultiPolygon", "coordinates": [[[[-117.1101, 33.63438], [-117.10578, 33.63443], [-117.10578, 33.63085], [-117.11002, 33.63089], [-117.1101, 33.63438]]], [[[-117.14335, 33.6307], [-117.14334, 33.63428], [-117.13682, 33.63432], [-117.12331, 33.63432], [-117.12328, 33.62709], [-117.12774, 33.62709], [-117.12773, 33.6253], [-117.13201, 33.62537], [-117.13196, 33.62358], [-117.13678, 33.62359], [-117.1368, 33.62711], [-117.14106, 33.62711], [-117.14101, 33.63071], [-117.14335, 33.6307]], [[-117.1368, 33.62892], [-117.13679, 33.62712], [-117.1323, 33.6271], [-117.13244, 33.6307], [-117.1368, 33.6307], [-117.1368, 33.62892]]], [[[-117.17557, 33.6052], [-117.17555, 33.60545], [-117.17549, 33.60567], [-117.17542, 33.60583], [-117.17531, 33.60603], [-117.17514, 33.60627], [-117.17498, 33.60645], [-117.17482, 33.60656], [-117.17474, 33.60687], [-117.17478, 33.60688], [-117.17458, 33.6074], [-117.17448, 33.60762], [-117.17443, 33.60768], [-117.17426, 33.60784], [-117.17285, 33.60876], [-117.17273, 33.60885], [-117.17261, 33.609], [-117.17252, 33.60922], [-117.17248, 33.60964], [-117.17239, 33.6123], [-117.17157, 33.61232], [-117.17175, 33.60688], [-117.17185, 33.6052], [-117.17557, 33.6052]]], [[[-117.18499, 33.60556], [-117.18491, 33.6057], [-117.18461, 33.60563], [-117.18433, 33.60581], [-117.1842, 33.60612], [-117.18415, 33.60618], [-117.1841, 33.60639], [-117.18399, 33.60653], [-117.18375, 33.60674], [-117.18341, 33.60694], [-117.18334, 33.607], [-117.18326, 33.60709], [-117.18322, 33.60716], [-117.1832, 33.60726], [-117.1832, 33.60735], [-117.18311, 33.60735], [-117.18293, 33.60756], [-117.18287, 33.60758], [-117.18277, 33.60769], [-117.18272, 33.60771], [-117.18263, 33.60781], [-117.18257, 33.60783], [-117.18247, 33.60795], [-117.18241, 33.60796], [-117.1823, 33.60809], [-117.18226, 33.60811], [-117.18214, 33.60825], [-117.18211, 33.60827], [-117.18203, 33.6084], [-117.18232, 33.60857], [-117.1823, 33.60861], [-117.18196, 33.60846], [-117.18187, 33.60863], [-117.18179, 33.60881], [-117.18174, 33.60898], [-117.18169, 33.60936], [-117.18143, 33.6094], [-117.18119, 33.60947], [-117.18086, 33.60962], [-117.18057, 33.60978], [-117.1803, 33.60997], [-117.18006, 33.61018], [-117.17985, 33.61042], [-117.17969, 33.61063], [-117.17936, 33.61055], [-117.17798, 33.61052], [-117.1778, 33.61044], [-117.17762, 33.61044], [-117.17755, 33.6107], [-117.17747, 33.61075], [-117.17745, 33.61081], [-117.17729, 33.61104], [-117.17719, 33.61116], [-117.17722, 33.61136], [-117.17717, 33.61148], [-117.17717, 33.61174], [-117.17713, 33.61181], [-117.17714, 33.61187], [-117.17717, 33.61191], [-117.17715, 33.61194], [-117.17715, 33.61229], [-117.17257, 33.6123], [-117.17267, 33.60987], [-117.17271, 33.60933], [-117.17278, 33.60911], [-117.17287, 33.60896], [-117.17297, 33.60887], [-117.17444, 33.6079], [-117.17454, 33.60782], [-117.17464, 33.60769], [-117.17483, 33.60732], [-117.17499, 33.60688], [-117.17561, 33.60688], [-117.1758, 33.60509], [-117.18041, 33.60509], [-117.18041, 33.605], [-117.17934, 33.605], [-117.17929, 33.60497], [-117.17935, 33.60327], [-117.1819, 33.60327], [-117.18203, 33.60324], [-117.18251, 33.60323], [-117.18251, 33.60473], [-117.18361, 33.60473], [-117.18362, 33.60509], [-117.18493, 33.6051], [-117.18493, 33.60539], [-117.18499, 33.60556]], [[-117.17609, 33.61172], [-117.17615, 33.61117], [-117.17517, 33.61118], [-117.17512, 33.61172], [-117.17609, 33.61172]]], [[[-117.17919, 33.60327], [-117.17913, 33.60499], [-117.17906, 33.60501], [-117.17582, 33.60501], [-117.17578, 33.60497], [-117.1758, 33.60455], [-117.17581, 33.6034], [-117.17586, 33.60335], [-117.17663, 33.60335], [-117.17677, 33.60337], [-117.1769, 33.60343], [-117.17699, 33.60345], [-117.17706, 33.60343], [-117.17711, 33.60339], [-117.17714, 33.60333], [-117.17713, 33.60327], [-117.17919, 33.60327]]]]} Unknown Access 4 12134 Triple Creeks Conservation Area 26546 315 Riverside, County of 169 County 3 County Agency 3 http://www.rivcoparks.org/ County 3 315 Riverside, County of 165 County 3 County Agency 3   Riverside 10 605.784 Triple Creeks Conservation Area 0 Local Conservation Area 4 2
8099 8099 8098 {"type": "MultiPolygon", "coordinates": [[[[-117.3176, 33.73889], [-117.31758, 33.73902], [-117.31747, 33.73927], [-117.31747, 33.73948], [-117.31751, 33.73969], [-117.31747, 33.74002], [-117.31721, 33.74052], [-117.31696, 33.74085], [-117.31673, 33.74099], [-117.31643, 33.74097], [-117.3163, 33.74056], [-117.31613, 33.74033], [-117.31575, 33.74021], [-117.31534, 33.74022], [-117.31514, 33.74026], [-117.31496, 33.74045], [-117.31491, 33.74076], [-117.31494, 33.74106], [-117.3152, 33.74142], [-117.31518, 33.74158], [-117.31022, 33.74163], [-117.31021, 33.7349], [-117.31004, 33.7308], [-117.31109, 33.73079], [-117.31111, 33.73124], [-117.31218, 33.73123], [-117.31232, 33.73491], [-117.31235, 33.73673], [-117.31448, 33.73673], [-117.31453, 33.73853], [-117.31669, 33.73852], [-117.31731, 33.73871], [-117.31749, 33.7388], [-117.3176, 33.73889]]], [[[-117.31506, 33.74212], [-117.31498, 33.74281], [-117.31466, 33.74341], [-117.31466, 33.74368], [-117.31472, 33.74395], [-117.31467, 33.74408], [-117.31471, 33.74421], [-117.31481, 33.74432], [-117.3148, 33.7446], [-117.31458, 33.7448], [-117.31425, 33.74484], [-117.31339, 33.74521], [-117.31311, 33.74535], [-117.31288, 33.74572], [-117.31285, 33.74613], [-117.31302, 33.74649], [-117.31324, 33.7467], [-117.3137, 33.74691], [-117.31383, 33.74731], [-117.3138, 33.74753], [-117.31367, 33.74757], [-117.3136, 33.74783], [-117.31372, 33.74837], [-117.314, 33.74886], [-117.31422, 33.74919], [-117.3142, 33.74942], [-117.31032, 33.74949], [-117.31022, 33.74218], [-117.31506, 33.74212]]], [[[-117.31693, 33.75672], [-117.31471, 33.75675], [-117.31464, 33.75079], [-117.31488, 33.75098], [-117.31518, 33.7513], [-117.31552, 33.75149], [-117.31597, 33.75207], [-117.3161, 33.75232], [-117.31615, 33.75314], [-117.31607, 33.75341], [-117.31611, 33.75354], [-117.31621, 33.7538], [-117.31624, 33.75394], [-117.3165, 33.75429], [-117.3166, 33.75455], [-117.31673, 33.7548], [-117.31682, 33.75507], [-117.31683, 33.75528], [-117.31663, 33.75573], [-117.31692, 33.75583], [-117.31693, 33.75672]]]]} Unknown Access 4 12135 North Peak Preserve 22845 315 Riverside, County of 169 County 3 County Agency 3 http://www.rivcoparks.org/ County 3 315 Riverside, County of 165 County 3 County Agency 3   Riverside 10 193.051 North Peak Preserve 0 Local Conservation Area 4 2
8101 8101 8100 {"type": "Polygon", "coordinates": [[[-117.31018, 33.69849], [-117.30588, 33.69858], [-117.30592, 33.70216], [-117.30153, 33.70223], [-117.30156, 33.69865], [-117.2974, 33.69872], [-117.29732, 33.68915], [-117.30424, 33.68905], [-117.30429, 33.69122], [-117.31014, 33.69113], [-117.31018, 33.69849]]]} Unknown Access 4 12138 Alberhill Conservation Area, Expansion 1 15335 315 Riverside, County of 169 County 3 County Agency 3 http://www.rivcoparks.org/ County 3 315 Riverside, County of 165 County 3 County Agency 3   Riverside 10 317.959 Alberhill Conservation Area, Expansion 1   None 674  
8102 8102 8101 {"type": "Polygon", "coordinates": [[[-117.30415, 33.68905], [-117.29733, 33.68915], [-117.29734, 33.69144], [-117.29287, 33.69151], [-117.29287, 33.69102], [-117.29327, 33.69128], [-117.29388, 33.69128], [-117.29399, 33.69136], [-117.29428, 33.69138], [-117.29457, 33.69129], [-117.29451, 33.69066], [-117.29452, 33.69039], [-117.29447, 33.69031], [-117.2946, 33.69005], [-117.29429, 33.68946], [-117.2946, 33.68922], [-117.29464, 33.68853], [-117.29508, 33.68828], [-117.29535, 33.68806], [-117.29568, 33.68802], [-117.29627, 33.6878], [-117.29667, 33.688], [-117.29688, 33.68832], [-117.29685, 33.68857], [-117.29726, 33.68882], [-117.29762, 33.68881], [-117.29775, 33.68866], [-117.29759, 33.68829], [-117.29711, 33.68815], [-117.29686, 33.68785], [-117.2964, 33.68762], [-117.29645, 33.68722], [-117.29662, 33.687], [-117.29678, 33.68667], [-117.29714, 33.68644], [-117.29761, 33.68597], [-117.29777, 33.68545], [-117.29782, 33.68494], [-117.29802, 33.68468], [-117.29801, 33.68457], [-117.29769, 33.68419], [-117.30405, 33.6841], [-117.30415, 33.68905]]]} Unknown Access 4 12139 Alberhill Conservation Area, Expansion 2 15336 315 Riverside, County of 169 County 3 County Agency 3 http://www.rivcoparks.org/ County 3 315 Riverside, County of 165 County 3 County Agency 3   Riverside 10 109.553 Alberhill Conservation Area, Expansion 2   None 675  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);