Street_Tree_List

Data source: data.sfgov.org

189,144 rows sorted by qAddress

View and edit SQL

Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
51 60867 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/1983 12:00:00 AM     Permit Number 20649          
57 44642 Permitted Site 1 Tree(s) :: 17   60 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
59 44994 Permitted Site 1 Tree(s) :: 17   106 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
84 36641 Permitted Site 1 Robinia x ambigua :: Locust 33   13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/1998 12:00:00 AM     Permit Number 39461          
103 117428 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/14/2016 12:00:00 AM 3   Permit Number 776915          
151 36617 Permitted Site 1 Robinia x ambigua :: Locust 33   8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/1998 12:00:00 AM     Permit Number 39461          
172 48332 Permitted Site 1 Tree(s) :: 17   142 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
204 61453 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/22/1984 12:00:00 AM     Permit Number 21392          
235 45975 Permitted Site 1 Tree(s) :: 17   132 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
279 48153 Permitted Site 1 Tree(s) :: 17   263 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
308 46059 Permitted Site 1 Tree(s) :: 17   101 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
320 48259 Permitted Site 1 Tree(s) :: 17   123 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
321 65143 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/1989 12:00:00 AM     Permit Number 27118          
444 44838 Permitted Site 1 Tree(s) :: 17   12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
515 48129 Permitted Site 1 Tree(s) :: 17   297 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
536 45913 Permitted Site 1 Tree(s) :: 17   59 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
580 48268 Permitted Site 1 Tree(s) :: 17   132 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
632 44905 Permitted Site 1 Tree(s) :: 17   139 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
633 48204 Permitted Site 1 Tree(s) :: 17   47 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
689 48269 Permitted Site 1 Tree(s) :: 17   120 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
726 44958 Permitted Site 1 Tree(s) :: 17   82 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
729 48266 Permitted Site 1 Tree(s) :: 17   130 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
793 65876 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/1990 12:00:00 AM     Permit Number 28874          
809 46145 Permitted Site 1 Tree(s) :: 17   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2001 12:00:00 AM     Permit Number 44490          
814 44650 Permitted Site 1 Tree(s) :: 17   70 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
921 30278 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 128          
937 45898 Permitted Site 1 Tree(s) :: 17   26 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
952 48321 Permitted Site 1 Tree(s) :: 17   187 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
953 46022 Permitted Site 1 Tree(s) :: 17   215 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
1010 45949 Permitted Site 1 Tree(s) :: 17   146 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
1015 48313 Permitted Site 1 Tree(s) :: 17   179 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
1067 48140 Permitted Site 1 Tree(s) :: 17   250 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
1086 48227 Permitted Site 1 Tree(s) :: 17   9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
1113 45845 Permitted Site 1 Tree(s) :: 17   81 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
1225 44628 Permitted Site 1 Tree(s) :: 17   156 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
1418 48339 Permitted Site 1 Tree(s) :: 17   156 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
1499 44884 Permitted Site 1 Tree(s) :: 17   157 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
1511 45972 Permitted Site 1 Tree(s) :: 17   119 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
1526 44588 Permitted Site 1 Tree(s) :: 17   116 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
1532 44561 Permitted Site 1 Tree(s) :: 17   14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
1765 45968 Permitted Site 1 Tree(s) :: 17   155 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
1804 44554 Permitted Site 1 Tree(s) :: 17   41 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
1828 35192 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
1869 35202 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
1885 30481 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/05/1956 12:00:00 AM     Permit Number 147          
1959 48104 Permitted Site 1 Tree(s) :: 17   213 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
1973 66343 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/10/1990 12:00:00 AM     Permit Number 29464          
1981 35702 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85   15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/10/1998 12:00:00 AM     Permit Number 38993          
2019 48201 Permitted Site 1 Tree(s) :: 17   44 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
2080 34119 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37980          
2086 45988 Permitted Site 1 Tree(s) :: 17   223 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
2115 44893 Permitted Site 1 Tree(s) :: 17   127 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
2154 45014 Permitted Site 1 Tree(s) :: 17   86 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
2193 46043 Permitted Site 1 Tree(s) :: 17   174 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
2195 44993 Permitted Site 1 Tree(s) :: 17   105 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
2304 44646 Permitted Site 1 Tree(s) :: 17   66 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
2366 44966 Permitted Site 1 Tree(s) :: 17   79 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
2434 48283 Permitted Site 1 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
2627 44896 Permitted Site 1 Tree(s) :: 17   130 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
2630 44978 Permitted Site 1 Tree(s) :: 17   50 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
2673 46063 Permitted Site 1 Tree(s) :: 17   105 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
2699 36646 Permitted Site 1 Robinia x ambigua :: Locust 33   18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/1998 12:00:00 AM     Permit Number 39461          
2726 46033 Permitted Site 1 Tree(s) :: 17   213 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
2842 36843 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
2860 44877 Permitted Site 1 Tree(s) :: 17   150 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
2904 44678 Permitted Site 1 Tree(s) :: 17   98 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
2945 44998 Permitted Site 1 Tree(s) :: 17   110 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
2960 44920 Permitted Site 1 Tree(s) :: 17   182 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
2992 43017 Permitted Site 1 Geijera parviflora :: Australian Willow 68   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2000 12:00:00 AM     Permit Number 42880          
3027 45855 Permitted Site 1 Tree(s) :: 17   79 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
3062 34116 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37979          
3077 35211 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
3090 44576 Permitted Site 1 Tree(s) :: 17   140 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
3118 48324 Permitted Site 1 Tree(s) :: 17   176 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
3134 44852 Permitted Site 1 Tree(s) :: 17   37 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
3168 33093 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM     Permit Number 37336          
3178 48242 Permitted Site 1 Tree(s) :: 17   26 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
3193 48299 Permitted Site 1 Tree(s) :: 17   133 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
3212 34102 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37975          
3227 48059 Permitted Site 1 Tree(s) :: 17   230 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
3266 44618 Permitted Site 1 Tree(s) :: 17   182 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
3285 44952 Permitted Site 1 Tree(s) :: 17   65 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
3297 44585 Permitted Site 1 Tree(s) :: 17   139 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
3322 44559 Permitted Site 1 Tree(s) :: 17   16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
3393 33932 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/25/1997 12:00:00 AM     Permit Number 37893          
3395 46141 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2001 12:00:00 AM     Permit Number 44490          
3408 44959 Permitted Site 1 Tree(s) :: 17   72 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
3420 35199 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
3444 48277 Permitted Site 1 Tree(s) :: 17   87 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
3448 48107 Permitted Site 1 Tree(s) :: 17   202 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
3458 44636 Permitted Site 1 Tree(s) :: 17   164 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
3539 46147 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2001 12:00:00 AM     Permit Number 44490          
3543 44857 Permitted Site 1 Tree(s) :: 17   31 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
3545 43015 Permitted Site 1 Geijera parviflora :: Australian Willow 68   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2000 12:00:00 AM     Permit Number 42880          
3614 46882 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/2002 12:00:00 AM     Permit Number 44940          
3663 36860 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
3668 43018 Permitted Site 1 Geijera parviflora :: Australian Willow 68   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2000 12:00:00 AM     Permit Number 42880          
3744 46296 Permitted Site 1 Robinia x ambigua :: Locust 33   13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/31/2002 12:00:00 AM     Permit Number 44564          
3751 45854 Permitted Site 1 Tree(s) :: 17   71 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
3765 45857 Permitted Site 1 Tree(s) :: 17   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 3280.418ms · Data source: data.sfgov.org