units_with_maps

Table actions

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

12 rows where ACCESS_TYP = 1, COUNTY = 2 and DES_TP = 3

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 12 ✖
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
86 86 85 {"type": "MultiPolygon", "coordinates": [[[[-121.14464, 37.45253], [-121.14452, 37.4562], [-121.14113, 37.45496], [-121.14118, 37.45251], [-121.14464, 37.45253]]], [[[-121.14422, 37.45628], [-121.14118, 37.45628], [-121.1412, 37.45516], [-121.1412, 37.45516], [-121.14422, 37.45628]]]]} Open Access 1 225 T.W. Patterson Sports Complex 26158 1248 Patterson, City of 10 City 2 City Agency 2 http://www.ci.patterson.ca.us/ City 2 1248 Patterson, City of 10 City 2 City Agency 2   Stanislaus 2 29.665 T.W. Patterson Sports Complex 0 Local Recreation Area 3 4
103 103 102 {"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 287 Riverbank Sports Complex 24435 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 10.966 Riverbank Sports Complex 0 Local Recreation Area 3 4
2335 2335 2334 {"type": "Polygon", "coordinates": [[[-120.97968, 37.58915], [-120.97831, 37.58915], [-120.97831, 37.58769], [-120.97967, 37.58769], [-120.97972, 37.58896], [-120.97968, 37.58915]]]} Open Access 1 18429 Strawberry Fields Park 25915 1050 Ceres, City of 514 City 2 City Agency 2 http://www.ci.ceres.ca.us/ City 2 1050 Ceres, City of 507 City 2 City Agency 2   Stanislaus 2 4.903 Strawberry Fields Park 0 Local Recreation Area 3 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
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
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
5777 5777 5776 {"type": "Polygon", "coordinates": [[[-120.83709, 37.74748], [-120.83712, 37.74754], [-120.83714, 37.74873], [-120.83713, 37.7489], [-120.83708, 37.74903], [-120.83695, 37.74922], [-120.8368, 37.74935], [-120.83658, 37.74948], [-120.83621, 37.74958], [-120.83463, 37.74956], [-120.83439, 37.74952], [-120.83428, 37.74948], [-120.83403, 37.74934], [-120.83394, 37.74926], [-120.83384, 37.74915], [-120.83373, 37.74897], [-120.83371, 37.74879], [-120.8337, 37.7475], [-120.83378, 37.74745], [-120.83702, 37.74745], [-120.83709, 37.74748]]]} Open Access 1 29 T L Davis Youth Sports Park 26155 1227 Oakdale, City of 2 City 2 City Agency 2 http://www.oakdalegov.com/#!recreation/c222d City 2 1227 Oakdale, City of 2 City 2 City Agency 2   Stanislaus 2 16.658 T L Davis Youth Sports Park 0 Local Recreation Area 3 4
7402 7402 7401 {"type": "Polygon", "coordinates": [[[-120.86774, 37.60385], [-120.86552, 37.60384], [-120.86554, 37.60217], [-120.8656, 37.60212], [-120.8669, 37.60212], [-120.86691, 37.60254], [-120.86681, 37.60254], [-120.86682, 37.60268], [-120.867, 37.60268], [-120.86701, 37.60262], [-120.86773, 37.60261], [-120.86774, 37.60385]]]} Open Access 1 48438 Lebright Fields 33140 1140 Hughson, City of 863 City 2 City Agency 2 http://hughson.org/government/city-departments/parks-and-recreations/ City 2 1140 Hughson, City of 841 City 2 City Agency 2   Stanislaus 2 8.156 Lebright Fields 2018 Local Recreation Area 3 4
10266 10266 10265 {"type": "Polygon", "coordinates": [[[-121.18041, 37.56148], [-121.17609, 37.56266], [-121.17586, 37.56246], [-121.17687, 37.56164], [-121.17721, 37.56192], [-121.18024, 37.56108], [-121.18041, 37.56148]]]} Open Access 1 18218 United Community Center and Park 26664 329 Stanislaus, County of 505 County 3 County Agency 3 http://www.stancounty.com/er/parks/ County 3 329 Stanislaus, County of 497 County 3 County Agency 3   Stanislaus 2 5.043 United Community Ctr. and Park 0 Local Recreation Area 3 4
10814 10814 10813 {"type": "Polygon", "coordinates": [[[-121.14316, 37.4669], [-121.14248, 37.46832], [-121.1421, 37.46825], [-121.14168, 37.46824], [-121.14156, 37.4682], [-121.14111, 37.4682], [-121.14112, 37.46691], [-121.14114, 37.46687], [-121.14258, 37.46679], [-121.14298, 37.46672], [-121.14304, 37.46674], [-121.14316, 37.4669]]]} Open Access 1 48545 City of Patterson Community Complex 33264 1248 Patterson, City of 10 City 2 City Agency 2 http://www.ci.patterson.ca.us/ City 2 1248 Patterson, City of 10 City 2 City Agency 2   Stanislaus 2 6.025 City of Patterson Community Complex 0 Local Recreation Area 3 4
12326 12326 12325 {"type": "MultiPolygon", "coordinates": [[[[-121.04968, 37.68284], [-121.04964, 37.68286], [-121.04072, 37.68546], [-121.04071, 37.68514], [-121.04967, 37.68252], [-121.04968, 37.68284]]], [[[-121.04051, 37.68552], [-121.03338, 37.6876], [-121.03168, 37.68809], [-121.03168, 37.68777], [-121.0405, 37.6852], [-121.04051, 37.68552]]], [[[-121.03142, 37.68816], [-121.02727, 37.68937], [-121.02669, 37.68937], [-121.0267, 37.68922], [-121.03142, 37.68784], [-121.03142, 37.68816]]], [[[-121.02637, 37.68964], [-121.02317, 37.69057], [-121.02251, 37.69076], [-121.0225, 37.69044], [-121.02532, 37.68962], [-121.02637, 37.68964]]], [[[-121.02237, 37.69086], [-121.02159, 37.69113], [-121.02161, 37.69143], [-121.01974, 37.69157], [-121.01781, 37.69213], [-121.01771, 37.69184], [-121.02069, 37.69097], [-121.02069, 37.69137], [-121.02155, 37.69138], [-121.02155, 37.69109], [-121.02237, 37.69079], [-121.02237, 37.69086]]], [[[-121.01761, 37.69219], [-121.01578, 37.69273], [-121.01265, 37.69363], [-121.01264, 37.69331], [-121.01377, 37.69298], [-121.01751, 37.6919], [-121.01761, 37.69219]]], [[[-121.0124, 37.69371], [-121.00845, 37.69486], [-121.00832, 37.69457], [-121.0124, 37.69339], [-121.0124, 37.69371]]], [[[-121.00826, 37.69491], [-121.00639, 37.69546], [-121.00416, 37.6961], [-121.00417, 37.69578], [-121.00813, 37.69463], [-121.00826, 37.69491]]]]} Open Access 1 25993 Hetch Hetchy Trail 19886 1208 Modesto, City of 517 City 2 City Agency 2 http://www.modestogov.com/prnd/ City 2 1208 Modesto, City of 510 City 2 City Agency 2   Stanislaus 2 32.984 Hetch Hetchy Trail 0 Local Recreation Area 3 4
16251 16251 16250 {"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 36543 Community Center Park 31854 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/Community-Center-Veterans-Park-9 Stanislaus 2 3.097 Community Ctr. Park 0 Local Recreation Area 3 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]);