969 rows where qSpecies_id = 97 sorted by YCoord

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)
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                    
75846 32047 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 501 Tunnel Ave 2 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
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
25718 176421 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 526 Lathrop Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6013003.58559 2086544.76512 37.7099866196603 -122.396817348641 (37.7099866196603, -122.396817348641) 10 3 8 309 1
139460 176420 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 526 Lathrop Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6012864.54988 2086589.64347 37.7101021070033 -122.397301031027 (37.7101021070033, -122.397301031027) 10 3 8 309 1
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
173183 57946 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 10 Byron Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/1977 12:00:00 AM 9   Permit Number 16905 5999382.31979 2086721.86457 37.7097053198058 -122.443907611844 (37.7097053198058, -122.443907611844) 9 7 6 28861 5
117760 176435 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 275 De Long St 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 10ft   5993714.58235 2086792.86785 37.7095753489021 -122.463501322023 (37.7095753489021, -122.463501322023) 9 8 6 28861 25
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
74260 176431 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 146 Britton St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6008376.30406 2087394.4749 37.7120611046958 -122.412870211214 (37.7120611046958, -122.412870211214) 9 7 8 309 39
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
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
41384 176403 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 332 Ellington Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   5998770.03746 2087851.68696 37.7127726114513 -122.446104973962 (37.7127726114513, -122.446104973962) 9 7 6 28861 25
124277 176402 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 332 Ellington Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   5998803.89987 2087884.30754 37.7128641138726 -122.445990279822 (37.7128641138726, -122.445990279822) 9 7 6 28861 25
144874 176409 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 45 Dichiera Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   5998625.6999 2087888.85423 37.7128664206305 -122.44660652137 (37.7128664206305, -122.44660652137) 9 7 6 28861 25
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
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
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
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
33097 176407 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 65 Dichiera Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5998589.29961 2087923.49641 37.7129594608753 -122.446734823157 (37.7129594608753, -122.446734823157) 9 7 6 28861 25
59306 176406 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 75 Dichiera Ct 2 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 2ft   5998546.73235 2087959.10708 37.7130548079177 -122.446884509935 (37.7130548079177, -122.446884509935) 9 7 6 28861 25
115754 176405 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 75 Dichiera Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 2ft   5998552.29871 2087983.35456 37.7131217039812 -122.446867014517 (37.7131217039812, -122.446867014517) 9 7 6 28861 25
93600 37390 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 95 Newton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1999 12:00:00 AM 15   Permit Number 41125 6000958.3691 2088020.28702 37.7133602752401 -122.438553486373 (37.7133602752401, -122.438553486373) 9 7 6 28861 5
11351 78716 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 412 Leland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6008662.0794 2088043.12802 37.7138582091656 -122.411928294567 (37.7138582091656, -122.411928294567) 9 7 8 309 39
133682 218815 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 317 Plymouth Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5995878.85538 2088132.44419 37.7133779756852 -122.456118052609 (37.7133779756852, -122.456118052609) 9 8 6 28861 24
43800 218814 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 317 Plymouth Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5995878.65108 2088143.05914 37.7134071101336 -122.456119525718 (37.7134071101336, -122.456119525718) 9 8 6 28861 24
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
70372 218812 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 317 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5995879.6181 2088168.92922 37.7134781988423 -122.456118052617 (37.7134781988423, -122.456118052617) 9 8 6 28861 24
147151 218826 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 354 Head St 1 : Tree Private 2     8 Width 3ft   5993503.05802 2088221.25741 37.713485177561 -122.46433601702 (37.713485177561, -122.46433601702) 9 8 6 64 24
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
53327 176434 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 109 Chester Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991752.24555 2088448.0917 37.714006934552 -122.47040389842 (37.714006934552, -122.47040389842) 9 8 6 64 24
103243 218824 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 104 Vernon St 1 : Tree Private 2     12 Width 3ft   5992465.47636 2088577.72346 37.7144040850433 -122.467948147585 (37.7144040850433, -122.467948147585) 9 8 6 64 24
149904 218823 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 122 Vernon St 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 10ft   5992474.68721 2088695.04537 37.7147267546141 -122.467924839857 (37.7147267546141, -122.467924839857) 9 8 6 64 24
50215 176416 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 860 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6000990.84724 2088839.6326 37.715611862882 -122.438499899353 (37.715611862882, -122.438499899353) 9 7 6 28861 5
79322 25364 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 994 Geneva Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6000636.2417 2088870.05563 37.7156752201082 -122.43972775363 (37.7156752201082, -122.43972775363) 9 7 6 28861 5
155149 176415 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 850 Lisbon St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6001011.08243 2088875.9268 37.7157126696686 -122.438432556321 (37.7157126696686, -122.438432556321) 9 7 6 28861 5
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
170945 58156 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 837 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1978 12:00:00 AM 9   Permit Number 17140 6001092.2872 2088918.12181 37.7158331464556 -122.438154896944 (37.7158331464556, -122.438154896944) 9 7 6 28861 5
48982 176417 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 825 Lisbon St 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 6ft   6001125.80716 2088973.54213 37.7159872246076 -122.438043004189 (37.7159872246076, -122.438043004189) 9 7 6 28861 5
158936 101289 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 830 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2     9     6001069.51096 2088976.20041 37.715991321918 -122.438237780259 (37.715991321918, -122.438237780259) 9 7 6 28861 5
100913 58155 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 815 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1978 12:00:00 AM 11   Permit Number 17139 6001141.03185 2088999.49301 37.7160593457428 -122.437992238373 (37.7160593457428, -122.437992238373) 9 7 6 28861 5
32503 176413 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 816 Lisbon St 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 6ft   6001088.39895 2089005.35886 37.7160724587542 -122.4381745822 (37.7160724587542, -122.4381745822) 9 7 6 28861 5
131345 58153 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 816 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1978 12:00:00 AM 2   Permit Number 17137 6001098.08865 2089024.55935 37.7161257300936 -122.438142464699 (37.7161257300936, -122.438142464699) 9 7 6 28861 5
156839 58154 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 807 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1978 12:00:00 AM 10   Permit Number 17138 6001157.22948 2089029.0056 37.7161413018433 -122.43793836449 (37.7161413018433, -122.43793836449) 9 7 6 28861 5
91045 58152 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 806 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1978 12:00:00 AM 11   Permit Number 17136 6001116.27875 2089048.95657 37.7161937539141 -122.438081337797 (37.7161937539141, -122.438081337797) 9 7 6 28861 5
74072 25396 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 945 Geneva Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3X3   6000465.25163 2089064.76788 37.7162001220051 -122.440332727576 (37.7162001220051, -122.440332727576) 9 7 6 28861 5
169776 218825 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 295 Bright St 1 Sidewalk: Curb side : Pot Tree Private 2     5 Width 4ft   5993731.49381 2089150.28883 37.7160492409447 -122.463613852416 (37.7160492409447, -122.463613852416) 9 8 6 64 24
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
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
137498 62505 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 800 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/10/1986 12:00:00 AM 15   Permit Number 22680 6000887.29767 2089194.58306 37.7165805865148 -122.438883234479 (37.7165805865148, -122.438883234479) 9 7 6 28861 5
67440 218816 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 170 Margaret Ave 1 Sidewalk: Curb side : Pot Tree Private 2     7 Width 4ft   5996666.01962 2089250.86092 37.7164940402408 -122.453478054989 (37.7164940402408, -122.453478054989) 9 8 6 28861 24
50071 218822 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 210 Vernon St 3 Sidewalk: Property side : Yard Tree Private 2     8 Width 8ft   5992480.53035 2089289.94219 37.7163605349795 -122.467947888583 (37.7163605349795, -122.467947888583) 9 8 6 64 24
91506 176412 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 2 Amazon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   6000489.46107 2089401.47314 37.7171260172357 -122.440273180786 (37.7171260172357, -122.440273180786) 9 7 6 28861 5
78944 55568 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1132 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/1972 12:00:00 AM 13 3x2 Permit Number 11537 6011293.45596 2089493.71978 37.7179885201224 -122.402935191909 (37.7179885201224, -122.402935191909) 10 7 8 309 39
164692 55317 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1126 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1972 12:00:00 AM 4   Permit Number 11246 6011285.28669 2089520.65076 37.7180620109438 -122.402965322811 (37.7180620109438, -122.402965322811) 10 7 8 309 39
11332 55316 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1125 Goettingen St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/26/1972 12:00:00 AM 14 3x3 Permit Number 11245 6011314.64048 2089535.2445 37.7181037214869 -122.402864884726 (37.7181037214869, -122.402864884726) 10 7 8 309 39
124492 218818 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 230 Lakeview Ave 1 : Tree Private 2     10 Width 3ft   5996994.97967 2089536.58432 37.7172974217136 -122.452361618599 (37.7172974217136, -122.452361618599) 9 8 6 28861 24
5103 55566 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1120 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/1972 12:00:00 AM 14 3x3 Permit Number 11535 6011279.28081 2089546.81423 37.7181335151377 -122.402987921868 (37.7181335151377, -122.402987921868) 10 7 8 309 39
84831 111317 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1114 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6011270.9057 2089563.62226 37.7181791988873 -122.403018052761 (37.7181791988873, -122.403018052761) 10 7 8 309 39
46674 111609 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 301x Ward St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 15x3   6011168.56615 2089615.14952 37.7183149668287 -122.403375421742 (37.7183149668287, -122.403375421742) 10 7 8 309 39
39200 111610 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 301x Ward St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 9x3   6011193.26322 2089621.79675 37.7183345981422 -122.403290521257 (37.7183345981422, -122.403290521257) 10 7 8 309 39
69802 111611 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 301x Ward St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 9x3   6011211.14629 2089627.82993 37.7183521627878 -122.403229130826 (37.7183521627878, -122.403229130826) 10 7 8 309 39
125788 218817 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 431 Lakeview Ave 1 : Tree Private 2     9 Width 3ft   5996521.08411 2089810.02006 37.7180210513199 -122.454019381193 (37.7180210513199, -122.454019381193) 9 8 6 28861 24
150846 28252 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3342 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X3   6011993.05449 2089944.36853 37.7192649513087 -122.400548608856 (37.7192649513087, -122.400548608856) 10 7 8 309 28
102221 28251 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3340 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X3   6011988.71606 2089960.7357 37.7193096502899 -122.400564754381 (37.7193096502899, -122.400564754381) 10 7 8 309 28
120892 176426 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3338 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6011984.529 2089984.5422 37.7193747846049 -122.400580899003 (37.7193747846049, -122.400580899003) 10 7 8 309 28
37053 176425 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3338 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6011982.06755 2090001.33634 37.7194207606357 -122.400590586484 (37.7194207606357, -122.400590586484) 10 7 8 309 28
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
153013 176419 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 638 Madrid St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   6002178.18938 2090229.77829 37.7194963630453 -122.43449524976 (37.7194963630453, -122.43449524976) 9 7 6 28861 5
71226 218821 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 278 Monticello St 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   5991714.63996 2090365.57714 37.719269707816 -122.470673455841 (37.719269707816, -122.470673455841) 9 8 6 64 24
161624 218820 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 205 Beverly St 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   5991411.7286 2090565.37313 37.7198007772708 -122.471735048829 (37.7198007772708, -122.471735048829) 9 8 6 64 24
24672 218819 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 205 Beverly St 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   5991410.90841 2090573.24495 37.7198223438984 -122.471738457278 (37.7198223438984, -122.471738457278) 9 8 6 64 24
125538 218810 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 75 Williar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5997095.6983 2090612.61251 37.7202577138075 -122.452091075552 (37.7202577138075, -122.452091075552) 9 8 6 28861 24
38823 218811 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 75 Williar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5997101.63162 2090622.46989 37.7202851197392 -122.45207127697 (37.7202851197392, -122.45207127697) 9 8 6 28861 24
47140 218809 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 118 Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5996535.53946 2090678.52967 37.720406603762 -122.45403210661 (37.720406603762, -122.45403210661) 9 8 6 28861 24
23930 15770 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 4770 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2007 12:00:00 AM 3 3X3   6001421.7162 2091049.3752 37.7217038208164 -122.437168746584 (37.7217038208164, -122.437168746584) 9 7 6 28861 25
120959 176410 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 60 Onondaga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6000924.60134 2091091.49706 37.7217912071684 -122.438890154751 (37.7217912071684, -122.438890154751) 9 7 6 28861 25
47706 176411 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 60 Onondaga Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6000874.43024 2091115.97701 37.7218555689538 -122.439065336396 (37.7218555689538, -122.439065336396) 9 7 6 28861 25
44712 30926 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 230 Holloway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM 13   Permit Number 34739 5996065.71046 2091231.30039 37.7218974306099 -122.455696079012 (37.7218974306099, -122.455696079012) 9 8 4 28861 24
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
12747 65465 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 618 Holloway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1989 12:00:00 AM     Permit Number 28343 5994991.49008264 2091257.73775868 37.7219083154277 -122.459411273619 (37.7219083154277, -122.459411273619) 9 8 4 28861 24
78518 66628 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 412 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/15/1991 12:00:00 AM 16   Permit Number 29832 6002951.53686 2091458.2652 37.7229133848294 -122.431909745644 (37.7229133848294, -122.431909745644) 9 7 6 28861 5
128778 65199 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 393 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/1989 12:00:00 AM     Permit Number 27185 6003086.32595187 2091584.19795725 37.7232668084318 -122.431452793676 (37.7232668084318, -122.431452793676) 9 7 6 28861 5
153527 65474 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1185 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/11/1989 12:00:00 AM     Permit Number 28355 5995034.99249971 2091783.3730714 37.7233540853263 -122.459298943633 (37.7233540853263, -122.459298943633) 9 8 4 28861 24
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
32783 62137 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 127 San Juan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/31/1985 12:00:00 AM     Permit Number 22247 6001408.1074829 2092199.32717361 37.7248605551976 -122.437298087712 (37.7248605551976, -122.437298087712) 9 7 6 28861 25
115568 62139 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 394 Capistrano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1985 12:00:00 AM     Permit Number 22347 6000980.72200275 2092487.56875551 37.7256276955072 -122.438796151694 (37.7256276955072, -122.438796151694) 9 7 6 28861 25
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
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
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
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
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
98693 218808 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 379 Flood Ave 2 Sidewalk: Property side : Yard Tree Private 2     5     5998237.66884 2094066.68072 37.7298071263007 -122.448392288972 (37.7298071263007, -122.448392288972) 9 7 4 28861 40
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
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
106260 218807 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 238 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   5999815.89022 2094384.28046 37.7307692875673 -122.442959015043 (37.7307692875673, -122.442959015043) 9 7 4 63 40
109653 173730 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 387 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999535 2094919 37.7322214835803 -122.443968498715 (37.7322214835803, -122.443968498715) 9 7 4 63 40
132605 218804 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 161 San Rafael Way 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5991882.49508 2095116.63402 37.7323246389721 -122.470439076297 (37.7323246389721, -122.470439076297) 9 8 4 59 40
128200 66311 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 140 Hamerton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1990 12:00:00 AM     Permit Number 29426 6001329.17242898 2095394.93152934 37.7336304648573 -122.437799727546 (37.7336304648573, -122.437799727546) 9 7 5 63 40
104440 224498 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 834 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6007554.05965 2095454.27722 37.7341454144668 -122.416282623937 (37.7341454144668, -122.416282623937) 2 7 7 28859 2

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