Street_Tree_List

Data source: data.sfgov.org

224 rows where qLegalStatus = 5

View and edit SQL

Suggested facets: qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
27 244214 Private 5 Tree(s) :: 17 342 Scott St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   03/20/2017 12:00:00 AM 3 Width 0ft Permit Number 779666 6002262.2202 2109717.5413 37.7730099442883 -122.43559821674499 (37.7730099442883, -122.435598216745)
50 138938 Private 5 Tree(s) :: 17 632 HAYES ST 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   03/21/2017 12:00:00 AM 3 Width 0ft Permit Number 779650 6004797.9634 2110922.1515 37.7764612085261 -122.426912572117 (37.7764612085261, -122.426912572117)
102 98037 Private 5 Pittosporum undulatum :: Victorian Box 26 1384X Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/23/2017 12:00:00 AM 3   Permit Number 767782 6001197.2582 2110764.9293 37.775825263482105 -122.439357134105 (37.7758252634821, -122.439357134105)
240 251249 Private 5 Private shrub :: Private Shrub 64 161 Lundys Ln 1 Front Yard : Yard 7 Landscaping 2 Private 1       3x3   6006716.0 2098685.0 37.7429691002686 -122.41940918518 (37.7429691002686, -122.41940918518)
294 251266 Private 5 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 10x Paloma Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
682 251365 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 138x Gladeview Way 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1                    
712 251366 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 138x Gladeview Way 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1                    
713 251364 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 138x Gladeview Way 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1                    
966 251417 Private 5 Eucalyptus globulus :: Blue Gum 103 418 19th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5990003.0 2112517.0 37.779992561868504 -122.478208632121 (37.7799925618685, -122.478208632121)
981 191653 Private 5 Lophostemon confertus :: Brisbane Box 11 149 03rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 5ft   6012146.38303 2114300.35662 37.786149737060796 -122.40172965521799 (37.7861497370608, -122.401729655218)
1079 3621 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 57 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/01/2017 03:22:00 PM 3 3X3   6017849.66978 2098333.64293 37.7426251400454 -122.380887189608 (37.7426251400454, -122.380887189608)
1081 3617 Private 5 Metrosideros excelsa :: New Zealand Xmas Tree 2 100X Cargo Way 53 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/01/2017 03:16:00 PM 3 3X3   6017937.25359 2098269.56212 37.742454020638796 -122.380579893948 (37.7424540206388, -122.380579893948)
1491 110535 Private 5 Maytenus boaria :: Mayten 22 100X ASHBURY ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 City College 12 Private 3 04/21/2015 04:52:00 PM 3 3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
1496 110536 Private 5 Lophostemon confertus :: Brisbane Box 11 100X ASHBURY ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 City College 12 Private 3 05/29/2015 02:12:00 PM 3 3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
1517 99716 Private 5 Platanus racemosa :: California Sycamore 81 1415 Scott St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6001693.2243 2113487.1552 37.7833280195253 -122.43783648412202 (37.7833280195253, -122.437836484122)
2502 253119 Private 5 Pinus radiata :: Monterey Pine 3 185 Belgrave Ave 1 Back Yard : Yard 13 Tree 1 Private 1         Permit Number 780239 5997636.85301 2104869.74588 37.759435335978296 -122.45124816933 (37.7594353359783, -122.45124816933)
2640 183247 Private 5 Metrosideros excelsa :: New Zealand Xmas Tree 2 2890 Rivera St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 780393 5984262.8939 2100232.1038 37.7459268239815 -122.49715885534201 (37.7459268239815, -122.497158855342)
2648 183237 Private 5 Metrosideros excelsa :: New Zealand Xmas Tree 2 2001 37th Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 780393 5984780.1717 2100543.2827 37.7468115375468 -122.495393151852 (37.7468115375468, -122.495393151852)
2656 183240 Private 5 Metrosideros excelsa :: New Zealand Xmas Tree 2 2001 37th Ave 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 780393 5984790.3243 2100348.3517 37.7462769046122 -122.495343672098 (37.7462769046122, -122.495343672098)
2668 183245 Private 5 Metrosideros excelsa :: New Zealand Xmas Tree 2 2706 Rivera St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 780393 5984600.1313 2100244.4562 37.745980498085295 -122.495993663284 (37.7459804980853, -122.495993663284)
2672 183250 Private 5 Metrosideros excelsa :: New Zealand Xmas Tree 2 2107 39th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 780393 5984200.2859 2100804.8827 37.7474958486327 -122.497417620086 (37.7474958486327, -122.497417620086)
2892 99717 Private 5 Platanus x hispanica :: Sycamore: London Plane 15 1415 Scott St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6001694.9164 2113468.8804 37.7832779377979 -122.437829320807 (37.7832779377979, -122.437829320807)
3419 252969 Private 5 Pyrus kawakamii :: Evergreen Pear 82 101 Whipple Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5998180.94106 2087280.50358 37.711170613109104 -122.448099970249 (37.7111706131091, -122.448099970249)
3835 253567 Private 5 Salix spp :: Willow 218 25 Raycliff Ter 1 Back Yard : Yard 13 Tree 1 Private 1           6000333.0 2116919.0 37.792673532262505 -122.44278881704399 (37.7926735322625, -122.442788817044)
4012 252965 Private 5 Pyrus kawakamii :: Evergreen Pear 82 115X Whipple Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 02:04:00 PM 3              
4061 252970 Private 5 Pyrus kawakamii :: Evergreen Pear 82 101X Whipple Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 12:21:00 PM 3              
4066 252966 Private 5 Pyrus kawakamii :: Evergreen Pear 82 111 Whipple Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 12:19:00 PM 3     5998135.7809 2087327.97675 37.7112983819328 -122.448259470506 (37.7112983819328, -122.448259470506)
4074 252967 Private 5 Pyrus kawakamii :: Evergreen Pear 82 109 Whipple Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 01:55:00 PM 3     5998144.81293 2087318.48212 37.7112728281964 -122.448227570418 (37.7112728281964, -122.448227570418)
4630 25362 Private 5 Lophostemon confertus :: Brisbane Box 11 974 Geneva Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/18/2017 12:00:00 AM 3 3X3 Permit Number 780532 6000558.35356 2088917.09573 37.7157999479938 -122.440000340863 (37.7157999479938, -122.440000340863)
4945 3600 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 36 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/01/2017 03:14:00 PM 3 3X3   6018222.967130001 2098056.59418 37.7418850159701 -122.379577179554 (37.7418850159701, -122.379577179554)
4949 83043 Private 5 Olea europaea :: Olive Tree 41 100X Cargo Way 9 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   03/18/2017 02:49:00 PM 3     6018760.2720099995 2097656.0724299997 37.7408148829885 -122.377691543139 (37.7408148829885, -122.377691543139)
4950 3646 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 82 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   04/10/2017 10:16:00 AM 3 3X3   6017441.11571 2098662.50366 37.7435055673357 -122.38232273959999 (37.7435055673357, -122.3823227396)
4973 3631 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 67 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/01/2017 03:27:00 PM 3 3X3   6017682.09522 2098458.88711 37.7429597849556 -122.381475327351 (37.7429597849556, -122.381475327351)
4980 83034 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 18 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   03/18/2017 02:59:00 PM 3     6018525.50747 2097831.43609 37.7412834585567 -122.37851545254298 (37.7412834585567, -122.378515452543)
4983 83050 Private 5 Rhamnus californica :: Coffeeberry Tree 232 100X Cargo Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/04/2006 12:00:00 AM 1     6018877.26977 2097567.07885 37.7405769700435 -122.377280830842 (37.7405769700435, -122.377280830842)
4985 83041 Private 5 Lophostemon confertus :: Brisbane Box 11 100X Cargo Way 11 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   04/10/2017 09:47:00 AM 3     6018722.37051 2097684.4746 37.74089078129229 -122.377824564564 (37.7408907812923, -122.377824564564)
4989 83048 Private 5 Lophostemon confertus :: Brisbane Box 11 100X Cargo Way 4 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   04/10/2017 09:41:00 AM 3     6018843.8838 2097592.61577 37.7406452501696 -122.37739803950001 (37.7406452501696, -122.3773980395)
4994 3624 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 60 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/01/2017 03:25:00 PM 3 3X3   6017797.96297 2098371.7943700003 37.742727042232396 -122.38106863050601 (37.7427270422324, -122.381068630506)
4998 83042 Private 5 Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 100X Cargo Way 10 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   03/18/2017 02:54:00 PM 3     6018742.83505 2097668.8048 37.740848882771 -122.37775271773 (37.740848882771, -122.37775271773)
5000 83036 Private 5 Ceratonia siliqua :: Carob 97 100X Cargo Way 16 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   03/18/2017 02:55:00 PM 3     6018559.56213 2097806.04485 37.7412156164156 -122.378395939846 (37.7412156164156, -122.378395939846)
5014 3588 Private 5 Lophostemon confertus :: Brisbane Box 11 100X Cargo Way 24 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   04/10/2017 10:07:00 AM 3 3X3   6018423.14615 2097904.9005 37.7414795341434 -122.37887448618 (37.7414795341434, -122.37887448618)
5023 3601 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 37 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   04/10/2017 10:11:00 AM 3 3X3   6018206.00756 2098069.0742900004 37.7419183484432 -122.379636687689 (37.7419183484432, -122.379636687689)
5038 83035 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 17 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   04/10/2017 09:50:00 AM 3     6018541.89406 2097818.9676900003 37.741250126083706 -122.37845792741501 (37.7412501260837, -122.378457927415)
5049 3594 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 30 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     12 3x3   6018322.1359 2097981.33701 37.741683843926396 -122.379229056502 (37.7416838439264, -122.379229056502)
5054 83037 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 15 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/04/2006 12:00:00 AM 5     6018575.81097 2097793.86484 37.74118306815279 -122.378338911137 (37.7411830681528, -122.378338911137)
5058 3648 Private 5 Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 100X Cargo Way 84 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/31/1996 12:00:00 AM 3 3X3   6017409.48154 2098690.6025 37.7435809736936 -122.382434078367 (37.7435809736936, -122.382434078367)
5059 83040 Private 5 Quercus suber :: Cork Oak 76 100X Cargo Way 12 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/04/2006 12:00:00 AM 6     6018704.22704 2097697.64106 37.740925933998 -122.37788821227699 (37.740925933998, -122.377888212277)
5063 3598 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 34 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/01/2017 03:10:00 PM 3 3X3   6018255.028469999 2098031.9569200003 37.7418191352571 -122.37946460960501 (37.7418191352571, -122.379464609605)
5065 3592 Private 5 Lophostemon confertus :: Brisbane Box 11 100X Cargo Way 28 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/31/1996 12:00:00 AM 3 3X3   6018357.04475 2097955.64275 37.741615217581796 -122.379106567936 (37.7416152175818, -122.379106567936)
5066 3614 Private 5 Lophostemon confertus :: Brisbane Box 11 100X Cargo Way 50 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     12 3X3   6017985.84349 2098232.4529 37.742354807434396 -122.380409304248 (37.7423548074344, -122.380409304248)
5070 3618 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 54 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     12 3X3   6017899.85524 2098296.735 37.7425265680461 -122.380711096061 (37.7425265680461, -122.380711096061)
5091 253769 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 100 Raccoon Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
7284 99715 Private 5 Platanus x hispanica :: Sycamore: London Plane 15 1415 Scott St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6001690.8553 2113503.3994 37.7833724872506 -122.43784584376199 (37.7833724872506, -122.437845843762)
7784 99714 Private 5 Platanus x hispanica :: Sycamore: London Plane 15 1415 Scott St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6001688.147999999 2113522.0126 37.7834234404081 -122.43785654353 (37.7834234404081, -122.43785654353)
7821 99713 Private 5 Platanus x hispanica :: Sycamore: London Plane 15 1415 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6001685.4406 2113539.6106 37.7834716060779 -122.43786717092199 (37.7834716060779, -122.437867170922)
8592 121500 Private 5 Pinus radiata :: Monterey Pine 3 251X Pennsylvania Ave 1 Back Yard : Yard 13 Tree 1 DPW 2                    
9555 105225 Private 5 Juniperus chinensis :: Juniper 19 175 Spruce St 1 Front Yard : Yard 7 Tree 1 Private 1     9     5997195.09596 2114417.64894 37.785626103218895 -122.453465347546 (37.7856261032189, -122.453465347546)
10202 173900 Private 5 Ligustrum lucidum :: Glossy Privet 55 601x Hearst Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
13268 187627 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 88 States St 1 Back Yard : Yard 13 Tree 1 Private 1           6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
13466 104640 Private 5 Acacia melanoxylon :: Blackwood Acacia 5 112 07th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 2.5x2.5   6009509.89326 2111697.52669 37.778855505921605 -122.410667371323 (37.7788555059216, -122.410667371323)
13709 115878 Private 5 Pittosporum undulatum :: Victorian Box 26 1125X Newhall St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/01/2016 12:00:00 AM 3   Permit Number 773046 6014969.9373 2096433.719 37.737248978447 -122.390711808999 (37.737248978447, -122.390711808999)
14482 109063 Private 5 Magnolia grandiflora :: Southern Magnolia 21 401 Harrison St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/2015 12:00:00 AM 3   Permit Number 774722 6014773.1420599995 2114255.79417 37.7861736122787 -122.39263857322901 (37.7861736122787, -122.392638573229)
15625 109064 Private 5 Magnolia grandiflora :: Southern Magnolia 21 401 Harrison St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/2015 12:00:00 AM 3   Permit Number 774722 6014787.30736 2114269.34055 37.7862115942283 -122.39259051256799 (37.7862115942283, -122.392590512568)
15764 80467 Private 5 Alnus cordata :: Italian Alder 294 1780 Bancroft Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/07/2002 12:00:00 AM 10     6013451.73876 2092852.71308 37.727331923129896 -122.395710120444 (37.7273319231299, -122.395710120444)
16217 22383 Private 5 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1799X Armstrong Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/13/1997 12:00:00 AM 2 4x15   6013476.602999999 2093118.78047 37.7280638732384 -122.39564279807301 (37.7280638732384, -122.395642798073)
16245 109062 Private 5 Magnolia grandiflora :: Southern Magnolia 21 401 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/2015 12:00:00 AM 3   Permit Number 774722 6014756.57852 2114238.14616 37.7861242349771 -122.392694644144 (37.7861242349771, -122.392694644144)
18151 124716 Private 5 Acacia melanoxylon :: Blackwood Acacia 5 2195 Palou Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
19281 114961 Private 5 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 220 Evelyn Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2015 12:00:00 AM     Permit Number 776128 5997838.7 2098850.9 37.7429206264442 -122.45011626136801 (37.7429206264442, -122.450116261368)
22310 3634 Private 5 Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 100X Cargo Way 70 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6 3X3   6017632.60306 2098495.95511 37.743058833606604 -122.38164903679899 (37.7430588336066, -122.381649036799)
22311 3643 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 79 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6 3X3   6017487.6627 2098619.8542 37.7433910314633 -122.382158823763 (37.7433910314633, -122.382158823763)
22313 3602 Private 5 Metrosideros excelsa :: New Zealand Xmas Tree 2 100X Cargo Way 38 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   03/07/2006 12:00:00 AM 3 3X3   6018187.24152 2098084.4470599997 37.7419595239099 -122.379702643058 (37.7419595239099, -122.379702643058)
22315 3636 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 72 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     12 3X3   6017599.14752 2098522.45762 37.7431297568333 -122.38176656108601 (37.7431297568333, -122.381766561086)
22318 3611 Private 5 Ceratonia siliqua :: Carob 97 100X Cargo Way 47 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/31/1996 12:00:00 AM 3 3X3   6018038.2961099995 2098194.83807 37.7422544187983 -122.380225323637 (37.7422544187983, -122.380225323637)
22321 3630 Private 5 Melaleuca quinquenervia :: Cajeput 50 100X Cargo Way 66 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     12 3X3   6017698.24794 2098446.68655 37.7429271764597 -122.381418626885 (37.7429271764597, -122.381418626885)
22327 3638 Private 5 Lophostemon confertus :: Brisbane Box 11 100X Cargo Way 74 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6 3X3   6017567.18226 2098548.9302 37.7432006800566 -122.381878930467 (37.7432006800566, -122.381878930467)
22328 3612 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 48 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6 3X3   6018020.628269999 2098207.76094 37.7422889275932 -122.380287312129 (37.7422889275932, -122.380287312129)
22330 3607 Private 5 Lophostemon confertus :: Brisbane Box 11 100X Cargo Way 43 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6 3x3   6018106.23722 2098142.91565 37.742115598557895 -122.37998679465001 (37.7421155985579, -122.37998679465)
22333 3610 Private 5 Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 100X Cargo Way 46 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6 3X3   6018056.230380001 2098180.90993 37.742217164400294 -122.380162344118 (37.7422171644003, -122.380162344118)
22335 3628 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 64 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6 3X3   6017730.69941 2098422.13413 37.7428615520079 -122.38130471064899 (37.7428615520079, -122.381304710649)
22337 3609 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 45 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     9 3X3   6018070.77279 2098169.47823 37.7421865775631 -122.380111266222 (37.7421865775631, -122.380111266222)
22338 3608 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 44 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   03/07/2006 12:00:00 AM 3 3X3   6018087.01832 2098157.15518 37.7421536371939 -122.380054237523 (37.7421536371939, -122.380054237523)
22339 3642 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 78 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6 3X3   6017503.4842 2098606.02713 37.7433539389383 -122.382103154832 (37.7433539389383, -122.382103154832)
22340 3632 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 68 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6 3X3   6017663.5913 2098472.7680200003 37.7429968775117 -122.38154027458799 (37.7429968775117, -122.381540274588)
22341 3629 Private 5 Metrosideros excelsa :: New Zealand Xmas Tree 2 100X Cargo Way 65 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6 3X3   6017712.663240001 2098437.04484 37.7429014981049 -122.38136811194201 (37.7429014981049, -122.381368111942)
22344 3639 Private 5 Ceratonia siliqua :: Carob 97 100X Cargo Way 75 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   03/07/2006 12:00:00 AM 3 3X3   6017551.66161 2098562.89956 37.743238180001995 -122.381933568796 (37.743238180002, -122.381933568796)
22346 3622 Private 5 Lophostemon confertus :: Brisbane Box 11 100X Cargo Way 58 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6 3X3   6017832.2114699995 2098347.65106 37.7426626399605 -122.380948529647 (37.7426626399605, -122.380948529647)
22347 3647 Private 5 Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 100X Cargo Way 83 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/31/1996 12:00:00 AM 3 3X3   6017425.17191 2098677.66921 37.7435463281955 -122.38237892474599 (37.7435463281955, -122.382378924746)
22348 3623 Private 5 Metrosideros excelsa :: New Zealand Xmas Tree 2 100X Cargo Way 59 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   03/07/2006 12:00:00 AM 3 3X3   6017813.51979 2098359.7555299997 37.7426948446985 -122.38101400211 (37.7426948446985, -122.38101400211)
22349 3626 Private 5 Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 100X Cargo Way 62 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     12 3X3   6017765.800369999 2098395.89545 37.7427914435713 -122.38118151611201 (37.7427914435713, -122.381181516112)
22350 3645 Private 5 Lophostemon confertus :: Brisbane Box 11 100X Cargo Way 81 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   03/07/2006 12:00:00 AM 3 3X3   6017457.23238 2098648.52258 37.7434680683118 -122.38226603915399 (37.7434680683118, -122.382266039154)
22352 3605 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 41 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6 3X3   6018137.75637 2098119.86028 37.7420540318827 -122.37987620861601 (37.7420540318827, -122.379876208616)
22941 110324 Private 5 Tree(s) :: 17 580 Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/06/2015 12:00:00 AM 3   Permit Number 773594 6005065.6 2110970.4 37.7766088164574 -122.42599017584601 (37.7766088164574, -122.425990175846)
23209 83033 Private 5 Olea europaea :: Olive Tree 41 100X Cargo Way 3 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/04/2006 12:00:00 AM 1     6018894.74802 2097554.01331 37.7405420574702 -122.377219490814 (37.7405420574702, -122.377219490814)
23256 3593 Private 5 Ceratonia siliqua :: Carob 97 100X Cargo Way 29 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   04/06/2016 12:00:00 AM 7 3X3   6018341.35218 2097966.95491 37.7416454132021 -122.379161613636 (37.7416454132021, -122.379161613636)
43784 83046 Private 5 Olea europaea 'Fruitless' :: Fruitless Olive 80 100X Cargo Way 6 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/04/2006 12:00:00 AM 1     6018811.25128 2097616.11187 37.740707968002 -122.37751250161399 (37.740707968002, -122.377512501614)
57485 73751 Private 5 Arbutus unedo :: Strawberry Tree 61 794-798 19th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/09/1996 12:00:00 AM 10 3x3   5990095.37972 2109981.17843 37.7730352575459 -122.477703639701 (37.7730352575459, -122.477703639701)
76816 104448 Private 5 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2490X Folsom St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3       3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816)
78203 26198 Private 5 Lophostemon confertus :: Brisbane Box 11 3830 03rd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 3x4   6015747.5106037995 2098323.3315623 37.742480578689 -122.388155190044 (37.742480578689, -122.388155190044)
78271 16888 Private 5 Tristaniopsis laurina :: Swamp Myrtle 37 300X Oak St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3X3   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
79103 120636 Private 5 Private shrub :: Private Shrub 64 385 Nevada St 1 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1       3x3   6008960.0 2096519.0 37.7371478708762 -122.411497024701 (37.7371478708762, -122.411497024701)

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