320 rows where qSpecies_id = 145 sorted by qCareAssistant

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)
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                    
1024 200362 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1300 Phelps St 3 : Tree Private 2     7 Width 5ft   6014166.7855 2096532.27247 37.7374749933851 -122.393495590258 (37.7374749933851, -122.393495590258) 10 3 8 58 1
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                    
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
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                    
6777 228843 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 709 Eugenia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6007452.72902 2097768.34677 37.7404936415683 -122.416796844595 (37.7404936415683, -122.416796844595) 2 7 7 28859 2
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                    
8045 260674 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1561 Holloway Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6   5990104.65959 2090917.24159 37.7206912087067 -122.476278766554 (37.7206912087067, -122.476278766554) 1 8 4 64 14
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                    
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
10946 200359 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1150 Phelps St 4 : Tree Private 2     9 Width 5ft   6014213.14362 2096595.32013 37.7376506849368 -122.393339717964 (37.7376506849368, -122.393339717964) 10 3 8 58 1
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
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                    
12841 260672 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1561 Holloway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6   5990104.65959 2090917.24159 37.7206912087067 -122.476278766554 (37.7206912087067, -122.476278766554) 1 8 4 64 14
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
14628 96325 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1300X Sansome St 8 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2011 12:00:00 AM 5 4x4 Permit Number 768012 6011919 2120150.9 37.8022012393453 -122.402927984504 (37.8022012393453, -122.402927984504) 3 1 10 28860 6
16053 260673 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1561 Holloway Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6   5990104.65959 2090917.24159 37.7206912087067 -122.476278766554 (37.7206912087067, -122.476278766554) 1 8 4 64 14
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                    
19163 129769 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 80 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   6013010.632 2119281.7619 37.7998756901686 -122.399089343701 (37.7998756901686, -122.399089343701) 3 1 10 28860 6
19355 260675 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1561 Holloway Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6   5990104.65959 2090917.24159 37.7206912087067 -122.476278766554 (37.7206912087067, -122.476278766554) 1 8 4 64 14
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
20881 17660 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1000X Phelps St 5 Sidewalk: Curb side : Cutout Tree PUC 8     12 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407) 10 3 8 58 1
22641 129809 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 901 Sacramento St 8 Sidewalk: Curb side : Pot Tree Private 2     12 Width 3ft   6010417.7029 2116870.15869 37.7931091785103 -122.407891739714 (37.7931091785103, -122.407891739714) 3 1 10 28857 4
22737 140286 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1960 HAYES ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5998499.0219 2110040.6876 37.7736827610161 -122.448638806221 (37.7736827610161, -122.448638806221) 15 5 11 29492 16
24469 227936 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 167 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2     26 Width 5ft   6004844.7517 2099277.52267 37.7444904598682 -122.42592162061 (37.7444904598682, -122.42592162061) 2 7 5 63 22
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
26081 129751 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2320 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6000742.15542 2119656.12238 37.8002122659526 -122.441569636242 (37.8002122659526, -122.441569636242) 13 9 1 57 17
27842 15115 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 201 Mission St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6014020.20981 2116155.23725 37.7913471979732 -122.395376652733 (37.7913471979732, -122.395376652733) 12 2 9 28855 6
28094 129831 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 354 Sacramento St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6012476.45918 2117195.30949 37.7941170091435 -122.40079112993 (37.7941170091435, -122.40079112993) 3 1 10 28860 4
28803 27659 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 201 Mission St 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6014051.97429 2116162.83492 37.7913698260154 -122.395267279985 (37.7913698260154, -122.395267279985) 12 2 9 28855 6
29034 129824 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 333 Battery St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6012608.14 2117404.20841 37.7946979397237 -122.400350177025 (37.7946979397237, -122.400350177025) 3 1 10 28860 4
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
29654 29755 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 532 Columbus Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     45 3x3   6010020.30224 2119411.75263 37.800065518477 -122.409446229453 (37.800065518477, -122.409446229453) 3 1 10 308 23
29799 228851 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 210 Cumberland St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004146.65332 2104546.18314 37.7589174920696 -122.42871101271 (37.7589174920696, -122.42871101271) 2 4 5 28862 3
30466 129799 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1300 Sansome St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6011905.71705 2120324.12534 37.8026761322601 -122.4029861412 (37.8026761322601, -122.4029861412) 3 1 10 28860 6
31823 97178 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 222X Cumberland St 7 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2015 12:00:00 AM 3 4x4 Permit Number 774483 6004147.2 2104574.7 37.7589958235368 -122.428711154895 (37.7589958235368, -122.428711154895) 2 4 5 28862 3
31986 208170 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1225 Willard St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   5996717.7598 2107182.54151 37.7657330159006 -122.454593911282 (37.7657330159006, -122.454593911282) 15 5 11 29492 12
32409 39384 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2710 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM 7   Permit Number 40925 6000588.20452 2117202.12069 37.7934654530274 -122.441926131987 (37.7934654530274, -122.441926131987) 13 9 1 57 27
32545 200348 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 900 Phelps St 10 : Tree Private 2     9 Width 4ft   6014546.28219 2097041.88556 37.738895364638 -122.392219112326 (37.738895364638, -122.392219112326) 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
33465 96320 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1300X Sansome St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 4x4   6011919 2120150.9 37.8022012393453 -122.402927984504 (37.8022012393453, -122.402927984504) 3 1 10 28860 6
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
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
35332 200356 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 900 Phelps St 20 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6014331.31299 2096752.73935 37.7380894902424 -122.392942157366 (37.7380894902424, -122.392942157366) 10 3 8 58 1
35348 17631 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 420X Phelps St 1 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18   11/15/1992 12:00:00 AM 6 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.388649846738 (37.7428823403387, -122.388649846738) 10 3 8 58 1
37605 228842 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1010 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5999127.09441 2106474.67422 37.7639272833421 -122.446209649681 (37.7639272833421, -122.446209649681) 15 5 5 29492 9
39193 200350 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 900 Phelps St 12 : Tree Private 2     7 Width 4ft   6014508.81125 2096991.75117 37.7387556252824 -122.392345164903 (37.7387556252824, -122.392345164903) 10 3 8 58 1
39645 140287 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1960 HAYES ST 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5998483.9171 2110037.6666 37.7736736024147 -122.448690838206 (37.7736736024147, -122.448690838206) 15 5 11 29492 16
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
40856 129790 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1160 Sansome St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6011945.5166 2120015.13463 37.8018299412604 -122.402826669824 (37.8018299412604, -122.402826669824) 3 1 10 28860 6
40885 227937 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 465 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6002968.42227 2098587.52799 37.7424896769594 -122.432360309607 (37.7424896769594, -122.432360309607) 2 7 5 63 22
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
43501 17638 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 420X Phelps St 8 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.388649846738 (37.7428823403387, -122.388649846738) 10 3 8 58 1
44116 129771 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 80 Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6012935.02914 2119270.4372 37.7998403818928 -122.399350164196 (37.7998403818928, -122.399350164196) 3 1 10 28860 6
44709 96323 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1300X Sansome St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 4x4   6011919 2120150.9 37.8022012393453 -122.402927984504 (37.8022012393453, -122.402927984504) 3 1 10 28860 6
45676 15118 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 201 Mission St 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6014060.69419 2116194.6265 37.7914576032294 -122.395239337045 (37.7914576032294, -122.395239337045) 12 2 9 28855 6
45782 200361 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1300 Phelps St 1 : Tree Private 2     7 Width 5ft   6014182.02229 2096553.32448 37.7375336444497 -122.393444381967 (37.7375336444497, -122.393444381967) 10 3 8 58 1
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
47457 129798 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1300 Sansome St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6011911.92184 2120288.00736 37.8025773075571 -122.402962127524 (37.8025773075571, -122.402962127524) 3 1 10 28860 6
47873 129815 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 433 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6012587.02488 2117167.29458 37.7940462531923 -122.400406589716 (37.7940462531923, -122.400406589716) 3 1 10 28860 6
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
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
49670 228845 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 4526 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6001290.00365 2104097.67072 37.7575238972389 -122.438558485713 (37.7575238972389, -122.438558485713) 2 4 5 28862 3
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
50047 129847 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 103 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6012509.67235 2118803.01279 37.798533230779 -122.400789209861 (37.798533230779, -122.400789209861) 3 1 10 28860 6
51868 15120 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 201 Mission St 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6014101.62567 2116233.31764 37.7915661163392 -122.395100425058 (37.7915661163392, -122.395100425058) 12 2 9 28855 6
52940 17658 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1000X Phelps St 3 Sidewalk: Curb side : Cutout Tree PUC 8     6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407) 10 3 8 58 1
53191 228841 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 65 Homestead St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6000998.7373 2101290.13943 37.7497985212072 -122.439364559745 (37.7497985212072, -122.439364559745) 2 4 5 28862 22
54518 200335 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 750 Phelps St 7 : Tree Purchasing Dept 18     4 Width 2ft   6015505.4551 2098329.2709 37.7424834725483 -122.388992567847 (37.7424834725483, -122.388992567847) 10 3 8 58 1
55303 122998 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 42 07th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     14 Width 4ft   5993660.47545 2115225.1028 37.7876399054327 -122.465752700208 (37.7876399054327, -122.465752700208) 11 6 1 54 11
55858 200333 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 903 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6015264.35575 2104459.34943 37.7593020107061 -122.39025440841 (37.7593020107061, -122.39025440841) 10 3 8 28856 29
55878 129828 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 354 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6012548.89522 2117204.86317 37.7941472812331 -122.400541163364 (37.7941472812331, -122.400541163364) 3 1 10 28860 4
55981 129840 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 238 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6012708.88892 2118533.80702 37.7978051657442 -122.400080938001 (37.7978051657442, -122.400080938001) 3 1 10 28860 6
56968 143040 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1760 Grant Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6010444.0727 2120551.0606 37.8032175128046 -122.408060206321 (37.8032175128046, -122.408060206321) 3 1 10 308 23
57571 124474 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 344 Willard St North 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5996301.59979 2110522.81259 37.7748806555631 -122.456274850509 (37.7748806555631, -122.456274850509) 11 6 2 54 16
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
58485 129758 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 311 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6006236.20671 2111756.75185 37.7788340363914 -122.421996574482 (37.7788340363914, -122.421996574482) 7 9 11 28852 10
59314 14844 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1327 McAllister St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/16/1987 12:00:00 AM 6 3x3   6002796.5861 2111629.8173 37.7782909152526 -122.43388649175 (37.7782909152526, -122.43388649175) 15 5 11 29492 41
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
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
62138 129846 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 485 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6011762.70539 2118367.67112 37.7972961962093 -122.40334332134 (37.7972961962093, -122.40334332134) 3 1 10 308 4
62750 129804 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 901 Sacramento St 3 Sidewalk: Curb side : Pot Tree Private 2     12 Width 3ft   6010351.68054 2116862.21581 37.7930836728157 -122.408119621635 (37.7930836728157, -122.408119621635) 3 1 10 28857 4
62839 129795 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1300 Sansome St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6011922.61764 2120202.56088 37.8023432895615 -122.402919101237 (37.8023432895615, -122.402919101237) 3 1 10 28860 6
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
63039 129800 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1300 Sansome St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6011900.25036 2120353.89385 37.8027575640746 -122.403007153861 (37.8027575640746, -122.403007153861) 3 1 10 28860 6
63614 17661 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1000X Phelps St 6 Sidewalk: Curb side : Cutout Tree PUC 8     12 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407) 10 3 8 58 1
65172 228847 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 210 Cumberland St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6004213.13115 2104548.41319 37.758927377407 -122.428481260227 (37.758927377407, -122.428481260227) 2 4 5 28862 3
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
65779 96326 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1300X Sansome St 9 Sidewalk: Curb side : Cutout Tree Private 2     5 4x4   6011919 2120150.9 37.8022012393453 -122.402927984504 (37.8022012393453, -122.402927984504) 3 1 10 28860 6
66349 129826 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 333 Battery St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6012620.11049 2117309.34489 37.7944381345611 -122.400302091187 (37.7944381345611, -122.400302091187) 3 1 10 28860 4

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