trees

320 rows where qSpecies_id = 145 sorted by DBH

✎ View and edit SQL

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)
845 35702 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   15 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
1180 35696 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   6 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
4226 35703 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   16 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
4373 35701 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   13 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
4732 35697 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   8 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
4846 35692 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   2 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
5266 35698 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   10 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
6671 35694 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   4 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
7472 35704 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   17 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
8118 35693 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   3 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
11339 35700 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   14 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
17394 35705 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   7 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
17489 35695 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   5 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
17537 35699 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   11 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
18253 35690 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   9 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
19550 7767 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 325X Fulton St 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/25/2010 12:00:00 AM   3X3   6006199.471782 2111757.686674 37.7788345313197 -122.422123721721 (37.7788345313197, -122.422123721721) 7 9 11 28852 10
24804 49224 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 500 Howard St 13 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
29140 108656 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1200x SANSOME ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011928 2119969 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163) 3 1 10 28860 23
33900 103111 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 300 Post St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010691 2115198.3 37.7885339521538 -122.40682822806 (37.7885339521538, -122.40682822806) 5 1 10 28857 6
39344 45668 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 46(REVISED) Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2003 12:00:00 AM     Permit Number 44364 6004865.19751473 2101080.41704042 37.7494419484142 -122.425979237767 (37.7494419484142, -122.425979237767) 2 4 5 28862 22
46691 258502 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 3321 16th St 2 Front Yard : Yard Tree Private 2           6004551.31558 2106568.33958 37.7644927464624 -122.427455559127 (37.7644927464624, -122.427455559127) 8 4 5 28862 3
49467 85037 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 170 Vasquez Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5994836.8 2099436.6 37.7443565743554 -122.460538359387 (37.7443565743554, -122.460538359387) 1 8 4 59 40
49701 31389 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 201 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/03/1996 12:00:00 AM     Permit Number 36942 6014160.17669171 2116306.66761031 37.7917707740774 -122.394902977188 (37.7917707740774, -122.394902977188) 12 2 9 28855 6
57735 97618 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 333 Battery St 3 Sidewalk: Curb side : Cutout Tree Private 2           6012618 2117355 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987) 3 1 10 28860 4
60012 85038 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 170 Vasquez Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           5994836.8 2099436.6 37.7443565743554 -122.460538359387 (37.7443565743554, -122.460538359387) 1 8 4 59 40
61012 61067 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 532 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2002 12:00:00 AM     Permit Number 46064 6010044.29985327 2119322.50303189 37.7998218055895 -122.409356886218 (37.7998218055895, -122.409356886218) 3 1 10 308 23
61782 108657 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1200x SANSOME ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011928 2119969 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163) 3 1 10 28860 23
62966 108652 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1200x SANSOME ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011928 2119969 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163) 3 1 10 28860 23
65204 100696 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 3 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
67026 97617 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 333 Battery St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012618 2117355 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987) 3 1 10 28860 4
67507 115305 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1199x KEARNY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       6x5   6011077 2118941 37.7988320967672 -122.405756453764 (37.7988320967672, -122.405756453764) 3 1 10 308 23
70762 100699 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 6 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
72090 108651 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1200x SANSOME ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011928 2119969 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163) 3 1 10 28860 23
73225 100695 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 2 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
76043 49214 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 500 Howard St 19 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
76067 100146 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 222X Cumberland St 5 Sidewalk: Curb side : Cutout Tree Private 2           6004147.2 2104574.7 37.7589958235368 -122.428711154895 (37.7589958235368, -122.428711154895) 2 4 5 28862 3
76827 52992 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1800 Oakdale Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 48973 6013995.42685531 2096291.44248921 37.7368042013217 -122.394071207374 (37.7368042013217, -122.394071207374) 10 3 8 58 1
77431 108649 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1200x SANSOME ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011928 2119969 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163) 3 1 10 28860 23
81217 253611 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 900 Front St 12 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6012712.81893 2119514.81479 37.8004989968021 -122.400136271497 (37.8004989968021, -122.400136271497) 3 1 10 28860 6
89260 49223 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 500 Howard St 6 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
90645 97619 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 333 Battery St 4 Sidewalk: Curb side : Cutout Tree Private 2           6012618 2117355 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987) 3 1 10 28860 4
93232 115306 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1199x KEARNY ST 2 Sidewalk: Curb side : Cutout Tree Private 2       5x5   6011157 2118940 37.7988338244478 -122.405479555764 (37.7988338244478, -122.405479555764) 3 1 10 308 23
95161 63072 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 709 Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/21/1986 12:00:00 AM     Permit Number 23550 6007407.20126882 2097784.26133742 37.7405347785586 -122.416955389518 (37.7405347785586, -122.416955389518) 2 7 7 28859 2
96572 49230 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 500 Howard St 11 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
98870 100701 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 8 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
100518 100698 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 5 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
102617 50617 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 222X Cumberland St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/04/2004 12:00:00 AM     Permit Number 47216 6004288.29588296 2104553.28636794 37.7589450112214 -122.42822165267 (37.7589450112214, -122.42822165267) 2 4 5 28862 3
103802 32407 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 201 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/03/1996 12:00:00 AM     Permit Number 36942 6014160.17669171 2116306.66761031 37.7917707740774 -122.394902977188 (37.7917707740774, -122.394902977188) 12 2 9 28855 6
121482 31388 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 201 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/03/1996 12:00:00 AM     Permit Number 36942 6014160.17669171 2116306.66761031 37.7917707740774 -122.394902977188 (37.7917707740774, -122.394902977188) 12 2 9 28855 6
126383 108650 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1200x SANSOME ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011928 2119969 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163) 3 1 10 28860 23
133011 49232 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 500 Howard St 27 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
134027 32408 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 201 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/03/1996 12:00:00 AM     Permit Number 36942 6014160.17669171 2116306.66761031 37.7917707740774 -122.394902977188 (37.7917707740774, -122.394902977188) 12 2 9 28855 6
137482 100694 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 1 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
141871 108654 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1200x SANSOME ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011928 2119969 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163) 3 1 10 28860 23
143003 49225 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 500 Howard St 23 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
143226 108037 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1527 Stockton St 3 Sidewalk: Curb side : Cutout Tree Private 2           6010078.268 2119414.52002 37.8000763647164 -122.4092458402 (37.8000763647164, -122.4092458402) 3 1 10 308 23
144675 108036 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1527 Stockton St 2 Sidewalk: Curb side : Cutout Tree Private 2           6010078.268 2119414.52002 37.8000763647164 -122.4092458402 (37.8000763647164, -122.4092458402) 3 1 10 308 23
148471 108655 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1200x SANSOME ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011928 2119969 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163) 3 1 10 28860 23
155249 100145 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 222X Cumberland St 4 Sidewalk: Curb side : Cutout Tree Private 2           6004147.2 2104574.7 37.7589958235368 -122.428711154895 (37.7589958235368, -122.428711154895) 2 4 5 28862 3
155881 108653 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1200x SANSOME ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011928 2119969 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163) 3 1 10 28860 23
158867 64146 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 465 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24921 6002780.16143913 2098575.90057442 37.7424470739996 -122.433010428517 (37.7424470739996, -122.433010428517) 2 7 5 63 22
165976 50616 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 222X Cumberland St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2004 12:00:00 AM     Permit Number 47216 6004288.29588296 2104553.28636794 37.7589450112214 -122.42822165267 (37.7589450112214, -122.42822165267) 2 4 5 28862 3
170900 100697 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 4 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
175740 32406 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 201 Mission St 5 Sidewalk: Curb side : Cutout Tree Private 2   10/03/1996 12:00:00 AM     Permit Number 36942 6014160.17669171 2116306.66761031 37.7917707740774 -122.394902977188 (37.7917707740774, -122.394902977188) 12 2 9 28855 6
182062 100700 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 7 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
183416 50615 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 222X Cumberland St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2004 12:00:00 AM     Permit Number 47216 6004288.29588296 2104553.28636794 37.7589450112214 -122.42822165267 (37.7589450112214, -122.42822165267) 2 4 5 28862 3
188850 49226 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 500 Howard St 26 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
193764 68365 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 945 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32186 6010298.82314684 2116844.8632649 37.7930330672197 -122.408301287665 (37.7930330672197, -122.408301287665) 3 1 10 28857 4
110687 227935 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 705 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6008535.61915 2104408.30699 37.7587863358342 -122.413522114462 (37.7587863358342, -122.413522114462) 2 4 7 28859 19
170852 51593 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1960 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/08/2010 12:00:00 AM 1 3x3 Permit Number 53890 5998519.8939 2110042.61 37.7736892328814 -122.448566745533 (37.7736892328814, -122.448566745533) 15 5 11 29492 16
182143 227934 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1731 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6005814.85418 2107243.32997 37.7664174935056 -122.423133300469 (37.7664174935056, -122.423133300469) 8 4 5 28853 19
10517 129837 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 733 Front St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6012785.65581 2118614.39014 37.7980307075983 -122.399820962885 (37.7980307075983, -122.399820962885) 3 1 10 28860 6
11205 17641 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 600X Phelps St 2 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     10 2x2   6015304.738625 2098066.4602575 37.7417507208067 -122.38966824015 (37.7417507208067, -122.38966824015) 10 3 8 58 1
32934 129796 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1300 Sansome St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6011917.98876 2120230.87285 37.8024207688713 -122.402937111974 (37.8024207688713, -122.402937111974) 3 1 10 28860 6
59419 228844 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 709 Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007473.72577 2097767.91667 37.7404936415809 -122.416724215363 (37.7404936415809, -122.416724215363) 2 7 7 28859 2
84528 17645 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 600X Phelps St 6 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     10 2x2   6015304.738625 2098066.4602575 37.7417507208067 -122.38966824015 (37.7417507208067, -122.38966824015) 10 3 8 58 1
85481 62970 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1827 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/21/1986 12:00:00 AM 10   Permit Number 23357 6008241.17422 2118766.33453 37.7981935154844 -122.415556992457 (37.7981935154844, -122.415556992457) 5 1 10 28858 21
85887 129766 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1375 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6006461.42741 2118668.07402 37.7978235173022 -122.421708471292 (37.7978235173022, -122.421708471292) 13 9 10 28858 32
96501 129759 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1827 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008241.72856 2118745.4751 37.7981362718366 -122.415553596641 (37.7981362718366, -122.415553596641) 5 1 10 28858 21
109468 129802 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 901 Sacramento St 1 Sidewalk: Curb side : Pot Tree Private 2     10 Width 3ft   6010252.4995 2116845.85776 37.79303320378 -122.408461640988 (37.79303320378, -122.408461640988) 3 1 10 28857 4
133294 200351 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 900 Phelps St 15 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6014421.21333 2096874.8296 37.73842971815 -122.39263986285 (37.73842971815, -122.39263986285) 10 3 8 58 1
153275 129770 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 80 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6012963.29649 2119273.7997 37.7998511899251 -122.399252584145 (37.7998511899251, -122.399252584145) 3 1 10 28860 6
158425 129805 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 901 Sacramento St 4 Sidewalk: Curb side : Pot Tree Private 2     10 Width 3ft   6010365.08882 2116862.85785 37.793086186442 -122.408073273289 (37.793086186442, -122.408073273289) 3 1 10 28857 4
180495 200337 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 750 Phelps St 9 : Tree Private 2     10 Width 4ft   6015484.25752 2098301.13552 37.7424050435698 -122.389063899405 (37.7424050435698, -122.389063899405) 10 3 8 58 1
34905 200353 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 900 Phelps St 17 : Tree Private 2     11 Width 5ft   6014392.43301 2096834.63166 37.738317744462 -122.392736560653 (37.738317744462, -122.392736560653) 10 3 8 58 1
40742 129762 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2222 Polk St 6 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6006368.54903 2118610.8656 37.797661199563 -122.422025790757 (37.797661199563, -122.422025790757) 13 9 10 28858 32
41885 129807 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 901 Sacramento St 6 Sidewalk: Curb side : Pot Tree Private 2     11 Width 3ft   6010390.20829 2116866.53247 37.7930976824694 -122.407986617304 (37.7930976824694, -122.407986617304) 3 1 10 28857 4
49455 129816 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 433 Sacramento St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6012609.05006 2117170.52576 37.7940563534572 -122.400330606896 (37.7940563534572, -122.400330606896) 3 1 10 28860 6
66376 129763 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1379 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6006382.65003 2118656.35061 37.7977868852004 -122.421980230217 (37.7977868852004, -122.421980230217) 13 9 10 28858 32
114811 129835 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 733 Front St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6012779.55401 2118654.25305 37.7981398214472 -122.399844877638 (37.7981398214472, -122.399844877638) 3 1 10 28860 6
117859 200354 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 900 Phelps St 18 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 5ft   6014359.7983 2096791.80766 37.7381983459865 -122.392846401168 (37.7381983459865, -122.392846401168) 10 3 8 58 1
123142 129844 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 750 Battery St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6012469.34241 2118758.90101 37.7984098608851 -122.400925663989 (37.7984098608851, -122.400925663989) 3 1 10 28860 6
129360 129755 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2407 Clay St 8 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6003208.43493 2116180.994 37.7908106615232 -122.432786962347 (37.7908106615232, -122.432786962347) 13 9 1 29490 27
163498 200355 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 900 Phelps St 19 : Tree Private 2     11 Width 5ft   6014345.08354 2096773.39107 37.7381469605042 -122.392895989784 (37.7381469605042, -122.392895989784) 10 3 8 58 1
164665 208168 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2590 16th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5991441.45062 2097800.63089 37.7396687033598 -122.472159425416 (37.7396687033598, -122.472159425416) 1 8 4 29491 40
165029 129803 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 901 Sacramento St 2 Sidewalk: Curb side : Pot Tree Private 2     11 Width 3ft   6010302.01456 2116853.58579 37.7930571958732 -122.408290860643 (37.7930571958732, -122.408290860643) 3 1 10 28857 4
179889 200347 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 900 Phelps St 9 : Tree Private 2     11 Width 4ft   6014556.03183 2097054.78425 37.7389313231291 -122.392186304173 (37.7389313231291, -122.392186304173) 10 3 8 58 1
190958 129820 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 241 Battery St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6012651.85549 2117070.09364 37.7937829775554 -122.400175437873 (37.7937829775554, -122.400175437873) 4 1 10 28860 6
4161 7768 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 325X Fulton St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006199.471782 2111757.686674 37.7788345313197 -122.422123721721 (37.7788345313197, -122.422123721721) 7 9 11 28852 10
14526 15114 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 201 Mission St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6014005.1464 2116140.60731 37.7913061897683 -122.39542774681 (37.7913061897683, -122.39542774681) 12 2 9 28855 6

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