Street_Tree_List

Data source: data.sfgov.org

297 rows where qSpecies = 58 sorted by qSiteInfo

View and edit SQL

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

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo ▼ PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
185 251243 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 299x Chapman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6008953.0 2098186.0 37.7417246968109 -122.411638974942 (37.7417246968109, -122.411638974942)
438 157409 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 125 Highland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/06/2017 12:00:00 AM 3 3x5   6005572.56549 2096690.1102099998 37.7374271143738 -122.423221099494 (37.7374271143738, -122.423221099494)
440 157410 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 125 Highland Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/06/2017 12:00:00 AM 3 2x5   6005546.67522 2096690.9332 37.7374279129674 -122.423310672857 (37.7374279129674, -122.423310672857)
1060 71174 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1432 Santiago St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/22/1995 12:00:00 AM 3     5988368.0802 2099689.3718 37.7446763519612 -122.48292408536301 (37.7446763519612, -122.482924085363)
3095 204715 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 327 Carl St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2008 12:00:00 AM 3 Width 6ft Permit Number 51243 5996623.78142 2106956.86791 37.7651079834665 -122.454902653043 (37.7651079834665, -122.454902653043)
3465 39926 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 0 Arleta Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/1999 12:00:00 AM     Permit Number 41198          
5046 150652 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 647 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 4ft   6011556.07446 2105379.04628 37.7616209062969 -122.403144210544 (37.7616209062969, -122.403144210544)
5660 39923 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 0 Arleta Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/1999 12:00:00 AM     Permit Number 41198          
6711 31341 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 430 Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/29/2014 12:00:00 AM 3 3x3 Permit Number 772811 6005729.4209 2111051.1148 37.7768679337671 -122.423699563703 (37.7768679337671, -122.423699563703)
8008 39924 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 0 Arleta Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/1999 12:00:00 AM     Permit Number 41198          
8423 37327 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/15/1998 12:00:00 AM     Permit Number 39838          
9782 159354 Planning Code 138.1 required 4 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 417x Ellington Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998501.29354 2087549.7908 37.7119283225022 -122.44701212372802 (37.7119283225022, -122.447012123728)
10397 108837 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 699 Paris St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774665 6001210.74249 2089636.42248 37.7178121756617 -122.437796877731 (37.7178121756617, -122.437796877731)
10733 39925 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 0 Arleta Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/1999 12:00:00 AM     Permit Number 41198          
10903 110032 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 630 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/19/2015 12:00:00 AM 3 3x3 Permit Number 775191 6002420.02658 2090107.3938799999 37.719174047824104 -122.433650566035 (37.7191740478241, -122.433650566035)
11143 109071 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 35 Mount Vernon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/23/2015 12:00:00 AM 3 3x3 Permit Number 772757 5999530.156 2088703.36466 37.715154504538795 -122.443538910497 (37.7151545045388, -122.443538910497)
12013 116582 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 195 Maynard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/17/2016 12:00:00 AM 3 3x3 Permit Number 778001 6004664.28928 2093799.33843 37.729438402445105 -122.426155697039 (37.7294384024451, -122.426155697039)
12022 108898 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 378 Allison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772818 6000293.95374 2086893.3367700002 37.7102281038126 -122.440769142495 (37.7102281038126, -122.440769142495)
12119 102524 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 154 Wilde Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/03/2013 12:00:00 AM 16 3x3 Permit Number 770317 6011839.9295 2088903.3705900002 37.7163980403033 -122.401004803454 (37.7163980403033, -122.401004803454)
12216 108836 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 699 Paris St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774665 6001204.89947 2089626.81587 37.717785465811296 -122.437816386741 (37.7177854658113, -122.437816386741)
12503 93870 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400-422X Tocoloma Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773818 6012462.01959 2086667.4072599998 37.7102932120209 -122.398697717749 (37.7102932120209, -122.398697717749)
12527 108378 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 358 Edinburgh St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/19/2014 12:00:00 AM 3 3x3 Permit Number 773808 6003377.41913 2091635.77484 37.7234249209965 -122.43045021882 (37.7234249209965, -122.43045021882)
12634 109574 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400 France Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/24/2015 12:00:00 AM 3 3x3 Permit Number 774875 6002013.87176 2089826.5009400002 37.7183797243364 -122.435034407708 (37.7183797243364, -122.435034407708)
13070 93869 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400-422X Tocoloma Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773818 6012466.99875 2086683.8296 37.7103385819422 -122.398681660343 (37.7103385819422, -122.398681660343)
13992 108725 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 877 Rhode Island St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773104 6011895.30838 2104315.65478 37.758720008153 -122.401896177292 (37.758720008153, -122.401896177292)
14920 37328 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/15/1998 12:00:00 AM     Permit Number 39838          
16644 80780 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 702 Vermont St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773102 6011234.66837 2105019.04099 37.760614457905795 -122.404230490851 (37.7606144579058, -122.404230490851)
18455 51904 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 168 Caselli Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/18/2005 12:00:00 AM     Permit Number 48111 6000192.99372442 2104905.40226883 37.7596792654558 -122.44241036439301 (37.7596792654558, -122.442410364393)
20912 52837 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 4219@ CASTRO 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/22/2006 12:00:00 AM     Permit Number 48855 6002474.48025452 2100603.93596677 37.7479982404255 -122.434212332638 (37.7479982404255, -122.434212332638)
24397 222703 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 214 Bradford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6009527.84065 2097295.3841 37.7393114881468 -122.40958851400299 (37.7393114881468, -122.409588514003)
35603 204716 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 155 Madrone Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5992699.213880001 2098207.72713 37.7408591943976 -122.467840257748 (37.7408591943976, -122.467840257748)
36204 222700 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 551 Eureka St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6001566.9280900005 2102610.03358 37.7534549532875 -122.437494242369 (37.7534549532875, -122.437494242369)
37117 175815 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 616 Dwight St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6009798.67948 2091167.8757200001 37.722501823573 -122.40822001654301 (37.722501823573, -122.408220016543)
38985 123068 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 678 12th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5992266.69336 2110864.34538 37.7755859643914 -122.47025718989201 (37.7755859643914, -122.470257189892)
40369 222690 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1071 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6010267.11643 2102987.22407 37.754981431951606 -122.40743358371901 (37.7549814319516, -122.407433583719)
40968 91228 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 250 Texas St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/2010 12:00:00 AM 4 3x3 Permit Number 53161 6013714.91861 2105876.83519 37.7631080513185 -122.39571247215 (37.7631080513185, -122.39571247215)
44119 222706 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 4218 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001708.51992 2101780.94195 37.7511865150679 -122.43694523773199 (37.7511865150679, -122.436945237732)
44360 222680 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 76 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 6ft   6006248.111740001 2099605.96855 37.7454715078156 -122.421092396098 (37.7454715078156, -122.421092396098)
45347 108716 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 201 Randall St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773302 6004213.21698 2097517.4141599997 37.73962189424871 -122.427979939698 (37.7396218942487, -122.427979939698)
47522 188400 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1045 Tennessee St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6015554.8451 2104260.21833 37.7587713477501 -122.389235841663 (37.7587713477501, -122.389235841663)
48133 60575 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 250 Texas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/16/1982 12:00:00 AM 3   Permit Number 20188 6013715.09373 2105885.47906 37.763131795228794 -122.395712472146 (37.7631317952288, -122.395712472146)
48921 204737 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 230 Acadia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001436.76661 2095116.79206 37.7328728755875 -122.43740783373 (37.7328728755875, -122.43740783373)
49828 222696 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 73 Leese St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6005530.879319999 2096284.28114 37.736310445970204 -122.423336387162 (37.7363104459702, -122.423336387162)
52474 204720 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 60 Agua Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5997138.083869999 2098588.27013 37.7421593919444 -122.452519836329 (37.7421593919444, -122.452519836329)
53901 222695 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 52 Mirabel Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6007649.81084 2099951.99688 37.746500541785394 -122.416270032545 (37.7465005417854, -122.416270032545)
54560 175803 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 421 Wheeler Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6011997.87722 2086794.11576 37.7106152574533 -122.400310793023 (37.7106152574533, -122.400310793023)
61729 222698 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 4215 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6002437.17664 2100607.07314 37.7480047370361 -122.434341551122 (37.7480047370361, -122.434341551122)
62729 96749 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 399X Liberty St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 1.5x2   6003700.0 2103889.2 37.7570882837734 -122.430208878023 (37.7570882837734, -122.430208878023)
62782 175806 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 154 Raymond Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6010320.93963 2087695.47295 37.7129965480265 -122.406170150427 (37.7129965480265, -122.406170150427)
63826 204741 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 843 Detroit St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5999425.99834 2095633.84899 37.734178072446205 -122.444396695552 (37.7341780724462, -122.444396695552)
70380 204738 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 130 Joost Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6001200.02257 2094962.19919 37.7324349372236 -122.43821524594401 (37.7324349372236, -122.438215245944)
70804 175801 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 421 Wheeler Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6011986.878880001 2086756.6218599998 37.7105116933366 -122.400346174163 (37.7105116933366, -122.400346174163)
71501 188399 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 619 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6010997.55787 2105333.97174 37.7614659351153 -122.40507272844499 (37.7614659351153, -122.405072728445)
77303 34415 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 209 Randall St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/15/1997 12:00:00 AM     Permit Number 38162 6004171.37602222 2097541.35369817 37.739685259534504 -122.42812631334499 (37.7396852595345, -122.428126313345)
77589 110797 Section 143 8 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 440 29th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/06/2015 12:00:00 AM 3     6003697.7 2098979.2 37.743606443306206 -122.42986661573299 (37.7436064433062, -122.429866615733)
77695 42820 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 801 Bay St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/29/2000 12:00:00 AM     Permit Number 42765 6006945.227660701 2121167.35462349 37.8047131790945 -122.42021185631901 (37.8047131790945, -122.420211856319)
77758 42824 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 801 Bay St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/11/2004 12:00:00 AM     Permit Number 42765 6006945.227660701 2121167.35462349 37.8047131790945 -122.42021185631901 (37.8047131790945, -122.420211856319)
78290 37278 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 700 Sanchez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/15/1998 12:00:00 AM     Permit Number 39817 6003661.86134005 2104206.66341524 37.7579578025996 -122.430363425655 (37.7579578025996, -122.430363425655)
78919 42827 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 801 Bay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/11/2004 12:00:00 AM     Permit Number 42765 6006945.227660701 2121167.35462349 37.8047131790945 -122.42021185631901 (37.8047131790945, -122.420211856319)
78986 105989 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 651X Duncan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6002337.0 2099724.0 37.745574339333 -122.434624822764 (37.745574339333, -122.434624822764)
79940 37260 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 801X Church St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/1998 12:00:00 AM 3 3x3 Permit Number 39806 6017074.59942826 2104815.9109509 37.7603812969624 -122.38401847505399 (37.7603812969624, -122.384018475054)
79996 96750 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 399X Liberty St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 1.5x2   6003700.0 2103889.2 37.7570882837734 -122.430208878023 (37.7570882837734, -122.430208878023)
81119 22153 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1570X Fairfax Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     0 3X3   6015582.155925799 2098251.0940713002 37.742273066345604 -122.388721900676 (37.7422730663456, -122.388721900676)
81255 50394 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 84 Sylvan Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2003 12:00:00 AM     Permit Number 47045 5987580.16978348 2095308.26318011 37.7326011016802 -122.48532707377899 (37.7326011016802, -122.485327073779)
81516 50910 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 2450 17th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/26/2004 12:00:00 AM 2 3x9 Permit Number 772737 5991103.05311172 2098729.45888754 37.742199437798 -122.47339717645399 (37.742199437798, -122.473397176454)
81823 36071 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1504 Bryant St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/28/1998 12:00:00 AM     Permit Number 39187 6009387.99483758 2107777.56202059 37.7680853638298 -122.410812146882 (37.7680853638298, -122.410812146882)
81984 14597 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1245 Masonic Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/2008 12:00:00 AM 3     5999399.25196 2108537.97287 37.769608122005 -122.445416710249 (37.769608122005, -122.445416710249)
82156 36956 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 16 05th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/29/1998 12:00:00 AM     Permit Number 39587 5994274.56771258 2115474.49567321 37.7883600733979 -122.463646184404 (37.7883600733979, -122.463646184404)
82453 42828 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 801 Bay St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/11/2004 12:00:00 AM     Permit Number 42765 6006945.227660701 2121167.35462349 37.8047131790945 -122.42021185631901 (37.8047131790945, -122.420211856319)
83513 102091 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 27 Santa Ana Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/18/2012 12:00:00 AM   3x3 Permit Number 769734 5992609.4 2096703.2 37.7367229555432 -122.468041385671 (37.7367229555432, -122.468041385671)
83692 109401 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1588 WALLER ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997977.9 2108248.0 37.7687306888354 -122.450312188331 (37.7687306888354, -122.450312188331)
84059 51242 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 80 De Soto St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/17/2004 12:00:00 AM     Permit Number 47612 5993144.07933001 2091663.61630064 37.722916365509704 -122.4658267259 (37.7229163655097, -122.4658267259)
84993 117424 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 600x POWHATTAN AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6008524.0 2098073.0 37.7413903494898 -122.41311433102699 (37.7413903494898, -122.413114331027)
85068 37279 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 700 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/15/1998 12:00:00 AM     Permit Number 39817 6003661.86134005 2104206.66341524 37.7579578025996 -122.430363425655 (37.7579578025996, -122.430363425655)
85314 40436 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 250 Banks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/08/1999 12:00:00 AM     Permit Number 41528 6008599.59735478 2097476.96685444 37.7397580168027 -122.412810811968 (37.7397580168027, -122.412810811968)
86034 51889 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 340 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/18/2005 12:00:00 AM     Permit Number 48102 6004103.48678716 2096538.35102027 37.736927401104396 -122.42828957914601 (37.7369274011044, -122.428289579146)
87762 50399 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 83 Sylvan Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2003 12:00:00 AM     Permit Number 47050 5987527.82253963 2095318.01016643 37.732624814623605 -122.485508763661 (37.7326248146236, -122.485508763661)
88482 92854 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 52 Prentiss St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/14/2009 12:00:00 AM   3x4 Permit Number 53073 6008847.1 2098275.4 37.7419642285502 -122.412011459633 (37.7419642285502, -122.412011459633)
88611 50909 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 2450 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/29/2014 12:00:00 AM     Permit Number 772737 5991103.05311172 2098729.45888754 37.742199437798 -122.47339717645399 (37.742199437798, -122.473397176454)
88809 37303 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400 Hill St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/15/1998 12:00:00 AM     Permit Number 39826 6003717.20570413 2103355.3114542 37.7556233268944 -122.430111288531 (37.7556233268944, -122.430111288531)
89470 50387 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 296 Liberty St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532583998 37.75737018369129 -122.427864268021 (37.7573701836913, -122.427864268021)
89633 55158 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 4218 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/26/2016 12:00:00 AM     Permit Number 775652 6001766.13275037 2101783.99509326 37.751198172676 -122.436746225237 (37.751198172676, -122.436746225237)
90034 42692 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 2500 Larkin St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2000 12:00:00 AM     Permit Number 42711 6006694.5506045995 2119774.0082852 37.8008732765742 -122.42098036158701 (37.8008732765742, -122.420980361587)
90437 109398 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1588 WALLER ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/13/2015 12:00:00 AM 3 3x3 Permit Number 774632 5997977.9 2108248.0 37.7687306888354 -122.450312188331 (37.7687306888354, -122.450312188331)
90766 47962 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 545 Melrose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/2002 12:00:00 AM     Permit Number 45692 5996911.63382453 2095401.78894083 37.733397110236 -122.45307285643601 (37.733397110236, -122.453072856436)
91092 51953 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 82 Mary St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2005 12:00:00 AM     Permit Number 48176 6010868.83737248 2112458.01845687 37.781019735711006 -122.40601981145599 (37.781019735711, -122.406019811456)
91902 91227 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 250 Texas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/2010 12:00:00 AM   3x3 Permit Number 53161 6013717.0 2105930.0 37.763254145992796 -122.39570899856199 (37.7632541459928, -122.395708998562)
92997 37307 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400 Hill St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/15/1998 12:00:00 AM     Permit Number 39826 6003717.20570413 2103355.3114542 37.7556233268944 -122.430111288531 (37.7556233268944, -122.430111288531)
94233 115439 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 77 Mirabel Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/01/2016 12:00:00 AM 3   Permit Number 777507 6007860.5 2100030.9 37.746729037116104 -122.41554707594 (37.7467290371161, -122.41554707594)
94464 36069 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1504 Bryant St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/19/2002 12:00:00 AM     Permit Number 44775 6009387.99483758 2107777.56202059 37.7680853638298 -122.410812146882 (37.7680853638298, -122.410812146882)
94670 109400 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1588 WALLER ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997977.9 2108248.0 37.7687306888354 -122.450312188331 (37.7687306888354, -122.450312188331)
94755 105988 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 651X Duncan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6002337.0 2099724.0 37.745574339333 -122.434624822764 (37.745574339333, -122.434624822764)
96552 36068 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1504 Bryant St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/28/1998 12:00:00 AM     Permit Number 39187 6009387.99483758 2107777.56202059 37.7680853638298 -122.410812146882 (37.7680853638298, -122.410812146882)
96969 109399 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1588 WALLER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997977.9 2108248.0 37.7687306888354 -122.450312188331 (37.7687306888354, -122.450312188331)
97134 122681 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 598x Powhattan Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6008469.0 2098078.0 37.7414009906205 -122.413304856031 (37.7414009906205, -122.413304856031)
97304 37262 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 801X Church St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/1998 12:00:00 AM 3 3x3 Permit Number 39806 6017074.59942826 2104815.9109509 37.7603812969624 -122.38401847505399 (37.7603812969624, -122.384018475054)
97803 45537 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 79 Melba Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2001 12:00:00 AM     Permit Number 44293 5989585.76469698 2094846.08328142 37.7314487101847 -122.478359538262 (37.7314487101847, -122.478359538262)
99854 37306 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400 Hill St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/15/1998 12:00:00 AM     Permit Number 39826 6003717.20570413 2103355.3114542 37.7556233268944 -122.430111288531 (37.7556233268944, -122.430111288531)
100374 52165 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 2981 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/01/2005 12:00:00 AM     Permit Number 48358 6009655.09893949 2101001.15400866 37.7494938511533 -122.409409967788 (37.7494938511533, -122.409409967788)
101349 51952 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 82 Mary St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2005 12:00:00 AM     Permit Number 48176 6010868.83737248 2112458.01845687 37.781019735711006 -122.40601981145599 (37.781019735711, -122.406019811456)

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