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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 157 | 157 | 3193 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3698 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 5996969.37189 | 2114704.2549799997 | 37.7864001056199 | -122.454266992435 | (37.7864001056199, -122.454266992435) | |||
| 192 | 192 | 138369 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6002665.8461 | 2114439.4026 | 37.78599790817471 | -122.434539711553 | (37.7859979081747, -122.434539711553) | |||
| 211 | 211 | 138370 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6002647.5104 | 2114436.9248 | 37.7859900638921 | -122.434602970779 | (37.7859900638921, -122.434602970779) | |||
| 220 | 220 | 138363 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6002798.656 | 2114455.2605 | 37.7860489882217 | -122.434081359893 | (37.7860489882217, -122.434081359893) | |||
| 221 | 221 | 138361 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6002830.8674 | 2114461.7028 | 37.78606850519029 | -122.433970377911 | (37.7860685051903, -122.433970377911) | |||
| 312 | 312 | 226557 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 320 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 7ft | 6004833.37225 | 2106401.74543 | 37.7640512674875 | -122.42646813862 | (37.7640512674875, -122.42646813862) | |||
| 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) | |||
| 383 | 383 | 181340 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1360 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5988678.0351 | 2106085.8063 | 37.7622572799997 | -122.48232089502501 | (37.7622572799997, -122.482320895025) | |||
| 472 | 472 | 236059 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 601X 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004719.95486 | 2107769.51353 | 37.7678004187701 | -122.42695783742799 | (37.7678004187701, -122.426957837428) | |||
| 540 | 540 | 224369 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3159 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1981 12:00:00 AM | 16 | Width 3ft | Permit Number 18874 | 6005753.01157 | 2106639.16646 | 37.7647551137777 | -122.423304250809 | (37.7647551137777, -122.423304250809) | |
| 685 | 685 | 214192 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 359 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1972 12:00:00 AM | 16 | Width 3ft | Permit Number 9509 | 5992777.37887 | 2094232.46292 | 37.7299486265111 | -122.46728101702 | (37.7299486265111, -122.46728101702) | |
| 724 | 724 | 25734 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013899.49111 | 2118360.1858599996 | 37.7973947538281 | -122.395948920127 | (37.7973947538281, -122.395948920127) | ||
| 794 | 794 | 212187 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6002096.28779 | 2095466.30888 | 37.733870041163 | -122.435152693763 | (37.733870041163, -122.435152693763) | ||||
| 796 | 796 | 212189 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6002068.0773599995 | 2095471.6867 | 37.7338832054473 | -122.435250610137 | (37.7338832054473, -122.435250610137) | ||||
| 797 | 797 | 212191 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6002043.865019999 | 2095478.6742 | 37.7339010165159 | -122.435334819059 | (37.7339010165159, -122.435334819059) | ||||
| 806 | 806 | 177713 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 3ft | 5991322.37032 | 2089056.90035 | 37.715653710133296 | -122.471934040933 | (37.7156537101333, -122.471934040933) | |||
| 928 | 928 | 224422 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 2 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 16 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 964 | 964 | 139348 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400 GEARY BLVD | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6004841.9268 | 2114136.7205 | 37.7852901070824 | -122.426989494298 | (37.7852901070824, -122.426989494298) | |||
| 1006 | 1006 | 232567 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 947 Elizabeth St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 6000330.76798 | 2101953.15424 | 37.751580964011204 | -122.441721996685 | (37.7515809640112, -122.441721996685) | |||
| 1072 | 1072 | 7266 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1740 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 4X4 | 6003064.3461 | 2114369.1192 | 37.7858275412041 | -122.433155987425 | (37.7858275412041, -122.433155987425) | |||
| 1114 | 1114 | 232676 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 73 Montezuma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x5 | 6007815.58423 | 2099781.3356 | 37.7460412642866 | -122.41568472316901 | (37.7460412642866, -122.415684723169) | |||
| 1277 | 1277 | 212203 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6001598.82808 | 2095593.8833700002 | 37.7341920703926 | -122.436881688932 | (37.7341920703926, -122.436881688932) | ||||
| 1289 | 1289 | 131895 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3274 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 4ft | 5999203.0 | 2115426.0 | 37.7885096634197 | -122.446591180632 | (37.7885096634197, -122.446591180632) | |||
| 1312 | 1312 | 25735 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013816.07307 | 2118422.78251 | 37.7975619881486 | -122.396241959692 | (37.7975619881486, -122.396241959692) | ||
| 1381 | 1381 | 189623 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 347 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6009091.0 | 2109329.0 | 37.7723285943803 | -122.411949073152 | (37.7723285943803, -122.411949073152) | |||
| 1394 | 1394 | 2927 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1820 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6005591.4546 | 2115905.84085 | 37.7901900249849 | -122.424522238615 | (37.7901900249849, -122.424522238615) | |||
| 1413 | 1413 | 246406 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | |||
| 1420 | 1420 | 228662 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4235 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/07/1990 12:00:00 AM | 16 | Width 3ft | 6001863.4982 | 2104671.44362 | 37.7591319452903 | -122.436616182999 | (37.7591319452903, -122.436616182999) | ||
| 1550 | 1550 | 142038 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1499X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6000824.0 | 2111032.0 | 37.7765373235881 | -122.44066748676701 | (37.7765373235881, -122.440667486767) | |||
| 1555 | 1555 | 18077 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2946 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5999820.6048 | 2114741.0687 | 37.7866642791044 | -122.44440512772499 | (37.7866642791044, -122.444405127725) | |||
| 1566 | 1566 | 21756 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2350 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6008463.4743 | 2120995.0395 | 37.8043254753522 | -122.41494559157199 | (37.8043254753522, -122.414945591572) | |||
| 1578 | 1578 | 143015 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 968 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/2016 07:32:00 AM | 16 | Width 0ft | 6008678.8788 | 2120570.254 | 37.8031712224349 | -122.41417009265301 | (37.8031712224349, -122.414170092653) | ||
| 1906 | 1906 | 244384 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 257 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6005748.2149 | 2110309.2015 | 37.7748318806023 | -122.423581789147 | (37.7748318806023, -122.423581789147) | |||
| 1992 | 1992 | 232379 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4235 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1972 12:00:00 AM | 16 | Width 3ft | Permit Number 10249 | 6001645.52772 | 2101734.6442400003 | 37.751055812089 | -122.43715975664499 | (37.751055812089, -122.437159756645) | |
| 2052 | 2052 | 143142 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2140 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6002105.6639 | 2119495.6188 | 37.7998491537216 | -122.43683987606899 | (37.7998491537216, -122.436839876069) | |||
| 2185 | 2185 | 43087 | Permitted Site 1 | Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 | 240 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 16 | Permit Number 42924 | 6009022.06951 | 2113499.20947 | 37.7837751347655 | -122.41248234170601 | (37.7837751347655, -122.412482341706) | |
| 2205 | 2205 | 123677 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4308 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5994223.96504 | 2114319.57116 | 37.7851860492976 | -122.46373740171002 | (37.7851860492976, -122.46373740171) | |||
| 2219 | 2219 | 122754 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 693 Vermont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 6011277.363419999 | 2105334.1858 | 37.761482160689894 | -122.404105006665 | (37.7614821606899, -122.404105006665) | |||
| 2297 | 2297 | 23709 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | 20 | 6003970.4427 | 2111382.6873 | 37.7776789009548 | -122.429808057223 | (37.7776789009548, -122.429808057223) | |||
| 2315 | 2315 | 195022 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6013709.75083 | 2113894.09551 | 37.785121356022394 | -122.39629229296001 | (37.7851213560224, -122.39629229296) | |||
| 2394 | 2394 | 125087 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2498X Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | Permit Number 779691 | 6001734.0 | 2116823.0 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | ||
| 2481 | 2481 | 12266 | DPW Maintained 3 | Tristania conferta :: 79 | 649 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1991 12:00:00 AM | 16 | 3X3 | 6004915.2268 | 2111219.2684 | 37.7772836485499 | -122.426528085844 | (37.7772836485499, -122.426528085844) | ||
| 2523 | 2523 | 141904 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6004738.7382 | 2111954.0648 | 37.7792912400822 | -122.42719096962601 | (37.7792912400822, -122.427190969626) | |||
| 2569 | 2569 | 139637 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6001520.6292 | 2112190.4921 | 37.7797578963919 | -122.438340667374 | (37.7797578963919, -122.438340667374) | |||
| 2586 | 2586 | 225598 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 236 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/1986 12:00:00 AM | 16 | Width 3ft | Permit Number 22999 | 6003567.57753 | 2109171.0221700002 | 37.771583391799396 | -122.431043812717 | (37.7715833917994, -122.431043812717) | |
| 2607 | 2607 | 139083 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2512 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6000143.6633 | 2113744.4727 | 37.7839463117797 | -122.443215821997 | (37.7839463117797, -122.443215821997) | |||
| 2806 | 2806 | 18057 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2882 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6000155.2064 | 2114785.6979 | 37.7868059046739 | -122.443250696948 | (37.7868059046739, -122.443250696948) | |||
| 2821 | 2821 | 229978 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 530 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 16 | Width 2ft | Permit Number 18745 | 6003326.59414 | 2095915.8411400001 | 37.735174140867294 | -122.43093122660801 | (37.7351741408673, -122.430931226608) | |
| 3088 | 3088 | 245344 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1005 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | 16 | Width 3ft | Permit Number 45840 | 6003175.28861 | 2102361.95423 | 37.752865096051394 | -122.431914479684 | (37.7528650960514, -122.431914479684) | |
| 3160 | 3160 | 109437 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 940 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x6 | 6003136.3777 | 2111029.1486 | 37.7766609049 | -122.432668109569 | (37.7766609049, -122.432668109569) | |||
| 3183 | 3183 | 132950 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2074 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6004267.0 | 2117052.0 | 37.7932622027482 | -122.42918651023999 | (37.7932622027482, -122.42918651024) | |||
| 3336 | 3336 | 240552 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3760 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003400.0 | 2103058.0 | 37.7547890094532 | -122.431187064477 | (37.7547890094532, -122.431187064477) | |||
| 3359 | 3359 | 20213 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1428 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6002747.1929 | 2113184.3178 | 37.7825563803095 | -122.4341685179 | (37.7825563803095, -122.4341685179) | |||
| 3429 | 3429 | 236137 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 44 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6006540.30314 | 2110387.22291 | 37.775090786432294 | -122.42084732634 | (37.7750907864323, -122.42084732634) | |||
| 3590 | 3590 | 246905 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 491 Frederick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 5997325.00222 | 2107400.6153700002 | 37.76636660087539 | -122.45250934033501 | (37.7663666008754, -122.452509340335) | |||
| 3621 | 3621 | 249566 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6005942.163819999 | 2114329.62673 | 37.7858819315591 | -122.42319672154899 | (37.7858819315591, -122.423196721549) | |||
| 4018 | 4018 | 2214 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1180 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 5x6 | 6000870.8593 | 2112663.4365 | 37.7810195019401 | -122.440622432274 | (37.7810195019401, -122.440622432274) | |||
| 4155 | 4155 | 203731 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2342 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2004 12:00:00 AM | 16 | Width 4ft | Permit Number 47446 | 5992657.79242 | 2099436.17889 | 37.7442298192534 | -122.468072813407 | (37.7442298192534, -122.468072813407) | |
| 4223 | 4223 | 246149 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998439.5671 | 2108294.2551 | 37.7688841037799 | -122.44871865576 | (37.7688841037799, -122.44871865576) | |||
| 4247 | 4247 | 246146 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1980 12:00:00 AM | 16 | Width 0ft | Permit Number 18128 | 5998494.9848 | 2108301.523 | 37.76890722837079 | -122.44852749406 | (37.7689072283708, -122.44852749406) | |
| 4299 | 4299 | 248326 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1525 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998285.1242 | 2108217.0336 | 37.768663240508 | -122.44924729658001 | (37.768663240508, -122.44924729658) | |||
| 4547 | 4547 | 131706 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 135 Locust St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5997495.0 | 2115921.0 | 37.789771092089794 | -122.452536302556 | (37.7897710920898, -122.452536302556) | |||
| 4551 | 4551 | 131707 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 135 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5997495.0 | 2115921.0 | 37.789771092089794 | -122.452536302556 | (37.7897710920898, -122.452536302556) | |||
| 4561 | 4561 | 142481 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 577 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2016 07:08:00 AM | 16 | Width 0ft | 6009828.1399 | 2119441.0618 | 37.8001352254525 | -122.41011325800501 | (37.8001352254525, -122.410113258005) | ||
| 4572 | 4572 | 132358 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 400 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6012526.494519999 | 2117856.33871 | 37.7959348285947 | -122.400664460412 | (37.7959348285947, -122.400664460412) | |||
| 4594 | 4594 | 142511 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 401 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2016 07:23:00 AM | 16 | Width 0ft | 6010278.0429 | 2119027.9064 | 37.799026008755 | -122.408527252185 | (37.799026008755, -122.408527252185) | ||
| 4730 | 4730 | 234655 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 437 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 6x12 | 6002991.56268 | 2105705.90685 | 37.762036373292 | -122.432788699846 | (37.762036373292, -122.432788699846) | |||
| 5186 | 5186 | 180527 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 543 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6003103.45709 | 2090752.9991099997 | 37.720985491961 | -122.43133426946301 | (37.720985491961, -122.431334269463) | |||
| 5241 | 5241 | 18090 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3000 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5999493.6958 | 2114692.3125 | 37.786511749732 | -122.44553264282699 | (37.786511749732, -122.445532642827) | |||
| 5289 | 5289 | 5945 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1415 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6003671.9554 | 2112797.4667 | 37.7815466261115 | -122.43094162257 | (37.7815466261115, -122.43094162257) | |||
| 5444 | 5444 | 7347 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2226 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6002843.64008 | 2115975.51024 | 37.790225759563 | -122.43403443894199 | (37.790225759563, -122.434034438942) | |||
| 5468 | 5468 | 3007 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2383 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 2X3 | 6003000.8179 | 2115475.95 | 37.788863013488296 | -122.433454901543 | (37.7888630134883, -122.433454901543) | |||
| 5470 | 5470 | 100796 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2477 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6002339.98716 | 2116721.3494700002 | 37.79224504601171 | -122.43583042464199 | (37.7922450460117, -122.435830424642) | |||
| 5513 | 5513 | 3181 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3600 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5997096.38905 | 2114719.80521 | 37.7864500854504 | -122.453828670963 | (37.7864500854504, -122.453828670963) | |||
| 5521 | 5521 | 13457 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 4X4 | 6013874.78204 | 2117010.42231 | 37.79368724652829 | -122.39593978660801 | (37.7936872465283, -122.395939786608) | |||
| 5532 | 5532 | 2876 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1454 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6007376.68644 | 2116152.23291 | 37.7909672119236 | -122.418362935713 | (37.7909672119236, -122.418362935713) | |||
| 5844 | 5844 | 11094 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1919 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6007253.30573 | 2118908.87044 | 37.798529306126795 | -122.41898543293001 | (37.7985293061268, -122.41898543293) | |||
| 6202 | 6202 | 9755 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 725 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/1997 12:00:00 AM | 16 | 4x4 | 6005757.8268 | 2112173.6531 | 37.7799517537853 | -122.423681131146 | (37.7799517537853, -122.423681131146) | ||
| 6275 | 6275 | 94965 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3098 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2010 12:00:00 AM | 16 | 4x9 | 5999357.80905 | 2116682.46141 | 37.7919684172533 | -122.446145981273 | (37.7919684172533, -122.446145981273) | ||
| 6415 | 6415 | 18972 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2900X Sacramento St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6000755.04185 | 2115567.80541 | 37.7889875549728 | -122.441231548694 | (37.7889875549728, -122.441231548694) | |||
| 6550 | 6550 | 114575 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3621 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5997436.353519999 | 2115714.9226900004 | 37.789201898491704 | -122.452724333156 | (37.7892018984917, -122.452724333156) | |||
| 6705 | 6705 | 106209 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 585X Bush St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 16 | 3x16 | 6010847.77195 | 2115873.69146 | 37.7903971865333 | -122.406333425049 | (37.7903971865333, -122.406333425049) | |||
| 6841 | 6841 | 14479 | DPW Maintained 3 | Tristania conferta :: 79 | 270 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5998992.7029 | 2112117.3083 | 37.7794128442998 | -122.44708056796001 | (37.7794128442998, -122.44708056796) | |||
| 6867 | 6867 | 18000 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2670 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6001175.0601 | 2114930.6744 | 37.7872620743104 | -122.43973264788299 | (37.7872620743104, -122.439732647883) | |||
| 6876 | 6876 | 2875 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1436 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6007428.26282 | 2116159.11985 | 37.7909890249637 | -122.41818497155701 | (37.7909890249637, -122.418184971557) | |||
| 6888 | 6888 | 27268 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2080 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6006061.90991 | 2117499.35626 | 37.794591976178296 | -122.423007804569 | (37.7945919761783, -122.423007804569) | |||
| 6913 | 6913 | 42637 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x4 | Permit Number 42688 | 6005203.48268 | 2118840.06651 | 37.7982247489172 | -122.42607356463999 | (37.7982247489172, -122.42607356464) |
| 7085 | 7085 | 42636 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x5 | Permit Number 42688 | 6005181.30457 | 2118838.80185 | 37.7982200229931 | -122.426150217479 | (37.7982200229931, -122.426150217479) |
| 7255 | 7255 | 9753 | DPW Maintained 3 | Tristania conferta :: 79 | 725 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/1990 12:00:00 AM | 16 | 4x4 | 6005752.1131 | 2112212.6104 | 37.780058398475106 | -122.423703668106 | (37.7800583984751, -122.423703668106) | ||
| 7264 | 7264 | 121250 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 31 Orben Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x3 | Permit Number 778957 | 6003136.4072 | 2115361.6956 | 37.788556991677495 | -122.432977615629 | (37.7885569916775, -122.432977615629) | ||
| 7312 | 7312 | 3059 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2737 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X2 | 6001071.6753 | 2115209.0181 | 37.7880204491267 | -122.440110303377 | (37.7880204491267, -122.440110303377) | |||
| 7354 | 7354 | 42635 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x5 | Permit Number 42688 | 6005113.3477300005 | 2118824.42387 | 37.7981767035488 | -122.426384344263 | (37.7981767035488, -122.426384344263) |
| 7389 | 7389 | 18951 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2841 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6001216.78701 | 2115581.69582 | 37.789051985994 | -122.439634971495 | (37.789051985994, -122.439634971495) | |||
| 7503 | 7503 | 2209 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1131 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 4X4 | 6000831.9408 | 2112595.4137 | 37.78083051240179 | -122.44075218952801 | (37.7808305124018, -122.440752189528) | |||
| 7684 | 7684 | 101521 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3010 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | Permit Number 23924 | 6000238.846469999 | 2115823.4476799998 | 37.7896600644188 | -122.443035877412 | (37.7896600644188, -122.443035877412) | ||
| 7705 | 7705 | 104698 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 455 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6011319.973040001 | 2118997.1094299997 | 37.7989997441925 | -122.40491963593901 | (37.7989997441925, -122.404919635939) | |||
| 7760 | 7760 | 14671 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 735 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 4x4 | 6005659.8218 | 2112023.5316 | 37.779534024179995 | -122.42400949606301 | (37.77953402418, -122.424009496063) | |||
| 7771 | 7771 | 96366 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1326 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6006664.3237 | 2118739.81484 | 37.7980319387709 | -122.421011488604 | (37.7980319387709, -122.421011488604) | |||
| 7899 | 7899 | 101329 | Undocumented 2 | Tristania conferta :: 79 | 2703 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5997904.4066 | 2111642.2894 | 37.7780463265361 | -122.45081116588301 | (37.7780463265361, -122.450811165883) | |||
| 7911 | 7911 | 42632 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x4 | Permit Number 42688 | 6005134.3142099995 | 2118828.07494 | 37.7981879136105 | -122.42631205408199 | (37.7981879136105, -122.426312054082) |
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");