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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 611 | 611 | 140070 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 601X Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005402.0 | 2111410.0 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | |||
| 1904 | 1904 | 245410 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2782 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6010125.3081 | 2102244.3008 | 37.752933591707794 | -122.40787161420401 | (37.7529335917078, -122.407871614204) | |||
| 3338 | 3338 | 138120 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1970 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003157.8417 | 2114507.235 | 37.7862120754355 | -122.432842389477 | (37.7862120754355, -122.432842389477) | |||
| 3362 | 3362 | 114879 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1454 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000868.0 | 2110394.0 | 37.7747880422892 | -122.440469509771 | (37.7747880422892, -122.440469509771) | ||||
| 5526 | 5526 | 99210 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007993.4855 | 2121112.3432 | 37.8046211410646 | -122.416580345595 | (37.8046211410646, -122.416580345595) | |||
| 5763 | 5763 | 107346 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 247 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5998163.7387 | 2112864.5437 | 37.7814171604492 | -122.450002161775 | (37.7814171604492, -122.450002161775) | |||
| 6691 | 6691 | 121389 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2646 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5999473.1272 | 2113649.2828 | 37.7836466874196 | -122.445528775036 | (37.7836466874196, -122.445528775036) | |||
| 7025 | 7025 | 113774 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1716 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 6000066.4859 | 2114892.9793 | 37.787095412064296 | -122.443565357608 | (37.7870954120643, -122.443565357608) | |||
| 7264 | 7264 | 121250 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 31 Orben Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x3 | Permit Number 778957 | 6003136.4072 | 2115361.6956 | 37.788556991677495 | -122.432977615629 | (37.7885569916775, -122.432977615629) | ||
| 7285 | 7285 | 113773 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1718 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x6 | 6000060.5464 | 2114943.4646 | 37.7872336928249 | -122.44358953494499 | (37.7872336928249, -122.443589534945) | |||
| 7887 | 7887 | 106203 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1600X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5x5 | 6003127.4057 | 2113944.8226 | 37.784666106882796 | -122.432907495725 | (37.7846661068828, -122.432907495725) | |||
| 16688 | 16688 | 97242 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016235.0824 | 2094868.9009 | 37.7330224130953 | -122.386228519291 | (37.7330224130953, -122.386228519291) | |||
| 18161 | 18161 | 107661 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1312 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5999086.9 | 2105066.2 | 37.7600576690463 | -122.446247345124 | (37.7600576690463, -122.446247345124) | |||
| 23838 | 23838 | 140159 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 251 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998783.859 | 2109828.5826 | 37.77311665794689 | -122.44763824308501 | (37.7731166579469, -122.447638243085) | |||
| 24010 | 24010 | 248469 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 145 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998248.1791 | 2107933.2828 | 37.7678820197346 | -122.449354639507 | (37.7678820197346, -122.449354639507) | |||
| 24268 | 24268 | 139286 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 847 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003452.0971 | 2111280.6163 | 37.777369272847295 | -122.431593901382 | (37.7773692728473, -122.431593901382) | |||
| 24575 | 24575 | 138501 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1799 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002528.8099 | 2114345.6813 | 37.7857327932764 | -122.435007113669 | (37.7857327932764, -122.435007113669) | |||
| 25206 | 25206 | 98347 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1331 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6011023.1341 | 2119487.8255 | 37.800330533908294 | -122.40598139081999 | (37.8003305339083, -122.40598139082) | |||
| 26187 | 26187 | 244530 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 557 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998936.3155 | 2108740.8879 | 37.7701388371467 | -122.44703258946998 | (37.7701388371467, -122.44703258947) | |||
| 26219 | 26219 | 201182 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 620 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6013434.6654 | 2113939.6272 | 37.785231064684204 | -122.39724720317801 | (37.7852310646842, -122.397247203178) | |||
| 26256 | 26256 | 142499 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 521 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6009964.3012 | 2119317.683 | 37.7998040885057 | -122.40963337214 | (37.7998040885057, -122.40963337214) | |||
| 26624 | 26624 | 141693 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 392 EWING TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998717.1894 | 2112334.7102 | 37.7799940283513 | -122.448049338774 | (37.7799940283513, -122.448049338774) | |||
| 27277 | 27277 | 138678 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2811 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000338.1385 | 2114753.4825 | 37.786727879036704 | -122.442615482645 | (37.7867278790367, -122.442615482645) | |||
| 27278 | 27278 | 248364 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1501 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998466.8217 | 2108253.3731 | 37.768773410658895 | -122.44862143957701 | (37.7687734106589, -122.448621439577) | |||
| 27423 | 27423 | 251079 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 5616 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5989547.9545 | 2112698.1385 | 37.7804634926969 | -122.479796079248 | (37.7804634926969, -122.479796079248) | |||
| 27469 | 27469 | 143247 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 153 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6010131.5523 | 2121103.7243 | 37.8047174875245 | -122.40918071917 | (37.8047174875245, -122.40918071917) | |||
| 27952 | 27952 | 143521 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2224 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002337.2397 | 2118485.1098 | 37.7970877186103 | -122.43596619228902 | (37.7970877186103, -122.435966192289) | |||
| 28054 | 28054 | 247274 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1637 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999148.0173 | 2109382.8294 | 37.7719135384803 | -122.446346504856 | (37.7719135384803, -122.446346504856) | |||
| 28056 | 28056 | 110580 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 403 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6001169.4361 | 2110112.2986 | 37.7740317204292 | -122.43940658540899 | (37.7740317204292, -122.439406585409) | |||
| 28588 | 28588 | 143227 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 106 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010308.3267 | 2121146.7978 | 37.8048456584244 | -122.408572011197 | (37.8048456584244, -122.408572011197) | |||
| 28791 | 28791 | 142940 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 318 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6010703.4174 | 2118721.6624 | 37.7982089506036 | -122.40703370934798 | (37.7982089506036, -122.407033709348) | |||
| 28900 | 28900 | 98468 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6011948.2516 | 2107041.0959 | 37.7662064164751 | -122.40190466033701 | (37.7662064164751, -122.401904660337) | |||
| 29051 | 29051 | 181932 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2378 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 0ft | 5985195.246 | 2099024.2764 | 37.74266505256279 | -122.49384596323 | (37.7426650525628, -122.49384596323) | |||
| 29158 | 29158 | 142470 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1443 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6010970.8958 | 2119887.8443 | 37.8014259659921 | -122.406190355577 | (37.8014259659921, -122.406190355577) | |||
| 29189 | 29189 | 140683 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 21288 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5997608.0859 | 2110262.8359 | 37.774241738407795 | -122.451736704617 | (37.7742417384078, -122.451736704617) | |||
| 29557 | 29557 | 141085 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 3370 GEARY BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5996665.207 | 2112963.3629 | 37.781602631354794 | -122.455193467958 | (37.7816026313548, -122.455193467958) | |||
| 29578 | 29578 | 108616 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 289 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6010459.7673 | 2120958.2392 | 37.8043364033733 | -122.408034626667 | (37.8043364033733, -122.408034626667) | |||
| 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) | |||
| 29780 | 29780 | 143503 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 24 GERKE ALY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6010601.2344 | 2120203.101 | 37.80227089957479 | -122.407491794352 | (37.8022708995748, -122.407491794352) | |||
| 29795 | 29795 | 142969 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 155 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6010117.5609 | 2121101.8588 | 37.804711581482294 | -122.40922900630501 | (37.8047115814823, -122.409229006305) | |||
| 30721 | 30721 | 246053 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1456 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998746.9386 | 2108335.7426 | 37.7690155895077 | -122.447658470154 | (37.7690155895077, -122.447658470154) | |||
| 30887 | 30887 | 140482 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1137 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003743.6898 | 2112670.736 | 37.781202719512 | -122.430684409839 | (37.781202719512, -122.430684409839) | |||
| 31071 | 31071 | 247300 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 815 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002551.3233 | 2109517.7945 | 37.772477905220796 | -122.434583889381 | (37.7724779052208, -122.434583889381) | |||
| 31190 | 31190 | 142631 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 241 BAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009683.097 | 2121540.8838 | 37.8058926846956 | -122.410763542627 | (37.8058926846956, -122.410763542627) | |||
| 31191 | 31191 | 143519 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2174 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002630.1383 | 2118528.26 | 37.79722283258779 | -122.434955780242 | (37.7972228325878, -122.434955780242) | |||
| 31267 | 31267 | 140047 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 997 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6002926.2641 | 2111608.0681 | 37.778238555435 | -122.433436333455 | (37.778238555435, -122.433436333455) | |||
| 31784 | 31784 | 98024 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1639 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5988098.058999999 | 2098940.517 | 37.742604479099 | -122.483802857352 | (37.742604479099, -122.483802857352) | |||
| 32305 | 32305 | 141109 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 154 WOOD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998503.1758 | 2112860.4826 | 37.7814254265925 | -122.44882758656601 | (37.7814254265925, -122.448827586566) | |||
| 32946 | 32946 | 143537 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2125 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002811.2386 | 2118507.9925 | 37.797177464275705 | -122.434327678668 | (37.7971774642757, -122.434327678668) | |||
| 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) | |||
| 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) | |||
| 34859 | 34859 | 138109 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1600 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004876.0712 | 2114750.6655 | 37.7869777775164 | -122.426915105637 | (37.7869777775164, -122.426915105637) | |||
| 35453 | 35453 | 246043 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1701 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997853.8956 | 2108495.9392 | 37.7694043689932 | -122.450758987128 | (37.7694043689932, -122.450758987128) | |||
| 35602 | 35602 | 217547 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 102 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5995842.2441 | 2088093.8487 | 37.713269899907104 | -122.45624180431801 | (37.7132698999071, -122.456241804318) | |||
| 36187 | 36187 | 143482 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 601 CALIFORNIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6010529.9358 | 2116279.9602 | 37.7914949183295 | -122.407461776619 | (37.7914949183295, -122.407461776619) | |||
| 36580 | 36580 | 142827 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1714 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006619.3625 | 2116773.8493 | 37.7926313555217 | -122.421027406021 | (37.7926313555217, -122.421027406021) | |||
| 36885 | 36885 | 142970 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 175 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010034.7291 | 2121089.9447 | 37.804674227418296 | -122.409514813908 | (37.8046742274183, -122.409514813908) | |||
| 37033 | 37033 | 137820 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 18 ORBEN PL | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003172.6736 | 2115287.4039 | 37.7883550625506 | -122.432846830068 | (37.7883550625506, -122.432846830068) | |||
| 37104 | 37104 | 244379 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 219 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6005931.9708 | 2110333.2151 | 37.7749081865836 | -122.42294784544501 | (37.7749081865836, -122.422947845445) | |||
| 37257 | 37257 | 142458 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1450 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000907.3913 | 2110378.0547 | 37.7747465034057 | -122.440332103705 | (37.7747465034057, -122.440332103705) | |||
| 37374 | 37374 | 143136 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2679 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5999509.2265 | 2119087.2107 | 37.7985798662052 | -122.445795098614 | (37.7985798662052, -122.445795098614) | |||
| 38494 | 38494 | 246056 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1466 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998693.9435 | 2108329.3832 | 37.7689950993057 | -122.44784131823401 | (37.7689950993057, -122.447841318234) | |||
| 38684 | 38684 | 137659 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1334 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002765.4317 | 2111672.0138 | 37.778405008308795 | -122.43399728327101 | (37.7784050083088, -122.433997283271) | |||
| 38762 | 38762 | 138500 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2416 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6001920.8461 | 2114683.7924 | 37.7866266207317 | -122.437134708687 | (37.7866266207317, -122.437134708687) | |||
| 38886 | 38886 | 248350 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1587 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997973.5131 | 2108185.8423 | 37.7685597685915 | -122.45032288098899 | (37.7685597685915, -122.450322880989) | |||
| 38980 | 38980 | 138629 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1705 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6000022.8572 | 2114841.5382 | 37.7869516798811 | -122.443712605837 | (37.7869516798811, -122.443712605837) | |||
| 39156 | 39156 | 248312 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1375 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999157.272000001 | 2108349.6728 | 37.769077281031606 | -122.44624016016199 | (37.7690772810316, -122.446240160162) | |||
| 39160 | 39160 | 138608 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500 PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999173.5218 | 2114868.2702 | 37.78697659984 | -122.44665302598801 | (37.78697659984, -122.446653025988) | |||
| 39181 | 39181 | 246129 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1486 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998642.4625 | 2108323.3267 | 37.768975527056206 | -122.44801895087299 | (37.7689755270562, -122.448018950873) | |||
| 39439 | 39439 | 181853 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2318 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5986420.3329 | 2099445.95 | 37.7438944556176 | -122.48964102637699 | (37.7438944556176, -122.489641026377) | |||
| 39575 | 39575 | 246153 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1720 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997461.1263 | 2108156.7707 | 37.7684506082583 | -122.45209307718099 | (37.7684506082583, -122.452093077181) | |||
| 39577 | 39577 | 142706 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 567 BAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6008189.6261 | 2121340.372 | 37.805258279506795 | -122.41591773769301 | (37.8052582795068, -122.415917737693) | |||
| 39668 | 39668 | 245409 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2778 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6010163.1606 | 2102247.1684 | 37.7529435845832 | -122.40774091468 | (37.7529435845832, -122.40774091468) | |||
| 40096 | 40096 | 142987 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1871 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6010368.8695 | 2120931.1728 | 37.8042569960583 | -122.408347277199 | (37.8042569960583, -122.408347277199) | |||
| 40899 | 40899 | 181727 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2755 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5987094.0342 | 2107004.1542 | 37.76468654333279 | -122.487866760897 | (37.7646865433328, -122.487866760897) | |||
| 41015 | 41015 | 138010 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1401 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6005424.6122 | 2114535.8430000003 | 37.7864189291949 | -122.42500198582199 | (37.7864189291949, -122.425001985822) | |||
| 41143 | 41143 | 140223 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 610 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003617.0405 | 2110448.5788 | 37.7750940511339 | -122.43096391168999 | (37.7750940511339, -122.43096391169) | |||
| 41284 | 41284 | 140538 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1025 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003370.5162 | 2111893.2524 | 37.7790467948997 | -122.43191987222 | (37.7790467948997, -122.43191987222) | |||
| 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) | |||
| 42222 | 42222 | 244167 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 443 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997917.5884 | 2109065.1071 | 37.7709708040394 | -122.450579717232 | (37.7709708040394, -122.450579717232) | |||
| 42656 | 42656 | 140057 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 909 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6002945.8926 | 2111449.3483 | 37.7778038640415 | -122.43335708659299 | (37.7778038640415, -122.433357086593) | |||
| 43401 | 43401 | 182246 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1455 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5985863.116 | 2105312.6885 | 37.759970370515106 | -122.491999577939 | (37.7599703705151, -122.491999577939) | |||
| 43462 | 43462 | 142119 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1208 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6002005.9378 | 2110874.6586 | 37.776172539897296 | -122.43656756597 | (37.7761725398973, -122.43656756597) | |||
| 43725 | 43725 | 246164 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1756 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5997323.9447 | 2108138.6009 | 37.768392859677896 | -122.452566262235 | (37.7683928596779, -122.452566262235) | |||
| 44212 | 44212 | 184648 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1691 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5983748.1287 | 2103659.9866 | 37.755308660398505 | -122.49919205978998 | (37.7553086603985, -122.49919205979) | |||
| 44940 | 44940 | 143210 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 175 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6010365.1796 | 2121277.1884 | 37.8052068625476 | -122.408384467587 | (37.8052068625476, -122.408384467587) | |||
| 45184 | 45184 | 140688 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003366.7058 | 2112262.0737 | 37.780059270229295 | -122.431959397228 | (37.7800592702293, -122.431959397228) | |||
| 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) | |||
| 45906 | 45906 | 137896 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1832 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6004416.1912 | 2115174.8872 | 37.788116570049404 | -122.428536436558 | (37.7881165700494, -122.428536436558) | |||
| 46030 | 46030 | 244321 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 255 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005987.0957 | 2110521.4851 | 37.7754282408756 | -122.42277053908501 | (37.7754282408756, -122.422770539085) | |||
| 46212 | 46212 | 140726 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 507 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002621.396000001 | 2110304.4034 | 37.774641715946004 | -122.43439775125799 | (37.774641715946, -122.434397751258) | |||
| 46678 | 46678 | 142123 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 15 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998622.5379 | 2110844.3781 | 37.7758965505953 | -122.448269431558 | (37.7758965505953, -122.448269431558) | |||
| 46963 | 46963 | 139407 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1311 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000207.9303 | 2113507.6319999998 | 37.7832996726996 | -122.44297646838301 | (37.7832996726996, -122.442976468383) | |||
| 47030 | 47030 | 244480 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 436 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6004459.1128 | 2109828.0982 | 37.773438040418796 | -122.42800677201201 | (37.7734380404188, -122.428006772012) | |||
| 47180 | 47180 | 141342 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 454 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001185.8232 | 2110322.8485 | 37.774610770124205 | -122.43936499503799 | (37.7746107701242, -122.439364995038) | |||
| 47229 | 47229 | 246151 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1622 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997783.0336 | 2108202.195 | 37.7685937659628 | -122.450982909765 | (37.7685937659628, -122.450982909765) | |||
| 47515 | 47515 | 140745 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2069 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6001396.8514 | 2113169.2925 | 37.7824383924166 | -122.43883902908199 | (37.7824383924166, -122.438839029082) | |||
| 47609 | 47609 | 139282 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 863 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003442.6809 | 2111357.0537 | 37.7775786172665 | -122.431631933616 | (37.7775786172665, -122.431631933616) | |||
| 48254 | 48254 | 248610 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 872 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997691.4278 | 2107516.4386 | 37.7667056091614 | -122.4512503025 | (37.7667056091614, -122.4512503025) |
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");