Street_Tree_List

Data source: data.sfgov.org

189,144 rows sorted by qAddress

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: qLegalStatus

Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
3821 3821 46195 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/31/2001 12:00:00 AM     Permit Number 44518          
3838 3838 48141 Permitted Site 1 Tree(s) :: 17   251 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
3864 3864 44703 Permitted Site 1 Tree(s) :: 17   40 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
3875 3875 48176 Permitted Site 1 Tree(s) :: 17   57 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
3909 3909 48174 Permitted Site 1 Tree(s) :: 17   67 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
4009 4009 34002 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 37940          
4038 4038 45886 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
4053 4053 45907 Permitted Site 1 Tree(s) :: 17   62 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
4084 4084 45961 Permitted Site 1 Tree(s) :: 17   162 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
4133 4133 48248 Permitted Site 1 Tree(s) :: 17   112 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
4171 4171 39901 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/03/2002 12:00:00 AM     Permit Number 41185          
4256 4256 44534 Permitted Site 1 Tree(s) :: 17   35 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
4347 4347 45877 Permitted Site 1 Tree(s) :: 17   31 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
4378 4378 45905 Permitted Site 1 Tree(s) :: 17   35 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
4492 4492 44688 Permitted Site 1 Tree(s) :: 17   108 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
4519 4519 46000 Permitted Site 1 Tree(s) :: 17   118 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
4531 4531 48083 Permitted Site 1 Tree(s) :: 17   193 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
4552 4552 97357 Permitted Site 1 Tree(s) :: 17   7 Unaccepted Street : Yard 14 Tree 1 Private 1                    
4576 4576 60252 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/23/1982 12:00:00 AM     Permit Number 19804          
4629 4629 34972 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/18/1997 12:00:00 AM     Permit Number 38555          
4714 4714 44605 Permitted Site 1 Tree(s) :: 17   148 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
4741 4741 48244 Permitted Site 1 Tree(s) :: 17   122 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
4774 4774 44595 Permitted Site 1 Tree(s) :: 17   150 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
4823 4823 45930 Permitted Site 1 Tree(s) :: 17   41 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
4831 4831 44933 Permitted Site 1 Tree(s) :: 17   166 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
4913 4913 97358 Permitted Site 1 Tree(s) :: 17   8 Unaccepted Street : Yard 14 Tree 1 Private 1                    
4975 4975 47475 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/14/2002 12:00:00 AM     Permit Number 45375          
4991 4991 35276 Permitted Site 1 Tree(s) :: 17   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/17/1998 12:00:00 AM     Permit Number 38758          
5018 5018 44607 Permitted Site 1 Tree(s) :: 17   171 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
5109 5109 36635 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21   10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/1998 12:00:00 AM     Permit Number 39461          
5121 5121 45851 Permitted Site 1 Tree(s) :: 17   74 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
5128 5128 44995 Permitted Site 1 Tree(s) :: 17   107 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
5147 5147 48270 Permitted Site 1 Tree(s) :: 17   94 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
5156 5156 44926 Permitted Site 1 Tree(s) :: 17   199 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
5208 5208 48263 Permitted Site 1 Tree(s) :: 17   127 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
5259 5259 42922 Permitted Site 1 Melaleuca quinquenervia :: Cajeput 50   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2000 12:00:00 AM     Permit Number 42829          
5261 5261 44583 Permitted Site 1 Tree(s) :: 17   147 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
5268 5268 44602 Permitted Site 1 Tree(s) :: 17   130 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
5270 5270 30482 Permitted Site 1 Tree(s) :: 17   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/05/1956 12:00:00 AM     Permit Number 147          
5277 5277 46045 Permitted Site 1 Tree(s) :: 17   172 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
5286 5286 48241 Permitted Site 1 Tree(s) :: 17   25 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
5321 5321 36650 Permitted Site 1 Tree(s) :: 17   9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/1998 12:00:00 AM     Permit Number 39461          
5325 5325 40088 Permitted Site 1 Prunus spp :: Cherry 84   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/09/1999 12:00:00 AM     Permit Number 41311          
5335 5335 43483 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2000 12:00:00 AM     Permit Number 43169          
5355 5355 48328 Permitted Site 1 Tree(s) :: 17   138 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
5360 5360 45002 Permitted Site 1 Tree(s) :: 17   114 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
5385 5385 44657 Permitted Site 1 Tree(s) :: 17   67 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
5386 5386 44855 Permitted Site 1 Tree(s) :: 17   17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
5392 5392 44924 Permitted Site 1 Tree(s) :: 17   197 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
5393 5393 44945 Permitted Site 1 Tree(s) :: 17   178 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
5401 5401 36558 Permitted Site 1 Tree(s) :: 17   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/19/1998 12:00:00 AM     Permit Number 39428          
5431 5431 36639 Permitted Site 1 Robinia x ambigua :: Locust 33   15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/1998 12:00:00 AM     Permit Number 39461          
5452 5452 44709 Permitted Site 1 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
5455 5455 48160 Permitted Site 1 Tree(s) :: 17   270 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
5458 5458 44616 Permitted Site 1 Tree(s) :: 17   180 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
5482 5482 44652 Permitted Site 1 Tree(s) :: 17   72 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
5514 5514 66482 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/31/1991 12:00:00 AM     Permit Number 29639          
5515 5515 48743 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 46023          
5540 5540 48296 Permitted Site 1 Tree(s) :: 17   135 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
5552 5552 44936 Permitted Site 1 Tree(s) :: 17   169 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
5567 5567 44850 Permitted Site 1 Tree(s) :: 17   39 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
5568 5568 48127 Permitted Site 1 Tree(s) :: 17   295 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
5571 5571 44915 Permitted Site 1 Tree(s) :: 17   188 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
5573 5573 44667 Permitted Site 1 Tree(s) :: 17   78 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
5574 5574 45943 Permitted Site 1 Tree(s) :: 17   183 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
5581 5581 44876 Permitted Site 1 Tree(s) :: 17   149 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
5586 5586 43016 Permitted Site 1 Geijera parviflora :: Australian Willow 68   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2000 12:00:00 AM     Permit Number 42880          
5590 5590 45005 Permitted Site 1 Tree(s) :: 17   117 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
5602 5602 48314 Permitted Site 1 Tree(s) :: 17   180 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
5603 5603 34246 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 38056          
5605 5605 34138 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37987          
5612 5612 35700 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85   14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/10/1998 12:00:00 AM     Permit Number 38993          
5616 5616 44680 Permitted Site 1 Tree(s) :: 17   100 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
5617 5617 35204 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2   18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
5642 5642 48249 Permitted Site 1 Tree(s) :: 17   113 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
5673 5673 46713 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2002 12:00:00 AM     Permit Number 44843          
5690 5690 34100 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37975          
5692 5692 64906 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/20/1989 12:00:00 AM     Permit Number 25933          
5706 5706 48133 Permitted Site 1 Tree(s) :: 17   31 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
5714 5714 46005 Permitted Site 1 Tree(s) :: 17   191 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
5746 5746 31847 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/1995 12:00:00 AM     Permit Number 35298          
5752 5752 44578 Permitted Site 1 Tree(s) :: 17   142 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
5753 5753 44603 Permitted Site 1 Tree(s) :: 17   121 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
5754 5754 48349 Permitted Site 1 Tree(s) :: 17   152 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
5758 5758 48084 Permitted Site 1 Tree(s) :: 17   194 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
5768 5768 44674 Permitted Site 1 Tree(s) :: 17   56 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
5773 5773 45953 Permitted Site 1 Tree(s) :: 17   150 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
5780 5780 59741 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/03/1981 12:00:00 AM     Permit Number 19174          
5783 5783 44584 Permitted Site 1 Tree(s) :: 17   114 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
5789 5789 48478 Permitted Site 1 Tree(s) :: 17   6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 45832          
5809 5809 46193 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/31/2001 12:00:00 AM     Permit Number 44518          
5810 5810 48078 Permitted Site 1 Tree(s) :: 17   244 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
5816 5816 48139 Permitted Site 1 Tree(s) :: 17   249 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
5825 5825 45844 Permitted Site 1 Tree(s) :: 17   82 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
5838 5838 45000 Permitted Site 1 Tree(s) :: 17   112 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
5841 5841 45969 Permitted Site 1 Tree(s) :: 17   154 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
5859 5859 48262 Permitted Site 1 Tree(s) :: 17   126 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
5873 5873 36615 Permitted Site 1 Robinia x ambigua :: Locust 33   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/1998 12:00:00 AM     Permit Number 39461          
5885 5885 46715 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2002 12:00:00 AM     Permit Number 44843          
5893 5893 46201 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/31/2001 12:00:00 AM     Permit Number 44518          

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 285.938ms · Data source: data.sfgov.org