720 rows where qSpecies_id = 127 sorted by Police 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)
690 19651 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 50 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
1786 19661 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 60 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
2447 19649 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 48 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
5193 19660 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 59 Sidewalk: Curb side : Cutout Tree DPW 1     18 60ST                      
6089 19680 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 79 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
6125 19650 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 49 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
6394 19671 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 70 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
6529 19672 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 71 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
8761 19674 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 73 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
11451 19677 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 76 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
11565 19675 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 74 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
11704 19657 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 56 Sidewalk: Curb side : Cutout Tree DPW 1     18 60ST                      
14154 19656 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 55 Sidewalk: Curb side : Cutout Tree DPW 1     18 60ST                      
14243 19683 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 82 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
15810 19653 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 52 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
19102 19678 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 77 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
23731 50377 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 1620 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734) 3 1 10 28860 6
33058 34460 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 1960 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/21/2015 12:00:00 AM   3x3 Permit Number 38200 6008233.26269903 2119182.7725058 37.7993365057546 -122.415613869084 (37.7993365057546, -122.415613869084) 5 1 10 308 32
85924 50378 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 1620 Montgomery St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734) 3 1 10 28860 6
157199 34459 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 1960 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/21/2015 12:00:00 AM     Permit Number 42077 6008233.26269903 2119182.7725058 37.7993365057546 -122.415613869084 (37.7993365057546, -122.415613869084) 5 1 10 308 32
161545 34458 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 1960 Jones St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/21/2015 12:00:00 AM   3x3 Permit Number 42077 6008233.26269903 2119182.7725058 37.7993365057546 -122.415613869084 (37.7993365057546, -122.415613869084) 5 1 10 308 32
2258 264781 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 90x Guy Pl 15 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
12634 264775 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 90x Guy Pl 9 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
83127 258089 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 499x 03rd St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6013834 2112606 37.7815914543655 -122.395772139146 (37.7815914543655, -122.395772139146) 6 2 9 28856 6
114449 224004 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 2 McCoppin St 5 : Tree Private 2     26 Width 5ft   6006363.21647 2109170.79033 37.7717407713548 -122.42137350531 (37.7717407713548, -122.42137350531) 8 2 9 28853 19
118289 258087 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 499x 03rd St 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   6013834 2112606 37.7815914543655 -122.395772139146 (37.7815914543655, -122.395772139146) 6 2 9 28856 6
160131 224448 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 36 McCoppin St 5 Sidewalk: Curb side : Cutout Tree Private 2     32 Width 4ft   6006371.64374 2109173.2323 37.7717479515507 -122.421344528235 (37.7717479515507, -122.421344528235) 8 2 9 28853 19
161192 48545 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 501X Mariposa St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM   3x3 Permit Number 45866 6013823 2112518 37.7813492145506 -122.395804026121 (37.7813492145506, -122.395804026121) 6 2 9 28856 6
176524 258088 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 499x 03rd St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6013834 2112606 37.7815914543655 -122.395772139146 (37.7815914543655, -122.395772139146) 6 2 9 28856 6
659 11520 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 101X Jennings St 10 Sidewalk: Curb side : Cutout Tree DPW 1   05/01/2017 12:00:00 AM 6 3X3   6018495.90717 2096693.85175 37.738158246093 -122.378538834904 (37.738158246093, -122.378538834904) 10 3 8 58 1
750 11540 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 101X Jennings St 30 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6018782.49291 2097080.98118 37.7392370206652 -122.37757481115 (37.7392370206652, -122.37757481115) 10 3 8 58 1
2037 62579 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 741 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/1986 12:00:00 AM 10   Permit Number 22784 6011303.77085 2104898.93824 37.7602885436105 -122.403983043294 (37.7602885436105, -122.403983043294) 10 3 8 28856 29
2309 11966 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1009X Mendell St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6015728.77645 2096327.58352 37.736999624078 -122.388080725796 (37.736999624078, -122.388080725796) 10 3 8 58 1
3167 199344 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1801 03rd St 3 Sidewalk: Property side : Yard Tree Private 2   10/16/2019 12:00:00 AM 3 Width 4ft   6015727.94816 2106771.64308 37.7656767749832 -122.388812492998 (37.7656767749832, -122.388812492998) 14 3 9 310 29
5369 38224 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1099 Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/21/1998 12:00:00 AM 14   Permit Number 40351 6014264.59569 2102044.43409 37.7526156672934 -122.393543078061 (37.7526156672934, -122.393543078061) 10 3 8 28856 29
6739 102293 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 801 Cesar Chavez St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6016486.61621 2101147.40436 37.7502758246674 -122.385796353939 (37.7502758246674, -122.385796353939) 10 3 8 58 1
6861 11269 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1176X Ingalls St 8 Sidewalk: Curb side : Cutout Tree DPW 1   04/03/1990 12:00:00 AM 3 3x3   6017716.362196 2093961.1645628 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671) 10 3 8 58 1
7136 62578 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 739 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/1986 12:00:00 AM 9   Permit Number 22783 6011302.74241 2104925.74778 37.7603620991639 -122.403988486898 (37.7603620991639, -122.403988486898) 10 3 8 28856 29
7357 11962 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 945X Mendell St 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6015820.0973 2096449.8462 37.7373403917231 -122.38777351408 (37.7373403917231, -122.38777351408) 10 3 8 58 1
7791 199356 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 2151 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 4ft   6011640.657 2104629.31608 37.759567037301 -122.402798942823 (37.759567037301, -122.402798942823) 10 3 8 28856 29
8025 10826 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1139X Hudson Ave 33 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/1990 12:00:00 AM 12 3X4   6017834.53501 2094620.05501 37.732427530713 -122.380681442077 (37.732427530713, -122.380681442077) 10 3 8 58 1
8639 199392 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1199 Ingalls St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   6018085.49835 2093997.29329 37.7307313955254 -122.379770541 (37.7307313955254, -122.379770541) 10 3 8 58 1
11257 199342 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1801 03rd St 1 Sidewalk: Property side : Yard Tree Private 2   10/16/2019 12:00:00 AM 3 Width 4ft   6015732.89393 2106644.75831 37.7653286510121 -122.388786527772 (37.7653286510121, -122.388786527772) 14 3 9 310 29
13883 11536 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 101X Jennings St 26 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6018721.15121 2096997.58655 37.739004655647 -122.377781119206 (37.739004655647, -122.377781119206) 10 3 8 58 1
13911 199353 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 2201 20th St 2 Sidewalk: Curb side : Yard Tree Private 2     15 Width 4ft   6011453.77249 2104619.23603 37.7595289231366 -122.403444576915 (37.7595289231366, -122.403444576915) 10 3 8 28856 29
14191 11527 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 101X Jennings St 17 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6018609.30332 2096848.22468 37.7385883738483 -122.378157476493 (37.7385883738483, -122.378157476493) 10 3 8 58 1
14650 199380 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 200 Jennings St 18 : Tree Private 2     15 Width 3ft   6018370.09073 2096624.46593 37.7379607900541 -122.378969032793 (37.7379607900541, -122.378969032793) 10 3 8 58 1
17121 199343 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1801 03rd St 2 Sidewalk: Property side : Yard Tree Private 2   10/16/2019 12:00:00 AM 3 Width 4ft   6015732.25453 2106672.58002 37.7654050079639 -122.388790681754 (37.7654050079639, -122.388790681754) 14 3 9 310 29
17736 199387 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1335 Hudson Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6017568.18175 2094804.88271 37.7329203283169 -122.381615146745 (37.7329203283169, -122.381615146745) 10 3 8 58 1
19346 199370 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 3550 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1     27 Width 4ft   6016015.91083 2099228.15232 37.7449798979207 -122.387290235768 (37.7449798979207, -122.387290235768) 10 3 8 58 1
19505 116636 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 2100 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 3x3   6011793.53885 2104686.09338 37.7597314702416 -122.402274190217 (37.7597314702416, -122.402274190217) 10 3 8 28856 29
20541 51528 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 2900 Hawes St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2005 12:00:00 AM     Permit Number 47830 6014679.41969777 2089453.24857655 37.7180658851091 -122.391228469926 (37.7180658851091, -122.391228469926) 10 3 8 58 1
22390 107072 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 400X Mariposa St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2014 12:00:00 AM 3 50x5 Permit Number 773144 6015855.63323 2106318.50292 37.7644396262057 -122.388339224777 (37.7644396262057, -122.388339224777) 14 3 9 310 29
22721 199372 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 2 Newhall St 2 : Tree DPW 1   11/12/2014 12:00:00 AM 15 Width 3ft Permit Number 774049 6018530.30847 2097200.55685 37.7395514542225 -122.378455061265 (37.7395514542225, -122.378455061265) 10 3 8 58 1
22932 11963 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1009X Mendell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6015687.60896 2096283.05677 37.7368750817287 -122.388219954896 (37.7368750817287, -122.388219954896) 10 3 8 58 1
23908 199351 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 875 Vermont St 8 Sidewalk: Curb side : Yard Tree Private 2     19     6011310.44581 2104289.70696 37.7586161031593 -122.403917085224 (37.7586161031593, -122.403917085224) 10 3 8 28856 29
24371 11231 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1050X Ingalls St 17 Sidewalk: Curb side : Cutout Tree DPW 1   04/02/1990 12:00:00 AM 50 3X4   6018085.6618829 2094069.8743192 37.7309306978843 -122.379775016493 (37.7309306978843, -122.379775016493) 10 3 8 58 1
25790 11503 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 Jennings St 17 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
26841 3665 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100X Cargo Way 101 Sidewalk: Curb side : Cutout Tree Port 6     18 3X3   6017153.34624 2098900.71457 37.7441437469313 -122.383334362693 (37.7441437469313, -122.383334362693) 10 3 8 58 1
27336 11531 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 101X Jennings St 21 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6018661.76808 2096921.71466 37.7387930541475 -122.377981176105 (37.7387930541475, -122.377981176105) 10 3 8 58 1
27772 11546 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 101X Jennings St 36 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6018856.19666 2097185.73418 37.7395287121888 -122.377327240377 (37.7395287121888, -122.377327240377) 10 3 8 58 1
28126 3696 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 401X Cargo Way 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6016376.57655 2099377.09307 37.7454088259626 -122.386053488085 (37.7454088259626, -122.386053488085) 10 3 8 58 1
29472 11507 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 Jennings St 21 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
31430 3675 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100X Cargo Way 111 Sidewalk: Curb side : Cutout Tree Port 6   03/07/2006 12:00:00 AM 3 3X3   6016978.81066 2099030.12804 37.7444894427423 -122.383946883753 (37.7444894427423, -122.383946883753) 10 3 8 58 1
31541 11327 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1223 Ingalls St 5 Sidewalk: Curb side : Cutout Tree DPW 1   05/03/1993 12:00:00 AM 40 3X3   6017540.6929483 2093936.3628532 37.7305340258377 -122.381649801703 (37.7305340258377, -122.381649801703) 10 3 8 58 1
31591 121615 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1406 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6011976.5645 2101798.75104 37.7518136770635 -122.401438271261 (37.7518136770635, -122.401438271261) 10 3 8 28856 29
32069 25444 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 2155 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6011824.01572 2087503.73336 37.7125540294141 -122.400961526274 (37.7125540294141, -122.400961526274) 10 3 8 309 1
32447 176389 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 700x Mansell St 16 Median : Cutout Tree DPW 1     38 Width 0ft   6009439.98083 2090047.93275 37.719406601704 -122.409380963965 (37.719406601704, -122.409380963965) 9 3 8 309 18
33732 11518 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 101X Jennings St 8 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6018467.96004 2096661.77747 37.7380686358665 -122.378633236729 (37.7380686358665, -122.378633236729) 10 3 8 58 1
34219 3678 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100X Cargo Way 114 Sidewalk: Curb side : Cutout Tree Port 6     18 3X3   6016900.55326 2099090.71493 37.7446514753884 -122.384221703094 (37.7446514753884, -122.384221703094) 10 3 8 58 1
34504 11481 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 10X Jennings St 7 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6012892.419875 2089345.335603 37.7176702433836 -122.397397833393 (37.7176702433836, -122.397397833393) 10 3 8 58 1
34976 3714 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 401X Cargo Way 19 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6016696.46917 2099138.87958 37.7447724395922 -122.384930747455 (37.7447724395922, -122.384930747455) 10 3 8 58 1
36799 3740 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 401X Cargo Way 45 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017167.798756 2098792.720184 37.7438480150026 -122.383276872883 (37.7438480150026, -122.383276872883) 10 3 8 58 1
38941 107069 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 400X Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2014 12:00:00 AM 3 8x8 Permit Number 773144 6015928.73625 2106322.43558 37.764454474908 -122.388086653778 (37.764454474908, -122.388086653778) 14 3 9 310 29
39028 200563 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1440 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 0ft   6016189.8592 2095311.5667 37.7342353814874 -122.386415722542 (37.7342353814874, -122.386415722542) 10 3 8 58 1
39632 36808 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 1290 Egbert Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39532 6014916.2781923 2090716.3266444 37.7215471911412 -122.39049795372 (37.7215471911412, -122.39049795372) 10 3 8 58 1
40398 3671 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100X Cargo Way 107 Sidewalk: Curb side : Cutout Tree Port 6     18 3X3   6017047.36981 2098978.83891 37.7443524031345 -122.38370624765 (37.7443524031345, -122.38370624765) 10 3 8 58 1
40825 199395 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 822 Mendell St 4 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6015923.40773 2096662.96792 37.7379313030858 -122.38743118203 (37.7379313030858, -122.38743118203) 10 3 8 58 1
41373 107948 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 2200 JERROLD AVE 4 Sidewalk: Property side : Cutout Tree Private 2       3x3   6012443.5 2099218.7 37.7447554536478 -122.399642400815 (37.7447554536478, -122.399642400815) 10 3 8 58 1
41424 200250 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 917 Ingerson Ave 1 unknown : Yard Tree Private 2     5 Width 0ft   6014641.601 2089467.7692 37.7181036570096 -122.391360208379 (37.7181036570096, -122.391360208379) 10 3 8 58 1
41537 3684 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100X Cargo Way 120 Sidewalk: Curb side : Cutout Tree Port 6     18 3X3   6016817.82171 2099151.76391 37.7448145287778 -122.384512026728 (37.7448145287778, -122.384512026728) 10 3 8 58 1
42566 11417 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 721X Mendell St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016212.49704 2096975.20091 37.7388046385926 -122.386453413297 (37.7388046385926, -122.386453413297) 10 3 8 58 1
42740 11506 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 Jennings St 20 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
43558 199363 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 2001 25th St 3 Sidewalk: Property side : Yard Tree Private 2     22 Width 8ft   6012400.81751 2101833.78107 37.7519335243359 -122.39997359673 (37.7519335243359, -122.39997359673) 10 3 8 28856 29
44147 3734 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 401X Cargo Way 39 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017167.798756 2098792.720184 37.7438480150026 -122.383276872883 (37.7438480150026, -122.383276872883) 10 3 8 58 1
44207 11524 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 101X Jennings St 14 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6018572.85172 2096797.82035 37.7384479645089 -122.378280011831 (37.7384479645089, -122.378280011831) 10 3 8 58 1
44228 3670 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100X Cargo Way 106 Sidewalk: Curb side : Cutout Tree Port 6     18 3X3   6017067.53558 2098965.30929 37.7443163682077 -122.383635576218 (37.7443163682077, -122.383635576218) 10 3 8 58 1
44656 3738 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 401X Cargo Way 43 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017167.798756 2098792.720184 37.7438480150026 -122.383276872883 (37.7438480150026, -122.383276872883) 10 3 8 58 1
44704 199379 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 200 Jennings St 17 : Tree Private 2     14 Width 3ft   6018388.0029 2096644.90744 37.7380179059959 -122.378908520106 (37.7380179059959, -122.378908520106) 10 3 8 58 1
46286 111319 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 200x PENINSULA AVE 2 Unaccepted Street : Yard Tree Private 2           6012569 2087626 37.7129312780718 -122.398395185538 (37.7129312780718, -122.398395185538) 10 3 8 309 1
47163 26803 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1470 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6016001.5116582 2095486.8668237 37.7347062925492 -122.387079128733 (37.7347062925492, -122.387079128733) 10 3 8 58 1
47765 36833 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 2715 Ingalls St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39537 6015005.69395491 2090908.83002417 37.7220807273762 -122.390202307194 (37.7220807273762, -122.390202307194) 10 3 8 58 1
48174 200148 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 2911 Keith St 2 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 0ft   6013582.2773 2091230.6387 37.7228852949007 -122.395145274417 (37.7228852949007, -122.395145274417) 10 3 8 58 1
49927 11477 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 10X Jennings St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6012892.419875 2089345.335603 37.7176702433836 -122.397397833393 (37.7176702433836, -122.397397833393) 10 3 8 58 1
50873 3679 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100X Cargo Way 115 Sidewalk: Curb side : Cutout Tree Port 6     12 3X3   6016884.1224 2099103.28613 37.7446850848489 -122.384279393677 (37.7446850848489, -122.384279393677) 10 3 8 58 1
51218 3739 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 401X Cargo Way 44 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017167.798756 2098792.720184 37.7438480150026 -122.383276872883 (37.7438480150026, -122.383276872883) 10 3 8 58 1
51353 11516 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 101X Jennings St 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6018445.80461 2096632.24283 37.7379863182046 -122.378707789643 (37.7379863182046, -122.378707789643) 10 3 8 58 1
51946 51527 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 2900 Hawes St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2005 12:00:00 AM     Permit Number 47830 6014679.41969777 2089453.24857655 37.7180658851091 -122.391228469926 (37.7180658851091, -122.391228469926) 10 3 8 58 1
55895 176390 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 700x Mansell St 37 Median : Cutout Tree DPW 1     21 Width 0ft   6009150.9462 2089957.57548 37.7191423008581 -122.410373676998 (37.7191423008581, -122.410373676998) 9 3 8 309 18
56138 3709 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 401X Cargo Way 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016611.7626 2099202.9223 37.7449436021699 -122.385228111002 (37.7449436021699, -122.385228111002) 10 3 8 58 1

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