trees
1,377 rows where qSpecies_id = 61 sorted by PlantDate descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31069 | 50648 | DPW Maintained 1 | Tristania conferta :: 61 | 821 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | 4 | Permit Number 47233 | 6012137.5662 | 2112614.0037 | 37.7815189132409 | -122.401641589024 | (37.7815189132409, -122.401641589024) | 6 | 2 | 9 | 28856 | 34 | ||
| 74845 | 50647 | DPW Maintained 1 | Tristania conferta :: 61 | 821 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | 4 | Permit Number 47233 | 6012121.5394 | 2112599.3505 | 37.7814777846222 | -122.401696004131 | (37.7814777846222, -122.401696004131) | 6 | 2 | 9 | 28856 | 34 | ||
| 58879 | 49069 | Permitted Site 7 | Tristania conferta :: 61 | 1298 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | 3x3 | Permit Number 776020 | 5995836.31315767 | 2092013.47244835 | 37.7240319217297 | -122.45654557668 | (37.7240319217297, -122.45654557668) | 9 | 8 | 4 | 28861 | 40 | ||
| 190391 | 17051 | DPW Maintained 1 | Tristania conferta :: 61 | 1235 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774567 | 6001055.3761 | 2109653.1693 | 37.7727645748724 | -122.43976821361 | (37.7727645748724, -122.43976821361) | 15 | 5 | 11 | 29492 | 9 | |
| 8843 | 57906 | DPW Maintained 1 | Tristania conferta :: 61 | 643 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 13 | Permit Number 20197 | 6000071.8454 | 2111132.0779 | 37.7767692506982 | -122.443276587526 | (37.7767692506982, -122.443276587526) | 15 | 5 | 11 | 29492 | 16 | |
| 10761 | 60596 | DPW Maintained 1 | Tristania conferta :: 61 | 1773 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 18 | Permit Number 20216 | 6000702.1439 | 2111336.8084 | 37.7773673101232 | -122.441110894469 | (37.7773673101232, -122.441110894469) | 15 | 5 | 11 | 29492 | 41 | |
| 15026 | 60579 | DPW Maintained 1 | Tristania conferta :: 61 | 556 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 13 | Permit Number 20193 | 6000143.5821 | 2110857.5211 | 37.7760194779825 | -122.443008707696 | (37.7760194779825, -122.443008707696) | 15 | 5 | 11 | 29492 | 16 | |
| 18547 | 41551 | DPW Maintained 1 | Tristania conferta :: 61 | 627 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 11 | Permit Number 42073 | 6000076.2449 | 2111080.2993 | 37.7766273307268 | -122.443257648559 | (37.7766273307268, -122.443257648559) | 15 | 5 | 11 | 29492 | 16 | |
| 36451 | 18237 | DPW Maintained 1 | Tristania conferta :: 61 | 1790X Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2007 12:00:00 AM | 4 | 4X4 | 6003723.9754 | 2114242.1212 | 37.7855162327444 | -122.43086478876 | (37.7855162327444, -122.43086478876) | 13 | 9 | 11 | 29490 | 13 | ||
| 168786 | 18236 | DPW Maintained 1 | Tristania conferta :: 61 | 1790X Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2007 12:00:00 AM | 3 | 4X4 | 6003740.4545 | 2114242.592 | 37.7855184591156 | -122.430807809552 | (37.7855184591156, -122.430807809552) | 13 | 9 | 11 | 29490 | 13 | ||
| 37992 | 22342 | DPW Maintained 1 | Tristania conferta :: 61 | 5256 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/23/1997 12:00:00 AM | 6 | 3X3 | 6014378.1352 | 2093759.8228 | 37.7298741534257 | -122.392570970493 | (37.7298741534257, -122.392570970493) | 10 | 3 | 8 | 58 | 1 | ||
| 128869 | 103963 | DPW Maintained 1 | Tristania conferta :: 61 | 2534 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2015 12:00:00 AM | 0 | Permit Number 773267 | 6000467 | 2114127 | 37.7850150648369 | -122.442124666784 | (37.7850150648369, -122.442124666784) | 15 | 6 | 1 | 29490 | 27 | ||
| 107065 | 22174 | DPW Maintained 1 | Tristania conferta :: 61 | 3900 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1995 12:00:00 AM | 3 | 3X3 | 6015675.1373 | 2098078.9572 | 37.7418055667015 | -122.388388385005 | (37.7418055667015, -122.388388385005) | 10 | 3 | 8 | 58 | 1 | ||
| 1178 | 7095 | DPW Maintained 1 | Tristania conferta :: 61 | 1970 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1994 12:00:00 AM | 18 | 3X3 | 5998027.6156 | 2109626.606 | 37.7725188329855 | -122.45023961224 | (37.7725188329855, -122.45023961224) | 15 | 5 | 11 | 29492 | 16 | ||
| 67027 | 14465 | DPW Maintained 1 | Tristania conferta :: 61 | 161 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1994 12:00:00 AM | 50 | 3X3 | 5998884.4079 | 2112430.1793 | 37.7802657190757 | -122.447477731101 | (37.7802657190757, -122.447477731101) | 15 | 5 | 2 | 54 | 16 | ||
| 97672 | 14454 | DPW Maintained 1 | Tristania conferta :: 61 | 109 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/1994 12:00:00 AM | 60 | 3X3 | 5998851.581 | 2112620.0339 | 37.7807851345871 | -122.447604964541 | (37.7807851345871, -122.447604964541) | 15 | 5 | 2 | 54 | 16 | ||
| 170134 | 7101 | DPW Maintained 1 | Tristania conferta :: 61 | 2070 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/1994 12:00:00 AM | 6 | 4X4 | 5997541.7411 | 2109558.8408 | 37.7723049499053 | -122.451915402773 | (37.7723049499053, -122.451915402773) | 15 | 5 | 11 | 29492 | 16 | ||
| 76512 | 22419 | DPW Maintained 1 | Tristania conferta :: 61 | 5815 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/19/2000 12:00:00 AM | 3 | 3x3 | 6013854.3759 | 2092034.5068 | 37.7251076834032 | -122.394260933329 | (37.7251076834032, -122.394260933329) | 10 | 3 | 8 | 58 | 1 | ||
| 99438 | 5904 | DPW Maintained 1 | Tristania conferta :: 61 | 1256 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6004447.9733 | 2112952.6596 | 37.782016686789 | -122.428268035802 | (37.782016686789, -122.428268035802) | 7 | 9 | 11 | 29490 | 41 | ||
| 137923 | 22393 | DPW Maintained 1 | Tristania conferta :: 61 | 5700 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2000 12:00:00 AM | 3 | 3X3 | 6013906.4177 | 2092399.467 | 37.7261126832633 | -122.394106567258 | (37.7261126832633, -122.394106567258) | 10 | 3 | 8 | 58 | 1 | ||
| 146500 | 22394 | DPW Maintained 1 | Tristania conferta :: 61 | 5700 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2000 12:00:00 AM | 3 | 3X3 | 6013900.6343 | 2092382.1168 | 37.7260647216629 | -122.394125346164 | (37.7260647216629, -122.394125346164) | 10 | 3 | 8 | 58 | 1 | ||
| 33638 | 27330 | DPW Maintained 1 | Tristania conferta :: 61 | 348 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/1998 12:00:00 AM | 25 | 4X4 | 6004421.6425 | 2109483.8508 | 37.7724907010193 | -122.4281118499 | (37.7724907010193, -122.4281118499) | 7 | 9 | 11 | 28852 | 10 | ||
| 120464 | 27329 | DPW Maintained 1 | Tristania conferta :: 61 | 342 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/1998 12:00:00 AM | 25 | 4X4 | 6004444.7102 | 2109487.8877 | 37.7725030904657 | -122.428032344144 | (37.7725030904657, -122.428032344144) | 7 | 9 | 11 | 28852 | 10 | ||
| 66751 | 7042 | DPW Maintained 1 | Tristania conferta :: 61 | 1300 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2009 12:00:00 AM | 3 | 3X3 | 6001153.5455 | 2110065.6201 | 37.7739026486508 | -122.439458206831 | (37.7739026486508, -122.439458206831) | 15 | 5 | 11 | 29492 | 10 | ||
| 106679 | 13268 | DPW Maintained 1 | Tristania conferta :: 61 | 2467 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2002 12:00:00 AM | 3 | 3X3 | 6000591.5664 | 2119207.4707 | 37.7989718069145 | -122.442058509671 | (37.7989718069145, -122.442058509671) | 13 | 9 | 1 | 57 | 17 | ||
| 62655 | 9589 | DPW Maintained 1 | Tristania conferta :: 61 | 1320 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/1997 12:00:00 AM | 6 | 3X3 | 6003248.1509 | 2112093.2525 | 37.7795890076566 | -122.432357471075 | (37.7795890076566, -122.432357471075) | 15 | 9 | 11 | 29490 | 41 | ||
| 73886 | 7092 | DPW Maintained 1 | Tristania conferta :: 61 | 1926 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2009 12:00:00 AM | 3 | 3X3 | 5998180.0393 | 2109648.8744 | 37.7725886979314 | -122.449713970747 | (37.7725886979314, -122.449713970747) | 15 | 5 | 11 | 29492 | 16 | ||
| 160202 | 13162 | DPW Maintained 1 | Tristania conferta :: 61 | 1901 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/1997 12:00:00 AM | 6 | 3X3 | 6003171.1793 | 2119566.6116 | 37.8001045813382 | -122.433157873196 | (37.8001045813382, -122.433157873196) | 13 | 9 | 1 | 57 | 17 | ||
| 114406 | 9560 | DPW Maintained 1 | Tristania conferta :: 61 | 1201 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/1991 12:00:00 AM | 12 | 3x3 | 6003719.6013 | 2112101.1806 | 37.7796374974752 | -122.430727087996 | (37.7796374974752, -122.430727087996) | 15 | 9 | 11 | 29490 | 41 | ||
| 72071 | 7005 | DPW Maintained 1 | Tristania conferta :: 61 | 1001 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/1999 12:00:00 AM | 3 | 3X3 | 6002577.0261 | 2110209.591 | 37.7743788659974 | -122.434544454712 | (37.7743788659974, -122.434544454712) | 15 | 5 | 11 | 29492 | 10 | ||
| 114160 | 13290 | DPW Maintained 1 | Tristania conferta :: 61 | 2665 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/03/1997 12:00:00 AM | 6 | 3X3 | 5999641.675 | 2119108.3375 | 37.7986454362464 | -122.445338306635 | (37.7986454362464, -122.445338306635) | 13 | 9 | 1 | 57 | 17 | ||
| 189492 | 33674 | DPW Maintained 1 | Tristania conferta :: 61 | 672 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 4 | Permit Number 37756 | 6004147.6576 | 2110988.6622 | 37.7766070388542 | -122.429166908178 | (37.7766070388542, -122.429166908178) | 7 | 9 | 11 | 28852 | 10 | ||
| 38204 | 41235 | DPW Maintained 1 | Tristania conferta :: 61 | 270 Masonic Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1999 12:00:00 AM | 14 | Permit Number 41940 | 5998984.5808 | 2112167.7332 | 37.7795508339841 | -122.44711229551 | (37.7795508339841, -122.44711229551) | 15 | 5 | 1 | 54 | 16 | ||
| 107579 | 114595 | DPW Maintained 1 | Tristania conferta :: 61 | 2584 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 775079 | 6000253.6 | 2114128.6 | 37.7850072942162 | -122.442863075731 | (37.7850072942162, -122.442863075731) | 15 | 6 | 1 | 29490 | 27 | |||
| 170156 | 114594 | DPW Maintained 1 | Tristania conferta :: 61 | 2584 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 775079 | 6000253.6 | 2114128.6 | 37.7850072942162 | -122.442863075731 | (37.7850072942162, -122.442863075731) | 15 | 6 | 1 | 29490 | 27 | |||
| 58559 | 16868 | DPW Maintained 1 | Tristania conferta :: 61 | 240 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1995 12:00:00 AM | 11 | 3X3 | 6005810.7253 | 2110367.9458 | 37.7749967064605 | -122.423369729341 | (37.7749967064605, -122.423369729341) | 7 | 9 | 11 | 28852 | 10 | ||
| 17454 | 55475 | DPW Maintained 1 | Tristania conferta :: 61 | 1290 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1972 12:00:00 AM | 9 | Permit Number 11427 | 6001668.0931 | 2110827.7285 | 37.7760244773884 | -122.437732898122 | (37.7760244773884, -122.437732898122) | 15 | 5 | 11 | 29492 | 10 | |
| 72260 | 55480 | DPW Maintained 1 | Tristania conferta :: 61 | 501 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | 17 | 8x6 | Permit Number 11433 | 6002131.5729 | 2110303.9871 | 37.7746127570805 | -122.436092114636 | (37.7746127570805, -122.436092114636) | 15 | 5 | 11 | 29492 | 10 | |
| 143756 | 65429 | DPW Maintained 1 | Tristania conferta :: 61 | 679 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/28/1989 12:00:00 AM | 9 | Permit Number 28288 | 6010678.2615 | 2116199.1916 | 37.7912814481387 | -122.406942874303 | (37.7912814481387, -122.406942874303) | 5 | 1 | 10 | 28857 | 6 | |
| 92855 | 57971 | DPW Maintained 1 | Tristania conferta :: 61 | 535 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 16 | Permit Number 19405 | 5999675.0078 | 2110381.8765 | 37.7746867521579 | -122.444595430155 | (37.7746867521579, -122.444595430155) | 15 | 5 | 11 | 29492 | 16 | |
| 3148 | 24262 | DPW Maintained 1 | Tristania conferta :: 61 | 600X Willow St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2004 12:00:00 AM | 3 | 3X3 | 6004514.0905 | 2113119.5269 | 37.7824786038336 | -122.428051195433 | (37.7824786038336, -122.428051195433) | 7 | 9 | 11 | 29490 | 41 | ||
| 44579 | 24261 | DPW Maintained 1 | Tristania conferta :: 61 | 600X Willow St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2004 12:00:00 AM | 5 | 3X3 | 6004538.0187 | 2113122.6754 | 37.7824886025731 | -122.427968638693 | (37.7824886025731, -122.427968638693) | 7 | 9 | 11 | 29490 | 41 | ||
| 191127 | 24257 | DPW Maintained 1 | Tristania conferta :: 61 | 600X Willow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2004 12:00:00 AM | 5 | 3X3 | 6004635.8921 | 2113135.7984 | 37.782530171668 | -122.427630974469 | (37.782530171668, -122.427630974469) | 7 | 9 | 11 | 29490 | 41 | ||
| 164771 | 9640 | DPW Maintained 1 | Tristania conferta :: 61 | 1475 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2002 12:00:00 AM | 3 | 3X3 | 6002575.9976 | 2111942.0905 | 37.779135818895 | -122.434671923313 | (37.779135818895, -122.434671923313) | 15 | 5 | 11 | 29490 | 41 | ||
| 69876 | 13270 | DPW Maintained 1 | Tristania conferta :: 61 | 2498 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/13/2000 12:00:00 AM | 9 | 3x3 | 6000499.2901 | 2119275.2189 | 37.7991525665006 | -122.442382681808 | (37.7991525665006, -122.442382681808) | 13 | 9 | 1 | 57 | 17 | ||
| 82971 | 22440 | DPW Maintained 1 | Tristania conferta :: 61 | 6025 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/11/2001 12:00:00 AM | 3 | 3X3 | 6013624.7927 | 2091445.832 | 37.723478536743 | -122.395013371509 | (37.723478536743, -122.395013371509) | 10 | 3 | 8 | 58 | 1 | ||
| 121148 | 22221 | DPW Maintained 1 | Tristania conferta :: 61 | 4301 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/10/1997 12:00:00 AM | 2 | 3x3 | 6015398.3252 | 2096867.7861 | 37.7384645963363 | -122.389260963878 | (37.7384645963363, -122.389260963878) | 10 | 3 | 8 | 58 | 1 | ||
| 83144 | 48780 | DPW Maintained 1 | Tristania conferta :: 61 | 1366(REVISED) Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2002 12:00:00 AM | 5 | Permit Number 46035 | 6003524.5015 | 2112470.6769 | 37.7806409869289 | -122.431428406628 | (37.7806409869289, -122.431428406628) | 15 | 9 | 11 | 29490 | 41 | ||
| 37850 | 58330 | DPW Maintained 1 | Tristania conferta :: 61 | 61 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/1978 12:00:00 AM | 15 | Permit Number 17355 | 5998228.2265 | 2111432.4618 | 37.7774887258067 | -122.449675837748 | (37.7774887258067, -122.449675837748) | 15 | 6 | 2 | 54 | 16 | ||
| 52751 | 58328 | DPW Maintained 1 | Tristania conferta :: 61 | 41 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/1978 12:00:00 AM | 18 | Permit Number 17353 | 5998217.1639 | 2111509.8996 | 37.7777007170302 | -122.449719688547 | (37.7777007170302, -122.449719688547) | 15 | 6 | 2 | 54 | 16 | ||
| 67678 | 58335 | DPW Maintained 1 | Tristania conferta :: 61 | 22 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/1978 12:00:00 AM | 17 | Permit Number 17360 | 5998246.0227 | 2111590.7043 | 37.7779242368219 | -122.449625680736 | (37.7779242368219, -122.449625680736) | 15 | 6 | 2 | 54 | 16 | ||
| 73998 | 58329 | DPW Maintained 1 | Tristania conferta :: 61 | 53 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/1978 12:00:00 AM | 14 | Permit Number 17354 | 5998224.3786 | 2111460.8397 | 37.7775664240249 | -122.449691194319 | (37.7775664240249, -122.449691194319) | 15 | 6 | 2 | 54 | 16 | ||
| 74351 | 58327 | DPW Maintained 1 | Tristania conferta :: 61 | 35 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/1978 12:00:00 AM | 14 | Permit Number 17352 | 5998213.7971 | 2111534.9106 | 37.7777691981302 | -122.449733138233 | (37.7777691981302, -122.449733138233) | 15 | 6 | 2 | 54 | 16 | ||
| 156041 | 58326 | DPW Maintained 1 | Tristania conferta :: 61 | 25 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/1978 12:00:00 AM | 10 | Permit Number 17351 | 5998207.5443 | 2111574.8319 | 37.7778784539283 | -122.449757646347 | (37.7778784539283, -122.449757646347) | 15 | 6 | 2 | 54 | 16 | ||
| 184432 | 58337 | DPW Maintained 1 | Tristania conferta :: 61 | 1593 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/1978 12:00:00 AM | 12 | Permit Number 17362 | 6000161.6495 | 2110915.9391 | 37.7761809090553 | -122.442950404096 | (37.7761809090553, -122.442950404096) | 15 | 5 | 11 | 29492 | 16 | ||
| 85005 | 6977 | DPW Maintained 1 | Tristania conferta :: 61 | 748 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/30/1990 12:00:00 AM | 12 | 3X3 | 6003831.4789 | 2110436.0515 | 37.7750718023939 | -122.430221228247 | (37.7750718023939, -122.430221228247) | 7 | 9 | 11 | 29492 | 10 | ||
| 65634 | 81428 | DPW Maintained 1 | Tristania conferta :: 61 | 2015 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49852 | 5990022.9826 | 2101627.3481 | 37.7500936819126 | -122.477343424721 | (37.7500936819126, -122.477343424721) | 1 | 8 | 3 | 29491 | 35 | |
| 74206 | 82190 | DPW Maintained 1 | Tristania conferta :: 61 | 1954 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49859 | 5989124.369 | 2102026.7679 | 37.751138201669 | -122.480480079647 | (37.751138201669, -122.480480079647) | 1 | 8 | 3 | 29491 | 35 | |
| 84708 | 32805 | DPW Maintained 1 | Tristania conferta :: 61 | 1690 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 18 | Permit Number 37166 | 5999795.9625 | 2110223.9545 | 37.774260039648 | -122.444165674595 | (37.774260039648, -122.444165674595) | 15 | 5 | 11 | 29492 | 16 | |
| 76079 | 5192 | DPW Maintained 1 | Tristania conferta :: 61 | 553 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/27/1992 12:00:00 AM | 6 | 3X3 | 6001623.3101 | 2110351.6501 | 37.7747147390438 | -122.437853707483 | (37.7747147390438, -122.437853707483) | 15 | 5 | 11 | 29492 | 10 | ||
| 10876 | 13180 | DPW Maintained 1 | Tristania conferta :: 61 | 1990 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 15 | 3X3 | 6002882.226 | 2119605.2218 | 37.8001941994801 | -122.434160523596 | (37.8001941994801, -122.434160523596) | 13 | 9 | 1 | 57 | 17 | ||
| 31794 | 13264 | DPW Maintained 1 | Tristania conferta :: 61 | 2460 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 19 | 3X3 | 6000672.0217 | 2119297.5934 | 37.7992238445501 | -122.441786579885 | (37.7992238445501, -122.441786579885) | 13 | 9 | 1 | 57 | 17 | ||
| 87468 | 13137 | DPW Maintained 1 | Tristania conferta :: 61 | 1769 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6003915.4564 | 2119670.1702 | 37.8004311181643 | -122.430589781889 | (37.8004311181643, -122.430589781889) | 13 | 9 | 1 | 57 | 17 | ||
| 109318 | 13106 | DPW Maintained 1 | Tristania conferta :: 61 | 1557 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 40 | 3x3 | 6004949.0522 | 2119813.2474 | 37.8008824710059 | -122.427023320732 | (37.8008824710059, -122.427023320732) | 13 | 9 | 1 | 57 | 17 | ||
| 111240 | 13151 | DPW Maintained 1 | Tristania conferta :: 61 | 1850 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 6 | 3x3 | 6003502.6435 | 2119692.0618 | 37.8004678320559 | -122.432019843179 | (37.8004678320559, -122.432019843179) | 13 | 9 | 1 | 57 | 17 | ||
| 128758 | 13116 | DPW Maintained 1 | Tristania conferta :: 61 | 1627 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 20 | 3x3 | 6004563.6038 | 2119765.555 | 37.8007297168722 | -122.428353733906 | (37.8007297168722, -122.428353733906) | 13 | 9 | 1 | 57 | 17 | ||
| 138386 | 13218 | DPW Maintained 1 | Tristania conferta :: 61 | 2230 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 20 | 3X3 | 6001666.6293 | 2119436.4581 | 37.7996617521403 | -122.438354855973 | (37.7996617521403, -122.438354855973) | 13 | 9 | 1 | 57 | 17 | ||
| 174986 | 13169 | DPW Maintained 1 | Tristania conferta :: 61 | 1929 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6003141.2876 | 2119559.1387 | 37.8000823670196 | -122.433260775641 | (37.8000823670196, -122.433260775641) | 13 | 9 | 1 | 57 | 17 | ||
| 79641 | 141844 | DPW Maintained 1 | Tristania conferta :: 61 | 1295 EDDY ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 09:40:00 AM | 8 | Width 0ft | 6004339.0372 | 2112890.3204 | 37.781839354336 | -122.428640459804 | (37.781839354336, -122.428640459804) | 7 | 9 | 11 | 29490 | 41 | ||
| 54167 | 2443 | DPW Maintained 1 | Tristania conferta :: 61 | 1296X Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/22/1990 12:00:00 AM | 12 | 3X3 | 6004305.6638 | 2112931.8799 | 37.7819515776166 | -122.428758879855 | (37.7819515776166, -122.428758879855) | 7 | 9 | 11 | 29490 | 41 | ||
| 141684 | 24306 | DPW Maintained 1 | Tristania conferta :: 61 | 1513 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/1994 12:00:00 AM | 3 | 6002219.6394 | 2111892.3425 | 37.7789789862822 | -122.435901149592 | (37.7789789862822, -122.435901149592) | 15 | 5 | 11 | 29490 | 41 | |||
| 59643 | 6906 | DPW Maintained 1 | Tristania conferta :: 61 | 333 Fell St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/2017 09:59:00 AM | 3 | 3X3 | 6005816.7808 | 2110662.8487 | 37.7758067801978 | -122.423369750882 | (37.7758067801978, -122.423369750882) | 7 | 9 | 11 | 28852 | 10 | ||
| 45104 | 253527 | DPW Maintained 1 | Tristania conferta :: 61 | 100 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/2017 09:54:00 AM | 3 | 3X3 | 6005589.149 | 2109643.5092 | 37.7729950707153 | -122.424084680793 | (37.7729950707153, -122.424084680793) | 7 | 9 | 11 | 28852 | 10 | ||
| 45358 | 18082 | DPW Maintained 1 | Tristania conferta :: 61 | 2970 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/17/2009 12:00:00 AM | 6 | 3X3 | 5999722.7619 | 2114728.5921 | 37.7866244385926 | -122.444742742308 | (37.7866244385926, -122.444742742308) | 15 | 6 | 1 | 29490 | 31 | ||
| 94517 | 94612 | DPW Maintained 1 | Tristania conferta :: 61 | 5668@ Armstrong 03rd St | 1 | Sidewalk: Curb side : | Tree | Private 2 | 10/13/2010 12:00:00 AM | 4 | Permit Number 53777 | 6013990.2772 | 2092621.1644 | 37.7267260802756 | -122.393832179047 | (37.7267260802756, -122.393832179047) | 10 | 3 | 8 | 58 | 1 | ||
| 30290 | 13100 | DPW Maintained 1 | Tristania conferta :: 61 | 1501 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/12/2017 12:00:00 AM | 8 | 3X3 | 6005075.7106 | 2119828.8842 | 37.800932566852 | -122.426586143087 | (37.800932566852, -122.426586143087) | 13 | 9 | 1 | 57 | 17 | ||
| 74394 | 251703 | DPW Maintained 1 | Tristania conferta :: 61 | 123 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 10:45:00 AM | 3 | 3x3 | 6004216 | 2094352 | 37.7309305395323 | -122.427744838273 | (37.7309305395323, -122.427744838273) | 9 | 7 | 6 | 28861 | 5 | ||
| 177868 | 6988 | DPW Maintained 1 | Tristania conferta :: 61 | 843 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/11/1990 12:00:00 AM | 11 | 3X3 | 6003376.2775 | 2110319.6203 | 37.7747263179186 | -122.431787553866 | (37.7747263179186, -122.431787553866) | 15 | 9 | 11 | 29492 | 10 | ||
| 87509 | 89053 | DPW Maintained 1 | Tristania conferta :: 61 | 2420 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2008 12:00:00 AM | 11 | 3x3 | Permit Number 51790 | 6000877.1335 | 2114188.3074 | 37.7852067638224 | -122.440710137812 | (37.7852067638224, -122.440710137812) | 15 | 6 | 1 | 29490 | 27 | |
| 130524 | 6253 | DPW Maintained 1 | Tristania conferta :: 61 | 1315 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2004 12:00:00 AM | 9 | 3X3 | 6004522.7205 | 2113262.2432 | 37.7828709555828 | -122.428031512738 | (37.7828709555828, -122.428031512738) | 7 | 9 | 11 | 29490 | 41 | ||
| 129700 | 32359 | DPW Maintained 1 | Tristania conferta :: 61 | 1660 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | 8 | Permit Number 36912 | 6010078.2473 | 2119834.5139 | 37.8012295633542 | -122.409275566389 | (37.8012295633542, -122.409275566389) | 3 | 1 | 10 | 308 | 23 | |
| 130647 | 32360 | DPW Maintained 1 | Tristania conferta :: 61 | 1660 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | 12 | Permit Number 36912 | 6010075.9386 | 2119846.6344 | 37.8012627139137 | -122.409284411348 | (37.8012627139137, -122.409284411348) | 3 | 1 | 10 | 308 | 23 | ||
| 30243 | 13145 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1996 12:00:00 AM | 8 | 3X3 | 6003646.5026 | 2119634.2054 | 37.8003171280845 | -122.431517900376 | (37.8003171280845, -122.431517900376) | 13 | 9 | 1 | 57 | 17 | ||
| 67253 | 13146 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1996 12:00:00 AM | 6 | 3x3 | 6003666.0486 | 2119638.1147 | 37.800328969814 | -122.431450542751 | (37.800328969814, -122.431450542751) | 13 | 9 | 1 | 57 | 17 | ||
| 154379 | 26165 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1996 12:00:00 AM | 10 | 3x3 | 6003705.1408 | 2119642.0239 | 37.8003419189704 | -122.431315547527 | (37.8003419189704, -122.431315547527) | 13 | 9 | 1 | 57 | 17 | ||
| 52298 | 10365 | DPW Maintained 1 | Tristania conferta :: 61 | 1158 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/01/2001 12:00:00 AM | 20 | 3X3 | 6000552.7964 | 2108940.2901 | 37.7707785679811 | -122.441455524572 | (37.7707785679811, -122.441455524572) | 15 | 5 | 11 | 29492 | 9 | ||
| 80936 | 10388 | DPW Maintained 1 | Tristania conferta :: 61 | 1354 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/26/2007 12:00:00 AM | 3 | 3X3 | 5999661.5734 | 2108814.8136 | 37.7703832281799 | -122.444529252288 | (37.7703832281799, -122.444529252288) | 15 | 5 | 11 | 29492 | 9 | ||
| 86662 | 10428 | DPW Maintained 1 | Tristania conferta :: 61 | 1427 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2007 12:00:00 AM | 3 | 3X3 | 5999264.0192 | 2108708.6767 | 37.7700691107077 | -122.445896752918 | (37.7700691107077, -122.445896752918) | 15 | 5 | 11 | 29492 | 9 | ||
| 17387 | 216652 | DPW Maintained 1 | Tristania conferta :: 61 | 329 Faxon Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 09/23/2020 12:00:00 AM | 3 | Width 4ft | 5994725.9247 | 2090785.70947 | 37.7205969659665 | -122.460295076156 | (37.7205969659665, -122.460295076156) | 9 | 8 | 6 | 28861 | 24 | ||
| 184456 | 57431 | DPW Maintained 1 | Tristania conferta :: 61 | 1933 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/1991 12:00:00 AM | 8 | Permit Number 30044 | 6003885.286 | 2115132.8962 | 37.7879712148727 | -122.430370279075 | (37.7879712148727, -122.430370279075) | 13 | 9 | 11 | 29490 | 27 | ||
| 135858 | 6903 | DPW Maintained 1 | Tristania conferta :: 61 | 333 Fell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2017 12:00:00 AM | 3 | 3X3 | 6005734.9676 | 2110651.7554 | 37.7757717028879 | -122.42365197493 | (37.7757717028879, -122.42365197493) | 7 | 9 | 11 | 28852 | 10 | ||
| 79434 | 12343 | DPW Maintained 1 | Tristania conferta :: 61 | 1200 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/16/1993 12:00:00 AM | 6 | 4X4 | 6004715.5822 | 2113048.0527 | 37.7822937509983 | -122.427349028504 | (37.7822937509983, -122.427349028504) | 7 | 9 | 11 | 28858 | 41 | ||
| 153348 | 12344 | DPW Maintained 1 | Tristania conferta :: 61 | 1200 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/16/1993 12:00:00 AM | 6 | 4X4 | 6004712.8065 | 2113066.0947 | 37.7823431328758 | -122.427359916847 | (37.7823431328758, -122.427359916847) | 7 | 9 | 11 | 28858 | 41 | ||
| 84646 | 17052 | DPW Maintained 1 | Tristania conferta :: 61 | 1255 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/14/1994 12:00:00 AM | 6 | 3X3 | 6001023.1352 | 2109648.8483 | 37.7727508752792 | -122.439879428361 | (37.7727508752792, -122.439879428361) | 15 | 5 | 11 | 29492 | 9 | ||
| 104575 | 246310 | DPW Maintained 1 | Tristania conferta :: 61 | 1601 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/06/2012 10:05:00 AM | 2 | Width 0ft | 6007075.5388 | 2109348.1328 | 37.7722678469563 | -122.418922111123 | (37.7722678469563, -122.418922111123) | 8 | 2 | 9 | 28853 | 19 | ||
| 102263 | 10469 | DPW Maintained 1 | Tristania conferta :: 61 | 1608 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/06/2011 12:00:00 AM | 3 | 3x3 | 5998376.833 | 2108635.1438 | 37.7698165098188 | -122.448960206815 | (37.7698165098188, -122.448960206815) | 15 | 5 | 11 | 29492 | 9 | ||
| 169282 | 10471 | DPW Maintained 1 | Tristania conferta :: 61 | 1628 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/06/2011 12:00:00 AM | 1 | 3x3 | 5998338.8079 | 2108630.4441 | 37.7698014309157 | -122.44909139548 | (37.7698014309157, -122.44909139548) | 15 | 5 | 11 | 29492 | 9 | ||
| 112356 | 18027 | DPW Maintained 1 | Tristania conferta :: 61 | 2770 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/03/2011 12:00:00 AM | 4 | 3x3 | 6000645.3835 | 2114854.2782 | 37.7870221472222 | -122.441559726807 | (37.7870221472222, -122.441559726807) | 13 | 6 | 1 | 29490 | 27 | ||
| 61264 | 5883 | DPW Maintained 1 | Tristania conferta :: 61 | 1118 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6005049.3601 | 2113036.9499 | 37.7822821368488 | -122.426193513801 | (37.7822821368488, -122.426193513801) | 7 | 9 | 11 | 28858 | 41 | ||
| 63126 | 5881 | DPW Maintained 1 | Tristania conferta :: 61 | 1106 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6005104.874 | 2113043.8892 | 37.7823043280422 | -122.426001954403 | (37.7823043280422, -122.426001954403) | 7 | 9 | 11 | 28858 | 41 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );