superunits_with_maps

Table actions

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

57 rows where ACCESS_TYP = 1, MNG_AGENCY = 185 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 57 ✖

MNG_AGENCY 1

  • Riverside, City of · 57 ✖

ACCESS_TYP 1

  • Open Access · 57 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
30 30 29 {"type": "MultiPolygon", "coordinates": [[[[-117.45748, 33.93032], [-117.45696, 33.93055], [-117.45684, 33.9303], [-117.45635, 33.9303], [-117.45634, 33.92971], [-117.45667, 33.92988], [-117.45692, 33.92988], [-117.45719, 33.92984], [-117.45748, 33.93032]]], [[[-117.46005, 33.93408], [-117.45945, 33.93387], [-117.45903, 33.93388], [-117.45891, 33.93342], [-117.45839, 33.93259], [-117.45813, 33.93269], [-117.45809, 33.93262], [-117.45833, 33.93249], [-117.45785, 33.93171], [-117.45762, 33.93157], [-117.45742, 33.93157], [-117.45754, 33.93125], [-117.45743, 33.93101], [-117.45709, 33.93091], [-117.45701, 33.93071], [-117.45758, 33.93047], [-117.45766, 33.93059], [-117.45798, 33.93077], [-117.45806, 33.93088], [-117.45867, 33.93184], [-117.45891, 33.93175], [-117.45898, 33.93186], [-117.45875, 33.93199], [-117.4592, 33.93271], [-117.45924, 33.93286], [-117.45933, 33.93298], [-117.45956, 33.93287], [-117.45967, 33.93295], [-117.45957, 33.93317], [-117.4598, 33.93348], [-117.45976, 33.93354], [-117.45977, 33.93361], [-117.4598, 33.93366], [-117.45989, 33.93372], [-117.45993, 33.93376], [-117.46002, 33.93393], [-117.46005, 33.93408]]]]} Open Access 1 El Dorado Open Space Park   18503 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 8.445 El Dorado OS Park  
666 666 665 {"type": "Polygon", "coordinates": [[[-117.33029, 33.96071], [-117.33022, 33.96079], [-117.32984, 33.96073], [-117.32966, 33.96063], [-117.32972, 33.96057], [-117.32972, 33.96049], [-117.33009, 33.96027], [-117.33022, 33.96031], [-117.33029, 33.96071]]]} Open Access 1 Kensington Pocket Park https://www.riversideca.gov/park_rec/sites/riversideca.gov.park_rec/files/pdf/Riverside%20Parks_0.pdf 33538 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 0.541 Kensington PP  
667 667 666 {"type": "MultiPolygon", "coordinates": [[[[-117.37087, 33.994], [-117.37078, 33.99435], [-117.37031, 33.99412], [-117.36972, 33.99353], [-117.36958, 33.99334], [-117.36949, 33.99316], [-117.36942, 33.99296], [-117.36939, 33.99277], [-117.36938, 33.99257], [-117.3694, 33.99237], [-117.36946, 33.99218], [-117.36955, 33.99197], [-117.36982, 33.99158], [-117.37012, 33.99184], [-117.36983, 33.99209], [-117.36977, 33.99312], [-117.36986, 33.9934], [-117.37009, 33.99365], [-117.37087, 33.994]]], [[[-117.37087, 33.99581], [-117.37063, 33.99558], [-117.37069, 33.99542], [-117.37072, 33.99526], [-117.37073, 33.99505], [-117.37071, 33.99487], [-117.37066, 33.99469], [-117.3706, 33.99454], [-117.37052, 33.99439], [-117.37041, 33.99424], [-117.37078, 33.99442], [-117.37117, 33.99516], [-117.37118, 33.99526], [-117.37115, 33.99537], [-117.37087, 33.99581]]], [[[-117.39089, 33.99042], [-117.39043, 33.99084], [-117.38686, 33.99507], [-117.3868, 33.99555], [-117.38654, 33.99586], [-117.38657, 33.9959], [-117.38427, 33.99864], [-117.38249, 33.99753], [-117.38234, 33.99761], [-117.38223, 33.99749], [-117.38215, 33.99752], [-117.38192, 33.99733], [-117.3817, 33.99744], [-117.38134, 33.997], [-117.38069, 33.99734], [-117.38051, 33.99749], [-117.38034, 33.99766], [-117.37982, 33.99846], [-117.37976, 33.99852], [-117.37777, 33.99729], [-117.37773, 33.99731], [-117.37699, 33.9973], [-117.37656, 33.99716], [-117.37477, 33.99998], [-117.37442, 33.99975], [-117.37329, 33.99888], [-117.37358, 33.99866], [-117.37363, 33.99866], [-117.37368, 33.99872], [-117.37379, 33.99867], [-117.37356, 33.99832], [-117.37344, 33.99837], [-117.373, 33.99865], [-117.37265, 33.99841], [-117.37237, 33.99824], [-117.37197, 33.99803], [-117.37138, 33.99775], [-117.37116, 33.9976], [-117.37098, 33.99745], [-117.37082, 33.99726], [-117.37074, 33.99714], [-117.37064, 33.99692], [-117.37056, 33.99658], [-117.37179, 33.99475], [-117.37179, 33.99473], [-117.37172, 33.9947], [-117.37218, 33.99403], [-117.37276, 33.99431], [-117.37305, 33.99439], [-117.37325, 33.99441], [-117.37344, 33.99439], [-117.37359, 33.99437], [-117.3738, 33.99429], [-117.37395, 33.99421], [-117.37409, 33.9941], [-117.37421, 33.99398], [-117.37506, 33.99271], [-117.37512, 33.99268], [-117.37519, 33.99268], [-117.37549, 33.99282], [-117.3753, 33.99314], [-117.37651, 33.99369], [-117.37669, 33.99393], [-117.3769, 33.99408], [-117.37685, 33.9942], [-117.37732, 33.99442], [-117.37717, 33.99452], [-117.37707, 33.99455], [-117.37701, 33.99458], [-117.37698, 33.99466], [-117.37699, 33.9947], [-117.37703, 33.99474], [-117.37712, 33.99477], [-117.37721, 33.99475], [-117.37724, 33.99472], [-117.37731, 33.99461], [-117.37749, 33.99448], [-117.37753, 33.99443], [-117.37782, 33.99465], [-117.37789, 33.9946], [-117.37801, 33.99467], [-117.37783, 33.99488], [-117.37766, 33.99533], [-117.37764, 33.99544], [-117.37779, 33.99546], [-117.3779, 33.99516], [-117.37801, 33.99493], [-117.37813, 33.99479], [-117.37869, 33.99428], [-117.37876, 33.99418], [-117.3789, 33.99383], [-117.37904, 33.99362], [-117.37944, 33.9938], [-117.37962, 33.99385], [-117.38049, 33.99381], [-117.3807, 33.99384], [-117.38084, 33.99389], [-117.38091, 33.99378], [-117.3809, 33.99376], [-117.38078, 33.99371], [-117.38057, 33.99367], [-117.38026, 33.99367], [-117.3797, 33.99371], [-117.3796, 33.99371], [-117.37951, 33.99368], [-117.37912, 33.9935], [-117.37937, 33.99312], [-117.38044, 33.99363], [-117.38108, 33.9936], [-117.38137, 33.99371], [-117.38161, 33.99374], [-117.38197, 33.9937], [-117.38214, 33.99358], [-117.38205, 33.9935], [-117.38324, 33.99227], [-117.38375, 33.99209], [-117.38449, 33.99162], [-117.38511, 33.9919], [-117.38617, 33.9913], [-117.38799, 33.98968], [-117.38909, 33.99004], [-117.38943, 33.9901], [-117.39011, 33.99028], [-117.39089, 33.99042]], [[-117.37158, 33.99781], [-117.37159, 33.99782], [-117.3717, 33.99776], [-117.37168, 33.99775], [-117.37158, 33.99781]]]]} Open Access 1 Fairmount Park http://www.riversideca.gov/park_rec/facilities.asp 9451 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 213.104 Fairmount Park  
670 670 669 {"type": "Polygon", "coordinates": [[[-117.46674, 33.9428], [-117.46599, 33.9428], [-117.46595, 33.94279], [-117.46591, 33.94273], [-117.46591, 33.94235], [-117.46674, 33.94235], [-117.46674, 33.9428]]]} Open Access 1 Arlanza Community Garden https://www.riversideca.gov/mayor/fitfreshfunriverside/community.asp 33539 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 0.937 Arlanza Community Garden  
1494 1494 1493 {"type": "Polygon", "coordinates": [[[-117.35103, 33.96113], [-117.35035, 33.96114], [-117.34983, 33.96116], [-117.34982, 33.96112], [-117.34865, 33.96038], [-117.34863, 33.96099], [-117.34849, 33.961], [-117.34849, 33.96038], [-117.34803, 33.95977], [-117.34669, 33.95629], [-117.34676, 33.95612], [-117.34851, 33.95588], [-117.34851, 33.95609], [-117.34852, 33.9561], [-117.34884, 33.95582], [-117.35026, 33.9561], [-117.3503, 33.95661], [-117.35047, 33.95689], [-117.3503, 33.95701], [-117.35022, 33.95758], [-117.35018, 33.95805], [-117.35018, 33.95823], [-117.35026, 33.95848], [-117.35055, 33.9584], [-117.3507, 33.95873], [-117.35049, 33.95894], [-117.35028, 33.95967], [-117.35028, 33.95989], [-117.3503, 33.95993], [-117.35034, 33.95995], [-117.35057, 33.95994], [-117.35086, 33.95982], [-117.35102, 33.96057], [-117.35096, 33.96063], [-117.35103, 33.96113]]]} Open Access 1 Andulka Park   15488 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 36.534 Andulka Park  
1567 1567 1566 {"type": "Polygon", "coordinates": [[[-117.43347, 33.90469], [-117.43345, 33.90471], [-117.43013, 33.90662], [-117.43009, 33.90663], [-117.43006, 33.90661], [-117.42888, 33.90516], [-117.42944, 33.90482], [-117.42825, 33.90334], [-117.4311, 33.90173], [-117.43346, 33.90466], [-117.43347, 33.90469]]]} Open Access 1 Arlington Heights Sports Park Picnic Area   15588 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 34.34 Arlington Heights Sports Park Picnic Area  
1569 1569 1568 {"type": "Polygon", "coordinates": [[[-117.44922, 33.92097], [-117.44787, 33.92173], [-117.4472, 33.9209], [-117.44883, 33.91998], [-117.44921, 33.92046], [-117.44896, 33.92063], [-117.44922, 33.92097]]]} Open Access 1 Arlington Park   15590 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 4.647 Arlington Park  
1960 1960 1959 {"type": "Polygon", "coordinates": [[[-117.3249, 33.88653], [-117.32405, 33.88669], [-117.32397, 33.88641], [-117.32373, 33.88644], [-117.3233, 33.88487], [-117.32336, 33.88494], [-117.32345, 33.88497], [-117.32371, 33.88491], [-117.32477, 33.8849], [-117.3248, 33.88491], [-117.32467, 33.88518], [-117.32464, 33.88533], [-117.32463, 33.88553], [-117.32465, 33.88565], [-117.3249, 33.88653]]]} Open Access 1 Bergmont Park   16021 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 5.032 Bergmont Park  
2104 2104 2103 {"type": "Polygon", "coordinates": [[[-117.35709, 33.97285], [-117.35709, 33.97395], [-117.356, 33.97398], [-117.35595, 33.97467], [-117.35505, 33.97466], [-117.35504, 33.97285], [-117.35709, 33.97285]]]} Open Access 1 Bobby Bonds Park and Sports Complex   16213 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 7.447 Bobby Bonds Park and Sports Complex  
2142 2142 2141 {"type": "Polygon", "coordinates": [[[-117.35709, 33.96642], [-117.35709, 33.96793], [-117.35707, 33.96798], [-117.35703, 33.96801], [-117.35503, 33.96801], [-117.355, 33.96725], [-117.35294, 33.96728], [-117.35296, 33.9646], [-117.35502, 33.96459], [-117.35502, 33.96601], [-117.35509, 33.96605], [-117.35538, 33.96619], [-117.35571, 33.96627], [-117.3565, 33.96639], [-117.35681, 33.96642], [-117.35709, 33.96642]]]} Open Access 1 Bordwell Park   16282 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 23.001 Bordwell Park  
2308 2308 2307 {"type": "Polygon", "coordinates": [[[-117.46151, 33.93868], [-117.46151, 33.93891], [-117.46149, 33.93896], [-117.46143, 33.93898], [-117.45898, 33.93897], [-117.45902, 33.937], [-117.45903, 33.93485], [-117.45964, 33.93506], [-117.46119, 33.93554], [-117.46115, 33.93866], [-117.46151, 33.93868]]]} Open Access 1 Bryant Park   16458 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 20.912 Bryant Park  
2633 2633 2632 {"type": "Polygon", "coordinates": [[[-117.39209, 33.98971], [-117.39155, 33.99036], [-117.39049, 33.99022], [-117.3899, 33.99009], [-117.39089, 33.98988], [-117.39165, 33.98966], [-117.39171, 33.98965], [-117.39172, 33.98967], [-117.39188, 33.98967], [-117.39209, 33.98971]]]} Open Access 1 Carlson Park   16863 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 1.897 Carlson Park  
2694 2694 2693 {"type": "Polygon", "coordinates": [[[-117.34818, 33.93665], [-117.34811, 33.93669], [-117.3475, 33.93651], [-117.34756, 33.93625], [-117.34755, 33.93624], [-117.34586, 33.9359], [-117.34436, 33.93551], [-117.34434, 33.93553], [-117.34434, 33.9358], [-117.34253, 33.93534], [-117.34234, 33.9353], [-117.34208, 33.93528], [-117.34018, 33.93528], [-117.34011, 33.93522], [-117.34011, 33.93487], [-117.34017, 33.93481], [-117.34046, 33.93475], [-117.34074, 33.93466], [-117.34112, 33.93447], [-117.34134, 33.93431], [-117.34216, 33.9336], [-117.34244, 33.93341], [-117.34274, 33.93325], [-117.34317, 33.9331], [-117.34351, 33.93301], [-117.34386, 33.93297], [-117.34435, 33.93296], [-117.34436, 33.93385], [-117.34516, 33.93385], [-117.34628, 33.93481], [-117.34664, 33.93477], [-117.34704, 33.93527], [-117.34732, 33.93509], [-117.34747, 33.93521], [-117.34765, 33.93529], [-117.3478, 33.93532], [-117.34808, 33.93533], [-117.34809, 33.93534], [-117.34809, 33.93618], [-117.3482, 33.93658], [-117.34818, 33.93665]]]} Open Access 1 Castleview Park   16959 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 31.37 Castleview Park  
2825 2825 2824 {"type": "Polygon", "coordinates": [[[-117.45939, 33.92471], [-117.45996, 33.92582], [-117.46002, 33.92601], [-117.46004, 33.92623], [-117.46002, 33.92641], [-117.45998, 33.92658], [-117.45933, 33.92831], [-117.45763, 33.92787], [-117.45744, 33.92783], [-117.45553, 33.92783], [-117.45536, 33.92785], [-117.45518, 33.92791], [-117.45519, 33.92631], [-117.45527, 33.92629], [-117.45526, 33.92568], [-117.45773, 33.92493], [-117.45804, 33.92488], [-117.45891, 33.92481], [-117.45916, 33.92477], [-117.45939, 33.92471]]]} Open Access 1 Challen Hill Park   17115 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 33.133 Challen Hill Park  
3103 3103 3102 {"type": "Polygon", "coordinates": [[[-117.48066, 33.91287], [-117.48064, 33.91295], [-117.47958, 33.9135], [-117.47841, 33.91207], [-117.47877, 33.91192], [-117.47881, 33.91196], [-117.47887, 33.91198], [-117.47899, 33.91197], [-117.47904, 33.91192], [-117.47912, 33.9118], [-117.4792, 33.91173], [-117.47953, 33.91154], [-117.47959, 33.91155], [-117.48066, 33.91287]]]} Open Access 1 Collett Park   17517 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 5.616 Collett Park  
3440 3440 3439 {"type": "Polygon", "coordinates": [[[-117.36263, 33.97145], [-117.36167, 33.97146], [-117.36167, 33.97143], [-117.36207, 33.97141], [-117.36206, 33.97072], [-117.36167, 33.97071], [-117.36167, 33.97062], [-117.36175, 33.97047], [-117.36181, 33.97046], [-117.36219, 33.97059], [-117.36224, 33.97066], [-117.3625, 33.97097], [-117.36262, 33.97106], [-117.36263, 33.97145]]]} Open Access 1 Dario Vasquez Park   17926 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 1.2 Dario Vasquez Park  
3651 3651 3650 {"type": "Polygon", "coordinates": [[[-117.42388, 33.91938], [-117.41909, 33.92211], [-117.41862, 33.92237], [-117.41949, 33.92047], [-117.41964, 33.92019], [-117.41975, 33.92002], [-117.42093, 33.91887], [-117.42114, 33.91856], [-117.42201, 33.91709], [-117.42388, 33.91938]]]} Open Access 1 Don Derr Park   18202 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 23.991 Don Derr Park  
3653 3653 3652 {"type": "Polygon", "coordinates": [[[-117.41925, 33.9404], [-117.41735, 33.94148], [-117.41678, 33.94078], [-117.41675, 33.94072], [-117.41676, 33.94066], [-117.41681, 33.9406], [-117.41858, 33.93959], [-117.41925, 33.9404]]]} Open Access 1 Don Jones Park   18205 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 5.714 Don Jones Park  
3654 3654 3653 {"type": "Polygon", "coordinates": [[[-117.44729, 33.93129], [-117.44564, 33.93223], [-117.44557, 33.93222], [-117.44446, 33.93087], [-117.44445, 33.93083], [-117.44448, 33.93079], [-117.44622, 33.92979], [-117.44646, 33.93007], [-117.44651, 33.93028], [-117.44658, 33.93041], [-117.44729, 33.93129]]]} Open Access 1 Don Lorenzi Sports Park   18207 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 9.203 Don Lorenzi Sports Park  
3656 3656 3655 {"type": "Polygon", "coordinates": [[[-117.44487, 33.92816], [-117.44309, 33.92917], [-117.44256, 33.92851], [-117.44257, 33.92847], [-117.44432, 33.92748], [-117.44487, 33.92816]]]} Open Access 1 Don Lorenzi Sports Center   18206 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 4.491 Don Lorenzi Sports Ctr.  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);