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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 353 | 353 | 13824 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 964 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6009889.5706 | 2113199.7435 | 37.7830015179357 | -122.40945995866699 | (37.7830015179357, -122.409459958667) | |||
| 609 | 609 | 13247 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2372X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1994 12:00:00 AM | 40 | 4x4 | 6001031.9779 | 2119351.2951 | 37.7993917986357 | -122.44054486433201 | (37.7993917986357, -122.440544864332) | ||
| 909 | 909 | 234895 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3255x 24th St | 6 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 40 | Width 10ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 931 | 931 | 13827 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 964 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6009845.6649 | 2113195.3529 | 37.7829870022194 | -122.409611544992 | (37.7829870022194, -122.409611544992) | |||
| 1247 | 1247 | 13128 | DPW Maintained 3 | Tristania conferta :: 79 | 1714 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6004131.2449 | 2119777.2826 | 37.8007374433085 | -122.42985071173901 | (37.8007374433085, -122.429850711739) | |||
| 1612 | 1612 | 13833 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 970 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6009828.1026 | 2113177.7906 | 37.782937796191504 | -122.40967106357901 | (37.7829377961915, -122.409671063579) | |||
| 2254 | 2254 | 13986 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1155 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6008672.0 | 2111900.0 | 37.779364436223 | -122.4135803097 | (37.779364436223, -122.4135803097) | |||
| 2340 | 2340 | 13486 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6013525.0360199995 | 2116684.5106599997 | 37.7927729057886 | -122.39712708324801 | (37.7927729057886, -122.397127083248) | |||
| 2903 | 2903 | 13280 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2524 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/15/1993 12:00:00 AM | 40 | 3X3 | 6000256.3025 | 2119240.7621 | 37.7990441048198 | -122.44322102307699 | (37.7990441048198, -122.443221023077) | ||
| 3381 | 3381 | 8153 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1052 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6002732.6953 | 2111326.1234 | 37.777453421805895 | -122.434085798199 | (37.7774534218059, -122.434085798199) | |||
| 3789 | 3789 | 13832 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 970 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6009846.7625 | 2113163.5212 | 37.7828996614361 | -122.409605500316 | (37.7828996614361, -122.409605500316) | |||
| 4679 | 4679 | 13767 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 870 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6010614.78099 | 2113901.0025400002 | 37.7849676168973 | -122.407000460322 | (37.7849676168973, -122.407000460322) | |||
| 4802 | 4802 | 14630 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 580 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6006405.54587 | 2112179.60651 | 37.7800046416385 | -122.42144080067499 | (37.7800046416385, -122.421440800675) | |||
| 5191 | 5191 | 22996 | DPW Maintained 3 | Grevillea robusta :: Silk Oak Tree 145 | 696X Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X6 | 6006194.34403 | 2105555.63063 | 37.76180487700171 | -122.42170082793899 | (37.7618048770017, -122.421700827939) | |||
| 5428 | 5428 | 24310 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2639 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 6006900.22287 | 2121405.53505 | 37.80536462583971 | -122.420384516339 | (37.8053646258397, -122.420384516339) | ||||
| 5504 | 5504 | 13771 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 870 Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6010531.25464 | 2113823.0651599998 | 37.784748944951296 | -122.407283940098 | (37.7847489449513, -122.407283940098) | |||
| 5712 | 5712 | 14629 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 580 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4X4 | 6006423.31397 | 2112182.40692 | 37.7800133326755 | -122.42137953166001 | (37.7800133326755, -122.42137953166) | |||
| 5866 | 5866 | 14435 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90X Masonic Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 3X3 | 5998902.8519 | 2113071.3194 | 37.7820271773983 | -122.447460087026 | (37.7820271773983, -122.447460087026) | |||
| 5883 | 5883 | 13770 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 870 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6010546.78687 | 2113838.87193 | 37.784793215875396 | -122.407231318094 | (37.7847932158754, -122.407231318094) | |||
| 5890 | 5890 | 14472 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 235 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/1990 12:00:00 AM | 40 | 2X2 | 5998919.6038 | 2112167.2256 | 37.7795457275321 | -122.44733704131501 | (37.7795457275321, -122.447337041315) | ||
| 5921 | 5921 | 13805 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 940 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6010091.9291 | 2113426.865 | 37.78363647594129 | -122.408775906869 | (37.7836364759413, -122.408775906869) | |||
| 6054 | 6054 | 13845 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 988 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6009746.4364 | 2113096.1529 | 37.7827090617985 | -122.40994783109 | (37.7827090617985, -122.40994783109) | |||
| 6160 | 6160 | 13487 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6013515.130369999 | 2116692.22603 | 37.792793538939904 | -122.397161898723 | (37.7927935389399, -122.397161898723) | |||
| 6285 | 6285 | 14483 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 281 Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5998945.3239 | 2112016.2894 | 37.7791327654133 | -122.447237198812 | (37.7791327654133, -122.447237198812) | |||
| 6345 | 6345 | 13106 | Permitted Site 1 | Tristania conferta :: 79 | 1557 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 40 | 3x3 | 6004949.0522 | 2119813.2474 | 37.8008824710059 | -122.427023320732 | (37.8008824710059, -122.427023320732) | ||
| 6396 | 6396 | 13484 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6013574.11951 | 2116730.39338 | 37.792901621262104 | -122.39696046946001 | (37.7929016212621, -122.39696046946) | |||
| 6489 | 6489 | 13769 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 870 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6010573.75857 | 2113862.26306 | 37.784858951821604 | -122.407139653797 | (37.7848589518216, -122.407139653797) | |||
| 6522 | 6522 | 14481 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 281 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/1990 12:00:00 AM | 40 | 3X3 | 5998935.5096 | 2112063.3301 | 37.779261366231104 | -122.447274536897 | (37.7792613662311, -122.447274536897) | ||
| 6524 | 6524 | 13479 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6013634.67492 | 2116810.39701 | 37.7931246630115 | -122.396756554485 | (37.7931246630115, -122.396756554485) | |||
| 6546 | 6546 | 13195 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2098 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6002408.3176 | 2119538.5881 | 37.7999843325384 | -122.435795658785 | (37.7999843325384, -122.435795658785) | |||
| 6862 | 6862 | 23930 | Permitted Site 1 | Tristania conferta :: 79 | 1715 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4X4 | 6003466.7876 | 2114641.1577 | 37.786597310936706 | -122.431783083706 | (37.7865973109367, -122.431783083706) | |||
| 7179 | 7179 | 14495 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 339 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X4 | 5998997.0731 | 2111620.7655 | 37.778049715609704 | -122.44702970697399 | (37.7780497156097, -122.447029706974) | |||
| 7265 | 7265 | 11178 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2741 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6006856.2652 | 2121744.00393 | 37.806291497706106 | -122.42056067914899 | (37.8062914977061, -122.420560679149) | |||
| 7423 | 7423 | 13730 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 790 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6010984.14633 | 2114255.43525 | 37.7859614675806 | -122.405747541935 | (37.7859614675806, -122.405747541935) | |||
| 7533 | 7533 | 23864 | DPW Maintained 3 | Tristania conferta :: 79 | 1440 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6003698.6329 | 2113675.0331 | 37.7839577153907 | -122.43091198011601 | (37.7839577153907, -122.430911980116) | |||
| 7620 | 7620 | 13281 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2524 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 40 | 3x3 | 6000224.9781 | 2119238.0771 | 37.7990349463185 | -122.44332922273199 | (37.7990349463185, -122.443329222732) | ||
| 8054 | 8054 | 14425 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 90X Masonic Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 12 | 5998875.1013 | 2112962.0092 | 37.781725454134396 | -122.447548220181 | (37.7817254541344, -122.447548220181) | |||
| 8094 | 8094 | 8144 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 990 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6003074.2562 | 2111370.9925 | 37.7775960000162 | -122.43290743350501 | (37.7775960000162, -122.432907433505) | |||
| 8299 | 8299 | 2926 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1820 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1990 12:00:00 AM | 40 | 3X3 | 6005614.68468 | 2115909.05372 | 37.7902001585605 | -122.424442092852 | (37.7902001585605, -122.424442092852) | ||
| 8447 | 8447 | 13826 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 964 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6009864.3248 | 2113179.9859 | 37.7829458536824 | -122.40954590422399 | (37.7829458536824, -122.409545904224) | |||
| 8656 | 8656 | 13680 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6011622.17093 | 2114867.06809 | 37.787676526003104 | -122.403583187615 | (37.7876765260031, -122.403583187615) | |||
| 8738 | 8738 | 23769 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1001 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6003798.9822 | 2112259.587 | 37.780076939071 | -122.430463780858 | (37.780076939071, -122.430463780858) | |||
| 8955 | 8955 | 13822 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 962X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6009902.7424 | 2113215.1105 | 37.783044450087296 | -122.409415474309 | (37.7830444500873, -122.409415474309) | |||
| 8967 | 8967 | 13759 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 856 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6010638.74998 | 2113921.52353 | 37.78502530391761 | -122.406918981721 | (37.7850253039176, -122.406918981721) | |||
| 9109 | 9109 | 23140 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1621X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 6004632.02812 | 2099337.8259 | 37.744644014501205 | -122.42666146912599 | (37.7446440145012, -122.426661469126) | |||
| 9261 | 9261 | 23750 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4x4 | 6003934.1806 | 2112005.4294 | 37.779386743058296 | -122.429977933491 | (37.7793867430583, -122.429977933491) | |||
| 9657 | 9657 | 114153 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9675 | 9675 | 114114 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9754 | 9754 | 25175 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3066 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 9x9 | Permit Number 772559 | 6000144.4461106 | 2105441.7794376 | 37.7611492576992 | -122.44261677830299 | (37.7611492576992, -122.442616778303) | ||
| 10349 | 10349 | 17525 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 342 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6002628.09189 | 2091001.6668200002 | 37.721641326157204 | -122.43299522107401 | (37.7216413261572, -122.432995221074) | |||
| 10375 | 10375 | 17615 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1018 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 6004156.70512 | 2090037.9094200002 | 37.7190816469907 | -122.427642581247 | (37.7190816469907, -122.427642581247) | |||
| 10459 | 10459 | 1079 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2133 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6000101.3096199995 | 2089802.83807 | 37.718205967213 | -122.441643618974 | (37.718205967213, -122.441643618974) | |||
| 10821 | 10821 | 1299 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 10 | 5991881.88808 | 2087114.90346 | 37.7103538164401 | -122.46985880224301 | (37.7103538164401, -122.469858802243) | |||
| 10968 | 10968 | 17595 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 818 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6003715.34966 | 2090318.2223099999 | 37.719826349498895 | -122.42918815340401 | (37.7198263494989, -122.429188153404) | |||
| 10975 | 10975 | 57115 | Permitted Site 1 | Melaleuca styphelliodes :: Paperbark Tree 239 | 543 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1974 12:00:00 AM | 40 | Permit Number 14385 | 6001502.35867 | 2090596.5763700001 | 37.7204651208625 | -122.43685758890699 | (37.7204651208625, -122.436857588907) | ||
| 11164 | 11164 | 17617 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1042 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6004228.49613 | 2089992.79688 | 37.7189618383998 | -122.427391215355 | (37.7189618383998, -122.427391215355) | |||
| 11202 | 11202 | 17556 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 626 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6003246.79786 | 2090613.7194400001 | 37.7206111833437 | -122.430828848684 | (37.7206111833437, -122.430828848684) | |||
| 11239 | 11239 | 17609 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1000X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6004106.27078 | 2090068.65464 | 37.7191632136975 | -122.42781910286999 | (37.7191632136975, -122.42781910287) | |||
| 11458 | 11458 | 816 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1407 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5982441.9002 | 2105512.2605 | 37.7603177651627 | -122.503846491262 | (37.7603177651627, -122.503846491262) | |||
| 11659 | 11659 | 106061 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 12X Canyon Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 6003256.93175 | 2086330.4794599998 | 37.7088509162175 | -122.430488359046 | (37.7088509162175, -122.430488359046) | ||||
| 11700 | 11700 | 109233 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2570 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x9 | 5986169.5717 | 2097728.0842 | 37.7391630116047 | -122.490381738824 | (37.7391630116047, -122.490381738824) | |||
| 12044 | 12044 | 17598 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6003858.866640001 | 2090228.3157 | 37.719587609170006 | -122.42868565992399 | (37.71958760917, -122.428685659924) | |||
| 12184 | 12184 | 828 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1412 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5981866.7376 | 2105450.851 | 37.7601153156753 | -122.50583112277701 | (37.7601153156753, -122.505831122777) | |||
| 12237 | 12237 | 17610 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1000X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6004083.7901099995 | 2090083.69021 | 37.7192032263241 | -122.427897880781 | (37.7192032263241, -122.427897880781) | |||
| 12238 | 12238 | 1033 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1986 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6000734.4092 | 2090618.0584 | 37.7204804291149 | -122.43951367630899 | (37.7204804291149, -122.439513676309) | |||
| 12243 | 12243 | 974 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1599 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X5 | 6001933.9280900005 | 2093061.6302200002 | 37.7272581220521 | -122.435542049851 | (37.7272581220521, -122.435542049851) | |||
| 12641 | 12641 | 1147 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2673 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X5 | 5998124.85608 | 2088323.0699599998 | 37.7140300561224 | -122.448368842743 | (37.7140300561224, -122.448368842743) | |||
| 12681 | 12681 | 17608 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1000X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1999 12:00:00 AM | 40 | 6x9 | 6004130.9636 | 2090056.2016 | 37.7191304172171 | -122.427732862395 | (37.7191304172171, -122.427732862395) | ||
| 12788 | 12788 | 17558 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 632 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6003270.54295 | 2090597.85658 | 37.7205689727677 | -122.430745637999 | (37.7205689727677, -122.430745637999) | |||
| 12981 | 12981 | 1044 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2006 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6000601.62098 | 2090401.54806 | 37.7198783824605 | -122.439957165309 | (37.7198783824605, -122.439957165309) | |||
| 13501 | 13501 | 18335 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 315 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010354.70669 | 2106796.76065 | 37.7654464639991 | -122.407399223297 | (37.7654464639991, -122.407399223297) | |||
| 13577 | 13577 | 18301 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 66 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x8 | 6010214.22645 | 2107929.32419 | 37.768548360654 | -122.407964989486 | (37.768548360654, -122.407964989486) | |||
| 13720 | 13720 | 18347 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 450 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010310.24011 | 2106203.39594 | 37.7638147305016 | -122.40751118620199 | (37.7638147305016, -122.407511186202) | |||
| 13758 | 13758 | 13987 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1155 Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6008674.4629 | 2111946.6237 | 37.7794925920949 | -122.413575087924 | (37.7794925920949, -122.413575087924) | |||
| 13801 | 13801 | 14001 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1169 Market St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6008548.2288 | 2111815.0326 | 37.77912418524271 | -122.414002475128 | (37.7791241852427, -122.414002475128) | |||
| 13894 | 13894 | 18337 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 333 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010361.5425 | 2106726.15165 | 37.7652529703592 | -122.40737060147801 | (37.7652529703592, -122.407370601478) | |||
| 13969 | 13969 | 18355 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 530 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6010321.43167 | 2105923.74376 | 37.7630474954578 | -122.407452760863 | (37.7630474954578, -122.407452760863) | |||
| 14088 | 14088 | 18359 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 530 Potrero Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010330.56094 | 2105773.09746 | 37.7626343658127 | -122.407410564659 | (37.7626343658127, -122.407410564659) | |||
| 14313 | 14313 | 18319 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 201 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010330.491230001 | 2107287.89813 | 37.766793660123 | -122.40751760916001 | (37.766793660123, -122.40751760916) | |||
| 14376 | 14376 | 14002 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1169 Market St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6008581.8698 | 2111847.3005 | 37.7792146745703 | -122.413888379992 | (37.7792146745703, -122.413888379992) | |||
| 14411 | 14411 | 13834 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 969 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6009863.2921 | 2113087.3887 | 37.78269154589 | -122.409542939524 | (37.78269154589, -122.409542939524) | |||
| 14444 | 14444 | 18315 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 180 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6010239.5154099995 | 2107483.3538 | 37.7673252439851 | -122.40784606493901 | (37.7673252439851, -122.407846064939) | |||
| 14484 | 14484 | 14003 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1169 Market St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6008564.706 | 2111828.7636 | 37.779162812711704 | -122.41394644518101 | (37.7791628127117, -122.413946445181) | |||
| 14496 | 14496 | 843 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 111X Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010316.34076 | 2107575.5688099996 | 37.7675827459718 | -122.407586838062 | (37.7675827459718, -122.407586838062) | |
| 14715 | 14715 | 18348 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 450 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6010315.31619 | 2106176.19135 | 37.7637403169978 | -122.407491711398 | (37.7637403169978, -122.407491711398) | |||
| 14748 | 14748 | 13762 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 865 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6010419.58295 | 2113602.96355 | 37.7841383475539 | -122.407654764781 | (37.7841383475539, -122.407654764781) | |||
| 14823 | 14823 | 18356 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 530 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6010323.6176 | 2105892.85967 | 37.7629628170943 | -122.407443022981 | (37.7629628170943, -122.407443022981) | |||
| 15026 | 15026 | 18303 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 66 Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4.5x9 | 6010216.03432 | 2107898.30496 | 37.7684632901843 | -122.40795654844999 | (37.7684632901843, -122.40795654845) | |||
| 15064 | 15064 | 13889 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1035 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6009418.1161 | 2112637.5269 | 37.7814313776989 | -122.411051279539 | (37.7814313776989, -122.411051279539) | |||
| 15207 | 15207 | 10616 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 54 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6016854.178859999 | 2095636.50917 | 37.735164359841 | -122.384141556392 | (37.735164359841, -122.384141556392) | |||
| 15208 | 15208 | 18336 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 325 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010355.87532 | 2106756.10317 | 37.7653348932237 | -122.40739231471399 | (37.7653348932237, -122.407392314714) | |||
| 15217 | 15217 | 18321 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 225 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010341.463959999 | 2107178.68956 | 37.7664944125046 | -122.40747195596 | (37.7664944125046, -122.40747195596) | |||
| 15235 | 15235 | 13616 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 555 Market St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6012665.47171 | 2115751.39842 | 37.7901629113271 | -122.40003567332899 | (37.7901629113271, -122.400035673329) | |||
| 15285 | 15285 | 18358 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 530 Potrero Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010328.61302 | 2105815.65836 | 37.762751119382 | -122.40742030251499 | (37.762751119382, -122.407420302515) | |||
| 15484 | 15484 | 13926 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1093 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6009084.0411 | 2112338.7399 | 37.78059223996821 | -122.412185898174 | (37.7805922399682, -122.412185898174) | |||
| 15598 | 15598 | 13511 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6013334.6843 | 2116384.87682 | 37.7919395832075 | -122.39776468639499 | (37.7919395832075, -122.397764686395) | |||
| 15836 | 15836 | 13873 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1005 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6009615.4607 | 2112837.6097 | 37.7819918221997 | -122.410382691921 | (37.7819918221997, -122.410382691921) | |||
| 15961 | 15961 | 17437 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1919 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6013108.75457 | 2096537.612 | 37.7374308105776 | -122.397154099803 | (37.7374308105776, -122.397154099803) | |||
| 16254 | 16254 | 13883 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1025 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2004 12:00:00 AM | 40 | 4X4 | 6009464.5221 | 2112703.7125 | 37.7816157098573 | -122.410895412581 | (37.7816157098573, -122.410895412581) | ||
| 16271 | 16271 | 18357 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 530 Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010325.20108 | 2105855.4457900003 | 37.7628601756842 | -122.407434908421 | (37.7628601756842, -122.407434908421) |
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");