3,267 rows where qSpecies_id = 67 sorted by YCoord

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)
85528 175608 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 466 Tocoloma Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6012381.21088 2086413.92424 37.7095926950223 -122.398959231579 (37.7095926950223, -122.398959231579) 10 3 8 309 1
72664 24269 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 300X Winding Way 7 Median : Cutout Tree DPW 1     6 8   6001399.20674 2086458.92155 37.7090981776115 -122.43691809172 (37.7090981776115, -122.43691809172) 9 7 6 28861 5
177132 24270 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 300X Winding Way 8 Median : Cutout Tree DPW 1     6 8   6001396.0736 2086458.9864 37.709098177596 -122.436928924942 (37.709098177596, -122.436928924942) 9 7 6 28861 5
49472 24271 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 300X Winding Way 9 Median : Cutout Tree DPW 1     6 8   6001388.30533 2086462.26856 37.7091067481538 -122.436956008017 (37.7091067481538, -122.436956008017) 9 7 6 28861 5
56671 24272 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 300X Winding Way 10 Median : Cutout Tree DPW 1     6 8   6001382.61488 2086464.98759 37.7091138905754 -122.436975869563 (37.7091138905754, -122.436975869563) 9 7 6 28861 5
14974 71651 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 177 Wilson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     5994505.19973 2086471.6739 37.7087389470079 -122.460745569971 (37.7087389470079, -122.460745569971) 9 8 6 28861 25
126793 175750 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 348 Naylor St 2 Sidewalk: Curb side : Yard Tree Private 2     12 Width 6ft   6002816.75765 2086477.59625 37.7092299219895 -122.432020159019 (37.7092299219895, -122.432020159019) 9 7 6 28861 5
47180 175749 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 348 Naylor St 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 6ft   6002804.80085 2086492.54523 37.7092702907661 -122.432062550353 (37.7092702907661, -122.432062550353) 9 7 6 28861 5
71180 69438 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 45 Santa Cruz Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/1994 12:00:00 AM 6   Permit Number 33545 5993088.80201 2086544.97974 37.7088586314964 -122.465646111595 (37.7088586314964, -122.465646111595) 9 8 6 28861 25
52972 175734 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 327 Naylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6002802.82744 2086547.25146 37.7094203903216 -122.432073274757 (37.7094203903216, -122.432073274757) 9 7 6 28861 5
63105 175748 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 66 Baltimore Way 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6002940.94851 2086563.0179 37.7094715113586 -122.431597030685 (37.7094715113586, -122.431597030685) 9 7 6 28861 5
123670 175735 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 327 Naylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6002788.22143 2086564.98214 37.7094682468215 -122.43212502085 (37.7094682468215, -122.43212502085) 9 7 6 28861 5
48141 175747 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 58 Baltimore Way 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6002963.82508 2086583.0162 37.709527718998 -122.431519392204 (37.709527718998, -122.431519392204) 9 7 6 28861 5
185749 175736 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 315 Naylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002759.3959 2086598.756 37.7095593481574 -122.432227057027 (37.7095593481574, -122.432227057027) 9 7 6 28861 5
150867 175746 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 52 Baltimore Way 2 Sidewalk: Curb side : Yard Tree Private 2     12 Width 6ft   6002987.27121 2086606.39333 37.7095932364015 -122.431440026154 (37.7095932364015, -122.431440026154) 9 7 6 28861 5
103443 175737 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 315 Naylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002750.42911 2086613.85059 37.7096002862062 -122.432259125069 (37.7096002862062, -122.432259125069) 9 7 6 28861 5
23518 175745 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 52 Baltimore Way 1 Sidewalk: Curb side : Yard Tree Private 2     10 Width 6ft   6003007.00361 2086627.02122 37.7096509944604 -122.431373299139 (37.7096509944604, -122.431373299139) 9 7 6 28861 5
129670 175738 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 315 Naylor St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002741.21238 2086627.06017 37.7096360342462 -122.432291922446 (37.7096360342462, -122.432291922446) 9 7 6 28861 5
61856 175744 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 46 Baltimore Way 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 6ft   6003028.75595 2086646.47615 37.7097056462618 -122.431299507078 (37.7097056462618, -122.431299507078) 9 7 6 28861 5
81783 175612 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 423 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6012227.11334 2086656.26164 37.7102495175719 -122.399508825282 (37.7102495175719, -122.399508825282) 10 3 8 309 1
30696 175647 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 199 Shakespeare St 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   5993520.37631 2086668.28967 37.7092220951912 -122.464163488366 (37.7092220951912, -122.464163488366) 9 8 6 28861 25
127449 175613 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 423 Peninsula Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6012234.29342 2086673.78527 37.7102980342056 -122.399485238767 (37.7102980342056, -122.399485238767) 10 3 8 309 1
54997 31001 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 285 Chicago Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM 9   Permit Number 34778 6002746.71825 2086679.2341 37.709779604712 -122.432276616899 (37.709779604712, -122.432276616899) 9 7 6 28861 5
42058 31004 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 285 Chicago Way 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM     Permit Number 34778 6002766.74364375 2086692.10708835 37.7098160865806 -122.432208324272 (37.7098160865806, -122.432208324272) 9 7 6 28861 5
110112 31003 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 285 Chicago Way 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM     Permit Number 34778 6002766.74364375 2086692.10708835 37.7098160865806 -122.432208324272 (37.7098160865806, -122.432208324272) 9 7 6 28861 5
143805 31002 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 285 Chicago Way 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM     Permit Number 34778 6002766.74364375 2086692.10708835 37.7098160865806 -122.432208324272 (37.7098160865806, -122.432208324272) 9 7 6 28861 5
139415 59349 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 275 Chicago Way 1 Sidewalk: Curb side : Cutout Tree Private 2   11/11/1980 12:00:00 AM 10   Permit Number 18697 6002772.3177 2086703.69426 37.7098482184782 -122.432189886274 (37.7098482184782, -122.432189886274) 9 7 6 28861 5
188208 175743 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 262 Chicago Way 4 Sidewalk: Curb side : Yard Tree Private 2     6 Width 6ft   6002717.2522 2086712.60101 37.7098695521959 -122.432380838397 (37.7098695521959, -122.432380838397) 9 7 6 28861 5
114178 175742 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 262 Chicago Way 3 Sidewalk: Curb side : Yard Tree Private 2     7 Width 6ft   6002727.11736 2086720.58714 37.7098920397623 -122.432347312594 (37.7098920397623, -122.432347312594) 9 7 6 28861 5
40740 175739 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 275 Chicago Way 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 6ft   6002794.41849 2086722.13696 37.7099001111816 -122.432114818072 (37.7099001111816, -122.432114818072) 9 7 6 28861 5
111450 175741 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 262 Chicago Way 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 6ft   6002753.09913 2086743.14922 37.709955463542 -122.432259125067 (37.709955463542, -122.432259125067) 9 7 6 28861 5
99669 175740 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 262 Chicago Way 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 6ft   6002767.48185 2086755.45159 37.7099900586728 -122.432210293693 (37.7099900586728, -122.432210293693) 9 7 6 28861 5
130797 57934 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 591 Brunswick St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/1977 12:00:00 AM 6   Permit Number 16893 5998966.09872 2086766.06528 37.7098029340355 -122.445349316823 (37.7098029340355, -122.445349316823) 9 7 6 28861 5
110702 175588 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 591 Brunswick St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   5998981.8077 2086772.94827 37.7098227299032 -122.445295518467 (37.7098227299032, -122.445295518467) 9 7 6 28861 5
70072 175589 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 591 Brunswick St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   5999000.75807 2086779.04267 37.7098405454782 -122.44523046062 (37.7098405454782, -122.44523046062) 9 7 6 28861 5
98494 69410 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 1033 Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/1994 12:00:00 AM     Permit Number 33515 6001287.00169166 2086793.18756043 37.7100096203988 -122.437329807487 (37.7100096203988, -122.437329807487) 9 7 6 28861 5
66203 175641 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 275 De Long St 3 Sidewalk: Curb side : Yard Tree Private 2     3 Width 10ft   5993718.84188 2086795.50483 37.709582834847 -122.463486791709 (37.709582834847, -122.463486791709) 9 8 6 28861 25
20579 175642 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 275 De Long St 4 Sidewalk: Curb side : Yard Tree Private 2     3 Width 10ft   5993719.3869 2086798.38844 37.709590783961 -122.463485117168 (37.709590783961, -122.463485117168) 9 8 6 28861 25
64716 175643 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 275 De Long St 5 Sidewalk: Curb side : Yard Tree Private 2     11 Width 10ft   5993719.91168 2086800.30724 37.7095960827685 -122.463483442609 (37.7095960827685, -122.463483442609) 9 8 6 28861 25
82516 175644 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 275 De Long St 6 Sidewalk: Curb side : Yard Tree Private 2     10 Width 10ft   5993719.95216 2086802.23653 37.7096013824754 -122.463483442623 (37.7096013824754, -122.463483442623) 9 8 6 28861 25
71880 175646 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 275 De Long St 8 Sidewalk: Curb side : Yard Tree Private 2     8 Width 10ft   5993722.89868 2086804.10451 37.7096066812751 -122.463473394488 (37.7096066812751, -122.463473394488) 9 8 6 28861 25
183944 175645 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 275 De Long St 7 Sidewalk: Curb side : Yard Tree Private 2     8 Width 10ft   5993719.51846 2086804.65789 37.7096080059695 -122.463485117158 (37.7096080059695, -122.463485117158) 9 8 6 28861 25
33420 175639 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 28 De Long St 1 : Tree Private 2     9 Width 3ft   5995095.5192 2086815.41001 37.7097167133235 -122.458730228841 (37.7097167133235, -122.458730228841) 9 8 6 28861 25
135072 175640 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 28 De Long St 2 : Tree Private 2     7 Width 3ft   5995084.70237 2086816.61805 37.7097194085931 -122.458767700893 (37.7097194085931, -122.458767700893) 9 8 6 28861 25
151342 175610 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 333 Tocoloma Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6012573.19218 2086887.11282 37.7109026735915 -122.398328885071 (37.7109026735915, -122.398328885071) 10 3 8 309 1
186704 44402 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1162 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/2001 12:00:00 AM 7   Permit Number 43756 6001306.88514 2087104.50261 37.7108655531865 -122.437283363033 (37.7108655531865, -122.437283363033) 9 7 6 28861 5
74635 54765 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 179 Nueva Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/1972 12:00:00 AM 9   Permit Number 10614 6012917.58994 2087110.3835 37.7115349095784 -122.397154203219 (37.7115349095784, -122.397154203219) 10 3 8 309 1
60678 175733 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1183 Munich St 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   6001131.65449 2087116.65406 37.710888955334 -122.437889869445 (37.710888955334, -122.437889869445) 9 7 6 28861 5
149848 175630 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 75 South Hill Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 4ft   6002944.13194 2087144.13507 37.7110673133896 -122.431627488931 (37.7110673133896, -122.431627488931) 9 7 6 28861 5
174351 31018 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 21 Naylor St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/2001 12:00:00 AM 6   Permit Number 43762 6002296.8403 2087180.6482 37.7111308594726 -122.433867290956 (37.7111308594726, -122.433867290956) 9 7 6 28861 5
183165 175609 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 166 Nueva Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6012906.3252 2087198.97417 37.7117775349824 -122.397199345568 (37.7117775349824, -122.397199345568) 10 3 8 309 1
146033 1189 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3027 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1995 12:00:00 AM 10 3X3   5996602.20659 2087199.59889 37.7108580924116 -122.453550597907 (37.7108580924116, -122.453550597907) 9 7 6 28861 25
77886 175604 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 243 Curtis St 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 2ft   6000875.03048 2087235.17223 37.711199783509 -122.438785307322 (37.711199783509, -122.438785307322) 9 7 6 28861 5
194149 175605 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 243 Curtis St 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 2ft   6000870.76223 2087251.30173 37.7112438287074 -122.438801214504 (37.7112438287074, -122.438801214504) 9 7 6 28861 5
161366 46208 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 297 Wheeler Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/03/2002 12:00:00 AM 12   Permit Number 44524 6012148.34549 2087261.89541 37.711908076982 -122.399823563722 (37.711908076982, -122.399823563722) 10 3 8 309 1
109150 175606 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 243 Curtis St 3 Sidewalk: Curb side : Yard Tree Private 2     12 Width 2ft   6000866.49397 2087267.4309 37.7112878729966 -122.438817121715 (37.7112878729966, -122.438817121715) 9 7 6 28861 5
177783 175611 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 297 Wheeler Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6012151.441 2087271.29905 37.7119340700793 -122.399813524593 (37.7119340700793, -122.399813524593) 10 3 8 309 1
92246 175638 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 116 Schwerin St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008956.41307 2087314.52628 37.7118741275743 -122.410859536636 (37.7118741275743, -122.410859536636) 9 7 8 309 39
124525 175593 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 120 Farragut Ave 7 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   5997391.38544 2087332.13149 37.7112672047814 -122.450832575961 (37.7112672047814, -122.450832575961) 9 7 6 28861 25
85588 175603 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 89 Florentine Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   5999564.54554 2087573.57634 37.7120543220234 -122.443338944435 (37.7120543220234, -122.443338944435) 9 7 6 28861 5
88387 205857 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 135 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5995009.88085 2087611.25691 37.7118970000092 -122.459083796406 (37.7118970000092, -122.459083796406) 9 8 6 28861 24
132332 175592 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 130 Moneta Way 1 Sidewalk: Property side : Yard Tree Private 2     13 Width 2ft   5997447.90678 2087770.39122 37.7124738008959 -122.450668802241 (37.7124738008959, -122.450668802241) 9 7 6 28861 25
181812 114958 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 66 Concord St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/24/2015 12:00:00 AM 1   Permit Number 775977 5999698.38088 2087820.43772 37.7127397789845 -122.44289408849 (37.7127397789845, -122.44289408849) 9 7 6 28861 5
10219 78797 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 85 Morse St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6001030.80147 2087976.50512 37.7132441799408 -122.438300000759 (37.7132441799408, -122.438300000759) 9 7 6 28861 5
132980 175590 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1 Moneta Ct 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 4ft   5997972.2511 2088063.00237 37.7133072440178 -122.448877579363 (37.7133072440178, -122.448877579363) 9 7 6 28861 25
178752 175591 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2 Moneta Ct 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 6ft   5997970.37238 2088102.39912 37.713415311033 -122.44888690892 (37.713415311033, -122.44888690892) 9 7 6 28861 25
141636 26063 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 236 Broad St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 2X3   5994596.9562 2088110.4909 37.7132440322131 -122.460547122662 (37.7132440322131, -122.460547122662) 9 8 6 28861 24
95601 26061 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 236 Broad St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3X3   5994614.7294 2088111.1256 37.7132467974329 -122.460485738783 (37.7132467974329, -122.460485738783) 9 8 6 28861 24
176075 26062 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 236 Broad St 3 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   5994603.6211 2088111.443 37.7132470298872 -122.460524155594 (37.7132470298872, -122.460524155594) 9 8 6 28861 24
191981 26060 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 236 Broad St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3X3   5994622.6639 2088111.443 37.713248125396 -122.460458337607 (37.713248125396, -122.460458337607) 9 8 6 28861 24
38467 204378 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 150 Ramsell St 1 : Tree Private 2     4 Width 3ft   5992980.7825 2088221.20971 37.7134549279767 -122.466141167706 (37.7134549279767, -122.466141167706) 9 8 6 64 24
125163 204383 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 41 Ralston St 5 Back Yard : Yard Tree Private 2     6     5992172.93339 2088222.97511 37.7134131337717 -122.468933482617 (37.7134131337717, -122.468933482617) 9 8 6 64 24
67707 204382 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 41 Ralston St 2 Back Yard : Yard Tree Private 2     4     5992173.48186 2088232.60675 37.7134396116198 -122.46893228742 (37.7134396116198, -122.46893228742) 9 8 6 64 24
54919 204381 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 47 Ralston St 4 Back Yard : Yard Tree Private 2     5     5992175.93878 2088248.61457 37.7134837071825 -122.468924959729 (37.7134837071825, -122.468924959729) 9 8 6 64 24
136347 48569 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 150 Ramsell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/2002 12:00:00 AM     Permit Number 45988 5992993.59423207 2088277.32681995 37.7136097512741 -122.466100961633 (37.7136097512741, -122.466100961633) 9 8 6 64 24
161535 31005 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 45 Curtis St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM 5   Permit Number 34779 6000594.89127 2088305.62905 37.7141230774792 -122.439830234972 (37.7141230774792, -122.439830234972) 9 7 6 28861 5
41536 204380 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 64 Ralston St 1 : Tree Private 2     7 Width 3ft   5992207.49196 2088316.25633 37.713671258107 -122.468820820922 (37.713671258107, -122.468820820922) 9 8 6 64 24
156580 175607 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2 Hester Ave 2 Sidewalk: Property side : Yard Tree Private 2     11 Width 4ft   6012544.08177 2088322.31575 37.7148418345529 -122.398530142577 (37.7148418345529, -122.398530142577) 10 3 8 309 1
145576 204384 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 82 Vernon St 1 Sidewalk: Property side : Yard Tree Private 2     15 Width 3ft   5992474.1987 2088421.8955 37.7139767227086 -122.46790667266 (37.7139767227086, -122.46790667266) 9 8 6 64 24
107553 204385 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 82 Vernon St 2 Sidewalk: Property side : Yard Tree Private 2     12 Width 3ft   5992474.44485 2088433.59957 37.7140088734796 -122.467906672658 (37.7140088734796, -122.467906672658) 9 8 6 64 24
62503 175635 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 29 Tucker Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6010977.99062 2088484.11586 37.7151987323072 -122.403954615717 (37.7151987323072, -122.403954615717) 9 7 8 309 39
13520 175634 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 29 Tucker Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6010973.25986 2088486.32565 37.7152045356343 -122.403971122781 (37.7152045356343, -122.403971122781) 9 7 8 309 39
163524 65697 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 20 Pope St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/17/1990 12:00:00 AM 12   Permit Number 28626 6000103.70653 2088525.92209 37.7146999808888 -122.441543751965 (37.7146999808888, -122.441543751965) 9 7 6 28861 5
163954 175585 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1711 Cayuga Ave 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 8ft   5998173.65271 2088704.87448 37.7150811936116 -122.448227659988 (37.7150811936116, -122.448227659988) 9 7 6 28861 25
50278 205858 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 4 Lobos St 2 Sidewalk: Curb side : Pot Tree Private 2     2 Width 2ft   5996833.75095 2088711.69181 37.7150232206213 -122.452859401447 (37.7150232206213, -122.452859401447) 9 8 6 28861 24
120987 1126 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 2500X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   5998746.09202 2088752.48006 37.7152446168065 -122.446252494655 (37.7152446168065, -122.446252494655) 9 7 6 28861 25
97151 175594 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2522 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   5998750.81028 2088752.88723 37.7152460042658 -122.446236215627 (37.7152460042658, -122.446236215627) 9 7 6 28861 25
47212 175596 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 861 Lisbon St 5 Sidewalk: Curb side : Yard Tree Private 2     11 Width 6ft   6001043.54225 2088836.75005 37.715606945381 -122.438317555522 (37.715606945381, -122.438317555522) 9 7 6 28861 5
136306 93570 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 920 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2     11     6001322.49897 2088870.02328 37.7157141688559 -122.437355737785 (37.7157141688559, -122.437355737785) 9 7 6 28861 5
142050 93571 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 920 Madrid St 2 Sidewalk: Curb side : Cutout Tree Private 2           6001349 2088904 37.7158089679017 -122.437266569668 (37.7158089679017, -122.437266569668) 9 7 6 28861 5
75882 97766 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 400X Amazon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6001498.93462 2088909.86278 37.7158335880342 -122.436748746672 (37.7158335880342, -122.436748746672) 9 7 6 28861 5
65817 204360 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 160 Ralston St 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 10ft   5992214.92072 2088927.28507 37.7153494245261 -122.46883958168 (37.7153494245261, -122.46883958168) 9 8 6 64 24
132703 97764 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 400X Amazon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6001442.97937 2088937.55839 37.715906453794 -122.436944135186 (37.715906453794, -122.436944135186) 9 7 6 28861 5
180398 175636 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1277 Brussels St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6011793.26419 2088994.55488 37.7166458107269 -122.401172506308 (37.7166458107269, -122.401172506308) 10 7 8 309 39
142504 113756 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 300x Amazon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6001223.92516 2089044.4895 37.7161876097347 -122.437708941119 (37.7161876097347, -122.437708941119) 9 7 6 28861 5
160717 113755 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 300x Amazon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6001200.73843 2089055.692 37.7162170508648 -122.437789887305 (37.7162170508648, -122.437789887305) 9 7 6 28861 5
146714 175586 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 158 Rome St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 1ft   5998844.18074 2089066.48098 37.7161123931481 -122.445936029128 (37.7161123931481, -122.445936029128) 9 7 6 28861 25
101547 55325 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1231 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1972 12:00:00 AM 11   Permit Number 11255 6011451.82111 2089071.07644 37.7168368689981 -122.402358088854 (37.7168368689981, -122.402358088854) 10 7 8 309 39
99185 121487 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 377 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6010852.01501 2089133.21638 37.7169739913337 -122.404435707158 (37.7169739913337, -122.404435707158) 9 7 8 309 39
59291 204365 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 294 Ramsell St 1 : Tree Private 2     6 Width 3ft   5992993.26737 2089135.18818 37.715965213689 -122.46616439447 (37.715965213689, -122.46616439447) 9 8 6 64 24

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