Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2214 | 2214 | 4695 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 850X Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 4x8 | 6008940.69941 | 2120350.9777900004 | 37.802583847399 | -122.41324853649999 | (37.802583847399, -122.4132485365) | |||
| 2631 | 2631 | 105340 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2014 12:00:00 AM | 12 | Permit Number 770950 | 6000144.5 | 2113810.0 | 37.784126280525605 | -122.44321763524201 | (37.7841262805256, -122.443217635242) | ||
| 3424 | 3424 | 13006 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 383 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 10:51:00 AM | 3 | 3X3 | 6010482.094 | 2120612.9552 | 37.8033895888272 | -122.407932999148 | (37.8033895888272, -122.407932999148) | ||
| 3713 | 3713 | 253521 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2626 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 6006643.0 | 2120264.0 | 37.8022157634914 | -122.42119356191999 | (37.8022157634914, -122.42119356192) | ||
| 4268 | 4268 | 2729 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2250 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002744.1445 | 2114802.6476 | 37.7869997310528 | -122.434294799469 | (37.7869997310528, -122.434294799469) | |||
| 4545 | 4545 | 253200 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
| 4562 | 4562 | 253642 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 427 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010361.39347 | 2118971.94152 | 37.7988770104459 | -122.40823488063499 | (37.7988770104459, -122.408234880635) | ||||
| 4854 | 4854 | 253694 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 536 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005450.0 | 2111168.0 | 37.7771730951376 | -122.42467448311199 | (37.7771730951376, -122.424674483112) | ||||
| 5465 | 5465 | 7223 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1234X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003286.8961 | 2111743.0712 | 37.7786296939692 | -122.432198419662 | (37.7786296939692, -122.432198419662) | |||
| 6631 | 6631 | 13008 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 373 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/27/2015 10:06:00 AM | 3 | 3X3 | 6010552.8791 | 2120622.2117 | 37.803418967602205 | -122.40768869648399 | (37.8034189676022, -122.407688696484) | ||
| 6653 | 6653 | 124728 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 198X Division St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010680.0 | 2108566.0 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | ||||
| 6680 | 6680 | 112268 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 8687 | 8687 | 13035 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 490 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/04/2015 08:33:00 AM | 3 | 3X3 | 6010007.9078 | 2120594.4895 | 37.8033123274611 | -122.40957264178199 | (37.8033123274611, -122.409572641782) | ||
| 9033 | 9033 | 173592 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 75 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 10016 | 10016 | 173777 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 89 Eureka St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001439.0 | 2105287.0 | 37.760797980712205 | -122.438128392537 | (37.7607979807122, -122.438128392537) | ||||
| 10025 | 10025 | 173773 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2235 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002649.0 | 2107045.0 | 37.7656937631635 | -122.434069218237 | (37.7656937631635, -122.434069218237) | ||||
| 10044 | 10044 | 120656 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 160 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10073 | 10073 | 120662 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 299X Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10165 | 10165 | 173892 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 24 Prospect Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007185.0 | 2099410.0 | 37.7449861923813 | -122.417838888286 | (37.7449861923813, -122.417838888286) | ||||
| 10210 | 10210 | 173906 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2510 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6005854.79213 | 2118988.3638299997 | 37.7986687249765 | -122.423830387644 | (37.7986687249765, -122.423830387644) | |||||
| 10267 | 10267 | 45426 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 614 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2001 12:00:00 AM | 9x9 | Permit Number 44218 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.41211965835899 | (37.7614283394777, -122.412119658359) | ||
| 19551 | 19551 | 55849 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2801X Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | Permit Number 46336 | 6001333.31634171 | 2116022.21010841 | 37.7902681559585 | -122.439263383199 | (37.7902681559585, -122.439263383199) | ||
| 21788 | 21788 | 17003 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 985 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5x9 | 6002297.8184 | 2109825.1269 | 37.7733073694664 | -122.435482776108 | (37.7733073694664, -122.435482776108) | |||
| 27180 | 27180 | 21626 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1610 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004833.69671 | 2114745.4452299997 | 37.7869610478907 | -122.427061339905 | (37.7869610478907, -122.427061339905) | |||
| 41076 | 41076 | 117048 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2183 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3x3 | 6002170.0 | 2114323.0 | 37.78565013631621 | -122.436246868292 | (37.7856501363162, -122.436246868292) | |||
| 44578 | 44578 | 17305 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 51X Otis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6006870.5020453 | 2109341.6908091 | 37.7722386113234 | -122.419630895813 | (37.7722386113234, -122.419630895813) | |||
| 46254 | 46254 | 23132 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 610X Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/29/1999 12:00:00 AM | 3 | 4x4 | 6010603.58879 | 2118945.35218 | 37.798817561298 | -122.407394925794 | (37.798817561298, -122.407394925794) | ||
| 50412 | 50412 | 111774 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 215 CLAYTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5998260.0 | 2109886.0 | 37.773244358342296 | -122.449454468346 | (37.7732443583423, -122.449454468346) | |||
| 51254 | 51254 | 120965 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1145x Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003243.0 | 2101623.0 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | ||||
| 51508 | 51508 | 7237 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1065 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003359.4574 | 2111944.18191 | 37.7791860077197 | -122.431961766737 | (37.7791860077197, -122.431961766737) | |||
| 58674 | 58674 | 102786 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3345 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4.5x6 | Permit Number 772480 | 6003174.4 | 2119873.2 | 37.8009465759098 | -122.433168646536 | (37.8009465759098, -122.433168646536) | ||
| 58954 | 58954 | 11429 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 810X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016007.44377 | 2096780.4211400002 | 37.738258459777605 | -122.38714881562599 | (37.7382584597776, -122.387148815626) | |||
| 58966 | 58966 | 110983 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 63413 | 63413 | 16731 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 19X Hollis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6003892.01293 | 2113485.99196 | 37.7834496108007 | -122.4302294651 | (37.7834496108007, -122.4302294651) | |||
| 71075 | 71075 | 106808 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 10 LOYOLA TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 772884 | 5998469.3 | 2110801.2 | 37.7757692329232 | -122.44879640789101 | (37.7757692329232, -122.448796407891) | |||
| 77331 | 77331 | 106090 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 615 Front St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012797.6 | 2118350.4 | 37.7973065196251 | -122.399761086072 | (37.7973065196251, -122.399761086072) | |||||
| 77420 | 77420 | 110696 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 77456 | 77456 | 18007 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2700X Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x4 | 6001006.540695201 | 2114902.0443839002 | 37.7871738702805 | -122.44031363373699 | (37.7871738702805, -122.440313633737) | |||
| 77463 | 77463 | 21815 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2653 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6008264.14138 | 2121978.44796 | 37.8070144637358 | -122.415705074993 | (37.8070144637358, -122.415705074993) | |||
| 77916 | 77916 | 11109 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2022 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3X3 | 6007225.09879 | 2119363.63368 | 37.7997763833106 | -122.419115312272 | (37.7997763833106, -122.419115312272) | |||
| 78051 | 78051 | 18469 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 4X4 | 6010532.642999999 | 2102160.24981 | 37.752725602318705 | -122.406457044136 | (37.7527256023187, -122.406457044136) | |||
| 78160 | 78160 | 44063 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2700 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.43831930796699 | (37.7948463022786, -122.438319307967) | |||
| 78246 | 78246 | 23492 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2510 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005839.2618 | 2119053.8946700003 | 37.798847779282106 | -122.423888789861 | (37.7988477792821, -122.423888789861) | |||
| 78448 | 78448 | 102504 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 290X Hermann St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6003881.1 | 2108703.5 | 37.7703174504719 | -122.429925966233 | (37.7703174504719, -122.429925966233) | ||||
| 78758 | 78758 | 12942 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 725X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 6 | 6005046.7981655 | 2104134.69405 | 37.7578385432445 | -122.425568603003 | (37.7578385432445, -122.425568603003) | |||
| 78954 | 78954 | 113001 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 79034 | 79034 | 16939 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 599X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004143.777734599 | 2110082.9014722 | 37.774119822677996 | -122.429115732545 | (37.774119822678, -122.429115732545) | |||
| 79144 | 79144 | 16393 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 250X Myrtle St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006231.99165 | 2114068.14091 | 37.785180307755105 | -122.42217541209699 | (37.7851803077551, -122.422175412097) | |||
| 79174 | 79174 | 108979 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3298 PIERCE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6001385.1 | 2119659.6 | 37.800258423921 | -122.43934505130699 | (37.800258423921, -122.439345051307) | |||
| 79552 | 79552 | 14994 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1459X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016235.7427248005 | 2097702.9858463 | 37.7408042749191 | -122.38642376985001 | (37.7408042749191, -122.38642376985) | |||
| 79596 | 79596 | 117399 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 75x BEACH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009846.0 | 2122112.0 | 37.80746995952921 | -122.410240137563 | (37.8074699595292, -122.410240137563) | ||||
| 79646 | 79646 | 117205 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6013468.70293325 | 2105662.80878203 | 37.762506682391 | -122.396549051509 | (37.762506682391, -122.396549051509) | |||||
| 79647 | 79647 | 107630 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2164 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6001495.0 | 2119755.0 | 37.8005266206576 | -122.438971595662 | (37.8005266206576, -122.438971595662) | |||
| 79798 | 79798 | 115056 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 499X BRANNAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013762.0 | 2111312.0 | 37.7780344196247 | -122.39593052209601 | (37.7780344196247, -122.395930522096) | ||||
| 79879 | 79879 | 110363 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1899x MARIPOSA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011823.0 | 2106021.0 | 37.7633984709679 | -122.40226615501801 | (37.7633984709679, -122.402266155018) | ||||
| 80014 | 80014 | 13200 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2130X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6002179.06604 | 2119515.41872 | 37.7999076905723 | -122.43658729566201 | (37.7999076905723, -122.436587295662) | |||
| 80115 | 80115 | 7156 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 712 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003631.55189 | 2110917.37527 | 37.7763820727629 | -122.430947178384 | (37.7763820727629, -122.430947178384) | |||
| 80581 | 80581 | 96337 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1851 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005204.9 | 2107156.8 | 37.766145462943605 | -122.42523686393 | (37.7661454629436, -122.42523686393) | |||
| 80590 | 80590 | 15250 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1450X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007716.1596800005 | 2110227.0605599997 | 37.7747172257492 | -122.416768419302 | (37.7747172257492, -122.416768419302) | |||
| 80730 | 80730 | 117185 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 201x GREENWICH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011833.0 | 2120374.0 | 37.80280901508429 | -122.40324129087 | (37.8028090150843, -122.40324129087) | ||||
| 81060 | 81060 | 17309 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 70 Otis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6006766.44916 | 2109389.93705 | 37.7723652222089 | -122.419994248937 | (37.7723652222089, -122.419994248937) | |||
| 81089 | 81089 | 100262 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 40 Federal St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6014922.0 | 2113400.9 | 37.7838345339316 | -122.39206375347099 | (37.7838345339316, -122.392063753471) | |||
| 81143 | 81143 | 4596 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 170 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6011285.22621 | 2118219.63855 | 37.796863055188496 | -122.40498510136801 | (37.7968630551885, -122.404985101368) | |||
| 81353 | 81353 | 112404 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 300x 15TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011264.0 | 2107649.0 | 37.7678373720049 | -122.404314158491 | (37.7678373720049, -122.404314158491) | ||||
| 81839 | 81839 | 15324 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1698X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006725.5802 | 2108585.93757 | 37.7701553284346 | -122.420078550817 | (37.7701553284346, -122.420078550817) | |||
| 82173 | 82173 | 94931 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1771 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004522.0 | 2118744.0 | 37.7979224352085 | -122.428424847305 | (37.7979224352085, -122.428424847305) | |||||
| 83726 | 83726 | 11117 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2054 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6007235.1189832 | 2119374.3616564 | 37.7998064039059 | -122.419081399975 | (37.7998064039059, -122.419081399975) | |||
| 83729 | 83729 | 101759 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 45X 11th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.41790686002899 | (37.7750397101602, -122.417906860029) | |||
| 83739 | 83739 | 7183 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 857 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003432.47617 | 2111314.05853 | 37.777459984774396 | -122.43166416476002 | (37.7774599847744, -122.43166416476) | |||
| 83751 | 83751 | 101716 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 560 Wisconsin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012536.0 | 2104936.0 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | |||||
| 83928 | 83928 | 4754 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1250 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6007719.65165 | 2121534.5567900003 | 37.8057650284682 | -122.41755791876301 | (37.8057650284682, -122.417557918763) | |||
| 84072 | 84072 | 49260 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 84293 | 84293 | 111114 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2085 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5997903.58032533 | 2109906.22418863 | 37.773279493542795 | -122.45068882440701 | (37.7732794935428, -122.450688824407) | ||||
| 84632 | 84632 | 23955 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1985X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6002890.93346 | 2119517.51166 | 37.7999538645084 | -122.43412411886601 | (37.7999538645084, -122.434124118866) | |||
| 85158 | 85158 | 121118 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2701X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010429.0 | 2102109.0 | 37.752579083030895 | -122.406811850318 | (37.7525790830309, -122.406811850318) | ||||
| 85247 | 85247 | 20114 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800X OAK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002934.0 | 2109937.0 | 37.773650656395205 | -122.43329013413602 | (37.7736506563952, -122.433290134136) | |||
| 85412 | 85412 | 18467 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1185X Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010590.614238201 | 2102338.4990144 | 37.7532182781408 | -122.40626912604701 | (37.7532182781408, -122.406269126047) | |||
| 85850 | 85850 | 9615 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1050X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6002927.21435 | 2111923.58629 | 37.77910494348671 | -122.43345559949101 | (37.7791049434867, -122.433455599491) | |||
| 85862 | 85862 | 113299 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700X DAVIS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013208.0 | 2119104.0 | 37.7993985951424 | -122.398393892143 | (37.7993985951424, -122.398393892143) | ||||
| 86004 | 86004 | 21810 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2627 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6008310.29957 | 2121825.65474 | 37.806597526846 | -122.415534509856 | (37.806597526846, -122.415534509856) | |||
| 86210 | 86210 | 14812 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1190X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003455.9090599995 | 2111772.60341 | 37.7787203633271 | -122.431615848033 | (37.7787203633271, -122.431615848033) | |||
| 86273 | 86273 | 4418 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1128 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004420.057130001 | 2102283.99445 | 37.752721523998 | -122.427604283815 | (37.752721523998, -122.427604283815) | |||
| 86351 | 86351 | 46223 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1888 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2002 12:00:00 AM | Permit Number 44530 | 6003335.27744655 | 2119677.01043482 | 37.8004170150887 | -122.432597920925 | (37.8004170150887, -122.432597920925) | |||
| 86675 | 86675 | 121337 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 44 Hugo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 5995656.55399656 | 2107084.69972772 | 37.765403444810204 | -122.45825728758899 | (37.7654034448102, -122.458257287589) | ||||
| 86827 | 86827 | 20091 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2075X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5997085.68869 | 2109091.58753 | 37.7709958615587 | -122.45345917871401 | (37.7709958615587, -122.453459178714) | |||
| 86960 | 86960 | 20258 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 495X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 8x8 | 6009991.4611599995 | 2120547.45752 | 37.80318226771129 | -122.40962623465201 | (37.8031822677113, -122.409626234652) | |||
| 87077 | 87077 | 108943 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 105 Richland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | |||||
| 87220 | 87220 | 8763 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3360 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | |||
| 87297 | 87297 | 15430 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2125 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006871.65728 | 2105982.3734 | 37.7630147835921 | -122.41938854119499 | (37.7630147835921, -122.419388541195) | |||
| 87520 | 87520 | 6801 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1385 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016634.4993322 | 2097405.4643513 | 37.7400094064471 | -122.38502428222701 | (37.7400094064471, -122.385024282227) | |||
| 87672 | 87672 | 107653 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 600 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2014 12:00:00 AM | 3 | Permit Number 772916 | 6005452.33302 | 2111401.13742 | 37.777813365393705 | -122.424683001313 | (37.7778133653937, -122.424683001313) | ||
| 87733 | 87733 | 109596 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3332 21ST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6006085.3 | 2103802.1 | 37.7569839418566 | -122.421953398845 | (37.7569839418566, -122.421953398845) | |||
| 87742 | 87742 | 6379 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 310 Elm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006136.3622127995 | 2112667.0618884997 | 37.781327894236796 | -122.422406674363 | (37.7813278942368, -122.422406674363) | |||
| 88003 | 88003 | 7190 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 896 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 5X5 | 6003496.10413 | 2111301.12929 | 37.7774280906657 | -122.431443131507 | (37.7774280906657, -122.431443131507) | |||
| 88023 | 88023 | 6773 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1355 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016787.8631263 | 2097291.0360598997 | 37.7397036915046 | -122.38448604022699 | (37.7397036915046, -122.384486040227) | |||
| 88266 | 88266 | 94296 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Rec/Park 7 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | ||||
| 88288 | 88288 | 102825 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2001X Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997438.0 | 2109144.0 | 37.77115996155629 | -122.45224431217899 | (37.7711599615563, -122.452244312179) | ||||
| 88384 | 88384 | 22722 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 88466 | 88466 | 7229 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1040 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6003407.8759699995 | 2111884.23201 | 37.7790241450036 | -122.431789985507 | (37.7790241450036, -122.431789985507) | |||
| 88597 | 88597 | 5622 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1202 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6005101.96034 | 2101291.72603 | 37.750035532108605 | -122.425175538874 | (37.7500355321086, -122.425175538874) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");