units_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 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
1698 1698 1697 {"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 6968 Tarman Park 26190 1059 Cloverdale, City of 410 City 2 City Agency 2 http://www.cloverdale.net/index.aspx?nid=152 City 2 1059 Cloverdale, City of 404 City 2 City Agency 2   Sonoma 16 0.409 Tarman Park 0 Local Park 2 4
3474 3474 3473 {"type": "Polygon", "coordinates": [[[-123.02509, 38.79963], [-123.02404, 38.79987], [-123.02384, 38.79927], [-123.02367, 38.79883], [-123.02439, 38.79818], [-123.02447, 38.79822], [-123.02466, 38.79839], [-123.02474, 38.79854], [-123.02509, 38.79963]]]} Open Access 1 48751 Vintage Meadows Park 33477 1059 Cloverdale, City of 410 City 2 City Agency 2 http://www.cloverdale.net/index.aspx?nid=152 City 2 1059 Cloverdale, City of 404 City 2 City Agency 2   Sonoma 16 3.513 Vintage Meadows Park 0 Local Park 2 4
5412 5412 5411 {"type": "Polygon", "coordinates": [[[-123.01294, 38.81679], [-123.0129, 38.81679], [-123.01282, 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.01004, 38.81127], [-123.01, 38.8115], [-123.0103, 38.81233], [-123.01099, 38.8138], [-123.01181, 38.81356], [-123.01206, 38.81445], [-123.01294, 38.81679]]]} Open Access 1 7172 Cloverdale River Park 17445 1059 Cloverdale, City of 410 City 2 City Agency 2 http://www.cloverdale.net/index.aspx?nid=152 City 2 1059 Cloverdale, City of 404 City 2 City Agency 2   Sonoma 16 33.866 Cloverdale River Park 0 Local Park 2 4
7460 7460 7459 {"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 6956 Cloverdale City Park 17442 1059 Cloverdale, City of 410 City 2 City Agency 2 http://www.cloverdale.net/index.aspx?nid=152 City 2 1059 Cloverdale, City of 404 City 2 City Agency 2   Sonoma 16 6.771 Cloverdale City Park 0 Local Park 2 4
7472 7472 7471 {"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 6980 Furber Park 19151 1059 Cloverdale, City of 410 City 2 City Agency 2 http://www.cloverdale.net/index.aspx?nid=152 City 2 1059 Cloverdale, City of 404 City 2 City Agency 2   Sonoma 16 6.162 Furber Park 0 Local Park 2 4
10872 10872 10871 {"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.02891, 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 20707 Clover Springs 31266 1059 Cloverdale, City of 410 City 2 City Agency 2 http://www.cloverdale.net/index.aspx?nid=152 City 2 1059 Cloverdale, City of 404 City 2 City Agency 2   Sonoma 16 255.548 Clover Springs   None 948  
17032 17032 17031 {"type": "Polygon", "coordinates": [[[-123.01796, 38.80475], [-123.01776, 38.80483], [-123.01761, 38.80461], [-123.01763, 38.80459], [-123.01759, 38.80453], [-123.01776, 38.80445], [-123.01796, 38.80475]]]} Open Access 1 23631 Veterans Memorial Center 27022 1059 Cloverdale, City of 410 City 2 City Agency 2 http://www.cloverdale.net/index.aspx?nid=152 City 2 1059 Cloverdale, City of 404 City 2 City Agency 2   Sonoma 16 0.172 Veterans Memorial Ctr. 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]);