units_with_maps

Table actions

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

12 rows where AGNCY_NAME = 41 and DES_TP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: COUNTY

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Park · 12 ✖

ACCESS_TYP 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
100 100 99 {"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 269 Staley Park 31853 1278 Riverbank, City of 41 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 1278 Riverbank, City of 40 City 2 City Agency 2 http://www.riverbank.org/facilities/facility/details/Staley-Park-Skate-Park-7 Stanislaus 2 0.663 Staley Park 0 Local Park 2 4
102 102 101 {"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.73915], [-120.94041, 37.73977]]]} Open Access 1 282 Pioneer Park 31852 1278 Riverbank, City of 41 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 1278 Riverbank, City of 40 City 2 City Agency 2   Stanislaus 2 1.761 Pioneer Park 0 Local Park 2 4
109 109 108 {"type": "Polygon", "coordinates": [[[-120.95678, 37.72226], [-120.95665, 37.72275], [-120.95652, 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 296 Silva Park 25481 1278 Riverbank, City of 41 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 1278 Riverbank, City of 40 City 2 City Agency 2   Stanislaus 2 8.173 Silva Park 0 Local Park 2 4
111 111 110 {"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 301 Whorton Park 27483 1278 Riverbank, City of 41 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 1278 Riverbank, City of 40 City 2 City Agency 2   Stanislaus 2 0.959 Whorton Park 0 Local Park 2 4
3750 3750 3749 {"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.94211, 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.94254, 37.74144], [-120.94254, 37.74143], [-120.94211, 37.73997], [-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 310 Zerillo Park 27863 1278 Riverbank, City of 41 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 1278 Riverbank, City of 40 City 2 City Agency 2   Stanislaus 2 5.721 Zerillo Park 0 Local Park 2 4
5773 5773 5772 {"type": "Polygon", "coordinates": [[[-120.94306, 37.74309], [-120.94221, 37.74318], [-120.94227, 37.7434], [-120.94008, 37.74348], [-120.93982, 37.74356], [-120.93983, 37.74365], [-120.93968, 37.74367], [-120.93971, 37.74333], [-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 278 Jacob Myers Park 20327 1278 Riverbank, City of 41 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 1278 Riverbank, City of 40 City 2 City Agency 2   San Joaquin 39 9.672 Jacob Myers Park 0 Local Park 2 4
5872 5872 5871 {"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 256 Castleberg Park 16957 1278 Riverbank, City of 41 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 1278 Riverbank, City of 40 City 2 City Agency 2   Stanislaus 2 12.167 Castleberg Park 0 Local Park 2 4
5881 5881 5880 {"type": "Polygon", "coordinates": [[[-120.93396, 37.73904], [-120.93395, 37.73933], [-120.93238, 37.73902], [-120.93396, 37.73904], [-120.93396, 37.73904]]]} Open Access 1 274 Hutcheson Park 20161 1278 Riverbank, City of 41 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 1278 Riverbank, City of 40 City 2 City Agency 2   Stanislaus 2 0.549 Hutcheson Park 0 Local Park 2 4
5885 5885 5884 {"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 291 Safreno Park 24780 1278 Riverbank, City of 41 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 1278 Riverbank, City of 40 City 2 City Agency 2   Stanislaus 2 5.295 Safreno Park 0 Local Park 2 4
9695 9695 9694 {"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 47893 Rotary Centennial Park 31850 1278 Riverbank, City of 41 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 1278 Riverbank, City of 40 City 2 City Agency 2 http://www.riverbank.org/facilities/facility/details/Rotary-Centennial-Park-11 Stanislaus 2 3.1 Rotary Centennial Park 0 Local Park 2 4
9766 9766 9765 {"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 47894 Harless Park 31851 1278 Riverbank, City of 41 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 1278 Riverbank, City of 40 City 2 City Agency 2 https://www.riverbank.org/Facilities/Facility/Details/Harless-Park-14 Stanislaus 2 3.007 Harless Park 0 Local Park 2 4
13146 13146 13145 {"type": "MultiPolygon", "coordinates": [[[[-120.95132, 37.71586], [-120.95101, 37.71585], [-120.95069, 37.71576], [-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.71418], [-120.94843, 37.71398], [-120.94865, 37.71361], [-120.94872, 37.71341], [-120.94873, 37.71327], [-120.94872, 37.71223], [-120.94887, 37.71219], [-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]]], [[[-120.94887, 37.71187], [-120.94872, 37.71191], [-120.94872, 37.71191], [-120.94872, 37.71187], [-120.94876, 37.71183], [-120.94887, 37.71181], [-120.94887, 37.71187]]]]} Open Access 1 48817 Sorensen Park 33537 1278 Riverbank, City of 41 City 2 City Agency 2 http://www.riverbank.org/Depts/Recreation/default.aspx City 2 1278 Riverbank, City of 40 City 2 City Agency 2 http://www.riverbank.org/facilities/facility/details/Sorensen-Park-12 Stanislaus 2 5.62 Sorensen Park 0 Local Park 2 4

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