trees
1,381 rows where qSpecies_id = 54
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35064 | 138707 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2874 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999741.1485 | 2114383.1871 | 37.7856770956012 | -122.444654293951 | (37.7856770956012, -122.444654293951) | 15 | 6 | 1 | 29490 | 31 | |||
| 35150 | 138369 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 0ft | 6002665.8461 | 2114439.4026 | 37.7859979081747 | -122.434539711553 | (37.7859979081747, -122.434539711553) | 13 | 9 | 11 | 29490 | 27 | |||
| 35369 | 140725 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002187.9434 | 2110254.4569 | 37.7744799618741 | -122.435893573485 | (37.7744799618741, -122.435893573485) | 15 | 5 | 11 | 29492 | 10 | |||
| 35755 | 246093 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 Stanyan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5997094.8545 | 2108310.1536 | 37.7688507707463 | -122.453371047271 | (37.7688507707463, -122.453371047271) | 15 | 5 | 11 | 29492 | 9 | |||
| 36126 | 63909 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2119 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/1987 12:00:00 AM | 12 | Permit Number 24624 | 6009399.6734 | 2120957.786 | 37.8042757485475 | -122.411703151333 | (37.8042757485475, -122.411703151333) | 3 | 1 | 10 | 308 | 23 | ||
| 36350 | 137858 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 22 Orben Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003153.1523 | 2115433.6928 | 37.7887556274538 | -122.43292482586 | (37.7887556274538, -122.43292482586) | 13 | 9 | 1 | 29490 | 27 | |||
| 36660 | 138731 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2755 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000355.1143 | 2114408.2991 | 37.7857810625069 | -122.44253195817 | (37.7857810625069, -122.44253195817) | 15 | 6 | 1 | 29490 | 27 | |||
| 36701 | 59351 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 503 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52085 | 6000121.1922 | 2110676.4601 | 37.7755210539143 | -122.443073153769 | (37.7755210539143, -122.443073153769) | 15 | 5 | 11 | 29492 | 16 | |
| 36792 | 244324 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 717 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003593.9138 | 2110004.6215 | 37.7738737432923 | -122.431012219304 | (37.7738737432923, -122.431012219304) | 15 | 9 | 11 | 29492 | 10 | |||
| 36803 | 143527 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1979 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003537.8633 | 2118608.4193 | 37.7974944269949 | -122.431820551935 | (37.7974944269949, -122.431820551935) | 13 | 9 | 1 | 57 | 17 | |||
| 37007 | 13191 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2095 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002470.5921 | 2119469.4635 | 37.7997980716779 | -122.435575217756 | (37.7997980716779, -122.435575217756) | 13 | 9 | 1 | 57 | 17 | |||
| 37114 | 13143 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1800 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6003680.9036 | 2119717.0807 | 37.8005466318744 | -122.431404778789 | (37.8005466318744, -122.431404778789) | 13 | 9 | 1 | 57 | 17 | |||
| 37283 | 201180 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 608 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6013469.6258 | 2113973.5593 | 37.785326180656 | -122.397128630227 | (37.785326180656, -122.397128630227) | 6 | 2 | 9 | 28855 | 6 | |||
| 37528 | 13212 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2190 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 6001925.0681 | 2119471.9545 | 37.7997739121356 | -122.437463108341 | (37.7997739121356, -122.437463108341) | 13 | 9 | 1 | 57 | 17 | |||
| 37790 | 142634 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 241 BAY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6009751.1154 | 2121551.1896 | 37.8059247953292 | -122.410528881628 | (37.8059247953292, -122.410528881628) | 3 | 1 | 10 | 308 | 23 | |||
| 37814 | 13181 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2001 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002704.7439 | 2119503.7145 | 37.7999054122901 | -122.434767417241 | (37.7999054122901, -122.434767417241) | 13 | 9 | 1 | 57 | 17 | |||
| 37866 | 67753 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1992 12:00:00 AM | 11 | 3x3 | Permit Number 31377 | 6011258.7412 | 2118020.5233 | 37.79631485229 | -122.405062718866 | (37.79631485229, -122.405062718866) | 3 | 1 | 10 | 308 | 4 | |
| 37910 | 244243 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 150 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005806.4217 | 2110019.2116 | 37.7740389237303 | -122.423359820085 | (37.7740389237303, -122.423359820085) | 7 | 9 | 11 | 28852 | 10 | |||
| 38110 | 138007 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1803 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003877.7864 | 2114559.3667 | 37.7863960226531 | -122.430355290708 | (37.7863960226531, -122.430355290708) | 13 | 9 | 11 | 29490 | 13 | |||
| 38247 | 21606 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1525 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005078.2447 | 2114724.3621 | 37.7869169843519 | -122.426213757225 | (37.7869169843519, -122.426213757225) | 13 | 9 | 11 | 28858 | 13 | |||
| 38278 | 32778 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 555 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 2 | Permit Number 37147 | 6001101.7087 | 2110645.4763 | 37.7754918376538 | -122.439679097651 | (37.7754918376538, -122.439679097651) | 15 | 5 | 11 | 29492 | 10 | |
| 38313 | 31337 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 745 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1995 12:00:00 AM | 16 | 6x18 | Permit Number 34951 | 6004453.62375 | 2111092.99154 | 37.7769108173179 | -122.428115918737 | (37.7769108173179, -122.428115918737) | 7 | 9 | 11 | 28852 | 10 | |
| 38348 | 142947 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 21 Bellair Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010050.2611 | 2121139.8618 | 37.8048121576562 | -122.40946458873 | (37.8048121576562, -122.40946458873) | 3 | 1 | 10 | 308 | 23 | |||
| 38413 | 4600 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 256 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6010961.6739 | 2118493.2807 | 37.7975963184564 | -122.406123962239 | (37.7975963184564, -122.406123962239) | 3 | 1 | 10 | 308 | 23 | |||
| 38615 | 98470 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6011914.0134 | 2107036.3406 | 37.7661914486194 | -122.402022750022 | (37.7661914486194, -122.402022750022) | 8 | 3 | 8 | 28853 | 20 | |||
| 38809 | 140069 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 582 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6005006.5887 | 2111294.3898 | 37.7774950779447 | -122.426217384893 | (37.7774950779447, -122.426217384893) | 7 | 9 | 11 | 28852 | 10 | |||
| 38889 | 246039 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1378 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5999138.4966 | 2108392.6745 | 37.7691942805388 | -122.446308196721 | (37.7691942805388, -122.446308196721) | 15 | 5 | 11 | 29492 | 9 | |||
| 38929 | 138927 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 901 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003523.5494 | 2110764.9413 | 37.7759574066142 | -122.431309905462 | (37.7759574066142, -122.431309905462) | 15 | 9 | 11 | 29492 | 10 | |||
| 39112 | 14585 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1206 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5999464.9463 | 2108691.264 | 37.7700327707282 | -122.44520049918 | (37.7700327707282, -122.44520049918) | 15 | 5 | 11 | 29492 | 9 | |||
| 39177 | 141081 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 190 Commonwealth Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996587.7084 | 2113030.7088 | 37.7817830987642 | -122.455466443539 | (37.7817830987642, -122.455466443539) | 11 | 6 | 1 | 54 | 31 | |||
| 39578 | 140070 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 601X Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005402 | 2111410 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | 7 | 9 | 11 | 28852 | 10 | |||
| 39581 | 142525 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 301 FRANCISCO ST | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 23 | Width 0ft | 6009759.5801 | 2121214.59 | 37.8050010513122 | -122.410475804946 | (37.8050010513122, -122.410475804946) | 3 | 1 | 10 | 308 | 23 | |||
| 39594 | 245462 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2886 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6007544.8329 | 2106792.8686 | 37.7652781065022 | -122.41711768386 | (37.7652781065022, -122.41711768386) | 8 | 4 | 7 | 28853 | 19 | |||
| 39600 | 143497 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 867 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6011217.2579 | 2117938.9551 | 37.7960885666374 | -122.40520051379 | (37.7960885666374, -122.40520051379) | 3 | 1 | 10 | 28857 | 4 | |||
| 39698 | 17058 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1285 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000917.1059 | 2109633.5588 | 37.7727028580257 | -122.440245097963 | (37.7727028580257, -122.440245097963) | 15 | 5 | 11 | 29492 | 9 | |||
| 39745 | 142504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 610 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/29/1999 12:00:00 AM | 12 | Width 0ft | 6010596.4955 | 2118942.3174 | 37.7988088315184 | -122.407419256939 | (37.7988088315184, -122.407419256939) | 3 | 1 | 10 | 308 | 23 | ||
| 40612 | 6232 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1220 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6005007.0756 | 2113377.0261 | 37.7832135118405 | -122.426364020332 | (37.7832135118405, -122.426364020332) | 7 | 9 | 11 | 28858 | 41 | ||
| 40681 | 140585 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 949 FILLMORE ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6003432.0437 | 2111445.4153 | 37.7778206333488 | -122.431675041477 | (37.7778206333488, -122.431675041477) | 15 | 9 | 11 | 29492 | 41 | |||
| 40786 | 143180 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 37 MIDWAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010061.0151 | 2121485.1789 | 37.8057609150954 | -122.409451758875 | (37.8057609150954, -122.409451758875) | 3 | 1 | 10 | 308 | 23 | |||
| 40875 | 138980 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 712 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003074.6186 | 2110844.4251 | 37.7761501973749 | -122.432868552462 | (37.7761501973749, -122.432868552462) | 15 | 9 | 11 | 29492 | 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 | |||
| 41042 | 143548 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2237 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002268.9185 | 2118432.4796 | 37.7969393283412 | -122.4361988317 | (37.7969393283412, -122.4361988317) | 13 | 9 | 1 | 57 | 17 | |||
| 41460 | 248350 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1587 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997973.5131 | 2108185.8423 | 37.7685597685915 | -122.450322880989 | (37.7685597685915, -122.450322880989) | 15 | 5 | 11 | 29492 | 9 | |||
| 41482 | 142934 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1201 KEARNY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6011088.1877 | 2119032.3 | 37.7990834099948 | -122.405724174807 | (37.7990834099948, -122.405724174807) | 3 | 1 | 10 | 308 | 23 | |||
| 41596 | 141533 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2901 TURK BLVD | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996746.9 | 2111493.597 | 37.7775717277647 | -122.454804626881 | (37.7775717277647, -122.454804626881) | 15 | 6 | 2 | 54 | 16 | |||
| 41625 | 142631 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 241 BAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009683.097 | 2121540.8838 | 37.8058926846956 | -122.410763542627 | (37.8058926846956, -122.410763542627) | 3 | 1 | 10 | 308 | 23 | |||
| 41667 | 56934 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1923 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 16 | 3x3 | Permit Number 14180 | 6001934.7565 | 2115177.2253 | 37.7879822517226 | -122.437121923696 | (37.7879822517226, -122.437121923696) | 13 | 6 | 1 | 29490 | 27 | |
| 41692 | 138365 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6002748.6045 | 2114451.296 | 37.7860352620012 | -122.434254240878 | (37.7860352620012, -122.434254240878) | 13 | 9 | 11 | 29490 | 27 | |||
| 41771 | 143014 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 488 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010067.5326 | 2120604.4864 | 37.8033431173057 | -122.409367013095 | (37.8033431173057, -122.409367013095) | 3 | 1 | 10 | 308 | 23 | |||
| 41892 | 138372 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1801 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002563.7609 | 2114481.5252 | 37.7861077705586 | -122.434895911649 | (37.7861077705586, -122.434895911649) | 13 | 9 | 11 | 29490 | 27 | |||
| 41921 | 141342 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 454 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001185.8232 | 2110322.8485 | 37.7746107701242 | -122.439364995038 | (37.7746107701242, -122.439364995038) | 15 | 5 | 11 | 29492 | 10 | |||
| 42028 | 97242 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1300X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6016235.0824 | 2094868.9009 | 37.7330224130953 | -122.386228519291 | (37.7330224130953, -122.386228519291) | 10 | 3 | 8 | 58 | 1 | |||
| 42047 | 97114 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1345 Noriega St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 18860 | 5989801.9904 | 2103085.8445 | 37.7540855022306 | -122.478214246151 | (37.7540855022306, -122.478214246151) | 1 | 8 | 3 | 56 | 35 | |||
| 42174 | 15298 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1640 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 6006986.0945 | 2109290.5977 | 37.7721048323796 | -122.419227425547 | (37.7721048323796, -122.419227425547) | 8 | 2 | 9 | 28853 | 19 | ||||
| 42302 | 16867 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 235 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6005854.7098 | 2110323.2964 | 37.7748765923478 | -122.423214402753 | (37.7748765923478, -122.423214402753) | 7 | 9 | 11 | 28852 | 10 | |||
| 42465 | 142940 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 318 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6010703.4174 | 2118721.6624 | 37.7982089506036 | -122.407033709348 | (37.7982089506036, -122.407033709348) | 3 | 1 | 10 | 308 | 23 | |||
| 42630 | 199741 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2399 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014513.885 | 2092478.0086 | 37.7263620876399 | -122.392012061617 | (37.7263620876399, -122.392012061617) | 10 | 3 | 8 | 58 | 1 | |||
| 42890 | 142518 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 420 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6010399.3582 | 2119003.2321 | 37.7989650524767 | -122.408105717547 | (37.7989650524767, -122.408105717547) | 3 | 1 | 10 | 308 | 23 | |||
| 43116 | 18005 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2683 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001144.5248 | 2114870.2639 | 37.7870944645688 | -122.439833960351 | (37.7870944645688, -122.439833960351) | 13 | 6 | 1 | 29490 | 27 | |||
| 43162 | 138126 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1850 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6003024.8426 | 2114663.3242 | 37.7866331126192 | -122.433313688795 | (37.7866331126192, -122.433313688795) | 13 | 9 | 11 | 29490 | 27 | |||
| 43203 | 30704 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 369 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 12 | Permit Number 34615 | 6005232.8948 | 2110236.794 | 37.7746039663436 | -122.42535923638 | (37.7746039663436, -122.42535923638) | 7 | 9 | 11 | 28852 | 10 | |
| 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 | ||||
| 43362 | 13125 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1688 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 25 | 3X3 | 6004309.8631 | 2119808.6849 | 37.8008337792511 | -122.429234859067 | (37.8008337792511, -122.429234859067) | 13 | 9 | 1 | 57 | 17 | ||
| 43602 | 140542 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1025 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003382.3327 | 2111808.7639 | 37.7788154803812 | -122.431872959815 | (37.7788154803812, -122.431872959815) | 15 | 9 | 11 | 29490 | 41 | |||
| 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 | |||
| 43753 | 140708 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6002652.7615 | 2110375.0497 | 37.7748374734767 | -122.434294303619 | (37.7748374734767, -122.434294303619) | 15 | 5 | 11 | 29492 | 10 | |||
| 43809 | 141086 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3370 GEARY BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5996653.0238 | 2112962.686 | 37.7816000737762 | -122.45523556685 | (37.7816000737762, -122.45523556685) | 11 | 6 | 1 | 54 | 31 | |||
| 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 | |||
| 43953 | 138715 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2900 BUSH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999573.0166 | 2114358.1558 | 37.7855987705543 | -122.445234179741 | (37.7855987705543, -122.445234179741) | 15 | 6 | 1 | 29490 | 31 | |||
| 44260 | 199854 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2505 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014200.0457 | 2092143.0549 | 37.7254249428706 | -122.393073571548 | (37.7254249428706, -122.393073571548) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 44783 | 142491 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 651 COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6009641.4463 | 2119604.1083 | 37.8005724449635 | -122.410770813978 | (37.8005724449635, -122.410770813978) | 3 | 1 | 10 | 308 | 4 | |||
| 44948 | 143136 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2679 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5999509.2265 | 2119087.2107 | 37.7985798662052 | -122.445795098614 | (37.7985798662052, -122.445795098614) | 13 | 9 | 1 | 57 | 17 | |||
| 45008 | 246387 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1356 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5999191.1888 | 2108399.0339 | 37.7692147510646 | -122.446126395439 | (37.7692147510646, -122.446126395439) | 15 | 5 | 11 | 29492 | 9 | |||
| 45097 | 138716 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1609 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999594.5745 | 2114418.8648 | 37.7857666921726 | -122.445163962127 | (37.7857666921726, -122.445163962127) | 15 | 6 | 1 | 29490 | 31 | |||
| 45477 | 138501 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1799 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002528.8099 | 2114345.6813 | 37.7857327932764 | -122.435007113669 | (37.7857327932764, -122.435007113669) | 13 | 9 | 11 | 29490 | 13 | |||
| 45570 | 142505 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 620 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2014 12:00:00 AM | 22 | Width 0ft | Permit Number 774306 | 6010566.6807 | 2118940.2612 | 37.7988015168915 | -122.407522281284 | (37.7988015168915, -122.407522281284) | 3 | 1 | 10 | 308 | 23 | |
| 45674 | 9652 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 75 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 3 | 2x3 | 6006083.2108 | 2109791.7339 | 37.7734299424642 | -122.42238619159 | (37.7734299424642, -122.42238619159) | 7 | 9 | 11 | 28852 | 10 | ||
| 45707 | 142945 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 152 PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010109.3364 | 2121119.0539 | 37.8047583341863 | -122.409258682298 | (37.8047583341863, -122.409258682298) | 3 | 1 | 10 | 308 | 23 | |||
| 45716 | 97934 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2133 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6009804.1904 | 2121525.9403 | 37.8058584423979 | -122.410343422594 | (37.8058584423979, -122.410343422594) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | ||||
| 45831 | 140535 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1099 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003363.1308 | 2111944.3591 | 37.7791867024877 | -122.4319490716 | (37.7791867024877, -122.4319490716) | 15 | 9 | 11 | 29490 | 41 | |||
| 46162 | 183273 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1251 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5983646.3542 | 2106625.2038 | 37.7634443416971 | -122.499763175358 | (37.7634443416971, -122.499763175358) | 1 | 8 | 3 | 56 | 35 | |||
| 46211 | 13183 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2001 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 12 | 3x3 | 6002759.5454 | 2119509.3192 | 37.7999239124366 | -122.434578184633 | (37.7999239124366, -122.434578184633) | 13 | 9 | 1 | 57 | 17 | ||
| 46246 | 143537 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2125 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002811.2386 | 2118507.9925 | 37.7971774642757 | -122.434327678668 | (37.7971774642757, -122.434327678668) | 13 | 9 | 1 | 57 | 17 | |||
| 46548 | 87369 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 926 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2008 12:00:00 AM | 10 | 3x3 | Permit Number 50349 | 5990243.3148 | 2099080.9621 | 37.7431147521003 | -122.476395524083 | (37.7431147521003, -122.476395524083) | 1 | 8 | 3 | 29491 | 35 | |
| 46642 | 142949 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 20 BELLAIR PL | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010058.1538 | 2121167.8448 | 37.8048894342531 | -122.40943925119 | (37.8048894342531, -122.40943925119) | 3 | 1 | 10 | 308 | 23 | |||
| 46647 | 494 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6010448.7752 | 2102218.4922 | 37.7528808308555 | -122.406751179708 | (37.7528808308555, -122.406751179708) | 10 | 4 | 7 | 28859 | 19 | |||
| 46663 | 246098 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5997112.7214 | 2108174.1833 | 37.7684784553517 | -122.453299429572 | (37.7684784553517, -122.453299429572) | 15 | 5 | 11 | 29492 | 9 | |||
| 46681 | 15435 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2141 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006881.4762 | 2105834.0306 | 37.7626080219354 | -122.419344056803 | (37.7626080219354, -122.419344056803) | 8 | 4 | 7 | 28859 | 19 | |||
| 46831 | 140683 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 21288 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5997608.0859 | 2110262.8359 | 37.7742417384078 | -122.451736704617 | (37.7742417384078, -122.451736704617) | 15 | 5 | 2 | 29492 | 16 | |||
| 46849 | 99233 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008063.2168 | 2121048.832 | 37.8044506767497 | -122.416334531861 | (37.8044506767497, -122.416334531861) | 5 | 1 | 10 | 308 | 32 | |||
| 47044 | 246126 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1546 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998264.229 | 2108270.3316 | 37.7688083880526 | -122.449323411621 | (37.7688083880526, -122.449323411621) | 15 | 5 | 11 | 29492 | 9 | |||
| 47249 | 13281 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2524 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 40 | 3x3 | 6000224.9781 | 2119238.0771 | 37.7990349463185 | -122.443329222732 | (37.7990349463185, -122.443329222732) | 13 | 9 | 1 | 57 | 17 | ||
| 47439 | 137799 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1900 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004356.41 | 2115593.3639 | 37.789262218427 | -122.42877311351 | (37.789262218427, -122.42877311351) | 13 | 9 | 11 | 28858 | 27 | |||
| 47497 | 142605 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 CHESTNUT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6008282.9909 | 2120710.7963 | 37.8035348717489 | -122.415550034395 | (37.8035348717489, -122.415550034395) | 5 | 1 | 10 | 308 | 32 | |||
| 47498 | 143390 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1806 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004317.0708 | 2118762.9621 | 37.7979629017809 | -122.429135313255 | (37.7979629017809, -122.429135313255) | 13 | 9 | 1 | 57 | 17 | |||
| 47554 | 25267 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1738 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 5994656.4814 | 2092369.8948 | 37.7249427634406 | -122.460649859339 | (37.7249427634406, -122.460649859339) | 9 | 8 | 4 | 28861 | 40 | |||
| 47862 | 17675 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1010 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002421.1673 | 2112056.7065 | 37.7794417346192 | -122.435215744209 | (37.7794417346192, -122.435215744209) | 15 | 5 | 11 | 29490 | 41 | |||
| 48097 | 15626 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3550 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005569.6902 | 2097797.6263 | 37.7404679423018 | -122.423309747569 | (37.7404679423018, -122.423309747569) | 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) );