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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 141565 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 501X Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1988 12:00:00 AM | 21 | Width 0ft | Permit Number 25401 | 6000609.0 | 2110829.0 | 37.7759676911831 | -122.441396661871 | (37.7759676911831, -122.441396661871) | |
| 4 | 4 | 207368 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 920 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5992009.48044 | 2105269.9271 | 37.760210314285004 | -122.47073935813 | (37.760210314285, -122.47073935813) | |||
| 6 | 6 | 141566 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 501X Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6000587.8822 | 2110733.5952 | 37.7757045307049 | -122.441462866076 | (37.7757045307049, -122.441462866076) | |||
| 8 | 8 | 122650 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 9 | 9 | 203507 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 920 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5991972.62617 | 2105259.8491700003 | 37.76018051163321 | -122.470866084321 | (37.7601805116332, -122.470866084321) | |||
| 10 | 10 | 122670 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 301x Hickory St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 11 | 11 | 122658 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 12 | 12 | 122660 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 13 | 13 | 122648 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 16 | 16 | 122649 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 17 | 17 | 145278 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 730 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2017 12:00:00 AM | 0 | Width 3ft | Permit Number 779614 | 5992589.961569999 | 2110455.11477 | 37.774481011910204 | -122.469109146279 | (37.7744810119102, -122.469109146279) | |
| 18 | 18 | 96369 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 168 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2011 12:00:00 AM | 24 | 3x3 | Permit Number 767919 | 6001162.44444 | 2121276.45677 | 37.8046852096195 | -122.44023153767799 | (37.8046852096195, -122.440231537678) | |
| 19 | 19 | 182260 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1471 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5987398.0 | 2105276.0 | 37.759959232607606 | -122.486688530832 | (37.7599592326076, -122.486688530832) | |||
| 22 | 22 | 203506 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 910 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5992059.0 | 2105289.0 | 37.760265546982495 | -122.470569484113 | (37.7602655469825, -122.470569484113) | |||
| 23 | 23 | 52566 | Permitted Site 1 | Hakea suaveolens :: Sweet Hakea Tree 14 | 1555 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 2 | 3x3 | Permit Number 777142 | 5983716.6125 | 2104561.7225 | 37.7577827259957 | -122.499367683206 | (37.7577827259957, -122.499367683206) | |
| 24 | 24 | 22346 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 5280 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/27/2014 12:00:00 AM | 3 | 3x3 | 6014341.487000001 | 2093641.8617 | 37.7295482207565 | -122.39268941982701 | (37.7295482207565, -122.392689419827) | ||
| 25 | 25 | 23567 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2975 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/27/1992 12:00:00 AM | 3 | 3X3 | 6005531.337230001 | 2120589.48411 | 37.803046726686894 | -122.42506362870199 | (37.8030467266869, -122.425063628702) | ||
| 26 | 26 | 237469 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4200 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2000 12:00:00 AM | 0 | Width 3ft | Permit Number 43111 | 6001814.64366 | 2102375.07824 | 37.75282390261339 | -122.43662077403299 | (37.7528239026134, -122.436620774033) | |
| 28 | 28 | 21823 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2741 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 3 | 4x4 | 6008229.33947 | 2122327.41953 | 37.8079706947476 | -122.415850241604 | (37.8079706947476, -122.415850241604) | ||
| 31 | 31 | 22614 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005426.7391 | 2112695.1691 | 37.781365013820206 | -122.424863625752 | (37.7813650138202, -122.424863625752) | |||
| 32 | 32 | 10933 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1359 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6016893.48466 | 2096461.5108299998 | 37.7374318223223 | -122.384063092353 | (37.7374318223223, -122.384063092353) | |||
| 33 | 33 | 2889 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1545 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 6006951.47041 | 2116025.01423 | 37.79059395549061 | -122.419825138035 | (37.7905939554906, -122.419825138035) | |||
| 34 | 34 | 240126 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006399.28254 | 2110261.0751 | 37.7747364652596 | -122.42132618837299 | (37.7747364652596, -122.421326188373) | |||
| 36 | 36 | 13434 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6014136.36792 | 2117295.16476 | 37.7944836321678 | -122.39505462349199 | (37.7944836321678, -122.395054623492) | |||
| 38 | 38 | 192589 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1390 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008004.0 | 2110521.0 | 37.775540499151 | -122.415793536261 | (37.775540499151, -122.415793536261) | |||
| 39 | 39 | 3558 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Cargo Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2017 05:52:00 PM | 6 | 3X3 | 6018773.865780001 | 2097541.9761 | 37.7405023461002 | -122.377636624239 | (37.7405023461002, -122.377636624239) | ||
| 40 | 40 | 222540 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Newburg St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002573.08856 | 2099992.67614 | 37.74632546084511 | -122.433827665916 | (37.7463254608451, -122.433827665916) | |||
| 41 | 41 | 192590 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1390 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008004.0 | 2110521.0 | 37.775540499151 | -122.415793536261 | (37.775540499151, -122.415793536261) | |||
| 42 | 42 | 28375 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 3014 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2003 12:00:00 AM | 3 | 3x3 | Permit Number 54020 | 6000248.590919999 | 2115494.6796 | 37.788757908594896 | -122.442978542939 | (37.7887579085949, -122.442978542939) | |
| 43 | 43 | 222539 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Newburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002564.39948 | 2099984.1142599997 | 37.7463014588556 | -122.433857099823 | (37.7463014588556, -122.433857099823) | |||
| 45 | 45 | 27522 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3201 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5998967.7443 | 2114917.3257 | 37.787099536792 | -122.44736849888001 | (37.787099536792, -122.44736849888) | |||
| 46 | 46 | 18228 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1737-1795 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2004 12:00:00 AM | 12 | 3X3 | 6003682.1522 | 2114179.2812 | 37.785341320174396 | -122.431004998109 | (37.7853413201744, -122.431004998109) | ||
| 47 | 47 | 17325 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 150 Otis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/31/2016 12:00:00 AM | 3 | 3x3 | 6006651.4447 | 2108878.4679400004 | 37.7709543699737 | -122.420355751511 | (37.7709543699737, -122.420355751511) | ||
| 48 | 48 | 3528 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2017 04:23:00 PM | 3 | 3X3 | 6018298.55272 | 2097894.94115 | 37.7414453176516 | -122.37930460042801 | (37.7414453176516, -122.379304600428) | ||
| 51 | 51 | 60867 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1983 12:00:00 AM | Permit Number 20649 | |||||||||
| 52 | 52 | 233897 | Undocumented 2 | Araucaria heterophylla :: Norfolk Island Pine 24 | 1021 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003182.0050800005 | 2102290.73647 | 37.75266992967379 | -122.43188616810801 | (37.7526699296738, -122.431886168108) | |||
| 53 | 53 | 251187 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000800.0 | 2109063.0 | 37.771129578660705 | -122.440609247553 | (37.7711295786607, -122.440609247553) | ||||
| 54 | 54 | 121137 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1388x Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 55 | 55 | 2909 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1700 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6006037.49643 | 2115968.63965 | 37.7903876339283 | -122.422983431149 | (37.7903876339283, -122.422983431149) | |||
| 56 | 56 | 27602 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4X4 | 6003218.3377 | 2111393.5053 | 37.7776659856505 | -122.432410615738 | (37.7776659856505, -122.432410615738) | |||
| 57 | 57 | 44642 | Permitted Site 1 | Tree(s) :: 17 | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 58 | 58 | 4749 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1255 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 8 | 3X3 | 6007516.58505 | 2121541.63395 | 37.805773032263296 | -122.41826116482599 | (37.8057730322633, -122.418261164826) | ||
| 59 | 59 | 44994 | Permitted Site 1 | Tree(s) :: 17 | 106 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 60 | 60 | 121139 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1388x Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 62 | 62 | 239043 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006946.59098 | 2109912.5632700003 | 37.773810376676295 | -122.41940820332898 | (37.7738103766763, -122.419408203329) | |||
| 63 | 63 | 222541 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Newburg St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | Permit Number 779491 | 6002580.9472199995 | 2099999.66602 | 37.7463450993615 | -122.433800991143 | (37.7463450993615, -122.433800991143) | ||
| 64 | 64 | 138748 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1614 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000643.1477 | 2114229.9232 | 37.7853077023438 | -122.441522641665 | (37.7853077023438, -122.441522641665) | |||
| 66 | 66 | 222538 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Newburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002556.19825 | 2099973.42317 | 37.746271638232 | -122.43388469462201 | (37.746271638232, -122.433884694622) | |||
| 67 | 67 | 166623 | Permitted Site 1 | Potential Site :: Potential Site 29 | 520 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 18521 | 6001647.24706 | 2101482.78936 | 37.7503643764264 | -122.437135780708 | (37.7503643764264, -122.437135780708) | |
| 68 | 68 | 251188 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Baker St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000800.0 | 2109063.0 | 37.771129578660705 | -122.440609247553 | (37.7711295786607, -122.440609247553) | ||||
| 69 | 69 | 19206 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 630 Sansome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6012230.08543 | 2117977.14861 | 37.7962500076802 | -122.40169859442699 | (37.7962500076802, -122.401698594427) | |||
| 70 | 70 | 121138 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1388x Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 71 | 71 | 251206 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 270 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005145.0 | 2094297.0 | 37.7308320294825 | -122.424529217878 | (37.7308320294825, -122.424529217878) | ||||
| 72 | 72 | 25725 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 729 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004286.7153 | 2111148.1106 | 37.777052715887706 | -122.428697236196 | (37.7770527158877, -122.428697236196) | |||
| 73 | 73 | 65479 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1051 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1997 12:00:00 AM | 10 | 3x3 | Permit Number 28361 | 6008468.497880001 | 2115537.43749 | 37.789340533487795 | -122.41454177659901 | (37.7893405334878, -122.414541776599) |
| 74 | 74 | 188665 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2175X Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 37 | 6011669.71313 | 2097723.45025 | 37.740606653987705 | -122.402212916691 | (37.7406066539877, -122.402212916691) | ||||
| 75 | 75 | 138824 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 729 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6004305.1004 | 2111150.1162 | 37.77705926326529 | -122.428633779399 | (37.7770592632653, -122.428633779399) | |||
| 77 | 77 | 49739 | Permitted Site 1 | Tree(s) :: 17 | 145 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2017 12:00:00 AM | 3 | Permit Number 779552 | 6013462.1222 | 2106403.54987 | 37.764540227980206 | -122.396623740816 | (37.7645402279802, -122.396623740816) | |
| 80 | 80 | 225032 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4425 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2004 12:00:00 AM | 11 | Width 3ft | Permit Number 47310 | 6001257.01437 | 2105216.66208 | 37.7605944983664 | -122.43875275812799 | (37.7605944983664, -122.438752758128) | |
| 81 | 81 | 221366 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 55 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 778991 | 6000992.93047 | 2101385.53728 | 37.750060130381605 | -122.439391477336 | (37.7500601303816, -122.439391477336) | |
| 83 | 83 | 130626 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3660 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | Permit Number 779583 | 5996802.12344 | 2115996.768 | 37.789939408212206 | -122.454939052208 | (37.7899394082122, -122.454939052208) | ||
| 84 | 84 | 36641 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 85 | 85 | 22613 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005358.7073 | 2112686.5825 | 37.7813375942673 | -122.42509837168001 | (37.7813375942673, -122.42509837168) | |||
| 87 | 87 | 11032 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007492.86428 | 2117507.22815 | 37.794694232707 | -122.41805706457599 | (37.794694232707, -122.418057064576) | |||
| 88 | 88 | 251208 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4115 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5982071.0 | 2104840.0 | 37.758450113202294 | -122.505079418654 | (37.7584501132023, -122.505079418654) | ||||
| 89 | 89 | 251189 | Permitted Site 1 | Tree(s) :: 17 | 1493 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2017 12:00:00 AM | 3 | 3x3 | 6016267.45517 | 2096986.6643299998 | 37.7388391569445 | -122.38626419104999 | (37.7388391569445, -122.38626419105) | ||
| 92 | 92 | 98091 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2X Frank Norris St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6007129.633230001 | 2115568.12393 | 37.789349482642606 | -122.41917628075599 | (37.7893494826426, -122.419176280756) | ||
| 94 | 94 | 201404 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1051 Ingalls St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1990 12:00:00 AM | 14 | Width 3ft | 6018112.6185 | 2094686.77545 | 37.732626074632705 | -122.379724665662 | (37.7326260746327, -122.379724665662) | ||
| 97 | 97 | 5266 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1245 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6001289.7409 | 2112772.8314 | 37.781343716873 | -122.43918115910401 | (37.781343716873, -122.439181159104) | |||
| 98 | 98 | 142074 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1384X GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001183.1648 | 2110763.0502 | 37.7758193019084 | -122.439405751925 | (37.7758193019084, -122.439405751925) | |||
| 99 | 99 | 7992 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2247 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2007 12:00:00 AM | 3 | 3X3 | 6005467.69382 | 2117725.44397 | 37.7951792074025 | -122.42507996488001 | (37.7951792074025, -122.42507996488) | ||
| 100 | 100 | 106679 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2200 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2014 12:00:00 AM | 10 | 3x3 | Permit Number 773028 | 5999374.7893199995 | 2116379.94206 | 37.7911387486163 | -122.44606546047702 | (37.7911387486163, -122.446065460477) | |
| 101 | 101 | 192592 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1399X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008031.0 | 2110483.0 | 37.775437677991796 | -122.41569744526699 | (37.7754376779918, -122.415697445267) | |||
| 102 | 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) | ||
| 103 | 103 | 117428 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776915 | ||||||||
| 104 | 104 | 251210 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1170 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1992 12:00:00 AM | |||||||||
| 105 | 105 | 6251 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1315 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/06/2003 12:00:00 AM | 24 | 3X3 | 6004480.8051 | 2113256.6545 | 37.7828532389184 | -122.428176124144 | (37.7828532389184, -122.428176124144) | ||
| 106 | 106 | 10645 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 906 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6003455.1435 | 2110726.9996 | 37.775849351151706 | -122.431543829861 | (37.7758493511517, -122.431543829861) | |||
| 107 | 107 | 142075 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1384X GROVE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001166.7226 | 2110758.8221 | 37.775806756879895 | -122.439462326391 | (37.7758067568799, -122.439462326391) | |||
| 108 | 108 | 192593 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1399X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008031.0 | 2110483.0 | 37.775437677991796 | -122.41569744526699 | (37.7754376779918, -122.415697445267) | |||
| 109 | 109 | 9895 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1800X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005051.0377 | 2115464.4068 | 37.7889474242075 | -122.426360597873 | (37.7889474242075, -122.426360597873) | |||
| 110 | 110 | 97646 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1824 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5988290.0 | 2103126.0 | 37.7541078738982 | -122.48344595561899 | (37.7541078738982, -122.483445955619) | |||
| 111 | 111 | 7749 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 400X Franklin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3 | 6006371.15759 | 2111615.2483900003 | 37.7784531123456 | -122.421519673008 | (37.7784531123456, -122.421519673008) | |||
| 112 | 112 | 9896 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1800X Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2007 12:00:00 AM | 3 | 3X3 | 6004999.6173 | 2115457.4476 | 37.7889254092316 | -122.426538009917 | (37.7889254092316, -122.426538009917) | ||
| 113 | 113 | 183695 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1341 42nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983048.7244 | 2105854.1384 | 37.7612921278024 | -122.50177309900499 | (37.7612921278024, -122.501773099005) | |||
| 115 | 115 | 6964 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 700 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6003997.6735 | 2110460.7643 | 37.7751490695403 | -122.42964808764499 | (37.7751490695403, -122.429648087645) | |||
| 116 | 116 | 26163 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 220 Richardson Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999083.87135 | 2119853.9919 | 37.8006609458028 | -122.447322173097 | (37.8006609458028, -122.447322173097) | |||
| 117 | 117 | 220007 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 929 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/12/2015 03:22:00 PM | 1 | Width 3ft | Permit Number 24134 | 6006336.25046 | 2104153.4311599997 | 37.7579627654961 | -122.421110461684 | (37.7579627654961, -122.421110461684) | |
| 119 | 119 | 251215 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 175X Otis St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.42011195674299 | (37.7705111956623, -122.420111956743) | ||||
| 120 | 120 | 110194 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2123 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774924 | 6001844.69538 | 2115843.7088 | 37.789807124247496 | -122.43748126425501 | (37.7898071242475, -122.437481264255) | |
| 121 | 121 | 59839 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1201 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1981 12:00:00 AM | 3 | Permit Number 19293 | 6016946.5018 | 2093669.1216 | 37.729767407645895 | -122.383685429115 | (37.7297674076459, -122.383685429115) | |
| 122 | 122 | 183689 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1341 42nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5983043.6112 | 2105976.497 | 37.761627789464704 | -122.501799836383 | (37.7616277894647, -122.501799836383) | |||
| 123 | 123 | 18916 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2621 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 6x5 | 6002236.03231 | 2115724.70658 | 37.7895026155894 | -122.4361187581 | (37.7895026155894, -122.4361187581) | |||
| 124 | 124 | 20281 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 20X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 125 | 125 | 119758 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 151X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 126 | 126 | 228560 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 700 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006200.30022 | 2105449.82338 | 37.761514690968596 | -122.42167271244301 | (37.7615146909686, -122.421672712443) | |||
| 127 | 127 | 18052 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2840 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000317.799 | 2114808.7133 | 37.7868783690408 | -122.442689819484 | (37.7868783690408, -122.442689819484) | |||
| 129 | 129 | 20398 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 130 | 130 | 66855 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2041 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | 8 | Permit Number 30161 | 5998071.2779 | 2109932.9259 | 37.7733624072524 | -122.450110663343 | (37.7733624072524, -122.450110663343) | |
| 133 | 133 | 218972 | Undocumented 2 | Fraxinus americana :: American Ash 23 | 742 Myra Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | Permit Number 779535 | 5997475.9556599995 | 2098006.28819 | 37.7405807633888 | -122.451309623139 | (37.7405807633888, -122.451309623139) |
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");