Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 139550 | 139550 | 95513 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5985988.88946 | 2112008.2856099997 | 37.7783619491242 | -122.49205757976002 | (37.7783619491242, -122.49205757976) | |||
| 96578 | 96578 | 95515 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5985992.57608 | 2111969.58011 | 37.7782558903759 | -122.492041976045 | (37.7782558903759, -122.492041976045) | |||
| 93377 | 93377 | 95497 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5985999.2312900005 | 2111660.71954 | 37.777408236422296 | -122.491996207782 | (37.7774082364223, -122.491996207782) | |||
| 124692 | 124692 | 95484 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986002.98697 | 2111639.37953 | 37.777349862368496 | -122.491981644298 | (37.7773498623685, -122.491981644298) | |||
| 91382 | 91382 | 95488 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986007.7101 | 2111508.12486 | 37.776989750535 | -122.491955639862 | (37.776989750535, -122.491955639862) | |||
| 140987 | 140987 | 95489 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986007.8525 | 2111486.5622099997 | 37.7769305539658 | -122.49195355936199 | (37.7769305539658, -122.491953559362) | |||
| 46618 | 46618 | 47195 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 371 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 6 | Permit Number 45155 | 5986820.372830001 | 2113443.94443 | 37.7823524278539 | -122.489286791849 | (37.7823524278539, -122.489286791849) | |
| 32706 | 32706 | 120106 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2651 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5987317.09594 | 2110472.8163099997 | 37.7742235329464 | -122.487350063639 | (37.7742235329464, -122.487350063639) | |||
| 162489 | 162489 | 120105 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2651 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5987348.97771 | 2110473.7803 | 37.7742280389644 | -122.48723985111201 | (37.7742280389644, -122.487239851112) | |||
| 27672 | 27672 | 120104 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2651 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5987387.7348 | 2110475.1455200003 | 37.7742340474401 | -122.48710588538201 | (37.7742340474401, -122.487105885382) | |||
| 164874 | 164874 | 43809 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301X 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 6 | Permit Number 43439 | 5989308.00445 | 2113283.29992 | 37.7820562394021 | -122.480669019793 | (37.7820562394021, -122.480669019793) | |
| 173552 | 173552 | 218775 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1423 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5991125.3108 | 2105694.23915 | 37.761324192066 | -122.473828208305 | (37.761324192066, -122.473828208305) | |||
| 175777 | 175777 | 68446 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1993 12:00:00 AM | 6 | Permit Number 32303 | 5992072.75481 | 2114889.3953400003 | 37.7866264342674 | -122.47122138404801 | (37.7866264342674, -122.471221384048) | ||
| 154123 | 154123 | 52457 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 522@ ANZA 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 6 | Permit Number 48568 | 5992231.03455 | 2111869.47508 | 37.778343715915206 | -122.47045376013901 | (37.7783437159152, -122.470453760139) | |
| 108610 | 108610 | 25213 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2435 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 6 | 3x3 | 5991877.560959999 | 2094367.52877 | 37.7302674980365 | -122.47040159900601 | (37.7302674980365, -122.470401599006) | ||
| 124759 | 124759 | 25215 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2411 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1996 12:00:00 AM | 6 | 3X3 | 5992017.8005099995 | 2094287.9738099999 | 37.730057167515604 | -122.469910986387 | (37.7300571675156, -122.469910986387) | ||
| 94151 | 94151 | 25287 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2390X Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1996 12:00:00 AM | 6 | 3X3 | 5992028.41499 | 2094382.48626 | 37.7303172887062 | -122.469881169704 | (37.7303172887062, -122.469881169704) | ||
| 83094 | 83094 | 25216 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2407 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 6 | 3X3 | 5992037.104280001 | 2094247.85119 | 37.7299481166344 | -122.46984133141399 | (37.7299481166344, -122.469841331414) | ||
| 89750 | 89750 | 25218 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2375 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 6 | 3X3 | 5992176.95374 | 2094185.34049 | 37.7297845605248 | -122.469353311194 | (37.7297845605248, -122.469353311194) | ||
| 126639 | 126639 | 25219 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2355 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 6 | 3X3 | 5992261.18749 | 2094144.32187 | 37.7296768009835 | -122.469059124236 | (37.7296768009835, -122.469059124236) | ||
| 114109 | 114109 | 25220 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2335 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 6 | 3X3 | 5992314.3392900005 | 2094095.02735 | 37.729544521444396 | -122.468871788642 | (37.7295445214444, -122.468871788642) | ||
| 41429 | 41429 | 219435 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1247 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992661.28483 | 2106962.1744 | 37.7648944511525 | -122.468608225701 | (37.7648944511525, -122.468608225701) | |||
| 111445 | 111445 | 29664 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2232 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 5992636.99947 | 2093738.93892 | 37.7285854269889 | -122.467730442067 | (37.7285854269889, -122.467730442067) | ||||
| 123841 | 123841 | 25286 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2232X Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 6 | 2X3 | 5992636.99947 | 2093738.93892 | 37.7285854269889 | -122.467730442067 | (37.7285854269889, -122.467730442067) | ||
| 94099 | 94099 | 25285 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 6 | 3X3 | 5992640.87111 | 2093746.9102599998 | 37.728607537869294 | -122.46771763720699 | (37.7286075378693, -122.467717637207) | ||
| 20624 | 20624 | 25466 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 446 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2015 12:00:00 AM | 6 | 3X3 | 5992823.9205 | 2088555.2969999998 | 37.714363200126904 | -122.466707603629 | (37.7143632001269, -122.466707603629) | ||
| 65118 | 65118 | 52463 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 575@ BALBOA 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 6 | Permit Number 48574 | 5993745.27169 | 2111594.95452 | 37.7776773937563 | -122.465195547979 | (37.7776773937563, -122.465195547979) | |
| 86022 | 86022 | 17243 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2003 12:00:00 AM | 6 | 3X34 | 5993969.30173 | 2088537.74626 | 37.7143810447114 | -122.462747471174 | (37.7143810447114, -122.462747471174) | ||
| 153727 | 153727 | 123356 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 712 04th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5994756.85987 | 2110644.08831 | 37.7751248504722 | -122.46162718724301 | (37.7751248504722, -122.461627187243) | |||
| 38984 | 38984 | 82050 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 116 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50668 | 5996119.951719999 | 2115777.79007 | 37.78929899740071 | -122.457283443584 | (37.7892989974007, -122.457283443584) | |
| 108794 | 108794 | 28590 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Ocean Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 6 | 3X3 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | ||
| 117573 | 117573 | 28588 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Ocean Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | |||
| 119764 | 119764 | 28589 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Ocean Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 6 | 3X3 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | ||
| 87032 | 87032 | 1201 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3099X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5996220.7283 | 2087044.1157099998 | 37.7104092959015 | -122.454857840965 | (37.7104092959015, -122.454857840965) | |||
| 95862 | 95862 | 1202 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3099X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5996220.7283 | 2087044.1157099998 | 37.7104092959015 | -122.454857840965 | (37.7104092959015, -122.454857840965) | |||
| 111383 | 111383 | 1199 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3099X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 5996220.7283 | 2087044.1157099998 | 37.7104092959015 | -122.454857840965 | (37.7104092959015, -122.454857840965) | |||
| 141065 | 141065 | 1200 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3099X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5996220.7283 | 2087044.1157099998 | 37.7104092959015 | -122.454857840965 | (37.7104092959015, -122.454857840965) | |||
| 79330 | 79330 | 26039 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 6 | 3X3 | 5996279.3875 | 2088089.20515 | 37.713282233928 | -122.454730559713 | (37.713282233928, -122.454730559713) | ||
| 108782 | 108782 | 15977 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5937 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1995 12:00:00 AM | 6 | 3X3 | 5996505.5077599995 | 2086284.06053 | 37.7083386912237 | -122.453818737586 | (37.7083386912237, -122.453818737586) | ||
| 84568 | 84568 | 15970 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5919X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1995 12:00:00 AM | 6 | 3X3 | 5996671.773019999 | 2086351.2464599998 | 37.708532699460896 | -122.45324895592199 | (37.7085326994609, -122.453248955922) | ||
| 9415 | 9415 | 15943 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5810X MISSION ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 5997175.0 | 2086632.0 | 37.7093324147693 | -122.451529986796 | (37.7093324147693, -122.451529986796) | |||
| 96152 | 96152 | 15940 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5810X MISSION ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/20/1998 12:00:00 AM | 6 | 3X3 | 5997175.0 | 2086632.0 | 37.7093324147693 | -122.451529986796 | (37.7093324147693, -122.451529986796) | ||
| 79600 | 79600 | 15934 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5775 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5997641.29025 | 2086713.63365 | 37.7095832536665 | -122.449924299561 | (37.7095832536665, -122.449924299561) | ||
| 61474 | 61474 | 219454 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 51 Geneva Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997958.98585 | 2091156.6658700001 | 37.7218009711136 | -122.44914616368999 | (37.7218009711136, -122.44914616369) | |||
| 183598 | 183598 | 219453 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 51 Geneva Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997974.85097 | 2091146.69585 | 37.7217745031653 | -122.449090604454 | (37.7217745031653, -122.449090604454) | |||
| 76587 | 76587 | 136923 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999086.92676 | 2119150.62372 | 37.7987298603595 | -122.447260949053 | (37.7987298603595, -122.447260949053) | |||
| 129631 | 129631 | 136922 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999089.06765 | 2119133.9695599996 | 37.798684254832004 | -122.44725234164801 | (37.798684254832, -122.447252341648) | |||
| 42471 | 42471 | 69532 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2395 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 6 | Permit Number 38574 | 5999900.2494 | 2119838.00764 | 37.8006636725595 | -122.444496029289 | (37.8006636725595, -122.444496029289) | ||
| 11724 | 11724 | 25307 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 355 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/1996 12:00:00 AM | 6 | 3X3 | 5999438.14042 | 2091535.09661 | 37.7229245454182 | -122.444060305044 | (37.7229245454182, -122.444060305044) | ||
| 90501 | 90501 | 111366 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2x MELROSE AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x9 | 5999779.0 | 2095500.0 | 37.7338306891962 | -122.443166651102 | (37.7338306891962, -122.443166651102) | |||
| 103584 | 103584 | 111364 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2x MELROSE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x9 | 5999779.0 | 2095500.0 | 37.7338306891962 | -122.443166651102 | (37.7338306891962, -122.443166651102) | |||
| 114489 | 114489 | 111363 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2x MELROSE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x9 | 5999779.0 | 2095500.0 | 37.7338306891962 | -122.443166651102 | (37.7338306891962, -122.443166651102) | |||
| 116463 | 116463 | 111365 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2x MELROSE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x9 | 5999779.0 | 2095500.0 | 37.7338306891962 | -122.443166651102 | (37.7338306891962, -122.443166651102) | |||
| 142815 | 142815 | 15859 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5367 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5999657.0 | 2088324.0 | 37.7141200881786 | -122.44307325545601 | (37.7141200881786, -122.443073255456) | ||
| 125649 | 125649 | 15854 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5319 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5999668.720480001 | 2088318.36983 | 37.714105297270606 | -122.443032341019 | (37.7141052972706, -122.443032341019) | ||
| 7392 | 7392 | 61776 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2939 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1993 12:00:00 AM | 6 | 3x3 | 6000507.69204 | 2118417.15605 | 37.7967970320012 | -122.44229197620001 | (37.7967970320012, -122.4422919762) | ||
| 6718 | 6718 | 97922 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2939 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000509.433540001 | 2118403.315 | 37.7967591273891 | -122.442284956098 | (37.7967591273891, -122.442284956098) | |||
| 8887 | 8887 | 97923 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2939 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000511.871719999 | 2118390.4696 | 37.7967239962744 | -122.442275596851 | (37.7967239962744, -122.442275596851) | |||
| 13082 | 13082 | 15846 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5256 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | 6 | 3x3 | Permit Number 775938 | 5999899.043409999 | 2088666.4410599999 | 37.7150741519211 | -122.442261231071 | (37.7150741519211, -122.442261231071) | |
| 184532 | 184532 | 180425 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 223 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001022.23935 | 2092393.12338 | 37.7253707319678 | -122.43864586561001 | (37.7253707319678, -122.43864586561) | |||
| 54205 | 54205 | 180426 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 223 San Juan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001041.98987 | 2092379.20948 | 37.7253336511123 | -122.43857659355899 | (37.7253336511123, -122.438576593559) | |||
| 157381 | 157381 | 83896 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 207 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50521 | 6001150.26292 | 2092302.9729900002 | 37.7251304816593 | -122.438196845812 | (37.7251304816593, -122.438196845812) | |
| 92194 | 92194 | 26649 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1686 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/1998 12:00:00 AM | 6 | 4X4 | 6001954.59403 | 2112257.165987 | 37.7799656396512 | -122.43684416995899 | (37.7799656396512, -122.436844169959) | ||
| 83003 | 83003 | 22765 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1674 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/1997 12:00:00 AM | 6 | 4X4 | 6002010.254376 | 2112254.96617 | 37.7799627627699 | -122.436651458736 | (37.7799627627699, -122.436651458736) | ||
| 12419 | 12419 | 981 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1604 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2003 12:00:00 AM | 6 | 3X3 | 6001745.7594099995 | 2092854.52102 | 37.7266787581039 | -122.436177732017 | (37.7266787581039, -122.436177732017) | ||
| 122804 | 122804 | 22761 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1640 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/1997 12:00:00 AM | 6 | 3X3 | 6002164.690701 | 2112286.628689 | 37.7800584752671 | -122.436119461658 | (37.7800584752671, -122.436119461658) | ||
| 129890 | 129890 | 69487 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 424 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 6 | Permit Number 33609 | 6002110.58866 | 2093918.45002 | 37.7296207867519 | -122.43499258833401 | (37.7296207867519, -122.434992588334) | |
| 97651 | 97651 | 22731 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1560 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1997 12:00:00 AM | 6 | 3X3 | 6002579.60353 | 2112492.8275 | 37.780648209102395 | -122.43469884150801 | (37.7806482091024, -122.434698841508) | ||
| 123865 | 123865 | 22743 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1575 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | 3x3 | 6002621.38954 | 2112212.2211 | 37.7798801065849 | -122.43453421421499 | (37.7798801065849, -122.434534214215) | ||
| 6827 | 6827 | 100292 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3701 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003061.81659 | 2121064.97367 | 37.804212487284005 | -122.43364345509701 | (37.804212487284, -122.433643455097) | |||
| 124395 | 124395 | 22709 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1420 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2001 12:00:00 AM | 6 | 3X3 | 6002934.09844 | 2112391.17322 | 37.780389210721005 | -122.433465208396 | (37.780389210721, -122.433465208396) | ||
| 99395 | 99395 | 22708 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1420 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | 3X3 | 6002966.72006 | 2112394.81869 | 37.780401071007795 | -122.43335261565399 | (37.7804010710078, -122.433352615654) | ||
| 140627 | 140627 | 22707 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1420 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | 3X3 | 6003000.316869999 | 2112401.14844 | 37.7804203568686 | -122.433236841096 | (37.7804203568686, -122.433236841096) | ||
| 88088 | 88088 | 22706 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1420 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | 3X3 | 6003033.98605 | 2112410.1866099997 | 37.7804470833639 | -122.433121009687 | (37.7804470833639, -122.433121009687) | ||
| 89638 | 89638 | 22703 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1410 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2001 12:00:00 AM | 6 | 3X3 | 6003133.70477 | 2112422.88036 | 37.7804875932729 | -122.432776943127 | (37.7804875932729, -122.432776943127) | ||
| 89793 | 89793 | 22701 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | 3X3 | 6003258.39673 | 2112440.37761 | 37.7805427074609 | -122.432346825159 | (37.7805427074609, -122.432346825159) | ||
| 144092 | 144092 | 22698 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1390 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1997 12:00:00 AM | 6 | 3X3 | 6003367.49805 | 2112454.4444 | 37.7805875170515 | -122.43197039694701 | (37.7805875170515, -122.431970396947) | ||
| 100477 | 100477 | 22696 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1390 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1997 12:00:00 AM | 6 | 3X3 | 6003467.66311 | 2112468.72246 | 37.780632399020796 | -122.431624898149 | (37.7806323990208, -122.431624898149) | ||
| 150136 | 150136 | 242914 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 326 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003748.60562 | 2099259.79726 | 37.7443797812115 | -122.429710605574 | (37.7443797812115, -122.429710605574) | |||
| 168978 | 168978 | 180434 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 138 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004160.88831 | 2092879.02625 | 37.7268829644663 | -122.42783045321 | (37.7268829644663, -122.42783045321) | |||
| 74244 | 74244 | 242911 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1750 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004608.20816 | 2098643.6107799998 | 37.74273651209621 | -122.426694407136 | (37.7427365120962, -122.426694407136) | |||
| 128364 | 128364 | 26781 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1762 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004617.6627263 | 2098622.9472722 | 37.7426803093545 | -122.426660244792 | (37.7426803093545, -122.426660244792) | |||
| 20345 | 20345 | 5583 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1069 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6005153.43733 | 2102137.63056 | 37.752361098006894 | -122.42505770847299 | (37.7523610980069, -122.425057708473) | |||
| 89102 | 89102 | 22603 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 888 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/1997 12:00:00 AM | 6 | 4X4 | 6005725.0 | 2112755.0 | 37.781546136890796 | -122.423836042859 | (37.7815461368908, -122.423836042859) | ||
| 86162 | 86162 | 40837 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2001 12:00:00 AM | 6 | Permit Number 44013 | 6005959.59269247 | 2110712.95216168 | 37.775952411307394 | -122.422879289341 | (37.7759524113074, -122.422879289341) | ||
| 104635 | 104635 | 22590 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 801 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/1997 12:00:00 AM | 6 | 4x4 | 6006166.11327 | 2112793.0062543997 | 37.781675384913605 | -122.422312701127 | (37.7816753849136, -122.422312701127) | ||
| 108601 | 108601 | 22587 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 801 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/1997 12:00:00 AM | 6 | 4x4 | 6006166.11327 | 2112793.0062543997 | 37.781675384913605 | -122.422312701127 | (37.7816753849136, -122.422312701127) | ||
| 121794 | 121794 | 242867 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1346 Stevenson St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6006264.314669999 | 2108835.25141 | 37.7708138850713 | -122.421691777169 | (37.7708138850713, -122.421691777169) | |||
| 179775 | 179775 | 242346 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1353 Stevenson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006282.631569999 | 2108802.50666 | 37.7707250086772 | -122.421626092471 | (37.7707250086772, -122.421626092471) | |||
| 12406 | 12406 | 27090 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 725 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X3 | 6006149.91754 | 2093595.5123 | 37.7289625981285 | -122.42100526258801 | (37.7289625981285, -122.421005262588) | |||
| 33164 | 33164 | 44473 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 258 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 6 | Permit Number 43787 | 6006246.79793 | 2092607.35071 | 37.7262547826049 | -122.420600221446 | (37.7262547826049, -122.420600221446) | |
| 169657 | 169657 | 31083 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1397 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34820 | 6006997.21961 | 2107418.2322400003 | 37.766964386521394 | -122.419056113368 | (37.7669643865214, -122.419056113368) | |
| 50918 | 50918 | 242882 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1399 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007001.44379 | 2107374.71472 | 37.7668451355276 | -122.419038415585 | (37.7668451355276, -122.419038415585) | |||
| 184893 | 184893 | 31070 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1564 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34815 | 6007025.21952 | 2107350.5984 | 37.7667802566181 | -122.41895446839199 | (37.7667802566181, -122.418954468392) | |
| 153111 | 153111 | 136951 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 685 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6007589.5511300005 | 2121604.68053 | 37.8059502490578 | -122.418013126415 | (37.8059502490578, -122.418013126415) | |||
| 176525 | 176525 | 136952 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 685 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6007607.689119999 | 2121607.56476 | 37.8059591892382 | -122.417950561469 | (37.8059591892382, -122.417950561469) | |||
| 159410 | 159410 | 242885 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 435 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007449.5098 | 2107068.51077 | 37.7660295925224 | -122.417466921388 | (37.7660295925224, -122.417466921388) | |||
| 151354 | 151354 | 136935 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 935 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007697.83158 | 2115657.05879 | 37.7896256581417 | -122.417216679615 | (37.7896256581417, -122.417216679615) | |||
| 65248 | 65248 | 242879 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1474 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007562.74357 | 2107381.13607 | 37.7668943590015 | -122.41709742140301 | (37.7668943590015, -122.417097421403) | |||
| 35409 | 35409 | 78535 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 62 Colby St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2000 12:00:00 AM | 6 | 6007981.72204 | 2093794.7148099998 | 37.7296126541786 | -122.41468665108 | (37.7296126541786, -122.41468665108) |
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");