Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 112391 | 112391 | 54212 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1301X 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993618.71802201 | 2106620.31797794 | 37.7640110640874 | -122.465271900961 | (37.7640110640874, -122.465271900961) | |||
| 129054 | 129054 | 101245 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1301X 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993577.2 | 2106568.3 | 37.763865841987204 | -122.465411719392 | (37.7638658419872, -122.465411719392) | |||
| 2567 | 2567 | 252819 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 407 Miguel St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | Permit Number 780051 | 6004479.0 | 2096413.0 | 37.736604456337105 | -122.426982337456 | (37.7366044563371, -122.426982337456) | ||
| 9709 | 9709 | 121554 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 330 Eureka St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 779292 | 6001441.0 | 2103840.0 | 37.7568249841019 | -122.438017823933 | (37.7568249841019, -122.438017823933) | ||
| 5410 | 5410 | 41173 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3253 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779130 | 5999305.0198 | 2120031.7499700002 | 37.801161655947396 | -122.446569707626 | (37.8011616559474, -122.446569707626) | |
| 5856 | 5856 | 120901 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2032 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778866 | 6001448.95372 | 2115547.55562 | 37.7889714571097 | -122.438829258958 | (37.7889714571097, -122.438829258958) | |
| 187923 | 187923 | 114432 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 700 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777170 | 5992893.39745 | 2110635.08838 | 37.774992699186 | -122.468072606609 | (37.774992699186, -122.468072606609) | ||
| 57491 | 57491 | 62699 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1870 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 3 | Permit Number 777072 | 6005257.84776 | 2117174.75811 | 37.793655307103 | -122.425766849977 | (37.793655307103, -122.425766849977) | ||
| 73281 | 73281 | 114558 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1870 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 3 | Permit Number 777072 | 6005244.08524 | 2117174.62604 | 37.7936541667538 | -122.42581446009599 | (37.7936541667538, -122.425814460096) | ||
| 96230 | 96230 | 61934 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 136 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2015 12:00:00 AM | 3 | 6x12 | Permit Number 775576 | 6005635.57133528 | 2100244.82922864 | 37.747191123987996 | -122.42325587148001 | (37.747191123988, -122.42325587148) |
| 4819 | 4819 | 38523 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1629 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2014 12:00:00 AM | 3 | Permit Number 773138 | 6008768.83808 | 2118471.22766 | 37.7974128706661 | -122.41371022836 | (37.7974128706661, -122.41371022836) | |
| 80855 | 80855 | 57660 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4417 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1976 12:00:00 AM | 3x3 | Permit Number 772993 | 6001718.02788931 | 2104070.42319625 | 37.7574734209258 | -122.437076257467 | (37.7574734209258, -122.437076257467) | ||
| 105257 | 105257 | 26194 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 573 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | Permit Number 772904 | 6002390.549968 | 2104882.2284699 | 37.7597406467411 | -122.43480846230499 | (37.7597406467411, -122.434808462305) | ||
| 2010 | 2010 | 142062 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1100 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 10 | Width 0ft | Permit Number 771276 | 6004214.4178 | 2112228.4 | 37.780014831771 | -122.429024376887 | (37.780014831771, -122.429024376887) | |
| 80701 | 80701 | 99678 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1250X Shrader St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 4x4 | Permit Number 770537 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | |
| 86507 | 86507 | 105174 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1601X NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 40 | 3x3 | Permit Number 770204 | 6015135.0 | 2095759.0 | 37.735405494081505 | -122.390093985074 | (37.7354054940815, -122.390093985074) | ||
| 93426 | 93426 | 102165 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3988 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769758 | 6003795.7 | 2104247.9 | 37.7580786087619 | -122.429903496461 | (37.7580786087619, -122.429903496461) |
| 159944 | 159944 | 101866 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 851 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/2013 12:00:00 AM | 2 | 3x3 | Permit Number 769709 | 6001077.037690001 | 2088890.9773 | 37.71575774639479 | -122.438205662778 | (37.7157577463948, -122.438205662778) | |
| 88505 | 88505 | 101406 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 50-52 Ramona Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769364 | 6005160.9 | 2107520.2 | 37.7671407866326 | -122.425414915098 | (37.7671407866326, -122.425414915098) | |
| 165700 | 165700 | 73647 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1100 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769028 | 6011581.87532 | 2119117.15178 | 37.799343987593495 | -122.404021813977 | (37.7993439875935, -122.404021813977) | |
| 35203 | 35203 | 96010 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767660 | 6009745.43326 | 2116416.2091099997 | 37.7918250833144 | -122.410185778057 | (37.7918250833144, -122.410185778057) |
| 47750 | 47750 | 96007 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009660.15049 | 2116404.46705 | 37.791788061820704 | -122.41048002812599 | (37.7917880618207, -122.410480028126) |
| 76026 | 76026 | 96009 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009716.9001400005 | 2116412.09513 | 37.7918121879409 | -122.41028421245701 | (37.7918121879409, -122.410284212457) |
| 131555 | 131555 | 96006 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009630.99676 | 2116399.7599 | 37.791773502706796 | -122.41058056783702 | (37.7917735027068, -122.410580567837) |
| 134858 | 134858 | 96008 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009692.64051 | 2116408.6515099998 | 37.791801372693 | -122.410367907846 | (37.791801372693, -122.410367907846) |
| 170773 | 170773 | 96011 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009766.6453599995 | 2116419.41202 | 37.7918350666884 | -122.410112610112 | (37.7918350666884, -122.410112610112) |
| 70114 | 70114 | 38632 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 17 | 6x60 | Permit Number 767658 | 6014957.1802 | 2094111.5595 | 37.730872092312204 | -122.390593696874 | (37.7308720923122, -122.390593696874) |
| 179911 | 179911 | 38634 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Shafter Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 16 | Permit Number 767658 | 6014976.9663 | 2094092.323 | 37.7308203704303 | -122.390523948894 | (37.7308203704303, -122.390523948894) | |
| 174666 | 174666 | 68980 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2258 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53507 | 6000514.3803 | 2119968.0276200003 | 37.8010556951124 | -122.44238022937901 | (37.8010556951124, -122.442380229379) | |
| 82134 | 82134 | 6001 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52927 | 6002410.467190799 | 2112668.0181364 | 37.7811196348904 | -122.43529649933501 | (37.7811196348904, -122.435296499335) | |
| 82832 | 82832 | 6003 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52927 | 6002410.467190799 | 2112668.0181364 | 37.7811196348904 | -122.43529649933501 | (37.7811196348904, -122.435296499335) | |
| 107667 | 107667 | 92632 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Eddy St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/22/2009 12:00:00 AM | 3x3 | Permit Number 52927 | 6002403.9 | 2112682.2 | 37.7811582017665 | -122.435320233246 | (37.7811582017665, -122.435320233246) | ||
| 114565 | 114565 | 92634 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Eddy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2009 12:00:00 AM | 3x3 | Permit Number 52927 | 6002403.9 | 2112682.2 | 37.7811582017665 | -122.435320233246 | (37.7811582017665, -122.435320233246) | ||
| 140445 | 140445 | 6002 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52927 | 6002410.467190799 | 2112668.0181364 | 37.7811196348904 | -122.43529649933501 | (37.7811196348904, -122.435296499335) | |
| 92119 | 92119 | 64694 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 114 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 3x3 | Permit Number 52635 | 6005548.53237974 | 2104042.55194245 | 37.757613879648105 | -122.42382684305099 | (37.7576138796481, -122.423826843051) | ||
| 110352 | 110352 | 89007 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 114 Liberty St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 3x3 | Permit Number 52635 | 6005558.0 | 2104034.0 | 37.757590932481 | -122.42379349206001 | (37.757590932481, -122.42379349206) | ||
| 70555 | 70555 | 102084 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 201 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52515 | 5991161.35766 | 2114023.19945 | 37.7841953413 | -122.474311334384 | (37.7841953413, -122.474311334384) |
| 2069 | 2069 | 129587 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1911 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 15 | Width 4ft | Permit Number 52344 | 6003864.05358 | 2118305.88007 | 37.79668221737371 | -122.43067024784901 | (37.7966822173737, -122.430670247849) | |
| 84994 | 84994 | 89034 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 88400 | 88400 | 89032 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 97203 | 97203 | 89033 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 120775 | 120775 | 89035 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 143097 | 143097 | 89036 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 77326 | 77326 | 54931 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1466 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1972 12:00:00 AM | 3x3 | Permit Number 51416 | 6003271.64345897 | 2099695.83318704 | 37.7455500147976 | -122.43139096057 | (37.7455500147976, -122.43139096057) | ||
| 78421 | 78421 | 88365 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 10 Lyon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51347 | 6000409.7 | 2108931.9 | 37.7707473776731 | -122.44194989411001 | (37.7707473776731, -122.44194989411) | |||
| 172930 | 172930 | 88217 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2833 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 11 | 3x3 | Permit Number 51182 | 6002528.21368 | 2117927.18 | 37.7955666353375 | -122.435265448048 | (37.7955666353375, -122.435265448048) | |
| 71004 | 71004 | 87383 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 431 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | 11 | 3x3 | Permit Number 50363 | 5997173.61731 | 2114868.15858 | 37.7868618517374 | -122.453572197813 | (37.7868618517374, -122.453572197813) | |
| 88091 | 88091 | 87157 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 237 Rivoli St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 50138 | 5997662.0 | 2105892.0 | 37.762243628012705 | -122.451234923187 | (37.7622436280127, -122.451234923187) | ||||
| 126839 | 126839 | 87156 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 237 Rivoli St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 50138 | 5997662.0 | 2105892.0 | 37.762243628012705 | -122.451234923187 | (37.7622436280127, -122.451234923187) | ||||
| 35483 | 35483 | 87082 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3119 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/2007 12:00:00 AM | 5 | 3x3 | Permit Number 50024 | 5999240.5872 | 2116291.1195799997 | 37.7908872010279 | -122.446523400642 | (37.7908872010279, -122.446523400642) | |
| 78314 | 78314 | 62107 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 373 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 49980 | 6006792.08421569 | 2101617.3134298 | 37.751024854952796 | -122.419354081346 | (37.7510248549528, -122.419354081346) | ||
| 98744 | 98744 | 51620 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 419 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48838 | 6004007.75048659 | 2096078.78682851 | 37.7356601244905 | -122.428587833263 | (37.7356601244905, -122.428587833263) | |||
| 121146 | 121146 | 52481 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 338HOLLY PARK Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48591 | 6006994.57282255 | 2096259.62185295 | 37.7363252369186 | -122.418274030892 | (37.7363252369186, -122.418274030892) | ||
| 102900 | 102900 | 52416 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 734 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/2005 12:00:00 AM | Permit Number 48535 | 6001832.35713287 | 2089688.63788093 | 37.717990874718 | -122.43565196916799 | (37.717990874718, -122.435651969168) | ||
| 110592 | 110592 | 52006 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1489 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48222 | 6011774.4965411 | 2101419.07057833 | 37.7507598806074 | -122.402110363809 | (37.7507598806074, -122.402110363809) | ||||
| 130801 | 130801 | 51606 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2321 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Permit Number 47903 | 6001273.37015 | 2116460.68929 | 37.7914686945789 | -122.439502237855 | (37.7914686945789, -122.439502237855) | |||
| 7848 | 7848 | 51578 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2005 12:00:00 AM | Permit Number 47872 | |||||||||
| 108106 | 108106 | 34423 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 136 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | Permit Number 47622 | 6003411.17015121 | 2096158.68200715 | 37.7358457184137 | -122.43065613991399 | (37.7358457184137, -122.430656139914) | ||
| 109533 | 109533 | 51073 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 553 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2004 12:00:00 AM | Permit Number 47535 | 6002758.66460209 | 2103250.32502289 | 37.7552807236709 | -122.43341871948499 | (37.7552807236709, -122.433418719485) | |||
| 79613 | 79613 | 51053 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 557 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2004 12:00:00 AM | Permit Number 47523 | 6002734.05323147 | 2103248.96658127 | 37.7552755973804 | -122.433503735784 | (37.7552755973804, -122.433503735784) | |||
| 77722 | 77722 | 50451 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 12 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47097 | 5999287.88101991 | 2108301.76865452 | 37.768953206578296 | -122.445784947419 | (37.7689532065783, -122.445784947419) | |||
| 163153 | 163153 | 50368 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2784 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 4 | Permit Number 47035 | 6000204.6547 | 2114445.9464 | 37.7858758547183 | -122.443055209056 | (37.7858758547183, -122.443055209056) | ||
| 28383 | 28383 | 49433 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 364@ KEARNY Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2003 12:00:00 AM | 8 | Permit Number 46371 | 6011642.68179 | 2116034.05853 | 37.7908819508039 | -122.403594362585 | (37.7908819508039, -122.403594362585) | ||
| 41312 | 41312 | 49432 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 364@ KEARNY Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2003 12:00:00 AM | 7 | Permit Number 46371 | 6011662.833319999 | 2116037.23111 | 37.7908917875712 | -122.403524862095 | (37.7908917875712, -122.403524862095) | ||
| 114705 | 114705 | 39756 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 430 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/2002 12:00:00 AM | Permit Number 45959 | 6003532.62268975 | 2103345.12328431 | 37.755584896633295 | -122.430748907314 | (37.7555848966333, -122.430748907314) | ||
| 174274 | 174274 | 47892 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 725 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2002 12:00:00 AM | 1 | Permit Number 45636 | 6000495.8068 | 2111504.9503 | 37.7778172299888 | -122.441836750591 | (37.7778172299888, -122.441836750591) | |
| 10748 | 10748 | 47214 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 570 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 12 | 6x4 | Permit Number 45165 | 6008824.68232 | 2093406.4927400001 | 37.728594004685895 | -122.41174501811301 | (37.7285940046859, -122.411745018113) |
| 50486 | 50486 | 46971 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1686 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44991 | 5982549.6238 | 2103640.11 | 37.7551837030962 | -122.50333530778 | (37.7551837030962, -122.50333530778) | |
| 70732 | 70732 | 46972 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1686 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44991 | 5982549.0126 | 2103652.333 | 37.755217228081996 | -122.50333832645 | (37.755217228082, -122.50333832645) | |
| 87389 | 87389 | 46271 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 325 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/2002 12:00:00 AM | Permit Number 44555 | 6006560.87997001 | 2097281.80561087 | 37.739107504355005 | -122.419846001297 | (37.739107504355, -122.419846001297) | |||
| 177945 | 177945 | 45683 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 107 Bernard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2001 12:00:00 AM | 4 | Permit Number 44370 | 6008292.83323 | 2118060.93092 | 37.79625955578 | -122.41532827329901 | (37.79625955578, -122.415328273299) | ||
| 82585 | 82585 | 44826 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 129 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2001 12:00:00 AM | Permit Number 43918 | 6010308.29040288 | 2087358.77915196 | 37.7120713475932 | -122.40619016379601 | (37.7120713475932, -122.406190163796) | |||
| 82533 | 82533 | 42985 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/16/2000 12:00:00 AM | 12 | 9x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
| 100933 | 100933 | 42989 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/05/2000 12:00:00 AM | 10 | 5x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
| 103689 | 103689 | 42990 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/05/2000 12:00:00 AM | 10 | 5x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
| 109074 | 109074 | 42988 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/16/2000 12:00:00 AM | 10 | 4x5 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
| 24146 | 24146 | 42768 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 837 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42744 | 6003836.146000001 | 2110735.9706 | 37.7758955707266 | -122.430226485287 | (37.7758955707266, -122.430226485287) | ||
| 83421 | 83421 | 41268 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 44 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091001 | (37.7726810295415, -122.42136607091) | |||
| 88113 | 88113 | 41267 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 44 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091001 | (37.7726810295415, -122.42136607091) | |||
| 155464 | 155464 | 41179 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1768 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/1999 12:00:00 AM | 8 | Permit Number 41898 | 6001615.11314 | 2121098.9248200003 | 37.8042235156744 | -122.438652307458 | (37.8042235156744, -122.438652307458) | |
| 167171 | 167171 | 41176 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1529 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/1999 12:00:00 AM | 9 | Permit Number 41895 | 6002871.193109999 | 2121292.04704 | 37.8048251531279 | -122.434319365747 | (37.8048251531279, -122.434319365747) | |
| 125956 | 125956 | 40954 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 117 Gillette Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41809 | 6013102.88048258 | 2086808.22702407 | 37.7107155607107 | -122.396492619427 | (37.7107155607107, -122.396492619427) | ||||
| 76780 | 76780 | 40626 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 721 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 5 | Permit Number 41627 | 6008236.32931 | 2114467.53897 | 37.7863898065975 | -122.415269286755 | (37.7863898065975, -122.415269286755) | |
| 33941 | 33941 | 40560 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 458 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1999 12:00:00 AM | 7 | Permit Number 41604 | 5990324.44539 | 2112242.31069 | 37.779256995112 | -122.47707654197399 | (37.779256995112, -122.477076541974) | |
| 58120 | 58120 | 40227 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 101 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1999 12:00:00 AM | 12 | Permit Number 41410 | 6014381.3439 | 2112518.0178400003 | 37.78138030849961 | -122.39387241520001 | (37.7813803084996, -122.3938724152) | ||
| 39400 | 39400 | 40056 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1311 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | 9 | Permit Number 41291 | 6016422.4594 | 2093017.6709 | 37.727949672354995 | -122.385451738871 | (37.727949672355, -122.385451738871) | |
| 106910 | 106910 | 40057 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1311 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41291 | 6016435.57889801 | 2093012.13201176 | 37.7279351895138 | -122.385405998165 | (37.7279351895138, -122.385405998165) | ||
| 95774 | 95774 | 39881 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 21 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/1999 12:00:00 AM | Permit Number 41174 | 6014188.8231878 | 2113135.05532668 | 37.783063851701705 | -122.39458166928499 | (37.7830638517017, -122.394581669285) | ||
| 161810 | 161810 | 38641 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | 16 | Permit Number 40566 | 6014964.8748 | 2094103.3153 | 37.7308498822776 | -122.39056651931001 | (37.7308498822776, -122.39056651931) | |
| 88630 | 88630 | 38432 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3844 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1998 12:00:00 AM | Permit Number 40460 | 5995813.83516301 | 2115862.46033815 | 37.7895138928462 | -122.45834869498002 | (37.7895138928462, -122.45834869498) | |||
| 104091 | 104091 | 37584 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 200 Eagle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40015 | 5999640.19520847 | 2104544.9581721 | 37.75865805116221 | -122.44429631061199 | (37.7586580511622, -122.444296310612) | ||
| 104069 | 104069 | 37554 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4515#A 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1998 12:00:00 AM | Permit Number 39993 | 6000985.32111964 | 2105199.93654746 | 37.7605331136342 | -122.439691220259 | (37.7605331136342, -122.439691220259) | ||
| 139903 | 139903 | 37549 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 533 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39989 | 6009274.16052214 | 2114821.41225481 | 37.7874197302007 | -122.411703653187 | (37.7874197302007, -122.411703653187) | ||
| 141672 | 141672 | 37544 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 825 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39986 | 6008203.02144852 | 2114810.28677718 | 37.7873290368122 | -122.415408797554 | (37.7873290368122, -122.415408797554) | ||
| 114643 | 114643 | 37534 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1138 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1998 12:00:00 AM | Permit Number 39980 | 6008135.8621207 | 2116394.85818942 | 37.791676107655704 | -122.415753397731 | (37.7916761076557, -122.415753397731) | |||
| 52526 | 52526 | 37500 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 830 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 8 | Permit Number 39965 | 6009516.4157 | 2115739.5778900003 | 37.789954378345705 | -122.41093037085501 | (37.7899543783457, -122.410930370855) | |
| 137832 | 137832 | 37501 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 830 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1998 12:00:00 AM | 9 | Permit Number 39965 | 6009497.3756099995 | 2115737.1064 | 37.7899465245609 | -122.41099607352601 | (37.7899465245609, -122.410996073526) | ||
| 47937 | 47937 | 37498 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 645 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 10 | Permit Number 39964 | 6010355.28098 | 2115804.39021 | 37.790179340162794 | -122.40803252947201 | (37.7901793401628, -122.408032529472) | |
| 64784 | 64784 | 37497 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 645 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 8 | Permit Number 39964 | 6010338.55748 | 2115802.28849 | 37.790172633000005 | -122.408090243478 | (37.790172633, -122.408090243478) | |
| 165028 | 165028 | 37499 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 645 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 8 | Permit Number 39964 | 6010316.35975 | 2115796.38999 | 37.790155194247 | -122.408166630084 | (37.790155194247, -122.408166630084) |
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");