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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
53004 | 53004 | 50647 | Permitted Site 1 | Tristania conferta :: 79 | 821 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2003 12:00:00 AM | 4 | Permit Number 47233 | 6012121.5394 | 2112599.3505 | 37.781477784622204 | -122.401696004131 | (37.7814777846222, -122.401696004131) | ||
156938 | 156938 | 50648 | Permitted Site 1 | Tristania conferta :: 79 | 821 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2003 12:00:00 AM | 4 | Permit Number 47233 | 6012137.5662 | 2112614.0037 | 37.7815189132409 | -122.401641589024 | (37.7815189132409, -122.401641589024) | ||
22266 | 22266 | 17051 | DPW Maintained 3 | Tristania conferta :: 79 | 1235 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774567 | 6001055.3761 | 2109653.1693 | 37.7727645748724 | -122.43976821361 | (37.7727645748724, -122.43976821361) | |
85477 | 85477 | 49069 | Permitted Site 1 | Tristania conferta :: 79 | 1298 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 3x3 | Permit Number 776020 | 5995836.31315767 | 2092013.47244835 | 37.724031921729704 | -122.45654557668001 | (37.7240319217297, -122.45654557668) | ||
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) | ||
23022 | 23022 | 18237 | Permitted Site 1 | Tristania conferta :: 79 | 1790X Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2007 12:00:00 AM | 4 | 4X4 | 6003723.9754 | 2114242.1212 | 37.7855162327444 | -122.43086478876002 | (37.7855162327444, -122.43086478876) | ||
13753 | 13753 | 22342 | DPW Maintained 3 | Tristania conferta :: 79 | 5256 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 6 | 3X3 | 6014378.1352 | 2093759.8228 | 37.729874153425705 | -122.392570970493 | (37.7298741534257, -122.392570970493) | ||
70474 | 70474 | 103963 | Permitted Site 1 | Tristania conferta :: 79 | 2534 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2015 12:00:00 AM | 0 | Permit Number 773267 | 6000467.0 | 2114127.0 | 37.7850150648369 | -122.442124666784 | (37.7850150648369, -122.442124666784) | ||
16601 | 16601 | 22174 | Permitted Site 1 | Tristania conferta :: 79 | 3900 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1995 12:00:00 AM | 3 | 3X3 | 6015675.1373 | 2098078.9572 | 37.7418055667015 | -122.388388385005 | (37.7418055667015, -122.388388385005) | ||
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) | ||
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) | ||
6776 | 6776 | 14454 | DPW Maintained 3 | Tristania conferta :: 79 | 109 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/1994 12:00:00 AM | 60 | 3X3 | 5998851.581 | 2112620.0339 | 37.7807851345871 | -122.447604964541 | (37.7807851345871, -122.447604964541) | ||
8199 | 8199 | 7101 | DPW Maintained 3 | Tristania conferta :: 79 | 2070 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/1994 12:00:00 AM | 6 | 4X4 | 5997541.7411 | 2109558.8408 | 37.7723049499053 | -122.451915402773 | (37.7723049499053, -122.451915402773) | ||
15567 | 15567 | 22419 | Permitted Site 1 | Tristania conferta :: 79 | 5815 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/19/2000 12:00:00 AM | 3 | 3x3 | 6013854.3759 | 2092034.5068 | 37.7251076834032 | -122.394260933329 | (37.7251076834032, -122.394260933329) | ||
6587 | 6587 | 5904 | DPW Maintained 3 | Tristania conferta :: 79 | 1256 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6004447.9733 | 2112952.6596 | 37.782016686789 | -122.428268035802 | (37.782016686789, -122.428268035802) | ||
16118 | 16118 | 22394 | Permitted Site 1 | Tristania conferta :: 79 | 5700 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2000 12:00:00 AM | 3 | 3X3 | 6013900.6343 | 2092382.1168 | 37.7260647216629 | -122.394125346164 | (37.7260647216629, -122.394125346164) | ||
16817 | 16817 | 22393 | Permitted Site 1 | Tristania conferta :: 79 | 5700 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2000 12:00:00 AM | 3 | 3X3 | 6013906.4177 | 2092399.467 | 37.726112683263295 | -122.39410656725799 | (37.7261126832633, -122.394106567258) | ||
17212 | 17212 | 27330 | DPW Maintained 3 | Tristania conferta :: 79 | 348 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/1998 12:00:00 AM | 25 | 4X4 | 6004421.6425 | 2109483.8508 | 37.772490701019294 | -122.42811184989999 | (37.7724907010193, -122.4281118499) | ||
20545 | 20545 | 27329 | DPW Maintained 3 | Tristania conferta :: 79 | 342 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/1998 12:00:00 AM | 25 | 4X4 | 6004444.7102 | 2109487.8877 | 37.772503090465705 | -122.428032344144 | (37.7725030904657, -122.428032344144) | ||
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) | ||
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) | ||
5416 | 5416 | 9589 | DPW Maintained 3 | Tristania conferta :: 79 | 1320 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/1997 12:00:00 AM | 6 | 3X3 | 6003248.1509 | 2112093.2525 | 37.779589007656604 | -122.432357471075 | (37.7795890076566, -122.432357471075) | ||
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) | ||
162200 | 162200 | 71273 | Undocumented 2 | Tristania conferta :: 79 | 2480 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 14 | 6000737.6791 | 2114169.5665 | 37.7851473635462 | -122.441191260636 | (37.7851473635462, -122.441191260636) | ||
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) | ||
8831 | 8831 | 9560 | Permitted Site 1 | Tristania conferta :: 79 | 1201 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/1991 12:00:00 AM | 12 | 3x3 | 6003719.6013 | 2112101.1806 | 37.77963749747521 | -122.430727087996 | (37.7796374974752, -122.430727087996) | ||
18778 | 18778 | 7005 | DPW Maintained 3 | Tristania conferta :: 79 | 1001 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/1999 12:00:00 AM | 3 | 3X3 | 6002577.0261 | 2110209.591 | 37.7743788659974 | -122.43454445471201 | (37.7743788659974, -122.434544454712) | ||
6937 | 6937 | 13290 | DPW Maintained 3 | Tristania conferta :: 79 | 2665 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1997 12:00:00 AM | 6 | 3X3 | 5999641.675 | 2119108.3375 | 37.7986454362464 | -122.445338306635 | (37.7986454362464, -122.445338306635) | ||
131053 | 131053 | 33674 | Permitted Site 1 | Tristania conferta :: 79 | 672 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 4 | Permit Number 37756 | 6004147.6576 | 2110988.6622 | 37.7766070388542 | -122.429166908178 | (37.7766070388542, -122.429166908178) | ||
58534 | 58534 | 41235 | Permitted Site 1 | Tristania conferta :: 79 | 270 Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | 14 | Permit Number 41940 | 5998984.5808 | 2112167.7332 | 37.7795508339841 | -122.44711229551001 | (37.7795508339841, -122.44711229551) | ||
108387 | 108387 | 114594 | Permitted Site 1 | Tristania conferta :: 79 | 2584 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775079 | 6000253.6 | 2114128.6 | 37.78500729421621 | -122.442863075731 | (37.7850072942162, -122.442863075731) | |||
114827 | 114827 | 114595 | Permitted Site 1 | Tristania conferta :: 79 | 2584 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775079 | 6000253.6 | 2114128.6 | 37.78500729421621 | -122.442863075731 | (37.7850072942162, -122.442863075731) | |||
17472 | 17472 | 16868 | Permitted Site 1 | Tristania conferta :: 79 | 240 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1995 12:00:00 AM | 11 | 3X3 | 6005810.7253 | 2110367.9458 | 37.7749967064605 | -122.42336972934099 | (37.7749967064605, -122.423369729341) | ||
8741 | 8741 | 55480 | Permitted Site 1 | Tristania conferta :: 79 | 501 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 17 | 8x6 | Permit Number 11433 | 6002131.5729 | 2110303.9871 | 37.7746127570805 | -122.436092114636 | (37.7746127570805, -122.436092114636) | |
137978 | 137978 | 65429 | Permitted Site 1 | Tristania conferta :: 79 | 679 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/28/1989 12:00:00 AM | 9 | Permit Number 28288 | 6010678.2615 | 2116199.1916 | 37.791281448138704 | -122.406942874303 | (37.7912814481387, -122.406942874303) | |
161911 | 161911 | 57971 | Permitted Site 1 | Tristania conferta :: 79 | 535 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 16 | Permit Number 19405 | 5999675.0078 | 2110381.8765 | 37.7746867521579 | -122.44459543015499 | (37.7746867521579, -122.444595430155) | |
984 | 984 | 24262 | DPW Maintained 3 | Tristania conferta :: 79 | 600X Willow St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2004 12:00:00 AM | 3 | 3X3 | 6004514.0905 | 2113119.5269 | 37.7824786038336 | -122.428051195433 | (37.7824786038336, -122.428051195433) | ||
4812 | 4812 | 24261 | DPW Maintained 3 | Tristania conferta :: 79 | 600X Willow St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2004 12:00:00 AM | 5 | 3X3 | 6004538.0187 | 2113122.6754 | 37.7824886025731 | -122.427968638693 | (37.7824886025731, -122.427968638693) | ||
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) | ||
8775 | 8775 | 9640 | Permitted Site 1 | Tristania conferta :: 79 | 1475 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2002 12:00:00 AM | 3 | 3X3 | 6002575.9976 | 2111942.0905 | 37.779135818895 | -122.434671923313 | (37.779135818895, -122.434671923313) | ||
23102 | 23102 | 13270 | DPW Maintained 3 | Tristania conferta :: 79 | 2498 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/13/2000 12:00:00 AM | 9 | 3x3 | 6000499.2901 | 2119275.2189 | 37.7991525665006 | -122.442382681808 | (37.7991525665006, -122.442382681808) | ||
15225 | 15225 | 22440 | Permitted Site 1 | Tristania conferta :: 79 | 6025 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/11/2001 12:00:00 AM | 3 | 3X3 | 6013624.7927 | 2091445.832 | 37.723478536743 | -122.395013371509 | (37.723478536743, -122.395013371509) | ||
23200 | 23200 | 22221 | DPW Maintained 3 | Tristania conferta :: 79 | 4301 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/1997 12:00:00 AM | 2 | 3x3 | 6015398.3252 | 2096867.7861 | 37.7384645963363 | -122.389260963878 | (37.7384645963363, -122.389260963878) | ||
178219 | 178219 | 48780 | Permitted Site 1 | Tristania conferta :: 79 | 1366(REVISED) Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | 5 | Permit Number 46035 | 6003524.5015 | 2112470.6769 | 37.780640986928894 | -122.431428406628 | (37.7806409869289, -122.431428406628) | ||
31075 | 31075 | 58326 | Permitted Site 1 | Tristania conferta :: 79 | 25 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/1978 12:00:00 AM | 10 | Permit Number 17351 | 5998207.5443 | 2111574.8319 | 37.7778784539283 | -122.44975764634701 | (37.7778784539283, -122.449757646347) | ||
47782 | 47782 | 58329 | Permitted Site 1 | Tristania conferta :: 79 | 53 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/1978 12:00:00 AM | 14 | Permit Number 17354 | 5998224.3786 | 2111460.8397 | 37.7775664240249 | -122.449691194319 | (37.7775664240249, -122.449691194319) | ||
52690 | 52690 | 58335 | Permitted Site 1 | Tristania conferta :: 79 | 22 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/1978 12:00:00 AM | 17 | Permit Number 17360 | 5998246.0227 | 2111590.7043 | 37.777924236821896 | -122.449625680736 | (37.7779242368219, -122.449625680736) | ||
54423 | 54423 | 58327 | Permitted Site 1 | Tristania conferta :: 79 | 35 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/1978 12:00:00 AM | 14 | Permit Number 17352 | 5998213.7971 | 2111534.9106 | 37.7777691981302 | -122.449733138233 | (37.7777691981302, -122.449733138233) | ||
67339 | 67339 | 58328 | Permitted Site 1 | Tristania conferta :: 79 | 41 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/1978 12:00:00 AM | 18 | Permit Number 17353 | 5998217.1639 | 2111509.8996 | 37.7777007170302 | -122.449719688547 | (37.7777007170302, -122.449719688547) | ||
174143 | 174143 | 58337 | Permitted Site 1 | Tristania conferta :: 79 | 1593 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/1978 12:00:00 AM | 12 | Permit Number 17362 | 6000161.6495 | 2110915.9391 | 37.77618090905529 | -122.442950404096 | (37.7761809090553, -122.442950404096) | ||
179187 | 179187 | 58330 | Permitted Site 1 | Tristania conferta :: 79 | 61 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/1978 12:00:00 AM | 15 | Permit Number 17355 | 5998228.2265 | 2111432.4618 | 37.777488725806705 | -122.44967583774799 | (37.7774887258067, -122.449675837748) | ||
55706 | 55706 | 79436 | Undocumented 2 | Tristania conferta :: 79 | 606 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 7 | 6004047.0413 | 2110853.2815 | 37.7762296204821 | -122.429505312147 | (37.7762296204821, -122.429505312147) | ||
6125 | 6125 | 6977 | DPW Maintained 3 | Tristania conferta :: 79 | 748 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/30/1990 12:00:00 AM | 12 | 3X3 | 6003831.4789 | 2110436.0515 | 37.775071802393896 | -122.43022122824699 | (37.7750718023939, -122.430221228247) | ||
59402 | 59402 | 82190 | Permitted Site 1 | Tristania conferta :: 79 | 1954 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49859 | 5989124.369 | 2102026.7679 | 37.751138201669 | -122.48048007964701 | (37.751138201669, -122.480480079647) | |
60940 | 60940 | 81428 | Permitted Site 1 | Tristania conferta :: 79 | 2015 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49852 | 5990022.9826 | 2101627.3481 | 37.7500936819126 | -122.477343424721 | (37.7500936819126, -122.477343424721) | |
167083 | 167083 | 32805 | Permitted Site 1 | Tristania conferta :: 79 | 1690 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 18 | Permit Number 37166 | 5999795.9625 | 2110223.9545 | 37.774260039648 | -122.444165674595 | (37.774260039648, -122.444165674595) | |
5304 | 5304 | 5192 | DPW Maintained 3 | Tristania conferta :: 79 | 553 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/27/1992 12:00:00 AM | 6 | 3X3 | 6001623.3101 | 2110351.6501 | 37.7747147390438 | -122.437853707483 | (37.7747147390438, -122.437853707483) | ||
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) | ||
2017 | 2017 | 13264 | DPW Maintained 3 | Tristania conferta :: 79 | 2460 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 19 | 3X3 | 6000672.0217 | 2119297.5934 | 37.7992238445501 | -122.441786579885 | (37.7992238445501, -122.441786579885) | ||
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) | ||
6020 | 6020 | 13137 | DPW Maintained 3 | Tristania conferta :: 79 | 1769 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6003915.4564 | 2119670.1702 | 37.8004311181643 | -122.430589781889 | (37.8004311181643, -122.430589781889) | ||
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) | ||
7529 | 7529 | 13218 | DPW Maintained 3 | Tristania conferta :: 79 | 2230 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 20 | 3X3 | 6001666.6293 | 2119436.4581 | 37.799661752140295 | -122.43835485597299 | (37.7996617521403, -122.438354855973) | ||
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) | ||
8455 | 8455 | 13169 | DPW Maintained 3 | Tristania conferta :: 79 | 1929 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6003141.2876 | 2119559.1387 | 37.8000823670196 | -122.433260775641 | (37.8000823670196, -122.433260775641) | ||
1978 | 1978 | 141844 | DPW Maintained 3 | Tristania conferta :: 79 | 1295 EDDY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 09:40:00 AM | 8 | Width 0ft | 6004339.0372 | 2112890.3204 | 37.781839354336 | -122.428640459804 | (37.781839354336, -122.428640459804) | ||
9532 | 9532 | 2443 | DPW Maintained 3 | Tristania conferta :: 79 | 1296X Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/22/1990 12:00:00 AM | 12 | 3X3 | 6004305.6638 | 2112931.8799 | 37.7819515776166 | -122.42875887985501 | (37.7819515776166, -122.428758879855) | ||
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) | |||
4692 | 4692 | 6906 | DPW Maintained 3 | Tristania conferta :: 79 | 333 Fell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/2017 09:59:00 AM | 3 | 3X3 | 6005816.7808 | 2110662.8487 | 37.7758067801978 | -122.423369750882 | (37.7758067801978, -122.423369750882) | ||
4690 | 4690 | 253527 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/2017 09:54:00 AM | 3 | 3X3 | 6005589.149 | 2109643.5092 | 37.7729950707153 | -122.424084680793 | (37.7729950707153, -122.424084680793) | ||
39695 | 39695 | 65945 | Permitted Site 1 | Tristania conferta :: 79 | 528 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/19/1991 12:00:00 AM | 12 | Permit Number 28966 | 6007615.5081 | 2113146.6876 | 37.7827281591619 | -122.41732353906299 | (37.7827281591619, -122.417323539063) | |
3181 | 3181 | 18082 | DPW Maintained 3 | Tristania conferta :: 79 | 2970 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/17/2009 12:00:00 AM | 6 | 3X3 | 5999722.7619 | 2114728.5921 | 37.786624438592604 | -122.44474274230801 | (37.7866244385926, -122.444742742308) | ||
46832 | 46832 | 94612 | Permitted Site 1 | Tristania conferta :: 79 | 5600@ Armstrong 03rd St | 3 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 4 | Permit Number 53777 | 6013990.2772 | 2092621.1644 | 37.726726080275604 | -122.393832179047 | (37.7267260802756, -122.393832179047) | ||
4445 | 4445 | 13100 | DPW Maintained 3 | Tristania conferta :: 79 | 1501 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/12/2017 12:00:00 AM | 8 | 3X3 | 6005075.7106 | 2119828.8842 | 37.800932566852005 | -122.42658614308701 | (37.800932566852, -122.426586143087) | ||
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) | ||
23349 | 23349 | 6988 | DPW Maintained 3 | Tristania conferta :: 79 | 843 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/11/1990 12:00:00 AM | 11 | 3X3 | 6003376.2775 | 2110319.6203 | 37.7747263179186 | -122.431787553866 | (37.7747263179186, -122.431787553866) | ||
169224 | 169224 | 89053 | Permitted Site 1 | Tristania conferta :: 79 | 2420 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2008 12:00:00 AM | 11 | 3x3 | Permit Number 51790 | 6000877.1335 | 2114188.3074 | 37.7852067638224 | -122.440710137812 | (37.7852067638224, -122.440710137812) | |
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) | ||
32641 | 32641 | 32360 | Permitted Site 1 | Tristania conferta :: 79 | 1660 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | 12 | Permit Number 36912 | 6010075.9386 | 2119846.6344 | 37.8012627139137 | -122.409284411348 | (37.8012627139137, -122.409284411348) | ||
153560 | 153560 | 32359 | Permitted Site 1 | Tristania conferta :: 79 | 1660 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | 8 | Permit Number 36912 | 6010078.2473 | 2119834.5139 | 37.8012295633542 | -122.40927556638901 | (37.8012295633542, -122.409275566389) | |
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) | ||
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) | ||
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) | ||
17853 | 17853 | 10365 | DPW Maintained 3 | Tristania conferta :: 79 | 1158 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/01/2001 12:00:00 AM | 20 | 3X3 | 6000552.7964 | 2108940.2901 | 37.7707785679811 | -122.44145552457199 | (37.7707785679811, -122.441455524572) | ||
19252 | 19252 | 10388 | DPW Maintained 3 | Tristania conferta :: 79 | 1354 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/26/2007 12:00:00 AM | 3 | 3X3 | 5999661.5734 | 2108814.8136 | 37.770383228179895 | -122.44452925228799 | (37.7703832281799, -122.444529252288) | ||
20800 | 20800 | 10428 | Permitted Site 1 | Tristania conferta :: 79 | 1427 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2007 12:00:00 AM | 3 | 3X3 | 5999264.0192 | 2108708.6767 | 37.7700691107077 | -122.44589675291799 | (37.7700691107077, -122.445896752918) | ||
135276 | 135276 | 57431 | Permitted Site 1 | Tristania conferta :: 79 | 1933 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/1991 12:00:00 AM | 8 | Permit Number 30044 | 6003885.286 | 2115132.8962 | 37.787971214872705 | -122.43037027907499 | (37.7879712148727, -122.430370279075) | ||
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) | ||
6095 | 6095 | 12343 | DPW Maintained 3 | Tristania conferta :: 79 | 1200 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/16/1993 12:00:00 AM | 6 | 4X4 | 6004715.5822 | 2113048.0527 | 37.7822937509983 | -122.42734902850401 | (37.7822937509983, -122.427349028504) | ||
8127 | 8127 | 12344 | DPW Maintained 3 | Tristania conferta :: 79 | 1200 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/16/1993 12:00:00 AM | 6 | 4X4 | 6004712.8065 | 2113066.0947 | 37.782343132875795 | -122.427359916847 | (37.7823431328758, -122.427359916847) | ||
19111 | 19111 | 17052 | DPW Maintained 3 | Tristania conferta :: 79 | 1255 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/14/1994 12:00:00 AM | 6 | 3X3 | 6001023.1352 | 2109648.8483 | 37.7727508752792 | -122.439879428361 | (37.7727508752792, -122.439879428361) | ||
3047 | 3047 | 246310 | DPW Maintained 3 | Tristania conferta :: 79 | 1601 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/06/2012 10:05:00 AM | 2 | Width 0ft | 6007075.5388 | 2109348.1328 | 37.7722678469563 | -122.41892211112301 | (37.7722678469563, -122.418922111123) | ||
19714 | 19714 | 10469 | DPW Maintained 3 | Tristania conferta :: 79 | 1608 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/06/2011 12:00:00 AM | 3 | 3x3 | 5998376.833 | 2108635.1438 | 37.769816509818796 | -122.44896020681499 | (37.7698165098188, -122.448960206815) | ||
21334 | 21334 | 10471 | DPW Maintained 3 | Tristania conferta :: 79 | 1628 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/06/2011 12:00:00 AM | 1 | 3x3 | 5998338.8079 | 2108630.4441 | 37.769801430915706 | -122.44909139548 | (37.7698014309157, -122.44909139548) | ||
9292 | 9292 | 18027 | Permitted Site 1 | Tristania conferta :: 79 | 2770 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/2011 12:00:00 AM | 4 | 3x3 | 6000645.3835 | 2114854.2782 | 37.7870221472222 | -122.441559726807 | (37.7870221472222, -122.441559726807) | ||
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) | ||
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) | ||
6193 | 6193 | 5895 | DPW Maintained 3 | Tristania conferta :: 79 | 1148 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/01/1992 12:00:00 AM | 6 | 3x3 | 6004928.6171 | 2113019.6018 | 37.7822276779046 | -122.426609995389 | (37.7822276779046, -122.426609995389) | ||
6570 | 6570 | 5899 | DPW Maintained 3 | Tristania conferta :: 79 | 1180 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6004803.0167 | 2113001.5597 | 37.7821710372677 | -122.42704323134701 | (37.7821710372677, -122.427043231347) | ||
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) |
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");