trees
8,298 rows where qLegalStatus_id = 4 sorted by qCaretaker_id
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
408 | 109629 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200X GELLERT DR | 30 | Median : Cutout | Tree | DPW 1 | 30x200 | 5985380 | 2094516.3 | 37.730298158605 | -122.492875173009 | (37.730298158605, -122.492875173009) | 1 | 8 | 4 | 64 | 35 | ||||
932 | 111099 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 480X LAKESHORE DR | 20 | Median : Cutout | Tree | DPW 1 | 30x200 | 5984942 | 2095282 | 37.7323749444343 | -122.494445798495 | (37.7323749444343, -122.494445798495) | 1 | 8 | 4 | 64 | 35 | ||||
1229 | 264907 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
1232 | 264776 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
1376 | 263620 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 3 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
2258 | 264781 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 90x Guy Pl | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
2913 | 264905 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
3022 | 264768 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
3144 | 113684 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X THE EMBARCADERO | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013440 | 2119057 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | 3 | 1 | 10 | 28860 | 6 | ||||
3197 | 261564 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1801 25th St | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
4232 | 264908 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
4280 | 264767 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 90x Guy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
4323 | 264887 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
4382 | 264774 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
4589 | 261026 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 758 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 3x3 | 5989802 | 2110189 | 37.7735888483109 | -122.478733667362 | (37.7735888483109, -122.478733667362) | 11 | 6 | 2 | 55 | 26 | |||
5493 | 264903 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
5495 | 260381 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1924 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015697 | 2093053 | 37.7280065148754 | -122.387962157958 | (37.7280065148754, -122.387962157958) | 10 | 3 | 8 | 58 | 1 | ||||
6639 | 261563 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1801 25th St | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
6742 | 264909 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
7713 | 264772 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
7972 | 264777 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
8504 | 109669 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 200X GELLERT DR | 33 | Median : Cutout | Tree | DPW 1 | 02/26/2015 01:37:00 PM | 3 | 30x200 | 5985380 | 2094516.3 | 37.730298158605 | -122.492875173009 | (37.730298158605, -122.492875173009) | 1 | 8 | 4 | 64 | 35 | ||
8638 | 116994 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 600M Divisadero St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 6001630.0135 | 2110553.7073 | 37.7752699186497 | -122.43784499429 | (37.7752699186497, -122.43784499429) | 15 | 5 | 11 | 29492 | 10 | ||||
9068 | 74830 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 493 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2013 12:00:00 AM | 6x6 | Permit Number 769961 | 6011188.26118785 | 2118621.30079081 | 37.7979605016561 | -122.405348925503 | (37.7979605016561, -122.405348925503) | 3 | 1 | 10 | 308 | 23 | ||
9425 | 264770 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
10029 | 260896 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 866 Kansas St | 1 | Front Yard : Cutout | Tree | DPW 1 | Private | 3x3 | 6011543 | 2104306 | 37.7586738299336 | -122.403113948893 | (37.7586738299336, -122.403113948893) | 10 | 3 | 8 | 28856 | 29 | |||
10225 | 263619 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 2 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
10489 | 102839 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1101X Portola Dr | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10516 | 102842 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10567 | 263621 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 4 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
10663 | 264778 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
10966 | 109166 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 5 | Median : Cutout | Tree | DPW 1 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | ||||
11694 | 263618 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 1 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
11719 | 264769 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
11739 | 264780 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
12086 | 264891 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
12194 | 261567 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 1299 Wisconsin St | 12 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
12634 | 264775 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 90x Guy Pl | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
12651 | 261028 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 743 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 3 | 3x3 | 5989712 | 2110287 | 37.7738527032106 | -122.479052157213 | (37.7738527032106, -122.479052157213) | 11 | 6 | 2 | 55 | 26 | ||
12733 | 102843 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
12931 | 264773 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
13415 | 264888 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
13665 | 109201 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 2401x CASTRO ST | 4 | Median : Yard | Tree | DPW 1 | 6002698 | 2098487 | 37.7421983129634 | -122.433288166914 | (37.7421983129634, -122.433288166914) | 2 | 7 | 5 | 63 | 7 | |||||
13700 | 104171 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 2607 DIAMOND ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6002306 | 2096613 | 37.7370304975493 | -122.434509617625 | (37.7370304975493, -122.434509617625) | 2 | 7 | 5 | 63 | 7 | |||
14967 | 108631 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 501 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6008465.6 | 2113811.6 | 37.7846016393538 | -122.4144296353 | (37.7846016393538, -122.4144296353) | 7 | 10 | 9 | 28852 | 36 | ||||
14985 | 113673 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X THE EMBARCADERO | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013440 | 2119057 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | 3 | 1 | 10 | 28860 | 6 | ||||
15033 | 261569 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1299x Wisconsin St | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
15114 | 264890 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
15154 | 102838 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
15329 | 264906 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
15616 | 264771 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
16338 | 261024 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 751 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 3x3 | 5989703 | 2110237 | 37.773714894321 | -122.479079631213 | (37.773714894321, -122.479079631213) | 11 | 6 | 2 | 55 | 26 | |||
16732 | 262211 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2162 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5999946 | 2089791 | 37.7181646124566 | -122.4421796072 | (37.7181646124566, -122.4421796072) | 9 | 7 | 6 | 28861 | 25 | ||||
17002 | 264889 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
17686 | 261568 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1299 Wisconsin St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
17933 | 264904 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
17999 | 264779 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
18337 | 113889 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 1x STORRIE ST | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 90 | 6000722 | 2105303 | 37.7608011093363 | -122.440609317727 | (37.7608011093363, -122.440609317727) | 15 | 4 | 5 | 28862 | 3 | ||||
18389 | 264893 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
18714 | 111970 | Undocumented 4 | Populus spp :: Poplar Spp 262 | 1x STORRIE ST | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x3 | 6000722 | 2105303 | 37.7608011093363 | -122.440609317727 | (37.7608011093363, -122.440609317727) | 15 | 4 | 5 | 28862 | 3 | |||
19473 | 261023 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 631 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 3x3 | 5985931 | 2111585 | 37.7771963436428 | -122.492226661995 | (37.7771963436428, -122.492226661995) | 11 | 6 | 2 | 55 | 26 | |||
19544 | 261022 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 393 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 3x3 | 5986499 | 2113341 | 37.7820510072297 | -122.490391009154 | (37.7820510072297, -122.490391009154) | 11 | 6 | 2 | 55 | 26 | |||
21767 | 109635 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2X GENEVA AVE | 4 | Median : Cutout | Tree | DPW 1 | 3x3 | 5997165.4 | 2091482.5 | 37.7226502134341 | -122.451912865332 | (37.7226502134341, -122.451912865332) | 9 | 8 | 6 | 28861 | 24 | ||||
25125 | 109198 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 2401x CASTRO ST | 2 | Median : Yard | Tree | DPW 1 | 6002698 | 2098487 | 37.7421983129634 | -122.433288166914 | (37.7421983129634, -122.433288166914) | 2 | 7 | 5 | 63 | 7 | |||||
25439 | 98708 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 105X Ord St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6000883.6 | 2105740.8 | 37.7620124016568 | -122.440081810476 | (37.7620124016568, -122.440081810476) | 15 | 5 | 5 | 28862 | 3 | |||||
26355 | 256053 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015452 | 2116243 | 37.7916677028969 | -122.390428783846 | (37.7916677028969, -122.390428783846) | 6 | 2 | 9 | 28855 | 6 | ||||
27591 | 113681 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X THE EMBARCADERO | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013440 | 2119057 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | 3 | 1 | 10 | 28860 | 6 | ||||
28184 | 109638 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1X Geneva Ave | 2 | Median : Cutout | Tree | DPW 1 | 3x3 | 6001799 | 2091822 | 37.723846713797 | -122.435919833731 | (37.723846713797, -122.435919833731) | 9 | 7 | 6 | 28861 | 25 | ||||
30323 | 122488 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 69x Bonview St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | ||||
30889 | 254841 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 71 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | 5993910 | 2115089 | 37.7872805943627 | -122.464879512834 | (37.7872805943627, -122.464879512834) | 11 | 6 | 1 | 54 | 11 | |
31232 | 111969 | Undocumented 4 | Populus spp :: Poplar Spp 262 | 1x STORRIE ST | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000722 | 2105303 | 37.7608011093363 | -122.440609317727 | (37.7608011093363, -122.440609317727) | 15 | 4 | 5 | 28862 | 3 | ||||
32665 | 104357 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 14 VALENCIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6005933 | 2109228 | 37.7718735901627 | -122.42286572041 | (37.7718735901627, -122.42286572041) | 8 | 2 | 9 | 28853 | 19 | |||
34104 | 113688 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X THE EMBARCADERO | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013440 | 2119057 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | 3 | 1 | 10 | 28860 | 6 | ||||
34378 | 109203 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 2401x CASTRO ST | 9 | Median : Yard | Tree | DPW 1 | 6002698 | 2098487 | 37.7421983129634 | -122.433288166914 | (37.7421983129634, -122.433288166914) | 2 | 7 | 5 | 63 | 7 | |||||
34560 | 255265 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1599x Market St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006908 | 2110080 | 37.7742679442705 | -122.419553577666 | (37.7742679442705, -122.419553577666) | 8 | 2 | 9 | 28853 | 19 | ||||
36097 | 115453 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 300 Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
37182 | 109162 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 1 | Median : Cutout | Tree | DPW 1 | 6 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | |||
37461 | 73302 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 900x Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/24/1999 12:00:00 AM | 5x5 | 6001563 | 2111524 | 37.7779302874148 | -122.438146331007 | (37.7779302874148, -122.438146331007) | 15 | 5 | 11 | 29490 | 41 | |||
38688 | 113686 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X THE EMBARCADERO | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013440 | 2119057 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | 3 | 1 | 10 | 28860 | 6 | ||||
42029 | 254843 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1814 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 5993025 | 2112122 | 37.7790829564028 | -122.467725532477 | (37.7790829564028, -122.467725532477) | 11 | 6 | 2 | 54 | 11 | |||
42181 | 103514 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 1205 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/16/2015 02:38:00 PM | 3 | 5x9 | 415-564-3245 marykittner@att.net | 5994830.1 | 2107339.6 | 37.7660558096286 | -122.461134258867 | (37.7660558096286, -122.461134258867) | 15 | 5 | 11 | 56 | 12 | |
44865 | 256049 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015452 | 2116243 | 37.7916677028969 | -122.390428783846 | (37.7916677028969, -122.390428783846) | 6 | 2 | 9 | 28855 | 6 | ||||
45998 | 112547 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 462 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011324 | 2118723 | 37.798247331278 | -122.404886391926 | (37.798247331278, -122.404886391926) | 3 | 1 | 10 | 308 | 23 | ||||
47204 | 108591 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 400x 06TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6011386 | 2111037 | 37.7771468605476 | -122.404130641378 | (37.7771468605476, -122.404130641378) | 14 | 2 | 9 | 28853 | 34 | |||
47310 | 255326 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 1003x Turk St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6005211 | 2112640 | 37.7812013451486 | -122.425606050794 | (37.7812013451486, -122.425606050794) | 7 | 9 | 11 | 28852 | 41 | ||||
48053 | 111053 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2059X MARKET ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6004434 | 2107851 | 37.7680079876693 | -122.427952728751 | (37.7680079876693, -122.427952728751) | 8 | 4 | 5 | 28862 | 3 | ||||
48117 | 254837 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 130 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 5992465 | 2114587 | 37.7858188208387 | -122.469842298582 | (37.7858188208387, -122.469842298582) | 11 | 6 | 2 | 54 | 11 | |||
50067 | 109632 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X GENEVA AVE | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 5997165.4 | 2091482.5 | 37.7226502134341 | -122.451912865332 | (37.7226502134341, -122.451912865332) | 9 | 8 | 6 | 28861 | 24 | ||||
50541 | 122733 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 3203 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6008384 | 2100540 | 37.7481563241105 | -122.41377286403 | (37.7481563241105, -122.41377286403) | 2 | 4 | 7 | 28859 | 2 | ||||
53785 | 255261 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1599x Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006908 | 2110080 | 37.7742679442705 | -122.419553577666 | (37.7742679442705, -122.419553577666) | 8 | 2 | 9 | 28853 | 19 | ||||
54207 | 109202 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 2401x CASTRO ST | 6 | Median : Yard | Tree | DPW 1 | 6002698 | 2098487 | 37.7421983129634 | -122.433288166914 | (37.7421983129634, -122.433288166914) | 2 | 7 | 5 | 63 | 7 | |||||
55368 | 109658 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 29 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
55889 | 109250 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 200x BAKER ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000999 | 2109836 | 37.773263372988 | -122.439976336261 | (37.773263372988, -122.439976336261) | 15 | 5 | 11 | 29492 | 10 | ||||
56525 | 122494 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 69x Bonview St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | ||||
59753 | 104427 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1000x GILMAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4x4 | 6015570 | 2089525 | 37.71831228448 | -122.3881550967 | (37.71831228448, -122.3881550967) | 10 | 3 | 8 | 58 | 1 | |||
59848 | 112528 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 459 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011361 | 2118561 | 37.797804586609 | -122.404746949234 | (37.797804586609, -122.404746949234) | 3 | 1 | 10 | 308 | 23 | ||||
60634 | 113685 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X THE EMBARCADERO | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013440 | 2119057 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | 3 | 1 | 10 | 28860 | 6 | ||||
62237 | 122492 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 69x Bonview St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | ||||
63160 | 109199 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 2401x CASTRO ST | 7 | Median : Yard | Tree | DPW 1 | 6002698 | 2098487 | 37.7421983129634 | -122.433288166914 | (37.7421983129634, -122.433288166914) | 2 | 7 | 5 | 63 | 7 | |||||
63499 | 122489 | Undocumented 4 | Cotoneaster SPP :: Cotoneaster 96 | 69x Bonview St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );