trees
8,659 rows where qSpecies_id = 11 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
54974 | 45388 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | 11 | 1 | 61 | 30 | |||||
85908 | 45386 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | 11 | 1 | 61 | 30 | |||||
132310 | 87691 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2640X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6010453.75722 | 2085956.27314 | 37.7082284842795 | -122.40558866725 | (37.7082284842795, -122.40558866725) | 28588 | |||||||
143428 | 45387 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | 11 | 1 | 61 | 30 | |||||
171870 | 87692 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2640X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6010446.60881 | 2085937.89343 | 37.708177617555 | -122.405612079416 | (37.708177617555, -122.405612079416) | 28588 | |||||||
187575 | 45385 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | 11 | 1 | 61 | 30 | |||||
194389 | 265057 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
194396 | 265058 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
194403 | 265059 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
254 | 130309 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Vallejo St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013009.60555 | 2119229.44522 | 37.7997319839043 | -122.399089221411 | (37.7997319839043, -122.399089221411) | 3 | 1 | 10 | 28860 | 6 | |||
572 | 130258 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6007346.42047 | 2122267.68592 | 37.8077570059352 | -122.418901572974 | (37.8077570059352, -122.418901572974) | 5 | 1 | 10 | 308 | 23 | |||
809 | 66604 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 795 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1993 12:00:00 AM | 17 | 3x3 | Permit Number 31919 | 6008813.15818 | 2115243.41738 | 37.7885525825831 | -122.413328486829 | (37.7885525825831, -122.413328486829) | 5 | 1 | 10 | 28858 | 21 |
1205 | 71779 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1062 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6007509.77749 | 2115111.57122 | 37.7881173017281 | -122.417828646693 | (37.7881173017281, -122.417828646693) | 13 | 1 | 10 | 28858 | 21 | |||
1719 | 65271 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 642 Commercial St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/1989 12:00:00 AM | 10 | Permit Number 28073 | 6011614.69631 | 2117224.41681 | 37.7941488271457 | -122.403774986938 | (37.7941488271457, -122.403774986938) | 3 | 1 | 10 | 28860 | 4 | ||
2892 | 52020 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1001 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50061 | 6009007.02458 | 2115965.45342 | 37.7905460009358 | -122.41270880089 | (37.7905460009358, -122.41270880089) | 5 | 1 | 10 | 28858 | 21 | |
3490 | 128009 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 490 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 02:34:00 PM | 3 | Width 3ft | 6008457.49636 | 2121430.59221 | 37.8055210575117 | -122.414997125824 | (37.8055210575117, -122.414997125824) | 3 | 1 | 10 | 308 | 23 | ||
3575 | 130205 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1033 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6009172.7127 | 2117683.88931 | 37.7952737045641 | -122.412257035446 | (37.7952737045641, -122.412257035446) | 3 | 1 | 10 | 28857 | 21 | |||
3733 | 60222 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1200 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1982 12:00:00 AM | 16 | Permit Number 19772 | 6009437.72242 | 2117453.02752 | 37.7946546814167 | -122.411323738797 | (37.7946546814167, -122.411323738797) | 3 | 1 | 10 | 28857 | 4 | |
3821 | 130402 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 537 Washington St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011944.02835 | 2117720.9303 | 37.7955305266544 | -122.402670389235 | (37.7955305266544, -122.402670389235) | 3 | 1 | 10 | 28860 | 4 | |||
5225 | 76274 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 753 Davis St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6013063.67102 | 2119100.92888 | 37.7993821215331 | -122.398893108952 | (37.7993821215331, -122.398893108952) | 3 | 1 | 10 | 28860 | 6 | |||
5312 | 4705 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 940 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2017 09:01:00 PM | 3 | 3X3 | 6008689.9314 | 2120561.6575 | 37.8031482394038 | -122.414131236147 | (37.8031482394038, -122.414131236147) | 3 | 1 | 10 | 308 | 23 | ||
5405 | 76328 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 753 Davis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6013055.77037 | 2119154.19347 | 37.7995279331128 | -122.398924188599 | (37.7995279331128, -122.398924188599) | 3 | 1 | 10 | 28860 | 6 | |||
5933 | 71780 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1080 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | Permit Number 768726 | 6007445.70481 | 2115106.99549 | 37.7881011319113 | -122.418050003112 | (37.7881011319113, -122.418050003112) | 13 | 1 | 10 | 28858 | 21 | ||
6050 | 11026 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1435 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2019 12:43:00 PM | 3 | 3x3 | 6007476.45198 | 2117303.69577 | 37.7941344595897 | -122.418099417266 | (37.7941344595897, -122.418099417266) | 5 | 1 | 10 | 28858 | 32 | ||
6105 | 130370 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1401 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011756.98576 | 2121020.06086 | 37.8045786948161 | -122.403549821892 | (37.8045786948161, -122.403549821892) | 3 | 1 | 10 | 28860 | 6 | |||
7105 | 262039 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1251 Hyde St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783100 | 6007540 | 2116706 | 37.7924969115625 | -122.417837146347 | (37.7924969115625, -122.417837146347) | 5 | 1 | 10 | 28858 | 21 | ||
7298 | 108182 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 835 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010686.57825 | 2116924.79472 | 37.7932742451254 | -122.406965263124 | (37.7932742451254, -122.406965263124) | 3 | 1 | 10 | 28857 | 4 | ||||
7314 | 249340 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 839 Post St | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6008138.31912 | 2114803.99526 | 37.7873081250076 | -122.415632209079 | (37.7873081250076, -122.415632209079) | 13 | 1 | 9 | 28858 | 36 | |||
7826 | 11042 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1540 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:37:00 PM | 3 | 3X3 | 6007470.84511 | 2117656.01984 | 37.7951015383692 | -122.418143807805 | (37.7951015383692, -122.418143807805) | 5 | 1 | 10 | 28858 | 32 | ||
9375 | 117618 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 345 Stockton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2016 12:00:00 AM | 3 | 5x5 | 6010671.67618 | 2115248.31215 | 37.7886701923237 | -122.406898612105 | (37.7886701923237, -122.406898612105) | 5 | 1 | 10 | 28857 | 6 | ||
9379 | 130406 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 502 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6012089.1118 | 2117473.06923 | 37.7948580586012 | -122.402150938127 | (37.7948580586012, -122.402150938127) | 3 | 1 | 10 | 28860 | 4 | |||
9432 | 130409 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 617 Battery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2018 12:00:00 AM | 3 | Width 3ft | 6012474.91779 | 2118327.27789 | 37.7972250382734 | -122.400876030414 | (37.7972250382734, -122.400876030414) | 3 | 1 | 10 | 28860 | 4 | ||
10465 | 75257 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 795 Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6007991.6501 | 2114435.56963 | 37.7862882722428 | -122.416113552304 | (37.7862882722428, -122.416113552304) | 13 | 1 | 9 | 28858 | 36 | |||
10657 | 29740 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 629 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775746 | 6009949.88308 | 2119458.12885 | 37.8001889103038 | -122.409693183014 | (37.8001889103038, -122.409693183014) | 3 | 1 | 10 | 308 | 23 | |
12078 | 249366 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 775 Post St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6008444.56493 | 2114842.41912 | 37.7874308375006 | -122.414575379762 | (37.7874308375006, -122.414575379762) | 5 | 1 | 10 | 28858 | 36 | |||
12200 | 130313 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009225.50566 | 2121536.68624 | 37.8058554919917 | -122.412346817477 | (37.8058554919917, -122.412346817477) | 3 | 1 | 10 | 308 | 23 | |||
13019 | 130300 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 815 Battery St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012386.58963 | 2118971.9326 | 37.798990178098 | -122.401226993538 | (37.798990178098, -122.401226993538) | 3 | 1 | 10 | 28860 | 6 | |||
13134 | 76293 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 753 Davis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6013060.18531 | 2119122.80042 | 37.7994419813198 | -122.398906706701 | (37.7994419813198, -122.398906706701) | 3 | 1 | 10 | 28860 | 6 | |||
13170 | 71778 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1035 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6007638.65798 | 2115077.87772 | 37.7880320397014 | -122.417380352623 | (37.7880320397014, -122.417380352623) | 13 | 1 | 10 | 28858 | 21 | |||
14287 | 4591 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x2 | 6011425.16703 | 2118064.77563 | 37.796445660597 | -122.404489964152 | (37.796445660597, -122.404489964152) | 3 | 1 | 10 | 308 | 4 | |||
14578 | 252915 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1924 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782602 | 6007321 | 2118975 | 37.7987146929528 | -122.418755881393 | (37.7987146929528, -122.418755881393) | 5 | 1 | 10 | 28858 | 32 | |
14727 | 11018 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1400 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2019 12:30:00 PM | 3 | 3X3 | 6007538.39019 | 2117184.37476 | 37.7938103196344 | -122.417876641695 | (37.7938103196344, -122.417876641695) | 5 | 1 | 10 | 28858 | 32 | ||
14933 | 37507 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 844 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2002 12:00:00 AM | 7 | Permit Number 44548 | 6008745.37016 | 2115468.73196 | 37.7891674355628 | -122.413578966021 | (37.7891674355628, -122.413578966021) | 5 | 1 | 10 | 28858 | 21 | |
15015 | 127892 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 623 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2016 12:00:00 AM | 20 | Width 4ft | Resulted descion 9/7/16 -DE | 6010045.66816 | 2119169.32215 | 37.7994012851886 | -122.40934133535 | (37.7994012851886, -122.40934133535) | 3 | 1 | 10 | 308 | 4 | |
15084 | 130382 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1301 Sansome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011871.65245 | 2120205.75024 | 37.8023492008037 | -122.403095691236 | (37.8023492008037, -122.403095691236) | 3 | 1 | 10 | 308 | 23 | |||
15613 | 136504 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 623 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | Width 4ft | 6010055.34635 | 2119170.82849 | 37.7994059634655 | -122.409307951612 | (37.7994059634655, -122.409307951612) | 3 | 1 | 10 | 308 | 4 | |||
15851 | 127893 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 623 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 5ft | 6010076.36393 | 2119174.65526 | 37.7994176483495 | -122.409235493238 | (37.7994176483495, -122.409235493238) | 3 | 1 | 10 | 308 | 4 | |||
16280 | 44358 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | 5 | 1 | 10 | 308 | 23 | |||
16366 | 101747 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1000 Montgomery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25770 | 6011635 | 2118713 | 37.7982372525996 | -122.403809528937 | (37.7982372525996, -122.403809528937) | 3 | 1 | 10 | 308 | 23 | ||||
16891 | 71181 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1054 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6007527.04046 | 2115114.42984 | 37.7881261222798 | -122.417769122357 | (37.7881261222798, -122.417769122357) | 13 | 1 | 10 | 28858 | 21 | |||
18357 | 130279 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 580 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007522.60247 | 2121991.88932 | 37.8070096576235 | -122.418272284063 | (37.8070096576235, -122.418272284063) | 5 | 1 | 10 | 308 | 23 | |||
18530 | 130296 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 815 Battery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012379.1265 | 2119031.68937 | 37.7991538394465 | -122.40125702009 | (37.7991538394465, -122.40125702009) | 3 | 1 | 10 | 28860 | 6 | |||
18593 | 71972 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 776 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6009259.78939 | 2119456.28205 | 37.8001451441351 | -122.412081054306 | (37.8001451441351, -122.412081054306) | 3 | 1 | 10 | 308 | 4 | |||
18750 | 130245 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1845 Leavenworth St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 4ft | 6007759.64505 | 2118718.9798 | 37.7980364128955 | -122.417219873113 | (37.7980364128955, -122.417219873113) | 5 | 1 | 10 | 28858 | 32 | |||
18900 | 73976 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1035 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6007626.91149 | 2115081.86603 | 37.7880423297227 | -122.417421276264 | (37.7880423297227, -122.417421276264) | 13 | 1 | 10 | 28858 | 21 | |||
19510 | 70615 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 956 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6007552.40866 | 2114767.26768 | 37.7871743274878 | -122.417656736796 | (37.7871743274878, -122.417656736796) | 13 | 1 | 10 | 28858 | 21 | |||
19746 | 256618 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1255 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6007516.58505 | 2121541.63395 | 37.8057730322633 | -122.418261164826 | (37.8057730322633, -122.418261164826) | 5 | 1 | 1 | 308 | 32 | ||||
20374 | 1327 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2001X Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/25/2012 12:00:00 AM | 3 | 3x3 | 6007161.0410492 | 2119546.6911637 | 37.8002754054915 | -122.41934996955 | (37.8002754054915, -122.41934996955) | 5 | 1 | 1 | 28858 | 32 | ||
20843 | 143428 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 855 SACRAMENTO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6010669.142 | 2116906.4357 | 37.7932228599776 | -122.407024299384 | (37.7932228599776, -122.407024299384) | 3 | 1 | 10 | 28857 | 4 | |||
21389 | 130250 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2333 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007531.72548 | 2120344.09497 | 37.8024857457914 | -122.418123815875 | (37.8024857457914, -122.418123815875) | 5 | 1 | 1 | 28858 | 32 | |||
22621 | 130054 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 639 Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008702.06176 | 2114530.64649 | 37.7865892483359 | -122.413662430293 | (37.7865892483359, -122.413662430293) | 5 | 1 | 9 | 28852 | 36 | |||
22758 | 142623 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 759 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2016 08:56:00 AM | 17 | Width 0ft | 6009232.3494 | 2119982.269 | 37.8015878341977 | -122.412213203248 | (37.8015878341977, -122.412213203248) | 3 | 1 | 10 | 308 | 4 | ||
22918 | 11058 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1637 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2015 12:00:00 AM | 3 | 3X3 | 6007383.08509 | 2117958.82409 | 37.795928023402 | -122.418468953194 | (37.795928023402, -122.418468953194) | 5 | 1 | 10 | 28858 | 32 | ||
23254 | 130414 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 603 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6012490.16974 | 2118226.98591 | 37.7969505112244 | -122.400816204819 | (37.7969505112244, -122.400816204819) | 3 | 1 | 10 | 28860 | 4 | |||
25104 | 130291 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1022 Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6011622.79821 | 2118827.8376 | 37.798551887221 | -122.403859836162 | (37.798551887221, -122.403859836162) | 3 | 1 | 10 | 308 | 23 | |||
25507 | 130325 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 542 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008159.70501 | 2121738.7701 | 37.8063504977306 | -122.416049515186 | (37.8063504977306, -122.416049515186) | 5 | 1 | 10 | 308 | 23 | |||
25913 | 27429 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1288 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6007634.94061 | 2121525.26539 | 37.8057347497405 | -122.417850415659 | (37.8057347497405, -122.417850415659) | 5 | 1 | 10 | 308 | 23 | |||
27354 | 130341 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 30 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011699.23635 | 2121176.78483 | 37.8050057945479 | -122.403760704806 | (37.8050057945479, -122.403760704806) | 3 | 1 | 10 | 28860 | 6 | |||
27691 | 4624 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 411 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2016 07:23:00 AM | 3 | 3X3 | 6010356.08949 | 2118958.97743 | 37.7988411172303 | -122.40825231938 | (37.7988411172303, -122.40825231938) | 3 | 1 | 10 | 308 | 4 | ||
28725 | 65270 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 632 Commercial St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/1989 12:00:00 AM | 7 | Permit Number 28072 | 6011648.40992 | 2117230.82491 | 37.7941683055707 | -122.403658784645 | (37.7941683055707, -122.403658784645) | 3 | 1 | 10 | 28860 | 4 | ||
28865 | 143433 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 855 SACRAMENTO ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6010770.5411 | 2116920.4657 | 37.7932670566772 | -122.406674439368 | (37.7932670566772, -122.406674439368) | 3 | 1 | 10 | 28857 | 4 | |||
28952 | 130287 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2800 Leavenworth St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007323.74687 | 2122200.41347 | 37.8075710162603 | -122.418975266098 | (37.8075710162603, -122.418975266098) | 5 | 1 | 10 | 308 | 23 | |||
29770 | 129948 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 766 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008863.00663 | 2115297.22265 | 37.7887031173885 | -122.41315982437 | (37.7887031173885, -122.41315982437) | 5 | 1 | 10 | 28858 | 21 | |||
30404 | 130303 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 815 Battery St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012394.993 | 2118908.6407 | 37.7988168625742 | -122.401193465017 | (37.7988168625742, -122.401193465017) | 3 | 1 | 10 | 28860 | 6 | |||
31205 | 52366 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 701JONES Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | Permit Number 48500 | 6008788.51328068 | 2114892.18368885 | 37.7875867962818 | -122.413388905547 | (37.7875867962818, -122.413388905547) | 5 | 1 | 10 | 28852 | 36 | ||
31500 | 46438 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 801 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2002 12:00:00 AM | 9 | Permit Number 44657 | 6008994.83708 | 2120066.08449 | 37.8018046406429 | -122.41304103653 | (37.8018046406429, -122.41304103653) | 3 | 1 | 10 | 308 | 32 | ||
31581 | 130413 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 617 Battery St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2018 12:00:00 AM | 3 | Width 3ft | 6012486.62021 | 2118257.34285 | 37.7970336661343 | -122.400830620963 | (37.7970336661343, -122.400830620963) | 3 | 1 | 10 | 28860 | 4 | ||
31942 | 130278 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500 Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007607.17064 | 2122005.04934 | 37.8070505515945 | -122.417980551172 | (37.8070505515945, -122.417980551172) | 5 | 1 | 10 | 308 | 23 | |||
32841 | 103295 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 50 Francisco St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2013 12:00:00 AM | 3x3 | Permit Number 769976 | 6011114.9 | 2121460 | 37.805750773231 | -122.405802839637 | (37.805750773231, -122.405802839637) | 3 | 1 | 10 | 308 | 23 | ||
32888 | 130271 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2701 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007752.16709 | 2122258.39153 | 37.8077543241725 | -122.417496725794 | (37.8077543241725, -122.417496725794) | 5 | 1 | 10 | 308 | 23 | |||
33377 | 129945 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6009687.96821 | 2115689.50821 | 37.78982651722 | -122.410333274961 | (37.78982651722, -122.410333274961) | 5 | 1 | 10 | 28857 | 21 | |||
34843 | 130217 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1625 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007864.11541 | 2117971.81072 | 37.7959907493387 | -122.416805412445 | (37.7959907493387, -122.416805412445) | 5 | 1 | 10 | 28858 | 32 | |||
35117 | 11110 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2027 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 5 | 3x3 | 6007193.19069 | 2119311.88557 | 37.7996324991014 | -122.41922205355 | (37.7996324991014, -122.41922205355) | 5 | 1 | 1 | 28858 | 32 | ||
35767 | 142481 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 577 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2016 07:08:00 AM | 16 | Width 0ft | 6009828.1399 | 2119441.0618 | 37.8001352254525 | -122.410113258005 | (37.8001352254525, -122.410113258005) | 3 | 1 | 10 | 308 | 4 | ||
36436 | 130259 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6007382.90307 | 2122272.11478 | 37.8077712206334 | -122.418775630111 | (37.8077712206334, -122.418775630111) | 5 | 1 | 10 | 308 | 23 | |||
36751 | 121063 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
36927 | 95272 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2245 Jones St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/08/2011 12:00:00 AM | 3 | 3x3 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | |
37525 | 130208 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1201 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009388.81251 | 2117500.36973 | 37.7947819282951 | -122.411496320518 | (37.7947819282951, -122.411496320518) | 3 | 1 | 10 | 28857 | 21 | |||
38261 | 29751 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1331 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 8 | 3x3 | 6007205.02077 | 2121826.2812 | 37.8065370584924 | -122.41935958779 | (37.8065370584924, -122.41935958779) | 5 | 1 | 1 | 28858 | 32 | ||
38429 | 129950 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 849 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008691.42727 | 2115500.84684 | 37.789252586086 | -122.413767874899 | (37.789252586086, -122.413767874899) | 5 | 1 | 10 | 28858 | 21 | |||
38689 | 130210 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1201 Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6009392.97153 | 2117468.4834 | 37.7946946095104 | -122.411479675841 | (37.7946946095104, -122.411479675841) | 3 | 1 | 10 | 28857 | 21 | |||
39033 | 130351 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1700 Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6011282.98959 | 2121299.98363 | 37.8053208063785 | -122.40520986247 | (37.8053208063785, -122.40520986247) | 3 | 1 | 10 | 28860 | 23 | |||
39045 | 129952 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 746 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6008793.25435 | 2115140.31722 | 37.7882683770388 | -122.41339005712 | (37.7882683770388, -122.41339005712) | 5 | 1 | 10 | 28858 | 21 | |||
39058 | 62974 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1625 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 15 | Permit Number 23363 | 6007862.08647 | 2117994.33802 | 37.796052489589 | -122.416814029769 | (37.796052489589, -122.416814029769) | 5 | 1 | 10 | 28858 | 32 | |
39149 | 130284 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2800 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007338.07417 | 2122103.44762 | 37.8073055795633 | -122.41891880127 | (37.8073055795633, -122.41891880127) | 5 | 1 | 10 | 308 | 23 | |||
39176 | 101744 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1000 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25770 | 6011635 | 2118713 | 37.7982372525996 | -122.403809528937 | (37.7982372525996, -122.403809528937) | 3 | 1 | 10 | 308 | 23 | ||||
39641 | 117617 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 345 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2016 12:00:00 AM | 3 | 5x5 | 6010668.3102 | 2115275.74007 | 37.788745314497 | -122.40691219187 | (37.788745314497, -122.40691219187) | 5 | 1 | 10 | 28857 | 6 | ||
39644 | 37504 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 844 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2002 12:00:00 AM | 6 | Permit Number 44548 | 6008742.48995 | 2115486.1091 | 37.7892149872375 | -122.413590160766 | (37.7892149872375, -122.413590160766) | 5 | 1 | 10 | 28858 | 21 | |
39820 | 4655 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 543 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2016 08:25:00 AM | 3 | 3x3 | 6009903.7233 | 2119369.9245 | 37.7999441360905 | -122.40984668478 | (37.7999441360905, -122.40984668478) | 3 | 1 | 10 | 308 | 4 | ||
39975 | 121061 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 |
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) );