1,377 rows where qSpecies_id = 61 sorted by Supervisor Districts

View and edit SQL

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)
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
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
4874 143132 DPW Maintained 1 Tristania conferta :: 61 2435 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6000754.0798 2119231.0352 37.7990457686205 -122.441497852636 (37.7990457686205, -122.441497852636) 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
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
13435 71273 DPW Maintained 1 Tristania conferta :: 61 2480 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     6000737.6791 2114169.5665 37.7851473635462 -122.441191260636 (37.7851473635462, -122.441191260636) 15 6 1 29490 27
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
17209 13251 DPW Maintained 1 Tristania conferta :: 61 2395 Lombard St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6000984.849 2119261.9127 37.7991436944439 -122.440701531677 (37.7991436944439, -122.440701531677) 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
27028 68142 DPW Maintained 1 Tristania conferta :: 61 2532 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1993 12:00:00 AM 1   Permit Number 31896 6000452.2737 2114128.7986 37.785019164077 -122.442175744115 (37.785019164077, -122.442175744115) 15 6 1 29490 27
29504 138720 DPW Maintained 1 Tristania conferta :: 61 2921 PINE ST 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/22/2016 03:10:00 PM 2 Width 0ft   5999959.1608 2114707.5789 37.7865802293131 -122.443923351787 (37.7865802293131, -122.443923351787) 15 6 1 29490 31
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
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
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
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
36334 138235 DPW Maintained 1 Tristania conferta :: 61 230 Masonic Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5998964.7831 2112316.4696 37.7799580944916 -122.447191491368 (37.7799580944916, -122.447191491368) 15 5 1 54 16
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
41026 138710 DPW Maintained 1 Tristania conferta :: 61 2699 BUSH ST 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6000650.0889 2114452.8379 37.7859201640241 -122.4415146292 (37.7859201640241, -122.4415146292) 15 6 1 29490 27
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
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
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
46016 143140 DPW Maintained 1 Tristania conferta :: 61 2532 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6000155.1695 2119230.0223 37.7990088489402 -122.44357020422 (37.7990088489402, -122.44357020422) 13 9 1 57 17
46527 138746 DPW Maintained 1 Tristania conferta :: 61 2516 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6000515.6821 2114142.2729 37.7850597745123 -122.441957339259 (37.7850597745123, -122.441957339259) 15 6 1 29490 27
46645 138597 DPW Maintained 1 Tristania conferta :: 61 1991 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6001451.6996 2115181.7517 37.7879672100973 -122.438793534901 (37.7879672100973, -122.438793534901) 13 6 1 29490 27
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
49136 42633 DPW Maintained 1 Tristania conferta :: 61 1651 Union St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/22/2016 02:56:00 PM 3 5x5 Permit Number 45045 6005048.16251 2118816.23898 37.7981505449739 -122.426609321383 (37.7981505449739, -122.426609321383) 13 9 1 57 17
51619 141090 DPW Maintained 1 Tristania conferta :: 61 196 Jordan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5996268.5766 2112969.4544 37.7815965932692 -122.456566052477 (37.7815965932692, -122.456566052477) 11 6 1 54 31
56076 13283 DPW Maintained 1 Tristania conferta :: 61 2539 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6000208.0345 2119155.4664 37.7988071530908 -122.44338191609 (37.7988071530908, -122.44338191609) 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
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
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
67481 138713 DPW Maintained 1 Tristania conferta :: 61 1642 BRODERICK ST 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6000620.5484 2114390.3234 37.7857468323482 -122.441612343055 (37.7857468323482, -122.441612343055) 15 6 1 29490 27
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
69058 89051 DPW Maintained 1 Tristania conferta :: 61 2420 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2011 12:00:00 AM 2 3x3 Permit Number 767132 6000933.3562 2114194.3706 37.7852266134024 -122.440516060128 (37.7852266134024, -122.440516060128) 15 6 1 29490 27
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
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
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
72289 141093 DPW Maintained 1 Tristania conferta :: 61 190 Jordan Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5996268.2382 2113005.3272 37.7816950710308 -122.456569818134 (37.7816950710308, -122.456569818134) 11 6 1 54 31
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
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
77870 13262 DPW Maintained 1 Tristania conferta :: 61 2443 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6000711.0138 2119222.9095 37.7990210040081 -122.441646291613 (37.7990210040081, -122.441646291613) 13 9 1 57 17
80655 137923 DPW Maintained 1 Tristania conferta :: 61 1901 WEBSTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6003379.2097 2115283.9028 37.7883571613531 -122.432131998946 (37.7883571613531, -122.432131998946) 13 9 1 29490 27
81130 137789 DPW Maintained 1 Tristania conferta :: 61 1711 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6005260.1426 2115739.9282 37.7897157547789 -122.425656740164 (37.7897157547789, -122.425656740164) 13 9 1 28858 27
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
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
83749 138245 DPW Maintained 1 Tristania conferta :: 61 750 PRESIDIO AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5999284.3395 2114037.2657 37.7847012079666 -122.446209824081 (37.7847012079666, -122.446209824081) 15 6 1 29490 31
84433 143133 DPW Maintained 1 Tristania conferta :: 61 2447 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6000680.1362 2119221.2843 37.7990147823393 -122.441753021456 (37.7990147823393, -122.441753021456) 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
84965 138569 DPW Maintained 1 Tristania conferta :: 61 1912 DIVISADERO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6001034.7522 2115044.284 37.7875660297526 -122.440226232429 (37.7875660297526, -122.440226232429) 13 6 1 29490 27
84992 138681 DPW Maintained 1 Tristania conferta :: 61 3050 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5999237.6946 2114657.811 37.786402399412 -122.44641585719 (37.786402399412, -122.44641585719) 15 6 1 29490 31
87396 18099 DPW Maintained 1 Tristania conferta :: 61 3019 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5999451.351 2114633.9478 37.786349077981 -122.445674946059 (37.786349077981, -122.445674946059) 15 6 1 29490 31
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
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
94108 141094 DPW Maintained 1 Tristania conferta :: 61 188 Jordan Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5996267.5613 2113016.8335 37.7817266254142 -122.456572992218 (37.7817266254142, -122.456572992218) 11 6 1 54 31
95409 68141 DPW Maintained 1 Tristania conferta :: 61 2528 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1993 12:00:00 AM 14   Permit Number 31895 6000471.2962 2114132.7617 37.7850311298137 -122.442110217066 (37.7850311298137, -122.442110217066) 15 6 1 29490 27
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
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
97333 89052 DPW Maintained 1 Tristania conferta :: 61 2420 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2011 12:00:00 AM 2 3x3 Permit Number 767132 6000895.8744 2114188.3074 37.7852078310557 -122.440645300245 (37.7852078310557, -122.440645300245) 15 6 1 29490 27
97432 53100 DPW Maintained 1 Tristania conferta :: 61 560@ PINE Presidio Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2011 12:00:00 AM 1   Permit Number 767803 5999200.433 2114690.2424 37.7864893192828 -122.446547106561 (37.7864893192828, -122.446547106561) 15 6 1 29490 31
97869 141234 DPW Maintained 1 Tristania conferta :: 61 22 COMMONWEALTH AVE 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 0ft   5996538.8064 2114429.9137 37.7856221373365 -122.455736793232 (37.7856221373365, -122.455736793232) 11 6 1 54 31
99454 24422 DPW Maintained 1 Tristania conferta :: 61 1709 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1995 12:00:00 AM 17 3X3   6005271.4523 2115623.5999 37.7893969854581 -122.425609326978 (37.7893969854581, -122.425609326978) 13 9 1 28858 27
100073 68137 DPW Maintained 1 Tristania conferta :: 61 2786 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1993 12:00:00 AM 9   Permit Number 31889 6000193.313 2114445.5102 37.7858740103556 -122.443094416733 (37.7858740103556, -122.443094416733) 13 6 1 29490 27
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
101768 138747 DPW Maintained 1 Tristania conferta :: 61 1614 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6000647.5573 2114208.4263 37.7852489286219 -122.441505842685 (37.7852489286219, -122.441505842685) 15 6 1 29490 27
103128 143135 DPW Maintained 1 Tristania conferta :: 61 2684 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5999523.0401 2119140.8402 37.7987279071831 -122.445751158267 (37.7987279071831, -122.445751158267) 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
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
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
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
106526 13252 DPW Maintained 1 Tristania conferta :: 61 2395 Lombard St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 3X3   6001005.1632 2119265.163 37.7991537757264 -122.440631471061 (37.7991537757264, -122.440631471061) 13 9 1 57 17
106592 137790 DPW Maintained 1 Tristania conferta :: 61 1711 Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6005264.6664 2115686.9342 37.7895705021499 -122.425637314961 (37.7895705021499, -122.425637314961) 13 9 1 28858 27
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
107434 24423 DPW Maintained 1 Tristania conferta :: 61 1707 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1995 12:00:00 AM 18 3x3   6005275.9761 2115602.2731 37.7893386830183 -122.425592156658 (37.7893386830183, -122.425592156658) 13 9 1 28858 27
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
108588 24424 DPW Maintained 1 Tristania conferta :: 61 1705 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1995 12:00:00 AM 18 3X3   6005279.8538 2115571.2522 37.7892537264959 -122.42557653158 (37.7892537264959, -122.42557653158) 13 9 1 28858 27
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
109409 14479 DPW Maintained 1 Tristania conferta :: 61 270 Masonic Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     16 3X3   5998992.7029 2112117.3083 37.7794128442998 -122.44708056796 (37.7794128442998, -122.44708056796) 15 5 1 54 16
109869 138450 DPW Maintained 1 Tristania conferta :: 61 1700 PIERCE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6002081.3526 2114464.1963 37.7860327882669 -122.436563672241 (37.7860327882669, -122.436563672241) 13 6 1 29490 27
110624 68143 DPW Maintained 1 Tristania conferta :: 61 2540 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1993 12:00:00 AM 14   Permit Number 31897 6000418.1917 2114124.8356 37.7850063402866 -122.442293372082 (37.7850063402866, -122.442293372082) 15 6 1 29490 27
110940 138204 DPW Maintained 1 Tristania conferta :: 61 270 MASONIC AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   5999001.1634 2112067.5603 37.7792767325302 -122.447047718592 (37.7792767325302, -122.447047718592) 15 5 1 54 16
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
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
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
112724 138451 DPW Maintained 1 Tristania conferta :: 61 2182 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6002125.8695 2114363.4018 37.7857585619048 -122.436402439491 (37.7857585619048, -122.436402439491) 13 6 1 29490 27
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
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
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
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
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
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
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
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
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
123256 57326 DPW Maintained 1 Tristania conferta :: 61 750 Presidio Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/31/1976 12:00:00 AM 14   Permit Number 16154 5999289.2953 2113999.1058 37.7845967138408 -122.446189932846 (37.7845967138408, -122.446189932846) 15 6 1 29490 31
124227 138714 DPW Maintained 1 Tristania conferta :: 61 1642 BRODERICK ST 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6000616.1387 2114405.757 37.7857889577881 -122.441628707296 (37.7857889577881, -122.441628707296) 15 6 1 29490 27
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
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
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);