Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 76508 | 76508 | 125805 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 349 Marina Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6001675.8593 | 2121806.39816 | 37.8061695046764 | -122.43849281089399 | (37.8061695046764, -122.438492810894) | ||||
| 31708 | 31708 | 64202 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 712 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1987 12:00:00 AM | 7 | Permit Number 24989 | 6007253.84118 | 2121612.31265 | 37.805952304912296 | -122.41917544799401 | (37.8059523049123, -122.419175447994) | ||
| 8730 | 8730 | 97454 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 758 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2011 12:00:00 AM | 3 | 3x3 | 6007159.12761 | 2121599.09194 | 37.805910669901294 | -122.41950228141899 | (37.8059106699013, -122.419502281419) | |
| 183606 | 183606 | 125853 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 743 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6007172.66204 | 2121545.51126 | 37.8057643133355 | -122.419451639674 | (37.8057643133355, -122.419451639674) | |||
| 28126 | 28126 | 125863 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 150 Francisco St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010483.33133 | 2121337.12789 | 37.8053780572129 | -122.407979816633 | (37.8053780572129, -122.407979816633) | ||||
| 56660 | 56660 | 142659 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 83 VANDEWATER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6009018.8867 | 2121294.5746 | 37.805179117528205 | -122.41304472676 | (37.8051791175282, -122.41304472676) | |||
| 172208 | 172208 | 142661 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 83 VANDEWATER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6009007.035 | 2121293.544 | 37.805175622447294 | -122.41308566824 | (37.8051756224473, -122.41308566824) | |||
| 63237 | 63237 | 41232 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3721 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51879 | 6002533.18198 | 2121382.3124 | 37.8050538066511 | -122.4354955486 | (37.8050538066511, -122.4354955486) | |
| 185702 | 185702 | 125792 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3801 Divisadero St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6000092.0831699995 | 2121324.76719 | 37.804756859503605 | -122.443939089914 | (37.8047568595036, -122.443939089914) | |||
| 147214 | 147214 | 125801 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3711 Fillmore St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6002004.76332 | 2121253.22913 | 37.804669352783 | -122.437314950825 | (37.804669352783, -122.437314950825) | |||
| 61886 | 61886 | 125802 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3711 Fillmore St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6002006.97076 | 2121237.2158 | 37.8046255099126 | -122.43730616445299 | (37.8046255099126, -122.437306164453) | |||
| 159810 | 159810 | 125803 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3711 Fillmore St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6002008.1217 | 2121228.27649 | 37.8046010303654 | -122.43730154103999 | (37.8046010303654, -122.43730154104) | |||
| 51174 | 51174 | 125804 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3711 Fillmore St | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6002009.77145 | 2121217.59748 | 37.804571802419 | -122.43729506680799 | (37.804571802419, -122.437295066808) | |||
| 32829 | 32829 | 142560 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2530 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6007965.9858 | 2121094.0101 | 37.8045692563949 | -122.41667421166599 | (37.8045692563949, -122.416674211666) | |||
| 23011 | 23011 | 7688 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 545 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 0 | 6008696.1209 | 2121067.5649 | 37.8045376819256 | -122.414145630391 | (37.8045376819256, -122.414145630391) | |||
| 65166 | 65166 | 142559 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2520 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6007970.2417 | 2121076.9865 | 37.804522753250296 | -122.416658276978 | (37.8045227532503, -122.416658276978) | |||
| 149820 | 149820 | 125796 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3701 Fillmore St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6002014.56051 | 2121190.75221 | 37.804498364667204 | -122.437276570469 | (37.8044983646672, -122.437276570469) | |||
| 53443 | 53443 | 42672 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 4 | Permit Number 42700 | 6008565.6692 | 2121051.5528 | 37.80448638863479 | -122.414595938174 | (37.8044863886348, -122.414595938174) | |
| 48619 | 48619 | 125797 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3701 Fillmore St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6002015.524540001 | 2121185.6757799997 | 37.804484480937795 | -122.437272870653 | (37.8044844809378, -122.437272870653) | |||
| 3373 | 3373 | 7694 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6008552.9537 | 2121047.3143 | 37.8044740363975 | -122.414639641316 | (37.8044740363975, -122.414639641316) | |||
| 99480 | 99480 | 7689 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 545 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008705.23662 | 2121043.7267299998 | 37.804472740304206 | -122.414112396989 | (37.8044727403042, -122.414112396989) | |||
| 163259 | 163259 | 125798 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3701 Fillmore St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6002015.8097 | 2121180.08116 | 37.8044691358044 | -122.43727148299801 | (37.8044691358044, -122.437271482998) | |||
| 932 | 932 | 7693 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6008532.7031 | 2121045.4305 | 37.804467726204 | -122.41470958714899 | (37.804467726204, -122.414709587149) | |||
| 52155 | 52155 | 142558 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2510 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6007972.8607 | 2121055.3796 | 37.8044635734573 | -122.416647682082 | (37.8044635734573, -122.416647682082) | |||
| 74203 | 74203 | 125799 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3701 Fillmore St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6002016.65647 | 2121175.8056799998 | 37.8044574446054 | -122.43726824635701 | (37.8044574446054, -122.437268246357) | |||
| 88168 | 88168 | 42673 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42700 | 6008532.69397696 | 2121039.56256614 | 37.804451613820206 | -122.41470920319901 | (37.8044516138202, -122.414709203199) | ||
| 101955 | 101955 | 42674 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42700 | 6008532.69397696 | 2121039.56256614 | 37.804451613820206 | -122.41470920319901 | (37.8044516138202, -122.414709203199) | ||
| 162136 | 162136 | 125800 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3701 Fillmore St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6002016.97166 | 2121171.67387 | 37.8044461176676 | -122.437266859587 | (37.8044461176676, -122.437266859587) | |||
| 36565 | 36565 | 62056 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1700 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/1985 12:00:00 AM | 8 | Permit Number 22136 | 6002013.39133 | 2121163.89045 | 37.8044245429292 | -122.437278691955 | (37.8044245429292, -122.437278691955) | ||
| 41997 | 41997 | 125764 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1700 Beach St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6002001.26828 | 2121162.98263 | 37.8044213611317 | -122.43732057970301 | (37.8044213611317, -122.437320579703) | |||
| 70984 | 70984 | 125765 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1700 Beach St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6001986.0819 | 2121160.2837400003 | 37.804413087367394 | -122.437372940016 | (37.8044130873674, -122.437372940016) | |||
| 185570 | 185570 | 142557 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2500 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6007977.1166 | 2121032.7906 | 37.8044017891252 | -122.41663135293899 | (37.8044017891252, -122.416631352939) | |||
| 73491 | 73491 | 125766 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1700 Beach St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6001936.3449099995 | 2121152.73709 | 37.8043895386146 | -122.437544518078 | (37.8043895386146, -122.437544518078) | |||
| 58624 | 58624 | 142553 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 660 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6008051.1039 | 2121026.5704 | 37.8043888708704 | -122.41637487197201 | (37.8043888708704, -122.416374871972) | |||
| 28081 | 28081 | 125767 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1700 Beach St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6001920.94521 | 2121150.96957 | 37.8043838099173 | -122.437597683295 | (37.8043838099173, -122.437597683295) | |||
| 27466 | 27466 | 142554 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 670 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6008032.7708 | 2121023.624 | 37.8043797498479 | -122.416438106574 | (37.8043797498479, -122.416438106574) | |||
| 91531 | 91531 | 100671 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 680X Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6008043.6 | 2121019.4 | 37.804368760788 | -122.41640033173 | (37.804368760788, -122.41640033173) | |||
| 110303 | 110303 | 100672 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 680X Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6008043.6 | 2121019.4 | 37.804368760788 | -122.41640033173 | (37.804368760788, -122.41640033173) | |||
| 124156 | 124156 | 100673 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 680X Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008043.6 | 2121019.4 | 37.804368760788 | -122.41640033173 | (37.804368760788, -122.41640033173) | |||
| 124392 | 124392 | 100670 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 680X Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6008043.6 | 2121019.4 | 37.804368760788 | -122.41640033173 | (37.804368760788, -122.41640033173) | |||
| 131033 | 131033 | 142555 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 680 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6008015.0924 | 2121019.6955 | 37.804367969011395 | -122.41649900590001 | (37.8043679690114, -122.4164990059) | |||
| 157072 | 157072 | 142556 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 690 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6007998.3962 | 2121018.0586 | 37.8043625355363 | -122.416556668642 | (37.8043625355363, -122.416556668642) | |||
| 126536 | 126536 | 27624 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 583 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6008543.932159999 | 2121005.06507 | 37.8043575237734 | -122.414667869562 | (37.8043575237734, -122.414667869562) | |||
| 61310 | 61310 | 125794 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 101 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001288.01162 | 2121135.2831 | 37.8043047325274 | -122.439786873275 | (37.8043047325274, -122.439786873275) | |||
| 40527 | 40527 | 125855 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2843 Larkin St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6006460.99405 | 2121028.21686 | 37.8043038458052 | -122.421877708416 | (37.8043038458052, -122.421877708416) | |||
| 65423 | 65423 | 125856 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2843 Larkin St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6006461.58499 | 2121022.9900700003 | 37.804289527702 | -122.421875291912 | (37.804289527702, -122.421875291912) | |||
| 162193 | 162193 | 125795 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 101 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001298.49165 | 2121127.66063 | 37.8042843997778 | -122.439750059544 | (37.8042843997778, -122.439750059544) | |||
| 31645 | 31645 | 125861 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2456 Leavenworth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6007523.933230001 | 2120832.54539 | 37.8038264685723 | -122.418185431117 | (37.8038264685723, -122.418185431117) | |||
| 48074 | 48074 | 69362 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3521 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 7 | Permit Number 33456 | 6002627.22111 | 2120704.3070900002 | 37.8031975232214 | -122.435121592481 | (37.8031975232214, -122.435121592481) | |
| 176472 | 176472 | 125791 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3535 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999695.76662 | 2120720.83293 | 37.803076004103296 | -122.44526713048401 | (37.8030760041033, -122.445267130484) | |||
| 24774 | 24774 | 143056 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 30 EDITH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6010306.5322 | 2120406.926 | 37.8028140529926 | -122.40852599821699 | (37.8028140529926, -122.408525998217) | |||
| 133038 | 133038 | 125868 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1306x Montgomery St | 50 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 8ft | 6011397.07627 | 2120306.83138 | 37.80260023127779 | -122.404745086537 | (37.8026002312778, -122.404745086537) | |||
| 172171 | 172171 | 143083 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 439 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6010755.7275 | 2120312.9864 | 37.8025812640991 | -122.40696492000099 | (37.8025812640991, -122.406964920001) | |||
| 131510 | 131510 | 125867 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1306x Montgomery St | 49 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6011400.22925 | 2120293.8654 | 37.802564806093294 | -122.40473326224199 | (37.8025648060933, -122.404733262242) | |||
| 73337 | 73337 | 125866 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1306x Montgomery St | 48 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 8ft | 6011400.87154 | 2120290.44992 | 37.802555463919 | -122.40473079899401 | (37.802555463919, -122.404730798994) | |||
| 47847 | 47847 | 125865 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1306x Montgomery St | 47 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6011401.82838 | 2120281.49833 | 37.8025309385205 | -122.404726857271 | (37.8025309385205, -122.404726857271) | |||
| 131755 | 131755 | 125864 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1306x Montgomery St | 46 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 8ft | 6011404.31889 | 2120270.9561400004 | 37.8025021314422 | -122.404717496217 | (37.8025021314422, -122.404717496217) | |||
| 74065 | 74065 | 125854 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2760 Polk St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6006137.21976 | 2120328.92662 | 37.8023655091144 | -122.422948425938 | (37.8023655091144, -122.422948425938) | |||
| 111783 | 111783 | 16376 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1400X Montgomery St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | |||
| 125952 | 125952 | 16375 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1400X Montgomery St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | |||
| 166321 | 166321 | 250223 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6011234.32087 | 2120070.9566599997 | 37.80194347887979 | -122.405291684587 | (37.8019434788798, -122.405291684587) | |||
| 165572 | 165572 | 250224 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6011221.34302 | 2120070.92711 | 37.8019426721638 | -122.405336592216 | (37.8019426721638, -122.405336592216) | |||
| 69791 | 69791 | 250225 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 0ft | 6011230.02021 | 2120062.52676 | 37.8019200919915 | -122.40530597298701 | (37.8019200919915, -122.405305972987) | |||
| 172111 | 172111 | 250226 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 0ft | 6011217.042090001 | 2120062.49723 | 37.8019192853099 | -122.405350881537 | (37.8019192853099, -122.405350881537) | |||
| 67816 | 67816 | 250228 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 0ft | 6011211.1715400005 | 2120049.4002099996 | 37.8018829958704 | -122.40537027363101 | (37.8018829958704, -122.405370273631) | |||
| 166394 | 166394 | 250229 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011206.629819999 | 2120043.6184099996 | 37.8018668665295 | -122.405385582777 | (37.8018668665295, -122.405385582777) | |||
| 158455 | 158455 | 125793 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2336 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5999595.05662 | 2120187.92972 | 37.8016070460784 | -122.445577294972 | (37.8016070460784, -122.445577294972) | |||
| 173590 | 173590 | 250208 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 212 Union St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6011783.4083 | 2119794.63457 | 37.8012154488822 | -122.403372122131 | (37.8012154488822, -122.403372122131) | |||
| 157703 | 157703 | 250210 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 212 Union St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6011753.31095 | 2119788.98637 | 37.8011982592529 | -122.40347587511101 | (37.8011982592529, -122.403475875111) | |||
| 41959 | 41959 | 250203 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 203 Union St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 0ft | 6011748.4940599995 | 2119742.37279 | 37.8010700006395 | -122.403489262419 | (37.8010700006395, -122.403489262419) | |||
| 104523 | 104523 | 97908 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2000 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1994 12:00:00 AM | Permit Number 33440 | 6002143.0 | 2119896.0 | 37.8009506172383 | -122.43673935569201 | (37.8009506172383, -122.436739355692) | |||
| 113365 | 113365 | 97909 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2000 Chestnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1994 12:00:00 AM | Permit Number 33440 | 6002143.0 | 2119896.0 | 37.8009506172383 | -122.43673935569201 | (37.8009506172383, -122.436739355692) | |||
| 109466 | 109466 | 69349 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2000 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | Permit Number 33440 | 6002263.91991676 | 2119868.04210329 | 37.80088072345829 | -122.43631892004801 | (37.8008807234583, -122.436318920048) | ||
| 52029 | 52029 | 125770 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2000 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002186.47699 | 2119858.60967 | 37.80085042396421 | -122.436586229264 | (37.8008504239642, -122.436586229264) | |||
| 183689 | 183689 | 97907 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2000 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1994 12:00:00 AM | 8 | Permit Number 33440 | 6002166.03814 | 2119855.12291 | 37.8008396887472 | -122.43665670643601 | (37.8008396887472, -122.436656706436) | ||
| 51987 | 51987 | 30475 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 424 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/1956 12:00:00 AM | 8 | Permit Number 123 | 6010870.8148 | 2119673.484 | 37.8008317865696 | -122.406521568491 | (37.8008317865696, -122.406521568491) | ||
| 41453 | 41453 | 125769 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2010 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002145.10351 | 2119851.40209 | 37.8008282826453 | -122.436728882426 | (37.8008282826453, -122.436728882426) | |||
| 149531 | 149531 | 125768 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2016 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002127.62309 | 2119848.5874799998 | 37.8008195610256 | -122.43678917031 | (37.8008195610256, -122.43678917031) | |||
| 33757 | 33757 | 125860 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2130 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007669.371830001 | 2119725.10958 | 37.8007939141569 | -122.417603593144 | (37.8007939141569, -122.417603593144) | |||
| 32737 | 32737 | 69323 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2130 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/1994 12:00:00 AM | 8 | Permit Number 33406 | 6007673.53376 | 2119706.35756 | 37.8007426600105 | -122.417587861288 | (37.8007426600105, -122.417587861288) | ||
| 32882 | 32882 | 45667 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3201 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2001 12:00:00 AM | 5 | Permit Number 44363 | 5999332.42339 | 2119845.91977 | 37.8006529814106 | -122.44646150300801 | (37.8006529814106, -122.446461503008) | ||
| 180057 | 180057 | 143119 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1727 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004073.3886 | 2119693.6255 | 37.80050446604229 | -122.430044947424 | (37.8005044660423, -122.430044947424) | |||
| 7769 | 7769 | 13131 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1727 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6003964.7125 | 2119675.6431 | 37.8004489355963 | -122.43041972679701 | (37.8004489355963, -122.430419726797) | |||
| 142229 | 142229 | 13130 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1727 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6004021.471059999 | 2119661.74787 | 37.8004139978499 | -122.430222327563 | (37.8004139978499, -122.430222327563) | |||
| 8444 | 8444 | 13167 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1906 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 26 | 3X3 | 6003216.0169 | 2119655.6641 | 37.8003516396791 | -122.433009083838 | (37.8003516396791, -122.433009083838) | ||
| 47326 | 47326 | 125857 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1148 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007410.78308 | 2119548.4108 | 37.8002941896961 | -122.418485883829 | (37.8002941896961, -122.418485883829) | |||
| 187670 | 187670 | 42671 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1115 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49824 | 6007552.9274699995 | 2119520.43861 | 37.8002253861525 | -122.417992022918 | (37.8002253861525, -122.417992022918) | |
| 157830 | 157830 | 125763 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1595 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005365.83059 | 2119555.3975299997 | 37.800198039578206 | -122.42556272904699 | (37.8001980395782, -122.425562729047) | |||
| 133054 | 133054 | 55308 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1595 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1972 12:00:00 AM | 10 | Permit Number 11237 | 6005282.805369999 | 2119544.50402 | 37.800163437253296 | -122.42584925305201 | (37.8001634372533, -122.425849253052) | ||
| 93652 | 93652 | 23956 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2004X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002791.01315 | 2119592.0011400003 | 37.8001527217578 | -122.43447520944099 | (37.8001527217578, -122.434475209441) | |||
| 42132 | 42132 | 55307 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2770 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2012 12:00:00 AM | 2 | Permit Number 769514 | 6005272.5834 | 2119510.27332 | 37.8000688708465 | -122.42588218711 | (37.8000688708465, -122.42588218711) | ||
| 90175 | 90175 | 108595 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1599x GREENWICH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005333.0 | 2119502.0 | 37.8000495685335 | -122.42567253315 | (37.8000495685335, -122.42567253315) | ||||
| 28106 | 28106 | 32369 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 858 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | 6 | Permit Number 36919 | 6008860.83914 | 2119402.12264 | 37.799974043636205 | -122.413457749072 | (37.7999740436362, -122.413457749072) | ||
| 4343 | 4343 | 13198 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2125 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002212.7759 | 2119440.8173 | 37.799704770189 | -122.436465304667 | (37.799704770189, -122.436465304667) | |||
| 173484 | 173484 | 125785 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3100 Lyon St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5999066.01183 | 2119467.37321 | 37.7995983743294 | -122.44735613150101 | (37.7995983743294, -122.447356131501) | |||
| 131963 | 131963 | 125784 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3100 Lyon St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5999066.91137 | 2119461.38091 | 37.7995819724856 | -122.44735258724701 | (37.7995819724856, -122.447352587247) | |||
| 31023 | 31023 | 125783 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3100 Lyon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5999067.20465 | 2119454.38129 | 37.79956277016829 | -122.44735106832199 | (37.7995627701683, -122.447351068322) | |||
| 45679 | 45679 | 125782 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3100 Lyon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5999068.0918 | 2119447.8062400003 | 37.7995447675413 | -122.44734752497699 | (37.7995447675413, -122.447347524977) | |||
| 67989 | 67989 | 143152 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2308 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6001295.2498 | 2119386.2355 | 37.799502723648 | -122.43963635915199 | (37.799502723648, -122.439636359152) | |||
| 107781 | 107781 | 13236 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2308 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6001297.71761 | 2119386.00749 | 37.7995022380504 | -122.43962780331199 | (37.7995022380504, -122.439627803312) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");