Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4021 | 4021 | 4643 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 515 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 6010000.9813 | 2119283.7816 | 37.7997130589262 | -122.409504050861 | (37.7997130589262, -122.409504050861) | |||
| 4223 | 4223 | 246149 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998439.5671 | 2108294.2551 | 37.7688841037799 | -122.44871865576 | (37.7688841037799, -122.44871865576) | |||
| 4236 | 4236 | 246150 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998421.7001 | 2108292.1353 | 37.7688772616464 | -122.448780303512 | (37.7688772616464, -122.448780303512) | |||
| 4243 | 4243 | 246126 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1546 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998264.228999999 | 2108270.3316 | 37.768808388052605 | -122.449323411621 | (37.7688083880526, -122.449323411621) | |||
| 4247 | 4247 | 246146 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1980 12:00:00 AM | 16 | Width 0ft | Permit Number 18128 | 5998494.9848 | 2108301.523 | 37.76890722837079 | -122.44852749406 | (37.7689072283708, -122.44852749406) | |
| 4255 | 4255 | 4659 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009780.1976 | 2119571.0943 | 37.800489575353104 | -122.410288343699 | (37.8004895753531, -122.410288343699) | |||
| 4265 | 4265 | 246125 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1546 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1979 12:00:00 AM | 13 | Width 0ft | Permit Number 17701 | 5998276.9478 | 2108272.4514 | 37.7688149359981 | -122.44927957115101 | (37.7688149359981, -122.449279571151) | |
| 4302 | 4302 | 13161 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1895 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6003359.5664 | 2119590.4223 | 37.8001806439695 | -122.432507683341 | (37.8001806439695, -122.432507683341) | |||
| 5145 | 5145 | 4664 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009692.467999999 | 2119649.5892 | 37.8007001848924 | -122.410597470914 | (37.8007001848924, -122.410597470914) | |||
| 5324 | 5324 | 4600 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 256 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6010961.6739 | 2118493.2807 | 37.7975963184564 | -122.406123962239 | (37.7975963184564, -122.406123962239) | |||
| 5353 | 5353 | 7166 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 745 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003498.9011 | 2110946.3415 | 37.7764540897977 | -122.43140812270599 | (37.7764540897977, -122.431408122706) | |||
| 5484 | 5484 | 13181 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2001 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002704.7439 | 2119503.7145 | 37.7999054122901 | -122.434767417241 | (37.7999054122901, -122.434767417241) | |||
| 5577 | 5577 | 7259 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1718 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6003082.9532 | 2114267.2697 | 37.785548943737204 | -122.433084332552 | (37.7855489437372, -122.433084332552) | |||
| 5637 | 5637 | 4723 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1050 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 5x5 | 6008295.1213 | 2120922.8472 | 37.804117792011795 | -122.41552307845801 | (37.8041177920118, -122.415523078458) | |||
| 5657 | 5657 | 26166 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1501 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005131.2215 | 2119837.4845 | 37.8009593191179 | -122.426394664407 | (37.8009593191179, -122.426394664407) | |||
| 5681 | 5681 | 14846 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1335 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6002759.5163 | 2111624.2963 | 37.7782736522759 | -122.43401433498501 | (37.7782736522759, -122.434014334985) | |||
| 5702 | 5702 | 7267 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1750 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003061.8978 | 2114394.5816 | 37.785897315625796 | -122.433166277822 | (37.7858973156258, -122.433166277822) | |||
| 5722 | 5722 | 21711 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1900 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6x6 | 6003392.8992 | 2114541.4083 | 37.7863192355998 | -122.43203159373999 | (37.7863192355998, -122.43203159374) | |||
| 5730 | 5730 | 4720 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1040 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 5x5 | 6008353.7979 | 2120870.8765 | 37.8039783914932 | -122.415316341899 | (37.8039783914932, -122.415316341899) | |||
| 5852 | 5852 | 4724 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1050 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4x4 | 6008259.9153 | 2120954.1415 | 37.8042017393393 | -122.41564712883101 | (37.8042017393393, -122.415647128831) | |||
| 5904 | 5904 | 24490 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 852 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1995 12:00:00 AM | 6 | 3X3 | 6003356.8582 | 2110371.9538 | 37.7748689119653 | -122.431858466675 | (37.7748689119653, -122.431858466675) | ||
| 5926 | 5926 | 13119 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1641 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3x3 | 6004501.8382 | 2119760.0821 | 37.8007111944994 | -122.42856707818899 | (37.8007111944994, -122.428567078189) | |||
| 6068 | 6068 | 13109 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1599 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1994 12:00:00 AM | 24 | 3x3 | 6004827.8666 | 2119796.0468 | 37.8008283892799 | -122.427441448129 | (37.8008283892799, -122.427441448129) | ||
| 6076 | 6076 | 8204 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1369 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001211.3032 | 2111062.2036 | 37.7766423030153 | -122.439329862063 | (37.7766423030153, -122.439329862063) | |||
| 6173 | 6173 | 13020 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 423 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6010295.8571 | 2120595.8738 | 37.8033322591341 | -122.40857627636002 | (37.8033322591341, -122.40857627636) | |||
| 6233 | 6233 | 4722 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1040 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 4x4 | 6008317.4743 | 2120903.2884 | 37.804065344872704 | -122.415444338519 | (37.8040653448727, -122.415444338519) | |||
| 6362 | 6362 | 21629 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1615 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1994 12:00:00 AM | 12 | 4X4 | 6004674.0893 | 2114666.9174 | 37.786736403473704 | -122.427607948661 | (37.7867364034737, -122.427607948661) | ||
| 6459 | 6459 | 13183 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2001 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 12 | 3x3 | 6002759.5454 | 2119509.3192 | 37.7999239124366 | -122.43457818463301 | (37.7999239124366, -122.434578184633) | ||
| 6481 | 6481 | 21673 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1781 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004071.937000001 | 2114582.0596 | 37.786469327183 | -122.429685197969 | (37.786469327183, -122.429685197969) | |||
| 6484 | 6484 | 21712 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1900 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6x8 | 6003372.5799 | 2114537.2521 | 37.786306671740704 | -122.432101596345 | (37.7863066717407, -122.432101596345) | |||
| 6541 | 6541 | 33662 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 453 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2016 12:00:00 AM | 3 | Permit Number 37750 | 6005235.3039 | 2110769.7304 | 37.7760674161616 | -122.425388836438 | (37.7760674161616, -122.425388836438) | ||
| 6546 | 6546 | 13195 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2098 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6002408.3176 | 2119538.5881 | 37.7999843325384 | -122.435795658785 | (37.7999843325384, -122.435795658785) | |||
| 6713 | 6713 | 12985 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 306 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3X3 | 6010818.9339 | 2120706.9936 | 37.8036666476299 | -122.406773977327 | (37.8036666476299, -122.406773977327) | |||
| 6715 | 6715 | 7162 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 727 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003506.9326 | 2110884.8593 | 37.7762857300682 | -122.43137594955499 | (37.7762857300682, -122.431375949555) | |||
| 6737 | 6737 | 17678 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1016 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002420.6118 | 2112080.0342 | 37.7795057550774 | -122.435219334932 | (37.7795057550774, -122.435219334932) | |||
| 6749 | 6749 | 13206 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2150 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6002065.1856 | 2119491.2596 | 37.799834883876 | -122.436979633615 | (37.799834883876, -122.436979633615) | |||
| 6838 | 6838 | 13222 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2245 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001648.8811 | 2119355.19 | 37.7994376018224 | -122.438410445473 | (37.7994376018224, -122.438410445473) | |||
| 6870 | 6870 | 9637 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1460 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002620.3308 | 2112001.9911 | 37.7793028076481 | -122.43452284095801 | (37.7793028076481, -122.434522840958) | |||
| 6951 | 6951 | 9697 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 423 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005890.102000001 | 2111192.506 | 37.7772652286056 | -122.42315377098801 | (37.7772652286056, -122.423153770988) | |||
| 6968 | 6968 | 4661 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009739.5649 | 2119605.2627 | 37.8005811155969 | -122.41043136381901 | (37.8005811155969, -122.410431363819) | |||
| 7037 | 7037 | 4663 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 60 | 5X5 | 6009710.0139 | 2119634.3519 | 37.8006593307081 | -122.41053567802 | (37.8006593307081, -122.41053567802) | |||
| 7064 | 7064 | 7154 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 709 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003520.226 | 2110798.7288 | 37.776049990393 | -122.431323814363 | (37.776049990393, -122.431323814363) | |||
| 7089 | 7089 | 18081 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2967 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999746.4018 | 2114674.089 | 37.7864761362834 | -122.444657035366 | (37.7864761362834, -122.444657035366) | |||
| 7109 | 7109 | 18519 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1700X Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6009627.5943 | 2119520.0726 | 37.800340927010296 | -122.410812809398 | (37.8003409270103, -122.410812809398) | |||
| 7263 | 7263 | 4725 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1050 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4x4 | 6008238.1211 | 2120976.4945 | 37.8042618899237 | -122.415724133248 | (37.8042618899237, -122.415724133248) | |||
| 7524 | 7524 | 21650 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1688 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004543.8112 | 2114703.7787 | 37.7868302455522 | -122.428061307883 | (37.7868302455522, -122.428061307883) | |||
| 7541 | 7541 | 7214 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 950 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6003450.6988 | 2111662.2209 | 37.778416985075104 | -122.431625989594 | (37.7784169850751, -122.431625989594) | |||
| 7585 | 7585 | 9638 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1470 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002570.9212 | 2111995.2227 | 37.7792814183991 | -122.434693285009 | (37.7792814183991, -122.434693285009) | |||
| 7620 | 7620 | 13281 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2524 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 40 | 3x3 | 6000224.9781 | 2119238.0771 | 37.7990349463185 | -122.44332922273199 | (37.7990349463185, -122.443329222732) | ||
| 7652 | 7652 | 13207 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2199 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6001946.8642 | 2119395.357 | 37.799564834652706 | -122.43738219799299 | (37.7995648346527, -122.437382197993) | ||
| 7692 | 7692 | 4721 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1040 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5x5 | 6008335.3567 | 2120887.0824 | 37.8040218523597 | -122.415381307054 | (37.8040218523597, -122.415381307054) | |||
| 7851 | 7851 | 4658 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 34 | 5X5 | 6009795.4348 | 2119557.2423 | 37.8004523952872 | -122.410234638074 | (37.8004523952872, -122.410234638074) | |||
| 7939 | 7939 | 4660 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 125 | 5X5 | 6009761.7282 | 2119587.7167 | 37.8005341810425 | -122.410353429867 | (37.8005341810425, -122.410353429867) | |||
| 8072 | 8072 | 7258 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1714 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6003084.9119 | 2114241.8074 | 37.785479141806604 | -122.433075736157 | (37.7854791418066, -122.433075736157) | |||
| 8138 | 8138 | 13110 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1599 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1994 12:00:00 AM | 16 | 3x3 | 6004846.6308 | 2119801.5197 | 37.800844477708004 | -122.427376906198 | (37.800844477708, -122.427376906198) | ||
| 8140 | 8140 | 21680 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1811 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003837.4434 | 2114549.281 | 37.7863660445938 | -122.430494147332 | (37.7863660445938, -122.430494147332) | |||
| 8167 | 8167 | 17998 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2655 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001236.5127 | 2114885.1235 | 37.7871405009053 | -122.43951676886299 | (37.7871405009053, -122.439516768863) | |||
| 8204 | 8204 | 7685 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 521 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6008756.4018 | 2121076.0419 | 37.804564343319605 | -122.41393762212 | (37.8045643433196, -122.41393762212) | |||
| 8257 | 8257 | 13205 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2150 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6002007.2704 | 2119484.4094 | 37.799812783065704 | -122.43717955071301 | (37.7998127830657, -122.437179550713) | |||
| 8267 | 8267 | 13269 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2495 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 6 | 3X3 | 6000559.8762 | 2119201.7827 | 37.798954383190896 | -122.442167759467 | (37.7989543831909, -122.442167759467) | ||
| 8289 | 8289 | 4662 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 80 | 5X5 | 6009727.0981 | 2119617.2678 | 37.8006133797513 | -122.41047535239099 | (37.8006133797513, -122.410475352391) | |||
| 8449 | 8449 | 7686 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 521 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6008772.4139 | 2121077.9257 | 37.8045704150203 | -122.413882343906 | (37.8045704150203, -122.413882343906) | |||
| 8458 | 8458 | 7176 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 821 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003466.4983 | 2111179.8077 | 37.777093293678206 | -122.43153688437401 | (37.7770932936782, -122.431536884374) | |||
| 8613 | 8613 | 7257 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1714 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6003087.8498 | 2114225.1589 | 37.785433595884 | -122.43306438198799 | (37.785433595884, -122.433064381988) | |||
| 8620 | 8620 | 13203 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2143 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002126.2145 | 2119425.2487 | 37.7996571038373 | -122.436763723295 | (37.7996571038373, -122.436763723295) | |||
| 8759 | 8759 | 22673 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1330 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003656.8115 | 2112490.6031 | 37.780703197144 | -122.430972105719 | (37.780703197144, -122.430972105719) | |||
| 8774 | 8774 | 9636 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1460 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002640.9745 | 2112004.0216 | 37.7793095547354 | -122.434451571103 | (37.7793095547354, -122.434451571103) | |||
| 8963 | 8963 | 12998 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 348 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6010660.6396 | 2120687.9769 | 37.803605574331705 | -122.407320424126 | (37.8036055743317, -122.407320424126) | |||
| 9238 | 9238 | 4685 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 716 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2012 12:00:00 AM | 3 | 3x3 | 6009342.0114 | 2119967.9552 | 37.801554684737894 | -122.411832709398 | (37.8015546847379, -122.411832709398) | ||
| 9434 | 9434 | 18037 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2807 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/1993 12:00:00 AM | 6 | 3X3 | 6000386.5591 | 2114760.4621 | 37.7867498032378 | -122.442448460651 | (37.7867498032378, -122.442448460651) | ||
| 9575 | 9575 | 23736 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 815 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2005 12:00:00 AM | 8 | 4X4 | 6003952.5765 | 2110750.7086 | 37.775942631605204 | -122.429824773698 | (37.7759426316052, -122.429824773698) | ||
| 12618 | 12618 | 15750 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 4625 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6002067.6674 | 2091962.7327 | 37.7242483928285 | -122.43500115616301 | (37.7242483928285, -122.435001156163) | |||
| 17134 | 17134 | 16973 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 779 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003283.5334 | 2109961.2453 | 37.773737050882396 | -122.432082777045 | (37.7737370508824, -122.432082777045) | |||
| 17142 | 17142 | 545 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2878 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6009558.0762 | 2102211.8871 | 37.7528128183786 | -122.40983092966101 | (37.7528128183786, -122.409830929661) | |||
| 17174 | 17174 | 17123 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1949 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997679.9901 | 2109179.4590000003 | 37.7712711825876 | -122.451409821439 | (37.7712711825876, -122.451409821439) | |||
| 17214 | 17214 | 17082 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1565 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5999524.2661 | 2109435.6263 | 37.7720799869694 | -122.445048833846 | (37.7720799869694, -122.445048833846) | |||
| 17403 | 17403 | 17098 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1705 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5998777.5925 | 2109332.4141 | 37.7717539478166 | -122.447624196011 | (37.7717539478166, -122.447624196011) | |||
| 17479 | 17479 | 17114 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1889X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998005.981000001 | 2109225.1746 | 37.7714153673222 | -122.45028550625 | (37.7714153673222, -122.45028550625) | |||
| 17505 | 17505 | 20093 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2079X Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997064.7516 | 2109095.7182 | 37.7710060031357 | -122.453531898634 | (37.7710060031357, -122.453531898634) | |||
| 17565 | 17565 | 542 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2870 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6009603.0598 | 2102213.6628 | 37.7528202149244 | -122.40967549279199 | (37.7528202149244, -122.409675492792) | |||
| 17632 | 17632 | 16985 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 867 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002849.3678 | 2109899.7049 | 37.7735434517189 | -122.433580223732 | (37.7735434517189, -122.433580223732) | |||
| 17644 | 17644 | 17126 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1971 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997587.7043 | 2109167.9232 | 37.7712342233691 | -122.45172820804599 | (37.7712342233691, -122.451728208046) | |||
| 17671 | 17671 | 16978 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 823 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003035.6347 | 2109919.8489 | 37.7736093289353 | -122.432937338869 | (37.7736093289353, -122.432937338869) | |||
| 17814 | 17814 | 16989 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 880 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002806.5013 | 2109946.7063 | 37.77367007365171 | -122.433731865097 | (37.7736700736517, -122.433731865097) | |||
| 17820 | 17820 | 17112 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1855 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5998114.9295 | 2109242.2645 | 37.7714685261947 | -122.449909881636 | (37.7714685261947, -122.449909881636) | |||
| 17964 | 17964 | 16976 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 811 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003075.3996 | 2109932.9295 | 37.7736475004085 | -122.432800720802 | (37.7736475004085, -122.432800720802) | |||
| 18114 | 18114 | 27413 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1125 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002017.7522 | 2110131.5591 | 37.774132845741704 | -122.436473498525 | (37.7741328457417, -122.436473498525) | |||
| 18214 | 18214 | 17113 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1875 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5998056.3964 | 2109231.5833 | 37.7714358490518 | -122.45011157971099 | (37.7714358490518, -122.450111579711) | |||
| 18241 | 18241 | 10403 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1369 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5999594.2543 | 2108755.1609 | 37.77021559548189 | -122.44475781986999 | (37.7702155954819, -122.44475781987) | |||
| 18281 | 18281 | 17048 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1205 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001170.7121 | 2109662.4759 | 37.7727966927365 | -122.43936992159401 | (37.7727966927365, -122.439369921594) | |||
| 18389 | 18389 | 16963 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 741 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003456.556 | 2109979.0777 | 37.7737958222062 | -122.43148553825701 | (37.7737958222062, -122.431485538257) | |||
| 18594 | 18594 | 17117 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1907 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5997844.0536 | 2109200.8214 | 37.771339231452 | -122.45084386213101 | (37.771339231452, -122.450843862131) | |||
| 18829 | 18829 | 14559 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1595X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999419.8987 | 2109421.3340000003 | 37.772034786606 | -122.44540881989799 | (37.772034786606, -122.445408819898) | |||
| 19393 | 19393 | 527 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2836 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6009841.2951 | 2102226.6843 | 37.7528693162895 | -122.408852546362 | (37.7528693162895, -122.408852546362) | |||
| 19595 | 19595 | 7021 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1105 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002080.4157 | 2110140.9294 | 37.7741621348105 | -122.43625740553301 | (37.7741621348105, -122.436257405533) | |||
| 19773 | 19773 | 17120 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1931 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997753.4769 | 2109191.4219 | 37.7713082373467 | -122.45115649157499 | (37.7713082373467, -122.451156491575) | |||
| 19853 | 19853 | 17115 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1899 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997963.2561 | 2109219.1931 | 37.7713964984716 | -122.450432861809 | (37.7713964984716, -122.450432861809) | |||
| 20080 | 20080 | 38646 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 209 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1998 12:00:00 AM | Permit Number 40570 | 6005214.92856016 | 2099001.03793316 | 37.7437522091261 | -122.42462195934401 | (37.7437522091261, -122.424621959344) | |||
| 20398 | 20398 | 16986 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 870 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002847.8984 | 2109953.1746 | 37.7736901829149 | -122.433589128645 | (37.7736901829149, -122.433589128645) | |||
| 20998 | 20998 | 16964 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 747 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6003424.2649 | 2109979.0777 | 37.7737939919852 | -122.431597238278 | (37.7737939919852, -122.431597238278) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");