Street_Tree_List

Data source: data.sfgov.org

105 rows where qCareAssistant = 3

View and edit SQL

Suggested facets: qLegalStatus, qSpecies, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize, PermitNotes

qCareAssistant

  • Private · 105
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
344 251279 DPW Maintained 3 Quercus suber :: Cork Oak 76 1200x Hudson Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3     3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
358 251286 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 1299x Hudson Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 02/09/1998 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
375 251284 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 1299x Hudson Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 06/21/1996 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
385 251282 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 1299x Hudson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 04/07/2016 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
390 251276 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1175X Hudson Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/09/1998 12:00:00 AM   3x3   6017547.0 2094834.0 37.732999109091 -122.381690402626 (37.732999109091, -122.381690402626)
391 251275 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1175x Hudson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 09/16/2011 12:00:00 AM   3x3   6017547.0 2094834.0 37.732999109091 -122.381690402626 (37.732999109091, -122.381690402626)
392 251280 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 1275x Hudson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/11/2006 12:00:00 AM   3x3   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
393 251277 DPW Maintained 3 Quercus suber :: Cork Oak 76 1200x Hudson Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 10/26/2011 12:00:00 AM   3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
398 251281 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 1275x Hudson Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/23/2006 12:00:00 AM   3x3   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
402 251283 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 1299x Hudson Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 06/06/1997 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
409 251278 DPW Maintained 3 Quercus suber :: Cork Oak 76 1200x Hudson Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 01/27/2016 09:31:00 AM   3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
410 251287 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 1299x Hudson Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 02/09/1998 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
445 251285 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1299x Hudson Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/11/2006 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
498 248943 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1500x Galvez Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 04/10/2017 01:08:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
499 248944 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1500x Galvez Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 04/10/2017 12:58:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
507 251288 DPW Maintained 3 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 1335 Fairfax Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/18/2017 01:58:00 PM 3 3x3   6016828.0 2097292.0 37.7397085577181 -122.38434732981199 (37.7397085577181, -122.384347329812)
517 248948 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1500x Galvez Ave 18 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 04/10/2017 01:15:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
525 248950 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1500x Galvez Ave 26 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 04/10/2017 01:18:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
527 248946 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1500x Galvez Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 04/10/2017 01:12:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
528 248942 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1500x Galvez Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/18/2017 12:56:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
679 187631 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 4255x Judah St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/28/2017 11:56:00 AM 3 3x3   5981269.0 2105492.0 37.760193098921796 -122.50790142928699 (37.7601930989218, -122.507901429287)
746 251371 DPW Maintained 3 Ficus nitida :: Laurel Fig 43 390 06th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
750 251368 DPW Maintained 3 Celtis sinensis :: Chinese Hackberry 111 270 06th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3     3x3   6010822.0 2111616.0 37.7787051302825 -122.40612250689199 (37.7787051302825, -122.406122506892)
781 251370 DPW Maintained 3 Ginkgo biloba :: Maidenhair Tree 44 390 06th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
786 251369 DPW Maintained 3 Ficus nitida :: Laurel Fig 43 390 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
975 251421 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 300X King St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 09/30/2014 01:37:00 PM   3x3   6014268.0 2110701.0 37.776384889187796 -122.394137287636 (37.7763848891878, -122.394137287636)
996 248949 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1500x Galvez Ave 19 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/18/2017 09:13:00 AM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
1063 248924 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 201x Cashmere St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 04/29/2017 10:39:00 AM 3 3x3   6016272.0 2096170.0 37.7365970133228 -122.38619155869101 (37.7365970133228, -122.386191558691)
1491 110535 Private 5 Maytenus boaria :: Mayten 22 100X ASHBURY ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 City College 12 Private 3 04/21/2015 04:52:00 PM 3 3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
1496 110536 Private 5 Lophostemon confertus :: Brisbane Box 11 100X ASHBURY ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 City College 12 Private 3 05/29/2015 02:12:00 PM 3 3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
1568 251592 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1999X Hyde St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3     3x3   6007220.0 2119146.0 37.799178528828 -122.41911751038602 (37.799178528828, -122.419117510386)
1986 251131 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 354 05th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 02/14/2014 12:00:00 AM   3x3 Permit Number 779305 6011875.0 2111882.0 37.779494345884295 -122.402498458881 (37.7794943458843, -122.402498458881)
2087 252878 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 300X King St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3     3x3   6014268.0 2110701.0 37.776384889187796 -122.394137287636 (37.7763848891878, -122.394137287636)
3317 253413 Undocumented 2 Potential Site :: Potential Site 29 2433 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9 Private 3     3x3   5989193.66308 2098780.80152 37.7422296590049 -122.48000293550501 (37.7422296590049, -122.480002935505)
4532 253201 DPW Maintained 3 Ficus nitida :: Laurel Fig 43 800 Oak St 3 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2 Private 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4536 253202 DPW Maintained 3 Ficus nitida :: Laurel Fig 43 800 Oak St 4 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2 Private 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4541 253199 DPW Maintained 3 Ficus nitida :: Laurel Fig 43 800 Oak St 1 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2 Private 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4545 253200 DPW Maintained 3 Ficus nitida :: Laurel Fig 43 800 Oak St 2 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2 Private 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4620 253639 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 4405 California St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3     3x3   5993893.0 2114132.0 37.784651953064206 -122.46486880251801 (37.7846519530642, -122.464868802518)
4668 253644 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1200x La Salle Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 11/05/1992 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4669 253646 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1200x La Salle Ave 22 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 11/09/1992 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4684 253645 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1200x La Salle Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/11/2006 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4719 253672 DPW Maintained 3 Tree(s) :: 17 390 06th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
6296 95177 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1227 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3   3 3x3   6001304.8007 2112660.3061 37.781035607967404 -122.439120992436 (37.7810356079674, -122.439120992436)
6709 85477 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1711 Hyde St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 02/10/2011 12:00:00 AM 18 4x4 Permit Number 56911 6007344.49108 2118216.09025 37.7966322393414 -122.418620748847 (37.7966322393414, -122.418620748847)
7078 95163 DPW Maintained 3 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 998 Divisadero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 04/21/2016 12:00:00 AM 3 3x3   6001491.8688 2111772.0851 37.7786074207661 -122.438410176931 (37.7786074207661, -122.438410176931)
7204 11066 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1711 Hyde St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 02/10/2011 12:00:00 AM 60 4x4 Permit Number 56911 6007343.19343 2118232.87472 37.7966782522465 -122.418626429868 (37.7966782522465, -122.418626429868)
9027 21627 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1615 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 10/14/2010 12:00:00 AM 6 4X4 Permit Number 53778 6004639.3671 2114660.2794 37.7867162131248 -122.42772760613701 (37.7867162131248, -122.427727606137)
13274 187630 DPW Maintained 3 Melaleuca quinquenervia :: Cajeput 50 4255x Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/23/2015 05:35:00 PM   3x3   5981269.0 2105492.0 37.760193098921796 -122.50790142928699 (37.7601930989218, -122.507901429287)
20491 85214   Jacaranda mimosifolia :: Jacaranda 52 2889 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 04/13/2007 12:00:00 AM 3 3x3 under 3yr maintenance agreement. ends on 4/13/2007 6009588.01504 2102148.81833 37.75264132339179 -122.409722943913 (37.7526413233918, -122.409722943913)
22922 251160 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 1126x Portola Dr 1 Median : Cutout 11 Tree 1 DPW 2 Private 3     3x3   5994964.0 2098019.0 37.7404715144277 -122.459995857341 (37.7404715144277, -122.459995857341)
25916 115393 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 800x Rutland St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Public Library 14 Private 3   4 3x3   6009906.5006099995 2087474.9292900001 37.712367789705 -122.407587055718 (37.712367789705, -122.407587055718)
39914 115395 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 800x Rutland St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Public Library 14 Private 3   4 3x3   6009893.891419999 2087442.30364 37.7122775004839 -122.40762833818998 (37.7122775004839, -122.40762833819)
53226 115394 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 800x Rutland St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Public Library 14 Private 3   4 3x3   6009899.82351 2087457.5745 37.7123197632209 -122.407608911042 (37.7123197632209, -122.407608911042)
61148 85309   Olea europaea :: Olive Tree 41 1250 Haight St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 07/26/2007 12:00:00 AM 3 3x3 Under 3 yr maintenance agreement. Ends 7/27/2010. 6000155.2862 2108898.36192 37.77064078968729 -122.442827504693 (37.7706407896873, -122.442827504693)
79581 117011 Undocumented 2 Maytenus boaria :: Mayten 22 457X CASTRO ST 1 Back Yard : Cutout 16 Tree 1 MTA 6 Private 3   27 3x6   6002348.0 2105584.0 37.7616651256499 -122.435005811888 (37.7616651256499, -122.435005811888)
81359 112751 Undocumented 2 Ficus nitida :: Laurel Fig 43 135X TRENTON ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Housing Authority 20 Private 3     3x3   6009947.0 2118097.0 37.796451422722605 -122.409607037418 (37.7964514227226, -122.409607037418)
82777 85446   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y12 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
85683 87557 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 408X Lake St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/03/2007 12:00:00 AM 3 3x3   5994236.225190001 2114896.53302 37.786770936164395 -122.463736876784 (37.7867709361644, -122.463736876784)
86565 91191 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 818 Van Ness Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 02/05/2009 12:00:00 AM   3x3 Permit Number 52040 6006711.43287 2113326.5718900003 37.7831711713524 -122.42046403454901 (37.7831711713524, -122.420464034549)
86815 112748 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 135X TRENTON ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Housing Authority 20 Private 3     3x3   6009947.0 2118097.0 37.796451422722605 -122.409607037418 (37.7964514227226, -122.409607037418)
88231 85433   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y1 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
89282 91179 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 1 Polk St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.41829917319299 (37.7785341058364, -122.418299173193)
91095 91190 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 818 Van Ness Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 02/05/2009 12:00:00 AM   3x3 Permit Number 52040 6006711.43287 2113326.5718900003 37.7831711713524 -122.42046403454901 (37.7831711713524, -122.420464034549)
95845 85448   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y14 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
96265 85437   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y4 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
97533 85444   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y10 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
98712 85439   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y5 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
98784 95178 DPW Maintained 3 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1215 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3   3 3x3   6001286.14287 2112595.80793 37.7808574507306 -122.439180914838 (37.7808574507306, -122.439180914838)
99579 85445   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y11 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
101441 112750 Undocumented 2 Ficus nitida :: Laurel Fig 43 135X TRENTON ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Housing Authority 20 Private 3     3x3   6009947.0 2118097.0 37.796451422722605 -122.409607037418 (37.7964514227226, -122.409607037418)
102102 108939 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1801 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Public Library 14 Private 3 01/13/2015 12:00:00 AM 3 3x3 Permit Number 774694 6004341.9 2118349.2 37.7968282226561 -122.42901988134199 (37.7968282226561, -122.429019881342)
102543 21639 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1641 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 10/14/2010 12:00:00 AM 18 4X4 Permit Number 53778 6004750.8195846 2114677.2774985 37.7867691895303 -122.42734321826401 (37.7867691895303, -122.427343218264)
102642 85435   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y3 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/07/2006 12:00:00 AM 3 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
103232 95167 DPW Maintained 3 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1300 DIVISADERO ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3   3 3x3   6001355.0 2112906.0 37.781713077167396 -122.43896494142 (37.7817130771674, -122.43896494142)
103498 85440   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y6 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
105788 85443   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y9 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3   6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
107282 100095 Permitted Site 1 Tree(s) :: 17 4372 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3 Private 3 07/03/2012 12:00:00 AM   3x3 Permit Number 769070 6001507.0 2100613.7 37.747970090970504 -122.43755853273001 (37.7479700909705, -122.43755853273)
107477 106680 Permitted Site 1 Tree(s) :: 17 2200 LYON ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9 Private 3 06/24/2014 12:00:00 AM 20 3x3 Permit Number 773028 5999398.2 2116386.7 37.7911586409716 -122.445984946853 (37.7911586409716, -122.445984946853)
109671 59556 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 4079 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5 Private 3 02/03/1981 12:00:00 AM 15   Permit Number 18942 6003404.16952868 2100363.87266154 37.747391805572796 -122.43098037560101 (37.7473918055728, -122.430980375601)
110121 49668 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 Private 3 04/18/2011 12:00:00 AM     Permit Number 46510 6000239.54014865 2120711.44405841 37.8030812490195 -122.44338472026199 (37.8030812490195, -122.443384720262)
114566 114692 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 391 Girard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9 Private 3 12/01/2015 12:00:00 AM     Permit Number 774511 6010909.5 2092975.0 37.7275259502006 -122.404507285761 (37.7275259502006, -122.404507285761)
114568 91178 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 1 Polk St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.41829917319299 (37.7785341058364, -122.418299173193)
114637 106120 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 849X Cabrillo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9 Private 3     6x9   5992954.7 2110649.6 37.775036084258794 -122.46786160539301 (37.7750360842588, -122.467861605393)
116277 102879 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 1680X Revere Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Public Library 14 Private 3 07/23/2010 12:00:00 AM 2 4x4 Permit Number 53643 6014844.7 2094689.6 37.732453033840706 -122.39102294843501 (37.7324530338407, -122.391022948435)
118120 114914 Undocumented 2 Eucalyptus Spp :: Eucalyptus 40 200x MIDDLE POINT RD 1 Sidewalk: Curb side : Cutout 1 Tree 1 Housing Authority 20 Private 3     3x3   6017974.0 2095171.0 37.7339480130439 -122.380237547959 (37.7339480130439, -122.380237547959)
119540 85436   Lophostemon confertus :: Brisbane Box 11 1397X Buchanan St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/17/2007 12:00:00 AM 3 3x3 Maintenance agreement ends 8/17/2010 6004184.830731 2113056.513958 37.782286952179 -122.429185796304 (37.782286952179, -122.429185796304)
120602 115341 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 1514 SUNNYDALE AVE 2 Sidewalk: Property side : Yard 9 Tree 1 Housing Authority 20 Private 3     3x3   6006572.0 2087815.0 37.7131143345755 -122.41913622882099 (37.7131143345755, -122.419136228821)
120951 85249   Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1335 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 07/19/2007 12:00:00 AM 3 3x3 under 3 yr maintenance agreement. expires 7/19/2010 6001350.124369999 2111060.02557 37.7766442216524 -122.43884948393499 (37.7766442216524, -122.438849483935)
122914 85441   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y7 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
123072 85434   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y2 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/23/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
125403 91180 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 1 Polk St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.41829917319299 (37.7785341058364, -122.418299173193)
126214 91181 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 1 Polk St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.41829917319299 (37.7785341058364, -122.418299173193)
126348 85447   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y13 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
138572 112749 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 135X TRENTON ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Housing Authority 20 Private 3     3x3   6009947.0 2118097.0 37.796451422722605 -122.409607037418 (37.7964514227226, -122.409607037418)
140895 85310   Olea europaea :: Olive Tree 41 1250 Haight St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 07/27/2007 12:00:00 AM 3 3x3 Under 3 yr maintenance agreement. Ends 7/27/2010. 6000155.2862 2108898.36192 37.77064078968729 -122.442827504693 (37.7706407896873, -122.442827504693)
143542 85442   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y8 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
144030 15159 Permitted Site 1 Ficus nitida :: Laurel Fig 43 895X Mission St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5 Private 3   18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907)
144968 17872 Section 143 8 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 2148 Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 07/21/2010 12:00:00 AM 0 3X3 Permit Number 53638 6003654.7045158 2115269.5781823 37.788333445178104 -122.43117780902399 (37.7883334451781, -122.431177809024)
145363 85250   Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1335 Fulton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 07/19/2007 12:00:00 AM 15 3x3 under 3yr maintenance agreement. Expires 7/19/2010. 6001350.124369999 2111060.02557 37.7766442216524 -122.43884948393499 (37.7766442216524, -122.438849483935)

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