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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 21140 | 21140 | 28785 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 800 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002281.4779 | 2109178.7673 | 37.7715316982304 | -122.435493052551 | (37.7715316982304, -122.435493052551) | |||
| 22051 | 22051 | 28786 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 800 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002265.8749 | 2109178.7673 | 37.7715308120493 | -122.43554702410299 | (37.7715308120493, -122.435547024103) | |||
| 151231 | 151231 | 54831 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 79 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/1972 12:00:00 AM | 8 | Permit Number 10685 | 6000087.3282 | 2112805.9967 | 37.781366286141896 | -122.443343289517 | (37.7813662861419, -122.443343289517) | ||
| 136175 | 136175 | 140775 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 79 TERRA VISTA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000103.2341 | 2112808.3657 | 37.781373697827796 | -122.443288433233 | (37.7813736978278, -122.443288433233) | |||
| 18612 | 18612 | 16974 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 785 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003248.3505 | 2109954.9799 | 37.7737178528926 | -122.43220403261299 | (37.7737178528926, -122.432204032613) | |||
| 21063 | 21063 | 16972 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 780 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003244.9501 | 2110008.9107 | 37.7738657407699 | -122.43221964740499 | (37.7738657407699, -122.432219647405) | |||
| 21454 | 21454 | 16971 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 780 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003271.9397 | 2110011.5439 | 37.7738745011261 | -122.43212647411501 | (37.7738745011261, -122.432126474115) | |||
| 17134 | 17134 | 16973 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 779 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003283.5334 | 2109961.2453 | 37.773737050882396 | -122.432082777045 | (37.7737370508824, -122.432082777045) | |||
| 149998 | 149998 | 248465 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 772 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997147.6982 | 2107925.2578 | 37.767796974534605 | -122.45316047633601 | (37.7677969745346, -122.453160476336) | |||
| 132110 | 132110 | 119622 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 77 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6000135.3841 | 2112812.4267 | 37.781386681539395 | -122.44317750199 | (37.7813866815394, -122.44317750199) | ||||
| 24233 | 24233 | 140776 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 77 TERRA VISTA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000147.5673 | 2112813.1036 | 37.7813892348129 | -122.443135402805 | (37.7813892348129, -122.443135402805) | |||
| 34800 | 34800 | 140777 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 77 TERRA VISTA AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000158.3968 | 2112814.4573 | 37.7813935692054 | -122.44309803536699 | (37.7813935692054, -122.443098035367) | |||
| 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) | |||
| 41329 | 41329 | 248473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 758 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5998609.6056 | 2107900.123 | 37.7678116388378 | -122.448102124294 | (37.7678116388378, -122.448102124294) | |||
| 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) | ||
| 20998 | 20998 | 16964 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 747 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6003424.2649 | 2109979.0777 | 37.7737939919852 | -122.431597238278 | (37.7737939919852, -122.431597238278) | |||
| 5353 | 5353 | 7166 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 745 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003498.9011 | 2110946.3415 | 37.7764540897977 | -122.43140812270599 | (37.7764540897977, -122.431408122706) | |||
| 68579 | 68579 | 138831 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 745 BUCHANAN ST | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 6004451.1778 | 2111098.9724 | 37.7769271009021 | -122.428124806353 | (37.7769271009021, -122.428124806353) | |||
| 18389 | 18389 | 16963 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 741 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003456.556 | 2109979.0777 | 37.7737958222062 | -122.43148553825701 | (37.7737958222062, -122.431485538257) | |||
| 2005 | 2005 | 7164 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 733 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003503.3323 | 2110918.6468 | 37.7763782981407 | -122.43139081647399 | (37.7763782981407, -122.431390816474) | |||
| 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) | |||
| 22087 | 22087 | 16962 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 729 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003498.0043 | 2109990.6447 | 37.7738299314263 | -122.431342987883 | (37.7738299314263, -122.431342987883) | |||
| 6715 | 6715 | 7162 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 727 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003506.9326 | 2110884.8593 | 37.7762857300682 | -122.43137594955499 | (37.7762857300682, -122.431375949555) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 146529 | 146529 | 247337 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 719 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003076.0904 | 2109591.4739 | 37.7727099867472 | -122.43277393402501 | (37.7727099867472, -122.432773934025) | |||
| 45465 | 45465 | 244323 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 719 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003563.5505 | 2110000.7658 | 37.7738614359578 | -122.431116975625 | (37.7738614359578, -122.431116975625) | |||
| 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) | |||
| 130045 | 130045 | 244324 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 717 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003593.9138 | 2110004.6215 | 37.7738737432923 | -122.43101221930401 | (37.7738737432923, -122.431012219304) | |||
| 132885 | 132885 | 138978 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 716 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003068.5257 | 2110892.0599 | 37.7762806451334 | -122.43289303328599 | (37.7762806451334, -122.432893033286) | |||
| 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) | ||
| 180054 | 180054 | 138979 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 714 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003072.403 | 2110865.473 | 37.7762078640198 | -122.432877720829 | (37.7762078640198, -122.432877720829) | |||
| 160111 | 160111 | 138980 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 712 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003074.6186 | 2110844.4251 | 37.776150197374896 | -122.43286855246201 | (37.7761501973749, -122.432868552462) | |||
| 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) | |||
| 181834 | 181834 | 94582 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 710 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4.5x5 | 6003079.6036 | 2110819.4999 | 37.7760820416979 | -122.432849526968 | (37.7760820416979, -122.432849526968) | |||
| 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) | |||
| 185073 | 185073 | 140702 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 710 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003550.9915 | 2110923.9408 | 37.776395535095 | -122.43122632799 | (37.776395535095, -122.43122632799) | |||
| 7064 | 7064 | 7154 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 709 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003520.226 | 2110798.7288 | 37.776049990393 | -122.431323814363 | (37.776049990393, -122.431323814363) | |||
| 59081 | 59081 | 140207 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 708 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003566.9815 | 2110815.4028 | 37.7760984227119 | -122.431163265184 | (37.7760984227119, -122.431163265184) | |||
| 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) | |||
| 183556 | 183556 | 140208 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 706 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003562.1361 | 2110838.1764 | 37.7761606788099 | -122.43118165261002 | (37.7761606788099, -122.43118165261) | |||
| 183850 | 183850 | 248348 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 706 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997944.2901 | 2108144.5061 | 37.7684445974615 | -122.45042098016701 | (37.7684445974615, -122.450420980167) | |||
| 37976 | 37976 | 140209 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 704 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003553.8988 | 2110879.8473 | 37.7762746300025 | -122.431213122749 | (37.7762746300025, -122.431213122749) | |||
| 132537 | 132537 | 55484 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 701 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 18 | Permit Number 11437 | 6002049.3973 | 2110903.3005 | 37.7762536529278 | -122.43641927844601 | (37.7762536529278, -122.436419278446) | ||
| 52969 | 52969 | 248377 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 701 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5997902.4997 | 2108143.1434 | 37.7684384639657 | -122.45056543049401 | (37.7684384639657, -122.450565430494) | |||
| 131399 | 131399 | 248376 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 701 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5997900.3799 | 2108160.4046 | 37.7684857374838 | -122.45057400725 | (37.7684857374838, -122.45057400725) | |||
| 33304 | 33304 | 248365 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 701 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998521.6337 | 2108231.8723 | 37.7687175089215 | -122.44843030114201 | (37.7687175089215, -122.448430301142) | |||
| 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) | |||
| 38816 | 38816 | 246090 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5997084.5583 | 2108373.7477 | 37.769024793611 | -122.45341125296001 | (37.769024793611, -122.45341125296) | |||
| 46704 | 46704 | 246095 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997104.5451 | 2108242.017 | 37.768664240613205 | -122.45333260848801 | (37.7686642406132, -122.453332608488) | |||
| 64636 | 64636 | 246098 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997112.7214 | 2108174.1833 | 37.7684784553517 | -122.45329942957198 | (37.7684784553517, -122.453299429572) | |||
| 133245 | 133245 | 246094 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997100.0026 | 2108265.6377 | 37.7687288366145 | -122.453350026115 | (37.7687288366145, -122.453350026115) | |||
| 150865 | 150865 | 246100 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997118.778 | 2108135.4212 | 37.7683723717283 | -122.453275681682 | (37.7683723717283, -122.453275681682) | |||
| 154687 | 154687 | 246093 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997094.8545 | 2108310.1536 | 37.7688507707463 | -122.453371047271 | (37.7688507707463, -122.453371047271) | |||
| 155231 | 155231 | 246099 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997115.1441 | 2108154.4994 | 37.7684245472814 | -122.453289628456 | (37.7684245472814, -122.453289628456) | |||
| 161629 | 161629 | 246091 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5997087.5866 | 2108354.0638 | 37.7689709202682 | -122.45339935697099 | (37.7689709202682, -122.453399356971) | |||
| 167223 | 167223 | 246096 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997106.9677 | 2108216.5794 | 37.768594534360204 | -122.453322392223 | (37.7685945343602, -122.453322392223) | |||
| 180852 | 180852 | 246097 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997110.2988 | 2108193.2616 | 37.7685307006045 | -122.45330918662901 | (37.7685307006045, -122.453309186629) | |||
| 187956 | 187956 | 246092 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997091.8262 | 2108330.4431 | 37.7689063069149 | -122.45338298694901 | (37.7689063069149, -122.453382986949) | |||
| 53658 | 53658 | 138867 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 STEINER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003082.3731 | 2110792.3591 | 37.7760076768733 | -122.43283800718399 | (37.7760076768733, -122.432838007184) | |||
| 132858 | 132858 | 138866 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 STEINER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003084.5886 | 2110775.7422 | 37.7759621766443 | -122.43282915583401 | (37.7759621766443, -122.432829155834) | |||
| 163992 | 163992 | 138865 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 STEINER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003091.7893 | 2110720.9068 | 37.775812020633005 | -122.432800328558 | (37.775812020633, -122.432800328558) | |||
| 188189 | 188189 | 138864 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003093.4509 | 2110708.1672 | 37.7757771350892 | -122.43279367037901 | (37.7757771350892, -122.432793670379) | |||
| 29701 | 29701 | 138739 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999270.4631 | 2114185.9407 | 37.7851086382869 | -122.446268530298 | (37.7851086382869, -122.446268530298) | |||
| 40459 | 40459 | 138740 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 PRESIDIO AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999265.5073 | 2114223.1094 | 37.7852104108131 | -122.44628835045299 | (37.7852104108131, -122.446288350453) | |||
| 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) | |||
| 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) | |||
| 51172 | 51172 | 141777 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 7 Hollis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003915.306 | 2113275.4592 | 37.7828728597693 | -122.43013385606702 | (37.7828728597693, -122.430133856067) | |||
| 33458 | 33458 | 244504 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 697 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003691.552 | 2110018.3364 | 37.773916933054 | -122.430675451783 | (37.773916933054, -122.430675451783) | |||
| 523 | 523 | 247328 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 696X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6003691.2873 | 2110070.3794 | 37.774059815342795 | -122.430680081912 | (37.7740598153428, -122.430680081912) | |||
| 58025 | 58025 | 244505 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 691 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003712.7095 | 2110021.2984 | 37.7739262645997 | -122.430602475909 | (37.7739262645997, -122.430602475909) | |||
| 174864 | 174864 | 64376 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 69 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1988 12:00:00 AM | 11 | Permit Number 25215 | 5996673.1599 | 2112554.0417 | 37.7804791997483 | -122.45513636713801 | (37.7804791997483, -122.455136367138) | ||
| 183117 | 183117 | 246173 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 675 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997888.1153 | 2108243.3798 | 37.768712864196 | -122.45062241217899 | (37.768712864196, -122.450622412179) | |||
| 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) | ||
| 76232 | 76232 | 140214 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 668 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003589.5295 | 2110658.3502 | 37.7756684727789 | -122.43107405366001 | (37.7756684727789, -122.43107405366) | |||
| 62593 | 62593 | 246085 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 668 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999025.5413 | 2108408.7245 | 37.769231898011896 | -122.44670005643101 | (37.7692318980119, -122.446700056431) | |||
| 64852 | 64852 | 103460 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 666 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 7x7 | 6005392.6099 | 2111621.0092 | 37.7784137063831 | -122.424905251399 | (37.7784137063831, -122.424905251399) | |||
| 170210 | 170210 | 57646 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 666 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1981 12:00:00 AM | 16 | 7x7 | Permit Number 19439 | 6005402.5793 | 2111576.4092 | 37.7782918087921 | -122.424867589608 | (37.7782918087921, -122.424867589608) | |
| 136566 | 136566 | 246132 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 662 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998549.1912 | 2108336.0455 | 37.7690051176051 | -122.448342484944 | (37.7690051176051, -122.448342484944) | |||
| 150342 | 150342 | 246133 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 662 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998546.7685 | 2108359.3633 | 37.7690690038469 | -122.44835254426701 | (37.7690690038469, -122.448352544267) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 43832 | 43832 | 138987 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003459.8516 | 2110684.9037 | 37.7757340330654 | -122.43152453742701 | (37.7757340330654, -122.431524537427) | |||
| 62338 | 62338 | 246145 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998507.7036 | 2108329.6861 | 37.768985284301706 | -122.448485529275 | (37.7689852843017, -122.448485529275) | |||
| 152180 | 152180 | 140213 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 658 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003592.9683 | 2110633.2956 | 37.775599873891295 | -122.43106036937901 | (37.7755998738913, -122.431060369379) | |||
| 45497 | 45497 | 72023 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 655 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1989 12:00:00 AM | 12 | 6010509.9754 | 2116460.1743 | 37.7919886256319 | -122.40754355100599 | (37.7919886256319, -122.407543551006) | ||
| 106229 | 106229 | 143475 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 655 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010503.0699 | 2116501.51 | 37.7921017369748 | -122.407570359871 | (37.7921017369748, -122.407570359871) |
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");