trees
1,381 rows where qSpecies_id = 54 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 118375 | 10259 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 180 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005281.5755 | 2109598.2125 | 37.7728533265249 | -122.425145392536 | (37.7728533265249, -122.425145392536) | 7 | 9 | 11 | 28852 | 10 | |||
| 185363 | 10403 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1369 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 5999594.2543 | 2108755.1609 | 37.7702155954819 | -122.44475781987 | (37.7702155954819, -122.44475781987) | 15 | 5 | 11 | 29492 | 9 | |||
| 53133 | 104353 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2594 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5999783.3073 | 2113692.3242 | 37.7837825709749 | -122.444458768108 | (37.7837825709749, -122.444458768108) | 15 | 6 | 11 | 29490 | 31 | |||
| 182746 | 10463 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1584 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 5998533.6334 | 2108659.497 | 37.7698923436585 | -122.448419594554 | (37.7698923436585, -122.448419594554) | 15 | 5 | 11 | 29492 | 9 | |||
| 176134 | 10477 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1649 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5998216.9877 | 2108565.5899 | 37.7696163897252 | -122.449508092743 | (37.7696163897252, -122.449508092743) | 15 | 5 | 11 | 29492 | 9 | |||
| 115370 | 10509 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1792 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5997587.0634 | 2108527.2635 | 37.7694750996845 | -122.451684203135 | (37.7694750996845, -122.451684203135) | 15 | 5 | 11 | 29492 | 9 | |||
| 125107 | 105341 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1407 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6000167.325 | 2113807.8025 | 37.7841215482425 | -122.4431385113 | (37.7841215482425, -122.4431385113) | 15 | 6 | 11 | 29490 | 31 | ||||
| 106185 | 105961 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 6005800.4768 | 2111198.1428 | 37.7772756476903 | -122.423464214596 | (37.7772756476903, -122.423464214596) | 7 | 9 | 11 | 28852 | 10 | ||||
| 68680 | 106203 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5x5 | 6003127.4057 | 2113944.8226 | 37.7846661068828 | -122.432907495725 | (37.7846661068828, -122.432907495725) | 13 | 9 | 11 | 29490 | 13 | |||
| 179783 | 106204 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 5x5 | 6003122.9413 | 2113972.2468 | 37.7847411535968 | -122.432924900964 | (37.7847411535968, -122.432924900964) | 13 | 9 | 11 | 29490 | 13 | |||
| 129005 | 106207 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600X Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 5x5 | 6003107.6347 | 2114075.5662 | 37.7850239743837 | -122.43298524084 | (37.7850239743837, -122.43298524084) | 13 | 9 | 11 | 29490 | 13 | |||
| 192358 | 10629 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 817 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003911.8012 | 2110745.3047 | 37.7759254847018 | -122.429965440473 | (37.7759254847018, -122.429965440473) | 7 | 9 | 11 | 29492 | 10 | ||
| 170449 | 10636 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 843 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003811.0913 | 2110732.5317 | 37.7758847092198 | -122.430312910525 | (37.7758847092198, -122.430312910525) | 7 | 9 | 11 | 29492 | 10 | ||
| 155347 | 10637 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 843 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003821.4079 | 2110734.0055 | 37.7758893402664 | -122.430277327931 | (37.7758893402664, -122.430277327931) | 7 | 9 | 11 | 29492 | 10 | ||
| 73394 | 10639 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 877 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003685.3267 | 2110714.3548 | 37.7758276754833 | -122.430746665053 | (37.7758276754833, -122.430746665053) | 7 | 9 | 11 | 29492 | 10 | |||
| 53873 | 106406 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 650 Presidio Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5x6 | 5999248.4097 | 2114351.2177 | 37.7855611862943 | -122.446356721815 | (37.7855611862943, -122.446356721815) | 15 | 6 | 1 | 29490 | 31 | |||
| 154652 | 106407 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 650 Presidio Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5x6 | 5999244.445 | 2114365.5896 | 37.7856004213418 | -122.446371472736 | (37.7856004213418, -122.446371472736) | 15 | 6 | 1 | 29490 | 31 | |||
| 111393 | 106408 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 650 Presidio Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 5x9 | 5999241.4715 | 2114391.8555 | 37.7856723708173 | -122.446383650374 | (37.7856723708173, -122.446383650374) | 15 | 6 | 1 | 29490 | 31 | |||
| 127244 | 107346 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 247 Collins St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5998163.7387 | 2112864.5437 | 37.7814171604492 | -122.450002161775 | (37.7814171604492, -122.450002161775) | 15 | 6 | 2 | 54 | 16 | |||
| 17983 | 107661 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 1312 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5999086.9 | 2105066.2 | 37.7600576690463 | -122.446247345124 | (37.7600576690463, -122.446247345124) | 15 | 5 | 5 | 28862 | 3 | |||
| 29165 | 108003 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 520 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 4x4 | 6005338.5862 | 2110997.1319 | 37.7766976400209 | -122.425047738741 | (37.7766976400209, -122.425047738741) | 7 | 9 | 11 | 28852 | 10 | |||
| 122196 | 108005 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 520 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6005304.2003 | 2110990.4457 | 37.7766773388863 | -122.425166213949 | (37.7766773388863, -122.425166213949) | 7 | 9 | 11 | 28852 | 10 | |||
| 87483 | 108006 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 520 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6005290.3504 | 2110988.0578 | 37.7766699998805 | -122.425213954913 | (37.7766699998805, -122.425213954913) | 7 | 9 | 11 | 28852 | 10 | |||
| 156143 | 108009 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 419X Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6005268.3816 | 2111120.1092 | 37.7770313396992 | -122.425299350558 | (37.7770313396992, -122.425299350558) | 7 | 9 | 11 | 28852 | 10 | ||||
| 174691 | 108010 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 419X Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6005279.8436 | 2111122.0196 | 37.7770372327377 | -122.42525983588 | (37.7770372327377, -122.42525983588) | 7 | 9 | 11 | 28852 | 10 | ||||
| 87360 | 108011 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 419X Ivy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6005290.828 | 2111124.4075 | 37.7770444098803 | -122.42522200735 | (37.7770444098803, -122.42522200735) | 7 | 9 | 11 | 28852 | 10 | ||||
| 186082 | 108616 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 289 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6010459.7673 | 2120958.2392 | 37.8043364033733 | -122.408034626667 | (37.8043364033733, -122.408034626667) | 3 | 1 | 10 | 308 | 23 | |||
| 61814 | 110466 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 3x3 | 6005573.1085 | 2111325.0754 | 37.7776113379896 | -122.424259785517 | (37.7776113379896, -122.424259785517) | 7 | 9 | 11 | 28852 | 10 | ||
| 32066 | 110467 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 3x3 | 6005585.7014 | 2111327.1742 | 37.7776178118347 | -122.424216371681 | (37.7776178118347, -122.424216371681) | 7 | 9 | 11 | 28852 | 10 | ||
| 114167 | 110468 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 3x3 | 6005616.1343 | 2111331.3718 | 37.7776310557335 | -122.42411139247 | (37.7776310557335, -122.42411139247) | 7 | 9 | 11 | 28852 | 10 | ||
| 109156 | 110469 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 3x3 | 6005632.4002 | 2111334.52 | 37.7776406182957 | -122.424055347089 | (37.7776406182957, -122.424055347089) | 7 | 9 | 11 | 28852 | 10 | ||
| 55824 | 110470 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 3x3 | 6005644.9931 | 2111337.1436 | 37.7776485330384 | -122.424011970547 | (37.7776485330384, -122.424011970547) | 7 | 9 | 11 | 28852 | 10 | ||
| 76159 | 110471 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 3x3 | 6005689.0684 | 2111342.3906 | 37.7776654283212 | -122.423859872139 | (37.7776654283212, -122.423859872139) | 7 | 9 | 11 | 28852 | 10 | ||
| 170999 | 110580 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 403 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6001169.4361 | 2110112.2986 | 37.7740317204292 | -122.439406585409 | (37.7740317204292, -122.439406585409) | 15 | 5 | 11 | 29492 | 10 | |||
| 151202 | 110907 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6013321.5581 | 2113739.1188 | 37.7846742173914 | -122.397624454233 | (37.7846742173914, -122.397624454233) | 6 | 2 | 9 | 28856 | 6 | ||||
| 136076 | 110908 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6013338.0101 | 2113761.7403 | 37.7847372468928 | -122.397569122522 | (37.7847372468928, -122.397569122522) | 6 | 2 | 9 | 28856 | 6 | ||||
| 120865 | 110909 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6013356.5185 | 2113781.277 | 37.7847919207208 | -122.397506459776 | (37.7847919207208, -122.397506459776) | 6 | 2 | 9 | 28856 | 6 | ||||
| 98202 | 110911 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6013393.5354 | 2113814.1809 | 37.7848843282601 | -122.397380700853 | (37.7848843282601, -122.397380700853) | 6 | 2 | 9 | 28856 | 6 | ||||
| 137924 | 111431 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500X Presidio Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5999170.7617 | 2114883.4508 | 37.7870181241285 | -122.446663667925 | (37.7870181241285, -122.446663667925) | 15 | 6 | 1 | 29490 | 31 | |||
| 118617 | 111432 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500X Presidio Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5999166.6215 | 2114917.2623 | 37.7871107251509 | -122.446680425702 | (37.7871107251509, -122.446680425702) | 15 | 6 | 1 | 29490 | 31 | |||
| 22348 | 111433 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500X Presidio Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5999168.0016 | 2114897.9415 | 37.7870577541309 | -122.446674260217 | (37.7870577541309, -122.446674260217) | 15 | 6 | 1 | 29490 | 31 | |||
| 158884 | 111730 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2.5x3 | 6005810.6231 | 2111200.9612 | 37.7772839590018 | -122.423429315645 | (37.7772839590018, -122.423429315645) | 7 | 9 | 11 | 28852 | 10 | |||
| 43861 | 111731 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 2.5x3 | 6005824.7151 | 2111202.6522 | 37.7772893974301 | -122.423380687053 | (37.7772893974301, -122.423380687053) | 7 | 9 | 11 | 28852 | 10 | |||
| 128250 | 111732 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2.5x3 | 6005836.5524 | 2111203.7796 | 37.7772931610788 | -122.423339818124 | (37.7772931610788, -122.423339818124) | 7 | 9 | 11 | 28852 | 10 | |||
| 114513 | 111733 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 2.5x3 | 6005854.5902 | 2111208.289 | 37.777306560799 | -122.423277740102 | (37.777306560799, -122.423277740102) | 7 | 9 | 11 | 28852 | 10 | |||
| 3207 | 111734 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2.5x3 | 6005865.3001 | 2111209.4164 | 37.777310260787 | -122.423240771205 | (37.777310260787, -122.423240771205) | 7 | 9 | 11 | 28852 | 10 | |||
| 40947 | 111735 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2.5x3 | 6005874.8827 | 2111210.5438 | 37.7773138971451 | -122.423207702005 | (37.7773138971451, -122.423207702005) | 7 | 9 | 11 | 28852 | 10 | |||
| 167006 | 112132 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 630 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6003600.3374 | 2110567.9569 | 37.7754208875098 | -122.431030213476 | (37.7754208875098, -122.431030213476) | 7 | 9 | 11 | 29492 | 10 | |||
| 168368 | 112635 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1715 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6000531.3846 | 2114698.9549 | 37.7865891741887 | -122.441942983766 | (37.7865891741887, -122.441942983766) | 13 | 6 | 1 | 29490 | 27 | |||
| 132386 | 113054 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 25 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003823 | 2108493 | 37.7697361782825 | -122.430111915017 | (37.7697361782825, -122.430111915017) | 15 | 9 | 5 | 29492 | 10 | ||||
| 5424 | 113149 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6010826.0688 | 2111360.9298 | 37.7780049945656 | -122.406090456701 | (37.7780049945656, -122.406090456701) | 14 | 2 | 9 | 28853 | 34 | |||
| 178572 | 113276 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2129 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6002796.8552 | 2118506.6849 | 37.7971730575287 | -122.434377355222 | (37.7971730575287, -122.434377355222) | 13 | 9 | 1 | 57 | 17 | |||
| 145196 | 113408 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 1450 SANCHEZ ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003890 | 2099760 | 37.7457612277667 | -122.429257354108 | (37.7457612277667, -122.429257354108) | 2 | 7 | 5 | 63 | 22 | ||||
| 45788 | 113409 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 401x DUNCAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003916 | 2099815 | 37.745913716911 | -122.429171370863 | (37.745913716911, -122.429171370863) | 2 | 7 | 5 | 63 | 22 | ||||
| 134819 | 113410 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 401x DUNCAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003916 | 2099815 | 37.745913716911 | -122.429171370863 | (37.745913716911, -122.429171370863) | 2 | 7 | 5 | 63 | 22 | ||||
| 33807 | 113465 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 20 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | |||
| 83117 | 113466 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 147121 | 113467 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 24 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 67077 | 113468 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 06/21/2016 02:14:00 PM | 3 | 6x7 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
| 43317 | 113469 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 26 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 188448 | 113470 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 27 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 4591 | 113471 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 28 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 91889 | 113472 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 29 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 15342 | 113473 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 30 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 65054 | 113474 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 31 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 143625 | 113475 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 32 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 193272 | 113486 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 30 PRESIDIO AVE | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998975 | 2116473 | 37.7913714231174 | -122.447455414162 | (37.7913714231174, -122.447455414162) | 13 | 6 | 1 | 29490 | 31 | ||||
| 190419 | 113773 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1718 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x6 | 6000060.5464 | 2114943.4646 | 37.7872336928249 | -122.443589534945 | (37.7872336928249, -122.443589534945) | 13 | 6 | 1 | 29490 | 27 | |||
| 184520 | 113774 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1716 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 6000066.4859 | 2114892.9793 | 37.7870954120643 | -122.443565357608 | (37.7870954120643, -122.443565357608) | 13 | 6 | 1 | 29490 | 27 | |||
| 124225 | 113988 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2183 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6002243.1253 | 2114325.3833 | 37.7856608347208 | -122.435994046788 | (37.7856608347208, -122.435994046788) | 13 | 6 | 11 | 29490 | 13 | |||
| 138159 | 114879 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1454 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000868 | 2110394 | 37.7747880422892 | -122.440469509771 | (37.7747880422892, -122.440469509771) | 15 | 5 | 11 | 29492 | 10 | ||||
| 158367 | 115983 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011256.8768 | 2118034.0404 | 37.796351862759 | -122.405070122367 | (37.796351862759, -122.405070122367) | 3 | 1 | 10 | 308 | 4 | |||
| 153254 | 115984 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011255.4785 | 2118051.2862 | 37.7963991373929 | -122.405076175742 | (37.7963991373929, -122.405076175742) | 3 | 1 | 10 | 308 | 4 | |||
| 76001 | 115985 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Kearny St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6011253.148 | 2118063.4049 | 37.7964322821358 | -122.405085093558 | (37.7964322821358, -122.405085093558) | 3 | 1 | 10 | 308 | 4 | |||
| 63384 | 117030 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2100 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6002496.7975 | 2114414.081 | 37.7859187837291 | -122.435122761266 | (37.7859187837291, -122.435122761266) | 13 | 6 | 1 | 29490 | 27 | |||
| 54082 | 117031 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2100 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6002487.093 | 2114413.0027 | 37.7859152719288 | -122.435156258966 | (37.7859152719288, -122.435156258966) | 13 | 6 | 1 | 29490 | 27 | |||
| 99244 | 117032 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2100 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6002478.4668 | 2114411.3853 | 37.7859103411195 | -122.435185987474 | (37.7859103411195, -122.435185987474) | 13 | 6 | 1 | 29490 | 27 | |||
| 122627 | 117047 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2183 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6002170.5041 | 2114314.4901 | 37.7856267989414 | -122.436244515027 | (37.7856267989414, -122.436244515027) | 13 | 6 | 11 | 29490 | 13 | |||
| 112471 | 117049 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2183 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6002213.4716 | 2114319.9367 | 37.7856441950939 | -122.436096250016 | (37.7856441950939, -122.436096250016) | 13 | 6 | 11 | 29490 | 13 | |||
| 148694 | 119622 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 77 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6000135.3841 | 2112812.4267 | 37.7813866815394 | -122.44317750199 | (37.7813866815394, -122.44317750199) | 15 | 5 | 1 | 29490 | 16 | ||||
| 27911 | 121250 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 31 Orben Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x3 | Permit Number 778957 | 6003136.4072 | 2115361.6956 | 37.7885569916775 | -122.432977615629 | (37.7885569916775, -122.432977615629) | 13 | 9 | 1 | 29490 | 27 | ||
| 101660 | 121389 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 2646 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 5999473.1272 | 2113649.2828 | 37.7836466874196 | -122.445528775036 | (37.7836466874196, -122.445528775036) | 15 | 6 | 11 | 29490 | 31 | |||
| 157841 | 12247 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 503 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004991.7276 | 2110673.0436 | 37.7757881731565 | -122.426224546997 | (37.7757881731565, -122.426224546997) | 7 | 9 | 11 | 28852 | 10 | |||
| 43620 | 12248 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 511 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004985.728 | 2110723.6115 | 37.7759266811529 | -122.426248902156 | (37.7759266811529, -122.426248902156) | 7 | 9 | 11 | 28852 | 10 | |||
| 3486 | 12249 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 511 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004989.1563 | 2110705.1842 | 37.7758762780635 | -122.426235730542 | (37.7758762780635, -122.426235730542) | 7 | 9 | 11 | 28852 | 10 | |||
| 108929 | 12264 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 640 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004966.4829 | 2111191.3303 | 37.7772098348265 | -122.426348784703 | (37.7772098348265, -122.426348784703) | 7 | 9 | 11 | 28852 | 10 | |||
| 119689 | 12265 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 646 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004962.1321 | 2111217.4355 | 37.7772812673791 | -122.426365694654 | (37.7772812673791, -122.426365694654) | 7 | 9 | 11 | 28852 | 10 | |||
| 75673 | 12271 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004951.5507 | 2111300.9055 | 37.7775098574182 | -122.426408243779 | (37.7775098574182, -122.426408243779) | 7 | 9 | 11 | 28852 | 10 | |||
| 191640 | 12985 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 306 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 3X3 | 6010818.9339 | 2120706.9936 | 37.8036666476299 | -122.406773977327 | (37.8036666476299, -122.406773977327) | 3 | 1 | 10 | 308 | 23 | |||
| 66267 | 12998 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 348 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 6010660.6396 | 2120687.9769 | 37.8036055743317 | -122.407320424126 | (37.8036055743317, -122.407320424126) | 3 | 1 | 10 | 308 | 23 | |||
| 67375 | 13020 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 423 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3X3 | 6010295.8571 | 2120595.8738 | 37.8033322591341 | -122.40857627636 | (37.8033322591341, -122.40857627636) | 3 | 1 | 10 | 308 | 23 | |||
| 122435 | 13021 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 423 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6010315.0722 | 2120598.0088 | 37.803339197434 | -122.408509932207 | (37.803339197434, -122.408509932207) | 3 | 1 | 10 | 308 | 23 | |||
| 184369 | 13052 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 557 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6009686.1191 | 2120512.8313 | 37.8030700779734 | -122.410680437216 | (37.8030700779734, -122.410680437216) | 3 | 1 | 10 | 308 | 23 | |||
| 125638 | 13093 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1450 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6005391.575 | 2119956.3245 | 37.8013003370098 | -122.42550219218 | (37.8013003370098, -122.42550219218) | 13 | 9 | 1 | 57 | 17 | |||
| 44629 | 13097 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1475 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005336.846 | 2119866.4127 | 37.8010503698402 | -122.42568517574 | (37.8010503698402, -122.42568517574) | 13 | 9 | 1 | 57 | 17 | |||
| 105917 | 13104 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1530 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 90 | 3X3 | 6005037.4004 | 2119906.2866 | 37.8011429280885 | -122.426724227861 | (37.8011429280885, -122.426724227861) | 13 | 9 | 1 | 57 | 17 | ||
| 85810 | 13105 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1530 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 90 | 3X3 | 6004999.0901 | 2119899.25 | 37.8011214413621 | -122.426856296775 | (37.8011214413621, -122.426856296775) | 13 | 9 | 1 | 57 | 17 | ||
| 153768 | 13109 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1599 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1994 12:00:00 AM | 24 | 3x3 | 6004827.8666 | 2119796.0468 | 37.8008283892799 | -122.427441448129 | (37.8008283892799, -122.427441448129) | 13 | 9 | 1 | 57 | 17 | ||
| 131660 | 13110 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1599 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1994 12:00:00 AM | 16 | 3x3 | 6004846.6308 | 2119801.5197 | 37.800844477708 | -122.427376906198 | (37.800844477708, -122.427376906198) | 13 | 9 | 1 | 57 | 17 | ||
| 151675 | 13111 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1599 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/1994 12:00:00 AM | 24 | 3X3 | 6004886.5048 | 2119803.0834 | 37.8008510262732 | -122.4272390368 | (37.8008510262732, -122.4272390368) | 13 | 9 | 1 | 57 | 17 |
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) );