Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCaretaker
qLegalStatus ✖
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 656 | 656 | 23200 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006725.22564 | 2112390.29825 | 37.7806011691535 | -122.420349841196 | (37.7806011691535, -122.420349841196) | |||
| 1026 | 1026 | 13476 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6013666.75675 | 2116818.6011799998 | 37.7931489752948 | -122.396646124018 | (37.7931489752948, -122.396646124018) | |||
| 1325 | 1325 | 141834 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1131 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 6004558.497 | 2112571.6053 | 37.7809766592124 | -122.427858513843 | (37.7809766592124, -122.427858513843) | |||
| 1479 | 1479 | 23464 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2305 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005842.187999999 | 2118344.10635 | 37.796899045714504 | -122.423828167031 | (37.7968990457145, -122.423828167031) | |||
| 1538 | 1538 | 3145 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3333 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5998356.8929 | 2114831.5358 | 37.7868290555036 | -122.449475716773 | (37.7868290555036, -122.449475716773) | |||
| 1570 | 1570 | 5344 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 180 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6004766.753190001 | 2107347.6889299997 | 37.7666448358082 | -122.42676592392999 | (37.7666448358082, -122.42676592393) | |||
| 1671 | 1671 | 13627 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 570 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6012289.31562 | 2115520.12346 | 37.789506905374395 | -122.401320892642 | (37.7895069053744, -122.401320892642) | |||
| 1756 | 1756 | 13756 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 838 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6010747.0 | 2114018.0 | 37.7852962621335 | -122.40655126994301 | (37.7852962621335, -122.406551269943) | |||
| 1834 | 1834 | 13113 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1611 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6004587.0591 | 2119767.9005 | 37.8007374842012 | -122.428272736084 | (37.8007374842012, -122.428272736084) | |||
| 1902 | 1902 | 242360 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 388 Coleridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | Width 3ft | 6006031.24378 | 2097876.97394 | 37.7407118512751 | -122.421719507764 | (37.7407118512751, -122.421719507764) | |||
| 1926 | 1926 | 11155 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2615 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6006917.28019 | 2121296.80497 | 37.805067041968 | -122.420317765078 | (37.805067041968, -122.420317765078) | |||
| 2194 | 2194 | 23455 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2240 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6005973.83981 | 2118127.35599 | 37.796311335142995 | -122.423357203778 | (37.796311335143, -122.423357203778) | |||
| 2580 | 2580 | 27387 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 2222 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6007153.30759 | 2119954.57165 | 37.8013949068162 | -122.419405682544 | (37.8013949068162, -122.419405682544) | |||
| 2620 | 2620 | 23170 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 202X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006871.78386 | 2111296.65749 | 37.7776065535391 | -122.41976520271601 | (37.7776065535391, -122.419765202716) | |||
| 2794 | 2794 | 7088 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1864 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5998522.1287 | 2109694.9471 | 37.7727347674481 | -122.448533971797 | (37.7727347674481, -122.448533971797) | |||
| 2986 | 2986 | 114577 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3610 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | 30 | 3x3 | Permit Number 777195 | 5997470.267659999 | 2115762.68023 | 37.7893349711866 | -122.452610443035 | (37.7893349711866, -122.452610443035) | |
| 3357 | 3357 | 32073 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3254 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Permit Number 35447 | 5999189.55674 | 2115674.61094 | 37.7891915158244 | -122.44665558658701 | (37.7891915158244, -122.446655586587) | |||
| 3385 | 3385 | 23505 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2600 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 5x5 | 6005801.9507 | 2119345.52815 | 37.7996464242096 | -122.424038648866 | (37.7996464242096, -122.424038648866) | |||
| 3473 | 3473 | 8205 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1374 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/2006 12:00:00 AM | 30 | 3X3 | 6001195.167 | 2111111.9943 | 37.7767780974284 | -122.43938925166599 | (37.7767780974284, -122.439389251666) | ||
| 3652 | 3652 | 8053 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 608 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/1990 12:00:00 AM | 30 | 3X3 | 6004781.8955 | 2111614.8115 | 37.778362174466295 | -122.427017501013 | (37.7783621744663, -122.427017501013) | ||
| 3655 | 3655 | 116023 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 755 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x5 | 6012121.98551 | 2118393.88956 | 37.7973882454367 | -122.40210195745199 | (37.7973882454367, -122.402101957452) | |||
| 3745 | 3745 | 221791 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 867 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/1991 12:00:00 AM | 30 | Width 6ft | Permit Number 29826 | 6010196.62735 | 2104192.74111 | 37.7582875664398 | -122.407762355146 | (37.7582875664398, -122.407762355146) | |
| 3752 | 3752 | 7102 | DPW Maintained 3 | Tristania conferta :: 79 | 2080 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 5997497.5881 | 2109552.6978 | 37.7722855537803 | -122.45206768793001 | (37.7722855537803, -122.45206768793) | |||
| 3859 | 3859 | 23825 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6003756.6414 | 2112968.1539 | 37.782020088596504 | -122.43066083333599 | (37.7820200885965, -122.430660833336) | |||
| 3956 | 3956 | 15038 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1017 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6015648.0 | 2096190.0 | 37.7366173719863 | -122.388350408836 | (37.7366173719863, -122.388350408836) | |||
| 4039 | 4039 | 3143 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3333 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5998281.9325 | 2114822.5676 | 37.7868001428071 | -122.449734414591 | (37.7868001428071, -122.449734414591) | |||
| 4360 | 4360 | 8196 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1310X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6001489.6126 | 2111152.0859 | 37.7769049310776 | -122.438373551392 | (37.7769049310776, -122.438373551392) | |||
| 4461 | 4461 | 3010 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2408 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/2016 12:00:00 AM | 30 | 3X3 | 6002770.31768 | 2115511.22109 | 37.788946778816296 | -122.434254922131 | (37.7889467788163, -122.434254922131) | ||
| 5019 | 5019 | 23410 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1748X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006148.01248 | 2116523.4539799998 | 37.7919172512266 | -122.422640495371 | (37.7919172512266, -122.422640495371) | |||
| 5275 | 5275 | 2881 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1492 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6007231.00292 | 2116132.4326400002 | 37.7909046433826 | -122.418865591085 | (37.7909046433826, -122.418865591085) | |||
| 5297 | 5297 | 9909 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1850 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005266.16067 | 2116037.55632 | 37.790533307027296 | -122.425657110207 | (37.7905333070273, -122.425657110207) | |||
| 5365 | 5365 | 23511 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2642 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005783.8382 | 2119486.2694099997 | 37.8000318412439 | -122.42411133926599 | (37.8000318412439, -122.424111339266) | |||
| 5372 | 5372 | 3142 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3333 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5998246.7366 | 2114816.476 | 37.7867814031738 | -122.449855744427 | (37.7867814031738, -122.449855744427) | |||
| 5383 | 5383 | 23482 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2450 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6005868.84657 | 2118854.8733 | 37.7983029872579 | -122.423772257989 | (37.7983029872579, -122.423772257989) | |||
| 5421 | 5421 | 13063 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 590 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2X2 | 6009554.3361 | 2120533.7978 | 37.803120257284 | -122.41113795910499 | (37.803120257284, -122.411137959105) | |||
| 5443 | 5443 | 23446 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005973.04919 | 2117793.46515 | 37.7953945104887 | -122.423336192033 | (37.7953945104887, -122.423336192033) | |||
| 5449 | 5449 | 13596 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 540 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6012494.67106 | 2115721.99193 | 37.7900726436904 | -122.40062456737199 | (37.7900726436904, -122.400624567372) | |||
| 5451 | 5451 | 23407 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1748X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006159.63822 | 2116414.10982 | 37.791617675355795 | -122.422592496742 | (37.7916176753558, -122.422592496742) | |||
| 5474 | 5474 | 23494 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2517 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6005746.70695 | 2119056.5774 | 37.7988499198478 | -122.424209251152 | (37.7988499198478, -122.424209251152) | |||
| 5497 | 5497 | 23429 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1940 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6006113.16891 | 2117146.74095 | 37.7936266753722 | -122.422805369879 | (37.7936266753722, -122.422805369879) | |||
| 5528 | 5528 | 23516 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2656 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/26/1994 12:00:00 AM | 30 | 5x5 | 6005775.26266 | 2119527.50037 | 37.800144566769205 | -122.42414394780899 | (37.8001445667692, -122.424143947809) | ||
| 5625 | 5625 | 23563 | Permitted Site 1 | Fraxinus americana :: American Ash 23 | 2940 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6005640.896240001 | 2120504.56885 | 37.8028197593833 | -122.42467845266701 | (37.8028197593833, -122.424678452667) | |||
| 5658 | 5658 | 13028 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 454 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6010168.2162 | 2120621.6241 | 37.8033958137672 | -122.40901980222401 | (37.8033958137672, -122.409019802224) | |||
| 5664 | 5664 | 2849 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1278 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/06/1992 12:00:00 AM | 30 | 3x3 | 6008228.025719999 | 2116269.55524 | 37.7913372370732 | -122.415425636607 | (37.7913372370732, -122.415425636607) | ||
| 5668 | 5668 | 13823 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 956X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6009903.0652 | 2113244.5712 | 37.7831253602597 | -122.40941643736 | (37.7831253602597, -122.40941643736) | |||
| 5716 | 5716 | 7070 | Permitted Site 1 | Tristania conferta :: 79 | 1634 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5999592.5889 | 2109848.7666 | 37.7732182646887 | -122.4448422034 | (37.7732182646887, -122.4448422034) | |||
| 5727 | 5727 | 3064 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2825 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6000790.4891 | 2115166.9367 | 37.787888892538206 | -122.44108013491501 | (37.7878888925382, -122.441080134915) | |||
| 5765 | 5765 | 23561 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2930 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005650.5577 | 2120458.20498 | 37.8026930017358 | -122.424641718951 | (37.8026930017358, -122.424641718951) | |||
| 5843 | 5843 | 8073 | DPW Maintained 3 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 664 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6004507.0606 | 2111574.6856 | 37.77823645397079 | -122.42796539753 | (37.7782364539708, -122.42796539753) | |||
| 5852 | 5852 | 4724 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1050 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4x4 | 6008259.9153 | 2120954.1415 | 37.8042017393393 | -122.41564712883101 | (37.8042017393393, -122.415647128831) | |||
| 5857 | 5857 | 99700 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1412 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4x4 | 6007375.87378 | 2117463.43004 | 37.794567388720296 | -122.41845876116301 | (37.7945673887203, -122.418458761163) | |||
| 5919 | 5919 | 28639 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300 Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6003713.3264 | 2113228.0439 | 37.7827312275464 | -122.43082923608401 | (37.7827312275464, -122.430829236084) | |||
| 6055 | 6055 | 13482 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6013593.59249 | 2116751.4695599996 | 37.792960575426505 | -122.396894569839 | (37.7929605754265, -122.396894569839) | |||
| 6131 | 6131 | 2816 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6009011.243530001 | 2116381.17314 | 37.791687702876 | -122.41272360552401 | (37.791687702876, -122.412723605524) | |||
| 6132 | 6132 | 11153 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2603 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006916.69653 | 2121280.21725 | 37.8050214634311 | -122.420318606842 | (37.8050214634311, -122.420318606842) | |||
| 6214 | 6214 | 23797 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1143 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6003734.1252 | 2112710.5884 | 37.7813116023897 | -122.430720343349 | (37.7813116023897, -122.430720343349) | |||
| 6225 | 6225 | 13241 | Permitted Site 1 | Tristania conferta :: 79 | 2352 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1994 12:00:00 AM | 30 | 3X3 | 6001099.421 | 2119356.9831 | 37.7994112565419 | -122.440311896156 | (37.7994112565419, -122.440311896156) | ||
| 6239 | 6239 | 11016 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2540 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2X3 | 6007002.01732 | 2121033.5199 | 37.804348902732 | -122.42000582623301 | (37.804348902732, -122.420005826233) | |||
| 6410 | 6410 | 2860 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6007887.31914 | 2116222.37624 | 37.79118853956071 | -122.416601133239 | (37.7911885395607, -122.416601133239) | |||
| 6476 | 6476 | 13064 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 590 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 2X2 | 6009534.3118 | 2120532.6199 | 37.8031159000828 | -122.411207170734 | (37.8031159000828, -122.411207170734) | |||
| 6496 | 6496 | 23490 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2500X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005777.87956 | 2119177.1307599996 | 37.799182688783496 | -122.424109961515 | (37.7991826887835, -122.424109961515) | |||
| 6534 | 6534 | 23551 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2900X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 6005612.78895 | 2120375.11437 | 37.802462723129395 | -122.424766503478 | (37.8024627231294, -122.424766503478) | ||||
| 6536 | 6536 | 23173 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 234 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6006914.60002 | 2111387.254 | 37.7778577216055 | -122.419623516337 | (37.7778577216055, -122.419623516337) | |||
| 6615 | 6615 | 11440 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 2200X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005103.39154 | 2117206.5873 | 37.7937339726032 | -122.426303549179 | (37.7937339726032, -122.426303549179) | |||
| 6654 | 6654 | 7065 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1588 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/2014 12:00:00 AM | 30 | 3X3 | 5999848.9957 | 2109884.015 | 37.7733296774154 | -122.443957794129 | (37.7733296774154, -122.443957794129) | ||
| 6662 | 6662 | 3109 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3101 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5999491.6257 | 2114988.3354 | 37.7873244331103 | -122.44556109943998 | (37.7873244331103, -122.44556109944) | |||
| 6679 | 6679 | 13098 | Permitted Site 1 | Tristania conferta :: 79 | 1488 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/1997 12:00:00 AM | 30 | 3X3 | 6005248.4978 | 2119934.433 | 37.8012321434749 | -122.42599574351499 | (37.8012321434749, -122.425995743515) | ||
| 6703 | 6703 | 13816 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 956 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6009921.7278 | 2113229.6411 | 37.783085411390005 | -122.40935081807899 | (37.78308541139, -122.409350818079) | |||
| 6849 | 6849 | 3196 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3700X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5996534.33799 | 2114642.16942 | 37.7862046784438 | -122.45576760121 | (37.7862046784438, -122.45576760121) | |||
| 6883 | 6883 | 14632 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 580 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/1989 12:00:00 AM | 30 | 4X4 | 6006365.97042 | 2112176.3489599996 | 37.7799934657604 | -122.421577478734 | (37.7799934657604, -122.421577478734) | ||
| 6885 | 6885 | 18901 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2590 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6002400.944180001 | 2115794.1415 | 37.7897026338206 | -122.435553151076 | (37.7897026338206, -122.435553151076) | |||
| 6900 | 6900 | 13253 | Permitted Site 1 | Tristania conferta :: 79 | 2400 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6000858.2681 | 2119325.515 | 37.7993111202698 | -122.44114410922899 | (37.7993111202698, -122.441144109229) | |||
| 6990 | 6990 | 11166 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2655 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006897.54428 | 2121449.5194099997 | 37.8054852447207 | -122.420396909886 | (37.8054852447207, -122.420396909886) | |||
| 7022 | 7022 | 14504 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 436 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5999110.8967 | 2111284.0293 | 37.7771316270833 | -122.446611718241 | (37.7771316270833, -122.446611718241) | |||
| 7027 | 7027 | 3144 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3333 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5998323.3892 | 2114826.7979 | 37.7868141298478 | -122.449591289713 | (37.7868141298478, -122.449591289713) | |||
| 7057 | 7057 | 14514 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 507 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5999077.3967 | 2111056.5759 | 37.776505184882204 | -122.446711235239 | (37.7765051848822, -122.446711235239) | |||
| 7101 | 7101 | 7075 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1702 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5999191.7179 | 2109787.4763 | 37.7730270916611 | -122.44622445463699 | (37.7730270916611, -122.446224454637) | |||
| 7109 | 7109 | 18519 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1700X Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6009627.5943 | 2119520.0726 | 37.800340927010296 | -122.410812809398 | (37.8003409270103, -122.410812809398) | |||
| 7116 | 7116 | 7056 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1390 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6000868.0121 | 2110028.3766 | 37.77378413322079 | -122.440443239867 | (37.7737841332208, -122.440443239867) | |||
| 7149 | 7149 | 23486 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005800.3407 | 2119014.80575 | 37.7987382537111 | -122.424020688524 | (37.7987382537111, -122.424020688524) | |||
| 7161 | 7161 | 13825 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 964 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6009866.5201 | 2113217.3058 | 37.783048448274 | -122.40954094417101 | (37.783048448274, -122.409540944171) | |||
| 7170 | 7170 | 4704 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 940 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6008705.2823 | 2120549.3769 | 37.803115382163206 | -122.414077244448 | (37.8031153821632, -122.414077244448) | |||
| 7172 | 7172 | 23175 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 242 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6006898.5067 | 2111467.03507 | 37.7780758746515 | -122.419684850991 | (37.7780758746515, -122.419684850991) | |||
| 7263 | 7263 | 4725 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1050 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4x4 | 6008238.1211 | 2120976.4945 | 37.8042618899237 | -122.415724133248 | (37.8042618899237, -122.415724133248) | |||
| 7273 | 7273 | 27386 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 2222 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6007153.462830001 | 2119942.0708 | 37.8013605913839 | -122.419404257997 | (37.8013605913839, -122.419404257997) | |||
| 7338 | 7338 | 8067 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 632 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/1990 12:00:00 AM | 30 | 3x3 | 6004611.4979 | 2111587.8776 | 37.778278583822996 | -122.427605050593 | (37.778278583823, -122.427605050593) | ||
| 7436 | 7436 | 4702 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 900 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1989 12:00:00 AM | 30 | 3X3 | 6008773.44 | 2120486.1314 | 37.8029455537581 | -122.413836905739 | (37.8029455537581, -122.413836905739) | ||
| 7495 | 7495 | 22650 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1251 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2014 12:00:00 AM | 30 | 5x6 | Permit Number 771274 | 6003965.2704 | 2112486.0639 | 37.7807082067095 | -122.42990467410401 | (37.7807082067095, -122.429904674104) | |
| 7519 | 7519 | 14445 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 5998940.7552 | 2112468.0825 | 37.7803730113246 | -122.44728552935801 | (37.7803730113246, -122.447285529358) | |||
| 7595 | 7595 | 13237 | Permitted Site 1 | Tristania conferta :: 79 | 2320 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1997 12:00:00 AM | 30 | 3X3 | 6001278.1859 | 2119382.1727 | 37.7994905970471 | -122.439695114779 | (37.7994905970471, -122.439695114779) | ||
| 7617 | 7617 | 3122 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3171 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5999239.7647 | 2114955.904 | 37.787221003016 | -122.44643014826 | (37.787221003016, -122.44643014826) | |||
| 7668 | 7668 | 2815 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6009039.2714599995 | 2116385.35959 | 37.7917007709177 | -122.4126269248 | (37.7917007709177, -122.4126269248) | |||
| 7672 | 7672 | 11164 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2650 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6006942.2149 | 2121476.64604 | 37.8055622446775 | -122.42024424728999 | (37.8055622446775, -122.42024424729) | |||
| 7689 | 7689 | 2817 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6008982.46588 | 2116376.26935 | 37.791672623032795 | -122.41282282951201 | (37.7916726230328, -122.412822829512) | |||
| 7762 | 7762 | 13026 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 454 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6010182.8546 | 2120622.6952 | 37.803399574741896 | -122.408969220865 | (37.8033995747419, -122.408969220865) | |||
| 7861 | 7861 | 8161 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1102 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6002408.427999999 | 2111279.278 | 37.7773063874437 | -122.43520419289699 | (37.7773063874437, -122.435204192897) | |||
| 7896 | 7896 | 23176 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 242 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6006895.65618 | 2111480.59471 | 37.77811294557971 | -122.419695674331 | (37.7781129455797, -122.419695674331) | |||
| 7904 | 7904 | 23169 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 202X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006882.10264 | 2111252.84384 | 37.777486833097896 | -122.419726396954 | (37.7774868330979, -122.419726396954) | |||
| 7917 | 7917 | 13681 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6011599.40373 | 2114850.857 | 37.7876307424154 | -122.403660817099 | (37.7876307424154, -122.403660817099) |
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");