units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1 and UNIT_NAME = "Cloverdale River Park"

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

DES_TP 1

ACCESS_TYP 1

  • Open Access · 2 ✖
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
509 509 508 {"type": "Polygon", "coordinates": [[[-123.01254, 38.82071], [-123.01186, 38.82152], [-123.01112, 38.82235], [-123.01076, 38.82218], [-123.0119, 38.82141], [-123.01148, 38.82068], [-123.01202, 38.81948], [-123.01254, 38.82071]]]} Open Access 1 1700 Cloverdale River Park 17444 328 Sonoma County Regional Parks Dept., County of 193 County 3 County Agency - Parks 7 http://parks.sonomacounty.ca.gov/ County 3 328 Sonoma County Regional Parks Dept., County of 189 County 3 County Agency - Parks 7   Sonoma 16 3.11 Cloverdale River 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

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