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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 687 | 687 | 13252 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6001005.1632 | 2119265.163 | 37.7991537757264 | -122.440631471061 | (37.7991537757264, -122.440631471061) | |||
| 739 | 739 | 13244 | Permitted Site 1 | Tristania conferta :: 79 | 2353 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2012 12:00:00 AM | 3 | 3x3 | 6001169.3018 | 2119289.54 | 37.7992300540772 | -122.44006524578501 | (37.7992300540772, -122.440065245785) | ||
| 823 | 823 | 13156 | Permitted Site 1 | Tristania conferta :: 79 | 1875 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6003411.9498 | 2119598.2407 | 37.800205081624604 | -122.432326975222 | (37.8002050816246, -122.432326975222) | |||
| 979 | 979 | 200925 | Undocumented 2 | Tristania conferta :: 79 | 4100 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | Width 0ft | 6015478.3928 | 2097437.2349 | 37.7400326248174 | -122.389023874228 | (37.7400326248174, -122.389023874228) | ||
| 1017 | 1017 | 6253 | Permitted Site 1 | Tristania conferta :: 79 | 1315 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2004 12:00:00 AM | 9 | 3X3 | 6004522.7205 | 2113262.2432 | 37.782870955582794 | -122.428031512738 | (37.7828709555828, -122.428031512738) | ||
| 1346 | 1346 | 21675 | Permitted Site 1 | Tristania conferta :: 79 | 1788 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004079.3213 | 2114634.9946 | 37.7866150915141 | -122.42966342693899 | (37.7866150915141, -122.429663426939) | |||
| 1424 | 1424 | 13099 | Permitted Site 1 | Tristania conferta :: 79 | 1501 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/1995 12:00:00 AM | 6 | 3X3 | 6005022.5453 | 2119823.4113 | 37.800914533929294 | -122.4267697277 | (37.8009145339293, -122.4267697277) | ||
| 1530 | 1530 | 13180 | Permitted Site 1 | Tristania conferta :: 79 | 1990 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 15 | 3X3 | 6002882.226 | 2119605.2218 | 37.8001941994801 | -122.434160523596 | (37.8001941994801, -122.434160523596) | ||
| 2361 | 2361 | 12987 | Permitted Site 1 | Tristania conferta :: 79 | 318 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 3 | 3X3 | 6010766.7048 | 2120702.1725 | 37.8036504876245 | -122.406954379692 | (37.8036504876245, -122.406954379692) | ||
| 2471 | 2471 | 7042 | Permitted Site 1 | Tristania conferta :: 79 | 1300 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2009 12:00:00 AM | 3 | 3X3 | 6001153.5455 | 2110065.6201 | 37.7739026486508 | -122.43945820683099 | (37.7739026486508, -122.439458206831) | ||
| 2578 | 2578 | 21604 | Permitted Site 1 | Tristania conferta :: 79 | 1521 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005122.6686 | 2114733.0427 | 37.7869433299583 | -122.426060678785 | (37.7869433299583, -122.426060678785) | |||
| 2624 | 2624 | 13174 | Permitted Site 1 | Tristania conferta :: 79 | 1950 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1997 12:00:00 AM | 14 | 3X3 | 6003011.134 | 2119622.0359 | 37.80024768199421 | -122.43371565452 | (37.8002476819942, -122.43371565452) | ||
| 2645 | 2645 | 13092 | Permitted Site 1 | Tristania conferta :: 79 | 1447 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2005 12:00:00 AM | 8 | 3x3 | 6005407.9937 | 2119875.0129 | 37.8010780038521 | -122.42543958631501 | (37.8010780038521, -122.425439586315) | ||
| 2704 | 2704 | 7043 | Permitted Site 1 | Tristania conferta :: 79 | 1300 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2010 12:00:00 AM | 12 | 3X3 | 6001130.7028 | 2110062.144 | 37.773891804124 | -122.43953697407801 | (37.773891804124, -122.439536974078) | ||
| 2847 | 2847 | 7089 | Permitted Site 1 | Tristania conferta :: 79 | 1874 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2009 12:00:00 AM | 3 | 3x3 | 5998459.5467 | 2109686.5004 | 37.7727079965007 | -122.448749840415 | (37.7727079965007, -122.448749840415) | ||
| 2872 | 2872 | 7051 | Permitted Site 1 | Tristania conferta :: 79 | 1350 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2008 12:00:00 AM | 3 | 3X3 | 6000969.3144 | 2110039.798 | 37.773821261144 | -122.440093639062 | (37.773821261144, -122.440093639062) | ||
| 2936 | 2936 | 246076 | Permitted Site 1 | Tristania conferta :: 79 | 1215 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | 11 | Width 0ft | Permit Number 17670 | 5999867.5576 | 2108450.6663 | 37.769395122673394 | -122.443790589358 | (37.7693951226734, -122.443790589358) | |
| 2968 | 2968 | 7092 | Permitted Site 1 | Tristania conferta :: 79 | 1926 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2009 12:00:00 AM | 3 | 3X3 | 5998180.0393 | 2109648.8744 | 37.7725886979314 | -122.449713970747 | (37.7725886979314, -122.449713970747) | ||
| 2972 | 2972 | 246077 | Permitted Site 1 | Tristania conferta :: 79 | 1221 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1980 12:00:00 AM | 6 | Width 0ft | Permit Number 17671 | 5999841.5143 | 2108446.1238 | 37.769381164613 | -122.443880345259 | (37.769381164613, -122.443880345259) | |
| 2981 | 2981 | 245990 | Permitted Site 1 | Tristania conferta :: 79 | 1250 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2010 12:00:00 AM | 11 | Width 0ft | Permit Number 53135 | 5999824.4044 | 2108487.46 | 37.76949368743671 | -122.44394249781901 | (37.7694936874367, -122.443942497819) | |
| 2995 | 2995 | 245989 | Permitted Site 1 | Tristania conferta :: 79 | 1250 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2010 12:00:00 AM | 14 | Width 0ft | Permit Number 53135 | 5999854.6873 | 2108493.8194 | 37.7695128761205 | -122.443838207787 | (37.7695128761205, -122.443838207787) | |
| 3080 | 3080 | 28823 | Permitted Site 1 | Tristania conferta :: 79 | 1054 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6002356.6442 | 2110231.7539 | 37.77442720694221 | -122.435308381556 | (37.7744272069422, -122.435308381556) | ||
| 3094 | 3094 | 253300 | Undocumented 2 | Tristania conferta :: 79 | 844 33rd Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5985769.0 | 2110141.0 | 37.773222058846 | -122.492680686455 | (37.773222058846, -122.492680686455) | ||||
| 3288 | 3288 | 13145 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1996 12:00:00 AM | 8 | 3X3 | 6003646.5026 | 2119634.2054 | 37.8003171280845 | -122.431517900376 | (37.8003171280845, -122.431517900376) | ||
| 3350 | 3350 | 21605 | Permitted Site 1 | Tristania conferta :: 79 | 1521 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005164.0288 | 2114740.1913 | 37.7869652957353 | -122.425918090858 | (37.7869652957353, -122.425918090858) | |||
| 3372 | 3372 | 101650 | Undocumented 2 | Tristania conferta :: 79 | 3X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5998828.7375 | 2112398.5369 | 37.780175655731796 | -122.447668041416 | (37.7801756557318, -122.447668041416) | |||
| 3588 | 3588 | 24306 | Permitted Site 1 | Tristania conferta :: 79 | 1513 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/1994 12:00:00 AM | 3 | 6002219.6394 | 2111892.3425 | 37.7789789862822 | -122.435901149592 | (37.7789789862822, -122.435901149592) | |||
| 3641 | 3641 | 13162 | Permitted Site 1 | Tristania conferta :: 79 | 1901 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/1997 12:00:00 AM | 6 | 3X3 | 6003171.1793 | 2119566.6116 | 37.8001045813382 | -122.433157873196 | (37.8001045813382, -122.433157873196) | ||
| 3666 | 3666 | 21602 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005338.1501 | 2114762.148 | 37.7870354220648 | -122.425317233161 | (37.7870354220648, -122.425317233161) | |||
| 3704 | 3704 | 6903 | Permitted Site 1 | Tristania conferta :: 79 | 333 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3X3 | 6005734.9676 | 2110651.7554 | 37.775771702887894 | -122.42365197493 | (37.7757717028879, -122.42365197493) | ||
| 3764 | 3764 | 24423 | Permitted Site 1 | Tristania conferta :: 79 | 1707 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1995 12:00:00 AM | 18 | 3x3 | 6005275.9761 | 2115602.2731 | 37.7893386830183 | -122.425592156658 | (37.7893386830183, -122.425592156658) | ||
| 4181 | 4181 | 21599 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x3 | 6005255.9404 | 2114750.4037 | 37.7869985302762 | -122.425600824408 | (37.7869985302762, -122.425600824408) | |||
| 4200 | 4200 | 28075 | Permitted Site 1 | Tristania conferta :: 79 | 915 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2010 12:00:00 AM | 3 | 3X3 | 6008651.5543 | 2120512.2278 | 37.8030103621977 | -122.41426054224199 | (37.8030103621977, -122.414260542242) | ||
| 4388 | 4388 | 251703 | Undocumented 2 | Tristania conferta :: 79 | 123 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 10:45:00 AM | 3 | 3x3 | 6004216.0 | 2094352.0 | 37.7309305395323 | -122.42774483827299 | (37.7309305395323, -122.427744838273) | ||
| 4457 | 4457 | 13208 | Permitted Site 1 | Tristania conferta :: 79 | 2199 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1997 12:00:00 AM | 6 | 3X3 | 6001971.1512 | 2119400.3389 | 37.7995798943259 | -122.437298513288 | (37.7995798943259, -122.437298513288) | ||
| 4588 | 4588 | 200921 | Permitted Site 1 | Tristania conferta :: 79 | 4040 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/18/2008 12:00:00 AM | 5 | Width 0ft | 6015547.5959 | 2097647.2059 | 37.7406129979736 | -122.388799250904 | (37.7406129979736, -122.388799250904) | |
| 4634 | 4634 | 13151 | Permitted Site 1 | Tristania conferta :: 79 | 1850 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 6 | 3x3 | 6003502.6435 | 2119692.0618 | 37.8004678320559 | -122.43201984317899 | (37.8004678320559, -122.432019843179) | ||
| 4874 | 4874 | 14465 | Permitted Site 1 | Tristania conferta :: 79 | 161 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1994 12:00:00 AM | 50 | 3X3 | 5998884.4079 | 2112430.1793 | 37.7802657190757 | -122.447477731101 | (37.7802657190757, -122.447477731101) | ||
| 5039 | 5039 | 13231 | Permitted Site 1 | Tristania conferta :: 79 | 2301X Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3 | 6001312.3137 | 2119307.4165 | 37.7992872786644 | -122.43957165866001 | (37.7992872786644, -122.43957165866) | |||
| 5258 | 5258 | 7076 | Permitted Site 1 | Tristania conferta :: 79 | 1712 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2008 12:00:00 AM | 3 | 3x3 | 5999133.3592 | 2109779.0297 | 37.7730005664352 | -122.44642571608499 | (37.7730005664352, -122.446425716085) | ||
| 5298 | 5298 | 13176 | Permitted Site 1 | Tristania conferta :: 79 | 1964 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6002959.4463 | 2119614.5629 | 37.800224230069205 | -122.43389397959601 | (37.8002242300692, -122.433893979596) | |||
| 5315 | 5315 | 18239 | Permitted Site 1 | Tristania conferta :: 79 | 1790X Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2000 12:00:00 AM | 3 | 4X4 | 6003687.2504 | 2114237.8837 | 37.7855025167716 | -122.43099154386499 | (37.7855025167716, -122.430991543865) | ||
| 5351 | 5351 | 13158 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6003428.3685 | 2119684.2434 | 37.8004421536411 | -122.432276305709 | (37.8004421536411, -122.432276305709) | |||
| 5368 | 5368 | 13177 | Permitted Site 1 | Tristania conferta :: 79 | 1970 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/1995 12:00:00 AM | 35 | 3x3 | 6002925.1953 | 2119612.0719999997 | 37.8002154469875 | -122.434012323171 | (37.8002154469875, -122.434012323171) | ||
| 5503 | 5503 | 7044 | Permitted Site 1 | Tristania conferta :: 79 | 1300 Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2010 12:00:00 AM | 12 | 3X3 | 6001092.4662 | 2110057.6748 | 37.7738773565747 | -122.439668919992 | (37.7738773565747, -122.439668919992) | ||
| 5506 | 5506 | 24257 | Permitted Site 1 | Tristania conferta :: 79 | 600X Willow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2004 12:00:00 AM | 5 | 3X3 | 6004635.8921 | 2113135.7984 | 37.782530171668 | -122.427630974469 | (37.782530171668, -122.427630974469) | ||
| 5606 | 5606 | 7095 | Permitted Site 1 | Tristania conferta :: 79 | 1970 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1994 12:00:00 AM | 18 | 3X3 | 5998027.6156 | 2109626.606 | 37.772518832985504 | -122.45023961224 | (37.7725188329855, -122.45023961224) | ||
| 5631 | 5631 | 5897 | Permitted Site 1 | Tristania conferta :: 79 | 1168 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6004857.8368 | 2113009.1929 | 37.782195095891396 | -122.42685412216001 | (37.7821950958914, -122.42685412216) | ||
| 5639 | 5639 | 12273 | Permitted Site 1 | Tristania conferta :: 79 | 721 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1991 12:00:00 AM | 12 | 3X3 | 6004895.7756 | 2111355.1796 | 37.7776557277721 | -122.426605054269 | (37.7776557277721, -122.426605054269) | ||
| 5716 | 5716 | 7070 | Permitted Site 1 | Tristania conferta :: 79 | 1634 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5999592.5889 | 2109848.7666 | 37.7732182646887 | -122.4448422034 | (37.7732182646887, -122.4448422034) | |||
| 5743 | 5743 | 12280 | Permitted Site 1 | Tristania conferta :: 79 | 741 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/1997 12:00:00 AM | 3 | 3X3 | 6004879.1558 | 2111501.6218 | 37.7780568825374 | -122.42667297875201 | (37.7780568825374, -122.426672978752) | ||
| 5826 | 5826 | 7045 | Permitted Site 1 | Tristania conferta :: 79 | 1300 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2010 12:00:00 AM | 12 | 3X3 | 6001075.5825 | 2110054.6953 | 37.7738682146278 | -122.43972710968599 | (37.7738682146278, -122.439727109686) | ||
| 5872 | 5872 | 24489 | Permitted Site 1 | Tristania conferta :: 79 | 840 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6003385.8226 | 2110373.2704 | 37.774874168918 | -122.43175836681499 | (37.774874168918, -122.431758366815) | ||
| 5924 | 5924 | 13114 | Permitted Site 1 | Tristania conferta :: 79 | 1618 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2005 12:00:00 AM | 12 | 3x3 | 6004576.6984 | 2119842.3294 | 37.800941260536 | -122.428313896065 | (37.800941260536, -122.428313896065) | ||
| 5943 | 5943 | 9604 | Permitted Site 1 | Tristania conferta :: 79 | 1355 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003125.8375 | 2112021.5623 | 37.7793852280154 | -122.432775482637 | (37.7793852280154, -122.432775482637) | |||
| 5954 | 5954 | 13262 | Permitted Site 1 | Tristania conferta :: 79 | 2443 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000711.0138 | 2119222.9095 | 37.799021004008104 | -122.44164629161301 | (37.7990210040081, -122.441646291613) | |||
| 5987 | 5987 | 28074 | Permitted Site 1 | Tristania conferta :: 79 | 915 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2010 12:00:00 AM | 3 | 3X3 | 6008638.4319 | 2120527.3912 | 37.8030512599832 | -122.414307026238 | (37.8030512599832, -122.414307026238) | ||
| 6001 | 6001 | 5894 | Permitted Site 1 | Tristania conferta :: 79 | 1142 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 3 | 3X3 | 6004948.741 | 2113023.7653 | 37.7822402475105 | -122.42654067221599 | (37.7822402475105, -122.426540672216) | ||
| 6017 | 6017 | 29686 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003340.0203 | 2119674.0794 | 37.800409236193296 | -122.432581299288 | (37.8004092361933, -122.432581299288) | |||
| 6025 | 6025 | 9561 | Permitted Site 1 | Tristania conferta :: 79 | 1201 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6003758.3426 | 2112108.0173 | 37.7796584641609 | -122.430593553118 | (37.7796584641609, -122.430593553118) | |||
| 6059 | 6059 | 10683 | Permitted Site 1 | Tristania conferta :: 79 | 1155 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002334.989 | 2110528.6392 | 37.775241150218 | -122.43540453260401 | (37.775241150218, -122.435404532604) | |||
| 6073 | 6073 | 14456 | Permitted Site 1 | Tristania conferta :: 79 | 135 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1997 12:00:00 AM | 50 | 3X3 | 5998867.4868 | 2112526.9679 | 37.7805305084906 | -122.447543237813 | (37.7805305084906, -122.447543237813) | ||
| 6139 | 6139 | 13094 | Permitted Site 1 | Tristania conferta :: 79 | 1450 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/1995 12:00:00 AM | 12 | 3X3 | 6005349.3555 | 2119944.5969 | 37.801265750478 | -122.425647455227 | (37.801265750478, -122.425647455227) | ||
| 6167 | 6167 | 10693 | Permitted Site 1 | Tristania conferta :: 79 | 1250 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001870.5552 | 2110507.5567 | 37.7751568758154 | -122.43700960221001 | (37.7751568758154, -122.43700960221) | |||
| 6191 | 6191 | 13159 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003407.2588 | 2119680.3342 | 37.8004302230496 | -122.43234907433599 | (37.8004302230496, -122.432349074336) | |||
| 6225 | 6225 | 13241 | Permitted Site 1 | Tristania conferta :: 79 | 2352 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1994 12:00:00 AM | 30 | 3X3 | 6001099.421 | 2119356.9831 | 37.7994112565419 | -122.440311896156 | (37.7994112565419, -122.440311896156) | ||
| 6253 | 6253 | 13146 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1996 12:00:00 AM | 6 | 3x3 | 6003666.0486 | 2119638.1147 | 37.800328969814 | -122.43145054275101 | (37.800328969814, -122.431450542751) | ||
| 6257 | 6257 | 18235 | Permitted Site 1 | Tristania conferta :: 79 | 1790X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1999 12:00:00 AM | 3 | 4X4 | 6003758.3462 | 2114245.8879 | 37.7855285225047 | -122.430746144837 | (37.7855285225047, -122.430746144837) | ||
| 6268 | 6268 | 24416 | Permitted Site 1 | Tristania conferta :: 79 | 1625 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6005321.0617 | 2115263.3908 | 37.7884107443518 | -122.425412039373 | (37.7884107443518, -122.425412039373) | ||
| 6344 | 6344 | 13283 | Permitted Site 1 | Tristania conferta :: 79 | 2539 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000208.0345 | 2119155.4664 | 37.7988071530908 | -122.44338191608999 | (37.7988071530908, -122.44338191609) | |||
| 6345 | 6345 | 13106 | Permitted Site 1 | Tristania conferta :: 79 | 1557 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 40 | 3x3 | 6004949.0522 | 2119813.2474 | 37.8008824710059 | -122.427023320732 | (37.8008824710059, -122.427023320732) | ||
| 6411 | 6411 | 10687 | Permitted Site 1 | Tristania conferta :: 79 | 1185 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002205.7566 | 2110510.4768 | 37.775183940568496 | -122.435850276383 | (37.7751839405685, -122.435850276383) | |||
| 6447 | 6447 | 9761 | Permitted Site 1 | Tristania conferta :: 79 | 745 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1997 12:00:00 AM | 8 | 4x4 | 6005736.7899 | 2112320.9115 | 37.7803549018091 | -122.423764380812 | (37.7803549018091, -122.423764380812) | ||
| 6500 | 6500 | 7087 | Permitted Site 1 | Tristania conferta :: 79 | 1854 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1992 12:00:00 AM | 12 | 3X3 | 5998578.5677 | 2109701.858 | 37.7727569698827 | -122.44833924164101 | (37.7727569698827, -122.448339241641) | ||
| 6506 | 6506 | 9520 | Permitted Site 1 | Tristania conferta :: 79 | 1046 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6004532.0878 | 2112270.4724 | 37.780148328739706 | -122.42792841204799 | (37.7801483287397, -122.427928412048) | ||
| 6548 | 6548 | 12281 | Permitted Site 1 | Tristania conferta :: 79 | 739 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6004881.0373 | 2111477.1625 | 37.777989829673096 | -122.426664727755 | (37.7779898296731, -122.426664727755) | |||
| 6645 | 6645 | 1662 | Permitted Site 1 | Tristania conferta :: 79 | 1400X Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2006 12:00:00 AM | 3 | 3X3 | 6000535.6523 | 2109979.223 | 37.7736302396696 | -122.441589394177 | (37.7736302396696, -122.441589394177) | ||
| 6679 | 6679 | 13098 | Permitted Site 1 | Tristania conferta :: 79 | 1488 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/1997 12:00:00 AM | 30 | 3X3 | 6005248.4978 | 2119934.433 | 37.8012321434749 | -122.42599574351499 | (37.8012321434749, -122.425995743515) | ||
| 6706 | 6706 | 21600 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005281.4713 | 2114753.9781 | 37.7870097872628 | -122.42551274764999 | (37.7870097872628, -122.42551274765) | |||
| 6826 | 6826 | 13243 | Permitted Site 1 | Tristania conferta :: 79 | 2353 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001148.9876 | 2119284.6646 | 37.799215511035705 | -122.440135189953 | (37.7992155110357, -122.440135189953) | |||
| 6862 | 6862 | 23930 | Permitted Site 1 | Tristania conferta :: 79 | 1715 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4X4 | 6003466.7876 | 2114641.1577 | 37.786597310936706 | -122.431783083706 | (37.7865973109367, -122.431783083706) | |||
| 6863 | 6863 | 10685 | Permitted Site 1 | Tristania conferta :: 79 | 1167 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002283.296 | 2110520.9551 | 37.7752171157043 | -122.435582800345 | (37.7752171157043, -122.435582800345) | |||
| 6887 | 6887 | 13251 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000984.848999999 | 2119261.9127 | 37.7991436944439 | -122.44070153167699 | (37.7991436944439, -122.440701531677) | |||
| 6900 | 6900 | 13253 | Permitted Site 1 | Tristania conferta :: 79 | 2400 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6000858.2681 | 2119325.515 | 37.7993111202698 | -122.44114410922899 | (37.7993111202698, -122.441144109229) | |||
| 6988 | 6988 | 7064 | Permitted Site 1 | Tristania conferta :: 79 | 1564 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5999951.2096 | 2109897.9532 | 37.7733737782492 | -122.44360522471099 | (37.7733737782492, -122.443605224711) | |||
| 7083 | 7083 | 1667 | Permitted Site 1 | Tristania conferta :: 79 | 1400X Fell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2006 12:00:00 AM | 3 | 3X3 | 6000310.2061 | 2109949.902 | 37.773536884549706 | -122.44236713923901 | (37.7735368845497, -122.442367139239) | ||
| 7113 | 7113 | 29685 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003360.3482 | 2119674.8613 | 37.800412535842206 | -122.43251101256 | (37.8004125358422, -122.43251101256) | |||
| 7208 | 7208 | 5898 | Permitted Site 1 | Tristania conferta :: 79 | 1174 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 3 | 3X3 | 6004835.6312 | 2113008.499 | 37.782191935057504 | -122.42693089417101 | (37.7821919350575, -122.426930894171) | ||
| 7228 | 7228 | 13213 | Permitted Site 1 | Tristania conferta :: 79 | 2199 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001911.9905 | 2119390.9978 | 37.799550882806 | -122.437502561002 | (37.799550882806, -122.437502561002) | |||
| 7268 | 7268 | 5883 | Permitted Site 1 | Tristania conferta :: 79 | 1118 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6005049.3601 | 2113036.9499 | 37.7822821368488 | -122.426193513801 | (37.7822821368488, -122.426193513801) | ||
| 7361 | 7361 | 5891 | Permitted Site 1 | Tristania conferta :: 79 | 1124 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 12 | 3X3 | 6005026.4605 | 2113033.4803 | 37.7822713158313 | -122.426272489182 | (37.7822713158313, -122.426272489182) | ||
| 7459 | 7459 | 7015 | Permitted Site 1 | Tristania conferta :: 79 | 1050 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6002372.7109 | 2110234.5481 | 37.7744357915241 | -122.435253003778 | (37.7744357915241, -122.435253003778) | ||
| 7594 | 7594 | 21603 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005357.043 | 2114765.7223 | 37.7870463035591 | -122.42525212232901 | (37.7870463035591, -122.425252122329) | |||
| 7595 | 7595 | 13237 | Permitted Site 1 | Tristania conferta :: 79 | 2320 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1997 12:00:00 AM | 30 | 3X3 | 6001278.1859 | 2119382.1727 | 37.7994905970471 | -122.439695114779 | (37.7994905970471, -122.439695114779) | ||
| 7596 | 7596 | 21601 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005314.151000001 | 2114757.5524 | 37.7870214478079 | -122.42539993758999 | (37.7870214478079, -122.42539993759) | |||
| 7721 | 7721 | 13116 | Permitted Site 1 | Tristania conferta :: 79 | 1627 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 20 | 3x3 | 6004563.6038 | 2119765.555 | 37.8007297168722 | -122.42835373390601 | (37.8007297168722, -122.428353733906) | ||
| 7899 | 7899 | 101329 | Undocumented 2 | Tristania conferta :: 79 | 2703 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5997904.4066 | 2111642.2894 | 37.7780463265361 | -122.45081116588301 | (37.7780463265361, -122.450811165883) | |||
| 7966 | 7966 | 100969 | Undocumented 2 | Tristania conferta :: 79 | 418 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6007656.9693 | 2112859.914 | 37.7819430807706 | -122.417159773401 | (37.7819430807706, -122.417159773401) | |||
| 7978 | 7978 | 18236 | Permitted Site 1 | Tristania conferta :: 79 | 1790X Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2007 12:00:00 AM | 3 | 4X4 | 6003740.4545 | 2114242.5919999997 | 37.7855184591156 | -122.43080780955201 | (37.7855184591156, -122.430807809552) | ||
| 8081 | 8081 | 4614 | Permitted Site 1 | Tristania conferta :: 79 | 347 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1991 12:00:00 AM | 30 | 3x3 | 6010525.6854 | 2118803.2675 | 37.7984230708943 | -122.407654474652 | (37.7984230708943, -122.407654474652) |
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");