969 rows where qSpecies_id = 97 sorted by rowid descending

View and edit SQL

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)
194356 224589 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 2765 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008256.05874 2106775.28704 37.7652698164603 -122.414656469826 (37.7652698164603, -122.414656469826) 8 4 7 28859 19
194157 224494 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 140 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6005454.36959 2096149.25289 37.7359353702183 -122.423591316208 (37.7359353702183, -122.423591316208) 2 7 7 28859 2
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
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
193369 61728 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 121 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1984 12:00:00 AM     Permit Number 21733 6004369.94753879 2101000.29060373 37.7491939379116 -122.427686117612 (37.7491939379116, -122.427686117612) 2 4 5 28862 22
193316 224541 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 2925 21st St 5 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008764.83764 2103880.48748 37.7573499314791 -122.412692054597 (37.7573499314791, -122.412692054597) 2 4 7 28859 19
193156 176432 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 125 Britton St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008419.02136 2087402.07841 37.7120843800612 -122.4127231046 (37.7120843800612, -122.4127231046) 9 7 8 309 39
192915 66937 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2350 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/1992 12:00:00 AM     Permit Number 30262 5998853.41639727 2111835.46191539 37.7786310079222 -122.447542123222 (37.7786310079222, -122.447542123222) 15 6 2 54 16
192225 224577 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3137 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008697.40376 2105629.55646 37.7621486905358 -122.413048937978 (37.7621486905358, -122.413048937978) 2 4 7 28859 19
190656 30538 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 614 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 34538 6003619.86564688 2110438.7017887 37.7750670913733 -122.430953433821 (37.7750670913733, -122.430953433821) 7 9 11 29492 10
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
189934 64807 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 74 Newburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1989 12:00:00 AM     Permit Number 25809 6002370.48571479 2099839.6903707 37.7458938988463 -122.434517304917 (37.7458938988463, -122.434517304917) 2 7 5 63 22
189826 218806 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 217 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5999893.77638 2094346.53737 37.7306700941413 -122.44268704209 (37.7306700941413, -122.44268704209) 9 7 4 63 40
189791 224495 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 142 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6005480.01407 2096145.74782 37.7359271935727 -122.423502403815 (37.7359271935727, -122.423502403815) 2 7 7 28859 2
189517 176433 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 118 Chester Ave 4 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5991720.02905 2088438.70148 37.7139792884876 -122.470514566313 (37.7139792884876, -122.470514566313) 9 8 6 64 24
189515 23099 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1406 Valencia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 5x4   6006424.41645 2101384.80463 37.7503657245067 -122.420609012309 (37.7503657245067, -122.420609012309) 2 4 5 28859 19
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
189333 224619 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1324 Clayton St 1 : Tree Private 2     13 Width 3ft   5999058.14954 2104997.17372 37.7598664980489 -122.446341813123 (37.7598664980489, -122.446341813123) 15 5 5 28862 3
188830 61704 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 560 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/1984 12:00:00 AM     Permit Number 21703 6005065.62335195 2107833.77826085 37.7679964138535 -122.42576678516 (37.7679964138535, -122.42576678516) 8 4 5 28853 19
188743 226482 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3470 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6006420.39089 2104965.96025 37.760198524163 -122.420877154151 (37.760198524163, -122.420877154151) 2 4 7 28859 19
188441 224628 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1053 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5997656.24362 2106853.17472 37.7648824406996 -122.45132415711 (37.7648824406996, -122.45132415711) 15 5 11 29492 9
188220 60835 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 237 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1983 12:00:00 AM     Permit Number 20608 6004787.65423878 2102293.57578284 37.7527686178291 -122.42633374857 (37.7527686178291, -122.42633374857) 2 4 5 28862 22
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
187780 224574 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3143 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6008595.85169 2105623.97585 37.7621276661759 -122.4133997743 (37.7621276661759, -122.4133997743) 2 4 7 28859 19
187559 51017 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 464 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/2004 12:00:00 AM     Permit Number 47495 6003323.42861905 2103333.57669245 37.75554133817 -122.431471541095 (37.75554133817, -122.431471541095) 2 4 5 28862 22
187398 623 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3158 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   6007941.8237 2102115.06302 37.7524562507759 -122.415413389641 (37.7524562507759, -122.415413389641) 2 4 7 28859 19
187259 224590 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3111 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6006042.423 2106653.80762 37.7648116442701 -122.422304291014 (37.7648116442701, -122.422304291014) 8 4 5 28859 19
186946 33612 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 310 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/02/1996 12:00:00 AM     Permit Number 37722 6005039.5469288 2110085.00234602 37.7741762578244 -122.42601725751 (37.7741762578244, -122.42601725751) 7 9 11 28852 10
186913 59494 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3121 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/02/1981 12:00:00 AM 14 4x4 Permit Number 18869 6006018.54214632 2106655.70514999 37.7648155073416 -122.422387023676 (37.7648155073416, -122.422387023676) 8 4 5 28859 19
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
186624 224609 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3556 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6005809.70389 2102588.37341 37.7536357835838 -122.422820259951 (37.7536357835838, -122.422820259951) 2 4 5 28859 19
186380 596 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3066 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     22 3x3   6008530.73419 2102152.94469 37.7525933479176 -122.413379510765 (37.7525933479176, -122.413379510765) 2 4 7 28859 19
186379 101432 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 2501X Buchanan St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003643.1 2116935.1 37.7929058867978 -122.431336896261 (37.7929058867978, -122.431336896261) 13 9 1 29490 27
186372 59298 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 734 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1980 12:00:00 AM     Permit Number 18636 5993516.37713931 2106668.84289355 37.7641383983924 -122.465629390558 (37.7641383983924, -122.465629390558) 11 8 11 56 12
186316 224703 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3236 24th St 2 Sidewalk: Curb side : Cutout Tree DPW 1     20 Width 3ft   6007440.93162 2102096.08231 37.7523759682811 -122.417144217627 (37.7523759682811, -122.417144217627) 2 4 7 28859 19
186297 63778 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 140 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24459 6004215.48168844 2101629.42267968 37.7509126493248 -122.428265095141 (37.7509126493248, -122.428265095141) 2 4 5 28862 22
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
185991 64025 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2395x 15TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1987 12:00:00 AM     Permit Number 24782 6001858 2107008 37.7655472468341 -122.436802461881 (37.7655472468341, -122.436802461881) 15 5 5 28862 3
185967 224558 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3349 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6007935.38501 2104420.89222 37.7587871703981 -122.415598898179 (37.7587871703981, -122.415598898179) 2 4 7 28859 19
185465 224629 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 329 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6007740.48208 2097528.6384 37.7398516362417 -122.415784934638 (37.7398516362417, -122.415784934638) 2 7 7 28859 2
185167 33614 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 312 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/02/1996 12:00:00 AM     Permit Number 37724 6005030.32834442 2110083.71933458 37.7741722139784 -122.4260490549 (37.7741722139784, -122.4260490549) 7 9 11 28852 10
185038 111900 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 650X Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2016 12:00:00 AM 3     6003603.61647971 2110556.18401653 37.7753887478808 -122.431018029936 (37.7753887478808, -122.431018029936) 7 9 11 29492 10
184895 218827 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 15 Rossmoor Dr 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5991236.4555 2094303.51433 37.7300546412872 -122.472613299773 (37.7300546412872, -122.472613299773) 9 8 4 64 40
184855 218813 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 317 Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5995878.91715 2088155.78665 37.7134420721779 -122.456119525718 (37.7134420721779, -122.456119525718) 9 8 6 28861 24
184847 63772 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1134 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24451 6003162.44517655 2101626.56141002 37.7508451528322 -122.431906388672 (37.7508451528322, -122.431906388672) 2 4 5 28862 22
184502 33607 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 314 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/02/1996 12:00:00 AM     Permit Number 37719 6005021.10976005 2110082.43632314 37.7741681701238 -122.426080852286 (37.7741681701238, -122.426080852286) 7 9 11 28852 10
184443 224505 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 2200 Folsom St 9 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6008118.04648 2105348.76718 37.7613451678544 -122.415032844197 (37.7613451678544, -122.415032844197) 2 4 7 28859 19
184346 218831 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1550 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991205.91202 2098425.81226 37.7413716577778 -122.473019387736 (37.7413716577778, -122.473019387736) 1 8 4 29491 40
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
184130 224683 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1380 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6006412.3793 2101568.56601 37.7508696128423 -122.420663681196 (37.7508696128423, -122.420663681196) 2 4 5 28859 19
183843 176408 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 55 Dichiera Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5998608.92575 2087907.12594 37.7129156324143 -122.446665811891 (37.7129156324143, -122.446665811891) 9 7 6 28861 25
183797 224615 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 525 Burnett Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5999500.0818 2102479.17274 37.7529779168973 -122.444632407852 (37.7529779168973, -122.444632407852) 2 5 5 63 38
183423 63773 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 400 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24453 6004132.01414207 2101578.81224199 37.7507689616906 -122.428550126724 (37.7507689616906, -122.428550126724) 2 4 5 28862 22
183317 5133 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 2796 Diamond St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6002464.77756 2095726.89475 37.7346064681217 -122.433897334607 (37.7346064681217, -122.433897334607) 2 7 5 63 7
183273 52783 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 269@ 24th ST Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/25/2006 12:00:00 AM     Permit Number 48827 6004796.86181264 2102115.84108407 37.7522811202098 -122.426289254005 (37.7522811202098, -122.426289254005) 2 4 5 28862 22
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
182989 218837 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 725 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5990923.73813 2099033.65671 37.7430243014348 -122.474039375442 (37.7430243014348, -122.474039375442) 1 8 4 29491 40
182814 61735 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 246 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1984 12:00:00 AM     Permit Number 21740 6003563.88991247 2101007.45012611 37.7491679679218 -122.430473986745 (37.7491679679218, -122.430473986745) 2 4 5 28862 22
182596 64939 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1904 Filbert St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/24/1989 12:00:00 AM 14 4x9 Permit Number 25968 6003770.59823 2119034.75591 37.798678227572 -122.431045672521 (37.798678227572, -122.431045672521) 13 9 1 57 17
182226 224626 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 601 Buena Vista Ave West 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5999843.00884 2107568.58853 37.7669717582745 -122.443812120926 (37.7669717582745, -122.443812120926) 15 5 5 29492 9
182138 63877 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 849 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/16/1987 12:00:00 AM     Permit Number 24582 6003121.89544563 2103305.24261692 37.7554521151946 -122.432166481498 (37.7554521151946, -122.432166481498) 2 4 5 28862 22
181783 176414 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 850 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6001021.05329 2088894.22631 37.7157634831843 -122.438399402832 (37.7157634831843, -122.438399402832) 9 7 6 28861 5
181653 103151 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 2190X Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x9   6002428.2 2119190 37.7990283301562 -122.435701904836 (37.7990283301562, -122.435701904836) 13 9 1 57 17
181644 224540 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 2925 21st St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008691.13752 2103878.13413 37.7573393329509 -122.412946773194 (37.7573393329509, -122.412946773194) 2 4 7 28859 19
181582 224591 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3117 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6006001.0018 2106651.39278 37.7648026771212 -122.422447384857 (37.7648026771212, -122.422447384857) 8 4 5 28859 19
181335 224625 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 50 Piedmont St 1 Sidewalk: Curb side : Yard Tree Private 2     9 Width 5ft   5999457.54578 2107020.99028 37.7654461969099 -122.445105999866 (37.7654461969099, -122.445105999866) 15 5 5 29492 9
181331 34143 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 400 Treat Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1997 12:00:00 AM     Permit Number 37990 6008524.65557539 2106230.12436926 37.7637880127631 -122.413688890617 (37.7637880127631, -122.413688890617) 8 4 7 28859 19
181277 68371 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1233 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32193 5998967.61980979 2105592.97843293 37.7614972584923 -122.446697779287 (37.7614972584923, -122.446697779287) 15 5 11 29492 12
181231 57942 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 15 Byron Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2015 12:00:00 AM 3 3x3 Permit Number 776219 5999289.47216 2086646.12526 37.7094920599881 -122.444223069735 (37.7094920599881, -122.444223069735) 9 7 6 28861 5
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
180591 224572 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3149 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6008508.49482 2105618.39976 37.7621074503316 -122.413701514835 (37.7621074503316, -122.413701514835) 2 4 7 28859 19
180413 101429 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 2501X Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003643.1 2116935.1 37.7929058867978 -122.431336896261 (37.7929058867978, -122.431336896261) 13 9 1 29490 27
180392 176418 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 216 Dublin St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 1ft   6004075.47639 2089186.2671 37.7167386279577 -122.427862706522 (37.7167386279577, -122.427862706522) 9 7 6 28861 5
180250 224681 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1390 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6006415.87838 2101496.97772 37.7506732449771 -122.420646499655 (37.7506732449771, -122.420646499655) 2 4 5 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
179766 34151 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 30 Steuart St 7 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
179582 224605 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 71 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6005897.27948 2103429.13328 37.7559492562604 -122.422577143518 (37.7559492562604, -122.422577143518) 2 4 5 28859 19
179560 66225 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 36 Dorland St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/1990 12:00:00 AM     Permit Number 29319 6005318.51312392 2105778.36560715 37.76236702737 -122.424745827071 (37.76236702737, -122.424745827071) 8 4 5 28859 19
179373 63876 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 493 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/16/1987 12:00:00 AM     Permit Number 24580 6003154.01696483 2103272.14676469 37.7553630630052 -122.432053032269 (37.7553630630052, -122.432053032269) 2 4 5 28862 22
179236 30890 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 412 Hayes St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/08/1995 12:00:00 AM     Permit Number 34719 6005865.19335847 2111068.58127823 37.7769235557198 -122.423231126893 (37.7769235557198, -122.423231126893) 7 9 11 28852 10
179128 66115 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 817 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/15/1990 12:00:00 AM     Permit Number 29170 6003947.68857827 2110748.1234611 37.7759352566539 -122.429841497852 (37.7759352566539, -122.429841497852) 7 9 11 29492 10
178967 224622 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1323 Clayton St 1 : Tree Private 2     13 Width 3ft   5999026.56459 2105047.83376 37.7600037939542 -122.446454694247 (37.7600037939542, -122.446454694247) 15 5 5 28862 12
178899 61526 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1335 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/1984 12:00:00 AM     Permit Number 21483 5991367.33157346 2114748.57792616 37.7861989598694 -122.47365167719 (37.7861989598694, -122.47365167719) 11 6 2 54 26
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
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
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
178322 30927 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 236 Holloway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM 13   Permit Number 34740 5996038.7385 2091232.95448 37.7219004244455 -122.455789433158 (37.7219004244455, -122.455789433158) 9 8 4 28861 24
177810 23094 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1384 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/01/1992 12:00:00 AM 3 3x3   6006412.34173 2101544.72785 37.7508041565902 -122.420662119057 (37.7508041565902, -122.420662119057) 2 4 5 28859 19
177687 224701 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3230 24th St 3 Sidewalk: Curb side : Cutout Tree DPW 1     17 Width 3ft   6007503.74003 2102097.04469 37.7523821439458 -122.416927083514 (37.7523821439458, -122.416927083514) 2 4 7 28859 19
177333 250315 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3828 Jackson St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5995912.98237 2115873.60258 37.7895501834435 -122.458006465223 (37.7895501834435, -122.458006465223) 11 6 1 54 31
177108 34149 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 30 Steuart St 5 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
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
176171 60542 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 615 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1982 12:00:00 AM     Permit Number 20152 5985331.57099648 2111677.45152223 37.7774151286277 -122.494307063797 (37.7774151286277, -122.494307063797) 11 6 2 55 26
176086 605 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3098 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   6008383.72095 2102142.9064 37.7525575297129 -122.413887199647 (37.7525575297129, -122.413887199647) 2 4 7 28859 19
176059 63988 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 237 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/1987 12:00:00 AM     Permit Number 24734 6004762.51437158 2103946.91619601 37.7573068822751 -122.42653840479 (37.7573068822751, -122.42653840479) 2 4 5 28862 3
175928 60193 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 236 Laussat St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/1986 12:00:00 AM     Permit Number 22999 6003584.73517067 2109188.28225965 37.771631755989 -122.430985695552 (37.771631755989, -122.430985695552) 15 9 11 29492 10
175733 224677 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 254 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007152.66781 2105827.76249 37.7626060812304 -122.418405656216 (37.7626060812304, -122.418405656216) 8 4 7 28859 19
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
175614 224623 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1323 Clayton St 1 : Tree Private 2     13 Width 3ft   5999023.60773 2105026.39376 37.75994475616 -122.446463378096 (37.75994475616, -122.446463378096) 15 5 5 28862 12
175405 176404 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 332 Ellington Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   5998751.95541 2087834.14028 37.712723399629 -122.446166209719 (37.712723399629, -122.446166209719) 9 7 6 28861 25

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);