Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96621 | 96621 | 17118 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1907 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5997842.841030001 | 2109183.73864 | 37.771292257165896 | -122.4508468245 | (37.7712922571659, -122.4508468245) | |||
| 114870 | 114870 | 52589 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 675 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2006 12:00:00 AM | Permit Number 774039 | 5997878.20498734 | 2108284.16023065 | 37.7688242695831 | -122.450659631577 | (37.7688242695831, -122.450659631577) | |||
| 139154 | 139154 | 106938 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1607 WALLER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 5997889.0 | 2108175.0 | 37.768525161365105 | -122.45061442154498 | (37.7685251613651, -122.450614421545) | ||||
| 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) | ||||
| 91527 | 91527 | 111115 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2085 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5997903.58032533 | 2109906.22418863 | 37.773279493542795 | -122.45068882440701 | (37.7732794935428, -122.450688824407) | ||||
| 127284 | 127284 | 111116 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2085 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5997903.58032533 | 2109906.22418863 | 37.773279493542795 | -122.45068882440701 | (37.7732794935428, -122.450688824407) | ||||
| 18363 | 18363 | 94569 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100@ Cole Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998051.0 | 2107197.0 | 37.765849093366796 | -122.449983584058 | (37.7658490933668, -122.449983584058) | ||||
| 99209 | 99209 | 94566 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998051.0 | 2107197.0 | 37.765849093366796 | -122.449983584058 | (37.7658490933668, -122.449983584058) | ||||
| 108733 | 108733 | 94567 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100 Carl St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998051.0 | 2107197.0 | 37.765849093366796 | -122.449983584058 | (37.7658490933668, -122.449983584058) | ||||
| 100007 | 100007 | 58524 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1544 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1979 12:00:00 AM | Permit Number 17701 | 5998255.704076401 | 2108272.5838384 | 37.7688140844915 | -122.449353060877 | (37.7688140844915, -122.449353060877) | |||
| 98986 | 98986 | 104241 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1544 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998256.5 | 2108266.6 | 37.768797699923 | -122.44934987666001 | (37.768797699923, -122.44934987666) | ||||
| 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) | |||
| 84824 | 84824 | 106999 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 10 Loyola Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998469.2817 | 2110801.2236 | 37.7757692966762 | -122.448796472896 | (37.7757692966762, -122.448796472896) | |||||
| 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) | |||
| 123862 | 123862 | 105233 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1508 WALLER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5998474.1 | 2108297.0 | 37.7688936152058 | -122.448599407064 | (37.7688936152058, -122.448599407064) | |||
| 58723 | 58723 | 116509 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1500x Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 3x3 | 5998488.0 | 2108327.0 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | ||
| 78415 | 78415 | 116510 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1500x Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998488.0 | 2108327.0 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | ||||
| 104104 | 104104 | 58777 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1500x Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1980 12:00:00 AM | 3x3 | Permit Number 18128 | 5998488.0 | 2108327.0 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | ||
| 118687 | 118687 | 116511 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1500x Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998488.0 | 2108327.0 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | ||||
| 54782 | 54782 | 17106 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1777 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998507.83576 | 2109285.1679 | 37.771608801349394 | -122.448553894841 | (37.7716088013494, -122.448553894841) | |||
| 103004 | 103004 | 10464 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1584 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5998533.97425 | 2108659.6299400004 | 37.7698927281656 | -122.44841842514099 | (37.7698927281656, -122.448418425141) | |||
| 110998 | 110998 | 17105 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1763 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998573.85799 | 2109309.47001 | 37.771679303532295 | -122.44832727139901 | (37.7716793035323, -122.448327271399) | |||
| 28450 | 28450 | 104230 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 409 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14x8 | 5998587.6 | 2115205.6 | 37.787869332154 | -122.44870447955601 | (37.787869332154, -122.448704479556) | ||||
| 109816 | 109816 | 10462 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1576 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5998589.8073 | 2108666.88124 | 37.7699158304312 | -122.448225822875 | (37.7699158304312, -122.448225822875) | |||
| 97826 | 97826 | 116231 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1486 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 5998599.14429808 | 2108320.44227206 | 37.7689651308865 | -122.448168577388 | (37.7689651308865, -122.448168577388) | ||||
| 110739 | 110739 | 116232 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1486 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x7 | 5998599.14429808 | 2108320.44227206 | 37.7689651308865 | -122.448168577388 | (37.7689651308865, -122.448168577388) | ||||
| 142435 | 142435 | 58520 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1486 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1979 12:00:00 AM | 7x7 | Permit Number 17697 | 5998599.14429808 | 2108320.44227206 | 37.7689651308865 | -122.448168577388 | (37.7689651308865, -122.448168577388) | ||
| 111498 | 111498 | 93200 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 756 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x6 | 5998607.0 | 2107901.0 | 37.7678138979087 | -122.448111199872 | (37.7678138979087, -122.448111199872) | ||||
| 109937 | 109937 | 121101 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 600x Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998712.0 | 2105642.0 | 37.761617254212396 | -122.44758538801099 | (37.7616172542124, -122.447585388011) | ||||
| 106747 | 106747 | 58514 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1460 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1979 12:00:00 AM | 3x3 | Permit Number 17691 | 5998731.52150291 | 2108338.88905051 | 37.7690233477366 | -122.447712023248 | (37.7690233477366, -122.447712023248) | ||
| 111700 | 111700 | 109331 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1325 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 5998933.0 | 2105018.0 | 37.7599165333482 | -122.446776141106 | (37.7599165333482, -122.446776141106) | |||
| 142530 | 142530 | 109332 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1321 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 5998933.0 | 2105018.0 | 37.7599165333482 | -122.446776141106 | (37.7599165333482, -122.446776141106) | |||
| 124253 | 124253 | 109328 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1349 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | 5999000.5 | 2104870.1 | 37.7595142924854 | -122.44653205153799 | (37.7595142924854, -122.446532051538) | ||
| 90601 | 90601 | 16813 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2097X O'Farrell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 5999009.37837 | 2112716.355 | 37.7810586242256 | -122.44706600273899 | (37.7810586242256, -122.447066002739) | |||
| 107022 | 107022 | 109334 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1313 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5999032.0 | 2105350.0 | 37.7608337776961 | -122.446457634643 | (37.7608337776961, -122.446457634643) | |||
| 80196 | 80196 | 120531 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1390 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | ||||
| 107309 | 107309 | 120530 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1390 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | ||||
| 119156 | 119156 | 58508 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1390 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | 3x3 | Permit Number 17683 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | ||
| 119985 | 119985 | 120532 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1390 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | ||||
| 91377 | 91377 | 109333 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1317 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 5999055.0 | 2105304.0 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | |||
| 99268 | 99268 | 18696 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 251X Richardson Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 100 | 5999064.164064 | 2119841.396854 | 37.8006252370733 | -122.44738946108299 | (37.8006252370733, -122.447389461083) | |||
| 127624 | 127624 | 18698 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 251X Richardson Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 100 | 5999064.164064 | 2119841.396854 | 37.8006252370733 | -122.44738946108299 | (37.8006252370733, -122.447389461083) | |||
| 142606 | 142606 | 18697 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 251X Richardson Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 100 | 5999064.164064 | 2119841.396854 | 37.8006252370733 | -122.44738946108299 | (37.8006252370733, -122.447389461083) | |||
| 112508 | 112508 | 107659 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1324 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5999078.1 | 2104991.6 | 37.759852333413 | -122.446272413537 | (37.759852333413, -122.446272413537) | |||
| 129095 | 129095 | 107660 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1316 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5999083.9 | 2105040.7 | 37.759987481053294 | -122.446255886285 | (37.7599874810533, -122.446255886285) | |||
| 91548 | 91548 | 112578 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 660x Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999086.0 | 2108401.0 | 37.7692141419233 | -122.446490377962 | (37.7692141419233, -122.446490377962) | ||||
| 11026 | 11026 | 173949 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1306 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999102.0 | 2105133.0 | 37.760241947595404 | -122.446199926833 | (37.7602419475954, -122.446199926833) | ||||
| 12922 | 12922 | 173948 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1300 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999106.0 | 2105162.0 | 37.7603218028196 | -122.446188178838 | (37.7603218028196, -122.446188178838) | ||||
| 143704 | 143704 | 50980 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 201 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2004 12:00:00 AM | 3x3 | Permit Number 47465 | 5999116.7 | 2119758.3 | 37.8004000774175 | -122.447201682136 | (37.8004000774175, -122.447201682136) | ||
| 101755 | 101755 | 26159 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 210 Richardson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999117.59522 | 2119823.02413 | 37.800577843616 | -122.447203245105 | (37.800577843616, -122.447203245105) | |||
| 107852 | 107852 | 50854 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1375 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2004 12:00:00 AM | Permit Number 47369 | 5999134.27629696 | 2108342.5104784 | 37.76905630179421 | -122.44631918531799 | (37.7690563017942, -122.446319185318) | |||
| 94553 | 94553 | 16728 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1519 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 5999136.4110982 | 2112734.4359693 | 37.781115526981296 | -122.446627836224 | (37.7811155269813, -122.446627836224) | |||
| 141191 | 141191 | 16729 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1519 O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 5999136.4110982 | 2112734.4359693 | 37.781115526981296 | -122.446627836224 | (37.7811155269813, -122.446627836224) | |||
| 102677 | 102677 | 109882 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1520 PAGE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x8 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.44624140323401 | (37.7711622584795, -122.446241403234) | ||||
| 79990 | 79990 | 111430 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 500X PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999200.0 | 2114887.0 | 37.7870295394193 | -122.446562765799 | (37.7870295394193, -122.446562765799) | ||||
| 97522 | 97522 | 17088 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1611 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5999244.55181 | 2109378.0663400004 | 37.77190597325 | -122.446012243601 | (37.77190597325, -122.446012243601) | |||
| 111696 | 111696 | 18684 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 165X Richardson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999250.42609 | 2119592.6225799997 | 37.7999528116563 | -122.446727010779 | (37.7999528116563, -122.446727010779) | |||
| 138552 | 138552 | 17085 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1585 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999415.39608 | 2109426.2103 | 37.7720479186519 | -122.445424745443 | (37.7720479186519, -122.445424745443) | |||
| 9862 | 9862 | 173716 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 1652 Fell St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5999516.0 | 2109850.0 | 37.7732172801378 | -122.445107222354 | (37.7732172801378, -122.445107222354) | |||||
| 88258 | 88258 | 109000 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 525x BURNETT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 circle | 5999530.0 | 2102478.0 | 37.7529764040195 | -122.44452886107901 | (37.7529764040195, -122.444528861079) | |||
| 108764 | 108764 | 109005 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 525x BURNETT AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1x1 | 5999530.0 | 2102478.0 | 37.7529764040195 | -122.44452886107901 | (37.7529764040195, -122.444528861079) | ||||
| 111519 | 111519 | 109004 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 525x BURNETT AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1x1 | 5999530.0 | 2102478.0 | 37.7529764040195 | -122.44452886107901 | (37.7529764040195, -122.444528861079) | ||||
| 112794 | 112794 | 109003 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 525x BURNETT AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1x1 | 5999530.0 | 2102478.0 | 37.7529764040195 | -122.44452886107901 | (37.7529764040195, -122.444528861079) | ||||
| 126595 | 126595 | 109001 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 525x BURNETT AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1x1 | 5999530.0 | 2102478.0 | 37.7529764040195 | -122.44452886107901 | (37.7529764040195, -122.444528861079) | ||||
| 144446 | 144446 | 109002 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 525x BURNETT AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1x1 | 5999530.0 | 2102478.0 | 37.7529764040195 | -122.44452886107901 | (37.7529764040195, -122.444528861079) | ||||
| 85878 | 85878 | 92850 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3150 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | Permit Number 53071 | 5999589.0 | 2116381.0 | 37.7911538835614 | -122.44532437717501 | (37.7911538835614, -122.445324377175) | |||
| 116825 | 116825 | 87134 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 65 Mars St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50103 | 5999603.0 | 2105413.0 | 37.761039357097104 | -122.44448733345502 | (37.7610393570971, -122.444487333455) | |||
| 92584 | 92584 | 1668 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2679X LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5999625.0 | 2119128.0 | 37.7986984723422 | -122.445397421769 | (37.7986984723422, -122.445397421769) | |||
| 105367 | 105367 | 1669 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2679X LOMBARD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 5999625.0 | 2119128.0 | 37.7986984723422 | -122.445397421769 | (37.7986984723422, -122.445397421769) | |||
| 122468 | 122468 | 108098 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2800X Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999639.0 | 2117762.0 | 37.794948598912704 | -122.445250712888 | (37.7949485989127, -122.445250712888) | |||||
| 82713 | 82713 | 61493 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3149 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1984 12:00:00 AM | Permit Number 777095 | 5999649.96958977 | 2116015.59113069 | 37.790154046975395 | -122.445087143888 | (37.7901540469754, -122.445087143888) | |||
| 129314 | 129314 | 98979 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 38 MILEY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 778225 | 5999656.0 | 2118689.0 | 37.7974948649915 | -122.44525857219999 | (37.7974948649915, -122.4452585722) | ||
| 102629 | 102629 | 18083 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2973 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999723.95099 | 2114672.94601 | 37.7864717167835 | -122.444734627115 | (37.7864717167835, -122.444734627115) | |||
| 110357 | 110357 | 4014 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1515X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999764.24548 | 2109470.85295 | 37.772190404364096 | -122.44422126053001 | (37.7721904043641, -122.44422126053) | |||
| 113651 | 113651 | 57604 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 238 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/1976 12:00:00 AM | 3x3 | Permit Number 16491 | 5999828.22001193 | 2094390.77346711 | 37.730787818817504 | -122.44291685523399 | (37.7307878188175, -122.442916855234) | ||
| 116080 | 116080 | 110926 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2970 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 775246 | 5999959.8 | 2116452.8 | 37.79137218692 | -122.444046586367 | (37.79137218692, -122.444046586367) | ||||
| 101098 | 101098 | 116493 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1946 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999967.0 | 2115587.0 | 37.7889953375883 | -122.44395943989299 | (37.7889953375883, -122.443959439893) | ||||
| 122994 | 122994 | 105343 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2500X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999969.06573 | 2113691.8640900003 | 37.783791904828604 | -122.443816082596 | (37.7837919048286, -122.443816082596) | |||||
| 92303 | 92303 | 13285 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2576 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 3 | 3X3 | 6000068.810330001 | 2119230.46658 | 37.799005143246 | -122.443869066799 | (37.799005143246, -122.443869066799) | ||
| 93129 | 93129 | 113767 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1730 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6000110.0 | 2114968.0 | 37.7873038809733 | -122.443420199664 | (37.7873038809733, -122.443420199664) | |||
| 139960 | 139960 | 113763 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1730 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000110.0 | 2114968.0 | 37.7873038809733 | -122.443420199664 | (37.7873038809733, -122.443420199664) | |||
| 79945 | 79945 | 113775 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1712 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6000121.0 | 2114885.0 | 37.7870766118482 | -122.443376178084 | (37.7870766118482, -122.443376178084) | |||
| 87299 | 87299 | 97999 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 30 Eagle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000135.0 | 2104379.0 | 37.7582305885461 | -122.442573139957 | (37.7582305885461, -122.442573139957) | |||
| 93909 | 93909 | 98001 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 30 Eagle St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000135.0 | 2104379.0 | 37.7582305885461 | -122.442573139957 | (37.7582305885461, -122.442573139957) | |||
| 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) | ||
| 102716 | 102716 | 13308 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 300X Lyon St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 100 | 6000275.5456666 | 2109923.7813264 | 37.7734631881999 | -122.442485158742 | (37.7734631881999, -122.442485158742) | |||
| 103460 | 103460 | 13309 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 300X Lyon St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 100 | 6000275.5456666 | 2109923.7813264 | 37.7734631881999 | -122.442485158742 | (37.7734631881999, -122.442485158742) | |||
| 120460 | 120460 | 13310 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 300X Lyon St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 100 | 6000275.5456666 | 2109923.7813264 | 37.7734631881999 | -122.442485158742 | (37.7734631881999, -122.442485158742) | |||
| 87064 | 87064 | 58078 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4624 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/1977 12:00:00 AM | Permit Number 17049 | 6000401.0 | 2105218.0 | 37.7605494356876 | -122.44171341046699 | (37.7605494356876, -122.441713410467) | |||
| 123064 | 123064 | 110274 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 4624 18TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 6000413.0 | 2105241.0 | 37.7606132717498 | -122.4416735587 | (37.7606132717498, -122.4416735587) | |||
| 86538 | 86538 | 13307 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1377X Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000417.28547 | 2109565.1947 | 37.7724866778901 | -122.441969118639 | (37.7724866778901, -122.441969118639) | |||
| 92207 | 92207 | 13306 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1377X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000417.28547 | 2109565.1947 | 37.7724866778901 | -122.441969118639 | (37.7724866778901, -122.441969118639) | |||
| 144249 | 144249 | 13305 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1377X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000417.28547 | 2109565.1947 | 37.7724866778901 | -122.441969118639 | (37.7724866778901, -122.441969118639) | |||
| 88349 | 88349 | 59060 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4437 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1992 12:00:00 AM | 14 | 2x2 | Permit Number 30882 | 6000423.21385776 | 2102243.23045707 | 37.75238271007429 | -122.441423120737 | (37.7523827100743, -122.441423120737) | |
| 98164 | 98164 | 112394 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2 AMAZON AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6000472.0 | 2089324.0 | 37.7169122992795 | -122.440327982322 | (37.7169122992795, -122.440327982322) | ||||
| 120173 | 120173 | 18035 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2807 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000503.4629009 | 2114781.5023211003 | 37.786814236904505 | -122.442045513134 | (37.7868142369045, -122.442045513134) | |||
| 5440 | 5440 | 13266 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2460 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 70 | 3X3 | 6000592.3683 | 2119282.3787 | 37.7991775301158 | -122.44206111460501 | (37.7991775301158, -122.442061114605) | ||
| 89324 | 89324 | 57802 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 107 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1988 12:00:00 AM | 8 | 3x3 | Permit Number 25561 | 6000622.33928566 | 2102551.03510935 | 37.753239209170204 | -122.44075659160102 | (37.7532392091702, -122.440756591601) | |
| 108226 | 108226 | 4883 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 87 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 2X2 | 6000657.525159299 | 2098217.505729 | 37.7413423773337 | -122.44032415487499 | (37.7413423773337, -122.440324154875) | |||
| 102747 | 102747 | 62645 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 400 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25453 | 6000705.45672766 | 2110331.40246789 | 37.7746069085927 | -122.441027287197 | (37.7746069085927, -122.441027287197) |
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");