494 rows where qSpecies_id = 243

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)
2758 179704 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 27 Tulane St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6007379.54871 2093756.9583 37.7294751316534 -122.416765758639 (37.7294751316534, -122.416765758639) 9 3 7 309 28
2950 19885 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 100 STAIRWAY33 17 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
4139 143087 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 480 FILBERT ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6010585.232 2119982.0381 37.8016630194804 -122.407531575883 (37.8016630194804, -122.407531575883) 3 1 10 308 23
5366 179679 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 498x San Juan Ave 4 Sidewalk: Property side : Yard Tree Private 2     7 Width 6ft   6000569.78695 2092772.13999 37.7263856753507 -122.44023711527 (37.7263856753507, -122.44023711527) 9 7 6 28861 25
5748 115724 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 250x Octavia St 1 Side Yard : Yard Tree Dept of Real Estate 7                              
6530 20001 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 100 STAIRWAY46 21 Sidewalk: Curb side : Cutout Tree DPW 1     6 2                      
6959 179678 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 498x San Juan Ave 3 Sidewalk: Property side : Yard Tree Private 2     7 Width 6ft   6000584.20911 2092761.60072 37.7263575580392 -122.440186503209 (37.7263575580392, -122.440186503209) 9 7 6 28861 25
7239 117920 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 727 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5983191.607 2110832.41366 37.7749694365706 -122.501647249063 (37.7749694365706, -122.501647249063) 11 6 2 55 26
7827 115725 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 250X Octavia St 2 Side Yard : Yard Tree Dept of Real Estate 7                              
8030 136599 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 2298 Beach St 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   5999338.92824 2120854.31751 37.8034221414854 -122.44651158266 (37.8034221414854, -122.44651158266) 13 9 1 57 17
8289 179793 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 629 Hamilton St 5 Sidewalk: Property side : Yard Tree Private 2     4 Width 2ft   6009759.65206 2091562.25484 37.7235825209091 -122.408382730001 (37.7235825209091, -122.408382730001) 10 3 7 309 28
10501 136602 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 3698 Beach St 1 Sidewalk: Property side : Yard Tree Private 2     12 Width 5ft   6002136.39741 2121144.63129 37.8043786541109 -122.436851639901 (37.8043786541109, -122.436851639901) 13 9 1 57 17
10511 142965 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 111 Pfeiffer St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6010321.3688 2121130.7743 37.8048023922739 -122.408525746416 (37.8048023922739, -122.408525746416) 3 1 10 308 23
10806 179754 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 201 Trumbull St 35 Sidewalk: Property side : Yard Tree Private 2     6 Width 4ft   6004870.43826 2094360.42789 37.730990679074 -122.42548293491 (37.730990679074, -122.42548293491) 9 7 6 28861 5
11360 187125 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 2600 Sunset Blvd 61 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985146.9994 2097362.2698 37.7380988064322 -122.493890328885 (37.7380988064322, -122.493890328885) 1 8 3 29491 35
11385 262470 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 35 Broadmoor Dr 2 Sidewalk: Property side : Yard Tree Private 2       2x6   5991096 2093545 37.7279638199594 -122.4730435743 (37.7279638199594, -122.4730435743) 9 8 4 64 40
12365 261369 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 48 Bache St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007159 2095436 37.7340730065148 -122.41764717788 (37.7340730065148, -122.41764717788) 2 7 7 28859 2
12366 179680 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 498x San Juan Ave 5 Sidewalk: Property side : Yard Tree Private 2     7 Width 6ft   6000544.18408 2092789.85376 37.726432855581 -122.440326892784 (37.726432855581, -122.440326892784) 9 7 6 28861 25
13180 179663 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 333 Tocoloma Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6012567.36741 2086868.9308 37.7108524248833 -122.398347742071 (37.7108524248833, -122.398347742071) 10 3 8 309 1
13186 215278 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 179 Staples Ave 5 Sidewalk: Property side : Yard Tree Private 2     6 Width 10ft   5998891.37241 2093762.83604 37.7290101929567 -122.446110523694 (37.7290101929567, -122.446110523694) 9 7 4 28861 40
15870 19880 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 100 STAIRWAY33 12 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
17702 241027 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 336 Hoffman Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6000616.7191 2101813.33629 37.7512133463326 -122.440723116081 (37.7512133463326, -122.440723116081) 2 4 5 28862 22
19097 179681 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 498x San Juan Ave 6 Sidewalk: Property side : Yard Tree Private 2     8 Width 6ft   6000538.34703 2092794.14032 37.7264442931449 -122.44034737844 (37.7264442931449, -122.44034737844) 9 7 6 28861 25
19691 215239 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 490 Faxon Ave 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   5994798.71482 2091830.48976 37.7234698691262 -122.46011911753 (37.7234698691262, -122.46011911753) 9 8 4 28861 24
19921 215192 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 199 Lomita Ave 3 Sidewalk: Property side : Yard Tree Private 2     10 Width 4ft   5991270.56411 2104187.78327 37.7571962750993 -122.473215972337 (37.7571962750993, -122.473215972337) 1 8 4 56 12
19969 106456 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 2343 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15     5988548.8369 2099368.6206 37.743806169615 -122.48227557587 (37.743806169615, -122.48227557587) 1 8 3 29491 35
20828 179697 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1100 Felton St 3 Sidewalk: Property side : Yard Tree Private 2     10 Width 2ft   6007690.32077 2092934.09301 37.7272331955512 -122.415633147958 (37.7272331955512, -122.415633147958) 9 3 7 309 5
22724 138531 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1660 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6001633.4592 2114193.0647 37.7852628681266 -122.438093830321 (37.7852628681266, -122.438093830321) 13 6 11 29490 13
22802 215228 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 469 Ulloa St 1 Sidewalk: Curb side : Yard Tree Private 2     28 Width 4ft   5995237.23604 2098198.29542 37.7409795263953 -122.459064099442 (37.7409795263953, -122.459064099442) 1 8 4 59 40
22855 122252 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1600 Clement St 7 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5990423.37327 2113418.93453 37.7824934165268 -122.476820305635 (37.7824934165268, -122.476820305635) 11 6 2 55 26
22938 179742 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 201 Trumbull St 23 Sidewalk: Property side : Yard Tree Private 2     12 Width 4ft   6004901.02549 2094358.92727 37.7309882868812 -122.425377082885 (37.7309882868812, -122.425377082885) 9 7 6 28861 5
23353 215272 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 320 Congo St 2 Sidewalk: Property side : Yard Tree Private 2     6 Width 8ft   6000122.75697 2094814.15611 37.7319671170702 -122.441928973853 (37.7319671170702, -122.441928973853) 9 7 4 63 40
23365 179763 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 201 Trumbull St 44 Sidewalk: Property side : Yard Tree Private 2     12 Width 10ft   6004845.97197 2094361.80258 37.7309930712551 -122.425567616849 (37.7309930712551, -122.425567616849) 9 7 6 28861 5
24220 179638 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 286 Foote Ave 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 5ft   5998314.38547 2088719.36109 37.7151290150634 -122.447742271601 (37.7151290150634, -122.447742271601) 9 7 6 28861 25
25328 241047 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 156 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6005501.90776 2099064.47249 37.7439425892855 -122.423634161688 (37.7439425892855, -122.423634161688) 2 7 5 28859 22
25387 249848 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 289 Greenwich St 2 Side Yard : Yard Tree Private 2     5 Width 0ft   6011433.333 2120390.12785 37.8028309694274 -122.404625486584 (37.8028309694274, -122.404625486584) 3 1 10 308 23
25640 179694 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 452 Pioche St 4 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   6005521.71663 2093231.02164 37.7279263551921 -122.423151104361 (37.7279263551921, -122.423151104361) 9 7 7 309 5
25750 253293 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 840x Sacramento St 1 Sidewalk: Property side : Cutout Tree Private 2           6010611 2116923 37.7932650877933 -122.407226643637 (37.7932650877933, -122.407226643637) 3 1 10 28857 4
25752 179781 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 201 Trumbull St 62 Sidewalk: Property side : Yard Tree Private 2     7 Width 10ft   6004781.59903 2094368.78968 37.7310086187399 -122.425790662224 (37.7310086187399, -122.425790662224) 9 7 6 28861 5
26268 241026 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 91 Gold Mine Dr 6 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   6001663.57793 2099103.26544 37.7438316956774 -122.436908978891 (37.7438316956774, -122.436908978891) 2 7 5 63 22
26310 187552 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 2 Beeman Ln 1 Side Yard : Yard Tree Private 2     35     6012028.62057 2088183.94027 37.7144331529482 -122.400302089394 (37.7144331529482, -122.400302089394) 10 7 8 309 39
26407 215220 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 2020 09th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     17 Width 6ft   5993507.89159 2101745.37647 37.7506193459188 -122.465301081296 (37.7506193459188, -122.465301081296) 1 8 4 29491 40
26471 179720 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 201 Trumbull St 1 Sidewalk: Property side : Yard Tree Private 2     20 Width 4ft   6004978.66043 2094360.05268 37.730995762948 -122.42510876568 (37.730995762948, -122.42510876568) 9 7 6 28861 5
26649 136624 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1120 Lombard St 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 2ft   6006955.61886 2120188.67307 37.8020265537335 -122.42010639829 (37.8020265537335, -122.42010639829) 5 1 1 28858 32
27104 136613 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1163 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008339.99161 2115873.76917 37.7902567978586 -122.415010210055 (37.7902567978586, -122.415010210055) 5 1 10 28858 21
28381 136612 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1697 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6006706.3991 2116349.10339 37.7914700147761 -122.420696089151 (37.7914700147761, -122.420696089151) 13 9 10 28858 21
28433 179761 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 201 Trumbull St 42 Sidewalk: Property side : Yard Tree Private 2     15 Width 10ft   6004848.16693 2094362.1927 37.7309942664614 -122.425560056251 (37.7309942664614, -122.425560056251) 9 7 6 28861 5
28719 179664 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 325 Tocoloma Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 1ft   6012585.69681 2086923.17392 37.711002386816 -122.398288194338 (37.711002386816, -122.398288194338) 10 3 8 309 1
30213 241032 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 683 Duncan St 10 Sidewalk: Property side : Yard Tree Private 2     2 Width 3ft   6002120.19766 2099702.71047 37.7455035731345 -122.435372968292 (37.7455035731345, -122.435372968292) 2 7 5 63 22
31347 215281 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 262 Judson Ave 2 Sidewalk: Property side : Yard Tree Private 2     5     5998329.72097 2093571.17707 37.7284518524518 -122.448038393164 (37.7284518524518, -122.448038393164) 9 7 4 28861 40
31356 106089 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 1446 36TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     14 6x6   5984998.6 2105346.4 37.7600123616364 -122.494991962302 (37.7600123616364, -122.494991962302) 1 8 3 56 35
31458 179784 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 201 Trumbull St 65 Sidewalk: Property side : Yard Tree Private 2     14     6004770.67322 2094369.23235 37.7310092167841 -122.425828466117 (37.7310092167841, -122.425828466117) 9 7 6 28861 5
31527 241022 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 612 28th St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6001940.95583 2099448.41005 37.7447951429899 -122.435974564372 (37.7447951429899, -122.435974564372) 2 7 5 63 22
31618 215190 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1762 08th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5993759.82909 2103508.02365 37.755473648904 -122.464557841094 (37.755473648904, -122.464557841094) 1 8 4 56 12
31668 123333 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 737 04th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 4ft   5994714.05712 2110527.69086 37.7748027900674 -122.461766808811 (37.7748027900674, -122.461766808811) 11 6 2 54 11
31815 179630 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 290 Foote Ave 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   5998313.80825 2088717.96768 37.7151251560878 -122.447744166462 (37.7151251560878, -122.447744166462) 9 7 6 28861 25
32092 179650 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 567 Lisbon St 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 6ft   6001888.79555 2090193.80134 37.719381146405 -122.435493004403 (37.719381146405, -122.435493004403) 9 7 6 28861 5
32437 215229 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 100 Hearst Ave 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   6000677.32217 2094383.25488 37.7308155477923 -122.439980842666 (37.7308155477923, -122.439980842666) 9 7 4 63 40
32487 136610 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 3798 Webster St 7 Side Yard : Yard Tree Private 2     15 Width 4ft   6002559.08771 2121673.9848 37.8058561332109 -122.43542677652 (37.8058561332109, -122.43542677652) 13 9 1 57 17
32605 179683 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 443 Peru Ave 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   6004745.82241 2092849.57746 37.7268351771866 -122.425806252864 (37.7268351771866, -122.425806252864) 9 7 6 28861 5
32797 136609 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 3798 Webster St 6 Side Yard : Yard Tree Private 2     7 Width 4ft   6002557.10875 2121672.73918 37.8058526006778 -122.435433535844 (37.8058526006778, -122.435433535844) 13 9 1 57 17
33313 15991 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 236 Moncada Way 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 35M   5992398.75579 2093455.53191 37.7277935021904 -122.468533444909 (37.7277935021904, -122.468533444909) 9 8 4 59 40
33409 241044 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 300 Virginia Ave 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 3ft   6006926.17772 2098328.2002 37.7420012434536 -122.418657149801 (37.7420012434536, -122.418657149801) 2 7 7 28859 2
33418 138663 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1722 LYON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5999590.4442 2114811.9884 37.7868458713434 -122.44520652592 (37.7868458713434, -122.44520652592) 15 6 1 29490 31
33562 179792 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 629 Hamilton St 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 2ft   6009761.92268 2091556.81874 37.7235677216684 -122.408374497582 (37.7235677216684, -122.408374497582) 10 3 7 309 28
34112 179641 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1101 Cayuga Ave 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   6000468.15764 2090746.71388 37.72081853103 -122.440443242589 (37.72081853103, -122.440443242589) 9 7 6 28861 25
34400 215259 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 500 Junipero Serra Blvd 41 : Tree Private 2     10 Width 0ft   5991333.88736 2093532.91422 37.7279444054996 -122.472220318525 (37.7279444054996, -122.472220318525) 9 8 4 64 40
34829 179692 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 425 Pioche St 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 8ft   6005640.05215 2093208.69537 37.7278717294828 -122.422740428923 (37.7278717294828, -122.422740428923) 9 7 7 309 5
35860 179747 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 201 Trumbull St 28 Sidewalk: Property side : Yard Tree Private 2     8 Width 4ft   6004888.75202 2094357.65549 37.7309841014177 -122.425419423893 (37.7309841014177, -122.425419423893) 9 7 6 28861 5
35926 183756 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 2279 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5987914.4572 2099809.712 37.7449803690211 -122.484501430655 (37.7449803690211, -122.484501430655) 1 8 3 29491 35
36253 16409 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1186X Munich St 2 Sidewalk: Curb side : Cutout Tree DPW 1     42 TR   6001094.97043 2087182.82135 37.7110685499383 -122.438021394384 (37.7110685499383, -122.438021394384) 9 7 6 28861 5
36453 179748 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 201 Trumbull St 29 Sidewalk: Property side : Yard Tree Private 2     5 Width 4ft   6004886.15105 2094358.79772 37.730987090773 -122.425428497145 (37.730987090773, -122.425428497145) 9 7 6 28861 5
36867 215262 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 500 Junipero Serra Blvd 68 : Tree Private 2     15 Width 0ft   5991312.44633 2093241.21549 37.7271422327182 -122.472273185176 (37.7271422327182, -122.472273185176) 9 8 4 64 40
37142 105552 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 329 Tocoloma Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9     6012582.61187 2086912.65676 37.7109733369276 -122.398298119266 (37.7109733369276, -122.398298119266) 10 3 8 309 1
37882 241038 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1550 Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 2ft   6003298.54471 2099144.36653 37.7440373400686 -122.431258583422 (37.7440373400686, -122.431258583422) 2 7 5 63 22
38361 215265 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 215 Acadia St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001400.43873 2095135.77818 37.732922941738 -122.437534787422 (37.732922941738, -122.437534787422) 9 7 5 63 40
38456 241046 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 2868 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6009024.96675 2103353.45753 37.7559174229641 -122.411755183159 (37.7559174229641, -122.411755183159) 2 4 7 28859 19
39363 215200 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1201 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5992335.9791 2098407.62605 37.7413870847351 -122.469110721894 (37.7413870847351, -122.469110721894) 1 8 4 59 40
39423 197875 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1022 Harrison St 1 Sidewalk: Curb side : Yard Tree Private 2     16 Width 0ft   6011232.56794 2110864.16266 37.7766637150973 -122.40464924399 (37.7766637150973, -122.40464924399) 14 2 9 28853 34
40395 122250 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1600 Clement St 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   5990504.56786 2113419.1912 37.7824988308057 -122.476539429393 (37.7824988308057, -122.476539429393) 11 6 2 55 26
41381 142963 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 119 Pfeiffer St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6010263.5377 2121122.3795 37.8047761033373 -122.408725285275 (37.8047761033373, -122.408725285275) 3 1 10 308 23
41481 179741 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 201 Trumbull St 22 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6004901.63647 2094356.73695 37.7309823072691 -122.425374814811 (37.7309823072691, -122.425374814811) 9 7 6 28861 5
41499 197887 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1493 Kansas St 2 Sidewalk: Curb side : Yard Tree Private 2     24 Width 6ft   6011776.63804 2101418.39447 37.7507581436897 -122.402102910747 (37.7507581436897, -122.402102910747) 10 3 8 28856 29
41588 215191 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1762 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   5993759.89754 2103496.87888 37.7554430521829 -122.46455679518 (37.7554430521829, -122.46455679518) 1 8 4 56 12
42214 114819 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 251x TRUMBULL ST 1 Median : Cutout Tree DPW 1     8 3x3   6004998 2094336 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756) 9 7 6 28861 5
44044 179666 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 309 Tocoloma Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6012604.11309 2086981.70393 37.7111641245081 -122.398228646659 (37.7111641245081, -122.398228646659) 10 3 8 309 1
44118 179637 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 120 Farragut Ave 6 Sidewalk: Property side : Yard Tree Private 2     6 Width 3ft   5997385.09042 2087337.68892 37.7112821038472 -122.450854733483 (37.7112821038472, -122.450854733483) 9 7 6 28861 25
44245 110874 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 800 INDIANA ST 8 Sidewalk: Property side : Yard Tree Private 2           6014913.4 2104437.2 37.7592217202179 -122.391466645187 (37.7592217202179, -122.391466645187) 10 3 8 28856 29
44306 136626 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1120 Lombard St 3 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6006933.58689 2120186.44007 37.8020191811091 -122.420182480954 (37.8020191811091, -122.420182480954) 5 1 1 28858 32
44787 179729 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 201 Trumbull St 10 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6004942.13253 2094358.51707 37.7309894829579 -122.425234939651 (37.7309894829579, -122.425234939651) 9 7 6 28861 5
44987 179658 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 579 Madrid St 6 Sidewalk: Property side : Yard Tree Private 2     13 Width 4ft   6002445.72289 2090555.63899 37.7204062871908 -122.433593761257 (37.7204062871908, -122.433593761257) 9 7 6 28861 5
45753 179777 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 201 Trumbull St 58 Sidewalk: Property side : Yard Tree Private 2     6 Width 10ft   6004790.57095 2094369.04032 37.731009813945 -122.425759662593 (37.731009813945, -122.425759662593) 9 7 6 28861 5
45972 215224 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 400x Miramar Ave 5 Median : Yard Tree DPW 1     29     5995369.41897 2092571.16571 37.7255363969609 -122.458199891431 (37.7255363969609, -122.458199891431) 9 7 4 28861 40
46073 241023 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 700 Grand View Ave 1 Sidewalk: Property side : Yard Tree Private 2     13 Width 3ft   6000036.33975 2101035.65516 37.7490449531781 -122.442674291501 (37.7490449531781, -122.442674291501) 2 4 5 28862 22
47809 116010 Significant Tree 6 Syzygium paniculatum :: Brush Cherry 243 199x SAN BUENAVENTURA WAY 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993547 2095667 37.7339319096844 -122.464724497297 (37.7339319096844, -122.464724497297) 9 8 4 59 40
47988 241042 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 414 Eureka St 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 1ft   6001480.46567 2103259.11131 37.7552322483814 -122.437839733137 (37.7552322483814, -122.437839733137) 2 4 5 28862 22
48412 179688 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 376 Trumbull St 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   6005640.73705 2094230.00919 37.7306760710471 -122.422810613826 (37.7306760710471, -122.422810613826) 9 7 6 28861 5
48868 179640 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1101 Cayuga Ave 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   6000461.77381 2090733.06087 37.7207806794643 -122.440464330785 (37.7207806794643, -122.440464330785) 9 7 6 28861 25
49407 179631 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 184 Mount Vernon Ave 11 Side Yard : Yard Tree Private 2     10     5998932.98787 2089405.36091 37.7170479506817 -122.445653426162 (37.7170479506817, -122.445653426162) 9 7 6 28861 25
49458 179701 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 1142 Silliman St 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6007388.41851 2093322.95448 37.7282839499293 -122.416704361037 (37.7282839499293, -122.416704361037) 9 3 7 309 5

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