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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52070 | 52070 | 142654 | Undocumented 2 | Tristania conferta :: 79 | 1188 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6007961.2413 | 2121229.1008 | 37.8049399144717 | -122.416700206529 | (37.8049399144717, -122.416700206529) | |||
| 76830 | 76830 | 142653 | Undocumented 2 | Tristania conferta :: 79 | 1188 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6007975.5818 | 2121216.8848 | 37.8049071789669 | -122.416649713579 | (37.8049071789669, -122.416649713579) | |||
| 55536 | 55536 | 142719 | Undocumented 2 | Tristania conferta :: 79 | 1170 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6008016.4786 | 2121177.0503 | 37.8048001035106 | -122.416505361905 | (37.8048001035106, -122.416505361905) | |||
| 7874 | 7874 | 26540 | DPW Maintained 3 | Tristania conferta :: 79 | 530 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6008777.828 | 2121123.8926 | 37.8046969326474 | -122.413866861434 | (37.8046969326474, -122.413866861434) | |||
| 62951 | 62951 | 142704 | Undocumented 2 | Tristania conferta :: 79 | 540 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6008680.9196 | 2121106.7911 | 37.804644533379005 | -122.41420101302299 | (37.804644533379, -122.414201013023) | |||
| 32931 | 32931 | 142689 | Undocumented 2 | Tristania conferta :: 79 | 554 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6008629.0451 | 2121101.0906 | 37.8046259673251 | -122.414380126753 | (37.8046259673251, -122.414380126753) | |||
| 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) | ||
| 181635 | 181635 | 38378 | Permitted Site 1 | Tristania conferta :: 79 | 2027 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1998 12:00:00 AM | 11 | Permit Number 40437 | 6009441.5117 | 2120654.7585 | 37.8034460574359 | -122.411536943543 | (37.8034460574359, -122.411536943543) | ||
| 121378 | 121378 | 99007 | DPW Maintained 3 | Tristania conferta :: 79 | 2099X Beach St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.803316837922104 | -122.442899765771 | (37.8033168379221, -122.442899765771) | ||
| 126814 | 126814 | 99009 | DPW Maintained 3 | Tristania conferta :: 79 | 2099X Beach St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.803316837922104 | -122.442899765771 | (37.8033168379221, -122.442899765771) | ||
| 181354 | 181354 | 72411 | Undocumented 2 | Tristania conferta :: 79 | 475 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 10 | 6x6 | 6010101.0381 | 2120567.585 | 37.803243672381704 | -122.40924846000601 | (37.8032436723817, -122.409248460006) | |
| 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) | ||
| 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) | ||
| 6823 | 6823 | 28076 | DPW Maintained 3 | Tristania conferta :: 79 | 915 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/13/2003 12:00:00 AM | 25 | 3X3 | 6008674.8876 | 2120493.8068 | 37.8029610933815 | -122.41417849255801 | (37.8029610933815, -122.414178492558) | ||
| 102667 | 102667 | 98999 | DPW Maintained 3 | Tristania conferta :: 79 | 2190X North Point St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771149 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | |
| 133582 | 133582 | 64370 | Permitted Site 1 | Tristania conferta :: 79 | 525 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | 7 | Permit Number 25209 | 6010332.9517 | 2120250.0174 | 37.8023847002257 | -122.408423498481 | (37.8023847002257, -122.408423498481) | |
| 25331 | 25331 | 64367 | Permitted Site 1 | Tristania conferta :: 79 | 545 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | 10 | Permit Number 25206 | 6010276.1583 | 2120241.7062 | 37.8023586991127 | -122.408619445814 | (37.8023586991127, -122.408619445814) | |
| 69416 | 69416 | 50978 | Permitted Site 1 | Tristania conferta :: 79 | 807REVISED Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2004 12:00:00 AM | 11 | Permit Number 47464 | 6008954.8893 | 2120241.9921 | 37.8022853965169 | -122.413191720991 | (37.8022853965169, -122.413191720991) | ||
| 23573 | 23573 | 143104 | Undocumented 2 | Tristania conferta :: 79 | 1736 STOCKTON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010039.5193 | 2120117.0378 | 37.8020031344426 | -122.40942953292802 | (37.8020031344426, -122.409429532928) | |||
| 58276 | 58276 | 122823 | Permitted Site 1 | Tristania conferta :: 79 | 1736 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 7 | 4x4 | 6010043.2132 | 2120098.5684 | 37.8019526289989 | -122.409415446027 | (37.8019526289989, -122.409415446027) | ||
| 169377 | 169377 | 122822 | Permitted Site 1 | Tristania conferta :: 79 | 1736 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 6010044.5984 | 2120081.0225 | 37.8019045299018 | -122.40940941357799 | (37.8019045299018, -122.409409413578) | |||
| 151070 | 151070 | 64341 | Permitted Site 1 | Tristania conferta :: 79 | 1736 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1988 12:00:00 AM | 11 | Permit Number 25170 | 6010046.9071 | 2120063.9383 | 37.80185775026089 | -122.40940021798299 | (37.8018577502609, -122.409400217983) | |
| 49458 | 49458 | 142626 | Undocumented 2 | Tristania conferta :: 79 | 735 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6009290.0663 | 2119929.1695 | 37.8014452745633 | -122.412009721134 | (37.8014452745633, -122.412009721134) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 126316 | 126316 | 143237 | Undocumented 2 | Tristania conferta :: 79 | 1550 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004970.9437 | 2119896.9045 | 37.801113409754294 | -122.426953528407 | (37.8011134097543, -122.426953528407) | |||
| 160180 | 160180 | 143236 | Undocumented 2 | Tristania conferta :: 79 | 1550 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004943.5793 | 2119894.559 | 37.8011054222859 | -122.42704805395901 | (37.8011054222859, -122.427048053959) | |||
| 188583 | 188583 | 143113 | Undocumented 2 | Tristania conferta :: 79 | 2775 VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005458.8135 | 2119882.0495 | 37.8011001957164 | -122.425264228759 | (37.8011001957164, -122.425264228759) | |||
| 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) | ||
| 24280 | 24280 | 143114 | Undocumented 2 | Tristania conferta :: 79 | 1463 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005363.4287 | 2119869.54 | 37.801060458669795 | -122.42559341080499 | (37.8010604586698, -122.425593410805) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 73441 | 73441 | 143235 | Undocumented 2 | Tristania conferta :: 79 | 1549 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004978.7622 | 2119817.1566 | 37.8008948846007 | -122.426920790121 | (37.8008948846007, -122.426920790121) | |||
| 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) | ||
| 167727 | 167727 | 143384 | Undocumented 2 | Tristania conferta :: 79 | 1650 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004460.6831 | 2119822.6068 | 37.8008805420914 | -122.428713951546 | (37.8008805420914, -122.428713951546) | |||
| 26424 | 26424 | 143385 | Undocumented 2 | Tristania conferta :: 79 | 1658 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004429.3589 | 2119821.4466 | 37.800875583620794 | -122.428822263738 | (37.8008755836208, -122.428822263738) | |||
| 53481 | 53481 | 143386 | Undocumented 2 | Tristania conferta :: 79 | 1662 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004406.1559 | 2119815.6459 | 37.800858343107706 | -122.42890214211701 | (37.8008583431077, -122.428902142117) | |||
| 65532 | 65532 | 143387 | Undocumented 2 | Tristania conferta :: 79 | 1680 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004355.1091 | 2119807.5248 | 37.800833155227 | -122.42907820616101 | (37.800833155227, -122.429078206161) | |||
| 1247 | 1247 | 13128 | DPW Maintained 3 | Tristania conferta :: 79 | 1714 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6004131.2449 | 2119777.2826 | 37.8007374433085 | -122.42985071173901 | (37.8007374433085, -122.429850711739) | |||
| 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) | ||
| 62156 | 62156 | 51913 | Permitted Site 1 | Tristania conferta :: 79 | 1734 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50189 | 6004067.1338 | 2119771.0279 | 37.8007166387692 | -122.43007211626801 | (37.8007166387692, -122.430072116268) | |
| 40296 | 40296 | 51914 | Permitted Site 1 | Tristania conferta :: 79 | 1738 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50190 | 6004049.1514 | 2119767.1187 | 37.8007048866604 | -122.43013406376998 | (37.8007048866604, -122.43013406377) | |
| 147212 | 147212 | 51915 | Permitted Site 1 | Tristania conferta :: 79 | 1738 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50190 | 6004018.6596 | 2119764.7731 | 37.8006967192313 | -122.430239410546 | (37.8006967192313, -122.430239410546) | |
| 8554 | 8554 | 13141 | DPW Maintained 3 | Tristania conferta :: 79 | 1790 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6003874.0187 | 2119744.4452 | 37.8006327105148 | -122.430738476202 | (37.8006327105148, -122.430738476202) | |||
| 8785 | 8785 | 13129 | Permitted Site 1 | Tristania conferta :: 79 | 1721 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6004129.6812 | 2119699.0984 | 37.800522681160494 | -122.42985054289801 | (37.8005226811605, -122.429850542898) | |||
| 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) | ||
| 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) | |||
| 151406 | 151406 | 30437 | Permitted Site 1 | Tristania conferta :: 79 | 567 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | 12 | Permit Number 90 | 6010234.0616 | 2119544.2672 | 37.8004413456091 | -122.40871589046002 | (37.8004413456091, -122.40871589046) | ||
| 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) | ||
| 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) | |||
| 8450 | 8450 | 13160 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003384.5853 | 2119677.9886 | 37.800422496977795 | -122.43242736604999 | (37.8004224969778, -122.43242736605) | |||
| 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) | |||
| 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) | |||
| 54915 | 54915 | 142501 | Undocumented 2 | Tristania conferta :: 79 | 601 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6010024.9768 | 2119514.2391 | 37.800347183021294 | -122.409437290498 | (37.8003471830213, -122.409437290498) | |||
| 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) | ||
| 149320 | 149320 | 82387 | Undocumented 2 | Tristania conferta :: 79 | 615 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2005 12:00:00 AM | 4 | 6010004.402000001 | 2119511.4587 | 37.8003383958996 | -122.40950829143699 | (37.8003383958996, -122.409508291437) | ||
| 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) | ||
| 63958 | 63958 | 142500 | Undocumented 2 | Tristania conferta :: 79 | 629 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6009964.6425 | 2119505.3419 | 37.8003193727849 | -122.40964544368299 | (37.8003193727849, -122.409645443683) | |||
| 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) | ||
| 8384 | 8384 | 13148 | Permitted Site 1 | Tristania conferta :: 79 | 1839 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1997 12:00:00 AM | 18 | 3X3 | 6003562.8454 | 2119623.2596 | 37.8002823318939 | -122.431806605227 | (37.8002823318939, -122.431806605227) | ||
| 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) | ||
| 179350 | 179350 | 34684 | Permitted Site 1 | Tristania conferta :: 79 | 1863 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 4 | Permit Number 38349 | 6003454.9512 | 2119604.4954 | 37.800224693559606 | -122.43217862062099 | (37.8002246935596, -122.432178620621) | |
| 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) | |||
| 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) | ||
| 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) | |||
| 990 | 990 | 13179 | DPW Maintained 3 | Tristania conferta :: 79 | 1976 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/1997 12:00:00 AM | 14 | 3X3 | 6002902.1538 | 2119607.7128 | 37.8002021701058 | -122.434091743886 | (37.8002021701058, -122.434091743886) | ||
| 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) | ||
| 159080 | 159080 | 142485 | Undocumented 2 | Tristania conferta :: 79 | 1501 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6010091.845 | 2119435.9713 | 37.8001360252908 | -122.409200372911 | (37.8001360252908, -122.409200372911) | |||
| 7143 | 7143 | 13163 | DPW Maintained 3 | Tristania conferta :: 79 | 1901 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003225.9808 | 2119572.2163 | 37.8001230789015 | -122.43296863968 | (37.8001230789015, -122.43296863968) | |||
| 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) | ||
| 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) | ||
| 101738 | 101738 | 13172 | Permitted Site 1 | Tristania conferta :: 79 | 1945X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1997 12:00:00 AM | 4 | 3x3 | 6003080.8814 | 2119554.1567 | 37.8000652607778 | -122.43346944790001 | (37.8000652607778, -122.4334694479) | ||
| 187235 | 187235 | 143123 | Undocumented 2 | Tristania conferta :: 79 | 1999 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002882.226 | 2119527.3787 | 37.799980462636796 | -122.4341549557 | (37.7999804626368, -122.4341549557) | |||
| 146921 | 146921 | 98674 | Permitted Site 1 | Tristania conferta :: 79 | 1520 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6010134.1069 | 2119364.7936 | 37.7999429563689 | -122.409049104677 | (37.7999429563689, -122.409049104677) | |||
| 7522 | 7522 | 13182 | DPW Maintained 3 | Tristania conferta :: 79 | 2001 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x4 | 6002733.3901 | 2119504.96 | 37.7999104584024 | -122.434668379841 | (37.7999104584024, -122.434668379841) | |||
| 131538 | 131538 | 65984 | Permitted Site 1 | Tristania conferta :: 79 | 1520 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1990 12:00:00 AM | 14 | Permit Number 29013 | 6010137.4433 | 2119339.4921 | 37.7998736715658 | -122.409035773182 | (37.7998736715658, -122.409035773182) | |
| 175295 | 175295 | 142498 | Undocumented 2 | Tristania conferta :: 79 | 535 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6009947.0726 | 2119329.9097 | 37.79983669458289 | -122.409693853229 | (37.7998366945829, -122.409693853229) | |||
| 47730 | 47730 | 143149 | Undocumented 2 | Tristania conferta :: 79 | 2200 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001799.8965 | 2119455.7632 | 37.7997223379978 | -122.437895087221 | (37.7997223379978, -122.437895087221) | |||
| 42521 | 42521 | 143150 | Undocumented 2 | Tristania conferta :: 79 | 2218 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001729.5264 | 2119441.44 | 37.799679008415396 | -122.43813756656 | (37.7996790084154, -122.43813756656) | |||
| 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) | ||
| 8463 | 8463 | 13221 | Permitted Site 1 | Tristania conferta :: 79 | 2240 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1997 12:00:00 AM | 12 | 3X3 | 6001619.3007 | 2119428.9852 | 37.799638541433794 | -122.438518094144 | (37.7996385414338, -122.438518094144) | ||
| 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) | ||
| 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) | |||
| 46058 | 46058 | 143151 | Undocumented 2 | Tristania conferta :: 79 | 2300 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6001315.563999999 | 2119391.1109 | 37.7995172663928 | -122.439566414616 | (37.7995172663928, -122.439566414616) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 80311 | 80311 | 108697 | Permitted Site 1 | Tristania conferta :: 79 | 2414 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774621 | 6000824.14262 | 2119316.97174 | 37.7992857188841 | -122.441261581656 | (37.7992857188841, -122.441261581656) |
| 8397 | 8397 | 13233 | DPW Maintained 3 | Tristania conferta :: 79 | 2301X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001245.6832 | 2119299.2908 | 37.7992611751931 | -122.439801639901 | (37.7992611751931, -122.439801639901) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 3926 | 3926 | 13242 | DPW Maintained 3 | Tristania conferta :: 79 | 2353 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001124.6106 | 2119280.6018 | 37.7992029678306 | -122.440219251047 | (37.7992029678306, -122.440219251047) | |||
| 171968 | 171968 | 93015 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; 3-year maintenance agreement through 12/29/12 | 6001036.8533 | 2119267.6007 | 37.7991622735558 | -122.440521987709 | (37.7991622735558, -122.440521987709) |
| 69366 | 69366 | 93014 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; 3-year maintenance agreement through 12/29/12 | 6001021.4146 | 2119265.9756 | 37.7991569323377 | -122.440575294128 | (37.7991569323377, -122.440575294128) |
| 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) |
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");