trees
27,746 rows where qCaretaker_id = 1 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
87 | 259654 | DPW Maintained 1 | :: 45 | 101x Cora St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
90 | 259864 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1398x Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | |||||||||||||
894 | 260859 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 739 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985675.22385 | 2110852.85567 | 37.7751711283725 | -122.493057514378 | (37.7751711283725, -122.493057514378) | 11 | 6 | 2 | 55 | 26 | |||
927 | 260891 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 839 34th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985392.72943 | 2110161.55054 | 37.7732564760791 | -122.493983752439 | (37.7732564760791, -122.493983752439) | 11 | 6 | 2 | 55 | 26 | |||
1030 | 260915 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1307 Waller St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5999454.48308 | 2108393.47297 | 37.7692145145226 | -122.445215277932 | (37.7692145145226, -122.445215277932) | 15 | 5 | 11 | 29492 | 9 | |||
1298 | 91659 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1015 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007624.666917 | 2103742.941155 | 37.7569082017019 | -122.4166254819 | (37.7569082017019, -122.4166254819) | 2 | 4 | 7 | 28859 | 19 | |||
1593 | 259756 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1523 Innes Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015921.70632 | 2096895.74231 | 37.7385703600528 | -122.387453298811 | (37.7385703600528, -122.387453298811) | 10 | 3 | 8 | 58 | 1 | |||
2010 | 260603 | DPW Maintained 1 | Tree(s) :: 17 | 1162 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013406.09782 | 2090446.93369 | 37.7207235989971 | -122.395699409803 | (37.7207235989971, -122.395699409803) | 10 | 3 | 8 | 58 | 1 | |||
2090 | 260628 | DPW Maintained 1 | Tree(s) :: 17 | 1251 Revere Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6016934.60308 | 2092996.85523 | 37.7279208386687 | -122.383679778477 | (37.7279208386687, -122.383679778477) | 10 | 3 | 8 | 58 | 1 | |||
2122 | 259750 | DPW Maintained 1 | Tilia tomentosa :: Silver Linden 217 | 1631 La Salle Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015305.45247 | 2096307.05022 | 37.7369197808761 | -122.389542925227 | (37.7369197808761, -122.389542925227) | 10 | 3 | 8 | 58 | 1 | |||
2248 | 90191 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1860X Balboa St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989777.17693 | 2111298.44542 | 37.7766336380006 | -122.478900695137 | (37.7766336380006, -122.478900695137) | 11 | 6 | 2 | 55 | 26 | |||
2500 | 258153 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 546 Sanchez St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6003620.18216 | 2105099.99944 | 37.760408329171 | -122.430571313 | (37.760408329171, -122.430571313) | 2 | 4 | 5 | 28862 | 3 | ||||
2658 | 91806 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2945 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009025.873084 | 2101313.36822 | 37.7503158463726 | -122.411607913685 | (37.7503158463726, -122.411607913685) | 2 | 4 | 7 | 28859 | 19 | |||
2699 | 260850 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 590 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985681.12582 | 2111876.19139 | 37.7779812613037 | -122.493112500198 | (37.7779812613037, -122.493112500198) | 11 | 6 | 2 | 55 | 26 | |||
2770 | 260890 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 527 46th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5981596.48479 | 2112160.58463 | 37.7785223833836 | -122.507263579501 | (37.7785223833836, -122.507263579501) | 11 | 6 | 2 | 55 | 26 | |||
3354 | 258363 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 526 Silliman St | Sidewalk: Property side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009244.29167 | 2093882.64592 | 37.7299249505577 | -122.410328004922 | (37.7299249505577, -122.410328004922) | 9 | 3 | 7 | 309 | 28 | ||||
3379 | 258367 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 901 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | ||||||||||||||
3470 | 260424 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 751 Goettingen St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6010808.85842 | 2091198.73798 | 37.7226430782423 | -122.404730210147 | (37.7226430782423, -122.404730210147) | 10 | 3 | 7 | 309 | 28 | |||
3541 | 258357 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 446 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6009476.28698 | 2093953.76582 | 37.7301332328809 | -122.409530983744 | (37.7301332328809, -122.409530983744) | 9 | 3 | 7 | 309 | 28 | |||
3750 | 90460 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 786 25th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988216.47669 | 2110650.29112 | 37.7747632366882 | -122.484252000581 | (37.7747632366882, -122.484252000581) | 11 | 6 | 2 | 55 | 26 | |||
3782 | 259863 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1393 Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6011953.37624 | 2088478.22992 | 37.7152370172193 | -122.40058282589 | (37.7152370172193, -122.40058282589) | 10 | 7 | 8 | 309 | 39 | |||
3785 | 258385 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 101 University St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007919.90114 | 2093441.26607 | 37.7286386864609 | -122.414875367562 | (37.7286386864609, -122.414875367562) | 9 | 3 | 7 | 309 | 28 | ||||
3933 | 258362 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 520 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009260.75409 | 2093887.69259 | 37.7299397304564 | -122.410271448334 | (37.7299397304564, -122.410271448334) | 9 | 3 | 7 | 309 | 28 | ||||
4381 | 260219 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2162 24th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | 5988860.24203 | 2100615.01865 | 37.7472465592201 | -122.48129007726 | (37.7472465592201, -122.48129007726) | 1 | 8 | 3 | 29491 | 35 | |||
4399 | 260599 | DPW Maintained 1 | Tree(s) :: 17 | 1114 Hollister Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014272.04969 | 2090150.96276 | 37.7199590543715 | -122.392685364492 | (37.7199590543715, -122.392685364492) | 10 | 3 | 8 | 58 | 1 | |||
4492 | 260884 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 195 26th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5987712.04911 | 2114688.49303 | 37.7858216131413 | -122.486293421393 | (37.7858216131413, -122.486293421393) | 11 | 6 | 1 | 55 | 33 | |||
4636 | 260858 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 730 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985713.16819 | 2110906.59773 | 37.7753209078179 | -122.492930217758 | (37.7753209078179, -122.492930217758) | 11 | 6 | 2 | 55 | 26 | |||
4640 | 259372 | DPW Maintained 1 | Laurus x 'Saratoga' :: Hybrid Laurel 4 | 1495 Shafter Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6015477.8076 | 2093733.58604 | 37.7298631224309 | -122.388767411163 | (37.7298631224309, -122.388767411163) | 10 | 3 | 8 | 58 | 1 | |||
4879 | 260889 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 527 45th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5981905.91133 | 2112171.65096 | 37.7785709887537 | -122.506193994794 | (37.7785709887537, -122.506193994794) | 11 | 6 | 2 | 55 | 26 | |||
4924 | 259757 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1539 Innes Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015839.81008 | 2096956.81487 | 37.7387335166642 | -122.387740719291 | (37.7387335166642, -122.387740719291) | 10 | 3 | 8 | 58 | 1 | |||
4943 | 260913 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 482 Frederick St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5997348.59542 | 2107447.85511 | 37.7664976608583 | -122.452431145559 | (37.7664976608583, -122.452431145559) | 15 | 5 | 11 | 29492 | 9 | |||
4980 | 86291 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1339 25th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988318.888394 | 2106196.850699 | 37.7625412799726 | -122.483571174333 | (37.7625412799726, -122.483571174333) | 1 | 8 | 3 | 56 | 35 | |||
5082 | 258116 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2245 Jones St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6008057.63672 | 2120117.2159 | 37.8018923796488 | -122.416287818099 | (37.8018923796488, -122.416287818099) | 5 | 1 | 10 | 308 | 32 | ||||
5176 | 260916 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1726 Page St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5998303.71415 | 2108967.89528 | 37.7707259785013 | -122.449237098474 | (37.7707259785013, -122.449237098474) | 15 | 5 | 11 | 29492 | 9 | |||
5254 | 260218 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2162 24th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | 5988860.24203 | 2100615.01865 | 37.7472465592201 | -122.48129007726 | (37.7472465592201, -122.48129007726) | 1 | 8 | 3 | 29491 | 35 | |||
5607 | 260608 | DPW Maintained 1 | Tree(s) :: 17 | 1010 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014125.00477 | 2089910.99969 | 37.7192919954616 | -122.393176869863 | (37.7192919954616, -122.393176869863) | 10 | 3 | 8 | 58 | 1 | |||
5732 | 258358 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 341 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009791.92467 | 2094008.68962 | 37.7303017232085 | -122.408443651573 | (37.7303017232085, -122.408443651573) | 10 | 3 | 7 | 309 | 28 | ||||
6021 | 260882 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 810 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985734.50152 | 2110356.92333 | 37.7738129057539 | -122.492815926544 | (37.7738129057539, -122.492815926544) | 11 | 6 | 2 | 55 | 26 | |||
6189 | 260917 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1740 Page St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5998239.87383 | 2108958.8784 | 37.7706975687071 | -122.44945727244 | (37.7706975687071, -122.44945727244) | 15 | 5 | 11 | 29492 | 9 | |||
6410 | 91640 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1427 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007757.588641 | 2101343.923892 | 37.7503285203588 | -122.415995902486 | (37.7503285203588, -122.415995902486) | 2 | 4 | 7 | 28859 | 19 | |||
6422 | 260907 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2125 Lake St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5988893.20555 | 2114661.62902 | 37.7858166251674 | -122.482205030291 | (37.7858166251674, -122.482205030291) | 11 | 6 | 2 | 55 | 26 | |||
6695 | 260396 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Thornton Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | |||||||||||||
6875 | 260888 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 528 45th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5981946.38688 | 2112159.7169 | 37.7785406040131 | -122.50605309173 | (37.7785406040131, -122.50605309173) | 11 | 6 | 2 | 55 | 26 | |||
6891 | 260855 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 710 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985708.10427 | 2111037.07472 | 37.775678864326 | -122.492957347897 | (37.775678864326, -122.492957347897) | 11 | 6 | 2 | 55 | 26 | |||
7388 | 29904 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 580 Fell St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6004657.19551 | 2110576.88809 | 37.7755052392808 | -122.427374927138 | (37.7755052392808, -122.427374927138) | 7 | 9 | 11 | 28852 | 10 | ||||||
7425 | 260849 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 765 34th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985374.15255 | 2110672.13132 | 37.774657298519 | -122.494085649617 | (37.774657298519, -122.494085649617) | 11 | 6 | 2 | 55 | 26 | |||
7475 | 260914 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1165 Oak St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 6001427.67727 | 2109710.45692 | 37.7729430567741 | -122.438484490103 | (37.7729430567741, -122.438484490103) | 15 | 5 | 11 | 29492 | 9 | |||
7789 | 259629 | DPW Maintained 1 | :: 45 | 18 Arleta Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011290.10954 | 2087489.4095 | 37.7124849020689 | -122.402805875722 | (37.7124849020689, -122.402805875722) | 9 | 7 | 8 | 309 | 39 | |||
8192 | 258125 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 731 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6009632.88512 | 2091554.43402 | 37.7235539468335 | -122.408820391364 | (37.7235539468335, -122.408820391364) | 9 | 3 | 7 | 309 | 28 | |||
8317 | 260848 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 754 34th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985411.75213 | 2110738.83335 | 37.7748426432981 | -122.493960503851 | (37.7748426432981, -122.493960503851) | 11 | 6 | 2 | 55 | 26 | |||
8600 | 260856 | DPW Maintained 1 | Tree(s) :: 17 | 626 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5985689.47211 | 2111611.95975 | 37.7772562449138 | -122.493064158363 | (37.7772562449138, -122.493064158363) | 11 | 6 | 2 | 55 | 26 | |||||
8860 | 260613 | DPW Maintained 1 | Tree(s) :: 17 | 1271 Revere Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6016832.40592 | 2093073.03805 | 37.7281243722496 | -122.384038382899 | (37.7281243722496, -122.384038382899) | 10 | 3 | 8 | 58 | 1 | |||
8909 | 259799 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1345 Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6011890.92519 | 2088681.18109 | 37.7157907972077 | -122.400812935252 | (37.7157907972077, -122.400812935252) | 10 | 7 | 8 | 309 | 39 | |||
8911 | 87411 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 898X Ellis St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006570.640875 | 2113589.260791 | 37.7838845156579 | -122.420969775985 | (37.7838845156579, -122.420969775985) | 7 | 9 | 9 | 28858 | 36 | |||
9345 | 259797 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 568 Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6010803.65234 | 2092086.8288 | 37.7250813008862 | -122.404810700268 | (37.7250813008862, -122.404810700268) | 10 | 3 | 7 | 309 | 28 | |||
9380 | 259601 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1606 Newcomb Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015178 | 2095783 | 37.7354737780225 | -122.389946992713 | (37.7354737780225, -122.389946992713) | 10 | 3 | 8 | 58 | 1 | |||||
9408 | 259103 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 625 Visitacion Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6010501.76504 | 2086856.29359 | 37.7107024439005 | -122.405486089504 | (37.7107024439005, -122.405486089504) | 9 | 7 | 8 | 309 | 39 | |||
9454 | 260881 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 751 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985678.2622 | 2110774.56948 | 37.7749563544765 | -122.493041236092 | (37.7749563544765, -122.493041236092) | 11 | 6 | 2 | 55 | 26 | |||
9531 | 258361 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 508 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009293.67894 | 2093897.78594 | 37.7299692902001 | -122.410158335055 | (37.7299692902001, -122.410158335055) | 9 | 3 | 7 | 309 | 28 | ||||
9576 | 258366 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 816 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6008411.83681 | 2093627.45022 | 37.7291775379757 | -122.413187871426 | (37.7291775379757, -122.413187871426) | 9 | 3 | 7 | 309 | 28 | ||||
10043 | 264733 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1367 De Haro St | Median : Cutout | Tree | DPW 1 | 3x3 | 6012260 | 2102130 | 37.7527390251575 | -122.400481372119 | (37.7527390251575, -122.400481372119) | 10 | 3 | 8 | 28856 | 29 | |||||
10488 | 260919 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 630 Cole St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5997903.7812 | 2108434.36371 | 37.7692381539002 | -122.450581995995 | (37.7692381539002, -122.450581995995) | 15 | 5 | 11 | 29492 | 9 | |||
10535 | 258146 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1048 Folsom St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010642.12041 | 2111257.36423 | 37.7777103373451 | -122.406719502289 | (37.7777103373451, -122.406719502289) | 14 | 2 | 9 | 28853 | 34 | ||||
10744 | 260918 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 469 Frederick St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5997465.89984 | 2107424.38822 | 37.7664399466471 | -122.452023719463 | (37.7664399466471, -122.452023719463) | 15 | 5 | 11 | 29492 | 9 | |||
10747 | 260852 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 629 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/13/2020 12:00:00 AM | 3 | 5985649.89934 | 2111597.68044 | 37.7772147235644 | -122.493199999111 | (37.7772147235644, -122.493199999111) | 11 | 6 | 2 | 55 | 26 | |||
11282 | 258111 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1647 23rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5989010.97347 | 2104127.32105 | 37.756899168939 | -122.481025994257 | (37.756899168939, -122.481025994257) | 1 | 8 | 3 | 56 | 35 | ||||||
11533 | 259758 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1547 Innes Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015798.86195 | 2096987.35115 | 37.7388150947049 | -122.387884430038 | (37.7388150947049, -122.387884430038) | 10 | 3 | 8 | 58 | 1 | |||
11689 | 260606 | DPW Maintained 1 | Tree(s) :: 17 | 1038 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013981.83254 | 2090017.73229 | 37.7195771072229 | -122.393679232644 | (37.7195771072229, -122.393679232644) | 10 | 3 | 8 | 58 | 1 | |||
11835 | 259749 | DPW Maintained 1 | Tilia tomentosa :: Silver Linden 217 | 1611 La Salle Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015459.97414 | 2096191.98269 | 37.7366123953782 | -122.389000639089 | (37.7366123953782, -122.389000639089) | 10 | 3 | 8 | 58 | 1 | |||
11972 | 99201 | DPW Maintained 1 | Tree(s) :: 17 | 4016 26th St | Sidewalk: Curb side : Cutout | Landscaping | DPW 1 | FUF | 04/12/2012 12:00:00 AM | 6x10.5 | Permit Number 768835 | 6003752.7 | 2100736.7 | 37.7484352450997 | -122.429801769855 | (37.7484352450997, -122.429801769855) | 2 | 4 | 5 | 28862 | 22 | ||
12037 | 260602 | DPW Maintained 1 | Tree(s) :: 17 | 1152 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013444.93607 | 2090417.98033 | 37.7206462592683 | -122.395563129546 | (37.7206462592683, -122.395563129546) | 10 | 3 | 8 | 58 | 1 | |||
12682 | 260425 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 508 Dwight St | Unaccepted Street : Yard | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6010099.90949 | 2091269.80828 | 37.7227985719868 | -122.407185909529 | (37.7227985719868, -122.407185909529) | 10 | 3 | 7 | 309 | 28 | |||
12888 | 260885 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 639 32nd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985963.68769 | 2111543.65127 | 37.7770847226637 | -122.49211054124 | (37.7770847226637, -122.49211054124) | 11 | 6 | 2 | 55 | 26 | |||
12976 | 260626 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1546 Van Dyke Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014701.33267 | 2093312.36998 | 37.7286634818435 | -122.391422361758 | (37.7286634818435, -122.391422361758) | 10 | 3 | 8 | 58 | 1 | |||
13376 | 29902 | DPW Maintained 1 | Tree(s) :: 17 | 1716 Divisadero St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6001149.68281092 | 2114264.52722613 | 37.7854315611698 | -122.439772670022 | (37.7854315611698, -122.439772670022) | 15 | 6 | 1 | 29490 | 27 | ||||||
13632 | 258133 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 2579 29th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 5987367.52261 | 2097738.52962 | 37.7392615861063 | -122.486240585494 | (37.7392615861063, -122.486240585494) | 1 | 8 | 3 | 29491 | 35 | |||
13705 | 258131 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 290 Holyoke St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6009566.32704 | 2093048.73199 | 37.7276532465172 | -122.409155864667 | (37.7276532465172, -122.409155864667) | 10 | 3 | 7 | 309 | 28 | |||
14084 | 258134 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 131 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6011357.19142 | 2092082.52958 | 37.7251004206417 | -122.402896861649 | (37.7251004206417, -122.402896861649) | 10 | 3 | 7 | 309 | 28 | |||
14442 | 260627 | DPW Maintained 1 | Tree(s) :: 17 | 1557 Hudson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6015914.7542 | 2097249.1447 | 37.7395403460526 | -122.387501983912 | (37.7395403460526, -122.387501983912) | 10 | 3 | 8 | 58 | 1 | |||
14943 | 260853 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 626 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985689.47211 | 2111611.95975 | 37.7772562449138 | -122.493064158363 | (37.7772562449138, -122.493064158363) | 11 | 6 | 2 | 55 | 26 | |||
15168 | 259102 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 619 Visitacion Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6010517.89431 | 2086850.21293 | 37.7106866494876 | -122.405429914879 | (37.7106866494876, -122.405429914879) | 9 | 7 | 8 | 309 | 39 | |||
15172 | 260605 | DPW Maintained 1 | Tree(s) :: 17 | 1042 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013961.37936 | 2090032.97981 | 37.719617837314 | -122.393750999085 | (37.719617837314, -122.393750999085) | 10 | 3 | 8 | 58 | 1 | |||
15426 | 262040 | DPW Maintained 1 | Tree(s) :: 17 | 740 Jamestown Ave | Back Yard : Yard | Tree | DPW 1 | Private | 6015231.58289 | 2088478.1596 | 37.7154191081975 | -122.38925181324 | (37.7154191081975, -122.38925181324) | 10 | 3 | 8 | 58 | 1 | |||||
15558 | 91677 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 599 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007489.042117 | 2106191.625958 | 37.7636240956729 | -122.417268041752 | (37.7636240956729, -122.417268041752) | 8 | 4 | 7 | 28859 | 19 | |||
15648 | 260854 | DPW Maintained 1 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 543 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985630.75782 | 2112196.1258 | 37.7788567636192 | -122.493310315227 | (37.7788567636192, -122.493310315227) | 11 | 6 | 2 | 55 | 26 | |||
15680 | 91641 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1401X South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007749.533216 | 2101489.31094 | 37.7507272674606 | -122.416034053567 | (37.7507272674606, -122.416034053567) | 2 | 4 | 7 | 28859 | 19 | |||
15765 | 258114 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 22 Isis St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 6008329.87381 | 2108642.20827 | 37.7704000939468 | -122.414533279126 | (37.7704000939468, -122.414533279126) | 8 | 2 | 9 | 28853 | 19 | |||||
15796 | 260912 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99x Belvedere St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | |||||||||||||
16099 | 258126 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 839 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6009323.9018 | 2091459.72013 | 37.7232765705422 | -122.409881813505 | (37.7232765705422, -122.409881813505) | 9 | 3 | 7 | 309 | 28 | |||
16275 | 260607 | DPW Maintained 1 | Tree(s) :: 17 | 1026 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014043.19207 | 2089971.98975 | 37.71945491674 | -122.393463933828 | (37.71945491674, -122.393463933828) | 10 | 3 | 8 | 58 | 1 | |||
16306 | 260886 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 709 32nd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985981.28564 | 2111059.97075 | 37.7757577023633 | -122.492014045289 | (37.7757577023633, -122.492014045289) | 11 | 6 | 2 | 55 | 26 | |||
16722 | 258368 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 910 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6008141.55513 | 2093544.59332 | 37.7289348532082 | -122.414116401333 | (37.7289348532082, -122.414116401333) | 9 | 3 | 7 | 309 | 28 | ||||
17004 | 259318 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 Wisconsin St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6012713 | 2104246 | 37.7585743521834 | -122.399063317374 | (37.7585743521834, -122.399063317374) | 10 | 3 | 8 | 28856 | 29 | |||||
17164 | 258124 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 231 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6011067.40482 | 2091994.16139 | 37.7248415942661 | -122.403892413165 | (37.7248415942661, -122.403892413165) | 10 | 3 | 7 | 309 | 28 | |||
17248 | 260604 | DPW Maintained 1 | Tree(s) :: 17 | 1058 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013879.56666 | 2090093.96987 | 37.7197807571849 | -122.394038065566 | (37.7197807571849, -122.394038065566) | 10 | 3 | 8 | 58 | 1 | |||
17341 | 260857 | DPW Maintained 1 | Tree(s) :: 17 | 726 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985712.15541 | 2110932.69313 | 37.7753924991275 | -122.492935643751 | (37.7753924991275, -122.492935643751) | 11 | 6 | 2 | 55 | 26 | |||
17383 | 258113 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 144 Freelon St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 6013235.08289 | 2111410.77261 | 37.7782762981131 | -122.397760259133 | (37.7782762981131, -122.397760259133) | 6 | 2 | 9 | 28856 | 34 | |||||
17544 | 259759 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1563 Innes Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015716.96571 | 2097048.42371 | 37.7389782502581 | -122.388171852411 | (37.7389782502581, -122.388171852411) | 10 | 3 | 8 | 58 | 1 | |||
17942 | 258365 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 811 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6008440.06545 | 2093594.26657 | 37.7290880075188 | -122.413087936875 | (37.7290880075188, -122.413087936875) | 9 | 3 | 7 | 309 | 28 | ||||
18004 | 110212 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2978 CESAR CHAVEZ ST | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 3x4 | 6009700.7 | 2100638.5 | 37.7485006383082 | -122.409226689451 | (37.7485006383082, -122.409226689451) | 2 | 4 | 7 | 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) );