units_with_maps

Table actions

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

10 rows where COUNTY = 10, DES_TP = 2 and MNG_AGENCY = 216

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Indio, City of · 10 ✖

DES_TP 1

  • Local Park · 10 ✖

ACCESS_TYP 1

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
607 607 606 {"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 2112 Cahuilla Park 16664 1145 Indio, City of 220 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 1145 Indio, City of 216 City 2 City Agency 2   Riverside 10 5.361 Cahuilla Park 0 Local Park 2 4
715 715 714 {"type": "Polygon", "coordinates": [[[-116.22695, 33.72294], [-116.22567, 33.72294], [-116.22566, 33.72343], [-116.2256, 33.72344], [-116.2256, 33.72375], [-116.22473, 33.72375], [-116.22472, 33.72386], [-116.22348, 33.72385], [-116.2235, 33.72127], [-116.22693, 33.72129], [-116.22696, 33.72135], [-116.22695, 33.72294]]]} Open Access 1 5359 Miles Avenue Park 22218 1145 Indio, City of 220 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 1145 Indio, City of 216 City 2 City Agency 2   Riverside 10 19.373 Miles Avenue Park 0 Local Park 2 4
1413 1413 1412 {"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.26004, 33.71507], [-116.26008, 33.71508], [-116.26009, 33.71504], [-116.26021, 33.71503], [-116.2602, 33.71543], [-116.2603, 33.71559]]]} Open Access 1 39060 Shields Park 25407 1145 Indio, City of 220 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 1145 Indio, City of 216 City 2 City Agency 2   Riverside 10 0.787 Shields Park 0 Local Park 2 4
3007 3007 3006 {"type": "Polygon", "coordinates": [[[-116.21623, 33.71146], [-116.21622, 33.71192], [-116.21491, 33.71193], [-116.2149, 33.71223], [-116.214, 33.71224], [-116.21399, 33.71312], [-116.21205, 33.71313], [-116.21204, 33.71375], [-116.21022, 33.71376], [-116.21022, 33.71403], [-116.20988, 33.71403], [-116.20987, 33.71151], [-116.21623, 33.71146]]]} Open Access 1 24267 South Jackson Park 25658 1145 Indio, City of 220 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 1145 Indio, City of 216 City 2 City Agency 2   Riverside 10 24.083 South Jackson Park 0 Local Park 2 4
3136 3136 3135 {"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 39057 Doug York Plaza 18240 1145 Indio, City of 220 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 1145 Indio, City of 216 City 2 City Agency 2   Riverside 10 0.476 Doug York Plaza 0 Local Park 2 4
3196 3196 3195 {"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 39058 Mulligan Dog Park 22598 1145 Indio, City of 220 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 1145 Indio, City of 216 City 2 City Agency 2   Riverside 10 1.035 Mulligan Dog Park 0 Local Park 2 4
3422 3422 3421 {"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 25146 Dominguez Park 18196 1145 Indio, City of 220 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 1145 Indio, City of 216 City 2 City Agency 2   Riverside 10 3.095 Dominguez Park 0 Local Park 2 4
5156 5156 5155 {"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 25145 Dr. Carreon Park 18266 1145 Indio, City of 220 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 1145 Indio, City of 216 City 2 City Agency 2   Riverside 10 1.986 Dr. Carreon Park 0 Local Park 2 4
11617 11617 11616 {"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 24639 Yucca Park 27848 1145 Indio, City of 220 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 1145 Indio, City of 216 City 2 City Agency 2   Riverside 10 1.218 Yucca Park 0 Local Park 2 4
14054 14054 14053 {"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 39056 Patton Park 23523 1145 Indio, City of 220 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 1145 Indio, City of 216 City 2 City Agency 2   Riverside 10 3.994 Patton Park 0 Local Park 2 4

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