trees
256 rows where qSpecies_id = 151 sorted by SiteOrder 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28120 | 131190 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2451 Steiner St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6002262.78346 | 2116332.95188 | 37.7911742205576 | -122.436069745025 | (37.7911742205576, -122.436069745025) | 13 | 9 | 1 | 29490 | 27 | |||
157444 | 49819 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 6 | Permit Number 46611 | 6012718.30127 | 2105671.30189 | 37.7624882124737 | -122.39914502972 | (37.7624882124737, -122.39914502972) | 14 | 3 | 8 | 28856 | 29 | ||
1406 | 75132 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 148X Paris St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6002992.10347 | 2092540.72564 | 37.7258878789975 | -122.431846767938 | (37.7258878789975, -122.431846767938) | 9 | 7 | 6 | 28861 | 5 | ||
91294 | 231963 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 500 Andover St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007553.14308 | 2097114.00894 | 37.7387026219233 | -122.416403314785 | (37.7387026219233, -122.416403314785) | 2 | 7 | 7 | 28859 | 2 | |||
174781 | 193532 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 200 Jennings St | 7 | : | Tree | Private 2 | 2 | Width 3ft | 6018580.21539 | 2096908.74747 | 37.7387529542923 | -122.378262250201 | (37.7387529542923, -122.378262250201) | 10 | 3 | 8 | 58 | 1 | |||
159201 | 231947 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1101 San Jose Ave | 64 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 6005025.65555 | 2096592.3987 | 37.7371279405099 | -122.425105073942 | (37.7371279405099, -122.425105073942) | 2 | 7 | 5 | 28859 | 2 | |||
9740 | 75309 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 125 Excelsior Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6002784.56496 | 2092514.51527 | 37.7258041440316 | -122.432562342276 | (37.7258041440316, -122.432562342276) | 9 | 7 | 6 | 28861 | 5 | ||
24703 | 121054 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
157761 | 87043 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 735 07th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49983 | 5993784.66357 | 2110476.13962 | 37.7746076992047 | -122.464978002989 | (37.7746076992047, -122.464978002989) | 11 | 6 | 2 | 54 | 11 | |
173277 | 231946 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 301 Webster St | 6 | : | Tree | Private 2 | 3 | Width 3ft | 6004139.43859 | 2109828.95399 | 37.7734222994207 | -122.429112631967 | (37.7734222994207, -122.429112631967) | 7 | 9 | 11 | 29492 | 10 | |||
175004 | 231962 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 500 Andover St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007543.01124 | 2097062.2707 | 37.7385599903583 | -122.416434682233 | (37.7385599903583, -122.416434682233) | 2 | 7 | 7 | 28859 | 2 | |||
179331 | 49825 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46611 | 6012763.71929 | 2105674.81061 | 37.7625003776121 | -122.398988190679 | (37.7625003776121, -122.398988190679) | 14 | 3 | 8 | 28856 | 29 | ||
40483 | 87042 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 735 07th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49983 | 5993785.1728 | 2110455.01638 | 37.7745497297907 | -122.464974707047 | (37.7745497297907, -122.464974707047) | 11 | 6 | 2 | 54 | 11 | |
58332 | 231961 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 500 Andover St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007544.54493 | 2097042.23546 | 37.7385050642556 | -122.416427960701 | (37.7385050642556, -122.416427960701) | 2 | 7 | 7 | 28859 | 2 | |||
110307 | 42646 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X GREEN ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/26/2000 12:00:00 AM | 10 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
121517 | 254611 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 49 Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2018 02:11:00 PM | 3 | 3X3 | 6001570.75814 | 2091771.51604 | 37.7236951277094 | -122.436705214986 | (37.7236951277094, -122.436705214986) | 9 | 7 | 6 | 28861 | 25 | ||
135882 | 49824 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46611 | 6012781.37184 | 2105676.15617 | 37.7625050558738 | -122.398927231008 | (37.7625050558738, -122.398927231008) | 14 | 3 | 8 | 28856 | 29 | ||
160327 | 121053 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
174822 | 75386 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 163X London St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/1992 12:00:00 AM | 10 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
28265 | 231979 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 478 Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002951.2565 | 2105388.22536 | 37.7611618104807 | -122.43290540667 | (37.7611618104807, -122.43290540667) | 15 | 4 | 5 | 28862 | 3 | |||
32603 | 87041 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 735 07th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49983 | 5993785.44399 | 2110433.89839 | 37.7744917610659 | -122.464972234911 | (37.7744917610659, -122.464972234911) | 11 | 6 | 2 | 54 | 11 | |
37383 | 121052 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
85647 | 193531 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 200 Jennings St | 4 | : | Tree | Private 2 | 3 | Width 3ft | 6018621.46299 | 2096962.90365 | 37.7389039297614 | -122.378123392174 | (37.7389039297614, -122.378123392174) | 10 | 3 | 8 | 58 | 1 | |||
99971 | 231960 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 500 Andover St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007542.74737 | 2097017.75117 | 37.7384377347063 | -122.416432442006 | (37.7384377347063, -122.416432442006) | 2 | 7 | 7 | 28859 | 2 | |||
163496 | 77992 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 163X London St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/01/2000 12:00:00 AM | 16 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
164137 | 49823 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 6 | Permit Number 46611 | 6012798.82942 | 2105676.31317 | 37.7625064597174 | -122.398866862242 | (37.7625064597174, -122.398866862242) | 14 | 3 | 8 | 28856 | 29 | ||
165181 | 43138 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1 Gambier St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2000 12:00:00 AM | 4 | Permit Number 42953 | 6005709.81909 | 2093489.20943 | 37.7286458955884 | -122.422519166951 | (37.7286458955884, -122.422519166951) | 9 | 7 | 7 | 309 | 5 | ||
166834 | 42645 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X GREEN ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/26/2000 12:00:00 AM | 6 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
61575 | 49822 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 7 | Permit Number 46611 | 6012816.10881 | 2105676.13284 | 37.7625069273679 | -122.398807086097 | (37.7625069273679, -122.398807086097) | 14 | 3 | 8 | 28856 | 29 | ||
70737 | 42344 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 380X Flood Ave | 3 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 8 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
100503 | 121051 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
135210 | 46920 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 174 Granville Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44977 | 5994451.42522147 | 2098637.59383586 | 37.7421405253127 | -122.461812970424 | (37.7421405253127, -122.461812970424) | 1 | 8 | 4 | 59 | 40 | |||
141258 | 87040 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 735 07th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49983 | 5993786.75747 | 2110417.02828 | 37.7744455159827 | -122.4649664659 | (37.7744455159827, -122.4649664659) | 11 | 6 | 2 | 54 | 11 | |
153381 | 45327 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1385 Holloway Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2001 12:00:00 AM | Permit Number 44161 | 5991450.97971793 | 2091205.24216012 | 37.7215599710698 | -122.471645977425 | (37.7215599710698, -122.471645977425) | 9 | 8 | 6 | 64 | 24 | |||
168613 | 25930 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1940 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2008 12:00:00 AM | 12 | 3x3 | 6013172.33562 | 2096908.97422 | 37.7384540331375 | -122.396960298598 | (37.7384540331375, -122.396960298598) | 10 | 3 | 8 | 58 | 1 | ||
173003 | 95811 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 691 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767553 | 6015465.85735 | 2105884.27578 | 37.7632257267086 | -122.389657033744 | (37.7632257267086, -122.389657033744) | 14 | 3 | 8 | 28856 | 29 |
177128 | 231952 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 195 Lexington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006488.33791 | 2105047.80636 | 37.7604270841668 | -122.420647967328 | (37.7604270841668, -122.420647967328) | 2 | 4 | 7 | 28859 | 19 | |||
178828 | 131186 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2501 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6001413.74236 | 2116589.85963 | 37.7918313506904 | -122.439025814797 | (37.7918313506904, -122.439025814797) | 13 | 6 | 1 | 29490 | 27 | |||
48519 | 131189 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2501 Jackson St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002000.17825 | 2116671.28438 | 37.792088271701 | -122.4370025821 | (37.792088271701, -122.4370025821) | 13 | 6 | 1 | 29490 | 27 | |||
193722 | 77213 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 499X Hearst Ave | 20 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 8 | 6x50 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
22053 | 49821 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 7 | Permit Number 46611 | 6012834.79813 | 2105677.969 | 37.7625130103804 | -122.398742575008 | (37.7625130103804, -122.398742575008) | 14 | 3 | 8 | 28856 | 29 | ||
23228 | 50536 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 799 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47174 | 6003192.2245553 | 2109948.41523105 | 37.7736966455287 | -122.432397711934 | (37.7736966455287, -122.432397711934) | 15 | 9 | 11 | 29492 | 10 | |||
28039 | 42596 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1950 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 11 | 3x3 | Permit Number 42667 | 6005477.78345 | 2116550.81967 | 37.7919545551073 | -122.424961440544 | (37.7919545551073, -122.424961440544) | 13 | 9 | 1 | 28858 | 27 | |
29959 | 45335 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1239 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2001 12:00:00 AM | Permit Number 44167 | 6013665.22038022 | 2106606.66789645 | 37.7651092465016 | -122.39593550872 | (37.7651092465016, -122.39593550872) | 14 | 3 | 8 | 28856 | 29 | ||
30115 | 46922 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 174 Granville Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44977 | 5994451.42522147 | 2098637.59383586 | 37.7421405253127 | -122.461812970424 | (37.7421405253127, -122.461812970424) | 1 | 8 | 4 | 59 | 40 | |||
43103 | 209295 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2559 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992040.53101 | 2098014.3866 | 37.7402902733651 | -122.470103641773 | (37.7402902733651, -122.470103641773) | 1 | 8 | 4 | 59 | 40 | |||
48209 | 209293 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1416 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993991.03354 | 2105859.32276 | 37.7619430335757 | -122.463928938879 | (37.7619430335757, -122.463928938879) | 1 | 5 | 11 | 56 | 12 | |||
51718 | 43139 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1 Gambier St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2000 12:00:00 AM | 4 | Permit Number 42953 | 6005713.11166 | 2093478.24293 | 37.7286159697368 | -122.422507005398 | (37.7286159697368, -122.422507005398) | 9 | 7 | 7 | 309 | 5 | ||
74510 | 121050 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
76546 | 177523 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 321 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5998908.35184 | 2087935.66658 | 37.7130110981499 | -122.44563295221 | (37.7130110981499, -122.44563295221) | 9 | 7 | 6 | 28861 | 25 | |||
84565 | 177524 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 151 London St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002754.06698 | 2092583.57784 | 37.725992044773 | -122.432672702599 | (37.725992044773, -122.432672702599) | 9 | 7 | 6 | 28861 | 5 | |||
97377 | 77990 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 163X London St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/01/2000 12:00:00 AM | 8 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
106210 | 231953 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 195 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006489.5205 | 2105029.86683 | 37.7603778930513 | -122.420642603769 | (37.7603778930513, -122.420642603769) | 2 | 4 | 7 | 28859 | 19 | |||
145208 | 95813 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 691 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767553 | 6015467.36325 | 2105865.66469 | 37.7631747081784 | -122.389650525366 | (37.7631747081784, -122.389650525366) | 14 | 3 | 8 | 28856 | 29 |
173866 | 45326 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1385 Holloway Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2001 12:00:00 AM | Permit Number 44161 | 5991450.97971793 | 2091205.24216012 | 37.7215599710698 | -122.471645977425 | (37.7215599710698, -122.471645977425) | 9 | 8 | 6 | 64 | 24 | |||
174951 | 47805 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 51 Escondido Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2002 12:00:00 AM | 0 | Permit Number 45573 | 5986262.03154998 | 2096094.88833599 | 37.7346840880203 | -122.489941970727 | (37.7346840880203, -122.489941970727) | 1 | 8 | 3 | 64 | 35 | ||
188020 | 87046 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 735@ 8th Ave 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53657 | 5993787.03862 | 2110396.38433 | 37.7743888494182 | -122.464963993756 | (37.7743888494182, -122.464963993756) | 11 | 6 | 2 | 54 | 11 | |
99923 | 131188 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2501 Jackson St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001926.62889 | 2116662.37015 | 37.7920596147963 | -122.437256424752 | (37.7920596147963, -122.437256424752) | 13 | 6 | 1 | 29490 | 27 | |||
55302 | 42355 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 380X Flood Ave | 14 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 9 | 8x90 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
67409 | 131191 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2451 Steiner St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002287.41432 | 2116178.40828 | 37.7907512828973 | -122.435973460016 | (37.7907512828973, -122.435973460016) | 13 | 9 | 1 | 29490 | 27 | |||
9741 | 131187 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2501 Jackson St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6001696.09346 | 2116629.35582 | 37.7919558582198 | -122.438051712318 | (37.7919558582198, -122.438051712318) | 13 | 6 | 1 | 29490 | 27 | |||
113343 | 113820 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 4101x 25TH ST | 13 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
27044 | 49828 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 7 | Permit Number 46611 | 6012702.02381 | 2105670.26876 | 37.7624844685969 | -122.399201255332 | (37.7624844685969, -122.399201255332) | 14 | 3 | 8 | 28856 | 29 | ||
890 | 231975 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3666 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003943.14044 | 2103070.57421 | 37.7548542993098 | -122.429309632052 | (37.7548542993098, -122.429309632052) | 2 | 4 | 5 | 28862 | 22 | |||
1945 | 44489 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 16 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 8 | Permit Number 43794 | 6005364.27294 | 2093438.07689 | 37.7284859970226 | -122.423710107629 | (37.7284859970226, -122.423710107629) | 9 | 7 | 6 | 28861 | 5 | |
3370 | 67249 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 559 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | 5 | Permit Number 30713 | 5983459.33471 | 2112007.07812 | 37.7782104457147 | -122.500808022251 | (37.7782104457147, -122.500808022251) | 11 | 6 | 2 | 55 | 26 | |
6623 | 42595 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1950 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 5 | Permit Number 42667 | 6005494.51102 | 2116553.24353 | 37.7919621552701 | -122.424903735525 | (37.7919621552701, -122.424903735525) | 13 | 9 | 1 | 28858 | 27 | |
6722 | 95806 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 570 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767550 | 6014847.40317 | 2105882.92079 | 37.7631876934897 | -122.391795984023 | (37.7631876934897, -122.391795984023) | 14 | 3 | 8 | 28856 | 29 |
8770 | 231971 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 4098 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 3ft | 6002611.76959 | 2101830.0379 | 37.7513726180492 | -122.433825215284 | (37.7513726180492, -122.433825215284) | 2 | 4 | 5 | 28862 | 22 | |||
9879 | 63777 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 118 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24458 | 6004354.0616299 | 2101637.06942721 | 37.7509414857928 | -122.427786417218 | (37.7509414857928, -122.427786417218) | 2 | 4 | 5 | 28862 | 22 | ||
10268 | 231965 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 799X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6007531.06073 | 2097759.54123 | 37.7404738690811 | -122.416525379751 | (37.7404738690811, -122.416525379751) | 2 | 7 | 7 | 28859 | 2 | |||
14127 | 45367 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 546 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/28/2001 12:00:00 AM | Permit Number 44192 | 6007805.03016333 | 2096352.99475391 | 37.7366272057089 | -122.415478542826 | (37.7366272057089, -122.415478542826) | 2 | 7 | 7 | 28859 | 2 | ||
14190 | 67936 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 78 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31649 | ||||||||||||
14893 | 69004 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2079 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 0 | 3x3 | Permit Number 33005 | 5982592.52058918 | 2100976.42518266 | 37.7478724914068 | -122.502989774605 | (37.7478724914068, -122.502989774605) | 1 | 8 | 3 | 29491 | 35 |
15126 | 121049 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
16040 | 78382 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 606 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6001696.66297 | 2089972.42102 | 37.7187623714737 | -122.436141300492 | (37.7187623714737, -122.436141300492) | 9 | 7 | 6 | 28861 | 5 | ||||
16063 | 231976 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3670 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6003921.45543 | 2103072.93083 | 37.7548595423439 | -122.42938479289 | (37.7548595423439, -122.42938479289) | 2 | 4 | 5 | 28862 | 22 | |||
16439 | 67516 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 327 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31052 | 5997915.17390153 | 2093778.82856929 | 37.7289983088646 | -122.449486452558 | (37.7289983088646, -122.449486452558) | 9 | 7 | 4 | 28861 | 40 | ||
18660 | 264656 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1199 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2020 04:53:00 PM | 3x3 | |||||||||||||
18761 | 56456 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 141 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1992 12:00:00 AM | Permit Number 30464 | 5999359.80887308 | 2107414.28954328 | 37.7665205189943 | -122.445472331181 | (37.7665205189943, -122.445472331181) | 15 | 5 | 5 | 29492 | 9 | ||
18805 | 78255 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 512 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001977.46264 | 2090420.81734 | 37.7200095171006 | -122.435202744616 | (37.7200095171006, -122.435202744616) | 9 | 7 | 6 | 28861 | 5 | |||
19381 | 70028 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 555 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983452.32231 | 2112030.75964 | 37.7782750565666 | -122.500834032057 | (37.7782750565666, -122.500834032057) | 11 | 6 | 2 | 55 | 26 | |||
19917 | 209292 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1466 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993385.70012 | 2105501.91756 | 37.7609267888564 | -122.465996561219 | (37.7609267888564, -122.465996561219) | 1 | 8 | 11 | 56 | 12 | |||
20236 | 131192 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1700 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6005755.68073 | 2116051.93764 | 37.7906004431923 | -122.423964421545 | (37.7906004431923, -122.423964421545) | 13 | 9 | 1 | 28858 | 27 | |||
21835 | 65598 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 966 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/1990 12:00:00 AM | Permit Number 28500 | 6001950.73496364 | 2088338.48153862 | 37.7142903680478 | -122.435146273727 | (37.7142903680478, -122.435146273727) | 9 | 7 | 6 | 28861 | 5 | ||
22314 | 231968 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 177 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004880.9264 | 2095958.67753 | 37.735379707894 | -122.425560380023 | (37.735379707894, -122.425560380023) | 2 | 7 | 5 | 28861 | 2 | |||
22799 | 101714 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1240 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006918 | 2119116 | 37.7990791449181 | -122.420160405591 | (37.7990791449181, -122.420160405591) | 5 | 1 | 1 | 28858 | 32 | |||||
23011 | 50535 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 799 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/2003 12:00:00 AM | Permit Number 47174 | 6003192.2245553 | 2109948.41523105 | 37.7736966455287 | -122.432397711934 | (37.7736966455287, -122.432397711934) | 15 | 9 | 11 | 29492 | 10 | ||
25626 | 68823 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 306 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32772 | 5999450.43970514 | 2094100.18276953 | 37.729968379033 | -122.444202023687 | (37.729968379033, -122.444202023687) | 9 | 7 | 4 | 63 | 40 | ||
25935 | 66407 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 533 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1991 12:00:00 AM | Permit Number 29534 | 6008039.98859373 | 2096389.06187115 | 37.7367394418447 | -122.414668739511 | (37.7367394418447, -122.414668739511) | 2 | 7 | 7 | 28859 | 2 | ||
26041 | 87359 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2127 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53579 | 6012075.86217 | 2102321.0716 | 37.7532533954437 | -122.401131582655 | (37.7532533954437, -122.401131582655) | 10 | 3 | 8 | 28856 | 29 | |
29365 | 231964 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 332 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008801.63861 | 2097226.11377 | 37.7390805674202 | -122.412094512652 | (37.7390805674202, -122.412094512652) | 10 | 7 | 7 | 28859 | 2 | |||
30587 | 47753 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 70 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/2003 12:00:00 AM | Permit Number 45532 | 6000951.94406001 | 2101308.28424915 | 37.7498456794841 | -122.439527672975 | (37.7498456794841, -122.439527672975) | 2 | 4 | 5 | 28862 | 22 | ||
31598 | 5809 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 25 Dukes Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/09/1998 12:00:00 AM | 6 | 3X4 | 6016112.32175 | 2096327.0001 | 37.7370192646182 | -122.386754585178 | (37.7370192646182, -122.386754585178) | 10 | 3 | 8 | 58 | 1 | ||
32169 | 231956 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 162 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6004841.81484 | 2095922.14472 | 37.7352771869788 | -122.425693003951 | (37.7352771869788, -122.425693003951) | 2 | 7 | 5 | 28861 | 2 | |||
32738 | 66930 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 206 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1991 12:00:00 AM | Permit Number 30252 | 6007535.74955777 | 2097703.77171349 | 37.7403210020284 | -122.41650521811 | (37.7403210020284, -122.41650521811) | 2 | 7 | 7 | 28859 | 2 | ||
32767 | 68798 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2448 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32737 | 5992373.31469622 | 2098785.22580126 | 37.7424260349459 | -122.469009103079 | (37.7424260349459, -122.469009103079) | 1 | 8 | 4 | 29491 | 40 | ||
34596 | 66400 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 531 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1991 12:00:00 AM | Permit Number 29526 | 6007491.7583768 | 2096409.40123315 | 37.7367644721833 | -122.416565655603 | (37.7367644721833, -122.416565655603) | 2 | 7 | 7 | 28859 | 2 | ||
34670 | 66326 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 135 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | Permit Number 29445 | 6000528.81306712 | 2095194.53475792 | 37.7330346787859 | -122.440552427184 | (37.7330346787859, -122.440552427184) | 9 | 7 | 5 | 63 | 40 | ||
35390 | 60180 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 39 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1982 12:00:00 AM | Permit Number 19713 | 6005845.55661292 | 2105868.08575362 | 37.7626431308333 | -122.422929354207 | (37.7626431308333, -122.422929354207) | 8 | 4 | 5 | 28859 | 19 |
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) );