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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7726 | 7726 | 14482 | DPW Maintained 3 | Tristania conferta :: 79 | 281 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5998940.9244 | 2112049.1164 | 37.7792226484867 | -122.447254781672 | (37.7792226484867, -122.447254781672) | |||
| 17246 | 17246 | 10340 | DPW Maintained 3 | Tristania conferta :: 79 | 914 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X4 | 6001716.4806 | 2109101.7503 | 37.7712881236094 | -122.437441889428 | (37.7712881236094, -122.437441889428) | |||
| 9376 | 9376 | 14452 | Permitted Site 1 | Tristania conferta :: 79 | 100 Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3x3 | 5998927.5567 | 2112628.8329 | 37.7808136360807 | -122.44734276226002 | (37.7808136360807, -122.44734276226) | |||
| 6471 | 6471 | 14471 | DPW Maintained 3 | Tristania conferta :: 79 | 227 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 5998914.8659 | 2112201.4062 | 37.77963930788229 | -122.447355892513 | (37.7796393078823, -122.447355892513) | |||
| 7828 | 7828 | 14470 | DPW Maintained 3 | Tristania conferta :: 79 | 223 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/1994 12:00:00 AM | 70 | 3X3 | 5998913.5122 | 2112227.1262 | 37.77970985099329 | -122.447362427254 | (37.7797098509933, -122.447362427254) | ||
| 5898 | 5898 | 14455 | DPW Maintained 3 | Tristania conferta :: 79 | 125 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5998862.4105 | 2112574.347 | 37.780660309110296 | -122.447564210548 | (37.7806603091103, -122.447564210548) | |||
| 6776 | 6776 | 14454 | DPW Maintained 3 | Tristania conferta :: 79 | 109 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/1994 12:00:00 AM | 60 | 3X3 | 5998851.581 | 2112620.0339 | 37.7807851345871 | -122.447604964541 | (37.7807851345871, -122.447604964541) | ||
| 7414 | 7414 | 14484 | DPW Maintained 3 | Tristania conferta :: 79 | 281 Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5998949.0465 | 2111993.9536 | 37.7790716497834 | -122.447222712917 | (37.7790716497834, -122.447222712917) | |||
| 8409 | 8409 | 14468 | DPW Maintained 3 | Tristania conferta :: 79 | 211 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 2X3 | 5998906.7438 | 2112277.8895 | 37.779848847108795 | -122.447389496791 | (37.7798488471088, -122.447389496791) | |||
| 8752 | 8752 | 14467 | DPW Maintained 3 | Tristania conferta :: 79 | 211 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 55 | 2X3 | 5998904.0364 | 2112297.518 | 37.7799025871774 | -122.447400276043 | (37.7799025871774, -122.447400276043) | |||
| 4874 | 4874 | 14465 | Permitted Site 1 | Tristania conferta :: 79 | 161 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1994 12:00:00 AM | 50 | 3X3 | 5998884.4079 | 2112430.1793 | 37.7802657190757 | -122.447477731101 | (37.7802657190757, -122.447477731101) | ||
| 6073 | 6073 | 14456 | Permitted Site 1 | Tristania conferta :: 79 | 135 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1997 12:00:00 AM | 50 | 3X3 | 5998867.4868 | 2112526.9679 | 37.7805305084906 | -122.447543237813 | (37.7805305084906, -122.447543237813) | ||
| 16912 | 16912 | 10519 | Permitted Site 1 | Tristania conferta :: 79 | 1840 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/1990 12:00:00 AM | 50 | 5997331.1413 | 2108490.0928 | 37.76935837855329 | -122.45256673963301 | (37.7693583785533, -122.452566739633) | |||
| 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) | |||
| 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) | ||
| 6862 | 6862 | 23930 | Permitted Site 1 | Tristania conferta :: 79 | 1715 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4X4 | 6003466.7876 | 2114641.1577 | 37.786597310936706 | -122.431783083706 | (37.7865973109367, -122.431783083706) | |||
| 7533 | 7533 | 23864 | DPW Maintained 3 | Tristania conferta :: 79 | 1440 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6003698.6329 | 2113675.0331 | 37.7839577153907 | -122.43091198011601 | (37.7839577153907, -122.430911980116) | |||
| 18847 | 18847 | 10366 | Permitted Site 1 | Tristania conferta :: 79 | 1166 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X4 | 6000501.5622 | 2108932.6998 | 37.7707548079908 | -122.441632199385 | (37.7707548079908, -122.441632199385) | |||
| 15369 | 15369 | 22443 | Permitted Site 1 | Tristania conferta :: 79 | 6025 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | 6013664.0377 | 2091536.7496 | 37.7237303604467 | -122.39488407213601 | (37.7237303604467, -122.394884072136) | |||
| 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) | ||
| 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) | |||
| 3752 | 3752 | 7102 | DPW Maintained 3 | Tristania conferta :: 79 | 2080 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 5997497.5881 | 2109552.6978 | 37.7722855537803 | -122.45206768793001 | (37.7722855537803, -122.45206768793) | |||
| 5716 | 5716 | 7070 | Permitted Site 1 | Tristania conferta :: 79 | 1634 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5999592.5889 | 2109848.7666 | 37.7732182646887 | -122.4448422034 | (37.7732182646887, -122.4448422034) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 7519 | 7519 | 14445 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 5998940.7552 | 2112468.0825 | 37.7803730113246 | -122.44728552935801 | (37.7803730113246, -122.447285529358) | |||
| 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) | ||
| 8081 | 8081 | 4614 | Permitted Site 1 | Tristania conferta :: 79 | 347 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1991 12:00:00 AM | 30 | 3x3 | 6010525.6854 | 2118803.2675 | 37.7984230708943 | -122.407654474652 | (37.7984230708943, -122.407654474652) | ||
| 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) | |||
| 20140 | 20140 | 10246 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005589.149 | 2109643.5092 | 37.7729950707153 | -122.424084680793 | (37.7729950707153, -122.424084680793) | |||
| 181815 | 181815 | 54243 | Permitted Site 1 | Tristania conferta :: 79 | 35 Kittredge Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1972 12:00:00 AM | 26 | Permit Number 9984 | 5997958.8776 | 2111479.5979 | 37.777602735942295 | -122.45061099973499 | (37.7776027359423, -122.450610999735) | ||
| 5959 | 5959 | 23753 | DPW Maintained 3 | Tristania conferta :: 79 | 900X Webster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1992 12:00:00 AM | 25 | 4x4 | 6003923.4316 | 2112087.5817 | 37.7796117041387 | -122.43002098071501 | (37.7796117041387, -122.430020980715) | ||
| 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) | ||
| 17212 | 17212 | 27330 | DPW Maintained 3 | Tristania conferta :: 79 | 348 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/1998 12:00:00 AM | 25 | 4X4 | 6004421.6425 | 2109483.8508 | 37.772490701019294 | -122.42811184989999 | (37.7724907010193, -122.4281118499) | ||
| 20545 | 20545 | 27329 | DPW Maintained 3 | Tristania conferta :: 79 | 342 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/1998 12:00:00 AM | 25 | 4X4 | 6004444.7102 | 2109487.8877 | 37.772503090465705 | -122.428032344144 | (37.7725030904657, -122.428032344144) | ||
| 21406 | 21406 | 10305 | DPW Maintained 3 | Tristania conferta :: 79 | 614 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/1999 12:00:00 AM | 25 | 3x3 | 6003095.7029 | 2109294.636 | 37.7718960552644 | -122.432684884303 | (37.7718960552644, -122.432684884303) | ||
| 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) | |||
| 1020 | 1020 | 10701 | DPW Maintained 3 | Tristania conferta :: 79 | 1290 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001704.3359 | 2110485.9297 | 37.7750880443133 | -122.43758304169201 | (37.7750880443133, -122.437583041692) | |||
| 5517 | 5517 | 10700 | DPW Maintained 3 | Tristania conferta :: 79 | 1290 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001738.9392 | 2110489.0192 | 37.775098494652795 | -122.437463562764 | (37.7750984946528, -122.437463562764) | |||
| 6979 | 6979 | 6191 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005268.6997 | 2113412.8277 | 37.7833265994852 | -122.42546145392201 | (37.7833265994852, -122.425461453922) | |||
| 7117 | 7117 | 7106 | DPW Maintained 3 | Tristania conferta :: 79 | 2136 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5997200.5381 | 2109511.6187 | 37.7721557413798 | -122.453092239143 | (37.7721557413798, -122.453092239143) | |||
| 9169 | 9169 | 7068 | Permitted Site 1 | Tristania conferta :: 79 | 1600 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 5999680.2623 | 2109860.1441 | 37.7732545074631 | -122.444539748344 | (37.7732545074631, -122.444539748344) | |||
| 9607 | 9607 | 6248 | DPW Maintained 3 | Tristania conferta :: 79 | 1310X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6004578.6077 | 2113315.336 | 37.783019896919605 | -122.427841950596 | (37.7830198969196, -122.427841950596) | |||
| 9620 | 9620 | 12359 | DPW Maintained 3 | Tristania conferta :: 79 | 1295X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X6 | 6004744.0331 | 2113287.4568 | 37.7829527043097 | -122.427267659807 | (37.7829527043097, -122.427267659807) | |||
| 17489 | 17489 | 9671 | Permitted Site 1 | Tristania conferta :: 79 | 207 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1995 12:00:00 AM | 24 | 3X3 | 6005999.0821 | 2110438.7223 | 37.77520167050999 | -122.422723192397 | (37.77520167051, -122.422723192397) | ||
| 20328 | 20328 | 10344 | DPW Maintained 3 | Tristania conferta :: 79 | 946 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6001573.5571 | 2109081.4751 | 37.7712243264402 | -122.43793481453899 | (37.7712243264402, -122.437934814539) | |||
| 21622 | 21622 | 5142 | DPW Maintained 3 | Tristania conferta :: 79 | 205 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 2X3 | 6001837.0393 | 2108819.6023 | 37.7705202684803 | -122.437004669282 | (37.7705202684803, -122.437004669282) | |||
| 178246 | 178246 | 141548 | Undocumented 2 | Tristania conferta :: 79 | 53 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 5997966.0923 | 2111424.7661 | 37.7774525950111 | -122.450582087707 | (37.7774525950111, -122.450582087707) | |||
| 35829 | 35829 | 139042 | Undocumented 2 | Tristania conferta :: 79 | 1434 BAKER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6000193.0745 | 2113977.6097 | 37.7845892631082 | -122.443061626662 | (37.7845892631082, -122.443061626662) | |||
| 161190 | 161190 | 245979 | Undocumented 2 | Tristania conferta :: 79 | 2401 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6006965.6446 | 2104307.6263 | 37.7584216103952 | -122.418944681916 | (37.7584216103952, -122.418944681916) | |||
| 49196 | 49196 | 141537 | Undocumented 2 | Tristania conferta :: 79 | 41 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5997962.2445 | 2111456.5108 | 37.777539537476 | -122.450597687662 | (37.777539537476, -122.450597687662) | |||
| 64576 | 64576 | 59552 | Permitted Site 1 | Tristania conferta :: 79 | 1602 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1981 12:00:00 AM | 21 | Permit Number 18937 | 6000082.8421 | 2110610.4978 | 37.7753377515139 | -122.44320107698401 | (37.7753377515139, -122.443201076984) | ||
| 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) | |||
| 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) | |||
| 7529 | 7529 | 13218 | DPW Maintained 3 | Tristania conferta :: 79 | 2230 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 20 | 3X3 | 6001666.6293 | 2119436.4581 | 37.799661752140295 | -122.43835485597299 | (37.7996617521403, -122.438354855973) | ||
| 7721 | 7721 | 13116 | Permitted Site 1 | Tristania conferta :: 79 | 1627 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 20 | 3x3 | 6004563.6038 | 2119765.555 | 37.8007297168722 | -122.42835373390601 | (37.8007297168722, -122.428353733906) | ||
| 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) | |||
| 9013 | 9013 | 23929 | Permitted Site 1 | Tristania conferta :: 79 | 1715 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/1992 12:00:00 AM | 20 | 4X4 | 6003463.555 | 2114659.6298 | 37.786647847412404 | -122.431795587112 | (37.7866478474124, -122.431795587112) | ||
| 17853 | 17853 | 10365 | DPW Maintained 3 | Tristania conferta :: 79 | 1158 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/01/2001 12:00:00 AM | 20 | 3X3 | 6000552.7964 | 2108940.2901 | 37.7707785679811 | -122.44145552457199 | (37.7707785679811, -122.441455524572) | ||
| 19979 | 19979 | 10448 | Permitted Site 1 | Tristania conferta :: 79 | 1525 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1996 12:00:00 AM | 20 | 2X3 | 5998831.2765 | 2108649.625 | 37.7698822506188 | -122.447389347046 | (37.7698822506188, -122.447389347046) | ||
| 20257 | 20257 | 10302 | DPW Maintained 3 | Tristania conferta :: 79 | 596 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/1997 12:00:00 AM | 20 | 3X3 | 6003330.7652 | 2109326.5077 | 37.7719968952641 | -122.431874063617 | (37.7719968952641, -122.431874063617) | ||
| 55003 | 55003 | 141512 | Undocumented 2 | Tristania conferta :: 79 | 36 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5997995.4321 | 2111502.2039 | 37.777666898397 | -122.450486176086 | (37.777666898397, -122.450486176086) | |||
| 60200 | 60200 | 141513 | Undocumented 2 | Tristania conferta :: 79 | 40 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5998000.2419 | 2111479.5979 | 37.777605103476205 | -122.45046790734501 | (37.7776051034762, -122.450467907345) | |||
| 63719 | 63719 | 246105 | Undocumented 2 | Tristania conferta :: 79 | 1764 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5997266.71 | 2108130.1217 | 37.7683662985003 | -122.45276361872 | (37.7683662985003, -122.45276361872) | |||
| 166802 | 166802 | 184808 | Undocumented 2 | Tristania conferta :: 79 | 1251 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 0ft | 5984676.7802 | 2106518.9511 | 37.763213013686396 | -122.49619147733 | (37.7632130136864, -122.49619147733) | |||
| 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) | ||
| 45406 | 45406 | 142355 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6005342.2141 | 2113373.8323 | 37.7832236810645 | -122.425204347304 | (37.7832236810645, -122.425204347304) | |||
| 50239 | 50239 | 245878 | Undocumented 2 | Tristania conferta :: 79 | 964 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6001502.0953 | 2109071.836 | 37.7711937958365 | -122.438181312666 | (37.7711937958365, -122.438181312666) | |||
| 131688 | 131688 | 139929 | Undocumented 2 | Tristania conferta :: 79 | 800 GOUGH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6005694.4032 | 2112619.0761 | 37.7811711958921 | -122.42393222480499 | (37.7811711958921, -122.423932224805) | |||
| 466 | 466 | 1665 | DPW Maintained 3 | Tristania conferta :: 79 | 1400X Fell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1992 12:00:00 AM | 18 | 3X3 | 6000409.8977 | 2109962.9335 | 37.7735783473195 | -122.44202322778901 | (37.7735783473195, -122.442023227789) | ||
| 1195 | 1195 | 12282 | DPW Maintained 3 | Tristania conferta :: 79 | 745 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x10 | 6004875.3929 | 2111529.8441 | 37.7781341613075 | -122.42668800624901 | (37.7781341613075, -122.426688006249) | |||
| 2008 | 2008 | 6077 | DPW Maintained 3 | Tristania conferta :: 79 | 1966 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2007 12:00:00 AM | 18 | 4X4 | 6001073.8278 | 2112479.7581 | 37.7805267238289 | -122.43990709148198 | (37.7805267238289, -122.439907091482) | ||
| 3764 | 3764 | 24423 | Permitted Site 1 | Tristania conferta :: 79 | 1707 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1995 12:00:00 AM | 18 | 3x3 | 6005275.9761 | 2115602.2731 | 37.7893386830183 | -122.425592156658 | (37.7893386830183, -122.425592156658) | ||
| 5369 | 5369 | 12368 | DPW Maintained 3 | Tristania conferta :: 79 | 1325 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1991 12:00:00 AM | 18 | 3X3 | 6004615.632999999 | 2113432.0006 | 37.7833423233744 | -122.42772217323 | (37.7833423233744, -122.42772217323) | ||
| 5606 | 5606 | 7095 | Permitted Site 1 | Tristania conferta :: 79 | 1970 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1994 12:00:00 AM | 18 | 3X3 | 5998027.6156 | 2109626.606 | 37.772518832985504 | -122.45023961224 | (37.7725188329855, -122.45023961224) | ||
| 5670 | 5670 | 10699 | DPW Maintained 3 | Tristania conferta :: 79 | 1275 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001777.3475 | 2110450.1636 | 37.774993990438205 | -122.43732791737 | (37.7749939904382, -122.43732791737) | |||
| 6167 | 6167 | 10693 | Permitted Site 1 | Tristania conferta :: 79 | 1250 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001870.5552 | 2110507.5567 | 37.7751568758154 | -122.43700960221001 | (37.7751568758154, -122.43700960221) | |||
| 6268 | 6268 | 24416 | Permitted Site 1 | Tristania conferta :: 79 | 1625 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6005321.0617 | 2115263.3908 | 37.7884107443518 | -122.425412039373 | (37.7884107443518, -122.425412039373) | ||
| 6411 | 6411 | 10687 | Permitted Site 1 | Tristania conferta :: 79 | 1185 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002205.7566 | 2110510.4768 | 37.775183940568496 | -122.435850276383 | (37.7751839405685, -122.435850276383) | |||
| 6548 | 6548 | 12281 | Permitted Site 1 | Tristania conferta :: 79 | 739 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6004881.0373 | 2111477.1625 | 37.777989829673096 | -122.426664727755 | (37.7779898296731, -122.426664727755) | |||
| 6605 | 6605 | 9632 | DPW Maintained 3 | Tristania conferta :: 79 | 1455 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002597.6566 | 2111945.8131 | 37.7791472697919 | -122.434597262323 | (37.7791472697919, -122.434597262323) | |||
| 6685 | 6685 | 6188 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005406.4851 | 2113431.574 | 37.783385856152 | -122.42498610479299 | (37.783385856152, -122.424986104793) | |||
| 6702 | 6702 | 10686 | DPW Maintained 3 | Tristania conferta :: 79 | 1179 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002229.5074 | 2110511.8739 | 37.775189125797205 | -122.435768217131 | (37.7751891257972, -122.435768217131) | |||
| 7068 | 7068 | 6193 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005219.9593 | 2113402.5172 | 37.783295535433204 | -122.425629342465 | (37.7832955354332, -122.425629342465) | |||
| 8284 | 8284 | 7069 | DPW Maintained 3 | Tristania conferta :: 79 | 1620 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999644.1221 | 2109852.7822 | 37.7732322313227 | -122.44466423249399 | (37.7732322313227, -122.444664232494) | |||
| 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) | ||
| 8401 | 8401 | 24417 | Permitted Site 1 | Tristania conferta :: 79 | 1615 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1995 12:00:00 AM | 18 | 3x3 | 6005329.2314 | 2115203.2857 | 37.788246172329 | -122.42537949452299 | (37.788246172329, -122.425379494523) | ||
| 8442 | 8442 | 6187 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005423.3129 | 2113433.3911 | 37.783391795987 | -122.424928016493 | (37.783391795987, -122.424928016493) | |||
| 8487 | 8487 | 5215 | DPW Maintained 3 | Tristania conferta :: 79 | 846 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/1990 12:00:00 AM | 18 | 3X3 | 6001547.7869 | 2111374.9525 | 37.7775201753497 | -122.43818827840599 | (37.7775201753497, -122.438188278406) | ||
| 8543 | 8543 | 9758 | DPW Maintained 3 | Tristania conferta :: 79 | 735 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/1997 12:00:00 AM | 18 | 4x4 | 6005747.9577 | 2112242.2179 | 37.78013945886 | -122.423720149275 | (37.78013945886, -122.423720149275) | ||
| 8695 | 8695 | 6189 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005309.0043 | 2113417.5143 | 37.7833417448711 | -122.425322349467 | (37.7833417448711, -122.425322349467) | |||
| 8926 | 8926 | 6195 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005185.2786 | 2113401.5799 | 37.7832910021365 | -122.425749257253 | (37.7832910021365, -122.425749257253) | |||
| 9084 | 9084 | 7073 | Permitted Site 1 | Tristania conferta :: 79 | 1664 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999470.1137 | 2109827.3502 | 37.773152470395296 | -122.44526431981701 | (37.7731524703953, -122.445264319817) | |||
| 9229 | 9229 | 10682 | Permitted Site 1 | Tristania conferta :: 79 | 1145 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002385.9834 | 2110534.2276 | 37.7752593905207 | -122.43522853143 | (37.7752593905207, -122.43522853143) | |||
| 9485 | 9485 | 24424 | Permitted Site 1 | Tristania conferta :: 79 | 1705 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6005279.8538 | 2115571.2522 | 37.7892537264959 | -122.42557653158 | (37.7892537264959, -122.42557653158) | ||
| 10218 | 10218 | 16871 | DPW Maintained 3 | Tristania conferta :: 79 | 254 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6005762.2091 | 2110361.0964 | 37.7749751613383 | -122.42353707049601 | (37.7749751613383, -122.423537070496) | ||
| 17108 | 17108 | 9664 | DPW Maintained 3 | Tristania conferta :: 79 | 115 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006036.6387 | 2110130.4049 | 37.7743572242045 | -122.422571361821 | (37.7743572242045, -122.422571361821) | ||
| 17441 | 17441 | 10432 | DPW Maintained 3 | Tristania conferta :: 79 | 1441 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/1999 12:00:00 AM | 18 | 3X3 | 5999180.1356 | 2108696.8663 | 37.770031892228495 | -122.44618605438801 | (37.7700318922285, -122.446186054388) |
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");