trees
77 rows where Supervisor Districts = 10 and qSpecies_id = 97 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5167 | 126631 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 7 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6013670.6132 | 2118002.84349 | 37.796400840179 | -122.39671583859 | (37.796400840179, -122.39671583859) | 3 | 1 | 10 | 28860 | 6 | |||
10858 | 128369 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 843 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 4ft | 6010471.73552 | 2116514.30785 | 37.7921351227858 | -122.4076796805 | (37.7921351227858, -122.4076796805) | 5 | 1 | 10 | 28857 | 21 | |||
30441 | 116039 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1401x Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6008038.31567 | 2116541.76159 | 37.7920739841803 | -122.416101317043 | (37.7920739841803, -122.416101317043) | 5 | 1 | 10 | 28858 | 21 | |||
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 | |||
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 | |||
56711 | 100477 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 340 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 781547 | 6009834.90147 | 2114634.4517 | 37.7869378210564 | -122.409750394691 | (37.7869378210564, -122.409750394691) | 5 | 10 | 10 | 28852 | 36 | ||
57949 | 126628 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 3 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6013814.15262 | 2118039.92484 | 37.7965106447043 | -122.396221758237 | (37.7965106447043, -122.396221758237) | 3 | 1 | 10 | 28860 | 6 | |||
93557 | 98577 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 301X Francisco St | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6x7 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 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 | ||||
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 | |
102943 | 100479 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 340 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 781547 | 6009830.08403 | 2114659.89537 | 37.7870074133103 | -122.409768858656 | (37.7870074133103, -122.409768858656) | 5 | 10 | 10 | 28852 | 36 | ||
106151 | 126625 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1445 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6011819.79643 | 2120570.04508 | 37.8033465696629 | -122.403300781611 | (37.8033465696629, -122.403300781611) | 3 | 1 | 10 | 28860 | 6 | |||
113783 | 126629 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 4 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6013771.20775 | 2118034.57435 | 37.7964935638782 | -122.396369982705 | (37.7964935638782, -122.396369982705) | 3 | 1 | 10 | 28860 | 6 | |||
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 | |||
145617 | 126630 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 6 | Median : Yard | Tree | DPW 1 | 9 | Width 8ft | 6013712.21512 | 2118015.33042 | 37.7964374416781 | -122.396572761821 | (37.7964374416781, -122.396572761821) | 3 | 1 | 10 | 28860 | 6 | |||
158586 | 100476 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 340 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 781547 | 6009833.38685 | 2114620.58318 | 37.7868996565447 | -122.409754655664 | (37.7868996565447, -122.409754655664) | 5 | 10 | 10 | 28852 | 36 | ||
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 | |
162216 | 126627 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 2 | Median : Yard | Tree | DPW 1 | 17 | Width 8ft | 6013882.15291 | 2118048.61881 | 37.796538299751 | -122.395987070255 | (37.796538299751, -122.395987070255) | 3 | 1 | 10 | 28860 | 6 | |||
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 | |||
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 | ||
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 | ||||
26923 | 101895 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 590X Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011780 | 2117743.1 | 37.795582240012 | -122.403239519119 | (37.795582240012, -122.403239519119) | 3 | 1 | 10 | 28860 | 4 | ||||
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 | ||||
36324 | 102902 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 290 PACIFIC AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6012556 | 2118523 | 37.797766966668 | -122.400609219963 | (37.797766966668, -122.400609219963) | 3 | 1 | 10 | 28860 | 6 | ||||
43388 | 102901 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 712 BATTERY ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6012523 | 2118543 | 37.7978200413762 | -122.400724815577 | (37.7978200413762, -122.400724815577) | 3 | 1 | 10 | 28860 | 6 | ||||
46826 | 110117 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 160x PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010076 | 2121146 | 37.8048304537654 | -122.409375949631 | (37.8048304537654, -122.409375949631) | 3 | 1 | 10 | 308 | 23 | ||||
57245 | 99116 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1200x KEARNY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011163 | 2119066 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | 3 | 1 | 10 | 308 | 23 | ||||
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 | ||||
66175 | 99115 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1200x KEARNY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011163 | 2119066 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | 3 | 1 | 10 | 308 | 23 | ||||
121030 | 101519 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 15X Bellair Pl | 2 | 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 | |||
125218 | 99176 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 300x BEACH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008712 | 2122248 | 37.8077797512209 | -122.414174245084 | (37.8077797512209, -122.414174245084) | 3 | 1 | 10 | 308 | 23 | ||||
129528 | 98986 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 847 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009438.4 | 2115684 | 37.7897973999496 | -122.411196371815 | (37.7897973999496, -122.411196371815) | 5 | 1 | 10 | 28857 | 21 | ||||
148031 | 98988 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 847 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009438.4 | 2115684 | 37.7897973999496 | -122.411196371815 | (37.7897973999496, -122.411196371815) | 5 | 1 | 10 | 28857 | 21 | ||||
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 | ||||
170940 | 98987 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 847 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009438.4 | 2115684 | 37.7897973999496 | -122.411196371815 | (37.7897973999496, -122.411196371815) | 5 | 1 | 10 | 28857 | 21 | ||||
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 | ||||
22488 | 98718 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1500@Polk Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | 13 | 9 | 10 | 28858 | 32 | |||||
23293 | 101516 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 610 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 28301 | 6008387 | 2114552 | 37.7866301828456 | -122.414753982265 | (37.7866301828456, -122.414753982265) | 5 | 1 | 10 | 28858 | 36 | ||
27124 | 33817 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1201 California St | 2 | 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 | |||
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 | ||
37424 | 48789 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 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 | |||
50226 | 48785 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
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 | |||
57306 | 52859 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2260on VALLEJO Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | Permit Number 48866 | 6005979.18116248 | 2118139.38977425 | 37.7963446783328 | -122.423339577445 | (37.7963446783328, -122.423339577445) | 13 | 9 | 10 | 28858 | 32 | |||
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 | ||
58028 | 48791 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
74295 | 97191 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 255 California St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | 4 | 1 | 10 | 28860 | 6 | |||
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 | ||
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 | ||
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 | ||
86785 | 47045 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 111 Maiden Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45035 | 6011125.92683466 | 2115044.13243826 | 37.7881349707775 | -122.405312579096 | (37.7881349707775, -122.405312579096) | 5 | 1 | 10 | 28857 | 6 | |||
87294 | 99016 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1133 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 29980 | 6008997 | 2116859 | 37.7929988993441 | -122.41280668477 | (37.7929988993441, -122.41280668477) | 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 | |||
92709 | 97190 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 255 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | 4 | 1 | 10 | 28860 | 6 | |||
93302 | 97189 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 255 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | 4 | 1 | 10 | 28860 | 6 | |||
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 | ||||
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 | ||
104901 | 104050 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 145X Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012363 | 2119165 | 37.7995189786281 | -122.401322196982 | (37.7995189786281, -122.401322196982) | 3 | 1 | 10 | 28860 | 6 | |||||
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 | ||
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 | |
133084 | 52857 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2260on VALLEJO Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | Permit Number 48866 | 6005979.18116248 | 2118139.38977425 | 37.7963446783328 | -122.423339577445 | (37.7963446783328, -122.423339577445) | 13 | 9 | 10 | 28858 | 32 | |||
145583 | 101515 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 610 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 28301 | 6008387 | 2114552 | 37.7866301828456 | -122.414753982265 | (37.7866301828456, -122.414753982265) | 5 | 1 | 10 | 28858 | 36 | ||
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 | ||
164310 | 52858 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2260on VALLEJO Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | Permit Number 48866 | 6005979.18116248 | 2118139.38977425 | 37.7963446783328 | -122.423339577445 | (37.7963446783328, -122.423339577445) | 13 | 9 | 10 | 28858 | 32 | |||
168714 | 52860 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2260on VALLEJO Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | Permit Number 48866 | 6005979.18116248 | 2118139.38977425 | 37.7963446783328 | -122.423339577445 | (37.7963446783328, -122.423339577445) | 13 | 9 | 10 | 28858 | 32 | |||
168838 | 84930 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1500@Polk Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | 13 | 9 | 10 | 28858 | 32 | |||||
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 | ||
181146 | 48788 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
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 |
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) );