trees
1,381 rows where qSpecies_id = 54 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 60700 | 244192 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 529 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998441.2408 | 2108808.2865 | 37.7702955988047 | -122.448749895574 | (37.7702955988047, -122.448749895574) | 15 | 5 | 11 | 29492 | 9 | |||
| 60753 | 58122 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 24 Orben Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1978 12:00:00 AM | 13 | Permit Number 17103 | 6003170.2635 | 2115307.1662 | 37.7884091881086 | -122.432856580985 | (37.7884091881086, -122.432856580985) | 13 | 9 | 1 | 29490 | 27 | ||
| 61039 | 137688 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1836 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6000295.9538 | 2111331.2873 | 37.7773290058158 | -122.442515637928 | (37.7773290058158, -122.442515637928) | 15 | 5 | 11 | 29490 | 16 | |||
| 61537 | 487 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2718 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010403.4669 | 2102258.6388 | 37.7529885293488 | -122.406910694342 | (37.7529885293488, -122.406910694342) | 10 | 4 | 7 | 28859 | 19 | |||
| 61568 | 138417 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2158 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6002253.1064 | 2114381.7326 | 37.7858161225558 | -122.435963548588 | (37.7858161225558, -122.435963548588) | 13 | 6 | 1 | 29490 | 27 | |||
| 61639 | 498 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2752 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010250.9097 | 2102250.6095 | 37.7529579449469 | -122.40743770282 | (37.7529579449469, -122.40743770282) | 2 | 4 | 7 | 28859 | 19 | |||
| 61706 | 138607 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 512 PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999174.9019 | 2114851.0194 | 37.7869293124952 | -122.446647009525 | (37.7869293124952, -122.446647009525) | 15 | 6 | 1 | 29490 | 31 | |||
| 62544 | 248469 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 145 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998248.1791 | 2107933.2828 | 37.7678820197346 | -122.449354639507 | (37.7678820197346, -122.449354639507) | 15 | 5 | 11 | 29492 | 9 | |||
| 62701 | 137986 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1826 WEBSTER ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 6003453.629 | 2115096.2902 | 37.7878462437049 | -122.431861119013 | (37.7878462437049, -122.431861119013) | 13 | 9 | 11 | 29490 | 27 | |||
| 63070 | 92953 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1338 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6006789.4485 | 2115574.9476 | 37.7893490550841 | -122.420353767408 | (37.7893490550841, -122.420353767408) | 13 | 9 | 10 | 28858 | 21 | ||||
| 63273 | 16989 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 880 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002806.5013 | 2109946.7063 | 37.7736700736517 | -122.433731865097 | (37.7736700736517, -122.433731865097) | 15 | 5 | 11 | 29492 | 10 | |||
| 63571 | 4684 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 722 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6009311.9987 | 2119994.7358 | 37.8016265338502 | -122.411938460907 | (37.8016265338502, -122.411938460907) | 3 | 1 | 10 | 308 | 23 | |||
| 63639 | 17679 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1004 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002429.082 | 2112004.3581 | 37.7792984485069 | -122.435184618671 | (37.7792984485069, -122.435184618671) | 15 | 5 | 11 | 29490 | 41 | |||
| 63983 | 62369 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 137 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/1985 12:00:00 AM | 9 | 3x3 | Permit Number 22515 | 5998258.1694 | 2110129.1192 | 37.7739117964536 | -122.449478321628 | (37.7739117964536, -122.449478321628) | 15 | 5 | 11 | 29492 | 16 | |
| 64439 | 15768 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 4770 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/29/2007 12:00:00 AM | 15 | 3x3 | 6001444.506 | 2091085.1877 | 37.7218034493139 | -122.437092531149 | (37.7218034493139, -122.437092531149) | 9 | 7 | 6 | 28861 | 25 | ||
| 64717 | 16976 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 811 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6003075.3996 | 2109932.9295 | 37.7736475004085 | -122.432800720802 | (37.7736475004085, -122.432800720802) | 15 | 5 | 11 | 29492 | 9 | |||
| 65242 | 56926 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 419 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 13 | Permit Number 14169 | 6001161.4908 | 2110173.8745 | 37.7742003402164 | -122.439438484322 | (37.7742003402164, -122.439438484322) | 15 | 5 | 11 | 29492 | 10 | ||
| 65301 | 9636 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1460 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002640.9745 | 2112004.0216 | 37.7793095547354 | -122.434451571103 | (37.7793095547354, -122.434451571103) | 15 | 5 | 11 | 29490 | 41 | |||
| 65586 | 59151 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 112 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/1980 12:00:00 AM | 13 | Permit Number 18460 | 6010290.1497 | 2121142.971 | 37.8048341329685 | -122.408634644798 | (37.8048341329685, -122.408634644798) | 3 | 1 | 10 | 308 | 23 | ||
| 66122 | 142987 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1871 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010368.8695 | 2120931.1728 | 37.8042569960583 | -122.408347277199 | (37.8042569960583, -122.408347277199) | 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 | |||
| 66541 | 6994 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 870 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003272.598 | 2110360.763 | 37.7748334078832 | -122.432149140862 | (37.7748334078832, -122.432149140862) | 15 | 9 | 11 | 29492 | 10 | |||
| 66733 | 140608 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 840 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6003502.6081 | 2111278.9255 | 37.7773674931794 | -122.431419046703 | (37.7773674931794, -122.431419046703) | 7 | 9 | 11 | 29492 | 10 | |||
| 66771 | 17128 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1999 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2003 12:00:00 AM | 12 | 3X3 | 5997486.4463 | 2109152.9695 | 37.7711873646815 | -122.452077382727 | (37.7711873646815, -122.452077382727) | 15 | 5 | 11 | 29492 | 9 | ||
| 67040 | 142933 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 502 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6011075.0739 | 2119008.1155 | 37.7990162718949 | -122.405767848781 | (37.7990162718949, -122.405767848781) | 3 | 1 | 10 | 308 | 23 | |||
| 67143 | 7179 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 833 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003463.175 | 2111217.4725 | 37.7771965235218 | -122.431551070298 | (37.7771965235218, -122.431551070298) | 15 | 9 | 11 | 29492 | 10 | |||
| 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 | |||
| 67787 | 143524 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2240 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002241.7862 | 2118472.6878 | 37.7970481880141 | -122.436295594804 | (37.7970481880141, -122.436295594804) | 13 | 9 | 1 | 57 | 17 | |||
| 67847 | 143515 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2072 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003081.9082 | 2118594.9468 | 37.7974315778327 | -122.433397312199 | (37.7974315778327, -122.433397312199) | 13 | 9 | 1 | 57 | 17 | |||
| 67867 | 513 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2792 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010090.1844 | 2102241.1856 | 37.7529230716135 | -122.407992859485 | (37.7529230716135, -122.407992859485) | 2 | 4 | 7 | 28859 | 19 | |||
| 67896 | 59593 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1528 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1981 12:00:00 AM | 15 | Permit Number 18990 | 6000159.8025 | 2114219.1556 | 37.7852505885272 | -122.443194090382 | (37.7852505885272, -122.443194090382) | 15 | 6 | 1 | 29490 | 27 | ||
| 67956 | 9638 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1470 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6002570.9212 | 2111995.2227 | 37.7792814183991 | -122.434693285009 | (37.7792814183991, -122.434693285009) | 15 | 5 | 11 | 29490 | 41 | |||
| 68312 | 138537 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1700 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003095.1947 | 2114174.7238 | 37.7852955304758 | -122.433035366169 | (37.7852955304758, -122.433035366169) | 13 | 9 | 11 | 29490 | 13 | |||
| 68359 | 21709 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1900 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x9 | 6003440.4648 | 2114551.568 | 37.7863498280943 | -122.431867754773 | (37.7863498280943, -122.431867754773) | 13 | 9 | 11 | 29490 | 27 | |||
| 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 | |||
| 69199 | 141383 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6001170.9258 | 2110090.9457 | 37.7739731755059 | -122.439399901379 | (37.7739731755059, -122.439399901379) | 15 | 5 | 11 | 29492 | 10 | |||
| 71079 | 17113 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1875 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 5998056.3964 | 2109231.5833 | 37.7714358490518 | -122.450111579711 | (37.7714358490518, -122.450111579711) | 15 | 5 | 11 | 29492 | 9 | |||
| 71148 | 137659 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1334 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002765.4317 | 2111672.0138 | 37.7784050083088 | -122.433997283271 | (37.7784050083088, -122.433997283271) | 15 | 5 | 11 | 29490 | 41 | |||
| 71569 | 181891 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2362 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5985808.0433 | 2099163.7908 | 37.7430839555722 | -122.491737385137 | (37.7430839555722, -122.491737385137) | 1 | 8 | 3 | 29491 | 35 | |||
| 71607 | 61078 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2590 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1983 12:00:00 AM | 13 | Permit Number 20915 | 5999806.8161 | 2113697.9026 | 37.7837992291467 | -122.444377837774 | (37.7837992291467, -122.444377837774) | 15 | 6 | 11 | 29490 | 31 | ||
| 71673 | 248411 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1737 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5997411.4623 | 2108107.5609 | 37.7683126457867 | -122.452261308397 | (37.7683126457867, -122.452261308397) | 15 | 5 | 11 | 29492 | 9 | |||
| 71734 | 18009 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2704 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6000887.4934 | 2114883.9407 | 37.7871173834408 | -122.440724211427 | (37.7871173834408, -122.440724211427) | 13 | 6 | 1 | 29490 | 27 | |||
| 72010 | 56572 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 238 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6010130.9034 | 2121308.9776 | 37.805281025756 | -122.409197457422 | (37.805281025756, -122.409197457422) | 3 | 1 | 10 | 308 | 23 | ||||
| 72034 | 92952 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1334 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6006791.0528 | 2115558.9055 | 37.789305097845 | -122.420347077615 | (37.789305097845, -122.420347077615) | 13 | 9 | 10 | 28858 | 21 | ||||
| 72300 | 251046 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 5625 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5989523.2215 | 2112593.8297 | 37.7801756529596 | -122.479874006145 | (37.7801756529596, -122.479874006145) | 11 | 6 | 2 | 55 | 26 | |||
| 72679 | 246053 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1456 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5998746.9386 | 2108335.7426 | 37.7690155895077 | -122.447658470154 | (37.7690155895077, -122.447658470154) | 15 | 5 | 11 | 29492 | 9 | |||
| 72884 | 8204 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1369 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001211.3032 | 2111062.2036 | 37.7766423030153 | -122.439329862063 | (37.7766423030153, -122.439329862063) | 15 | 5 | 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 | |||
| 73860 | 137987 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1815 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004374.8136 | 2115107.5838 | 37.7879294301748 | -122.428674796307 | (37.7879294301748, -122.428674796307) | 13 | 9 | 11 | 29490 | 27 | |||
| 73929 | 246153 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1720 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5997461.1263 | 2108156.7707 | 37.7684506082583 | -122.452093077181 | (37.7684506082583, -122.452093077181) | 15 | 5 | 11 | 29492 | 9 | |||
| 74356 | 143530 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2198 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6002524.2241 | 2118512.569 | 37.797173734939 | -122.435321146522 | (37.797173734939, -122.435321146522) | 13 | 9 | 1 | 57 | 17 | |||
| 74359 | 140630 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 808 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6003528.2379 | 2111115.3472 | 37.7769198002338 | -122.431318705355 | (37.7769198002338, -122.431318705355) | 7 | 9 | 11 | 29492 | 10 | |||
| 74602 | 17126 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1971 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5997587.7043 | 2109167.9232 | 37.7712342233691 | -122.451728208046 | (37.7712342233691, -122.451728208046) | 15 | 5 | 11 | 29492 | 9 | |||
| 74673 | 141682 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2350 TURK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998677.6671 | 2111822.1113 | 37.7785843052603 | -122.448149143618 | (37.7785843052603, -122.448149143618) | 15 | 6 | 2 | 54 | 16 | |||
| 74774 | 28785 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 800 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6002281.4779 | 2109178.7673 | 37.7715316982304 | -122.435493052551 | (37.7715316982304, -122.435493052551) | 15 | 5 | 11 | 29492 | 9 | |||
| 74806 | 201182 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 620 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6013434.6654 | 2113939.6272 | 37.7852310646842 | -122.397247203178 | (37.7852310646842, -122.397247203178) | 6 | 2 | 9 | 28855 | 6 | |||
| 75544 | 143539 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2133 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002781.8179 | 2118502.7622 | 37.7971614332575 | -122.434429107355 | (37.7971614332575, -122.434429107355) | 13 | 9 | 1 | 57 | 17 | |||
| 75606 | 140724 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002188.642 | 2110237.6916 | 37.7744339682233 | -122.435889957062 | (37.7744339682233, -122.435889957062) | 15 | 5 | 11 | 29492 | 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 | |||
| 75736 | 143545 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2165 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002649.7521 | 2118486.4174 | 37.7971090573089 | -122.434884917759 | (37.7971090573089, -122.434884917759) | 13 | 9 | 1 | 57 | 17 | |||
| 76877 | 53483 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 647 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1969 12:00:00 AM | 16 | Permit Number 6392 | 6008737.1169 | 2120721.7235 | 37.8035903907477 | -122.413979278997 | (37.8035903907477, -122.413979278997) | 3 | 1 | 10 | 308 | 23 | ||
| 76970 | 244502 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 607 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003992.8339 | 2110059.3818 | 37.7740466976962 | -122.429636195865 | (37.7740466976962, -122.429636195865) | 7 | 9 | 11 | 29492 | 10 | |||
| 77347 | 142506 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1223 KEARNY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6011074.9884 | 2119120.527 | 37.7993249217375 | -122.405776067035 | (37.7993249217375, -122.405776067035) | 3 | 1 | 10 | 308 | 23 | |||
| 77368 | 247387 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1053 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6001955.5092 | 2109778.1291 | 37.7731588780046 | -122.43666350389 | (37.7731588780046, -122.43666350389) | 15 | 5 | 11 | 29492 | 9 | |||
| 77520 | 33692 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 11 | Permit Number 37765 | 6005361.9877 | 2111137.3022 | 37.7770838353758 | -122.42497676123 | (37.7770838353758, -122.42497676123) | 7 | 9 | 11 | 28852 | 10 | ||
| 77575 | 23736 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 815 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2005 12:00:00 AM | 8 | 4X4 | 6003952.5765 | 2110750.7086 | 37.7759426316052 | -122.429824773698 | (37.7759426316052, -122.429824773698) | 7 | 9 | 11 | 29492 | 10 | ||
| 77793 | 62731 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2307 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1993 12:00:00 AM | 10 | Permit Number 32015 | 5985442.2939 | 2099497.5593 | 37.7439790107491 | -122.49302661105 | (37.7439790107491, -122.49302661105) | 1 | 8 | 3 | 29491 | 35 | ||
| 78074 | 246129 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1486 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998642.4625 | 2108323.3267 | 37.7689755270562 | -122.448018950873 | (37.7689755270562, -122.448018950873) | 15 | 5 | 11 | 29492 | 9 | |||
| 78131 | 18011 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2707 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000900.4249 | 2114838.7005 | 37.7869939019534 | -122.440676225149 | (37.7869939019534, -122.440676225149) | 13 | 6 | 1 | 29490 | 27 | |||
| 78236 | 14558 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1599X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5999395.6349 | 2109419.0073 | 37.7720270129329 | -122.445492582637 | (37.7720270129329, -122.445492582637) | 15 | 5 | 11 | 29492 | 9 | |||
| 78902 | 143556 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 848 KEARNY ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6011275.0549 | 2117918.4465 | 37.7960354859857 | -122.404999078913 | (37.7960354859857, -122.404999078913) | 3 | 1 | 10 | 28857 | 4 | |||
| 79062 | 17070 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1419 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6000207.1415 | 2109530.5209 | 37.7723794951397 | -122.442693535131 | (37.7723794951397, -122.442693535131) | 15 | 5 | 11 | 29492 | 9 | |||
| 79160 | 138864 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003093.4509 | 2110708.1672 | 37.7757771350892 | -122.432793670379 | (37.7757771350892, -122.432793670379) | 15 | 9 | 11 | 29492 | 10 | |||
| 79297 | 182039 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1323 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5988935.747 | 2106319.8798 | 37.7629149697028 | -122.481446720354 | (37.7629149697028, -122.481446720354) | 1 | 8 | 3 | 56 | 35 | |||
| 79767 | 17087 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1621 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5999187.9651 | 2109387.1019 | 37.7719275511448 | -122.446208630434 | (37.7719275511448, -122.446208630434) | 15 | 5 | 11 | 29492 | 9 | |||
| 79951 | 248610 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 872 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997691.4278 | 2107516.4386 | 37.7667056091614 | -122.4512503025 | (37.7667056091614, -122.4512503025) | 15 | 5 | 11 | 29492 | 9 | |||
| 80103 | 244379 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 219 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005931.9708 | 2110333.2151 | 37.7749081865836 | -122.422947845445 | (37.7749081865836, -122.422947845445) | 7 | 9 | 11 | 28852 | 10 | |||
| 80284 | 64505 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 412 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/1988 12:00:00 AM | 9 | Permit Number 25386 | 6001213.6317 | 2110153.0182 | 37.7741460412807 | -122.439256624823 | (37.7741460412807, -122.439256624823) | 15 | 5 | 11 | 29492 | 10 | |
| 80537 | 199852 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2501 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014213.4453 | 2092166.8088 | 37.7254909106612 | -122.393028911239 | (37.7254909106612, -122.393028911239) | 10 | 3 | 8 | 58 | 1 | |||
| 80718 | 14846 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1335 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6002759.5163 | 2111624.2963 | 37.7782736522759 | -122.434014334985 | (37.7782736522759, -122.434014334985) | 15 | 5 | 11 | 29492 | 41 | |||
| 80867 | 59153 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 20 Bellair Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/1982 12:00:00 AM | 11 | Permit Number 19779 | 6010063.4155 | 2121130.5341 | 37.8047872831513 | -122.409418407658 | (37.8047872831513, -122.409418407658) | 3 | 1 | 10 | 308 | 23 | ||
| 80916 | 481 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2700 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010503.8335 | 2102264.9476 | 37.7530114675552 | -122.406564050249 | (37.7530114675552, -122.406564050249) | 10 | 4 | 7 | 28859 | 19 | |||
| 81395 | 4723 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1050 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 5x5 | 6008295.1213 | 2120922.8472 | 37.8041177920118 | -122.415523078458 | (37.8041177920118, -122.415523078458) | 5 | 1 | 10 | 308 | 23 | |||
| 81768 | 16876 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 274 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005679.4463 | 2110349.1101 | 37.7749375780539 | -122.423822512667 | (37.7749375780539, -122.423822512667) | 7 | 9 | 11 | 28852 | 10 | |||
| 81789 | 98493 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1703 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | 6006578.8967 | 2116733.3834 | 37.7925179651008 | -122.421164544764 | (37.7925179651008, -122.421164544764) | 13 | 9 | 10 | 28858 | 32 | ||||
| 82036 | 140060 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 448 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005624.0049 | 2111381.7435 | 37.777769808526 | -122.424087748475 | (37.777769808526, -122.424087748475) | 7 | 9 | 11 | 28852 | 10 | |||
| 82175 | 64038 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 16 Loyola Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/1988 12:00:00 AM | 10 | Permit Number 25745 | 5998453.4174 | 2110814.7286 | 37.7758054707119 | -122.44885232426 | (37.7758054707119, -122.44885232426) | 15 | 6 | 2 | 29492 | 16 | ||
| 82265 | 142992 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 455 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6009662.0127 | 2120854.6155 | 37.8040071808412 | -122.410788010808 | (37.8040071808412, -122.410788010808) | 3 | 1 | 10 | 308 | 23 | |||
| 83079 | 15282 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6007118.1667 | 2109554.742 | 37.7728375468829 | -122.418789312367 | (37.7728375468829, -122.418789312367) | 8 | 2 | 9 | 28853 | 19 | |||
| 83182 | 141692 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 392 EWING TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5998708.9601 | 2112320.4172 | 37.7799543130642 | -122.44807677808 | (37.7799543130642, -122.44807677808) | 15 | 6 | 2 | 54 | 16 | |||
| 83890 | 57820 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2357 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/1977 12:00:00 AM | 11 | Permit Number 16759 | 6002204.3143 | 2114668.0157 | 37.7865994109848 | -122.436152849525 | (37.7865994109848, -122.436152849525) | 13 | 6 | 1 | 29490 | 27 | ||
| 84048 | 57327 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2904 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1976 12:00:00 AM | 17 | Permit Number 16155 | 5999526.9274 | 2114356.6691 | 37.7855920575643 | -122.445393527485 | (37.7855920575643, -122.445393527485) | 15 | 6 | 1 | 29490 | 31 | ||
| 84375 | 138765 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2736 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5999497.9358 | 2113999.1058 | 37.7846086267732 | -122.445468109626 | (37.7846086267732, -122.445468109626) | 15 | 6 | 1 | 29490 | 31 | |||
| 84754 | 20151 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1043 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778996 | 6002888.3687 | 2111863.5194 | 37.7789378108444 | -122.433585688352 | (37.7789378108444, -122.433585688352) | 15 | 9 | 11 | 29490 | 41 | |
| 84974 | 13190 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2095 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6002390.8808 | 2119455.1404 | 37.7997542165181 | -122.435850022657 | (37.7997542165181, -122.435850022657) | 13 | 9 | 1 | 57 | 17 | ||
| 85092 | 138010 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1401 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005424.6122 | 2114535.843 | 37.7864189291949 | -122.425001985822 | (37.7864189291949, -122.425001985822) | 13 | 9 | 11 | 28858 | 13 | |||
| 85736 | 23797 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1143 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6003734.1252 | 2112710.5884 | 37.7813116023897 | -122.430720343349 | (37.7813116023897, -122.430720343349) | 15 | 9 | 11 | 29490 | 41 | |||
| 85833 | 17048 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1205 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001170.7121 | 2109662.4759 | 37.7727966927365 | -122.439369921594 | (37.7727966927365, -122.439369921594) | 15 | 5 | 11 | 29492 | 9 | |||
| 86344 | 17069 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1407 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6000238.3853 | 2109534.8419 | 37.7723931405508 | -122.442585770509 | (37.7723931405508, -122.442585770509) | 15 | 5 | 11 | 29492 | 9 | |||
| 86447 | 141678 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2340 TURK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998817.5652 | 2111841.8183 | 37.7786464120147 | -122.447666603511 | (37.7786464120147, -122.447666603511) | 15 | 6 | 2 | 54 | 16 |
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) );