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

23 rows where MNG_AGENCY = 596

View and edit SQL

MNG_AG_TYP

MNG_AGENCY

  • Calexico, City of · 23

ACCESS_TYP

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
5 4 {"type": "Polygon", "coordinates": [[[-115.49103, 32.68828], [-115.49059, 32.68816], [-115.48996, 32.68793], [-115.48966, 32.68785], [-115.48947, 32.68784], [-115.48945, 32.68778], [-115.48946, 32.68677], [-115.49041, 32.68677], [-115.49042, 32.6874], [-115.49103, 32.6874], [-115.49103, 32.68828]]]} Open Access 1 Kennedy Gardens Large   33476 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 4.156 Kennedy Gardens Large  
1149 1148 {"type": "Polygon", "coordinates": [[[-115.50404, 32.66996], [-115.50403, 32.67085], [-115.50251, 32.67088], [-115.50227, 32.67028], [-115.50227, 32.66996], [-115.50404, 32.66996]]]} Open Access 1 American Legion Softball Field   15453 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 3.933 American Legion Softball Field  
2158 2157 {"type": "Polygon", "coordinates": [[[-115.49853, 32.66622], [-115.4981, 32.66622], [-115.4981, 32.66614], [-115.49806, 32.66612], [-115.49765, 32.66611], [-115.49765, 32.66571], [-115.49797, 32.66571], [-115.49821, 32.66584], [-115.49835, 32.66594], [-115.49842, 32.66601], [-115.4985, 32.66613], [-115.49853, 32.66622]]]} Open Access 1 Border Friendship Park   16279 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 0.77 Border Friendship Park  
2495 2494 {"type": "Polygon", "coordinates": [[[-115.48723, 32.672], [-115.48723, 32.67277], [-115.48625, 32.67276], [-115.48625, 32.672], [-115.48723, 32.672]]]} Open Access 1 Calexico holding 1   16681 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1.937 Calexico holding 1  
2720 2719 {"type": "Polygon", "coordinates": [[[-115.46973, 32.6904], [-115.46973, 32.69168], [-115.46968, 32.69172], [-115.46807, 32.69172], [-115.46807, 32.69039], [-115.46973, 32.6904]]]} Open Access 1 Ceasar Chavez Park   16989 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 5.65 Ceasar Chavez Park  
3362 3361 {"type": "Polygon", "coordinates": [[[-115.48727, 32.67578], [-115.48625, 32.6758], [-115.48625, 32.67464], [-115.48727, 32.67463], [-115.48727, 32.67578]]]} Open Access 1 Crummett Park   17840 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 3.029 Crummett Park  
3985 3984 {"type": "Polygon", "coordinates": [[[-115.49511, 32.6772], [-115.49465, 32.6772], [-115.49464, 32.67736], [-115.49442, 32.67736], [-115.49442, 32.67694], [-115.49437, 32.67693], [-115.49428, 32.67703], [-115.49416, 32.67713], [-115.49403, 32.6772], [-115.49382, 32.67724], [-115.49353, 32.67723], [-115.49353, 32.67649], [-115.49511, 32.67649], [-115.49511, 32.6772]]]} Open Access 1 Emerson Field   18621 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 2.894 Emerson Field  
4966 4965 {"type": "Polygon", "coordinates": [[[-115.51124, 32.68437], [-115.5097, 32.68436], [-115.50971, 32.68397], [-115.50976, 32.68386], [-115.50977, 32.68381], [-115.50975, 32.68376], [-115.50971, 32.68372], [-115.50961, 32.68369], [-115.50961, 32.6831], [-115.51116, 32.6831], [-115.51122, 32.68312], [-115.51125, 32.68319], [-115.51124, 32.68437]]]} Open Access 1 Las Casitas Park   21046 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 5.158 Las Casitas Park  
5009 5008 {"type": "Polygon", "coordinates": [[[-115.50228, 32.67811], [-115.50131, 32.67812], [-115.50131, 32.67728], [-115.50227, 32.67728], [-115.50228, 32.67811]]]} Open Access 1 Heber Park   19789 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 2.081 Heber Park  
5542 5541 {"type": "Polygon", "coordinates": [[[-115.4824, 32.68317], [-115.4824, 32.68418], [-115.48237, 32.68422], [-115.48019, 32.68423], [-115.4802, 32.68316], [-115.4824, 32.68317]]]} Open Access 1 Joel Riesen Field   20424 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 6.014 Joel Riesen Field  
5704 5703 {"type": "Polygon", "coordinates": [[[-115.4951, 32.68835], [-115.49502, 32.68837], [-115.49434, 32.68837], [-115.49433, 32.68816], [-115.49426, 32.6881], [-115.49413, 32.6881], [-115.49333, 32.6882], [-115.49332, 32.68849], [-115.49316, 32.68847], [-115.49329, 32.68831], [-115.49328, 32.68821], [-115.493, 32.68811], [-115.49259, 32.6878], [-115.49268, 32.6876], [-115.49398, 32.68757], [-115.49406, 32.68737], [-115.49423, 32.68748], [-115.49406, 32.68769], [-115.49413, 32.68785], [-115.49449, 32.68813], [-115.4951, 32.68835]]]} Open Access 1 Kennedy Gardens Park   20600 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 2.543 Kennedy Gardens Park  
6237 6236 {"type": "Polygon", "coordinates": [[[-115.48523, 32.67692], [-115.48429, 32.67693], [-115.48429, 32.67653], [-115.48441, 32.67652], [-115.4844, 32.67626], [-115.48472, 32.67626], [-115.48476, 32.67631], [-115.48522, 32.67631], [-115.48523, 32.67692]]]} Open Access 1 Lioness Park   21312 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1.466 Lioness Park  
7502 7501 {"type": "Polygon", "coordinates": [[[-115.52025, 32.67254], [-115.52024, 32.67333], [-115.51786, 32.67332], [-115.51784, 32.67254], [-115.52025, 32.67254]]]} Open Access 1 Nosotros Park   22908 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 4.815 Nosotros Park  
8517 8516 {"type": "Polygon", "coordinates": [[[-115.48239, 32.66837], [-115.48238, 32.66977], [-115.48154, 32.66977], [-115.48155, 32.66838], [-115.48239, 32.66837]]]} Open Access 1 Rancho Elegante Field   24144 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 3.012 Rancho Elegante Field  
8730 8729 {"type": "Polygon", "coordinates": [[[-115.51038, 32.67404], [-115.50945, 32.67403], [-115.50936, 32.674], [-115.50953, 32.67367], [-115.51038, 32.67399], [-115.51038, 32.67404]]]} Open Access 1 Rio Vista Park   24390 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 0.529 Rio Vista Park  
8878 8877 {"type": "Polygon", "coordinates": [[[-115.49341, 32.67129], [-115.49223, 32.6713], [-115.49224, 32.66997], [-115.4934, 32.66997], [-115.49341, 32.67129]]]} Open Access 1 Rockwood Plaza Park   24539 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 3.994 Rockwood Plaza Park  
8900 8899 {"type": "Polygon", "coordinates": [[[-115.50729, 32.67527], [-115.50728, 32.67704], [-115.50583, 32.67704], [-115.50582, 32.67663], [-115.50535, 32.67663], [-115.50535, 32.67518], [-115.50677, 32.67518], [-115.50704, 32.67524], [-115.50729, 32.67527]]]} Open Access 1 Rodriguez Park   24554 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 8.683 Rodriguez Park  
10868 10867 {"type": "Polygon", "coordinates": [[[-115.48658, 32.686], [-115.4865, 32.68606], [-115.48618, 32.68603], [-115.48621, 32.68558], [-115.48631, 32.68558], [-115.48639, 32.68554], [-115.48651, 32.68559], [-115.48658, 32.686]]]} Open Access 1 Victoria Park   27083 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 0.428 Victoria Park  
10889 10888 {"type": "Polygon", "coordinates": [[[-115.48238, 32.67698], [-115.48238, 32.67704], [-115.4816, 32.67704], [-115.48102, 32.67713], [-115.48102, 32.67576], [-115.48238, 32.67576], [-115.48238, 32.67698]]]} Open Access 1 Villa Santa Fe Park   27106 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 4.565 Villa Santa Fe Park  
11267 11266 {"type": "Polygon", "coordinates": [[[-115.51108, 32.67915], [-115.51108, 32.67942], [-115.50737, 32.67942], [-115.50737, 32.67915], [-115.51108, 32.67915]]]} Open Access 1 Williams Greenbelt Park   27562 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 2.588 Williams Greenbelt 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]);