Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3796 | 3796 | 182316 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2726 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2001 12:00:00 AM | 3 | Width 0ft | Permit Number 43905 | 5986380.5744 | 2105064.6172 | 37.759319468361 | -122.490191716108 | (37.759319468361, -122.490191716108) | |
| 4156 | 4156 | 213178 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 629 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 08:23:00 AM | 3 | Width 3ft | Permit Number 20774 | 5994856.22066 | 2090552.89382 | 37.7199652039099 | -122.45982783161502 | (37.7199652039099, -122.459827831615) | |
| 4201 | 4201 | 252891 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:13:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4203 | 4203 | 252894 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:10:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4212 | 4212 | 204652 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 324 Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:45:00 PM | 3 | Width 3ft | 5997137.29551 | 2090290.56774 | 37.719375836806705 | -122.45192406695601 | (37.7193758368067, -122.451924066956) | ||
| 4213 | 4213 | 252892 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:08:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4246 | 4246 | 252893 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:25:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4291 | 4291 | 252895 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 790x Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:29:00 PM | 3 | 3x3 | 5997282.0 | 2090432.0 | 37.719772464034904 | -122.45143407539 | (37.7197724640349, -122.45143407539) | ||
| 4444 | 4444 | 24256 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 203 Willow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2014 12:00:00 AM | 3 | 2x3 | 6006439.8092 | 2113362.67149 | 37.783254981274204 | -122.421406308981 | (37.7832549812742, -122.421406308981) | ||
| 4793 | 4793 | 12272 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 700X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/1997 12:00:00 AM | 3 | 3X3 | 6004950.3992 | 2111308.9655 | 37.7775319231116 | -122.426412801229 | (37.7775319231116, -122.426412801229) | ||
| 5538 | 5538 | 27609 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2695 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2000 12:00:00 AM | 3 | 3x3 | 6001941.56922 | 2115683.47507 | 37.7893726707572 | -122.437134613375 | (37.7893726707572, -122.437134613375) | ||
| 7463 | 7463 | 52815 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2760 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773616 | 6000112.35725 | 2118047.78661 | 37.7957603016641 | -122.44363337348999 | (37.7957603016641, -122.44363337349) | |
| 9115 | 9115 | 90912 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 545 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5993886.17439 | 2110710.21085 | 37.775256248873895 | -122.464643860229 | (37.7752562488739, -122.464643860229) | ||
| 10007 | 10007 | 99273 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2825 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | DPW for City Agency 2 | 02/01/2013 12:00:00 AM | 3 | 3x3 | 6002499.0 | 2095479.8 | 37.733929944538204 | -122.43376136145201 | (37.7339299445382, -122.433761361452) | |
| 10380 | 10380 | 27204 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 6003546.09454 | 2093473.22062 | 37.728479690960796 | -122.429998148515 | (37.7284796909608, -122.429998148515) | ||
| 10673 | 10673 | 121353 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1221 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2016 12:00:00 AM | 3 | 3x3 | 5984567.3281 | 2106871.8527 | 37.76417557031971 | -122.496596073864 | (37.7641755703197, -122.496596073864) | ||
| 10789 | 10789 | 27116 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 431 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2000 12:00:00 AM | 3 | 3X3 | 6004280.51311 | 2093512.4294900002 | 37.7286289154695 | -122.42746201715599 | (37.7286289154695, -122.427462017156) | ||
| 10857 | 10857 | 27206 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/28/2012 12:00:00 AM | 3 | 3X3 | 6003601.03384 | 2093471.82188 | 37.7284789616114 | -122.429808120849 | (37.7284789616114, -122.429808120849) | ||
| 10985 | 10985 | 27196 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2001 12:00:00 AM | 3 | 3X3 | 6003338.54684 | 2093501.7358400002 | 37.7285462309168 | -122.430717685294 | (37.7285462309168, -122.430717685294) | ||
| 11092 | 11092 | 27197 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 3 | 3X3 | 6003357.925480001 | 2093496.2985900003 | 37.72853239932861 | -122.43065030447501 | (37.7285323993286, -122.430650304475) | ||
| 11230 | 11230 | 27210 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2000 12:00:00 AM | 3 | 3X3 | 6003698.299930001 | 2093465.5644 | 37.728467287514206 | -122.42947142096901 | (37.7284672875142, -122.429471420969) | ||
| 11300 | 11300 | 26996 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1239 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2000 12:00:00 AM | 3 | 3X3 | 6008815.333330001 | 2094106.20179 | 37.730514731765396 | -122.41182676109399 | (37.7305147317654, -122.411826761094) | ||
| 11345 | 11345 | 27198 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 3 | 3X3 | 6003379.2285400005 | 2093490.3772 | 37.7285173473825 | -122.43057623633001 | (37.7285173473825, -122.43057623633) | ||
| 11557 | 11557 | 27528 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1136 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/25/2002 12:00:00 AM | 3 | 6008310.55132 | 2093825.05625 | 37.729714434952506 | -122.413551995327 | (37.7297144349525, -122.413551995327) | |||
| 11632 | 11632 | 27199 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 3 | 3X3 | 6003401.87305 | 2093484.5761900002 | 37.7285027019175 | -122.43049753933998 | (37.7285027019175, -122.43049753934) | ||
| 12234 | 12234 | 27239 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 267 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/2004 12:00:00 AM | 3 | 3X3 | 6002994.26296 | 2093731.2602 | 37.7291569416186 | -122.431924275083 | (37.7291569416186, -122.431924275083) | ||
| 12322 | 12322 | 27195 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2001 12:00:00 AM | 3 | 3X3 | 6003315.89626 | 2093507.2409400002 | 37.728560063388294 | -122.430796382249 | (37.7285600633883, -122.430796382249) | ||
| 12327 | 12327 | 27038 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1346 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2005 12:00:00 AM | 3 | 3X3 | 6009450.86564 | 2094320.46878 | 37.7311386966779 | -122.409644741423 | (37.7311386966779, -122.409644741423) | ||
| 12570 | 12570 | 27105 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 595 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1999 12:00:00 AM | 3 | 3X3 | 6005329.57476 | 2093556.08719 | 37.728808068530796 | -122.42383844898701 | (37.7288080685308, -122.423838448987) | ||
| 12696 | 12696 | 27224 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 367 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1999 12:00:00 AM | 3 | 3X3 | 6003787.64028 | 2093509.2466099998 | 37.728592287005604 | -122.429165680266 | (37.7285922870056, -122.429165680266) | ||
| 12768 | 12768 | 27200 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 6003430.014219999 | 2093478.3653900002 | 37.728487242572605 | -122.430399810923 | (37.7284872425726, -122.430399810923) | ||
| 12957 | 12957 | 27096 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 707 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2006 12:00:00 AM | 3 | 3X3 | 6006037.723730001 | 2093592.8940700002 | 37.7289490840269 | -122.42139293964199 | (37.7289490840269, -122.421392939642) | ||
| 13190 | 13190 | 27285 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 670 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1999 12:00:00 AM | 3 | 3X3 | 6005819.54085 | 2093537.91486 | 37.728785819299105 | -122.422143310586 | (37.7287858192991, -122.422143310586) | ||
| 13750 | 13750 | 96932 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6011002.04218 | 2094782.5630700001 | 37.732494311353506 | -122.404314536086 | (37.7324943113535, -122.404314536086) | |||
| 13770 | 13770 | 96936 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010967.89306 | 2094873.35668 | 37.732741703157394 | -122.404438986978 | (37.7327417031574, -122.404438986978) | |||
| 14213 | 14213 | 25940 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2018 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2000 12:00:00 AM | 3 | 3x3 | 6012740.13667 | 2097232.43261 | 37.739318114344 | -122.398477333477 | (37.739318114344, -122.398477333477) | ||
| 14326 | 14326 | 27149 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1735 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/1999 12:00:00 AM | 3 | 3X3 | 6011161.84153 | 2095168.8132099998 | 37.7335638013107 | -122.403789237593 | (37.7335638013107, -122.403789237593) | ||
| 14432 | 14432 | 27132 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2009 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/2004 12:00:00 AM | 3 | 2X3 | 6012226.6815599995 | 2095938.3676200002 | 37.735736266604704 | -122.40016178436501 | (37.7357362666047, -122.400161784365) | ||
| 14531 | 14531 | 25952 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2370 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 3X3 | 6011712.98649 | 2098000.83737 | 37.7413707152901 | -122.40208278929701 | (37.7413707152901, -122.402082789297) | ||
| 14841 | 14841 | 96934 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010990.76512 | 2094811.6628299998 | 37.7325735829947 | -122.404355571269 | (37.7325735829947, -122.404355571269) | |||
| 14985 | 14985 | 97996 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6012957.391559999 | 2106153.16264 | 37.7638246167349 | -122.398351909517 | (37.7638246167349, -122.398351909517) | |||
| 15016 | 15016 | 27146 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1751 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1999 12:00:00 AM | 3 | 2X3 | 6011294.03802 | 2095268.15566 | 37.7338439590333 | -122.403339179952 | (37.7338439590333, -122.403339179952) | ||
| 15147 | 15147 | 96937 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010960.45235 | 2094890.17175 | 37.732787457976706 | -122.40446589470699 | (37.7327874579767, -122.404465894707) | |||
| 16365 | 16365 | 27145 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1751 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1999 12:00:00 AM | 3 | 2X3 | 6011315.84096 | 2095284.6201400002 | 37.7338903847377 | -122.40326495802499 | (37.7338903847377, -122.403264958025) | ||
| 16389 | 16389 | 96935 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010973.7505 | 2094855.21788 | 37.7326922251695 | -122.404417459925 | (37.7326922251695, -122.404417459925) | |||
| 16407 | 16407 | 97995 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 3x3 | 6013004.40763 | 2106156.2643 | 37.7638357521307 | -122.398189511757 | (37.7638357521307, -122.398189511757) | ||
| 16570 | 16570 | 96933 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010997.56747 | 2094792.1485099997 | 37.7325203809043 | -122.40433068074101 | (37.7325203809043, -122.404330680741) | |||
| 22702 | 22702 | 21528 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1300 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2007 12:00:00 AM | 3 | 4X4 | 6006219.829580001 | 2114935.40618 | 37.787560918141295 | -122.422279128893 | (37.7875609181413, -122.422279128893) | ||
| 27078 | 27078 | 188288 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6010227.812000001 | 2110667.04277 | 37.7760662630739 | -122.40811110056299 | (37.7760662630739, -122.408111100563) | |||
| 27384 | 27384 | 39767 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 476 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 3 | 2x2 | Permit Number 42916 | 6008173.90648 | 2113469.9166 | 37.7836470686025 | -122.41541460189899 | (37.7836470686025, -122.415414601899) |
| 30747 | 30747 | 188322 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012715.86863 | 2103660.87857 | 37.75696789675921 | -122.39901232755399 | (37.7569678967592, -122.399012327554) | |||
| 38900 | 38900 | 222499 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 301 Webster St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004137.32896 | 2109855.92191 | 37.7734962273111 | -122.429121852705 | (37.7734962273111, -122.429121852705) | |||
| 39974 | 39974 | 188355 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1339 Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017230.94644 | 2095282.0098400002 | 37.7342117988404 | -122.38281425956998 | (37.7342117988404, -122.38281425957) | |||
| 40087 | 40087 | 125883 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 786 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008823.04151 | 2115295.3212900003 | 37.7886956530184 | -122.413297963833 | (37.7886956530184, -122.413297963833) | |||
| 45847 | 45847 | 43213 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 361 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 3 | Permit Number 43004 | 6008709.78977 | 2094511.79844 | 37.7316224914874 | -122.41222029725 | (37.7316224914874, -122.41222029725) | |
| 47784 | 47784 | 221322 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 76 Oakwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005240.85494 | 2105024.4327599998 | 37.760292519512205 | -122.42496077502899 | (37.7602925195122, -122.424960775029) | |||
| 50745 | 50745 | 188325 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 9 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6012720.87909 | 2103581.41048 | 37.7567499739592 | -122.39898942183201 | (37.7567499739592, -122.398989421832) | |||
| 51501 | 51501 | 44809 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1371 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 3 | Permit Number 43903 | 5986466.0604 | 2105911.3769 | 37.7616494289947 | -122.48995834721501 | (37.7616494289947, -122.489958347215) | |
| 53807 | 53807 | 188319 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012713.14067 | 2103722.27252 | 37.7571363191045 | -122.39902607101001 | (37.7571363191045, -122.39902607101) | |||
| 55954 | 55954 | 49814 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46606 | 6012411.85736 | 2104145.59448 | 37.758281874620295 | -122.400097759826 | (37.7582818746203, -122.400097759826) | |
| 61469 | 61469 | 181675 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2700 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5987341.4731 | 2106458.4895 | 37.763202728798106 | -122.486970869844 | (37.7632027287981, -122.486970869844) | |||
| 61563 | 61563 | 247044 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 596 Valley St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6002079.830030001 | 2099170.11996 | 37.74403891207071 | -122.43547446040199 | (37.7440389120707, -122.435474460402) | |||
| 63601 | 63601 | 125885 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 476 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008153.2935 | 2113467.57124 | 37.7836394702246 | -122.415485749065 | (37.7836394702246, -122.415485749065) | |||
| 65637 | 65637 | 222567 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 115 College Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004467.78746 | 2096013.76695 | 37.735507618486096 | -122.42699267809601 | (37.7355076184861, -122.426992678096) | |||
| 65817 | 65817 | 188323 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012718.59247 | 2103642.7954599997 | 37.7569183962771 | -122.399001638237 | (37.7569183962771, -122.399001638237) | |||
| 70052 | 70052 | 47793 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2578 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2002 12:00:00 AM | 3 | Permit Number 45565 | 5987410.8144 | 2097738.044 | 37.7392627758453 | -122.48609086811899 | (37.7392627758453, -122.486090868119) | |
| 71277 | 71277 | 175764 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 325 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010619.0390099995 | 2092334.0476400002 | 37.7257497917057 | -122.40546629512698 | (37.7257497917057, -122.405466295127) | |||
| 71455 | 71455 | 175779 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003783.14523 | 2093465.1437900001 | 37.728470936062706 | -122.429178076504 | (37.7284709360627, -122.429178076504) | |||
| 73619 | 73619 | 248397 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 710 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997610.5725 | 2108098.1732 | 37.7682982739336 | -122.451571931383 | (37.7682982739336, -122.451571931383) | |||
| 75941 | 75941 | 73418 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2483 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 3 | 5983001.5767 | 2098246.6338 | 37.740401269768796 | -122.50137340388001 | (37.7404012697688, -122.50137340388) | ||
| 82895 | 82895 | 27119 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2345X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 3 | 3X3 | 6013094.94494 | 2096422.2568700002 | 37.7371133006396 | -122.397193759945 | (37.7371133006396, -122.397193759945) | ||
| 89141 | 89141 | 30743 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 490X Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.42905135835501 | (37.7740034947051, -122.429051358355) |
| 93238 | 93238 | 96931 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010934.9 | 2094931.8 | 37.7329003323541 | -122.404557165415 | (37.7329003323541, -122.404557165415) | |||
| 93454 | 93454 | 108730 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1822-1898X 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773105 | 6013006.0 | 2102886.0 | 37.7548564119513 | -122.39795458116001 | (37.7548564119513, -122.39795458116) |
| 93893 | 93893 | 24248 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 265X Willow St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/1990 12:00:00 AM | 3 | 4x4 | 6006141.132777 | 2113311.4044124 | 37.783097370149 | -122.422435967678 | (37.783097370149, -122.422435967678) | ||
| 95395 | 95395 | 27160 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1700X Silver Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3X3 | 6011020.5092245005 | 2095004.7366116 | 37.733105385033795 | -122.40426632243 | (37.7331053850338, -122.40426632243) | |||
| 97552 | 97552 | 108723 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 764 Arkansas St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773103 | 6013016.81056 | 2103494.00722 | 37.7565264696642 | -122.39795984425301 | (37.7565264696642, -122.397959844253) | |
| 98059 | 98059 | 96209 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 201X Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/28/2012 12:00:00 AM | 3 | 4x4 | 6001762.6 | 2104666.8 | 37.759113460692 | -122.43696480408701 | (37.759113460692, -122.436964804087) | |
| 98718 | 98718 | 19415 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 600X Sloat Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/04/1999 12:00:00 AM | 3 | 20 | 5989744.831209299 | 2096044.8028161 | 37.7347493206824 | -122.477897219949 | (37.7347493206824, -122.477897219949) | ||
| 102034 | 102034 | 19417 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/04/1999 12:00:00 AM | 3 | 20 | 5988998.102828201 | 2096024.0271709 | 37.7346489082814 | -122.48047736602301 | (37.7346489082814, -122.480477366023) | ||
| 107953 | 107953 | 19416 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 700X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/04/1999 12:00:00 AM | 3 | 20 | 5989518.2187007 | 2096039.5354251 | 37.7347217027544 | -122.4786803033 | (37.7347217027544, -122.4786803033) | ||
| 108854 | 108854 | 27124 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2095X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/1999 12:00:00 AM | 3 | 3X3 | 6012407.8106259005 | 2096047.4553772 | 37.736045896585495 | -122.399543203223 | (37.7360458965855, -122.399543203223) | ||
| 113808 | 113808 | 89718 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1655 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5993507.69164 | 2112056.80986 | 37.778931820846296 | -122.46605098131501 | (37.7789318208463, -122.466050981315) | ||
| 114797 | 114797 | 5808 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 22 Dukes Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2012 12:00:00 AM | 3 | 6016199.5009328 | 2096264.8663221002 | 37.736853484109794 | -122.38644883389 | (37.7368534841098, -122.38644883389) | |||
| 115008 | 115008 | 12297 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 861 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2004 12:00:00 AM | 3 | 4X4 | 6004837.02716 | 2111802.36626 | 37.778880271067294 | -122.426840140564 | (37.7788802710673, -122.426840140564) | ||
| 115921 | 115921 | 10852 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299X HUDSON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2016 12:00:00 AM | 3 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 122560 | 122560 | 12293 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 841X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2002 12:00:00 AM | 3 | 4X4 | 6004846.05575 | 2111737.27176 | 37.7787020480516 | -122.42680427007099 | (37.7787020480516, -122.426804270071) | ||
| 131032 | 131032 | 33248 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2591 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 3 | 3x3 | Permit Number 37429 | 5987367.1404 | 2097667.8262 | 37.7390674308693 | -122.486236717873 | (37.7390674308693, -122.486236717873) |
| 135943 | 135943 | 96017 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767661 | 6008768.28006 | 2115323.27409 | 37.7887693299764 | -122.413489408823 | (37.7887693299764, -122.413489408823) |
| 144749 | 144749 | 16346 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 900X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996119.1686597 | 2094698.5315602 | 37.7314206866198 | -122.45576179592301 | (37.7314206866198, -122.455761795923) | ||
| 145034 | 145034 | 47724 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 85 Sycamore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2015 12:00:00 AM | 3 | Permit Number 774851 | 6006351.18478147 | 2105818.87737664 | 37.7625365339004 | -122.421177070604 | (37.7625365339004, -122.421177070604) | ||
| 146218 | 146218 | 12283 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 803X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2000 12:00:00 AM | 3 | 4X4 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | ||
| 147889 | 147889 | 204616 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 621 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993775.2241 | 2107303.2691599997 | 37.7658952931499 | -122.46478019575198 | (37.7658952931499, -122.464780195752) | |||
| 148647 | 148647 | 222566 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 115 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004480.72884 | 2096010.51075 | 37.73549940946629 | -122.426947702995 | (37.7354994094663, -122.426947702995) | |||
| 148883 | 148883 | 43665 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 241 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 3 | Permit Number 43308 | 5992118.30424 | 2113674.27096 | 37.7832926725519 | -122.47097524296001 | (37.7832926725519, -122.47097524296) | |
| 151156 | 151156 | 222586 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 219 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001763.88203 | 2104576.51068 | 37.758865620975705 | -122.43695390631599 | (37.7588656209757, -122.436953906316) | |||
| 151270 | 151270 | 222585 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 219 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001765.705709999 | 2104562.10445 | 37.758826168613204 | -122.436946567843 | (37.7588261686132, -122.436946567843) | |||
| 153571 | 153571 | 204611 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1715 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992772.93939 | 2103781.0166 | 37.7561662752808 | -122.467990635168 | (37.7561662752808, -122.467990635168) | |||
| 159939 | 159939 | 188347 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 83 Scotia Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011997.83069 | 2095044.25145 | 37.7332684477844 | -122.400890216316 | (37.7332684477844, -122.400890216316) | |||
| 165657 | 165657 | 185126 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 600 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5989258.3218 | 2096043.9506 | 37.7347187320697 | -122.479579168443 | (37.7347187320697, -122.479579168443) |
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");