Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 275 | 275 | 818 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1385 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 5982124.8821 | 2105687.3873 | 37.7607799675436 | -122.504955867812 | (37.7607799675436, -122.504955867812) | |||
| 278 | 278 | 9598 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1350 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003113.217999999 | 2112071.7207 | 37.7795222347306 | -122.43282272296999 | (37.7795222347306, -122.43282272297) | |||
| 281 | 281 | 9686 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6005996.09112 | 2110833.49174 | 37.7762854431535 | -122.42276159987499 | (37.7762854431535, -122.422761599875) | |||
| 286 | 286 | 10157 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 995 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005745.7610599995 | 2103227.37374 | 37.755386722241504 | -122.42308680461201 | (37.7553867222415, -122.423086804612) | |||
| 288 | 288 | 226558 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 320 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 7ft | 6004836.50691 | 2106380.98977 | 37.7639944545966 | -122.42645581878 | (37.7639944545966, -122.42645581878) | |||
| 291 | 291 | 129605 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2101 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 4ft | 6005928.19437 | 2117729.67294 | 37.79521682154579 | -122.42348685993299 | (37.7952168215458, -122.423486859933) | |||
| 292 | 292 | 9421 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 701X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767203 | 6006076.0707 | 2112433.28351 | 37.7806825946662 | -122.42259863641199 | (37.7806825946662, -122.422598636412) | |
| 295 | 295 | 230413 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 310 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2016 08:33:00 AM | 1 | Width 7ft | 6004826.22566 | 2106515.9879900003 | 37.7643645463025 | -122.42650099174601 | (37.7643645463025, -122.426500991746) | ||
| 296 | 296 | 18021 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2725 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000769.3896 | 2114817.5231 | 37.78692829139071 | -122.44112805661501 | (37.7869282913907, -122.441128056615) | |||
| 309 | 309 | 20164 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1155X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1990 12:00:00 AM | 25 | 4X4 | 6002621.0 | 2112212.0 | 37.7798794773869 | -122.43453554599199 | (37.7798794773869, -122.434535545992) | ||
| 313 | 313 | 230412 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 310 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2016 08:29:00 AM | 1 | Width 6ft | 6004822.22232 | 2106544.83878 | 37.7644435373721 | -122.426516892666 | (37.7644435373721, -122.426516892666) | ||
| 315 | 315 | 127442 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2101 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 4ft | 6005941.14617 | 2117647.79475 | 37.794992735681504 | -122.423436220932 | (37.7949927356815, -122.423436220932) | |||
| 317 | 317 | 7957 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1800 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/2016 03:18:00 PM | 3 | 3X3 | 6005720.43568 | 2116275.48789 | 37.791212266380896 | -122.424102272302 | (37.7912122663809, -122.424102272302) | ||
| 319 | 319 | 3139 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3320 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5998401.91704 | 2114901.9804700003 | 37.7870250535005 | -122.449325021743 | (37.7870250535005, -122.449325021743) | |||
| 323 | 323 | 27392 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2240 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007139.14869 | 2120046.64789 | 37.801646927424706 | -122.419461214785 | (37.8016469274247, -122.419461214785) | |||
| 324 | 324 | 244302 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 350 Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005598.2085 | 2110574.7953 | 37.775552668496104 | -122.424119585265 | (37.7755526684961, -122.424119585265) | |||
| 325 | 325 | 21670 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1776 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 4X4 | 6004121.8146 | 2114641.2436 | 37.786634655728605 | -122.429516856277 | (37.7866346557286, -122.429516856277) | |||
| 329 | 329 | 5267 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1245 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6001292.1098 | 2112753.8798 | 37.7812918154006 | -122.43917160516001 | (37.7812918154006, -122.43917160516) | |||
| 331 | 331 | 244290 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 201 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005571.2897 | 2110005.1565 | 37.7739870584615 | -122.424172183065 | (37.7739870584615, -122.424172183065) | |||
| 332 | 332 | 244303 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 350 Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 0ft | 6005595.8477 | 2110592.7369 | 37.775601798483 | -122.42412902808998 | (37.775601798483, -122.42412902809) | |||
| 335 | 335 | 244346 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005627.7176 | 2110356.4274 | 37.77495474924589 | -122.42400197393101 | (37.7749547492459, -122.424001973931) | |||
| 336 | 336 | 244304 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 350 Octavia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005592.0705 | 2110609.2621 | 37.775646959405705 | -122.42414326985501 | (37.7756469594057, -122.424143269855) | |||
| 337 | 337 | 14819 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1234 McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003219.5071 | 2111735.2352 | 37.7786043572111 | -122.432430984172 | (37.7786043572111, -122.432430984172) | |||
| 338 | 338 | 244347 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005625.3569 | 2110371.5361 | 37.774996100795995 | -122.424011214757 | (37.774996100796, -122.424011214757) | |||
| 340 | 340 | 191854 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 573 10th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 24 | Width 6ft | tree is in ROW therefore DPW maintained | 6009977.72395 | 2108375.30106 | 37.7697596664942 | -122.408814503513 | (37.7697596664942, -122.408814503513) | ||
| 341 | 341 | 14553 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 875 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999239.2853 | 2109883.9856 | 37.7732947980524 | -122.446066856713 | (37.7732947980524, -122.446066856713) | |||
| 342 | 342 | 21738 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2045 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002837.9936 | 2114410.7158 | 37.7859289122324 | -122.43394207733601 | (37.7859289122324, -122.433942077336) | |||
| 343 | 343 | 244298 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 350 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005605.7628 | 2110511.5277 | 37.7753793775331 | -122.42408895277501 | (37.7753793775331, -122.424088952775) | |||
| 344 | 344 | 251279 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Hudson Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6017356.0 | 2095183.0 | 37.733946845802 | -122.38237501907301 | (37.733946845802, -122.382375019073) | |||
| 345 | 345 | 13664 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 648 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 6011893.33766 | 2115132.41268 | 37.788420242855395 | -122.402663664993 | (37.7884202428554, -122.402663664993) | |||
| 346 | 346 | 235602 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 721 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006265.751680001 | 2105377.56697 | 37.761319982338904 | -122.421441210755 | (37.7613199823389, -122.421441210755) | |||
| 348 | 348 | 229175 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 795 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 3ft | 6006285.87907 | 2104987.97511 | 37.7602513890079 | -122.421343931093 | (37.7602513890079, -122.421343931093) | |||
| 352 | 352 | 14742 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004772.182 | 2111961.3352 | 37.779313094037704 | -122.427075791541 | (37.7793130940377, -122.427075791541) | |||
| 353 | 353 | 13824 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 964 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6009889.5706 | 2113199.7435 | 37.7830015179357 | -122.40945995866699 | (37.7830015179357, -122.409459958667) | |||
| 358 | 358 | 251286 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 02/09/1998 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 359 | 359 | 22941 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 413 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/2017 12:00:00 AM | 6 | 3X3 | 6006166.67617 | 2107189.14794 | 37.766288570288204 | -122.421912561635 | (37.7662885702882, -122.421912561635) | ||
| 360 | 360 | 6307 | DPW Maintained 3 | Tristania conferta :: 79 | 1804 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6002139.3488 | 2112974.3616 | 37.781945376326 | -122.436256362281 | (37.781945376326, -122.436256362281) | |||
| 362 | 362 | 187139 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 0ft | 5984937.035 | 2099496.8257 | 37.7439474344515 | -122.494773601416 | (37.7439474344515, -122.494773601416) | |||
| 366 | 366 | 22992 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 670 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/2017 12:00:00 AM | 18 | 3X3 | 6006180.5496 | 2105697.57647 | 37.7621938490894 | -122.42175862016501 | (37.7621938490894, -122.421758620165) | ||
| 367 | 367 | 235603 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 715 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006265.7166 | 2105404.69213 | 37.7613944596986 | -122.42144325851002 | (37.7613944596986, -122.42144325851) | |||
| 368 | 368 | 18096 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 3008 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/1997 12:00:00 AM | 6 | 3X3 | 5999424.6928 | 2114682.6521 | 37.786481285230295 | -122.44577068023099 | (37.7864812852303, -122.445770680231) | ||
| 370 | 370 | 3092 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2980 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000114.4381800005 | 2115142.33295 | 37.7877828069853 | -122.443417371621 | (37.7877828069853, -122.443417371621) | |||
| 375 | 375 | 251284 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 06/21/1996 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 376 | 376 | 229176 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 793 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 3ft | 6006285.11873 | 2105008.6290700003 | 37.7603080570896 | -122.42134802750601 | (37.7603080570896, -122.421348027506) | |||
| 378 | 378 | 138112 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1698 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 0ft | 6004508.5013 | 2114699.1479 | 37.7868155327596 | -122.428183141793 | (37.7868155327596, -122.428183141793) | |||
| 385 | 385 | 251282 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/07/2016 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 388 | 388 | 11057 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1630 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007426.31744 | 2117960.00612 | 37.795933702633796 | -122.418319444503 | (37.7959337026338, -122.418319444503) | |||
| 389 | 389 | 191855 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 573 10th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 49 | Width 6ft | Cal Trans adjacent; 10 ft ROW | 6009921.77605 | 2108434.69103 | 37.7699196037317 | -122.409012217656 | (37.7699196037317, -122.409012217656) | ||
| 390 | 390 | 251276 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1175X Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/09/1998 12:00:00 AM | 3x3 | 6017547.0 | 2094834.0 | 37.732999109091 | -122.381690402626 | (37.732999109091, -122.381690402626) | ||
| 391 | 391 | 251275 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1175x Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 09/16/2011 12:00:00 AM | 3x3 | 6017547.0 | 2094834.0 | 37.732999109091 | -122.381690402626 | (37.732999109091, -122.381690402626) | ||
| 392 | 392 | 251280 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1275x Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/11/2006 12:00:00 AM | 3x3 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 393 | 393 | 251277 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/26/2011 12:00:00 AM | 3x3 | 6017356.0 | 2095183.0 | 37.733946845802 | -122.38237501907301 | (37.733946845802, -122.382375019073) | ||
| 397 | 397 | 13004 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 368 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2016 06:38:00 AM | 3 | 4X4 | 6010562.3418 | 2120670.5672 | 37.8035522695821 | -122.407659361785 | (37.8035522695821, -122.407659361785) | ||
| 398 | 398 | 251281 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1275x Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/23/2006 12:00:00 AM | 3x3 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 399 | 399 | 17856 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2121 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2000 12:00:00 AM | 10 | 3X3 | 6003596.6138 | 2115206.3541 | 37.7881565558045 | -122.431374278321 | (37.7881565558045, -122.431374278321) | ||
| 402 | 402 | 251283 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 06/06/1997 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 405 | 405 | 13887 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1028 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6009423.7082400005 | 2112763.96692 | 37.781778865529105 | -122.411040866943 | (37.7817788655291, -122.411040866943) | |||
| 409 | 409 | 251278 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 01/27/2016 09:31:00 AM | 3x3 | 6017356.0 | 2095183.0 | 37.733946845802 | -122.38237501907301 | (37.733946845802, -122.382375019073) | ||
| 410 | 410 | 251287 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 02/09/1998 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 417 | 417 | 229177 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 789 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | Width 3ft | 6006284.79968 | 2105036.34994 | 37.7603841541343 | -122.42135109956699 | (37.7603841541343, -122.421351099567) | |||
| 418 | 418 | 23307 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/01/2014 12:00:00 AM | 2 | 3x3 | 6006542.6232900005 | 2114014.0044299997 | 37.785049178209206 | -122.421096875635 | (37.7850491782092, -122.421096875635) | ||
| 419 | 419 | 13971 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6008925.3091 | 2112314.2981 | 37.780516220741 | -122.412733301341 | (37.780516220741, -122.412733301341) | |||
| 421 | 421 | 236222 | DPW Maintained 3 | Platanus racemosa :: California Sycamore 81 | 758 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006212.30332 | 2105198.62923 | 37.7608256474983 | -122.42161335716801 | (37.7608256474983, -122.421613357168) | |||
| 428 | 428 | 14314 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 4X4 | 6003589.1349 | 2107204.4091 | 37.766184772649495 | -122.430828874247 | (37.7661847726495, -122.430828874247) | |||
| 436 | 436 | 6932 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 500 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004980.8762 | 2110598.20876 | 37.775582081585895 | -122.42625675563801 | (37.7755820815859, -122.426256755638) | |||
| 437 | 437 | 20292 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 445 | 445 | 251285 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1299x Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/11/2006 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 447 | 447 | 27524 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3201 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 5999021.2149 | 2114925.4479 | 37.787124893549795 | -122.447184087894 | (37.7871248935498, -122.447184087894) | |||
| 449 | 449 | 200971 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1408 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | Width 0ft | Permit Number 779898 | 6007408.8361 | 2110843.7597 | 37.7763932439775 | -122.417875241075 | (37.7763932439775, -122.417875241075) | ||
| 453 | 453 | 200966 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1438 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | Permit Number 779897 | 6007276.3996 | 2110716.1923 | 37.776035520315205 | -122.418324330264 | (37.7760355203152, -122.418324330264) | ||
| 455 | 455 | 234501 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2423 Market St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 12 | Width 8ft | 6002117.5892 | 2105782.84009 | 37.7621980066439 | -122.435816935712 | (37.7621980066439, -122.435816935712) | |||
| 456 | 456 | 23112 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1448 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/1992 12:00:00 AM | 20 | 3X3 | Permit Number 779902 | 6006436.396269999 | 2101132.22455 | 37.74967287242389 | -122.42054965793899 | (37.7496728724239, -122.420549657939) | |
| 463 | 463 | 234072 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 4 | Width 3ft | 6011140.67766 | 2101759.7310900004 | 37.7516598624171 | -122.404326151746 | (37.7516598624171, -122.404326151746) | ||
| 464 | 464 | 18999 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3039 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6000252.38525 | 2115449.79519 | 37.7886348840283 | -122.442962190565 | (37.7886348840283, -122.442962190565) | |||
| 465 | 465 | 200701 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1433 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 1 | Width 0ft | 6014951.6841 | 2095311.6378 | 37.7341669595219 | -122.390696529464 | (37.7341669595219, -122.390696529464) | ||
| 466 | 466 | 1665 | DPW Maintained 3 | Tristania conferta :: 79 | 1400X Fell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1992 12:00:00 AM | 18 | 3X3 | 6000409.8977 | 2109962.9335 | 37.7735783473195 | -122.44202322778901 | (37.7735783473195, -122.442023227789) | ||
| 471 | 471 | 10470 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1614 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2015 08:11:00 AM | 3 | 3x3 | 5998358.4613 | 2108632.1531 | 37.76980724742621 | -122.449023538308 | (37.7698072474262, -122.449023538308) | ||
| 475 | 475 | 6052 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1900 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2003 12:00:00 AM | 3 | 3X3 | 6001270.4508 | 2112511.2313 | 37.7806243318768 | -122.439229137442 | (37.7806243318768, -122.439229137442) | ||
| 477 | 477 | 14079 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1420 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779898 | 6007326.0633 | 2110762.9345 | 37.7761666587056 | -122.418155844592 | (37.7761666587056, -122.418155844592) | ||
| 479 | 479 | 85531 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 101X 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007317.968280001 | 2109362.68703 | 37.7723214572932 | -122.418084555959 | (37.7723214572932, -122.418084555959) | |||
| 480 | 480 | 200973 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1416 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 0ft | Permit Number 779898 | 6007323.0 | 2110807.0 | 37.7762874795996 | -122.41816956622401 | (37.7762874795996, -122.418169566224) | ||
| 481 | 481 | 14087 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779892 | 6007224.7884 | 2110663.6072 | 37.775888228839705 | -122.418499137854 | (37.7758882288397, -122.418499137854) | ||
| 487 | 487 | 85532 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007270.64018 | 2109417.23244 | 37.7724685621036 | -122.418252136526 | (37.7724685621036, -122.418252136526) | |||
| 489 | 489 | 200974 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1422 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 0ft | Permit Number 779898 | 6007323.0 | 2110807.0 | 37.7762874795996 | -122.41816956622401 | (37.7762874795996, -122.418169566224) | ||
| 490 | 490 | 85529 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 3x3 | 6007351.89443 | 2109342.45047 | 37.7722678019432 | -122.417965767207 | (37.7722678019432, -122.417965767207) | ||
| 493 | 493 | 14089 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | Permit Number 779892 | 6007243.2905 | 2110686.0046 | 37.7759507683181 | -122.418436722662 | (37.7759507683181, -122.418436722662) | ||
| 494 | 494 | 14085 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779892 | 6007257.8975 | 2110700.6115 | 37.775991697649104 | -122.418387229062 | (37.7759916976491, -122.418387229062) | ||
| 497 | 497 | 14419 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 5998835.1676 | 2113089.5942 | 37.7820734871416 | -122.447695558807 | (37.7820734871416, -122.447695558807) | ||||
| 498 | 498 | 248943 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1500x Galvez Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/10/2017 01:08:00 PM | 3 | 3x3 | 6016393.0 | 2097292.0 | 37.739684495027205 | -122.385851388433 | (37.7396844950272, -122.385851388433) | |
| 499 | 499 | 248944 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1500x Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/10/2017 12:58:00 PM | 3 | 3x3 | 6016393.0 | 2097292.0 | 37.739684495027205 | -122.385851388433 | (37.7396844950272, -122.385851388433) | |
| 500 | 500 | 6742 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:53:00 PM | 3 | 3x3 | 6016901.500630001 | 2097278.26947 | 37.7396749203573 | -122.384092237585 | (37.7396749203573, -122.384092237585) | ||
| 501 | 501 | 251171 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:21:00 AM | 3 | ||||||||
| 502 | 502 | 18680 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 150X Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 15X15TR | 5999310.287959999 | 2119651.54595 | 37.8001180187875 | -122.446524108406 | (37.8001180187875, -122.446524108406) | |||
| 503 | 503 | 8533 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6001504.6387 | 2113566.4305 | 37.783534963845 | -122.43849459602801 | (37.783534963845, -122.438494596028) | |||
| 505 | 505 | 6741 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300X Fairfax Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:50:00 PM | 3 | 3x3 | 6016924.03316 | 2097256.8815900004 | 37.739617439282604 | -122.38401284003099 | (37.7396174392826, -122.384012840031) | ||
| 507 | 507 | 251288 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1335 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/18/2017 01:58:00 PM | 3 | 3x3 | 6016828.0 | 2097292.0 | 37.7397085577181 | -122.38434732981199 | (37.7397085577181, -122.384347329812) | |
| 508 | 508 | 6667 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Evans Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:21:00 PM | 3 | 3X3 | 6015906.32098 | 2098408.37334 | 37.7427228837554 | -122.387611997891 | (37.7427228837554, -122.387611997891) | ||
| 512 | 512 | 6424 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1100X Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 12:46:00 PM | 3 | 3x3 | 6018234.67827 | 2096633.8011 | 37.7379789554566 | -122.37943787365299 | (37.7379789554566, -122.379437873653) | ||
| 513 | 513 | 8263 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1555 Galvez Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:25:00 PM | 3 | 3x3 | 6016021.98279 | 2097500.00782 | 37.740235103578 | -122.38714872385201 | (37.740235103578, -122.387148723852) | ||
| 516 | 516 | 188685 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1300 Evans Ave | 14 | : 4 | Tree 1 | DPW 2 | 04/10/2017 01:01:00 PM | 3 | Width 3ft | 6017863.857919999 | 2096944.2017700002 | 37.738810795988606 | -122.38074156686301 | (37.7388107959886, -122.380741566863) |
JSON shape: default, array, newline-delimited
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");