Street_Tree_List

Data source: data.sfgov.org

219 rows where qSpecies = 99 sorted by qSiteInfo

View and edit SQL

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo ▼ PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
57805 206027 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 804 Faxon Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 10ft   5994921.23721 2093409.63408 37.7278128652723 -122.459809914392 (37.7278128652723, -122.459809914392)
65401 190004 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1745 20th St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 3ft   6012733.96255 2104688.60274 37.7597908102085 -122.399021884672 (37.7597908102085, -122.399021884672)
130881 225147 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1706 Dolores St 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   6005278.315280001 2098374.8158 37.7420363251164 -122.424358251742 (37.7420363251164, -122.424358251742)
134896 120285 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 151 24th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     5988326.80885 2115016.043 37.7867567842415 -122.484190580999 (37.7867567842415, -122.484190580999)
148481 225146 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1706 Dolores St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   6005275.161069999 2098395.65522 37.7420933673216 -122.424370639893 (37.7420933673216, -122.424370639893)
38579 190011 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1599 Newhall St 1 : 4 Tree 1 Private 1     10 Width 4ft   6014210.748430001 2095415.1555299999 37.7344100624646 -122.39326543937 (37.7344100624646, -122.39326543937)
27326 190005 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 700 Arkansas St 2 Front Yard : Yard 7 Tree 1 Private 1     2     6012982.63799 2103818.56401 37.757415728567295 -122.398100794529 (37.7574157285673, -122.398100794529)
27402 201678 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 401 08th St 14 Front Yard : Yard 7 Tree 1 Private 1     4     6010253.38486 2109790.37511 37.7736605694093 -122.407960800466 (37.7736605694093, -122.407960800466)
45520 190006 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 700 Arkansas St 4 Front Yard : Yard 7 Tree 1 Private 1     4     6012982.38984 2103806.3309400002 37.7573821254062 -122.398100794542 (37.7573821254062, -122.398100794542)
63791 201677 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 401 08th St 13 Front Yard : Yard 7 Tree 1 Private 1     8     6010264.4203699995 2109791.71635 37.7736648699818 -122.407922721364 (37.7736648699818, -122.407922721364)
69677 201679 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 401 08th St 15 Front Yard : Yard 7 Tree 1 Private 1     5     6010240.772059999 2109788.80533 37.7736555529973 -122.40800431955799 (37.7736555529973, -122.408004319558)
70258 201675 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 401 08th St 11 Front Yard : Yard 7 Tree 1 Private 1     4     6010282.589459999 2109782.99387 37.7736419372697 -122.40785925619801 (37.7736419372697, -122.407859256198)
72268 201680 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 401 08th St 16 Front Yard : Yard 7 Tree 1 Private 1     5     6010229.21797 2109787.73605 37.7736519701026 -122.40804421168998 (37.7736519701026, -122.40804421169)
89297 201672 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 401 08th St 8 Front Yard : Yard 7 Tree 1 Private 1     5     6010270.770690001 2109756.0907799997 37.773567405955 -122.407898241816 (37.773567405955, -122.407898241816)
134762 201676 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 401 08th St 12 Front Yard : Yard 7 Tree 1 Private 1     5     6010275.73936 2109794.09532 37.7736720357783 -122.40788373484301 (37.7736720357783, -122.407883734843)
137477 189995 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1301 Minnesota St 3 Front Yard : Yard 7 Tree 1 Private 1     3     6015392.22277 2102247.2850900004 37.753235244428204 -122.389657680355 (37.7532352444282, -122.389657680355)
151815 201673 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 401 08th St 9 Front Yard : Yard 7 Tree 1 Private 1     7     6010274.35746 2109764.89142 37.773591771276706 -122.4078864553 (37.7735917712767, -122.4078864553)
158218 190007 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 700 Arkansas St 5 Front Yard : Yard 7 Tree 1 Private 1     3     6012984.44615 2103792.30277 37.7573437216454 -122.398092698838 (37.7573437216454, -122.398092698838)
158705 190031 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1301 Minnesota St 76 Front Yard : Yard 7 Tree 1 Private 1     2     6015368.80756 2102249.49615 37.753240017127 -122.389738810018 (37.753240017127, -122.389738810018)
159709 201681 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 401 08th St 17 Front Yard : Yard 7 Tree 1 Private 1     2     6010219.21458 2109785.59098 37.7736455201492 -122.408078663801 (37.7736455201492, -122.408078663801)
166477 201674 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 401 08th St 10 Front Yard : Yard 7 Tree 1 Private 1     6     6010278.21151 2109773.9479799997 37.773616854257604 -122.407873762259 (37.7736168542576, -122.407873762259)
183572 201671 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 401 08th St 7 Front Yard : Yard 7 Tree 1 Private 1     5     6010268.2107 2109746.2247 37.7735401726656 -122.407906401378 (37.7735401726656, -122.407906401378)
23690 126012 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 2600 Lyon St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 7ft   5999234.571959999 2117780.83993 37.7949772349663 -122.446651443424 (37.7949772349663, -122.446651443424)
31524 175845 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 98 Newton St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23 Width 10ft   6000912.9484 2087984.8955700002 37.7132605143345 -122.43870794134399 (37.7132605143345, -122.438707941344)
34445 189999 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 700 Carolina St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 3ft   6012378.8382 2104615.7006200003 37.759570841431604 -122.400244972539 (37.7595708414316, -122.400244972539)
38646 201508 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1001 Innes Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   6018593.65925 2094901.94124 37.7332433998449 -122.378076502435 (37.7332433998449, -122.378076502435)
45931 190000 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 770 De Haro St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   6012104.84568 2104756.14819 37.7599411975544 -122.401202450128 (37.7599411975544, -122.401202450128)
52213 190002 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 790 De Haro St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     6012104.02513 2104748.44893 37.759920011313206 -122.401204746997 (37.7599200113132, -122.401204746997)
55039 225145 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 450 Florida St 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18     6009179.2133599995 2106266.6276700003 37.76392497748579 -122.41142754574899 (37.7639249774858, -122.411427545749)
57727 117702 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 4021 Clement St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 7ft   5983001.87469 2113075.50324 37.781117159673705 -122.50246961447901 (37.7811171596737, -122.502469614479)
60204 189997 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1809 19th St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 6ft   6012307.781769999 2105132.0490099997 37.760984657528894 -122.40052699363501 (37.7609846575289, -122.400526993635)
61054 247121 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 2301 Castro St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5     6002764.34837 2098855.27399 37.743213271472705 -122.433085061551 (37.7432132714727, -122.433085061551)
62061 206040 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 621 Holloway Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 3ft   5994946.74244 2091203.9910900001 37.7217581669755 -122.45956206304899 (37.7217581669755, -122.459562063049)
66694 225148 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1199 Capp St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 9ft   6007231.69522 2100624.49408 37.7483235475968 -122.417763493512 (37.7483235475968, -122.417763493512)
70787 201506 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1001 Innes Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   6018588.36983 2094906.5368 37.7332557268509 -122.378095108499 (37.7332557268509, -122.378095108499)
147063 189996 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1809 19th St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   6012291.07861 2105130.95435 37.7609807203027 -122.400584686038 (37.7609807203027, -122.400584686038)
150193 206044 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 275 Byxbee St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   5991926.36894 2090353.75557 37.7192494901497 -122.46994073500099 (37.7192494901497, -122.469940735001)
153857 201507 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1001 Innes Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   6018590.61876 2094904.2906900002 37.733249683412296 -122.37808717738599 (37.7332496834123, -122.378087177386)
156182 189998 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1950 18th St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6011839.98262 2105629.53813 37.7623245520575 -122.402179893599 (37.7623245520575, -122.402179893599)
159626 206047 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 575 Rockdale Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   5997894.62452 2097851.39191 37.7401794193521 -122.449850874237 (37.7401794193521, -122.449850874237)
160931 126014 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 2322 North Point St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 8ft   5999611.42315 2120546.01877 37.8025911966964 -122.445546423945 (37.8025911966964, -122.445546423945)
166097 201509 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1001 Innes Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   6018596.778580001 2094899.20439 37.73323605689679 -122.378065528029 (37.7332360568968, -122.378065528029)
166960 126011 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 2600 Lyon St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 7ft   5999243.15513 2117721.3039700002 37.7948142553315 -122.446617458939 (37.7948142553315, -122.446617458939)
168817 206042 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 621 Holloway Ave 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 3ft   5994983.67365 2091204.0797700002 37.7217605339977 -122.45943440879101 (37.7217605339977, -122.459434408791)
171439 126013 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 2600 Lyon St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 7ft   5999233.22196 2117805.48778 37.795044834292895 -122.44665788886499 (37.7950448342929, -122.446657888865)
171539 190001 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 790 De Haro St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9     6012095.84153 2104748.83564 37.759920616576 -122.401233077439 (37.759920616576, -122.401233077439)
172254 190033 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 651 Missouri St 30 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 7ft   6013606.61157 2104092.53416 37.7582027253025 -122.39596202861901 (37.7582027253025, -122.395962028619)
178979 206041 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 621 Holloway Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 3ft   5994962.333219999 2091204.5266599997 37.7217605340024 -122.459508208932 (37.7217605340024, -122.459508208932)
181426 201513 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1001 Innes Ave 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   6018634.55292 2094871.3359599998 37.7331616173072 -122.377932996723 (37.7331616173072, -122.377932996723)
181433 190032 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 651 Missouri St 29 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 7ft   6013600.610230001 2104091.57262 37.7581997512359 -122.395982716627 (37.7581997512359, -122.395982716627)
182738 117701 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 4021 Clement St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 7ft   5983015.82317 2113078.8166099996 37.7811270768141 -122.502421605789 (37.7811270768141, -122.502421605789)
183433 206043 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 621 Holloway Ave 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 3ft   5994997.50397 2091203.21567 37.721758956587294 -122.459386538764 (37.7217589565873, -122.459386538764)
27211 190009 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 499 Arkansas St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 3ft   6013000.6424 2104780.97852 37.7600593109036 -122.39810604475099 (37.7600593109036, -122.398106044751)
32476 126017 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 500 Post St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 3ft   6009644.05128 2115053.2571900003 37.788077063340204 -122.410440279012 (37.7880770633402, -122.410440279012)
34064 126015 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 500 Post St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 3ft   6009674.03362 2115055.86699 37.788085909974605 -122.410336729273 (37.7880859099746, -122.410336729273)
34786 126022 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 550 Geary St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 4ft   6009023.96612 2114628.9203 37.786877155513004 -122.412555665234 (37.786877155513, -122.412555665234)
37175 126019 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 542 Geary St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     11 Width 4ft   6009096.37686 2114637.77725 37.7869055381056 -122.412305766101 (37.7869055381056, -122.412305766101)
42492 247161 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 2399 Market St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     28 Width 5ft   6002372.95372 2105936.54637 37.7626345492748 -122.43494472103998 (37.7626345492748, -122.43494472104)
47236 225176 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1020 Alabama St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 3ft   6009156.40291 2103118.80305 37.7552804871291 -122.411284056222 (37.7552804871291, -122.411284056222)
49752 225207 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 3816 24th St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 3ft   6004299.338409999 2101924.10637 37.7517265264651 -122.427996107428 (37.7517265264651, -122.427996107428)
59914 206025 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1366 16th Ave 6 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 3ft   5991157.5258599995 2106131.34791 37.76252624212071 -122.473748679463 (37.7625262421207, -122.473748679463)
60112 225210 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 3641 17th St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 3ft   6004615.0966300005 2105985.22525 37.7628952609247 -122.427193419352 (37.7628952609247, -122.427193419352)
67868 206024 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1366 16th Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 3ft   5991156.52884 2106111.8053099997 37.7624725256075 -122.473750702041 (37.7624725256075, -122.473750702041)
131352 126018 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 500 Post St 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 3ft   6009631.44446 2115049.8898 37.788067110556604 -122.41048365871 (37.7880671105566, -122.41048365871)
154165 246301 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 3998 17th St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 0ft   6002344.4551 2105927.1578 37.7626071523851 -122.435042615882 (37.7626071523851, -122.435042615882)
154762 190008 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 499 Arkansas St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 3ft   6013001.004319999 2104770.77292 37.7600313087249 -122.39810407704901 (37.7600313087249, -122.398104077049)
176416 225206 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 3816 24th St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 3ft   6004315.95235 2101927.5657 37.751736964897106 -122.427938900685 (37.7517369648971, -122.427938900685)
178754 190010 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 499 Arkansas St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 3ft   6013000.60503 2104793.1604 37.7600927575897 -122.398107028633 (37.7600927575897, -122.398107028633)
181010 126016 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 500 Post St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 3ft   6009654.60353 2115055.05542 37.7880825923961 -122.410403896944 (37.7880825923961, -122.410403896944)
181029 126020 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 550 Geary St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 4ft   6009058.631990001 2114632.0881 37.786887798972295 -122.412435952882 (37.7868877989723, -122.412435952882)
188409 126023 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 560 Geary St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 4ft   6009008.4198 2114630.0994700002 37.7868795207321 -122.412609535497 (37.7868795207321, -122.412609535497)
188481 126021 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 550 Geary St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 4ft   6009038.2153900005 2114627.76765 37.7868747902962 -122.412506284359 (37.7868747902962, -122.412506284359)
10585 27651 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 2700 Sloat Blvd 1 Median : Cutout 11 Tree 1 DPW 2   06/06/1999 12:00:00 AM 12 4X4   5982420.6256 2096461.5972 37.73546591249 -122.503249937577 (37.73546591249, -122.503249937577)
10607 27653 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 2900X Sloat Blvd 1 Median : Cutout 11 Tree 1 DPW 2   06/06/1999 12:00:00 AM 12 4X4   5981776.6997 2096484.8387 37.7354918543068 -122.505477915571 (37.7354918543068, -122.505477915571)
11897 27649 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 2500 Sloat Blvd 1 Median : Cutout 11 Tree 1 DPW 2   06/06/1999 12:00:00 AM 12 4X4   5982997.5613 2096369.9984 37.7352483041994 -122.501248513045 (37.7352483041994, -122.501248513045)
12298 27647 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 2300 Sloat Blvd 1 Median : Cutout 11 Tree 1 DPW 2     12 4X4   5983545.7870000005 2096052.8205 37.7344095981993 -122.499329695326 (37.7344095981993, -122.499329695326)
17378 29984 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1622X Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2   03/24/2007 12:00:00 AM 3 3x3   6005923.58357 2099590.01571 37.7454094051301 -122.422213431617 (37.7454094051301, -122.422213431617)
17470 29703 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1488X Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 6     6005875.752859999 2100395.2692 37.7476177497694 -122.42243602910901 (37.7476177497694, -122.422436029109)
17649 30005 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 795X San Jose Ave 1 Median : Cutout 11 Tree 1 DPW 2   03/24/2007 12:00:00 AM 3 3x3   6005615.08127 2098546.14287 37.7425257613504 -122.423205996259 (37.7425257613504, -122.423205996259)
17658 29711 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1534X Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 6     6005892.92513 2100118.18846 37.7468579179619 -122.422356964326 (37.7468579179619, -122.422356964326)
17666 16203 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 501X Monterey Blvd 3 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 12 5   5998659.38581 2094694.1828400001 37.731554201452106 -122.446979509806 (37.7315542014521, -122.446979509806)
17832 16310 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 700X Monterey Blvd 2 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 18 5   5997364.820830001 2094712.7517799998 37.7315311410332 -122.45145638890499 (37.7315311410332, -122.451456388905)
18341 29708 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1534X Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 6     6005897.61494 2100055.38982 37.746685751754605 -122.422336286217 (37.7466857517546, -122.422336286217)
18826 16271 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 601X Monterey Blvd 3 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 18 5   5997920.42958 2094705.3029200002 37.731542488687204 -122.449535014353 (37.7315424886872, -122.449535014353)
19514 16309 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 700X Monterey Blvd 1 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 18 5   5997384.824659999 2094713.0859599998 37.7315332040811 -122.45138725623801 (37.7315332040811, -122.451387256238)
19536 29706 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1594X Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3     6005915.3087 2099718.0441099997 37.745760475271204 -122.422251139273 (37.7457604752712, -122.422251139273)
19578 29700 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1488X Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 6     6005880.5001300005 2100335.27269 37.747453280849 -122.422415350984 (37.747453280849, -122.422415350984)
19777 16245 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 601X Monterey Blvd 1 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 12 5   5997958.54401 2094705.63588 37.7315455832604 -122.44940326996401 (37.7315455832604, -122.449403269964)
19998 30014 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 738X San Jose Ave 6 Median : Cutout 11 Tree 1 DPW 2   03/24/2007 12:00:00 AM 3 3x3   6005753.20487 2098967.8779700003 37.7436915444264 -122.422758369527 (37.7436915444264, -122.422758369527)
20337 29707 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1594X Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3     6005916.90216 2099727.1189900003 37.74578548271 -122.422246273943 (37.74578548271, -122.422246273943)
20510 16215 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 501X Monterey Blvd 2 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 12 5   5998684.93347 2094693.5890400002 37.7315540305774 -122.446891144221 (37.7315540305774, -122.446891144221)
20789 29999 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 681X San Jose Ave 13 Median : Cutout 11 Tree 1 DPW 2   03/24/2007 12:00:00 AM 3 3x3   6005890.72277 2099411.68829 37.7449179049514 -122.422314391296 (37.7449179049514, -122.422314391296)
21427 16246 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 601X Monterey Blvd 2 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 12 5   5997938.93286 2094706.04445 37.731545583255 -122.44947109863001 (37.731545583255, -122.44947109863)
21577 30015 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 738X San Jose Ave 7 Median : Cutout 11 Tree 1 DPW 2   03/24/2007 12:00:00 AM 3 3x3   6005757.33905 2098980.75435 37.7437271333024 -122.422744989392 (37.7437271333024, -122.422744989392)
21879 29710 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1534X Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3     6005894.4456400005 2100106.5973900002 37.7468261772965 -122.422350883111 (37.7468261772965, -122.422350883111)
21912 29701 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1488X Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 6     6005878.92208 2100344.0622799997 37.7474773260372 -122.42242143222201 (37.7474773260372, -122.422421432222)
22067 16311 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 700X Monterey Blvd 3 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 3 5   5997346.34886 2094713.5127 37.7315321725506 -122.45152030461901 (37.7315321725506, -122.451520304619)
22275 29704 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1488X Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 6     6005876.958869999 2100402.60074 37.7476379485377 -122.422432379649 (37.7476379485377, -122.422432379649)
27590 225203 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1534x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2     6 Width 3ft   6005899.22105 2100030.8366400003 37.746618424914296 -122.422328988218 (37.7466184249143, -122.422328988218)
35962 225200 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1622x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005924.11488 2099598.76228 37.74543345119329 -122.42221221572599 (37.7454334511933, -122.422212215726)

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