trees
7,157 rows where qSpecies_id = 36 sorted by qCaretaker_id 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
95696 | 99259 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5995893.7088 | 2113098.76002 | 37.7819301026873 | -122.457872268014 | (37.7819301026873, -122.457872268014) | 11 | 6 | 1 | 54 | 31 | ||
95849 | 234073 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 17 | Width 3ft | 6011143.13167 | 2101723.71293 | 37.7515611015794 | -122.404315130536 | (37.7515611015794, -122.404315130536) | 10 | 4 | 8 | 28859 | 19 | |||
95964 | 51930 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2641 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/21/2005 12:00:00 AM | 10 | 3x3 | Permit Number 48158 | 6011052.19017876 | 2101794.26112893 | 37.7517497291988 | -122.404634585115 | (37.7517497291988, -122.404634585115) | 10 | 4 | 8 | 28859 | 19 |
97987 | 99681 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Grattan St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
98442 | 142544 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 03/23/2016 02:55:00 PM | 26 | Width 0ft | 6009534.8661 | 2121184.7078 | 37.8049064021217 | -122.411251344133 | (37.8049064021217, -122.411251344133) | 3 | 1 | 10 | 308 | 23 | ||
99299 | 142522 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | Width 0ft | 6009689.0581 | 2121206.8206 | 37.8049757647303 | -122.410719306308 | (37.8049757647303, -122.410719306308) | 3 | 1 | 10 | 308 | 23 | |||
101801 | 256358 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6005778.11415 | 2120709.05822 | 37.8033889834786 | -122.424218159845 | (37.8033889834786, -122.424218159845) | 5 | 9 | 1 | 28858 | 32 | |||
103512 | 95456 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986576.02446 | 2111660.34524 | 37.7774409068096 | -122.490000890521 | (37.7774409068096, -122.490000890521) | 11 | 6 | 2 | 55 | 26 | ||
104016 | 110959 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 940 Filbert St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 5x5 | 6008435.02538 | 2119688.12069 | 37.8007354051603 | -122.414951484348 | (37.8007354051603, -122.414951484348) | 5 | 1 | 10 | 308 | 32 | ||
105400 | 110956 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 940 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 7 | 5x5 | 6008474.06115 | 2119692.72385 | 37.8007502377013 | -122.414816729923 | (37.8007502377013, -122.414816729923) | 5 | 1 | 10 | 308 | 32 | ||
110284 | 98635 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6002251.83785 | 2120250.68488 | 37.8019306734253 | -122.436388130233 | (37.8019306734253, -122.436388130233) | 13 | 9 | 1 | 57 | 17 | ||
111399 | 98935 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1401X Utah St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6010911 | 2101810 | 37.7517850526072 | -122.405123950338 | (37.7517850526072, -122.405123950338) | 10 | 4 | 8 | 28859 | 19 | ||
111842 | 98941 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400X San Bruno Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6011147.5 | 2101806.3 | 37.7517881116631 | -122.404305836485 | (37.7517881116631, -122.404305836485) | 10 | 4 | 8 | 28859 | 19 | ||
112087 | 98638 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6002513 | 2120207.2 | 37.8018261113234 | -122.435481274987 | (37.8018261113234, -122.435481274987) | 13 | 9 | 1 | 57 | 17 | ||
115106 | 98606 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 4.5x4.5 | 6003043.17178 | 2116866.41104 | 37.7926832667819 | -122.433407765274 | (37.7926832667819, -122.433407765274) | 13 | 9 | 1 | 29490 | 27 | ||
118273 | 99694 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550X Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6007274.7 | 2117123.2 | 37.7936275055362 | -122.418784695641 | (37.7936275055362, -122.418784695641) | 5 | 1 | 10 | 28858 | 32 | ||
121669 | 234075 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400 San Bruno Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 14 | Width 4ft | 6011146.17896 | 2101629.85029 | 37.7513035456277 | -122.404297986789 | (37.7513035456277, -122.404297986789) | 10 | 4 | 8 | 28859 | 19 | |||
123401 | 98939 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400X San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3x3 | 6011147.5 | 2101806.3 | 37.7517881116631 | -122.404305836485 | (37.7517881116631, -122.404305836485) | 10 | 4 | 8 | 28859 | 19 | ||
125465 | 142523 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 7 | Width 0ft | 6009712.3662 | 2121206.8206 | 37.8049770715314 | -122.410638645677 | (37.8049770715314, -122.410638645677) | 3 | 1 | 10 | 308 | 23 | |||
131177 | 98630 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6002266.09398 | 2120152.58331 | 37.8016621223571 | -122.436331772404 | (37.8016621223571, -122.436331772404) | 13 | 9 | 1 | 57 | 17 | ||
136350 | 59884 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550X Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/20/1981 12:00:00 AM | 24 | 3x3 | Permit Number 19349 | 6004500.5356676 | 2116743.15343908 | 37.7924274060317 | -122.42835643846 | (37.7924274060317, -122.42835643846) | 13 | 9 | 1 | 28858 | 27 |
139610 | 98609 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 6003008.4 | 2116877.5 | 37.7927117414369 | -122.433528869724 | (37.7927117414369, -122.433528869724) | 13 | 9 | 1 | 29490 | 27 | ||
139813 | 71107 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4235 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/07/1990 12:00:00 AM | 8 | 3x3 | 6001944.69626247 | 2104668.40530987 | 37.7591282168027 | -122.436335144342 | (37.7591282168027, -122.436335144342) | 2 | 4 | 5 | 28862 | 3 | |
140158 | 98755 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 540X Eureka St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | 2 | 4 | 5 | 28862 | 22 | ||||
140414 | 98753 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 540X Eureka St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | 2 | 4 | 5 | 28862 | 22 | ||||
140661 | 98604 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 6003077.63265 | 2116870.32542 | 37.792695969686 | -122.433288809234 | (37.792695969686, -122.433288809234) | 13 | 9 | 1 | 29490 | 27 | ||
142206 | 99260 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/2015 03:10:00 PM | 3 | 3x3 | 5995894.58408 | 2113075.36458 | 37.7818659153243 | -122.457867546462 | (37.7818659153243, -122.457867546462) | 11 | 6 | 1 | 54 | 31 | |
143470 | 98602 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 6003137.34298 | 2116882.04608 | 37.7927315387907 | -122.433083047059 | (37.7927315387907, -122.433083047059) | 13 | 9 | 1 | 29490 | 27 | ||
149681 | 98932 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1401X Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6010911 | 2101810 | 37.7517850526072 | -122.405123950338 | (37.7517850526072, -122.405123950338) | 10 | 4 | 8 | 28859 | 19 | ||
149719 | 98608 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 6002968.64851 | 2116857.31006 | 37.7926540495901 | -122.433664967757 | (37.7926540495901, -122.433664967757) | 13 | 9 | 1 | 29490 | 27 | ||
150387 | 98603 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 6003120.00759 | 2116875.00163 | 37.7927112131931 | -122.433142524628 | (37.7927112131931, -122.433142524628) | 13 | 9 | 1 | 29490 | 27 | ||
151965 | 98629 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 6x6 | 6002271.75666 | 2120123.52327 | 37.8015826528763 | -122.436310096028 | (37.8015826528763, -122.436310096028) | 13 | 9 | 1 | 57 | 17 | ||
152258 | 98578 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/26/2016 09:53:00 AM | 3 | 6x7 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
152503 | 98570 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/26/2016 09:47:00 AM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
153204 | 81998 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50638 | 6005939.39797 | 2120724.94139 | 37.8034416999448 | -122.42366116025 | (37.8034416999448, -122.42366116025) | 5 | 9 | 1 | 28858 | 32 |
154088 | 95241 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1220 Noe St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | 2 | 4 | 5 | 28862 | 22 | ||
154771 | 98634 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6002253.74096 | 2120233.67924 | 37.8018840885493 | -122.436380326794 | (37.8018840885493, -122.436380326794) | 13 | 9 | 1 | 57 | 17 | ||
155011 | 98574 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
155740 | 95235 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1220 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | 2 | 4 | 5 | 28862 | 22 | ||
156452 | 98568 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:55:00 PM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
160459 | 98572 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
163770 | 98938 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400X San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6011147.5 | 2101806.3 | 37.7517881116631 | -122.404305836485 | (37.7517881116631, -122.404305836485) | 10 | 4 | 8 | 28859 | 19 | ||
165062 | 142548 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 7 | Width 0ft | 6009639.4537 | 2121197.2583 | 37.8049467277157 | -122.410890292822 | (37.8049467277157, -122.410890292822) | 3 | 1 | 10 | 308 | 23 | |||
165159 | 98934 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1401X Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6010911 | 2101810 | 37.7517850526072 | -122.405123950338 | (37.7517850526072, -122.405123950338) | 10 | 4 | 8 | 28859 | 19 | ||
165305 | 93105 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 02/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53160 | 5995888.42271 | 2113224.45495 | 37.7822749237882 | -122.457899654053 | (37.7822749237882, -122.457899654053) | 11 | 6 | 1 | 54 | 31 |
166204 | 98605 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 6003064.14598 | 2116869.67879 | 37.7926934290995 | -122.433335427386 | (37.7926934290995, -122.433335427386) | 13 | 9 | 1 | 29490 | 27 | ||
170711 | 95240 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1220 Noe St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 12 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | 2 | 4 | 5 | 28862 | 22 | ||
171496 | 98747 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 540X Eureka St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | 2 | 4 | 5 | 28862 | 22 | ||||
173163 | 97729 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | Permit Number 50638 | 6005819.00921 | 2120706.70735 | 37.8033848375917 | -122.424076473471 | (37.8033848375917, -122.424076473471) | 5 | 9 | 1 | 28858 | 32 | |
175199 | 96769 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Lane St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 1 | 4x4 | 6015646.9436 | 2095179.7309 | 37.7338433188148 | -122.388283573512 | (37.7338433188148, -122.388283573512) | 10 | 3 | 8 | 58 | 1 | ||
175355 | 98575 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
175564 | 95236 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1220 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 12 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | 2 | 4 | 5 | 28862 | 22 | ||
179818 | 98748 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 540X Eureka St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | 2 | 4 | 5 | 28862 | 22 | ||||
183108 | 99680 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Grattan St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
183257 | 98751 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 540X Eureka St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | 2 | 4 | 5 | 28862 | 22 | ||||
185623 | 99257 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5995884.63149 | 2113369.41772 | 37.7826727350965 | -122.457923263549 | (37.7826727350965, -122.457923263549) | 11 | 6 | 1 | 54 | 31 | ||
188131 | 97727 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | Permit Number 50638 | 6005898.3389 | 2120719.31411 | 37.8034239311172 | -122.423802846647 | (37.8034239311172, -122.423802846647) | 5 | 9 | 1 | 28858 | 32 | |
191362 | 97733 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | Permit Number 50638 | 6005736.8865 | 2120695.23683 | 37.8033487055393 | -122.424359846228 | (37.8033487055393, -122.424359846228) | 5 | 9 | 1 | 28858 | 32 | |
161345 | 106209 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 585X Bush St | 7 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 16 | 3x16 | 6010847.77195 | 2115873.69146 | 37.7903971865333 | -122.406333425049 | (37.7903971865333, -122.406333425049) | 5 | 1 | 10 | 28857 | 6 | |||
66 | 132469 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3135 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001403 | 2119193 | 37.7989782820217 | -122.43924964791 | (37.7989782820217, -122.43924964791) | 13 | 9 | 1 | 57 | 17 | |||
174 | 113728 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 5 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
352 | 98788 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003538.80686 | 2121150.47161 | 37.804474295204 | -122.431998903525 | (37.804474295204, -122.431998903525) | 13 | 9 | 1 | 57 | 17 | |||
363 | 234091 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 460 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005712.20409 | 2107866.30498 | 37.7681222411638 | -122.423532643536 | (37.7681222411638, -122.423532643536) | 8 | 4 | 5 | 28853 | 19 | |||
368 | 234039 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 93 Scott St | 1 | : | Tree | Private 2 | 12 | Width 4ft | 6002347.86623 | 2108745.44445 | 37.7703456710482 | -122.435232412346 | (37.7703456710482, -122.435232412346) | 15 | 5 | 5 | 29492 | 9 | |||
412 | 121036 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1830 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006566 | 2117108 | 37.7935458417616 | -122.421235781398 | (37.7935458417616, -122.421235781398) | 13 | 9 | 10 | 28858 | 32 | ||||
511 | 23082 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1304 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/1990 12:00:00 AM | 12 | 4x4 | 6006396.78239 | 2101930.96357 | 37.7518637944919 | -122.420743341327 | (37.7518637944919, -122.420743341327) | 2 | 4 | 5 | 28859 | 19 | ||
592 | 211675 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 140 Jules Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 785250 | 5994473.3982 | 2090822.99818 | 37.7206848225258 | -122.461170675896 | (37.7206848225258, -122.461170675896) | 9 | 8 | 6 | 28861 | 24 | |
596 | 234286 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 803 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007964.56694 | 2103204.29318 | 37.7554483078008 | -122.415411844593 | (37.7554483078008, -122.415411844593) | 2 | 4 | 7 | 28859 | 19 | |||
602 | 234309 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3221 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008660.48476 | 2104460.24756 | 37.7589359632462 | -122.413093942738 | (37.7589359632462, -122.413093942738) | 2 | 4 | 7 | 28859 | 19 | |||
634 | 79736 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 705 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6008945.3206 | 2110776.64932 | 37.7762953249107 | -122.412555345054 | (37.7762953249107, -122.412555345054) | 8 | 2 | 9 | 28853 | 34 | |||
641 | 132666 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3408 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5998390.41513 | 2115562.86415 | 37.7888390076521 | -122.449412451134 | (37.7888390076521, -122.449412451134) | 13 | 6 | 1 | 54 | 31 | |||
669 | 30402 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2800 Turk St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1956 12:00:00 AM | Permit Number 66 | 5997681.665837 | 2111673.48633421 | 37.7781192320704 | -122.451583952943 | (37.7781192320704, -122.451583952943) | 15 | 6 | 2 | 54 | 16 | |||
702 | 62566 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 484 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1986 12:00:00 AM | 11 | Permit Number 22767 | 6011457.1056 | 2106150.727 | 37.7637342411783 | -122.403540799888 | (37.7637342411783, -122.403540799888) | 8 | 3 | 8 | 28856 | 29 | |
731 | 262111 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2021 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991247 | 2101647 | 37.7502185858925 | -122.473112177678 | (37.7502185858925, -122.473112177678) | 1 | 8 | 4 | 29491 | 12 | ||||
781 | 98761 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 16 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11 | 3x3 | 6003198.92766 | 2121046.5425 | 37.8041696588781 | -122.433167654376 | (37.8041696588781, -122.433167654376) | 13 | 9 | 1 | 57 | 17 | |||
817 | 132762 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3749 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003038.53227 | 2121230.80772 | 37.8046665028104 | -122.43373589191 | (37.8046665028104, -122.43373589191) | 13 | 9 | 1 | 57 | 17 | |||
818 | 71164 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2118 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5988230.9552 | 2100880.1949 | 37.7479380567645 | -122.483485514105 | (37.7479380567645, -122.483485514105) | 1 | 8 | 3 | 29491 | 35 | |||
864 | 71270 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1215 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6001794.92 | 2112753.6259 | 37.7813197166319 | -122.437432113692 | (37.7813197166319, -122.437432113692) | 15 | 5 | 11 | 29490 | 41 | |||
869 | 62385 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 642 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1985 12:00:00 AM | 12 | Permit Number 22535 | 6001098.1348 | 2110956.5992 | 37.7763458992435 | -122.439713770865 | (37.7763458992435, -122.439713770865) | 15 | 5 | 11 | 29492 | 10 | |
877 | 140007 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 590 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005073.8071 | 2111650.2628 | 37.778476017163 | -122.426010193621 | (37.778476017163, -122.426010193621) | 7 | 9 | 11 | 28852 | 41 | |||
901 | 124502 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2721 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996533.72285 | 2111260.82962 | 37.7769203792262 | -122.455525245928 | (37.7769203792262, -122.455525245928) | 11 | 6 | 2 | 54 | 16 | |||
914 | 72135 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 720 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6011518.46823 | 2104995.10588 | 37.7605645914089 | -122.403247266572 | (37.7605645914089, -122.403247266572) | 10 | 3 | 8 | 28856 | 29 | |||
926 | 120780 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5989259.72068 | 2114624.20771 | 37.7857351884005 | -122.48093426444 | (37.7857351884005, -122.48093426444) | 11 | 6 | 2 | 55 | 26 | |||
931 | 211755 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 78 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993084.56789 | 2098632.31996 | 37.7420472635629 | -122.466538712105 | (37.7420472635629, -122.466538712105) | 1 | 8 | 4 | 59 | 40 | |||
935 | 132500 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2512 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6000920.49838 | 2118292.02212 | 37.796476965998 | -122.440854593363 | (37.796476965998, -122.440854593363) | 13 | 9 | 1 | 57 | 17 | |||
944 | 211787 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 145 Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994159.28368 | 2097331.60357 | 37.7385377797886 | -122.462728377219 | (37.7385377797886, -122.462728377219) | 9 | 8 | 4 | 59 | 40 | |||
948 | 62575 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 836 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1986 12:00:00 AM | 11 | Permit Number 22778 | 6011550.65022 | 2104487.06027 | 37.7591714084613 | -122.403100226493 | (37.7591714084613, -122.403100226493) | 10 | 3 | 8 | 28856 | 29 | |
959 | 49689 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2235 NOTES) Hayes St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2003 12:00:00 AM | Permit Number 46511 | 5997175.15188937 | 2109805.23760487 | 37.7729604879505 | -122.453201252207 | (37.7729604879505, -122.453201252207) | 15 | 5 | 11 | 29492 | 16 | |||
989 | 40872 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 3456 Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1999 12:00:00 AM | Permit Number 41788 | 5998239.16759035 | 2115871.78992415 | 37.7896785829725 | -122.449958017829 | (37.7896785829725, -122.449958017829) | 13 | 6 | 1 | 54 | 31 | |||
1018 | 41589 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2601 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2013 12:00:00 AM | 4 | Permit Number 770702 | 6001047.66976 | 2117208.8358 | 37.7935100620898 | -122.440336832983 | (37.7935100620898, -122.440336832983) | 13 | 9 | 1 | 29490 | 27 | ||
1034 | 194657 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1701 19th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 7ft | 6012465.19562 | 2105138.61132 | 37.7610114537331 | -122.39998302521 | (37.7610114537331, -122.39998302521) | 10 | 3 | 8 | 28856 | 29 | |||
1098 | 31784 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 7 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35255 | 6001631.05677 | 2108636.54376 | 37.7700059251571 | -122.437704050605 | (37.7700059251571, -122.437704050605) | 15 | 5 | 5 | 29492 | 9 | |
1167 | 33310 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1549 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 8 | Permit Number 37457 | 6005491.84423 | 2119228.52143 | 37.7993076406048 | -122.425103401209 | (37.7993076406048, -122.425103401209) | 13 | 9 | 1 | 57 | 17 | |
1225 | 70200 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 651 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002623.55844 | 2089844.48662 | 37.7184637093015 | -122.432928262055 | (37.7184637093015, -122.432928262055) | 9 | 7 | 6 | 28861 | 5 | |||
1316 | 79413 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1666 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | 5987817.2161 | 2103952.4133 | 37.7563494532381 | -122.485141568367 | (37.7563494532381, -122.485141568367) | 1 | 8 | 3 | 56 | 35 | ||
1362 | 244521 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 577 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003849.83 | 2109698.0755 | 37.7730465408764 | -122.430105090767 | (37.7730465408764, -122.430105090767) | 7 | 9 | 11 | 29492 | 10 | |||
1379 | 19129 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 25 Sanchez St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2009 12:00:00 AM | 3 | 3X4 | 6003497.27744 | 2108239.16815 | 37.7690207646335 | -122.431220458483 | (37.7690207646335, -122.431220458483) | 7 | 9 | 5 | 28862 | 3 | ||
1385 | 101200 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 502 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994231.2 | 2106687.3 | 37.7642302811549 | -122.463158383346 | (37.7642302811549, -122.463158383346) | 11 | 5 | 11 | 56 | 12 | |||||
1436 | 256792 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 120 Cedar St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006815 | 2114489 | 37.7863687502832 | -122.420188259313 | (37.7863687502832, -122.420188259313) | 13 | 9 | 10 | 28858 | 36 | ||||
1444 | 256097 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:12:00 PM | 3 | 3x3 | 6010298.36751 | 2122029.07931 | 37.8072676263732 | -122.408668755752 | (37.8072676263732, -122.408668755752) | 3 | 1 | 10 | 308 | 23 |
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) );