Street_Tree_List

Data source: data.sfgov.org

297 rows where qSpecies = 58 sorted by XCoord

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
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          
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          
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          
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          
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          
126538 43593 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 2014 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/20/2000 12:00:00 AM     Permit Number 43254 5986663.03161814 2101533.45903453 37.7496403612652 -122.488955268867 (37.7496403612652, -122.488955268867)
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)
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)
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)
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)
125410 45536 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 79 Melba Ave 1 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)
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)
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)
171726 204714 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1484 16th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 5ft   5991182.79274 2105342.1880099997 37.7603608823676 -122.473603723127 (37.7603608823676, -122.473603723127)
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)
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)
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)
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)
129739 204728 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400 Junipero Serra Blvd 13 : 4 Tree 1 Private 1     2 Width 0ft   5991366.51565 2094145.3724 37.729627950748295 -122.47215214722401 (37.7296279507483, -122.472152147224)
188538 204729 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400 Junipero Serra Blvd 16 : 4 Tree 1 Private 1     1 Width 0ft   5991368.5463 2094108.06034 37.729525618690204 -122.47214240847 (37.7295256186902, -122.47214240847)
17688 29574 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400X Junipero Serra Blvd 7 Median : Cutout 11 Tree 1 DPW 2     9 3X3   5991374.696380001 2094208.91815 37.729802904883 -122.472128495928 (37.729802904883, -122.472128495928)
17436 29576 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400X Junipero Serra Blvd 5 Median : Cutout 11 Tree 1 DPW 2   04/01/2007 12:00:00 AM 3 3X3   5991377.92956 2094240.4375599998 37.7298896363903 -122.47211961513099 (37.7298896363903, -122.472119615131)
170450 204725 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 300 Junipero Serra Blvd 29 : 4 Tree 1 Private 1     5 Width 0ft   5991390.23736 2094439.33755 37.730436478151496 -122.47209155807501 (37.7304364781515, -122.472091558075)
170368 204724 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 300 Junipero Serra Blvd 21 : 4 Tree 1 Private 1     8 Width 0ft   5991391.18592 2094484.3447599998 37.730560111554496 -122.47209155808999 (37.7305601115545, -122.47209155809)
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)
135308 204726 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 300 Junipero Serra Blvd 30 : 4 Tree 1 Private 1     5 Width 0ft   5991392.43358 2094433.51883 37.7304206284982 -122.472083541544 (37.7304206284982, -122.472083541544)
154057 204723 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 300 Junipero Serra Blvd 12 : 4 Tree 1 Private 1     5 Width 0ft   5991397.3981 2094531.5501400002 37.7306900851772 -122.47207352129801 (37.7306900851772, -122.472073521298)
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)
140864 53611 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 2266 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/18/1969 12:00:00 AM   3x3 Permit Number 50102 5991755.89113084 2099997.75858136 37.7457196459604 -122.47123227110201 (37.7457196459604, -122.471232271102)
130324 123045 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 568 Funston Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5991929.81513 2111594.03006 37.777569997766705 -122.47147570428301 (37.7775699977667, -122.471475704283)
153957 218236 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 353 Wawona St 1 : 4 Tree 1 Private 1     1 Width 3ft   5991977.13565 2097137.64691 37.7378793033766 -122.47025900595101 (37.7378793033766, -122.470259005951)
125292 40738 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 20 Alviso St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/13/1999 12:00:00 AM     Permit Number 41717 5992072.81756498 2091384.27409538 37.7220875062624 -122.469509497536 (37.7220875062624, -122.469509497536)
124574 87268 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 727 Moraga St   Sidewalk: Property side : Cutout 5 Tree 1 Private 1   03/05/2008 12:00:00 AM     Permit Number 50290 5992077.0 2103851.0 37.756318217439706 -122.47040250406201 (37.7563182174397, -122.470402504062)
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)
165838 59091 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 3524 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/23/1980 12:00:00 AM 1   Permit Number 18392 5992426.174880001 2110042.4468799997 37.77333847202161 -122.46964566266001 (37.7733384720216, -122.46964566266)
176434 124049 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 651 11th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 3ft   5992517.64773 2111006.08275 37.775989642541795 -122.469399404795 (37.7759896425418, -122.469399404795)
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)
114122 102090 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 27 Santa Ana Ave 2 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)
125714 102089 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 27 Santa Ana Ave 1 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)
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)
128301 45396 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 135 Corona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/21/2006 12:00:00 AM     Permit Number 44206 5992967.23882057 2092102.4527906997 37.72411110068 -122.466469901656 (37.72411110068, -122.466469901656)
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)
98857 97214 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 300X Claremont Blvd 1 Sidewalk: Property side : Cutout 5 Tree 1 DPW for City Agency 10     12     5993486.0 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055)
107044 107197 Significant Tree 6 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 339 Kirkham St 1 Front Yard : Cutout 8 Tree 1 Private 1   08/07/2014 12:00:00 AM   3x3 Permit Number 773549 5993785.2645 2105241.5874099997 37.7602350326789 -122.464595750688 (37.7602350326789, -122.464595750688)
136522 204722 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 422 Bright St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5993793.315830001 2090006.70292 37.7184043108851 -122.46346228245501 (37.7184043108851, -122.463462282455)
128258 204719 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 110 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993903.71897 2099982.29966 37.7458012037543 -122.46380433331001 (37.7458012037543, -122.46380433331)
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)
178842 204733 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 80 Merced Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994927.12974 2099849.55804 37.745495650106605 -122.460255934077 (37.7454956501066, -122.460255934077)
129702 204734 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 80 Merced Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994953.56479 2099867.13318 37.7455454275919 -122.460165799529 (37.7455454275919, -122.460165799529)
171203 204735 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 40 Vasquez Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5995650.24765 2100035.09823 37.746046665624 -122.457768945275 (37.746046665624, -122.457768945275)
172403 204736 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 40 Vasquez Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5995677.52131 2100065.8007099996 37.7461325337836 -122.457676858293 (37.7461325337836, -122.457676858293)
56364 204718 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1485x Northwood Dr 6 Median : Yard 3 Tree 1 DPW 2     3     5995836.31697 2094012.72029 37.7295213774971 -122.456690081702 (37.7295213774971, -122.456690081702)
75225 204717 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1485x Northwood Dr 5 Median : Yard 3 Tree 1 DPW 2     2     5995876.20042 2094034.0159599998 37.7295821401899 -122.456553740875 (37.7295821401899, -122.456553740875)
18868 15071 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1X Minerva St 3 Median : Cutout 11 Tree 1 DPW 2     3 11   5995959.8595900005 2089005.6685900001 37.7157802951115 -122.45590116312201 (37.7157802951115, -122.455901163122)
116569 49132 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 100 Valdez Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/14/2003 12:00:00 AM     Permit Number 46261 5996360.20601003 2094239.45226773 37.7301739953755 -122.454895331277 (37.7301739953755, -122.454895331277)
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)
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)
185050 204744 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 545 Melrose Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 6ft   5996927.5801099995 2095415.2897 37.733435093958896 -122.453018700168 (37.7334350939589, -122.453018700168)
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)
131430 204721 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 460 Staples Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   5997139.03164 2093838.66053 37.729118162849495 -122.452173936375 (37.7291181628495, -122.452173936375)
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)
118481 52690 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1401@ RIVOLI Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/26/2011 12:00:00 AM     Permit Number 768319 5997782.141834901 2105912.5855129 37.76230702883 -122.45082088432301 (37.76230702883, -122.450820884323)
103296 101469 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1230 Twin Peaks Blvd 1 Back Yard : Yard 13 Tree 1 Private 1           5997905.5 2100119.1 37.7464066170132 -122.449976668748 (37.7464066170132, -122.449976668748)
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)
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)
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)
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)
125228 109402 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1588 WALLER ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997977.9 2108248.0 37.7687306888354 -122.450312188331 (37.7687306888354, -122.450312188331)
122286 97347 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1130 Cole St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/22/2011 12:00:00 AM   3x3 Permit Number 768267 5998216.1 2106370.5 37.7635891788793 -122.449352986262 (37.7635891788793, -122.449352986262)
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)
169588 204739 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 463 Mangels Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 10ft   5998365.55897 2095230.78545 37.7330107938072 -122.44803394331899 (37.7330107938072, -122.448033943319)
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)
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)
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)
110619 108023 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 721 Ashbury St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/12/2014 12:00:00 AM 3   Permit Number 773960 5998996.170080001 2108175.50509 37.7685898587188 -122.446784866101 (37.7685898587188, -122.446784866101)
175957 204740 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 317 Mangels Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 6ft   5999296.31857 2095221.44608 37.7330383112512 -122.44481540373 (37.7330383112512, -122.44481540373)
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)
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)
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)
136961 205922 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 370 Monterey Blvd 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   5999640.50046 2094726.6696 37.7316994068856 -122.443589949734 (37.7316994068856, -122.443589949734)
129111 51597 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1478 Masonic Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/04/2005 12:00:00 AM   3x3 Permit Number 47890 5999641.13876025 2107457.97579425 37.766656526924294 -122.444502404738 (37.7666565269243, -122.444502404738)
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)
105228 57041 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 200 Central Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/2015 12:00:00 AM 1   Permit Number 31232 5999893.57375842 2109179.37340811 37.7713974526383 -122.443752960181 (37.7713974526383, -122.443752960181)
165084 204743 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 280 Joost Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 7ft   6000165.05205 2094974.5458099998 37.732409919872 -122.441794258103 (37.732409919872, -122.441794258103)
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)
121909 49971 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 168@ DOUGLASS Caselli Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/08/2005 12:00:00 AM     Permit Number 48111 6000192.99372442 2104905.40226883 37.7596792654558 -122.44241036439301 (37.7596792654558, -122.442410364393)
144836 51903 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 168 Caselli Ave 2 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)
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)
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)
155781 222708 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 290 States St 2 Front Yard : Yard 7 Tree 1 Private 1     8 Width 3ft   6000342.850880001 2106861.9429200003 37.76505998306129 -122.442032523579 (37.7650599830613, -122.442032523579)
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)
82422 113192 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 150X Museum Way 1 Back Yard : Yard 13 Tree 1 Private 1   09/11/2015 12:00:00 AM     Permit Number 774288 6001029.7 2106463.5 37.7640050744287 -122.439628320832 (37.7640050744287, -122.439628320832)
116006 106924 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 196 States St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1   06/30/2014 12:00:00 AM     Permit Number 772939 6001039.87531 2106387.50014 37.7637969766711 -122.43958767886002 (37.7637969766711, -122.43958767886)
144682 106923 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 196 States St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1   06/30/2014 12:00:00 AM     Permit Number 772939 6001039.87531 2106387.50014 37.7637969766711 -122.43958767886002 (37.7637969766711, -122.43958767886)
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)
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)
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)
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)

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