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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 6970 | 6970 | 6245 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1280 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6004753.0279 | 2113338.633 | 37.7830937301366 | -122.427240188063 | (37.7830937301366, -122.427240188063) | ||
| 7032 | 7032 | 6224 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1220 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6005090.9413 | 2113387.3731 | 37.7832466624445 | -122.42607461530899 | (37.7832466624445, -122.426074615309) | |||
| 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) | |||
| 7090 | 7090 | 21632 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1615 Sutter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/04/1991 12:00:00 AM | 12 | 4X4 | 6004741.4911 | 2114677.6404 | 37.7867696583856 | -122.42737551849501 | (37.7867696583856, -122.427375518495) | ||
| 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) | |||
| 7192 | 7192 | 21587 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005314.2609 | 2114809.1294 | 37.787163071612795 | -122.42540322917601 | (37.7871630716128, -122.425403229176) | |||
| 7225 | 7225 | 21740 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2045 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002881.8287 | 2114415.6319 | 37.7859448981022 | -122.433790771597 | (37.7859448981022, -122.433790771597) | |||
| 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) | |||
| 7298 | 7298 | 7263 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1730 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003079.0359 | 2114300.077 | 37.785638802077706 | -122.433100230123 | (37.7856388020777, -122.433100230123) | |||
| 7334 | 7334 | 12265 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 646 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004962.1321 | 2111217.4355 | 37.7772812673791 | -122.42636569465401 | (37.7772812673791, -122.426365694654) | |||
| 7382 | 7382 | 2590 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1712 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 6005179.844 | 2115138.5122 | 37.788059879281505 | -122.42589173782301 | (37.7880598792815, -122.425891737823) | |||
| 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) | ||
| 7444 | 7444 | 7160 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 722 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6003546.1461 | 2110964.1580000003 | 37.7765056869903 | -122.43124596095899 | (37.7765056869903, -122.431245960959) | |||
| 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) | ||
| 7483 | 7483 | 7265 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1740 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003066.7944 | 2114355.8984 | 37.78579137911579 | -122.433146572029 | (37.7857913791158, -122.433146572029) | |||
| 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) | |||
| 7509 | 7509 | 23794 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1125 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003750.8632 | 2112612.5515 | 37.7810433657763 | -122.43065544025299 | (37.7810433657763, -122.430655440253) | |||
| 7525 | 7525 | 7159 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 719 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003516.9027 | 2110817.5612 | 37.7761015111675 | -122.431336655161 | (37.7761015111675, -122.431336655161) | |||
| 7583 | 7583 | 6242 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1250 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6004855.4094 | 2113352.7921 | 37.783138396913294 | -122.426886998286 | (37.7831383969133, -122.426886998286) | ||
| 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) | |||
| 7644 | 7644 | 7201 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 949 Fillmore St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003424.6737 | 2111504.3754 | 37.7779821053868 | -122.431704747493 | (37.7779821053868, -122.431704747493) | |||
| 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) | |||
| 7706 | 7706 | 21589 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005274.899 | 2114802.7621 | 37.7871433646236 | -122.425538959573 | (37.7871433646236, -122.425538959573) | |||
| 7736 | 7736 | 20147 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1025 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 12 | 3x3 | 6002893.7013 | 2111823.32 | 37.778827735903604 | -122.433564367127 | (37.7788277359036, -122.433564367127) | ||
| 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) | |||
| 7868 | 7868 | 4605 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 270 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6010895.3992 | 2118554.4574 | 37.7977605876582 | -122.40635760441799 | (37.7977605876582, -122.406357604418) | |||
| 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) | |||
| 8007 | 8007 | 12247 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 503 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004991.7276 | 2110673.0436 | 37.7757881731565 | -122.42622454699699 | (37.7757881731565, -122.426224546997) | |||
| 8030 | 8030 | 10637 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 843 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003821.4079 | 2110734.0055 | 37.7758893402664 | -122.43027732793101 | (37.7758893402664, -122.430277327931) | ||
| 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) | |||
| 8075 | 8075 | 21657 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1725 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6004318.092999999 | 2114616.1002 | 37.7865767294467 | -122.428835987308 | (37.7865767294467, -122.428835987308) | |||
| 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) | ||
| 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) | |||
| 8268 | 8268 | 10636 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 843 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003811.0913 | 2110732.5317 | 37.7758847092198 | -122.430312910525 | (37.7758847092198, -122.430312910525) | ||
| 8290 | 8290 | 21710 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1900 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6003404.4442 | 2114543.7174 | 37.7863262303196 | -122.431991815976 | (37.7863262303196, -122.431991815976) | |||
| 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) | |||
| 8359 | 8359 | 7168 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 761 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003490.0388 | 2111001.7309 | 37.7766056731066 | -122.431442734929 | (37.7766056731066, -122.431442734929) | |||
| 8369 | 8369 | 7167 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 761 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003488.931 | 2111020.5633 | 37.776657319429 | -122.431447911846 | (37.776657319429, -122.431447911846) | |||
| 8428 | 8428 | 21739 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2045 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002859.7063 | 2114412.7642 | 37.785935768772 | -122.433867103908 | (37.785935768772, -122.433867103908) | |||
| 8479 | 8479 | 7161 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 726 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003541.3006 | 2110998.0762 | 37.7765985433792 | -122.431265144599 | (37.7765985433792, -122.431265144599) | |||
| 8536 | 8536 | 21588 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005294.0011 | 2114805.6563 | 37.7871523906748 | -122.42547307647301 | (37.7871523906748, -122.425473076473) | |||
| 8583 | 8583 | 21586 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005346.0976 | 2114810.866 | 37.7871696385608 | -122.425293204645 | (37.7871696385608, -122.425293204645) | |||
| 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) | |||
| 8655 | 8655 | 21608 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1531 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/1990 12:00:00 AM | 12 | 4X4 | 6005005.2261 | 2114710.5754 | 37.786875002060704 | -122.42646540299 | (37.7868750020607, -122.42646540299) | ||
| 8679 | 8679 | 21671 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1776 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6004100.5679 | 2114639.3689 | 37.7866283052779 | -122.429590230958 | (37.7866283052779, -122.429590230958) | |||
| 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) | |||
| 8894 | 8894 | 21590 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005256.9547 | 2114799.289 | 37.78713281444121 | -122.425600795702 | (37.7871328144412, -122.425600795702) | |||
| 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) | ||
| 8915 | 8915 | 10629 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 817 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003911.8012 | 2110745.3047 | 37.775925484701794 | -122.429965440473 | (37.7759254847018, -122.429965440473) | ||
| 8928 | 8928 | 7213 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 950 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003452.6284 | 2111644.2112 | 37.7783676442869 | -122.43161802827 | (37.7783676442869, -122.43161802827) | |||
| 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) | |||
| 9530 | 9530 | 12248 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 511 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004985.727999999 | 2110723.6115 | 37.775926681152896 | -122.42624890215599 | (37.7759266811529, -122.426248902156) | |||
| 9534 | 9534 | 8072 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 661 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005345.6576 | 2111619.4154 | 37.778406678029796 | -122.425067563729 | (37.7784066780298, -122.425067563729) | |||
| 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) | |||
| 10079 | 10079 | 492 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2749X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6010397.1581 | 2102215.0511 | 37.752868494158704 | -122.406929439613 | (37.7528684941587, -122.406929439613) | |||
| 10272 | 10272 | 531 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2847 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 3x3 | 6009825.6422 | 2102183.2205 | 37.752749097586296 | -122.408903610932 | (37.7527490975863, -122.408903610932) | |||
| 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) | ||
| 13519 | 13519 | 113149 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6010826.0688 | 2111360.9298 | 37.7780049945656 | -122.406090456701 | (37.7780049945656, -122.406090456701) | |||
| 14599 | 14599 | 7391 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/1992 12:00:00 AM | 30 | 3x3 | 6010784.4697 | 2111320.9947 | 37.77789301527721 | -122.40623154915001 | (37.7778930152772, -122.40623154915) | ||
| 14749 | 14749 | 7388 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6010798.3361 | 2111334.861 | 37.7779318645299 | -122.406184557349 | (37.7779318645299, -122.406184557349) | |||
| 14753 | 14753 | 7389 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6010809.9838 | 2111345.3995 | 37.7779614523005 | -122.406145006296 | (37.7779614523005, -122.406145006296) | |||
| 15556 | 15556 | 7384 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1026 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6010763.6701 | 2111388.108 | 37.7780761292824 | -122.406308232523 | (37.7780761292824, -122.406308232523) | |||
| 16043 | 16043 | 7390 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6010768.3847 | 2111305.4643 | 37.7778494726714 | -122.40628609857299 | (37.7778494726714, -122.406286098573) | |||
| 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) | |||
| 17085 | 17085 | 16938 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 595X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004175.1129 | 2110087.9596 | 37.7741354848182 | -122.42900769942301 | (37.7741354848182, -122.429007699423) | |||
| 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) | |||
| 17156 | 17156 | 16864 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 230 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005857.5291 | 2110371.9412 | 37.7750103183132 | -122.423208108745 | (37.7750103183132, -122.423208108745) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 17198 | 17198 | 538 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2860 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009651.0028 | 2102218.3979 | 37.7528359029411 | -122.409510030546 | (37.7528359029411, -122.409510030546) | |||
| 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) | |||
| 17292 | 17292 | 540 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2869 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6009646.1294 | 2102175.7647 | 37.75271856860871 | -122.409523875049 | (37.7527185686087, -122.409523875049) | |||
| 17307 | 17307 | 15307 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1650 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 3 | 4X4 | 6006881.466 | 2109048.7514 | 37.771434887034104 | -122.419572183108 | (37.7714348870341, -122.419572183108) | ||
| 17429 | 17429 | 529 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2833 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009902.781 | 2102188.0955 | 37.7527668038666 | -122.408637193736 | (37.7527668038666, -122.408637193736) | |||
| 17455 | 17455 | 519 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2802 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6009998.1456 | 2102238.5221 | 37.7529106047271 | -122.408310960592 | (37.7529106047271, -122.408310960592) | |||
| 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) | |||
| 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) | |||
| 17687 | 17687 | 9652 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 75 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 3 | 2x3 | 6006083.2108 | 2109791.7339 | 37.773429942464205 | -122.42238619158998 | (37.7734299424642, -122.42238619159) | ||
| 17778 | 17778 | 15435 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2141 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006881.4762 | 2105834.0306 | 37.7626080219354 | -122.419344056803 | (37.7626080219354, -122.419344056803) | |||
| 17799 | 17799 | 514 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2790 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6010107.5289 | 2102242.0067 | 37.752926297242205 | -122.407932936557 | (37.7529262972422, -122.407932936557) | |||
| 17957 | 17957 | 15626 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3550 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005569.6902 | 2097797.6263 | 37.7404679423018 | -122.42330974756901 | (37.7404679423018, -122.423309747569) | |||
| 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) | |||
| 18202 | 18202 | 16867 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 235 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x5 | 6005854.7098 | 2110323.2964 | 37.7748765923478 | -122.42321440275299 | (37.7748765923478, -122.423214402753) | |||
| 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) | |||
| 18224 | 18224 | 494 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2749X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6010448.7752 | 2102218.4922 | 37.752880830855496 | -122.40675117970801 | (37.7528808308555, -122.406751179708) | |||
| 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) | |||
| 18297 | 18297 | 513 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2792 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010090.1844 | 2102241.1856 | 37.752923071613495 | -122.40799285948499 | (37.7529230716135, -122.407992859485) | |||
| 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) | |||
| 18580 | 18580 | 497 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2749X 24th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6010516.451 | 2102220.2128 | 37.75288934158429 | -122.40651726425399 | (37.7528893415843, -122.406517264254) | |||
| 18610 | 18610 | 487 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2718 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010403.4669 | 2102258.6388 | 37.7529885293488 | -122.406910694342 | (37.7529885293488, -122.406910694342) |
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");