27,746 rows where qCaretaker_id = 1 sorted by SiteOrder

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);