Data source: data.sfgov.org
This data as json, CSV (advanced)
id | value ▼ |
---|---|
4 | : |
24 | : Cutout |
23 | : Yard |
16 | Back Yard : Cutout |
13 | Back Yard : Yard |
25 | Front Yard : |
8 | Front Yard : Cutout |
30 | Front Yard : Pot |
7 | Front Yard : Yard |
29 | Hanging basket : Cutout |
27 | Hanging basket : Yard |
22 | Median : |
11 | Median : Cutout |
28 | Median : Hanging Pot |
3 | Median : Yard |
18 | Side Yard : Cutout |
17 | Side Yard : Yard |
21 | Sidewalk: Curb side : |
1 | Sidewalk: Curb side : Cutout |
15 | Sidewalk: Curb side : Hanging Pot |
10 | Sidewalk: Curb side : Pot |
2 | Sidewalk: Curb side : Yard |
26 | Sidewalk: Property side : |
5 | Sidewalk: Property side : Cutout |
6 | Sidewalk: Property side : Pot |
9 | Sidewalk: Property side : Yard |
20 | Unaccepted Street : Cutout |
14 | Unaccepted Street : Yard |
12 | unknown : Cutout |
31 | unknown : Pot |
19 | unknown : Yard |
JSON shape: default, array, newline-delimited, object
CREATE TABLE "qSiteInfo" ( "id" INTEGER PRIMARY KEY , "value" TEXT );