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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 268 | 268 | 46773 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 35 San Juan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2017 12:00:00 AM | 3 | Permit Number 779460 | 6001741.72526 | 2092006.08473 | 37.7243489150655 | -122.43613098976101 | (37.7243489150655, -122.436130989761) | |
| 959 | 959 | 83601 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2008 12:00:00 AM | 5 | 6009088.96788 | 2112689.1650900003 | 37.7815547005346 | -122.41219362785499 | (37.7815547005346, -122.412193627855) | ||
| 1788 | 1788 | 108703 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2436 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772910 | 6001246.11089 | 2119029.77225 | 37.798521172675294 | -122.439780826226 | (37.7985211726753, -122.439780826226) |
| 1801 | 1801 | 251699 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1230 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2017 12:00:00 AM | 3 | 4x3 | Permit Number 778360 | 6005943.79297 | 2120373.7363400003 | 37.8024776288704 | -122.423620966152 | (37.8024776288704, -122.423620966152) |
| 1809 | 1809 | 172747 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1230 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2017 12:00:00 AM | 3 | 4x3 | Permit Number 778360 | 6006022.78943 | 2120387.12776 | 37.802518857014704 | -122.423348551388 | (37.8025188570147, -122.423348551388) |
| 1812 | 1812 | 172746 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1230 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2017 12:00:00 AM | 3 | 4x3 | Permit Number 778360 | 6006038.86692 | 2120389.38612 | 37.8025259652646 | -122.423293075825 | (37.8025259652646, -122.423293075825) |
| 3894 | 3894 | 52352 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1078 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 11 | 3x3 | Permit Number 48492 | 6009562.81073 | 2117112.1754400004 | 37.793725799570396 | -122.41086683016701 | (37.7937257995704, -122.410866830167) |
| 4796 | 4796 | 160687 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:00:00 PM | 3 | Width 0ft | 6002383.98515 | 2090374.0075 | 37.7199040644127 | -122.433794193158 | (37.7199040644127, -122.433794193158) | |
| 5225 | 5225 | 73666 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 725 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1988 12:00:00 AM | 8 | 6007366.2246900005 | 2113649.85624 | 37.7840957097951 | -122.418221641431 | (37.7840957097951, -122.418221641431) | ||
| 6616 | 6616 | 43072 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 775 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 6 | 3x3 | 6008014.74915 | 2114436.68155 | 37.7862926240458 | -122.41603371409799 | (37.7862926240458, -122.416033714098) | |
| 6966 | 6966 | 120642 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 795 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2016 12:00:00 AM | 3 | 3x3 | 6008851.25075 | 2115247.06869 | 37.788564746801896 | -122.413196950189 | (37.7885647468019, -122.413196950189) | |
| 7001 | 7001 | 108984 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2468 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | Permit Number 772908 | 6001097.74629 | 2119009.51185 | 37.7984570968878 | -122.440292758998 | (37.7984570968878, -122.440292758998) | |
| 7520 | 7520 | 108983 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2468 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | Permit Number 772908 | 6001114.291780001 | 2119011.40091 | 37.798463225757104 | -122.44023564217501 | (37.7984632257571, -122.440235642175) | |
| 7812 | 7812 | 73980 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/23/1986 12:00:00 AM | 3 | Permit Number 769778 | 6007997.423219999 | 2113875.47963 | 37.7847507256189 | -122.416053899389 | (37.7847507256189, -122.416053899389) | |
| 9827 | 9827 | 173704 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5997184.0 | 2089426.0 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | |||
| 9830 | 9830 | 60472 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1982 12:00:00 AM | 3x3 | Permit Number 20066 | 5997184.0 | 2089426.0 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | |
| 9956 | 9956 | 173750 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 989 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6007621.28893018 | 2103912.36255672 | 37.7573732040434 | -122.41664916584601 | (37.7573732040434, -122.416649165846) | ||||
| 12974 | 12974 | 70398 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 153 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 15 | 3x3 | Permit Number 775403 | 6006428.67416 | 2093189.7216599998 | 37.7278640951339 | -122.420012793267 | (37.7278640951339, -122.420012793267) |
| 13639 | 13639 | 30788 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 555 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 8 | 3x3 | Permit Number 34660 | 6013413.6029900005 | 2112078.5920599997 | 37.780119917635396 | -122.397189528597 | (37.7801199176354, -122.397189528597) |
| 13689 | 13689 | 32652 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 245 05th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 37086 | 6011382.82025 | 2112467.88535 | 37.781075561520204 | -122.404242374492 | (37.7810755615202, -122.404242374492) | |
| 14153 | 14153 | 82559 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1201 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/2013 12:00:00 AM | 6 | 3x3 | Permit Number 769973 | 6009193.39922 | 2110671.57266 | 37.7760207286215 | -122.41168974309099 | (37.7760207286215, -122.411689743091) |
| 14333 | 14333 | 44517 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 698 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2001 12:00:00 AM | 10 | 3x3 | Permit Number 43820 | 6015238.92645 | 2112278.49137 | 37.780770244383504 | -122.390888827059 | (37.7807702443835, -122.390888827059) |
| 15254 | 15254 | 32651 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 245 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 37086 | 6011423.97254 | 2112425.20329 | 37.7809606659531 | -122.404097002688 | (37.7809606659531, -122.404097002688) | |
| 15325 | 15325 | 32642 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 245 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 37086 | 6011410.82425 | 2112441.1225400004 | 37.7810036418498 | -122.40414361006701 | (37.7810036418498, -122.404143610067) | |
| 15914 | 15914 | 32653 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 245 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 37086 | 6011396.32164 | 2112453.5559400003 | 37.7810369707226 | -122.404194657383 | (37.7810369707226, -122.404194657383) | |
| 18077 | 18077 | 46101 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 250 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2001 12:00:00 AM | Permit Number 44468 | 6015276.73031133 | 2112998.11508414 | 37.7827482661819 | -122.39080835017 | (37.7827482661819, -122.39080835017) | ||
| 18371 | 18371 | 68355 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 627 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32175 | 5989388.74548019 | 2111065.82314724 | 37.7759723585503 | -122.48022734798799 | (37.7759723585503, -122.480227347988) | ||
| 18448 | 18448 | 62738 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 4521 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/07/1986 12:00:00 AM | Permit Number 23085 | 6000942.99197149 | 2105197.51217307 | 37.7605240475123 | -122.439837443247 | (37.7605240475123, -122.439837443247) | ||
| 18637 | 18637 | 60677 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1098 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/1988 12:00:00 AM | Permit Number 25704 | 6001311.54507479 | 2109393.91334387 | 37.7720673006946 | -122.438863516223 | (37.7720673006946, -122.438863516223) | ||
| 18887 | 18887 | 92885 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1366 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2009 12:00:00 AM | 3x3 | Permit Number 53100 | 6008075.0 | 2110545.0 | 37.77561038858529 | -122.415549628976 | (37.7756103885853, -122.415549628976) | |
| 18920 | 18920 | 64985 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Kingston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/28/1989 12:00:00 AM | Permit Number 26023 | 6005554.31706226 | 2098219.5570786 | 37.741625601295 | -122.42339288942699 | (37.741625601295, -122.423392889427) | ||
| 19017 | 19017 | 39449 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 205 13th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1999 12:00:00 AM | Permit Number 40934 | 6007392.37160238 | 2108419.72859009 | 37.7697365039652 | -122.417760336994 | (37.7697365039652, -122.417760336994) | ||
| 19021 | 19021 | 67521 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 424 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | Permit Number 31057 | 5997342.043029 | 2093839.69948247 | 37.729132642900794 | -122.451472187982 | (37.7291326429008, -122.451472187982) | ||
| 19107 | 19107 | 64799 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 450 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25798 | 6003587.23896685 | 2100132.28558533 | 37.7467662928737 | -122.430330814023 | (37.7467662928737, -122.430330814023) | ||
| 19110 | 19110 | 62227 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 228 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1985 12:00:00 AM | Permit Number 22352 | 6001110.06412505 | 2093217.52334826 | 37.72763934179729 | -122.43840130114799 | (37.7276393417973, -122.438401301148) | ||
| 19130 | 19130 | 68743 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3929 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/1993 12:00:00 AM | Permit Number 32664 | 6003434.71793969 | 2105335.41306872 | 37.761044210169004 | -122.431229551523 | (37.761044210169, -122.431229551523) | ||
| 19271 | 19271 | 66851 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 4314 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | Permit Number 30156 | 6001689.12791695 | 2104706.38300314 | 37.7592179697276 | -122.437221739283 | (37.7592179697276, -122.437221739283) | ||
| 20265 | 20265 | 52930 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 36 Havelock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48915 | 5999971.05699015 | 2092944.44477133 | 37.7268246780096 | -122.442319255194 | (37.7268246780096, -122.442319255194) | ||
| 21198 | 21198 | 42536 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Brady St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42642 | 6006853.97359683 | 2109407.99798814 | 37.772419743979896 | -122.419692774816 | (37.7724197439799, -122.419692774816) | ||
| 21201 | 21201 | 63890 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 165 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1987 12:00:00 AM | Permit Number 24599 | 6005777.74997654 | 2109961.71011831 | 37.77387942030639 | -122.42345491188401 | (37.7738794203064, -122.423454911884) | ||
| 23249 | 23249 | 53025 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 362 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/06/2006 12:00:00 AM | 12 | 3x3 | Permit Number 49004 | 6014453.29815 | 2112295.9284599996 | 37.7807744999799 | -122.39360793807501 | (37.7807744999799, -122.393607938075) |
| 23649 | 23649 | 83478 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 10 | 6015481.04355 | 2105634.6159 | 37.762541056634 | -122.38958707191001 | (37.762541056634, -122.38958707191) | ||
| 24115 | 24115 | 37515 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 334 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 8 | Permit Number 39971 | 6008037.23261 | 2113608.31593 | 37.784019396929494 | -122.41589724646002 | (37.7840193969295, -122.41589724646) | |
| 24289 | 24289 | 65026 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 271 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 13 | Permit Number 26077 | 6013497.70585 | 2105830.92167 | 37.7629698974541 | -122.396460524653 | (37.7629698974541, -122.396460524653) | |
| 24736 | 24736 | 34593 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3196 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38289 | 5999056.096030001 | 2116639.74571 | 37.7918338966676 | -122.447186830523 | (37.7918338966676, -122.447186830523) | |
| 24793 | 24793 | 35384 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 567 Vermont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 8 | Permit Number 38840 | 6011258.3331699995 | 2105715.55317 | 37.7625282467018 | -122.40419766648998 | (37.7625282467018, -122.40419766649) | |
| 26077 | 26077 | 98248 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 650 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | I believe these were planted in 2010 by FUF. C.Buck | 6007281.495490001 | 2113344.84788 | 37.7832534614285 | -122.41849313956001 | (37.7832534614285, -122.41849313956) | |
| 26375 | 26375 | 75838 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 101 Henry Adams St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | 15 | 6011420.310769999 | 2107843.20731 | 37.768379354641105 | -122.40378716196699 | (37.7683793546411, -122.403787161967) | ||
| 26916 | 26916 | 47467 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1903 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 11 | Permit Number 45369 | 6000459.82276 | 2115245.67943 | 37.7880862598074 | -122.44222983124901 | (37.7880862598074, -122.442229831249) | |
| 27453 | 27453 | 71972 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 776 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/1995 12:00:00 AM | 13 | 6009259.7893900005 | 2119456.28205 | 37.8001451441351 | -122.41208105430599 | (37.8001451441351, -122.412081054306) | ||
| 28967 | 28967 | 34594 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3196 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38289 | 5999039.4413 | 2116637.89487 | 37.7918278631246 | -122.447244322395 | (37.7918278631246, -122.447244322395) | |
| 29431 | 29431 | 49523 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 575@ DIVISION 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2003 12:00:00 AM | 6 | Permit Number 46430 | 6010035.11091 | 2108310.12323 | 37.769583917386896 | -122.408611404187 | (37.7695839173869, -122.408611404187) | |
| 30113 | 30113 | 70615 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 956 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 13 | 6007552.40866 | 2114767.26768 | 37.7871743274878 | -122.417656736796 | (37.7871743274878, -122.417656736796) | ||
| 30115 | 30115 | 65436 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 650X Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/1989 12:00:00 AM | 15 | 3x3 | Permit Number 28309 | 6008836.61529 | 2114836.9012599997 | 37.7874377047295 | -122.413218570787 | (37.7874377047295, -122.413218570787) |
| 30240 | 30240 | 75882 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 539 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 12 | 6013498.81204 | 2112165.8305200003 | 37.7803641977969 | -122.39690086778201 | (37.7803641977969, -122.396900867782) | ||
| 30495 | 30495 | 37516 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 401 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | 11 | Permit Number 41076 | 6007956.902430001 | 2113828.4377200003 | 37.784619281597294 | -122.41619075552299 | (37.7846192815973, -122.416190755523) | |
| 30524 | 30524 | 41722 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 232 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42170 | 6009584.56743913 | 2109048.70213008 | 37.771586640345795 | -122.41022197760701 | (37.7715866403458, -122.410221977607) | ||
| 31031 | 31031 | 66600 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 795 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | 11 | Permit Number 29793 | 6010138.53594 | 2116122.08721 | 37.7910395219106 | -122.40880487713801 | (37.7910395219106, -122.408804877138) | |
| 31559 | 31559 | 35385 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 567 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 10 | Permit Number 38840 | 6011258.977630001 | 2105699.98405 | 37.7624855334018 | -122.404194341714 | (37.7624855334018, -122.404194341714) | |
| 31584 | 31584 | 37502 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 844 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 7 | Permit Number 39966 | 6008740.03897 | 2115504.68539 | 37.7892658555875 | -122.413599955284 | (37.7892658555875, -122.413599955284) | |
| 32214 | 32214 | 121078 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 726 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 4x4 | 6007074.608519999 | 2113528.41761 | 37.7837458501408 | -122.419221913271 | (37.7837458501408, -122.419221913271) | ||
| 32254 | 32254 | 41802 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Henry Adams St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | 5 | Permit Number 42199 | 6011432.49542 | 2107611.3986 | 37.7677435411696 | -122.403728703313 | (37.7677435411696, -122.403728703313) | |
| 32607 | 32607 | 79175 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 399 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 5 | 6005975.99544 | 2111376.30995 | 37.777774756444 | -122.422869703793 | (37.777774756444, -122.422869703793) | ||
| 35308 | 35308 | 30782 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 454 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 5 | Permit Number 34656 | 6013813.25306 | 2111685.96726 | 37.7790641000695 | -122.39577942850201 | (37.7790641000695, -122.395779428502) | |
| 35556 | 35556 | 64007 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2160 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1987 12:00:00 AM | 16 | Permit Number 24755 | 6007652.23543 | 2119845.6976400004 | 37.80112405438229 | -122.417671444289 | (37.8011240543823, -122.417671444289) | |
| 36120 | 36120 | 30524 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 161 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1995 12:00:00 AM | 7 | Permit Number 34529 | 6008071.29151 | 2113023.94527 | 37.7824167708541 | -122.415738023293 | (37.7824167708541, -122.415738023293) | |
| 36303 | 36303 | 41801 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Henry Adams St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | 6 | Permit Number 42199 | 6011430.3722 | 2107669.42894 | 37.767902760721896 | -122.403740131013 | (37.7679027607219, -122.403740131013) | |
| 36757 | 36757 | 49619 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1452 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46479 | 6008198.17728 | 2109818.54948 | 37.7736226504053 | -122.41507209599399 | (37.7736226504053, -122.415072095994) |
| 37708 | 37708 | 41797 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Henry Adams St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | 18 | Permit Number 42199 | 6011431.47132 | 2107642.26388 | 37.7678282330246 | -122.403734417609 | (37.7678282330246, -122.403734417609) | |
| 38601 | 38601 | 65456 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 895 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1989 12:00:00 AM | 15 | Permit Number 28332 | 6008339.818530001 | 2115177.38309 | 37.7883446818054 | -122.41496149919399 | (37.7883446818054, -122.414961499194) | |
| 39027 | 39027 | 37506 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 844 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 6 | Permit Number 39966 | 6008737.124969999 | 2115540.18684 | 37.7893631703113 | -122.413612549392 | (37.7893631703113, -122.413612549392) | |
| 39435 | 39435 | 30780 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 454 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 2 | Permit Number 34656 | 6013835.79296 | 2111706.6575599997 | 37.7791221647875 | -122.39570290337099 | (37.7791221647875, -122.395702903371) | |
| 39446 | 39446 | 31556 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 160 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 1 | Permit Number 35101 | 5998589.70626628 | 2112540.1098933998 | 37.780550714408605 | -122.448505154861 | (37.7805507144086, -122.448505154861) | |
| 40095 | 40095 | 66604 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 795 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1993 12:00:00 AM | 17 | 3x3 | Permit Number 31919 | 6008813.15818 | 2115243.41738 | 37.7885525825831 | -122.41332848682899 | (37.7885525825831, -122.413328486829) |
| 40824 | 40824 | 67705 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 374 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | 12 | Permit Number 31425 | 6014391.04027 | 2112236.06649 | 37.780606672994296 | -122.39381912855801 | (37.7806066729943, -122.393819128558) | |
| 41515 | 41515 | 64721 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1031 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/1990 12:00:00 AM | 5 | Permit Number 28427 | 6007202.72869 | 2114670.35811 | 37.786888554407795 | -122.41885968072901 | (37.7868885544078, -122.418859680729) | |
| 41628 | 41628 | 75898 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2650 18th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1996 12:00:00 AM | 15 | 6009892.14521 | 2105512.72299 | 37.761894888354995 | -122.408908522215 | (37.761894888355, -122.408908522215) | ||
| 41890 | 41890 | 72084 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 262 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1985 12:00:00 AM | 8 | 5988392.799430001 | 2114246.03166 | 37.7846463939543 | -122.48390578898001 | (37.7846463939543, -122.48390578898) | ||
| 41906 | 41906 | 59990 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3701 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1993 12:00:00 AM | 1 | Permit Number 31697 | 5997018.354180001 | 2115328.30221 | 37.7881163817185 | -122.45414261620701 | (37.7881163817185, -122.454142616207) | |
| 42061 | 42061 | 30783 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 415 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 13 | Permit Number 34657 | 6014357.565830001 | 2112984.90996 | 37.782660966471504 | -122.393987370124 | (37.7826609664715, -122.393987370124) | |
| 42118 | 42118 | 33856 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 757 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 8 | Permit Number 37855 | 6014472.91099 | 2103543.4730599998 | 37.7567432802823 | -122.39292755146799 | (37.7567432802823, -122.392927551468) | |
| 42781 | 42781 | 64160 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 680 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | 16 | Permit Number 24939 | 5991956.12179 | 2110816.35243 | 37.77543622828279 | -122.47132802483601 | (37.7754362282828, -122.471328024836) | |
| 43006 | 43006 | 96030 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 753 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2016 12:00:00 AM | 2 | 3x3 | Permit Number 774797 | 6007450.19055 | 2113968.20942 | 37.784974556074 | -122.41795372439199 | (37.784974556074, -122.417953724392) |
| 43500 | 43500 | 45194 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 434 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/2005 12:00:00 AM | 6 | Permit Number 44039 | 6008463.064259999 | 2114024.0616200003 | 37.7851848652278 | -122.41445344698201 | (37.7851848652278, -122.414453446982) | |
| 44781 | 44781 | 62416 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 677 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/09/1985 12:00:00 AM | 12 | Permit Number 22573 | 5991607.27791 | 2110834.1835 | 37.775465002111396 | -122.472536046895 | (37.7754650021114, -122.472536046895) | |
| 44836 | 44836 | 62725 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 109 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/07/1986 12:00:00 AM | Permit Number 23071 | 6001085.93774818 | 2105743.30332199 | 37.7620307920739 | -122.439382183867 | (37.7620307920739, -122.439382183867) | ||
| 44975 | 44975 | 76336 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Townsend St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 8 | 6015855.31224 | 2112664.17743 | 37.7818634332888 | -122.388783363957 | (37.7818634332888, -122.388783363957) | ||
| 45407 | 45407 | 71779 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1062 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1995 12:00:00 AM | 15 | 6007509.77749 | 2115111.5712200003 | 37.7881173017281 | -122.417828646693 | (37.7881173017281, -122.417828646693) | ||
| 45603 | 45603 | 43411 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 536 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43154 | 6002822.07551999 | 2103890.28570644 | 37.757041500225895 | -122.433245151224 | (37.7570415002259, -122.433245151224) | ||
| 45867 | 45867 | 47065 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 608 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2008 12:00:00 AM | 7 | Permit Number 45052 | 6004036.92026 | 2110896.92583 | 37.7763488840161 | -122.42954343689699 | (37.7763488840161, -122.429543436897) | |
| 46341 | 46341 | 72457 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 539 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 13 | 6013447.28917 | 2112118.8251 | 37.780232263644294 | -122.397075813805 | (37.7802322636443, -122.397075813805) | ||
| 46435 | 46435 | 62419 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 709 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/17/1986 12:00:00 AM | 10 | Permit Number 22733 | 5991616.4924 | 2110573.10216 | 37.7747486770974 | -122.472485133995 | (37.7747486770974, -122.472485133995) | |
| 46522 | 46522 | 49604 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 374@ FOLSOM 11th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2003 12:00:00 AM | 7 | Permit Number 46472 | 6008794.40254 | 2108798.04692 | 37.7708540766855 | -122.41293748767599 | (37.7708540766855, -122.412937487676) | |
| 46724 | 46724 | 80810 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/2003 12:00:00 AM | 10 | 6015596.09754 | 2102496.67483 | 37.7539313187876 | -122.38897004433399 | (37.7539313187876, -122.388970044334) | ||
| 46728 | 46728 | 76328 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 753 Davis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 8 | 6013055.77037 | 2119154.1934700003 | 37.7995279331128 | -122.398924188599 | (37.7995279331128, -122.398924188599) | ||
| 46899 | 46899 | 75994 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 500 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1982 12:00:00 AM | 9 | 6007959.81163 | 2114150.16473 | 37.785502829521896 | -122.41620348452899 | (37.7855028295219, -122.416203484529) | ||
| 47051 | 47051 | 30518 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 409 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 5 | Permit Number 34527 | 6008424.27484 | 2113452.8519200003 | 37.7836142820115 | -122.41454721209 | (37.7836142820115, -122.41454721209) | |
| 47271 | 47271 | 69139 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 573 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/1994 12:00:00 AM | Permit Number 33171 | 6008555.67489002 | 2114162.36008798 | 37.7855698016133 | -122.4141428296 | (37.7855698016133, -122.4141428296) | ||
| 48384 | 48384 | 64139 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 523 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24910 | 6003239.38144538 | 2098311.93722578 | 37.7417483289476 | -122.43140374486299 | (37.7417483289476, -122.431403744863) | ||
| 48650 | 48650 | 32713 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1105 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 5 | Permit Number 37110 | 6007292.26872 | 2115149.22414 | 37.7882084444054 | -122.418583862255 | (37.7882084444054, -122.418583862255) |
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");