superunits_with_maps

Table actions

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

32 rows where ACCESS_TYP = 1, MNG_AGENCY = 41 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 32 ✖

MNG_AGENCY 1

  • Turlock, City of · 32 ✖

ACCESS_TYP 1

  • Open Access · 32 ✖
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
1562 1562 1561 {"type": "Polygon", "coordinates": [[[-120.85242, 37.4975], [-120.85158, 37.49809], [-120.85103, 37.4976], [-120.85187, 37.49701], [-120.85242, 37.4975]]]} Open Access 1 Broadway Park   16408 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1.782 Broadway Park  
2067 2067 2066 {"type": "Polygon", "coordinates": [[[-120.8462, 37.49432], [-120.846, 37.49446], [-120.84529, 37.49384], [-120.8455, 37.4937], [-120.8462, 37.49432]]]} Open Access 1 Central Park   17063 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 0.538 Central Park  
2163 2163 2162 {"type": "Polygon", "coordinates": [[[-120.83275, 37.48942], [-120.83182, 37.48941], [-120.83182, 37.48919], [-120.83251, 37.48918], [-120.83275, 37.48942]]]} Open Access 1 Bothun Park   16292 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 0.451 Bothun Park  
2197 2197 2196 {"type": "Polygon", "coordinates": [[[-120.88136, 37.53461], [-120.88115, 37.53479], [-120.88095, 37.53489], [-120.88068, 37.53495], [-120.88041, 37.53495], [-120.88049, 37.53372], [-120.88047, 37.5333], [-120.88062, 37.5336], [-120.88084, 37.53392], [-120.88105, 37.53417], [-120.88134, 37.53445], [-120.88133, 37.53453], [-120.88136, 37.53461]]]} Open Access 1 Brad Bates Park   16322 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1.958 Brad Bates Park  
2266 2266 2265 {"type": "Polygon", "coordinates": [[[-120.82047, 37.5121], [-120.8204, 37.51213], [-120.82023, 37.51213], [-120.81968, 37.512], [-120.81952, 37.51198], [-120.81935, 37.51201], [-120.81911, 37.51208], [-120.81873, 37.51224], [-120.81851, 37.51228], [-120.81832, 37.51227], [-120.81822, 37.51224], [-120.81804, 37.51217], [-120.81804, 37.5121], [-120.81817, 37.51194], [-120.81835, 37.5118], [-120.81868, 37.51157], [-120.81886, 37.51136], [-120.81893, 37.51131], [-120.81903, 37.51125], [-120.81915, 37.51121], [-120.81941, 37.51118], [-120.8197, 37.51121], [-120.81977, 37.51124], [-120.82014, 37.5114], [-120.82027, 37.5115], [-120.82037, 37.51163], [-120.82044, 37.51176], [-120.82047, 37.51187], [-120.82047, 37.5121]]]} Open Access 1 Bristol Park   16401 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 3.932 Bristol Park  
2923 2923 2922 {"type": "Polygon", "coordinates": [[[-120.84436, 37.53193], [-120.84235, 37.53192], [-120.84237, 37.52946], [-120.84402, 37.52949], [-120.84431, 37.52954], [-120.84434, 37.52957], [-120.84436, 37.53193]]]} Open Access 1 Christoffersen Park   17230 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 11.802 Christoffersen Park  
3120 3120 3119 {"type": "Polygon", "coordinates": [[[-120.85675, 37.49166], [-120.85466, 37.49166], [-120.85468, 37.49088], [-120.85531, 37.49088], [-120.85532, 37.49057], [-120.85612, 37.49057], [-120.85614, 37.49088], [-120.85675, 37.4909], [-120.85675, 37.49166]]]} Open Access 1 Columbia Park   17548 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 4.552 Columbia Park  
3287 3287 3286 {"type": "Polygon", "coordinates": [[[-120.83346, 37.50072], [-120.83346, 37.50072], [-120.83084, 37.50259], [-120.83086, 37.50036], [-120.83313, 37.5004], [-120.83346, 37.50072]]]} Open Access 1 Crane Park   17758 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 7.918 Crane Park  
3558 3558 3557 {"type": "Polygon", "coordinates": [[[-120.83929, 37.49929], [-120.83836, 37.49996], [-120.83836, 37.49996], [-120.83834, 37.49928], [-120.83929, 37.49929]]]} Open Access 1 Denair Park   18083 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 0.777 Denair Park  
3611 3611 3610 {"type": "Polygon", "coordinates": [[[-120.8808, 37.50024], [-120.87679, 37.50024], [-120.87679, 37.50016], [-120.87661, 37.50004], [-120.8766, 37.49988], [-120.87658, 37.4998], [-120.87646, 37.49955], [-120.87639, 37.49949], [-120.87634, 37.49942], [-120.87632, 37.49793], [-120.87652, 37.49793], [-120.87654, 37.49792], [-120.87651, 37.49766], [-120.87648, 37.49741], [-120.87645, 37.49733], [-120.87643, 37.49713], [-120.87642, 37.49561], [-120.87868, 37.49562], [-120.87871, 37.49551], [-120.88074, 37.4955], [-120.88077, 37.49712], [-120.88076, 37.49779], [-120.88078, 37.49844], [-120.8808, 37.50024]]]} Open Access 1 Dianne Park   18150 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 49.275 Dianne Park  
3658 3658 3657 {"type": "Polygon", "coordinates": [[[-120.85795, 37.51084], [-120.85467, 37.51087], [-120.85466, 37.51054], [-120.85329, 37.51053], [-120.85332, 37.508], [-120.8533, 37.50783], [-120.85319, 37.50749], [-120.85321, 37.50743], [-120.85506, 37.50741], [-120.85577, 37.50746], [-120.85794, 37.50748], [-120.85795, 37.51084]]]} Open Access 1 Donnelly Park   18212 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 37.329 Donnelly Park  
4212 4212 4211 {"type": "Polygon", "coordinates": [[[-120.8557, 37.53293], [-120.85571, 37.53303], [-120.85565, 37.53511], [-120.85523, 37.53496], [-120.85498, 37.53482], [-120.85405, 37.5341], [-120.85404, 37.53404], [-120.85513, 37.53316], [-120.85543, 37.53301], [-120.8557, 37.53293]]]} Open Access 1 Ferreira Ranch   18885 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 5.042 Ferreira Ranch  
4346 4346 4345 {"type": "Polygon", "coordinates": [[[-120.87312, 37.52606], [-120.87307, 37.5261], [-120.87207, 37.5261], [-120.87192, 37.52599], [-120.87183, 37.52596], [-120.87175, 37.52596], [-120.87168, 37.52599], [-120.87161, 37.52607], [-120.87161, 37.52545], [-120.8719, 37.52544], [-120.87198, 37.52538], [-120.87199, 37.52531], [-120.87199, 37.52526], [-120.87194, 37.52518], [-120.87194, 37.52491], [-120.87197, 37.52481], [-120.87201, 37.52475], [-120.87213, 37.52464], [-120.87231, 37.52458], [-120.87256, 37.52457], [-120.87266, 37.52459], [-120.8728, 37.52467], [-120.87295, 37.52483], [-120.87306, 37.52554], [-120.87313, 37.52583], [-120.87312, 37.52606]]]} Open Access 1 Four Seasons Park   19026 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 4.273 Four Seasons Park  
4476 4476 4475 {"type": "Polygon", "coordinates": [[[-120.84027, 37.49579], [-120.83997, 37.49599], [-120.83997, 37.49554], [-120.83997, 37.49554], [-120.84027, 37.49579]]]} Open Access 1 Gar Park   19187 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 0.164 Gar Park  
6696 6696 6695 {"type": "Polygon", "coordinates": [[[-120.83065, 37.52046], [-120.83065, 37.52154], [-120.83048, 37.52167], [-120.82841, 37.52165], [-120.82836, 37.52161], [-120.82836, 37.52118], [-120.8284, 37.52093], [-120.82851, 37.52077], [-120.82865, 37.52063], [-120.82884, 37.52052], [-120.82909, 37.52043], [-120.82919, 37.52042], [-120.83059, 37.52042], [-120.83065, 37.52046]]]} Open Access 1 Markley Park   21875 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 6.503 Markley Park  
7472 7472 7471 {"type": "Polygon", "coordinates": [[[-120.88049, 37.53372], [-120.88041, 37.53495], [-120.88038, 37.53654], [-120.87582, 37.53652], [-120.87585, 37.53545], [-120.87589, 37.53495], [-120.87593, 37.53376], [-120.88049, 37.53372]]]} Open Access 1 North Turlock Sports Complex   22863 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 30.779 North Turlock Sports Complex  
8055 8055 8054 {"type": "Polygon", "coordinates": [[[-120.88556, 37.52021], [-120.88521, 37.51984], [-120.88476, 37.51929], [-120.88313, 37.51663], [-120.88214, 37.51477], [-120.88239, 37.51468], [-120.88255, 37.51454], [-120.88545, 37.51453], [-120.88545, 37.51814], [-120.88544, 37.51869], [-120.88547, 37.51882], [-120.88554, 37.51896], [-120.88556, 37.52021]]]} Open Access 1 Pedretti Park   23561 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 25.207 Pedretti Park  
8938 8938 8937 {"type": "Polygon", "coordinates": [[[-120.85131, 37.52948], [-120.85129, 37.52985], [-120.8513, 37.53009], [-120.8513, 37.53114], [-120.84914, 37.53115], [-120.84914, 37.53039], [-120.84916, 37.53021], [-120.84914, 37.52964], [-120.84934, 37.52949], [-120.84954, 37.52949], [-120.84972, 37.52947], [-120.85131, 37.52948]]]} Open Access 1 Rose Circle Park   24607 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 8.681 Rose Circle Park  
9010 9010 9009 {"type": "Polygon", "coordinates": [[[-120.8625, 37.52003], [-120.86037, 37.52003], [-120.86039, 37.51965], [-120.86036, 37.51958], [-120.86035, 37.51911], [-120.8604, 37.51907], [-120.86243, 37.51907], [-120.8625, 37.51912], [-120.8625, 37.52003]]]} Open Access 1 Rotary International Park   24685 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 4.976 Rotary International Park  
9033 9033 9032 {"type": "Polygon", "coordinates": [[[-120.86724, 37.50022], [-120.86539, 37.50025], [-120.86541, 37.49801], [-120.86237, 37.49803], [-120.86236, 37.4969], [-120.86414, 37.49687], [-120.8642, 37.49471], [-120.8649, 37.49469], [-120.86489, 37.49284], [-120.86718, 37.49284], [-120.86717, 37.49545], [-120.86721, 37.49685], [-120.86724, 37.50022]]]} Open Access 1 Turlock Memorial Park Cemetery   26582 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 49.4 Turlock Memorial Park Cemetery  

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