trees
969 rows where qSpecies_id = 97 sorted by Location
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15539 | 37970 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 602 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/1998 12:00:00 AM | Permit Number 40200 | |||||||||||||
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 | ||
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 | |
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||
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 | |||
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 |
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) );