trees
1,377 rows where qSpecies_id = 61 sorted by Location 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 183503 | 142654 | DPW Maintained 1 | Tristania conferta :: 61 | 1188 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6007961.2413 | 2121229.1008 | 37.8049399144717 | -122.416700206529 | (37.8049399144717, -122.416700206529) | 5 | 1 | 10 | 308 | 23 | |||
| 193951 | 142653 | DPW Maintained 1 | Tristania conferta :: 61 | 1188 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6007975.5818 | 2121216.8848 | 37.8049071789669 | -122.416649713579 | (37.8049071789669, -122.416649713579) | 5 | 1 | 10 | 308 | 23 | |||
| 68806 | 142719 | DPW Maintained 1 | Tristania conferta :: 61 | 1150 COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6008016.4786 | 2121177.0503 | 37.8048001035106 | -122.416505361905 | (37.8048001035106, -122.416505361905) | 5 | 1 | 10 | 308 | 23 | |||
| 169804 | 26540 | DPW Maintained 1 | Tristania conferta :: 61 | 530 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008777.828 | 2121123.8926 | 37.8046969326474 | -122.413866861434 | (37.8046969326474, -122.413866861434) | 3 | 1 | 10 | 308 | 23 | |||
| 55003 | 142704 | DPW Maintained 1 | Tristania conferta :: 61 | 540 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6008680.9196 | 2121106.7911 | 37.804644533379 | -122.414201013023 | (37.804644533379, -122.414201013023) | 3 | 1 | 10 | 308 | 23 | |||
| 58162 | 142689 | DPW Maintained 1 | Tristania conferta :: 61 | 554 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6008629.0451 | 2121101.0906 | 37.8046259673251 | -122.414380126753 | (37.8046259673251, -122.414380126753) | 3 | 1 | 10 | 308 | 23 | |||
| 163692 | 12987 | DPW Maintained 1 | Tristania conferta :: 61 | 318 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 3 | 3X3 | 6010766.7048 | 2120702.1725 | 37.8036504876245 | -122.406954379692 | (37.8036504876245, -122.406954379692) | 3 | 1 | 10 | 308 | 23 | ||
| 138915 | 38378 | DPW Maintained 1 | Tristania conferta :: 61 | 2027 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/1998 12:00:00 AM | 11 | Permit Number 40437 | 6009441.5117 | 2120654.7585 | 37.8034460574359 | -122.411536943543 | (37.8034460574359, -122.411536943543) | 3 | 1 | 10 | 308 | 23 | ||
| 32812 | 99009 | DPW Maintained 1 | Tristania conferta :: 61 | 2099X Beach St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||
| 162433 | 99007 | DPW Maintained 1 | Tristania conferta :: 61 | 2099X Beach St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||
| 5348 | 72411 | DPW Maintained 1 | Tristania conferta :: 61 | 475 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6x6 | 6010101.0381 | 2120567.585 | 37.8032436723817 | -122.409248460006 | (37.8032436723817, -122.409248460006) | 3 | 1 | 10 | 308 | 23 | ||
| 75868 | 28074 | DPW Maintained 1 | Tristania conferta :: 61 | 915 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2010 12:00:00 AM | 3 | 3X3 | 6008638.4319 | 2120527.3912 | 37.8030512599832 | -122.414307026238 | (37.8030512599832, -122.414307026238) | 3 | 1 | 10 | 308 | 32 | ||
| 179871 | 28075 | DPW Maintained 1 | Tristania conferta :: 61 | 915 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2010 12:00:00 AM | 3 | 3X3 | 6008651.5543 | 2120512.2278 | 37.8030103621977 | -122.414260542242 | (37.8030103621977, -122.414260542242) | 3 | 1 | 10 | 308 | 32 | ||
| 112653 | 28076 | DPW Maintained 1 | Tristania conferta :: 61 | 915 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/2003 12:00:00 AM | 25 | 3X3 | 6008674.8876 | 2120493.8068 | 37.8029610933815 | -122.414178492558 | (37.8029610933815, -122.414178492558) | 3 | 1 | 10 | 308 | 32 | ||
| 95484 | 98999 | DPW Maintained 1 | Tristania conferta :: 61 | 2190X North Point St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771149 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | |
| 158633 | 64370 | DPW Maintained 1 | Tristania conferta :: 61 | 525 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 7 | Permit Number 25209 | 6010332.9517 | 2120250.0174 | 37.8023847002257 | -122.408423498481 | (37.8023847002257, -122.408423498481) | 3 | 1 | 10 | 308 | 23 | |
| 69266 | 64367 | DPW Maintained 1 | Tristania conferta :: 61 | 545 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 10 | Permit Number 25206 | 6010276.1583 | 2120241.7062 | 37.8023586991127 | -122.408619445814 | (37.8023586991127, -122.408619445814) | 3 | 1 | 10 | 308 | 23 | |
| 76380 | 50978 | DPW Maintained 1 | Tristania conferta :: 61 | 807REVISED Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2004 12:00:00 AM | 11 | Permit Number 47464 | 6008954.8893 | 2120241.9921 | 37.8022853965169 | -122.413191720991 | (37.8022853965169, -122.413191720991) | 3 | 1 | 10 | 308 | 32 | ||
| 74581 | 143104 | DPW Maintained 1 | Tristania conferta :: 61 | 1736 STOCKTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010039.5193 | 2120117.0378 | 37.8020031344426 | -122.409429532928 | (37.8020031344426, -122.409429532928) | 3 | 1 | 10 | 308 | 23 | |||
| 66530 | 122823 | Permitted Site 7 | Tristania conferta :: 61 | 1736 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 4x4 | 6010043.2132 | 2120098.5684 | 37.8019526289989 | -122.409415446027 | (37.8019526289989, -122.409415446027) | 3 | 1 | 10 | 308 | 23 | ||
| 1715 | 122822 | DPW Maintained 1 | Tristania conferta :: 61 | 1736 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6010044.5984 | 2120081.0225 | 37.8019045299018 | -122.409409413578 | (37.8019045299018, -122.409409413578) | 3 | 1 | 10 | 308 | 23 | |||
| 117314 | 64341 | DPW Maintained 1 | Tristania conferta :: 61 | 1736 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1988 12:00:00 AM | 11 | Permit Number 25170 | 6010046.9071 | 2120063.9383 | 37.8018577502609 | -122.409400217983 | (37.8018577502609, -122.409400217983) | 3 | 1 | 10 | 308 | 23 | |
| 49007 | 142626 | DPW Maintained 1 | Tristania conferta :: 61 | 735 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6009290.0663 | 2119929.1695 | 37.8014452745633 | -122.412009721134 | (37.8014452745633, -122.412009721134) | 3 | 1 | 10 | 308 | 4 | |||
| 191173 | 13094 | DPW Maintained 1 | Tristania conferta :: 61 | 1450 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/1995 12:00:00 AM | 12 | 3X3 | 6005349.3555 | 2119944.5969 | 37.801265750478 | -122.425647455227 | (37.801265750478, -122.425647455227) | 13 | 9 | 1 | 57 | 17 | ||
| 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 | ||
| 103234 | 13098 | DPW Maintained 1 | Tristania conferta :: 61 | 1488 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/1997 12:00:00 AM | 30 | 3X3 | 6005248.4978 | 2119934.433 | 37.8012321434749 | -122.425995743515 | (37.8012321434749, -122.425995743515) | 13 | 9 | 1 | 57 | 17 | ||
| 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 | |
| 141669 | 143237 | DPW Maintained 1 | Tristania conferta :: 61 | 1550 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004970.9437 | 2119896.9045 | 37.8011134097543 | -122.426953528407 | (37.8011134097543, -122.426953528407) | 13 | 9 | 1 | 57 | 17 | |||
| 121271 | 143236 | DPW Maintained 1 | Tristania conferta :: 61 | 1550 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/2016 06:43:00 AM | 3 | Width 0ft | 6004943.5793 | 2119894.559 | 37.8011054222859 | -122.427048053959 | (37.8011054222859, -122.427048053959) | 13 | 9 | 1 | 57 | 17 | ||
| 47298 | 143113 | DPW Maintained 1 | Tristania conferta :: 61 | 2775 VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005458.8135 | 2119882.0495 | 37.8011001957164 | -122.425264228759 | (37.8011001957164, -122.425264228759) | 13 | 9 | 1 | 57 | 17 | |||
| 75752 | 13092 | DPW Maintained 1 | Tristania conferta :: 61 | 1447 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2005 12:00:00 AM | 8 | 3x3 | 6005407.9937 | 2119875.0129 | 37.8010780038521 | -122.425439586315 | (37.8010780038521, -122.425439586315) | 13 | 9 | 1 | 57 | 17 | ||
| 143985 | 143114 | DPW Maintained 1 | Tristania conferta :: 61 | 1463 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005363.4287 | 2119869.54 | 37.8010604586698 | -122.425593410805 | (37.8010604586698, -122.425593410805) | 13 | 9 | 1 | 57 | 17 | |||
| 6704 | 13114 | DPW Maintained 1 | Tristania conferta :: 61 | 1618 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2005 12:00:00 AM | 12 | 3x3 | 6004576.6984 | 2119842.3294 | 37.800941260536 | -122.428313896065 | (37.800941260536, -122.428313896065) | 13 | 9 | 1 | 57 | 17 | ||
| 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 | ||
| 122631 | 13099 | DPW Maintained 1 | Tristania conferta :: 61 | 1501 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/1995 12:00:00 AM | 6 | 3X3 | 6005022.5453 | 2119823.4113 | 37.8009145339293 | -122.4267697277 | (37.8009145339293, -122.4267697277) | 13 | 9 | 1 | 57 | 17 | ||
| 65922 | 143235 | DPW Maintained 1 | Tristania conferta :: 61 | 1549 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004978.7622 | 2119817.1566 | 37.8008948846007 | -122.426920790121 | (37.8008948846007, -122.426920790121) | 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 | ||
| 156559 | 143384 | DPW Maintained 1 | Tristania conferta :: 61 | 1650 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004460.6831 | 2119822.6068 | 37.8008805420914 | -122.428713951546 | (37.8008805420914, -122.428713951546) | 13 | 9 | 1 | 57 | 17 | |||
| 186310 | 143385 | DPW Maintained 1 | Tristania conferta :: 61 | 1658 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004429.3589 | 2119821.4466 | 37.8008755836208 | -122.428822263738 | (37.8008755836208, -122.428822263738) | 13 | 9 | 1 | 57 | 17 | |||
| 177527 | 143386 | DPW Maintained 1 | Tristania conferta :: 61 | 1662 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004406.1559 | 2119815.6459 | 37.8008583431077 | -122.428902142117 | (37.8008583431077, -122.428902142117) | 13 | 9 | 1 | 57 | 17 | |||
| 113209 | 143387 | DPW Maintained 1 | Tristania conferta :: 61 | 1680 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004355.1091 | 2119807.5248 | 37.800833155227 | -122.429078206161 | (37.800833155227, -122.429078206161) | 13 | 9 | 1 | 57 | 17 | |||
| 130 | 13128 | DPW Maintained 1 | Tristania conferta :: 61 | 1714 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6004131.2449 | 2119777.2826 | 37.8007374433085 | -122.429850711739 | (37.8007374433085, -122.429850711739) | 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 | ||
| 74531 | 51913 | DPW Maintained 1 | Tristania conferta :: 61 | 1734 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50189 | 6004067.1338 | 2119771.0279 | 37.8007166387692 | -122.430072116268 | (37.8007166387692, -122.430072116268) | 13 | 9 | 1 | 57 | 17 | |
| 24618 | 51914 | DPW Maintained 1 | Tristania conferta :: 61 | 1738 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50190 | 6004049.1514 | 2119767.1187 | 37.8007048866604 | -122.43013406377 | (37.8007048866604, -122.43013406377) | 13 | 9 | 1 | 57 | 17 | |
| 82224 | 51915 | DPW Maintained 1 | Tristania conferta :: 61 | 1738 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50190 | 6004018.6596 | 2119764.7731 | 37.8006967192313 | -122.430239410546 | (37.8006967192313, -122.430239410546) | 13 | 9 | 1 | 57 | 17 | |
| 179984 | 13141 | DPW Maintained 1 | Tristania conferta :: 61 | 1790 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6003874.0187 | 2119744.4452 | 37.8006327105148 | -122.430738476202 | (37.8006327105148, -122.430738476202) | 13 | 9 | 1 | 57 | 17 | |||
| 113908 | 13129 | DPW Maintained 1 | Tristania conferta :: 61 | 1721 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6004129.6812 | 2119699.0984 | 37.8005226811605 | -122.429850542898 | (37.8005226811605, -122.429850542898) | 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 | ||
| 113698 | 13158 | DPW Maintained 1 | Tristania conferta :: 61 | 1880 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6003428.3685 | 2119684.2434 | 37.8004421536411 | -122.432276305709 | (37.8004421536411, -122.432276305709) | 13 | 9 | 1 | 57 | 17 | |||
| 21708 | 30437 | DPW Maintained 1 | Tristania conferta :: 61 | 567 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 12 | Permit Number 90 | 6010234.0616 | 2119544.2672 | 37.8004413456091 | -122.40871589046 | (37.8004413456091, -122.40871589046) | 3 | 1 | 10 | 308 | 23 | ||
| 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 | ||
| 69190 | 13159 | DPW Maintained 1 | Tristania conferta :: 61 | 1880 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6003407.2588 | 2119680.3342 | 37.8004302230496 | -122.432349074336 | (37.8004302230496, -122.432349074336) | 13 | 9 | 1 | 57 | 17 | |||
| 68040 | 13160 | DPW Maintained 1 | Tristania conferta :: 61 | 1880 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6003384.5853 | 2119677.9886 | 37.8004224969778 | -122.43242736605 | (37.8004224969778, -122.43242736605) | 13 | 9 | 1 | 57 | 17 | |||
| 84941 | 29685 | DPW Maintained 1 | Tristania conferta :: 61 | 1880 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003360.3482 | 2119674.8613 | 37.8004125358422 | -122.43251101256 | (37.8004125358422, -122.43251101256) | 13 | 9 | 1 | 57 | 17 | |||
| 72018 | 29686 | DPW Maintained 1 | Tristania conferta :: 61 | 1880 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003340.0203 | 2119674.0794 | 37.8004092361933 | -122.432581299288 | (37.8004092361933, -122.432581299288) | 13 | 9 | 1 | 57 | 17 | |||
| 105426 | 142501 | DPW Maintained 1 | Tristania conferta :: 61 | 601 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6010024.9768 | 2119514.2391 | 37.8003471830213 | -122.409437290498 | (37.8003471830213, -122.409437290498) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | ||
| 11172 | 82387 | DPW Maintained 1 | Tristania conferta :: 61 | 615 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6010004.402 | 2119511.4587 | 37.8003383958996 | -122.409508291437 | (37.8003383958996, -122.409508291437) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | ||
| 51824 | 142500 | DPW Maintained 1 | Tristania conferta :: 61 | 629 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6009964.6425 | 2119505.3419 | 37.8003193727849 | -122.409645443683 | (37.8003193727849, -122.409645443683) | 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 | ||
| 188720 | 13174 | DPW Maintained 1 | Tristania conferta :: 61 | 1950 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/1997 12:00:00 AM | 14 | 3X3 | 6003011.134 | 2119622.0359 | 37.8002476819942 | -122.43371565452 | (37.8002476819942, -122.43371565452) | 13 | 9 | 1 | 57 | 17 | ||
| 141557 | 34684 | DPW Maintained 1 | Tristania conferta :: 61 | 1863 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 4 | Permit Number 38349 | 6003454.9512 | 2119604.4954 | 37.8002246935596 | -122.432178620621 | (37.8002246935596, -122.432178620621) | 13 | 9 | 1 | 57 | 17 | |
| 121377 | 13176 | DPW Maintained 1 | Tristania conferta :: 61 | 1964 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6002959.4463 | 2119614.5629 | 37.8002242300692 | -122.433893979596 | (37.8002242300692, -122.433893979596) | 13 | 9 | 1 | 57 | 17 | |||
| 42452 | 13177 | DPW Maintained 1 | Tristania conferta :: 61 | 1970 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/1995 12:00:00 AM | 35 | 3x3 | 6002925.1953 | 2119612.072 | 37.8002154469875 | -122.434012323171 | (37.8002154469875, -122.434012323171) | 13 | 9 | 1 | 57 | 17 | ||
| 111151 | 13156 | DPW Maintained 1 | Tristania conferta :: 61 | 1875 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6003411.9498 | 2119598.2407 | 37.8002050816246 | -122.432326975222 | (37.8002050816246, -122.432326975222) | 13 | 9 | 1 | 57 | 17 | |||
| 9366 | 13179 | DPW Maintained 1 | Tristania conferta :: 61 | 1976 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/1997 12:00:00 AM | 14 | 3X3 | 6002902.1538 | 2119607.7128 | 37.8002021701058 | -122.434091743886 | (37.8002021701058, -122.434091743886) | 13 | 9 | 1 | 57 | 17 | ||
| 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 | ||
| 56029 | 142485 | DPW Maintained 1 | Tristania conferta :: 61 | 1501 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6010091.845 | 2119435.9713 | 37.8001360252908 | -122.409200372911 | (37.8001360252908, -122.409200372911) | 3 | 1 | 10 | 308 | 23 | |||
| 115758 | 13163 | DPW Maintained 1 | Tristania conferta :: 61 | 1901 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003225.9808 | 2119572.2163 | 37.8001230789015 | -122.43296863968 | (37.8001230789015, -122.43296863968) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | ||
| 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 | ||
| 103148 | 13172 | DPW Maintained 1 | Tristania conferta :: 61 | 1945X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/1997 12:00:00 AM | 4 | 3x3 | 6003080.8814 | 2119554.1567 | 37.8000652607778 | -122.4334694479 | (37.8000652607778, -122.4334694479) | 13 | 9 | 1 | 57 | 17 | ||
| 153584 | 143123 | DPW Maintained 1 | Tristania conferta :: 61 | 1999 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002882.226 | 2119527.3787 | 37.7999804626368 | -122.4341549557 | (37.7999804626368, -122.4341549557) | 13 | 9 | 1 | 57 | 17 | |||
| 65594 | 98674 | DPW Maintained 1 | Tristania conferta :: 61 | 1520 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6010134.1069 | 2119364.7936 | 37.7999429563689 | -122.409049104677 | (37.7999429563689, -122.409049104677) | 3 | 1 | 10 | 308 | 23 | |||
| 138156 | 13182 | DPW Maintained 1 | Tristania conferta :: 61 | 2001 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x4 | 6002733.3901 | 2119504.96 | 37.7999104584024 | -122.434668379841 | (37.7999104584024, -122.434668379841) | 13 | 9 | 1 | 57 | 17 | |||
| 4802 | 65984 | DPW Maintained 1 | Tristania conferta :: 61 | 1520 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1990 12:00:00 AM | 14 | Permit Number 29013 | 6010137.4433 | 2119339.4921 | 37.7998736715658 | -122.409035773182 | (37.7998736715658, -122.409035773182) | 3 | 1 | 10 | 308 | 23 | |
| 59790 | 142498 | DPW Maintained 1 | Tristania conferta :: 61 | 535 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6009947.0726 | 2119329.9097 | 37.7998366945829 | -122.409693853229 | (37.7998366945829, -122.409693853229) | 3 | 1 | 10 | 308 | 4 | |||
| 151498 | 143149 | DPW Maintained 1 | Tristania conferta :: 61 | 2200 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001799.8965 | 2119455.7632 | 37.7997223379978 | -122.437895087221 | (37.7997223379978, -122.437895087221) | 13 | 9 | 1 | 57 | 17 | |||
| 60050 | 143150 | DPW Maintained 1 | Tristania conferta :: 61 | 2218 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001729.5264 | 2119441.44 | 37.7996790084154 | -122.43813756656 | (37.7996790084154, -122.43813756656) | 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 | ||
| 118696 | 13221 | DPW Maintained 1 | Tristania conferta :: 61 | 2240 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/1997 12:00:00 AM | 12 | 3X3 | 6001619.3007 | 2119428.9852 | 37.7996385414338 | -122.438518094144 | (37.7996385414338, -122.438518094144) | 13 | 9 | 1 | 57 | 17 | ||
| 95987 | 13208 | DPW Maintained 1 | Tristania conferta :: 61 | 2199 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/1997 12:00:00 AM | 6 | 3X3 | 6001971.1512 | 2119400.3389 | 37.7995798943259 | -122.437298513288 | (37.7995798943259, -122.437298513288) | 13 | 9 | 1 | 57 | 17 | ||
| 139070 | 13213 | DPW Maintained 1 | Tristania conferta :: 61 | 2199 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6001911.9905 | 2119390.9978 | 37.799550882806 | -122.437502561002 | (37.799550882806, -122.437502561002) | 13 | 9 | 1 | 57 | 17 | |||
| 100614 | 143151 | DPW Maintained 1 | Tristania conferta :: 61 | 2300 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6001315.564 | 2119391.1109 | 37.7995172663928 | -122.439566414616 | (37.7995172663928, -122.439566414616) | 13 | 9 | 1 | 57 | 17 | |||
| 105826 | 13237 | DPW Maintained 1 | Tristania conferta :: 61 | 2320 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/1997 12:00:00 AM | 30 | 3X3 | 6001278.1859 | 2119382.1727 | 37.7994905970471 | -122.439695114779 | (37.7994905970471, -122.439695114779) | 13 | 9 | 1 | 57 | 17 | ||
| 144729 | 13241 | DPW Maintained 1 | Tristania conferta :: 61 | 2352 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1994 12:00:00 AM | 30 | 3X3 | 6001099.421 | 2119356.9831 | 37.7994112565419 | -122.440311896156 | (37.7994112565419, -122.440311896156) | 13 | 9 | 1 | 57 | 17 | ||
| 16548 | 143139 | DPW Maintained 1 | Tristania conferta :: 61 | 2520 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000358 | 2119336 | 37.7993114011756 | -122.442875959315 | (37.7993114011756, -122.442875959315) | 13 | 9 | 1 | 57 | 17 | |||
| 171319 | 13253 | DPW Maintained 1 | Tristania conferta :: 61 | 2400 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6000858.2681 | 2119325.515 | 37.7993111202698 | -122.441144109229 | (37.7993111202698, -122.441144109229) | 13 | 9 | 1 | 57 | 17 | |||
| 105044 | 13231 | DPW Maintained 1 | Tristania conferta :: 61 | 2301X Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3X3 | 6001312.3137 | 2119307.4165 | 37.7992872786644 | -122.43957165866 | (37.7992872786644, -122.43957165866) | 13 | 9 | 1 | 57 | 17 | |||
| 133803 | 108697 | DPW Maintained 1 | Tristania conferta :: 61 | 2414 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774621 | 6000824.14262 | 2119316.97174 | 37.7992857188841 | -122.441261581656 | (37.7992857188841, -122.441261581656) | 13 | 9 | 1 | 57 | 17 |
| 181310 | 13233 | DPW Maintained 1 | Tristania conferta :: 61 | 2301X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001245.6832 | 2119299.2908 | 37.7992611751931 | -122.439801639901 | (37.7992611751931, -122.439801639901) | 13 | 9 | 1 | 57 | 17 | |||
| 3754 | 261321 | DPW Maintained 1 | Tristania conferta :: 61 | 2353 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001169.3018 | 2119289.54 | 37.7992300540772 | -122.440065245785 | (37.7992300540772, -122.440065245785) | 13 | 9 | 1 | 57 | 17 | ||||
| 127281 | 13244 | DPW Maintained 1 | Tristania conferta :: 61 | 2353 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/2012 12:00:00 AM | 3 | 3x3 | 6001169.3018 | 2119289.54 | 37.7992300540772 | -122.440065245785 | (37.7992300540772, -122.440065245785) | 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 | ||
| 143898 | 13243 | DPW Maintained 1 | Tristania conferta :: 61 | 2353 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001148.9876 | 2119284.6646 | 37.7992155110357 | -122.440135189953 | (37.7992155110357, -122.440135189953) | 13 | 9 | 1 | 57 | 17 | |||
| 42759 | 13242 | DPW Maintained 1 | Tristania conferta :: 61 | 2353 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001124.6106 | 2119280.6018 | 37.7992029678306 | -122.440219251047 | (37.7992029678306, -122.440219251047) | 13 | 9 | 1 | 57 | 17 | |||
| 129116 | 93015 | DPW Maintained 1 | Tristania conferta :: 61 | 2395 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 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) | 13 | 9 | 1 | 57 | 17 |
| 83005 | 93014 | DPW Maintained 1 | Tristania conferta :: 61 | 2395 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 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) | 13 | 9 | 1 | 57 | 17 |
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) );