27,746 rows where qCaretaker_id = 1 sorted by rowid descending

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)
194516 265149 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1201 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6006404 2114579 37.7865927014925 -122.421616611631 (37.7865927014925, -122.421616611631) 13 9 11 28858 41
194515 265162 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1699 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6006124 2116197 37.791019535338 -122.422700369292 (37.791019535338, -122.422700369292) 13 9 1 28858 27
194514 265151 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1201 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6006404 2114579 37.7865927014925 -122.421616611631 (37.7865927014925, -122.421616611631) 13 9 11 28858 41
194513 265163 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1699 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6006124 2116197 37.791019535338 -122.422700369292 (37.791019535338, -122.422700369292) 13 9 1 28858 27
194511 23411 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1790 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006198.56305 2116531.68812 37.7919427119246 -122.422466175278 (37.7919427119246, -122.422466175278) 13 9 10 28858 21
194509 134259 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1625 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     8 Width 4ft   6006170.6591 2116000.96505 37.7904839045708 -122.422524994529 (37.7904839045708, -122.422524994529) 13 9 1 28858 27
194506 134257 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1625 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 Width 4ft   6006160.66305 2116055.60858 37.7906333781701 -122.422563464854 (37.7906333781701, -122.422563464854) 13 9 1 28858 27
194505 134258 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1625 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 Width 4ft   6006165.05583 2116021.37931 37.7905396409395 -122.422545832742 (37.7905396409395, -122.422545832742) 13 9 1 28858 27
194503 265148 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1201 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6006404 2114579 37.7865927014925 -122.421616611631 (37.7865927014925, -122.421616611631) 13 9 11 28858 41
194498 265150 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1201 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6006404 2114579 37.7865927014925 -122.421616611631 (37.7865927014925, -122.421616611631) 13 9 11 28858 41
194484 27260 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1300X Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   6006404.26283 2115076.39725 37.7879584463594 -122.421651043279 (37.7879584463594, -122.421651043279) 13 9 10 28858 21
194480 265130 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 119X 07th St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/11/2021 12:00:00 AM 3 3x3   6009560.38235 2111747.77793 37.7789963145717 -122.410496258221 (37.7789963145717, -122.410496258221) 14 2 9 28853 34
194469 28912 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 119X 07th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/11/2021 12:00:00 AM 3 3x3   6009560.38235 2111747.77793 37.7789963145717 -122.410496258221 (37.7789963145717, -122.410496258221) 14 2 9 28853 34
194468 265112 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1300X Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1       3X3   6006404.26283 2115076.39725 37.7879584463594 -122.421651043279 (37.7879584463594, -122.421651043279) 13 9 10 28858 21
194445 24428 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1501 Franklin St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/20/1995 12:00:00 AM 3 3X3   6005809.51077 2115255.80256 37.7884174936216 -122.42372154163 (37.7884174936216, -122.42372154163) 13 9 1 28858 41
194444 4138 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 3550 Cesar Chavez St 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6006105.41199 2100602.05875 37.7481984995675 -122.421656565093 (37.7481984995675, -122.421656565093) 2 4 5 28859 19
194436 15776 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4804 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/08/2017 12:00:00 AM 3 3X3 Permit Number 773279 6001272.7685 2090814.9657 37.7210517172508 -122.437666839136 (37.7210517172508, -122.437666839136) 9 7 6 28861 25
194428 253435 DPW Maintained 1 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 793 Vienna St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/18/2017 11:49:00 AM 3     6002373 2088903 37.7158643806251 -122.433727084844 (37.7158643806251, -122.433727084844) 9 7 6 28861 5
194427 15775 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4808 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/08/2017 12:00:00 AM 3 3X3 Permit Number 773279 6001261.3736 2090797.0594 37.7210019026793 -122.437704946106 (37.7210019026793, -122.437704946106) 9 7 6 28861 25
194423 15800 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 4950 Mission St 8 Sidewalk: Curb side : Cutout Tree DPW 1   10/05/2018 02:11:00 PM 3 4x4   6000889.9210477 2090200.0223298 37.7193414459012 -122.438946180066 (37.7193414459012, -122.438946180066) 9 7 6 28861 25
194390 8397 DPW Maintained 1 Cupressocyparis leylandii :: Leyland Cypress 185 1500 Geary Blvd 8 Median : Cutout Tree DPW 1     18 8   6004036.9348 2113953.0096 37.7847401317276 -122.429761413143 (37.7847401317276, -122.429761413143) 13 9 11 29490 41
194380 255779 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 45 Niagara Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private 04/08/2017 12:00:00 AM 3 3x3   5999808 2089058 37.7161440949055 -122.442604012325 (37.7161440949055, -122.442604012325) 9 7 6 28861 25
194375 206127 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 207 Irving St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/11/2008 12:00:00 AM 4 Width 3ft   5995066.94571 2106670.30306 37.7642317209355 -122.460266565852 (37.7642317209355, -122.460266565852) 15 5 11 56 12
194371 205154 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 200 Irving St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/10/2008 12:00:00 AM 7 Width 3ft   5995104.98822 2106728.27185 37.7643930764078 -122.460139188574 (37.7643930764078, -122.460139188574) 15 5 11 56 12
194370 258049 DPW Maintained 1 Olea europaea 'Swan Hill' :: Olive 161 576 Union St 1 Sidewalk: Curb side : Cutout Tree DPW 1       5x6 Cross streets are also Jasper to Stockton; site is directly across from Via Ferlinghetti (alley) 6010185.99879 2119580.18301 37.8005372695328 -122.408884743211 (37.8005372695328, -122.408884743211) 3 1 10 308 23
194368 206128 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 207 Irving St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/11/2008 12:00:00 AM 2 Width 3ft   5995094.6325 2106669.72305 37.7642317209303 -122.46017076378 (37.7642317209303, -122.46017076378) 15 5 11 56 12
194366 265027 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2623 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private     3x3   5997622 2089116 37.7161784966097 -122.450164015076 (37.7161784966097, -122.450164015076) 9 8 6 28861 24
194361 265029 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2611 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 Private 12/05/1997 12:00:00 AM   3x3   5997671 2089167 37.7163213347739 -122.449998321991 (37.7163213347739, -122.449998321991) 9 8 6 28861 24
194348 265030 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2611 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private 12/05/1997 12:00:00 AM   3x3   5997671 2089167 37.7163213347739 -122.449998321991 (37.7163213347739, -122.449998321991) 9 8 6 28861 24
194340 265026 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2621 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private 11/07/2001 12:00:00 AM   3x3   5997640 2089142 37.7162509166522 -122.450103671662 (37.7162509166522, -122.450103671662) 9 8 6 28861 24
194323 264998 DPW Maintained 1 :: Tree 573 712 Francisco St   Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6007843 2120971 37.8042245839852 -122.417091095202 (37.8042245839852, -122.417091095202) 5 1 1 308 32
194317 264994 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 701 Irving St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/07/2020 12:00:00 AM 3 Width 3ft Permit Number 780527 5993564.21584 2106614.23574 37.7639912206449 -122.465459964506 (37.7639912206449, -122.465459964506) 1 8 11 56 12
194314 214535 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 701 Irving St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/07/2020 12:00:00 AM 3 Width 3ft Permit Number 780527 5993564.21584 2106614.23574 37.7639912206449 -122.465459964506 (37.7639912206449, -122.465459964506) 1 8 11 56 12
194310 264995 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 701 Irving St 3 Sidewalk: Curb side : Cutout Tree DPW 1   12/07/2020 12:00:00 AM 3 Width 3ft Permit Number 780527 5993564.21584 2106614.23574 37.7639912206449 -122.465459964506 (37.7639912206449, -122.465459964506) 1 8 11 56 12
194301 262312 DPW Maintained 1 Potential Site :: Potential Site 48 1425x Quint St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6013385 2096525 37.7374115554262 -122.396198099694 (37.7374115554262, -122.396198099694) 10 3 8 58 1
194286 171103 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1802 Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     0 Width 4ft Permit Number 785586 6001233.28844 2091580.94986 37.7231526917255 -122.437858144945 (37.7231526917255, -122.437858144945) 9 7 6 28861 25
194285 171104 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1802 Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     0 Width 4ft Permit Number 785586 6001222.88972 2091557.90636 37.7230888281699 -122.437892441496 (37.7230888281699, -122.437892441496) 9 7 6 28861 25
194284 4966 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5200X Diamond Heights Blvd 2 Median : Cutout Tree DPW 1   12/03/2018 12:00:00 AM 3 12   6000791.48606 2099581.9209 37.7450963646197 -122.439958774198 (37.7450963646197, -122.439958774198) 2 7 5 63 7
194280 171105 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1802 Alemany Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     0 Width 4ft Permit Number 785586 6001198.95061 2091509.82624 37.7229554497111 -122.437971751813 (37.7229554497111, -122.437971751813) 9 7 6 28861 25
194279 249475 DPW Maintained 1 Quercus suber :: Cork Oak 78 1200x Van Ness Ave 2 Median : Yard Tree DPW 1     18   Permit Number 787880 6006389.52859 2114780.40651 37.7871448980627 -122.421680989782 (37.7871448980627, -122.421680989782) 13 9 1 28858 21
194271 15783 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 4840 Mission St 3 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2015 03:01:00 PM 3 3X3 Permit Number 785142 6001146.6106 2090614.741 37.7204947713768 -122.43808859365 (37.7204947713768, -122.43808859365) 9 7 6 28861 25
194268 15788 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 4840 Mission St 8 Sidewalk: Curb side : Cutout Tree DPW 1   05/29/2020 12:00:00 AM 12 3X3 Permit Number 785142 6001054.6013 2090473.5841 37.7201019532463 -122.438396531841 (37.7201019532463, -122.438396531841) 9 7 6 28861 25
194266 15786 DPW Maintained 1 Washingtonia robusta :: Mexican Fan Palm 72 4840 Mission St 6 Sidewalk: Curb side : Cutout Tree DPW 1   03/04/2013 12:00:00 AM 12 3x3 Permit Number 785142 6001077.7653 2090502.844 37.7201836118857 -122.43831855702 (37.7201836118857, -122.43831855702) 9 7 6 28861 25
194263 15782 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 4840 Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/06/2015 12:38:00 PM 3 3X3 Permit Number 785142 6001159.6334 2090631.0194 37.7205402088092 -122.438044743528 (37.7205402088092, -122.438044743528) 9 7 6 28861 25
194261 15784 DPW Maintained 1 Washingtonia robusta :: Mexican Fan Palm 72 4840 Mission St 4 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2015 02:53:00 PM 3 3X3 Permit Number 785142 6001135.2157 2090596.8347 37.7204449566644 -122.438126700052 (37.7204449566644, -122.438126700052) 9 7 6 28861 25
194258 175137 DPW Maintained 1 Acer buergeranum :: Trident Maple 110 1802 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 Width 4ft Permit Number 785586 6001243.74865 2091600.63197 37.7232073291514 -122.437823395139 (37.7232073291514, -122.437823395139) 9 7 6 28861 25
194257 4968 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5200X Diamond Heights Blvd 4 Median : Cutout Tree DPW 1   12/03/2018 12:00:00 AM 3 12   6000815.91312 2099549.13893 37.7450077436274 -122.439871959934 (37.7450077436274, -122.439871959934) 2 7 5 63 7
194253 93351 DPW Maintained 1 Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 2100X Turk Blvd 34 Sidewalk: Curb side : Cutout Tree DPW 1   11/21/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771488 -122.443750351573 (37.779314771488, -122.443750351573) 15 5 1 29490 16
194248 1915 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 9 Bell Ct 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016631.8921901 2095265.2766477 37.7341327371653 -122.384884235042 (37.7341327371653, -122.384884235042) 10 3 8 58 1
194232 18350 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 459 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/08/2015 06:59:00 AM 3 3x3   6010395.85662 2106161.99214 37.7637058369709 -122.407212144541 (37.7637058369709, -122.407212144541) 8 4 8 28859 19
194226 20570 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1392X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree DPW 1     42 60   5984737.8310876 2105717.624989 37.7610163726955 -122.49592120853 (37.7610163726955, -122.49592120853) 1 8 3 56 35
194225 21968 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2580 03rd St 4 Sidewalk: Curb side : Cutout Tree DPW 1   01/27/1995 12:00:00 AM 3 3x3   6015815.49965 2103569.56022 37.7568893941329 -122.38828616762 (37.7568893941329, -122.38828616762) 10 3 8 28856 29
194223 14733 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 912X Laguna St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6004848.1679 2112085.98552 37.7796596496687 -122.426821804086 (37.7796596496687, -122.426821804086) 7 9 11 28852 41
194222 119595 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 431 Octavia St 1 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005470 2110737 37.7759908035691 -122.42457463067 (37.7759908035691, -122.42457463067) 7 9 11 28852 10
194215 14371 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2324 Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6002694.0419 2106348.375 37.7637835565652 -122.433863631274 (37.7637835565652, -122.433863631274) 15 4 5 28862 3
194214 17745 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1600X Pine St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006152.6648 2115617.75127 37.7894306797229 -122.422560011429 (37.7894306797229, -122.422560011429) 13 9 1 28858 41
194201 11511 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 101X Jennings St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 5   6018385.91854 2096547.1526 37.7377493756286 -122.378908940096 (37.7377493756286, -122.378908940096) 10 3 8 58 1
194193 108718 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1103 GOUGH ST 7 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005549.7 2113553.5 37.7837287235103 -122.424499312595 (37.7837287235103, -122.424499312595) 7 9 11 28858 41
194191 29620 DPW Maintained 1 Calocedrus decurrens :: Incense Cedar 206 900X Junipero Serra Blvd 29 Median : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   5991161.61567 2090864.54697 37.7206077605242 -122.472621393665 (37.7206077605242, -122.472621393665) 9 8 4 64 40
194188 96748 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 399X Liberty St 2 Sidewalk: Curb side : Cutout Tree DPW 1     4 1.5x2   6003700 2103889.2 37.7570882837734 -122.430208878023 (37.7570882837734, -122.430208878023) 2 4 5 28862 3
194184 449 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 700x 23rd Ave 9 Median : Cutout Tree DPW 1     12 8-HOA   5988819.75093 2110337.06115 37.7739383014913 -122.482142223603 (37.7739383014913, -122.482142223603) 11 6 2 55 26
194183 16195 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 482 Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5998892.4801472 2094730.9663599 37.7316685147685 -122.446176305405 (37.7316685147685, -122.446176305405) 9 7 4 59 40
194174 7713 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 101X Franklin St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/12/2005 12:00:00 AM 3 3x3   6006483.35851 2110441.04443 37.7752353575277 -122.421048133036 (37.7752353575277, -122.421048133036) 7 9 11 28852 10
194172 240286 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 5200x Diamond Heights Blvd 42 Median : Yard Tree DPW 1     2     6001709.51148 2098788.78469 37.7429708160432 -122.436727644972 (37.7429708160432, -122.436727644972) 2 7 5 63 7
194169 89654 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 3021 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/18/2008 12:00:00 AM 3 3x3   5989260.15494 2111906.26324 37.7782725005109 -122.480733712855 (37.7782725005109, -122.480733712855) 11 6 2 55 26
194161 23222 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 655X Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 4X4   6006626.36739 2112726.37233 37.7815183756303 -122.420715704793 (37.7815183756303, -122.420715704793) 7 9 11 28852 41
194159 10077 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 611 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6005621.78486 2105416.82041 37.7613914334809 -122.423671214664 (37.7613914334809, -122.423671214664) 2 4 5 28859 19
194158 22602 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 871 Turk St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6005851.84947 2112745.07106 37.7815260346282 -122.423396497843 (37.7815260346282, -122.423396497843) 7 9 11 28852 41
194140 2459 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1801X Buchanan St 7 Sidewalk: Curb side : Cutout Tree DPW 1   02/18/1998 12:00:00 AM 3 4X4   6003961.1396892 2114603.1916159 37.7865210759478 -122.430070036959 (37.7865210759478, -122.430070036959) 13 9 11 29490 27
194132 90370 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 401 Balboa St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/12/2008 12:00:00 AM 3 3x3   5994385.188155 2111417.285678 37.7772264433422 -122.462968981972 (37.7772264433422, -122.462968981972) 11 6 2 54 11
194124 254846 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 790 38th Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2018 12:00:00 AM 3 Width 4ft   5984182.54238 2110499.30676 37.774112974271 -122.498194837344 (37.774112974271, -122.498194837344) 11 6 2 55 26
194116 972 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1599 Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     20 4X4   6001888.30681 2092957.56794 37.7269697994111 -122.435692320241 (37.7269697994111, -122.435692320241) 9 7 6 28861 25
194105 2593 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1717 Bush St 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 4x4   6005272.31567 2115067.90207 37.7878712268979 -122.425566774536 (37.7878712268979, -122.425566774536) 13 9 11 28858 27
194083 4978 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 5200X Diamond Heights Blvd 14 Median : Cutout Tree DPW 1     48 12   6001055.51411 2099325.52296 37.7444073831894 -122.439027441656 (37.7444073831894, -122.439027441656) 2 7 5 63 7
194078 26818 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1310 Divisadero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6001324.9368 2112970.4697 37.7818883840034 -122.439073567606 (37.7818883840034, -122.439073567606) 15 5 11 29490 41
194072 29516 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1900X Ingalls St 7 Sidewalk: Curb side : Cutout Tree DPW 1   02/28/2006 12:00:00 AM 8 3x3   6016223.32775 2092631.55928 37.7268784667079 -122.386113243292 (37.7268784667079, -122.386113243292) 10 3 8 58 1
194069 9286 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 13X George Ct 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017208.5497632 2094048.0250587 37.7308222832509 -122.382805848563 (37.7308222832509, -122.382805848563) 10 3 8 58 1
194051 5069 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 5541 Diamond Heights Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6001780.21152 2097345.69555 37.7390124482591 -122.436379924815 (37.7390124482591, -122.436379924815) 2 7 5 63 7
194047 90783 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3701X Cabrillo St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5984061.67765 2110354.79455 37.7737090977378 -122.498602245888 (37.7737090977378, -122.498602245888) 11 6 2 55 26
194040 175614 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 100x Mansell St 10 Median : Cutout Tree DPW 1     12 Width 0ft   6011421.83278 2090628.04482 37.7211103133815 -122.402571168832 (37.7211103133815, -122.402571168832) 10 7 8 309 28
194033 212143 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 650x Miramar Ave 1 Median : Yard Tree DPW 1     3     5995395.28868 2093711.39383 37.7286686754144 -122.458192950462 (37.7286686754144, -122.458192950462) 9 7 4 28861 40
194025 13640 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 579 Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 4X4   6012428.77503 2115545.54355 37.7895844826841 -122.400840161846 (37.7895844826841, -122.400840161846) 12 2 9 28855 6
194016 18379 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 248 744 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/02/2005 12:00:00 AM 3 3X4   6010385.67998 2104816.8587 37.7600118348065 -122.407152518593 (37.7600118348065, -122.407152518593) 10 4 8 28859 19
194011 19212 DPW Maintained 1 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 710X Duboce Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/31/1998 12:00:00 AM 3 3X3   6002366.0960506 2108316.0051988 37.7691675719148 -122.435138635645 (37.7691675719148, -122.435138635645) 15 5 5 29492 9
194001 8648 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2800 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   5998383.6283 2113204.2346 37.782362442714 -122.449265934547 (37.782362442714, -122.449265934547) 15 6 1 54 31
193996 91442 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 900X Portola Dr 7 Median : Cutout Tree DPW 1   10/14/2005 12:00:00 AM   4x4   5996336.043197 2098916.600218 37.7430149203693 -122.455316749086 (37.7430149203693, -122.455316749086) 9 7 4 59 40
193994 90675 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3808 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5983782.70932 2110400.38504 37.7738179116671 -122.499570595637 (37.7738179116671, -122.499570595637) 11 6 2 55 26
193993 24013 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 393 West Portal Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   5991924.8305 2096676.2373 37.7366093650749 -122.470406255119 (37.7366093650749, -122.470406255119) 1 8 4 59 40
193945 2569 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1616 Bush St 2 Sidewalk: Curb side : Cutout Tree DPW 1     10 4X4   6005720.9755 2115211.89577 37.7882919383578 -122.424024736347 (37.7882919383578, -122.424024736347) 13 9 1 28858 41
193930 10418 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1219X Masonic Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 4X4   5999402.57096 2108712.61162 37.7700878253378 -122.445417788957 (37.7700878253378, -122.445417788957) 15 5 11 29492 9
193925 1427 DPW Maintained 1 Olea europaea :: Olive Tree 9 65 Arguello Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1     40 5X5PL   5995465.80895 2115602.75583 37.7887808090871 -122.459534003067 (37.7887808090871, -122.459534003067) 11 6 1 54 11
193924 14229 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2000X Market St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6004655.4793 2108222.1981 37.7690397355533 -122.427213099786 (37.7690397355533, -122.427213099786) 7 4 5 28862 3
193919 10634 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 830 Hayes St 3 Sidewalk: Curb side : Cutout Tree DPW 1   08/02/1990 12:00:00 AM 12 3X3   6003840.507 2110782.2115 37.7760227838468 -122.430214699132 (37.7760227838468, -122.430214699132) 7 9 11 29492 10
193914 115028 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1009 HARRISON ST 4 Sidewalk: Curb side : Cutout Tree DPW 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
193913 12078 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1241X La Salle Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017245.0743814 2094442.9323579 37.7319086387255 -122.382707045529 (37.7319086387255, -122.382707045529) 10 3 8 58 1
193910 85695 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 640 Howard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/30/2007 12:00:00 AM 3 3x3   6012881.28755 2114275.485576 37.7861224301769 -122.399185316932 (37.7861224301769, -122.399185316932) 12 2 9 28855 6
193897 90817 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3145 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5985785.77932 2110419.22548 37.7739869681874 -122.492643140314 (37.7739869681874, -122.492643140314) 11 6 2 55 26
193892 96142 DPW Maintained 1 Tree(s) :: 17 1468X Innes Ave 2 Median : Yard Tree DPW 1     12     6016228.8 2096740.9 37.738162198215 -122.386380713289 (37.738162198215, -122.386380713289) 10 3 8 58 1
193891 105837 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2100X SLOAT BLVD 4 Median : Yard Tree DPW 1     7     5984309 2095832 37.733848030924 -122.49667476772 (37.733848030924, -122.49667476772) 1 8 3 64 35
193872 18113 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1102X PORTOLA DR 2 Median : Cutout Tree DPW 1     24 10   5995249 2098057 37.7405922403942 -122.459013196083 (37.7405922403942, -122.459013196083) 1 7 4 59 40

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