Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCaretaker, qCareAssistant
qLegalStatus ✖
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12 | 12 | 122660 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 94 | 94 | 201404 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1051 Ingalls St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1990 12:00:00 AM | 14 | Width 3ft | 6018112.6185 | 2094686.77545 | 37.732626074632705 | -122.379724665662 | (37.7326260746327, -122.379724665662) | ||
| 826 | 826 | 175048 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 80X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | 25 | Width 3ft | 5991330.3562 | 2089025.12852 | 37.7155669345385 | -122.47190412410299 | (37.7155669345385, -122.471904124103) | ||
| 1242 | 1242 | 138398 | DPW Maintained 3 | Tristania conferta :: 79 | 2445 PINE ST | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | Width 0ft | 6002388.1124 | 2115043.7135 | 37.787641421844896 | -122.435543840756 | (37.7876414218449, -122.435543840756) | |||
| 2191 | 2191 | 9460 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1998 12:00:00 AM | 6 | 3X3 | 6005350.8775 | 2112393.4845 | 37.7805323769118 | -122.42510459789499 | (37.7805323769118, -122.425104597895) | ||
| 2656 | 2656 | 183240 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2001 37th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984790.3243 | 2100348.3517 | 37.7462769046122 | -122.495343672098 | (37.7462769046122, -122.495343672098) | |
| 3112 | 3112 | 253318 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3322 | 3322 | 44559 | Permitted Site 1 | Tree(s) :: 17 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3421 | 3421 | 13448 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/2016 10:29:00 AM | 3 | 4x4 | 6013957.13139 | 2117096.02637 | 37.793926876278206 | -122.39566084929301 | (37.7939268762782, -122.395660849293) | ||
| 3758 | 3758 | 253548 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 16 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 04:31:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3801 | 3801 | 177109 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 6 | Width 5ft | 5998958.08532 | 2091518.52367 | 37.72285164275971 | -122.445718558684 | (37.7228516427597, -122.445718558684) | |||
| 3935 | 3935 | 160073 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:36:00 AM | 3 | Width 0ft | 6000082.999340001 | 2090399.7386 | 37.7198438772755 | -122.44174972458201 | (37.7198438772755, -122.441749724582) | ||
| 4013 | 4013 | 253610 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1075 Mission St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 6009725.02676 | 2112060.52163 | 37.7798642637711 | -122.40994876804 | (37.7798642637711, -122.40994876804) | ||||
| 4452 | 4452 | 19593 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY4 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
| 4583 | 4583 | 142550 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/26/2016 09:53:00 AM | 22 | Width 0ft | 6009784.6811 | 2121219.3711 | 37.805015586162796 | -122.41038927752199 | (37.8050155861628, -122.410389277522) | ||
| 4938 | 4938 | 203012 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:41:00 AM | 3 | Width 3ft | 6017482.43996 | 2098513.81637 | 37.743099584575795 | -122.382169507733 | (37.7430995845758, -122.382169507733) | ||
| 5000 | 5000 | 83036 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:55:00 PM | 3 | 6018559.56213 | 2097806.04485 | 37.7412156164156 | -122.378395939846 | (37.7412156164156, -122.378395939846) | |||
| 5064 | 5064 | 3711 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 401X Cargo Way | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 10:38:00 AM | 3 | 3X3 | 6016645.526269999 | 2099177.51182 | 37.7448756979524 | -122.38510959115 | (37.7448756979524, -122.38510959115) | ||
| 5471 | 5471 | 98637 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6002243.51572 | 2120296.51697 | 37.8020560434066 | -122.43642021082898 | (37.8020560434066, -122.436420210829) | ||
| 5610 | 5610 | 109560 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006827.8052900005 | 2112008.26753 | 37.7795579852454 | -122.41996785053101 | (37.7795579852454, -122.419967850531) | |||
| 6242 | 6242 | 35188 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 6668 | 6668 | 19738 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY14 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40ST | ||||||||
| 7028 | 7028 | 20295 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | ||||||||
| 7488 | 7488 | 35443 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 8690 | 8690 | 13488 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6013500.87864 | 2116662.8138599996 | 37.7927119866299 | -122.397209147309 | (37.7927119866299, -122.397209147309) | |||
| 9206 | 9206 | 24109 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 105X Whitney Young Cir | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.0813580002 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | ||
| 9343 | 9343 | 3813 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101X Cashmere St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1995 12:00:00 AM | 9 | 3X3 | 6017067.4579304 | 2095837.0108628003 | 37.7357266870687 | -122.383418119044 | (37.7357266870687, -122.383418119044) | ||
| 9448 | 9448 | 3859 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 201X Cashmere St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1996 12:00:00 AM | 8 | 3X3 | 6016272.1162427 | 2096165.2075516998 | 37.73658386065979 | -122.386190822782 | (37.7365838606598, -122.386190822782) | ||
| 9655 | 9655 | 114155 | Significant Tree 6 | Pittosporum spp :: Pittosporum spp 128 | 1200X JUNIPERO SERRA BLVD | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||||
| 9665 | 9665 | 114123 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 10242 | 10242 | 20328 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 10274 | 10274 | 36628 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 10729 | 10729 | 17592 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003646.11767 | 2090408.41073 | 37.7200700675728 | -122.42943389227699 | (37.7200700675728, -122.429433892277) | |||
| 10732 | 10732 | 48232 | Permitted Site 1 | Tree(s) :: 17 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 10850 | 10850 | 20451 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 495X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 10951 | 10951 | 24278 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350X Winding Way | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000808.42529 | 2086790.5767400002 | 37.709975233345 | -122.438983668972 | (37.709975233345, -122.438983668972) | |||
| 11109 | 11109 | 19996 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY46 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | ||||||||
| 11482 | 11482 | 46287 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 11548 | 11548 | 27209 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003678.0618199995 | 2093467.5761400003 | 37.728471665429396 | -122.42954152854401 | (37.7284716654294, -122.429541528544) | ||
| 11911 | 11911 | 1278 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/1990 12:00:00 AM | 12 | 3X3 | 5992545.036040001 | 2087392.68167 | 37.711154838998 | -122.467587032028 | (37.711154838998, -122.467587032028) | ||
| 11940 | 11940 | 19758 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 100 STAIRWAY15 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 12445 | 12445 | 27074 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 801 Silver Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4 | 6006810.48241 | 2093646.38042 | 37.7291394849019 | -122.418725241992 | (37.7291394849019, -122.418725241992) | |||
| 12458 | 12458 | 35205 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 12536 | 12536 | 44847 | Permitted Site 1 | Tree(s) :: 17 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 13373 | 13373 | 45906 | Permitted Site 1 | Tree(s) :: 17 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 13495 | 13495 | 14948 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016767.4558 | 2097838.85848 | 37.7412067724716 | -122.384594749942 | (37.7412067724716, -122.384594749942) | |||
| 13962 | 13962 | 19832 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 100 STAIRWAY25 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60X | ||||||||
| 14034 | 14034 | 78331 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 50 Pomona St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014103.033559999 | 2094377.1679 | 37.7315539757311 | -122.393565225657 | (37.7315539757311, -122.393565225657) | |
| 14188 | 14188 | 19617 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30 | ||||||||
| 14368 | 14368 | 18561 | DPW Maintained 3 | Ficus carica :: Edible Fig 201 | 1700X Quesada Ave | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014529.14736 | 2095157.7057700001 | 37.7337208418243 | -122.392146622477 | (37.7337208418243, -122.392146622477) | |||
| 14481 | 14481 | 6524 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 15 | 6017425.7364 | 2097207.6932200002 | 37.7395101016101 | -122.382274727523 | (37.7395101016101, -122.382274727523) | |||
| 14506 | 14506 | 20366 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
| 15183 | 15183 | 19718 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY13 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40ST | ||||||||
| 15304 | 15304 | 19794 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 STAIRWAY19 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 50ST | ||||||||
| 15541 | 15541 | 12136 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400X La Salle Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/1992 12:00:00 AM | 9 | 3X3 | 6016399.978680001 | 2095343.4315799999 | 37.734334505034 | -122.38569148576799 | (37.734334505034, -122.385691485768) | ||
| 15554 | 15554 | 21874 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015644.57338 | 2106657.85439 | 37.7653597144938 | -122.38909292500901 | (37.7653597144938, -122.389092925009) | ||
| 15612 | 15612 | 51105 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 15632 | 15632 | 20427 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 453X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 15768 | 15768 | 19884 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY33 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 25ST | ||||||||
| 15799 | 15799 | 35703 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 17169 | 17169 | 29607 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900X Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991176.48666 | 2091034.59302 | 37.7210755258009 | -122.472582381082 | (37.7210755258009, -122.472582381082) | ||
| 17217 | 17217 | 29295 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5997814.38842 | 2099950.16176 | 37.745937540096705 | -122.450279545065 | (37.7459375400967, -122.450279545065) | ||
| 17719 | 17719 | 29272 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998824.92396 | 2100202.06446 | 37.7466869838152 | -122.446803387487 | (37.7466869838152, -122.446803387487) | ||
| 18785 | 18785 | 18441 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 40 | 3X3 | 6010542.91396 | 2103606.86832 | 37.75669827012629 | -122.406523454504 | (37.7566982701263, -122.406523454504) | |||
| 18888 | 18888 | 451 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 740X 23rd Ave | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8-HOA | 5988823.24796 | 2110191.1107400004 | 37.7735377655293 | -122.482119432452 | (37.7735377655293, -122.482119432452) | |||
| 19065 | 19065 | 99574 | Undocumented 2 | Tree(s) :: 17 | 650X Brunswick St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
| 19241 | 19241 | 116677 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 100 Esmeralda Ave | 16 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 20325 | 20325 | 29327 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5993837.34412 | 2097865.72316 | 37.7399857917194 | -122.463880239694 | (37.7399857917194, -122.463880239694) | ||
| 20760 | 20760 | 97 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1997 12:00:00 AM | 12 | 3X3 | 6002378.86758 | 2107679.69737 | 37.767421152188604 | -122.435048944375 | (37.7674211521886, -122.435048944375) | ||
| 21068 | 21068 | 29972 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991341.172 | 2093706.68724 | 37.7284219643784 | -122.47220779725299 | (37.7284219643784, -122.472207797253) | ||
| 22042 | 22042 | 11684 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 700X Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 2X2 | 5991290.8523 | 2092837.83415 | 37.7260333983166 | -122.472318441749 | (37.7260333983166, -122.472318441749) | |||
| 22489 | 22489 | 26769 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1661 Pine St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | 6 | 3X3 | 6006177.03944 | 2115566.8639 | 37.789292330715604 | -122.42247206045299 | (37.7892923307156, -122.422472060453) | ||
| 22839 | 22839 | 251114 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 16 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 23151 | 23151 | 3506 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/1990 12:00:00 AM | 7 | 3X3 | 6017950.95507 | 2098155.67272 | 37.742142059314105 | -122.380524603638 | (37.7421420593141, -122.380524603638) | ||
| 23596 | 23596 | 179735 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6004922.43107 | 2094357.6156 | 37.7309858946841 | -122.42530298683701 | (37.7309858946841, -122.425302986837) | |||
| 23611 | 23611 | 211242 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 5ft | 5993561.819519999 | 2100384.28411 | 37.7468852429767 | -122.465015753384 | (37.7468852429767, -122.465015753384) | |||
| 23829 | 23829 | 191740 | Undocumented 2 | Eucalyptus gunnii :: Cider Gum 337 | 1 24th St | 16 | : Yard 23 | Tree 1 | Private 1 | 26 | 6017295.65111 | 2102637.55401 | 37.7544122033759 | -122.383102334025 | (37.7544122033759, -122.383102334025) | ||||
| 23999 | 23999 | 202780 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 77 Long Bridge St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014779.1442599995 | 2109356.92385 | 37.77272275278771 | -122.39227505555401 | (37.7727227527877, -122.392275055554) | |||
| 24224 | 24224 | 121780 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1501x Illinois St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6016262.62034 | 2101684.40187 | 37.7517379101009 | -122.38660839408001 | (37.7517379101009, -122.38660839408) | |||
| 24654 | 24654 | 190986 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6016149.69105 | 2100259.24355 | 37.747818469462 | -122.38689953970601 | (37.747818469462, -122.386899539706) | ||||
| 25226 | 25226 | 200137 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1561 Wallace Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015217.7405 | 2092518.6514 | 37.7265127372406 | -122.38958168278201 | (37.7265127372406, -122.389581682782) | |||
| 25269 | 25269 | 135059 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010565.46035 | 2122201.4821900004 | 37.807755957339396 | -122.40775658241999 | (37.8077559573394, -122.40775658242) | ||||
| 25284 | 25284 | 175279 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 526 Lathrop Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013138.73238 | 2086502.48989 | 37.7098780615819 | -122.396347291017 | (37.7098780615819, -122.396347291017) | |||
| 25309 | 25309 | 184952 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1990 41st Ave | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5983556.4384 | 2101472.9274 | 37.749292356781794 | -122.49969333533701 | (37.7492923567818, -122.499693335337) | |||
| 25566 | 25566 | 214228 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Detroit St | 16 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999467.5472800005 | 2095443.9032 | 37.733658896535 | -122.444239403229 | (37.733658896535, -122.444239403229) | ||||
| 26836 | 26836 | 175414 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 229 Delano Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6000123.85878 | 2092354.19797 | 37.7252127039895 | -122.44174868225201 | (37.7252127039895, -122.441748682252) | |||
| 27462 | 27462 | 193991 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 604 Keith St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6017161.38899 | 2096480.62152 | 37.73749910420911 | -122.38313814232201 | (37.7374991042091, -122.383138142322) | |||
| 27497 | 27497 | 126030 | Undocumented 2 | Cinnamomum camphora :: Camphor Tree 230 | 3301 Laguna St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6003671.03027 | 2120119.72439 | 37.8016516272786 | -122.431467704597 | (37.8016516272786, -122.431467704597) | ||||
| 28168 | 28168 | 139305 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1499 Post St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6005379.3471 | 2114416.7168 | 37.78608928126771 | -122.425150112273 | (37.7860892812677, -122.425150112273) | |||
| 28233 | 28233 | 195318 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 70 Steuart St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6014592.47705 | 2116860.68192 | 37.7933159964751 | -122.39344599623199 | (37.7933159964751, -122.393445996232) | |||
| 28874 | 28874 | 218292 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Woodacre Dr | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 5991223.38049 | 2095418.74528 | 37.73311602796429 | -122.472739784911 | (37.7331160279643, -122.472739784911) | ||||
| 28993 | 28993 | 196012 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6015764.416780001 | 2110694.68671 | 37.7764506135265 | -122.388960275907 | (37.7764506135265, -122.388960275907) | ||||
| 29252 | 29252 | 210843 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 32 Malta Dr | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5999589.7002 | 2096031.76487 | 37.735279994668005 | -122.443859307484 | (37.735279994668, -122.443859307484) | |||
| 29260 | 29260 | 195123 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 700 Minnesota St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015178.48076 | 2104950.70331 | 37.7606463991393 | -122.390585742959 | (37.7606463991393, -122.390585742959) | |||
| 29372 | 29372 | 190112 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 201 Utah St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010607.49637 | 2107318.24064 | 37.766892474940704 | -122.406561628027 | (37.7668924749407, -122.406561628027) | |||
| 29763 | 29763 | 186867 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985177.3409 | 2096363.4859 | 37.7353581877907 | -122.493711846576 | (37.7353581877907, -122.493711846576) | |||
| 29883 | 29883 | 189391 | Undocumented 2 | Corylus colurna :: Hazel: Turkish 368 | 800 19th St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6014993.43555 | 2105332.67798 | 37.7616849515235 | -122.391252437349 | (37.7616849515235, -122.391252437349) | |||
| 30335 | 30335 | 223901 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005051.96111 | 2102449.00234 | 37.753210319725106 | -122.425430786811 | (37.7532103197251, -122.425430786811) | |||
| 30713 | 30713 | 134493 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6008191.76515 | 2111982.49606 | 37.7795639729274 | -122.41524748988998 | (37.7795639729274, -122.41524748989) | |||
| 30950 | 30950 | 250591 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 7ft | 5998359.83298 | 2111349.05645 | 37.7772672447332 | -122.44921455891199 | (37.7772672447332, -122.449214558912) |
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");