8,298 rows where qLegalStatus_id = 4

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)
1199 116255 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 155 LAGUNA ST 3 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
1219 122783 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 424 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6006739 2101281 37.7500984250046 -122.419513794578 (37.7500984250046, -122.419513794578) 2 4 7 28859 19
1229 264907 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 259 Clara St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
1232 264776 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 90x Guy Pl 10 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
1256 97187 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 9 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086) 12 2 9 28855 6
1361 105851 Undocumented 4 Tree(s) :: 17 2590 16TH AVE   Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991465.4 2097806.4 37.7396859298071 -122.472077039908 (37.7396859298071, -122.472077039908) 1 8 4 29491 40
1376 263620 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 3 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
1385 101200 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 502 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2           5994231.2 2106687.3 37.7642302811549 -122.463158383346 (37.7642302811549, -122.463158383346) 11 5 11 56 12
1436 256792 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 120 Cedar St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006815 2114489 37.7863687502832 -122.420188259313 (37.7863687502832, -122.420188259313) 13 9 10 28858 36
1442 103437 Undocumented 4 Podocarpus henkelii :: Long-Leafed Yellow-Wood 187 50X Bluxome St 14 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
1444 256097 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2 North Point St 15 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2020 12:12:00 PM 3 3x3   6010298.36751 2122029.07931 37.8072676263732 -122.408668755752 (37.8072676263732, -122.408668755752) 3 1 10 308 23
1477 112866 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 750 VICENTE ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990595 2097751 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927) 1 8 4 29491 40
1505 106993 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 160 HENRY ST 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002480.9 2107459.2 37.766821513471 -122.434680259747 (37.766821513471, -122.434680259747) 15 5 5 28862 3
1523 260685 Undocumented 4 Pinus radiata :: Monterey Pine 15 198X Miraloma Dr 2 Median : Yard Tree Private 2       10x10   5994595 2096392 37.7359829456919 -122.461153801837 (37.7359829456919, -122.461153801837) 9 8 4 59 40
1551 260493 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1799 Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2019 12:00:00 AM 3 3x3   6006327 2116970 37.7931534514646 -122.422052933674 (37.7931534514646, -122.422052933674) 13 9 10 28858 32
1574 122761 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 86X Park Hill Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001171 2107689 37.7673780360046 -122.439227450619 (37.7673780360046, -122.439227450619) 15 5 5 29492 3
1588 260075 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 171X Gellert Dr 1 Median : Yard Tree Private 2       3x3   5985371 2094678 37.7307416178434 -122.492918192866 (37.7307416178434, -122.492918192866) 1 8 4 64 35
1667 101664 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2X Daniel Burnham Ct 4 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1730 121323 Undocumented 4 Tree(s) :: 17 3699X Laguna St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003556 2121083 37.8042900105203 -122.431934584375 (37.8042900105203, -122.431934584375) 13 9 1 28858 17
1769 251583 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 75 Rice St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/30/1995 12:00:00 AM   3x3   5995352 2086409 37.7086155444167 -122.457814401925 (37.7086155444167, -122.457814401925) 9 7 6 28861 25
1778 262558 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 1801 03rd St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
1841 113206 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 50x DASHIELL HAMMETT ST 2 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6010410 2116139 37.7911011617465 -122.407866810246 (37.7911011617465, -122.407866810246) 5 1 10 28857 21
1914 116946 Undocumented 4 :: 45 3676 23RD ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005238 2102584 37.7535915013127 -122.424797029407 (37.7535915013127, -122.424797029407) 2 4 5 28859 19
1918 262485 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 500X Delta St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6009406 2087980 37.7137265813857 -122.409352565386 (37.7137265813857, -122.409352565386) 9 7 8 309 39
1922 260512 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 180 Stratford Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5990850 2091280 37.7217304489912 -122.473728831815 (37.7217304489912, -122.473728831815) 9 8 4 64 40
1942 113791 Undocumented 4 Ficus Spp. :: 101 1152 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008028 2101194 37.7499320627009 -122.415050188245 (37.7499320627009, -122.415050188245) 2 4 7 28859 19
1943 262553 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 1801 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
1948 113530 Undocumented 4 Prunus spp :: Flowering Plum 209 2598x 30TH AVE 3 Front Yard : Yard Tree Private 2       3x3   5987135 2097625 37.7389363086492 -122.487036198648 (37.7389363086492, -122.487036198648) 1 8 3 29491 35
1969 104927 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 810 Gonzalez Dr 2 Median : Yard Tree Private 2     10     5990385 2090588 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222) 1 8 4 64 14
2023 264805 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 600X Visitacion Ave 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6010564 2086911 37.7108561363482 -122.405274840324 (37.7108561363482, -122.405274840324) 9 7 8 309 39
2062 112894 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1x WEBSTER ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004219 2108568 37.7699645303419 -122.428747509741 (37.7699645303419, -122.428747509741) 7 9 5 28862 10
2069 116350 Undocumented 4 Privet :: 212 4051X 24TH ST 4 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   6002850 2101803 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035) 2 4 5 28862 22
2072 259693 Undocumented 4 Maytenus boaria :: Mayten 58 30 Lafayette St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007347 2109367 37.7723349336637 -122.417984438142 (37.7723349336637, -122.417984438142) 8 2 9 28853 19
2094 262557 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 1801 03rd St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
2101 117036 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2220x SUTTER ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001781 2114465 37.7860179225956 -122.437602866759 (37.7860179225956, -122.437602866759) 13 6 1 29490 27
2158 95238 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1220 Noe St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
2168 254831 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2800 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2018 02:34:00 PM 3 3x3   5996454 2087913 37.7128084296521 -122.454114323504 (37.7128084296521, -122.454114323504) 9 8 6 28861 24
2220 117168 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 299x ALMA ST 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   5997407 2106053 37.7626710894654 -122.452128484278 (37.7626710894654, -122.452128484278) 15 5 11 29492 9
2230 256764 Undocumented 4 Tree(s) :: 17 25 Serrano Dr 1 Sidewalk: Property side : Cutout Tree Private 2   09/25/2019 12:00:00 AM 3 6x6 Permit Number 782398 5990027 2090605 37.7198293671123 -122.476524410241 (37.7198293671123, -122.476524410241) 1 8 4 64 14
2258 264781 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 90x Guy Pl 15 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
2261 101055 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 760 Geary St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008077 2114493 37.7864507606031 -122.415822330961 (37.7864507606031, -122.415822330961) 13 1 9 28858 36
2279 264803 Undocumented 4 Acer buergeranum :: Trident Maple 110 99 Rutland St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010906 2089373 37.7176354050598 -122.404265973296 (37.7176354050598, -122.404265973296) 10 7 8 309 39
2280 116028 Undocumented 4 Ficus nitida :: Laurel Fig 53 1500 PACIFIC AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006937 2117734 37.7952855901943 -122.419996533467 (37.7952855901943, -122.419996533467) 13 9 10 28858 32
2335 262272 Undocumented 4 Tree(s) :: 17 99X Glendale St   Unaccepted Street : Yard Tree Private 2       3x3   5999984 2103563 37.7559814441149 -122.443036761048 (37.7559814441149, -122.443036761048) 2 5 5 28862 38
2343 99661 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1365 Portola Dr 2 Sidewalk: Curb side : Cutout Tree Private 2           5993416.2 2097683.7 37.7394617231066 -122.465323151466 (37.7394617231066, -122.465323151466) 1 8 4 59 40
2361 256460 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2901 Sunset Blvd 9 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
2369 117212 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 620x YORK ST 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6009734 2105398 37.7615710253283 -122.409447389709 (37.7615710253283, -122.409447389709) 2 4 8 28859 19
2398 262570 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 1801 03rd St 20 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
2436 102404 Undocumented 4 Tree(s) :: 17 95X Harriet St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6010704.6 2111649.2 37.7787897224959 -122.406530981243 (37.7787897224959, -122.406530981243) 14 2 9 28853 34
2450 251744 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 70 Winding Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002620 2086992 37.710631205907 -122.432736905509 (37.710631205907, -122.432736905509) 9 7 6 28861 5
2553 140071 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 601X Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005402 2111410 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543) 7 9 11 28852 10
2589 262566 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 1801 03rd St 16 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
2653 100053 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
2670 262494 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 41 Miraloma Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5994945 2097531 37.7391304944698 -122.4600262078 (37.7391304944698, -122.4600262078) 9 7 4 59 40
2733 107738 Undocumented 4 Tree(s) :: 17 155x HAYES ST 4 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2016 12:00:00 AM 3 3x3 Permit Number 774227 6007127.8 2111172.9 37.7772811641179 -122.41887077508 (37.7772811641179, -122.41887077508) 7 9 9 28852 36
2861 116035 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 280 GLENVIEW DR 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   5999243 2100752 37.748220848146 -122.445397263788 (37.748220848146, -122.445397263788) 2 5 5 63 38
2879 261758 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 49 Bache St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007215 2095432 37.7340651744382 -122.417453284567 (37.7340651744382, -122.417453284567) 2 7 7 28859 2
2911 258680 Undocumented 4 Potential Site :: Potential Site 48 2824 21st St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009247 2103976 37.7576392372832 -122.411031286576 (37.7576392372832, -122.411031286576) 2 4 7 28859 19
2913 264905 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 259 Clara St 3 Median : Cutout Tree DPW 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
2915 223666 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1511 Castro St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4   02/16/2016 05:50:00 AM 2 Width 3ft   6002610.0457 2101075.27233 37.7493001124297 -122.433777236447 (37.7493001124297, -122.433777236447) 2 4 5 28862 22
2944 97145 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2001X Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6008686.3 2106815.2 37.7654035712889 -122.413171184614 (37.7654035712889, -122.413171184614) 8 4 7 28859 19
2945 98684 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 40 Bay View St 1 Sidewalk: Curb side : Cutout Tree Private 2           6014207 2094775 37.7326521179743 -122.393233618799 (37.7326521179743, -122.393233618799) 10 3 8 58 1
2991 99574 Undocumented 4 Tree(s) :: 17 650X Brunswick St 16 Sidewalk: Curb side : Cutout Tree Private 2     4 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
3022 264768 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 90x Guy Pl 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
3033 121390 Undocumented 4 Shrub :: Shrub 66 1301x 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993851 2106604 37.7639796518152 -122.464467327674 (37.7639796518152, -122.464467327674) 1 8 11 56 12
3085 262583 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2801X 14th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992317 2097142 37.7379108993029 -122.469084256099 (37.7379108993029, -122.469084256099) 1 8 4 59 40
3101 99753 Undocumented 4 Tree(s) :: 17 526 Clipper St 2 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3 Permit Number 776170 6001772 2100900 37.748771266015 -122.436662665796 (37.748771266015, -122.436662665796) 2 4 5 28862 22
3144 113684 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 500X THE EMBARCADERO 18 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6013440 2119057 37.7992824654164 -122.3975877866 (37.7992824654164, -122.3975877866) 3 1 10 28860 6
3197 261564 Undocumented 4 Pinus radiata :: Monterey Pine 15 1801 25th St 9 Sidewalk: Property side : Yard Tree DPW 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
3300 113370 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 88 HOWARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014757 2116474 37.7922633974731 -122.39284966575 (37.7922633974731, -122.39284966575) 12 2 9 28855 6
3301 102850 Undocumented 4 Tree(s) :: 17 25X Guy Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x4   6014185 2114270 37.7861799368485 -122.394674400267 (37.7861799368485, -122.394674400267) 6 2 9 28855 6
3310 175373 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 10 Junipero Serra Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5991419.90979 2088711.03664 37.714709696259 -122.47157171488 (37.714709696259, -122.47157171488) 9 8 6 64 24
3312 102758 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1392 09TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5993422.3 2106025.2 37.7623656970292 -122.465908002531 (37.7623656970292, -122.465908002531) 1 8 11 56 12
3347 121153 Undocumented 4 Myoporum laetum :: Myoporum 62 50X Trumbull St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778630 6003754 2094198 37.7304815449788 -122.429331070998 (37.7304815449788, -122.429331070998) 9 7 6 28861 5
3419 259044 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 3649 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981832 2098708 37.7415992976029 -122.505451458513 (37.7415992976029, -122.505451458513) 1 8 3 29491 35
3496 98500 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1670 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990941.3 2104038.3 37.7567667631156 -122.474343775715 (37.7567667631156, -122.474343775715) 1 8 4 56 12
3509 99817 Undocumented 4 Schinus molle :: California Pepper 91 1134 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6002486 2102282 37.7526064609065 -122.434292449268 (37.7526064609065, -122.434292449268) 2 4 5 28862 22
3566 246019 Undocumented 4 Olea europaea :: Olive Tree 9 609 Clayton St 1 Sidewalk: Curb side : Pot Tree Private 2     16 Width 0ft   5998477.1179 2108551.0541 37.7695913556898 -122.448607268219 (37.7695913556898, -122.448607268219) 15 5 11 29492 9
3569 261071 Undocumented 4 Acer buergeranum :: Trident Maple 110 58 Latona St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6014335 2094330 37.7314373487466 -122.392759967745 (37.7314373487466, -122.392759967745) 10 3 8 58 1
3596 264801 Undocumented 4 Olea europaea :: Olive Tree 9 350 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011023 2089107 37.7169115603385 -122.403842847789 (37.7169115603385, -122.403842847789) 10 7 8 309 39
3606 262564 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 1801 03rd St 14 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
3645 254418 Undocumented 4 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1245x Ingalls St 12 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6017856 2093901 37.7304543311207 -122.380557270451 (37.7304543311207, -122.380557270451) 10 3 8 58 1
3669 103667 Undocumented 4 Tree(s) :: 17 350X Hickory St 6 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
3681 106711 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 3990 FOLSOM ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008366.1 2096547.2 37.7371919715517 -122.413552407719 (37.7371919715517, -122.413552407719) 2 7 7 28859 2
3697 114907 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 248 LOBOS ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5994525 2088748 37.7149903414399 -122.460842000428 (37.7149903414399, -122.460842000428) 9 8 6 28861 24
3723 260511 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 199X Stratford Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5990954 2091213 37.7215525064104 -122.47336445039 (37.7215525064104, -122.47336445039) 9 8 4 64 40
3728 264799 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 698 Dwight St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009708 2091117 37.7223570514359 -122.408529889307 (37.7223570514359, -122.408529889307) 10 3 7 309 28
3775 262460 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 88 06th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009992 2112469 37.7810008079546 -122.409054015659 (37.7810008079546, -122.409054015659) 14 2 9 28853 34
3790 262255 Undocumented 4 Tree(s) :: 17 4210 Ocean Ave 8 Sidewalk: Property side : Yard Tree Private 2   11/10/2020 12:00:00 AM 3 3x3 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
3800 261425 Undocumented 4 Tree(s) :: 17 1001 Potrero Ave 19 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
3804 117402 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
3825 263630 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1020 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000550 2112598 37.7808215534457 -122.441727743189 (37.7808215534457, -122.441727743189) 15 5 1 29490 16
3845 105016 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1099X 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2         Marked for a basin expansion. SB 6015050.3 2102960.5 37.755174615412 -122.390889970266 (37.755174615412, -122.390889970266) 10 3 8 28856 29
3863 113716 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 498x 21ST AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989370 2112285 37.7793187899318 -122.480381451803 (37.7793187899318, -122.480381451803) 11 6 2 55 26
3865 105892 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1100 Masonic Ave 3 Sidewalk: Curb side : Cutout Tree Private 2           5999444.5 2109060.1 37.7710443339737 -122.445297745357 (37.7710443339737, -122.445297745357) 15 5 11 29492 9
3872 262252 Undocumented 4 Pinus radiata :: Monterey Pine 15 4210 Ocean Ave 5 Sidewalk: Property side : Yard Tree Private 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
3950 230064 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 501 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007631.21664 2095734.29453 37.7349186191825 -122.416035690789 (37.7349186191825, -122.416035690789) 2 7 7 28859 2
3957 101709 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 95X Milton St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003767.7 2095277.7 37.7334469335284 -122.429360672359 (37.7334469335284, -122.429360672359) 2 7 5 28861 25
4013 264857 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 800x Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007181 2113695 37.7842092359088 -122.41886565636 (37.7842092359088, -122.41886565636) 7 9 9 28858 36
4070 262551 Undocumented 4 Melaleuca linariifolia :: Flaxleaf Paperbark 103 1835 Owens St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014708 2106994 37.7662307347547 -122.392355853292 (37.7662307347547, -122.392355853292) 14 3 9 310 29

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