trees
1,121 rows where qSpecies_id = 6 sorted by Zip Codes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17357 | 116552 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 8 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001598.03525 | 2088202.06693 | 37.7138957693564 | -122.436355582838 | (37.7138957693564, -122.436355582838) | 9 | 7 | 6 | 28861 | 5 | |||
| 17874 | 170661 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 301X San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | Width 3ft | 6000920.86362 | 2092466.57168 | 37.7255666366796 | -122.439001572678 | (37.7255666366796, -122.439001572678) | 9 | 7 | 6 | 28861 | 25 | ||
| 18371 | 27202 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 302 Silver Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003502.33889 | 2093475.71167 | 37.7284840526724 | -122.430149591636 | (37.7284840526724, -122.430149591636) | 9 | 7 | 6 | 28861 | 5 | ||
| 19087 | 261350 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 299 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784323 | 5994169 | 2087374 | 37.7111971725927 | -122.461972900974 | (37.7111971725927, -122.461972900974) | 9 | 8 | 6 | 28861 | 24 | |
| 19183 | 261351 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 299 Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784323 | 5994169 | 2087374 | 37.7111971725927 | -122.461972900974 | (37.7111971725927, -122.461972900974) | 9 | 8 | 6 | 28861 | 24 | |
| 21610 | 83554 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 117X Peru Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003920.58239 | 2093359.59743 | 37.7281889086723 | -122.428695428367 | (37.7281889086723, -122.428695428367) | 9 | 7 | 6 | 28861 | 5 |
| 21651 | 27207 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 302 Silver Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003623.95003 | 2093470.28644 | 37.7284760433174 | -122.429728788952 | (37.7284760433174, -122.429728788952) | 9 | 7 | 6 | 28861 | 5 | ||
| 24139 | 95719 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 25141 | 95718 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 26675 | 207018 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 466 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5997114.73821 | 2093838.00202 | 37.7291149630685 | -122.452257872798 | (37.7291149630685, -122.452257872798) | 9 | 7 | 4 | 28861 | 40 | |||
| 27543 | 83558 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 483 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52321 | 6001949.50225 | 2090800.06366 | 37.7210492547906 | -122.435326507535 | (37.7210492547906, -122.435326507535) | 9 | 7 | 6 | 28861 | 5 | |
| 27595 | 63507 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 574 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/1987 12:00:00 AM | 4 | Permit Number 24113 | 6001588.8915 | 2090307.92108 | 37.7196774559426 | -122.436537823274 | (37.7196774559426, -122.436537823274) | 9 | 7 | 6 | 28861 | 5 | ||
| 28327 | 162331 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 26 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:09:00 PM | 3 | Width 0ft | 5996526.61739 | 2090076.51041 | 37.7187530886569 | -122.454019490912 | (37.7187530886569, -122.454019490912) | 9 | 8 | 6 | 28861 | 24 | ||
| 28544 | 159338 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 517 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:04:00 AM | 3 | Width 0ft | 5998112.9338 | 2087183.20699 | 37.7108995709325 | -122.448328017142 | (37.7108995709325, -122.448328017142) | 9 | 7 | 6 | 28861 | 25 | ||
| 29101 | 176889 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 277 Athens St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004392.5622 | 2091665.65248 | 37.7235644112504 | -122.426943181195 | (37.7235644112504, -122.426943181195) | 9 | 7 | 6 | 28861 | 5 | |||
| 29210 | 176917 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 9 | Median : Yard | Tree | DPW 1 | 3 | 6001514.03799 | 2088123.65893 | 37.7136757052349 | -122.436640299224 | (37.7136757052349, -122.436640299224) | 9 | 7 | 6 | 28861 | 5 | ||||
| 30385 | 181018 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 197 Rolph St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 11:31:00 AM | 3 | Width 4ft | 6001005.57228 | 2088396.04691 | 37.7143947132291 | -122.43841724089 | (37.7143947132291, -122.43841724089) | 9 | 7 | 6 | 28861 | 5 | ||
| 30581 | 252889 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 301x Howth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2019 08:45:00 AM | 3 | 3x3 | 5997131 | 2090234 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | 9 | 8 | 6 | 28861 | 24 | ||
| 30949 | 176888 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 13 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002306.40089 | 2092528.29831 | 37.7258148612434 | -122.434216303453 | (37.7258148612434, -122.434216303453) | 9 | 7 | 6 | 28861 | 25 | |||
| 33674 | 27102 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 669 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2009 12:00:00 AM | 3 | 3X3 | 6005822.11431 | 2093583.57584 | 37.7289113394767 | -122.422137656546 | (37.7289113394767, -122.422137656546) | 9 | 7 | 6 | 28861 | 5 | ||
| 34235 | 207024 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997067.34432 | 2090557.59428 | 37.7201050223995 | -122.452185117661 | (37.7201050223995, -122.452185117661) | 9 | 8 | 6 | 28861 | 24 | |||
| 35156 | 26976 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 504X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3 | 3x3 | 6004631.39194 | 2093482.01374 | 37.7285652398765 | -122.426246843332 | (37.7285652398765, -122.426246843332) | 9 | 7 | 6 | 28861 | 5 | ||
| 37676 | 176896 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 70 La Grande Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005242.33299 | 2091887.73518 | 37.7242222149627 | -122.424021456542 | (37.7242222149627, -122.424021456542) | 9 | 7 | 6 | 28861 | 5 | |||
| 39381 | 181028 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Rolph St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 04:38:00 PM | 3 | Width 4ft | 6000533.08885 | 2088674.46766 | 37.7151323074928 | -122.440070279342 | (37.7151323074928, -122.440070279342) | 9 | 7 | 6 | 28861 | 5 | ||
| 41454 | 253116 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 12:00:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
| 41858 | 83563 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 422 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769753 | 6002333.87212 | 2090986.92404 | 37.7215841526661 | -122.434011205875 | (37.7215841526661, -122.434011205875) | 9 | 7 | 6 | 28861 | 5 | |
| 42520 | 27117 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 415 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/03/2009 12:00:00 AM | 3 | 3X3 | 6004172.1589 | 2093507.51269 | 37.7286092859714 | -122.427836253857 | (37.7286092859714, -122.427836253857) | 9 | 7 | 6 | 28861 | 5 | ||
| 44017 | 116540 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 3 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001555.50616 | 2088195.95431 | 37.7138765688354 | -122.436502141754 | (37.7138765688354, -122.436502141754) | 9 | 7 | 6 | 28861 | 5 | |||
| 46761 | 27182 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 214 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/03/2015 07:50:00 AM | 3 | 2X3 | 6002674.64617 | 2093876.57211 | 37.7295378108224 | -122.433039593603 | (37.7295378108224, -122.433039593603) | 9 | 7 | 6 | 28861 | 25 | ||
| 47209 | 165132 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 929 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781230 | 5995776.8676 | 2094560.79185 | 37.7310228361347 | -122.456935228771 | (37.7310228361347, -122.456935228771) | 9 | 7 | 4 | 28861 | 40 |
| 47657 | 207016 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 409 Edna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5998750.98669 | 2094179.12135 | 37.7301451967391 | -122.446625784855 | (37.7301451967391, -122.446625784855) | 9 | 7 | 4 | 28861 | 40 | |||
| 48472 | 207040 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 115 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996029.16987 | 2093727.86128 | 37.7287502942706 | -122.456002788314 | (37.7287502942706, -122.456002788314) | 9 | 7 | 4 | 28861 | 40 | |||
| 48782 | 83518 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 117X Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003951.4498 | 2093338.17621 | 37.7281318376981 | -122.428587192249 | (37.7281318376981, -122.428587192249) | 9 | 7 | 6 | 28861 | 5 |
| 52445 | 251444 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 244 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 07:40:00 AM | 3 | 3x3 | 5994545 | 2088436 | 37.7141348140673 | -122.460750275072 | (37.7141348140673, -122.460750275072) | 9 | 8 | 6 | 28861 | 24 | ||
| 53300 | 95720 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 56393 | 176895 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 70 La Grande Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005265.09064 | 2091962.62602 | 37.7244291336757 | -122.42394810962 | (37.7244291336757, -122.42394810962) | 9 | 7 | 6 | 28861 | 5 | |||
| 57710 | 181021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 179 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 12:49:00 PM | 3 | 8x6 | 6000934.69942 | 2088437.13017 | 37.71450348711 | -122.438665147076 | (37.71450348711, -122.438665147076) | 9 | 7 | 6 | 28861 | 5 | ||
| 57846 | 159339 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 517 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:12:00 AM | 3 | Width 0ft | 5998126.45786 | 2087195.02696 | 37.7109327990681 | -122.44828212563 | (37.7109327990681, -122.44828212563) | 9 | 7 | 6 | 28861 | 25 | ||
| 58866 | 116551 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 7 | Median : Yard | Tree | DPW 1 | 4 | 3x3 | 6001523.56178 | 2088140.13665 | 37.713721490625 | -122.436608560332 | (37.713721490625, -122.436608560332) | 9 | 7 | 6 | 28861 | 5 | |||
| 61823 | 109689 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 836 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774161 | 6003406.50306 | 2089728.73547 | 37.7181902596385 | -122.430213694415 | (37.7181902596385, -122.430213694415) | 9 | 7 | 6 | 28861 | 5 |
| 65213 | 176887 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 13 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002286.64114 | 2092541.40018 | 37.7258497144844 | -122.434285547657 | (37.7258497144844, -122.434285547657) | 9 | 7 | 6 | 28861 | 25 | |||
| 65853 | 116538 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 1 | Median : Yard | Tree | DPW 1 | 1 | 3x3 | 6001578.10158 | 2088233.43486 | 37.7139807660769 | -122.436426724612 | (37.7139807660769, -122.436426724612) | 9 | 7 | 6 | 28861 | 5 | |||
| 67542 | 95712 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 642 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767468 | 6003074.18539 | 2089625.7401 | 37.7178886288451 | -122.431355025819 | (37.7178886288451, -122.431355025819) | 9 | 7 | 6 | 28861 | 5 |
| 68598 | 109688 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 610 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774167 | 6002866.93373 | 2090069.72294 | 37.719095959684 | -122.432103090885 | (37.719095959684, -122.432103090885) | 9 | 7 | 6 | 28861 | 5 |
| 69235 | 116543 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 6 | Median : Yard | Tree | DPW 1 | 5 | 3x3 | 6001574.84931 | 2088164.89401 | 37.7137923832878 | -122.43643306305 | (37.7137923832878, -122.43643306305) | 9 | 7 | 6 | 28861 | 5 | |||
| 70068 | 207041 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1414 Plymouth Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5995889.45634 | 2093373.14104 | 37.727768297568 | -122.456460143934 | (37.727768297568, -122.456460143934) | 9 | 7 | 4 | 28861 | 40 | |||
| 72364 | 216718 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 978 Capitol Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/13/2017 11:36:00 AM | 3 | Width 3ft | 5995057.03199 | 2090421.24862 | 37.7196152839906 | -122.459124173263 | (37.7196152839906, -122.459124173263) | 9 | 8 | 6 | 28861 | 24 | ||
| 72730 | 251681 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:36:00 PM | 3 | 3x5 | 5996550 | 2089909 | 37.7182944850221 | -122.453926576307 | (37.7182944850221, -122.453926576307) | 9 | 8 | 6 | 28861 | 24 | ||
| 72790 | 40470 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 43 Lakeview Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | 9 | 8 | 6 | 28861 | 24 | |||
| 75681 | 227160 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 236 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003812.10722 | 2095285.7669 | 37.7334715974377 | -122.429207719083 | (37.7334715974377, -122.429207719083) | 2 | 7 | 5 | 28861 | 25 | |||
| 76214 | 37822 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 10 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/11/2017 09:46:00 AM | 3 | 3x3 | Permit Number 40134 | 6003933.77466 | 2090481.79158 | 37.7202878374987 | -122.428444787301 | (37.7202878374987, -122.428444787301) | 9 | 7 | 6 | 28861 | 5 |
| 76315 | 27177 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 241 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2005 12:00:00 AM | 3 | 2X3 | 6002847.37275 | 2093824.85102 | 37.7294055924915 | -122.432438768257 | (37.7294055924915, -122.432438768257) | 9 | 7 | 6 | 28861 | 25 | ||
| 76325 | 253875 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 274 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777423 | 6003013.5236 | 2093666.24958 | 37.728979528994 | -122.431853049446 | (37.728979528994, -122.431853049446) | 9 | 7 | 6 | 28861 | 25 | |
| 77796 | 83657 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 7 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 7 | Permit Number 769748 | 6003905.60089 | 2093401.91906 | 37.728304266518 | -122.428750235745 | (37.728304266518, -122.428750235745) | 9 | 7 | 6 | 28861 | 5 | |
| 78745 | 176904 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 68 Cambridge St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6006443.50632 | 2094472.10137 | 37.7313860651023 | -122.420052485745 | (37.7313860651023, -122.420052485745) | 9 | 7 | 7 | 28861 | 5 | |||
| 79736 | 251742 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 300 Naylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002771 | 2086560 | 37.7094535905361 | -122.432184185389 | (37.7094535905361, -122.432184185389) | 9 | 7 | 6 | 28861 | 5 | ||||
| 80180 | 160063 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:07:00 AM | 3 | Width 0ft | 6000471.59074 | 2090857.95331 | 37.7211241647202 | -122.440439349407 | (37.7211241647202, -122.440439349407) | 9 | 7 | 6 | 28861 | 25 | ||
| 80751 | 176890 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 18 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003663.21456 | 2093989.9827 | 37.7299052360341 | -122.429630099158 | (37.7299052360341, -122.429630099158) | 9 | 7 | 6 | 28861 | 5 | |||
| 81002 | 159346 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 461 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:49:00 AM | 3 | Width 0ft | 5998276.6806 | 2087336.80621 | 37.7113306798385 | -122.44777312285 | (37.7113306798385, -122.44777312285) | 9 | 7 | 6 | 28861 | 25 | ||
| 82967 | 25763 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1682 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/20/2015 06:02:00 PM | 3 | 2X3 | 6004184.86566 | 2087196.38583 | 37.711281031873 | -122.427342931648 | (37.711281031873, -122.427342931648) | 9 | 7 | 6 | 28861 | 5 | ||
| 84190 | 253150 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 3 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/11/2017 09:41:00 AM | 3 | 3x3 | 6003965.72194 | 2090553.13154 | 37.7204855291627 | -122.428339438009 | (37.7204855291627, -122.428339438009) | 9 | 7 | 6 | 28861 | 5 | |
| 84495 | 52937 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 436@THERESA Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 9 | Permit Number 48924 | 6002078.69882 | 2093873.61529 | 37.7294958700207 | -122.435099629266 | (37.7294958700207, -122.435099629266) | 9 | 7 | 6 | 28861 | 25 | |
| 84749 | 95721 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 84873 | 69398 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1174 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 6 | Permit Number 33502 | 6001210.49529 | 2087131.44104 | 37.7109340401325 | -122.43761843606 | (37.7109340401325, -122.43761843606) | 9 | 7 | 6 | 28861 | 5 | |
| 85730 | 43321 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 283 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49915 | 6004368.56572 | 2091597.24704 | 37.7233752280736 | -122.427021263027 | (37.7233752280736, -122.427021263027) | 9 | 7 | 6 | 28861 | 5 | |
| 87197 | 27205 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 302 Silver Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003575.96193 | 2093472.33897 | 37.7284789616109 | -122.429894832577 | (37.7284789616109, -122.429894832577) | 9 | 7 | 6 | 28861 | 5 | ||
| 88773 | 216845 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 194 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 07:48:00 AM | 3 | Width 3ft | 5995118.95449 | 2088413.12295 | 37.7141050056202 | -122.458764825742 | (37.7141050056202, -122.458764825742) | 9 | 8 | 6 | 28861 | 24 | ||
| 91908 | 27212 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 302 Silver Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003753.294 | 2093466.82209 | 37.7284738543786 | -122.429281393342 | (37.7284738543786, -122.429281393342) | 9 | 7 | 6 | 28861 | 5 | ||
| 92269 | 165133 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 929 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781230 | 5995820.38989 | 2094571.40487 | 37.731054476063 | -122.456785533051 | (37.731054476063, -122.456785533051) | 9 | 7 | 4 | 28861 | 40 |
| 92790 | 37817 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 5 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003961.27408 | 2090526.10251 | 37.7204110616965 | -122.428352887393 | (37.7204110616965, -122.428352887393) | 9 | 7 | 6 | 28861 | 5 |
| 93865 | 109578 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 10X Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775018 | 6002262.55573 | 2092599.72242 | 37.7260084870829 | -122.434372977031 | (37.7260084870829, -122.434372977031) | 9 | 7 | 6 | 28861 | 25 |
| 94734 | 207019 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 234 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 5998513.62611 | 2093807.4558 | 37.7291111292533 | -122.447419626323 | (37.7291111292533, -122.447419626323) | 9 | 7 | 4 | 28861 | 40 | |||
| 95040 | 116547 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 3 | Median : Yard | Tree | DPW 1 | 4 | 3x3 | 6001554.67745 | 2088129.8106 | 37.7136949057732 | -122.436500274771 | (37.7136949057732, -122.436500274771) | 9 | 7 | 6 | 28861 | 5 | |||
| 96295 | 253108 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:41:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
| 99068 | 176488 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 295 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 09:25:00 AM | 3 | Width 2ft | 6004452.71642 | 2090718.28415 | 37.7209665468512 | -122.4266678079 | (37.7209665468512, -122.4266678079) | 9 | 7 | 6 | 28861 | 5 | ||
| 99461 | 216848 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 258 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 02:39:00 PM | 3 | Width 3ft | 5994378.76562 | 2088424.12647 | 37.7140926462446 | -122.461323980613 | (37.7140926462446, -122.461323980613) | 9 | 8 | 6 | 28861 | 24 | ||
| 100552 | 172375 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 216 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 07:37:00 AM | 3 | Width 2ft | 6002574 | 2086750 | 37.7099641176609 | -122.432878614235 | (37.7099641176609, -122.432878614235) | 9 | 7 | 6 | 28861 | 5 | ||
| 101773 | 176894 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 68 La Grande Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005238.00808 | 2092009.90059 | 37.7245574102793 | -122.424045090732 | (37.7245574102793, -122.424045090732) | 9 | 7 | 6 | 28861 | 5 | |||
| 101905 | 43742 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
| 102249 | 176892 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 128 Craut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004016.19178 | 2094155.91914 | 37.7303808407035 | -122.428421637873 | (37.7303808407035, -122.428421637873) | 9 | 7 | 6 | 28861 | 5 | |||
| 102267 | 207020 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 230 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996253.66444 | 2091441.06295 | 37.7224841734802 | -122.455061523672 | (37.7224841734802, -122.455061523672) | 9 | 8 | 4 | 28861 | 24 | |||
| 102650 | 120680 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 522 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2016 12:00:00 AM | 3 | 3x3 | 6003717 | 2090174 | 37.7194304401491 | -122.42917217064 | (37.7194304401491, -122.42917217064) | 9 | 7 | 6 | 28861 | 5 | ||
| 104234 | 160065 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:13:00 AM | 3 | Width 0ft | 6000417.53141 | 2090750.67913 | 37.7208265358932 | -122.440618525839 | (37.7208265358932, -122.440618525839) | 9 | 7 | 6 | 28861 | 25 | ||
| 107401 | 43741 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
| 108454 | 227082 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4021 Mission St | 1 | : | Tree | Private 2 | 4 | Width 4ft | 6004538.86235 | 2095169.33967 | 37.7331930297319 | -122.426686831253 | (37.7331930297319, -122.426686831253) | 2 | 7 | 7 | 28861 | 2 | |||
| 108686 | 207015 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 409 Edna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 5998751.39592 | 2094165.76826 | 37.7301085556677 | -122.446623409741 | (37.7301085556677, -122.446623409741) | 9 | 7 | 4 | 28861 | 40 | |||
| 109143 | 181019 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 191 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 12:36:00 PM | 3 | Width 4ft | 6000981.45407 | 2088409.26942 | 37.7144296473919 | -122.438501549606 | (37.7144296473919, -122.438501549606) | 9 | 7 | 6 | 28861 | 5 | ||
| 111662 | 252898 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 501x Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997879 | 2089997 | 37.7186122227881 | -122.449339142229 | (37.7186122227881, -122.449339142229) | 9 | 8 | 6 | 28861 | 24 | ||||
| 111712 | 253162 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 323 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004481 | 2091226 | 37.7223622223708 | -122.426606175157 | (37.7223622223708, -122.426606175157) | 9 | 7 | 6 | 28861 | 5 | ||||
| 112076 | 27237 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 279 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2007 12:00:00 AM | 3 | 3X3 | 6003060.07524 | 2093688.79098 | 37.7290440614247 | -122.431693725785 | (37.7290440614247, -122.431693725785) | 9 | 7 | 6 | 28861 | 25 | ||
| 112582 | 207022 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997053.5846 | 2090532.92812 | 37.7200365066592 | -122.452230901246 | (37.7200365066592, -122.452230901246) | 9 | 8 | 6 | 28861 | 24 | |||
| 113520 | 207008 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 451 Hearst Ave | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5998589.10288 | 2094366.3057 | 37.730649912467 | -122.447198902106 | (37.730649912467, -122.447198902106) | 9 | 7 | 4 | 28861 | 40 | |||
| 113846 | 207017 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 466 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5997128.21176 | 2093837.95674 | 37.7291156105912 | -122.452211290622 | (37.7291156105912, -122.452211290622) | 9 | 7 | 4 | 28861 | 40 | |||
| 115087 | 207027 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 43 Lakeview Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5997356.56263 | 2089224.02458 | 37.7164599136667 | -122.451089274853 | (37.7164599136667, -122.451089274853) | 9 | 8 | 6 | 28861 | 24 | |||
| 116664 | 116546 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 2 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001545.43478 | 2088113.86518 | 37.7136505979649 | -122.436531080144 | (37.7136505979649, -122.436531080144) | 9 | 7 | 6 | 28861 | 5 | |||
| 117385 | 181020 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 183 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 12:41:00 PM | 3 | Width 4ft | 6000952.49174 | 2088426.93011 | 37.7144764921819 | -122.438602919392 | (37.7144764921819, -122.438602919392) | 9 | 7 | 6 | 28861 | 5 | ||
| 117585 | 160061 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:02:00 AM | 3 | Width 0ft | 6000547.45442 | 2091000.21878 | 37.7215191128017 | -122.440187308101 | (37.7215191128017, -122.440187308101) | 9 | 7 | 6 | 28861 | 25 | ||
| 117729 | 27114 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 451 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/03/2009 12:00:00 AM | 3 | 3x3 | 6004400.62614 | 2093530.84049 | 37.7286862607878 | -122.427048090034 | (37.7286862607878, -122.427048090034) | 9 | 7 | 6 | 28861 | 5 | ||
| 120285 | 207025 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997075.91635 | 2090573.81293 | 37.7201500460637 | -122.452156656813 | (37.7201500460637, -122.452156656813) | 9 | 8 | 6 | 28861 | 24 | |||
| 121056 | 251749 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 601 Prague St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002875 | 2087693 | 37.7125704580966 | -122.43190559156 | (37.7125704580966, -122.43190559156) | 9 | 7 | 6 | 28861 | 5 |
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) );