trees
417 rows where Supervisor Districts = 11 and qSpecies_id = 53 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37838 | 102503 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 290X Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | 6003881.1 | 2108703.5 | 37.7703174504719 | -122.429925966233 | (37.7703174504719, -122.429925966233) | 7 | 9 | 11 | 29492 | 10 | ||||
| 21029 | 102504 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 290X Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6003881.1 | 2108703.5 | 37.7703174504719 | -122.429925966233 | (37.7703174504719, -122.429925966233) | 7 | 9 | 11 | 29492 | 10 | ||||
| 61596 | 102505 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 290X Hermann St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x7 | 6003881.1 | 2108703.5 | 37.7703174504719 | -122.429925966233 | (37.7703174504719, -122.429925966233) | 7 | 9 | 11 | 29492 | 10 | ||||
| 60833 | 102647 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 221 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x9 | 6002283 | 2109227 | 37.7716642197307 | -122.435491238531 | (37.7716642197307, -122.435491238531) | 15 | 5 | 11 | 29492 | 9 | ||||
| 148808 | 102824 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2001X Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997438 | 2109144 | 37.7711599615563 | -122.452244312179 | (37.7711599615563, -122.452244312179) | 15 | 5 | 11 | 29492 | 9 | ||||
| 59389 | 102825 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2001X Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997438 | 2109144 | 37.7711599615563 | -122.452244312179 | (37.7711599615563, -122.452244312179) | 15 | 5 | 11 | 29492 | 9 | ||||
| 28710 | 102826 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2001X Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997438 | 2109144 | 37.7711599615563 | -122.452244312179 | (37.7711599615563, -122.452244312179) | 15 | 5 | 11 | 29492 | 9 | ||||
| 170119 | 103480 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1247 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x5 | Permit Number 31998 | 5994182.5 | 2107061.8 | 37.765255754741 | -122.463353999562 | (37.765255754741, -122.463353999562) | 11 | 5 | 11 | 56 | 12 | ||
| 107943 | 104241 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1544 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998256.5 | 2108266.6 | 37.768797699923 | -122.44934987666 | (37.768797699923, -122.44934987666) | 15 | 5 | 11 | 29492 | 9 | ||||
| 130761 | 10462 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1576 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5998589.8073 | 2108666.88124 | 37.7699158304312 | -122.448225822875 | (37.7699158304312, -122.448225822875) | 15 | 5 | 11 | 29492 | 9 | |||
| 105646 | 10464 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1584 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5998533.97425 | 2108659.62994 | 37.7698927281656 | -122.448418425141 | (37.7698927281656, -122.448418425141) | 15 | 5 | 11 | 29492 | 9 | |||
| 8565 | 105233 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1508 WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5998474.1 | 2108297 | 37.7688936152058 | -122.448599407064 | (37.7688936152058, -122.448599407064) | 15 | 5 | 11 | 29492 | 9 | |||
| 23596 | 105340 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1401 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2014 12:00:00 AM | 12 | Permit Number 770950 | 6000144.5 | 2113810 | 37.7841262805256 | -122.443217635242 | (37.7841262805256, -122.443217635242) | 15 | 6 | 11 | 29490 | 31 | ||
| 162853 | 105343 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2500X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999969.06573 | 2113691.86409 | 37.7837919048286 | -122.443816082596 | (37.7837919048286, -122.443816082596) | 15 | 6 | 11 | 29490 | 31 | |||||
| 188563 | 10618 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 350 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006025.52151 | 2110969.11138 | 37.7766594822933 | -122.422669431679 | (37.7766594822933, -122.422669431679) | 7 | 9 | 11 | 28852 | 10 | |||
| 83704 | 10626 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 414 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6005955 | 2111106 | 37.7770313662769 | -122.422923117926 | (37.7770313662769, -122.422923117926) | 7 | 9 | 11 | 28852 | 10 | |||
| 162520 | 10628 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 805 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 6 | 3X4 | 6003942.23141 | 2110755.32974 | 37.775954734286 | -122.429860889744 | (37.775954734286, -122.429860889744) | 7 | 9 | 11 | 29492 | 10 | ||
| 172277 | 10647 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 913 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6003471.55966 | 2110689.4075 | 37.775747062973 | -122.431484357932 | (37.775747062973, -122.431484357932) | 15 | 9 | 11 | 29492 | 10 | ||
| 177966 | 106938 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1607 WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5997889 | 2108175 | 37.7685251613651 | -122.450614421545 | (37.7685251613651, -122.450614421545) | 15 | 5 | 11 | 29492 | 9 | ||||
| 135459 | 106967 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1225 02ND AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5995419.1 | 2107212.6 | 37.7657409782079 | -122.459087842629 | (37.7657409782079, -122.459087842629) | 15 | 5 | 11 | 56 | 12 | ||||||
| 43983 | 10710 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 17X Hollis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003901.15311 | 2113362.61867 | 37.7831113762968 | -122.430189039187 | (37.7831113762968, -122.430189039187) | 7 | 9 | 11 | 29490 | 41 | |||
| 151746 | 10712 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 17X Hollis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6003917.66999 | 2113282.5787 | 37.7828925420276 | -122.430126185708 | (37.7828925420276, -122.430126185708) | 7 | 9 | 11 | 29490 | 41 | |||
| 110927 | 10713 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 17X Hollis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6003918.21533 | 2113256.44585 | 37.7828208186367 | -122.430122434181 | (37.7828208186367, -122.430122434181) | 7 | 9 | 11 | 29490 | 41 | |||
| 115288 | 107652 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 600 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2014 12:00:00 AM | 3 | Permit Number 772916 | 6005452.33302 | 2111401.13742 | 37.7778133653937 | -122.424683001313 | (37.7778133653937, -122.424683001313) | 7 | 9 | 11 | 28852 | 10 | ||
| 116014 | 107653 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 600 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2014 12:00:00 AM | 3 | Permit Number 772916 | 6005452.33302 | 2111401.13742 | 37.7778133653937 | -122.424683001313 | (37.7778133653937, -122.424683001313) | 7 | 9 | 11 | 28852 | 10 | ||
| 26376 | 107654 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 600 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2014 12:00:00 AM | 3 | Permit Number 772916 | 6005452.33302 | 2111401.13742 | 37.7778133653937 | -122.424683001313 | (37.7778133653937, -122.424683001313) | 7 | 9 | 11 | 28852 | 10 | ||
| 102782 | 109882 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1520 PAGE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.446241403234 | (37.7711622584795, -122.446241403234) | 15 | 5 | 11 | 29492 | 9 | ||||
| 163074 | 110027 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1101X WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6003707 | 2112516 | 37.7807757743573 | -122.430800292528 | (37.7807757743573, -122.430800292528) | 15 | 9 | 11 | 29490 | 41 | ||||
| 145447 | 110581 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 401x BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6001156 | 2110113 | 37.7740328816457 | -122.439453113359 | (37.7740328816457, -122.439453113359) | 15 | 5 | 11 | 29492 | 10 | ||||
| 155645 | 110676 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1898 SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001594 | 2114879 | 37.7871440264162 | -122.438279504546 | (37.7871440264162, -122.438279504546) | 13 | 6 | 11 | 29490 | 27 | ||||
| 48462 | 111114 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2085 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5997903.58032533 | 2109906.22418863 | 37.7732794935428 | -122.450688824407 | (37.7732794935428, -122.450688824407) | 15 | 5 | 11 | 29492 | 16 | ||||
| 90078 | 111115 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2085 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5997903.58032533 | 2109906.22418863 | 37.7732794935428 | -122.450688824407 | (37.7732794935428, -122.450688824407) | 15 | 5 | 11 | 29492 | 16 | ||||
| 26693 | 111116 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2085 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5997903.58032533 | 2109906.22418863 | 37.7732794935428 | -122.450688824407 | (37.7732794935428, -122.450688824407) | 15 | 5 | 11 | 29492 | 16 | ||||
| 36005 | 111369 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 724 IRVING ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993485 | 2106687 | 37.7641864431876 | -122.465739233402 | (37.7641864431876, -122.465739233402) | 11 | 8 | 11 | 56 | 12 | ||||
| 158763 | 111774 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 215 CLAYTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5998260 | 2109886 | 37.7732443583423 | -122.449454468346 | (37.7732443583423, -122.449454468346) | 15 | 5 | 11 | 29492 | 16 | |||
| 20310 | 112288 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 895x PAGE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002361 | 2109458 | 37.7723029182135 | -122.435237957834 | (37.7723029182135, -122.435237957834) | 15 | 5 | 11 | 29492 | 9 | ||||
| 92694 | 112578 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 660x Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999086 | 2108401 | 37.7692141419233 | -122.446490377962 | (37.7692141419233, -122.446490377962) | 15 | 5 | 11 | 29492 | 9 | ||||
| 180149 | 112971 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 601x COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5997795 | 2108483 | 37.7693654697431 | -122.450961770246 | (37.7693654697431, -122.450961770246) | 15 | 5 | 11 | 29492 | 9 | |||
| 162574 | 113000 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 49558 | 113001 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 118914 | 113002 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 184217 | 113003 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 38742 | 113004 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 43330 | 113005 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 173558 | 113006 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 173238 | 113007 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 176974 | 113008 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 105584 | 113009 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 107825 | 113010 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 102388 | 113158 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1104 STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997339 | 2106686 | 37.764405251212 | -122.452409351598 | (37.764405251212, -122.452409351598) | 15 | 5 | 11 | 29492 | 9 | ||||
| 156343 | 113279 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2 Hugo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5995790.34429445 | 2107089.36315796 | 37.7654239364323 | -122.457794878244 | (37.7654239364323, -122.457794878244) | 15 | 5 | 11 | 56 | 12 | ||||
| 90763 | 113321 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 222 HERMANN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6004169 | 2108774 | 37.7705273263251 | -122.428935147688 | (37.7705273263251, -122.428935147688) | 7 | 9 | 11 | 29492 | 10 | |||
| 170574 | 114952 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 601X OCTAVIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005348 | 2111368 | 37.7777164851071 | -122.42504156742 | (37.7777164851071, -122.42504156742) | 7 | 9 | 11 | 28852 | 10 | ||||
| 137864 | 115903 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 201 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 4x4 | 6003287.79827449 | 2108952.35112135 | 37.7709671172915 | -122.431995967048 | (37.7709671172915, -122.431995967048) | 15 | 9 | 11 | 29492 | 9 | ||
| 74559 | 115904 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||||
| 106362 | 115905 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||||
| 151430 | 115906 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||
| 35050 | 115907 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||
| 20084 | 115908 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||
| 39288 | 116011 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1448 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2016 12:00:00 AM | 3 | 6000920 | 2110390.8 | 37.7747822166773 | -122.440289401956 | (37.7747822166773, -122.440289401956) | 15 | 5 | 11 | 29492 | 10 | |||
| 111821 | 116112 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 201x SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002265 | 2109203 | 37.7715972993524 | -122.435551784305 | (37.7715972993524, -122.435551784305) | 15 | 5 | 11 | 29492 | 9 | ||||
| 151645 | 116113 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 201x SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002265 | 2109203 | 37.7715972993524 | -122.435551784305 | (37.7715972993524, -122.435551784305) | 15 | 5 | 11 | 29492 | 9 | ||||
| 105056 | 116231 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1486 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5998599.14429808 | 2108320.44227206 | 37.7689651308865 | -122.448168577388 | (37.7689651308865, -122.448168577388) | 15 | 5 | 11 | 29492 | 9 | ||||
| 134924 | 116232 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1486 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x7 | 5998599.14429808 | 2108320.44227206 | 37.7689651308865 | -122.448168577388 | (37.7689651308865, -122.448168577388) | 15 | 5 | 11 | 29492 | 9 | ||||
| 132056 | 116509 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500x Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 3x3 | 5998488 | 2108327 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | 15 | 5 | 11 | 29492 | 9 | ||
| 28579 | 116510 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1500x Waller St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998488 | 2108327 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | 15 | 5 | 11 | 29492 | 9 | ||||
| 165112 | 116511 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1500x Waller St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998488 | 2108327 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | 15 | 5 | 11 | 29492 | 9 | ||||
| 71007 | 116518 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 480 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2016 12:00:00 AM | 3 | 9x6 | 6003703 | 2109976 | 37.7738013362642 | -122.430632829648 | (37.7738013362642, -122.430632829648) | 7 | 9 | 11 | 29492 | 10 | ||
| 129156 | 116906 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 358 Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 6003554.93862357 | 2108664.35445356 | 37.7701914899734 | -122.431051362966 | (37.7701914899734, -122.431051362966) | 15 | 9 | 11 | 29492 | 10 | ||||
| 172861 | 117048 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2183 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6002170 | 2114323 | 37.7856501363162 | -122.436246868292 | (37.7856501363162, -122.436246868292) | 13 | 6 | 11 | 29490 | 13 | |||
| 128624 | 117343 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 372 HAYES ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6006019 | 2111114 | 37.7770569433878 | -122.422702290381 | (37.7770569433878, -122.422702290381) | 7 | 9 | 11 | 28852 | 10 | ||||
| 172169 | 117345 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 395 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006014 | 2111158 | 37.7771774746178 | -122.422722714586 | (37.7771774746178, -122.422722714586) | 7 | 9 | 11 | 28852 | 10 | ||||
| 122156 | 120530 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1390 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | 15 | 5 | 11 | 29492 | 9 | ||||
| 52375 | 120531 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1390 Waller St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | 15 | 5 | 11 | 29492 | 9 | ||||
| 152847 | 120532 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1390 Waller St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | 15 | 5 | 11 | 29492 | 9 | ||||
| 125686 | 121101 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 600x Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998712 | 2105642 | 37.7616172542124 | -122.447585388011 | (37.7616172542124, -122.447585388011) | 15 | 5 | 11 | 29492 | 12 | ||||
| 70103 | 121337 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 44 Hugo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5995656.55399656 | 2107084.69972772 | 37.7654034448102 | -122.458257287589 | (37.7654034448102, -122.458257287589) | 15 | 5 | 11 | 56 | 12 | ||||
| 147215 | 121369 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11x Seymour St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001614 | 2112138 | 37.7796190766925 | -122.438013896478 | (37.7796190766925, -122.438013896478) | 15 | 5 | 11 | 29490 | 41 | ||||
| 141056 | 121371 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11x Seymour St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001614 | 2112138 | 37.7796190766925 | -122.438013896478 | (37.7796190766925, -122.438013896478) | 15 | 5 | 11 | 29490 | 41 | ||||
| 142334 | 12245 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 503 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2015 03:15:00 PM | 3 | 5x5 | Permit Number 780762 | 6004995.5845 | 2110652.4736 | 37.7757319109571 | -122.426209740207 | (37.7757319109571, -122.426209740207) | 7 | 9 | 11 | 28852 | 10 | |
| 117462 | 12246 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 501 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2015 03:15:00 PM | 3 | 5x5 | 6004973.20209 | 2110637.42143 | 37.775689316239 | -122.426286094705 | (37.775689316239, -122.426286094705) | 7 | 9 | 11 | 28852 | 10 | ||
| 57513 | 12263 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 640 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004991.72568 | 2111198.95935 | 37.7772322091826 | -122.426262005109 | (37.7772322091826, -122.426262005109) | 7 | 9 | 11 | 28852 | 10 | |||
| 119332 | 12427 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1710 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/1989 12:00:00 AM | 12 | 4X4 | 6004482.43729 | 2114709.16781 | 37.7868415701808 | -122.428274031584 | (37.7868415701808, -122.428274031584) | 13 | 9 | 11 | 28858 | 27 | ||
| 96583 | 12428 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1710 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/1989 12:00:00 AM | 12 | 4X4 | 6004482.43729 | 2114709.16781 | 37.7868415701808 | -122.428274031584 | (37.7868415701808, -122.428274031584) | 13 | 9 | 11 | 28858 | 27 | ||
| 181818 | 13305 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1377X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6000417.28547 | 2109565.1947 | 37.7724866778901 | -122.441969118639 | (37.7724866778901, -122.441969118639) | 15 | 5 | 11 | 29492 | 9 | |||
| 87620 | 13306 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1377X Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000417.28547 | 2109565.1947 | 37.7724866778901 | -122.441969118639 | (37.7724866778901, -122.441969118639) | 15 | 5 | 11 | 29492 | 9 | |||
| 75844 | 13307 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1377X Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6000417.28547 | 2109565.1947 | 37.7724866778901 | -122.441969118639 | (37.7724866778901, -122.441969118639) | 15 | 5 | 11 | 29492 | 9 | |||
| 113625 | 13308 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 300X Lyon St | 1 | Median : Cutout | Tree | DPW 1 | 6 | 100 | 6000275.5456666 | 2109923.7813264 | 37.7734631881999 | -122.442485158742 | (37.7734631881999, -122.442485158742) | 15 | 5 | 11 | 29492 | 16 | |||
| 105017 | 13309 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 300X Lyon St | 2 | Median : Cutout | Tree | DPW 1 | 6 | 100 | 6000275.5456666 | 2109923.7813264 | 37.7734631881999 | -122.442485158742 | (37.7734631881999, -122.442485158742) | 15 | 5 | 11 | 29492 | 16 | |||
| 156516 | 13310 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 300X Lyon St | 3 | Median : Cutout | Tree | DPW 1 | 6 | 100 | 6000275.5456666 | 2109923.7813264 | 37.7734631881999 | -122.442485158742 | (37.7734631881999, -122.442485158742) | 15 | 5 | 11 | 29492 | 16 | |||
| 2956 | 139431 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 539 OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005398.6042 | 2111220.8061 | 37.7773151849796 | -122.424856035409 | (37.7773151849796, -122.424856035409) | 7 | 9 | 11 | 28852 | 10 | |||
| 18607 | 139432 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 539 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005403.0601 | 2111196.299 | 37.77724814614 | -122.424838877048 | (37.77724814614, -122.424838877048) | 7 | 9 | 11 | 28852 | 10 | |||
| 18271 | 139433 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 539 OCTAVIA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005406.0306 | 2111183.3028 | 37.7772126295238 | -122.424827676313 | (37.7772126295238, -122.424827676313) | 7 | 9 | 11 | 28852 | 10 | |||
| 5715 | 140049 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 651 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005353.1353 | 2111583.6293 | 37.778308840554 | -122.42503914867 | (37.778308840554, -122.42503914867) | 7 | 9 | 11 | 28852 | 10 | |||
| 6753 | 140065 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 612 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005425.1416 | 2111379.12 | 37.7777513751906 | -122.424775499228 | (37.7777513751906, -122.424775499228) | 7 | 9 | 11 | 28852 | 10 | |||
| 12493 | 140066 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 614 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005423.0428 | 2111393.287 | 37.7777901557735 | -122.424783767818 | (37.7777901557735, -122.424783767818) | 7 | 9 | 11 | 28852 | 10 | |||
| 15896 | 140067 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 616 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005420.4192 | 2111411.6517 | 37.7778404325738 | -122.424794150591 | (37.7778404325738, -122.424794150591) | 7 | 9 | 11 | 28852 | 10 | |||
| 2723 | 140583 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 949 FILLMORE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6003424.6737 | 2111485.9504 | 37.7779315149131 | -122.431703431668 | (37.7779315149131, -122.431703431668) | 15 | 9 | 11 | 29492 | 41 | |||
| 34775 | 14651 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 655X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.7797037167615 | -122.422781416289 | (37.7797037167615, -122.422781416289) | 7 | 9 | 11 | 28852 | 10 | |||
| 83435 | 14655 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 655X McAllister St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.7797037167615 | -122.422781416289 | (37.7797037167615, -122.422781416289) | 7 | 9 | 11 | 28852 | 10 |
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) );