superunits_with_maps

Table actions

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

11 rows where MNG_AGENCY = 216 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • City Agency · 11 ✖

MNG_AGENCY 1

  • Indio, City of · 11 ✖
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
1749 1749 1748 {"type": "Polygon", "coordinates": [[[-116.20372, 33.73346], [-116.20136, 33.73345], [-116.20135, 33.73248], [-116.20244, 33.73249], [-116.20262, 33.73252], [-116.2029, 33.73262], [-116.20312, 33.73267], [-116.20332, 33.73268], [-116.20372, 33.73268], [-116.20372, 33.73346]]]} Open Access 1 Cahuilla Park   16664 1145 Indio, City of 216 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 5.359 Cahuilla Park  
2918 2918 2917 {"type": "Polygon", "coordinates": [[[-116.236, 33.72465], [-116.236, 33.72515], [-116.23582, 33.72509], [-116.23569, 33.72507], [-116.23545, 33.72507], [-116.23447, 33.72536], [-116.23386, 33.72536], [-116.23387, 33.72466], [-116.236, 33.72465]]]} Open Access 1 Dominguez Park   18196 1145 Indio, City of 216 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 3.095 Dominguez Park  
3670 3670 3669 {"type": "Polygon", "coordinates": [[[-116.21751, 33.72078], [-116.21751, 33.72092], [-116.21735, 33.72115], [-116.21714, 33.72105], [-116.21699, 33.72092], [-116.21699, 33.72069], [-116.21751, 33.7207], [-116.21751, 33.72078]]]} Open Access 1 Doug York Plaza   18240 1145 Indio, City of 216 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 0.476 Doug York Plaza  
3702 3702 3701 {"type": "Polygon", "coordinates": [[[-116.23189, 33.70746], [-116.23189, 33.70846], [-116.23111, 33.70846], [-116.23111, 33.70747], [-116.23189, 33.70746]]]} Open Access 1 Dr. Carreon Park   18266 1145 Indio, City of 216 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 1.985 Dr. Carreon Park  
5884 5884 5883 {"type": "Polygon", "coordinates": [[[-116.22696, 33.72135], [-116.22695, 33.72294], [-116.22567, 33.72294], [-116.22566, 33.72343], [-116.2256, 33.72345], [-116.2256, 33.72375], [-116.22474, 33.72375], [-116.22472, 33.72386], [-116.22348, 33.72385], [-116.2235, 33.72127], [-116.22693, 33.72129], [-116.22696, 33.72135]]]} Open Access 1 Miles Avenue Park   22218 1145 Indio, City of 216 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 19.379 Miles Avenue Park  
7277 7277 7276 {"type": "Polygon", "coordinates": [[[-116.20066, 33.71858], [-116.20066, 33.71881], [-116.19995, 33.71937], [-116.19949, 33.71896], [-116.20008, 33.71895], [-116.20009, 33.71858], [-116.20066, 33.71858]]]} Open Access 1 Mulligan Dog Park   22598 1145 Indio, City of 216 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 1.038 Mulligan Dog Park  
8022 8022 8021 {"type": "Polygon", "coordinates": [[[-116.20543, 33.73682], [-116.20543, 33.73778], [-116.20384, 33.73778], [-116.20379, 33.73775], [-116.20379, 33.73753], [-116.20386, 33.73744], [-116.20387, 33.73738], [-116.20379, 33.7372], [-116.20379, 33.73686], [-116.20382, 33.73686], [-116.20388, 33.73681], [-116.20543, 33.73682]]]} Open Access 1 Patton Park   23523 1145 Indio, City of 216 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 3.994 Patton Park  
9589 9589 9588 {"type": "Polygon", "coordinates": [[[-116.2603, 33.71559], [-116.26019, 33.71569], [-116.26001, 33.71554], [-116.25966, 33.71554], [-116.25966, 33.71507], [-116.26003, 33.71497], [-116.26005, 33.71507], [-116.26007, 33.71507], [-116.26009, 33.71504], [-116.26021, 33.71503], [-116.2602, 33.71542], [-116.2603, 33.71559]]]} Open Access 1 Shields Park   25407 1145 Indio, City of 216 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 0.789 Shields Park  
9787 9787 9786 {"type": "Polygon", "coordinates": [[[-116.21623, 33.71146], [-116.21622, 33.71192], [-116.21492, 33.71193], [-116.2149, 33.71223], [-116.214, 33.71224], [-116.21399, 33.71312], [-116.21206, 33.71313], [-116.21204, 33.71375], [-116.21023, 33.71376], [-116.21022, 33.71403], [-116.20988, 33.71403], [-116.20987, 33.71151], [-116.21623, 33.71146]]]} Open Access 1 South Jackson Park   25658 1145 Indio, City of 216 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 24.101 South Jackson Park  
11496 11496 11495 {"type": "Polygon", "coordinates": [[[-116.23029, 33.73267], [-116.22948, 33.73267], [-116.22944, 33.73266], [-116.22942, 33.73262], [-116.22942, 33.73214], [-116.22947, 33.73212], [-116.23029, 33.73211], [-116.23029, 33.73267]]]} Open Access 1 Yucca Park   27848 1145 Indio, City of 216 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 1.217 Yucca Park  
13805 13805 13804 {"type": "Polygon", "coordinates": [[[-116.21454, 33.74765], [-116.20803, 33.7476], [-116.20804, 33.74405], [-116.21453, 33.7441], [-116.21454, 33.74765]]]} Restricted Access 2 Indio's Municipal Golf Course   33103 1145 Indio, City of 216 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 58.609 Indio's Municipal GC  

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