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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3945 | 3945 | 6232 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1220 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6005007.0756 | 2113377.0261 | 37.7832135118405 | -122.42636402033199 | (37.7832135118405, -122.426364020332) | ||
| 3990 | 3990 | 21628 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1615 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/1994 12:00:00 AM | 6 | 4X4 | 6004654.6857 | 2114664.3643 | 37.786728295749896 | -122.427674898563 | (37.7867282957499, -122.427674898563) | ||
| 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) | |||
| 4022 | 4022 | 22785 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1885 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001011.2725 | 2112069.058 | 37.7793954847522 | -122.44009404075399 | (37.7793954847522, -122.440094040754) | |||
| 4206 | 4206 | 13097 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1475 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005336.846 | 2119866.4127 | 37.801050369840205 | -122.42568517574 | (37.8010503698402, -122.42568517574) | |||
| 4221 | 4221 | 244055 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401 Cole St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997910.1594 | 2109123.3007 | 37.771130163517704 | -122.450609610411 | (37.7711301635177, -122.450609610411) | |||
| 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) | |
| 4252 | 4252 | 244056 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401 Cole St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997913.0484 | 2109110.0936 | 37.771094065570296 | -122.45059866498 | (37.7710940655703, -122.45059866498) | |||
| 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) | |
| 4278 | 4278 | 246148 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998461.6736 | 2108298.4947 | 37.768897008730896 | -122.44864249661501 | (37.7688970087309, -122.448642496615) | |||
| 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) | |||
| 4440 | 4440 | 28068 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3445 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5996452.8473 | 2112841.7002 | 37.78125639187 | -122.455919329089 | (37.78125639187, -122.455919329089) | |||
| 4497 | 4497 | 13125 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1688 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 25 | 3X3 | 6004309.8631 | 2119808.6849 | 37.8008337792511 | -122.429234859067 | (37.8008337792511, -122.429234859067) | ||
| 4557 | 4557 | 245383 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3720 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 0ft | 6005268.7499 | 2096538.92 | 37.7369948294896 | -122.42426078327499 | (37.7369948294896, -122.424260783275) | |||
| 4565 | 4565 | 142525 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 301 FRANCISCO ST | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 23 | Width 0ft | 6009759.5801 | 2121214.59 | 37.8050010513122 | -122.410475804946 | (37.8050010513122, -122.410475804946) | |||
| 4602 | 4602 | 245382 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3720 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6005277.267000001 | 2096556.8057 | 37.7370444205252 | -122.42423260748899 | (37.7370444205252, -122.424232607489) | |||
| 4603 | 4603 | 142513 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 419 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 0ft | 6010363.8889 | 2118953.3694 | 37.798826155678796 | -122.408224935007 | (37.7988261556788, -122.408224935007) | |||
| 4606 | 4606 | 142512 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 427 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6010331.5039 | 2118981.6421 | 37.798901972160294 | -122.40833899341601 | (37.7989019721603, -122.408338993416) | |||
| 4924 | 4924 | 143020 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 560 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 0ft | 6009678.016 | 2120549.6995 | 37.8031708545804 | -122.410711083519 | (37.8031708545804, -122.410711083519) | |||
| 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) | |||
| 5252 | 5252 | 17675 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1010 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002421.1673 | 2112056.7065 | 37.779441734619205 | -122.435215744209 | (37.7794417346192, -122.435215744209) | |||
| 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) | |||
| 5332 | 5332 | 10639 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 877 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003685.3267 | 2110714.3548 | 37.7758276754833 | -122.43074666505301 | (37.7758276754833, -122.430746665053) | |||
| 5342 | 5342 | 17679 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1004 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002429.082 | 2112004.3581 | 37.7792984485069 | -122.435184618671 | (37.7792984485069, -122.435184618671) | |||
| 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) | |||
| 5382 | 5382 | 7155 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 710 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003553.4142 | 2110901.6518 | 37.776334472306 | -122.431216355856 | (37.776334472306, -122.431216355856) | |||
| 5422 | 5422 | 4684 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 722 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6009311.9987 | 2119994.7358 | 37.801626533850204 | -122.411938460907 | (37.8016265338502, -122.411938460907) | |||
| 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) | |||
| 5501 | 5501 | 99227 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008003.9616 | 2121103.5041 | 37.8045974602939 | -122.416543465428 | (37.8045974602939, -122.416543465428) | |||
| 5526 | 5526 | 99210 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007993.4855 | 2121112.3432 | 37.8046211410646 | -122.416580345595 | (37.8046211410646, -122.416580345595) | |||
| 5554 | 5554 | 21709 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1900 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6x9 | 6003440.4648 | 2114551.568 | 37.786349828094295 | -122.43186775477301 | (37.7863498280943, -122.431867754773) | |||
| 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) | |||
| 5648 | 5648 | 7179 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 833 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003463.175 | 2111217.4725 | 37.777196523521795 | -122.431551070298 | (37.7771965235218, -122.431551070298) | |||
| 5652 | 5652 | 6235 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1250 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6004904.9664 | 2113362.05 | 37.7831666187465 | -122.426716210533 | (37.7831666187465, -122.426716210533) | ||
| 5653 | 5653 | 12271 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 700X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004951.5507 | 2111300.9055 | 37.7775098574182 | -122.426408243779 | (37.7775098574182, -122.426408243779) | |||
| 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) | |||
| 5748 | 5748 | 6994 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 870 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003272.597999999 | 2110360.7630000003 | 37.77483340788321 | -122.43214914086201 | (37.7748334078832, -122.432149140862) | |||
| 5763 | 5763 | 107346 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 247 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5998163.7387 | 2112864.5437 | 37.7814171604492 | -122.450002161775 | (37.7814171604492, -122.450002161775) | |||
| 5781 | 5781 | 7252 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1701 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003031.0875 | 2114271.6252 | 37.78555796067371 | -122.433264083866 | (37.7855579606737, -122.433264083866) | |||
| 5822 | 5822 | 18009 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2704 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6000887.4934 | 2114883.9407 | 37.787117383440794 | -122.440724211427 | (37.7871173834408, -122.440724211427) | |||
| 5835 | 5835 | 7158 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 719 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003514.1332 | 2110837.5014 | 37.7761561050706 | -122.431347659332 | (37.7761561050706, -122.431347659332) | |||
| 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) | |||
| 5865 | 5865 | 13184 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2055X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002517.9206 | 2119475.0682 | 37.799816148716296 | -122.435411844948 | (37.7998161487163, -122.435411844948) | |||
| 5884 | 5884 | 17676 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1004 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002427.6935 | 2112026.5749 | 37.779359371412795 | -122.43519101157301 | (37.7793593714128, -122.435191011573) | |||
| 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) | |||
| 5946 | 5946 | 18013 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2707 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000963.2953 | 2114846.642 | 37.7870192873225 | -122.440459278057 | (37.7870192873225, -122.440459278057) | |||
| 5974 | 5974 | 21668 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1776 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 4X4 | 6004178.0557 | 2114647.4926 | 37.7866549980826 | -122.42932272146601 | (37.7866549980826, -122.429322721466) | |||
| 6034 | 6034 | 17999 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2663 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001215.9923 | 2114878.7551 | 37.7871218470279 | -122.439587308087 | (37.7871218470279, -122.439587308087) | |||
| 6061 | 6061 | 14540 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 712 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5999232.8618 | 2110380.1211 | 37.7746566927117 | -122.44612477022 | (37.7746566927117, -122.44612477022) | |||
| 6065 | 6065 | 13190 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2095 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6002390.8808 | 2119455.1404 | 37.7997542165181 | -122.435850022657 | (37.7997542165181, -122.435850022657) | ||
| 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) | |||
| 6110 | 6110 | 13189 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2055X Lombard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002690.4208 | 2119498.1098 | 37.7998892100694 | -122.43481657946998 | (37.7998892100694, -122.43481657947) | |||
| 6126 | 6126 | 7180 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 837 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003455.9744 | 2111255.1372 | 37.7772995333232 | -122.43157866908199 | (37.7772995333232, -122.431578669082) | |||
| 6144 | 6144 | 7206 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 940 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003460.3469 | 2111580.5338 | 37.778193239457295 | -122.431586779834 | (37.7781932394573, -122.431586779834) | |||
| 6161 | 6161 | 7251 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1701 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003028.1584 | 2114287.7355 | 37.785602029314205 | -122.43327536926 | (37.7856020293142, -122.43327536926) | |||
| 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) | |||
| 6213 | 6213 | 99229 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008022.9494 | 2121084.5162 | 37.804546392141496 | -122.416476410342 | (37.8045463921415, -122.416476410342) | |||
| 6214 | 6214 | 23797 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1143 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6003734.1252 | 2112710.5884 | 37.7813116023897 | -122.430720343349 | (37.7813116023897, -122.430720343349) | |||
| 6232 | 6232 | 13105 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1530 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 90 | 3X3 | 6004999.0901 | 2119899.25 | 37.8011214413621 | -122.426856296775 | (37.8011214413621, -122.426856296775) | ||
| 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) | |||
| 6264 | 6264 | 18011 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2707 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000900.4249 | 2114838.7005 | 37.786993901953394 | -122.440676225149 | (37.7869939019534, -122.440676225149) | |||
| 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) | ||
| 6400 | 6400 | 106204 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1600X Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5x5 | 6003122.9413 | 2113972.2468 | 37.7847411535968 | -122.432924900964 | (37.7847411535968, -122.432924900964) | |||
| 6429 | 6429 | 7178 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 837 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6x6 | 6003458.7438 | 2111235.1971 | 37.777244939721704 | -122.431567664925 | (37.7772449397217, -122.431567664925) | |||
| 6452 | 6452 | 13171 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1940X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003096.45 | 2119636.9817 | 37.8002935599258 | -122.433421496602 | (37.8002935599258, -122.433421496602) | |||
| 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) | |||
| 6528 | 6528 | 13104 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1530 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 90 | 3X3 | 6005037.4004 | 2119906.2866 | 37.801142928088495 | -122.426724227861 | (37.8011429280885, -122.426724227861) | ||
| 6530 | 6530 | 8195 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1301 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001448.9604 | 2111096.3198 | 37.776749499067705 | -122.438510182933 | (37.7767494990677, -122.438510182933) | |||
| 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) | |||
| 6639 | 6639 | 12264 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 640 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004966.4829 | 2111191.3303 | 37.7772098348265 | -122.42634878470301 | (37.7772098348265, -122.426348784703) | |||
| 6652 | 6652 | 13197 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2114 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6002204.6803 | 2119511.1874 | 37.799897528014704 | -122.436498357806 | (37.7998975280147, -122.436498357806) | |||
| 6666 | 6666 | 7250 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1701 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1990 12:00:00 AM | 12 | 4X4 | 6003025.9615 | 2114308.2396 | 37.7856582037536 | -122.43328443554199 | (37.7856582037536, -122.433284435542) | ||
| 6691 | 6691 | 121389 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2646 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5999473.1272 | 2113649.2828 | 37.7836466874196 | -122.445528775036 | (37.7836466874196, -122.445528775036) | |||
| 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) | |||
| 6739 | 6739 | 99228 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008013.4555 | 2121093.6827 | 37.8045710271276 | -122.416509914664 | (37.8045710271276, -122.416509914664) | |||
| 6743 | 6743 | 7207 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 940 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003456.4877 | 2111615.9101 | 37.778290155247205 | -122.431602656487 | (37.7782901552472, -122.431602656487) | |||
| 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) | |||
| 6753 | 6753 | 14817 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1234 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003267.0451 | 2111739.9368 | 37.7786199621548 | -122.43226686795799 | (37.7786199621548, -122.432266867958) | |||
| 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) | |||
| 6933 | 6933 | 18012 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2707 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000934.1764 | 2114843.3331 | 37.787008543855 | -122.44055978525299 | (37.787008543855, -122.440559785253) | |||
| 6938 | 6938 | 18020 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2723 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000792.5524 | 2114820.8321 | 37.786938696374 | -122.44104815631201 | (37.786938696374, -122.441048156312) | |||
| 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) | |||
| 6963 | 6963 | 13021 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 423 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6010315.0722 | 2120598.0088 | 37.803339197434 | -122.408509932207 | (37.803339197434, -122.408509932207) |
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");