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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 110396 | 110396 | 116525 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 371 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5988056.07752 | 2113501.1512599997 | 37.7825815558183 | -122.485016050979 | (37.7825815558183, -122.485016050979) | |||
| 98466 | 98466 | 102722 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 375 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5988056.70632 | 2113482.94478 | 37.7825316026095 | -122.485012539451 | (37.7825316026095, -122.485012539451) | |||
| 83370 | 83370 | 115588 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2574 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 5987741.7 | 2097778.5 | 37.739393135719105 | -122.484949795247 | (37.7393931357191, -122.484949795247) | |||
| 100963 | 100963 | 31495 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2303 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1985 12:00:00 AM | Permit Number 35057 | 5988337.12371134 | 2114638.53030717 | 37.7857208424063 | -122.48412719950001 | (37.7857208424063, -122.4841271995) | ||
| 115708 | 115708 | 31494 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2303 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1985 12:00:00 AM | Permit Number 35057 | 5988337.12371134 | 2114638.53030717 | 37.7857208424063 | -122.48412719950001 | (37.7857208424063, -122.4841271995) | ||
| 56637 | 56637 | 120296 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 251 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5988341.26351 | 2114368.41525 | 37.784979424246394 | -122.48409306168101 | (37.7849794242464, -122.484093061681) | |||
| 56658 | 56658 | 120297 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 251 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5988342.527980001 | 2114355.8487 | 37.78494499368679 | -122.48408776520901 | (37.7849449936868, -122.484087765209) | |||
| 66123 | 66123 | 120299 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 251 24th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5988342.23164 | 2114313.46332 | 37.7848285982154 | -122.48408568111799 | (37.7848285982154, -122.484085681118) | |||
| 170966 | 170966 | 120298 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 251 24th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5988342.89023 | 2114335.04494 | 37.784887893559606 | -122.48408498582701 | (37.7848878935596, -122.484084985827) | |||
| 158922 | 158922 | 120300 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 251 24th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5988342.8496199995 | 2114295.25375 | 37.7847786358849 | -122.48408220731501 | (37.7847786358849, -122.484082207315) | |||
| 74385 | 74385 | 120301 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 251 24th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5988343.7445 | 2114280.6375700003 | 37.7847385561038 | -122.484078039151 | (37.7847385561038, -122.484078039151) | |||
| 132289 | 132289 | 62216 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 275 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1985 12:00:00 AM | 13 | Permit Number 22339 | 5988348.592569999 | 2114168.35653 | 37.78443054648461 | -122.48405303004499 | (37.7844305464846, -122.484053030045) | |
| 151941 | 151941 | 72086 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 287 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1985 12:00:00 AM | 17 | 5988351.63673 | 2114094.1060200003 | 37.784226852873104 | -122.48403705170799 | (37.7842268528731, -122.484037051708) | ||
| 149215 | 149215 | 72082 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 246 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1985 12:00:00 AM | 18 | 5988387.30119 | 2114347.80064 | 37.784925502609994 | -122.483932275813 | (37.78492550261, -122.483932275813) | ||
| 49708 | 49708 | 72083 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 258 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1985 12:00:00 AM | 14 | 5988389.53404 | 2114272.5728700003 | 37.784719078490895 | -122.48391903284599 | (37.7847190784909, -122.483919032846) | ||
| 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) | ||
| 71752 | 71752 | 62214 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 266 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1985 12:00:00 AM | 17 | Permit Number 22337 | 5988393.1262 | 2114211.2935200003 | 37.7845510318996 | -122.483902110393 | (37.7845510318996, -122.483902110393) | |
| 143259 | 143259 | 477 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2250X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/24/2014 12:00:00 AM | 3 | 5 | 5988503.27356 | 2114693.97925 | 37.7858827615482 | -122.483556441897 | (37.7858827615482, -122.483556441897) | ||
| 109732 | 109732 | 12829 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2224 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2013 12:00:00 AM | 3 | 5x3 | 5988535.80746 | 2114700.2042099996 | 37.7859017470948 | -122.483444341492 | (37.7859017470948, -122.483444341492) | ||
| 144174 | 144174 | 12828 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2218 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2013 12:00:00 AM | 3 | 3x3 | 5988557.29084 | 2114700.7549 | 37.7859045094744 | -122.483370056215 | (37.7859045094744, -122.483370056215) | ||
| 79093 | 79093 | 38875 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1901 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/2003 12:00:00 AM | Permit Number 46314 | 5988391.39591113 | 2104399.73946123 | 37.7576111203086 | -122.48318866650499 | (37.7576111203086, -122.483188666505) | ||
| 83158 | 83158 | 49312 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1901 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | Permit Number 46314 | 5988391.39591113 | 2104399.73946123 | 37.7576111203086 | -122.48318866650499 | (37.7576111203086, -122.483188666505) | |||
| 70417 | 70417 | 177219 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988139.55796 | 2089802.05972 | 37.7175150450661 | -122.48298973781 | (37.7175150450661, -122.48298973781) | ||||
| 80957 | 80957 | 43800 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 374 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | Permit Number 45517 | 5988757.1951541 | 2112799.72616617 | 37.780696453390895 | -122.482539101317 | (37.7806964533909, -122.482539101317) | ||
| 116447 | 116447 | 114366 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 839 GONZALEZ DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5988367.0 | 2089770.0 | 37.7174402490935 | -122.482201236859 | (37.7174402490935, -122.482201236859) | ||||
| 117151 | 117151 | 12807 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2100X Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2003 12:00:00 AM | 20 | 5 | 5988897.58667 | 2114714.2968599997 | 37.785961490964496 | -122.482193733009 | (37.7859614909645, -122.482193733009) | ||
| 124240 | 124240 | 12806 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2100X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/24/2014 12:00:00 AM | 3 | 5 | 5988917.68392 | 2114715.00312 | 37.7859645990864 | -122.4821242546 | (37.7859645990864, -122.4821242546) | ||
| 58776 | 58776 | 72337 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 796 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 10 | 5988859.60272 | 2109927.01745 | 37.7728147529064 | -122.481974327583 | (37.7728147529064, -122.481974327583) | ||
| 115009 | 115009 | 12797 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2026 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/02/1997 12:00:00 AM | 12 | 3X3 | 5989130.05686 | 2114725.3406 | 37.7860053327892 | -122.481390268149 | (37.7860053327892, -122.481390268149) | ||
| 77525 | 77525 | 12793 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2022 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/1995 12:00:00 AM | 30 | 3X3 | 5989145.28019 | 2114725.01824 | 37.786005332771 | -122.48133757655701 | (37.786005332771, -122.481337576557) | ||
| 80596 | 80596 | 45384 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | ||||
| 82825 | 82825 | 45388 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | ||||
| 97324 | 97324 | 45386 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | ||||
| 113309 | 113309 | 45387 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | ||||
| 124016 | 124016 | 45381 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | ||||
| 139690 | 139690 | 45385 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | ||||
| 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) | ||
| 51076 | 51076 | 177220 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5989003.1682400005 | 2089530.2906900002 | 37.7168190498446 | -122.47998478988801 | (37.7168190498446, -122.479984789888) | ||||
| 60826 | 60826 | 62987 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 139 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1994 12:00:00 AM | 11 | Permit Number 23387 | 5989577.1157 | 2114447.52745 | 37.785268518536796 | -122.479823246943 | (37.7852685185368, -122.479823246943) | |
| 179200 | 179200 | 120816 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 139 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 5989577.31882 | 2114430.25196 | 37.7852210967041 | -122.47982127963499 | (37.7852210967041, -122.479821279635) | |||
| 163350 | 163350 | 61498 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 143 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1984 12:00:00 AM | 9 | Permit Number 21449 | 5989578.4132 | 2114401.3487400003 | 37.78514180017461 | -122.47981537772301 | (37.7851418001746, -122.479815377723) | |
| 130895 | 130895 | 70147 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2927 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 10 | 5989529.51616 | 2111917.79074 | 37.7783198039619 | -122.479802747413 | (37.7783198039619, -122.479802747413) | ||
| 120782 | 120782 | 12776 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1845 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/1990 12:00:00 AM | 40 | 3X3 | 5989688.1607800005 | 2114688.0112400004 | 37.7859352699138 | -122.47945666963601 | (37.7859352699138, -122.479456669636) | ||
| 152141 | 152141 | 177221 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989179.19874 | 2089367.33922 | 37.7163818516244 | -122.479364431248 | (37.7163818516244, -122.479364431248) | ||||
| 129048 | 129048 | 12772 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1835 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2010 12:00:00 AM | 3 | 3X3 | 5989714.94854 | 2114687.4445700003 | 37.785935269914496 | -122.479363950909 | (37.7859352699145, -122.479363950909) | ||
| 29386 | 29386 | 177222 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5989183.517969999 | 2089355.54971 | 37.7163497314364 | -122.479348640047 | (37.7163497314364, -122.479348640047) | ||||
| 83807 | 83807 | 12769 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1824 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2000 12:00:00 AM | 25 | 3X3 | 5989722.2865699995 | 2114743.49149 | 37.7860895851796 | -122.479342665361 | (37.7860895851796, -122.479342665361) | ||
| 179243 | 179243 | 177223 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5989192.47222 | 2089346.91127 | 37.7163265325079 | -122.47931705855 | (37.7163265325079, -122.47931705855) | ||||
| 48772 | 48772 | 49873 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1721@ 21st AVE Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2003 12:00:00 AM | 0 | Permit Number 46641 | 5989549.03002443 | 2105119.85153385 | 37.7596556546053 | -122.47923781968399 | (37.7596556546053, -122.479237819684) | |
| 90367 | 90367 | 65091 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1830 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1989 12:00:00 AM | Permit Number 27056 | 5989804.11356074 | 2114740.85049779 | 37.786087086023706 | -122.479059375757 | (37.7860870860237, -122.479059375757) | ||
| 176115 | 176115 | 177224 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5989267.30759 | 2089305.68388 | 37.716217678587704 | -122.47905538010401 | (37.7162176785877, -122.479055380104) | ||||
| 46185 | 46185 | 121812 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 154 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5989933.15356 | 2114449.74425 | 37.7852952829234 | -122.478591640538 | (37.7852952829234, -122.478591640538) | |||
| 158453 | 158453 | 121813 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 154 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5989936.15799 | 2114430.0214299997 | 37.7852413040302 | -122.47857980341401 | (37.7852413040302, -122.478579803414) | |||
| 31471 | 31471 | 121814 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 154 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5989936.87518 | 2114412.4385 | 37.785193067878794 | -122.47857603590599 | (37.7851930678788, -122.478576035906) | |||
| 54647 | 54647 | 121817 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 154 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5989939.26951 | 2114350.5757 | 37.7850233490015 | -122.47856322681801 | (37.7850233490015, -122.478563226818) | |||
| 24968 | 24968 | 121818 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 154 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5989940.09904 | 2114328.00207 | 37.784961416308 | -122.478558705586 | (37.784961416308, -122.478558705586) | |||
| 139798 | 139798 | 12759 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1740 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/1996 12:00:00 AM | 3 | 3X3 | 5989949.26559 | 2114751.4672 | 37.7861246648237 | -122.478557970773 | (37.7861246648237, -122.478557970773) | ||
| 115240 | 115240 | 12760 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1740 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/17/2003 12:00:00 AM | 9 | 3X3 | 5989961.92897 | 2114768.04375 | 37.7861709145741 | -122.47851537196001 | (37.7861709145741, -122.47851537196) | ||
| 136838 | 136838 | 104722 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Garces Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 770294 | 5989426.465469999 | 2089157.7784799999 | 37.7158208086468 | -122.478494450472 | (37.7158208086468, -122.478494450472) | |||
| 120568 | 120568 | 12758 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1740 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2004 12:00:00 AM | 8 | 3x3 | 5989980.802630001 | 2114752.5247299997 | 37.78612939943471 | -122.478448939556 | (37.7861293994347, -122.478448939556) | ||
| 103365 | 103365 | 12756 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1738 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/1996 12:00:00 AM | 12 | 3X3 | 5990012.642419999 | 2114751.50661 | 37.786128452368295 | -122.47833870907499 | (37.7861284523683, -122.478338709075) | ||
| 91875 | 91875 | 12745 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1650 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2000 12:00:00 AM | 12 | 27x4 | 5990264.89621 | 2114778.94563 | 37.786218432750296 | -122.47746799357 | (37.7862184327503, -122.47746799357) | ||
| 69891 | 69891 | 12723 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1538 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/08/2012 12:00:00 AM | 3 | 3x3 | 5990625.74037 | 2114773.38232 | 37.786224089243206 | -122.476219173709 | (37.7862240892432, -122.476219173709) | ||
| 164700 | 164700 | 122081 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 419 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990579.84035 | 2112499.16315 | 37.7799770543185 | -122.476211800327 | (37.7799770543185, -122.476211800327) | |||
| 121916 | 121916 | 12722 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1536 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1990 12:00:00 AM | 13 | 3X3 | 5990660.75385 | 2114775.05706 | 37.7862307179629 | -122.476098159844 | (37.7862307179629, -122.476098159844) | ||
| 114483 | 114483 | 12719 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1522 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5990686.46435 | 2114778.99732 | 37.786243027629396 | -122.476009497029 | (37.7862430276294, -122.476009497029) | |||
| 142882 | 142882 | 12720 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1523 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5990697.01836 | 2114721.1819 | 37.786084894599 | -122.475968759315 | (37.786084894599, -122.475968759315) | |||
| 138538 | 138538 | 12718 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1516 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/2003 12:00:00 AM | 10 | 3X3 | 5990720.064069999 | 2114779.3223 | 37.78624586810071 | -122.475893275697 | (37.7862458681007, -122.475893275697) | ||
| 52555 | 52555 | 37622 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 675 17th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 4 | Permit Number 40046 | 5990642.23762 | 2110786.10945 | 37.7752770986592 | -122.475870804319 | (37.7752770986592, -122.475870804319) | ||
| 151313 | 151313 | 122088 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 675 17th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 5990644.01594 | 2110748.8080700003 | 37.7751747823996 | -122.475861928095 | (37.7751747823996, -122.475861928095) | |||
| 103573 | 103573 | 36123 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1382 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2005 12:00:00 AM | Permit Number 45475 | 5990544.53201136 | 2105986.36930627 | 37.7620926477181 | -122.47585819144899 | (37.7620926477181, -122.475858191449) | ||
| 36338 | 36338 | 208195 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1125 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 5990483.84963 | 2103108.20928 | 37.7541864672384 | -122.475857869365 | (37.7541864672384, -122.475857869365) | |||
| 169698 | 169698 | 75198 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 675 17th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1997 12:00:00 AM | 7 | 5990644.77295 | 2110703.6496599996 | 37.7750508336714 | -122.475856010882 | (37.7750508336714, -122.475856010882) | ||
| 53788 | 53788 | 67393 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 723 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1992 12:00:00 AM | Permit Number 30890 | 5990653.53990007 | 2110457.0289972 | 37.774374189154294 | -122.475807670593 | (37.7743741891543, -122.475807670593) | ||
| 161210 | 161210 | 122247 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 47 Lake St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 4ft | 5990771.99578 | 2114778.5706599997 | 37.7862468151678 | -122.475713552448 | (37.7862468151678, -122.475713552448) | |||
| 78644 | 78644 | 12717 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1500X Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/08/1994 12:00:00 AM | 65 | 3x3 | 5990792.41803 | 2114766.86784 | 37.786215866445495 | -122.475642042646 | (37.7862158664455, -122.475642042646) | ||
| 112777 | 112777 | 68630 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1723 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32535 | 5990571.47036723 | 2103657.89182142 | 37.7557008300619 | -122.47559499297701 | (37.7557008300619, -122.475594992977) | ||
| 116148 | 116148 | 68631 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1727 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32536 | 5990572.37020858 | 2103631.76860623 | 37.7556291547891 | -122.47558997367202 | (37.7556291547891, -122.475589973672) | ||
| 110494 | 110494 | 68632 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1745 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32537 | 5990576.41949486 | 2103514.21413179 | 37.755306616031 | -122.475567386919 | (37.755306616031, -122.475567386919) | ||
| 123084 | 123084 | 68651 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1201 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32556 | 5990583.86142611 | 2103796.60254924 | 37.7560824113328 | -122.47556226909599 | (37.7560824113328, -122.475562269096) | ||
| 116769 | 116769 | 68633 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1757 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32538 | 5990579.11901849 | 2103435.84449843 | 37.7550915902247 | -122.47555232919599 | (37.7550915902247, -122.475552329196) | ||
| 94293 | 94293 | 68634 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1759 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32539 | 5990579.56893937 | 2103422.78288473 | 37.755055752567 | -122.475549819582 | (37.755055752567, -122.475549819582) | ||
| 115061 | 115061 | 68638 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1779 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32543 | 5990584.0681457 | 2103292.16682101 | 37.7546973761762 | -122.47552472359301 | (37.7546973761762, -122.475524723593) | ||
| 99833 | 99833 | 27534 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3721X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2000 12:00:00 AM | 18 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | ||
| 123966 | 123966 | 68635 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1762 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32540 | 5990632.43795796 | 2103398.44981419 | 37.754992005066796 | -122.475365208722 | (37.7549920050668, -122.475365208722) | ||
| 134022 | 134022 | 49300 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 148 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | 8 | Permit Number 46309 | 5990866.53152 | 2114436.55853 | 37.7853132254981 | -122.475361507174 | (37.7853132254981, -122.475361507174) | ||
| 91324 | 91324 | 68636 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1766 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32541 | 5990633.33779973 | 2103372.3265868 | 37.754920329742 | -122.475360189684 | (37.754920329742, -122.475360189684) | ||
| 82197 | 82197 | 68637 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1770 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32542 | 5990634.2376415 | 2103346.20335941 | 37.7548486544161 | -122.47535517065599 | (37.7548486544161, -122.475355170656) | ||
| 119519 | 119519 | 68639 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1800 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32544 | 5990641.93379117 | 2103122.53441302 | 37.754234964606106 | -122.475312226686 | (37.7542349646061, -122.475312226686) | ||
| 128739 | 128739 | 68650 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1979 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32555 | 5990630.42882931 | 2101932.6813693 | 37.7509672741353 | -122.475265151572 | (37.7509672741353, -122.475265151572) | ||
| 126301 | 126301 | 68641 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1862 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32546 | 5990655.67709974 | 2102718.74378804 | 37.7531270585087 | -122.475235222283 | (37.7531270585087, -122.475235222283) | ||
| 98551 | 98551 | 68642 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1866 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32547 | 5990656.56376524 | 2102692.69276741 | 37.7530555806526 | -122.475230254333 | (37.7530555806526, -122.475230254333) | ||
| 82385 | 82385 | 68646 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1930 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32551 | 5990671.72018063 | 2102247.71531868 | 37.7518346679739 | -122.47514535924999 | (37.7518346679739, -122.47514535925) | ||
| 92889 | 92889 | 104953 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 113878 | 113878 | 104954 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 138275 | 138275 | 104955 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 97098 | 97098 | 87588 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3690X 19th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 5990484.73648 | 2091103.44002 | 37.721224497411704 | -122.474978557179 | (37.7212244974117, -122.474978557179) | ||||
| 106626 | 106626 | 87587 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3690X 19th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 5990484.73648 | 2091103.44002 | 37.721224497411704 | -122.474978557179 | (37.7212244974117, -122.474978557179) | |||
| 170267 | 170267 | 208330 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3698 19th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5990493.99716 | 2091321.1364099998 | 37.7218227742729 | -122.474962428782 | (37.7218227742729, -122.474962428782) | |||
| 85494 | 85494 | 361 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3690X 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/12/1994 12:00:00 AM | 20 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) |
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");