trees
969 rows where qSpecies_id = 97 sorted by XCoord descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
117473 | 115032 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
122705 | 115031 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
132591 | 115030 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
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 | ||||
143436 | 115026 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
145158 | 117225 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
171805 | 115033 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
178512 | 115027 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
193914 | 115028 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
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 | ||||
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 | ||
37377 | 176427 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 383 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6010742.02473 | 2089174.64706 | 37.7170816042145 | -122.404818807562 | (37.7170816042145, -122.404818807562) | 9 | 7 | 8 | 309 | 39 | |||
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 | ||
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 | ||
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 | |||
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 | ||
107742 | 121142 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 100x Rutledge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 9x6 | 6010389 | 2099533 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | 2 | 7 | 7 | 28859 | 2 | |||
165184 | 121141 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 100x Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 9x6 | 6010389 | 2099533 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
173711 | 173681 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 125 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010317 | 2099454 | 37.7452827689443 | -122.407012047483 | (37.7452827689443, -122.407012047483) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
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 | ||
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 | ||
11640 | 245417 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2761 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010192.4103 | 2102204.1541 | 37.7528271142349 | -122.407636730621 | (37.7528271142349, -122.407636730621) | 2 | 4 | 7 | 28859 | 19 | |
625 | 245416 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2761 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010170.0429 | 2102204.1541 | 37.7528258621349 | -122.407714081565 | (37.7528258621349, -122.407714081565) | 2 | 4 | 7 | 28859 | 19 | |
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 | |||
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 | |
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | ||
193808 | 67150 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 427 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1992 12:00:00 AM | Permit Number 30582 | 6010005.12050673 | 2098589.41341875 | 37.7428913451797 | -122.40802951845 | (37.7428913451797, -122.40802951845) | 10 | 7 | 7 | 28859 | 2 | ||
164535 | 67096 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 431 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30501 | 6010004.32773544 | 2098578.96669132 | 37.7428626163512 | -122.408031523079 | (37.7428626163512, -122.408031523079) | 10 | 7 | 7 | 28859 | 2 | ||
109279 | 68204 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1110 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | 16 | 3x3 | Permit Number 32363 | 6009978.53990017 | 2102725.22931804 | 37.7542458964916 | -122.408413088762 | (37.7542458964916, -122.408413088762) | 2 | 4 | 7 | 28859 | 19 |
42609 | 67152 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 412 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1992 12:00:00 AM | Permit Number 30584 | 6009956.04429273 | 2098629.91177988 | 37.7429997970033 | -122.408202066775 | (37.7429997970033, -122.408202066775) | 10 | 7 | 7 | 28859 | 2 | ||
50729 | 67095 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 432 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30500 | 6009952.08043631 | 2098577.67814271 | 37.7428561528472 | -122.408212089588 | (37.7428561528472, -122.408212089588) | 10 | 7 | 7 | 28859 | 2 | ||
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 | ||
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 | |||
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
129505 | 176430 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 242 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009808.91529 | 2087898.02053 | 37.7135240489616 | -122.407954158975 | (37.7135240489616, -122.407954158975) | 9 | 7 | 8 | 309 | 39 | |||
99319 | 176423 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 538 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009799.11271 | 2092612.10018 | 37.726467385945 | -122.408320334118 | (37.726467385945, -122.408320334118) | 10 | 3 | 7 | 309 | 28 | |||
19928 | 176429 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 246 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009787.6259 | 2087905.19547 | 37.7135425579218 | -122.4080282487 | (37.7135425579218, -122.4080282487) | 9 | 7 | 8 | 309 | 39 | |||
102851 | 176422 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 538 Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009782.31983 | 2092607.20943 | 37.7264530165924 | -122.408378041837 | (37.7264530165924, -122.408378041837) | 10 | 3 | 7 | 309 | 28 | |||
59959 | 176428 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 250 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009763.04467 | 2087916.93122 | 37.7135734055712 | -122.408114037746 | (37.7135734055712, -122.408114037746) | 9 | 7 | 8 | 309 | 39 | |||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | |||
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 | ||||
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 | ||||
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 | ||||
138825 | 60292 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2902 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1982 12:00:00 AM | Permit Number 19857 | 6009437.54414231 | 2102795.33502096 | 37.7544080802013 | -122.410288944543 | (37.7544080802013, -122.410288944543) | 2 | 4 | 7 | 28859 | 19 | ||
107233 | 224512 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 915 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009423.35212 | 2103670.74387 | 37.756810960566 | -122.41039983289 | (37.756810960566, -122.41039983289) | 2 | 4 | 7 | 28859 | 19 | |||
38124 | 552 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2904 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009418.497 | 2102204.07854 | 37.7527835545272 | -122.410313070807 | (37.7527835545272, -122.410313070807) | 2 | 4 | 7 | 28859 | 19 | |||
125391 | 554 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2912X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009391.31353 | 2102200.13523 | 37.7527712032402 | -122.410406798162 | (37.7527712032402, -122.410406798162) | 2 | 4 | 7 | 28859 | 19 | |||
171938 | 60290 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2915 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1982 12:00:00 AM | Permit Number 19854 | 6009379.15115854 | 2102740.05515277 | 37.7542530206621 | -122.41048698011 | (37.7542530206621, -122.41048698011) | 2 | 4 | 7 | 28859 | 19 | ||
112805 | 224672 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 800 Florida St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009346.52184 | 2104406.68388 | 37.7588273781878 | -122.410717513006 | (37.7588273781878, -122.410717513006) | 2 | 4 | 7 | 28859 | 19 | |||
54673 | 224671 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 800 Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009345.91132 | 2104426.34813 | 37.758881337533 | -122.410721013192 | (37.758881337533, -122.410721013192) | 2 | 4 | 7 | 28859 | 19 | |||
111591 | 224669 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 800 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6009345.52709 | 2104457.09364 | 37.7589657361945 | -122.410724513338 | (37.7589657361945, -122.410724513338) | 2 | 4 | 7 | 28859 | 19 | |||
138926 | 224670 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 800 Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009345.18768 | 2104440.47189 | 37.758920077605 | -122.410724513327 | (37.758920077605, -122.410724513327) | 2 | 4 | 7 | 28859 | 19 | |||
142071 | 224668 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 800 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6009343.82267 | 2104472.74899 | 37.7590086266741 | -122.410731513656 | (37.7590086266741, -122.410731513656) | 2 | 4 | 7 | 28859 | 19 | |||
178369 | 556 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2934 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6009338.07942 | 2102203.47128 | 37.7527773788967 | -122.410591127672 | (37.7527773788967, -122.410591127672) | 2 | 4 | 7 | 28859 | 19 | |||
156513 | 74274 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 3001 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/1999 12:00:00 AM | 15 | 3x3 | 6009331.26403705 | 2104492.17139473 | 37.759061252045 | -122.410776319185 | (37.759061252045, -122.410776319185) | 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 | |||
15993 | 226468 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3001 20th St | 2 | 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 | |||
62588 | 114016 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 800x ALABAMA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009320 | 2104474 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | 2 | 4 | 7 | 28859 | 19 | ||||
83716 | 114018 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 800x ALABAMA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009320 | 2104474 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | 2 | 4 | 7 | 28859 | 19 | ||||
92990 | 114017 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 800x ALABAMA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009320 | 2104474 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | 2 | 4 | 7 | 28859 | 19 | ||||
179998 | 72861 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 800x ALABAMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/1999 12:00:00 AM | 14 | 3x3 | 6009320 | 2104474 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | 2 | 4 | 7 | 28859 | 19 | ||
184258 | 114015 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 800x ALABAMA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009320 | 2104474 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | 2 | 4 | 7 | 28859 | 19 | ||||
50814 | 224511 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1117 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6009227.24206 | 2102557.50534 | 37.7537432624556 | -122.410999428875 | (37.7537432624556, -122.410999428875) | 2 | 4 | 7 | 28859 | 19 | |||
154134 | 13369 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 900 Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X50 | 6009189.31279 | 2090017.34286 | 37.7193085603337 | -122.410245275395 | (37.7193085603337, -122.410245275395) | 9 | 3 | 7 | 309 | 28 | |||
28999 | 224659 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1086 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6009169.14858 | 2102873.09479 | 37.7546065423583 | -122.41122262175 | (37.7546065423583, -122.41122262175) | 2 | 4 | 7 | 28859 | 19 | |||
65684 | 65243 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1086 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28037 | 6009165.76758609 | 2102839.33295033 | 37.7545136503205 | -122.411231929366 | (37.7545136503205, -122.411231929366) | 2 | 4 | 7 | 28859 | 19 | ||
134890 | 569 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2970 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6009068.4734 | 2102184.68731 | 37.7527106833549 | -122.411522150837 | (37.7527106833549, -122.411522150837) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
108921 | 571 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2970 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/30/2015 12:00:00 AM | 12 | 3x3 | 6009054.00613 | 2102184.08314 | 37.7527082129358 | -122.411572138748 | (37.7527082129358, -122.411572138748) | 2 | 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 | |||
122395 | 224578 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2881 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009009.60186 | 2101733.0677 | 37.7514673346644 | -122.411693832315 | (37.7514673346644, -122.411693832315) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||||
175731 | 224660 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 602 Alabama St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6008966.98404 | 2105222.67226 | 37.7610466091319 | -122.41208780281 | (37.7610466091319, -122.41208780281) | 2 | 4 | 7 | 28859 | 19 | |||
38685 | 224661 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 602 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6008966.38412 | 2105242.83972 | 37.7611019507102 | -122.412091302998 | (37.7611019507102, -122.412091302998) | 2 | 4 | 7 | 28859 | 19 | |||
190230 | 26514 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2880 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6008952.92902 | 2101706.37447 | 37.7513908617048 | -122.411887928494 | (37.7513908617048, -122.411887928494) | 2 | 4 | 7 | 28859 | 19 | |||
152129 | 35055 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 570 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/1998 12:00:00 AM | Permit Number 38614 | 6008948.51314843 | 2105576.68374234 | 37.7620176073252 | -122.41217670641 | (37.7620176073252, -122.41217670641) | 8 | 4 | 7 | 28859 | 19 | ||
36047 | 69485 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 560 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | Permit Number 33606 | 6008946.01217425 | 2105621.19939594 | 37.7621396967865 | -122.412188502645 | (37.7621396967865, -122.412188502645) | 8 | 4 | 7 | 28859 | 19 | ||
122639 | 224666 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 570 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008945.18383 | 2105567.26579 | 37.7619915609728 | -122.412187555625 | (37.7619915609728, -122.412187555625) | 8 | 4 | 7 | 28859 | 19 | |||
108436 | 224667 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 560 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008944.82068 | 2105599.01741 | 37.7620787232758 | -122.412191055786 | (37.7620787232758, -122.412191055786) | 8 | 4 | 7 | 28859 | 19 | |||
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 | ||||
52676 | 224579 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2577 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008913.82756 | 2103471.3398 | 37.7562348656635 | -122.412147871222 | (37.7562348656635, -122.412147871222) | 2 | 4 | 7 | 28859 | 19 | |||
135138 | 574 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3000 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6008882.07656 | 2102170.50291 | 37.7526612791072 | -122.412165744373 | (37.7526612791072, -122.412165744373) | 2 | 4 | 7 | 28859 | 19 | |||
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 |
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) );