Street_Tree_List

Data source: data.sfgov.org

297 rows where qSpecies = 58 sorted by qCaretaker

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
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)
767 251382 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 731 Huron Ave 1 Front Yard : Yard 7 Tree 1 Private 1       2x5   5997668.0 2087467.0 37.7116533538928 -122.449886244657 (37.7116533538928, -122.449886244657)
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)
2939 203654 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 42 Mangels Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1   08/14/2017 12:00:00 AM 3 Width 8ft   6001070.39767 2095226.13763 37.7331522778487 -122.438682294452 (37.7331522778487, -122.438682294452)
3005 208852 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 42 Mangels Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1   08/14/2017 12:00:00 AM 3 Width 8ft   6001113.97001 2095223.0116299998 37.733146173254205 -122.43853142959101 (37.7331461732542, -122.438531429591)
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)
11005 108841 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 125 Pioche St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1 FUF 1 01/06/2015 12:00:00 AM 3   Permit Number 773762 6006499.8637 2093472.98879 37.7286458955893 -122.419786780156 (37.7286458955893, -122.419786780156)
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)
18891 107407 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 171 TWIN PEAKS BLVD 1 Front Yard : Yard 7 Tree 1 Private 1     12     5998631.4 2104681.4 37.7589750798494 -122.44779499190099 (37.7589750798494, -122.447794991901)
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)
24848 188408 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 2033 22nd St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 3ft   6011976.80987 2103707.86259 37.7570556930855 -122.40157158857299 (37.7570556930855, -122.401571588573)
26902 175812 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 15 Athens St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2     6005342.42292 2093158.1624099999 37.727716180055204 -122.42376574960899 (37.7277161800552, -122.423765749609)
28419 108850 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 250x MONTCALM ST 1 Back Yard : Yard 13 Tree 1 Private 1   02/09/2015 12:00:00 AM 3   Permit Number 774524 6009909.2 2099657.1 37.745817608401104 -122.40843648152 (37.7458176084011, -122.40843648152)
28752 222686 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1201 San Jose Ave 17 Front Yard : Yard 7 Tree 1 Private 1     1     6004284.84781 2095906.59844 37.735203011805204 -122.427617536921 (37.7352030118052, -122.427617536921)
29739 187574 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 72 Bishop St 1 Side Yard : Yard 17 Tree 1 Private 1     10     6010842.8913900005 2089488.5588 37.71794917929 -122.404492242147 (37.71794917929, -122.404492242147)
29820 187571 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 73 Bishop St 2 Side Yard : Yard 17 Tree 1 Private 1     7     6010860.52073 2089475.11103 37.7179132396708 -122.40443035886899 (37.7179132396708, -122.404430358869)
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)
36636 188403 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 700 De Haro St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     6012073.44818 2105095.84941 37.7608721901295 -122.401334912194 (37.7608721901295, -122.401334912194)
36978 187575 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 72 Bishop St 2 Side Yard : Yard 17 Tree 1 Private 1     11     6010832.96557 2089490.7918200002 37.7179547559905 -122.40452670863998 (37.7179547559905, -122.40452670864)
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)
38028 204732 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 700 Junipero Serra Blvd 92 : 4 Tree 1 Private 1     9 Width 0ft   5991226.61275 2092125.57221 37.7240739859998 -122.472488607886 (37.7240739859998, -122.472488607886)
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)
39135 247897 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 351 Mayflower St 2 Side Yard : Yard 17 Tree 1 Private 1     4     6010077.88258 2098386.8429099997 37.7423392041858 -122.407763645688 (37.7423392041858, -122.407763645688)
39239 175813 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 15 Athens St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1     6005348.05368 2093155.48995 37.727709159929105 -122.42374609402201 (37.7277091599291, -122.423746094022)
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)
42508 204742 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 933 Teresita Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 7ft   5998605.5734 2095661.21413 37.734206366028296 -122.44723512141701 (37.7342063660283, -122.447235121417)
43676 204727 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 300 Junipero Serra Blvd 38 : 4 Tree 1 Private 1     4 Width 0ft   5991391.65527 2094396.58957 37.73031918497 -122.47208354153798 (37.73031918497, -122.472083541538)
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)
44277 188414 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 602 Arthur Ave 36 Front Yard : Yard 7 Tree 1 Private 1     5     6015677.9579 2099872.41216 37.746730180067395 -122.388503787217 (37.7467301800674, -122.388503787217)
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)
44937 222679 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 749 Dolores St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 8ft   6005046.9751 2104064.76222 37.7576465368663 -122.425563014118 (37.7576465368663, -122.425563014118)
45007 248046 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 38 Rutledge St 3 Side Yard : Yard 17 Tree 1 Private 1     4     6010555.404680001 2099417.48898 37.745195855721995 -122.406185107956 (37.745195855722, -122.406185107956)
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)
49133 247976 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 503 Peralta Ave 2 Side Yard : Yard 17 Tree 1 Private 1     9     6009801.95016 2099270.17301 37.7447491849331 -122.408780045086 (37.7447491849331, -122.408780045086)
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)
51309 222685 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 145 Coso Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5     6007512.1231 2099620.66206 37.74558302735271 -122.41672267392201 (37.7455830273527, -122.416722673922)
52153 125934 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1715 Taylor St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 4ft   6008711.31794 2118818.3670900003 37.7983627993626 -122.41393383309799 (37.7983627993626, -122.413933833098)
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)
52605 204713 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1484 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 5ft   5991184.777919999 2105315.94504 37.7602889411076 -122.473594943052 (37.7602889411076, -122.473594943052)
53626 175808 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 72 La Grande Ave 1 Side Yard : Yard 17 Tree 1 Private 1     3     6005234.38829 2091786.48978 37.7239437686747 -122.42404172366001 (37.7239437686747, -122.42404172366)
53767 222709 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 290 States St 3 Front Yard : Yard 7 Tree 1 Private 1     8 Width 3ft   6000333.10816 2106866.5537099997 37.7650720879349 -122.44206655213699 (37.7650720879349, -122.442066552137)
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)
53963 205923 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 266 Judson Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5998304.035759999 2093569.7761099997 37.7284465374612 -122.448127087008 (37.7284465374612, -122.448127087008)
54390 247973 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 155 Faith St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6010331.53551 2099090.76742 37.7442862247418 -122.406936189376 (37.7442862247418, -122.406936189376)
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)
54760 188413 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 398 Mississippi St 4 : 4 Tree 1 Private 1     1 Width 3ft   6014027.478680001 2105319.8341099997 37.7615960301482 -122.394592417822 (37.7615960301482, -122.394592417822)
56499 222681 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 2318 22nd St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     6011232.98207 2103716.09635 37.7570367677534 -122.404144621787 (37.7570367677534, -122.404144621787)
59138 222697 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 690 28th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6001460.97341 2099432.54018 37.744724288990895 -122.43763311299101 (37.7447242889909, -122.437633112991)
60035 187570 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 73 Bishop St 1 Side Yard : Yard 17 Tree 1 Private 1     6     6010859.73078 2089462.03095 37.7178772802949 -122.404432169207 (37.7178772802949, -122.404432169207)
61378 204745 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 370 Monterey Blvd 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   5999685.08818 2094723.93815 37.731694449820296 -122.44343560538799 (37.7316944498203, -122.443435605388)
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)
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)
62795 188412 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 398 Mississippi St 3 : 4 Tree 1 Private 1     1 Width 3ft   6014026.1658 2105339.44297 37.761649798808996 -122.394598331744 (37.761649798809, -122.394598331744)
63474 175799 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1500 San Jose Ave 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 8ft   6001536.44317 2094235.33238 37.7304582561421 -122.43700014314 (37.7304582561421, -122.43700014314)
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)
63986 188409 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 2033 22nd St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   6011983.90541 2103708.46876 37.757057753421 -122.40154709194799 (37.757057753421, -122.401547091948)
65950 222683 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1100 San Jose Ave 27 Front Yard : Yard 7 Tree 1 Private 1     4     6004834.7029800005 2096673.11166 37.7373387712724 -122.425771027308 (37.7373387712724, -122.425771027308)
68446 188417 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 274 Topeka Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 3ft   6013295.80448 2094667.84679 37.7323072334974 -122.396376359792 (37.7323072334974, -122.396376359792)
68906 204731 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400 Junipero Serra Blvd 25 : 4 Tree 1 Private 1     5 Width 0ft   5991352.35851 2093912.8371599999 37.728988647895 -122.472184145999 (37.728988647895, -122.472184145999)
69867 222678 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 749 Dolores St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 8ft   6005045.75661 2104048.66592 37.7576022713581 -122.425566082603 (37.7576022713581, -122.425566082603)
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)
72067 204730 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400 Junipero Serra Blvd 20 : 4 Tree 1 Private 1     7 Width 0ft   5991365.099780001 2094040.0062400002 37.7293385597172 -122.472149364714 (37.7293385597172, -122.472149364714)
72437 222707 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 290 States St 1 Front Yard : Yard 7 Tree 1 Private 1     7 Width 3ft   6000349.79562 2106864.73806 37.7650680535768 -122.44200870415101 (37.7650680535768, -122.442008704151)
72995 217762 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 470 West Portal Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5     5991703.40817 2096440.7638 37.735950009376204 -122.471154649778 (37.7359500093762, -122.471154649778)
75485 175814 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 11 Athens St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3     6005376.332880001 2093192.89602 37.727813465104 -122.423650990705 (37.727813465104, -122.423650990705)
77059 188411 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 398 Mississippi St 2 : 4 Tree 1 Private 1     1 Width 3ft   6014024.24871 2105357.36092 37.7616988910081 -122.394606216998 (37.7616988910081, -122.394606216998)
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)

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