trees
194,517 rows sorted by Police Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1241 | 140612 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 880 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003492.8085 | 2111354.3072 | 37.777573917235 | -122.431458329369 | (37.777573917235, -122.431458329369) | 7 | 9 | 11 | 29492 | 10 | |||
1252 | 138873 | DPW Maintained 1 | Chitalpa tashkentensis :: 114 | 400 OCTAVIA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 5 | Width 0ft | 6005564.9563 | 2110783.2259 | 37.7761230908013 | -122.42424943998 | (37.7761230908013, -122.42424943998) | 7 | 9 | 11 | 28852 | 10 | ||
1267 | 244161 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 441 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004421.3191 | 2109776.7375 | 37.7732948782123 | -122.428133844936 | (37.7732948782123, -122.428133844936) | 7 | 9 | 11 | 28852 | 10 | |||
1290 | 125914 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 1401 Broadway | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006770.3381 | 2117989.04828 | 37.7959764977783 | -122.420591325329 | (37.7959764977783, -122.420591325329) | 13 | 9 | 10 | 28858 | 32 | |||
1292 | 102259 | DPW Maintained 1 | Tree(s) :: 17 | 904 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2013 12:00:00 AM | 9 | 3x3 | Permit Number 769677 | 6003013.4 | 2111448.1 | 37.7778042661218 | -122.433123466086 | (37.7778042661218, -122.433123466086) | 15 | 9 | 11 | 29492 | 41 | |
1296 | 114159 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 2250 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770124 | 6002793.85496 | 2117859.65506 | 37.7953963109343 | -122.434341453993 | (37.7953963109343, -122.434341453993) | 13 | 9 | 1 | 57 | 17 | |
1308 | 52427 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1815X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48544 | 6004786.32091155 | 2115731.58720361 | 37.7896660673411 | -122.427295522794 | (37.7896660673411, -122.427295522794) | 13 | 9 | 11 | 28858 | 27 |
1311 | 23384 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1451X Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6006248.25114 | 2115440.18145 | 37.7889485091226 | -122.42221667202 | (37.7889485091226, -122.42221667202) | 13 | 9 | 1 | 28858 | 41 | |||
1329 | 124750 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 566 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004650.035 | 2110687.35997 | 37.7758081630602 | -122.42740756863 | (37.7758081630602, -122.42740756863) | 7 | 9 | 11 | 28852 | 10 | |||
1341 | 76159 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
1362 | 244521 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 577 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003849.83 | 2109698.0755 | 37.7730465408764 | -122.430105090767 | (37.7730465408764, -122.430105090767) | 7 | 9 | 11 | 29492 | 10 | |||
1379 | 19129 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 25 Sanchez St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2009 12:00:00 AM | 3 | 3X4 | 6003497.27744 | 2108239.16815 | 37.7690207646335 | -122.431220458483 | (37.7690207646335, -122.431220458483) | 7 | 9 | 5 | 28862 | 3 | ||
1383 | 260901 | DPW Maintained 1 | Populus alba :: White Poplar 184 | 1599 Steiner St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Width 0ft | 6002672 | 2113572 | 37.7836165897996 | -122.434456380093 | (37.7836165897996, -122.434456380093) | 13 | 9 | 11 | 29490 | 41 | ||||
1388 | 49516 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1910 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Permit Number 46422 | 6002507.7627 | 2114881.9371 | 37.7872040200664 | -122.435118299397 | (37.7872040200664, -122.435118299397) | 13 | 9 | 11 | 29490 | 27 | |||
1400 | 23567 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2975 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/27/1992 12:00:00 AM | 3 | 3X3 | 6005531.33723 | 2120589.48411 | 37.8030467266869 | -122.425063628702 | (37.8030467266869, -122.425063628702) | 13 | 9 | 1 | 28858 | 17 | ||
1405 | 96265 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2776 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/2011 12:00:00 AM | Permit Number 767311 | 6004841.3 | 2119075.5 | 37.798850712467 | -122.427343605274 | (37.798850712467, -122.427343605274) | 13 | 9 | 1 | 57 | 17 | |||
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 | ||||
1453 | 23301 | DPW Maintained 1 | Eucalyptus melliodora :: Yellow Box 188 | 950X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006575.9602707 | 2113798.8129121 | 37.7844601942992 | -122.420966256023 | (37.7844601942992, -122.420966256023) | 7 | 9 | 9 | 28858 | 36 | |||
1464 | 130824 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2451 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004088.29924 | 2117192.3041 | 37.7936373242572 | -122.429814838808 | (37.7936373242572, -122.429814838808) | 13 | 9 | 1 | 29490 | 27 | |||
1493 | 264741 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 2040 Sutter St | 2 | Back Yard : Yard | Tree | Private 2 | 6002832.74822 | 2114456.05498 | 37.7860531044459 | -122.433963466929 | (37.7860531044459, -122.433963466929) | 13 | 9 | 11 | 29490 | 27 | |||||
1494 | 21556 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1409 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005783.75363 | 2114822.50195 | 37.7872263038018 | -122.423779835692 | (37.7872263038018, -122.423779835692) | 13 | 9 | 1 | 28858 | 41 | |||
1496 | 103826 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1000 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006957.18445 | 2114384.03926 | 37.7860885642674 | -122.419688886254 | (37.7860885642674, -122.419688886254) | 13 | 9 | 9 | 28858 | 36 | ||
1518 | 99500 | Permitted Site 7 | Aesculus hippocastanum :: White Horsechestnut 190 | 2698@Divisadero Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000656 | 2117555 | 37.7944382299983 | -122.441716891944 | (37.7944382299983, -122.441716891944) | 13 | 9 | 1 | 57 | 27 | |||||
1521 | 244457 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 690 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003333.6569 | 2109668.6973 | 37.7729366277203 | -122.43188849891 | (37.7729366277203, -122.43188849891) | 15 | 9 | 11 | 29492 | 10 | |||
1541 | 70231 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6005265.5585 | 2110935.6138 | 37.7765246008409 | -122.425295984643 | (37.7765246008409, -122.425295984643) | 7 | 9 | 11 | 28852 | 10 | |||
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 | ||
1554 | 129221 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2711 Vallejo St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6000567.88231 | 2117494.00338 | 37.7942657282202 | -122.442017408682 | (37.7942657282202, -122.442017408682) | 13 | 9 | 1 | 57 | 27 | |||
1557 | 33639 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 440 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 5 | Permit Number 37734 | 6005272.3664 | 2110799.1387 | 37.7761502580876 | -122.425262720434 | (37.7761502580876, -122.425262720434) | 7 | 9 | 11 | 28852 | 10 | |
1590 | 130502 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1971 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5999816.57477 | 2121214.69005 | 37.8044388979007 | -122.444884593948 | (37.8044388979007, -122.444884593948) | 13 | 9 | 1 | 57 | 17 | |||
1592 | 262226 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1970 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6002649 | 2114114 | 37.7851034789316 | -122.434574718683 | (37.7851034789316, -122.434574718683) | 13 | 9 | 11 | 29490 | 13 | ||||
1614 | 140208 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 708 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003569 | 2110758 | 37.7759409231905 | -122.431152184499 | (37.7759409231905, -122.431152184499) | 7 | 9 | 11 | 29492 | 10 | |||
1627 | 35149 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 11 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38681 | 6004664.75137838 | 2109286.2995173 | 37.7719620248453 | -122.427256837171 | (37.7719620248453, -122.427256837171) | 7 | 9 | 11 | 28852 | 10 | ||
1656 | 125137 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2645 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000115.81749 | 2117703.18818 | 37.7948143227728 | -122.443596633488 | (37.7948143227728, -122.443596633488) | 13 | 9 | 1 | 57 | 27 | |||
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 | |||
1672 | 9818 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005621.8341 | 2113520.56064 | 37.783642353453 | -122.424247412091 | (37.783642353453, -122.424247412091) | 7 | 9 | 11 | 28858 | 41 | |||
1690 | 52430 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2536 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 12 | Permit Number 48545 | 6002701.73302 | 2117006.28973 | 37.7930479607542 | -122.434599161948 | (37.7930479607542, -122.434599161948) | 13 | 9 | 1 | 29490 | 27 | |
1696 | 12442 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004358.0388014 | 2115316.8218262 | 37.788502995764 | -122.428747755973 | (37.788502995764, -122.428747755973) | 13 | 9 | 11 | 29490 | 27 | |||
1699 | 5933 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1355 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/1990 12:00:00 AM | 3 | 4X4 | 6004029.33456 | 2112693.29822 | 37.781280848415 | -122.429697830179 | (37.781280848415, -122.429697830179) | 7 | 9 | 11 | 29490 | 41 | ||
1724 | 134353 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 826 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006643.13761 | 2113330.8233 | 37.7831789957579 | -122.420700610947 | (37.7831789957579, -122.420700610947) | 7 | 9 | 9 | 28858 | 36 | |||
1727 | 249457 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Olive St | 2 | : | Tree | Private 2 | 11 | Width 4ft | 6006319.82833 | 2113698.46294 | 37.7841702168319 | -122.421845255461 | (37.7841702168319, -122.421845255461) | 7 | 9 | 11 | 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 | ||||
1746 | 136062 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1776 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006341.69714 | 2116340.45076 | 37.7914256952996 | -122.421957338886 | (37.7914256952996, -122.421957338886) | 13 | 9 | 10 | 28858 | 21 | |||
1748 | 56640 | Permitted Site 7 | Tree(s) :: 17 | 2016 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004277.89575757 | 2115357.17634953 | 37.7886092629589 | -122.429027916831 | (37.7886092629589, -122.429027916831) | 13 | 9 | 11 | 29490 | 27 | |||||
1765 | 73918 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 740 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6004497.3871 | 2111109.5855 | 37.776958856214 | -122.42796571067 | (37.776958856214, -122.42796571067) | 7 | 9 | 11 | 28852 | 10 | |||
1808 | 134289 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2416 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6004999.06299 | 2117994.49764 | 37.7958914767778 | -122.426720670937 | (37.7958914767778, -122.426720670937) | 13 | 9 | 1 | 28858 | 27 | |||
1811 | 258532 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1565 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 777683 | 6006695.00356 | 2117330.6469 | 37.7941644464503 | -122.420805231935 | (37.7941644464503, -122.420805231935) | 13 | 9 | 10 | 28858 | 32 | |
1828 | 98097 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 81 Frank Norris St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006875.6654 | 2115508.14993 | 37.7891705031567 | -122.420050723983 | (37.7891705031567, -122.420050723983) | 13 | 9 | 10 | 28858 | 21 | |||
1862 | 23733 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X Webster St | 8 | Median : Cutout | Tree | DPW 1 | 35 | 20 | 6003923.026 | 2111743.9893 | 37.7786682616238 | -122.429997867276 | (37.7786682616238, -122.429997867276) | 7 | 9 | 11 | 29490 | 41 | |||
1888 | 29108 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 765 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2018 12:59:00 PM | 3 | 3x3 | 6007194.65596 | 2113631.10211 | 37.7840345567841 | -122.418813878265 | (37.7840345567841, -122.418813878265) | 7 | 9 | 9 | 28858 | 36 | ||
1889 | 259158 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x | 6004817 | 2110376 | 37.7749626863145 | -122.426807815207 | (37.7749626863145, -122.426807815207) | 7 | 9 | 11 | 28852 | 10 | ||||
1896 | 17856 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2121 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2000 12:00:00 AM | 10 | 3X3 | 6003596.6138 | 2115206.3541 | 37.7881565558045 | -122.431374278321 | (37.7881565558045, -122.431374278321) | 13 | 9 | 11 | 29490 | 27 | ||
1900 | 141936 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1101 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 10/12/1994 12:00:00 AM | 8 | Width 0ft | 6003954.1428 | 2112136.7195 | 37.7797483635991 | -122.429918243479 | (37.7797483635991, -122.429918243479) | 7 | 9 | 11 | 29490 | 41 | ||
1913 | 140032 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 855 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005092.0233 | 2111947.5572 | 37.7792933441417 | -122.4259683453 | (37.7792933441417, -122.4259683453) | 7 | 9 | 11 | 28852 | 41 | |||
1924 | 96221 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 170 Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2015 09:36:00 AM | 3 | 3x3 | 6006663 | 2110979.9 | 37.7767250501872 | -122.420464968339 | (37.7767250501872, -122.420464968339) | 7 | 9 | 11 | 28852 | 10 | ||
1925 | 250092 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1698 Gough St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6005353.59952 | 2115427.24795 | 37.7888624934521 | -122.425311128409 | (37.7888624934521, -122.425311128409) | 13 | 9 | 1 | 28858 | 41 | |||
1966 | 61296 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2360 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1986 12:00:00 AM | 9 | Permit Number 23055 | 6006748.00387 | 2119357.01746 | 37.7997313381808 | -122.420765770421 | (37.7997313381808, -122.420765770421) | 5 | 9 | 1 | 28858 | 32 | |
1990 | 132531 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2201 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000159.7629 | 2120220.59264 | 37.8017289527983 | -122.443625508009 | (37.8017289527983, -122.443625508009) | 13 | 9 | 1 | 57 | 17 | |||
2005 | 23894 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1581 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:37:00 AM | 3 | 3X3 | 6003529.5219 | 2114142.2135 | 37.7852308919409 | -122.431530405312 | (37.7852308919409, -122.431530405312) | 13 | 9 | 11 | 29490 | 13 | ||
2011 | 264734 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1364 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006427.83864 | 2119405.514 | 37.7998464469137 | -122.42187710854 | (37.7998464469137, -122.42187710854) | 13 | 9 | 1 | 28858 | 32 | |||||
2038 | 8035 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005070.3181 | 2111601.5224 | 37.7783419907871 | -122.426018792814 | (37.7783419907871, -122.426018792814) | 7 | 9 | 11 | 28852 | 10 | |||
2052 | 13108 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1557 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3x3 | 6004929.5061 | 2119810.12 | 37.8008727786968 | -122.427090735634 | (37.8008727786968, -122.427090735634) | 13 | 9 | 1 | 57 | 17 | |||
2053 | 9801 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1010 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6005681.92309 | 2113158.17696 | 37.7826507298416 | -122.424013748222 | (37.7826507298416, -122.424013748222) | 7 | 9 | 11 | 28858 | 41 | |||
2056 | 5946 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1415 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003699.8521 | 2112803.046 | 37.7815635260957 | -122.430845511676 | (37.7815635260957, -122.430845511676) | 15 | 9 | 11 | 29490 | 41 | |||
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 | ||||
2077 | 2574 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1660 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/31/2017 10:41:00 AM | 3 | 4x4 | 6005572.29299 | 2115192.6753 | 37.788230768278 | -122.424537786114 | (37.788230768278, -122.424537786114) | 13 | 9 | 1 | 28858 | 41 | ||
2098 | 113076 | DPW Maintained 1 | Howea forsteriana :: Kentia Palm 214 | 3456 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2015 12:00:00 AM | 6 | 3x3 | Permit Number 775955 | 5999268.84985 | 2120685.32695 | 37.8029541360916 | -122.446741924202 | (37.8029541360916, -122.446741924202) | 13 | 9 | 1 | 57 | 17 | |
2104 | 132472 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2901 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6001487.88028 | 2118402.43157 | 37.7968124185064 | -122.438899249622 | (37.7968124185064, -122.438899249622) | 13 | 9 | 1 | 57 | 17 | |||
2115 | 125373 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2820 Van Ness Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6005714.14628 | 2120095.1224 | 37.8016996609768 | -122.424395829926 | (37.8016996609768, -122.424395829926) | 5 | 9 | 1 | 28858 | 32 | |||
2121 | 110341 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 564 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6005076.8079 | 2111304.1554 | 37.7775258606118 | -122.425975168518 | (37.7775258606118, -122.425975168518) | 7 | 9 | 11 | 28852 | 10 | |||
2131 | 140415 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100x WEBSTER ST | 7 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6003782.7679 | 2112770.1424 | 37.7814778785376 | -122.430556314217 | (37.7814778785376, -122.430556314217) | 15 | 9 | 11 | 29490 | 41 | |||
2137 | 134250 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1851 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006058.4702 | 2116853.96653 | 37.7928197038277 | -122.422973813809 | (37.7928197038277, -122.422973813809) | 13 | 9 | 1 | 28858 | 27 | |||
2145 | 140433 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 Turk St | 12 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 15 | Width 0ft | 6003251.7396 | 2112391.1099 | 37.7804070531695 | -122.432366335522 | (37.7804070531695, -122.432366335522) | 15 | 9 | 11 | 29490 | 41 | |||
2152 | 33675 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 469 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 13 | Permit Number 37757 | 6005116.23557125 | 2111084.96150687 | 37.7769262359606 | -122.425823168919 | (37.7769262359606, -122.425823168919) | 7 | 9 | 11 | 28852 | 10 | |
2172 | 53666 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1630 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/1969 12:00:00 AM | 17 | 3x3 | Permit Number 772472 | 6006654.5213 | 2116532.6022 | 37.7919709328888 | -122.420888619402 | (37.7919709328888, -122.420888619402) | 13 | 9 | 10 | 28858 | 21 |
2208 | 8032 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005001.9506 | 2111591.9082 | 37.7783117284071 | -122.426254616894 | (37.7783117284071, -122.426254616894) | 7 | 9 | 11 | 28852 | 10 | |||
2209 | 134782 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2222 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006396 | 2118554 | 37.7975066091486 | -122.421926761206 | (37.7975066091486, -122.421926761206) | 13 | 9 | 10 | 28858 | 32 | |||
2222 | 20236 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 1750X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/1992 12:00:00 AM | 6 | 4X4 | 6002603.6550052 | 2114233.7432168 | 37.7854296891778 | -122.434740163706 | (37.7854296891778, -122.434740163706) | 13 | 9 | 11 | 29490 | 13 | ||
2235 | 16944 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 599X Oak St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
2251 | 143510 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2026 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2006 12:00:00 AM | 14 | Width 0ft | Permit Number 48982 | 6003323.1573 | 2118630.9053 | 37.797543994409 | -122.432565097779 | (37.797543994409, -122.432565097779) | 13 | 9 | 1 | 57 | 17 | |
2257 | 134060 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2434 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6001939.59837 | 2117387.98791 | 37.7940527103301 | -122.43726352939 | (37.7940527103301, -122.43726352939) | 13 | 9 | 1 | 57 | 27 | |||
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 | ||||
2288 | 50724 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3110 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2004 12:00:00 AM | 2 | Permit Number 47275 | 6001439.94101 | 2119110.04202 | 37.798752603299 | -122.439115871123 | (37.798752603299, -122.439115871123) | 13 | 9 | 1 | 57 | 17 | |
2294 | 84947 | Permitted Site 7 | Tree(s) :: 17 | 1812 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003475 | 2114918 | 37.7873579154126 | -122.431774444579 | (37.7873579154126, -122.431774444579) | 13 | 9 | 11 | 29490 | 27 | |||||
2317 | 129136 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2500 Chestnut St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 5999820.13203 | 2119534.7646 | 37.7998264765557 | -122.444751458338 | (37.7998264765557, -122.444751458338) | 13 | 9 | 1 | 57 | 17 | |||
2333 | 246547 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 4ft | 6005744.74711 | 2109415.26549 | 37.7723771523117 | -122.423530217156 | (37.7723771523117, -122.423530217156) | 7 | 9 | 11 | 28852 | 10 | |||
2345 | 59877 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2125 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1981 12:00:00 AM | 11 | Permit Number 19342 | 6002756.67005 | 2118848.34018 | 37.7981088730742 | -122.434540847196 | (37.7981088730742, -122.434540847196) | 13 | 9 | 1 | 57 | 17 | |
2346 | 114557 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2775 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5999783.32875 | 2117736.28966 | 37.7948862424707 | -122.444749467237 | (37.7948862424707, -122.444749467237) | 13 | 9 | 1 | 57 | 27 | |||
2350 | 132920 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2311 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6002441.57111 | 2117401.95011 | 37.7941195695148 | -122.435527653476 | (37.7941195695148, -122.435527653476) | 13 | 9 | 1 | 29490 | 27 | |||
2353 | 229453 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 500 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004612.82375 | 2110259.96619 | 37.7746325395952 | -122.427505836641 | (37.7746325395952, -122.427505836641) | 7 | 9 | 11 | 28852 | 10 | |||
2376 | 57631 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 724 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1976 12:00:00 AM | 8 | Permit Number 16529 | 6004511.94268 | 2110995.61836 | 37.7766467538829 | -122.427907235555 | (37.7766467538829, -122.427907235555) | 7 | 9 | 11 | 28852 | 10 | |
2390 | 143239 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 986 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6006984.4971 | 2114185.2189 | 37.7855441907656 | -122.41958028036 | (37.7855441907656, -122.41958028036) | 13 | 9 | 9 | 28858 | 36 | |||
2395 | 224762 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 301 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004982.47318 | 2110039.87008 | 37.7740491098102 | -122.426211472077 | (37.7740491098102, -122.426211472077) | 7 | 9 | 11 | 28852 | 10 | |||
2422 | 80046 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2325 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6001817.74148 | 2118715.85745 | 37.7976917657091 | -122.437780314931 | (37.7976917657091, -122.437780314931) | 13 | 9 | 1 | 57 | 17 | |||
2426 | 100409 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 201 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006409.6 | 2110870.2 | 37.7764095571607 | -122.421333763494 | (37.7764095571607, -122.421333763494) | 7 | 9 | 11 | 28852 | 10 | |||
2435 | 129307 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2363 Larkin St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 6006689.73885 | 2119362.09742 | 37.7997420023389 | -122.420967750079 | (37.7997420023389, -122.420967750079) | 13 | 9 | 1 | 28858 | 32 | |||
2440 | 79187 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 45 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2019 12:00:00 AM | 3 | 3x3 | Permit Number 50829 | 6001057.44461 | 2119906.39281 | 37.8009174000823 | -122.440496575066 | (37.8009174000823, -122.440496575066) | 13 | 9 | 1 | 57 | 17 | |
2456 | 260910 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 241 Laussat St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6003564.7514 | 2109147.66361 | 37.7715190947724 | -122.431051921008 | (37.7715190947724, -122.431051921008) | 15 | 9 | 11 | 29492 | 10 | ||||
2465 | 133092 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1380 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | Width 3ft | 6006306.20218 | 2119734.15962 | 37.800741963924 | -122.422321379938 | (37.800741963924, -122.422321379938) | 13 | 9 | 1 | 28858 | 32 | ||
2484 | 20118 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 875X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1992 12:00:00 AM | 12 | 2X2 | 6003233.15229 | 2110304.12624 | 37.774675660821 | -122.432281545934 | (37.774675660821, -122.432281545934) | 15 | 9 | 11 | 29492 | 10 | ||
2485 | 59880 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2139 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1981 12:00:00 AM | 10 | Permit Number 19345 | 6002701.87127 | 2118840.74506 | 37.7980849079605 | -122.434729923369 | (37.7980849079605, -122.434729923369) | 13 | 9 | 1 | 57 | 17 |
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) );