superunits_with_maps

Table actions

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

33 rows where MNG_AGENCY = 467

This data as json, copyable, CSV (advanced)

Suggested facets: PARK_URL

MNG_AG_TYP 1

MNG_AGENCY 1

  • Merced, City of · 33 ✖

ACCESS_TYP 1

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
956 956 955 {"type": "Polygon", "coordinates": [[[-120.52536, 37.32598], [-120.52391, 37.32599], [-120.52384, 37.32593], [-120.52386, 37.32508], [-120.52382, 37.32494], [-120.52374, 37.32475], [-120.52371, 37.32464], [-120.52376, 37.32459], [-120.52445, 37.32459], [-120.52446, 37.32503], [-120.52536, 37.32503], [-120.52536, 37.32598]]]} Open Access 1 Drake Avenue Park   33589 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 4.224 Drake Avenue Park  
1131 1131 1130 {"type": "Polygon", "coordinates": [[[-120.47399, 37.35291], [-120.47387, 37.35298], [-120.4733, 37.35322], [-120.47278, 37.35349], [-120.47297, 37.35373], [-120.47251, 37.354], [-120.47241, 37.35399], [-120.47215, 37.35365], [-120.47194, 37.35328], [-120.47178, 37.35289], [-120.47184, 37.35283], [-120.47241, 37.35276], [-120.47399, 37.35275], [-120.47399, 37.35291]]]} Open Access 1 Elmer Murchie Park   32871 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 3.541 Elmer Murchie Park  
1403 1403 1402 {"type": "Polygon", "coordinates": [[[-120.45419, 37.30635], [-120.45368, 37.30715], [-120.45136, 37.30715], [-120.45137, 37.30635], [-120.45419, 37.30635]]]} Open Access 1 Ada Givens Park   15254 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 4.994 Ada Givens Park  
1522 1522 1521 {"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.31305], [-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.48461, 37.3122], [-120.48488, 37.31179], [-120.48762, 37.31278]]]} Open Access 1 Applegate Park   15542 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 25.82 Applegate Park  
1953 1953 1952 {"type": "Polygon", "coordinates": [[[-120.50555, 37.29161], [-120.50555, 37.29165], [-120.50529, 37.29156], [-120.50523, 37.29164], [-120.504, 37.29119], [-120.50379, 37.29152], [-120.50367, 37.29147], [-120.50412, 37.29068], [-120.50444, 37.29079], [-120.50426, 37.29113], [-120.50468, 37.29129], [-120.50469, 37.29131], [-120.5049, 37.29138], [-120.50492, 37.29138], [-120.50555, 37.29161]]]} Open Access 1 Benjamin Banneker Memorial Park   16013 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 0.977 Benjamin Banneker Memorial Park  
2099 2099 2098 {"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 Bob Carpenter Park   16207 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 5.953 Bob Carpenter Park  
2359 2359 2358 {"type": "Polygon", "coordinates": [[[-120.46587, 37.3165], [-120.46587, 37.31737], [-120.46538, 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 Burbank Park   16509 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 3.755 Burbank Park  
2611 2611 2610 {"type": "Polygon", "coordinates": [[[-120.49516, 37.33647], [-120.49512, 37.33651], [-120.49363, 37.33653], [-120.49356, 37.33652], [-120.49344, 37.33648], [-120.49326, 37.33649], [-120.49313, 37.33655], [-120.49309, 37.33658], [-120.49305, 37.33665], [-120.49305, 37.33673], [-120.49312, 37.33691], [-120.49313, 37.33724], [-120.49308, 37.33729], [-120.49169, 37.33729], [-120.49151, 37.33731], [-120.49118, 37.3374], [-120.49074, 37.33762], [-120.49069, 37.33757], [-120.4925, 37.33673], [-120.49234, 37.33648], [-120.49227, 37.33648], [-120.49225, 37.33643], [-120.49196, 37.33608], [-120.49195, 37.33603], [-120.49192, 37.33598], [-120.49182, 37.33592], [-120.49182, 37.33566], [-120.49497, 37.33562], [-120.49505, 37.33564], [-120.49513, 37.33571], [-120.49514, 37.33579], [-120.49516, 37.33647]]]} Open Access 1 Rudolph Joseph Merino Neighborhood Park https://www.cityofmerced.org/Home/Components/FacilityDirectory/FacilityDirectory/48/3557 33623 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 8.812 Rudolph Joseph Merino Neighborhood Park  
2850 2850 2849 {"type": "Polygon", "coordinates": [[[-120.4915, 37.2933], [-120.49129, 37.29367], [-120.49082, 37.2935], [-120.49103, 37.29312], [-120.4915, 37.2933]]]} Open Access 1 Charles Richard Drew Park   17141 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 0.516 Charles Richard Drew Park  
2945 2945 2944 {"type": "Polygon", "coordinates": [[[-120.46511, 37.30208], [-120.46498, 37.30229], [-120.46491, 37.30233], [-120.46484, 37.30233], [-120.46474, 37.30229], [-120.46471, 37.30225], [-120.4647, 37.30219], [-120.46481, 37.30199], [-120.46488, 37.30196], [-120.46508, 37.30203], [-120.46511, 37.30208]]]} Open Access 1 Circle Drive Park   17262 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 0.245 Circle Drive Park  
3453 3453 3452 {"type": "Polygon", "coordinates": [[[-120.45683, 37.33995], [-120.45637, 37.33993], [-120.45612, 37.33986], [-120.45579, 37.3397], [-120.45557, 37.33956], [-120.45533, 37.33946], [-120.45505, 37.33936], [-120.45469, 37.33931], [-120.45401, 37.33931], [-120.45403, 37.33859], [-120.45463, 37.33855], [-120.45505, 37.33842], [-120.45638, 37.33845], [-120.45647, 37.33853], [-120.45669, 37.33865], [-120.45678, 37.33875], [-120.45683, 37.33995]]]} Open Access 1 Davenport Park   17940 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 7.283 Davenport Park  
3561 3561 3560 {"type": "MultiPolygon", "coordinates": [[[[-120.50386, 37.30145], [-120.50368, 37.30177], [-120.5034, 37.30167], [-120.50358, 37.30135], [-120.50386, 37.30145]]], [[[-120.50419, 37.30157], [-120.50401, 37.30189], [-120.50371, 37.30178], [-120.50389, 37.30146], [-120.50419, 37.30157]]]]} Open Access 1 Dennis Chavez Park   18088 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 0.543 Dennis Chavez Park  
3613 3613 3612 {"type": "Polygon", "coordinates": [[[-120.49375, 37.29584], [-120.49364, 37.29603], [-120.49319, 37.29587], [-120.4933, 37.29568], [-120.49375, 37.29584]]]} Open Access 1 Diego Rivera Park   18153 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 0.253 Diego Rivera Park  
3953 3953 3952 {"type": "MultiPolygon", "coordinates": [[[[-120.48044, 37.3308], [-120.48043, 37.33102], [-120.47957, 37.33103], [-120.47936, 37.33099], [-120.47933, 37.33122], [-120.47925, 37.33123], [-120.47913, 37.33095], [-120.47891, 37.33092], [-120.47889, 37.33086], [-120.47856, 37.33086], [-120.47855, 37.33077], [-120.47916, 37.3308], [-120.47927, 37.33059], [-120.47937, 37.33058], [-120.47939, 37.33085], [-120.47958, 37.33078], [-120.48044, 37.3308]]], [[[-120.4793, 37.32869], [-120.47929, 37.32887], [-120.4786, 37.32886], [-120.47861, 37.32869], [-120.4793, 37.32869]]], [[[-120.48191, 37.32963], [-120.48164, 37.32966], [-120.48163, 37.32947], [-120.48171, 37.32924], [-120.4817, 37.32879], [-120.48157, 37.32866], [-120.48138, 37.32884], [-120.48131, 37.32881], [-120.48136, 37.32859], [-120.48105, 37.32859], [-120.4808, 37.32878], [-120.48031, 37.32878], [-120.48021, 37.32879], [-120.48026, 37.32899], [-120.4802, 37.32901], [-120.48002, 37.32883], [-120.47985, 37.32888], [-120.47951, 37.32886], [-120.47952, 37.32874], [-120.48006, 37.32871], [-120.4805, 37.32863], [-120.48106, 37.32847], [-120.48106, 37.32826], [-120.48081, 37.32825], [-120.4808, 37.32818], [-120.48107, 37.32809], [-120.48095, 37.32774], [-120.48112, 37.32754], [-120.48112, 37.32741], [-120.48082, 37.32746], [-120.4808, 37.3274], [-120.48115, 37.32719], [-120.48117, 37.32678], [-120.48125, 37.32673], [-120.48112, 37.32649], [-120.48123, 37.32645], [-120.48137, 37.32642], [-120.4813, 37.32829], [-120.48191, 37.32831], [-120.48192, 37.32892], [-120.48191, 37.32963]]], [[[-120.48253, 37.33198], [-120.48223, 37.33198], [-120.48223, 37.33129], [-120.48197, 37.33132], [-120.48193, 37.33125], [-120.48216, 37.3311], [-120.48208, 37.33091], [-120.48177, 37.33097], [-120.48136, 37.33103], [-120.48067, 37.33103], [-120.48068, 37.33081], [-120.48113, 37.33081], [-120.48165, 37.33085], [-120.48203, 37.33078], [-120.48196, 37.33061], [-120.48164, 37.33053], [-120.48163, 37.33047], [-120.48188, 37.3304], [-120.48175, 37.33011], [-120.48174, 37.32983], [-120.4823, 37.32978], [-120.48241, 37.3303], [-120.48263, 37.33096], [-120.48262, 37.33118], [-120.48253, 37.33163], [-120.48253, 37.33198]]]]} Open Access 1 Santa Fe Strip Park https://www.cityofmerced.org/Home/Components/FacilityDirectory/FacilityDirectory/26/3556 33624 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 7.781 Santa Fe Strip Park  
3958 3958 3957 {"type": "Polygon", "coordinates": [[[-120.43929, 37.329], [-120.43929, 37.32952], [-120.43925, 37.32958], [-120.4392, 37.3296], [-120.43809, 37.3296], [-120.43785, 37.32954], [-120.4377, 37.32947], [-120.43758, 37.32938], [-120.43748, 37.32927], [-120.43739, 37.32908], [-120.43738, 37.32895], [-120.43738, 37.32783], [-120.43739, 37.32779], [-120.43743, 37.32776], [-120.43749, 37.32774], [-120.4389, 37.32775], [-120.4389, 37.32899], [-120.43929, 37.329]]]} Open Access 1 Richard Bernasconi Neighborhood Park   33625 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 7.143 Richard Bernasconi Neighborhood Park  
4120 4120 4119 {"type": "Polygon", "coordinates": [[[-120.5026, 37.32463], [-120.50255, 37.32632], [-120.49734, 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.4955, 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 Fahrens Park   18783 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 49.729 Fahrens Park  
4243 4243 4242 {"type": "MultiPolygon", "coordinates": [[[[-120.47664, 37.28434], [-120.47574, 37.28433], [-120.47574, 37.28253], [-120.47664, 37.28254], [-120.47664, 37.28434]]], [[[-120.48346, 37.28095], [-120.48345, 37.28231], [-120.48218, 37.28228], [-120.48217, 37.28092], [-120.48346, 37.28095]]]]} Open Access 1 Flanagan Park   18939 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 8.183 Flanagan Park  
4918 4918 4917 {"type": "Polygon", "coordinates": [[[-120.49486, 37.28895], [-120.49462, 37.28936], [-120.49421, 37.28921], [-120.49439, 37.2889], [-120.49456, 37.28896], [-120.49463, 37.28887], [-120.49486, 37.28895]]]} Open Access 1 Harriet Tubman Park   19693 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 0.447 Harriet Tubman Park  
5538 5538 5537 {"type": "MultiPolygon", "coordinates": [[[[-120.44838, 37.29479], [-120.44838, 37.29502], [-120.44834, 37.29505], [-120.44707, 37.29505], [-120.44707, 37.29497], [-120.44796, 37.29497], [-120.4481, 37.29492], [-120.44827, 37.29478], [-120.44837, 37.29478], [-120.44838, 37.29479]]], [[[-120.45142, 37.29149], [-120.45142, 37.29155], [-120.4512, 37.29155], [-120.45119, 37.29169], [-120.45142, 37.29171], [-120.45141, 37.29302], [-120.45129, 37.29304], [-120.45129, 37.29327], [-120.45141, 37.29329], [-120.45141, 37.29332], [-120.44935, 37.29332], [-120.44933, 37.29374], [-120.44865, 37.29375], [-120.44864, 37.29502], [-120.44855, 37.29501], [-120.44854, 37.29456], [-120.4484, 37.29456], [-120.44838, 37.29461], [-120.44835, 37.29464], [-120.44819, 37.29466], [-120.448, 37.29481], [-120.44793, 37.29483], [-120.44707, 37.29483], [-120.44709, 37.29149], [-120.45142, 37.29149]]]]} Open Access 1 Joe Herb Park   20419 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 25.748 Joe Herb Park  
6495 6495 6494 {"type": "Polygon", "coordinates": [[[-120.48172, 37.28829], [-120.4811, 37.28936], [-120.478, 37.28823], [-120.478, 37.28823], [-120.48172, 37.28829]]]} Open Access 1 Macias Park   21633 1203 Merced, City of 467 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 4.911 Macias Park  

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