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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 34909 | 34909 | 143246 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 647 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6008746.811000001 | 2120723.5878 | 37.8035960540957 | -122.413945863948 | (37.8035960540957, -122.413945863948) | |||
| 49979 | 49979 | 53483 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 647 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/1969 12:00:00 AM | 16 | Permit Number 6392 | 6008737.1169 | 2120721.7235 | 37.80359039074771 | -122.413979278997 | (37.8035903907477, -122.413979278997) | ||
| 188113 | 188113 | 142604 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 CHESTNUT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6008306.3204 | 2120712.3516 | 37.8035404535195 | -122.415469411535 | (37.8035404535195, -122.415469411535) | |||
| 181119 | 181119 | 142605 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 CHESTNUT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6008282.9909 | 2120710.7963 | 37.8035348717489 | -122.41555003439501 | (37.8035348717489, -122.415550034395) | |||
| 935 | 935 | 143018 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 404 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 0ft | 6010387.0782 | 2120648.4016 | 37.80348159588821 | -122.40826430805402 | (37.8034815958882, -122.408264308054) | |||
| 148979 | 148979 | 143004 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 432 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6010250.3341 | 2120628.0507 | 37.8034180593376 | -122.408736082419 | (37.8034180593376, -122.408736082419) | |||
| 172803 | 172803 | 143014 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 488 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010067.5326 | 2120604.4864 | 37.8033431173057 | -122.409367013095 | (37.8033431173057, -122.409367013095) | |||
| 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) | |||
| 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) | |||
| 30821 | 30821 | 143043 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 443 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010277.7096 | 2120592.1376 | 37.8033209840901 | -122.40863881299299 | (37.8033209840901, -122.408638812993) | |||
| 58556 | 58556 | 143036 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 502 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6009910.3575 | 2120582.9753 | 37.8032752457109 | -122.409909406146 | (37.8032752457109, -122.409909406146) | |||
| 63670 | 63670 | 143037 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 510 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6009884.4437 | 2120577.0857 | 37.8032576219869 | -122.40999866606701 | (37.8032576219869, -122.409998666067) | |||
| 165059 | 165059 | 143038 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 516 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6009865.0083 | 2120574.7299 | 37.803250064240004 | -122.41006575677 | (37.80325006424, -122.41006575677) | |||
| 148138 | 148138 | 143039 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 520 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6009841.4502 | 2120571.1962 | 37.8032390411539 | -122.410147031042 | (37.8032390411539, -122.410147031042) | |||
| 155353 | 155353 | 143049 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 475 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6010056.7368 | 2120562.2475 | 37.8032265348731 | -122.40940138982201 | (37.8032265348731, -122.409401389822) | |||
| 954 | 954 | 251405 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 540 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:08:00 PM | Width 0ft | 6009678.016 | 2120549.6995 | 37.8031708545804 | -122.410711083519 | (37.8031708545804, -122.410711083519) | |||
| 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) | |||
| 3435 | 3435 | 13052 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 557 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009686.1191 | 2120512.8313 | 37.8030700779734 | -122.410680437216 | (37.8030700779734, -122.410680437216) | |||
| 173192 | 173192 | 142746 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 LOMBARD ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6009447.7459 | 2120475.7434 | 37.802954876200204 | -122.41150271469601 | (37.8029548762002, -122.411502714696) | |||
| 7436 | 7436 | 4702 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 900 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1989 12:00:00 AM | 30 | 3X3 | 6008773.44 | 2120486.1314 | 37.8029455537581 | -122.413836905739 | (37.8029455537581, -122.413836905739) | ||
| 71914 | 71914 | 143259 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 LOMBARD ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6009421.8295 | 2120470.7273 | 37.802939649537294 | -122.41159204460399 | (37.8029396495373, -122.411592044604) | |||
| 149277 | 149277 | 143034 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 670 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2016 12:36:00 PM | 25 | Width 0ft | 6009144.7897 | 2120475.5959 | 37.80293747355329 | -122.41255109357701 | (37.8029374735533, -122.412551093577) | ||
| 27933 | 27933 | 143258 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 LOMBARD ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6009397.1671 | 2120467.3833 | 37.8029290843214 | -122.41167715318599 | (37.8029290843214, -122.411677153186) | |||
| 72235 | 72235 | 143257 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 LOMBARD ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6009374.1767 | 2120464.0392 | 37.8029186125655 | -122.41175647573 | (37.8029186125655, -122.41175647573) | |||
| 43131 | 43131 | 143256 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 LOMBARD ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6009354.5304 | 2120461.1132 | 37.8029094763595 | -122.411824255457 | (37.8029094763595, -122.411824255457) | |||
| 176204 | 176204 | 143255 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 LOMBARD ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6009331.5401 | 2120459.4412 | 37.802903595680704 | -122.411903695843 | (37.8029035956807, -122.411903695843) | |||
| 44319 | 44319 | 143254 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 LOMBARD ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6009304.3696 | 2120454.8431 | 37.802889446076605 | -122.411997395012 | (37.8028894460766, -122.411997395012) | |||
| 155316 | 155316 | 143253 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 LOMBARD ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6009276.7812 | 2120451.499 | 37.8028787161223 | -122.412092628976 | (37.8028787161223, -122.412092628976) | |||
| 183526 | 183526 | 143069 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1709 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6010441.5711 | 2120399.4535 | 37.802801097041204 | -122.40805816505501 | (37.8028010970412, -122.408058165055) | |||
| 154183 | 154183 | 143085 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 463 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6010679.3104 | 2120299.3653 | 37.8025395875062 | -122.40722840196999 | (37.8025395875062, -122.40722840197) | |||
| 29780 | 29780 | 143503 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 24 GERKE ALY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6010601.2344 | 2120203.101 | 37.80227089957479 | -122.407491794352 | (37.8022708995748, -122.407491794352) | |||
| 54336 | 54336 | 143505 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 11 Gerke Aly | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6010554.2854 | 2120185.3922 | 37.802219647583 | -122.40765301215599 | (37.802219647583, -122.407653012156) | |||
| 130351 | 130351 | 143504 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 3 Gerke Aly | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6010525.4571 | 2120179.6266 | 37.8022022028818 | -122.407752365718 | (37.8022022028818, -122.407752365718) | |||
| 182825 | 182825 | 142620 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1 Scotland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6009140.6951 | 2120065.1504 | 37.8018102626301 | -122.412536232083 | (37.8018102626301, -122.412536232083) | |||
| 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) | |||
| 74573 | 74573 | 142464 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1456 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010990.4041 | 2119956.0656 | 37.8016143761567 | -122.406127656852 | (37.8016143761567, -122.406127656852) | |||
| 136475 | 136475 | 142465 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1457 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010961.892000001 | 2119955.2575 | 37.8016105625065 | -122.406226265244 | (37.8016105625065, -122.406226265244) | |||
| 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) | ||
| 55708 | 55708 | 142468 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1455 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010964.6624 | 2119932.1708 | 37.801547327044894 | -122.40621505084299 | (37.8015473270449, -122.406215050843) | |||
| 146917 | 146917 | 142466 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1454 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010993.6362 | 2119929.285 | 37.8015410239646 | -122.40611458444599 | (37.8015410239646, -122.406114584446) | |||
| 29158 | 29158 | 142470 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1443 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6010970.8958 | 2119887.8443 | 37.8014259659921 | -122.406190355577 | (37.8014259659921, -122.406190355577) | |||
| 156290 | 156290 | 142471 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1439 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6010974.128 | 2119867.5279 | 37.8013703629213 | -122.406177738482 | (37.8013703629213, -122.406177738482) | |||
| 170251 | 170251 | 142629 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 725 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6009330.2372 | 2119895.0012 | 37.8013537106151 | -122.41186829545 | (37.8013537106151, -122.41186829545) | |||
| 180623 | 180623 | 142630 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 707 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6009347.3214 | 2119879.3022 | 37.8013115634868 | -122.411808066362 | (37.8013115634868, -122.411808066362) | |||
| 7042 | 7042 | 13093 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1450 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6005391.575 | 2119956.3245 | 37.8013003370098 | -122.42550219218 | (37.8013003370098, -122.42550219218) | |||
| 135505 | 135505 | 142472 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1429 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6010978.9762 | 2119829.6657 | 37.8012666737636 | -122.40615829244699 | (37.8012666737636, -122.406158292447) | |||
| 171052 | 171052 | 142473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1429 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6010981.054 | 2119812.8124 | 37.8012205149436 | -122.40614991427499 | (37.8012205149436, -122.406149914275) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 7470 | 7470 | 13111 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1599 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/1994 12:00:00 AM | 24 | 3X3 | 6004886.5048 | 2119803.0834 | 37.8008510262732 | -122.4272390368 | (37.8008510262732, -122.4272390368) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 2016 | 2016 | 13112 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1601 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 6004666.807 | 2119779.6281 | 37.800774197193796 | -122.42799761136001 | (37.8007741971938, -122.42799761136) | |||
| 3904 | 3904 | 4665 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 5X5 | 6009675.3838 | 2119664.5956 | 37.8007404309352 | -122.410657649881 | (37.8007404309352, -122.410657649881) | |||
| 1834 | 1834 | 13113 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1611 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6004587.0591 | 2119767.9005 | 37.8007374842012 | -122.428272736084 | (37.8007374842012, -122.428272736084) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 168607 | 168607 | 142488 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 651 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6009640.0611 | 2119612.4195 | 37.800595187798294 | -122.410776194648 | (37.8005951877983, -122.410776194648) | |||
| 130476 | 130476 | 142490 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 651 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6009644.6785 | 2119609.6491 | 37.8005878398576 | -122.41076002073 | (37.8005878398576, -122.41076002073) | |||
| 47321 | 47321 | 142489 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 651 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6009636.3672 | 2119608.7257 | 37.8005848384211 | -122.410788716085 | (37.8005848384211, -122.410788716085) | |||
| 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) | |||
| 152282 | 152282 | 142492 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 651 COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6009649.7576 | 2119605.0318 | 37.8005754466702 | -122.41074211863399 | (37.8005754466702, -122.410742118634) | |||
| 166089 | 166089 | 142491 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 651 COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6009641.4463 | 2119604.1083 | 37.8005724449635 | -122.410770813978 | (37.8005724449635, -122.410770813978) | |||
| 67407 | 67407 | 142493 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 651 COLUMBUS AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6009645.6019 | 2119599.491 | 37.8005599999984 | -122.410756107582 | (37.8005599999984, -122.410756107582) | |||
| 1121 | 1121 | 13143 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1800 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6003680.9036 | 2119717.0807 | 37.8005466318744 | -122.431404778789 | (37.8005466318744, -122.431404778789) | |||
| 1528 | 1528 | 13126 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1701 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3X3 | 6004190.6649 | 2119706.135 | 37.8005454550984 | -122.42964001675399 | (37.8005454550984, -122.429640016754) | |||
| 150761 | 150761 | 142496 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 523 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6010454.4069 | 2119574.2954 | 37.800536134500106 | -122.40795552251998 | (37.8005361345001, -122.40795552252) | |||
| 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) | |||
| 137082 | 137082 | 62689 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 523 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1986 12:00:00 AM | 14 | Permit Number 23025 | 6010433.276000001 | 2119569.2907 | 37.8005212097535 | -122.408028291205 | (37.8005212097535, -122.408028291205) | ||
| 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) | |||
| 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) | |||
| 146640 | 146640 | 142920 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1339 KEARNY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6011019.5196 | 2119515.0732 | 37.800405147287 | -122.405995819069 | (37.800405147287, -122.405995819069) | |||
| 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) | |||
| 25206 | 25206 | 98347 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1331 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6011023.1341 | 2119487.8255 | 37.800330533908294 | -122.40598139081999 | (37.8003305339083, -122.40598139082) | |||
| 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) | |||
| 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) | |||
| 159721 | 159721 | 13194 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2098 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002438.8321 | 2119544.8156 | 37.8000031649019 | -122.435690512961 | (37.8000031649019, -122.435690512961) | |||
| 157733 | 157733 | 143124 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1997 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002936.4047 | 2119532.9834 | 37.7999989264566 | -122.43396787786999 | (37.7999989264566, -122.43396787787) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 2056 | 2056 | 143141 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2140 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 0ft | 6002153.6152 | 2119503.7145 | 37.7998741075374 | -122.436674526744 | (37.7998741075374, -122.436674526744) | |||
| 2052 | 2052 | 143142 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2140 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6002105.6639 | 2119495.6188 | 37.7998491537216 | -122.43683987606899 | (37.7998491537216, -122.436839876069) | |||
| 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) | |||
| 153827 | 153827 | 143126 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2055 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002559.0217 | 2119480.0502 | 37.7998321621177 | -122.43526997659201 | (37.7998321621177, -122.435269976592) | |||
| 2054 | 2054 | 143144 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2150 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6002035.2938 | 2119489.3913 | 37.799828054976395 | -122.437082936374 | (37.7998280549764, -122.437082936374) | |||
| 8594 | 8594 | 13185 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2055X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002536.6029 | 2119475.0682 | 37.7998172097056 | -122.435347197327 | (37.7998172097056, -122.435347197327) | |||
| 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) | |||
| 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) | |||
| 59693 | 59693 | 143145 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2190 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6001985.4743 | 2119482.5412 | 37.7998064144784 | -122.437254839351 | (37.7998064144784, -122.437254839351) | |||
| 26256 | 26256 | 142499 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 521 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6009964.3012 | 2119317.683 | 37.7998040885057 | -122.40963337214 | (37.7998040885057, -122.40963337214) | |||
| 44977 | 44977 | 143125 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2095 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002486.7834 | 2119470.7090000003 | 37.799802411097296 | -122.435519279075 | (37.7998024110973, -122.435519279075) |
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");