trees
3,267 rows where qSpecies_id = 67 sorted by YCoord
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );