trees
604 rows where SiteOrder = 1 and qSpecies_id = 97 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15539 | 37970 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 602 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/1998 12:00:00 AM | Permit Number 40200 | |||||||||||||
20155 | 98985 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 847 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009438.4 | 2115684 | 37.7897973999496 | -122.411196371815 | (37.7897973999496, -122.411196371815) | 5 | 1 | 10 | 28857 | 21 | ||||
28593 | 66848 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 919 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | Permit Number 30152 | 6008182.6560056 | 2115155.17049763 | 37.7882748588768 | -122.415503684404 | (37.7882748588768, -122.415503684404) | 13 | 1 | 10 | 28858 | 21 | ||
30487 | 99178 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 330 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008617 | 2122137 | 37.807469636787 | -122.41449515712 | (37.807469636787, -122.41449515712) | 3 | 1 | 10 | 308 | 23 | ||||
30525 | 109918 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 114 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | 6010269.5 | 2121152.3 | 37.8048585915517 | -122.408706764133 | (37.8048585915517, -122.408706764133) | 3 | 1 | 10 | 308 | 23 | ||||
36271 | 126620 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1430 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6007903.30397 | 2116551.24821 | 37.7920924400618 | -122.416569132658 | (37.7920924400618, -122.416569132658) | 5 | 1 | 10 | 28858 | 21 | |||
41084 | 48790 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/2006 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | ||
41504 | 33816 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1201 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1997 12:00:00 AM | Permit Number 37831 | 6008598.80477101 | 2116262.85239853 | 37.7913396656633 | -122.414142270961 | (37.7913396656633, -122.414142270961) | 5 | 1 | 10 | 28858 | 21 | |||
46860 | 126624 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 801x Greenwich St | 1 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6009066.28691 | 2120109.01558 | 37.8019265293585 | -122.412796822924 | (37.8019265293585, -122.412796822924) | 3 | 1 | 10 | 308 | 4 | |||
53369 | 67032 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 255 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012868.03417039 | 2116855.7141363 | 37.7932063935721 | -122.399412377848 | (37.7932063935721, -122.399412377848) | 4 | 1 | 10 | 28860 | 6 | |||
57362 | 65894 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 649 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1990 12:00:00 AM | Permit Number 28901 | 6009912.39060761 | 2119145.15114701 | 37.7993274494867 | -122.409800817555 | (37.7993274494867, -122.409800817555) | 3 | 1 | 10 | 308 | 4 | ||
58481 | 65402 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 760 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1989 12:00:00 AM | 12 | 3x3 | Permit Number 28251 | 6008077 | 2114493 | 37.7864507606031 | -122.415822330961 | (37.7864507606031, -122.415822330961) | 13 | 1 | 9 | 28858 | 36 |
63531 | 99175 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 300x BEACH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008712 | 2122248 | 37.8077797512209 | -122.414174245084 | (37.8077797512209, -122.414174245084) | 3 | 1 | 10 | 308 | 23 | ||||
76403 | 66852 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 805 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | Permit Number 30158 | 6008246.52380896 | 2115214.16051417 | 37.7884404207738 | -122.415286889274 | (37.7884404207738, -122.415286889274) | 13 | 1 | 10 | 28858 | 21 | ||
79131 | 97722 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 1 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | ||
80740 | 35236 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1198 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 10 | Permit Number 38733 | 6007268.58471 | 2119527.95161 | 37.8002300077587 | -122.418976495462 | (37.8002300077587, -122.418976495462) | 5 | 1 | 1 | 28858 | 32 | |
83298 | 65478 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 601 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/1989 12:00:00 AM | Permit Number 28359 | 6010541.36110634 | 2116214.27782437 | 37.7913152098094 | -122.407417612453 | (37.7913152098094, -122.407417612453) | 5 | 1 | 10 | 28857 | 21 | ||
84852 | 65486 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 801 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1989 12:00:00 AM | Permit Number 28370 | 6009649.36997858 | 2115707.80146662 | 37.7898745823318 | -122.410468114048 | (37.7898745823318, -122.410468114048) | 5 | 1 | 10 | 28857 | 21 | ||
91974 | 64063 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1421 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1988 12:00:00 AM | Permit Number 25296 | 6010151.38612308 | 2118964.80181049 | 37.7988456450066 | -122.408961074202 | (37.7988456450066, -122.408961074202) | 3 | 1 | 10 | 308 | 4 | |||
94866 | 30886 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1440 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 34718 | 6011020.35277298 | 2119822.53522602 | 37.8012494094877 | -122.406014607975 | (37.8012494094877, -122.406014607975) | 3 | 1 | 10 | 308 | 23 | ||||
94910 | 251399 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 841 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6008927.48691 | 2120274.72498 | 37.8023737344278 | -122.413288863041 | (37.8023737344278, -122.413288863041) | 3 | 1 | 10 | 308 | 32 | ||||
101268 | 101053 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 746 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008144 | 2114503 | 37.7864819845184 | -122.415591235338 | (37.7864819845184, -122.415591235338) | 13 | 1 | 9 | 28858 | 36 | |||
102755 | 62037 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 395 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/1985 12:00:00 AM | 14 | 3x3 | Permit Number 781547 | 6009850.4646 | 2114693.00092 | 37.7870994553217 | -122.409700683759 | (37.7870994553217, -122.409700683759) | 5 | 1 | 10 | 28852 | 36 | |
107326 | 66869 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 640 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1991 12:00:00 AM | Permit Number 30178 | 6009507.57601331 | 2115392.34348399 | 37.789000460867 | -122.410936420318 | (37.789000460867, -122.410936420318) | 5 | 1 | 10 | 28857 | 21 | ||
118171 | 126626 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50 Washington St | 1 | Median : Yard | Tree | Private 2 | 16 | Width 8ft | 6013909.98641 | 2118052.46146 | 37.7965503992498 | -122.395891028944 | (37.7965503992498, -122.395891028944) | 3 | 1 | 10 | 28860 | 6 | |||
124253 | 66867 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 925 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1991 12:00:00 AM | 15 | 3x3 | Permit Number 30174 | 6008155.2662548 | 2115151.32890411 | 37.788262771233 | -122.415598176589 | (37.788262771233, -122.415598176589) | 13 | 1 | 10 | 28858 | 21 | |
149996 | 64775 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 517 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1989 12:00:00 AM | Permit Number 25767 | 6010461.649147 | 2119569.81510368 | 37.8005242381712 | -122.407930145171 | (37.8005242381712, -122.407930145171) | 3 | 1 | 10 | 308 | 23 | ||
152169 | 65423 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 801 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1989 12:00:00 AM | Permit Number 28281 | 6010517.63649674 | 2116529.16048818 | 37.7921784739149 | -122.407521909343 | (37.7921784739149, -122.407521909343) | 5 | 1 | 10 | 28857 | 21 | ||
160598 | 34453 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1167 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 10 | Permit Number 38197 | 6007453.34661 | 2118811.22971 | 37.7982724714417 | -122.418286300874 | (37.7982724714417, -122.418286300874) | 5 | 1 | 10 | 28858 | 32 | |
163520 | 101520 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 15X Bellair Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769472 | 6010051.6 | 2121037.7 | 37.8045317217453 | -122.409452740826 | (37.8045317217453, -122.409452740826) | 3 | 1 | 10 | 308 | 23 | |||
169076 | 110116 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 160x PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010076 | 2121146 | 37.8048304537654 | -122.409375949631 | (37.8048304537654, -122.409375949631) | 3 | 1 | 10 | 308 | 23 | ||||
170465 | 64776 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 816 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1989 12:00:00 AM | Permit Number 25768 | 6010808.79838009 | 2116967.92817235 | 37.7933995175775 | -122.406545412053 | (37.7933995175775, -122.406545412053) | 3 | 1 | 10 | 28857 | 4 | ||
174227 | 33820 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1025 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/1984 12:00:00 AM | Permit Number 37834 | 6007679.68250964 | 2115084.43114941 | 37.7880523419006 | -122.417238879212 | (37.7880523419006, -122.417238879212) | 13 | 1 | 10 | 28858 | 21 | |||
176360 | 53343 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 620 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1995 12:00:00 AM | Permit Number 30179 | 6009598.94591555 | 2115405.06508937 | 37.7890405143898 | -122.410621189952 | (37.7890405143898, -122.410621189952) | 5 | 1 | 10 | 28857 | 21 | ||
178511 | 116038 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1401x Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6008011.06753 | 2116537.17208 | 37.7920598504338 | -122.416195270994 | (37.7920598504338, -122.416195270994) | 5 | 1 | 10 | 28858 | 21 | |||
183193 | 65401 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 747 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1989 12:00:00 AM | Permit Number 28250 | 6008150.2130763 | 2114455.0011203 | 37.7863505404889 | -122.415566339973 | (37.7863505404889, -122.415566339973) | 13 | 1 | 9 | 28858 | 36 | ||
186873 | 99114 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1200x KEARNY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011163 | 2119066 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | 3 | 1 | 10 | 308 | 23 | ||||
74931 | 64702 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 110 Cyril Magnin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25683 | 6010200.02442425 | 2113768.63085544 | 37.7845809377612 | -122.408426051637 | (37.7845809377612, -122.408426051637) | 14 | 10 | 10 | 28852 | 36 | ||
98731 | 64717 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 35 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25671 | 6010371.58706878 | 2113906.86566108 | 37.7849701038252 | -122.407842251054 | (37.7849701038252, -122.407842251054) | 14 | 10 | 10 | 28852 | 36 | ||
111103 | 64725 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 174 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25680 | 6010012.44318345 | 2114072.97215331 | 37.7854060800363 | -122.409096504402 | (37.7854060800363, -122.409096504402) | 14 | 10 | 9 | 28852 | 36 | ||
140818 | 65399 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 471 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1989 12:00:00 AM | Permit Number 28247 | 6008612.45505665 | 2113822.69504434 | 37.7846403524021 | -122.41392234969 | (37.7846403524021, -122.41392234969) | 7 | 10 | 9 | 28852 | 36 | ||
144563 | 64727 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 166 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25682 | 6009623.89289745 | 2113671.39889681 | 37.7842816815144 | -122.410412412425 | (37.7842816815144, -122.410412412425) | 14 | 10 | 9 | 28852 | 36 | ||
186261 | 64726 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 127 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25681 | 6010217.12887008 | 2114048.91615067 | 37.7853514923776 | -122.40838665256 | (37.7853514923776, -122.40838665256) | 14 | 10 | 10 | 28852 | 36 | ||
189489 | 100475 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 340 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 781547 | 6009838.89839 | 2114609.02446 | 37.7868682279306 | -122.409734770741 | (37.7868682279306, -122.409734770741) | 5 | 10 | 10 | 28852 | 36 | ||
9284 | 259046 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1x Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007165 | 2109609 | 37.7729891632586 | -122.418631158564 | (37.7729891632586, -122.418631158564) | 8 | 2 | 9 | 28853 | 19 | ||||
27707 | 66488 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1043 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | Permit Number 29647 | 6007587.84875499 | 2109703.11754078 | 37.7732713850209 | -122.417175139527 | (37.7732713850209, -122.417175139527) | 8 | 2 | 9 | 28853 | 19 | ||
30353 | 105684 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 1 | Front Yard : Pot | Tree | Private 2 | 10 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
34847 | 173694 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 201X Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011772 | 2114653 | 37.7870971135768 | -122.403049742128 | (37.7870971135768, -122.403049742128) | 12 | 2 | 9 | 28853 | 6 | ||||
36413 | 33765 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1580 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | 8 | 2 | 9 | 28853 | 19 | |||
40283 | 30534 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1020 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.77681277294 | -122.404779881684 | (37.77681277294, -122.404779881684) | 14 | 2 | 9 | 28853 | 34 | |||
46822 | 34158 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
87966 | 30505 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1500 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 34518 | 6007587.04685478 | 2110100.36731732 | 37.7743620934089 | -122.417206068405 | (37.7743620934089, -122.417206068405) | 8 | 2 | 9 | 28853 | 19 | |||
126290 | 251396 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 299 Townsend St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6013957 | 2110872 | 37.776837125863 | -122.395225113019 | (37.776837125863, -122.395225113019) | 6 | 2 | 9 | 28856 | 20 | ||||
135027 | 115025 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
3099 | 104652 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 953 Indiana St | 1 | Front Yard : Cutout | Tree | Private 2 | 6015057.1 | 2104275.7 | 37.7587862506702 | -122.390958369803 | (37.7587862506702, -122.390958369803) | 10 | 3 | 8 | 28856 | 29 | |||||
10390 | 199430 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 695 Arkansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Width 10ft | 6013045.24345 | 2103834.71473 | 37.7574635617095 | -122.397885411392 | (37.7574635617095, -122.397885411392) | 10 | 3 | 8 | 28856 | 29 | ||
18380 | 65586 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1779 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Permit Number 28486 | 6014089.25997 | 2096159.17746 | 37.7364462435881 | -122.393737527685 | (37.7364462435881, -122.393737527685) | 10 | 3 | 8 | 58 | 1 | ||
23581 | 31969 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 470 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1995 12:00:00 AM | Permit Number 35370 | 6009517.59351868 | 2092163.53246737 | 37.7252199449059 | -122.409261897755 | (37.7252199449059, -122.409261897755) | 9 | 3 | 7 | 309 | 28 | |||
30016 | 199432 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1400 Newhall St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6014474.33722 | 2095838.07196 | 37.7355859449403 | -122.39238369005 | (37.7355859449403, -122.39238369005) | 10 | 3 | 8 | 58 | 1 | |||
60993 | 61785 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1495 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1987 12:00:00 AM | Permit Number 24636 | 6012051.50334521 | 2101403.29784414 | 37.7507320294913 | -122.401151335946 | (37.7507320294913, -122.401151335946) | 10 | 3 | 8 | 28856 | 29 | ||
71033 | 62088 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 474 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1985 12:00:00 AM | Permit Number 22174 | 6013214.9408475 | 2104861.98073646 | 37.7602936588903 | -122.397370564655 | (37.7602936588903, -122.397370564655) | 10 | 3 | 8 | 28856 | 29 | ||
90644 | 61306 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1494 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1984 12:00:00 AM | Permit Number 21205 | 6011999.58311152 | 2101400.41872379 | 37.7507212274206 | -122.401330679383 | (37.7507212274206, -122.401330679383) | 10 | 3 | 8 | 28856 | 29 | ||
103250 | 111889 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 142 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6011076.19973 | 2092521.56402 | 37.7262902239912 | -122.403899105983 | (37.7262902239912, -122.403899105983) | 10 | 3 | 7 | 309 | 28 | |||
109268 | 200443 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2535 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6015875.48388 | 2103755.07735 | 37.7574021083324 | -122.388091663914 | (37.7574021083324, -122.388091663914) | 10 | 3 | 8 | 28856 | 29 | |||
115001 | 67594 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 308 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31161 | 6013452.45067872 | 2105638.02121278 | 37.7624377166869 | -122.39660352483 | (37.7624377166869, -122.39660352483) | 10 | 3 | 8 | 28856 | 29 | ||
121851 | 61725 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 66 Williams Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/1985 12:00:00 AM | Permit Number 21727 | 6013825.41276045 | 2093670.69143799 | 37.7295987054368 | -122.394475571882 | (37.7295987054368, -122.394475571882) | 10 | 3 | 8 | 58 | 1 | ||
124236 | 30843 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1375 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/1995 12:00:00 AM | Permit Number 34691 | 6011743.60320296 | 2101979.83639733 | 37.7522978969141 | -122.40225661865 | (37.7522978969141, -122.40225661865) | 10 | 3 | 8 | 28856 | 29 | ||
129824 | 26001 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6014400.39468 | 2095925.25999 | 37.7358212390678 | -122.392645436853 | (37.7358212390678, -122.392645436853) | 10 | 3 | 8 | 58 | 1 | |||
134941 | 61310 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2337 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1984 12:00:00 AM | Permit Number 21209 | 6011897.61971652 | 2101840.97458612 | 37.7519252086186 | -122.4017142423 | (37.7519252086186, -122.4017142423) | 10 | 3 | 8 | 28856 | 29 | ||
150898 | 54789 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 271 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1972 12:00:00 AM | 21 | Permit Number 10638 | 6012677.12996 | 2087211.64652 | 37.7117995683772 | -122.39799240103 | (37.7117995683772, -122.39799240103) | 10 | 3 | 8 | 309 | 1 | ||
155644 | 176424 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 538 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009812.17284 | 2092615.83589 | 37.7264783747515 | -122.408275448966 | (37.7264783747515, -122.408275448966) | 10 | 3 | 7 | 309 | 28 | |||
165378 | 61309 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2325 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1984 12:00:00 AM | Permit Number 21208 | 6011929.28683038 | 2101842.72936764 | 37.7519317939639 | -122.40160485559 | (37.7519317939639, -122.40160485559) | 10 | 3 | 8 | 28856 | 29 | ||
167803 | 41049 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1452 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1999 12:00:00 AM | Permit Number 41829 | 6011713.00642169 | 2101589.94219711 | 37.7512256245579 | -122.402335016202 | (37.7512256245579, -122.402335016202) | 10 | 3 | 8 | 28856 | 29 | ||
173842 | 32046 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 501 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1999 12:00:00 AM | Permit Number 35428 | 6012610 | 2086139 | 37.7088505533644 | -122.398149216451 | (37.7088505533644, -122.398149216451) | 10 | 3 | 8 | 309 | 1 | ||
187823 | 199429 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1340 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6013567.84766 | 2105719.02996 | 37.7626665705253 | -122.396210084142 | (37.7626665705253, -122.396210084142) | 14 | 3 | 8 | 28856 | 29 | |||
374 | 5332 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 125 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 6x7 | 6004849.91389 | 2107615.96816 | 37.7673861676625 | -122.426497389946 | (37.7673861676625, -122.426497389946) | 8 | 4 | 5 | 28862 | 19 | |||
443 | 107383 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 73 HILL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6005896.4 | 2103362 | 37.7557648742481 | -122.422575414787 | (37.7557648742481, -122.422575414787) | 2 | 4 | 5 | 28859 | 19 | ||||
1108 | 627 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3166 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6007870.94281 | 2102116.96374 | 37.7524574855488 | -122.415658642859 | (37.7524574855488, -122.415658642859) | 2 | 4 | 7 | 28859 | 19 | |||
1525 | 224536 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3283 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | Width 3ft | 6007118.3907 | 2102031.54495 | 37.7521806130667 | -122.418255044036 | (37.7521806130667, -122.418255044036) | 2 | 4 | 7 | 28859 | 19 | |||
1692 | 61474 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1960 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1984 12:00:00 AM | Permit Number 21417 | 6004396.86379546 | 2107211.14447839 | 37.7662489975602 | -122.428035576337 | (37.7662489975602, -122.428035576337) | 8 | 4 | 5 | 28862 | 3 | ||
4606 | 224510 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1198 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6007627.97792 | 2102718.14058 | 37.7540945196695 | -122.416541439837 | (37.7540945196695, -122.416541439837) | 2 | 4 | 7 | 28859 | 19 | |||
5380 | 640 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3200 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6007574.72227 | 2102100.08892 | 37.7523944952223 | -122.416681830316 | (37.7523944952223, -122.416681830316) | 2 | 4 | 7 | 28859 | 19 | |||
5652 | 657 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3262 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6007285.35691 | 2102087.12511 | 37.7523426205157 | -122.417681586846 | (37.7523426205157, -122.417681586846) | 2 | 4 | 7 | 28859 | 19 | |||
5761 | 224699 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3236 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | Width 3ft | 6007526.74961 | 2102095.67359 | 37.7523796734842 | -122.416847415286 | (37.7523796734842, -122.416847415286) | 2 | 4 | 7 | 28859 | 19 | |||
6491 | 224533 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3143 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 3ft | 6008085.98241 | 2102084.65077 | 37.7523808471161 | -122.41491271097 | (37.7523808471161, -122.41491271097) | 2 | 4 | 7 | 28859 | 19 | |||
6718 | 226469 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3001 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009320 | 2104474 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | 2 | 4 | 7 | 28859 | 19 | |||
7424 | 61750 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3235 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1984 12:00:00 AM | Permit Number 21761 | 6005283.427251 | 2106614.91851966 | 37.7646620214784 | -122.424926696656 | (37.7646620214784, -122.424926696656) | 8 | 4 | 5 | 28859 | 19 | ||
8924 | 224586 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2757 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6008370.39736 | 2106782.63343 | 37.7652964112246 | -122.414261518161 | (37.7652964112246, -122.414261518161) | 8 | 4 | 7 | 28859 | 19 | |||
9506 | 26517 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2883 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6009010.68122 | 2101716.60139 | 37.7514221824079 | -122.411688936397 | (37.7514221824079, -122.411688936397) | 2 | 4 | 7 | 28859 | 19 | |||
10092 | 224526 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 173 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6006718.37785 | 2102818.25251 | 37.7543182071448 | -122.419694167076 | (37.7543182071448, -122.419694167076) | 2 | 4 | 7 | 28859 | 19 | |||
10260 | 261386 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 31 Abbey St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6004642 | 2106187 | 37.7634508076606 | -122.427114742536 | (37.7634508076606, -122.427114742536) | 8 | 4 | 5 | 28862 | 3 | ||||
11707 | 224712 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3560 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6006570.05679 | 2104384.71114 | 37.7586109842303 | -122.420318274095 | (37.7586109842303, -122.420318274095) | 2 | 4 | 7 | 28859 | 19 | |||
13271 | 551 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2900 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6009445.64374 | 2102206.22318 | 37.7527909649347 | -122.41021934346 | (37.7527909649347, -122.41021934346) | 2 | 4 | 7 | 28859 | 19 | |||
13405 | 245415 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2761 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010145.3814 | 2102202.4336 | 37.752819757444 | -122.407799244655 | (37.752819757444, -122.407799244655) | 2 | 4 | 7 | 28859 | 19 | |
15629 | 66830 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 393 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | Permit Number 30127 | 6001175.80343985 | 2104102.01378806 | 37.7575293253254 | -122.438953746382 | (37.7575293253254, -122.438953746382) | 2 | 4 | 5 | 28862 | 3 | ||
15856 | 224535 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3195 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6007823.33257 | 2102073.06201 | 37.7523342649139 | -122.415820179079 | (37.7523342649139, -122.415820179079) | 2 | 4 | 7 | 28859 | 19 | |||
16341 | 224695 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3034 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | Width 3ft | 6008772.76102 | 2102170.48787 | 37.7526551034509 | -122.412543777077 | (37.7526551034509, -122.412543777077) | 2 | 4 | 7 | 28859 | 19 | |||
16785 | 224704 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3282 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6007185.41243 | 2102081.52674 | 37.7523216240474 | -122.418026814981 | (37.7523216240474, -122.418026814981) | 2 | 4 | 7 | 28859 | 19 | |||
17311 | 61740 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 219 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21745 | 6003738.99947337 | 2100964.64707663 | 37.7490603587459 | -122.429865402911 | (37.7490603587459, -122.429865402911) | 2 | 4 | 5 | 28862 | 22 | ||
17850 | 60829 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 82 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20508 | 6004586.81845905 | 2101649.91280729 | 37.7509899147675 | -122.426982435992 | (37.7509899147675, -122.426982435992) | 2 | 4 | 5 | 28862 | 22 |
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) );