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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22559 | 22559 | 9075 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 5612 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5989561.9341 | 2112697.6008 | 37.7804628284507 | -122.47974767842399 | (37.7804628284507, -122.479747678424) | |||
| 22784 | 22784 | 9074 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 5612 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5989576.4513 | 2112697.6008 | 37.780463671789 | -122.47969745716499 | (37.780463671789, -122.479697457165) | |||
| 22715 | 22715 | 9008 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 5255 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 5990650.4547 | 2112633.3493 | 37.7803495870008 | -122.475977319009 | (37.7803495870008, -122.475977319009) | |||
| 17676 | 17676 | 25267 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1738 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 5994656.4814 | 2092369.8948 | 37.7249427634406 | -122.46064985933901 | (37.7249427634406, -122.460649859339) | |||
| 18821 | 18821 | 25266 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1738 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 5994668.335 | 2092363.0322 | 37.7249246023662 | -122.460608386003 | (37.7249246023662, -122.460608386003) | |||
| 20249 | 20249 | 25265 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1738 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5994685.8034 | 2092359.9129 | 37.7249170424989 | -122.46054777423099 | (37.7249170424989, -122.460547774231) | |||
| 7961 | 7961 | 28067 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3445 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5996427.4656 | 2112840.3465 | 37.7812512181791 | -122.456007038851 | (37.7812512181791, -122.456007038851) | |||
| 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) | |||
| 21345 | 21345 | 17138 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2049 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5997189.9355 | 2109110.6719 | 37.771054237387396 | -122.453099965702 | (37.7710542373874, -122.453099965702) | |||
| 21485 | 21485 | 17133 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2021 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5997314.265 | 2109127.7618 | 37.7711082865548 | -122.452671141791 | (37.7711082865548, -122.452671141791) | |||
| 21783 | 21783 | 17132 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2017 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5997337.3364 | 2109131.1798 | 37.7711189934376 | -122.45259158414301 | (37.7711189934376, -122.452591584143) | |||
| 21113 | 21113 | 17130 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2001 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5997372.7981 | 2109137.1613 | 37.7711374488605 | -122.45246935322399 | (37.7711374488605, -122.452469353224) | |||
| 19705 | 19705 | 17131 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2001 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5997393.7333 | 2109140.5793 | 37.771148033222794 | -122.452397184671 | (37.7711480332228, -122.452397184671) | |||
| 18803 | 18803 | 17128 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1999 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2003 12:00:00 AM | 12 | 3X3 | 5997486.4463 | 2109152.9695 | 37.7711873646815 | -122.452077382727 | (37.7711873646815, -122.452077382727) | ||
| 18301 | 18301 | 17129 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1999 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5997503.109 | 2109154.2513 | 37.7711918386222 | -122.452019838592 | (37.7711918386222, -122.452019838592) | |||
| 20349 | 20349 | 10509 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1792 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5997587.0634 | 2108527.2635 | 37.7694750996845 | -122.45168420313499 | (37.7694750996845, -122.451684203135) | |||
| 17018 | 17018 | 4509 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1807X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5998320.8634 | 2109271.3175 | 37.7715600792218 | -122.44919964223699 | (37.7715600792218, -122.449199642237) | |||
| 18044 | 18044 | 4510 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1805X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5998343.9349 | 2109273.4537 | 37.7715672642721 | -122.449119990901 | (37.7715672642721, -122.449119990901) | |||
| 17595 | 17595 | 17108 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1789 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5998462.7101 | 2109289.6892 | 37.7716186353865 | -122.448710312151 | (37.7716186353865, -122.448710312151) | |||
| 21546 | 21546 | 17107 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1781 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5998487.0633 | 2109292.2527 | 37.7716270666505 | -122.44862625802799 | (37.7716270666505, -122.448626258028) | |||
| 23341 | 23341 | 10463 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1584 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 5998533.6334 | 2108659.497 | 37.7698923436585 | -122.44841959455401 | (37.7698923436585, -122.448419594554) | |||
| 2207 | 2207 | 244533 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1588 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 0ft | 5998589.1758 | 2108666.333 | 37.7699142890018 | -122.448227967728 | (37.7699142890018, -122.448227967728) | |||
| 21929 | 21929 | 1652 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1701X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998816.4722 | 2109337.1138 | 37.7717690739196 | -122.44749004749399 | (37.7717690739196, -122.447490047494) | |||
| 19249 | 19249 | 17087 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1621 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5999187.9651 | 2109387.1019 | 37.7719275511448 | -122.446208630434 | (37.7719275511448, -122.446208630434) | |||
| 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) | |||
| 20300 | 20300 | 17086 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1611 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5999247.78 | 2109394.7924 | 37.771952083100295 | -122.446002280338 | (37.7719520831003, -122.446002280338) | |||
| 18240 | 18240 | 14585 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1206 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999464.9463 | 2108691.264 | 37.7700327707282 | -122.44520049918002 | (37.7700327707282, -122.44520049918) | |||
| 17168 | 17168 | 17084 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1575 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999487.0395 | 2109431.3054 | 37.772065998090895 | -122.445177292475 | (37.7720659980909, -122.445177292475) | |||
| 8195 | 8195 | 13291 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2671 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | 5999604.2969 | 2119102.6495 | 37.7986276847794 | -122.44546723704599 | (37.7986276847794, -122.445467237046) | |||
| 23190 | 23190 | 13311 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2973X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 5999715.5386 | 2114669.4924 | 37.7864617540071 | -122.44476348344801 | (37.7864617540071, -122.444763483448) | |||
| 8913 | 8913 | 13286 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2599 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/16/1993 12:00:00 AM | 12 | 3X3 | 6000047.9587 | 2119131.9019 | 37.7987333214715 | -122.443934134594 | (37.7987333214715, -122.443934134594) | ||
| 18854 | 18854 | 17070 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1419 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000207.1415 | 2109530.5209 | 37.7723794951397 | -122.442693535131 | (37.7723794951397, -122.442693535131) | |||
| 19368 | 19368 | 17069 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1407 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000238.3853 | 2109534.8419 | 37.7723931405508 | -122.442585770509 | (37.7723931405508, -122.442585770509) | |||
| 2903 | 2903 | 13280 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2524 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/15/1993 12:00:00 AM | 40 | 3X3 | 6000256.3025 | 2119240.7621 | 37.7990441048198 | -122.44322102307699 | (37.7990441048198, -122.443221023077) | ||
| 8872 | 8872 | 18050 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2832 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000363.8297 | 2114817.6224 | 37.7869054550264 | -122.442531204238 | (37.7869054550264, -122.442531204238) | |||
| 7121 | 7121 | 18036 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2807 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000406.6253 | 2114762.207 | 37.7867557380075 | -122.44237916186701 | (37.7867557380075, -122.442379161867) | |||
| 19910 | 19910 | 17068 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1369 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000465.401000001 | 2109559.9366 | 37.7724749822064 | -122.441802305278 | (37.7724749822064, -122.441802305278) | |||
| 17107 | 17107 | 17067 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1355 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000506.9486 | 2109572.2346 | 37.772511116707605 | -122.441659471159 | (37.7725111167076, -122.441659471159) | |||
| 8032 | 8032 | 18023 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2729 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000744.2415 | 2114813.5523 | 37.786915956134294 | -122.44121477806101 | (37.7869159561343, -122.441214778061) | |||
| 296 | 296 | 18021 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2725 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000769.3896 | 2114817.5231 | 37.78692829139071 | -122.44112805661501 | (37.7869282913907, -122.441128056615) | |||
| 10070 | 10070 | 18018 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2718 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000772.0 | 2114884.0 | 37.7871109684575 | -122.44112379643299 | (37.7871109684575, -122.441123796433) | |||
| 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) | |||
| 21314 | 21314 | 17056 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1285 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x4.5 | 6000853.6213 | 2109624.5846 | 37.7726746024779 | -122.44046405381799 | (37.7726746024779, -122.440464053818) | |||
| 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) | |||
| 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) | |||
| 18203 | 18203 | 17058 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1285 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000917.1059 | 2109633.5588 | 37.7727028580257 | -122.44024509796301 | (37.7727028580257, -122.440245097963) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 7489 | 7489 | 22786 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1885 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001038.3513 | 2112073.2703 | 37.7794085922078 | -122.440000666135 | (37.7794085922078, -122.440000666135) | |||
| 20305 | 20305 | 17050 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1225 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001073.9894 | 2109656.1607 | 37.7727738479618 | -122.43970404277201 | (37.7727738479618, -122.439704042772) | |||
| 3729 | 3729 | 18005 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2683 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001144.5248 | 2114870.2639 | 37.787094464568796 | -122.43983396035101 | (37.7870944645688, -122.439833960351) | |||
| 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) | |||
| 11043 | 11043 | 15768 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 4770 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 15 | 3x3 | 6001444.506 | 2091085.1877 | 37.721803449313896 | -122.437092531149 | (37.7218034493139, -122.437092531149) | ||
| 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) | |||
| 23064 | 23064 | 13226 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2265 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 6001595.9478 | 2119347.0943 | 37.7994123621689 | -122.438593032687 | (37.7994123621689, -122.438593032687) | ||||
| 17192 | 17192 | 17024 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1101 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001643.357000001 | 2109735.2672 | 37.7730234456568 | -122.437740206634 | (37.7730234456568, -122.437740206634) | |||
| 8969 | 8969 | 8181 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1212 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6001826.5111 | 2111197.1465 | 37.7770478129311 | -122.43721134601002 | (37.7770478129311, -122.43721134601) | |||
| 17194 | 17194 | 5146 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 217 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001830.6224 | 2108865.7235 | 37.7706465411236 | -122.437030167851 | (37.7706465411236, -122.437030167851) | |||
| 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) | |||
| 21361 | 21361 | 7023 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1115 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002035.3214 | 2110135.6586 | 37.7741451002744 | -122.43641301713801 | (37.7741451002744, -122.436413017138) | |||
| 21210 | 21210 | 19218 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1103X Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002097.9849 | 2110143.8576 | 37.7741711731344 | -122.43619684024799 | (37.7741711731344, -122.436196840248) | |||
| 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) | |||
| 20516 | 20516 | 19219 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1101X Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002112.0403 | 2110145.6145 | 37.774176795696995 | -122.436148345951 | (37.774176795697, -122.436148345951) | |||
| 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) | |||
| 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) | |||
| 1462 | 1462 | 247381 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1001 Oak St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 0ft | 6002208.0 | 2109818.0 | 37.7732826991746 | -122.43579295981199 | (37.7732826991746, -122.435792959812) | |||
| 1466 | 1466 | 247380 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1001 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6002208.0 | 2109818.0 | 37.7732826991746 | -122.43579295981199 | (37.7732826991746, -122.435792959812) | |||
| 1468 | 1468 | 247377 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1001 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 0ft | 6002208.0 | 2109818.0 | 37.7732826991746 | -122.43579295981199 | (37.7732826991746, -122.435792959812) | |||
| 8120 | 8120 | 17670 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1015X Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/15/1995 12:00:00 AM | 12 | 3X3 | 6002378.1109 | 2112076.6861 | 37.7794941484605 | -122.435366123882 | (37.7794941484605, -122.435366123882) | ||
| 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) | ||
| 2890 | 2890 | 17680 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1020 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002416.7239 | 2112103.0842 | 37.7795688238035 | -122.43523443397801 | (37.7795688238035, -122.435234433978) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 1463 | 1463 | 13191 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2095 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002470.5921 | 2119469.4635 | 37.7997980716779 | -122.43557521775601 | (37.7997980716779, -122.435575217756) | |||
| 7852 | 7852 | 14863 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1398 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6002510.6756 | 2111638.0989 | 37.77829742557871 | -122.434876152922 | (37.7782974255787, -122.434876152922) | |||
| 1838 | 1838 | 9642 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1482 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 6002517.4506 | 2111986.4237 | 37.7792542228164 | -122.43487763237101 | (37.7792542228164, -122.434877632371) | |||
| 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) | |||
| 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) | |||
| 8320 | 8320 | 9641 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1482 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002541.4785 | 2111991.5 | 37.77926952525671 | -122.434794873127 | (37.7792695252567, -122.434794873127) | |||
| 19445 | 19445 | 16994 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 900 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002602.5998 | 2109922.2867 | 37.7735914513761 | -122.434435444699 | (37.7735914513761, -122.434435444699) | |||
| 230 | 230 | 138371 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 0ft | 6002611.3346 | 2114434.4469999997 | 37.785981206770394 | -122.434727951803 | (37.7859812067704, -122.434727951803) | |||
| 273 | 273 | 20166 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1155X Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4X4 | 6002621.0 | 2112212.0 | 37.7798794773869 | -122.43453554599199 | (37.7798794773869, -122.434535545992) | |||
| 17284 | 17284 | 16993 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 900 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002625.7759 | 2109923.0859 | 37.7735949613156 | -122.434355332323 | (37.7735949613156, -122.434355332323) | |||
| 20899 | 20899 | 16992 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 900 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 1x1 | 6002640.9603 | 2109924.6842 | 37.773600211727 | -122.434302921546 | (37.773600211727, -122.434302921546) | |||
| 211 | 211 | 138370 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6002647.5104 | 2114436.9248 | 37.7859900638921 | -122.434602970779 | (37.7859900638921, -122.434602970779) | |||
| 192 | 192 | 138369 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6002665.8461 | 2114439.4026 | 37.78599790817471 | -122.434539711553 | (37.7859979081747, -122.434539711553) | |||
| 188 | 188 | 138368 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6002679.2262 | 2114443.3671 | 37.786009553218996 | -122.434493703661 | (37.786009553219, -122.434493703661) | |||
| 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) | |||
| 201 | 201 | 138367 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 0ft | 6002691.6152 | 2114444.3582 | 37.7860129777854 | -122.434450912019 | (37.7860129777854, -122.434450912019) | |||
| 217 | 217 | 138366 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 0ft | 6002708.9598 | 2114445.3493 | 37.7860166836287 | -122.43439097535801 | (37.7860166836287, -122.434390975358) | |||
| 7601 | 7601 | 9631 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1439 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002709.6742 | 2111961.3805 | 37.7791963723972 | -122.434210861246 | (37.7791963723972, -122.434210861246) | |||
| 7272 | 7272 | 14849 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1344 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002734.6717 | 2111669.6476 | 37.7783967656122 | -122.43410352432501 | (37.7783967656122, -122.434103524325) | |||
| 21377 | 21377 | 16990 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 899 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002737.3984 | 2109886.1011 | 37.773499745425795 | -122.43396656947701 | (37.7734997454258, -122.433966569477) | |||
| 18945 | 18945 | 17664 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 892X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002741.8184 | 2109937.0039 | 37.773639762745 | -122.433954919315 | (37.773639762745, -122.433954919315) | |||
| 195 | 195 | 138365 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 0ft | 6002748.6045 | 2114451.296 | 37.78603526200121 | -122.43425424087799 | (37.7860352620012, -122.434254240878) | |||
| 7675 | 7675 | 2728 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2250 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002761.9846 | 2114804.6298 | 37.7870061862481 | -122.43423321856899 | (37.7870061862481, -122.434233218569) | |||
| 17157 | 17157 | 16991 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 899 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002773.5007 | 2109890.2869 | 37.7735132873347 | -122.433841985714 | (37.7735132873347, -122.433841985714) | |||
| 216 | 216 | 138364 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 0ft | 6002783.7892 | 2114453.2783 | 37.7860427018539 | -122.43413265320801 | (37.7860427018539, -122.434132653208) |
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");