trees
969 rows where qSpecies_id = 97 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 92420 | 126617 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3001 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 5999428.93901 | 2119163.44026 | 37.7987845877085 | -122.446078403512 | (37.7987845877085, -122.446078403512) | 13 | 9 | 1 | 57 | 17 | |||
| 150027 | 126618 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3301 Van Ness Ave | 6 | : | Tree | Private 2 | 15 | Width 3ft | 6005157.45717 | 2122152.06561 | 37.8073160440754 | -122.426468777106 | (37.8073160440754, -122.426468777106) | 13 | 9 | 1 | 28858 | 17 | |||
| 86489 | 126619 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3616 Jackson St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 5996924.84901 | 2116015.00596 | 37.789996524161 | -122.454515752993 | (37.789996524161, -122.454515752993) | 11 | 6 | 1 | 54 | 31 | |||
| 36271 | 126620 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1430 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6007903.30397 | 2116551.24821 | 37.7920924400618 | -122.416569132658 | (37.7920924400618, -122.416569132658) | 5 | 1 | 10 | 28858 | 21 | |||
| 132084 | 126621 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3616 Jackson St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 5996947.82538 | 2116018.92975 | 37.7900086155661 | -122.454436540723 | (37.7900086155661, -122.454436540723) | 11 | 6 | 1 | 54 | 31 | |||
| 129082 | 126622 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3340 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5998235.51312 | 2116198.50625 | 37.7905754501486 | -122.449994218979 | (37.7905754501486, -122.449994218979) | 13 | 6 | 1 | 54 | 31 | |||
| 147021 | 126623 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3200 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5998899.76803 | 2116292.09263 | 37.7908703998933 | -122.447702685234 | (37.7908703998933, -122.447702685234) | 13 | 6 | 1 | 54 | 31 | |||
| 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 | |||
| 106151 | 126625 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1445 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6011819.79643 | 2120570.04508 | 37.8033465696629 | -122.403300781611 | (37.8033465696629, -122.403300781611) | 3 | 1 | 10 | 28860 | 6 | |||
| 118171 | 126626 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50 Washington St | 1 | Median : Yard | Tree | Private 2 | 16 | Width 8ft | 6013909.98641 | 2118052.46146 | 37.7965503992498 | -122.395891028944 | (37.7965503992498, -122.395891028944) | 3 | 1 | 10 | 28860 | 6 | |||
| 162216 | 126627 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 2 | Median : Yard | Tree | DPW 1 | 17 | Width 8ft | 6013882.15291 | 2118048.61881 | 37.796538299751 | -122.395987070255 | (37.796538299751, -122.395987070255) | 3 | 1 | 10 | 28860 | 6 | |||
| 57949 | 126628 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 3 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6013814.15262 | 2118039.92484 | 37.7965106447043 | -122.396221758237 | (37.7965106447043, -122.396221758237) | 3 | 1 | 10 | 28860 | 6 | |||
| 113783 | 126629 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 4 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6013771.20775 | 2118034.57435 | 37.7964935638782 | -122.396369982705 | (37.7964935638782, -122.396369982705) | 3 | 1 | 10 | 28860 | 6 | |||
| 145617 | 126630 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 6 | Median : Yard | Tree | DPW 1 | 9 | Width 8ft | 6013712.21512 | 2118015.33042 | 37.7964374416781 | -122.396572761821 | (37.7964374416781, -122.396572761821) | 3 | 1 | 10 | 28860 | 6 | |||
| 5167 | 126631 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 7 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6013670.6132 | 2118002.84349 | 37.796400840179 | -122.39671583859 | (37.796400840179, -122.39671583859) | 3 | 1 | 10 | 28860 | 6 | |||
| 10858 | 128369 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 843 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 4ft | 6010471.73552 | 2116514.30785 | 37.7921351227858 | -122.4076796805 | (37.7921351227858, -122.4076796805) | 5 | 1 | 10 | 28857 | 21 | |||
| 5816 | 130501 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1971 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5999805.39025 | 2121212.90425 | 37.8044333562689 | -122.444923170372 | (37.8044333562689, -122.444923170372) | 13 | 9 | 1 | 57 | 17 | |||
| 1590 | 130502 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1971 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5999816.57477 | 2121214.69005 | 37.8044388979007 | -122.444884593948 | (37.8044388979007, -122.444884593948) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 120716 | 1351 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 271 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5999796.36324 | 2099302.32917 | 37.7442719740833 | -122.443379644158 | (37.7442719740833, -122.443379644158) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | ||
| 61058 | 166227 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3200 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6007587.23887 | 2102689.09416 | 37.7540124736145 | -122.416680268187 | (37.7540124736145, -122.416680268187) | 2 | 4 | 7 | 28859 | 19 | |||
| 131474 | 16900 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 409 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005007.3916 | 2110203.70331 | 37.7745003644325 | -122.426136940772 | (37.7745003644325, -122.426136940772) | 7 | 9 | 11 | 28852 | 10 | |||
| 69321 | 16914 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 483 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004697.20239 | 2110157.08412 | 37.7743548226588 | -122.427206624104 | (37.7743548226588, -122.427206624104) | 7 | 9 | 11 | 28852 | 10 | |||
| 27966 | 173643 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 657 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012793 | 2114089 | 37.7856054636163 | -122.399477673173 | (37.7856054636163, -122.399477673173) | 6 | 2 | 9 | 28853 | 6 | ||||
| 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 | ||||
| 34847 | 173694 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 201X Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011772 | 2114653 | 37.7870971135768 | -122.403049742128 | (37.7870971135768, -122.403049742128) | 12 | 2 | 9 | 28853 | 6 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 37941 | 184315 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1557 39th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5984032.5928 | 2104430.6415 | 37.7574413473895 | -122.498265228241 | (37.7574413473895, -122.498265228241) | 1 | 8 | 3 | 56 | 35 | |||
| 77132 | 184317 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1557 39th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5984033.1876 | 2104377.9194 | 37.7572966221146 | -122.498259277429 | (37.7572966221146, -122.498259277429) | 1 | 8 | 3 | 56 | 35 | |||
| 74301 | 1923 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 78 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6001189.66062 | 2097346.80979 | 37.7389819342562 | -122.438421854409 | (37.7389819342562, -122.438421854409) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 10390 | 199430 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 695 Arkansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Width 10ft | 6013045.24345 | 2103834.71473 | 37.7574635617095 | -122.397885411392 | (37.7574635617095, -122.397885411392) | 10 | 3 | 8 | 28856 | 29 | ||
| 1151 | 199431 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 695 Arkansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Width 10ft | 6013045.46319 | 2103845.54885 | 37.7574933220764 | -122.397885411405 | (37.7574933220764, -122.397885411405) | 10 | 3 | 8 | 28856 | 29 | ||
| 30016 | 199432 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1400 Newhall St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6014474.33722 | 2095838.07196 | 37.7355859449403 | -122.39238369005 | (37.7355859449403, -122.39238369005) | 10 | 3 | 8 | 58 | 1 | |||
| 101216 | 199433 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1400 Newhall St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6014453.55095 | 2095806.16281 | 37.7354971746608 | -122.392453325466 | (37.7354971746608, -122.392453325466) | 10 | 3 | 8 | 58 | 1 | |||
| 71962 | 199434 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6014431.27107 | 2095902.06527 | 37.7357592658851 | -122.392537062245 | (37.7357592658851, -122.392537062245) | 10 | 3 | 8 | 58 | 1 | |||
| 31557 | 199435 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6014455.52547 | 2095885.24717 | 37.735714433762 | -122.392452028664 | (37.735714433762, -122.392452028664) | 10 | 3 | 8 | 58 | 1 | |||
| 109268 | 200443 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2535 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6015875.48388 | 2103755.07735 | 37.7574021083324 | -122.388091663914 | (37.7574021083324, -122.388091663914) | 10 | 3 | 8 | 28856 | 29 | |||
| 5550 | 207625 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1223 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5995447.2053 | 2107231.58705 | 37.7657947273793 | -122.458992007973 | (37.7657947273793, -122.458992007973) | 15 | 5 | 11 | 56 | 12 | |||
| 145876 | 218802 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2370 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5992350.84884 | 2099324.20257 | 37.7439046297971 | -122.46912600049 | (37.7439046297971, -122.46912600049) | 1 | 8 | 4 | 29491 | 40 | |||
| 40301 | 218803 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2370 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5992349.88043 | 2099344.31841 | 37.7439598068059 | -122.469130812732 | (37.7439598068059, -122.469130812732) | 1 | 8 | 4 | 29491 | 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 | |||
| 98687 | 218805 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 67 Marne Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5995289.12081 | 2097585.29615 | 37.73929936437 | -122.458840331911 | (37.73929936437, -122.458840331911) | 9 | 7 | 4 | 59 | 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 |
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) );