units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1, DES_TP = 2 and UNIT_NAME = "Silver Oak Park"

This data as json, copyable, CSV (advanced)

These facets timed out: DES_TP

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
8576 8576 8575 {"type": "Polygon", "coordinates": [[[-119.18085, 35.3729], [-119.18085, 35.37375], [-119.18079, 35.3738], [-119.18018, 35.37382], [-119.1778, 35.37383], [-119.1778, 35.37259], [-119.18025, 35.37258], [-119.18026, 35.37208], [-119.18077, 35.37208], [-119.18084, 35.37215], [-119.18085, 35.3729]]]} Open Access 1 13611 Silver Oak Park 25493 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 10.144 Silver Oak Park 0 Local Park 2 4
10121 10121 10120 {"type": "Polygon", "coordinates": [[[-122.25007, 38.16579], [-122.25006, 38.16611], [-122.24926, 38.16618], [-122.24901, 38.16619], [-122.24855, 38.16624], [-122.24795, 38.16628], [-122.24767, 38.16632], [-122.24714, 38.16636], [-122.24707, 38.16634], [-122.24676, 38.16635], [-122.24673, 38.16638], [-122.24666, 38.16636], [-122.2466, 38.16636], [-122.24648, 38.16624], [-122.24617, 38.16623], [-122.24613, 38.16637], [-122.2461, 38.16692], [-122.24607, 38.16705], [-122.24567, 38.16833], [-122.24481, 38.16833], [-122.24437, 38.16835], [-122.24436, 38.16612], [-122.24297, 38.1657], [-122.24259, 38.16565], [-122.2424, 38.16566], [-122.24223, 38.16562], [-122.24167, 38.16545], [-122.24143, 38.16543], [-122.24137, 38.16545], [-122.24127, 38.16537], [-122.24113, 38.16538], [-122.24109, 38.16533], [-122.24066, 38.16533], [-122.24065, 38.16534], [-122.24096, 38.16671], [-122.24044, 38.16609], [-122.24015, 38.16562], [-122.24004, 38.16511], [-122.24004, 38.16489], [-122.24005, 38.16481], [-122.24015, 38.16476], [-122.24066, 38.16488], [-122.24128, 38.16496], [-122.24386, 38.16536], [-122.24448, 38.16579], [-122.24464, 38.16579], [-122.2447, 38.16598], [-122.24471, 38.16623], [-122.24684, 38.16591], [-122.2472, 38.16605], [-122.24759, 38.16583], [-122.24809, 38.16587], [-122.24906, 38.16569], [-122.24923, 38.16559], [-122.24923, 38.16557], [-122.24991, 38.16564], [-122.25007, 38.16579]]]} Open Access 1 17590 Silver Oak Park 25492 1005 American Canyon, City of 434 City 2 City Agency 2 http://cityofamericancanyon.org/city-departments/parks-recreation City 2 1005 American Canyon, City of 428 City 2 City Agency 2   Napa 11 19.202 Silver Oak Park 2006 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]);