units_with_maps

Table actions

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

6 rows where AGNCY_LEV = 2, MNG_AGENCY = 738 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 6 ✖

MNG_AGENCY 1

  • Williams, City of · 6 ✖

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
4352 4352 4351 {"type": "Polygon", "coordinates": [[[-122.15012, 39.15433], [-122.14972, 39.15449], [-122.1496, 39.15431], [-122.15001, 39.15415], [-122.15012, 39.15433]]]} Open Access 1 45673 Williams Historic Town Square 28702 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 0.22 Williams Historic Town Square 0 Local Historic or Cultural Area 19 4
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
13799 13799 13798 {"type": "Polygon", "coordinates": [[[-122.15135, 39.15148], [-122.15134, 39.15235], [-122.15081, 39.15256], [-122.15016, 39.15159], [-122.15049, 39.15147], [-122.15135, 39.15148]]]} Open Access 1 36392 Williams holding 1 27564 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 2.145 Williams holding 1 0 Local Other or Unknown 14 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
15026 15026 15025 {"type": "Polygon", "coordinates": [[[-122.13866, 39.15128], [-122.13863, 39.15136], [-122.13837, 39.15143], [-122.1374, 39.15143], [-122.1374, 39.15083], [-122.13777, 39.15084], [-122.13797, 39.15083], [-122.13827, 39.15074], [-122.13835, 39.15077], [-122.13866, 39.15128]]]} Open Access 1 45678 Valley Ranch Playground 28492 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/parks-facilities.htm Colusa 49 1.648 Valley Ranch Playground 0 Local Recreation Area 3 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]);