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) | |||
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) | |
3074 | 3074 | 199930 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016497.9258 | 2092921.8231 | 37.727690668221506 | -122.385184171361 | (37.7276906682215, -122.385184171361) | ||
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) | ||
3081 | 3081 | 199928 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/27/2008 12:00:00 AM | 4 | Width 0ft | 6016476.4427 | 2092884.9162 | 37.727588140695204 | -122.385255868852 | (37.7275881406952, -122.385255868852) | ||
3082 | 3082 | 199927 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 5 | Width 0ft | 6016464.324 | 2092869.4925 | 37.7275451198245 | -122.385296689415 | (37.7275451198245, -122.385296689415) | ||
3105 | 3105 | 199929 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016487.4596 | 2092903.0942 | 37.727638663365 | -122.385219049049 | (37.727638663365, -122.385219049049) | ||
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) | |||
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) | ||
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) | ||
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) | ||
8135 | 8135 | 26165 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1996 12:00:00 AM | 10 | 3x3 | 6003705.1408 | 2119642.0239 | 37.800341918970396 | -122.431315547527 | (37.8003419189704, -122.431315547527) | ||
8162 | 8162 | 13268 | Permitted Site 1 | Tristania conferta :: 79 | 2467 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2002 12:00:00 AM | 3 | 3X3 | 6000591.5664 | 2119207.4707 | 37.7989718069145 | -122.442058509671 | (37.7989718069145, -122.442058509671) |
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");