superunits_with_maps

Table actions

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

15 rows where MNG_AGENCY = 40 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 15 ✖

MNG_AGENCY 1

  • Riverbank, City of · 15 ✖

ACCESS_TYP 1

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
165 165 164 {"type": "Polygon", "coordinates": [[[-120.93077, 37.73589], [-120.92905, 37.73587], [-120.92904, 37.73514], [-120.93077, 37.73514], [-120.93077, 37.73589]]]} Open Access 1 Community Center Park https://www.riverbank.org/Facilities/Facility/Details/Community-Center-Veterans-Park-9 31854 1278 Riverbank, City of 40 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 3.096 Community Ctr. Park  
170 170 169 {"type": "Polygon", "coordinates": [[[-120.94402, 37.72135], [-120.94378, 37.72263], [-120.94364, 37.72261], [-120.94344, 37.72254], [-120.94332, 37.72247], [-120.94323, 37.72238], [-120.94295, 37.72195], [-120.94286, 37.72178], [-120.94273, 37.72141], [-120.9432, 37.72103], [-120.94338, 37.72114], [-120.94358, 37.72124], [-120.94379, 37.72131], [-120.94402, 37.72135]]]} Open Access 1 Rotary Centennial Park http://www.riverbank.org/facilities/facility/details/Rotary-Centennial-Park-11 31850 1278 Riverbank, City of 40 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 3.1 Rotary Centennial Park  
172 172 171 {"type": "Polygon", "coordinates": [[[-120.93452, 37.7213], [-120.93422, 37.72138], [-120.93289, 37.71818], [-120.9332, 37.71818], [-120.93363, 37.71921], [-120.93373, 37.71935], [-120.93401, 37.71963], [-120.93418, 37.71988], [-120.93426, 37.72006], [-120.9343, 37.72025], [-120.93431, 37.72044], [-120.93429, 37.7207], [-120.93432, 37.72086], [-120.9344, 37.72107], [-120.93439, 37.72119], [-120.93444, 37.72127], [-120.93452, 37.7213]]]} Open Access 1 Harless Park https://www.riverbank.org/Facilities/Facility/Details/Harless-Park-14 31851 1278 Riverbank, City of 40 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 3.007 Harless Park  
173 173 172 {"type": "Polygon", "coordinates": [[[-120.93957, 37.73594], [-120.93907, 37.73593], [-120.93908, 37.73512], [-120.9392, 37.73504], [-120.93957, 37.73594]]]} Open Access 1 Staley Park http://www.riverbank.org/facilities/facility/details/Staley-Park-Skate-Park-7 31853 1278 Riverbank, City of 40 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 0.662 Staley Park  
174 174 173 {"type": "Polygon", "coordinates": [[[-120.93555, 37.73614], [-120.93555, 37.73649], [-120.93528, 37.73649], [-120.93528, 37.73614], [-120.93555, 37.73614]]]} Open Access 1 Plaza del Rio https://www.riverbank.org/Facilities/Facility/Details/Plaza-Del-Rio-16 31855 1278 Riverbank, City of 40 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 0.223 Plaza del Rio  
669 669 668 {"type": "Polygon", "coordinates": [[[-120.95132, 37.71586], [-120.95101, 37.71585], [-120.95069, 37.71577], [-120.95058, 37.71607], [-120.94989, 37.71593], [-120.94967, 37.7159], [-120.94942, 37.71589], [-120.94937, 37.71585], [-120.94933, 37.71573], [-120.94928, 37.71562], [-120.94915, 37.71544], [-120.94904, 37.71533], [-120.94864, 37.71506], [-120.94848, 37.71489], [-120.94841, 37.71476], [-120.94838, 37.71462], [-120.94837, 37.71419], [-120.94843, 37.71398], [-120.94865, 37.71361], [-120.94872, 37.71341], [-120.94873, 37.71327], [-120.94872, 37.71187], [-120.94876, 37.71183], [-120.94887, 37.71181], [-120.94889, 37.71409], [-120.94893, 37.71424], [-120.94903, 37.71444], [-120.94914, 37.71456], [-120.94925, 37.71466], [-120.94927, 37.71465], [-120.94927, 37.71462], [-120.95042, 37.71555], [-120.95057, 37.71565], [-120.95073, 37.71573], [-120.95091, 37.71578], [-120.9511, 37.71581], [-120.95132, 37.71582], [-120.95132, 37.71586]]]} Open Access 1 Sorensen Park http://www.riverbank.org/facilities/facility/details/Sorensen-Park-12 33537 1278 Riverbank, City of 40 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 5.739 Sorensen Park  
2692 2692 2691 {"type": "Polygon", "coordinates": [[[-120.92888, 37.72501], [-120.92786, 37.725], [-120.92787, 37.72535], [-120.92678, 37.72536], [-120.92672, 37.72281], [-120.92884, 37.7228], [-120.92888, 37.72501]]]} Open Access 1 Castleberg Park   16957 1278 Riverbank, City of 40 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 12.169 Castleberg Park  
5310 5310 5309 {"type": "Polygon", "coordinates": [[[-120.93396, 37.73904], [-120.93395, 37.73933], [-120.93238, 37.73902], [-120.93238, 37.73902], [-120.93396, 37.73904]]]} Open Access 1 Hutcheson Park   20161 1278 Riverbank, City of 40 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 0.549 Hutcheson Park  
5458 5458 5457 {"type": "Polygon", "coordinates": [[[-120.94306, 37.74309], [-120.94222, 37.74318], [-120.94227, 37.7434], [-120.94008, 37.74348], [-120.93983, 37.74356], [-120.93983, 37.74365], [-120.93968, 37.74367], [-120.93971, 37.74334], [-120.93951, 37.74331], [-120.93971, 37.74196], [-120.94093, 37.74208], [-120.94189, 37.74222], [-120.94199, 37.74249], [-120.94287, 37.74245], [-120.94306, 37.74309]]]} Open Access 1 Jacob Myers Park   20327 1278 Riverbank, City of 40 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 9.679 Jacob Myers Park  
8775 8775 8774 {"type": "Polygon", "coordinates": [[[-120.96209, 37.72901], [-120.96038, 37.72734], [-120.96038, 37.72548], [-120.96205, 37.72549], [-120.96209, 37.72901]]]} Open Access 1 Riverbank Sports Complex   24435 1278 Riverbank, City of 40 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 10.965 Riverbank Sports Complex  
9094 9094 9093 {"type": "Polygon", "coordinates": [[[-120.9562, 37.72867], [-120.95452, 37.72867], [-120.95453, 37.72811], [-120.95457, 37.72798], [-120.95456, 37.72791], [-120.95452, 37.72786], [-120.9545, 37.72755], [-120.95558, 37.72727], [-120.95588, 37.72716], [-120.95609, 37.7274], [-120.95612, 37.72746], [-120.95618, 37.72753], [-120.95619, 37.7276], [-120.95621, 37.72848], [-120.9562, 37.72857], [-120.9562, 37.72867]]]} Open Access 1 Safreno Park   24780 1278 Riverbank, City of 40 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 5.294 Safreno Park  
9668 9668 9667 {"type": "Polygon", "coordinates": [[[-120.95678, 37.72226], [-120.95665, 37.72275], [-120.95653, 37.72305], [-120.95633, 37.72333], [-120.95606, 37.72359], [-120.95585, 37.72375], [-120.95567, 37.72385], [-120.95531, 37.724], [-120.95501, 37.72408], [-120.95481, 37.72412], [-120.95457, 37.72414], [-120.95451, 37.7241], [-120.95448, 37.72234], [-120.95449, 37.72231], [-120.95458, 37.72224], [-120.95463, 37.72222], [-120.95673, 37.72222], [-120.95678, 37.72226]]]} Open Access 1 Silva Park   25481 1278 Riverbank, City of 40 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 8.173 Silva Park 0
11195 11195 11194 {"type": "Polygon", "coordinates": [[[-120.93366, 37.72786], [-120.93363, 37.72791], [-120.93302, 37.72791], [-120.93301, 37.72736], [-120.93306, 37.72723], [-120.9332, 37.72706], [-120.93326, 37.72702], [-120.93332, 37.72705], [-120.93366, 37.72786]]]} Open Access 1 Whorton Park   27483 1278 Riverbank, City of 40 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 0.959 Whorton Park  
11510 11510 11509 {"type": "Polygon", "coordinates": [[[-120.94386, 37.73879], [-120.94314, 37.73885], [-120.94287, 37.73891], [-120.94263, 37.73902], [-120.94225, 37.73926], [-120.94216, 37.7393], [-120.94209, 37.73937], [-120.94207, 37.73943], [-120.94207, 37.73949], [-120.94212, 37.73957], [-120.94271, 37.74155], [-120.94263, 37.74162], [-120.94258, 37.74163], [-120.94248, 37.74161], [-120.94226, 37.74155], [-120.94204, 37.74153], [-120.94253, 37.74144], [-120.94254, 37.74142], [-120.94212, 37.73998], [-120.94189, 37.73997], [-120.94169, 37.7393], [-120.94138, 37.7393], [-120.9411, 37.73836], [-120.94174, 37.73838], [-120.94238, 37.73837], [-120.94323, 37.73832], [-120.94379, 37.73826], [-120.94386, 37.73879]]]} Open Access 1 Zerillo Park   27863 1278 Riverbank, City of 40 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 5.725 Zerillo Park  
13143 13143 13142 {"type": "Polygon", "coordinates": [[[-120.94041, 37.73977], [-120.93977, 37.73977], [-120.93976, 37.73954], [-120.93952, 37.73938], [-120.93908, 37.73937], [-120.93907, 37.73903], [-120.94036, 37.73903], [-120.9404, 37.73916], [-120.94041, 37.73977]]]} Open Access 1 Pioneer Park   31852 1278 Riverbank, City of 40 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 1.762 Pioneer Park  

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