superunits_with_maps

Table actions

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

6 rows where MNG_AGENCY = 738

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Williams, City of · 6 ✖

ACCESS_TYP 1

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
10643 10643 10642 {"type": "Polygon", "coordinates": [[[-122.13515, 39.15415], [-122.13498, 39.15429], [-122.13498, 39.15532], [-122.13506, 39.1554], [-122.13456, 39.15594], [-122.13438, 39.15599], [-122.13414, 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.13482, 39.15389], [-122.13515, 39.15415]]]} Open Access 1 Valley Vista Park   26811 1381 Williams, City of 738 City 2 City Agency 2 http://www.cityofwilliams.org/parks-rec/index.htm City 2 12.41 Valley Vista Park  
10672 10672 10671 {"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 Venice Park   26847 1381 Williams, City of 738 City 2 City Agency 2 http://www.cityofwilliams.org/parks-rec/index.htm City 2 6.245 Venice Park  
11234 11234 11233 {"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 Williams holding 1   27564 1381 Williams, City of 738 City 2 City Agency 2 http://www.cityofwilliams.org/parks-rec/index.htm City 2 2.144 Williams holding 1  
11807 11807 11806 {"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 North View Park http://www.cityofwilliams.org/parks-rec/ada/index.htm 28446 1381 Williams, City of 738 City 2 City Agency 2 http://www.cityofwilliams.org/parks-rec/index.htm City 2 2.505 North View Park  
11842 11842 11841 {"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 Valley Ranch Playground http://www.cityofwilliams.org/parks-rec/parks-facilities.htm 28492 1381 Williams, City of 738 City 2 City Agency 2 http://www.cityofwilliams.org/parks-rec/index.htm City 2 1.648 Valley Ranch Playground  
11919 11919 11918 {"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 Williams Historic Town Square   28702 1381 Williams, City of 738 City 2 City Agency 2 http://www.cityofwilliams.org/parks-rec/index.htm City 2 0.219 Williams Historic Town Square  

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