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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 185766 | 185766 | 228589 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2820 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008794.575180001 | 2106388.6841599997 | 37.764238535116206 | -122.41276652837401 | (37.7642385351162, -122.412766528374) | |||
| 185723 | 185723 | 202769 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 77 Long Bridge St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014575.89833 | 2109172.63741 | 37.7722054555392 | -122.392965215098 | (37.7722054555392, -122.392965215098) | |||
| 185711 | 185711 | 228784 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 20 Hickory St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006829.74541 | 2110663.1076599997 | 37.77586460991171 | -122.41986566058998 | (37.7758646099117, -122.41986566059) | |||
| 185672 | 185672 | 229070 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1425 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5998267.3386 | 2105513.86084 | 37.7612399939635 | -122.44911405249701 | (37.7612399939635, -122.449114052497) | |||
| 185664 | 185664 | 129908 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 65 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6001694.14605 | 2120844.10453 | 37.803528342422794 | -122.438360541313 | (37.8035283424228, -122.438360541313) | |||
| 185652 | 185652 | 102357 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3551 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/16/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769877 | 6000702.4264400005 | 2120580.06982 | 37.802746916103295 | -122.441773461287 | (37.8027469161033, -122.441773461287) |
| 185643 | 185643 | 130333 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 150 Lombard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011625.98867 | 2120823.31457 | 37.804031159681394 | -122.40398929806601 | (37.8040311596814, -122.403989298066) | |||
| 185642 | 185642 | 130017 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 488 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008520.4701 | 2113862.5861299997 | 37.7847447172366 | -122.414243411208 | (37.7847447172366, -122.414243411208) | |||
| 185635 | 185635 | 130078 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Van Ness Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6006636.458330001 | 2112607.58351 | 37.781192779173104 | -122.42067235963499 | (37.7811927791731, -122.420672359635) | |||
| 185631 | 185631 | 228598 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2130 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008719.47717 | 2105938.46018 | 37.7629981083047 | -122.412994436344 | (37.7629981083047, -122.412994436344) | |||
| 185615 | 185615 | 229016 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2900 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6009519.4903 | 2104549.01087 | 37.7592278723746 | -122.410129353684 | (37.7592278723746, -122.410129353684) | |||
| 185600 | 185600 | 130066 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 820 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6005746.45036 | 2112612.6258 | 37.7811564231596 | -122.42375170848699 | (37.7811564231596, -122.423751708487) | |||
| 185588 | 185588 | 208405 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 17 Santa Monica Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993430.6013400005 | 2097468.6651 | 37.73887212166029 | -122.46525774297301 | (37.7388721216603, -122.465257742973) | |||
| 185536 | 185536 | 228753 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 36 States St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6002041.28039 | 2106249.9304299997 | 37.763476187904296 | -122.43611428487199 | (37.7634761879043, -122.436114284872) | |||
| 185517 | 185517 | 200475 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1495 Tennessee St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6015666.49707 | 2102252.1345 | 37.7532637646194 | -122.388709514333 | (37.7532637646194, -122.388709514333) | |||
| 185487 | 185487 | 228626 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3926 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003423.4893 | 2105384.37737 | 37.76117801805871 | -122.431271881716 | (37.7611780180587, -122.431271881716) | |||
| 185425 | 185425 | 202424 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 120 Brannan St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6015792.05409 | 2113571.87018 | 37.784352246798 | -122.389065605418 | (37.784352246798, -122.389065605418) | |||
| 185400 | 185400 | 201155 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3450 03rd St | 8 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6016026.02144 | 2099329.8922 | 37.745259814586795 | -122.38726237027599 | (37.7452598145868, -122.387262370276) | |||
| 185377 | 185377 | 202402 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 427 Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6015305.1908599995 | 2114649.65643 | 37.787284602342 | -122.390825344821 | (37.787284602342, -122.390825344821) | |||
| 185368 | 185368 | 202374 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Spear St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6015354.42559 | 2115632.91412 | 37.7899871343417 | -122.39072374032 | (37.7899871343417, -122.39072374032) | |||
| 185335 | 185335 | 202409 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014816.592730001 | 2115071.66562 | 37.7884162210836 | -122.392545335093 | (37.7884162210836, -122.392545335093) | |||
| 185295 | 185295 | 192721 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1200 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017930.52005 | 2093957.2427700001 | 37.7306128747628 | -122.380303548475 | (37.7306128747628, -122.380303548475) | |||
| 185292 | 185292 | 75924 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 500 Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1982 12:00:00 AM | 17 | 6007948.10688 | 2114213.26854 | 37.785675439112396 | -122.416248450599 | (37.7856754391124, -122.416248450599) | ||
| 185219 | 185219 | 228715 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 37 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002859.5798 | 2108072.9095799997 | 37.7685281007225 | -122.433414330326 | (37.7685281007225, -122.433414330326) | |||
| 185107 | 185107 | 192513 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 560 Mission Bay Blvd North | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014659.7547 | 2108718.7787900004 | 37.770963918076404 | -122.39264339178301 | (37.7709639180764, -122.392643391783) | |||
| 185098 | 185098 | 129916 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 512 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004084.72879 | 2110562.0124 | 37.7754320009199 | -122.429354165577 | (37.7754320009199, -122.429354165577) | |||
| 185084 | 185084 | 202555 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Bluxome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6013779.77553 | 2111120.49842 | 37.777509588621 | -122.39585560737301 | (37.777509588621, -122.395855607373) | |||
| 185049 | 185049 | 192683 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6017532.94915 | 2095576.52883 | 37.7350371705259 | -122.381790607154 | (37.7350371705259, -122.381790607154) | |||
| 185019 | 185019 | 201059 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 501 Illinois St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015989.38827 | 2106628.51362 | 37.765298259327295 | -122.38789823233499 | (37.7652982593273, -122.387898232335) | |||
| 185003 | 185003 | 202520 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 41 Lansing St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6014454.63005 | 2114268.41989 | 37.78619058516529 | -122.39374143341699 | (37.7861905851653, -122.393741433417) | |||
| 184925 | 184925 | 249371 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 651 Jones St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008791.00522 | 2114822.15821 | 37.7873946631776 | -122.41337532982 | (37.7873946631776, -122.41337532982) | |||
| 184918 | 184918 | 228025 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 621 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006233.32164 | 2106033.04315 | 37.7631179375756 | -122.42159992849399 | (37.7631179375756, -122.421599928494) | |||
| 184885 | 184885 | 191612 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 202 Jessie St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011988.75206 | 2114601.1815400003 | 37.7869669339158 | -122.40229617864401 | (37.7869669339158, -122.402296178644) | |||
| 184829 | 184829 | 129866 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2150 North Point St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000402.94592 | 2120648.58524 | 37.8029179725475 | -122.442814735917 | (37.8029179725475, -122.442814735917) | |||
| 184810 | 184810 | 202716 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 415 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6014375.68893 | 2113000.2537599998 | 37.7827041042563 | -122.393925745878 | (37.7827041042563, -122.393925745878) | |||
| 184778 | 184778 | 201020 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2415 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6015834.180869999 | 2104378.6233200002 | 37.75911194438579 | -122.38827802503599 | (37.7591119443858, -122.388278025036) | |||
| 184758 | 184758 | 228983 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1300 San Jose Ave | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6003399.166619999 | 2095595.2622599998 | 37.734298015935295 | -122.430657448703 | (37.7342980159353, -122.430657448703) | ||||
| 184754 | 184754 | 75978 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 500 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1982 12:00:00 AM | 16 | 6007956.14824 | 2114165.5597099997 | 37.7855448944115 | -122.416217249547 | (37.7855448944115, -122.416217249547) | ||
| 184747 | 184747 | 192656 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Cashmere St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6016666.45643 | 2095945.35214 | 37.736002000097606 | -122.384812095401 | (37.7360020000976, -122.384812095401) | |||
| 184744 | 184744 | 208345 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3594 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5990578.14128 | 2092637.2329799999 | 37.7254413233411 | -122.474767578959 | (37.7254413233411, -122.474767578959) | |||
| 184719 | 184719 | 228686 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 72 Hattie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000606.2014 | 2105304.5578400004 | 37.760798791952205 | -122.44100992426701 | (37.7607987919522, -122.441009924267) | |||
| 184694 | 184694 | 246832 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 200 Baker St | 4 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6000792.448369999 | 2109807.86593 | 37.7731743635249 | -122.44068880603999 | (37.7731743635249, -122.44068880604) | |||
| 184680 | 184680 | 208194 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 338 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 5992905.17714 | 2102566.7418400003 | 37.7528398269164 | -122.46744502009399 | (37.7528398269164, -122.467445020094) | |||
| 184677 | 184677 | 201102 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 199 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6010597.07336 | 2107530.66905 | 37.7674751717804 | -122.406612651066 | (37.7674751717804, -122.406612651066) | |||
| 184657 | 184657 | 130148 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 399 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6005992.302080001 | 2111377.41632 | 37.7777787143452 | -122.422813372063 | (37.7777787143452, -122.422813372063) | |||
| 184562 | 184562 | 228577 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3132 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007388.02772 | 2103845.9473099997 | 37.7571777211942 | -122.417451170662 | (37.7571777211942, -122.417451170662) | |||
| 184528 | 184528 | 228758 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 46 States St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6001976.01738 | 2106245.24414 | 37.7634596124877 | -122.43633967294 | (37.7634596124877, -122.43633967294) | |||
| 184526 | 184526 | 129991 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1020 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6005653.153940001 | 2113299.68835 | 37.7830376609932 | -122.42412334433 | (37.7830376609932, -122.42412334433) | |||
| 184509 | 184509 | 130300 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 815 Battery St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6012386.58963 | 2118971.9326 | 37.798990178098 | -122.401226993538 | (37.798990178098, -122.401226993538) | |||
| 184494 | 184494 | 208460 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5998994.59253 | 2097295.1297 | 37.738714930956704 | -122.446007644855 | (37.7387149309567, -122.446007644855) | |||
| 184417 | 184417 | 33857 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 757 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 13 | Permit Number 37855 | 6014476.109730001 | 2103508.37921 | 37.7566470977886 | -122.39291403375499 | (37.7566470977886, -122.392914033755) | |
| 184413 | 184413 | 191611 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 75 01st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6013242.23758 | 2115774.13253 | 37.790257474145 | -122.398041690185 | (37.790257474145, -122.398041690185) | |||
| 184374 | 184374 | 92892 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 642 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6013735.378 | 2113344.3843 | 37.7836134015686 | -122.396165091043 | (37.7836134015686, -122.396165091043) | |||
| 184349 | 184349 | 130405 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 502 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012102.526000001 | 2117469.9807599997 | 37.7948503271223 | -122.40210430559401 | (37.7948503271223, -122.402104305594) | |||
| 184346 | 184346 | 202491 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 87 Townsend St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6015462.64565 | 2112286.54201 | 37.780804760374295 | -122.39011542988001 | (37.7808047603743, -122.39011542988) | |||
| 184328 | 184328 | 228610 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2001 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008738.30789 | 2106670.03017 | 37.7650078880392 | -122.412981035564 | (37.7650078880392, -122.412981035564) | |||
| 184284 | 184284 | 130259 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 501 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6007382.90307 | 2122272.11478 | 37.8077712206334 | -122.41877563011101 | (37.8077712206334, -122.418775630111) | |||
| 184191 | 184191 | 208325 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 230 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5994700.197380001 | 2088418.89135 | 37.7140967660267 | -122.460212618242 | (37.7140967660267, -122.460212618242) | |||
| 184161 | 184161 | 201131 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1301 Cesar Chavez St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014896.91206 | 2101063.92865 | 37.7499585204909 | -122.39128786525299 | (37.7499585204909, -122.391287865253) | |||
| 184145 | 184145 | 228169 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 712 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007884.413380001 | 2097705.90914 | 37.7403464729105 | -122.41529982501999 | (37.7403464729105, -122.41529982502) | |||
| 184123 | 184123 | 92893 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 642 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6013727.291259999 | 2113337.6212400002 | 37.7835943818045 | -122.39619259412599 | (37.7835943818045, -122.396192594126) | |||
| 184104 | 184104 | 33333 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3042 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/2006 12:00:00 AM | 8 | Permit Number 48741 | 6004278.25254 | 2119648.85188 | 37.8003931295033 | -122.429332840858 | (37.8003931295033, -122.429332840858) | |
| 184078 | 184078 | 228772 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 201 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006402.31382 | 2110745.78275 | 37.7760675266195 | -122.42135013101002 | (37.7760675266195, -122.42135013101) | |||
| 184075 | 184075 | 208448 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 79 Dorado Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 5994592.569569999 | 2093111.8186299999 | 37.726976229566205 | -122.46092454135 | (37.7269762295662, -122.46092454135) | |||
| 184072 | 184072 | 229166 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1369 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006475.81783 | 2101605.35927 | 37.7509742139056 | -122.42044691578998 | (37.7509742139056, -122.42044691579) | |||
| 184061 | 184061 | 228861 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 280 Valencia St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6006057.3965 | 2107996.75615 | 37.76849990698 | -122.422347927012 | (37.76849990698, -122.422347927012) | |||
| 184034 | 184034 | 228773 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 201 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6006414.99756 | 2110745.52232 | 37.77606752663979 | -122.421306236009 | (37.7760675266398, -122.421306236009) | |||
| 184030 | 184030 | 130313 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009225.50566 | 2121536.68624 | 37.8058554919917 | -122.412346817477 | (37.8058554919917, -122.412346817477) | |||
| 183972 | 183972 | 130277 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 500 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007637.996780001 | 2122009.8332599998 | 37.807065421886 | -122.41787420993099 | (37.807065421886, -122.417874209931) | |||
| 183964 | 183964 | 228178 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 131 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007747.837590001 | 2107196.4501099996 | 37.7663976652576 | -122.416444126014 | (37.7663976652576, -122.416444126014) | |||
| 183938 | 183938 | 228569 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 508 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006139.40955 | 2106596.9487 | 37.7646609934284 | -122.421964799655 | (37.7646609934284, -122.421964799655) | |||
| 183919 | 183919 | 228677 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 190 Storrie St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 3ft | 6000787.94516 | 2105321.30732 | 37.7608551317704 | -122.44038255632 | (37.7608551317704, -122.44038255632) | |||
| 183915 | 183915 | 208239 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 40 Santa Monica Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993602.68671 | 2097407.79413 | 37.738714907574604 | -122.464658337632 | (37.7387149075746, -122.464658337632) | |||
| 183888 | 183888 | 110750 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1155 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 7 | 50109 | 6009522.08219 | 2110985.7839099998 | 37.7769019113319 | -122.41057493088199 | (37.7769019113319, -122.410574930882) | ||
| 183879 | 183879 | 208200 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 141 San Benito Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5992880.92249 | 2095766.2437900002 | 37.7341659846737 | -122.467034523631 | (37.7341659846737, -122.467034523631) | |||
| 183867 | 183867 | 111189 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 8 10th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x6 | 6007707.06136 | 2110648.86423 | 37.7758748864569 | -122.416829782278 | (37.7758748864569, -122.416829782278) | |||
| 183806 | 183806 | 130201 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1200 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009429.74314 | 2117502.72379 | 37.7947906877019 | -122.411354860739 | (37.7947906877019, -122.411354860739) | |||
| 183802 | 183802 | 201123 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3305 03rd St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016087.07184 | 2099842.99163 | 37.7466720604868 | -122.38708704742399 | (37.7466720604868, -122.387087047424) | |||
| 183746 | 183746 | 202382 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 304 Spear St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015836.791619999 | 2115035.51841 | 37.7883735725194 | -122.38901305353201 | (37.7883735725194, -122.389013053532) | |||
| 183615 | 183615 | 130178 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 100 Fell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006688.806419999 | 2110839.1222900003 | 37.7763399627555 | -122.420365701616 | (37.7763399627555, -122.420365701616) | |||
| 183589 | 183589 | 228878 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 317 Buchanan St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6004644.5004900005 | 2109700.89583 | 37.7730992602639 | -122.427356425982 | (37.7730992602639, -122.427356425982) | |||
| 183457 | 183457 | 200425 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2833 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6015964.97782 | 2102366.8244 | 37.7535952169477 | -122.387685298953 | (37.7535952169477, -122.387685298953) | |||
| 183365 | 183365 | 129966 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1005 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6007337.22214 | 2114824.39315 | 37.7873190688613 | -122.418405289284 | (37.7873190688613, -122.418405289284) | |||
| 183338 | 183338 | 35034 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 403 Main St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/1998 12:00:00 AM | 13 | Permit Number 38603 | 6015612.4311 | 2114850.7115599997 | 37.7878536960372 | -122.38977639806801 | (37.7878536960372, -122.389776398068) | ||
| 183322 | 183322 | 208353 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 5000 19th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5990626.636469999 | 2093347.4472599998 | 37.727394203873 | -122.474651748098 | (37.727394203873, -122.474651748098) | |||
| 183283 | 183283 | 228150 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 298 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006255.81001 | 2098299.6746900002 | 37.74188515358411 | -122.420973046186 | (37.7418851535841, -122.420973046186) | |||
| 183198 | 183198 | 129895 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Cherry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5996272.40169 | 2114646.25643 | 37.786200864412706 | -122.456674122309 | (37.7862008644127, -122.456674122309) | |||
| 183169 | 183169 | 130229 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1541 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006183.93008 | 2118283.97946 | 37.7967532386312 | -122.422641382112 | (37.7967532386312, -122.422641382112) | |||
| 183139 | 183139 | 123778 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1099 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992301.31875 | 2110654.6770900004 | 37.775012273795 | -122.470122142574 | (37.775012273795, -122.470122142574) | |||
| 183071 | 183071 | 129986 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 355 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008451.705569999 | 2113763.66062 | 37.7844692288282 | -122.414474312134 | (37.7844692288282, -122.414474312134) | |||
| 183017 | 183017 | 192713 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1241 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6017134.34835 | 2093897.4434200001 | 37.7304047158846 | -122.38305190094401 | (37.7304047158846, -122.383051900944) | |||
| 182978 | 182978 | 229108 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1381 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6007750.358469999 | 2101656.23053 | 37.7511856373284 | -122.416043019385 | (37.7511856373284, -122.416043019385) | |||
| 182954 | 182954 | 202646 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1735 Alameda St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6011282.956669999 | 2107891.8278799998 | 37.7685051814939 | -122.404265682213 | (37.7685051814939, -122.404265682213) | |||
| 182945 | 182945 | 200414 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1020 Minna St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6007716.757230001 | 2109893.6357299997 | 37.7738017539805 | -122.41674272608999 | (37.7738017539805, -122.41674272609) | |||
| 182935 | 182935 | 202667 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 218 De Haro St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011931.6063 | 2107639.73611 | 37.7678492186945 | -122.40200432166701 | (37.7678492186945, -122.402004321667) | |||
| 182914 | 182914 | 201399 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1051 Ingalls St | 11 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6018101.39877 | 2094718.1086 | 37.732711490446206 | -122.3797656316 | (37.7327114904462, -122.3797656316) | |||
| 182913 | 182913 | 228036 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3225 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006862.04153 | 2103190.1661900003 | 37.7553474883977 | -122.41922372091001 | (37.7553474883977, -122.41922372091) | |||
| 182909 | 182909 | 208283 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 5995702.361819999 | 2098208.0995400003 | 37.74103317363429 | -122.45745658465401 | (37.7410331736343, -122.457456584654) | |||
| 182877 | 182877 | 130101 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 151 Leavenworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6008550.81103 | 2113028.3188099996 | 37.7824557240915 | -122.414079400045 | (37.7824557240915, -122.414079400045) | |||
| 182852 | 182852 | 208214 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1600x Portola Dr | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 5992270.30355 | 2096715.89094 | 37.7367382129937 | -122.46921470239599 | (37.7367382129937, -122.469214702396) |
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");