units_with_maps

Table actions

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

3 rows where AGNCY_WEB = "http://www.cityofwilliams.org/parks-rec/index.htm", DES_TP = 2 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 3 ✖

MNG_AGENCY 1

DES_TP 1

  • Local Park · 3 ✖

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
11890 11890 11889 {"type": "Polygon", "coordinates": [[[-122.13515, 39.15415], [-122.13498, 39.15429], [-122.13498, 39.15532], [-122.13506, 39.1554], [-122.13455, 39.15594], [-122.13438, 39.15599], [-122.13413, 39.15628], [-122.13467, 39.15657], [-122.13453, 39.15675], [-122.13277, 39.15594], [-122.13276, 39.15386], [-122.13345, 39.15387], [-122.13349, 39.15379], [-122.13361, 39.15378], [-122.13481, 39.15379], [-122.13481, 39.15389], [-122.13515, 39.15415]]]} Open Access 1 24465 Valley Vista Park 26811 1381 Williams, City of 752 City 2 City Agency 2 http://www.cityofwilliams.org/parks-rec/index.htm City 2 1381 Williams, City of 738 City 2 City Agency 2   Colusa 49 12.402 Valley Vista Park 0 Local Park 2 4
11898 11898 11897 {"type": "Polygon", "coordinates": [[[-122.16123, 39.15041], [-122.16121, 39.15238], [-122.15988, 39.15238], [-122.15989, 39.1504], [-122.16123, 39.15041]]]} Open Access 1 24467 Venice Park 26847 1381 Williams, City of 752 City 2 City Agency 2 http://www.cityofwilliams.org/parks-rec/index.htm City 2 1381 Williams, City of 738 City 2 City Agency 2   Colusa 49 6.246 Venice Park 0 Local Park 2 4
14984 14984 14983 {"type": "Polygon", "coordinates": [[[-122.16206, 39.15879], [-122.16207, 39.15889], [-122.16204, 39.15974], [-122.16171, 39.15978], [-122.1615, 39.15997], [-122.1612, 39.15998], [-122.1612, 39.15959], [-122.16116, 39.15938], [-122.1611, 39.15922], [-122.16096, 39.15909], [-122.16082, 39.15888], [-122.16081, 39.15879], [-122.16206, 39.15879]]]} Open Access 1 45618 North View Park 28446 1381 Williams, City of 752 City 2 City Agency 2 http://www.cityofwilliams.org/parks-rec/index.htm City 2 1381 Williams, City of 738 City 2 City Agency 2 http://www.cityofwilliams.org/parks-rec/ada/index.htm Colusa 49 2.505 North View 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]);