units_with_maps

Table actions

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

30 rows where GAP_STS = 4, MNG_AGENCY = 41 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

MNG_AG_TYP 1

  • City Agency · 30 ✖

MNG_AGENCY 1

  • Turlock, City of · 30 ✖

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
101 101 100 {"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 317 Pedretti Park 23561 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 25.207 Pedretti Park 0 Local Park 2 4
113 113 112 {"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 328 Bothun Park 16292 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 0.451 Bothun Park 0 Local Park 2 4
117 117 116 {"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 349 Christoffersen Park 17230 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 11.803 Christoffersen Park 0 Local Park 2 4
121 121 120 {"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.81869, 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.51175], [-120.82047, 37.51187], [-120.82047, 37.5121]]]} Open Access 1 334 Bristol Park 16401 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 3.933 Bristol Park 0 Local Park 2 4
135 135 134 {"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 344 Central Park 17063 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 0.538 Central Park 0 Local Park 2 4
148 148 147 {"type": "Polygon", "coordinates": [[[-120.85795, 37.51084], [-120.85467, 37.51087], [-120.85467, 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 380 Donnelly Park 18212 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 37.329 Donnelly Park 0 Local Park 2 4
151 151 150 {"type": "Polygon", "coordinates": [[[-120.84027, 37.49579], [-120.83997, 37.49599], [-120.83997, 37.49554], [-120.84027, 37.49579], [-120.84027, 37.49579]]]} Open Access 1 390 Gar Park 19187 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 0.164 Gar Park 0 Local Park 2 4
158 158 157 {"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.53022], [-120.84914, 37.52964], [-120.84934, 37.52949], [-120.84954, 37.52949], [-120.84972, 37.52947], [-120.85131, 37.52948]]]} Open Access 1 404 Rose Circle Park 24607 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 8.682 Rose Circle Park 0 Local Park 2 4
161 161 160 {"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.51911], [-120.8625, 37.52003]]]} Open Access 1 410 Rotary International Park 24685 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 4.977 Rotary International Park 0 Local Park 2 4
162 162 161 {"type": "Polygon", "coordinates": [[[-120.86475, 37.5022], [-120.86469, 37.50228], [-120.86459, 37.50236], [-120.86459, 37.50246], [-120.86464, 37.50252], [-120.86467, 37.50344], [-120.86461, 37.5035], [-120.86437, 37.5035], [-120.8641, 37.50357], [-120.86391, 37.50365], [-120.86378, 37.50374], [-120.86362, 37.50389], [-120.86347, 37.50412], [-120.86342, 37.50435], [-120.86342, 37.50596], [-120.8635, 37.50621], [-120.86358, 37.50634], [-120.86384, 37.50658], [-120.86395, 37.5067], [-120.86403, 37.50681], [-120.86408, 37.50699], [-120.86409, 37.50712], [-120.86403, 37.50717], [-120.86253, 37.50715], [-120.86247, 37.50712], [-120.8625, 37.50223], [-120.86475, 37.5022]]]} Open Access 1 423 Summerfaire Park 25955 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 16.647 Summerfaire Park 0 Local Park 2 4
164 164 163 {"type": "Polygon", "coordinates": [[[-120.83063, 37.48901], [-120.8284, 37.48899], [-120.82841, 37.48718], [-120.83061, 37.4872], [-120.83063, 37.48901]]]} Open Access 1 426 Quaile Rand Norton Park 32562 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 9.749 Quaile Rand Norton Park 0 Local Park 2 4
3212 3212 3211 {"type": "Polygon", "coordinates": [[[-120.84495, 37.50234], [-120.84431, 37.50234], [-120.84432, 37.50155], [-120.84494, 37.50155], [-120.84495, 37.50234]]]} Open Access 1 48066 Brandon Koch Memorial Skate Park 32558 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 1.221 Brandon Koch Memorial Skate Park 0 Local Recreation Area 3 4
4787 4787 4786 {"type": "Polygon", "coordinates": [[[-120.86036, 37.48086], [-120.85915, 37.48087], [-120.85916, 37.48008], [-120.86035, 37.48008], [-120.86036, 37.48086]]]} Open Access 1 48062 Montana Park 32554 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 2.273 Montana Park 2016 Local Park 2 4
5117 5117 5116 {"type": "Polygon", "coordinates": [[[-120.84391, 37.47676], [-120.8439, 37.47694], [-120.84332, 37.47693], [-120.84333, 37.47674], [-120.8434, 37.47668], [-120.84385, 37.47671], [-120.84391, 37.47676]]]} Open Access 1 48072 Tot Lot 32564 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 0.327 Tot Lot 0 Local Recreation Area 3 4
5213 5213 5212 {"type": "Polygon", "coordinates": [[[-120.85675, 37.49166], [-120.85466, 37.49166], [-120.85468, 37.49088], [-120.85532, 37.49088], [-120.85532, 37.49057], [-120.85612, 37.49057], [-120.85613, 37.49088], [-120.85675, 37.4909], [-120.85675, 37.49166]]]} Open Access 1 355 Columbia Park 17548 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 4.548 Columbia Park 0 Local Park 2 4
5522 5522 5521 {"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.52525], [-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 384 Four Seasons Park 19026 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 4.273 Four Seasons Park 0 Local Park 2 4
5529 5529 5528 {"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 395 Markley Park 21875 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 6.503 Markley Park 0 Local Park 2 4
5530 5530 5529 {"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 399 North Turlock Sports Complex 22863 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 30.78 North Turlock Sports Complex 0 Local Recreation Area 3 4
5882 5882 5881 {"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 340 Broadway Park 16408 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 1.782 Broadway Park 0 Local Park 2 4
5905 5905 5904 {"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 360 Crane Park 17758 1358 Turlock, City of 42 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 1358 Turlock, City of 41 City 2 City Agency 2   Stanislaus 2 7.919 Crane Park 0 Local Park 2 4

Next page

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