units_with_maps

Table actions

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

96 rows where ACCESS_TYP = 1, COUNTY = 37 and DES_TP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY

MNG_AG_TYP 2

DES_TP 1

  • Local Park · 96 ✖

ACCESS_TYP 1

  • Open Access · 96 ✖
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
516 516 515 {"type": "Polygon", "coordinates": [[[-120.62395, 36.98985], [-120.62208, 36.98986], [-120.62208, 36.98902], [-120.62395, 36.98902], [-120.62395, 36.98985]]]} Open Access 1 25989 Pierini Park 23664 1460 Dos Palos, City of 194 City 2 City Agency 2   City 2 1460 Dos Palos, City of 190 City 2 City Agency 2   Merced 37 3.824 Pierini Park 0 Local Park 2 4
527 527 526 {"type": "Polygon", "coordinates": [[[-120.63533, 36.98758], [-120.63434, 36.98758], [-120.63433, 36.98728], [-120.63533, 36.98728], [-120.63533, 36.98758]]]} Open Access 1 25990 Des Park 18106 1460 Dos Palos, City of 194 City 2 City Agency 2   City 2 1460 Dos Palos, City of 190 City 2 City Agency 2   Merced 37 0.735 Des Park 0 Local Park 2 4
595 595 594 {"type": "Polygon", "coordinates": [[[-120.70774, 37.37509], [-120.70769, 37.37584], [-120.70689, 37.37578], [-120.70694, 37.37503], [-120.70774, 37.37509]]]} Open Access 1 48788 Singh Park 33511 1179 Livingston, City of 219 City 2 City Agency 2 http://www.livingstoncity.com/ City 2 1179 Livingston, City of 215 City 2 City Agency 2   Merced 37 1.459 Singh Park 0 Local Park 2 4
2035 2035 2034 {"type": "Polygon", "coordinates": [[[-120.61843, 37.35282], [-120.61826, 37.35311], [-120.61742, 37.3528], [-120.6176, 37.3525], [-120.61843, 37.35282]]]} Open Access 1 17066 Heller Park 19805 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 0.743 Heller Park 0 Local Park 2 4
2037 2037 2036 {"type": "Polygon", "coordinates": [[[-120.57652, 37.35744], [-120.57649, 37.36043], [-120.57413, 37.36044], [-120.57417, 37.35745], [-120.57652, 37.35744]]]} Open Access 1 17077 Veterans Park 27037 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 17.116 Veterans Park 0 Local Park 2 4
2060 2060 2059 {"type": "Polygon", "coordinates": [[[-120.5026, 37.32463], [-120.50255, 37.32632], [-120.49733, 37.32619], [-120.49733, 37.32628], [-120.49619, 37.32625], [-120.49612, 37.32633], [-120.49608, 37.32681], [-120.49667, 37.32683], [-120.49656, 37.32703], [-120.49646, 37.32775], [-120.49506, 37.32776], [-120.49478, 37.32773], [-120.49448, 37.32767], [-120.49415, 37.32753], [-120.49257, 37.32679], [-120.49224, 37.32671], [-120.49198, 37.32668], [-120.49227, 37.32645], [-120.4925, 37.32639], [-120.4938, 37.32607], [-120.49499, 37.32599], [-120.49551, 37.3258], [-120.4955, 37.32517], [-120.49477, 37.32497], [-120.49422, 37.32489], [-120.49382, 37.32488], [-120.48924, 37.32491], [-120.48822, 37.32573], [-120.48823, 37.32621], [-120.48701, 37.32619], [-120.48707, 37.325], [-120.4871, 37.32472], [-120.5026, 37.32463]]]} Open Access 1 17183 Fahrens Park 18783 1203 Merced, City of 474 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 1203 Merced, City of 467 City 2 City Agency 2   Merced 37 49.713 Fahrens Park 0 Local Park 2 4
2061 2061 2060 {"type": "Polygon", "coordinates": [[[-120.48346, 37.28095], [-120.48345, 37.28231], [-120.48218, 37.28228], [-120.48217, 37.28092], [-120.48346, 37.28095]]]} Open Access 1 17190 Flanagan Park 18939 1203 Merced, City of 474 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 1203 Merced, City of 467 City 2 City Agency 2   Merced 37 4.228 Flanagan Park 0 Local Park 2 4
2069 2069 2068 {"type": "Polygon", "coordinates": [[[-120.45486, 37.32488], [-120.45107, 37.32489], [-120.45114, 37.32226], [-120.45128, 37.32237], [-120.45151, 37.32264], [-120.45184, 37.32277], [-120.45213, 37.32281], [-120.4523, 37.32277], [-120.45322, 37.32263], [-120.45421, 37.32265], [-120.4544, 37.32276], [-120.45458, 37.3229], [-120.45448, 37.32309], [-120.45444, 37.32341], [-120.45433, 37.32358], [-120.45409, 37.32381], [-120.45384, 37.32413], [-120.45368, 37.3244], [-120.45359, 37.32461], [-120.45356, 37.32471], [-120.45367, 37.32477], [-120.45419, 37.32473], [-120.45458, 37.32476], [-120.45486, 37.32488]]]} Open Access 1 17208 Rahilly Park 24073 1203 Merced, City of 474 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 1203 Merced, City of 467 City 2 City Agency 2   Merced 37 16.515 Rahilly Park 0 Local Park 2 4
2076 2076 2075 {"type": "MultiPolygon", "coordinates": [[[[-120.48446, 37.30559], [-120.48421, 37.306], [-120.48402, 37.30604], [-120.48391, 37.30609], [-120.48365, 37.30627], [-120.4836, 37.30627], [-120.48269, 37.30595], [-120.48317, 37.30512], [-120.48446, 37.30559]]], [[[-120.48598, 37.30615], [-120.48564, 37.30673], [-120.48546, 37.30672], [-120.48514, 37.30663], [-120.48487, 37.3065], [-120.48464, 37.30635], [-120.48448, 37.30608], [-120.4847, 37.30568], [-120.48598, 37.30615]]]]} Open Access 1 17232 Courthouse Square 17719 308 Merced, County of 476 County 3 County Agency 3 http://www.co.merced.ca.us/index.aspx?NID=757 County 3 308 Merced, County of 469 County 3 County Agency 3   Merced 37 5.112 Courthouse Square 0 Local Park 2 4
2080 2080 2079 {"type": "Polygon", "coordinates": [[[-120.77651, 37.43633], [-120.77555, 37.43632], [-120.77574, 37.43492], [-120.77646, 37.43492], [-120.77651, 37.43633]]]} Open Access 1 17257 Shattuck Park 25374 308 Merced, County of 476 County 3 County Agency 3 http://www.co.merced.ca.us/index.aspx?NID=757 County 3 308 Merced, County of 469 County 3 County Agency 3   Merced 37 2.867 Shattuck Park 0 Local Park 2 4
2081 2081 2080 {"type": "Polygon", "coordinates": [[[-120.61865, 37.39656], [-120.61343, 37.39659], [-120.61347, 37.39483], [-120.61787, 37.39482], [-120.61845, 37.39525], [-120.61865, 37.39656]]]} Open Access 1 17262 Winton Community Park 27658 308 Merced, County of 476 County 3 County Agency 3 http://www.co.merced.ca.us/index.aspx?NID=757 County 3 308 Merced, County of 469 County 3 County Agency 3   Merced 37 21.353 Winton Community Park 0 Local Park 2 4
2324 2324 2323 {"type": "Polygon", "coordinates": [[[-120.58918, 37.34515], [-120.58917, 37.34574], [-120.58912, 37.34686], [-120.58835, 37.34684], [-120.58786, 37.34686], [-120.5876, 37.34684], [-120.58758, 37.34649], [-120.5876, 37.34644], [-120.58761, 37.34609], [-120.58819, 37.34609], [-120.58822, 37.34561], [-120.58823, 37.34513], [-120.58918, 37.34515]]]} Open Access 1 17040 Albiani Park 15342 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 5.058 Albiani Park 0 Local Park 2 4
2340 2340 2339 {"type": "Polygon", "coordinates": [[[-120.58817, 37.35139], [-120.58803, 37.35234], [-120.58724, 37.35357], [-120.58661, 37.35356], [-120.58664, 37.35261], [-120.58532, 37.35254], [-120.58534, 37.35248], [-120.58538, 37.35243], [-120.58547, 37.35208], [-120.58551, 37.35134], [-120.58817, 37.35139]]]} Open Access 1 17063 Faul Park 18853 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 9.972 Faul Park 0 Local Park 2 4
2343 2343 2342 {"type": "Polygon", "coordinates": [[[-120.59246, 37.36059], [-120.59241, 37.3635], [-120.59095, 37.36273], [-120.5894, 37.36117], [-120.58928, 37.36074], [-120.58931, 37.3606], [-120.59246, 37.36059]]]} Open Access 1 17072 Osborn Park 23233 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 14.332 Osborn Park 0 Local Park 2 4
2344 2344 2343 {"type": "MultiPolygon", "coordinates": [[[[-120.60698, 37.34989], [-120.60658, 37.35059], [-120.60568, 37.35024], [-120.60609, 37.34955], [-120.60698, 37.34989]]], [[[-120.60858, 37.35052], [-120.60819, 37.3512], [-120.60683, 37.35068], [-120.60724, 37.34998], [-120.60858, 37.35052]]]]} Open Access 1 17074 Ralston Park 24105 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 4.66 Ralston Park 0 Local Park 2 4
2359 2359 2358 {"type": "Polygon", "coordinates": [[[-121.00338, 37.25772], [-121.0023, 37.25798], [-121.00217, 37.25766], [-121.00186, 37.25773], [-121.00157, 37.25702], [-121.00298, 37.25667], [-121.00309, 37.25667], [-121.00319, 37.25669], [-121.00333, 37.25679], [-121.00337, 37.25685], [-121.00338, 37.25691], [-121.00338, 37.25772]]]} Open Access 1 17127 Henry Miller Park 19826 1127 Gustine, City of 516 City 2 City Agency 2 http://www.cityofgustine.com/pView.aspx?id=13859&catid=649 City 2 1127 Gustine, City of 509 City 2 City Agency 2   Merced 37 4.094 Henry Miller Park 0 Local Park 2 4
2366 2366 2365 {"type": "Polygon", "coordinates": [[[-120.86852, 37.05834], [-120.8685, 37.05835], [-120.86824, 37.05832], [-120.86805, 37.05827], [-120.8679, 37.05819], [-120.86778, 37.05804], [-120.86758, 37.05772], [-120.86761, 37.05771], [-120.86852, 37.05834]]]} Open Access 1 17156 Airport Park 15303 1189 Los Banos, City of 519 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 1189 Los Banos, City of 512 City 2 City Agency 2   Merced 37 0.388 Airport Park 0 Local Park 2 4
2372 2372 2371 {"type": "Polygon", "coordinates": [[[-120.48762, 37.31278], [-120.48744, 37.31322], [-120.48708, 37.31318], [-120.48628, 37.31314], [-120.4856, 37.31321], [-120.48531, 37.31326], [-120.48449, 37.31331], [-120.48401, 37.3133], [-120.48373, 37.31327], [-120.48279, 37.31304], [-120.48243, 37.313], [-120.48224, 37.313], [-120.48161, 37.31306], [-120.4806, 37.31328], [-120.48031, 37.31333], [-120.48017, 37.31333], [-120.47897, 37.31315], [-120.4788, 37.31311], [-120.47863, 37.31304], [-120.4795, 37.31153], [-120.48011, 37.31176], [-120.48037, 37.31133], [-120.48279, 37.31222], [-120.48314, 37.31166], [-120.48462, 37.3122], [-120.48488, 37.31179], [-120.48762, 37.31278]]]} Open Access 1 17174 Applegate Park 15542 1203 Merced, City of 474 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 1203 Merced, City of 467 City 2 City Agency 2   Merced 37 25.808 Applegate Park 0 Local Park 2 4
2373 2373 2372 {"type": "Polygon", "coordinates": [[[-120.45084, 37.32863], [-120.45083, 37.32986], [-120.4489, 37.32986], [-120.4489, 37.32887], [-120.44895, 37.32866], [-120.44899, 37.32859], [-120.45079, 37.32859], [-120.45084, 37.32863]]]} Open Access 1 17177 Bob Carpenter Park 16207 1203 Merced, City of 474 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 1203 Merced, City of 467 City 2 City Agency 2   Merced 37 5.954 Bob Carpenter Park 0 Local Park 2 4
2374 2374 2373 {"type": "Polygon", "coordinates": [[[-120.46587, 37.3165], [-120.46587, 37.31737], [-120.46537, 37.31766], [-120.46535, 37.31792], [-120.46535, 37.31835], [-120.46479, 37.31836], [-120.46481, 37.31765], [-120.46481, 37.3165], [-120.46587, 37.3165]]]} Open Access 1 17180 Burbank Park 16509 1203 Merced, City of 474 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 1203 Merced, City of 467 City 2 City Agency 2   Merced 37 3.754 Burbank 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]);