Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qCaretaker, PlantDate, DBH, PlotSize
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18907 | 18907 | 481 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2700 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010503.8335 | 2102264.9476 | 37.753011467555204 | -122.406564050249 | (37.7530114675552, -122.406564050249) | |||
| 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) | |||
| 21717 | 21717 | 491 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2749X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6010371.9231 | 2102214.4775 | 37.7528655070754 | -122.40701666692699 | (37.7528655070754, -122.407016666927) | |||
| 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) | |||
| 20229 | 20229 | 493 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2749X 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6010421.2461 | 2102217.9187 | 37.752877715813796 | -122.406846340514 | (37.7528777158138, -122.406846340514) | |||
| 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) | |||
| 20426 | 20426 | 496 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2749X 24th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6010495.2306 | 2102220.2128 | 37.7528881543902 | -122.406590648723 | (37.7528881543902, -122.406590648723) | |||
| 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) | |||
| 18753 | 18753 | 498 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2752 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010250.9097 | 2102250.6095 | 37.7529579449469 | -122.40743770281999 | (37.7529579449469, -122.40743770282) | |||
| 20773 | 20773 | 501 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2754 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x5 | 6010215.9248 | 2102247.7419 | 37.7529481129231 | -122.40755848565901 | (37.7529481129231, -122.407558485659) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 19545 | 19545 | 520 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2809 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 5x5 | 6009957.8393 | 2102189.816 | 37.752774611473995 | -122.408446912653 | (37.752774611474, -122.408446912653) | |||
| 21970 | 21970 | 524 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2826 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6009890.4218 | 2102229.0519 | 37.752878568819796 | -122.408682823354 | (37.7528785688198, -122.408682823354) | |||
| 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) | |||
| 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) | |||
| 22134 | 22134 | 532 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2850 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009709.5998 | 2102220.1735 | 37.7528440615121 | -122.409307515735 | (37.7528440615121, -122.409307515735) | |||
| 19043 | 19043 | 533 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2850 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009680.0053 | 2102218.3979 | 37.7528375279845 | -122.409409734124 | (37.7528375279845, -122.409409734124) | |||
| 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) | |||
| 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) | |||
| 21819 | 21819 | 544 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2872 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009585.3031 | 2102212.4790000003 | 37.752815969417206 | -122.409736815429 | (37.7528159694172, -122.409736815429) | |||
| 19398 | 19398 | 547 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2889 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009603.6887 | 2102171.1765 | 37.7527035922626 | -122.409670319384 | (37.7527035922626, -122.409670319384) | |||
| 19885 | 19885 | 549 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2899 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009532.5718 | 2102167.7354 | 37.7526901583127 | -122.40991601243401 | (37.7526901583127, -122.409916012434) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 23286 | 23286 | 4726 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1075 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 6008251.3021 | 2120879.6119999997 | 37.803996615927794 | -122.41567165532301 | (37.8039966159278, -122.415671655323) | ||||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 2225 | 2225 | 7163 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 730 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3X3 | 6003538.8779 | 2111021.3343 | 37.776662267069895 | -122.43127518600001 | (37.7766622670699, -122.431275186) | |||
| 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) | |||
| 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) | |||
| 1343 | 1343 | 7169 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003470.3756 | 2111160.9753 | 37.777041804334296 | -122.43152212680799 | (37.7770418043343, -122.431522126808) | ||
| 1345 | 1345 | 7170 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003473.1451 | 2111141.589 | 37.776988731328295 | -122.43151116193 | (37.7769887313283, -122.43151116193) | ||
| 1336 | 1336 | 7171 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003475.9145 | 2111120.5411 | 37.7769310959731 | -122.431500078765 | (37.7769310959731, -122.431500078765) | ||
| 1340 | 1340 | 7172 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003478.683999999 | 2111101.7087 | 37.7768795438362 | -122.43148915347099 | (37.7768795438362, -122.431489153471) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 1759 | 1759 | 7200 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 949 Fillmore St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003420.9887 | 2111521.8792 | 37.7780299575939 | -122.431718745255 | (37.7780299575939, -122.431718745255) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 23207 | 23207 | 7224 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1234X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 6003339.1357 | 2111756.6534 | 37.778669949054 | -122.432018673024 | (37.778669949054, -122.432018673024) | ||||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 1120 | 1120 | 7264 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1730 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003073.6496 | 2114318.6841 | 37.78568958693 | -122.43312019509199 | (37.78568958693, -122.433120195092) | |||
| 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) | |||
| 1072 | 1072 | 7266 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1740 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 4X4 | 6003064.3461 | 2114369.1192 | 37.7858275412041 | -122.433155987425 | (37.7858275412041, -122.433155987425) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 20511 | 20511 | 10259 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 180 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6005281.5755 | 2109598.2125 | 37.772853326524896 | -122.425145392536 | (37.7728533265249, -122.425145392536) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 911 | 911 | 12249 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 511 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004989.1563 | 2110705.1842 | 37.7758762780635 | -122.42623573054199 | (37.7758762780635, -122.426235730542) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");