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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 151491 | 151491 | 176168 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 30 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 8ft | 6008416.5566300005 | 2086198.9199700002 | 37.7087806162127 | -122.412646622645 | (37.7087806162127, -122.412646622645) | |||
| 68299 | 68299 | 176169 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 30 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 8ft | 6008410.17529 | 2086203.98853 | 37.7087941752841 | -122.41266903556999 | (37.7087941752841, -122.41266903557) | |||
| 165253 | 165253 | 73605 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 129 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994880.25496 | 2086485.81008 | 37.7087993338054 | -122.459450360941 | (37.7087993338054, -122.459450360941) | ||
| 66352 | 66352 | 176873 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 34 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008389.4363 | 2086207.95793 | 37.7088039104301 | -122.412740993025 | (37.7088039104301, -122.412740993025) | |||
| 151378 | 151378 | 177164 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 30 Kelloch Ave | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6008391.56884 | 2086208.1675200001 | 37.708804605615896 | -122.41273363745701 | (37.7088046056159, -122.412733637457) | |||
| 176962 | 176962 | 175882 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6008037.77895 | 2086218.44055 | 37.708812949517394 | -122.413957113834 | (37.7088129495174, -122.413957113834) | |||
| 179124 | 179124 | 175881 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 4 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6008040.46364 | 2086219.1455 | 37.7088150359462 | -122.413947884982 | (37.7088150359462, -122.413947884982) | |||
| 4180 | 4180 | 180661 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 551 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 01:41:00 PM | 3 | Width 5ft | 6002181.0 | 2086340.0 | 37.7088160489029 | -122.434207604104 | (37.7088160489029, -122.434207604104) | ||
| 162521 | 162521 | 178554 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 575 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007838.70528 | 2086225.04271 | 37.7088198950039 | -122.414645608726 | (37.7088198950039, -122.414645608726) | |||
| 116815 | 116815 | 102841 | Undocumented 2 | Tree(s) :: 17 | 5 Canyon Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2013 12:00:00 AM | Permit Number 770737 | 6003515.0 | 2086316.0 | 37.7088257745465 | -122.429595407579 | (37.7088257745465, -122.429595407579) | |||
| 171717 | 171717 | 176170 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 42 Kelloch Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6008360.10661 | 2086217.92738 | 37.7088296382394 | -122.41284306515499 | (37.7088296382394, -122.412843065155) | |||
| 55394 | 55394 | 175880 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6008040.572369999 | 2086224.4613400002 | 37.7088296382554 | -122.413947884988 | (37.7088296382554, -122.413947884988) | |||
| 184578 | 184578 | 71588 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 133 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 8 | 5994866.39831 | 2086497.9329400002 | 37.7088318236054 | -122.45949912847999 | (37.7088318236054, -122.45949912848) | ||
| 52100 | 52100 | 178508 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 575 Argonaut Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007843.72677 | 2086231.7813400002 | 37.708838680016704 | -122.414628730257 | (37.7088386800167, -122.414628730257) | |||
| 154303 | 154303 | 175879 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6008041.81725 | 2086229.374 | 37.708843197325 | -122.41394392978701 | (37.708843197325, -122.413943929787) | |||
| 131950 | 131950 | 71605 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 178 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994512.31694 | 2086511.3564 | 37.7088483153534 | -122.46072384594 | (37.7088483153534, -122.46072384594) | ||
| 188869 | 188869 | 178549 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 42 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008341.68171 | 2086226.9900599997 | 37.7088534882771 | -122.412907384688 | (37.7088534882771, -122.412907384688) | |||
| 156719 | 156719 | 178517 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 328 Schwerin St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 4ft | 6008541.04755 | 2086224.10569 | 37.708856757315395 | -122.41221814244801 | (37.7088567573154, -122.412218142448) | |||
| 43076 | 43076 | 177793 | Undocumented 2 | Morus alba :: White Mulberry 112 | 163 Sears St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | Width 4ft | 5996220.07429 | 2086479.7824400002 | 37.7088597295732 | -122.45481935425501 | (37.7088597295732, -122.454819354255) | |||
| 119122 | 119122 | 178548 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 328 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008543.60628 | 2086225.1928599998 | 37.7088598860379 | -122.412209375875 | (37.7088598860379, -122.412209375875) | |||
| 57129 | 57129 | 175878 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6008044.64173 | 2086236.91355 | 37.7088640580086 | -122.413934700952 | (37.7088640580086, -122.413934700952) | |||
| 120051 | 120051 | 175838 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994346.0156 | 2086520.6232200002 | 37.708864190212296 | -122.461299273568 | (37.7088641902123, -122.461299273568) | |||
| 60233 | 60233 | 176171 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 46 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 6ft | 6008338.63627 | 2086231.2816700002 | 37.708865101208204 | -122.412918213412 | (37.7088651012082, -122.412918213412) | |||
| 145728 | 145728 | 178555 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 580 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6007810.831590001 | 2086243.5160299998 | 37.708869052843 | -122.414743250798 | (37.708869052843, -122.414743250798) | |||
| 30302 | 30302 | 175150 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 141 Goethe St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5994849.69598 | 2086516.03158 | 37.708880557851 | -122.45955816357299 | (37.708880557851, -122.459558163573) | |||
| 50693 | 50693 | 176103 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 50 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 6008313.99103 | 2086238.6229700001 | 37.7088838754685 | -122.413003909814 | (37.7088838754685, -122.413003909814) | |||
| 156268 | 156268 | 177815 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 520 Carter St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6005230.32972 | 2086303.80615 | 37.708889269593705 | -122.42366611910299 | (37.7088892695937, -122.423666119103) | ||||
| 174882 | 174882 | 71606 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 182 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 13 | 5994495.515430001 | 2086527.6412 | 37.708892062899 | -122.460783093263 | (37.708892062899, -122.460783093263) | ||
| 149597 | 149597 | 175837 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994356.88277 | 2086531.76861 | 37.7088954182656 | -122.461262522762 | (37.7088954182656, -122.461262522762) | |||
| 60266 | 60266 | 177814 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 520 Carter St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6005234.109619999 | 2086313.99971 | 37.70891747232 | -122.423653779491 | (37.70891747232, -122.423653779491) | ||||
| 3065 | 3065 | 175836 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Rhine St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994366.585519999 | 2086543.72285 | 37.70892880020671 | -122.46122985488998 | (37.7089288002067, -122.46122985489) | |||
| 147503 | 147503 | 178547 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 322 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008553.87122 | 2086250.69527 | 37.7089304864164 | -122.412175699859 | (37.7089304864164, -122.412175699859) | |||
| 76451 | 76451 | 178516 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 322 Schwerin St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6008552.66413 | 2086251.2184400002 | 37.70893185520271 | -122.41217990870001 | (37.7089318552027, -122.4121799087) | |||
| 152396 | 152396 | 177857 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 435 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010447.87727 | 2086216.0665099998 | 37.7089414959281 | -122.40562727470501 | (37.7089414959281, -122.405627274705) | |||
| 32945 | 32945 | 178518 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 62 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 6008249.62715 | 2086262.35093 | 37.708945414261606 | -122.41322803793899 | (37.7089454142616, -122.413228037939) | |||
| 70516 | 70516 | 178550 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 62 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008247.372380001 | 2086262.5391799998 | 37.7089458045697 | -122.413235844076 | (37.7089458045697, -122.413235844076) | |||
| 892 | 892 | 251400 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5994375.43496 | 2086552.5575599999 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | ||||
| 171265 | 171265 | 175835 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994375.43496 | 2086552.5575599999 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | |||
| 57617 | 57617 | 177094 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993369.32747 | 2086575.0773 | 37.708957449004394 | -122.464678768412 | (37.7089574490044, -122.464678768412) | |||
| 168435 | 168435 | 176111 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 64 | 6005239.18473 | 2086329.3019599998 | 37.7089597755375 | -122.423637326411 | (37.7089597755375, -122.423637326411) | ||||
| 61136 | 61136 | 71581 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 237 Flournoy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994022.886390001 | 2086563.0023 | 37.70896195100121 | -122.46241911655301 | (37.7089619510012, -122.462419116553) | ||
| 111059 | 111059 | 108382 | Undocumented 2 | Tree(s) :: 17 | 30 CASTILLO ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6x12 | 6006869.1 | 2086298.1 | 37.7089659714277 | -122.418001881162 | (37.7089659714277, -122.418001881162) | ||||
| 131503 | 131503 | 177093 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 5993374.13741 | 2086578.2467 | 37.7089664287264 | -122.464662374692 | (37.7089664287264, -122.464662374692) | |||
| 62440 | 62440 | 178519 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 74 Kelloch Ave | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6008207.90106 | 2086273.84024 | 37.7089746188665 | -122.413373061735 | (37.7089746188665, -122.413373061735) | |||
| 64171 | 64171 | 180218 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 241 Flournoy St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5994016.46026 | 2086567.8312400002 | 37.70897484008071 | -122.462441676038 | (37.7089748400807, -122.462441676038) | |||
| 41117 | 41117 | 71607 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 190 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 11 | 5994457.91424 | 2086560.2946 | 37.708979557936104 | -122.46091541234199 | (37.7089795579361, -122.460915412342) | ||
| 166145 | 166145 | 178551 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 74 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008208.8909599995 | 2086276.4009099999 | 37.70898170551929 | -122.413369821453 | (37.7089817055193, -122.413369821453) | |||
| 70441 | 70441 | 177856 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 435 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010405.93473 | 2086233.7709700002 | 37.7089877633386 | -122.405773481086 | (37.7089877633386, -122.405773481086) | |||
| 184172 | 184172 | 178271 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 35 Tomaso Ct | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 3ft | 6009176.170940001 | 2086260.2904299998 | 37.7089917311415 | -122.41002561149901 | (37.7089917311415, -122.410025611499) | |||
| 55176 | 55176 | 178556 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 550 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6007824.59893 | 2086288.7583 | 37.708994052312 | -122.414698868372 | (37.708994052312, -122.414698868372) | |||
| 183428 | 183428 | 177855 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 435 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010393.78556 | 2086237.29466 | 37.7089967592527 | -122.40581571863301 | (37.7089967592527, -122.405815718633) | |||
| 176645 | 176645 | 178270 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 35 Tomaso Ct | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 3ft | 6009167.93697 | 2086263.08528 | 37.7089989437285 | -122.41005426658701 | (37.7089989437285, -122.410054266587) | |||
| 30008 | 30008 | 178244 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 62 Tomaso Ct | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | Width 8ft | 6009170.0421 | 2086265.24197 | 37.7090049835504 | -122.410047143074 | (37.7090049835504, -122.410047143074) | |||
| 168635 | 168635 | 177817 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6009184.18934 | 2086265.3806200002 | 37.7090061571804 | -122.409998257729 | (37.7090061571804, -122.409998257729) | |||
| 37802 | 37802 | 178243 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 62 Tomaso Ct | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | Width 8ft | 6009152.06447 | 2086268.0035 | 37.7090115585089 | -122.410109471469 | (37.7090115585089, -122.410109471469) | |||
| 171783 | 171783 | 177092 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5993402.95207 | 2086595.08273 | 37.7090143176374 | -122.464564009531 | (37.7090143176374, -122.464564009531) | |||
| 180452 | 180452 | 177816 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 60 Tomaso Ct | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 3ft | 6009147.33252 | 2086269.1354099999 | 37.7090144012735 | -122.41012590570601 | (37.7090144012735, -122.410125905706) | |||
| 132971 | 132971 | 178242 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 62 Tomaso Ct | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | Width 8ft | 6009144.65272 | 2086270.07017 | 37.709016817728 | -122.41013523347401 | (37.709016817728, -122.410135233474) | |||
| 183568 | 183568 | 176102 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 62 Tomaso Ct | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | Width 8ft | 6009173.04361 | 2086270.9274900001 | 37.709020763061396 | -122.41003717048099 | (37.7090207630614, -122.410037170481) | |||
| 34606 | 34606 | 178520 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 74 Kelloch Ave | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6008160.20585 | 2086291.9091900003 | 37.7090215544595 | -122.413539180899 | (37.7090215544595, -122.413539180899) | |||
| 183973 | 183973 | 176110 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 47 | 6005248.37143 | 2086351.63031 | 37.709021603021604 | -122.423607162245 | (37.7090216030216, -122.423607162245) | ||||
| 70765 | 70765 | 178552 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 80 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008167.33564 | 2086292.8160599999 | 37.7090244448819 | -122.413514603312 | (37.7090244448819, -122.413514603312) | |||
| 171840 | 171840 | 177646 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5870 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 4ft | 5996947.52419 | 2086525.1457 | 37.7090259881292 | -122.45230847045299 | (37.7090259881292, -122.452308470453) | |||
| 48603 | 48603 | 177091 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5993412.52644 | 2086599.2418 | 37.709026289400796 | -122.46453122115801 | (37.7090262894008, -122.464531221158) | |||
| 66895 | 66895 | 176112 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Tomaso Ct | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6009187.4096 | 2086275.4475900002 | 37.7090339795175 | -122.409987838189 | (37.7090339795175, -122.409987838189) | |||
| 110307 | 110307 | 117181 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 8 KNOTT CT | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000120.0 | 2086463.0 | 37.7090365866676 | -122.44133950250601 | (37.7090365866676, -122.441339502506) | ||||
| 144893 | 144893 | 117180 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 8 KNOTT CT | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000120.0 | 2086463.0 | 37.7090365866676 | -122.44133950250601 | (37.7090365866676, -122.441339502506) | |||
| 63565 | 63565 | 178691 | Undocumented 2 | Prunus armeniaca :: Apricot 259 | 549 Cordova St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6002129.66344 | 2086422.5793700002 | 37.709039879958 | -122.43439093020099 | (37.709039879958, -122.434390930201) | |||
| 68489 | 68489 | 176113 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Santa Barbara Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5993424.30452 | 2086604.0814 | 37.709040256765 | -122.464490865868 | (37.709040256765, -122.464490865868) | |||
| 53016 | 53016 | 180001 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 62 Tomaso Ct | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 8ft | 6009181.15123 | 2086279.38185 | 37.709044431429604 | -122.41000974567899 | (37.7090444314296, -122.410009745679) | |||
| 51044 | 51044 | 176285 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1 Santa Barbara Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5993431.64495 | 2086606.10767 | 37.7090462435678 | -122.464465643484 | (37.7090462435678, -122.464465643484) | |||
| 45207 | 45207 | 178692 | Undocumented 2 | Prunus armeniaca :: Apricot 259 | 549 Cordova St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6002131.76754 | 2086425.47642 | 37.7090479540599 | -122.43438386511801 | (37.7090479540599, -122.434383865118) | |||
| 24565 | 24565 | 176109 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6005252.95246 | 2086362.20208 | 37.7090508894465 | -122.42359208063299 | (37.7090508894465, -122.423592080633) | ||||
| 150256 | 150256 | 178521 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 90 Kelloch Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6008137.560430001 | 2086303.76828 | 37.7090528454867 | -122.413618285264 | (37.7090528454867, -122.413618285264) | |||
| 163592 | 163592 | 178693 | Undocumented 2 | Prunus armeniaca :: Apricot 259 | 549 Cordova St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6002128.86761 | 2086428.02428 | 37.7090547853188 | -122.434394069733 | (37.7090547853188, -122.434394069733) | |||
| 164474 | 164474 | 177818 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009189.876619999 | 2086285.53025 | 37.7090618027185 | -122.409980023068 | (37.7090618027185, -122.409980023068) | |||
| 170072 | 170072 | 177090 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 36 Santa Cruz Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 5993074.958319999 | 2086622.9468 | 37.7090719120225 | -122.46569961766001 | (37.7090719120225, -122.46569961766) | |||
| 167412 | 167412 | 178553 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 90 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008120.85709 | 2086313.06742 | 37.7090774410456 | -122.413676671965 | (37.7090774410456, -122.413676671965) | |||
| 172551 | 172551 | 176108 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 6005255.13814 | 2086372.0334299998 | 37.7090780076251 | -122.4235852251 | (37.7090780076251, -122.4235852251) | ||||
| 166675 | 166675 | 178558 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 525 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6007875.12546 | 2086323.01846 | 37.7090909623615 | -122.414526663487 | (37.7090909623615, -122.414526663487) | |||
| 2767 | 2767 | 252950 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) | |||
| 2772 | 2772 | 252949 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) | |||
| 999 | 999 | 251422 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 480x De Long St | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5992963.0 | 2086633.0 | 37.709093057147996 | -122.466087289133 | (37.709093057148, -122.466087289133) | |||||
| 182795 | 182795 | 177819 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009193.28856 | 2086304.97531 | 37.709115386123 | -122.40996960262501 | (37.709115386123, -122.409969602625) | |||
| 4209 | 4209 | 180663 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 355 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 01:48:00 PM | 3 | Width 6ft | 6002383.84355 | 2086445.14687 | 37.709116270155604 | -122.43351405884898 | (37.7091162701556, -122.433514058849) | ||
| 148750 | 148750 | 177906 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 345 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008626.38347 | 2086318.08135 | 37.709119583283204 | -122.411929844982 | (37.7091195832832, -122.411929844982) | |||
| 160633 | 160633 | 176276 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 62 Tomaso Ct | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 8ft | 6009192.32266 | 2086308.3659400002 | 37.7091246419674 | -122.40997318013201 | (37.7091246419674, -122.409973180132) | |||
| 173412 | 173412 | 178557 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 520 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6007843.02927 | 2086335.9512200002 | 37.709124669828796 | -122.41463850766199 | (37.7091246698288, -122.414638507662) | |||
| 34590 | 34590 | 178546 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 304 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008580.640819999 | 2086320.97824 | 37.709124971097296 | -122.412088143666 | (37.7091249710973, -122.412088143666) | |||
| 168228 | 168228 | 178515 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 304 Schwerin St | 1 | : 4 | Tree 1 | Private 1 | 22 | Width 5ft | 6008576.98547 | 2086321.37555 | 37.709125856931706 | -122.41210080521601 | (37.7091258569317, -122.412100805216) | |||
| 68231 | 68231 | 177711 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 41 Rhine St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 5994431.51774 | 2086616.4840900002 | 37.7091323221755 | -122.461010711685 | (37.7091323221755, -122.461010711685) | |||
| 180877 | 180877 | 175103 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 56 Tomaso Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009154.75517 | 2086318.89701 | 37.709151452539004 | -122.410103762579 | (37.709151452539, -122.410103762579) | |||
| 173162 | 173162 | 178509 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 515 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007885.078480001 | 2086346.0784099998 | 37.7091548393851 | -122.41449389489901 | (37.7091548393851, -122.414493894899) | |||
| 177259 | 177259 | 175096 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 56 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6009154.581590001 | 2086320.62957 | 37.7091562000666 | -122.410104484734 | (37.7091562000666, -122.410104484734) | |||
| 30355 | 30355 | 180399 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 349 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002410.48398 | 2086459.29818 | 37.7091566380421 | -122.433422996175 | (37.7091566380421, -122.433422996175) | |||
| 4254 | 4254 | 180668 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 01:45:00 PM | 3 | Width 6ft | 6002314.90905 | 2086461.72548 | 37.709157880008 | -122.433753490754 | (37.709157880008, -122.433753490754) | ||
| 172180 | 172180 | 177710 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 41 Rhine St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5994442.40126 | 2086628.41328 | 37.709165703209294 | -122.460973960888 | (37.7091657032093, -122.460973960888) | |||
| 109122 | 109122 | 117509 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 300x HANOVER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999715.0 | 2086521.0 | 37.7091727618039 | -122.442743399736 | (37.7091727618039, -122.442743399736) | ||||
| 130867 | 130867 | 179477 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 245 Wilson St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5994326.32135 | 2086634.18047 | 37.709174858293295 | -122.461375565754 | (37.7091748582933, -122.461375565754) | ||||
| 121253 | 121253 | 177645 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5838 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5997080.8498599995 | 2086578.3954599998 | 37.709179836936705 | -122.45185151865299 | (37.7091798369367, -122.451851518653) |
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");