trees
3,267 rows where qSpecies_id = 67 sorted by YCoord descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38256 | 125805 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 349 Marina Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6001675.8593 | 2121806.39816 | 37.8061695046764 | -122.438492810894 | (37.8061695046764, -122.438492810894) | 13 | 9 | 1 | 57 | 17 | ||||
140447 | 64202 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 712 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1987 12:00:00 AM | 7 | Permit Number 24989 | 6007253.84118 | 2121612.31265 | 37.8059523049123 | -122.419175447994 | (37.8059523049123, -122.419175447994) | 5 | 1 | 1 | 28858 | 32 | ||
50289 | 97454 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 758 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2011 12:00:00 AM | 3 | 3x3 | 6007159.12761 | 2121599.09194 | 37.8059106699013 | -122.419502281419 | (37.8059106699013, -122.419502281419) | 5 | 1 | 1 | 28858 | 32 | |
147993 | 125853 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 743 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6007172.66204 | 2121545.51126 | 37.8057643133355 | -122.419451639674 | (37.8057643133355, -122.419451639674) | 5 | 1 | 1 | 28858 | 32 | |||
133779 | 41232 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3721 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51879 | 6002533.18198 | 2121382.3124 | 37.8050538066511 | -122.4354955486 | (37.8050538066511, -122.4354955486) | 13 | 9 | 1 | 57 | 17 | |
120711 | 125863 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 Francisco St | 11 | Front Yard : Yard | Tree | Private 2 | 4 | 6010483.33133 | 2121337.12789 | 37.8053780572129 | -122.407979816633 | (37.8053780572129, -122.407979816633) | 3 | 1 | 10 | 308 | 23 | ||||
189877 | 125792 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3801 Divisadero St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6000092.08317 | 2121324.76719 | 37.8047568595036 | -122.443939089914 | (37.8047568595036, -122.443939089914) | 13 | 9 | 1 | 57 | 17 | |||
102922 | 142659 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 83 VANDEWATER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6009018.8867 | 2121294.5746 | 37.8051791175282 | -122.41304472676 | (37.8051791175282, -122.41304472676) | 3 | 1 | 10 | 308 | 23 | |||
172754 | 142661 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 83 VANDEWATER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6009007.035 | 2121293.544 | 37.8051756224473 | -122.41308566824 | (37.8051756224473, -122.41308566824) | 3 | 1 | 10 | 308 | 23 | |||
189453 | 125801 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3711 Fillmore St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6002004.76332 | 2121253.22913 | 37.804669352783 | -122.437314950825 | (37.804669352783, -122.437314950825) | 13 | 9 | 1 | 57 | 17 | |||
157746 | 125802 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3711 Fillmore St | 4 | : | Tree | Private 2 | 4 | Width 3ft | 6002006.97076 | 2121237.2158 | 37.8046255099126 | -122.437306164453 | (37.8046255099126, -122.437306164453) | 13 | 9 | 1 | 57 | 17 | |||
71825 | 125803 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3711 Fillmore St | 5 | : | Tree | Private 2 | 4 | Width 3ft | 6002008.1217 | 2121228.27649 | 37.8046010303654 | -122.43730154104 | (37.8046010303654, -122.43730154104) | 13 | 9 | 1 | 57 | 17 | |||
68671 | 125804 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3711 Fillmore St | 6 | : | Tree | Private 2 | 5 | Width 3ft | 6002009.77145 | 2121217.59748 | 37.804571802419 | -122.437295066808 | (37.804571802419, -122.437295066808) | 13 | 9 | 1 | 57 | 17 | |||
131163 | 125796 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3701 Fillmore St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002014.56051 | 2121190.75221 | 37.8044983646672 | -122.437276570469 | (37.8044983646672, -122.437276570469) | 13 | 9 | 1 | 57 | 17 | |||
79479 | 125797 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3701 Fillmore St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002015.52454 | 2121185.67578 | 37.8044844809378 | -122.437272870653 | (37.8044844809378, -122.437272870653) | 13 | 9 | 1 | 57 | 17 | |||
33845 | 125798 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3701 Fillmore St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6002015.8097 | 2121180.08116 | 37.8044691358044 | -122.437271482998 | (37.8044691358044, -122.437271482998) | 13 | 9 | 1 | 57 | 17 | |||
34165 | 125799 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3701 Fillmore St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6002016.65647 | 2121175.80568 | 37.8044574446054 | -122.437268246357 | (37.8044574446054, -122.437268246357) | 13 | 9 | 1 | 57 | 17 | |||
29574 | 125800 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3701 Fillmore St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6002016.97166 | 2121171.67387 | 37.8044461176676 | -122.437266859587 | (37.8044461176676, -122.437266859587) | 13 | 9 | 1 | 57 | 17 | |||
25945 | 62056 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/1985 12:00:00 AM | 8 | Permit Number 22136 | 6002013.39133 | 2121163.89045 | 37.8044245429292 | -122.437278691955 | (37.8044245429292, -122.437278691955) | 13 | 9 | 1 | 57 | 17 | ||
176719 | 125764 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Beach St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6002001.26828 | 2121162.98263 | 37.8044213611317 | -122.437320579703 | (37.8044213611317, -122.437320579703) | 13 | 9 | 1 | 57 | 17 | |||
186447 | 125765 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Beach St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6001986.0819 | 2121160.28374 | 37.8044130873674 | -122.437372940016 | (37.8044130873674, -122.437372940016) | 13 | 9 | 1 | 57 | 17 | |||
114672 | 125766 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Beach St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6001936.34491 | 2121152.73709 | 37.8043895386146 | -122.437544518078 | (37.8043895386146, -122.437544518078) | 13 | 9 | 1 | 57 | 17 | |||
190475 | 125767 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Beach St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6001920.94521 | 2121150.96957 | 37.8043838099173 | -122.437597683295 | (37.8043838099173, -122.437597683295) | 13 | 9 | 1 | 57 | 17 | |||
184537 | 125794 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001288.01162 | 2121135.2831 | 37.8043047325274 | -122.439786873275 | (37.8043047325274, -122.439786873275) | 13 | 9 | 1 | 57 | 17 | |||
175589 | 125795 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001298.49165 | 2121127.66063 | 37.8042843997778 | -122.439750059544 | (37.8042843997778, -122.439750059544) | 13 | 9 | 1 | 57 | 17 | |||
55568 | 142560 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2530 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6007965.9858 | 2121094.0101 | 37.8045692563949 | -122.416674211666 | (37.8045692563949, -122.416674211666) | 5 | 1 | 10 | 308 | 32 | |||
31686 | 142559 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2520 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6007970.2417 | 2121076.9865 | 37.8045227532503 | -122.416658276978 | (37.8045227532503, -122.416658276978) | 5 | 1 | 10 | 308 | 32 | |||
87622 | 7688 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 545 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 0 | 6008696.1209 | 2121067.5649 | 37.8045376819256 | -122.414145630391 | (37.8045376819256, -122.414145630391) | 3 | 1 | 10 | 308 | 23 | |||
62693 | 142558 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2510 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6007972.8607 | 2121055.3796 | 37.8044635734573 | -122.416647682082 | (37.8044635734573, -122.416647682082) | 5 | 1 | 10 | 308 | 32 | |||
23528 | 42672 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 581 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 4 | Permit Number 42700 | 6008565.6692 | 2121051.5528 | 37.8044863886348 | -122.414595938174 | (37.8044863886348, -122.414595938174) | 3 | 1 | 10 | 308 | 23 | |
37878 | 7694 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 581 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6008552.9537 | 2121047.3143 | 37.8044740363975 | -122.414639641316 | (37.8044740363975, -122.414639641316) | 3 | 1 | 10 | 308 | 23 | |||
194032 | 7693 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 581 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6008532.7031 | 2121045.4305 | 37.804467726204 | -122.414709587149 | (37.804467726204, -122.414709587149) | 3 | 1 | 10 | 308 | 23 | |||
106867 | 7689 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 545 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008705.23662 | 2121043.72673 | 37.8044727403042 | -122.414112396989 | (37.8044727403042, -122.414112396989) | 3 | 1 | 10 | 308 | 23 | |||
69722 | 42673 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 581 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42700 | 6008532.69397696 | 2121039.56256614 | 37.8044516138202 | -122.414709203199 | (37.8044516138202, -122.414709203199) | 3 | 1 | 10 | 308 | 23 | ||
108556 | 42674 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 581 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42700 | 6008532.69397696 | 2121039.56256614 | 37.8044516138202 | -122.414709203199 | (37.8044516138202, -122.414709203199) | 3 | 1 | 10 | 308 | 23 | ||
133972 | 142557 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2500 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6007977.1166 | 2121032.7906 | 37.8044017891252 | -122.416631352939 | (37.8044017891252, -122.416631352939) | 5 | 1 | 10 | 308 | 32 | |||
101575 | 125855 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2843 Larkin St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6006460.99405 | 2121028.21686 | 37.8043038458052 | -122.421877708416 | (37.8043038458052, -122.421877708416) | 5 | 9 | 1 | 28858 | 32 | |||
76357 | 142553 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 660 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6008051.1039 | 2121026.5704 | 37.8043888708704 | -122.416374871972 | (37.8043888708704, -122.416374871972) | 5 | 1 | 10 | 308 | 32 | |||
17521 | 142554 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 670 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6008032.7708 | 2121023.624 | 37.8043797498479 | -122.416438106574 | (37.8043797498479, -122.416438106574) | 5 | 1 | 10 | 308 | 32 | |||
85498 | 125856 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2843 Larkin St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6006461.58499 | 2121022.99007 | 37.804289527702 | -122.421875291912 | (37.804289527702, -122.421875291912) | 5 | 9 | 1 | 28858 | 32 | |||
22395 | 142555 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 680 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6008015.0924 | 2121019.6955 | 37.8043679690114 | -122.4164990059 | (37.8043679690114, -122.4164990059) | 5 | 1 | 10 | 308 | 32 | |||
10172 | 100673 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 680X Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008043.6 | 2121019.4 | 37.804368760788 | -122.41640033173 | (37.804368760788, -122.41640033173) | 5 | 1 | 10 | 308 | 32 | |||
23377 | 100670 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 680X Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6008043.6 | 2121019.4 | 37.804368760788 | -122.41640033173 | (37.804368760788, -122.41640033173) | 5 | 1 | 10 | 308 | 32 | |||
80554 | 100671 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 680X Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6008043.6 | 2121019.4 | 37.804368760788 | -122.41640033173 | (37.804368760788, -122.41640033173) | 5 | 1 | 10 | 308 | 32 | |||
138476 | 100672 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 680X Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6008043.6 | 2121019.4 | 37.804368760788 | -122.41640033173 | (37.804368760788, -122.41640033173) | 5 | 1 | 10 | 308 | 32 | |||
147927 | 142556 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 690 Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6007998.3962 | 2121018.0586 | 37.8043625355363 | -122.416556668642 | (37.8043625355363, -122.416556668642) | 5 | 1 | 10 | 308 | 32 | |||
34574 | 27624 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 583 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6008543.93216 | 2121005.06507 | 37.8043575237734 | -122.414667869562 | (37.8043575237734, -122.414667869562) | 3 | 1 | 10 | 308 | 23 | |||
129268 | 125861 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2456 Leavenworth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6007523.93323 | 2120832.54539 | 37.8038264685723 | -122.418185431117 | (37.8038264685723, -122.418185431117) | 5 | 1 | 1 | 308 | 32 | |||
34809 | 125791 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3535 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999695.76662 | 2120720.83293 | 37.8030760041033 | -122.445267130484 | (37.8030760041033, -122.445267130484) | 13 | 9 | 1 | 57 | 17 | |||
31272 | 69362 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3521 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 7 | Permit Number 33456 | 6002627.22111 | 2120704.30709 | 37.8031975232214 | -122.435121592481 | (37.8031975232214, -122.435121592481) | 13 | 9 | 1 | 57 | 17 | |
23657 | 143056 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 30 EDITH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6010306.5322 | 2120406.926 | 37.8028140529926 | -122.408525998217 | (37.8028140529926, -122.408525998217) | 3 | 1 | 10 | 308 | 23 | |||
160047 | 125854 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2760 Polk St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6006137.21976 | 2120328.92662 | 37.8023655091144 | -122.422948425938 | (37.8023655091144, -122.422948425938) | 5 | 9 | 1 | 28858 | 32 | |||
121340 | 143083 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 439 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010755.7275 | 2120312.9864 | 37.8025812640991 | -122.406964920001 | (37.8025812640991, -122.406964920001) | 3 | 1 | 10 | 308 | 23 | |||
102481 | 125868 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306x Montgomery St | 50 | Median : Yard | Tree | DPW 1 | 9 | Width 8ft | 6011397.07627 | 2120306.83138 | 37.8026002312778 | -122.404745086537 | (37.8026002312778, -122.404745086537) | 3 | 1 | 10 | 308 | 23 | |||
102190 | 125867 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306x Montgomery St | 49 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6011400.22925 | 2120293.8654 | 37.8025648060933 | -122.404733262242 | (37.8025648060933, -122.404733262242) | 3 | 1 | 10 | 308 | 23 | |||
112318 | 125866 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306x Montgomery St | 48 | Median : Yard | Tree | DPW 1 | 6 | Width 8ft | 6011400.87154 | 2120290.44992 | 37.802555463919 | -122.404730798994 | (37.802555463919, -122.404730798994) | 3 | 1 | 10 | 308 | 23 | |||
46684 | 125865 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306x Montgomery St | 47 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6011401.82838 | 2120281.49833 | 37.8025309385205 | -122.404726857271 | (37.8025309385205, -122.404726857271) | 3 | 1 | 10 | 308 | 23 | |||
102674 | 125864 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306x Montgomery St | 46 | Median : Yard | Tree | DPW 1 | 11 | Width 8ft | 6011404.31889 | 2120270.95614 | 37.8025021314422 | -122.404717496217 | (37.8025021314422, -122.404717496217) | 3 | 1 | 10 | 308 | 23 | |||
182998 | 125793 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2336 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5999595.05662 | 2120187.92972 | 37.8016070460784 | -122.445577294972 | (37.8016070460784, -122.445577294972) | 13 | 9 | 1 | 57 | 17 | |||
21332 | 16375 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400X Montgomery St | 8 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | 3 | 1 | 10 | 308 | 23 | |||
149540 | 16376 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400X Montgomery St | 9 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | 3 | 1 | 10 | 308 | 23 | |||
75799 | 250223 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 312 Filbert St | 4 | Side Yard : Yard | Tree | Private 2 | 17 | Width 0ft | 6011234.32087 | 2120070.95666 | 37.8019434788798 | -122.405291684587 | (37.8019434788798, -122.405291684587) | 3 | 1 | 10 | 308 | 23 | |||
187357 | 250224 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 312 Filbert St | 6 | Side Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011221.34302 | 2120070.92711 | 37.8019426721638 | -122.405336592216 | (37.8019426721638, -122.405336592216) | 3 | 1 | 10 | 308 | 23 | |||
163752 | 250225 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 312 Filbert St | 5 | Side Yard : Yard | Tree | Private 2 | 18 | Width 0ft | 6011230.02021 | 2120062.52676 | 37.8019200919915 | -122.405305972987 | (37.8019200919915, -122.405305972987) | 3 | 1 | 10 | 308 | 23 | |||
92147 | 250226 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 312 Filbert St | 6 | Side Yard : Yard | Tree | Private 2 | 13 | Width 0ft | 6011217.04209 | 2120062.49723 | 37.8019192853099 | -122.405350881537 | (37.8019192853099, -122.405350881537) | 3 | 1 | 10 | 308 | 23 | |||
162263 | 250228 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 312 Filbert St | 8 | Side Yard : Yard | Tree | Private 2 | 16 | Width 0ft | 6011211.17154 | 2120049.40021 | 37.8018829958704 | -122.405370273631 | (37.8018829958704, -122.405370273631) | 3 | 1 | 10 | 308 | 23 | |||
86197 | 250229 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 312 Filbert St | 9 | Side Yard : Yard | Tree | Private 2 | 20 | Width 0ft | 6011206.62982 | 2120043.61841 | 37.8018668665295 | -122.405385582777 | (37.8018668665295, -122.405385582777) | 3 | 1 | 10 | 308 | 23 | |||
117013 | 97908 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1994 12:00:00 AM | Permit Number 33440 | 6002143 | 2119896 | 37.8009506172383 | -122.436739355692 | (37.8009506172383, -122.436739355692) | 13 | 9 | 1 | 57 | 17 | |||
147750 | 97909 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Chestnut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1994 12:00:00 AM | Permit Number 33440 | 6002143 | 2119896 | 37.8009506172383 | -122.436739355692 | (37.8009506172383, -122.436739355692) | 13 | 9 | 1 | 57 | 17 | |||
117921 | 69349 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | Permit Number 33440 | 6002263.91991676 | 2119868.04210329 | 37.8008807234583 | -122.436318920048 | (37.8008807234583, -122.436318920048) | 13 | 9 | 1 | 57 | 17 | ||
172101 | 125770 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002186.47699 | 2119858.60967 | 37.8008504239642 | -122.436586229264 | (37.8008504239642, -122.436586229264) | 13 | 9 | 1 | 57 | 17 | |||
9270 | 97907 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1994 12:00:00 AM | 8 | Permit Number 33440 | 6002166.03814 | 2119855.12291 | 37.8008396887472 | -122.436656706436 | (37.8008396887472, -122.436656706436) | 13 | 9 | 1 | 57 | 17 | ||
93912 | 125769 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2010 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1994 12:00:00 AM | 7 | Width 3ft | Permit Number 33440 | 6002145.10351 | 2119851.40209 | 37.8008282826453 | -122.436728882426 | (37.8008282826453, -122.436728882426) | 13 | 9 | 1 | 57 | 17 | |
69309 | 125768 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2016 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1994 12:00:00 AM | 5 | Width 3ft | Permit Number 33440 | 6002127.62309 | 2119848.58748 | 37.8008195610256 | -122.43678917031 | (37.8008195610256, -122.43678917031) | 13 | 9 | 1 | 57 | 17 | |
45623 | 45667 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3201 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2001 12:00:00 AM | 5 | Permit Number 44363 | 5999332.42339 | 2119845.91977 | 37.8006529814106 | -122.446461503008 | (37.8006529814106, -122.446461503008) | 13 | 9 | 1 | 57 | 17 | ||
25371 | 250208 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 212 Union St | 4 | Front Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6011783.4083 | 2119794.63457 | 37.8012154488822 | -122.403372122131 | (37.8012154488822, -122.403372122131) | 3 | 1 | 10 | 308 | 23 | |||
142883 | 250210 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 212 Union St | 6 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6011753.31095 | 2119788.98637 | 37.8011982592529 | -122.403475875111 | (37.8011982592529, -122.403475875111) | 3 | 1 | 10 | 308 | 23 | |||
173812 | 250203 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 203 Union St | 4 | Side Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6011748.49406 | 2119742.37279 | 37.8010700006395 | -122.403489262419 | (37.8010700006395, -122.403489262419) | 3 | 1 | 10 | 308 | 23 | |||
1799 | 125860 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2130 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007669.37183 | 2119725.10958 | 37.8007939141569 | -122.417603593144 | (37.8007939141569, -122.417603593144) | 5 | 1 | 1 | 308 | 32 | |||
39297 | 69323 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2130 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/1994 12:00:00 AM | 8 | Permit Number 33406 | 6007673.53376 | 2119706.35756 | 37.8007426600105 | -122.417587861288 | (37.8007426600105, -122.417587861288) | 5 | 1 | 1 | 308 | 32 | ||
189501 | 143119 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1727 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004073.3886 | 2119693.6255 | 37.8005044660423 | -122.430044947424 | (37.8005044660423, -122.430044947424) | 13 | 9 | 1 | 57 | 17 | |||
109242 | 13131 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1727 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6003964.7125 | 2119675.6431 | 37.8004489355963 | -122.430419726797 | (37.8004489355963, -122.430419726797) | 13 | 9 | 1 | 57 | 17 | |||
23405 | 30475 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 424 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/1956 12:00:00 AM | 8 | Permit Number 123 | 6010870.8148 | 2119673.484 | 37.8008317865696 | -122.406521568491 | (37.8008317865696, -122.406521568491) | 3 | 1 | 10 | 308 | 23 | ||
47672 | 13130 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1727 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6004021.47106 | 2119661.74787 | 37.8004139978499 | -122.430222327563 | (37.8004139978499, -122.430222327563) | 13 | 9 | 1 | 57 | 17 | |||
186412 | 13167 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1906 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 26 | 3X3 | 6003216.0169 | 2119655.6641 | 37.8003516396791 | -122.433009083838 | (37.8003516396791, -122.433009083838) | 13 | 9 | 1 | 57 | 17 | ||
91719 | 23956 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2004X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002791.01315 | 2119592.00114 | 37.8001527217578 | -122.434475209441 | (37.8001527217578, -122.434475209441) | 13 | 9 | 1 | 57 | 17 | |||
50074 | 125763 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1595 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005365.83059 | 2119555.39753 | 37.8001980395782 | -122.425562729047 | (37.8001980395782, -122.425562729047) | 13 | 9 | 1 | 57 | 17 | |||
187196 | 125857 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1148 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007410.78308 | 2119548.4108 | 37.8002941896961 | -122.418485883829 | (37.8002941896961, -122.418485883829) | 5 | 1 | 1 | 28858 | 32 | |||
13380 | 55308 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1595 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/1972 12:00:00 AM | 10 | Permit Number 11237 | 6005282.80537 | 2119544.50402 | 37.8001634372533 | -122.425849253052 | (37.8001634372533, -122.425849253052) | 13 | 9 | 1 | 57 | 17 | ||
177709 | 42671 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1115 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49824 | 6007552.92747 | 2119520.43861 | 37.8002253861525 | -122.417992022918 | (37.8002253861525, -122.417992022918) | 5 | 1 | 1 | 28858 | 32 | |
16874 | 55307 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2770 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2012 12:00:00 AM | 2 | Permit Number 769514 | 6005272.5834 | 2119510.27332 | 37.8000688708465 | -122.42588218711 | (37.8000688708465, -122.42588218711) | 13 | 9 | 1 | 57 | 17 | ||
60084 | 108595 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1599x GREENWICH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005333 | 2119502 | 37.8000495685335 | -122.42567253315 | (37.8000495685335, -122.42567253315) | 13 | 9 | 1 | 57 | 17 | ||||
149564 | 125785 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3100 Lyon St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5999066.01183 | 2119467.37321 | 37.7995983743294 | -122.447356131501 | (37.7995983743294, -122.447356131501) | 13 | 9 | 1 | 57 | 17 | |||
110922 | 125784 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3100 Lyon St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5999066.91137 | 2119461.38091 | 37.7995819724856 | -122.447352587247 | (37.7995819724856, -122.447352587247) | 13 | 9 | 1 | 57 | 17 | |||
96100 | 125783 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3100 Lyon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5999067.20465 | 2119454.38129 | 37.7995627701683 | -122.447351068322 | (37.7995627701683, -122.447351068322) | 13 | 9 | 1 | 57 | 17 | |||
83710 | 125782 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3100 Lyon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5999068.0918 | 2119447.80624 | 37.7995447675413 | -122.447347524977 | (37.7995447675413, -122.447347524977) | 13 | 9 | 1 | 57 | 17 | |||
165540 | 13198 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2125 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002212.7759 | 2119440.8173 | 37.799704770189 | -122.436465304667 | (37.799704770189, -122.436465304667) | 13 | 9 | 1 | 57 | 17 | |||
39118 | 32369 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 858 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | 6 | Permit Number 36919 | 6008860.83914 | 2119402.12264 | 37.7999740436362 | -122.413457749072 | (37.7999740436362, -122.413457749072) | 3 | 1 | 10 | 308 | 32 | ||
110300 | 143152 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2308 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6001295.2498 | 2119386.2355 | 37.799502723648 | -122.439636359152 | (37.799502723648, -122.439636359152) | 13 | 9 | 1 | 57 | 17 | |||
116736 | 13236 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2308 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6001297.71761 | 2119386.00749 | 37.7995022380504 | -122.439627803312 | (37.7995022380504, -122.439627803312) | 13 | 9 | 1 | 57 | 17 |
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) );