Street_Tree_List

Data source: data.sfgov.org

297 rows where qSpecies = 58 sorted by YCoord

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          
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)
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)
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)
171201 175802 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 421 Wheeler Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6011992.04716 2086775.8851599998 37.7105648747395 -122.400329663484 (37.7105648747395, -122.400329663484)
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)
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)
110009 108903 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 200 Cordova St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     3x3 Permit Number 772783 6001785.77868 2087307.18495 37.7114492867677 -122.43564268921001 (37.7114492867677, -122.43564268921)
140417 108905 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 200 Cordova St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772783 6001785.8 2087307.2 37.7114493293027 -122.43564261659901 (37.7114493293027, -122.435642616599)
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)
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)
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)
184518 39934 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 186 Arleta Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/25/1999 12:00:00 AM 3 3x3 Permit Number 41205 6010249.35801 2088014.8431799999 37.7138694695674 -122.40644005139299 (37.7138694695674, -122.406440051393)
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)
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)
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)
137834 175805 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 35 Ervine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6009673.12409 2089221.0725599998 37.7171492746007 -122.408516774841 (37.7171492746007, -122.408516774841)
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)
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)
146973 187576 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 72 Bishop St 3 Side Yard : Yard 17 Tree 1 Private 1     6     6010826.85106 2089479.8583099998 37.7179243930824 -122.40454707471301 (37.7179243930824, -122.404547074713)
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)
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)
162264 187573 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 73 Bishop St 4 Side Yard : Yard 17 Tree 1 Private 1     14     6010858.37792 2089492.3055900002 37.717960332674295 -122.404438975305 (37.7179603326743, -122.404438975305)
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)
187407 175800 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 701 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6001959.2202699995 2089802.6495400001 37.71831113034379 -122.43522160969401 (37.7183111303438, -122.435221609694)
116475 109575 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400 France Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/24/2015 12:00:00 AM 3 3x3 Permit Number 774875 6002004.0 2089808.9 37.7183308355338 -122.43506727205299 (37.7183308355338, -122.435067272053)
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)
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)
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)
34874 175804 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 500x Mansell St 7 Median : Cutout 11 Tree 1 DPW 2     12 Width 0ft   6010489.90873 2090338.0061700002 37.72026185429429 -122.40577215548402 (37.7202618542943, -122.405772155484)
113561 115771 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1204 Egbert Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/24/2016 12:00:00 AM 3   Permit Number 775363 6015358.9 2090410.1 37.7207308974409 -122.38894654781099 (37.7207308974409, -122.388946547811)
178316 202043 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 52 Exeter St 2 : 4 Tree 1 Private 1     1 Width 3ft   6012522.16713 2090984.69593 37.722150974681604 -122.398792625891 (37.7221509746816, -122.398792625891)
156475 175816 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 616 Dwight St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6009781.28405 2091163.7033900002 37.7224893931511 -122.40827985473699 (37.7224893931511, -122.408279854737)
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)
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)
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)
101966 37855 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 50 Ina Ct 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/07/1998 12:00:00 AM     Permit Number 40144 6004964.50568845 2091639.69049004 37.7235254489092 -122.42496422599702 (37.7235254489092, -122.424964225997)
107545 37854 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 50 Ina Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/07/1998 12:00:00 AM     Permit Number 40144 6004964.50568845 2091639.69049004 37.7235254489092 -122.42496422599702 (37.7235254489092, -122.424964225997)
138640 37856 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 50 Ina Ct 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/07/1998 12:00:00 AM     Permit Number 40144 6004964.50568845 2091639.69049004 37.7235254489092 -122.42496422599702 (37.7235254489092, -122.424964225997)
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)
173385 175810 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 72 La Grande Ave 3 Side Yard : Yard 17 Tree 1 Private 1     6     6005231.38021 2091782.6619 37.7239330883183 -122.424051850035 (37.7239330883183, -122.424051850035)
116919 175809 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 72 La Grande Ave 2 Side Yard : Yard 17 Tree 1 Private 1     4     6005230.95207 2091785.5880000002 37.7239410985769 -122.424053538037 (37.7239410985769, -122.424053538037)
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)
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)
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)
166040 175807 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 156 San Juan Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 10ft   6001266.11551 2092303.88748 37.725139581023605 -122.437796421768 (37.7251395810236, -122.437796421768)
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)
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)
149164 175811 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 15 Athens St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1     6005336.45581 2093162.3032099998 37.727727212929004 -122.423786672331 (37.727727212929, -122.423786672331)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
148165 222701 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 340 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6004099.43344 2096524.74955 37.7368898251991 -122.42830262426399 (37.7368898251991, -122.428302624264)
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)
162790 222684 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1100 San Jose Ave 28 Front Yard : Yard 7 Tree 1 Private 1     4     6004829.85448 2096667.61167 37.7373233955514 -122.42578739946501 (37.7373233955514, -122.425787399465)
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)

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