trees
772 rows where qCareAssistant = "DPW for City Agency" and qCaretaker_id = 4 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
167 | 99668 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
1047 | 42641 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1651 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 12:11:00 PM | 3 | 5x5 | Permit Number 42688 | 6005090.06351 | 2118821.98656 | 37.7981686950973 | -122.426464740961 | (37.7981686950973, -122.426464740961) | 13 | 9 | 1 | 57 | 17 |
1121 | 77643 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | 6006923.44086 | 2093174.37286 | 37.7278498138936 | -122.418301281799 | (37.7278498138936, -122.418301281799) | 9 | 3 | 7 | 309 | 5 | ||
1341 | 76159 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
1403 | 77662 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6006681.78325 | 2093389.68756 | 37.7284274151839 | -122.419151965791 | (37.7284274151839, -122.419151965791) | 9 | 3 | 7 | 309 | 5 | ||
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 | ||
1502 | 77647 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1300X Silliman St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006841.82551 | 2093150.82877 | 37.7277805724005 | -122.418581759638 | (37.7277805724005, -122.418581759638) | 9 | 3 | 7 | 309 | 5 | ||
2028 | 76748 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1501X 42nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 7 | 3x12 | 5983093.5463 | 2104693.1195 | 37.7581069307926 | -122.501532189631 | (37.7581069307926, -122.501532189631) | 1 | 8 | 3 | 56 | 35 | ||
2404 | 76334 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6006750.61437 | 2093170.72103 | 37.7278300567077 | -122.418898489194 | (37.7278300567077, -122.418898489194) | 9 | 3 | 7 | 309 | 5 | ||
2999 | 94036 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Lane St | 4 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/14/2019 09:52:00 AM | 3 | 5x5 | 6015673.325 | 2095216.0053 | 37.7339443827642 | -122.388194894968 | (37.7339443827642, -122.388194894968) | 10 | 3 | 8 | 58 | 1 | |
3327 | 99692 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550X Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 2x2 | 6007274.7 | 2117123.2 | 37.7936275055362 | -122.418784695641 | (37.7936275055362, -122.418784695641) | 5 | 1 | 10 | 28858 | 32 | ||
3404 | 74737 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 151X Palm Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5995889.08215 | 2113282.06845 | 37.7824331529909 | -122.457901543211 | (37.7824331529909, -122.457901543211) | 11 | 6 | 1 | 54 | 31 | ||
3604 | 77660 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006693.80957 | 2093349.88561 | 37.7283188049508 | -122.419107568078 | (37.7283188049508, -122.419107568078) | 9 | 3 | 7 | 309 | 5 | ||
3628 | 76755 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501X 42nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x12 | 5983093.5463 | 2104662.8676 | 37.758023867602 | -122.501529951702 | (37.758023867602, -122.501529951702) | 1 | 8 | 3 | 56 | 35 | ||
3789 | 77644 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x5 | 6006907.53511 | 2093169.55905 | 37.7278357008551 | -122.41835592728 | (37.7278357008551, -122.41835592728) | 9 | 3 | 7 | 309 | 5 | ||
3937 | 98576 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 301X Francisco St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:52:00 PM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
3976 | 75213 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 125 Excelsior Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x5 | 6002883.60734 | 2092451.48886 | 37.7256367037627 | -122.43221546119 | (37.7256367037627, -122.43221546119) | 9 | 7 | 6 | 28861 | 5 | ||
4078 | 78328 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 50 Pomona St | 19 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014090.70522 | 2094312.98368 | 37.7313770539035 | -122.393603356926 | (37.7313770539035, -122.393603356926) | 10 | 3 | 8 | 58 | 1 | ||
4799 | 95481 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986568.37611 | 2111910.32722 | 37.778126839673 | -122.490045739805 | (37.778126839673, -122.490045739805) | 11 | 6 | 2 | 55 | 26 | |
4815 | 98680 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
4867 | 76353 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006742.79477 | 2093189.9157 | 37.7278823207912 | -122.418926882581 | (37.7278823207912, -122.418926882581) | 9 | 3 | 7 | 309 | 5 | ||
5047 | 37814 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003977.37565 | 2090552.2455 | 37.720483755714 | -122.428299091747 | (37.720483755714, -122.428299091747) | 9 | 7 | 6 | 28861 | 5 |
5271 | 78323 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 24 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014072.33534 | 2094216.70422 | 37.7311116693492 | -122.393660129315 | (37.7311116693492, -122.393660129315) | 10 | 3 | 8 | 58 | 1 | ||
5378 | 76652 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 148X Paris St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6002965.38435 | 2092499.73249 | 37.7257738062998 | -122.43193620819 | (37.7257738062998, -122.43193620819) | 9 | 7 | 6 | 28861 | 5 | ||
5484 | 71815 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5995888.68435 | 2113315.23973 | 37.7825242096287 | -122.45790532062 | (37.7825242096287, -122.45790532062) | 11 | 6 | 1 | 54 | 31 | ||
5500 | 77664 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006642.94243 | 2093520.00504 | 37.728783051183 | -122.419295481395 | (37.728783051183, -122.419295481395) | 9 | 3 | 7 | 309 | 5 | ||
5610 | 46958 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 7 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
5633 | 76756 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501X 42nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 2 | 3x12 | 5983095.0741 | 2104639.3384 | 37.757959352781 | -122.501522927406 | (37.757959352781, -122.501522927406) | 1 | 8 | 3 | 56 | 35 | ||
5695 | 77663 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6006674.08558 | 2093407.54115 | 37.7284760037541 | -122.419179842976 | (37.7284760037541, -122.419179842976) | 9 | 3 | 7 | 309 | 5 | ||
5845 | 96500 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
5947 | 76372 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006736.19364 | 2093210.27498 | 37.7279378512454 | -122.418951146283 | (37.7279378512454, -122.418951146283) | 9 | 3 | 7 | 309 | 5 | ||
6227 | 77210 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 5 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
6245 | 75019 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 151X Palm Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5995892.05475 | 2113163.21783 | 37.782106991639 | -122.457882656117 | (37.782106991639, -122.457882656117) | 11 | 6 | 1 | 54 | 31 | ||
6638 | 77652 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006723.02825 | 2093252.77715 | 37.7280538116191 | -122.41899967279 | (37.7280538116191, -122.41899967279) | 9 | 3 | 7 | 309 | 5 | ||
6745 | 74583 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | 5995884.6031 | 2113341.96396 | 37.7825973527613 | -122.457921374418 | (37.7825973527613, -122.457921374418) | 11 | 6 | 1 | 54 | 31 | |
7113 | 51366 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014162.99112 | 2094669.44393 | 37.7323598375173 | -122.393378385216 | (37.7323598375173, -122.393378385216) | 10 | 3 | 8 | 58 | 1 |
7380 | 75048 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6003019.45241 | 2092585.35122 | 37.7260119611657 | -122.431755409402 | (37.7260119611657, -122.431755409402) | 9 | 7 | 6 | 28861 | 5 | ||
7428 | 78326 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 50 Pomona St | 21 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014084.32077 | 2094282.11607 | 37.7312919429706 | -122.393623269718 | (37.7312919429706, -122.393623269718) | 10 | 3 | 8 | 58 | 1 | ||
7682 | 76663 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 148X Paris St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6002979.0601 | 2092519.08061 | 37.725827707182 | -122.431890313086 | (37.725827707182, -122.431890313086) | 9 | 7 | 6 | 28861 | 5 | ||
7708 | 76081 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
7775 | 77645 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | 6006883.85072 | 2093162.97754 | 37.7278162961767 | -122.418437338432 | (37.7278162961767, -122.418437338432) | 9 | 3 | 7 | 309 | 5 | ||
7794 | 78331 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 50 Pomona St | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014103.03356 | 2094377.1679 | 37.7315539757311 | -122.393565225657 | (37.7315539757311, -122.393565225657) | 10 | 3 | 8 | 58 | 1 | ||
7857 | 78321 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 26 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014066.05948 | 2094191.20422 | 37.7310413028018 | -122.3936800421 | (37.7310413028018, -122.3936800421) | 10 | 3 | 8 | 58 | 1 | ||
7953 | 97241 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 260 Madrid St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003464 | 2092306.9 | 37.7252725856131 | -122.430198780788 | (37.7252725856131, -122.430198780788) | 9 | 7 | 6 | 28861 | 5 |
8049 | 51364 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014150.64944 | 2094610.63008 | 37.7321976609735 | -122.393416939157 | (37.7321976609735, -122.393416939157) | 10 | 3 | 8 | 58 | 1 |
8094 | 78325 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 50 Pomona St | 22 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014082.07463 | 2094268.00581 | 37.7312530742586 | -122.393630047885 | (37.7312530742586, -122.393630047885) | 10 | 3 | 8 | 58 | 1 | ||
8159 | 78322 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 25 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014069.27853 | 2094204.92894 | 37.7310791669665 | -122.393669873461 | (37.7310791669665, -122.393669873461) | 10 | 3 | 8 | 58 | 1 | ||
8399 | 95483 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5986569.82886 | 2111856.71768 | 37.7779797279503 | -122.490036770148 | (37.7779797279503, -122.490036770148) | 11 | 6 | 2 | 55 | 26 | ||
8452 | 116055 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650x Kansas St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/08/2020 12:00:00 AM | 3 | 4x4 | 6011513.13975 | 2105199.40577 | 37.7611252557522 | -122.403280067548 | (37.7611252557522, -122.403280067548) | 10 | 3 | 8 | 28856 | 29 | |
8515 | 76311 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 299X Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 0 | 6006754.26056 | 2093151.90933 | 37.7277786091743 | -122.418884550584 | (37.7277786091743, -122.418884550584) | 9 | 3 | 7 | 309 | 5 | ||
8555 | 77658 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6006705.39704 | 2093310.53877 | 37.7282114196192 | -122.419064719886 | (37.7282114196192, -122.419064719886) | 9 | 3 | 7 | 309 | 5 | ||
8962 | 116061 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2100x 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 16 | 3x3 | 6011385.89017 | 2105128.48272 | 37.7609234092204 | -122.403715181115 | (37.7609234092204, -122.403715181115) | 10 | 3 | 8 | 28856 | 29 | ||
9059 | 77640 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 13 | 0 | 6006980.92428 | 2093193.11147 | 37.7279045016753 | -122.418103887786 | (37.7279045016753, -122.418103887786) | 9 | 3 | 7 | 309 | 5 | ||
9148 | 76641 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 148X Paris St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6002952.72216 | 2092480.76402 | 37.7257210052939 | -122.43197862653 | (37.7257210052939, -122.43197862653) | 9 | 7 | 6 | 28861 | 5 | ||
9319 | 77642 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 4x4 | 6006942.10409 | 2093179.93326 | 37.7278661320969 | -122.418237156514 | (37.7278661320969, -122.418237156514) | 9 | 3 | 7 | 309 | 5 | ||
9619 | 75308 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 125 Excelsior Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x5 | 6002852.68268 | 2092471.30856 | 37.7256893707662 | -122.43232378004 | (37.7256893707662, -122.43232378004) | 9 | 7 | 6 | 28861 | 5 | ||
9739 | 77653 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006717.25868 | 2093269.99639 | 37.7281007670162 | -122.41902083924 | (37.7281007670162, -122.41902083924) | 9 | 3 | 7 | 309 | 5 | ||
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 | ||
10546 | 77641 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 4x4 | 6006964.98892 | 2093186.85252 | 37.7278864190206 | -122.418158533295 | (37.7278864190206, -122.418158533295) | 9 | 3 | 7 | 309 | 5 | ||
10649 | 76037 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/16/1996 12:00:00 AM | 6 | 4x6 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | 5 | 9 | 1 | 28858 | 32 | |
10992 | 98625 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6002285.2374 | 2120040.843 | 37.8013564005351 | -122.43625752619 | (37.8013564005351, -122.43625752619) | 13 | 9 | 1 | 57 | 17 | ||
11126 | 51368 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014172.09212 | 2094713.43563 | 37.7324811353964 | -122.393349998121 | (37.7324811353964, -122.393349998121) | 10 | 3 | 8 | 58 | 1 |
11170 | 76785 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1501X 42nd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 3x12 | 5983097.8243 | 2104541.5546 | 37.75769102754 | -122.501506182606 | (37.75769102754, -122.501506182606) | 1 | 8 | 3 | 56 | 35 | ||
11183 | 74883 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | 5995886.83117 | 2113252.75826 | 37.7823525456975 | -122.457907208857 | (37.7823525456975, -122.457907208857) | 11 | 6 | 1 | 54 | 31 | |
11450 | 93122 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | 5995895.24901 | 2113041.91566 | 37.7817741116959 | -122.457862824896 | (37.7817741116959, -122.457862824896) | 11 | 6 | 1 | 54 | 31 | |
11581 | 98091 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2X Frank Norris St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6007129.63323 | 2115568.12393 | 37.7893494826426 | -122.419176280756 | (37.7893494826426, -122.419176280756) | 13 | 9 | 10 | 28858 | 21 | ||
11807 | 70932 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 5988727.46903 | 2113517.26751 | 37.7826648905872 | -122.482694534783 | (37.7826648905872, -122.482694534783) | 11 | 6 | 2 | 55 | 26 | |||
11856 | 107887 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
12386 | 73495 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 5988730.14838 | 2113498.62278 | 37.7826138532986 | -122.482683898749 | (37.7826138532986, -122.482683898749) | 11 | 6 | 2 | 55 | 26 | |||
12599 | 93632 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 53266 | 5995882.07932 | 2113403.99303 | 37.7827675230466 | -122.457934595796 | (37.7827675230466, -122.457934595796) | 11 | 6 | 1 | 54 | 31 |
12918 | 42635 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 11:32:00 AM | 3 | 4x5 | Permit Number 42688 | 6005113.34773 | 2118824.42387 | 37.7981767035488 | -122.426384344263 | (37.7981767035488, -122.426384344263) | 13 | 9 | 1 | 57 | 17 |
12999 | 38424 | DPW Maintained 1 | Morus alba :: White Mulberry 246 | 1451 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/24/2005 12:00:00 AM | 12 | 3x3 | Permit Number 48015 | 6007280.79709 | 2117415.82487 | 37.7944313239892 | -122.418784361633 | (37.7944313239892, -122.418784361633) | 5 | 1 | 10 | 28858 | 32 |
13176 | 78329 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014093.60126 | 2094328.91133 | 37.7314209489083 | -122.39359445904 | (37.7314209489083, -122.39359445904) | 10 | 3 | 8 | 58 | 1 | ||
13195 | 78202 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 27 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014063.31576 | 2094176.73754 | 37.7310014277784 | -122.393688515509 | (37.7310014277784, -122.393688515509) | 10 | 3 | 8 | 58 | 1 | ||
13398 | 51356 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014174.8382 | 2094728.02379 | 37.7325213440762 | -122.393341524701 | (37.7325213440762, -122.393341524701) | 10 | 3 | 8 | 58 | 1 |
13407 | 42632 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 12:07:00 PM | 3 | 4x4 | Permit Number 42688 | 6005134.31421 | 2118828.07494 | 37.7981879136105 | -122.426312054082 | (37.7981879136105, -122.426312054082) | 13 | 9 | 1 | 57 | 17 |
13778 | 77659 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6006700.09662 | 2093328.78928 | 37.7282612330662 | -122.419084337666 | (37.7282612330662, -122.419084337666) | 9 | 3 | 7 | 309 | 5 | ||
14144 | 75133 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 125 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 4x4 | 6002899.19862 | 2092441.61812 | 37.7256104849218 | -122.432160858845 | (37.7256104849218, -122.432160858845) | 9 | 7 | 6 | 28861 | 5 | ||
14250 | 116051 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 650x Kansas St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 4x4 | 6011500.28754 | 2105307.13541 | 37.7614203394907 | -122.403332096897 | (37.7614203394907, -122.403332096897) | 10 | 3 | 8 | 28856 | 29 | ||
14433 | 76390 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006730.14725 | 2093235.82763 | 37.7280076727975 | -122.418973860459 | (37.7280076727975, -122.418973860459) | 9 | 3 | 7 | 309 | 5 | ||
14678 | 96770 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Lane St | 6 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12/08/2012 12:00:00 AM | 3 | 3x3 | 6015623.8599 | 2095148.9526 | 37.7337575287133 | -122.388361234061 | (37.7337575287133, -122.388361234061) | 10 | 3 | 8 | 58 | 1 | |
14697 | 76382 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1501X 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 25 | 3x12 | 5983091.4072 | 2104771.8049 | 37.7583228530818 | -122.501545408351 | (37.7583228530818, -122.501545408351) | 1 | 8 | 3 | 56 | 35 | ||
14855 | 75049 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6003005.92399 | 2092563.39586 | 37.7259509097926 | -122.431800609333 | (37.7259509097926, -122.431800609333) | 9 | 7 | 6 | 28861 | 5 | ||
14886 | 51359 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 50 Pomona St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014112.78564 | 2094416.99761 | 37.7316638818713 | -122.393534297068 | (37.7316638818713, -122.393534297068) | 10 | 3 | 8 | 58 | 1 |
15106 | 78327 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 20 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014087.33436 | 2094297.79766 | 37.7313351688787 | -122.393613948242 | (37.7313351688787, -122.393613948242) | 10 | 3 | 8 | 58 | 1 | ||
15357 | 98942 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400X San Bruno Ave | 6 | 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 | ||
15390 | 60892 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 940 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/11/1983 12:00:00 AM | 16 | 5x5 | Permit Number 20677 | 6008514.66964 | 2119698.45237 | 37.8007682484075 | -122.414676612845 | (37.8007682484075, -122.414676612845) | 5 | 1 | 10 | 308 | 32 |
15563 | 42636 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 11:48:00 AM | 3 | 4x5 | Permit Number 42688 | 6005181.30457 | 2118838.80185 | 37.7982200229931 | -122.426150217479 | (37.7982200229931, -122.426150217479) | 13 | 9 | 1 | 57 | 17 |
15783 | 78330 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 50 Pomona St | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014096.48223 | 2094344.10726 | 37.7314628339206 | -122.39358556205 | (37.7314628339206, -122.39358556205) | 10 | 3 | 8 | 58 | 1 | ||
15793 | 42348 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 7 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 3 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
16291 | 51365 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014154.93455 | 2094628.60419 | 37.7322472522973 | -122.393403381858 | (37.7322472522973, -122.393403381858) | 10 | 3 | 8 | 58 | 1 |
16535 | 78324 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 23 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014075.45071 | 2094231.93865 | 37.7311536731068 | -122.393650424725 | (37.7311536731068, -122.393650424725) | 10 | 3 | 8 | 58 | 1 | ||
17099 | 96505 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
17218 | 77646 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6006863.07514 | 2093156.65739 | 37.7277977728371 | -122.418508712231 | (37.7277977728371, -122.418508712231) | 9 | 3 | 7 | 309 | 5 | ||
17259 | 77657 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006712.15653 | 2093290.62233 | 37.7281571140509 | -122.41903993995 | (37.7281571140509, -122.41903993995) | 9 | 3 | 7 | 309 | 5 | ||
17590 | 73937 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4235 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/07/1990 12:00:00 AM | 10 | 3x3 | 6001944.69626247 | 2104668.40530987 | 37.7591282168027 | -122.436335144342 | (37.7591282168027, -122.436335144342) | 2 | 4 | 5 | 28862 | 3 | |
17940 | 42637 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 11:43:00 AM | 3 | 4x4 | Permit Number 42688 | 6005203.48268 | 2118840.06651 | 37.7982247489172 | -122.42607356464 | (37.7982247489172, -122.42607356464) | 13 | 9 | 1 | 57 | 17 |
18051 | 77661 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6006687.82384 | 2093371.12447 | 37.7283767851556 | -122.419129766951 | (37.7283767851556, -122.419129766951) | 9 | 3 | 7 | 309 | 5 | ||
18070 | 99372 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499X 29th Ave | 26 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3x3 | 5986859.5 | 2112566.5 | 37.7799454996166 | -122.489086903101 | (37.7799454996166, -122.489086903101) | 11 | 6 | 2 | 55 | 26 | ||
18124 | 95460 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986585.7747 | 2111417.7398 | 37.7767753504668 | -122.489949313769 | (37.7767753504668, -122.489949313769) | 11 | 6 | 2 | 55 | 26 |
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) );