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 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
3253 3252 {"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 29193 American Legion Softball Field 15453 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 3.933 American Legion Softball Field 0 Local Recreation Area 3 4
3348 3347 {"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 30419 Rockwood Plaza Park 24539 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 3.996 Rockwood Plaza Park 0 Local Park 2 4
3440 3439 {"type": "Polygon", "coordinates": [[[-115.48246, 32.68055], [-115.48244, 32.68268], [-115.48183, 32.68268], [-115.4818, 32.68052], [-115.48243, 32.68051], [-115.48246, 32.68055]]]} Open Access 1 48748 Meadows Park 33474 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 3.51 Meadows Park 0 Local Park 2 4
3444 3443 {"type": "Polygon", "coordinates": [[[-115.49283, 32.68887], [-115.49278, 32.68897], [-115.49196, 32.68892], [-115.49199, 32.68869], [-115.49221, 32.68849], [-115.49283, 32.68887]]]} Open Access 1 48749 Robert F. Kennedy Park 33475 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 0.625 Robert F. Kennedy Park 0 Local Park 2 4
3445 3444 {"type": "Polygon", "coordinates": [[[-115.49103, 32.68828], [-115.49059, 32.68816], [-115.48997, 32.68793], [-115.48965, 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 48750 Kennedy Gardens Large 33476 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 4.152 Kennedy Gardens Large   None 281  
5121 5120 {"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 26508 Nosotros Park 22908 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 4.815 Nosotros Park 0 Local Park 2 4
6702 6701 {"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 30416 Rio Vista Park 24390 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 0.53 Rio Vista Park 0 Local Park 2 4
7056 7055 {"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 30417 Rancho Elegante Field 24144 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 3.013 Rancho Elegante Field 0 Local Recreation Area 3 4
7143 7142 {"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 34893 Williams Greenbelt Park 27562 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 2.591 Williams Greenbelt Park 0 Local Park 2 4
12346 12345 {"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 26509 Rodriguez Park 24554 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 8.68 Rodriguez Park 0 Local Park 2 4
12374 12373 {"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 26510 Las Casitas Park 21046 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 5.16 Las Casitas Park 0 Local Park 2 4
12375 12374 {"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 26511 Heber Park 19789 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 2.082 Heber Park 0 Local Park 2 4
12376 12375 {"type": "Polygon", "coordinates": [[[-115.49853, 32.66622], [-115.4981, 32.66622], [-115.4981, 32.66614], [-115.49807, 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 26512 Border Friendship Park 16279 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 0.77 Border Friendship Park 0 Local Park 2 4
12377 12376 {"type": "Polygon", "coordinates": [[[-115.4951, 32.68835], [-115.49502, 32.68837], [-115.49434, 32.68837], [-115.49434, 32.68816], [-115.49426, 32.6881], [-115.49414, 32.6881], [-115.49333, 32.6882], [-115.49332, 32.68849], [-115.49316, 32.68847], [-115.49329, 32.68831], [-115.49329, 32.68821], [-115.493, 32.68811], [-115.49259, 32.6878], [-115.49268, 32.6876], [-115.49399, 32.68757], [-115.49406, 32.68737], [-115.49423, 32.68748], [-115.49405, 32.68769], [-115.49413, 32.68785], [-115.49449, 32.68813], [-115.4951, 32.68835]]]} Open Access 1 26513 Kennedy Gardens Park 20600 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 2.535 Kennedy Gardens Park 0 Local Park 2 4
12378 12377 {"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 26514 Crummett Park 17840 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 3.03 Crummett Park 0 Local Park 2 4
12379 12378 {"type": "Polygon", "coordinates": [[[-115.48306, 32.66602], [-115.48305, 32.66656], [-115.48268, 32.66655], [-115.48269, 32.66605], [-115.48306, 32.66602]]]} Open Access 1 26515 Cortez Park 17665 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 0.5 Cortez Park 0 Local Park 2 4
12380 12379 {"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 26516 Lioness Park 21312 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 1.466 Lioness Park 0 Local Park 2 4
12745 12744 {"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 30420 Villa Santa Fe Park 27106 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 4.566 Villa Santa Fe Park 0 Local Park 2 4
12753 12752 {"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 30421 Joel Riesen Field 20424 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 6.015 Joel Riesen Field 0 Local Recreation Area 3 4
12862 12861 {"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 30422 Victoria Park 27083 1451 Calexico, City of 607 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 1451 Calexico, City of 596 City 2 City Agency 2   Imperial 20 0.428 Victoria 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]);