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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40 | 40 | 222540 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Newburg St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002573.08856 | 2099992.67614 | 37.74632546084511 | -122.433827665916 | (37.7463254608451, -122.433827665916) | |||
| 65 | 65 | 226926 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Newburg St | 3 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 15 | Width 4ft | 6002574.76935 | 2099983.89995 | 37.7463014588644 | -122.433821226777 | (37.7463014588644, -122.433821226777) | |||
| 107 | 107 | 142075 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1384X GROVE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001166.7226 | 2110758.8221 | 37.775806756879895 | -122.439462326391 | (37.7758067568799, -122.439462326391) | |||
| 108 | 108 | 192593 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1399X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008031.0 | 2110483.0 | 37.775437677991796 | -122.41569744526699 | (37.7754376779918, -122.415697445267) | |||
| 161 | 161 | 142720 | Undocumented 2 | :: 54 | 1170 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6007999.4825 | 2121188.7351 | 37.8048312311886 | -122.416565007078 | (37.8048312311886, -122.416565007078) | ||||
| 257 | 257 | 251260 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1163 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6007684.87734 | 2102881.8281400003 | 37.754547168222295 | -122.41635626045701 | (37.7545471682223, -122.416356260457) | ||||
| 260 | 260 | 221893 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3164 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008601.79804 | 2101572.78068 | 37.751004337584796 | -122.41309273944599 | (37.7510043375848, -122.413092739446) | |||
| 262 | 262 | 141360 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1499X Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000919.0 | 2110350.0 | 37.77467013322371 | -122.44028993459101 | (37.7746701332237, -122.440289934591) | |||
| 276 | 276 | 173808 | Undocumented 2 | Tree(s) :: 17 | 1201 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779410 | 6015204.0 | 2109228.0 | 37.772392338117704 | -122.390796408976 | (37.7723923381177, -122.390796408976) | |
| 280 | 280 | 194427 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 905 Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008110.0 | 2110227.0 | 37.774739203286295 | -122.415406037323 | (37.7747392032863, -122.415406037323) | |||
| 327 | 327 | 191528 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2017 12:00:00 AM | 3 | Width 5ft | 6016052.47786 | 2107208.19392 | 37.76689343092 | -122.38772046693501 | (37.76689343092, -122.387720466935) | ||
| 452 | 452 | 221749 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 275 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 24 | Width 4ft | 5997432.91763 | 2106413.5715 | 37.763662611962 | -122.452064861225 | (37.763662611962, -122.452064861225) | |||
| 472 | 472 | 236059 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 601X 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004719.95486 | 2107769.51353 | 37.7678004187701 | -122.42695783742799 | (37.7678004187701, -122.426957837428) | |||
| 478 | 478 | 142161 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 490X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000657.0 | 2110488.0 | 37.7750341257837 | -122.44120614609 | (37.7750341257837, -122.44120614609) | |||
| 486 | 486 | 98534 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1805X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 779899 | 5999986.755609999 | 2115164.0145 | 37.787835056676705 | -122.443860686142 | (37.7878350566767, -122.443860686142) | ||
| 541 | 541 | 251317 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 557 | 557 | 194124 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 3 | Sidewalk: Curb side : Hanging Pot 15 | Tree 1 | Private 1 | 9 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 558 | 558 | 251320 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 35 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6004965.06472 | 2096463.48809 | 37.7367705580153 | -122.425305393447 | (37.7367705580153, -122.425305393447) | ||||
| 593 | 593 | 140072 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 601X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005402.0 | 2111410.0 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | |||
| 648 | 648 | 244249 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 200 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2017 03:00:00 PM | 3 | Width 0ft | 6005669.2453 | 2110057.8231 | 37.774137198555 | -122.423837083382 | (37.774137198555, -122.423837083382) | ||
| 660 | 660 | 244391 | Undocumented 2 | Shrub :: Shrub 98 | 250 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2017 01:16:00 PM | 3 | Width 0ft | 6005650.1507 | 2110201.4148 | 37.774530388668 | -122.42391334778499 | (37.774530388668, -122.423913347785) | ||
| 720 | 720 | 104746 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 700X 20th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779658 | 5989767.16587 | 2110527.4876599996 | 37.774516219561704 | -122.478878924469 | (37.7745162195617, -122.478878924469) | |
| 795 | 795 | 140241 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 160 Ashbury St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998775.6798 | 2110202.3294 | 37.7741424035345 | -122.44769344620701 | (37.7741424035345, -122.447693446207) | |||
| 855 | 855 | 251398 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 299 Townsend St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 882 | 882 | 187661 | Undocumented 2 | Tree(s) :: 17 | 1155 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779411 | 6015039.0 | 2109715.0 | 37.77372037595529 | -122.391401215397 | (37.7737203759553, -122.391401215397) | |
| 891 | 891 | 251304 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | Health Dept 5 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | |||
| 908 | 908 | 206337 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 240 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 5993194.556580001 | 2103260.73418 | 37.7547620531274 | -122.466494737945 | (37.7547620531274, -122.466494737945) | |||
| 913 | 913 | 107355 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2001 Grant Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6010310.1611 | 2121354.7321 | 37.8054166971664 | -122.40858034027201 | (37.8054166971664, -122.408580340272) | |||
| 915 | 915 | 140945 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 971 | 971 | 251415 | Undocumented 2 | Potential Site :: Potential Site 29 | 10x Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2005 12:00:00 AM | 3x3 | 6009207.0 | 2112641.0 | 37.7814290728676 | -122.411781887248 | (37.7814290728676, -122.411781887248) | |||
| 979 | 979 | 200925 | Undocumented 2 | Tristania conferta :: 79 | 4100 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | Width 0ft | 6015478.3928 | 2097437.2349 | 37.7400326248174 | -122.389023874228 | (37.7400326248174, -122.389023874228) | ||
| 998 | 998 | 106624 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 156 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x6 | Permit Number 778450 | 5996579.9247 | 2113340.3647 | 37.78263288517989 | -122.455515759177 | (37.7826328851799, -122.455515759177) | ||
| 1104 | 1104 | 218512 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2700x San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997075.0 | 2088509.0 | 37.7144804976148 | -122.452010931306 | (37.7144804976148, -122.452010931306) | |||
| 1157 | 1157 | 251464 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3440 16th St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6003947.0 | 2106622.0 | 37.7646058870383 | -122.429549548663 | (37.7646058870383, -122.429549548663) | ||||
| 1262 | 1262 | 251479 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1214 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 779194 | 5987090.84961 | 2106996.2792700003 | 37.7646647351899 | -122.48787719677 | (37.7646647351899, -122.48787719677) | ||||
| 1265 | 1265 | 108488 | Undocumented 2 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 139 | 1 Rausch St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2017 12:00:00 AM | 3 | 4x4 | Permit Number 779048 | 6009599.94268 | 2111020.96873 | 37.777002885413104 | -122.410308071481 | (37.7770028854131, -122.410308071481) | |
| 1360 | 1360 | 125405 | Undocumented 2 | Tree(s) :: 17 | 2500X Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779167 | 6001716.65019 | 2117116.43684 | 37.7932944253528 | -122.438015491236 | (37.7932944253528, -122.438015491236) | |
| 1368 | 1368 | 141257 | Undocumented 2 | Rhaphiolepis indica :: India Hawthorn 144 | 51 COMMONWEALTH AVE | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5996492.2734 | 2114210.7856 | 37.7850177994523 | -122.455881936455 | (37.7850177994523, -122.455881936455) | |||
| 1487 | 1487 | 233540 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 660 Clipper St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779879 | 6001114.06108 | 2100904.6606 | 37.748746650735505 | -122.438938144387 | (37.7487466507355, -122.438938144387) | |
| 1502 | 1502 | 223929 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 610 Clipper St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779880 | 6001216.05485 | 2100901.84413 | 37.748744719898 | -122.43858524950599 | (37.748744719898, -122.438585249506) | |
| 1549 | 1549 | 142039 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1499X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6000824.0 | 2111032.0 | 37.7765373235881 | -122.44066748676701 | (37.7765373235881, -122.440667486767) | |||
| 1553 | 1553 | 207056 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 340 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991811.94775 | 2097766.11202 | 37.7395953573424 | -122.470875903123 | (37.7395953573424, -122.470875903123) | |||
| 1557 | 1557 | 251590 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 340x Vicente St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5991910.0 | 2097743.0 | 37.739537567792894 | -122.47053520105601 | (37.7395375677929, -122.470535201056) | ||||
| 1580 | 1580 | 239668 | Undocumented 2 | Butia capitata :: Pindo Palm 149 | 180 Dolores St | 3 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 23 | Width 4ft | 6004776.3298 | 2107329.36682 | 37.766595069134105 | -122.426731495165 | (37.7665950691341, -122.426731495165) | |||
| 1592 | 1592 | 251595 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005038.0 | 2104916.0 | 37.7599833282319 | -122.42565463806999 | (37.7599833282319, -122.42565463807) | ||||
| 1600 | 1600 | 251625 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 76R Amber Dr | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999293.0 | 2100015.0 | 37.746200078593205 | -122.44517138727 | (37.7462000785932, -122.44517138727) | |||||
| 1605 | 1605 | 251634 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 14R Amethyst Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999202.0 | 2100044.0 | 37.746274510978395 | -122.445488137723 | (37.7462745109784, -122.445488137723) | |||||
| 1613 | 1613 | 251616 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 64R Amber Dr | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999367.0 | 2100045.0 | 37.746286674920704 | -122.44491766156601 | (37.7462866749207, -122.444917661566) | |||||
| 1638 | 1638 | 251620 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 72R Amber Dr | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999318.0 | 2100030.0 | 37.746242691915 | -122.445086018875 | (37.746242691915, -122.445086018875) | |||||
| 1661 | 1661 | 245154 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000359.4788 | 2109307.5305 | 37.771775902629706 | -122.44215057779499 | (37.7717759026297, -122.442150577795) | |||
| 1670 | 1670 | 251646 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011949.0 | 2112390.0 | 37.7808933270361 | -122.40227818697599 | (37.7808933270361, -122.402278186976) | ||||
| 1673 | 1673 | 223647 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 3270 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007640.90679 | 2105619.03236 | 37.7620604292697 | -122.416702221525 | (37.7620604292697, -122.416702221525) | |||
| 1694 | 1694 | 251475 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 151 32nd Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779951 | 5985659.0 | 2114437.0 | 37.78501121016021 | -122.493377758762 | (37.7850112101602, -122.493377758762) | |
| 1726 | 1726 | 139069 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2211 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001584.0 | 2113871.0 | 37.784375747905706 | -122.43824186327299 | (37.7843757479057, -122.438241863273) | |||
| 1727 | 1727 | 251675 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2201 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001586.0 | 2113871.0 | 37.784375861655995 | -122.438234943981 | (37.784375861656, -122.438234943981) | ||||
| 1803 | 1803 | 200050 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1590 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6014991.2562 | 2094154.9788 | 37.730993203361 | -122.39047892232401 | (37.730993203361, -122.390478922324) | |||
| 1857 | 1857 | 251765 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Seville St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6001915.0 | 2087651.0 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | ||||
| 1868 | 1868 | 231236 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009517.72345 | 2105367.35909 | 37.7614747718611 | -122.41019324152599 | (37.7614747718611, -122.410193241526) | |||
| 1874 | 1874 | 251773 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 90x Seville St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002045.0 | 2087474.0 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | ||||
| 1905 | 1905 | 251810 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 3 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
| 1908 | 1908 | 127945 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2017 12:00:00 AM | 3 | Width 2ft | 6012656.99006 | 2119182.6904 | 37.7995839500992 | -122.40030612282601 | (37.7995839500992, -122.400306122826) | ||
| 2002 | 2002 | 190904 | Undocumented 2 | Corymbia maculata :: Spotted Gum 165 | 5 George Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6017188.0 | 2093995.0 | 37.7306755515034 | -122.382873204359 | (37.7306755515034, -122.382873204359) | |||
| 2030 | 2030 | 138247 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1599 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001634.7269 | 2113859.0317 | 37.7843457709869 | -122.43806550855301 | (37.7843457709869, -122.438065508553) | |||
| 2045 | 2045 | 124757 | Undocumented 2 | Tree(s) :: 17 | 2040 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779873 | 6003680.83051 | 2117635.7933099996 | 37.7948319494745 | -122.431256385468 | (37.7948319494745, -122.431256385468) | |
| 2046 | 2046 | 131756 | Undocumented 2 | Tree(s) :: 17 | 1818 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6004733.3748 | 2117781.6991 | 37.795292161346104 | -122.427624834041 | (37.7952921613461, -122.427624834041) | |||
| 2096 | 2096 | 200850 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6007584.0 | 2110630.0 | 37.77581616716321 | -122.417254147161 | (37.7758161671632, -122.417254147161) | |||
| 2102 | 2102 | 196505 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3536 Jennings St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 6013064.418880001 | 2089502.0027700001 | 37.7181099951501 | -122.39681428375299 | (37.7181099951501, -122.396814283753) | |||
| 2122 | 2122 | 252898 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 501x Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997879.0 | 2089997.0 | 37.7186122227881 | -122.44933914222901 | (37.7186122227881, -122.449339142229) | ||||
| 2123 | 2123 | 128055 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 449 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780354 | 6008758.87824 | 2121765.85838 | 37.8064585449799 | -122.413977880988 | (37.8064585449799, -122.413977880988) | |
| 2155 | 2155 | 235936 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | Width 3ft | 6010180.29259 | 2103880.6842099996 | 37.7574298137383 | -122.40779684417 | (37.7574298137383, -122.40779684417) | ||
| 2159 | 2159 | 251203 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780227 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | |
| 2211 | 2211 | 188595 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Rhode Island St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/05/2017 12:00:00 AM | 3 | Width 7ft | 6011997.611930001 | 2102271.8897 | 37.7531139870419 | -122.401398733477 | (37.7531139870419, -122.401398733477) | ||
| 2302 | 2302 | 97526 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 532 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Permit Number 778941 | 6013958.0435 | 2114445.5251 | 37.7866492675441 | -122.395471917224 | (37.7866492675441, -122.395471917224) | ||
| 2309 | 2309 | 122433 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 778941 | 6013698.925 | 2114193.6044 | 37.785943135879 | -122.396350747311 | (37.785943135879, -122.396350747311) | ||
| 2311 | 2311 | 193166 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 282 02nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | Permit Number 778941 | 6013536.23807 | 2114063.46383 | 37.7855767457266 | -122.396904475854 | (37.7855767457266, -122.396904475854) | ||
| 2323 | 2323 | 201173 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 599X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | Permit Number 778941 | 6013705.0945 | 2114111.3445 | 37.7857176125048 | -122.39632363473801 | (37.7857176125048, -122.396323634738) | ||
| 2336 | 2336 | 195020 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6013662.142659999 | 2113947.50545 | 37.785265358143896 | -122.39646074858601 | (37.7852653581439, -122.396460748586) | |||
| 2339 | 2339 | 253036 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | ||||
| 2394 | 2394 | 125087 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2498X Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | Permit Number 779691 | 6001734.0 | 2116823.0 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | ||
| 2417 | 2417 | 201819 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021071.50009 | 2093300.7706900002 | 37.7289831323462 | -122.369399226393 | (37.7289831323462, -122.369399226393) | ||
| 2463 | 2463 | 106683 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 125 Maple St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6x300 | 5996555.44655 | 2115800.39633 | 37.789386070660704 | -122.45577832652201 | (37.7893860706607, -122.455778326522) | |||
| 2505 | 2505 | 127968 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 73 Castle St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 1ft | 6011251.91529 | 2119582.84216 | 37.8006042192626 | -122.405196407682 | (37.8006042192626, -122.405196407682) | |||
| 2512 | 2512 | 178827 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 927 Brazil Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004338.08735 | 2090755.04432 | 37.7210610008535 | -122.427066663506 | (37.7210610008535, -122.427066663506) | |||
| 2535 | 2535 | 246841 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 3 | : 4 | Tree 1 | DPW for City Agency 10 | 14 | Width 3ft | 6001195.01805 | 2109899.62825 | 37.7734492368388 | -122.439302846449 | (37.7734492368388, -122.439302846449) | |||
| 2605 | 2605 | 253138 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 40 Brady St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | ||||
| 2622 | 2622 | 238126 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3388 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2017 02:38:00 PM | 3 | Width 3ft | 6006363.87344 | 2106134.73006 | 37.7634045065344 | -122.421155613935 | (37.7634045065344, -122.421155613935) | ||
| 2625 | 2625 | 248771 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 8ft | 5999742.36883 | 2101773.9828 | 37.751055459558394 | -122.4437438777 | (37.7510554595584, -122.4437438777) | |||
| 2684 | 2684 | 233816 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 41 Brady St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006595.43726 | 2109656.08938 | 37.7730863765667 | -122.420604692871 | (37.7730863765667, -122.420604692871) | |||
| 2692 | 2692 | 100830 | Undocumented 2 | Ficus rubiginosa :: Port Jackson Fig 188 | 1601X North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003038.84698 | 2120959.7606900004 | 37.8039222967503 | -122.433715418836 | (37.8039222967503, -122.433715418836) | |||
| 2747 | 2747 | 177162 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 221 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | Permit Number 780274 | 6007512.10716 | 2087312.1903 | 37.711786621718296 | -122.415851310014 | (37.7117866217183, -122.415851310014) | ||
| 2783 | 2783 | 252852 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 100X Langton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6010166.0 | 2110701.0 | 37.776156040570996 | -122.408327321329 | (37.776156040571, -122.408327321329) | ||||
| 2812 | 2812 | 206249 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 450 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994303.087119999 | 2106698.53981 | 37.7642652836473 | -122.46291056368601 | (37.7642652836473, -122.462910563686) | |||
| 2817 | 2817 | 253222 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 148 Felton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6010428.10303 | 2093767.62468 | 37.729675416078294 | -122.406227307752 | (37.7296754160783, -122.406227307752) | ||||
| 2824 | 2824 | 124729 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 198X Division St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010680.0 | 2108566.0 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | ||||
| 2837 | 2837 | 241584 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 38X Java St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5999751.0 | 2107467.0 | 37.7666875731096 | -122.444123063419 | (37.7666875731096, -122.444123063419) | |||
| 2855 | 2855 | 110902 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2300x Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6005485.732559999 | 2117962.0378900003 | 37.795829853409295 | -122.425034389936 | (37.7958298534093, -122.425034389936) | |||
| 2856 | 2856 | 253264 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2425 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991946.0 | 2094328.0 | 37.730162918760904 | -122.470162120918 | (37.7301629187609, -122.470162120918) | ||||
| 2864 | 2864 | 209183 | Undocumented 2 | Tree(s) :: 17 | 140 Kensington Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780524 | 5994862.40668 | 2098482.07156 | 37.741737150351 | -122.460380669142 | (37.741737150351, -122.460380669142) | |
| 2866 | 2866 | 253244 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 299X Moncada Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | ||||
| 2901 | 2901 | 253237 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Paloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) |
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");