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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10506 | 10506 | 1276 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3995X Alemany Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/1990 12:00:00 AM | 3 | 3X3 | 5992475.089319999 | 2087359.09364 | 37.71105857555521 | -122.46782634163701 | (37.7110585755552, -122.467826341637) | ||
| 11574 | 11574 | 1844 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2400 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010955.95806 | 2086992.43212 | 37.7111016386939 | -122.403925861702 | (37.7111016386939, -122.403925861702) | |||
| 18191 | 18191 | 29691 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 235X Hahn St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2006 12:00:00 AM | 3 | 3X3 | 6007408.6946 | 2087074.91278 | 37.7111292927788 | -122.416191939068 | (37.7111292927788, -122.416191939068) | ||
| 89356 | 89356 | 29692 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 235X Hahn St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2006 12:00:00 AM | 3 | 3X3 | 6007408.6946 | 2087074.91278 | 37.7111292927788 | -122.416191939068 | (37.7111292927788, -122.416191939068) | ||
| 127230 | 127230 | 29690 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 235X Hahn St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2006 12:00:00 AM | 3 | 3X3 | 6007408.6946 | 2087074.91278 | 37.7111292927788 | -122.416191939068 | (37.7111292927788, -122.416191939068) | ||
| 81534 | 81534 | 86987 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Executive Park Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2007 12:00:00 AM | 3x3 | Permit Number 49938 | 6014761.5 | 2086930.3 | 37.711142914018296 | -122.390768534473 | (37.7111429140183, -122.390768534473) | ||
| 87321 | 87321 | 86986 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Executive Park Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2007 12:00:00 AM | 3x3 | Permit Number 49938 | 6014761.5 | 2086930.3 | 37.711142914018296 | -122.390768534473 | (37.7111429140183, -122.390768534473) | ||
| 91022 | 91022 | 86991 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Executive Park Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2007 12:00:00 AM | 3x3 | Permit Number 49938 | 6014761.5 | 2086930.3 | 37.711142914018296 | -122.390768534473 | (37.7111429140183, -122.390768534473) | ||
| 93242 | 93242 | 86988 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Executive Park Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2007 12:00:00 AM | 3x3 | Permit Number 49938 | 6014761.5 | 2086930.3 | 37.711142914018296 | -122.390768534473 | (37.7111429140183, -122.390768534473) | ||
| 97746 | 97746 | 86994 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Executive Park Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2007 12:00:00 AM | 3x3 | Permit Number 49938 | 6014761.5 | 2086930.3 | 37.711142914018296 | -122.390768534473 | (37.7111429140183, -122.390768534473) | ||
| 98781 | 98781 | 86983 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Executive Park Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2007 12:00:00 AM | 3x3 | Permit Number 49938 | 6014761.5 | 2086930.3 | 37.711142914018296 | -122.390768534473 | (37.7111429140183, -122.390768534473) | ||
| 110208 | 110208 | 86993 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Executive Park Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2007 12:00:00 AM | 3x3 | Permit Number 49938 | 6014761.5 | 2086930.3 | 37.711142914018296 | -122.390768534473 | (37.7111429140183, -122.390768534473) | ||
| 127432 | 127432 | 86992 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Executive Park Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2007 12:00:00 AM | 3x3 | Permit Number 49938 | 6014761.5 | 2086930.3 | 37.711142914018296 | -122.390768534473 | (37.7111429140183, -122.390768534473) | ||
| 98765 | 98765 | 87658 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2401 Bay Shore Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2008 12:00:00 AM | 3 | 6011058.544175 | 2087018.2668340001 | 37.711178306502205 | -122.403573113663 | (37.7111783065022, -122.403573113663) | |||
| 104623 | 104623 | 87662 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2401 Bay Shore Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2008 12:00:00 AM | 6011058.544175 | 2087018.2668340001 | 37.711178306502205 | -122.403573113663 | (37.7111783065022, -122.403573113663) | ||||
| 12140 | 12140 | 87655 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2401 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2007 12:00:00 AM | 3 | 6011107.97471 | 2087042.08104 | 37.711246456543 | -122.40340394286001 | (37.711246456543, -122.40340394286) | |||
| 132587 | 132587 | 192625 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 251 Executive Park Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6014580.9976699995 | 2086985.89577 | 37.7112855527657 | -122.391396283929 | (37.7112855527657, -122.391396283929) | |||
| 159434 | 159434 | 192626 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 251 Executive Park Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6014541.1313 | 2086989.76137 | 37.7112939542297 | -122.391534343345 | (37.7112939542297, -122.391534343345) | |||
| 130699 | 130699 | 192627 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 251 Executive Park Blvd | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6014487.44333 | 2086993.90645 | 37.711302355688204 | -122.391720193647 | (37.7113023556882, -122.391720193647) | |||
| 29872 | 29872 | 192628 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 251 Executive Park Blvd | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6014467.5100300005 | 2086995.83932 | 37.7113065564365 | -122.391789223787 | (37.7113065564365, -122.391789223787) | |||
| 70031 | 70031 | 192629 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 251 Executive Park Blvd | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6014450.387080001 | 2086997.4605599998 | 37.7113100574851 | -122.39184851879999 | (37.7113100574851, -122.3918485188) | |||
| 170514 | 170514 | 192630 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 251 Executive Park Blvd | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6014430.72002 | 2086999.8980299998 | 37.7113156584728 | -122.391916664016 | (37.7113156584728, -122.391916664016) | |||
| 12360 | 12360 | 1850 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2401 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6011131.66864 | 2087081.7921400003 | 37.7113568186287 | -122.403324842066 | (37.7113568186287, -122.403324842066) | |||
| 35945 | 35945 | 177158 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 221 Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6007422.7575199995 | 2087173.9249099998 | 37.71140195020789 | -122.41615034177799 | (37.7114019502079, -122.416150341778) | |||
| 11885 | 11885 | 87668 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2320 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6011025.105219999 | 2087108.4140400002 | 37.711423964715294 | -122.40369502642599 | (37.7114239647153, -122.403695026426) | |||
| 12813 | 12813 | 87667 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2320 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6011034.7133599995 | 2087125.8467 | 37.711472368028105 | -122.40366304381901 | (37.7114723680281, -122.403663043819) | |||
| 12599 | 12599 | 87656 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2401 Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6011160.10599 | 2087129.6938599998 | 37.711489935374296 | -122.40322992225 | (37.7114899353743, -122.40322992225) | |||
| 11645 | 11645 | 25449 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2320 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/1998 12:00:00 AM | 6 | 3x3 | 6011044.69941 | 2087142.06998 | 37.7115174717274 | -122.40362966997 | (37.7115174717274, -122.40362966997) | ||
| 45090 | 45090 | 177159 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 221 Hahn St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6007445.49487 | 2087228.3234299999 | 37.711552595661004 | -122.416075605431 | (37.711552595661, -122.416075605431) | |||
| 11108 | 11108 | 87666 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2300X Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6011061.70959 | 2087167.365 | 37.71158787695521 | -122.403572656549 | (37.7115878769552, -122.403572656549) | |||
| 2758 | 2758 | 177160 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 221 Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | Permit Number 780274 | 6007458.52227 | 2087256.96391 | 37.7116319689192 | -122.416032606129 | (37.7116319689192, -122.416032606129) | ||
| 11847 | 11847 | 87665 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2300X Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/10/2015 08:16:00 AM | 3 | 3x3 | 6011071.30165 | 2087183.9968700001 | 37.71163408052671 | -122.403540673064 | (37.7116340805267, -122.403540673064) | ||
| 10997 | 10997 | 87663 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2300X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 6 | 3x3 | 6011080.48345 | 2087200.23652 | 37.711679184215996 | -122.403510079939 | (37.711679184216, -122.403510079939) | ||
| 12700 | 12700 | 1837 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2201X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6011211.45884 | 2087199.50485 | 37.71168449021379 | -122.403057339627 | (37.7116844902138, -122.403057339627) | |||
| 23137 | 23137 | 1254 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3802X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 5992777.102469999 | 2087583.7041 | 37.711692737 | -122.466798837414 | (37.711692737, -122.466798837414) | ||||
| 93925 | 93925 | 50582 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 261 (REVISED) Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1990 12:00:00 AM | Permit Number 47197 | 6000169.17301697 | 2087429.90254261 | 37.7116942865763 | -122.441238881747 | (37.7116942865763, -122.441238881747) | ||
| 142542 | 142542 | 87657 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2401 Bay Shore Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6011208.27555 | 2087204.0629599998 | 37.7116968281026 | -122.403068662408 | (37.7116968281026, -122.403068662408) | ||||
| 13041 | 13041 | 87664 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2300X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2016 07:04:00 AM | 3 | 3x3 | 6011092.11043 | 2087218.0287 | 37.7117286874105 | -122.40347114468 | (37.7117286874105, -122.40347114468) | ||
| 10994 | 10994 | 1220 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3602X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 20 | 5993502.10505 | 2087589.31821 | 37.711749968047 | -122.46429345928301 | (37.711749968047, -122.464293459283) | |||
| 79624 | 79624 | 1223 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3600X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 15 | 3X5 | 5993524.054670201 | 2087589.4711722 | 37.7117516532039 | -122.46421760708901 | (37.7117516532039, -122.464217607089) | ||
| 92400 | 92400 | 1222 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3600X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 12 | 3X5 | 5993524.054670201 | 2087589.4711722 | 37.7117516532039 | -122.46421760708901 | (37.7117516532039, -122.464217607089) | ||
| 104734 | 104734 | 1225 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3600X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 15 | 3X5 | 5993524.054670201 | 2087589.4711722 | 37.7117516532039 | -122.46421760708901 | (37.7117516532039, -122.464217607089) | ||
| 110280 | 110280 | 1226 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3600X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 15 | 3X5 | 5993524.054670201 | 2087589.4711722 | 37.7117516532039 | -122.46421760708901 | (37.7117516532039, -122.464217607089) | ||
| 166612 | 166612 | 177204 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011244.59226 | 2087232.80828 | 37.711777784991604 | -122.402945161798 | (37.7117777849916, -122.402945161798) | |||
| 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) | ||
| 169292 | 169292 | 177215 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3602 Alemany Blvd | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5993434.694569999 | 2087605.54338 | 37.7117906327114 | -122.46452762384399 | (37.7117906327114, -122.464527623844) | |||
| 37554 | 37554 | 29368 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3802X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2006 12:00:00 AM | 10 | 3X3 | 5992911.10359 | 2087617.0895099998 | 37.7117921381675 | -122.466338121928 | (37.7117921381675, -122.466338121928) | ||
| 2093 | 2093 | 177161 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 221 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6007505.03845 | 2087315.4239400001 | 37.711795103221604 | -122.41587597032499 | (37.7117951032216, -122.415875970325) | |||
| 45080 | 45080 | 177216 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3602 Alemany Blvd | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5993403.40349 | 2087610.58828 | 37.7118026809134 | -122.464636139668 | (37.7118026809134, -122.464636139668) | |||
| 88416 | 88416 | 25440 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2401 Bay Shore Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1997 12:00:00 AM | 3 | 3X3 | 6011248.80473 | 2087244.76876 | 37.7118108612964 | -122.40293144295201 | (37.7118108612964, -122.402931442952) | ||
| 74212 | 74212 | 177205 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011261.11709 | 2087247.3890900002 | 37.7118187437114 | -122.402889071969 | (37.7118187437114, -122.402889071969) | |||
| 99961 | 99961 | 1256 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3800X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 0 | 5992948.4963594 | 2087630.4709831001 | 37.711831037999794 | -122.466209855136 | (37.7118310379998, -122.466209855136) | |||
| 23091 | 23091 | 1240 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3702X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X5 | 5993007.23866 | 2087630.97634 | 37.711835814643 | -122.466006863839 | (37.711835814643, -122.466006863839) | |||
| 128115 | 128115 | 177217 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3602 Alemany Blvd | 6 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5993336.53195 | 2087626.2537599998 | 37.711841839194605 | -122.464868401251 | (37.7118418391946, -122.464868401251) | |||
| 141014 | 141014 | 1242 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3700X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X5 | 5993218.71389 | 2087629.4001799999 | 37.71184368475021 | -122.46527583828698 | (37.7118436847502, -122.465275838287) | |||
| 57692 | 57692 | 177218 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3602 Alemany Blvd | 7 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5993301.35241 | 2087629.7349200002 | 37.7118493692142 | -122.46499024319799 | (37.7118493692142, -122.464990243198) | |||
| 116275 | 116275 | 29696 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1430 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2006 12:00:00 AM | 3 | 3X3 | 6007593.91011 | 2087362.66778 | 37.7119298209181 | -122.415572147266 | (37.7119298209181, -122.415572147266) | ||
| 87726 | 87726 | 29693 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 199X Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2006 12:00:00 AM | 3 | 3x3 | 6007499.8753 | 2087368.04212 | 37.711939291510504 | -122.41589753931999 | (37.7119392915105, -122.41589753932) | ||
| 106730 | 106730 | 29695 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 199X Hahn St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2006 12:00:00 AM | 3 | 3X3 | 6007499.8753 | 2087368.04212 | 37.711939291510504 | -122.41589753931999 | (37.7119392915105, -122.41589753932) | ||
| 110757 | 110757 | 29694 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 199X Hahn St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2006 12:00:00 AM | 3 | 3X3 | 6007499.8753 | 2087368.04212 | 37.711939291510504 | -122.41589753931999 | (37.7119392915105, -122.41589753932) | ||
| 11372 | 11372 | 94591 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2260 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6011152.33862 | 2087310.9543599999 | 37.7119872065292 | -122.40326951128701 | (37.7119872065292, -122.403269511287) | |||
| 10335 | 10335 | 94590 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2260 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6011161.44702 | 2087323.58946 | 37.7120224086757 | -122.403238918143 | (37.7120224086757, -122.403238918143) | |||
| 167373 | 167373 | 177206 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011387.88775 | 2087322.29627 | 37.712031501723 | -122.40245617881 | (37.712031501723, -122.40245617881) | |||
| 86249 | 86249 | 87659 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2401 Bay Shore Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6011392.94261 | 2087323.8118599998 | 37.712035945421 | -122.40243881416599 | (37.712035945421, -122.402438814166) | ||||
| 35853 | 35853 | 177213 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 191 Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007513.73926 | 2087408.76732 | 37.7120518938527 | -122.415852503397 | (37.7120518938527, -122.415852503397) | |||
| 33194 | 33194 | 177166 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2899 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5997136.98269 | 2087629.18233 | 37.7120682714136 | -122.45173326588801 | (37.7120682714136, -122.451733265888) | |||
| 10755 | 10755 | 94589 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2260 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6011173.46811 | 2087340.9730900002 | 37.712070811991794 | -122.40319859163701 | (37.7120708119918, -122.403198591637) | |||
| 174147 | 174147 | 177207 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Bay Shore Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011493.477530001 | 2087358.2704900003 | 37.712136173824206 | -122.40209375562999 | (37.7121361738242, -122.40209375563) | |||
| 50967 | 50967 | 177214 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 191 Hahn St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007528.08099 | 2087439.2108200002 | 37.7121362916291 | -122.415805088439 | (37.7121362916291, -122.415805088439) | |||
| 81228 | 81228 | 87661 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2401 Bay Shore Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6011511.5626 | 2087362.3598200001 | 37.7121484117148 | -122.402031535292 | (37.7121484117148, -122.402031535292) | ||||
| 169387 | 169387 | 177208 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Bay Shore Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011519.41669 | 2087365.20165 | 37.7121566531729 | -122.40200458875799 | (37.7121566531729, -122.402004588758) | |||
| 161208 | 161208 | 177167 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2899 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 5997176.63506 | 2087670.62401 | 37.712184331616 | -122.45159920395201 | (37.712184331616, -122.451599203952) | |||
| 51544 | 51544 | 6858 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2865X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/1992 12:00:00 AM | 15 | 3X3 | 5997253.0 | 2087738.0 | 37.7123737035526 | -122.451340121886 | (37.7123737035526, -122.451340121886) | ||
| 144551 | 144551 | 6860 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2865X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/13/1997 12:00:00 AM | 12 | 3X3 | 5997253.0 | 2087738.0 | 37.7123737035526 | -122.451340121886 | (37.7123737035526, -122.451340121886) | ||
| 62605 | 62605 | 87633 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2189 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 5 | 6011731.39741 | 2087443.1040700001 | 37.7123823866133 | -122.401277387957 | (37.7123823866133, -122.401277387957) | |||
| 10707 | 10707 | 25431 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2184X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2003 12:00:00 AM | 6 | 3X3 | 6011467.81335 | 2087456.61452 | 37.7124047743446 | -122.40218936886801 | (37.7124047743446, -122.402189368868) | ||
| 11030 | 11030 | 1159 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2850 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 12 | 3X3 | 5997145.26521 | 2087753.04945 | 37.712408856364 | -122.45171356894501 | (37.712408856364, -122.451713568945) | ||
| 11535 | 11535 | 1834 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2189 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6011752.1374 | 2087455.01469 | 37.7124162478888 | -122.40120654027099 | (37.7124162478888, -122.401206540271) | |||
| 40420 | 40420 | 177199 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2184 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011482.89691 | 2087463.2956700001 | 37.712423961369794 | -122.402137704617 | (37.7124239613698, -122.402137704617) | |||
| 117436 | 117436 | 87654 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2180X Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 3 | 6011539.840931 | 2087478.317387 | 37.712468386259204 | -122.40194194288999 | (37.7124683862592, -122.40194194289) | |||
| 75475 | 75475 | 177198 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2182 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011531.3996 | 2087480.36268 | 37.712473531102 | -122.401971262582 | (37.712473531102, -122.401971262582) | |||
| 10509 | 10509 | 29778 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2155 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6011846.13129 | 2087520.2941700001 | 37.712600735722 | -122.40088625032699 | (37.712600735722, -122.400886250327) | |||
| 12235 | 12235 | 1830 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2155 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6011860.5198800005 | 2087534.8853200001 | 37.712641602691605 | -122.400837543032 | (37.7126416026916, -122.400837543032) | |||
| 10317 | 10317 | 87652 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2158 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2010 12:00:00 AM | 3 | 6011710.82599 | 2087552.41903 | 37.712681395911204 | -122.40135616677901 | (37.7126813959112, -122.401356166779) | |||
| 80474 | 80474 | 87651 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2152 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6011761.115735 | 2087586.701923 | 37.7127783356082 | -122.401184755968 | (37.7127783356082, -122.401184755968) | |||
| 36340 | 36340 | 177197 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2148 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011773.00633 | 2087598.6227099998 | 37.7128117310604 | -122.40114449512801 | (37.7128117310604, -122.401144495128) | |||
| 12486 | 12486 | 87650 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2148 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 3 | 6011790.09435 | 2087616.19351 | 37.7128609302491 | -122.40108666691002 | (37.7128609302491, -122.40108666691) | |||
| 108391 | 108391 | 111916 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 125 TUNNEL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6012052.0 | 2087737.0 | 37.7132072479286 | -122.40018990943399 | (37.7132072479286, -122.400189909434) | ||||
| 4290 | 4290 | 161549 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 77 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 10:57:00 AM | 3 | Width 0ft | 6001063.17018 | 2087984.7408099999 | 37.713268634318 | -122.43818871324301 | (37.713268634318, -122.438188713243) | ||
| 23196 | 23196 | 1823 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2111 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 6012045.082330001 | 2087761.7241200001 | 37.713274749700496 | -122.400215554797 | (37.7132747497005, -122.400215554797) | ||||
| 45047 | 45047 | 111915 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2107 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 6012063.63789 | 2087784.79558 | 37.7133391339723 | -122.400153039325 | (37.7133391339723, -122.400153039325) | |||
| 4216 | 4216 | 161550 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 57 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 11:14:00 AM | 3 | Width 0ft | 6001143.14071 | 2088011.22838 | 37.713345911251395 | -122.43791420417801 | (37.7133459112514, -122.437914204178) | ||
| 125195 | 125195 | 94933 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 33@ Hester Lois Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53980 | 6012381.0 | 2087786.0 | 37.713360131581105 | -122.399056203003 | (37.7133601315811, -122.399056203003) | |||
| 84094 | 84094 | 52996 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 28VISITATION Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2006 12:00:00 AM | 3 | Permit Number 48977 | 6008565.598259999 | 2087899.60017 | 37.7134586979431 | -122.41225163232401 | (37.7134586979431, -122.412251632324) | ||
| 175043 | 175043 | 177182 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 100 Hester Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012738.24424 | 2087832.97197 | 37.713509008717104 | -122.39782472694799 | (37.7135090087171, -122.397824726948) | |||
| 4197 | 4197 | 161557 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 15 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 11:09:00 AM | 3 | Width 0ft | 6001350.49803 | 2088073.55411 | 37.7135288333539 | -122.43720196631399 | (37.7135288333539, -122.437201966314) | ||
| 178021 | 178021 | 177181 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 100 Hester Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012733.04621 | 2087844.4062 | 37.7135401153657 | -122.397843494878 | (37.7135401153657, -122.397843494878) | |||
| 66399 | 66399 | 177169 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 30 Morse St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6001283.266009999 | 2088090.37173 | 37.7135711887396 | -122.43743554722799 | (37.7135711887396, -122.437435547228) | |||
| 168964 | 168964 | 177180 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 100 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012720.89372 | 2087869.88497 | 37.7136093982281 | -122.397887284673 | (37.7136093982281, -122.397887284673) | |||
| 116346 | 116346 | 51680 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 10X Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 3 | 3x3 | Permit Number 47961 | 6001415.38816785 | 2088105.22450821 | 37.7136194817396 | -122.43697994924999 | (37.7136194817396, -122.43697994925) |
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");