superunits_with_maps

Table actions

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

7 rows where MNG_AGENCY = 404 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 7 ✖

MNG_AGENCY 1

  • Cloverdale, City of · 7 ✖

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
6 6 5 {"type": "Polygon", "coordinates": [[[-123.02509, 38.79963], [-123.02404, 38.79987], [-123.02384, 38.79928], [-123.02367, 38.79883], [-123.02439, 38.79818], [-123.02446, 38.79822], [-123.02466, 38.79839], [-123.02474, 38.79854], [-123.02509, 38.79963]]]} Open Access 1 Vintage Meadows Park   33477 1059 Cloverdale, City of 404 City 2 City Agency 2 http://www.cloverdale.net/index.aspx?nid=152 City 2 3.513 Vintage Meadows Park  
3037 3037 3036 {"type": "Polygon", "coordinates": [[[-123.02615, 38.80458], [-123.02333, 38.80518], [-123.02292, 38.80422], [-123.02556, 38.80366], [-123.02615, 38.80458]]]} Open Access 1 Cloverdale City Park   17442 1059 Cloverdale, City of 404 City 2 City Agency 2 http://www.cloverdale.net/index.aspx?nid=152 City 2 6.77 Cloverdale City Park  
3040 3040 3039 {"type": "Polygon", "coordinates": [[[-123.01294, 38.81679], [-123.0129, 38.81679], [-123.01281, 38.81658], [-123.01155, 38.81652], [-123.01151, 38.81674], [-123.0114, 38.81674], [-123.01073, 38.81518], [-123.00987, 38.81458], [-123.00961, 38.81387], [-123.00919, 38.81341], [-123.00885, 38.8126], [-123.00868, 38.81232], [-123.00835, 38.81149], [-123.00794, 38.81075], [-123.00768, 38.81019], [-123.00773, 38.80922], [-123.0079, 38.8089], [-123.00898, 38.80835], [-123.00914, 38.80831], [-123.00903, 38.8088], [-123.00904, 38.80895], [-123.00917, 38.80931], [-123.00971, 38.81026], [-123.00985, 38.81038], [-123.01012, 38.81049], [-123.01041, 38.81068], [-123.01059, 38.81082], [-123.01077, 38.81103], [-123.01003, 38.81127], [-123.01, 38.8115], [-123.0103, 38.81233], [-123.01099, 38.81379], [-123.01181, 38.81356], [-123.01206, 38.81445], [-123.01294, 38.81679]]]} Open Access 1 Cloverdale River Park   17445 1059 Cloverdale, City of 404 City 2 City Agency 2 http://www.cloverdale.net/index.aspx?nid=152 City 2 33.88 Cloverdale River Park  
4453 4453 4452 {"type": "Polygon", "coordinates": [[[-123.02115, 38.78558], [-123.02111, 38.78563], [-123.0185, 38.78635], [-123.01845, 38.78625], [-123.0188, 38.78591], [-123.01884, 38.78555], [-123.01912, 38.78519], [-123.01907, 38.78506], [-123.01898, 38.78492], [-123.01949, 38.78474], [-123.01963, 38.78467], [-123.01996, 38.78444], [-123.02006, 38.78444], [-123.0201, 38.78447], [-123.02056, 38.78482], [-123.02068, 38.78494], [-123.02091, 38.78519], [-123.02112, 38.78549], [-123.02115, 38.78558]]]} Open Access 1 Furber Park   19151 1059 Cloverdale, City of 404 City 2 City Agency 2 http://www.cloverdale.net/index.aspx?nid=152 City 2 6.163 Furber Park  
8706 8706 8705 {"type": "Polygon", "coordinates": [[[-123.01441, 38.79804], [-123.01401, 38.79805], [-123.01398, 38.79765], [-123.01439, 38.79761], [-123.01441, 38.79804]]]} Open Access 1 Tarman Park   26190 1059 Cloverdale, City of 404 City 2 City Agency 2 http://www.cloverdale.net/index.aspx?nid=152 City 2 0.409 Tarman Park  
13755 13755 13754 {"type": "Polygon", "coordinates": [[[-123.04475, 38.7832], [-123.04484, 38.78688], [-123.0444, 38.79057], [-123.03502, 38.79041], [-123.03144, 38.79029], [-123.03118, 38.79017], [-123.03098, 38.7901], [-123.03076, 38.79001], [-123.03057, 38.78991], [-123.03021, 38.78985], [-123.02993, 38.78969], [-123.02969, 38.78964], [-123.02936, 38.78954], [-123.02905, 38.78948], [-123.02883, 38.78956], [-123.02864, 38.78949], [-123.0289, 38.78892], [-123.02882, 38.78874], [-123.02909, 38.78817], [-123.02949, 38.78668], [-123.03058, 38.78668], [-123.03067, 38.78307], [-123.03627, 38.78313], [-123.03963, 38.78319], [-123.04475, 38.7832]]]} Open Access 1 Clover Springs   31266 1059 Cloverdale, City of 404 City 2 City Agency 2 http://www.cloverdale.net/index.aspx?nid=152 City 2 255.558 Clover Springs  
15603 15603 15602 {"type": "Polygon", "coordinates": [[[-123.01796, 38.80475], [-123.01776, 38.80483], [-123.01761, 38.80461], [-123.01762, 38.80459], [-123.01759, 38.80453], [-123.01776, 38.80445], [-123.01796, 38.80475]]]} Open Access 1 Veterans Memorial Center   27022 1059 Cloverdale, City of 404 City 2 City Agency 2 http://www.cloverdale.net/index.aspx?nid=152 City 2 0.172 Veterans Memorial Ctr.  

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